SUMMARY

• 10+ years of I.T experience in serviced based industries with experience in Analysis, Design, Development, Testing and Implementation of Business Intelligence solutions like Data Warehouse/Data Marts implementations using Informatica, Teradata, Oracle and Unix.
• Experience in software development and testing of various applications with different clients in HealthCare, Utility and Investment domains.
• Expertise in RX, Provider, Membership, Claims and Third - Party Subject areas supporting Enterprise Data Warehouse.
• Experience working in client environment which has built the capability and expertise in on-shore-offshore business model.
• Currently as ETL Developer lead, driving the projects which involves the complete SDLC process.
• Perform Source Systems Analysis, Requirements gathering and analysis, Data modeling, Effort Estimation, Design, development, System testing, UAT support, Implementation and production support.
• Experience in Production support project working under SLA’s providing 24 X 7 supports.
• Experience in Data Migration and Data integration projects.
• Extensive experience in design of Extraction, Transformation and Loading (ETL) framework including Error handling, Audit Balancing, Metadata Reporting, Data Governance Framework.
• Experience in fixing Data Quality issues, Process improvements, Tuning system for performance.
• Experience in tuning Teradata SQL Queries and Stored Procedures.
• Robust knowledge in STAR schema, Snow Flake schema, Fact tables and Dimension tables.
• Experience in Informatica Power Center Client tools - Mapping Designer, Repository manager, Workflow Manager/Monitor.
• Extensively worked in writing Teradata BTEQ scripts, Teradata load Utilities FLOAD, MLOAD.
• Demonstrated ability to lead and coordinate complex projects, besides contributing to the actual development work.
• Experience in System and Regression testing activities.
• Extensive knowledge on Quality processes. Participated in various audits like ISO, PMR, Internal Project reviews.

TECHNICAL SKILLS

ETL Tools: Informatica Power Center 9.6.1, Ab initio

Databases: TERADATA 14, Oracle, DB2, SQL Server, IMS DB

Scripting: Unix Shell Script

Scheduling Tools: Work Load Manager, Control -M

Languages: SQL, PL/SQL, COBOL, JCL, C

Database Tools: Teradata SQL Assistant, TOAD, SQL Developer, SPUFI, QMF

Reporting Tools: Business Objects, COBOL Reports

Operating System: UNIX, Windows, OS/390, Z/OS

PROFESSIONAL EXPERIENCE

Confidential

ETL Developer Lead

Responsibilities:

• Responsible in Requirement Analysis, LOE preparation, Project Planning.
• Involved in Mapping analysis, Data Profiling, Design, Develop, Unit Testing, System Testing, UAT coordination, Implementation Support.
• To design/develop mappings to load the data extracts in staging layers using Informatica tool.
• Worked extensively using Teradata BTEQ, Informatica and UNIX shell scripting.
• Involved in reviewing the deliverables and ensuring quality.
• Provided solutions, approach and coding for critical items.
• Co-ordination with Source systems and Business Analyst to fix Mapping issues, data quality and source related issues.
• Worked with Data Architect for database model changes.
• Worked with Teradata DBA team to build Database components, resolve access and performance issues.
• Responsible for ensuring the quality, coding standards and creating required documentations.
• Responsible in doing production executions, post production validations, giving LO Handover and getting signoff.
• Collaboration with multiple stakeholders including Client, Business Analyst, Source systems, Release Team, Testing Team and support teams.
• Deriving the deliverables, Risks/issues and reporting to higher up management and keeping track of the project status as well.

Confidential

Project Lead - Teradata

Responsibilities:

• Involved in gathering requirements, LOE Preparation, staffing.
• Involved in GAP analysis, Preparing BSD, TSD documents.
• Involved in Data Profiling using SQL.
• Worked on Stored Procedures.
• Worked with Data Architects to prepare mapping documents.
• Worked with solution architect in designing the project.
• Provided technical guidance and reviewing deliverables.
• Involved in design/developing Informatica mapping using complex transformations.
• Involved in coding Teradata BTEQ scripts and UNIX coding.
• Worked with Project Managers in Project planning and schedules.
• Responsible to track status, risks and issues, participating onsite/offshore meetings, conducting weekly team meetings, driving knowledge sharing sessions, conducting daily touch point calls.
• Migrating business objects reports and users.

Confidential

Technical Lead

Responsibilities:

• Providing 24 X 7 Production Support for Confidential Applications and ensure that all applications are available to business users within committed SLA’s.
• Batch monitoring through Work Load Manager (WLM) Tool.
• Handling Batch Failures and Daily Batch status reporting.
• Worked on fixing Production issues and providing technical support to the team.
• Worked on Data quality issues.
• Break Fixes and Permanent resolutions for repetitive production failures.
• Worked on priority1 issues which are to be solved in 4 hours as per SLA.
• Worked on automation of reusable processes.
• Responsible to collect defect Metrics and status reporting to the management.
• Worked with Process analyst to set the SLA for different ticket categories.
• Involved in reviewing resolutions and planning workloads.

Confidential

Technical Lead

Responsibilities:

• Involved in Analyzing, defining and documenting data requirements.
• Understanding the Functional Requirement.
• Created ETL Mappings for existing Sources/Feeds to Data warehouse fields.
• Extensively used most of the Transformations, which includes Look Up, Rank, Aggregator, Filter, Router, Joiner, Sequence Generator, Stored Procedure, and Expression to design and develop various mappings and performed data loads.
• Worked on creating UNIX scripting.
• Created unit test cases and executed.
• Involved in integrated and system Testing.
• Involved in doing peer reviews.

Confidential

Senior Data warehouse Developer

Responsibilities:

• Analyze the functional requirement of the data warehouse applications of Confidential .
• Estimation and planning for the new Change request or any enhancement related work.
• Creating the Oracle PL/SQL modules using Oracle Designer for extracting the information from different component of Vodafone and then populating them to the ODS (Operational Data Store) Coordination with the on-site team members.
• ETL mapping creation using Informatica transformations like Aggregator, Joiner, Filter, Expression, Router, Look up and Update Strategy.
• Worked with UNIX commands.

Confidential

ETL Developer

Responsibilities:

• Involved in gathering Requirements, Translating and preparing Functional Specifications document and Analyzing requirements
• Prepared Design documents and Mapping documents.
• Developed mappings using Informatica to load the data from different file system to staging area and from Staging Area to Warehouse targets.
• Created mappings using various transformations like Aggregator, Joiner, Filter, Expression, Router, Look up and Update Strategy.
• Testing the mapping according to Unit Test Cases.
• Integration testing and system testing at workflow level on each of the servers.
• Tracking issues and interacting with client for issue resolutions.

Confidential

Developer

Responsibilities:

• As a Team member I am primarily involved in Analysis, Development of mappings using needed Transformations in Informatica Power Center tool according to technical specifications, Testing, Review and Post Implementation Support.
• Involved in Unit Testing for the changes.
• Involved in on call Support and Provided Application Support for the System.
• Worked according to the rules of Cap Gemini Energy AM support environment.
• Quality assurance (participated in peer reviews and make sure the work is delivered without any bugs).

Confidential

Developer

Responsibilities:

• Writing technical specifications from functional specifications.
• Created COBOL programs and JCL jobs.
• Worked in IMS DB programs.
• Worked extensively on VSAM files.
• Wrote COBOL programs to load data into IMS database.
• Wrote Test Plan and Test Cases documents, Involved in Unit Testing.