Developer/Analyst

Objective:

Seeking a challenging position to best utilize my skill sets and provide the best results for the company.

Professional Summary:

Experience in Essbase, Hyperion Planning, Hyperion Financial Management, and Financial Data Quality Management. Includes configuration, business rules, interfaces, data validation and identifying anomalies in data.

Performed all types of testing for multiple applications and projects including unit testing, regression testing, integration testing and customer acceptance testing.

Knowledge in Scientific Engineering, Business Application Development, and relational database design

Knowledge of Visual Basic, Oracle (SQL*plus, PL/SQL, FORMS 4.5, Reports 2.5)

Interface with end users on all aspects of application and business process issues.

Experience:

General Motors Oct ’13 to May’18

Hyperion Support Analyst

*Addition of new entities, Accounts and update the rule changes based on the AOC change request.

*Updated all the data validation templates for forecast & actual which are used in the closing process.

*Perform enhancement of data forms, task flows and standard reports related to the application.

*Set up the security in oracle shared services for the applications.

*Perform mapping changes for accounts and entities in FDM.

*Data loading of Actuals from FDM on the trial balance day.

*Archive the current month data and prepare for next forecast.

*Work with internal team to gather information and evidence as required for SOX controls testing.

*Maintenance support and testing during software upgrades.

Tower International Sept ’12 to Sept’13

Hyperion Administrator

*Updated all the forecast and actual data load templates which are used in the loading data for trial balance process.

*Updated all the forecast templates and actual retrieve templates used in the closing process.

*Set up the security in oracle shared services for the new application HFM.

*Mapping of all accounts from QAD to HFM as per chart of Accounts.

*Load the Exchange Rates into HFM provided by Treasury department.

*Manual adjustments to forecasts, Actual as directed by Manager of Financial Planning.

*Locking and unlocking the actual and forecast categories in Hyperion based on Manager’s approval.

*The addition of new entities, Accounts and subaccounts based on the approval of the Corporate Controller.

*Preparation of next forecast issue based on current month forecast.

*Help Desk Support for Version 11 HFM and FDM applications

Ford Motor Company Oct ’09 to Dec ’11

Essbase Consultant

*Analyzing of any database issues.

*Enhancement of the existing application and generation of reports.

*Creation of different load rules required for various batch processes.

*Creation of various calc scripts based upon customer requirements.

*Modified the batch process of the application and Maxl script files.

*To restore the database as recovery process with SLA agreement.

*Maintenance support during server ITIO upgrades.

*Prepare the SCRP documentation during twice yearly for Sox applications.

*Help Desk Support for all essbase applications.

*Involved in unit testing, regression testing, integration testing and customer acceptance testing

when essbase application has been upgraded.

Chrysler Corporation May’07 to Jun’09

*Modified the Batch scripts, reports, calc scripts for loading IFRS files.

*Monthly enhancement of the existing applications.

*Syncing of actual data between the all essbase cubes using transition partitions.

*Maintenance of web menu options on the web portral.

*Maintenance and update of the excel VBA templates related to application.

*Monthly maintenance of partition files for various essbase applications.

*End user Support for all essbase application issues.

Ford Motor Company Aug ’00 to Sep ’04

Essbase Developer

*Analyzing of any database problems.

*Enhancement of the existing application and generation of reports.

*Creation of different load rules required for various batch processes.

*Creation of various calc scripts depending upon customer requirements.

*Modified the batch process of the application and esscmd script files.

*To restore the database as recovery process with SLA agreement.

*Maintenance of Ford Financial Credit Essbase website.

*Maintenance of partition files for PASPCPAR & PASCBG applications.

*Help Desk Support for all Essbase applications.

*Involved in unit testing, regression testing, integration testing and customer acceptance

testing during software and server upgrades.

Budd Company

Programmer Analyst Jan ’99 to May ‘00

*Enhancement of the existing application, template creation and generation of reports.

*Data files creation and preparation

*Responsible for system study and developing the application

*Created procedures, Indexes, Rules, Defaults and other Database objects.

*Developed GUI forms and coding the application.

*Testing the application.

Vinsai Software Consultants, Southfield, MI July ’96 to Dec ‘98

Programmer/Analyst

*Designed and developed the user interface for order and item-wise details.

*Written validation triggers, PL/SQL procedures.

*Created libraries for this application.

*Created programmatic generation of sequences.

*Developed user interface to process customer wise order details, invoice and payment transactions.

*Developed multi-block forms to review orders, payments and shipping details.

*Created validation and sequence triggers.

*Developed an user interface with MS Access 2.0 to generate reports for another client.

Education:

*Master’s Degree in Science with distinction from India.

Computer Skills:

OLAP Tools Hyperion Essbase 5.x, 7.x, 11.x, Hyperion Planning, Hyperion Reports

Hyperion Web Forms. Hyperion EAS 7.1.5, 9.3.3, 11.1.3, Hyperion Enterprise 6.5.1.1, HFM, Oracle Hyperion Financial Management (FDM) 9.3.3, 11.1.1.3

Languages: ESSCMD, CALC SCRIPTS, REPORT SCRIPTS, PERL, JAVA, C, PL/SQL, SQL, MAXL, HTML, SHELL SCRIPTING

Tools and Packages SQL*Plus, Forms 4.5, Reports 2.5

Database Excel 2000, Oracle 7x

GUI Visual Basic 6.0, MS Access 2.0

Operating Systems Solaris 2.5, Windows NT 4.0, Windows 2000, windows server 2008

Unix, MS DOS

Platforms Sun sparc server/ Workstations IBM RS6000, IBM compatibles.

Other Tools Visual Source Safe, SoftCM, Exceed, Frontpage, Control IT(RP32)

Contact this candidate