Manager Data

Akanksha Jain

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

Phone: 732-***-****

Professional Summary

Over 8 years of experience in Information Technology with a strong background in Database development and Data warehousing mostly as an ETL/ SQL Developer.

Good experience in designing, Implementation of data warehousing and Business Intelligence using

ETL tools like Informatica Power Center (designer, workflow manager, workflow monitor and repository manager).

Created mappings in mapping designer to load data from various sources using transformations like

Transaction Control, Lookup (Connected and Un-connected), Router, Filter, Expression, Aggregator,

Joiner and Update Strategy, SQL, Stored Procedure and more.

Excellent Knowledge on Slowly Changing Dimensions (SCD Type1, SCD Type 2, SCD Type 3), Change

Data Capture, Dimensional Data Modeling, Ralph Kimball Approach, Star/Snowflake Modeling, Data

Marts, OLAP and FACT and Dimensions tables, Physical and Logical data modeling.

Experience in developing Transformations, Mapplets and Mappings in Informatica Designer and creating tasks using Workflow Manager to move data from multiple sources to target.

Worked in different phases of the projects involving Requirements Gathering, Design, Development, deployment, testing and maintaining.

Experience in using SQL Server Integration Services (SSIS) to extract, Transform and Load data

Good knowledge on database architecture of OLTP and OLAP applications, Data Analysis.

experience in E-R modeling, developing Database Schemas like Star schema, Snowflake schema used in relational, dimensional and multidimensional modeling.

Worked with wide variety of sources like Relational Databases, Flat Files, Mainframes, XML files and scheduling tools like Control-M, Auto sys and Informatica Scheduler.

Strong experience working with different RDBMS like Oracle, Sybase, MS SQL Server 2005-08, SQL, PL/SQL, SQL* PLUS, SQL* Loader, TOAD, Stored Procedures, Triggers.

Very Strong skills and clear understanding of requisites and solutions to various issues in implementation throughout the Software Development life cycle (SDLC).

Hands on experience in PL/SQL (Stored Procedures, Functions, Packages, Triggers, Cursors, Indexes) and UNIX Shell scripting

Exposure in writing Simple and Complex SQLs, PL/SQL Functions and Procedures and creation of DB2Objects - Tables, Indexes, Views and Triggers.

Implemented Control M Skills such as Parallel Scheduling of Jobs for optimizing Process.

Expertise in doing Unit Testing, Integration Testing, System Testing and Data Validation for developed Informatica Mappings.

Proficient in integration of CRM data source such as Salesforce and SAP using Power Exchange.

Hands on experience working in LINUX, UNIX and Windows environments.

Experience in working Production Support and migrated the code from DEV to QA to Production.

Experience creating different documentations like RTM, BRD, HLD, TDD, Unit Test Cases, Deployment Plans and Production Turnover documents.

Excellent Verbal and Written Communication Skills. Have proven to be highly effective in interfacing

across business and technical groups, supporting in creating and analyzing business requirement documents, checking mappings and data movement and report generation as per BRD requirement.

Project Responsibilities

Oracle PL/SQL Developer

May 2016 to Present Equinox Fitness – New York, NY

Equinox fitness is a high end fitness company specializing in Fitness, Yoga, Spa and Personal Training as their main area of business focus.

One of the key reasons for them being a major player in the fitness business is their customer centric marketing approach which is facilitated by immense

data mining initiatives. To further improve on this, they choose to implement BI solution for all their data needs and reporting.

As part of Enterprise Data Warehouse initiative I am fully involved in creating the following DataMart

1. Series (PT / Pilates / Spa / Kids Club) Usage DataMart

2. Contract (Membership)

3. POS Sale

Responsibilities:

Writing technical specifications for the data mapping from the source to the target involving different transformations from normalized and flat file data sources to the data warehouse and then to the de-normalized star schema data mart for all the reporting needs.

Designing the source to target mappings that confirmed to the business rules for the application during the extract, transform and load process.

Extensively using joins and sub-queries for complex queries, which were involving multiple tables from different databases. Analyzing data and re-mapping fields based on business requirements.

Developed aggregate strategies to aggregate data, sorting and joining tables.

Develop data extraction, transformation and load programs for an enterprise Data Warehouse, developing and executing ETL test plans, and automating the ETL process through scheduling and exception-handling routines and development and maintenance of ETL mappings for an enterprise Data Warehouse environment.

Extensively worked on Source Analyzer, Warehouse Designer, Mapping Designer, and Mapplet Designer to Extract Sources, Transform Data and load into Target. Used Informatica Workflow manager to create Workflows and Sessions

Implemented different types of constraints on tables.

Familiar with building data quality solutions and implementing custom code in SSIS packages, identity mapping and De-duplicating, and SSIS knowledge.

Created PL/SQL stored procedures for data transformation, which had complex and reusable business logic.

Tuned the mappings both at the designer and workflow manager by updating the different tunable parameters wherever applicable.

Performance tuned the stored procedures and queries for efficient Report generation.

Environment: Informatica 9.6.1, Oracle 11g, SQL Server 2005-08, Windows 2008

ETL Developer XL insurance Group - Columbus, Ohio

January 2014 to April 2016

XL Insurance instills a Datawarehouse with multiple data marts in different domains of insurance, claims and coverages. It also maintains data of life and health insurance, investment and retirement savings. This application is based on Informatica Power Center, UNIX, Oracle RDBMS and Business Objects.

Responsibilities:

The team comprised of an outsourced Development team, on the day-to- day efforts across multiple projects including FSV credit card project.

Designed and coded new changes as requested by the business. Involved in data modeling and

database design of the new management database by applying Ralph Kimball methodology of dimensional modeling and using Erwin for data modeling

Interacting with various stakeholders like Business Analysts, Data Architect, Downstream users and

application team for gathering functional and technical requirements.

Developed mappings that perform Extraction, Transformation and load of source data to SQL Server

2008 using various power center transformations like Source Qualifier, Aggregator, Filter, Router,

Sequence Generator, look up, Joiner, Expression, Stored Procedure, SQL, update strategy to meet business logic.

Developed the PL/SQL programs and involved in optimize stored procedures and queries for faster retrieval and Server efficiency for SSIS.

Created scheduling jobs using Autosys Scheduling tool.

Preparing the test cases and performing unit testing.

Scheduled the workflows to pull data from the source databases at weekly intervals, to maintain most

current and consolidated data for P&C Legal management reporting

Communication with Product Owner and his team, requirements collection, Business Requirement Document(BRD) for analyzing source target mapping and history capturing fields.

Analyzing data from different sources for providers including Salesforce, Flat Files, Oracle Files.

Highly efficient SQL analysis of the source data for data quality checks and cleaning data before loading in target.

Environment: Informatica 9.1, Oracle 11g, SQL Server 2005, Unix-HP-UX,SSIS

ETL/SQL Developer Fidelity Investments- Denver, CO

March 2013 to December 2013

Fidelity Investments offers multiple services like common and preferred stocks, futures, ETFs, option trades, mutual funds. This application is based on Informatica Power Center, UNIX and Oracle RDBMS.

Responsibilities:

• Work closely with team of business users to gather business requirement and translate into technical specification.

• Extensively used Informatica Client tools - Source Analyzer, Mapping Designer, Informatica Repository Manager

and Informatica Workflow Manager.

• Developed Mapping by using various transformations to suit the business user requirements and business rules to

load and eliminate unrequired data from DB2.

• Conversion of Oracle Packages, store procedures to Informatica to reduce ETL load time.

• Used Workflows Manager to create the Sessions to transport the data to target warehouse.

• Manage and conducted System testing, Integration testing, Functional testing, UAT and Regression testing.

• Use the SQL query against database to test and validate Informatica mappings.

• Involved in Unit and Integration ETL testing of Informatica workflows.

• Prepared Project plans for Control-M implementations, Upgrade and various job flow migrations from application

teams.

• Responsible for manually start and monitor production jobs based on the business users requests.

• Scheduled the workflows to pull data from the source databases on daily basis, to maintain most current and

consolidated data.

• Worked on developing enhanced functionalities of already existing Informatica Mapping and Workflows.

• Worked on data integration tasks such as conceptualizing designs and code reviews. Supported component and

data architecture design. Conducted performance monitoring, product evaluation and profitability analysis.

• Identified performance issues in existing sources, targets and mappings by analyzing the data flow, evaluating

transformations and tuned accordingly for better performance.

Environment: Informatica Power Center 9.0, Oracle 11g, PL/SQL Developer, Flat files, Control M, UNIX shell scripting, Windows.

Informatica Developer P & C Package Solution - Tysons, VA

September 2011 to February 2013

Responsibilities:

Developed Mapping by using various transformations to suit the business user requirements and business rules to load

Worked on Source Analyzer, Warehouse Designer, Mapping Designer, and Mapplet Designer to Extract Sources, transform Data and load into Target. Used Informatica Workflow manager to create Workflows and Sessions

Responsible for administration and development with Informatica Power Exchange tool for CDC,

Involved in the designing of Star and Snow Flake Schemas, Physical and Logical models, ER diagrams, Data Flow Diagrams/Process Diagrams.

Involved in Performance Tuning and optimizing ETL process and coming up with the best design to

obtain superior performance.

Worked on creating UNIX shell scripts to automate the ETL process.

Writing PL/SQL procedures, functions, triggers and other database components.

Environment: Informatica Power Center 9.1, Oracle 10i, PL/SQL Developer, SQL*Plus, UNIX Shell

Script

Informatica Developer Cigna HealthCare -Carmel, IN

May 2008 to August 2011

Responsibilities:

Analyzed business requirements, technical specification, source repositories and physical data models for ETL mapping and process flow.

Created detailed Technical specifications for Data Warehouse and ETL processes.

Involved in design phase of logical and physical data model using Erwin 4.0.

Worked on Informatica - Source Analyzer, Warehouse Designer, Mapping Designer, Mapplet Designer and Transformation Developer.

Extracted/loaded data from/into diverse source/target systems like Oracle, XML and Flat Files.

Used most of the transformations such as the Source Qualifier, Expression, Aggregator, Filter, Connected and unconnected Lookups, Joiner, update strategy and stored procedure.

Developed mappings to load Fact and Dimension tables, SCD Type I and SCD Type II dimensions and Incremental loading and unit tested the mappings.

Creating new and enhancing the existing stored procedure SQL used for semantic views and load procedures for materialized views.

Addressed many performance issues on ETL jobs, semantic views, stored procedures, Reporting and Ad-hoc SQL.

Involved in creating different types of reports including OLAP, Drill Down and Summary in BO.

Worked in the Performance Tuning of SQL, ETL and other processes to optimize session performance.

Created Reusable transformations, Mapplets, Worklets using Transformation Developer, Mapplet Designer and Worklet Designer.

Working knowledge of DB2 Data sharing .

Monitor systems performance for bottlenecks and tune when appropriate using DB2.

Tuned Informatica mappings to improve the execution time by applying suitable Partitioning

mechanisms and tuning individual transformations inside the mapping.

Environment: Informatica Power Center 8.6, Oracle 9i, DB2, PL/SQL Developer, SQL*Plus, UNIX Shell Script

Technical Skills Summary

ETL Tools: Informatica Power Center 9.x, 8.x, SSIS

Databases: Oracle 10.x, Oracle 11.x MS SQL Server 2005, 2008,2012

Data Modeling: Erwin

Tools: Autosys

Languages: SQL, PL/SQL

Operating Systems: Windows, Linux, UNIX (Solaris 11.x), HP-UX

Utilities: Toad, SQL Developer, SQL Server Management Studio

Contact this candidate