Summary

• About 7 years of working experience in various stages of software development, with 6 years experience in full life cycle (SDLC) Data Warehousing, Data Integration, Business Intelligence as Sr.ETL/Informatica Specialist, Data Warehouse Developer using Informatica PowerCenter8.x,7.x,6.2, Teradata, Unix, Oracle
• Proficiency in defining ETL design and integrating data from disparate source systems and disparate data formats including Requirements gathering, Source system analysis, Data Quality, ETL-QA, Performance Tuning, Maintenance and Production Support using Informatica PowerCenter8.5.1, 8.1.1, 7.1.x, 6.x and Custom built scripts using PLSQL, Unix Shell and BTEQ
• Strong experience in Data Modeling and deployment of multi-dimensional schema (Star and Snowflake Schemas) using Ralph Kimball Methodology, Conceptual/Logical/Physical design, Entity Relationship modeling using Erwin, Visio.
• Strong programming and debugging skills Informatica, PL-SQL, Teradata and BTEQ scripting. Experience in developing Stored Procedures, Functions, Packages, Database triggers, Materialized views and extensive experience in Query optimization, Performance tuning.
• Experience with DB2, SQLServer, TOAD, SQL Assistant
• Five years of Healthcare Claims, Revenue and Membership
• Well-versed in SDLC all phases, good understanding of CMM and ISO 9001:2000 guidelines, team leadership, Onsite/Offshore activities and exposed to driving the translation and construction of a client\'s complex business problems into innovative technology solutions. Ability to learn very quickly and apply new skills to existing problems.

Technical Skills

ETL: Informatica PowerCenter8.5.1/7.1.x/6.2
Data Modeling: ERWIN 4.x, Visio
Database tools: TOAD, SQL Assistant
RDBMS: TERADATA V2 R 4.1, SQL Server, Oracle 8i/9i, DB2
Languages: PL/SQL, C, C++, BTEQ
O.S: Windows XP/2000/ NT/9x
Business Intelligence: Business objects
Hardware: HP 9000, Pentium PCs
Tools/Utilities: MS Project, SharePoint, Clear Case, VSS, TFS

Education:

B.E.(Electronics and Telecommunication Engineering)

Projects Profile

Confidential,USA Jun 2012 - Present

a company specializing in providing insurance and investment options. The company is building a enterprise wide data warehouse to aid financial reporting. The project is to develop the EDW as a single source of information which will be used by monthly and quarterly reporting against general Ledger.
Role & Responsibilities: Technical Lead

• Requirement Analysis.
• Interacting with client and conducting design/code walkthroughs. Responsible for code migration, Code review, test plans, test scenarios, test cases as part of Unit/Integrations testing
• Automate the Production jobs using Informatica Workflows in Autosys
• Estimation for new enhancements.

Environment
InformaticaPowerCenter 8.6.1, Oracle 10g, Autosys

Confidential,USA Dec 2011 – Jun 2012

Sony Electronics is Sony Group Company specializing in Consumer products like TV, CD, Audio systems etc. For these products, there is always a need to report sell data and generate report based on it. Separate applications were planned to be developed for budgeting and compensating sales force of the company based on sales data. The project was to develop a data warehouse that will hold the real time sales and reference data which can be further used for Budgeting and Compensating.
Role & Responsibilities: Technical Lead (Confidential,Diego, CA)

• Requirement Analysis.
• Translating business requirements to ETL solution.
• Data analysis and managing Change control
• Interacting with client and conducting design/code walkthroughs. Responsible for code migration, Code review, test plans, test scenarios, test cases as part of Unit/Integrations testing
• Automate the Production jobs using Informatica Workflows in Control M
• Co-ordinating with multiple teams involved – SAP, WebMethods and business.
• Onsite and Offshore Co-ordination

Environment
InformaticaPowerCenter 8.6.1, Oracle 10g, Control M

Confidential,USA Feb 2011 – Dec 2011

Molina Inc is a healthcare firm providing solutions for Medicare/Medicaid business. For one of regions that this company operates, existing claim processing engine – QNXT should be upgraded to the latest version. This project involves working with SQL server 2008 database tables, using Informatica for Data Processing and finally generating reports using crystal reports.
Role & Responsibilities: Technical Lead (Confidential,Long Beach, CA)

• Migration/ Integration of data.
• Translating business requirements to Data Migration solution.
• Designing of schema for staging databases
• Enhancing existing functionalities.
• Interacting with client and conducting design/code walkthroughs. Responsible for code migration, Code review, test plans, test scenarios, test cases as part of Unit/Integrations testing
• Automate the Production jobs using Informatica Workflows, DTS packages, batch scripts through UC4 Scheduling Tool.
• Generating reports using crystal reports.
• Managing team of five people.

Environment
InformaticaPowerCenter 8.6.1, SQL Server 2008,Crystal reports, Team Foundation Server,UC4

Confidential, USA Aug 2010 – Jan 2011

WellPoint Inc is a healthcare company having over than 25 million members. Claims filed by these members are processed using batch processes. But for many exceptional claims, manual processing is used. Project was to develop a system to track effectiveness of this manual adjudication process. Employee perks are derived based on this effectiveness Index. This project involves developing database model, processing hour by hour data of associates and developing report based on the data.

Role & Responsibilities: Technical Lead (Confidential,Pune, India)

• Actively participate in understanding business requirements, analysis and designing Data Migration/Integration Process from Business Analyst
• Translate business requirements into Data Migration architectural design.
• Create Technical Design document, Source to Target mapping documents based on the client business requirement.
• Use Informatica PowerCenter and BTEQ Scripts through WLM Scheduling tool to extract, transform and load data
• Use Business Object to generate reports.
• Create reusable transformations and mapplets to use in multiple mappings
• Handle the performance tuning of scripts and SQLs
• Responsible for Code review, test scenarios, test cases as part of Unit/Integrations testing
• Managing team of six people.
• Automate the Production jobs using Informatica Workflows & Shell script through WLM Scheduling Tool.

Environment
InformaticaPowerCenter 8.6.1, Teradata V12, Business Objects,VSS

Confidential,USA Apr 2010 – Aug 2010

WellPoint Inc. participates in many state sponsored healthcare plans. For these plans, state requires a monthly submission of the claims filed and processed. State also sends responses on these processed claims. Project was to develop a data warehouse such that, it helps generating these monthly submission files and also help interpreting response received from the state. Project involved creating Informatica mapping to load the data warehouse, automating process of File Transfer and generating reports on the data submitted and response received.

Role & Responsibilities: Technology Lead, Onsite Coordinator (Onsite – Camarillo, CA)

• Participated in all phases of the Development Life Cycle
• Onsite –Offshore co-ordination, translating client requirements to design needs and ensuring that offshore understands these needs.
• Responsible for Requirements gathering, Technical System Design, Development , Testing, Code Review, Code migration, UAT, Job scheduling, Offshore Coordination
• Interacted with Data Architecture group, PM, Project team to finalize the TSD design strategies. Created various diagrams as part of the Project deliverable and physical database design.
• Designed and developed high performance ETL design plans, Staging and Target tables design to load large volumes of data(Flat file to table, Table to Table, table to Flat file) utilizing Informatica Power Center, Parameter File
• Performance Tuning on the Targets, Sources, Mappings and Sessions used Techniques like reusable Transformations, reusable Caches and partitioning etc.
• Developed an automatic file transfer scripts for FTP of the file
• Developed test plans, test scenarios, test cases as part of Unit/Integrations testing

Environment
Informatica Power Center 8.6.1, Teradata V12, Business Objects

Confidential, USA Dec 2009 – April 2010

WellPoint Inc, developed a architecture design for Data warehouse with more than 1000 data elements required for Cost Of Care (COC) reporting. The project was to develop extracts to load this enterprise warehouse using Transaction systems. This required development of quick data movement techniques to meet aggressive SLAs. The enterprise warehouse is the single source of Information for all reporting systems used in Wellpoint. The project involved designing Informatica mappings, BTEQ scripts, implementing Teradata performance Tuning techniques and automation of jobs by WLM Scheduling.

Role & Responsibilities: Technical Lead (Offshore)

• Responsible for designing, developing, implementing all aspects of ETL Phase
• Defined star schema and staging database environments
• Developing BTEQ scripts for quick turn-around of data
• Developed various Complex Informatica Mappings
• Designed bulk loading utility for large volume of staging data into final warehouse.
• Detected bottlenecks, trouble shooting and tuning of mappings, queries, sessions for better performance and efficiency. Handled error handling routine using Process Control table and automated error checking mechanisms to reduce failures & monitor error logs
• Deliver project documentations such as Source to target mapping document, ETL design specs, ETL Test strategy, Production Operational documents\\
• Managing Team of four people.
• Participating various Quality Audits conducted internally within Infosys.

Environment
InformaticaPowerCenter 8.6.1 Development and testing, Teradata V12 Query Building and testing, Mercury Test Director, Testing tool (Internal), VSS, WLM

Confidential,USA Oct 2007 – Dec 2009

WellPoint which has grown by mergers and acquisitions is divided into six regions nationwide. Each region has its own Data warehouse sourcing data from its operational system to support decision making. They needed to consolidate its warehouses from these 6 regions and build enterprise decision support systems that facilitate strategic decision making with actionable information. With this perspective an Enterprise data warehouse having close to 500 elements from six regional warehouses with the data latency of 40 + days was developed as part of this release.

Role & Responsibilities: Developer, Onsite Co-ordinator (Confidential, VA)

• Handling onsite-offshore co-ordination.
• Responsible for Requirements gathering, Technical System Design, Development , Testing, Code Review, Code migration, UAT, Job scheduling, Offshore Coordination
• Interacted with Data Architecture group, PM, Project team to finalize the TSD design strategies. Created various diagrams as part of the Project deliverable and physical database design.
• Wrote new DDL scripts. Prepared the source-to-target mapping document.
• Conducting code, design walkthrough and reviews with client
• Involved closely with the Query designs for various modules and scenarios
• Involved closely with the Status reporting to Client and resolutions for the data and code issues.
• Code deployment across various environments from SIT to production.

Environment
InformaticaPowerCenter 8.6.1 Development and testing, Teradata V12 Query Building and testing, Mercury Test Director, Testing tool (Internal)

Confidential,USA Jan 2006 – Sept 2007

WellPoint which has grown by mergers and acquisitions is divided into six regions nationwide. Each region has its own Data warehouse sourcing data from its operational system to support decision making. They needed to consolidate its warehouses from these 6 regions and build enterprise decision support systems that facilitate strategic decision making with actionable information. With this perspective an Enterprise data warehouse having close to 500 elements from six regional warehouses with the data latency of 40 + days was developed as part of this release.

Role & Responsibilities: Informatica Developer (Offshore)

• Responsible for designing, developing, implementing all aspects of ETL Phase
• Defined star schema and staging database environments
• Developed high performance ETL plans to load large volumes of data
• Design and develop ETL processes to data from PeopleSoft tables
• Developed various Complex Informatica Mappings, slowly changing dimensions
• Designed and implemented slowly changing dimension types for Organizational hierarchy and GL/GM account mappings for across five campuses
• Developed various Complex Informatica Mappings implementing SCD type 2
• Designed bulk loading utility for large volume of source data
• Detected bottlenecks, trouble shooting and tuning of mappings, queries, sessions for better performance and efficiency. Handled error handling routine using Process Control table and automated error checking mechanisms to reduce failures & monitor error logs
• Created DDL scripts, developed back-end routines using SQL, PLSQL Stored procedures.
• Created ETL batch jobs, worklets and workflows for data warehouse data loading automation process. Designed a strategy to integrate workflows with Control-M scheduler.
• Created UNIX Shell scripts to automate routine tasks
• Deliver project documentations such as Source to target mapping document, ETL design specs, ETL Test strategy, Production Operational documents
• Configuration Management Anchor

Environment
InformaticaPowerCenter 8.6.1 Development and testing, Teradata V12 Query Building and testing, BTEQs Script writing, UNIX coding and environment migration