A highly experienced business and a commercially orientated IT Professional with a track record of success, focused on the delivery of Data Warehouse/Business Intelligence solutions DW/BI in both technical ETL Architect and managerial capacities.

• More than 13 years of DW/BI experience in domain areas of Utilities, Insurance, Telecom, Retail, and Manufacturing and extensive experience in the Business Intelligence arena.
• Has experience in delivery of Data Warehouse/Business Intelligence solutions DW/BI in both technical ETL Architect and managerial capacities.
• Experience on Data Warehousing applications and directly responsible for the Design and Architecture for Extraction, Transformation and Loading of data from heterogeneous sources into Data Warehouses. Worked extensively with Dimensional modeling, data migration, data cleansing, building ETL processes for Data Warehouses.
• Successfully played roles such as ETL Architect, Technical Lead, ETL Lead, and ETL Developer. A rich experience in Software Development and Support Life Cycle covering User Interviews, Requirement Gathering, Analysis, Application Design/Reviews, Construction, Testing, UAT, Implementation, Maintenance, support, and Enhancements.
• Extensive Functional and Technical experience in Dimensional Modeling, Data Modeling, Business Intelligence BI , Decision Support Systems DSS and Customer OLTP/OLAP Systems, Normalized OLTP .
• Extensive analytical and programming experience in Data warehousing ETL tools such as Informatica, SAP BODS/Business Object Data Integrator, DataStage, Microsoft SSIS and open source tools.
• Experience in Performance Tuning, and testing of the ETL jobs using different methodologies like configurations of the environment variables, designing and editing configuration files, increasing the reading as well as the writing speed while fetching or loading data to files or databases for voluminous data.
• Expertise in working with various heterogeneous and operational/legacy sources like Vertica, Oracle, DB2, Teradata, Flat files, VSAM files into a staging area.
• Excellent working hands on experience in Oracle, PL/SQL, writing, testing and implementation of the triggers, stored procedures, functions at Database level.
• Have strong Presentation, Communication and Leadership skills. Worked globally with cross cultural teams.
• Managed teams across projects in the onsite / offshore model. Strong leadership qualities able to schedule priorities and perform/ delegate accordingly to effectively accomplish tasks at hand.
• Has experience in liaising, coordinating and working with external vendors.
• Experience in writing responses for RFP, effort estimation.

• DW BI Tools: Informatica Power center 9.5.1/8.6/7.5/6.x/5.x, Datastage 7.5, Microsoft SSIS, SAP Data Services 4.0, BODI, Pentaho Kettle, MicorStrategy , Business Objects XIR2, Cognos
• Data Modelling Tools: Erwin 9/8, System Architect
• DBMS Languages: Oracle 11g/10g/9x and related tools, IBM DB2, SQL Server 2008/2005, HP Vertica 6.x, PostgreSQL, Teradata V2R5.6, , SQL. PL/SQL, Unix Shell scripting, C

Confidential

ETL Architect

TECHNOLOGIES Informatica 9.5.1, IBM DB2, ALM, Cognos 9.x, MS Visio, UNIX, VSS

Key Responsibilities:

• Develop Business Requirement Document, Technical Design Documents/Design Specification Documents, and Mapping Specification Documents.
• Suggest proper tool stack i.e. ETL tools, RDBMS for development of new system.
• Estimation of total execution plan.
• Design a new system which will suffice all the reporting needs.
• Thoroughly understand the existing reports and come up with analysis and design of a new reporting system.
• Understand the existing systems and there business process.
• Designing strategy for Architectural/ETL to achieve the business requirement.
• Reviewing the ETL code and standards.
• Thoroughly understand the existing reports and come up with analysis and design of a new reporting system.
• Manage Areas of Problem Management and Change Management.

Achievements:

• Analyzed and designed an ODS system for MetLife from scratch.
• Meet the Architectural requirements as mandated by the Enterprise Architect
• Improve efficiencies in technical processes for Source to Target mappings

Confidential

ETL Architect

• TECHNOLOGIES Informatica 9.5.1, MicorStrategy, Business Objects Data Integrator, BO XIR2, SQL Server 2005, Oracle 11g, PL/SQL, Vertica 6.x, ALM
• I play key role in providing design solutions, ETL Architecture, testing, and implementation Energy Data Warehouse EDW , working closely with the business stakeholders and BI architect. I also provide production support to Energy Data Warehouse, so that business should receive the reports timely fashion, without any interruption. Identified and solved many architectural design issues, analyzed the data issues reported by business and resolved ASAP. I am/was involved in multiple projects of energy business as a Lead ETL Architect/Designer. A sample of these projects is provided below:

Key Responsibilities:

• Analyzing and understanding project business requirements, by meeting stakeholders.
• Preparing/Updating documents such as, interface dependency documents IDA , technical design documents, ETL design documents, logical business transformation documents LBTs .
• Configured data warehouse system for analysis, data modeling, business logic mapping.
• Estimating the effort required for development and documenting the changes.
• Designing strategy for Architectural/ETL to achieve the business requirement.
• Reviewing the ETL code and standards.
• Designing exception handling strategy and implementing the same for handling erroneous records.
• Outlining strategy for integration testing and user acceptance testing.
• Identifying project risks and suggesting contingency plan
• Root cause analysis on system failure and identifying appropriate solution.
• Provide visibility with regular updates and communication to sponsor / stakeholders.
• Lay out testing strategy across the program of work to promote better Data migration strategy and Defect Management.
• Deployment in production and maintenance going forward

Achievements:

• Analyzed and fixed architectural issue where one hundred forty million records were missing from the data warehouse, which boosted the customer confidence.
• Successfully implemented the settlements reconciliation and energy risk process through BI, once MDMS was decommissioned.
• Eliminated the manual handling of files coming from the AEMO by designing the process, so that data can be loaded into data warehouse without any delay.

Confidential

ETL Architect

TECHNOLOGIES Informatica 8.6, Business Objects Data Integrator, Pentaho, Fast Radar, SQL Server 2005, Oracle 11g/10g, PL/SQL, DB2, Teradata, Postgre SQL

Key Responsibilities:

• Design a new system which will suffice all the reporting needs.
• Develop Business Requirement Document, Technical Design Documents/Design Specification Documents, and Mapping Specification Documents.
• Regularly review problem trends and proactively take actions to identify problems e.g. long running batches , performance tuning of jobs.
• Estimation of total effort and execution plan.
• Allocation of work to the team members, creating weekly project status report for the stake holders.
• Develop proof of concept for proposed solution and demonstrate to customer.
• Develop Specifications and code as per requirements and Quality standards.
• Implemented automated error handling process for ETL data loads.
• Thoroughly understand the existing reports and come up with analysis and design of a new reporting system.
• Managing customer escalations.
• Manage Areas of Problem Management and Change Management.
• Preparation of template for unit test cases, unit test plans, and development standards and Guidelines for ETL jobs.
• Review of code to maintain proper logic implementation/quality standards in the code.

Achievements:

• Lead a team for State Farm insurance, and completed the project effectively within tight timeframe.
• Written responses for many project proposals, with approaches, effort, and cost estimation.
• Provide visibility with regular updates and communication to sponsor / stakeholders
• Lay out testing strategy across the program of work to promote better Defect Management
• Meet the Architectural requirements as mandated by the Enterprise Architect
• Improve efficiencies in technical processes for Source to Target mappings