EXPERIENCE SUMMARY:

• 10+ years of experience in implementing/managing ETL and Master data management related Projects.
• Expertise in Informatica 7.x,8.x,9.x, Datawarehouse Application Console (DAC), Oracle database, Siebel 7.x,8.x
• Expertise in Datatsage 9.1.2
• 6+ years of experience on Enhancements/Development/Maintenance, 3 years in Production Support and 5+ years of Onshore/Client facing roles.
• Involved in all the phases of project life cycle - Analysis, Design, Development, Testing, Implementation and Maintenance.
• Proficient in using Informatica PowerCenter tools Repository Manager, Designer, workflow manager, workflow monitor, pmcmd (Informatica command line utility) to create, schedule and control workflows, tasks, and sessions
• Proficient in using IBM Infosphere Datastage Designer,Director.
• Designed complex Mappings and expertise in performance tuning.
• Proficient in coding using SQL and PL/SQL
• Knowledge with reporting tools like OBIEE.
• Expertise in upgrade activities which includes Informatica (7.x/8.x to 9.x) upgrade and Oracle/Siebel data model.
• Experience in projects across various industries like Banking, Financial, Insurance, Pharma, al Institutions
• Knowledge in OLTP/OLAP System Study, Analysis and E-R modeling, developing Database Schemas like Star Schema used in dimensional modeling
• Oracle certified Siebel 7.7 Core Consultant.

TECHNICAL SKILLS:

Hardware/ Operating System: Windows 9X/2000/2003/XP, UNIX.

Programming Languages: VB Script

Java Script: HTML

Databases & Tools: Siebel Tools Configuration

Siebel EIM: Informatica Powercenter(9.x,8.x,7.x)

Datastage 9.1.2: SQL Server Integration Services(SSIS)

DAC: Oracle On Demand

Oracle: SQL Server

DB2: Toad

PROFESSIONAL EXPERIENCE:

Confidential

Country Lead

Responsibilities:

• Area of expertise lies in developing and deploying Siebel application using Siebel 7.7.
• In this project he was the lead for Support and maintenance project for sales force automation application (Siebel 7.7.2.6) for 20 countries. This was a multilingual application and the user base was around 10000 which include both online and offline users.
• He has also worked at the Client end at UK as a Production Support Lead for UK and successfully carried out all the major implementations.
• He was mainly involved in Product upgrades handling, Maintenance release development, Siebel Client installation and extracts, Siebel EIM batch loading, Upgrade kit and Packager creation.
• He has also done extensive Siebel Tools configuration to tailor client’s need for implementing Sales Force activities and testing configured application. Actively involved in debugging and incorporating the late change requests received from the client.

Confidential

Developer

Responsibilities:

• He was a key developer in this project. He is mainly involved in analyzing the business requirements for designing mappings, resolving issues from data perspective, coordinating among team members to effectively develop test cases, writing validation scripts in SQL and perform end to end testing.
• In this project he designed new functionalities to be incorporated in the existing Client application using his knowledge of Informatica ETL, SFA, Siebel and SRMW Data Model. He will be using Siebel 8.x tool for configuring the application to meet business requirements, Informatica 8.1.1 to created mapping for OLAP, Oracle 10g and its associated tools for database implementation.
• Apart from such industry wide used development tools, he is also well versed with the quality procedures and practices in Confidential . His experience of being a part of the CMMI Level 5 Appraisal process is also seen as an essential advantage for Confidential and the Client.

Confidential

Senior Developer

Responsibilities:

• Coordinate with Confidential team at offshore and Onsite
• Develop the ETL mappings
• Coordinate with the reporting team to troubleshoot their reports.
• Review and troubleshoot ETL routines
• Conduct Conference Room Pilot
• Conduct/Support UAT
• Support Deployment Activities
• Fix issues arising out of Unit Testing and subsequently at ST and UAT.

Confidential

Technical Consultant

Responsibilities:

• Working at Client end at China to successfully migrate the entire application from France to China.
• Coordinate with Confidential Support team at China to Set up the entire application
• Configure the entire Setup for Siebel marketing application and sort out the issues
• Configure the entire Setup for running the Interfaces using SSIS packages
• Configure the entire Setup for Analytics, Informatica & DAC
• Coordinate with the application & reporting team to troubleshoot their issues.
• Review and troubleshoot ETL routines.
• Conduct Dry Run
• Conduct/Support System Test
• Fixing ST issues
• Conduct/Support UAT
• Fixing UAT issues
• Deployment plan and execution
• Warranty support after GoLive.

Confidential

Senior Consultant

Responsibilities:

• He played the role of an ETL Production Support Lead during his tenure at offshore.
• At onsite his role is of an ETL Data Lead. As part of his role he understands the Business requirements and then shares the same information with Offshore.
• He is involved in release planning process, providing estimates, design review, code review, code migration and Production Deployment. His key milestones for this project are Application Upgrade, Quick Win Data Solutions, UPN Consolidation and Sofia Move (Server Movement).
• Tools used for this project are Informatica, DAC and DB2 Database.
• He is involved in the Coordination for Oracle On Demand Project which is being handled by the CoE team within Zurich Financial Services.

Confidential

Senior Consultant

Responsibilities:

• He played the role of a senior ETL architect during the upgrade project.
• He was involved in Siebel 8.1 Data model Analysis as compared to Siebel 7.8 Application and its impact on the ETL routines.
• He was involved in setting up the servers with ETL tools, upgrading the Application to the desired versions, providing estimates, planning, code review, code migration and Production Deployment.
• His key milestones for this project are Application Upgrade in Development, Test and Staging Environment.
• He was also involved in the Coordination between Siebel and OBIEE teams.
• Tools used for this project are Siebel, Informatica, DAC and SQL Server Database.
• He worked for the development of the Interface Required to Integrate CRM Desktop with Data warehouse via Siebel.
• As part of his role he understands the Business requirements and then provides the solution to any issue faced.
• He was involved in Design & Development of key modules for Claritas Program.
• He was involved in building interfaces which will help external system to pull data from existing Data Warehouse.

Confidential

Senior Consultant

Responsibilities:

• Managing Application and infrastructure support for data management of customer hub which includes batch interfaces (client and contact), Oracle based customer repository and outbound feeds.
• Owns the Release Management Process which comprises of Oracle DB script deployment, PL/SQL procedures, Informatica Mapping, UNIX scripts, customer application code and Control-M scheduler changes.
• He is responsible for preparing migration document to move the code from QA to UAT and then to production.
• He is in client facing role and handles issues related to Batch Interfaces (ETL jobs) and provides quick win solutions like Breakglass and then helps with fixing the code as well.
• Post release he performed Application and DB checkouts.
• His key milestones for this project were setting up concurrent users, Country of Domicile Cleanup, Siebel Version Upgrade, SSO Implementation, several Quarterly and Monthly Releases, Defect Density Reduction.
• Recommended data modeling changes and ETL changes to improve maintainability, data quality, best practices and performance.
• He was also involved in the Coordination with all Upstream as well as Downstream systems.
• Tools used for this project are Siebel, Informatica, Oracle, Unix.
• He is responsible for providing weekly status to Business on the Production issues.
• As part of his role he understands the Business requirements and then provides the solution to any issue faced.
• He created many Breakglass to modify/rectify the bad Production Data to streamline the Production Data.

Confidential

Senior Consultant

Responsibilities:

• Owns ETL development process to ensure all Transaction Data is captured, validated, processed and settled on a day to day basis.
• Currently leading the Team for the practice along with Client Counterpart to ensure delivery is on time.
• He is in client facing role and handles Customer meetings which include Weekly Status Call discussions on Metrics and SLA, Business Updates.
• He is part of the decision making team where all the technical and business decisions are involved.
• He is involved with Customers on System Study, Requirements gathering project scoping and analysis, support on End to End IT solution offering.
• Recommended data modeling changes and ETL changes to improve maintainability, data quality, best practices and performance.
• He is also involved in the Coordination with all Upstream as well as Downstream systems.
• He is involved in planning and implementing Release Process.