Seeking position as ETL developer

Location:

Charlotte, NC

Posted:

March 27, 2016

Contact this candidate

Resume:

Neha Gupta

**** ***** **** ** *** ****, Charlotte NC 28262

u Mobile: +1-980-333-8540u ************@*****.***

Career Summary

Dynamic, result driven and focused IT professional with 5.3 years of significant working experience in various domains like Retail and Financial. Holding degree of Masters of Science in Information Technology with advanced data and knowledge discovery as concentration. Proficient and strong knowledge of ETL (extract transform and load) implementations/tools like Informatica and data warehousing/modelling. Excellent in Oracle 10g/11g, SQL SERVER 2008, PL/SQL and Teradata databases. Worked as a Technology Analyst in a leading Bank for a year now.

A proactive, open and honest communicator thriving on fresh challenges. Understanding requirements and providing customized, viable and cost effective solutions in liaison with cross-functional activities always keeping in mind the end user experience.

Facilitate a team approach to achieve organizational objectives. Received various awards and appreciation from clients, seniors and colleagues for significant contribution done for the growth of organization.

Career Objective

Ability to exceed organizational performance with adapt analytical and problem solving skills. I seek for Data/Business Analyst/Database Consultant/ETL Lead position in Data warehousing and Business Intelligence domain of IT Arena.

Core Competencies

Requirement Gathering and Analysis

Software Development

Product Designing

Product Development

Analytical Skills

Troubleshooting

Multitasking Skills

Communication skills

Career Path

Technology Analyst

Infosys Ltd (US) - Worked in Bank of America as a contractor from Infosys.

Infosys Ltd (India)

Senior Systems Engineer

Infosys Ltd (India)

-Worked in Retail Domain with Procter and Gamble

Feb 2015 – Feb 2016

Nov 2012 – Jan 2013

Aug 2010 – Oct 2012

Software Engineer

Infosys Ltd(India)

-Worked in Retail Domain with Procter and Gamble.

Nov 2008 – Jul 2010

Key Responsibilities

Experience of working in Waterfall and Prototype Models.

Lead teams both at onsite and offshore. Responsibility of handling and guiding the team throughout the SDLC.

Ensuring of implementation of all SDLC processes in the project defined by organization or client.

Interacting & coordinating with project management team/Business/Client for gathering requirements, understanding the requirement and creating technical design for them.

Responsible for the activities associated with core designing and product development.

End to End analysis of the future data warehouse, modelling, ETL implementation and upstream/downstream impacts.

Conducting design, unit test case and code reviews sessions.

Have worked on all phases of a product like development from scratch, production warranty support and change requests.

Associated with designing and improvisation of the key features.

Shared Domain and Process Knowledge with the team.

Projects

Projects worked at Onsite (USA)

Project Title / Name

Wholesale Credit Provisioning – Flood Remediation

Project Duration

January 2016 – February 2016

Role

Technology Analyst

Software / Tools / Technology Used

Microsoft Sql Server Management Studio 2008, Client tools like Toad for Sql

Server, Toad for Oracle, SSIS.

Project Description

This project aims at creating an automated flood report/dashboard after consolidating all the inputs/feedback

From different SOR’s without any manual intervention.

Responsibilities

Understanding and analyzing the different SOR’s query and then transforming them into a more performance

– tuned queries.

Designing the approach to load the data from SOR’s to our system depending upon the data availability.

Maintaining the history data using Triggers.

Involved in discussions with business and other impacted teams to have an overall understanding of the various components/keys impacting the data.

Designing the data Model and data lineage.

Build and reviewed the SQL Server Integration Services Packages.

Project Title / Name

Wholesale Credit Provisioning – W to WCP Conversion and Comparison Utility Tool

Project Duration

September 2015 – December 2015

Role

Technology Analyst

Software / Tools / Technology Used

Informatica 8.6, Oracle 11g, Teradata Tools and Utilities, Autosys Job scheduling tool, Unix Scripting.

Project Description

This project is developed to address the data reconciliation between W and Wholesale Credit Provisioning (WCP) systems for two System of Records - LOANIQ and ELMS.

Responsibilities

Analysis of existing W mapping Specifications and based on that designing the overall architecture for W to WCP module.

Involved in discussions with Bank stakeholders and taking full responsibility of coordinating with other teams for providing source files.

Build and reviewed the Informatica mappings and database design.

Developed a comparison tool to compare source files.

Project Title / Name

Vendor Data Warehouse(VDW) project in financial domain

Project Duration

February 2015 – August 2015

Role

Technology Analyst

Software / Tools / Technology Used

Informatica 8.5/8.6,Unix scripting, Oracle 11g, Autosys Job scheduling tool, Aginity workbench for Netezza, Toad for Oracle.

Project Description

The objective of project is to address the gap specific to an integrated Vendor Data Domain Model for the standardization, publication, and distribution of Vendor Admin (VA) data for Vendor, Risk, and Contract information groups along with associated reference data which enable VA data consumers to source critical business information with assurance for data quality and data availability.

Responsibilities

Leading the Data modelling approach

Responsible for handling and coordinating with the ETL development team (onsite and offshore) throughout the project life cycle, analyzing business requirements.

Responsible for implementing and following the different SDLC processes as defined by organization.

Creating knowledge management artifacts related to application and helping in boarding of new resources on to the project.

It included supporting production issues/break fixes in between and delivering the product within the timelines.

Created and reviewed the source-target mappings (STT) and other deign documents like HLD and LLD

Build ETL code using informatica mappings and Implemented logic for error handling records as per business logic

Worked in performance tuning of the existing code through informatica.

Projects Worked at Offshore (India)

Project Title / Name MEDIA DW REVAMP in retail domain for Procter and Gamble (P&G)

Project Duration November 2011 – May 2012

Role Senior systems engineer

Software/Tools/Technology Used Unix Shell scripting, Oracle 10g, Control-M scheduling tool,

Informatica 8.5/8.6, PLSQL

Project description

It’s a high priority project aimed at gathering information of the different modes of media and then processing them to derive certain business measures.

Responsibilities

Prepared system and process design documents.

Developed Data modeling and data flow diagrams.

Development of ETL tracks within the project and testing.

Requirement elicitation via constant discussion with client and other stake holders.

Project Title / Name RDS V2 and Orphan Processing in retail domain for Procter and Gamble

Project Duration October 2010 – October 2011

Role Senior Systems engineer

Software/Tools/Technology Used Unix Shell scripting, Oracle 10g, Control-M scheduling tool,

Informatica 8.5/8.6

Project description

It’s a legacy application for the whole P&G account. Here, the data was extracted from the different data marts and transformed as per the business requirements.

Responsibilities

Involved in all the SDLC processes from requirements analysis to production support.

Designed and Developed ETL solution to extract data from various data marts and perform transformations as per business rules.

Migrated objects across different environments through XML exports.

Created high and low level design documents, Unit test planning and Code migration documents.

Project Title / Name Distributed Inventory and Case Fill Rate(DICFR) in retail domain for Procter

and Gamble

Project Duration November 2008 – September 2010

Role Software Engineer and Senior Systems engineer

Software/Tools/Technology Used Unix Shell scripting, Oracle 10g, Control-M scheduling tool,

Informatica 8.5/8.6, Load- Runner testing tool

Project description

This was a development project that aimed at creating a DW and ETL solution for Inventory management application. It was an end- to end solution.

Responsibilities

Involved in solution architecture and the entire SDLC processes.

Developed design documents and test scripts.

Involved in creating schema objects and UNIX scripts.

Learned and implemented Control M job scheduling.

Production support and maintenance.

Single point of contact for offshore activities with onsite.

Education

Master of Science in Information Technology GPA – 4.0 Aug 2013 – Dec 2014

University of North Carolina at Charlotte, NC

Bachelor Of Technology in Information Technology HONORS Division

Graphic Era Institute of Technology, Dehradun, India

June 2004 – July 2008

Technical Skills