Engineer Project

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

MANIKYAM S. NAKKA Plainsboro, NJ 08536-4303

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

SUMMARY

. Fourteen years of IT experience with eight years in analysis, design,

development, testing, implementation of applications using

Client/Server technology; Online Analytical Processing (OLAP) systems,

Multi-Dimensional Databases and its reporting tools using Hyperion

Essbase OLAP Engine.

. Extensive experience in Hyperion Planning, web forms, business rules,

Hyperion reports/ Financial Reporting, Analyzer/ Web analysis, MDM

with major interfaces.

. Developed business value solutions using Hyperion Planning for

customers.

. Experience in both BSO and ASO technologies of Essbase

. Create/Review project plans and provide timely feedback and direction.

. Experience in whole System 9 Hyperion tool set and better

understanding of the technical architecture and integration between

the products.

. Extensive experience in accounting (with 35 credits).

. Strong experience with Essbase calculation and report scripting.

. Extensive experience in Essbase load rules and overall system

architecture.

. Extensive experience with Essbase administrative activities such as

database backups, recovery, optimization and performance tuning.

. Good experience in all phases of development including defining user

acceptance criteria, developing plans/scripts, documenting expected

results, execution of scripts, validating actual results.

. Excellent communication, interpersonal, written, analytical and

problem solving skills.

. Effective Team Player and an individual contributor with steep

learning curve.

. Experience in upgrade of Hyperion tools set from pre System 9 version

to latest System 9 versions 9.3.1, System 11 (11.1.1.3)

. Excellent Business knowledge in Finance, Accounting, Budgeting and

worked on EPMA.

. Expertise in Building Financial Budgeting and Forecasting OLAP

applications with Hyperion Planning/Essbase. MDM with several

interfaces as per business requirement.

EDUCATION

Masters Degree in Commerce

Post Graduate Diploma in Computer Applications

Web Authorship and Development Certificate

NJIT, NJ

CERTIFICATIONS

. Oracle Certified Hyperion Essbase Analytics 9.3 Developer

. Certified Associate of All India Institute of Bankers

. Test Director Certification from Qwest Comm. International, Denver,

CO.

TECHNICAL SKILLS

. Languages: C, SQL, PL/SQL, COBOL, MaxL, ESSCMD

. OLAP Tools: Hyperion System 9, BPMA, Hyperion Essbase 6.x/7.x, EIS

7.x, Hyperion Planning 3.x/9.x, HFM. FDM, DRM and ODI

. Reporting Tools: BI+, Hyperion Reports 7.x, Hyperion Analyzer 7.x,

Excel Add-In, SmartView, WebAnalysis, Financial Reporting

. G U I: Visual Basic 5.0/6.0 Developer 2000

. Database: Oracle 9.x /10.x and M S Access

. Testing Tools: SQA Suite, WinRunner, LoadRunner

. Operating System: Unix, Windows 95/98 and Windows NT

. Hardware: Intel486, Pentium, Pentium II, IV & all IBM compatibles

EXPERIENCE

Accenture, LLC (US) - Atlanta DCN

04/2012 to Present

Sr. Systems Analyst

. Currently working on Fannie Mae Project at Atlanta Delivery Center

. To support and create MDX and Calculations Scripts for the ASO and

BSO technologies of Hyperion Essbase.

. Creation of Data load/dimensional member load rules and to support

the business users

. Testing of Outline and MDX/Calculation Scripts as per the

requirement from time to time.

. Developed Batch files using MAXL, PERL,ESSCMD's and Rules files to

upload data from sources systems to Essbase cubes

. Essbase spreadsheet add-in and Smartview are being used for report

creation/testing etc.

. Responsibilities included developing and optimizing outlines,

calculation scripting, rule files creation, data load and

extraction, data testing, data integrity validation and database

settings optimization.

. Working on Web form creation for Hyperion Planning and to support

Hyperion planning application.

Prior to the above, worked on Ascension Health Care Project (at St. Louis);

Interfaces' Document for the Hyperion Planning for automating Data loads

through ODI was studied Documented.

Savannah River Nuclear Solutions

Aiken, SC (srs.gov)

01/2012 to 03/2012

Principal Software Engineer:

. Project Summary: This project is to track and maintain the

different projects of DOE (Department of Energy) at every stage of

completion. Work Breakdown Structure (WBS) will track the minute

details of expenditure incurred on several projects/types under

various Business entities.

Role and Responsibilities:

. Gathered the requirements from the Business users and financial

heads including PS maintenance group and documented.

. As Hyperion Essbase and Planning Administrator created new ASO/BSO

cubes with required number of dimensions.

. User access profiles in Shared services and EAS maintained.

. Data interface is through PeopleSoft application. Using TOAD (Quest

Tool for SQL/PL/SQL) generating data files for the dimensions and

data.

. Using ODI (Oracle Data Integrator) ETL/E-LT toll for automating the

data load process in due course replacing the current manual load.

. Guiding the Corporate and business users in installing and

configuring Smart view (11.1.1.3) on their main system.

. Providing production Support and tracking and resolving application

level/user level issues from time to time.

Environment - Hyperion 11.1.1.3, (Essbase and Planning), Lotus Notes

8.6, Oracle 11g, Windows XP, Quest Toad 10.6 and MS office tools and

PeopleSoft.

Hilton Worldwide

Memphis, TN

02/2011 to 12/2011

SST Finance Project Consultant:

. Project Summary: Hotel Level Finance and Forecast System (HLBFS) -

Provided support to the User community all across globe.

. Hilton inhouse developed tool Single Source of Truth (SST)

validated from time to time by sourcing data from PS

. Various maintenance tasks involved in maintaining the tasks

rendered at a world class hotel setting are maintained through

inhouse tool OnQ, which is multi functional and tasking tool.

. Provided timely and much needed help and access provided to the

users at Hotel level and users in the Corporate offices.

. This Finance and Forecasting project helps users to track their

reporting requirements such as daily, weekly and Monthly besides

Final Statements required by governmental agencies etc.

. Essbase outline updating and moving to production from time to time

. Worked with the IT and other team members during the maintenance

window, three times of the day.

.

Role and Responsibilities:

. As Hyperion Essbase Administration maintaied user access profiles

and production support from time to time.

. Data interface is through PeopleSoft applications. Guiding users

from all across the globe to access HLBFS (Hotel Level Budgeting

and Forecasting systems) etc.

. Involved in Actuals/Forecast data loading process for domectic and

International Hotels on monthly basis.

. Guided the Corporate and large Hotels in installing and configuring

Essbase tool (9.3.1) on their main system.

. Totally restructured the entire European Region Hotels in the

Outline as per the revised classification and market segments.

. Calculation Scripts of varied tasks in the financial sector;

created/edited to meet the requirements of the users in Essbase.

Environment - Hyperion 9.3.1, (Essbase and Planning), Oracle 10g,

Windows 7, Hilton created Tool OnQ for helping the Business and

Corporate users for rendering various tasks. MS Office tools etc.

Aetna Inc, Hartford, CT

02/2009 - 01/2011

Sr. Application Developer

. Project Summary: Worked as Sr. Application Developer (Hyperion) - The

project was to design and implement Hyperion Application for Financial

Performance and Operating Expense Analysis and Reporting.

. Windows scheduler was used for Batch processing and execution of

Essbase scripts to automate Outline updating and data loading to

Essbase database. Hyperion Report and Essbase Excel add-ins were used

for reporting and analysis. Due to the presence of more dimensions

using ASO cube as data mart and at a pre-determined intervals,

exporting data to EMIS for use by Executives and higher officials in

the hierarchy.

. Created Report Scripts for transferring data from ASO cube to EMIS

system for the current and plus four years of forecast data in the

given format. Project document and relevant TCs were prepared and

trained users. Research on ODI was made for getting data to view with

Level0 members of all the thirteen Dimensions.

. Worked on Hyperion Financial Data Quality Management (FDM) for

extraction, Transformation and loading of data (ETL) with multiple

ledgers to HFM, Essbase etc.

. DRM - is used in Hyperion Planning implementation at the

organizational level. Consistent hierarchy structures across

applications was achieved using - Hyperion Data Relationship

Management (DRM)

Role & Responsibilities:

. Requirement gathering from Business Analysts users and PWC team

(Designating team)

. Designed, developed, and implemented reporting framework and

applications using Hyperion Essbase. Aetna Planning, Budgeting and

Forecasting Project.

. Development of Essbase components Load rules for actual and other data

loads, setting up substitution variables

. Involved in creating calc scripts, generating report scripts as per

the fortmat specified for exporting to EMIS system.

. Generated reports using Excel add-in. Cube Optimization and

performance tuning was done in QA environment.

. Generated level zero data files from the Aetnaplan, Reporting and

Membership cubes for taking daily back-ups using Maxl statements.

. Extensively worked with Hyperion Reports to produce the consolidation

reports, financial planning and analysis reports for management.

. Participated in Hyperion CRs resolution weekly meetings.

. Conducted and Involved in the requirements and design documents review

and updating meetings to meet the current requirements.

. Executed test cases for manual testing and documentation of the whole

process is done and test scripts stored in CC. Unit test for all the

dimensions/members with and without data executed and test script

created besides Stress test on server for retrieving more than 2.7

million records in less than 5 minutes of retrieval time.

. Environment: Hyperion Essbase 9.3.1/7.1.5, Hyperion Planning 9.x,

Hyperion Shared Services, Hyperion Reports 7.0, Financial Reporting,

Web Analysis, EIS 7.1.2, Excel Add-In, Unix, Windows NT 4.0, Perl,

Oracle 10g, HAL,ODI.

Merrill Lynch, Hopewell, NJ

07/2006 - 01/2009

Hyperion/Essbase Developer (Consultant)

. Project Summary: Worked as Hyperion/Essbase Developer (Consultant)

Merrill Lynch operated nine different Oracle instances globally.

Eight were considered regional General Ledgers (GL) and one served as

a Consolidating General Ledger. Due to the instance separation, each

region had developed its own reporting structure, reports and in some

cases its own reporting tools. With the FDW (Financial Data

Warehouse) initiative, the US and Regional instances were upgraded to

Oracle 11i and shared a global chart of accounts. As a result, the

opportunity existed to consolidate the various reporting solutions and

standardize reporting formats across regions through Hyperion

Products.

Role & Responsibilities:

. Involved in Production & Design of Financial and Management Reporting

Application. Involved in Consulting with users/Clients on database

enhancements, maintenance, analytics and reporting.

. Actively involved in migration and configuration of Hyperion 7.2

version to 9.3.1 for Planning and Essbase with other 2 team members.

. Involved in development of Legal Reporting /Management Reporting

cubes.

. Extensively involved in troubleshooting and managing 24/7 Production

support.

. Performance tuning & optimization of cubes for satisfying the users

reporting requirements.

. Error Handling, Trouble shooting, handling restructuring and server

problems.

. Involved in Migrations of databases from development servers to

QA/Production servers.

. Guide and determine suitable technical development of database

architecture for given functional requirements in collaboration with

system architects, Business Analysts and Designers.

. Security Maintenance: Maintaining users, user groups and access

securities for all the developers & end users depending on their

current privileges in Oracle GL.

. Automated monthly/annual PDF/Snapshot book generation, developed Excel

Templates for user interface in Essbase database.

. Web forms for data input for income statement accounts, balance sheet

accounts, drivers, stats accounts, and actual adjustments.

. Development of planning security.

Environment: Hyperion Essbase 9x/7.1.5/7.1.2/7.1, Hyperion Planning

9.x, Hyperion Shared Services, Hyperion Reports 7.0, Financial

Reporting, Web Analysis, EIS 7.1.2, Excel Add-In, IBM AIX, Autosys,

PVCS, Unix, Windows NT 4.0, Perl, Oracle 11i.

Novo Nordisk Inc, NJ

02/2003 - 06/2006

Hyperion/Essbase Developer

. Novo Nordisk is a healthcare company and a world leader in diabetes

and insulin Products. Novo Nordisk has a leading position within areas

such as haemostasis management, growth hormone therapy and hormone

replacement therapy. With headquarters in Denmark and branch locations

in 79 countries and markets its products in 179 countries. Novo

Nordisk has decided to move all of its existing legacy systems to SAP

applications which include reporting tools Hyperion Essbase, Analyzer,

Warehouse Builder, Query, and Report Writer.

Roles and Responsibilities:

. Designed complex outline formulas to satisfy the requirements of

conditional aggregations on some stat accounts, YTD and QTD

calculations, Allocations, etc.

. Involved in Migrations of databases from development servers to

QA/Production servers.

. Performed Essbase administration activities such as filter creation,

creation of users, of groups and maintenance of Essbase Servers.

. Extensively worked with Hyperion Reports to produce the consolidation

reports, financial planning and analysis reports for management.

. Supported/Involved in the maintenance and provisioning of security to

the 27 essbase applications used by the different internal departments

like Marketing, Sales etc.

. Regularly interacted with Analysts, Field Managers, Product Analysts,

Marketing Analysts and Business Analysts from the various departments.

. Involved in unit testing and the system testing for the essbase and

analyzer reports. As a part of the unit and system testing I was

involved in interacting with the end user.

. Modified the existing applications based on the user requirements.

. Created and modified the dimension build rules files, data load rules

files and calc scripts.

. Environment: Essbase 6.5.1/7x, Hyperion Planning 3.5, Hyperion

Reports 7, Excel Add-In, UNIX, Autosys, Windows NT, PVCS, Perl, and

Oracle 9i

Qwest Information Technologies, CO 12/2000

- 01/2003

QA Engineer/Team Lead

. Worked as QA Engineer/Team Lead on multiple applications of varied

business entities, including VRU (Voice Response Unit) applications.

Worked mainly on Forte-based application; designed for the NT 4.0

workstation. This application displays the information and

functionality from multiple systems in a single application. This

single application approach provides benefits to Mass Markets

relationships with both customers and Customer Contact Employees

(CCEs). Qwest TOAD was extensively used.

Responsibilities:

. Updated existing Test Cases.

. Wrote New Test cases to cover the enhancements in the application from

release to release. Attended TC review and finalization meeting.

. Running Test cases for System test and Integration test

. Checking to see the orders generated (New Connect, Change, T&F, Record

and Disconnect) are properly routed to SOPs (Service order Processor)

in the respective region, without any errors.

. Attended weekly and short notice meetings with developers. Discussed

with them before raising a CR or Failing an existing CR. Defects

(bugs) were reported in rationale corporation tool, Clear DDTS

(Document of Defect Tracking System).

. Assigned CRs, did Sanity test, wrote meeting minutes etc on a weekly

rotation basis.

. Interacted with (SMEs) Subject Matter Experts about the correctness or

otherwise of the generated service orders.

. Environment - Test Director, Win Runner, Hyperion Essbase, Java, C,

Sql, Visual Basic, UNIX, Window NT

Summit Bank, Dayton, NJ 12/1998

- 11/2000

Software Test Engineer

. I was working as Software Test engineer in Summit Bank, NJ, on a

banking application. This application is an Internet based

application. In this application the customers have a lot of

facilities for their personal accounts to apply for different kind of

loans, status check of Credit Cards etc. There are eight different

modules of this application for online banking.

Responsibilities:

. As QA team member, I was responsible for testing the entire online

application to meet the business requirements. I was actively

involved in writing Test plans, creating test scripts; Team co-

ordination, Training and interaction with development team were major

responsibilities. I was responsible for carrying out manual testing

like integration testing, Performance testing during the various

phases covering all the seven modules of the application. Defects were

resolved and application was deployed when it was error free. I was

responsible for submission of data to the server through various

modules of the application and verified for its accuracy.

. WinRunner testing tool was used for automation of testing like,

regression and performance testing.

. LoadRunner was used for testing the application by generating virtual

users interacting with the application at the same time.

. Environment: HTML, DHTML, ASP, JavaScript, Oracle, Windows 95/NT and

Unix.

Cover-All Technologies Inc., NJ 01/1998

- 11/1998

QA Engineer

. Worked as a QA Engineer on an application Total Administrative

Solutions (TAS2000). This application is system integrated, modular

package for the management of insurance business functions. TAS2000

offers an effective method of performing administrative and management

tasks.

. Responsible for writing detail test plans and test scripts and

executing them.

. Extensively used INTERSOLV PVCS Tracker, the system change request-

tracking tool to efficiently manage system change.

. Participated in team meetings for testing methodologies and discussed

the problems in the application.

. Created a cycle that tests the user interface of the application and

the application's performance under stress.

. Automated test cases using WinRunner.

. Created Batch Test using call statements and performed regression

test.

. Compared the current version of the application under test to its

behavior with an earlier version using GUI checkpoints, Bitmap

checkpoints, and Text checkpoints.

. New defects in the application are reported using the Remote Bug

Reporter form and imported the defect information into a TestDirector

database until they were fixed.

. Environment: Windows NT, Oracle, Developer/2000, WinRunner,

TestDirector, PVCS Tracker.

Invamed Inc., Dayton, NJ

11/1997 - 01/1998

QA Test Engineer

. Invamed Inc., is a pharmaceutical manufacturing company with branches

located in NJ and NY. The software consists of modules for Employee

Database, Vendors List Management, Inventory Management and Purchase

and Sales orders. It supports 1000 employees, 500 vendors.

Software was tested for the following features:

. Graphical User Interface for different forms written in Visual Basic.

. Updating vendors list.

. Inventory updating for both purchases and sales.

. Assets and Liabilities Management.

. Payroll operations.

. Integrity of central database with updation capability at different

branches.

. Generated automation scripts using SQA Robot for regression testing

and stress testing.

. Environment: Database: Oracle, Platform: Windows NT, Front-End: Visual

Basic

Contact this candidate