SUMMARY:

• A dedicated & keen professional with around 10 years of Business Discovery, Data Discovery & Analysis, Data Modelling, ETL Design, Development, Testing, Implementation and Troubleshooting in the field of Data warehousing Applications.
• Informatica - Certified Developer with strong Data warehousing experience specializing in RDBMS, ETL Concepts, Strategy, Design & Architecting, and Informatica Development & Testing.
• Over 3 Years of Experience in Project Planning and Tracking, Identifying and Mitigating risks, Development and Maintenance of DWH applications.
• Around 2 years of Experience in Big Data Migration projects, by using Informatica BDM/DQ, Hadoop, Hive, Squoop tools.
• Large amount of experience gathering user requirements and translating them into technical and system specifications. Managing clients, vendors, and partner relationships.
• Currently associated with Cognizant Technology Solutions US Corp as Senior Application Lead.
• Exposure to applications in Industry verticals like IT Services, Health care and Insurance
• Good knowledge of software processes gained while working with robust data warehouse development projects for clients like National Health Service ( Confidential ) UK, Health Net and Centene (USA)
• Participated in Quality Audits, Training and recruiting programs for current employer.

AREA OF EXPERTISE:

• Extensive experience in Full Life Cycle projects for the development and enhancement of Operational Data Ware House Projects such as Gathering business requirements, Data modelling performed source system analysis, prepared technical design documents, source to target data mapping documents, Build, Testing, implementation and Production support activities.
• An expert in the ETL Tool Informatica which includes components like Power Center, Designer, Workflow Manager, Workflow Monitor, Repository Manager, Repository Server Administration Console, Data Quality, BigDataManagement, have had extensive experience in working with various PowerCenter Transformations using Designer Tool. Have handled various Data Sources like RDBMS, Oracle, SQL Server, MS Access, MS Excel, including COBOL Files, Flat Files CSV files, EDI translated 834/820 Formatted Files and XML Files.
• Very good knowledge of Data Warehouse/Data mart concepts and Expertise in data modelling for OLAP & OLTP systems from design and analysis to implementation including the conceptual, logical and physical data models by using Erwin
• Was involved in the complete life cycle of lot of Data warehouse implementations which include System Architecture, Functional/Technical Design, Development - Coding and Testing (Unit Testing, System Integration Testing and User Acceptance Testing) and Implementation.
• Good experience in Unix Shell Scripting and ETL Process Automation using Shell Programming and Informatica. Also have had quite good experience in Performance Tuning at both Database Level and Informatica.
• Proficiency in Oracle PL/SQL, SQL*Plus, SQL Loader
• Played various roles on Projects that required Data warehouse consulting which include Data warehouse ETL Architect, Program Technical Lead, Defect prevention Representative, Software quality Analyst and Project/Team Lead and Managerial roles with a maximum project team size of 10 Consultants.
• Worked on Big Data Migration project from Informatica Power Center to Informatica Big Data Management on Big data environments Harton work Hadoop Platform 2.7.1.
• Provided tier-1, tier-2 and tier-3 level production support and track issues/requests for system enhancements.
• Strong Logical and Analytical Reasoning Skills, Excellent Communication with good Listening, Presentation and Intrapersonal Skills.
• Strong Team building and mentoring skills and excellent Team leadership capability.
• Very good knowledge in working with Windows and UNIX operating systems.
• Conceptualizing detailed project reports and project execution plans after thorough discussion with clients.
• Good Knowledge of IT Governance involving alignment of IT processes and business goals. Exposure to world class IT processes and their deployment for continuous improvement focus.
• Spearheading the operations progress to meet the committed timelines on regular basis.
• Providing updates & presentations to management on ongoing projects, new technologies and other initiatives.
• Interacting and proactively understanding customer's requirements and provided the permanent fixes
• Experienced in leading multiple team members at both onsite and offshore locations

TECHNICAL SKILLS:

Domain: Health Insurance

Project Management Tools: MS-Project

ETL Tools: Informatica BDM 10.x,Informatica Powecenter 8.x/9.x/10.x,InformaticaDataQuality9.6.1,Microsoft Data Transformation Services(DTS),SSIS

Reporting Tools: Business Objects 3.x/4.x,Tableau 10,MicroStrategy

Data Bases: Oracle 8i/9i/10g/11g, MS-SQL Server 2000/2005/2008/2012. Tera Data 14.0, Hive1.2.1,Amazon Redshift,S3

Data Modelling: ERWIN 4.0, MySQL Workbench 5, Sybase Power Designer and Ms-Visio

Development/Productivity Tools: SQL Server Management Studio, Query Analyzer, SQL Profiler,Sqoop

OperatingSystems: Windows 98, 2000/XP/07. HP UNIX 3.2.2, Sun Solaris 7,Susi Linux

Hive Interface: Ambar2.0

Scripting: Unix,Perl.HTML,C,SQl/PLSQL,T-SQL,TOAD,SQL Loader.

Schedulers: Informatica Scheduler and Unix script based tools, Cisco Tidal Enterprise Scheduler 6.2,Autosys 11.0

Configuration Management Tools: Visual Source Safe 6.0 and IBM Rational Synergy

Soft Tools: Microsoft Office 2005, 2007, 2010.

Quality Tools: HP Quality Centre, HP Application Lifecycle Management

Service Delivery: Remedy, Service Now, Jira

PROFESSIONAL EXPERIENCE:

Confidential, St Louis, MO

Technologies: Informatica BDM 10.1, Informatica 9.6.1, Oracle11g, RDB 7.2, SQL Server, Hadoop, Hive, Squoop, Perl, Teradata, Amazon redshift, Big Decisions (Cognizant Product), BRAVO (Cognizant product), Jira, Cisco Tidal scheduler

Responsibilities:

• Played the role of a Program ETL Lead/ETL Architect and was responsible for designing the ETL Strategy & Architecture of the Project.
• Was responsible in managing tasks and deadlines for the ETL teams both Onsite and Offshore.
• Was the Single Point of contact on the ETL team for other teams such as Reporting, Testing, QA and Project Management for updates on Project Status and issues.
• Break up the work into task list and estimate based on simple, medium and complex methodology
• Prepared/Reviewed technical specifications documents to develop Informatica BDM mappings to load data into Hive tables from various source files like COBOL, XML, CSV, XLS,EDI translated 834/820 formatted files and Databases Like Oracle, RDB and MS SQL.
• Was involved in conducting the review of Informatica Code, Unit Test Cases & Results with the Developers.
• Organize daily technical discussions with the Onsite team also including the individual offshore work stream leads and set expectations for offshore delivery.
• Developing, implementing & providing all kind of support in migration activities.
• Extensively worked on Informatica Developer 10.1.0 Developer tool.
• Extracted data from various sources like COBOL, XML, CSV, XLS and Databases like Oracle, RDB and MS SQL and load into Hadoop hive tables.
• Extensively used managed tables and External ORC compressed tables during migration activities.
• Used Data processor transformation for COBOL, XML source files.
• Implemented dynamic mappings for the related staging loads
• Implemented CDC logic for incremental loads.
• Used Tidal for scheduling the informatica BDM jobs
• Providing updates & presentations to management on ongoing projects, new technologies and other initiatives.

Confidential, Woodland Hills, CA

Project Lead/Architect

Technologies: Informatica 9.6.1, Oracle11g, UNIX scripting, Perl, Erwin 4.0,IDQ, Informatica/EISscheduler.

Responsibilities:

• Liaise with business subject matter experts in analysing business requirements, understand the various data sources.
• Model & Architect DW design, direct and/or execute the technical characteristics of the overall strategy of the data warehouse and ETL process in Informatica.
• Architect the database schema. Review and maintain the schema, its tables, indexes and views in Oracle 11g.
• Map source system data elements to target system and develop, test, and support extraction, transformation and load processes.
• Design and develop the technical/functional specification for ETL development and implement using Informatica.
• Manage artifacts - versions, including software code, documents, design models, and even the directory structure itself.
• Based on business rules, load related data, develop Informatica mappings, create sessions, workflows to load and process data received from Source system(ABS)
• Prepared the required ETL unit test cases for assigned modules.
• Self-Review of Unit test cases, Integration test cases of all the modules.
• Do the detailed unit/integration testing.
• Providing User Acceptance testing support for all data loads and any clarifications
• Code Migration from lower environments Production environments.
• Providing all types of Production support based on the priority of Tickets.

Confidential

Technologies: Informatica 9.x, Oracle11g, UNIX scripting, Perl, Business Objects 5.0

Responsibilities:

• Lead and guide development of an Informatica based ETL architecture
• Assessed requirements for completeness and accuracy and determined if requirements are actionable for ETL team
• Conducted impact assessment and determine size of effort based on requirements.
• Established best practice and standard for ETL process documents.
• Designed ETL architecture and architecture documents.
• Created source to target mapping document.
• Reviewed ETL process detail design from ETL Developer.
• Coded ETL mappings, sessions and workflows.
• Creating QA testing scripts and Test Case document.
• Supported UAT testing and defect fixes.
• Trouble-shot and implemented existing code.
• Provided on-call technical support assistance for the Informatica application as part of an on call rotation.

Confidential

Technologies: Informatica 9.6.1, Oracle11g, UNIX scripting, Perl,

• Direct and/or execute the technical characteristics of the overall strategy of the data warehouse and ETL process.
• Lead the application development team in providing support & maintenance.
• Involved in Requirement Gathering, Analysis, Design and Development
• Worked on Informatica Power Center tools - Source Analyzer, warehouse designer, Mapping Designer, Workflow Manager.
• Developed Informatica Mappings and Sessions based on user requirements and business rules to load data from source RDBMS tables to flat files.
• Maps sources system data elements to target systems and develops, tests, and supports extraction, transformation and load processes - define mapping, sessions and workflow
• Involved in QA testing for different Objects.
• Timely resolution of incidents based on the estimate and agreed date/ time
• Delivering Objects with High Quality
• UAT Support and Code deployment
• Involved in post-production support.
• Helping the team members to deliver the Objects with adequate quality.

Confidential

ETL Developer/Module Lead

Technologies: Informatica 8.6, Oracle11g, UNIX scripting, Perl

• Involved in Requirement Gathering, Analysis, Design and Development
• Involved in preparing Technical design specification, Unit testing and system testing documents
• Building ETL code, Unit Testing and Performance Testing for the Mappings
• Developing UNIX and Perl scripts to achieve the requirements fulfilled in Informatica.
• Delivering Objects with High Quality
• UAT Support and Code deployment
• Involved in post-production support.
• Attending quality audits
• Helping the team members to deliver the Objects with adequate quality.

Confidential

ETL Developer/Module Lead

Technologies: Informatica 8.6, Oracle11g, UNIX scripting, Perl

Responsibilities:

• Involved in Requirement Gathering, Analysis, Design and Development
• Involved in preparing Technical design specification, Unit testing and system testing documents
• Building ETL code, Unit Testing and Performance Testing for the Mappings
• Developing UNIX and Perl scripts to achieve the requirements fulfilled in Informatica.
• Delivering Objects with High Quality
• UAT Support and Code deployment
• Involved in post-production support.
• Attending quality audits
• Helping the team members to deliver the Objects with adequate quality.

Confidential

Technologies: Informatica 8.6, Oracle11g, UNIX scripting, Perl

Responsibilities:

• Involved in Requirement Gathering, Analysis, Design and Development
• Involved in preparing Technical design specification, Unit testing and system testing documents
• Building ETL code, Unit Testing and Performance Testing for the Mappings
• Developing UNIX and Perl scripts to achieve the requirements fulfilled in Informatica.
• Delivering Objects with High Quality
• UAT Support and Code deployment
• Involved in post-production support.

Confidential

Technologies: Informatica 8.6, Oracle11g, UNIX scripting, Perl, MS Visotica mappings will be created to load the AZ data into newly created tables in Oracle.

Responsibilities:

• Involved in Requirement Gathering, Analysis, Design and Development
• Involved in preparing Technical design specification, Unit testing and system testing documents
• Building ETL code, Unit Testing and Performance Testing for the Mappings
• Developing UNIX and Perl scripts to achieve the requirements fulfilled in Informatica.
• Delivering Objects with High Quality
• UAT Support and Code deployment
• Involved in post-production support.

Confidential

Technologies: MS Excel, MS Visio, SQL Server2008, Informatica 8.6, Data Transformation Services.

Responsibilities:

• Designing Intermediate Flat Files
• Creating Mappings in Informatica based on the inputs given in the IFF.
• Performing Unit testing on the created packages.
• Creating XML files and Writing Validation rules.
• Loading the extracted data in to target by using LDMS Tool.
• Performing the UI validation for the loaded Data.
• Solving the Loading Issues and CS Issues, UI Validation
• Analyzing the Customer requirements and Business Processes.

Confidential

Technologies: MS Excel, MS Visio, SQL Server2008, Informatica 8.x

• Designing Intermediate Flat Files
• Creating Mappings in Informatica based on the inputs given in the IFF.
• Performing Unit testing on the created packages.
• Creating XML files and Writing Validation rules.
• Loading the extracted data in to target by using LDMS Tool.
• Performing the UI validation for the loaded Data.
• Solving the Loading Issues and CS Issues, UI Validation
• Analyzing the Customer requirements and Business Processes.

Confidential

ETL Developer

Technologies: MS Excel, MS Visio, SQL Server2008, Data Transformation Services (DTS)

Responsibilities:

• Designing Intermediate Flat Files
• Creating Mappings in Informatica based on the inputs given in the IFF.
• Performing Unit testing on the created packages.
• Creating XML files and Writing Validation rules.
• Loading the extracted data in to target by using LDMS Tool.
• Performing the UI validation for the loaded Data.
• Solving the Loading Issues and CS Issues, UI Validation
• Analyzing the Customer requirements and Business Processes.