Project Management Customer Service

PREM REDDY SAMALA

***, ****** ***, **********, **, United States 203-***-**** ac2wsv@r.postjobfree.com

OBJECTIVE AND SUMMARY

To obtain an full time position as an Analyst, allowing me to utilize my education and experience while gaining valuable work experience in a team oriented environment.

EDUCATION

Master of Science: Engineering Management May 2016

University of New Haven - West Haven, CT

GPA : 3.8

Decision Making under Uncertainty

Project Management

Cost estimation and engineering economics

Applied statistics & Probability

Bachelor of Technology: Mechanical Engineering May 2014

CMR Engineering College – Hyderabad, India

GPA: 3.5

Programming

C, SQL, R

Drafting tools

AutoCAD, Solid works

Simulation tools

Rockwell Arena, Flexsim, Simio

Data tools

Excel, Minitab, TreeAge, Excel Macros, VBA, SQL SERVER

Reporting tool

Tableau, Excel Power Pivot

Packages

MS Office 2003/7/10/16(MS- Access, Excel, Word, Visio and Power Point) @Risk, @Crystal Ball

Project Management

Microsoft Project 2016

Operating Systems

Windows 10//8.1/8/7/Vista/XP/2000

TECHNICAL SKILLS

EXPERIENCE

Data Analyst - PVR America, Irving, TX

Extracting, manipulating, transforming, loading data using SQL developer, SSIS from RDBMS

proficient in developing complex stored procedures, triggers, tables, user functions, user profiles, relational database models and data integrity, SQL joins and query writing, Business intelligence ETL data mapping

Worked on Data Reporting using SSIS, Tableau, Excel dashboards, Power pivot, pivot tables, Control Charts, Data Quality using TALEND, Minitab tools .

Discrete event Simulation Project (09/2015 – 12/2015)

Capstone Project - University of New Haven, CT

Man Power Requirement is a Process improvement Simulation project which is an imitation of real process in Business Store using Statistical Methods with cost effective analysis for better output reducing the cost and with maximum productivity and efficiency with optimal customer service.

Requirements gathering and data collection, analysis using Minitab and input analyzer for patterns and distributions, central tendency and variability

Created stochastic simulation models, modeled detailed operations of business and basic inputs using simulation software Rockwell Arena

Performed data visualization of process flow, Animated an advanced 2D model of operations, Running several simulations and analyzing results

Integrated results (WIP) work in progress using excel, scenario planning using process analyzer

Worked on optimal and feasible scenarios using Opt Quest tool to maximize the optimization objective function with maximum utilization of workers

Developed solution for store staffing model need at different times in business and reduce the Total cost by optimizing manpower

Masters Experience (2015 – 2016)

Six Sigma Quality Planning, Correlation, Lean principles, Capability index, SPC, DOE, quality control charts Cp, Cpk, Capacity planning, Running Macros, Visual basic for Application (VBA)

Time and motion studies, Queuing theory, Normalization and Hypothesis testing

Decision Making under Uncertainty

Developed simulation models using @Risk in excel, Risk analysis, probability analysis for sales forecast and New product Development

Used @Crystal ball tool for Predictive Modeling in financial Modeling and Monte Carlo simulation, markov, Decision tress using TreeAge

Performed decision analytic Regression analysis (ANOVA), linear optimization, multiple regression analysis, Normalization and Hypothesis testing, Utility theory

Engineering economic Analysis and Cost estimation

Financial investment analysis, IRR, ROR, NPV, Statistical analysis for evaluating alternatives and reliability analysis

Worked on Annual, present, future worth Analysis, project Life cycle estimation

Risk Analysis, break even, sensitivity analysis, Inflation effects and after Tax effects, risk and uncertainty in project outcomes, comparing alternative projects

Project Management

Creating Task based tracking Gantt Work breakdown structure with MS Project

Scheduling Resources and assigning with team planner without resource conflicts

Tracking progress and analyzing project statistics(budget, resources), critical path with baseline, Creating customized visual reports, sharing info on share point, excel

Contact this candidate