Sriram Sunkavalli Email: acvl5n@r.postjobfree.com

(Senior Informatica Developer) 571-***-****(mobile)

PROFESSIONAL SUMMARY:

Ten(10) years of experience in Information Technology with a strong working background in Data warehousing using Informatica and SAP BI nearly 8+ years of experience in ETL process using Informatica Power Center 9.x/8.x/7.x, Oracle 10g/9.x/8.x/7.x,Sqlserver,Teradata,DB2,MS Access ’97/2000, OLTP, OLAP, Autosys, ESP and DAC.

Good Domain knowledge in Finance, Insurance, Banking and HR systems.

Experience in integration of various data sources with Multiple Relational Databases like Oracle, SQL Server, Teradata,DB2 and Worked on integrating data from flat files like fixed width and delimited.

Have extensively worked in developing ETL for supporting Data Extraction, transformations and loading using Informatica Power Center.

Strong experience with Informatica client tools – Source Analyzer, Warehouse designer, Mapping designer, Mapplet Designer, Transformations Developer, Informatica Repository Manager and Informatica Server Manager, Workflow Manager/Monitor.

Worked extensively with complex mappings using different transformations Like Source Qualifiers, Expressions, Filters, Joiners, Routers, Union, Unconnected / Connected Lookups and Aggregators.

Expertise in implementing complex business rules by creating re-usable transformations, and Mappings/Mapplets.

Experience in debugging mappings. Identified bugs in existing mappings by analyzing the data flow and evaluating transformations.

Hands on experience in Performance Tuning of sources, targets, transformations, mappings and sessions.

Good working knowledge on customizing OOTB mappings using OBIA.

Knowledge on Informatica Administrator consol and also create the users.

Good knowledge about SQL and PL/SQL programming.

Experience in creating Transformations and Mappings using Informatica to move data from multiple sources into targets and Data marts and Data warehouse.

Involved in extensive Production Support for crucial issues, Migration activities,Production Support and deployment activities.

Very good team player with good communication and coordination skills, highly motivated and enthusiastic professional with a strong duty-first attitude.

TECHNICAL PROFICIENCIES

Operating System: WINDOWS 2003/2000/NT/XP/7, AIX, Unix,Linux

Database: ORACLE 10g/9i/8i, MS SQL Server, DB2,Teradata

DB Tools: SQL-TOAD, SQL Developer, DB Visualizer Pro 9.0.6, SQL-Navigator, SQL*PLUS, SQL* Loader, PL/SQL 2.3/8.0

ETL Tools: Informatica Power Center/Developer 7.2/8.1/8.6.1/9.1.0/9.5.1/9.6.1

Reporting Tools: Business Objects 6.2/5.1, Cognos7.0/8.0,Tabluea,OBIEE

Data Modeling Star Schema Modelling, Snow Flake Modelling, ERWIN 4.0/ERX 3.5.2

Scheduling Tools: Autosys, ESP(Enterprise System Platform), DAC(Data ware house Administrative Consol)

Project Mgmt Tools: Jira, Rally, Solution Manager

Web Technologies: HTML, XML,Unix

Hardware: HP-K570, HP 9000/800, RS6000, Citrix Meta Frame

PROFESSIONAL EXPERIENCE

Client: Cigna Health Care, Philadelphia, PA (08/15– Till Date)

Role: Senior Informatica Developer

Cigna is a global health service company dedicated to helping people improve their health, well-being and sense of security. In 1982, Cigna was formed through the combination of INA Corporation and Connecticut General Corporation.

The Current Project is a project under IT Data:

Cigna Corprate Warehouse(CCW):

The Business working Group developed a Proof of Concept for the CCW.

The main aim of this project is to load the data into the CCW from different source systems of clinical data related to lab and biometrics. The source systems providing the data to CCW Daily, weekly and Monthly of files and different databases. Lab and Biometrics results capture from different vendors of Cigna for customers covered under different Cigna health products. Also CCW send the data to their downstream clients.

Responsibilities:

Responsible for Business Analysis and Requirements Collection.

Followed Agile Methodology and daily involved in Scrum meetings

Parsed high-level design specification to simple ETL coding and mapping standards.

Involved in building the ETL architecture and Source to Target mapping to load data into Data warehouse.

Created mapping documents to outline data flow from sources to targets.

Extracted data from different sources like Oracle, Flat files and Sql server databases into staging area and then to the base tables(DWH).

Worked on Informatica Power Center tools- Designer, Repository Manager, Workflow Manager, and Workflow Monitor.

Used various transformations like Source Qualifier, Filter, Aggregator, Lookup, Sorter, Expression, Normalizer, Router, Sequence Generator, Update Strategy, Joiner, Stored Procedure, and Union to develop robust mappings in the Informatica Designer.

Designed and developed with Cigna standard, transformation logic and processes in Informatica for implementing business rules and standardization of source data from multiple source systems into the data warehouse.

Modified existing mappings for enhancements of new business requirements.

Created Unit Test documents for the mappings to test the data load.

Involved in data validation from Source to staging to Target.

Identified sources, targets, mappings and sessions bottlenecks and tuned them to improve performance.

Extensively involved in writing queries for testing the target data against source data.

Supported during QA/UAT/PROD deployments and bug fixes.

Worked closely with QA team to discuss the UAT defects and responsible for maintaining the

Test results on Mercury Quality Center for defect tracking.

Prepared and involved creating STM’s, TD and Job inventory as per the requirements.

Using ESP(Enterprise System Platform) scheduling tool to create jobs to run the informatica workflows.

Involved in code Reviews as per ETL/Informatica standards and best practices

Followed Informatica recommendations, methodologies and best practices.

Environment: Informatica Power center/Developer 9.6.1(HF2), SQL Server Management Studio, UNIX, Oracle 9i, Oracle 10G, SQL, PL/SQL, SQL developer, SQL SERVER, Teradata, ESP(Enterprise System Platform),Rally for project Management, Microsoft Visio Standard 2010.

Client: Specsavers, Los Angeles CA (11/13 – 06/15)

Role: Senior Informatica Developer

Specsavers Optical Group Ltd is the biggest optical retailer, providing a trusted eye care service, affordable glasses and contact lenses to a number of countries in Europe and across the globe having over 1,593 stores.

The Current Project is a project under Single View of Customer (Svoc) Data and Analytics:

Single View of Customer (Svoc):

The main aim of this project is to have a single view of customer data. Current system of Specsavers includes loading of customer data onto a database from every retail store system and also from web in a region (UK) on a daily basis. This process causes a lot of scope for customer data redundancy in database and also the maintenance cost when campaigns executed as the de duplication is not handled. Present system uses OEDQ (Oracle Enterprise Data Quality) tool for data cleansing and IIR (Informatica Identity Resolution) to do de dup check and load customer data into OCH (Oracle Customer Hub). Campaign related details will be loaded in Siebel CRM. OBAW tables will be loaded through Informatica mappings and DAC from OCH and Siebel. OBIEE will be used for generating reports.

Responsibilities:

Responsible for Business Analysis and Requirements Collection.

Worked on Informatica Power Center tools- Designer, Repository Manager, Workflow Manager, and Workflow Monitor.

Parsed high-level design specification to simple ETL coding and mapping standards.

Involved in building the ETL architecture and Source to Target mapping to load data into Data warehouse.

Created mapping documents to outline data flow from sources to targets.

Extracted data from different sources like Oracle, Flat files and other RDBMS databases into staging area and populated onto Data warehouse.

Used various transformations like Source Qualifier, Filter, Aggregator, Lookup, Sorter, Expression, Normalizer, Router, Sequence Generator, Update Strategy, Joiner, Stored Procedure, and Union to develop robust mappings in the Informatica Designer.

Developed mapping parameters and variables to support SQL override.

Created mapplets to use them in different mappings.

Developed Informatica mappings for TYPE 2 Slowly Changing Dimensions.

Used existing ETL standards to develop these mappings.

Modified existing mappings for enhancements of new business requirements.

Tuned the Informatica mappings for optimal load performance.

Used Debugger to test the mappings and fixed the bugs.

Created Unit Test documents for the mappings to test the data load.

Involved in data validation from Source to staging to Target.

Identified sources, targets, mappings and sessions bottlenecks and tuned them to improve performance.

Created SQL queries, for Validating the target data against source data.

Extensively involved in writing queries for testing the target data against source data.

Prepared migration document to move the mappings from development to testing and then to production repositories.

Supported during QA/UAT/PROD deployments and bug fixes.

Involved in code Reviews as per ETL/Informatica standards and best practices

Creating task, subject areas and Execution plans and run the Execution plans.

Running Informatica workflow through DAC and monitoring the data loads through DAC.

Followed Informatica recommendations, methodologies and best practices.

Environment: Informatica 9.1.0,Oracle 9i, Oracle 10G, SQL, PL/SQL, DAC, IIR, OEDQ, SIEBEL,OBIEE, Microsoft Visio Standard 2010.

Client: UBS Investment Banking, Kansas City, MO (06/12– 10/13)

Role: Informatica Developer

UBS investment banking division has a group operations division. Institutional Client & Instrument Data (ICD) is just one part of Group Operations. EOD pricing is part of investment banking – Instrument data which is solely responsible for maintaining and distributing Instrument data used within the investment bank.

The current project is a huge project Under Model Office Data and Informatics:

EOD Module:

EOD service provides end of day exchange traded prices across Equities, futures & options, Bonds, EOD sources Equity and ETD prices from external and internal vendors and subsequently distributes through distribution hub(Web services (request/response) including XML, JSON, text, Spice (pub/sub) – TIBCO EMS, File via RDDH(Reference Data Distribution Hub)) to the downstream clients for e.g. Atlas, NOVA, NEO etc

Responsibilities:

Analyze the business requirements and functional specifications.

Involved in the design phase of the Informatica mappings.

Review the Source to Target Mapping specifications and Transformation rules prepared by the Business Analyst.

Coordinate with the Business Analyst for questions related to the requirements, Mapping specifications and Transformation rules.

Used Informatica Power Center for extraction, transformation and load (ETL) of data in the data warehouse.

Extracted data from different sources like Oracle, Delimited and Fixed Width Flat files and load into ODS.

Extensively used Transformations like Router, Aggregator, Normalizer, Joiner, Expression and Lookup, Update strategy and Sequence generator and Stored Procedure for developing Informatica mappings.

Parameterized the mappings and increased the re-usability.

Implemented performance tuning logic on targets, sources, mappings, sessions to provide maximum efficiency and performance.

Extensively used Informatica debugger to figure out the problems in mapping. Also involved in troubleshooting existing ETL bugs.

Involved and writing Oracle stored procedures and functions for calling during the execution of Informatica mapping or as Pre or Post session execution.

Involved in designing the ETL testing strategies for functional, integration and system testing for Data warehouse implementation.

Created Unit Test documents for the mappings to test the data load.

Involved in data validation from Source to staging to Target.

Resolved Defects logged in the Mercury Quality Center during testing.

Identified sources, targets, mappings and sessions bottlenecks and tuned them to improve performance.

Support to L2 team during any failures and delays of ETL workflows and autosys jobs.

Created SQL Queries for validating the target data against source data.

Extensively involved in writing unit Test Cases, queries for testing the target data against source data.

Involved in the documentation to describe program development, logic, and coding, testing, changes, corrections, preparing the test plan, execution and test report related to testing.

Working with SVN(software versioning and revision control system) to update all the release related documents for every release with new release version number.

For Release process guide the L2 team for DR in UAT and Release in PROD to make the release success.

Followed Informatica recommendations, methodologies and best practices.

Environment: Informatica 8.6.1 Windows XP, Oracle 11G, SQL, PL/SQL, Toad, Autosys,Jira,Mercury Quality Center.

Client: U S BANK, Washington DC (06/10 – 04/12)

Role: Informatica Developer

U.S. Bank Power Track is the world’s largest freight payment solutions provider and is a clear industry leader with an unmatched set of offerings in the market place. As U.S. Bank Power Track continues to evolve as a world-class leader in the payment and supply chain marketplace, it will need new product offerings and identify new revenue streams based on its BI strategy (focused on customer expectations, product offerings and BI tool & database design).

The current project is a huge project Under Model Office Data and Informatics:

ODS U.S. Bank Power Track:

We will develop a new Data Warehouse with components that will include an Operation Data store (ODS)/Staging, an Enterprise Warehouse and Subject Specific Data Marts. We will also develop ETL Mappings in order to load data into the new DWH.

Responsibilities:

Involved in Analysis phase of the business requirement, Functional Specifications and design of the Informatica mappings.

Responsible for analyzing the Source to Target Mapping specifications and Transformation rules.

Interact with the business analyst for any questions related to the business requirements, mapping Specifications and Transformation Rules.

Extracted data from different sources like Oracle, Delimited and Fixed width Flat files and loaded into ODS.

Extensively used Transformations like Router, Aggregator, Normalizer, Joiner, Expression and Lookup, Update strategy and Sequence generator and Stored Procedure for developing Informatica mappings.

Developed complex mappings in Informatica to load the data from various sources.

Implemented performance tuning logic on targets, sources, mappings, sessions to provide maximum efficiency and performance.

Used Informatica Power Center Workflow manager to create sessions, workflows and batches to run with the logic embedded in the mappings.

Involved in designing the ETL testing strategies for functional, integration and system testing for Data warehouse implementation.

Preparation of LLD (Low level Design) documents, of HLD (High level Design) documents, UTP documents and Unit test cases.

Involved in data validation from Source to staging to Target.

Resolved Defects logged in the Mercury Quality Center during Testing.

Identified sources, targets, mappings and sessions bottlenecks and tuned them to improve performance.

Extensively involved in testing by writing some QA procedures, for testing the target data against source data.

Extensively involved writing queries for testing the target data against source data.

Involved in preparing the test plan, execution and test report related to testing.

Followed Informatica recommendations, methodologies and best practices.

Environment: Informatica 8.1.1, IBM DB2, UNIX, Windows XP, SQL Server, Mercury Quality Center.

Client: GE Corporate, Fairfield, CT (10/08 – 05/10)

Role: Informatica developer

Project: HR Informatica Support

Pre incremental load technique for HR3 data warehouse was truncation and loading of all data mart tables that were taking an approximate load time between six and seven hours. It was too long and unacceptable load time for the system, the objective or client requirement was to reduce the load time to two and a half hours, to achieve this target incremental loading technique was agreed and adopted.

Responsibilities:

Involved in the Design phase of the Informatica mappings.

Analyzed the Source to Target Mapping specifications and Transformation rules.

Extracted data from different sources like Oracle, Flat files and loaded into ODS.

Used various transformations of Informatica, such as Source Qualifier Transformation, Expression Transformation, Look-up transformation, Update Strategy transformation, Filter transformation, Router transformation, Joiner transformation etc for developing Informatica mappings.

Developed Informatica mappings for TYPE 2 Slowly Changing Dimensions.

Prepared various mappings to load the data into different stages like Landing, Staging and Target tables.

Creating sessions and work-flows for the Informatica mappings.

Creating various mapplets as part of mapping design.

Used Exception handling logic in all mappings to handle the null values or rejected rows.

Created Unit Test documents for the mappings to test the data load.

Prepared SQL Queries to validate the data in both source and target databases.

Resolved Defects logged in the Mercury Quality Center during Testing.

Involved in Performance tuning for sources, targets, mappings, sessions and server.

Identified sources, targets, mappings and sessions bottlenecks and tuned them to improve performance.

Extensively involved in testing by writing some QA procedures, for testing the target data against source data.

Closely worked with the reporting team to ensure that correct data is presented in the reports.

Writing UNIX shell scripts for execution of the Informatica sessions and work-flows.

Environment: Informatica 7.1.4,UNIX, Windows XP, Oracle 9i, SQL, PL/SQL.

Client: Swiss Re(Insurance) Zurich (09/06 – 09/08)

Role: BI Support & Development

Project: SAP CCC HR SUPPORT

SwissRe is world’s Second largest Reinsurance company based in Switzerland. SwissRe implemented the HCMS project to maintain the world wide employees and their activities. HR data gets loaded from five legacy systems(REBUS,ULTIPRO,ZURICH,PSASIA and MUNICH) using ETL tool Informatica 8.6 to SAP ECC system. BI system gets data from ECC system to feed the HR reports. The project has an Incident management tool Solution Manager where developers gets the tickets to resolve and update the progress in the tool. Enhancements come as Change Requests (CR) and it contains the business requirement and functional test cases would be given by the requestor. The developer has to prepare the proposed solution, technical specifications, estimations and test cases in the same document to get the business sign-off. Implementation would be started upon business approval. Enhanced objects will be transported to respective target systems(QA or Prod) upon business approval. The transport system is integrated with Solution Manager Tool.

Responsibilities:

Understanding the system requirements

Involved in Analysis and design of the system.

Involved in deployment of the application on the server.

Involved and worked on change requests(CR) as per the new business changes.

Involved and worked on enhanced objects will be transported to respective target systems

Testing the application (UT & IUT)

Environment: SAP BI, BEx Suite, Web Application Designer (WAD), Solution Manager.

EDUCATION:

Bachelor’s Degree in Instrumentation Applications, India

Master’s Degree in Computer Science, India

Contact this candidate