Sales Data

DEVANG RANA, ORACLE CERTIFIED HYPERION CONSULTANT

Oracle Certified Senior Hyperion Essbase Consultant with over 7 years of

Hands-on experience

Complete Hyperion End-to-end Project Delivery Techno-functional skills

Structured Analysis and Systems Design Approach

PROFILE

. Product Expertise - Hyperion Essbase, Oracle RDBMS, UNIX, C, C++,

Visual Basic, Fidelio (ERP)

. Domain Expertise - Data Warehousing, SQL Development, Quality

Assurance, Hardware and OS Configuration

. Functional Expertise - Finance, Sales, Production

. Industry Expertise - Electronics, Data Networking, Telemetric, Tourism

. Process Expertise - Software Development Life Cycle (SDLC), Rapid

Application Deployment (RAD)

. Project Roles - Senior Developer, Business Analyst, QA Lead

. Team player and capable of working independently, Resolve problems

creatively

. Proven Leadership skills, Multi-tasking, strong written and verbal

communication

TECHNICAL SKILL-SET

. Hyperion Essbase 6.2/6.5/7.1/ 9x, BSO, ASO, Load Rules, Calc Scripts,

Business Rules, MDX, Report Scripts, Esscmd, MaxL, SQL Interface, Essbase

Integration Services (EIS), Hyperion Application Link (HAL), Hyperion

Reports, Spreadsheet Add-in

. Oracle RDBMS, PL/SQL, TOAD, SQL Server 2005, MS Access

. C, C++, Visual Basic, Korn Shell Scripting, DOS scripting

. Solaris 10, Windows 2003 Server, Winrunner

MAJOR ASSIGNMENTS:

Par Pharmaceuticals (Woodcliff Lake, NJ) Apr 08

- Sep 09

Technical Environment: Hyperion Essbase 7.1.6/9.3, ASO, BSO, SQL Interface,

Load Rules, MDX, Calc Scripts, Report Scripts, MaxL, Spreadsheet Add-in,

Hyperion Reports, HAL, SQL 2005, Windows 2000

Application Details: Sales Analysis of Pharmaceutical Drugs, Finance

Analysis, Secondary Market Research Analysis related to Audits.

. Created new ASO cube for Secondary Market Research to analyze NPA,

NSP, IPS, NJA and NDTI audits from IMS data warehouse and another cube

to capture FDA, NDC and EOB data

. Cubes contain unusually high number of dimensions (17) and attribute

dimensions (13). Overall cube size -70 GB

. Use of stored and dynamic hierarchy to optimize data calculation and

retrieval time.

. Coordinate reporting needs between Generic Marketing, Branded

Marketing, Sales,Operations, Finance and Information Technology.

. Define requirements, refine scope and execute web interface for

budgeting/forecasting applications.

. Translate business requirements into technical requirements.

. Use new capabilities to enable fast turn around time for information

processing and dissemination of reports.

. Resolve data discrepancy issues.

. System test, User acceptance test.

. Received weekly and monthly data for various audits.

. Automate cube build processes using dos bat file by calling MaxL

scripts and using Windows scheduler to minimize manual processing.

. Validate data after cube build using Excel templates and SQL queries.

. Created views and temp tables on SQL server and used to develop dim

build and data loads using SQL interface.

. Developed SSIS packages to build tables from external web site flat

file source.

DAC Finance (Orlando, FL):

Jan 05 - Mar 08

Technical Environment: Hyperion Essbase 7.1.6, ASO, BSO, SQL Interface,

Load Rules, MDX, Calc Scripts, Report Scripts, MaxL, Spreadsheet Add-in,

Hyperion Reports, HAL, Oracle 9i, Solaris 10

Application Details: Sales Analysis, Finance Analysis, Tourism Traffic,

Transportation and Accommodation

. Created two new ASO cubes for Tourism Traffic and

Transportation/Accomodation from Global Insight data.

. Cubes contain unusually high number of dimensions (15) and attribute

dimensions (30). Overall cube size -20 GB

. Use of stored and dynamic hierarchy to optimize data calculation and

retrieval time.

. Managing, enhancing and administrating Sales and Finance applications.

. Coordinate reporting needs between all the departments Accounting,

Human Resources, Sales, Operations, Finance and Information Technology

. Define requirements, refine scope and execute web interface for

budgeting/forecasting applications.

. Translate business requirements into technical requirements.

. Use new capabilities to enable fast turn around time for information

processing and dissemination of reports.

. Resolve data discrepancy issues.

. System test, User acceptance test.

. Facilitate reports after month end from Fidelio (ERP System) to

Hyperion.

. Design and implement Planning and Essbase security

. Developing and implementing plans for Software Upgrades.

. Automate processes by writing MaxL scripts to minimize manual

processing.

. Introduced a data warehousing methodology to be followed in the

project.

OnStar (Detroit, MI): Feb 04-

Dec 04

Technical Environment: Hyperion Essbase 7.1.x, Load Rules, Calc Scripts,

Report Scripts, MaxL, Spreadsheet Addin, Oracle 8i, Solaris 10, Windows

2000 Server, PL/SQL, Datastage

Application Details: Volume Analysis, Profit and Loss Statement Analysis

. Developed Hyperion cube to forecast and compare various volumes for

Onstar business - vehicle volume, subscription volume, Call Volume, XM

Radio volume, personal calling volume etc.

. Developed Hyperion cube for Profit and Loss cube to generate monthly

forecasts and yearly budgets.

. Create functionality to handle corporate restructuring in forecasting

cycle.

. Helped various business units agree to a common definition for the

dimensions that were being conformed.

. Created Logical and Physical schemas.

. Create data mapping documents and extract specification documents for

the ETL team.

. Developed Calc scripts, Load Rules, Report Scripts, MaxL, Spreadsheet

Add-in templates.

. Cube design, Database optimization and fine-tuning.

. Attended meetings between test team and applicable development team

members to identify and resolve performance issues identified by the

test team.

. Transition documentation for support and administration team

DAC Finance (Orlando, FL): Nov

02- Jan 04

Technical Environment: Hyperion Essbase 6.2/6.5, Load Rules, Calc Scripts,

Report Scripts, MaxL, Spreadsheet Addin

Application Details: Sales Analysis, Finance Analysis, Tourism Traffic,

Transportation and Accomodation

. Developed two Hyperion cubes for sales and finance.

. Define business and technical scope of various financial reporting

needs

. Analyzing actual data with Budget and forecast data and variance

analysis.

. Gather business requirements and document the same

. Research, present and implement data integration options.

. Use enterprise standards to detail process flow to meet company

objectives.

. Coordinate efforts to resolve business and technical issues.

. Develop Essbase cubes: Define the outline, write calc scripts, load

rules and reports.

. Design Excel input and output templates.

. Design and architect different applications.

. Ensure smooth transition from development to Production.

. Document system process and maintenance procedures.

. Provide application support

. Post production support for day-to-day handling of Dataloads,

modifications, enhancements and issue resolutions including backup and

restore functions.

. Development using Calc Scripts, Load Rules, Report Scripts, ESSCMD and

Spreadsheet Add-in.

. Created the user friendly mappings document to migrate data from

customer platform to custom developed workflow modules.

. Automated scorecard generation routines & provided capability to

correct the erroneous data.

. Maintained the data models and adhered to the standards of the

company.

. Created user manual for customers.

Dynamicsoft for Level One (East Orange, NJ):

Apr 00 - Oct 02

Technical Environment: C, C++, Solaris 7, Windows 2000 professional

Application Details: Messenger Software Development and Testing

. MCS (Messenger Communicating Service) is main product consist of User

Agents, Proxy Server, Presence Server with Java based Front End with

UNIX/Oracle Back End.

. Design and document Test Plan from Business requirements and review

with Team.

. Developed and Tested different products like Proxy Server, Location

Server, Route Engine, Presence SDK, Java and C/C++ User Agents (end

points) based on SIP Protocol patterned after HTTP.

. Build C/C++ AutoTestApp using Object and Source libraries.

. Execute Test Plan including defect tracking and defect root causer

analysis.

. Write and execute SQL queries to test data in backend database and

create test data prior to testing.

. Perform detailed data analysis as required to improve gap in business

functionality.

. Monitor progress against project plan tasks and milestones. Assess

requirements changes and risks to project.

. Tested detail functionalities using UNIX utility and documented and

review test result.

. Mentor and train (or arrange formal training for) subordinate test team

members in testing methodology, processes, and tools.

. Participate in presentations as needed to cover project status and

test plan.

. Facilitate testing status meetings with developers, and business users

when appropriate..

LeCroy Research Systems (Chestnut Ridge, NY):

Jan 97- Mar 00

Technical Environment: Oscilloscope, High Voltage Power Supplies, Embedded

Software, EPROM, GATE Array, C, C++

Application Details: External, calibrated measurement instrument

. Responsible for testing embedded software and managed QA test process

for business requirement to deliver project.

. Participated in review of product design, software requirements and

functional requirements specifications.

. Designing and implementing detailed use cases for verification of new

product functionality.

. Involved in different release design review, code review, verified

installation and release note and understood E2E business functionality

based on customer experience.

. Responsible for testing and troubleshooting digitally Controlled High

Voltage Switching Power Supply Systems used in high energy physics by

Nuclear Physics research Labs and for high energy applications.

. Used SQL queries to validate data and updated in each release.

. Interacted with cross functional team to review Test Plan, Test Result.

. Timely progress reports and test case status updates.

. Managed Defects, root cause analysis of defects and discussed with team

to resolve outstanding issue.

Production Supervisor Experience (84 - 96)

. NUtronics Inc (Parsipanny NJ) - Electronics Technician - Jan 91-Dec 96

. Microtronics Corp (W. Caldwell NJ) - Production Supervisor - July 84 -

Sep 90

EDUCATION

. Bachelor of Science, University of Bombay

. Certificate Course in Analog and Digital Electronics, RETS (National

Education Center), Nutley NJ

. Certificate Course in C, C++ RETS (National Education Center), Nutley

NJ

. Oracle Certified Hyperion Essbase Consultant

Contact this candidate