Project Data

R s u m

Bhavesh Patel

***** ****** **** **, *** # 913, Austin, Tx 78753. Ph- 512-***-****. Email:

abhhs5@r.postjobfree.com

Objective: Provide professional Business/Data Analyst expertise to assist

you achieve successful completions with a winning attitude of cooperation

Academic Record

Graduate Education: The University of Texas at Arlington, Master of City

Planning

Undergraduate Education: CEPT University (India), Bachelors of Technology

(Civil-Construction)

Diploma in (PPM) Project Planning and Management using Primavera Project

Planner 6.0 certification

Technical Expertise

. Infor ERP (Enterprise Resource Planning) Syteline V 8.01.00 software

Cross-function (data collection, modification, leveling, interpretation,

upload, change, remove, and export), engineering modules, customer

service, IT (data administration), materials and production modules

. Project Management Tools (Primavera Enterprise 6.0, MS Project 2007)

Primavera 6.0 certified, create project CPM baseline with WBS

task/resource data, create activity coding for various reporting and

analysis resource assignment and leveling, look ahead, assign baseline,

issues and thresholds period report, estimating the cost of the project,

updating the project progress & comparing the actual progress with

baseline CPM risk analysis, analyzing Earned Value Management (EVM),

creation of Methodology Management, Database Management and Storage

. Oracle 10g DBA Certification (Basic)

Creating a database, use of SQL, managing the database instance, managing

tablespaces, datafiles, tables and indexes, creating views and sequences,

managing users and security monitoring performance loading and unloading,

data managing, undo data, backup & recovery reports

. MS Office 2010

MS Word, Power Point, Access and Advance Excel including Vlookup, advance

filter, conditional formatting, hyperlinks, pivot table, what if

analysis, macro, VB, add-ins, import, export, database query, analysis

with using formulas, custom short, remove duplicates

MS Visio for organizational chart, a network diagram, or a business

process, MS Publisher and MS outlook

. SAP (Crystal Report v12.3, Interactive Analysis, Sales and Distribution

Module)

. Analytical Tools

Arc GIS Desktop 9x, Arc SDE server integration, Network Analyst, Business

Analyst and Spatial Analyst extensions

SPSS for Statistical Data Analysis (Multiple Regressions)

Professional Experience

Applied Materials/Adecco Technical

Assistant Planner/Analyst (05/2010 - 04/2011)

. Responsible for purchasing more than $300,000 semiconductor system parts,

interpreting bills of materials, quote requests with different vendors,

placing purchase orders, tracking and scheduling delivery

. Performed system administration work in implementation of Infor ERP

SyteLine, an advanced enterprise resource planning (ERP) solution working

with IT consultant, database configuration, project integration,

datafile import/export, assigning report format, helped in software GUI

troubleshooting with consultant

. Responsible for governing and uploading more than 100,000 line item data

in ERP Syteline form Excel and Access database through creating Excel

Macro and Access query, data mapping, converting BOM structure as per the

change requirement

. Assigning roles and privileges to individuals also involved on test run

and problem solving process

. Using Oracle BOM, Oracle ECO, PDM, Oracle P/C Planner & Teamcenter

Applications for interpretation of BOM structure and current and future

demands

. Preparation of project deadlines, milestones and manufacturing schedules

. Preparation of Enterprise Resource Planning Software training documents

and guidelines for end users

. Conducting meetings with suppliers and consultants

. Lotus Notes V 8.5 for communications

Roots Engineers /Planners (P) Ltd

Planning Consultant (10/2009 - 04/2010)

. Involved in feasibility study of Integrated Public Transit System in

India using Primavera Project Planner, Advance MS Excel and Oracle

applications

. Responsible for data collection from survey, data storage and management,

normalization, data interpretation, data matrix analysis

. Involved in analyzing other operations such as preparation of model

choice, model test for the future performance, preparing testing and

evaluation methodology, best practices, cost benefit analysis, report

preparation and presentation also, prepare complex process and systems

improvement recommendations that assist in achieving its goals and

objectives

Mehta & Associates Inc

Engineering Inspector (07/2007 - 11/2008)

. Supervised and Inspected $14 million project of construction of State

Highway in Pensacola, Florida

. Responsible for various tasks including quantity survey, estimation and

preparation of daily and monthly report

. Co-ordination with sub-contractors, state agency for work progress and

reporting

The University of Texas at Arlington

Research Assistant (05/2006 - 12/2006)

. Worked on Texas Department of Transportation Project of finding

relationship between built environment and travel behavior in

metropolitan areas of Dallas-Fort Worth and Houston-Galveston

. Responsible for analyzing public survey data, data collection from

Environmental Protection Agency, US Census Bureau, data filtration and

leveling, intersection geo-coding, editing, spatial join-relate,

preparing geo-data base, GIS maps, flow charts, process charts,

preparations and data analysis and interpretations

Major Analytical Projects during Masters

To implement a new Public Transit System

Study focused on impact analysis of changing behavior of new and existing

businesses within the city

The processes includes data collection from different government and non-

government organizations also from public survey . evaluation of existing

issues . data editing . data organizing . leveling . and filtration of

data to use for analysis including report preparation and presentation .

worked with city officials and other planning agencies

Retail Business Trend Analysis

A Performance Evaluation of Retail Businesses . population growth

analysis and forecasting . data collection of annual retail sales from

Business Data USA . business locations . business size and type . types

employments

Analysis methods include Geographic Information Systems application,

excel and access database . preparation of interactive graphs and report

including presentation

Suitability analysis for New Business

Collection of monthly sales receipts and revenue data of local business .

identifying available use of surrounding amenities . analyzing existing

business conditions and change behavior . suitable location analysis .

forecast future business growth and potential with existing and proposed

land use . statistical analysis include application of SPSS software, MS

excel and Access data . preparation of graphical reports and presentation

Reference will be provided on request

Contact this candidate