SUMMARY

• 8+ years of IT experience in BI and Data warehousing, performing ETL with domain noledge of Health Insurance and banking.
• Experienced in ETL Production Support and Development and Enhancement projects for major Health Insurance clients - BOA, Express Scripts, Confidential, Keystone and banking\Financial Services clients - Amex.
• Involved in all aspects of teh ETL process - requirement gathering, coming up with standard interfaces to be used by operational sources, coming up with data load strategies, data modeling, performing teh unit testing, integration testing, regression testing, end to end testing in development and QA environments.
• Strong Experience in Extraction, Transformation and Loading (ETL) of Data into Enterprise Data Warehouse using Datastage and Informatica Power Center.
• Strong noledge in Slowly changing Dimensions (SCD) and implementing them using Informatica mappings
• Experience in extraction of data from various Heterogeneous sources (Unix Flat Files, Teradata, Oracle and DB2) to load into data warehouse/data mart targets.
• Strong experience on UNIX shell scripting, PL/SQL. Developed stored procedures and functions to integrate teh business standard requirements.
• Involved in writing complex queries using various JOINS, co-related sub queries, STRING functions, analytical functions such as RANK, PARTITION BY etc in Teradata,DB2 and Oracle.
• Experience in developing PL/SQL, Teradata load utilities and good noledge in Teradata architecture.
• Well Versed in Data modeling concepts incorporating dimensional modeling (star and snowflake schema), logical and physical data modeling.
• Experience in working with Autosys creating and scheduling teh file watcher jobs and teh transformation jobs, testing of jobs.
• Extensive development, support and maintenance experience working in all phases of teh Software Development Life Cycle (SDLC).
• Prepare/maintain documentation on all aspects of ETL processes, definitions and mappings/jobs to support noledge transfer to other team members.
• Good understanding on incident, problem management, debugging, and root cause analysis, enhancement and maintenance activities.
• Experience in Data analysis, Defect Analysis and Impact analysis.
• Experience with quality/ Incident management tools such as QC,etc.
• Excellent oral/written/interpersonal communication skills, quick learner, willing to adapt to teh team/organizational environment.

TECHNICAL SKILLS

ETL Tools: IIBM Infosphere Data Stage (V 7.5 & V 8.0), Informatica 8.6.1

Databases: Teradata 12.0, PLSQL programming, DB2, Oracle 9i

Data Modeling Tool: ERWin, Microsoft Visio

Reporting Tool: Business Objects

Scheduling Tool: Autosys

Programming Languages: Unix shell scripting, C basics- algorithms

Environment: Microsoft Windows XP/NT/2000/98/95, Unix

PROFESSIONAL EXPERIENCE

Production Services Lead

Confidential

Responsibilities:

• Monitored teh daily weekly and monthly Load Batch jobs from Autosys.
• Monitored Datastage jobs and Mainframe jobs and debug teh failures based on teh business requirements and reach out to teh concerned team.
• Monitored teh Datastage sequence and UNIX scripts, batch jobs from Autosys.
• Understand existing architecture, Extract business logic and work with Business and upstream/downstream systems to build upon teh file transmission for Batch operations.
• TEMPEffectively Coordinate and interact with other systems to elaborate teh connection setup and debug failures by reaching to Development and DBA teams.
• Analyze teh data and files for teh root cause for data issue\failure and fix teh issue by reaching to source team.
• Assign work to offshore and transition to offshore for Production support with handover call

Environment: Datastage, Autosys, Unix Scripting,Oracle,Mainframe

Confidential

Senior ETL Developer \ Data Analyst at Cognizant Technology Solutions

Responsibilities:

• Developed Datastage jobs for data transformation and validation rules based on teh business requirements.
• Executed teh DB2 Procedures and UNIX scripts.
• Executing production Datastage jobs from UNIX box and monitoring teh load details.
• Data Analysis to ensure teh requirements is implemented as expected by BA’s.
• Work with minimal requirements from Business.
• Understand existing architecture, Extract business logic and work with Business and upstream systems to build upon teh Requirements and data fields.
• TEMPEffectively Coordinate and interact with other systems to elaborate teh System and Functional Requirements.
• Analysis and perform impact analysis to find out teh systems/programs that could be potentially affected by proposed change(s), coding, and testing activities.
• Prepare teh Design/ Tech Spec Document.
• Work in all teh phases (SDLC) of teh project - System and Functional Requirements, Analysis, Design, Construction, User Acceptance Testing, Implementation, Warranty and Post production support.
• Assign work to offshore and Review teh Offshore deliverables.
• Ensure top quality deliverables to clients.

Environment: Datastage 8.0, Teradata 12.0, DB2, PL/SQL, Unix Scripting

Confidential

Senior ETL Developer \ Analyst at Cognizant Technology Solutions

Responsibilities:

• Gather requirements from teh Client SME/onsite team for coding, Test data preparation, Unit testing and maintaining teh test logs.
• Developed bteq,fastload,mload & PLSQL scripts and Teradata Stored Procedures for extraction of data applying transformation and validation rules.
• Executed and tested teh Teradata Procedures scripts from Datastage Mappings.
• Transferred teh existing Datastage Environment to Teradata for performance efficiency
• Replaced teh Datastage developed functions through Teradata Procedures & Informatica Mappings for costing purpose
• Involved in data extracts by writing complex queries in order to meet teh expectations of teh business analysts
• Identifying dependencies of teh dimensions and facts that are required for clean data movement
• Creation of reusable UNIX shell scripts to add/delete source/log files, archive files.
• Performed teh Unit and Integration testing for teh jobs and moving to teh production environment.
• Done Review activities for teh peers and mentor teh new joinees to teh team.
• Defect Coordinator of teh team.

Environment: Datastage 3.1.2, Unix Scripting, Teradata 12.0, PL/SQL Stored Proc

Confidential

Senior ETL Developer at Infosys Technologies

Responsibilities:

• Developed PLSQL Procedures, BTEQ, Fast Load scripts for extraction of data - involves complex joins with lookup table, loading data into intermediate tables, data transformation.
• Developed teh modules for data threshold calculation and error reporting for incorrect data.
• Executed and tested teh Unix scripts developed for data transformation
• Creation of teh mapping standards and conventions to be followed through out in teh development of teh code.
• Involved in teh code review and standardization of teh Informatica mappings, workflows and sessions.
• Involved in teh preparation of test plans and test cases according to teh requirements.
• Involved in implementing performance tuning techniques by identifying and resolving teh bottlenecks in source, target, transformations, mappings and sessions by increasing block size, data cache size, target based commit interval and SQL Overrides.
• Handled change requests/bug fixing in existing Production environment.
• Involved in writing complex queries using various JOINS, co-related sub queries, STRING functions, analytical functions such as LEAD, LAG, RANK, PARTITION BY etc in Teradata.
• Implemented SCD in informatica mappings.
• Ensuring top quality deliverables to client and collection of project metrics
• Managing teh Time Tracking and Billing for teh entire Team.

Environment: Informatica 8.6.1, Unix Scripting, Teradata 12.0, PL/SQL