SKILLS SUMMARY

• Over 12 years Hyperion Essbase and Planning experiences in three US Fortune 100 companies.
• Played on Hyperion developer role. Designed, developed and maintained 11 Hyperion Essbase applications, 5 VBA based Essbase applications, 2 Hyperion Planning applications and converted 2 applications from BSO to ASO.
• Performed Hyperion admin role on Hyperion infrastructure setup on multi - server environment, Hyperion version upgrading, server refresh and migration, database configuration, performance tuning, database backup, security setup, database release, data issue shooting, script troubleshooting, functional testing and other related tasks. Skilled in Hyperion Finance Management admin and Hyperion Finance Report generations.
• Extensive skills in Hyperion developing and supporting tools such as Form, Business Rules, Outline, Calc Script, Report Script, MDX, MaxL and Security hierarchy, as well as in-depth expertise with OLAP front tools include Excel Add-in, Smartview and VBA.
• Expertise in automation of Hyperion Essbase cube refreshes using Window Batch/Esscmd MaxL, MDX, HAL and ODI (Oracle Data Interface). Setup “Autosys” processes to automatically handle daily/weekly data backup, refresh, validation, and notification.
• Performed 24x7 on-call application supports.
• Good experiences at Oracle, MySQL, C/C++, Java/JSP, PHP/HTML, data warehouse and mining.
• Educated in both MBA (Finances) and Master of Computer Sciences. Excellent in chart of account mapping, business and data analysis, communication, and tech. documentation. Strong knowledge in AOP, QBP and Headcount workflows.
• Never miss deadlines and ability to handle pressure when coordinating multiple tasks in a work environment and a versatile team player with excellent presentation and inter-personal skills.

WORK EXPERIENCE

Essbase Specialist

Confidential, Manhattan, NY

Responsibilities:

• Worked on 5 Essbase applications (3 BSO and 2 ASO).
• Converted BSO applications to ASO and re-wrote MDX to replace calc scripts.
• Upgraded VBA applications from Essbase Add-in to Smartview.
• Heavily coded Essbase calc scripts on BSO applications.
• Worked on generating attribute dimension on fly for an ASO cube daily refresh.
• Worked on BSO database analysis (outline, cache, calc script and configuration) for database performance tuning.
• Researched on the Essbase data export by comparing calc script, MDX and report script on ASO with MaxL to solve the performance issue of overnight process.
• Coded ksh script to solve the data file transfer between UNIX and MaxL
• Solved user tickets and addresses the data issue.

Hyperion Planning Contractor (Consultant from SGI Technology Group)

Confidential, White Plains, NY

Responsibilities:

• Supported, maintained and upgraded 2 Hyperion Planning applications.
• Wrote USTA Planning application support document.
• Tested Concur (for T&E), Lawson (Foe JE) auto-loading and reconcile processes
• Verify Forecast and Budget data for Cash Flow, Balance Sheet and Income Statement based on my finance knowledge.
• Built financial reports using Hyperion Finance Report and solved old report issues
• Coded stand alone VBA for Year End A/P report generation.

Sr. Application Analyst (Consultant from Cognizant Technology Solution)

Confidential, Purchase, NY

Responsibilities:

• Supported, maintained and upgraded 2 Finance Essbase databases, 3 Operational Essbase databases. 2 Hyperion Planning for AOP and 2 Essbase/VBA based AOP applications.
• Developed and enhanced Calc Script, Loading Rules, and Report for Finance applications and Form and Business Rules for AOP applications.
• Worked on new Hyperion version upgrading, new server setup, application migrations, database configuration, testing and performance tuning.
• Performed database backup, Period/Year End application flipping, data issue shooting.
• Maintained application Security on Hyperion Shared Services adherent to PepsiCo's Security Policy
• Provided 24X7 application supports. Handled all kinds of business tickets to solve various program, data and security issues within SLA timeframe.
• Prepared variety documents for user new requirement, data analysis, functional system design and implementation.
• Independently developed “Drive Tree” project using VBA on Excel, PPT to generate various styles of Tree Chart based on the parameters selected dynamically.
• Independently developed GPR Brand report on Excel/VBA/Pivottable against Teradata.
• Remote trained and supervised India off-shore team for job outsources.

BI Analyst (Employee)

Confidential, Purchase, NY

Responsibilities:

• Designed, developed and upgraded 2 Finance Essbase applications (Finance database, Finance data-mart for period close) and 3 operational Essbase applications (PCNA, LOB and Beverage A&M).
• Designed and developed 2 Hyperion Planning AOP applications (Russia P&L and Mexico P&L). Updated and maintained 2 old Hyperion Planning AOP applications (Brand Plan and HQGA).
• Developed and maintained 2 Essbase/VBA AOP applications (S&D and MEM).
• Heavily programmed Calc Script, Loading Rules, and Report for Essbase applications, Form and Business Rules for Hyperion Planning applications, HAL, SQL Interface and ODI for data ETL, Window script, Esscmd, MaxL, and MDX for hourly/daily/period database refresh automation.
• Worked on server upgrade, server migration, application migration, application release (Period/Year End Flipping), performance tuning, system configuration and Autosys setup.
• Designed and managed filter /user/group permissions on EAS, LDAP server and Shared services
• Communicated with business, prepared user requirement and technical documents.
• Ensured smooth program operations with extensive testing and debugging.
• Provide working-hour and off-hour application support. Handled all kinds of business tickets to solve various program, system performance, and data issues within SLA timeframe.
• Trained new hires and supervised contractor to become efficient members of the team on site.

Essbase Developer (Consultant from Millennium Software)

Confidential, Dearborn, MI

Responsibilities:

• Preparation of user requirement and technical documents for Motor Parts data-mart.
• Designed and developed Essbase database (Motor Part Data-mart) and data loading processes.
• Coded frontend application using embedded Essbase/VBA.
• Built ETL for weekly data transfer from Teradata.
• Heavily performed performance optimizations.