Siva Durga Prasad,

Email: acx0w9@r.postjobfree.com

Phone : +91 -958*******.

Professional experience:

8+ years of experience in Information Technology. Having both onshore and offshore. Involved in two international assignments.

Over 7+ years of experience working in Data Stage 7.5,8.0.1,8.5,8.7 for Overseas Clients.

Arounnd 1 year into wherescape red

Data ware Housing ETL Tools & Software Skill Set:

ETL Tools : Data Stage 7.5, 8.0.1, 8.5, wherescape red

RDBMS : Oracle, DB2.

Operating Systems : Windows 2000/XP, UNIX.

Trainings Attended : Informatica, BODS

Experience Summary:

Organization

From Date

To Date

Designation

CTS

Apr 2014

Till date

Senior Associate

Helios & Matheson

Sep 2013

Mar 2014

Lead Consultant

Capgemini

Jul 2010

Aug 2013

Senior Consultant

MGL ( Mascon Global Limited)

Jul 2009

Jul 2010

Software Engineer

Tata Consultancy Services India Pvt.ltd

Sep 2007

Dec 2008

Asst Systems Engineer

Education Summary:

Course

University

Year

MCA

Nagarjuna University

From 2004 to 2007 with 73%

Project Details:

Assignment #1

Project Name : NBS(Norhern Brokerage System).

Client : Northern Trust

Size : 7

Role : Team Lead.

Environment/ Tool : Data Stage 8.7,Oracle

Duration : Feb 2015 –Till date.

Description:

The Northern Trust Corporation is an American international financial services company headquartered in Chicago, Illinois. It provides investment management, asset and fund administration, fiduciary and banking services through a network of 85 offices in 18 U.S. states and 20 international offices in North America, Europe and the Asia-Pacific region. As of June 30, 2014, Northern Trust Corporation had $106 billion in banking assets, $6.0 trillion in assets under custody and $924.4 billion in assets under management. In March 2010, Forbes magazine ranked Northern Trust as the world's most admired company in the "Superregional Banks" category..

Responsibilities:

Interacted to the customer directly regarding design.

Provided project estimations to the customer.

Resource estimation as per the dead lines of the project.

Designed High Level Design documents and Low Level Design documents.

Involved in status calls and involved in team meeting with team members.

Involved in different phases of the project like design, development, UAT and production

Migration.

Offshore coordination.

Used the Data Stage Designer to develop jobs for extracting, cleansing, transforming, integrating, and loading data into Data warehouse.

Used the Data stage Designer for importing and exporting Data Stage components from the repository

Used Data Stage director to run and schedule the jobs.

Designed Sequencer to automate the whole process of data loading.

Facilitating knowledge transition to new members joining the team.

Assignment #2

Project Name : CRM Consolidation.

Client : BAXTER

Size : 7

Role : Team Lead.

Environment/ Tool : Data Stage 8.7, SFDC.

Duration : May 2014 –Jan 2015.

Description:

Baxter International Inc. is an American health care company with headquarters in Deerfield, Illinois. The company primarily focuses on products to treat haemophilia, kidney disease, immune disorders and other chronic and acute medical conditions.

Moving existing data and capabilities from Siebel to SFDC (Lift and Shift). Build new capabilities in SFDC to address already identified enhancement backlog capabilities from Siebel. Inbound Integration between Salesforce.com and ODS, JD Edwards, RDW, Roaster Access DB, Vault and Box.com systems. Developing Data Migration strategy and framework for migration of historical data, involving Data Mapping between legacy systems and Salesforce.com object/s.

Responsibilities:

Interacted to the customer directls regarding design.

Provided project estimations to the customer.

Resource estimation as per the dead lines of the project.

Designed High Level Design documents and Low Level Design documents.

Involved in status calls and involved in team meeting with team members.

Involved in different phases of the project like design, development, UAT and production

Migration.

Offshore coordination.

Involved in POC on Sales force Connector stage.

Got it approved from the customer and implemented the same in this sales force integration project.

Offshore coordination.

Used the Data Stage Designer to develop jobs for extracting, cleansing, transforming, integrating, and loading data into Data warehouse.

Used the Data stage Designer for importing and exporting Data Stage components from the repository

Used Data Stage director to run and schedule the jobs.

Designed Sequencer to automate the whole process of data loading.

Facilitating knowledge transition to new members joining the team.

Assignment #3

Project Name : Control Tower.

Client : Bank of America

Size : 7

Role : Team Lead.

Environment/ Tool : Data Stage 8.5, SAP.

Duration : Sep 2013 –Apr 2014.

Description:

The Bank of America Corporation is an American multinational banking and financial services corporation headquartered in Charlotte, North Carolina. It is the second largest bank holding company in the United States by assets. This project has been initiated to re-engineer the current Control Tower Reporting environment to that of a dimensional design environment with an analytics platform that will be the target reporting and analytics framework for the business. The new Retention Control Tower Data Mart will provide a robust and reliable reporting environment that delivers the home loan information that management needs to make informed decisions to run the business.

Responsibilities:

Involved in status calls and involved in team meeting with team members.

Offshore coordination.

Used the Data Stage Designer to develop jobs for extracting, cleansing, transforming, integrating, and loading data into Data warehouse.

Used the Data stage Designer for importing and exporting Data Stage components from the repository

Used Data Stage director to run and schedule the jobs.

Designed Sequencer to automate the whole process of data Loading

Assignment #4

Project Name : Indirect Spend Project Accounting (ISPA).

Client : Target

Size : 10

Role : Team Lead

Environment/ Tool : Data Stage 8.5, SAP.

Duration : Jun 2012 –Aug 2013.

Description:

Indirect Spend Project Accounting (ISPA) is the major SAP initiative to transform systems and processes enterprise-wide. ISPA uses Enterprise Resource Planning (ERP) software to manage and coordinate resources, information and business functions for Target. The ERP Target selected to facilitate this change is called SAP.

Before SAP, Target's financial systems were built to accommodate existing business needs. As needs changed, additional systems were developed to meet specific requirements. The set of systems and process grew and grew, making integration more challenging. An initiative called TGT$100 was rolled out in 2010 to replace end-of-life financial systems and related processes with SAP. As of August 2011, TGT$100 was retired as a program, leading to the new SAP Domestic initiatives such as ISPA.

Responsibilities:

•Involved in understanding the functionality of the objects.

• Involved in the status calls and sharing the business information among other vendors.

•Involved in LLD design and objects(jobs) development.

•Involved in performance testing.

•Involved in Regression testing.

•Involved in E2E testing.

•Work with other vendors to get the required test cases completed as per the time lines.

Assignment #5

Project Name : EPG (Efficient Project Reporting).

Client : Network Rail (UK)

Size : 5

Role : Team Lead

Environment/ Tool : Wherescape Red, Oracle

Duration : Jun 2011 – May 2012

Description

Efficient Project Reporting (EPG) initiative will enhance the business reporting capability for Network Development, Information Management, Investment Projects & Asset Management, enforcing the use of standard outputs and a consistent information lifecycle.

Responsibilities:

•Interacted with the business champions to understand their business requirements

• Designed Jobs as per the business requirement using Wherescape Red.

•Involved in monthly ETL runs using Wherescape Red.

•Involved in unit testing as well as UAT.

•Involved in taking the back up of the entire project using Wherescape Red.

Assignment #6

Project Name : Prims

Client : Target, USA

Size : 4

Role : ETL Test Lead

Environment/ Tool : Data Stage 7.5.1, DB2

Duration : Jul 2010 – May 2011.

Description

Target Corporation, doing business as Target, is an American retailing company headquartered in Minneapolis, Minnesota. It is the second-largest discount retailer in the United States, behind Wal-Mart. Prism is also known as TCI(Target.com Item) in TTS( Target technology services)J2EE Web Application used to create and maintain items (products) for “the Web.”

Consists of Amazon: Two Marketplaces

Target Amazon – Target items on Amazon.com

Target.com – Target items on Target.com

Item Setup and Management is a workflow process involving many other systems. Prior to PRISM, MPAs (Merchandise Process Administrators) had to manage an item in numerous systems/applications through manual processes (telephone, email, spread sheets, etc.).PRISM was built to provide a single User Interface to house the vast majority of this workflow and manage the system interfaces.

Responsibilities:

Involved in the status calls. Sharing the information among the team members.

Creating the items as per the requirement using Prism UI.

Publishing the items to different system like OMS, WMS using data stage.

Conducting the meetings between different teams to understand the data flow in between different systems.

Used the Data stage Designer to develop jobs for extracting, cleansing, transforming, integrating, and loading data into group Data warehouse.

Used Data Stage director to run and schedule the jobs.

Worked with Data stage Manager for importing metadata from repository.

Designed Sequencer to automate the whole process of data Loading

Assignment #7

Project Name : Cardinal HealthCare

Client : Cardinal HealthCare, U.S.

Size : 8

Role : Team Member

Environment/Tool :Data stage 8.0.1,Oracle 9i

Duration : Jul 2009-Jul 2010

Description:

Headquartered in Dublin, Ohio, Cardinal Health, Inc. (NYSE: CAH) is a $91 billion, global company serving the health care industry with products and services that help hospitals, physician offices and pharmacies reduce costs, improve safety, productivity and profitability, and deliver better care to patients. With a focus on making supply chains more efficient, Cardinal Health manufactures medical and surgical products and is one of the largest distributors of pharmaceuticals and medical supplies worldwide. Ranked No. 18 on the Fortune 500, Cardinal Health employs more than 30,000 people across the world. Cardinal Health currently uses Informatica 6.0 to load its Enterprise Data Warehouse, this project aims at migrating the existing Informatica mappings to Data stage 8.0.1 Parallel Jobs to bring in efficiency through increased parallelism and provide more scope for other functionalities provided within IBM Information Server

Responsibilities:

.

Analysed the Informatica mappings and created an equivalent Data stage jobs, containers and sequences Wherever applicable

Developed the data stage equivalent jobs for the various modules.

Prepared Unit Test cases, maintaining Code Review Documents etc. as per the standards

Assignment #8

Project Name : Maintenance and Enhancement Services

Client : IMF

Size : 8

Role : Team Member

Environment/Tool :Data stage Px,Oracle 9i

Duration : Aug 2008-Dec 2008

Description:

The IMF is an international organization of 185 member countries. It was established by international treaty in 1945 to promote international monetary cooperation, exchange stability, and orderly exchange arrangements; to foster economic growth and high levels of employment; and to provide temporary financial assistance to countries to help ease balance of payments adjustment. Its statutory purposes include promoting the balanced growth of international trade, stability of exchange rates and the maintenance of orderly exchange arrangements among members. The IMF monitors global economic and financial developments and gives policy advice, lends to member countries with balance of payments problems, and provides technical assistance in its areas of expertise.

Responsibilities:

Used the Data stage Designer to develop jobs for extracting, cleansing, transforming, integrating, and loading data into group Data warehouse.

Used Data Stage director to run and schedule the jobs.

Worked with Data stage Manager for importing metadata from repository.

Designed Sequencer to automate the whole process of data Loading

Assignment #9

Project Name : CBA, Australia(Onsite)

Client : Commonwealth Bank of Australia

Size : 8

Role : Team Member

Environment/Tool :Data stage Px,Oracle 9i

Duration : Sep 2007-Aug 2008

Description:

CBA is one of the third largest banks in Australia. In this project I have mainly involved in payments domain. We have extracted the data from the source staging area which is in oracle and did transformations according to their business need and load into the group data warehouse. The main objective of this project is the bank management can take proper decisions from the reports generated from our group data warehouse and get the knowledge of new business opportunities.

Responsibilities:

Used the Data stage Designer to develop jobs for extracting, cleansing, transforming, integrating, and loading data into group Data warehouse.

Used Data Stage director to run and schedule the jobs.

Worked with Data stage Manager for importing metadata from repository.

Designed Sequencer to automate the whole process of data Loading

Contact this candidate