EDUCATION

Bachelor of Technology in Computer Science and Engineering

TECHNICAL SKILLS

ETL Tools: Informatica Power Center 6.x/7.x/8.1.1/8.5.1/8.6.1

Scheduling Tool: OBIEE DAC, Autosys, Tidal

BI Tools: Business Objects 6.5/XI/XIR2,Cognos 6.0

Data Cleansing Tool: Trillium

Data Modeling Tool: Erwin 4.5

RDBMS: Oracle 9i/10G/11G, MS Access 2000/2002, IBM UDB DB2 8.0/7.0, MS SQL Server 2002/2005

CRM:SalesForce.com(SFDC)

GUI Tools: WinSCP (SFTP), Toad, SQL Navigator, MS Share point, Clear case (version control), SQL * Loader, HP Quality Center

Languages: SQL, PLSQL, COBOL, XML, UNIX Korn Shell Scripting

Web Servers: Apache, Tomcat, Web Logic 2.0

Operating Systems: Windows NT, XP, UNIX (Sun-Solaris/AIX/HP), and Linux

Others: MS Office Products (Project, Excel, Power Point, word, Outlook, Visio etc.)

PROFESSIONAL SUMMARY

• Over 11 years of IT experience in ETL Architecture, Analysis, design, development, testing ,implementation, maintenance and supporting of Enterprise level Data Integration,Data Warehouse (EDW) Business Intelligence (BI) solutions using Operational Data Store(ODS)Data Warehouse (DW)/Data Mart (DM), ETL, OLAP, ROLAP Client/Server and Web applications on Windows and Unix platforms
• Worked on projects for Insurance Clients such as The Hartford, BlueShield Of CA and life sciences Clients such as Pfizer Inc., Amgen Inc., AstraZeneca(With IMS data), and Retail Clients such as Ahold Inc.,7Eleven and Staples Inc.
• Over 10 years of Relational Modeling and Dimensional Data Modeling using Star & Snow Flake schema, De normalization, Normalization, and Aggregations. Designed Data bases using Erwin 4.5
• Over 9 years experience in using Informatica Power Center 6.x/7.x/8.1.1/8.5.1/8.6.1Data Stencil, Designer, Repository Manager, Server Manager, Workflow Manager, Workflow Monitor including Administration and performance tuning of Informatica transformations/mappings/sessions/workflow's
• Over 2 Years of experience in generating various complex reports, Dash Boards and score cards using Business Objects 6.X/XI/XIR2 Designer, Reports, Info view, Supervisor, Web Intelligence(WEBI) including security administration
• Over 11 Years of experience in using SQL, PL/SQL Dynamic SQL,Stored procedures/functions, triggers and packages, complex joins, correlated sub-queries, aggregate functions analytic functions, materialized views, indexing, partitioning and performance tuning the same using explain plan and TKPROF Analysis.
• Over 11 years of experience working in large scale data warehouse using Databases like Oracle 11g/10g/9i, MS Access 2000/2002, XML ,IBM UDB DB2 8.2, SQL Server 2000 ,SalesForce.com(SFDC), MS Excel and Flat files
• Have Good understanding of ETL/Informatica standards and best practices ,Confirmed Dimensions, Slowly Changing Dimensions (SCD1,SCD2,SCD3)
• Experience in writing UNIX Korn shell scripting
• Experience creating dimensions and cubes
• Experience in Data Quality Analysis, Data Profiling, Data cleansing and Master data management
• Experience in testing coordination ,writing test cases and executing test scripts ,And logged defects in HP Quality Center(QC),StarTeam
• Maintaining and Supporting during Assembly/Integration Test ,QA,UAT, and Production for Issues/Bug fixes/Defects
• Experience in all phases of agile System Development Life Cycle(SDLC)
• Excellent team player with very good communication skills and leadership qualities.
• Experience with coordinating and leading onsite-offshore development

EXPERIENCE

ConfidentialnBroomfield, CO July' 2011-Till date

Senior Data Warehouse/ETL/Informatica Technical Lead

• Involved in business requirement analysis and prepared functional requirement document
• Involved in the ETL technical design discussions and prepared ETL high level technical design document
• Involved in the analysis of source to target mapping provided by data analysts and prepared function and technical design documents
• Extracted data from excel files ,high volume of data sets from data files, Oracle ,DB2,SalesForce.com(SFDC) using Informatica ETL mappings/SQL PLSQL scripts and loaded to Data Store Area
• Created complex Informatica mappings using Unconnected Lookup, joiner, Rank, Source Qualifier, Sorter, Aggregator, newly changed dynamic Lookup and Router transformations to extract, transform and loaded data mart area
• Created re-usable transformations/mapplets and used across various mappings
• Wrote complex PLSQL scripts /functions/procedures/packages
• Developed Informatica workflows/worklets/sessions associated with the mappings using Workflow Manager
• Created Tidal jobs to schedule Informatica Workflows
• Executed workflows using Tidal scheduler
• Wrote Unit Test cases and executed unit test scripts successfully
• Involved in performance tuning of Informatica code using standard informatica tuning steps
• Involved in the performance tuning of SQL/PLSQL scripts based on explain plan
• Supported during QA/UAT/PROD deployments and bug fixes
• Wrote UNIX Korn shell scripts for file transfer/archiving./Email notifications
• Involved in code Reviews as per ETL/Informatica standards and best practices

Technology:

Erwin4.5, Informatica Power Center 8.6.1, Oracle11G, DB2,SalesForce.Com(SFDC), PLSQL, TOAD, ODBC, Tidal, Windows XP, Unix Korn Shell Scripting, MS Excel and Flat Files, MS project, WinSCP, StarTeam

Confidential, Sanfrancisco, CA July 2010-June'2011

On-site Data Warehouse /ETL/Informatica Lead

• Involved in business requirement analysis and prepared functional requirement document
• Involved in the ETL technical design discussions and prepared ETL high level technical design document
• Involved in the analysis of source to target mapping provided by data analysts
• Involved in ETL low level design and prepared design document for each of the target table
• Extracted data from excel files ,high volume of data sets from data files, Oracle using Informatica ETL mappings/SQL PLSQL scripts and loaded to PRESTG area
• Created complex Informatica mappings using Unconnected Lookup, joiner, Rank, Source Qualifier, Sorter, Aggregator, dynamic Lookup and Router transformations to extract, transform and loaded data to ODS
• Created re-usable transformations/mapplets and used across various mappings
• Created completed informatica mappings to load dimensions and facts to EDW area
• Wrote complex PLSQL scripts /functions/procedures/packages
• Experience in the execution of SQL scripts through informatica external procedure transformation using UNIX shell script.
• Developed Informatica workflows/worklets/sessions associated with the mappings using Workflow Manager
• Created integrated workflow per subject area keeping the dependency with in the subject area
• Executed workflows using inbuilt ABC(Audit, Balancing and Control) process
• Wrote Unit Test cases and executed test scripts successfully
• Involved in performance tuning of Informatica code using standard informatica tuning steps
• Involved in the performance tuning of SQL/PLSQL scripts based on explain plan
• Supported during QA/UAT/PROD deployments and bug fixes
• Wrote UNIX Korn shell scripts for file transfer/archiving./Email notifications
• Involved in code Reviews as per ETL/Informatica standards and best practices

Technology:

Erwin4.5,Informatica Power Center 8.6.1, Oracle11G, PLSQL, TOAD, ODBC, Windows XP, Sun-solaris, Unix Shell Scripting , MS Excel and Flat Files , MS project,WinSCP

Confidential, Quincy, MA April 2009-July 2010

Senior Data Warehouse /ETL/Informatica Specialist

• Involved in business requirement analysis and design ,prepared functional and technical design document
• Involved in creating logical ,physical data models for cleansing model
• Involved in data profiling ,data quality and data cleansing and metadata management
• Extracted data from Salesforce.com(SFDC),Oracle,excel ,data files using Informatica ETL mappings/SQL PLSQL scripts
• Created complex Informatica mappings using Unconnected Lookup, joiner, Rank, Source Qualifier, Sorter, Aggregator, newly changed dynamic Lookup and Router transformations to extract, transform and load data to Cleansing area
• Wrote complex PLSQL functions/procedures/packages
• Developed Informatica workflows/worklets/sessions associated with the mappings using Workflow Manager
• Wrote Test cases and executed test scripts in Cleansing area
• Involved in performance tuning of Informatica code and PLSQL scripts
• Supported during QA/UAT/PROD deployments
• Wrote UNIX Korn shell scripts for file transfer/archiving.
• Involved in Reviews as per ETL/Informatica standards and best practices
• Created Autosys JIL files and executed to generate Autosys Jobs.
• Scheduling of Informatica workflows/sessions using Autosys

Technology:

Erwin4.5,Informatica Power Center 8.5.1/8.6.1, Oracle9i/10G, PLSQL, TOAD, ODBC, Autosys, Windows XP, Sun-solaris, Share point ,SQL Server 2005, XML, Lotus Notes DB,XML,Salesforce.com(SFDC),Sun-Solaris Shell Scripting , MS Excel and Flat Files , MS project, HP Quality Center,WinSCP

Confidential,Hartford, CT April 2007-March 2009

Senior Data Warehouse /ETL/Informatica Developer

• Analyzed business requirements, performed source system analysis, prepared functional and technical design documents
• Extracted data from oracle, SQL server, Lotus notes, XML, MS excel and Flat files, transformed and loaded to common Oracle staging area.
• Implemented Oracle streams change data capture (CDC) to capture the changes.
• Created complex Informatica mappings using Unconnected Lookup, joiner, Rank, Source Qualifier, Sorter, Aggregator, newly changed dynamic Lookup and Router transformations to extract, transform and load data to staging area.
• Wrote complex PLSQL functions/procedures/packages to generate Table DDL's, Session XML's, Parameter files and load functions to load target tables.
• Developed Informatica workflows/worklets/sessions associated with the mappings using Workflow Manager
• Involved in test data preparation as per test data strategy and standards.
• Wrote Test cases and executed test scripts in Data warehouse
• Wrote UNIX Korn shell scripts for file transfer/archiving.
• Involved in Reviews as per ETL/Informatica standards and best practices
• Involved in Data Validation and Data Integrity checking.
• Created Autosys JIL files and executed to generate Autosys Jobs.
• Scheduling of Informatica workflows/sessions using Autosys

Technology:

Erwin4.5,Informatica Power Center 8.1.1/8.5.1/8.6.1, Oracle9i/10G, PLSQL, TOAD, ODBC, Autosys, Windows XP, Sun-Solaris, Share point ,SQL Server 2005, XML, Lotus Notes DB,XML, , Sun-Solaris Shell Scripting , MS Excel and Flat Files , MS project, HP Quality Center,WinSCP

Confidential,San Diego, CA July 2006- March 2007

On-site Data Warehouse /ETL/Informatica Lead

• Involved in System Study and Transferred knowledge to offshore team
• Involved in production support and ensured ETL processes works as expected
• Involved in researching and resolving production issues
• Involved in technical supporting, troubleshooting data warehouse application to meet Service Level Agreement(SLA's)
• Handling of CR's (Change Requests) and enhancements for existing application and followed change management process
• Understanding the business requirement specifications provided by the client.
• Involved in Data Quality ,Data profiling , Data Cleansing and metadata management
• Performing impact analysis and handling ETL change requests based on the business rules.
• Created design specifications for ETL coding and mapping standards
• Created complex mappings using Unconnected Lookup, joiner, Rank, Source Qualifier, Sorter, Aggregator, newly changed dynamic Lookup and Router transformations to extract, transform and load data to staging area.
• Wrote PLSQL procedures/Functions and called from Informatica
• Involved in test data preparation for all releases.
• Wrote Test cases and executed test scripts in Data warehouse
• Scheduling of Informatica workflows using Autosys Scheduler
• Establish performance and tuning methods for mappings, workflows
• Distribution of work to onsite and offshore team and follow-ups.
• Reviewing the work and submitting the work to client with sufficient documentation
• Created timelines for project completion and cost estimation.

Technology:

Erwin 4.5, Informatica Power Center 7.2.1/8.1.1,Oracle 9i,ODBC,PLSQL, MS Access 2002, Autosys, Flat Files, TOAD,SQL Server 2005, Windows XP, HP UNIX Korn Shell Scripting, Clear Case,WebLogic,MS Project,FTP, HP Quality Center

Confidential,Chennai, India January 2006-June 2006

Senior Business Objects Developer

• Analyzed data model and business reporting requirements
• Prepared Reporting design specification document
• Involved in Data Quality, Data profiling, Data Cleansing and metadata management.
• Designed and developed the universe as per business requirements
• Created Contexts and Aliases for resolving Loops in the Universes
• Created user objects including Dimensions, Details and Measures.
• Wrote the complex SQL queries including Sub Queries, Unions, Intersect Developed and tested the Business Objects reports
• Created Master Detail and Cross Tab reports to view the data in an analyzed way.
• Implemented Security Features of Business Objects like row level, object level and report level to make the data secure.
• Provided the security access management by creating users/groups and folders.
• Create DESKI and WEBI reports as per requirements
• Created Dash board reports and score card reports
• Reports were formatted to the Users according to their requirements using Business objects like Slice and Dice, Drill Down and Formulas etc.
• Used Broadcast Agent for scheduling and broadcast timely reports.
• Handled Knowledge Transfer session to Pfizer BI team on BO reports
• Managed the project, created timelines for project completion and cost estimation.

Technology:

Erwin 4.0, Informatica Power Center 7.1.1, Business Objects 6.5.1/XI ,Java,WEBI,Oracle 9i,IBM DB2,Autosys,SQL Server 2002, SQL Navigator, Flat Files, Windows XP, HP UNIX Korn Shell Scripting.,WebLogic

Confidential,Chennai, India January 2005- December 2005

ETL/Informatica Developer

• Involved in requirement analysis and development based on the business transformation specifications.
• Understood Life sciences Siebel 7.x pharma data model
• Involved in pulling IMS sales and Early view data for sales and marketing
• Customized Siebel Vanilla Informatica mappings to pull the data from Siebel OLTP
• Created sessions/Workflows using Informatica
• Wrote PLSQL procedures/Functions and called from Informatica
• Transformed data using Informatica Power Center transformations
• Scheduled ,grouped and executed Informatica mappings through OBIEE Data Administration console(DAC)
• Built Siebel Relationship Management Warehouse(SRMW)
• Did performance tuning at mapping and session level in order to improve performance.
• Comply with Siebel standards for folder/objects maintenance and migration
• Assisted reporting team in resolving data issues/fixes
• Assisted reporting team in creating complex reports as per requirements
• Written Shell scripts to create parameter files update process and compress files.
• Created test plan, and implemented test plan and analyzed test failure.
• Created timelines for project completion and cost estimation.

Technology: Informatica Power Center 7.1.1, Oracle9i, MS Access 2000, PLSQL, TOAD, Siebel Analytics 7.7.1,Siebel DAC,Siebel OLTP,OBIEE

Confidential, Chennai, India October 2004-December 2004

ETL/Informatica Developer

• Involved in requirement analysis and development based on the business transformation specifications.
• Created Informatica mappings and sessions using Informatica
• Wrote PLSQL procedures/Functions and called from Informatica
• Transformed data using the Informatica Power Center transformations
• Scheduled and executed Informatica mappings
• Did performance tuning at mapping and session level in order to improve performance.
• Written Shell scripts to create parameter files update process
• Created test plan, and implemented test plan and analyzed test failure.
• Created timelines for project completion and cost estimation.

Technology: Informatica Power Center 6.1.2, Oracle 9i, MS Access 2000, TOAD, PLSQL, Tomcat

Confidential,Chennai, India November 2003-September 2004

ETL/Informatica Developer

• Involved in requirement analysis and development based on the business transformation specifications.
• Created Informatica mappings and sessions using Informatica 6.2.2
• Wrote PLSQL procedures/Functions and called from Informatica
• Scheduled and executed Informatica mappings through UNIX shell scripts
• Created test plan, and implemented test plan and analyzed test failure.

Technology: Informatica Power Center 6.1.2, Oracle9, IBM UDB DB2, XML, Flat Files, TOAD, SQL, Trillium

Confidential,Hyderabad, India August 2002 - October 2003

Business Objects Developer

• All reports were created & automated using Business objects and Broadcast Agent Server.
• Used Universes as the main Data Providers for creating reports.
• Wrote the complex SQL queries including Sub Queries, Unions, Intersect and Aliases.
• Created user objects including Dimensions, Details and Measures.
• Created Contexts and Aliases for resolving Loops in the Universes
• Reports were formatted to the Users according to their requirements using
• Business objects like Slice and Dice, Drill Down and Formulas etc.
• Created Master Detail and Cross Tab reports to view the data in an analyzed way.
• Created dash boards and score card reports
• Implemented Security Features of Business Objects like row level, object level and report level to make the data secure.
• Provided the security access management by creating users/groups and folders.
• Created the documentation and gave the total presentation of these screens using Power Point in various meetings.

Technology: Business Object 5.1.7, Oracle 8i, Win NT, TOAD

Confidential,Hyderabad, India September 2001-July 2002

Business Objects Developer

Technology: Business Object 5.1.7, Oracle 8i, Win NT, TOADs