Manager Project

Resume

Pridhviraj Nandarapu

Ph - 510-***-****

*******.*********@*****.***

Objective

Seeking position to use my knowledge and expertise in Mainframe and Data

Warehouse technology, coupled with analytical, problem solving skills and

team leading for an efficient and successful execution of projects

undertaken.

Overview of Professional Background

. 6 years of experience at Wipro Technologies and Infosys Technologies

Ltd; most leading IT companies in India. Engaged in full software life

cycle development.

. Deputed to onsite as Senior consultant for client Best Buy, MN, USA

(Jun 2011 - Till date)

. Deputed to onsite as Programmer Analyst for client Wal-Mart, AR,USA

(Sep 2009 - May 2011)

. Deputed to onsite as Programmer Analyst for client APL, CA, USA and

was leading the team. (Sep 2008 - Aug 2009)

. Deputed to onsite as Software Engineer for Client BNSF Railways, TX,

USA.( May 2008 - Aug 2008)

. Provided efficient offshore support to onsite team while at offshore.

Capabilities and Skill set

. Experienced in Data Warehousing application development life cycle

including maintenance and support

. Extensive knowledge in various database technologies like Teradata,

DB2, VSAM, PL/SQL and ETL methodology for supporting data

transformations and processing, in a corporate wide ETL Solution using

JCL, COBOL, SYNCSORT.

. Experienced in Testing of DW/BI functionalities

. Handled various production support- Identified, analysed, and fixed

root cause of production bugs or system errors.

. Expert in the creation of data validation scripts using S QL and well

versed with different tools like Teradata SQL Assistant, Query man and

TOAD

. Extensive experience in TERADATA Utilities like BTEQ, FASTLOAD, MLOAD

and Mainframe tools SPUFI, QMF, FILE-AID, XPEDITOR, ENDEAVOUR,

CHANGEMAN, CA7, Platinum, ABEND-AID, SQL, TSO/ISPF, SORT and IBM

UTILITIES

. Experienced in using various transformations in Informatica and

building the Data-marts.

. Excellent Domain Knowledge in Retail markets.

. Excellent inter-personal and communication skills

. Strong team player.

Certifications

. Teradata Basic V12 Exam for Teradata Certified Professional Program

. Retail Domain certified by Infosys

Educational Details

Bachelor of Engineering in Computer Science & Information Technology from

JNTU University, Hyderabad, India.

Technical Skills:

Technologies IBM MAINFRAME, DATAWARE HOUSE, UNIX

Languages COBOL, JCL, CICS, IMS-DC

Databases TERADATA, DB2, VSAM

Utilities/Tools BTEQ, FASTLOAD, MLOAD, QUERY MAN,TSO/ISPF, SPUFI,

ENDEAVOR, FILE-AID, FILE-MANAGER, XPEDITER, CLIST,

ABEND-AID, CHANGE Man, SYNCSORT, INFOMAN, CA7,,

MICROSOFT OFFICE SUITE, EXCEL, OUTLOOK,

POWERPOINT, VISIO, REMEDY, INFORMATICA

Operating Systems OS/390, MVS/ESA, Windows 2000, Windows

XP/ME/98/95, Unix

File Organization VSAM, PS, PDS, GDG

Online/GUI Tools IMS/DC, TELON, ADSO

Professional Experience

During my services, at Infosys Technologies Ltd, I was offered both

offshore& onsite assignments at various leading US companies as Software

Developer and as Programmer Analyst.

. Best buy, MN, USA Specialty retailer of consumer electronics in US

(Jun 2011 - Till date)

. Wal-Mart, AR, USA World's Largest Retail Industry in US (Sep 2009 -

May 2011)

. American Presidential Lines, CA, USA One of the leading shipping

corporation in US (Sep 2008 - Aug 2009)

. BNSF Railways, TX, USA one of the leading railroad industry in US

(July 2005 - Aug 2008)

Detailed Description of Projects & Assignments:

Client: Best Buy

Duration: Jun 2011 - Till date

Role: Teradata Lead

Project: Gross Margin Erosion (EBI)

Gross margin erosion (GMR) is a part of Best buy enterprise business

intelligence which provides the complete details about profits and erosions

on particular sales transactions to the business users. Here the various

types of discounts, price-matches, Promotions, Clearances given by Best

buy at item level are pulled and used in calculating the profits and

erosions. These values are categorized as controllable and uncontrollable

erosion buckets and used by business users in taking business decisions to

improve the sales.

Responsibilities:

. Worked as a Teradata senior consultant and leaded the team from

onsite.

. As part of this project we introduced new erosion buckets and

improved the performance of existing process.

. Responsible for guiding and reviewing the design, development and

Implementation.

. Interacted with business users and solved real time issues.

. Improved performance and query tuning of existing system.

. Designed the complete testing procedure in order to provide accurate

values to the business.

Environment:

Languages: UNIX

Utilities/Tools: QUERY MAN, Teradata Manager, Teradata

Utilities (BTEQ, MLOAD, Fast

Export), Informatica.

Databases: Teradata

Client: Wal-Mart

Duration: SEP 2009 - MAY 2011

Role: Programmer Analyst

Project: People Systems Operations

People System operations involves maintenance and enhancement of

applications like Career planning and recruitment, Gain, Time and

attendance, Employee training and Development which is used across the Wal-

Mart stores and DC's. However the data from these applications are stored

in Teradata and is shared across globally to the business users as well as

to other applications in the system for running the business smoothly. The

data from all the stores and DC's are Extracted, Transformed into required

format and loaded into the Data warehouse (Teradata) through hourly jobs

and nightly jobs.

Responsibilities:

. Involved completely in Project Life cycle.

. Understand the business needs, business requirements and the data

warehouse schema to test the data loads.

. Implemented documentation process in the project - Test Strategy Doc,

Test Plan, Test Evaluation Summary Doc.

. Designed Quality Assurance process to meet the desired quality in the

deliverables and accuracy in the testing.

. Provided Production support and handled well in resolving the issues

based on severity.

. Performed Wal-Mart, SAMS, DC's monthly and quarterly financial

loadings which are used in calculating the quarterly and yearly

incentives.

. Complete knowledge on the data flow between Lawson to PeopleSoft and

Lawson to HRDW.

. Received client appreciation for resolving the data issues between

Lawson-HRDW-PeopleSoft which in turn fixed the year end incentives

calculation.

. Experience in handling the HRDW access requests.

. Performed weekly, monthly database archives/purging improve

performance and space management.

. Experience in 24/7 support

Environment:

Languages: COBOL, JCL

Utilities/Tools: QUERYMAN, BTEQ, FASTLOAD, MLOAD TSO/ISPF, SPUFI,

FILE-AID, LIBRARIAN, SYNC SORT, CA7,

REMEDY.

Databases: TERADATA, DB2, Lawson and PeopleSoft

Client: American Presidential Lines (APL)

Duration: SEP 2008 - AUG 2009

Role: ETL Designer and ETL Developer

Project: Finance and Liner Applications

Finance:

This project involves calculations of amount spent on day to day

shipping orders, Amount received and this data is used for budget

calculations based on the Market, Region. Also this involves generation of

reports on revenue analysis, Budget Vs Actual.

Liner:

This application involves automatic vessel schedules, cargo and

container management, customer priority calculation based on business rules

that are used while booking the orders.

Responsibilities:

. Responsible for guiding and reviewing the design, development and

implementation of various releases for the application based on the

service-oriented architecture.

. Involved in developing and testing of various service routines which

are reusable.

. Worked on both online and batch applications development and testing.

. Created interfaces to share data between Mainframe and UNIX

environments.

. Writing and Reviewing Cobol/DB2 as well as JCL and TERDATA code from

scratch and report generations.

. Involved in Unit testing and Integration Testing.

. Provided Production support and handled well in resolving the issues

based on severity.

. Performed weekly, monthly database archives/purging improve

performance and space management.

. Provide first level user/operational support, trouble shoot

application/database issues; assisting QA/testing team in their test

of enhancements and new functionalities.

. Worked on automation and performance of mainframe batch jobs.

. Task allocation, monitoring & successful completion within the team.

. Maintained/Documented all application issues, actions taken and their

resolutions and reused in day to day repeated issues.

Environment:

Languages: COBOL, JCL

Utilities/Tools: QUERYMAN, BTEQ, FASTLOAD, MLOAD TSO/ISPF, SPUFI,

FILE-AID, ABEND-AID, ENDEAVOR, SYNC

SORT, CA7.

Databases: TERADATA, DB2, VSAM, IDMS

Client: Burlington Northern Santafe Railroad

Duration: JUL 2007 - AUG 2008

Role: ETL Designer and ETL Developer

Project: Systematic Marketing Analysis and Reporting Tool (SMART)

SMART is used by the Marketing managers and Forecasting directors for

planning and forecasting the marketing revenue and units in BNSF railway.

Scopes of this project includes creation of a data mart for marketing

department and utilizes that for the Forecasting and Analysis. The project

has been executed in the Waterfall model with onsite and offshore

developments. The system has inputs from Main frame files; files located in

UNIX server and separate data marts. Different ETL technologies used in the

system include BTEQ, Multiload, and Fast Export.

Responsibilities:

. Involved completely in all stages of project life cycle.

. Estimation of effort and time and scheduling of resources

. Database design and consultation with logical and physical DBA's

. Design and development of JCLs, BTEQ, MLOAD and Fast export scripts

. Automated BTEQ reports creation and emailing to users

. Scheduling the batch jobs in CA-7

. Support the system in Production environment

Environment:

Languages: COBOL, JCL

Utilities/Tools: TSO/ISPF, QUERY MAN, Teradata Manager, Teradata

Utilities (BTEQ, MLOAD, Fast Export)

FILE-MANAGER,

XPEDITER, ABEND-AID, CHANGE Man,

SYNC SORT,

INFOMAN, CA7

Databases: Teradata, DB2, VSAM,

Client: Burlington Northern Santafe Railroad

Duration: AUG 2006 - JUN 2007

Role: Programmer Analyst / Team Lead

Project: REFERENCE FILES

The responsibility of Reference files includes Build, Maintain and provides

easy access to a central repository of corporate and industry carrier data

meeting the needs of BNSF's applications and end users.

In a nut shell, Reference files are single source of industry data. It

Enforces Industry Compliance, Allows manual maintenance of data and Allows

applications to access the industry data.

Responsibilities:

. Involved in design, Coding and testing of EMIS application which is

the central repository for all railroads and all BNSF applications.

. Designed Sequence & Class Diagrams for representing end-to-end

functioning of different modules.

. Involved in all phases of conversion of existing system to EMIS.

. Developed a central service system basically a data mart from which

data can be accessed by both JAVA and Mainframe environments in

secured way.

. Involved in Coding, unit testing and integration testing of the

application.

. Design and development of JCLs, BTEQ, MLOAD and Fast export scripts

. Developed reusable BTEQ scripts which is used in creating various

weekly and monthly reports.

. Developed reusable service programs which are used at various

applications.

. Developed mapping document which contains the mapping of source and

target systems.

. Interacted with business users and solved real time issues.

. Improved performance and query tuning of existing system.

. Received "BEST PERFORMER" for my technical and business skills.

Environment:

Languages: COBOL, JCL

Utilities/Tools: TSO/ISPF, QUERY MAN, Teradata Manager, Teradata

Utilities (BTEQ, MLOAD, Fast Export)

FILE-MANAGER,

XPEDITER, ABEND-AID, CHANGE Man,

SYNC SORT,

INFOMAN, CA7

Databases: Teradata, DB2, VSAM,

Client: Burlington Northern Santafe Railroad

Duration: JAN 2006 - JUL 2006

Role: Programmer Analyst / Team Lead

Project: CAR ACCOUNTING SYSTEM

The System for Car Accounting comprises the functionalities of Capturing,

billing and collecting all revenues associated to equipment car hire. The

overall responsibility of the system is to ensure accurate rating mileage

payouts for all private line car hire shipments

a) When non BNSF equipment runs on BNSF railroad, BNSF pays car-hire to the

other railroad and vice versa.

b) Car Accounting System mainly deals in maintaining payable and receivable

car-hire details. Car Hire payments are mainly regulated with a monthly AAR

exchange tape process between the railroads.

Responsibilities:

. Involved in all stages of project life cycle.

. Improved the performance of batch applications which increased the

fixing of freight claims.

. Developed new freight claims fixing online screens in TELON and

decreased the time frame in solving the freight claims.

. Improved the existing system performance by performance tuning and

there by increased the revenues to the BNSF.

. Involved in all phases of testing

Environment:

Languages: COBOL, JCL, IMS-DC, REXX

Utilities/Tools: TSO/ISPF, SPUFI, TELON, FILE-MANAGER, XPEDITER,

CLIST, REXX, ABEND-AID, CHANGE Man,

SYNC

SORT, INFOMAN, CA7,

Databases: DB2, VSAM

Client: Burlington Northern Santafe Railroad

Duration: JUL 2005 - DEC 2005

Role: Software Engineer

Project: INTERLINE SWITCHING ACCOUNT

Interline Switch Accounting (ISA) determines settlement amounts for

interline switch events. Interline switch events are car movements from one

railroad to another delivering the cars to or from a customer or between

carriers. ISA calculates the foreign line amounts due to BNSF and verifies

the BNSF amounts due to foreign lines.

The Switch Accounting department uses ISA to enter and maintain billing

information. The Marketing department uses ISA to enter and maintain

industry and rate information.

ISA provides a common database that allows you to inquire, create, and

maintain the following:

Operations Information, such as the Location ID, Industry and Road Serving,

Billing Rate Information.

Responsibilities:

. Developed new switching screens which are flexible in usage to the

users.

. Involved in analysis, coding and testing of all the modules.

. Improved the performance of the existing batch process and there by

improved overall performance of application.

. Received "Best performer" award for technical and testing skills.

. Involved in training of junior developers.

Environment:

Languages: COBOL, JCL, IMS-DC, REXX

Utilities/Tools: TSO/ISPF, SPUFI, TELON, FILE-MANAGER, XPEDITER,

CLIST, REXX, ABEND-AID, CHANGE Man,

SYNC

SORT, INFOMAN, CA7,

Databases: DB2, VSAM

Contact this candidate