DWH Consultant
Master Works
Total years of experience :17 years, 10 Months
• Developed and maintained ETL (Data Extraction, Transformation and Loading)
mappings Microsoft SSIS to extract the data from multiple source systems that
comprise databases like Oracle, SQL Server, flat files to the Staging area, EDW and
then to the Data Marts.
• Created packages for both incremental and full load.
• Performed Impact Analysis of the changes done to the existing mappings and
provided the feedback
• Participated in providing the project estimates for development team efforts for
the off shore as well as on-site.
• Coordinated and monitored the project progress to ensure the timely flow and
complete delivery of the project
• Created Complex ETL Packages using SSIS to extract data from staging tables to
partitioned tables with incremental load.
• Responsible for performing T-SQL tuning, multi-tasking and optimizing queries
for reports which take longer time in execution with SQL Server
• Performed operations like Data reconciliation, validation and error handling
after Extracting data into SQL Server.
• Created stored procedures to build Fact tables in data mart for Multi-
Dimensional analysis.
• Created Database Objects - Tables, Indexes, Views, Stored Procedures and User
defined functions according to the requirements of the project.
• Worked with business owners to identify key data elements that will be
monitored on an on-going basis to ensure a high level of data quality within the
Warehouse.
• Involved in data migration from existing/legacy system to NLG system.
• Responsible for Oracle based back-end Development handling high-volume
online data.
• Created PL/SQL stored procedures, functions and packages for processing data
as per requirement.
• Developed and maintained ETL (Data Extraction, Transformation and Loading)
mappings using Informatica Power Centre Designer 9.6 to extract the data from
multiple source systems that comprise databases like Oracle, SQL Server, files.
• Handling incidents and service requests related to the application, monitoring
and implementing changes to scale the application.
• Review of functional/technical design of the application. Reviewing the current
application code to come up with the improvements.
• Working with testing team for fixes and enhancements. Identifying and fixing
performance bottlenecks. Aligning with other Teams for integration like SAP
CRM, SAP PO.
• Stabilize the data migration logic by improving the exception handling logic
that also helps troubleshooting, easy debugging and fixing issues in the
migration code.
•Coordinate with different level of team members and report to manager on the
daily tasks.
•Suggest indexes on the tables for faster retrieval of the data to enhance the
overall migration performance
Restructure the existing systems to make it more user friendly, flexible,
uniform, & standardized. Provide support for other Engineering Applications,
Project Control System, Online Time sheet System. Integration with HR and
Payroll and Personnel Management System
•Involved in migration of data for SmartPlant Instrumentation project.
•Create complex PL/SQL stored procedures, functions and packages for data
extraction and data manipulation as per the Data Migration Mapping logic.
•Create database objects like tables, views, materialized views, procedures and
packages using oracle tools like Toad and PL/SQL Developer.
•Use the advanced features of PL/SQL like bulk collection, Records, Tables,
Object types and Dynamic SQL to improve the overall data migration
performance.
•Stabilize the data migration logic by improving the exception handling logic
that also helps troubleshooting, easy debugging and fixing issues in the
migration code.
•Coordinate with different level of team members and report to manager on the
daily tasks.
•Suggest indexes on the tables for faster retrieval of the data to enhance the
overall migration performance
• Involved in Unit tests, Integration testing & Performance tests for newly
developed systems.
Master of Computer Applications (MCA) is a three year long professional post-graduate programme for candidates wanting to delve deeper into the world of computer application development with the help of learning modern programming language. The programme is a blend of both theoretical and practical knowledge. An MCA degree endows students’ an opportunity to work with tools meant to develop better and faster applications.