NIKHIL

Contact no. 980-***-**** acgbmx@r.postjobfree.com

PROFESSIONAL SUMMARY:

Over 7 years of IT experience in System Analysis, Design, Development, Implementation and

Testing of Data Warehouse and Data Integration applications in domains like Financial, Banking,

Insurance, and Telecommunications.

Hands on experience with AGILE and Software Development Life Cycle (SDLC) in all aspects of Software

development.

Expert level skills in developing Strategies for Extraction, Transformation and Loading (ETL) using

Informatica Power Center 7x, 8x and 9x, Informatica Metadata Manager, Informatica Data Quality

(IDQ), Informatica IDE, MDM, Power Exchange, Data stage etc.

Profound knowledge in the principles of DW, designing and implementing Fact Tables,

Dimension Tables, E R modeling, Star schema and Snowflake Schema modeling using ERWIN.

Experience in writing BTEQ scripts and loading data into Teradata using FASTLOAD, MLOAD

and TPUMP utilities.

Expert in Unit Testing, System Integration Testing, Implementation, Maintenance and

Performance Tuning.

Expert in Data Warehousing techniques for Data Cleansing, Slowly Changing Dimension

phenomenon (SCD), surrogate key assignment and CDC (Change Data Capture).

Worked on creating reports using OBIEE, Business Objects and Cognos.

Experience with high end programming using PL/SQL, SQL, Unix Shell Scripting.

Expert in working on various operating systems like UNIX, LINUX and Windows.

Experienced in Multi Terabyte environments, solid experience in coding using SQL, SQL*plus, PL/SQL,

TOAD, stored procedures/functions, triggers and packages.

Extensive experience in extraction, transformation and loading of data directly from different heterogeneous

source systems like Relational Sources, Flat files, XML, Mainframe COBOL files, Web Services.

Highly motivated and adaptive with the ability to grasp things quickly.

Excellent team member with effective communication, interpersonal skills, ability to balance

multiple short term programming projects.

TECHNICAL EXPERTISE:

ETL Informatica PowerCenter 9.1/8.6/8.1/7.1, Metadata Manager, IDQ, IDE IBM

InfoSphere Data Stage 8.X/7.X.

Databases Oracle 9i /10g, ParAccel, SQL Server 2000/2005, DB2, Netezza.

Database Erwin 4.0/3.5, Star Schema, Snowflake schema, Fact and Dimensions Tables,

Modeling Physical and Logical Data Modeling, Dimensional Data Modeling

Programming SQL, SQL PLUS, PL/SQL,C, Shell Scripting, XML, HTML.

Database Tools Data Studio, WinSQL, TOAD, SQL Navigator, SQL*Loader, Test Director, Quality

Stage, ERWIN.

Operating Windows NT/9X/2000/XP, UNIX, LINUX

Systems

Other Tools WinSCP, DAC, Autosys, Tidal, HP Quality Center, MS Visio, MS Project, MS

office

Professional Experience:

Valspar

Minneapolis, MN

May 2014 – Till date

Informatica Developer

The Valspar Corporation is one of the largest global coatings manufacturers in the world, providing coatings and coating

intermediates to a wide variety of customers. The project involves integrating Retail transaction files from daily

transaction from distributed systems.

Responsibilities:

Created mappings and sessions to implement technical enhancements for data warehouse by extracting data from

Flat file sources.

Development of ETL jobs for error handling in ParAccel using Informatica 9.1.

Created jobs for straight loading of the data coming from Flat files and SFDC files into tables in ParAccel

Database.

Applied slowly changing dimensions like Type 1 and 2 effectively to handle the delta Loads.

Extensively used Informatica debugger to figure out the problems in mapping. Also involved in troubleshooting

existing ETL bugs.

Writing File watcher jobs to schedule the jobs and call the dependency jobs in ParAccel.

Scheduled ETL Jobs using Data Administration Console in Operational Data Store.

Involved in Requirement Analysis, Existing code Analysis and worked on Fact tables, Dimension

tables, History tables.

Performed Unit testing of several jobs and involved in deploying the code from development to

Production.

Verify program logic by overseeing the preparation of test data, testing and debugging of programs.

Scheduling of the jobs are done in DAC

Closely worked with the Micro Strategy (reporting) team to ensure that correct data is presented in the reports

Environment: Informatica Power Center 9.1, ParAccel Database, Oracle, SQL, SQL Developer, WinSQL, DAC,

WinSCP, UNIX.

Wells Fargo Bank

Minneapolis, MN

Oct 2013 – May 2014

Tech Lead/Informatica Developer

Wells Fargo Advisors (WFA) takes care of supporting Wells Fargo representatives in all branches in distributing to

customers across United States. The ODS (Operational Data Store) is used to acquire, prepare and deliver data which

was generated within the CORE on line applications. The COD database (Consolidated Originations Database) of OLTP

system is the primary data source for the ODS. ODS is divided into various schema’s like Raw, staging and static to

ensure the proper cleansing and transformation of data to various downstream systems.

Responsibilities:

Interact with business analysts and business teams to gather and understand the business requirements

to provide technical solutions.

Prepared technical design/specifications for data Extraction, Transformation and Loading.

Analyze complex business requirements to design or redesign computer platforms and applications

Verify program logic by overseeing the preparation of test data, testing and debugging of programs.

Oversee overall systems testing and migrations of platforms and applications to production.

Assure quality, security and compliance requirements are met for supported area and oversee creation

of or updates to and testing of the business continuation plan.

Significant and in depth Data analysis, data management and determining data behaviors.

Worked closely with Onsite Coordinator and attend Design Review and Code Review meetings.

Worked on Data Quality issues which ensure accurate reports in downstream jobs by identifying the

code issues and redesigning the code in Informatica Power Center Client.

Environment: Informatica Power Center 9.5/9.1, Autosys, UNIX, Solaris, Oracle, SQL, SQL Developer, DB2, IBM

Data Studio

Omni Engineering Services

Minneapolis, MN

Jan 2013 – Oct 2013

Sr. Data Integration Developer

The project involves integrating Retail transaction files from daily transaction from distributed systems. XML and flat

files are received and are loaded into the ODS system initially using the Informatica interface. The four transaction

Retail, Tender, Inventory and Batch data from all the system are stored in the ODS system. The data is then loaded from

ODS database into Oracle Data Warehouse.

Responsibilities:

Worked closely with the Business analyst to understand the various data sources and requirements.

Heavily involved in Requirement Analysis, ETL Design and Development for extracting from the

source systems and loading it into the Data mart, and creating documents according to project

standards.

Used Informatica Power Center Workflow manager to create sessions and workflows to run the logic

embedded in the mappings.

Worked in on site offshore model. Managed offshore team of 4 developers during testing phase to

register and resolve defects and change requests using HP quality center.

Created complex mappings which involved Slowly Changing Dimensions, implementation of Business

Logic and capturing the deleted records in the source systems

Performed Informatica administrative tasks such as stopping/starting Informatica Repository and

Server processes.

Provided Production Support for business users and documented problems and solutions for running

the workflow.

Used Workflow Monitor to monitor the progress of workflow and session and also used the workflow

log and session log for trouble shooting purposes.

Debug mappings to gain troubleshooting information about data and error conditions using Informatica

Debugger.

Understanding the specification and analyzed data according to client requirement.

Performed unit testing to test load time and documented the Unit Test Results and Unit Test Cases.

Involved in unit testing and preparing test cases and Involved in peer to peer reviews. Used HP Quality

Center for defect logging and resolution.

Environment: Informatica Power Center 9.5/9.1, XML, Oracle 11g, TOAD 8.6, SQL plus, Win XP, HP Quality Center,

Teradata, SQL assistant, SQL Server 2005/2008

BNY MELLON Corp, NY

Mar 2011 – Dec 2012

Sr. Informatica Developer

BNY Mellon Corp is a leading investment services, asset management and security solutions company. GIS (Global

Investment Services) decided to move the CNT project from PNC bank with the merger of Mellon Financial Corporation

and the Bank of New York Company Inc. ACR system will generate daily files with the mismatch in accounting and

custody systems in Cash Reconciliation Tool Project. Informatica ETL is responsible in loading the daily flat files to

Oracle DB. Data loaded will be used by, SAP Business Objects and IBM BPM Lombardi users to prepare, validate and

research the daily mismatches in the system.

Responsibilities

:

Interacted with business users to understand the business requirements

Translated business requirements into Data warehouse design.

Coordination with offshore team for development and support activities.

Extracted data from different source systems /flat files/parameter files to load the staging tables

and the master tables.

Worked extensively with front end team to meet the business requirements.

Developed various shell scripts for ETL process, to truncate the staging tables, to ftp the files from

local server to remote, file validation scripts, file archive scripts, mailing scripts.

Worked extensively in Informatica Designer, Workflow Manager, and Workflow Monitor.

Created stored procedures, packages, triggers, tables, views, synonyms, and test data in Oracle.

Creating Data Maps, Extracting (incremental) CDC data from Main frame sources, exporting Data

maps to Repository and Importing Mainframe source files on to shared folders.

Involved in the design phase of logical and Physical data model using ERWIN.

Extensively worked in the performance tuning of the programs, ETL Procedures and processes.

Developed PL/SQL procedures for processing business logic in the database.

Used SQL tools like TOAD to run SQL queries and validate the data in warehouse.

Created and scheduled jobs using Autosys.

Environment: Informatica Power Centre 9.1, Oracle 11g, DB2, MS SQL Server, IBM Mainframes, Flat files, TOAD,

Autosys, UNIX scripting, ERWIN.

ussell Cellular, Battlefield, MO

R Jan 2010 Feb’11

Informatica Developer

Russell Cellular (Retail) offers Verizon wireless phones, accessories, and services from 160 locations in 11 states. The

project involved integrating Retail transaction files from daily transaction from various states archiving system.

Responsibilities:

Analyzed the business systems, gathered requirements from the users and documented business

needs for decision support data.

Responsible for performance tuning at all levels of the Data warehouse.

Prepared technical design/specifications for data Extraction, Transformation and Loading.

Interpreted logical and physical data models for business users to determine common data

definitions and establish referential integrity of the system.

Created the Entity Relationship diagrams and maintained corresponding documentation for

corporate data dictionary with all attributes, table names and constraints.

Prepared technical documentation to map source to target.

Designed, Developed, Deployed and implemented ETL mappings using Informatica.

Developing PL/SQL Procedures, functions, packages to load the data from sources to targets and

utilized multi threading for the parallel execution of same procedure.

Testing Informatica mappings, PL/SQL programs and Tuning the mappings, PL/SQL programs.

Pushing the data from development database to PLE (Production like Environment) database.

Environment : Informatica Power Center 8.6/8.1, Toad 8.5.1.6, Teradata, Oracle 10g/9i, PL/SQL, Erwin 4.x, SQL

server 2005.

The Hartford Life Insurance Company, Hartford, CT

Feb ‘08 – Dec ‘09

Informatica Developer

The Strategic reporting platform created for Hartford Life, Various analyzes were made in order to improve the

performance of the process. This phase is for update, maintain and change current web application. This has been a

milestone project in the path of The Hartford group.

Responsibilities

:

Gather requirements from different source systems, analyze, design database objects, code,

automate, debug, test and implement.

Design and develop type 2 SCD mappings and workflows to load initial and daily Incremental

data.

Design of new architecture, new tables, changes to existing tables and Solution Design

Specifications(SDS) document preparation

Set up file monitoring scripts in the operating system to look for the source system file and trigger

the Input file validation job.

Load the Source system files to the Database staging area and to the Common Data Model

progressively.

Build/Code review for ETL components and PL/SQL components

Unit Test Plans, Unit test results, System Test Plan and System Test Results

Release management activities in SIT, QA and Production

System Testing

Defect tracking and immediate bug fixing

Preparing project documents KT doc, Operations Manual etc

Send success e mail to the business.

Automate the scripts for the daily process.

Warranty Support for the project.

Environment: Informatica 8.6.1, Oracle Warehouse Builder, Oracle 11g/10g, WINDOWS, TOAD, Oracle SQL

Developer, PL/SQL, Autosys, Sub Version, HP Quality Center, Remedy

Aug’06 – Dec’07 Data

HDFC Bank, Hyderabad,India

base Developer Intern

HDFC is engaged in commercial and retail banking and offers a comprehensive selection of financial products and

services including, lending, depository, trust, investment management, insurance services and other related financial

services tailored to the needs of its individual, business, institutional and governmental customers.

Responsibilities:

Involved in Business Analysis and Requirements Gathering.

Attended in house Training in Informatica and Dimensional Data Modeling.

Utilized SQL*Loader to load data from flat files in to the base tables.

Designed various Database objects like tables, Views, Sequences, Collections.

Used Informatica Power Center 6.1 to create data mappings.

Developed Analytical applications that can analyze large amounts of online and offline data.

Installation and setting up of oracle database dedicated server and multi threaded server.

Developed front end forms and Reports using Oracle Forms and Reports builder.

Environment: Oracle 9i, Informatica Power Center 6.2, SQL, TOAD, UNIX.

Education Qualifications

:

Bachelor’s degree in Electronics & Communication, J.N.T.University, India.

Contact this candidate