Engineer Customer Service

VATSAL SHAH

Boston MA

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

Phone: 607-***-****

Technical Summary:

Hyperion Suites – Hyperion Essbase 11.1.2, Hyperion Planning 11.1.2, HBR (Business Rules), Hyperion Financial Reporting, Web Analysis, Essbase Spread Sheet Add-in and SmartView

Database: Essbase, SQL Server.

MATLAB Toolboxes – Math, Statistics and Optimization, Test and Measurement, Computational Finance, MATLAB Compiler, MATLAB Builder EX, Image Processing and Database.

Languages: C, C++, Visual C++, Linux, HTML, Visual Basic and VB.Net.

Statistical Packages: JMP, Minitab R15/R14/ R13, SAS, and STATA.

Modeling and Analysis Software: Arena 7.0, CimLITE Quality Simulator and MAPICS system.

Desktop Applications: Microsoft Word, Excel, PowerPoint, Access, Visio, Project.

Design Tools: Solid Works, LABVIEW and AutoCAD

Work Experience:

Federal Reserve Bank of St. Louis, St. Louis, MO July 2010 – Dec 2011

Planning and Forecasting Consultant

• Responsible for installation of all Hyperion products. Developed installation guides and procedures for internal use.

• Researched new requirements, collaboratively, with FP&A Directors, Managers and Analysts.

• Provided hands-on design and implementation/development forecasting application in Hyperion Planning.

• Performed detail analysis of historical data that would be used to populate dimensions and members.

• Implemented and supported the forecasting application in Hyperion Planning.

• Created integrations to build the planning dimensional hierarchies using Outline Load Utility.

• Built complex Business Rules, fine tuned them and attached to planning web forms.

• Developed and implemented the security model via Shared Services and planning security system.

• Created calc scripts to perform complex statistical calculations on data reported in various financial systems.

• Developed a web based front end for access to the financial reports.

• Retrieved reports using SmartView and Financial Reports.

• Designed and developed GUI interface using MATLAB for the financial models.

• Provided support for problem identification and resolution for issues related to Essbase, Planning and user security.

Milara Inc., Medway, MA Jan 2010 – Jun 2010

Sr.Applications Engineer

• Designed and created new cubes in Essbase for Sales Forecasting applications using attributes and shared hierarchies across ASO and BSO partitions.

• Developed reports using Hyperion Analyzer and Hyperion Reports.

• Responsible for developing, analyzing and testing processes for wide range of applications using MATLAB, Minitab and SAS.

• Responsible for providing process inputs to optimize productivity to internal and external customers.

• Developed a step-by-step procedure for documenting the acceptance testing protocols.

• Used MATLAB Statistics and Data Analysis to perform Statistical analysis to enhance base of machine performance.

• Worked with the hardware team to develop machine control simulation using MATLAB.

IDS Imaging Development Systems Inc., Woburn, MA Apr 2009 – Dec 2009

Applications Engineer

• Conducted intensive research about Hyperion suites of products.

• Updated forms for the purpose of inputting data for the Hyperion Cubes.

• Responsible for construction of test units for feasibility studies for customer requirements.

• Responsible for replication of customer problem scenarios and solutions thereof.

• Assisted customers in their software development during camera integration.

• Tasked with learning MATLAB’s Control System Design to assist with the programming of Linear Control motors.

• Developed applications using Visual Basic throughout the full life-cycle including testing and debugging code.

Speedline Technologies Inc., Franklin, MA Mar 2006 – Feb 2009

Advanced Process Development Engineer

• Developed completely new processes for emerging technologies.

• Designed and executed formal experiments and perform data analysis using MATLAB and Minitab.

• Developed computer simulation of an assembly line using MATLAB.

• Worked with Sales, Applications, Software and Manufacturing groups to customize the equipments based on customer requirements and processes.

• Developed vision testing procedures using MATLAB.

• Used MATLAB to automate the data collection of prototype machines.

• Created programs for formal training programs and implement the new process at customer sites.

• Developed applications using Visual Basic throughout the full life-cycle including testing and debugging code

• Developed and maintained SQL Server databases including design as well as creating stored procedures, triggers and scripts.

Integrated Electronics Engineering Center (IEEC), Binghamton, NY May 2004 – Jan 2006

Graduate Research Assistant

Project for Amphenol Aerospace Operations, Sidney, NY

• Reduced the set up time by implementing changes in the process.

• Used MATLAB 7.0, Minitab and Excel to estimate the content of tin mixed in the solution and its effect on reliability and quality of the joint.

Project for Analog Devices Inc., Boston, MA

• Determined the presence of solder on lid surface and in castellations after lid reflow process.

• Investigated and analyzed different conditions of reflow parameters and different combinations of die attach adhesives.

Project for Endicott Coil Company Inc., Binghamton, NY

• Developed an experimental procedure for determining the maximum operating temperature of the components in the control unit of a light fixture;

• Conducted time based analysis using MATLAB 7.0 on the components at different temperatures and different atmospheric conditions.

Bharati Cellular Ltd., Mumbai, India Sept 2002 – Jun 2003

Quality Assurance Engineer

• Worked with Quality Control Department to evaluate the performance of the customer service representatives;

• Used control charts to monitor their performances and identify performance improvement activities;

• Used design of experiments (DOE) to identify the factors affecting their performance.

Education:

Master of Science, Industrial and Systems Engineering

Binghamton University – SUNY, Binghamton, NY

Bachelor of Science, Electrical Engineering

Mumbai University, Mumbai, India

Contact this candidate