Pradeep Patel

e-mail : acowgh@r.postjobfree.com

** ******** ***

Sewell, NJ 08080

Cell # : 609-***-****

Legal Status: U.S. Citizen

Summary of Experience

Twenty seven years of experience in wide range of fields to include ETL Infomatica Development Strategies,

Product Management, Software Development, Data Analytics, Strategic Planning, Value Proposition Analysis,

Business Benefit Analysis of new products in rail freight and rail transit using several technologies such as

Oracle, Informatica, Microsoft Visual Basic, Excel, Access.

A self-starter with excellent problem solving skills and oral/written communication abilities

EDUCATION:

Masters in Industrial Engineering

University Of Houston, Houston, TX

Bachelors in Mechanical Engineering

Gujarat University, Ahmedabad, India

TECHNICAL SKILLS:

Informatica Power Center 9.1

Operating

MS Windows (7, XP, 2000, NT, 98), DOS

Systems:

Databases: Oracle (11g), Paradox, dbase III

Tools: SQL*Plus

PROFESSIONAL EXPERIENCE:

ETL Developer:

Preparation of technical specification for the development of Informatica (ETL) mappings to load

data into various tables in Data Marts.

Designed and Developed complex mappings to extract, transform, Load the data from Relational,

Flat files, Excel etc to Staging, Data warehouse and Datamarts.

Poduct Management:

Responsible for Business analysis and Technical Requirement gathering for Company’s

Maintenance of Way Information Systems

Served as the primary point of contact between business and technical staff at all level

Data Analyst:

Developed regression models to support in decision making process for the Vice president of sales to

better utilize sales resources.

Designed and developed data collection and integration using SQL commands

Business Analyst/Programmer:

Responsible for the customer interviews and requirements gathering, translate requirements into

technical solutions, provided accurate time estimates for project deliverables

Developed several application software for the rail freight and transit customers

Responsible for the design development, implementation, and maintenance of custom system

software

Worked both independently and as part of a team to design, develop and deliver software solutions

Employment:

Harsco Rail

Cherry Hill, NJ, June 2007 – December, 2014

Project Manager

I. Value proposition analysis for Harsco Rail’s products and maintenance machine

Harsco Rail manufactures various railroad maintenance machines and measuring systems including

grinders, tampers, rail renewal machine, new track construction machine, telematics system, track

geometry systems, track inspection system.

Developed value proposition analysis models in user friendly excel spreadsheet formats by defining

several benefit factors and areas based on each systems for the Harsco customers.

Using Informatica Power Center designer 9.0.1, data was extracted from various sources like Flat

files, Oracle, Access and transformed using complex transformation and mappings and loaded to

targets like Flat files, Excel.

The parameters and variables were gathered and derived by utilizing several data resources from

safety data, sales data and product data.

These models help sold several multimillion dollars maintenance machines.

II. Development of Sales Forecasting models

In collaboration with sales team developed and implemented data collection systems and strategies

that optimized statistical efficiency and data quality

Applied statistical analysis and data mining to identify trends using several tools including Excel and

web based data extraction tools.

Generated reports and graphs for the presentation to the sales team.

III. Product Management of HARSCO RAIL's Maintenance of Way Information System(MOWIS):

Conducted User Acceptance Testing (UAT) to ensure all requirements are satisfied by the application

for several clients including Port Authority of NY and NJ(PATH), Port Authority Transit Corporation

(PATCO) and Toronto Transit Commission (TTC) transit systems

Supervised two programmers in Agile process methodology with two weeks iterations delivering

new features and working software at each iteration

Served as the primary point of contact between business and technical staff at all level

IV. West Africa Regional Rail Integration Project: USTDA sponsored for client UEMOA

As the Project Manager I was responsible for providing subject matter expert advice in simulation

analysis of heavy haul rail train operations and the use of those simulations models for projecting the

resulting operating railway company (enterprise) Income Statement pro forma estimates.

Utilized industry specific train simulation models and excel data spreadsheet to generate the various

graphs and reports.

These reports identified significant economic benefits from an increase in maximum axle loads for

heavy haul rail freight equipment upgrading for 23 ton axle load operation

As part of this $1 million Rail Feasibility project, results delivered showed improvements costs and

projected operating results for a 1,233 km long railway modernization between Dakar and Bamako.

In line with the client requests, results were projected as both meter gauge and standard gauge

designs.

Zeta-Tech Associates Inc. Cherry Hill, NJ, 1987 to 2007

Software Development Projects:

I. INTEGRATED RAILWAY REMOTE INFORMATION SERVICE (INTERRIS) Cost Model:

The Integrated Railroad Remote Information Service (InteRRIS) developed by Transportation

Technology Center created a data warehouse containing information from many railroad defect

detectors.

Using above data warehouse data I developed using Visual Basic a computer model that enabled

FRA to estimate the economic benefits of various types of wayside detectors linked in an

InteRRIS-type system

The model determined the economic benefits of the existing network of wheel impact load

detectors (WILD) and Truck Performance detectors (TPD) sites.

Development and Application of the Weighted System Average Cost model to Conrail’s

II.

AMTRAK Routes

Designed and developed WSAC model using engineering equation and multiple regression

models to calculate damage factors to help determine Maintenance of Way (MOW) costs for

AMTRAK trains and several heavy axle load freight trains.

Applied train simulation modeling and operations analysis to identify significant economic

benefits from an increase in maximum axle loads for heavy haul rail freight.

The model was developed in both Lotus and Excel applications using lotus macro and VBA.

Container Cost Model

III.

Container Cost model develops the variable costs for rail movement of ocean containers

between New York and Chicago for use in modal diversion studies.

It is use to develop variable cost and a “fully allocated” cost that reflects any necessary

capital investment to enable railroads to handle additional intermodal traffic

Contact this candidate