Data Manager

Sushmala S R

**** ********** **** ******, # ***, Morrisville, NC-27560 201-***-**** ***.********@*****.*** LinkedIn URL

Summary of Experience:

Experienced in ETL/ Informatica Power Center 10.1/9.5/9.1/8.6, Data warehousing, file transfer with emphasis on Business Requirements Analysis, Application Design, Development, testing and implementation.

Designing and developing Strategies for Extraction, Transformation and Loading (ETL) mechanism using Informatica PowerCenter client tools Designer, Repository Manager, Workflow Manager and Workflow Monitor.

Experienced in Extracting and Loading data from data sources such as Flat files, Oracle, XML, Teradata. Experienced in writing complex queries on various database systems like Oracle 11g/10g/9i/8i, MS Access 7.0/97/2000, Teradata, My SQL, DB2 8.0.

Experience in complete life cycle (SDLC) of Design, Maintenance, Development, Implementation and Enterprise Data Warehouse (EDW).

Experienced in tools SAP Business Objects 4.x, Tableau 9.0, Spotfire 7.11, Informatica Power Analyzer.

Designed Dimension Data models, Star schema/ Snowflake schema, Facts and Dimension tables. Worked extensively with slowly changing dimensions Type1, Type2, Type3.

Experience on Master Data Management - MDM Data Integration concepts in large scale implementation environments. Proficiency in developing complex mappings using Informatica and Change data capture (CDC), Data Cleansing.

Experienced in creating and using Stored Procedures, Functions, Triggers, Views and packages in Different databases.

Experience with Informatica Installation, Configuration, Upgrade tasks and Performance Tuning.

Hand-on experience in failure investigation, creating Session logs and workflow logs for error tracking, creating bug fix plan, coordinating with all the teams involved, communicating with the client management for all the Production related issues.

Working with different Stakeholders to manage scope, requirements, Joint Design sessions, Testing and Deployment.

Skills:

ETL tools

Informatica Power Center 10.1/9.5/9.1/8.6, Informatica PowerAnalyzer, Informatica PowerExchange.

Databases

Oracle 11g/10g/9i/8i, MS Access 7.0/97/2000, Teradata, My SQL, DB2 8.0.

Reporting Tools

SAP Business Objects 4.x, Tableau 9.0, Spotfire 7.11.

Data Sources

Flat files, Oracle, XML, Teradata.

Programming Languages

SQL, PL/SQL, Python, HTML, JAVA, C.

Methodology

Agile/Scrum, Waterfall.

Operating Systems

Windows, Unix, Mac OS

Tools

MS Office, MS Project, MS Excel, MS Power Point, MS Word.

Work Experience:

Capgemini India Pvt Ltd (Jan 2015 - Dec 2016)

Senior ETL Developer

Extensively developed various mappings incorporated business logic for WARNER BROS (WB) project, which performed Extraction, Transformation and Loading of source data into OLAP schema.

Created Several Informatica Mappings to populate the data into dimensions and fact tables. Worked on MDM Hub configurations - Data modeling & Mappings, Data validation, Match and Merge rules, Hierarchy Manager, customizing/configuring Informatica Data Director (IDD).

Involved in the development of Informatica mappings and Mapplets and tuned them for optimum performance, Dependencies and Batch Design.

Designed and developed complex ETL mappings making use of transformations like Source Qualifier, Joiner, Update Strategy, Connected Lookup and unconnected Lookup, Rank, Expression, Router, Filter, Aggregator and Sequence Generator transformations.

Understand the business rules completely based on High Level document specifications and implements the data transformation methodologies for PROCTER &GAMBLE (P&G) project.

Developed ETL packages with different data sources (SQL Server, Flat Files, Excel source files, XML files etc) and loaded the data into target tables by performing different kinds of transformations using SQL Server Integration Services (SSIS).

Star minds Solutions Pvt. Ltd (Aug 2014 - Jan2015)

ETL Developer

Using Informatica Power Center for ETL jobs, loading the data from heterogeneous source systems to target database.

Designing and developing several complex mappings using various transformations like Source Qualifier, Aggregator, Router, Joiner, Union, Expression, Lookup (Connected & unconnected), Filter, Update Strategy, Stored Procedure, Sequence Generator and used reusable transformations as well as mapplets.

Creating and loading the dimensional tables, views in the databases which are linked through the SAP databases, which makes the informatica easy to read and write the data into SAP databases via relational databases.

Support and bug fix for ETL (Extract, Transformation and Loading) mappings to extract the data from multiple source systems like Oracle and Flat files and loaded into Oracle.

Achievements and Rewards:

Awarded "Feather in the Crown" award for my work in P&G project at Capgemini India Pvt. Ltd.

Winner of “ETL Tech-Competition” at Capgemini India Pvt Ltd.

Received appreciation E-mails from clients, congratulating the quality of work done.

Education:

University of Bridgeport, School of Engineering (3.8/4.0) Bridgeport, CT

Master of Science in Technology Management (Concentration: Big data) Dec 2018

T. John Institute of Technology, Institute of Technology Karnataka, India

Bachelor of Engineering, major in Electronics and Communication July 2014

Contact this candidate