• Designed Customer Prior Relationship Initiative for Targeted Marketing Campaigns.

• Designed Nextgen Marketing Core Party Model /Marketing Campaigns Data Mart.

• Design, develop and deliver data mart for Internet Listening’s Weblogs with CRF Data Model.

• Designed & Developed Enterprise Level Events Data Lake Canonical Model ETL Architecture & Implementation.

• Data Architect for Events Data Visualization Initiative.

• Analyzed IVR Call Data and translated it in to physical data model for optimized ETL processes and reporting.

• Carry out data profiling (using sql), analyze results and feed the findings into strategy decision making.

• Designed coding templates for increasing ETL developer efficiency and reducing code defects.

• Implemented new Projections in Vertica Database for performance improvement

• Designed coding templates for increasing ETL developer efficiency and reducing code defects.

• Meet with business users and data analysts to gather technical requirements for reference data architecture.

• Responsible for communicating and resolving various technical issues to ensure project deadlines are met.

• Design ETL specifications, including data flow, source system selection, data quality and transformations.

• Design ETL specifications/mapping rules for Data Integration of MDM system.

• Coordinate and train production support team and provide level 3/escalation level production support

• Give walkthroughs to QA team and review test cases to ensure quality of ETL code.

• Participate in project related architecture discussion.

• Coded and unit tested ETL mappings, sessions and workflows.

• Involved in ETL code optimization, performance enhancements and code reviews.

• Decoded Nasco SMR/GMR file by using Power exchange.

• Responsible for Nasco SMR/GMR segments data validation/queries.

• Design, Analysis and development of new ETL.

• Used Informatica B2B for XML files processing.

• Implemented Informatica Concurrent Workflow Processing model for better ETL Performance.

• Implmented Unix Process Launcher Script to handle Concurrent Processing of informatica workflows.

• Designed & Developed RISK Feed ETL layer based on Message Queue layer.

• Involved in ETL code optimization, performance enhancements and code reviews.

• Worked with support team to resolve the production incidents.

• Used Informatica Bulk Load option with Oracle Database.

• Worked on Oracle SQL performance tuning.

• Used Informatica Pushed down Optimization for Performance improvements.