SUMMARY

• 9 years of comprehensive and versatile exposure of IT experience on Data Warehouse and Business Intelligence with proven ability of implementation through Software development life cycle (SDLC) encapsulating the encyclopedic process like Business Requirements Analysis, Application Design, Development, Testing, Implementation and maintenance of client/server Data Warehouse and DataMart systems in the Telecom, Health Care, Online Media and Entertainment Domains.
• 8 years of development and design of ETL methodology for supporting data transformations and processing in a corporate wide ETL Solution using Informatica Power Center 9.5/8.6.1/8.0 , 7.2, Power Exchange for CDC, IDQ/IDE, Oracle PL/SQL, Teradata, DB2, SQL Server 2008.
• 2 years of experience in using Data modeling tools like ER Studio, ERWIN 4.0/3.5, Visio and Oracle Designer. Knowledge in designing and developing Data marts, Data warehouse using multi - dimensional Models such as Snow Flake Schema and Star Schema while implementing Decision Support Systems, OLTP and OLAP systems. Experience in FACT & Dimensions tables (SCD), Physical & logical data modeling with normalization process.
• 5 Years of database Programming experience using Oracle 10g PL/SQL,9i/8i, MS SQL Server 2000,MS Access7.0/2000, Teradata, SQL, PL/SQL, SQL*Plus, SQL*Loader and Impdp/expdp. Hands on Working knowledge in Oracle and PL/SQL Writing Stored Procedures, Packages, Functions, exception handling, ref cursors, autonomous pragma transactions and Triggers.
• 5+ years of experience in various types of testing like smoke, functional, Data Quality, Regression, Performance and System Integration testing.
• 3 Years of Shell scripting using sed, awk programming. FTPing files, split large files to process, archival process, running jobs in background, system load monitor etc.
• 2 years Business Intelligence reporting experience using SSAS, Business Objects 6.5, Cognos. Create Universes, catalogs, reports and modify existing reports in various BI tools.
• 1 Year experience in developing and executing FLOAD, MLOAD&BTEQ Scripts to load data into Teradata Enterprise Data warehouse from various source files, possess good knowledge over Teradata Database and it’s loader utilities.
• Proficient in creating deployment groups, migration of code across repositories, create users with right security levels
• Vast experience in Waterfall and Agile Methodologies
• Knowledge in Informatica MDM, ILM

TECHNICAL SKILLS

Data Warehousing Tools: Informatica Power Center 9.5.1 /9.1/8.6.1/7.0 , Power Exchange CDC, IDQ/IDE, MDM, ILM, SSIS.

Reporting Tools: Business Objects, SSRS Reports, Cognos Reports

Data Modeling Tool: Dimensional Data Modeling, Star/Snow flake Schema Modeling (2NF, 3NF), Erwin 8/7, Microsoft Visio.

Databases: Oracle 10g/9i/8i, Oracle golden gate CDC, DB2, Salesforce, Teradata V2R5 (Fast-Load, Multi-Load, Fast Export, BTEQ), MS SQL Server 2005/2008, MS Access.

Languages: SQL, PL/SQL, Shell Scripting, COBOL, core Java, VB Scripting

Operating Systems: Sun OS UNIX, IBM AIX, HPUX, MS Windows, Windows NT.

Utilities: Toad, SQL Developer, data loader

Others: Rally, HP Quality Center, Remedy User, Jira, Maestro, Tidal, Tivoli, Autosys, VCS, MS Visio, WinScp, Tomcat 6, WebLogic.

PROFESSIONAL EXPERIENCE

Confidential - San Diego, CA

Sr ETL Consultant

Responsibilities:

• Implement BI and Data Warehousing design principles and industry best practices
• Work closely with Leads, SME, Data architect, Data Analyst, BAs.
• Involve in gathering requirements and created architectural, detail design documents and mapping documents
• Involve in designing data model along with the Data Architect/Technical Lead
• Implement mapping for Initial/Incremental loads, Error handling, Audit and data quality checks
• Data profiling, data quality rules enforcement and work with data governance team.
• Develop mappings, mapplets, sessions, workflows, worklets, reusable transformations
• Identify bottlenecks and perform tuning using appropriate transformations in building mappings.
• Develop various dimensions like SCD Type1, Type2 and Facts and reconcile facts.
• Build scripts for Oracle golden gate Extract/Pump/Replicate process and implement.
• Maintain consistent ETL standards, configuration management strategies and production deployment standards
• Ensure ETL quality through code reviews along best practices, Standards, inspections and knowledge sharing
• Create and execute unit test plans and test cases based on system and validation requirements
• Log and maintain QA summary reports in Rally for bug fixes in multiple cycles.
• Develop, troubleshoot, optimize and tune ETL mappings.

Environment: Informatica 9.5.1, Oracle golden gate CDC, IDE/IDQ, DB2, MS SQL Server 2005, ER Studio, Shell programming, MS Visio, WINScp, TOAD 9, UNIX AIX, Erwin, Rally, Remedy User.

Confidential - San Jose, CA

ETL Consultant

Responsibilities:

• Convert the Business requirements into technical requirement documentation (FSD,TD).
• Develop ETL for Framework, Logging Activity, Control Tables and Error Handling by Interacting with the ETL Integration Consultants and Architects.
• Develop Informatica technical mapping document to pull data from different Source systems and integrate.
• Interact with Leads to understand the enterprise level operations and its process.
• Responsible to prepare mapping document, work closely with modeler on data model
• Workflow Recovery with mapping build for recovery, Tuning and Error Handling.
• Debugging and Performance Tuning of sources, targets, mappings and sessions.
• Develop several reusable transformations and mapplets, several workflow tasks.
• Develop mappings to load Facts and Dimensions
• Load sales force data on accounts, contacts, contracts, etc.
• Build Packages/Procedures/Functions using PL/SQL and performance Tuning.
• Worked on Oracle Utilities SQL Loader, UTL FILE, SMTP, EXPORT, IMPORT, Triggers, EXPLAIN PLAN, Cursors, Views, Materialized Views, Error Handling mechanism etc.
• Worked in Exceptional handling, records, arrays, Partitioning of tables, Bulk Collects.
• Fine tuning offensive SQL using SQL Trace, Analyze, Explain Plan, and TKPROF.
• Shell programming for manipulating the files using AWK and SED.
• Review test cases and evaluate test cases for Unit, Integration and system Testing.

Environment: Informatica 9.1, ORACLE RDBMS 10g, PL/SQL,OBIEE, MS SQL Server 2005, ER Studio, Sales Force, Shell programming, MS Visio, WINScp, Serena, TOAD 9, UNIX AIX, Erwin, HP Quality Center, Request Management tool.

Confidential - San Francisco, CA

Informatica Developer

Responsibilities:

• Perform analysis, validation on the flat files received from different source systems and integrate the various source systems.
• Design ETL Framework, Logging Activity and Error Handling by Interacting with the ETL Integration Consultants and Architects.
• Low Level Design Documentation of mapping/ETL Specs for business functionality
• Develop mappings to pull data from different Source systems and integrate.
• Integrate and load data from different sources like CSV files, Excel files, Cubes, Databases.
• Fine tune packages, SQL stored procedures and collect statistics for performance.
• Use different tasks like SQL task, package task, process task, email task, ftp task, script task etc.
• Create package containers to group related tasks for easy maintenance.
• Build Packages/Procedures/Functions using PL/SQL and performance Tuning.
• Worked in Exceptional handling, records, arrays, Partitioning of tables, Bulk Collects.
• Fine tuning offensive SQL using SQL Trace, Analyze, Explain Plan, and TKPROF.
• Shell programming for manipulating the files using AWK and SED.
• Responsible to deploy the releases according to the project plan.
• Provide production support and monitor the loads.
• Write test cases and evaluate test cases for Unit, Integration and system Testing.

Environment: Informatica 8.6.1, SSIS, MS SQL Server 2008, ORACLE RDBMS 10g, PL/SQL, SSIS, Shell programming, MS Visio, Web Logic, WINScp, VSS, TOAD 8, DOS Batch Programming, UNIX, Cygwin, CRONTAB, Erwin.

Confidential - San Jose, CA

ETL Developer

Responsibilities:

• Convert the Business requirements into technical requirement documentation (FSD, TD).
• Perform analysis, validation on the SAP data received from Scientific Atlanta, Tandberg source data and integrate the source systems.
• Develop ETL for Framework, Logging Activity, Control Tables and Error Handling by Interacting with the ETL Integration Consultants and Architects.
• Developed Informatica technical mapping document to pull data from different Source systems and integrate.
• Workflow Recovery with mapping build for recovery, Tuning and Error Handling.
• Debugging and Performance Tuning of sources, targets, mappings and sessions.
• Developed several reusable transformations and mapplets, several workflow tasks.
• Developed Slowly Changing Dimension Mappings of type II
• Created different transformations for loading the data into targets using various transformations.
• Interact with SMEs to understand the enterprise level operations and its process.
• Lead offshore team and interact 24*7 based on need.
• Shell programming for manipulating the files using AWK and SED.
• Responsible to deploy the releases according to the project plan.
• Provide production support and monitor the loads.
• Review test cases and evaluate test cases for Unit, Integration and system Testing.

Environment: Informatica 8.6.2, ORACLE RDBMS 10g, PL/SQL, SAP, Shell programming, MS Visio, WINScp, $U, PVCS, TOAD 9, UNIX AIX, Erwin, ONRAMP, HP Quality Center.

Confidential

Informatica Developer

Responsibilities:

• Convert the Business requirements into technical requirement documentation (LSD and ETL Design Documentation).
• Perform analysis, validation on the DB2 data received from California Track, Qcare related oracle data from Colorado and integrate the various source systems.
• Design ETL for Framework, Logging Activity, Control Tables and Error Handling by Interacting with the ETL Integration Consultants and Architects.
• Developed Informatica technical mapping document to pull data from different Source systems and integrate.
• Workflow Recovery with mapping build for recovery, Tuning and Error Handling.
• Debugging and Performance Tuning of sources, targets, mappings and sessions.
• Developed several reusable transformations and mapplets, several workflow tasks.
• Developed Slowly Changing Dimension Mappings of type II
• Complex mappings creation using various transformation tasks and fine tune.
• Build Packages/Procedures/Functions using PL/SQL and performance Tuning.
• Worked on Oracle Utilities SQL Loader, UTL FILE, SMTP, EXPORT, IMPORT, Triggers, EXPLAIN PLAN, Cursors, Views, Materialized Views, Error Handling mechanism etc.
• Assist in usage of Exceptional handling, records, arrays, Partitioning of tables, Bulk Collects.
• Shell programming for manipulating the files using AWK and SED.
• Responsible to deploy the releases according to the project plan.
• Create RFC and SRs for any enhancements for deployment and get approvals.
• Do health checks by ensuring the source data and target data are accurate and valid.

Environment: Informatica 8.6.1, ORACLE RDBMS 10g, PL/SQL, DB2,WinSQL, MS SQL Server, Shell programming, MS Visio, WINScp, VSS, TOAD 9, UNIX AIX, Cygwin, Tivoli, Erwin, Remedy User.