Lead Consultant Resume

SUMMARY

Over 10 years of IT experience in Advanced Analytical Software Application, Business Analysis,
Requirement Gathering, Testing and Database Administration of OLAP and Client/Server projects
Involved in successful implementation of 3 full life cycles, starting from require gathering to end user s.
Extensively worked on Essbase (ASO\BSO\Hybrid) applications.
Written\modified simple to complex Cal script for financial clients.
Written\modified MDX script for ASO applications.
Written member formulas for ASO applications
Created Partitions between ASO application to migrate data.
Developed\Modified data load rules using flat files and Oracle database
Written\edited Maxl’s for automation, data retrieval, Properties settings, cube building and etc .. purpose
Created new Hyperion Planning applications (Classic and Hybrid).
Developed\modified simple and composite data forms, task list, menus, Smart list in Hyperion planning
Written\Edited simple to complex Business rules as per business requirement
Designed and developed interfaces to load the data from multiple sources like
Relational databases, flat files into oracle database using ODI
Migrating application and Objects form lower environment to Higher environment and vice - versa
Maintained security in Essbase and Shared services.
Extensively involved in Agile methodologies on Scrum Management activities, requirement Gathering, Effort Estimations.
Excellent debugging skills and ability to resolve issues on time
Created POCs for client on Essbase Cloud
Worked on Hyperion Essbase Cloud to build Essbase standalone Applications.
Have experience in data Extraction, Loading and Transformation in data ware house

PROFESSIONAL EXPERIENCE

Confidential, San Antonio

Lead Consultant

Products: Hyperion Planning, Hyperion Essbase(ASO,BSO and Hybrid), SmartView, ODI, PL\SQL, Essbase Cloud

Responsibilities:

Submitted POC to client for Essbase Cloud services and PBCS
Created classic Hyperion planning applications as per business requirement.
Built metadata in Essbase and Planning applications using ODI.
Using ODI, cleared and loaded data into Essbase application.
Webforms created for user to submit adjustments during forecast.
Necessary business rules created to calculate the adjustments and their roll ups.
Worked with DRM team to tune the metadata exports required for metadata build process.
Worked with database team for data transformation needed as per the data sources we are loading into Planning application.
Created validation files to test the Business rules calculations and built data validation queries to validate the source data vs Hyperion cubes.

Confidential, Atlanta, Georgia

Hyperion Consultant

Products: Hyperion Planning, Hyperion Essbase, SmartView, DRM

Responsibilities:

Creating outline, metadata, and member formulas as per business requirement.
Loaded data manually and using Automation techniques using MaxL Scripts.
Created Web Forms with in Hyperion planning.
Created automation scripts in Windows environment using MAXL.
Trained End users in accessing the Web forms.
Worked on data reload process for Essbase application.

Confidential

Lead

Products: Hyperion Planning, Hyperion Essbase, DRM

Responsibilities:

As a lead I was instrumental in providing solution for end-to-end implementation of Hyperion Planning 11.1.2
Created two Planning Applications for Expenses and Workforce
Involved in Requirement Gathering
Update and review of the DLD’s
Involved in Development of the Project
Creation and deployment of the Application
Outline Building, Design/Modify the Outline, Data forms, task Lists and update the business rules
Monitor the flow of Metadata from Essbase to DWH & flow of data from DWH to Essbase
Design/Modify the Financial Reports, Books created in Hyperion Financial Reporting.
Design/Modify the Dashboards created in Hyperion Interactive Reporting.
Administration of the DEVELOPMENT Environment.
Involved in In UNIT testing and SIT of the project

Confidential, Chicago,USA

Consultant

Products: Hyperion Essbase, Hyperion Planning, Hyperion Reports

Responsibilities:

Involved in the design to build up / rolling budget from individual entity level and at consolidated level
Actively involved in Period opening
Involved in Data reconciliation between source data and Hyperion Essbase data
Created Webforms
Involved in Consolidation
Developed financial reports and scheduled them as per business needs.

Confidential

Associate Consultant

Products: Hyperion Essbase, Hyperion Planning and Hyperion Reports.

Responsibilities:

Designed, Developing and Modified the Outline according to the business requirement
Understanding new requirements, Converting functional requirement into Technical
Create Load rules, Calculation script and validation template
Developing process map
Creating users and user groups and applied security Essbase
Generated Hyperion Reports for the business through Hyperion Financial Reporting.

We provide IT Staff Augmentation Services!

We'd love your feedback!

Resume Categories

Client Services

Job Seekers

Visa Sponsorship