Data Project

RESUME

Audi ****.*******@*****.*** Ph. +1-513-***-****

Summary of Experience:

Around 8+ years of profound IT experience in Design, Development and Implementation of Relational Database and Data Warehousing Systems using IBM DataStage (v8.1, 8.5, 8.7, 9.1and Ascential DataStage v7.5) Client-Server environment. Proficient in all stages of SDLC (Software Development Life Cycle).

Sound knowledge on Banking and Telecom domain.

Sound knowledge in Relational Database Modeling (RDBMS), Dimensional Modeling (DMS) and DW concepts like – Data marts, OLTP, OLAP, Fact tables, Dimension tables, Star schema and Snow Flake Schema modeling.

Bigdata and sales force integration using IBM Infosphere Datastage 11.5.2.

Coordinated with cross functional team like Solution Architecture, Business Analyst, QA Testing, Performance Tuning and Operations team to ensure the timely and successful delivery of projects.

Worked as data modeler for ETL solutions and Coordinated with cross functional team like Solution Architecture, Business Analyst, QA Testing, Performance Tuning and Operations team to ensure the timely and successful delivery of projects.

Extensive experience in Extraction, Transformation and Loading (ETL) data from various sources such as Oracle, MS-SQL Server, DB2 and Flat files.

Worked on DataStage client tools like DataStage Designer, DataStage Director and DataStage Administrator.

Created Technical Design document as per business requirements by regular interactions with business team, Business Analysts and concerns teams.

Involved in all the project stages of various IT project’s such as Analysis, Design and testing, deployment, production support, Unit Testing, UAT, production roll out and enhancements.

Experienced in scheduling sequence, parallel and server jobs using DataStage Director, UNIX scripts and scheduling tools.

Expertise in Designing and developing Parallel and Server jobs in DS Designer using all the types of available stages.

Skilled in data mapping for the SCD1, SCD2 (Flagging, Time stamping and version) SCD3, Facts and Aggregate Facts.

Strong experience creation of SSIS Packages and migrating from DEV-UAT and UAT – Admins.

Outstanding skills in Unit testing and Data validation, end-to-end testing.

Good experience in writing SQL queries to perform ETL operations.

Outstanding skills in data format using SQL queries and load them into targets.

Extensive experience in creating jobs, data mapping, data extraction, transformation and loading from heterogeneous sources like Oracle DB2/Teradata/SQL Server and Flat files into DataStage.

Creating local and shared containers to facilitate ease and reuse of jobs.

Loading bulk data, troubleshooting datastage jobs addressing production issues like performance tuning and enhancement.

Ability to develop Job Sequences with restart capability for the designed jobs using Job Activity, Exec Command, E-Mail Notification Activities and Triggers.

Involved in performance tuning of DataStage ETL jobs.

Good in writing PL/SQL store procedures.

Ability to work effectively and efficiently in a team and individually with professional conduct and excellent interpersonal and technical communication skill set.

Adaptive to new and challenging technological environments with quick learning abilities.

Technical Skills:

Tools & Utilities

IBM Infosphere Datastage (11.5,9.1 & 8X & 7X), SSIS, Informatica 10.1.0, Bigdata Concepts (HDFS, Hive, Sqoop), Salesforce.

RDBMS

DB211.1, SQL Server 2016, Oracle 18c

Languages

SQL, PL SQL, Unix Shell

Tools & Utilities

Microsoft Visio, HP Quality Center, TOAD, AQT, FileZilla, WinSCP, Harvest (Version Control), Putty

Operating Systems

Unix, Linux and Windows

Education:

Degree

University

MCA

Madras University, Chennai

Professional Summary:

PROJECT #1

Project Title

LOS (Loan Originating System)

Client

53rd Bank Madisonville, Kingsley Dr Cincinnati OH.

Role

ETL Consultant

Duration

Aug 2016 – Till Date

Environment

IBM Infosphere DataStage 11.5 & 9.1, Windows XP, DB2, Unix, Site scope, Tivoli

Project Description:

Loan Originating System – Fifth Third is undertaking a program to transform our consumer real estate experience - for both customers and employees. The intent is to bring all consumer real estate lending under a single loan origination platform – including residential first mortgages and our second mortgage offerings.

Responsibilities:

Understand the requirements and document their expectations, handling the current process, modifying and created the jobs to the updated requirements, handle the load process to data marts.

Extract the data using salesforce stages and loaded into salesforce database.

Provided a solution for ETL jobs from (‘. p’ progressive language) to SQL query language.

Strong experience in writing DDL / DML statements.

Prepared technical design / specification of data Extraction, Transformation and Loading.

Built E2E ETL solutions beginning from data modeling till Production implantation.

Worked closely with the ETL / DB Admin team to ensure that all Database / ETL objects and components are correctly migrated for the production deployment.

Using SQL queries and pull the data from different tables and generate files as per FSD requirements.

Taking care end-to-end testing as per FSD requirements and validating data as per client need.

Worked for version and data migration Datastage jobs from 9.1 to 11.5

Performed release management planning to ensure release are scheduling inline of existing process and the business deadlines.

Performed Root Cause Analysis, ETL code fix /data fix for Data issues raised by the business in the data marts.

Once data loaded into target database as per client requirement and then using SAP BO generate visualized reports for client need.

Worked performance tuning at various levels of Target, Source for large datasets.

Guiding peers and reviewing their code.

Providing end to end support for UAT (User Acceptance Test) and production deployment.

Project #2

Project Title

Investment Advisors

Client

53rd Bank Madisonville, Kingsley Dr Cincinnati OH.

Role

ETL Consultant

Duration

Sep 2013 – July 2016

Environment

IBM Infosphere DataStage 8.5 & 9.1 Windows XP, DB2, Unix, Sitescope, Tivoli

Project Description:

Investment Advisory – manages money for individuals and institutions by offering numerous solutions to help its customers in achieving their investment and wealth management goals. Fifth Third understands the current financial situation and long-term goals as well as the personal interests, attitudes and beliefs of customers and suggests the most appropriate investment choice

Responsibilities:

Prepared technical design / specification of data Extraction, Transformation and Loading.

Built E2E ETL solutions beginning from data modeling till Production implantation.

Worked closely with the ETL / DB Admin team to ensure that all Database / ETL objects and components are correctly migrated for the Production deployment.

Performed release management planning to ensure release are scheduling inline of existing process and the business deadlines.

Extract real time data using XML stage with the help of web services

Worked for version migration Datastage jobs from 8.5 to 9.1

Performed Root Cause Analysis, ETL Code fix /data fix for Data issues raised by the business in the Data marts.

Worked performance tuning at various levels Target, Source for large datasets.

Guiding peers and reviewing their code

Providing end to end support for UAT (User Acceptance Test) and Production deployment.

Project #3

Project Title

EDW Granular

Client

Bell Canada

Role

ETL Consultant

Duration

Aug 2011 – Sep 2013

Environment

IBM Infosphere DataStage 8.5, Windows XP, Oracle 11g, Linux

Project Description:

Bell is Canada's largest communications company, providing consumers and business with solutions to all their communications needs, including Bell Mobility wireless, high-speed Bell Internet, Bell Satellite TV and Bell Fibe TV, Bell Home Phone local and long distance, and Bell Business Markets IP-broadband and information and communications technology (ICT) services.

Responsibilities:

Understanding the Technical design document and Source-To-Target mappings.

Created jobs to extract the source from different sources.

Created Jobs using various stages in data stage Designer.

Analysis of Existing Source and Target System

Analyzed the performance of the jobs and enhanced their performance.

Designed the job using the stages like Aggregator, Transformer, Look-up, Filter, Remove Duplicate, Copy, Dataset, and Sequential file set.

Involved in testing the developed codes, fixing defects if any and redoing the test and fix upon delivery to the client manager.

Scheduled jobs using data stage Director.

Monitored and validated the jobs using data stage Director.

Involved guiding peers and reviewing their code.

Provide support during implementation of projects

Project #4

Project Title

Sales Information System

Client

Randall’s Food Markets, US

Role

ETL Consultant

Duration

Oct 2009 – July 2011

Environment

IBM Websphere DataStage 8.1, Windows XP, Oracle 9i, UNIX

Project Description:

The client is a chain of departmental stores in US. It is having number of stores and it sells various numbers of products. The database has lots of historical data. So the Data Warehouse plays a major role in enabling various stores to view them at lowest Level and help them to make decisions to bring more revenue to company with new policies. This project involves in developing Enterprise Data Warehouse in Oracle as database for Gottschalks to view day-to-day sales and growth rate in the business.

Responsibilities:

Understanding the Technical design document and Source-To-Target mappings.

Designing the ETL process using DataStage tool to load data from source to target

Schema.

Developing various kinds of jobs according to TDD.

Developing parallel jobs Using stages like Dataset, Sequential file, Aggregator,

Merge, Transformer, Lookup, Joins and etc.,

Testing the Jobs to assure that data is loaded as per TDD.

Preparing Unit Test Cases and executing them for each job.

Moving the ETL jobs from Development to Production.

Running, monitoring of the jobs using Data Stage Director and checking logs.

Contact this candidate