Renuka Kodati

adgvau@r.postjobfree.com

480-***-****

Professional Summary:

Extensive IT experience in IT/Software Industry Possessing Strong Knowledge in Data warehousing technology.

Extensive Work experience on various projects through all phases of Data Warehouse Development Life Cycle and Software Development Life Cycle including, requirement gathering, analysis, design, development, testing, performance tuning, and production support.

Worked with Informatica tool to develop jobs for extracting, cleaning, transforming and loading data into data warehouse.

Experience with informatica Intelligent cloud services (IICS).

Experience with salesforce standard and custom objects such as Account, Contact, Order, and Purchase Order.

Experience in creating packages and extracting, cleaning, transforming and loading data into database tables using SSIS tool.

Worked on writing expressions in SSRS and created parameterized, Drill through and Drill Down reports using SSRS.

Developed different reports in SSRS from data sources such as SQL Server Database.

Extensive experience in creation of ETL Mappings and Transformations using Informatica Power Center to move data from multiple sources into target area.

Experienced in creations transformations, and developing strategies for Extraction, Transformation and Loading (ETL) mechanism.

Worked with various source systems such as relational Sources, Flat files etc.

Experience on deployment activities and monitoring ETL jobs.

Well acquainted with Performance Tuning of Informatica Power Center Mappings

Experience in creation of sessions, batches using Informatica workflow manager to run with the logic in the mappings.

Good experience in developing reusable code for mapping, Mapplets and worklets.

Experience with Informatica scheduler, Autosys and control-M to schedule the jobs.

Experience with data cleansing issues and data profiling.

Used shell script while working with downstream and placing parameter files in shared location.

Extensive knowledge of Relational Database Management Systems and database performance tuning.

Worked in SCRUM and agile work environment, which included Daily Scrum meeting or Standups, Sprint Planning, and Sprint reviews, backlog refinements.

Co-ordinating with users and establishing good relations between users and development team.

Flexible, enthusiastic and project-oriented team player with solid communication and leadership skills to develop creative solution for challenging client needs.

Technical Skills:

Tools

Informatica Power Center 10.2.0/10.1.0/9.6.1/9.x, Informatica cloud services (ICS), SSIS

Operating Systems

Windows XP/2000/2003/7, Unix/Linux

IDE Tools

TOAD, SQL Server 2014 Management Studio, Salesforce Developer Console, Aginity workbench, SQL Navigator, AQT, SQL Developer, SQL*Plus

Database

SQL Server, Netezza, Oracle 10g/11i, DB2

Query Language

SQL, PL/SQL

CRM Application

Salesforce

BI Tools

SSRS 2012, OBIEE 11g

Education: Bachelor of Technology, Hi-Tech Engineering College, India

Professional Experience:

US BANK, MN Oct 18- Current

Project Description: Voice of Customer (VOC) which provide a better experience for customers. The US bank has decided to transition to a new insurance vendor who will be responsible for reviewing insurance coverage for all newly booked loans on different source systems. They will ensure proper coverage to meet the value of property. They will also assist our customers with any insurance questions including assistance through loss or damage to their home. Extracting Mortgage, email survey, and other information from various systems to data warehouse to improve the voice of customers.

Role: Sr. Informatica Developer.

Responsibilities:

Interacted with Business Analyst to understand the business requirements and implement the same into a functional Data warehouse design.

Involved in creating the design and technical specifications for the ETL process based on Functional specifications.

Extracted data from various sources like SQL Server, flat files, and Oracle.

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

Developed mappings using Informatica Power Center Designer to transform and load the data from source systems to target database.

Used various transformations like Source Qualifier, SQL transformation, unconnected and connected Lookup, Filter, Expression, Update Strategy, and Joiner to develop robust mappings in the Informatica Designer.

Extensively worked on Mapping Variables, Mapping Parameters, Workflow Variables and Session Parameters to extract only the additional data added during the period.

Responsible for monitoring all the sessions that are running, scheduled, completed and failed. Debugged the mapping of the failed session.

Responsible for performing Unit testing in Dev, IT, and UAT environments.

Migrated data from higher environments to lower environment for Unit testing using TOAD.

Involved in Version Control of Repository Objects using Check-in and Check-out.

Extensively worked in areas of code debugging and Performance Tuning of Informatica ETL mappings. Identify root cause and implement resolution for production processing issues.

Environment: PowerCenter Informatica 10.2.0(Power Center Designer, workflow manager, workflow monitor), SQL server, SQL Server 2014 Management Studio (SSMS), TOAD, UNIX, and Autosys.

Renewal by Andersen, MN Feb 18- Sept 18

Project Description: Renewal by Andersen provides a different, better window and door replacement experience for homeowners. This company process begins with a free in-home consultation to listen to customer needs, then

custom-make beautiful, energy-efficient composite windows and professionally install them with optimal performance.

Role: Informatica Developer.

Responsibilities:

Analyzed the business requirement document and prepared Source-Target Mapping documents to describe the relationship between source and target data.

Created source, target connections, and new mappings in Informatica Intelligent Cloud Services (IICS).

Worked with salesforce different custom objects such as purchase order, Resource skill, Labor, Order Financing and business adjustments.

Inserted various data into SalesForce.com using Informatica 10.1.0 with Sales Force Adapter.

Worked on updating Sales Force using external ID.

Production Support has been done to resolve the ongoing issues and troubleshoot the problems.

Performance tuning was done at the mapping level. Used relational SQL wherever possible to minimize the data transfer over the network.

Developed UNIX scripts to create file lists, transfer and archive source data files for backup purposes.

Experience in creating stored procedures and views to implement business logic.

Optimizing performance tuning at source, target, mapping and session level.

Developed and Documented Unit Test cases as part of the testing deliverables.

Performed data migrations for different Renewal by Andersen stores and provided QA support.

Responsible for migrating mappings/workflows from Development to Production environment.

Involved in Agile and Scrum meetings, which included Sprint Planning, Daily Scrums or Standups, and Sprint reviews.

Environment: PowerCenter Informatica 10.1.0, Informatica Intelligent Cloud Services (IICS), Salesforce Application, SQL server, WinSCP, SQL Server 2017 Management Studio.

Farm Bureau Financial Services, IA Sep 16- Feb 18

Project Description: Cost center conversion is a bank domain project. Employees can be given access to a company credit card where the nature of their job requires such use. Company credit cards may only be used for business expenses and may not be used for expenses of a personal nature. The general purpose of a statement of policy and procedure is to ensure that company credit cards are used for appropriate purposes and that adequate controls are established for day-to-day use. Companies require employee-submitted expense reports for business expense approval. For individual payment cards, employees are held responsible for the payment of their credit card. Employees submit an itemized expense report to their employers, who reimburse their employees for approved business expenses.

Role: Informatica Developer.

Responsibilities:

Involved in business requirement analysis and mapping specification documentation.

Developed new mappings using different transformations source qualifier, Filter, XML Generator and HTTP, Router, expression, aggregator transformation.

Involved in standup meetings and sprint planning in Agile environment.

Worked with shell script to perform different tasks such as merging flat files, run the workflow using pmcmd command, backing up files and removing files.

Used Parameter files to manage the relational connection in different environments.

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

Responsible to migrate repository objects to QA, STAGE and PROD by Import/export as XML files subsequently create the migration documents for QA, STAGE and PROD environment.

Worked with delimited and fixed width flat files.

Used service now to request Control-M Batch jobs to run the workflows, software request and Incidents.

Extensively used debugger to test data in different scenarios.

Worked on SSIS tool to load data to SQL Server database tables and generated reports using SSRS reporting tool.

Developed SSIS packages to transform/convert data and loaded it from heterogenous sources to different targets. Used flat files, Oracle databases as sources and SQL Server as target.

Worked on different SSIS transformations such as derived column, sort, pivot, aggregate, SQL, lookup, data conversion, conditional split, and Merge tasks etc.

Performed Unit testing and took the screenshots of it once development is completed.

Created parametrized Reports in SQL server Data Tools and Compared those reports with Prod Impromptu Reports as they were not using Impromptu Reports in future, so we have developed same logic in SSRS from Impromptu.

Good experience in developing and designing reports through SSRS and Excel.

Environment: PowerCenter Informatica 10.1/9.6.1, SSIS, SSRS, SQL server, DB2, FileZilla 3.9.0.6, SQL Server 2014 Management Studio (SSMS), SQL server Data Tools 2012, PuTTY, Control-M Workload Automation 9.0.00, Excel2013.

UHG, India Sept 14-Apr 16

Project Description: ORCHARD is a health domain project. The purpose of this project is to migrate the Current

Optum Rx Data Warehouse from DB2 database environment to a Netezza appliance, to consolidate existing data

marts to reduce redundancy and to expose the current source raw data in the Data Fabric.

Role: ETL developer

Responsibilities:

Extensively worked in data Extraction, Transformation and Loading from source to target system using power center of Informatica.

Importing Source/Target tables from the respective databases and created reusable transformations and mappings using Designer Tool set of Informatica.

Closely worked with ETL team and supervised various Informatica Mappings using Mapping Designer that load the data from various sources, using different transformations like Source Qualifier, Expression, Lookup (Connected and Unconnected), Aggregator, Update Strategy, Joiner, Filter, and Sorter transformations.

Used Workflow Manager for Creating, Validating, Testing and running the sequential, parallel, and initial and Incremental Load.

Worked on developing many Informatica Objects (Workflows, Sessions, Mappings, and Mapplets with various transformations for performing the full and incremental loading.

Experience in using Debugger within the Mapping Designer to test the dataflow between source and target and to troubleshoot the invalid mappings.

Requirements analysis and preparing Design document (mapping specification).

Migrating all the required objects into higher environments using import and export options.

Have taken the Ownership of Master SQL scripts.

Used UNIX commands while working with placing param files in UNIX environments.

Experience working in SCRUM and an Agile work environment.

Taken the responsibility of Migrating the workflows and instant fixes in SIT environment.

Environment: Power Center Informatica 9.0.1, Oracle 11g, SQL, OBIA, UNIX, SQL Developer 1.5, Windows Server 2003.

Dell, India May 12- Sept 14

Project Description: AVEVA has been the world’s leading engineering software provider to the plant, power and marine industries for over 45 years. AVEVA’s mission is to enable the creation and management of complex digital assets, allowing their customers to work globally with less risk, shorter lead times and greater business efficiency throughout the lifecycle of their physical assets. This company has number of

Employees working for production, maintenance, marketing and IT, to come up with a unified analytic platform for human resource management they have come up with this HR Analytics implementation.

Role: Jr. ETL Developer.

Responsibilities:

Analyzed the sources, transformed the data, mapped the data and loaded the data into targets using Power Center Designer.

Worked with various transformations like Source Qualifier, Expression, Filter, Aggregator, Lookup, Update Strategy, Stored Procedure, Sequence generator, joiner transformations. Mocking the test data.

Developed ETL mappings to load data into database tables using various transformations.

Developed sessions and workflows for the mappings.

Involved in testing the ETL jobs and coding the mappings on the change requests.

Extensively worked with Joiner Transformation to join the heterogeneous sources.

Worked with aggregate functions like Avg, Min, Max, First, Last in the Aggregator Transformation.

Extensively worked with Incremental Loading using Parameter Files, Mapping Variables, and Mapping Parameters.

Worked with Source Qualifier Transformation to join the homogeneous sources.

Worked with re-usable objects like Re-Usable Transformation, Mapplets and Worklets.

Created Stored Procedures, functions, triggers and views for data analysis.

Created DDL statements for the tables and SQL Statement to fire on the Database.

Involved in creating Shell Scripts to automate Pre-Session and Post-Session Processes.

Environment: Oracle 8i, PL/SQL, OBIA, MS SQL, Oracle, Informatica Power Center 9.0.1, Excel, SQL Developer.

Contact this candidate