Data Customer Service

Vinisha Vangapally

ETL Informatica Developer

Email:************@*****.***

Phone: 832-***-****

Professional Summary:

* ***** ** ** ********** in development of various projects using Data Warehousing tool Informatica Power Center and Informatica MDM (Master Data Management) and Databases like Oracle, Teradata and SQL Server.

Experience in various phases of project lifecycle such as Planning, Requirement Analysis, Design, Development, Testing and Deployment.

Good experience in working Informatica Client Tools Informatica Power Center Repository Manager, Informatica Power Center Designer, Informatica Workflow Manager and Informatica Workflow Monitor.

Experience in developing mappings using different transformations like expression, filter, router, joiner, aggregator, sorter, lookup, update strategy, xml generator, xml parser, web service consumer.

Worked on design and implementation of Slowly Changing Dimensions (SCD) type1 and type2.

Good experience in extracting data from different database sources like SQL Server, Oracle, Teradata and also with flat and csv files(excel).

Standardized Parameter Files to define session parameters such as database connection for sources and targets and also for file path.

Experience in working with tools like TOAD, SQL Server Management studio and SQL plus for development and customization.

Experienced in loading data, troubleshooting, Debugging mappings, performance tuning of Informatica (Sources, Targets, Mappings and Sessions) and fine-tuned transformations to make them more efficient in terms of session performance.

Applied the concept of Change Data Capture (CDC) and imported the source from databases using Informatica Power Center.

Experience in doing Unit Testing, Integration Testing, System Testing and Data Validation for Developed Informatica Mappings.

Created shell scripts for zipping, moving and cleaning the files.

Experience and working knowledge of Informatica MDM (Master Data Management).

Worked as techno functional analyst for different types of Connectors (web services, database, message connectors and files), Event Management and Workflows. Well versed with business process flows.

Experience in working with web services and API's using SOAP UI/ REST.

Worked on Enterprise applications using SOAP webservices supporting XML.

Created message queues and sent messages to Active MQ, IBM MQ and TIBCO platforms.

Worked on XSLT 1.0 & 2.0 for creating XML from flat files (txt, csv, delimiter).

Excellent Analytical, Communication skills, working in a team and ability to communicate effectively at all levels of the development process.

Responsible for developing the code by following Informatica best practices.

Technical Skills:

Data Warehousing ETL & Business Intelligence

Informatica Power Center 9.x, 9.5.1, 8.6.1, ION (Intelligent Open Network), MDM, FACT & Dimensions tables, Physical & logical data modeling

RDBMS

Teradata 13.0, Oracle 11g, MS SQL Server 2008

Database Languages

SQL, PL/SQL, SQL Plus, TOAD

Programming Languages

C, C++, UNIX Shell Scripting

Office Package

MS Office-97, 2000, 2003and 2007

Environment

HP-UNIX, Windows2000/NT, Windows XP/Vista/7

Scheduling Tools

Informatica Scheduler, TWS Maestro, Autosys

Bug Tracking Systems

Jira, HP Quality Center

Projects:

Hewlett Packard, Houston, TX Mar 2016 to Till Date

Informatica Developer

Project Description: The Aurora program is a comprehensive program that encompasses many aspects of HPI Contra and Channel Data Management (CCDM) business capability. One of the key program elements is the replacement of existing CCDM systems with the SaaS offerings provided by Zyme Solutions.

Responsibilities:

Worked on developing mappings for loading data from flat files into Oracle tables using Informatica Power Center 9.5.1.

Worked on transformation Source Qualifier, Expression, Router, Filter and Update Strategy.

Created ETL design document with the help of data requirements specification (DRS) vs database tables.

Used debugger in identifying bugs in existing mappings by analyzing data flow and evaluating transformations.

Performed migration requests from lower environments to higher environments of ETL code.

Created a list of the inconsistencies in the data load on the source side so as to review and correct the issues.

Extensively used SQL developer utility for executing SQL scripts and worked on SQL for creating database tables.

Followed Informatica recommendations, methodologies and best practices.

Environment: Informatica Power Center 9.5.1, Oracle, SQL Developer, Flat Files, UNIX, Tidal Scheduler.

Infor Global Solutions, Hyderabad, India Sep 2013 to Feb 2016

ETL InformaticaDeveloper

Project Description: The main objective of the project is to help the decision making team of the organization, to monitor/improve the sales and to explore avenues for new business opportunities. This project includes developing Data warehouse from different data feeds and other operational data sources.Built a central Database where data comes from different sources like oracle, SQL server and flat files. Actively involved as an Analyst for preparing design documents and interacted with the data modelers to understand the data model and design the ETL logic.

Responsibilities:

Involved in all phases of SDLC from requirement, design, development, testing and support for production environment.

Gather requirements from business and end users for project that include reports, extract file and data update and built Business Requirement Document.

Collaborate with analysts to ensure projects are developed as per user requirements

Good understanding of data and relational databases and technical data design

Extracted data from different sources like Oracle, Teradata, Flat files and loaded into centralized oracle database.

Developed mappings using Mapping Designer and worked with Aggregator, Lookup (connected and unconnected), Filter, Router, Joiner, Source Qualifier, Expression, Stored Procedure, XML Generator, Sorter and Sequence Generator transformations.

Worked on Master Data Management (MDM), Hub Development, extract, transform, cleansing, loading the data onto the staging and base object tables.

Develops test plans to verify logic of new or modified programs.

Provide technical support and respond to error reports, problems or questions.

Environment: Informatica Power Center 9.6.1,Informatica MDM, TOAD, Oracle, Teradata, UNIX, HEAT, TWS Scheduling (Maestro).

ETL Informatica Consultant April 2012 to Aug 2013

Project Description: The scope of this TRACS project is to build the data mart for the customer service department and for the claims division & to integrate all the information in to the data warehouse for generating the reports. The data mart provides feed for extensive reporting. It enables an insight in to the current and future customer service and claims business decisions based on the reports generated from this data warehouse.

Responsibilities:

•Involved in requirements gathering, designing, development, unit testing.

•Involved in developing source to target mapping document, technical design document and business relationship document.

•Developed mappings for loading data from source objects to txt files, target tables and created sessions, workflows for the mappings based on the business rules and standards.

•Developed mappings using transformations connected lookup, unconnected lookup, aggregator, router, filter, expression.

•Developed data Mappings between source systems and warehouse components.

•Created Pre/Post Session/SQL commands in sessions and mappings on the target instance.

•Designed and developed Informatica workflows, mappings, mapplets, transformations and DDL scripts to create database object.

•Good communication skill to work with client, business users and team members.

•Strong problem solving skills and able to work independently with minimum supervision.

Environment: Informatica 9.x, UNIX, Oracle 11g, Flat files, SQL server, SQL Developer

Database/Informatica Developer May 2010 to Mar 2012

Project Description: The objective of the project is to create a single integrated system that will support standard home loans, auto loans reporting, self-service analytics and ad-hoc analysis. As a Data warehouse consultant loaded different data sources into staging area, leveraging the database platform.

Responsibilities:

Involved in designing technical specifications for new applications.

Used Informatica Designer to create mappings using different transformations to move data to a source tables to target tables.

Developed mappings in Informatica to load the data from various sources into the Data Warehouse, using different transformations like Source Qualifier, Expression, Lookup, aggregate, Update Strategy, and Joiner.

Worked on mapping parameters, mapping variables and parameter files.

Monitor the workflow using workflow monitor and also used to stop, Abort and cancel the sessions while running.

Involved in the production support of the Informatica applications

Experienced in working with tools like TOAD, SQL Server Management studio and SQL plus for development and customization.

Strong verbal, written and interpersonal skills with ability to communicate effectively across organizational lines and with virtual team members.

Environment: Informatica Power Center 8.0 Work Flow Manager/Monitor, Oracle 10g/9i, SQL, PL/SQL, SQL Loader, UNIX Shell Scripting, Win 2000/NT.

Education Qualification:

Bachelor of Technology (J.N.T.U Hyderabad)

Contact this candidate