Developer Project

DEEPA YADLAPALLI

E-mail id: *****.**********@*****.*** Mobile.No: +1 701(989)2880

Have 9 years of experience in Data warehousing.

Hands on experience in DataStage 8.1,DataStage 8.7,Datastage 11.3 (ETL),Oracle 11g and Teradata13.

Got IBM Certified in DataStage 8.5

Very strong understanding of Data warehousing concepts.

Have profound knowledge on Dimension, Facts, SCDs, Snowflake and Star Schema.

Followed the SDLC thoroughly.

Proven ability to effectively manage time and resources and prioritize tasks in order to consistently complete projects according to specifications and on time.

Self-Motivated, Hard Working & Good Communication/Interpersonal Skills.

Flexible and adaptable to new technologies with quick learning abilities

Involved in end to end design of ETL for new development and Change requests.

Demonstrated strong ability to think through some complex scenarios and come up with robust solutions

Discuss with clients to understand the requirements and provide design/technical inputs to offshore development team.

Company Name

Designation

Tenure

Deloitte Consulting LLP

Senior Consultant

4th June’18 to Till date

Deloitte Consulting US India Private Ltd.

Consultant

18th May'15 to 1st June’18

IBM India Pvt Ltd.

Data Specialist

10th Sep'13 to 8th May'15

Cognizant Technology solutions Pvt Ltd.

Programmer Analyst

18th Feb'13 to 27th Aug'13

Tech Mahindra Ltd.

Technical Associate

30th Jul'10 to 11th Feb‘13

Database

Teradata13, Oracle 10g, Oracle 11g and Oracle 12c(SQL)

ETL Tools

Datastage 8.1, Datastage 8.7, Datastage 9.1, Datastge 11.3

Operating Systems

Windows 2000, Windows XP, Linux

Languages

Unix shell Scripting, SQL, BTEQ scripting in Teradata.

RPA

UI Path Diploma Certified

Got Cookies Award for displaying timely and efficient analysis and delivery to Customers.

Got Eminence and Excellence Orion award, 2014 for displaying one of the IBM practices ‘put the client first’.

Got Manager’s Choice award twice in September 2014, November 2014.

Went to Onsite, Melbourne, Australia for 4 weeks to attend meetings with Onsite team and KT.

Got Spot Award, Applause award, Space rangers and outstanding award in Deloitte.

Currently working on H1B in Bismarck North Dakota at client location.

S. No

Project

Client

Technical Environment

1

EDB BI

Etisalat Telecommunications.

Unix, Datastage8.1, Teradata13 and ERWIN

2

IDSS

AT&T

Unix, Datastage 8.7, Oracle 10g

3

ResCap Seperation

Ally Financial Inc.

Unix, Datastage 8.7, Oracle 10g

4

IMCOE

ANZ Bank, Australia

Unix, Datastage 9.1,Teradata 14

5

Project of North Dakota

State of North Dakota

Unix,Datastage 11.3,Oracle 12c

Project#5:

Project : Project of North Dakota

Client : State of North Dakota

Employer : Deloitte Consulting LLP.

Duration : June 2015 to Till date

Tools/ Environment : Unix, Datastage 11.3,Oracle 11g,Oracle 12c

Role : Senior ETL Consultant and Reports Track Lead

The client is the state of North Dakota

The project is to to build a solution for the state for Integrated Eligibility platform, which they must use to determine eligibility for the residents based on various eigibility criteria and also to generate reports for some key performance indicators.

The scope is to build a data warehous and enable repoting capbility for the state.

Responsibilities :

Design of the data warehouse and create ETLs to load Facts and Dimensions.

Implemented Slowly Changing Dimension in Datastage jobs.

Working on DataStage & Oracle Connectivity.

Jobs designed with parallelism utilization in DataStage.

Designed RCP jobs which simplified job designs which required no metadata to be loaded, hence improving performance.

Driving calls with offshore development team and provide required technical/Design inputs for development of ETL jobs.

Meeting with clients to get the requirements to build Federal and Operational reports.

• Working with clients to understand their Adhoc requests and provide them with the

requested reports by developing them before the timeline provided and with zero

defects.

Performing BA testing and raised defects in Integration testing

Providing inputs needed for the development to offshore by talking to different source teams to extract the information needed.

Providing Demo to the clients regarding various reports built and getting approval for deploying them to production.

Managing the development work done at offshore by providing DEV timelines and by providing resource allocation plan.

Jobs designed with parallelism utilization in DataStage.

Worked on stages Pivot, Join, Filter, Aggregators and Lookups, Transformer and used Teradata connector.

Designed RCP jobs which simplified job designs which required no metadata to be loaded, hence improving performance.

Restartability and sequencing of Datastage Jobs implemented.

Project#4:

Project : IMCOE

Client : ANZ Bank, Australia

Employer : IBM India Pvt Ltd.

Duration : October 2013 to May 2015

Tools/ Environment : Unix, Datastage 9.1,Teradata 14

Role : ETL Developer.

Responsibilities :

Analyze and understand the mapping requirement document.

Involved in creating views based on mapping document.

Involved in peer reviews of the views created.

Worked on Teradata BTEQ scripting to build dimensions and facts.

Project#3:

Project : ResCap Seperation

Client : Ally Financial Inc.

Employer : Cognizant Technology solutions.

Duration : February 2013 to August 2013

Description : Seperation of Rescap data from third party data center to Ally data

Center.

Tools/ Environment : Unix, Datastage 8.7,Oracle 10g

Role : ETL Developer.

Responsibilities :

Analyze and understand the system requirement specification document.

Involved in the preparation of IDD documents.

Designing ETL strategies for the Data Migration

Working on DataStage & Oracle Connectivity.

Jobs designed with parallelism utilization in DataStage.

Working on stages Join, Filter, Aggregators and Lookups, Transformer and used Oracle connector.

Restartability and sequencing of Datastage Jobs implemented.

Project#2:

Project : IDSS

Client : AT&T.

Employer : Tech Mahindra Ltd.

Duration : October 2011 to February 2013.

Description : Capture Success rate of network transactions.

Tools/ Environment : Unix, Datastage 8.7, Oracle 10g.

Role : ETL Developer.

Responsibilities :

Analyze and understand the Data Integration requirements.

Designing ETL strategies for the Data Integration

Facts, Dimensions are implemented using Datastage jobs.

Working on DataStage & Oracle Connectivity.

Jobs designed with parallelism utilization in DataStage.

Working on stages Pivot, Join, Filter, Aggregators and Lookups, Transformer, External source, External target and used Oracle connector.

Worked on real time stages such as xml input stage to parse the xml.

Restartability and sequencing of Datastage Jobs implemented.

Project#1:

Project : EDB BI

Client : Etisalat Telecommunications.

Employer : Tech Mahindra Ltd.

Duration : October 2010 to September 2011.

Description : Develop Regulatory & Usage/Performance reports.

Tools/ Environment : Unix, Datastage 8.1, Teradata13 and ERWIN

Role : ETL Developer.

Responsibilities :

Analyze and understand the Data Integration requirements.

Designing ETL strategies for the Data Integration

Implemented Slowly Changing Dimension in datastage jobs.

Facts, Dimensions are implemented using the Bteq scripts

Worked on Bteq scripts in Teradata.

Used analytical functions such as qualify, rank, partition etc along with the aggregate functions.

Worked on DataStage & Teradata connectivity.

Jobs designed with parallelism utilization in DataStage.

Worked on stages Pivot, Join, Filter, Aggregators and Lookups, Transformer and used Teradata connector.

Designed RCP jobs which simplified job designs which required no metadata to be loaded, hence improving performance.

Restartability and sequencing of Datastage Jobs implemented.

Deployment of Datastage jobs in SIT & Production environment.

Documentation & KT sessions to the support Team.

Completed bachelor of Technology(B.Tech) in Electronics and communication engineering from JNT University with an aggregate of 76.6%

Board of intermediate education in MPC with an aggregate of 93%

Board of secondary school with an aggregate of 83.11%

Tech Mahindra Initial Training Program (ITP) which included

SQL, C, SE, DBMS, Unix, Behavioral Training, Basic Telecom, VVT.

IBM Data stage 8.5 Certified.

UI Path Diploma Certified.

Professional Summary

Employment History

Technical Summary

Achievements

Projects Handled

Project Details

Educational Qualifications

Training Programs Attended

Contact this candidate