Mr.VENU GOPAL ADIPUDI

Professional Summary

. Over 14 years of IT experience in various phases of IT projects

following the SDLC process such as analysis, design, coding, testing

and deployment.

. Around 12 years of experience as a Technical consultant in SONY

ELECTRONICS INC.

. Strong experience (6+years) in developing strategies for Extraction,

Transformation and Loading (ETL) mechanism using Informatica Power

Center 6.x/7.x/8.x,Power Exchange 5.2.

. Extensive experience in gathering the requirements, converting the

requirements into functional and technical specifications.

Communicate the technical issues to non technical end-users as a

part of the project meetings.

. Expertise in dealing with Methodologies like Data Loading and Slowly

Changing Dimensions.

. Actively involved in Data Modeling and data migration using Power

Designer.

. Created logical and physical data models using Power Designer and

Quest data analyzer for staging database.

. Experience in Database design, development and loading various

heterogeneous sources such as Mainframe files, Oracle and DB2 table

data into ODS.

. Strong in SQL using tools like TOAD to run SQL queries to validate

the data.

. Experience in PL/SQL Programming (Packages, Stored Procedures,

Functions and Triggers) in Oracle 9i and 10g environment.

. Extensive experience with ETL tool Informatica in designing and

developing complex Mappings, Mapplets, Transformations, Workflows.

. Extensive experience in designing and developing complex mappings

from varied transformation logic used in Informatica.( Like

Unconnected and Connected lookups, Source Qualifier, Router, Filter,

Expression, Aggregator, Joiner, Update Strategy etc).

. Extensively worked in OLTP & OLAP environment that includes

production, QA and development databases in ORACLE and DB2

environment..

. Extensive experience in Workflow Manager, Workflow Monitor and

support critical production issues.

. Extensive Experience in Performance Tuning of targets, sources,

mappings and sessions, Co-coordinating with DBAs in defining the

partitions and indexes to handle large size databases as a part of

the ETL tuning process.

. Extensive knowledge in Mainframe legacy systems and data structures.

. Good Knowledge with UNIX Operating System and understanding the

Shell scripting.

. Demonstrated ability to quickly grasp new concepts, both technical

and business related and utilize as needed.

. A Team Player with excellent communication, analytical, verbal and

writing skills.

. Excellent problem solving skills with a strong technical background

and interpersonal skills.

. Ability to meet tight deadlines and work under pressure.

. Extensive experience in working with multiple projects and teams

across the globe in a cost effective way.

TECHNICAL SKILLS:

Data Warehousing: Informatica Power Center 8.6/ 8.5.1/ 8.1/

7.1.3/7.1.1 ETL

(Source Analyzer, Warehouse Designer, Metadata Manager,

Mapping Designer, Mapplets, Transformations, Workflow

Manager, Worklets, Workflow Monitor), Powercenter Connect

tool for SAP R/3 and Power exchange for Mainframes.

Data Modeling: Dimensional Data Modeling, Star Schema, Snow-Flake schema

Modeling, FACT and Dimensions Tables, Physical and Logical

Data Modeling .

Databases: Oracle (10g,9i,8i), IBM DB2 and IMS DB on

Mainframe.

Operating Systems: MS Windows XP, 98, Windows NT/2000, NT 4.0, MVS, and SCO

UNIX

Languages: PL/ SQL, SQL* Plus 8, UNIX Shell Script, COBOL, M/F FOCUS.

Tools & Utilities: SQL* Plus 8, Toad for Oracle V9.7, FTP Tools, JCL,

VSAM, CICS, Easytrieve Plus, Quest Data Analyzer, Erwin,

Vi editor, Perigrine & Remedy for Incident tracking, Abend-

AID, File_AID.

Domain Knowledge: Manufacturing, supply chain, Inventory Mgmt, Corporate

Data Warehouse.

Trainings

Type Title Location Organized by Duration

Informatica ETL Client Self Learning 5 Weeks

Training Location

Professional Experiences:

Industry Manufacturing

Project Name: Corporate Data Warehouse - ODS redesign.

Client SONY ELECTRONICS

Role Sr. ETL Tech Lead

Organization Sony Electronics

Duration August/2005-Till Date

Team Size Project: 12 Module: 50

Environment Languages: PL/SQL, COBOL, Informatica

(with skill

versions)

Database: ORACLE 10g,DB2, IMS DB

Tools: TOAD, Strieva Detail, FOCUS

O/s : UNIX, MVS, Unix Sun Solaris 2.6

Hardware NA

Project Description

Sony Electronics, Inc. is principally engaged in the design, development

and worldwide marketing of Electronics, Computers including Laptops (VAIO)

and Desktops, and various Computer Accessory products. The Company is a

manufacturer and seller of the electronic products worldwide. Sony sells

its products to retail accounts in the United States and through a mix of

owned retail stores, distributors, licensees and subsidiaries worldwide.

CDW - ODS project is to redesign the Sony Electronics Inc, Data Warehouse

Reporting application after the recent ERP implementation using SAP R/3,

replace the existing Legacy reporting application with Oracle using

Informatica as the ETL tool. During the project involved in designing

various Fact tables and Dimension tables need for the Data warehouse and

prepared a historical data load (one-time) using legacy data, which is

residing in Mainframes using the Strievea Detail (Power exchange) tool.

Replaced the current data feeds with Informatica ETL using Power Exchange

tool as per the Architectural direction. Involved in the Metadata extract

for the Informatica Migrate project from Informatica 7.1 version to

Informatica 8.6.1 version for some of the ETL objects present in the older

version.

Responsibilities/Contribution:

> Involved in the full life cycle development of the project including:

Design, development, and testing.

> Responsible for converting the existing legacy data load process with

Informatica ETL process.

> Responsible for defining the source structure for heterogeneous files

from various Orders management systems into Uniform ODS environment for

CDW.

> Requirement gathering, preparing the Functional and Technical Designing

documents as per the Customer needs.

> Delegate the work to Offshore and reviewing the deliverables.

> Preparing the production turn-over documents and responsible for the

stabilizing the ETL developed and produce the adhoc report using FOCUS

and ORACLE to help end users inquires.

> Involved in the design of ODS tables for Corporate Data warehouse.

> Worked with DBA team to establish and fine-tune the Large Fact tables for

the data loads and updates.

> Improved performance by using Explain Plan, Creating appropriate indexes,

using hints, queries optimization, utilizing table spaces and

partitioning schemas in databases.

> Improved ETL performance by identifying the bottleneck in the existing

informatica mappings and fine-tune the ETL objects.

> Worked with the Operations Support Group to schedule the Jobs using CNTL-

M tool.

> Supported the Production support team in resolving the critical issues

arises during month-end and critical data load events.

> Chair and participate in regular status review meetings with the

Business.

> Establish and maintain Projects and program communications.

> Establish and maintain processes to manage scope over the Project

lifecycle.

> Identify and manage Projects and/or program issues.

> Set Project quality and performance standards.

> Structure the Project team to ensure maximum performance and provide

purpose, direction and motivation to team.

> Provided an end-to-end solution based on the domain knowledge gained

during the project.

> Actively share knowledge and learning from Project experiences.

> Well experienced with all the processes involved in stages of Project

Management

> Bi-weekly presentation to upper Management in the infrastructure group to

report the ongoing Issues and to inform management of the deadlines that

are being met and those being changed.

> Proven ability of issue tracking, risk analyzing and contingency

planning, estimating, projecting and project documentation.

> Excellent organizational, time management, written and verbal

communications skills and able to communicate with higher management.

Industry Manufacturing - Supply Chain

Project Name: CDW Legacy Support

Client SONY Electronics INC

Role CDW production support

Organization Sony Electronics Inc.

Duration August/2005--September/2008

Team Size Project: 3 Module: 20

Environment Languages: COBOL, JCL, VSAM, FOCUS, PL/SQL

(With skill

versions)

Database: DB2, VSAM, ORACLE

Tools: EasyTrieve, Focus, TOAD, Power Exchange

O/s: UNIX, MVS

Hardware NA

Project Description

Supporting and maintenance of CDW Legacy process, enhancing and replacing

the existing data feeds with Informatica ETL using Power Exchange (STRIEVA)

tool, Power Exchange Navigator.

Contribution

> Involved in the full life cycle development of the project including:

Design, development, and testing.

> Responsible for analyzing and resolving the critical issues during the

regular batch cycle.

> Responsible for converting the existing legacy mainframe data load

process with Informatica ETL process.

> Responsible for defining the source structure for heterogeneous files

from various Orders management systems into Uniform ODS environment for

CDW.

> Responsible for the complete Data loads for Corporate Data warehouse

using the Legacy process.

> Generated adhoc reports using the legacy tools available within the

client environment such as Focus.

Industry Manufacturing - Supply Chain

Project Name: STN - Production Support

Client SONY Electronics INC

Role Sony Mainframe Production support

Organization Sony Electronics Inc.

Duration August/2003--August/2005

Team Size Project: 8 Module: 20

Environment Languages: COBOL, JCL, VSAM, FOCUS, PL/SQL

(With skill

versions)

Database: DB2, VSAM, ORACLE

Tools: EasyTrieve, CICS

O/s: UNIX, MVS

Hardware NA

Project Description

STN (Sony Tigher Network) is a backbone application for handling Sony

Electronics Legacy Order management system designed to handle the various

functions of Supply chain, Order processing, inventory management and

Invoicing and sales application developed and maintained from 1985 in

Mainframe Legacy environment using IBM IMS DB and CICS environment using

COBOL language. STN production support project is provide a 24X7 support

to the batch and online application.

Contribution

> Involved in the full life cycle development of the project including:

Design, development, and testing.

> Responsible for analyzing and resolving the critical issues during the

regular batch cycle.

> Responsible for the Mission critical application support during the

regular Month-end for Sony Electronics.

> Responsible for the Critical Financial Inventory balancing application

and working with the Japan for AIMS feed.

> Resolved critical support issues using the ABEND AID and debugging tools

in Legacy environment.

Industry Manufacturing - Supply Chain

Project Name: STN - FSRP

Client SONY Electronics INC

Role Senior Mainframe Analyst

Organization Sony Electronics Inc.

Duration Jan/1999--July/2003

Team Size Project: 35 Module: 50

Environment Languages: COBOL, JCL, VSAM, FOCUS, PL/SQL

(With skill

versions)

Database: DB2, VSAM, ORACLE

Tools: EasyTrieve, CICS

O/s: UNIX, MVS

Hardware NA

Project Description

Responsible for gathering the requirements, coding the programs, which will

modify the existing financial, feed from SONY order management system STN

into FIS. Involved in analyzing the complex order management system and

accommodate the New Oracle GL structure for the Sony Financial Inventory

Balancing system.

Contributions

> Involved in the full life cycle development of the project including:

Design, development, and testing.

> Responsible for converting the data feeds to FIS compatible with Oracle

GL structure.

> Responsible for generating reports against the feeds for regression test

results.

> Written many programs to feed the data from legacy system into the new

Oracle Financial system as a onetime data feeds.

> Involved in Year 2000 conversion activities for the Sony Legacy order

management application developed in Mainframes.

Industry Airlines - Supply Chain

Project Name: Northwest Airlines - SCEPTRE Enhancements

Client Northwest Airlines, Eagan, MN

Role Senior Mainframe Analyst

Organization Northwest Airlines

Duration Jul/1996--Dec/1998

Team Size Project: 8 Module: 50

Environment Languages: COBOL, JCL, VSAM, FOCUS, PL/SQL

(With skill

versions)

Database: IMS DB, VSAM, ORACLE

Tools: EasyTrieve, IMS DC

O/s: MVS

Hardware NA

Project Description

Responsible for gathering the requirements and writing the technical

documents, code review and document the change requests as per the client

standards. Sending the work to Offshore and reviewing the deliverables and

co-ordinate with the offshore team in successful enhancements based on the

Change requests.

Contributions

> Involved in the full life cycle development of the project including:

Design, development, and testing.

> Responsible for converting the Business requirements into the Technical

specifications for offshore team to develop.

> Responsible to delegate the work and co-ordinate with Offshore as Onsite

representative for Northwest Airline SCEPTRE system using IMS DB/DC

environment.

Education

Degree Specialization University Year of passing

Post Graduation MCA Computers JNT University 1996

Post Graduation M.SC MATHEMATICS Andhra University 1990

Graduation B.SC GENERAL Osmania University 1985

Passport & Visa Details

Passport No. 466745320 Valid Upto: 10 Feb 2020

Visa Type Country Valid Upto

US Citizen USA NA

Personal Details

Name Mr.VENU GOPAL ADIPUDI

Email Id Client email id abkbec@r.postjobfree.com

Personal email id abkbec@r.postjobfree.com

abkbec@r.postjobfree.com

Location Sony Electronics, San Diego, CA, Bldg-5

Home: 858-***-****

Contact Numbers

Mobile: 858-***-****

Work: 858-***-****

References are available on request.

Profile can be viewed at: http://www.linkedin.com/in/venugopaladipudi

Contact this candidate