PROFESSIONAL SUMMARY:

• Fourteen (14) years of IT experience including Ten (10) years of experience in Analysis, Design, Development and Implementation of various DW&BI applications in client/server environment using Hyperion Essbase 7.x & 6.x, Hyperion System 9 BI+, Oracle EPM v11.1.2, Hyperion Planning 6.5.1, Hyperion MDM 9.2.1, Hyperion Reports, Hyperion Analyzer, EAS, ESSCMD, MaxL, Essbase Excel Add - in, VBA, Essbase Query Designer, Visual Explorer, SAP BPC 10 and Oracle PL/SQL on Windows 2003 & Unix environment.
• Ten years of expertise in DW&BI solution mainly using Oracle and Hyperion, database design, and web technologies.
• Expert in OLAP, MOLAP, Data Warehousing, and Business Intelligence concepts & tools.
• Expert in MOLAP tools such as Hyperion Essbase, Hyperion Planning, Hyperion Analyzer and Hyperion Reports.
• Exposure to Aviation, Telecom, Media & Entertainment and Financial Services domains.
• Performed Essbase database backups, Dense/Sparse settings, partitioning, ESSCMD scripts, MaxL scripts, Optimization and tuning cubes etc.
• Involved in writing custom Essbase calculations scripts, automated the Essbase Cubes using ESSCMD and Batch Scripts.
• Proficient in Batch Scripting, UNIX Shell Scripting, Perl Programming, Excel VBA coding, PL/SQL Scripting, Software Installation, System Upgrade and Server Maintenance, Application and Data back-ups and Security.
• Proficient in Requirement Engineering, Solution Architecture, Technical Specification, Estimation, Software Documentation, Strong leadership qualities, and flexible in work schedules.
• Well versed with CMM Level 5 & ITIL processes - requirements and change management, configuration management, software lifecycle and product quality, review process, process defect management, process improvement and implementing best practices.
• Ability to meet deadlines and handle pressure in coordinating multiple tasks in a work/project environment.
• Versatile team player with excellent analytical, presentation, communication and inter-personal skills.

TECHNICAL SKILLS:

Hyperion/Oracle EPM: Hyperion Essbase 6.x/7.x, Hyperion Planning 3.5.1, Hyperion MDM 9.2.1

Hyperion Reports, Essbase Excel add: in, Query Designer, Visual ExplorerHyperion System 9 BI+, Hyperion Application Link 7.0, Oracle Data Integrator, Hyperion Analyzer, Hyperion Web Analysis, Oracle EPM v11.1.2, OBIEE 10.1.3.4.1 , HFM

RDBMS: Oracle 7.3/8.0/8i/9i/10g, Microsoft SQL Server 7.0/2000, MS Access

Hyperion 3rd Party Tools: HyperRoll

SAP Module: SAP BPC 10 & SAP BW 7.31

Automation Tools: Appworx 6.1

Languages: C, PERL, PL/SQL

Scripting Languages: JavaScript, VB Script, VBA

Markup Languages: HTML, DHTML, XML, XSL

Shell Languages: PERL, Bash shell

ETL Tools: Data Stage 6.1

Reporting Tools: Business Object 6.5

Web Technologies: ASP 3.0, Microsoft Visual Interdev, Developer 2000

Source Control Tools: MS Visual Source Safe 6.0

Bug Tracking Tools: Vantive, DRIFT2K, ITSM

Operating Systems: Windows 98/NT/2000/XP/2003/Vista/7, Unix

Domain: Aviation, Telecom, BFSI, Manufacturing & Entertainment

PROFESSIONAL EXPERIENCE:

Confidential, Burbank, CA

Sr. Hyperion Application Consultant and Project Lead

Responsibilities:

• Senior Hyperion Application Consultant for WHVI - Essbase Applications.
• Project planning, Production support and customer management.
• Requirement gathering & analysis, Technical specification, Solution Architecture, and Estimation.
• Involved in Essbase to SAP BPC conversion project study, design & build.
• Excel templates application creation using VBA.
• Issue analysis, Solution providing, support & maintenance for maintenance projects.

Environment: Hyperion Essbase 9.3.1, Hyperion System 9 BI+ (Essbase Analytics, Visual Explorer, Essbase Excel add-in), Hyperion Essbase Administration Services 9.3.1, Essbase Excel add-in, Excel 2002/2003, MaxL Scripts, Batch Scripts, Oracle 10g, MQ Series, SAP BPC 10 & SAP BW 7.31

Confidential, Teaneck, NJ

Sr. Hyperion Consultant and Project Lead

Responsibilities:

• Senior Hyperion Consultant to the Confidential BI projects.
• Project planning for Hyperion part & execution.
• Requirement gathering & analysis, Technical specification, Solution Architecture, and Estimation.
• Involved in Design, Development, Administration, Migration and Optimization of ASO cubes.
• Essbase ASO Application/Outline Design, Cube Build, Data Load into Cube, Calculation Scripts Development & Automation for developmental projects.
• Creation of Business Rules and Web Forms using Hyperion Planning.
• Working with OBIEE reports to create dashboard / reports.
• Involved in the complete life cycle of the Essbase Application.
• Issue analysis, Solution providing, support & maintenance for maintenance projects.
• Assisted the organization in hiring/interviewing the candidates.
• Worked on creating/modifying Load Rules, Calc Scripts, and Report Scripts.
• Working with Hyperion application upgrade to v11.1.2.

Environment: Hyperion Essbase 11.1.1.3, Hyperion System 9 BI+ (Essbase Analytics, Visual Explorer, Essbase Excel add-in), Hyperion Essbase Administration Services 9.3.1, Essbase Excel add-in, MaxL Scripts, Unix Shell, Hyperion Planning 3.5.1, OBIEE 10.1.3.4.1 , Oracle 10g, Oracle EPM v11.1.2, Hyperion Application Link 7.0, Oracle Data Integrator

Confidential, Teaneck, NJ

Sr. Hyperion Consultant and Project Lead

Responsibilities:

• Project Planning and Execution.
• Requirement gathering & analysis, Technical specification, Solution Architecture, and Estimation.
• Involved in Design, Development, Administration, Migration and Optimization of BSO cubes.
• Involved in the complete life cycle of the Essbase Application.
• Optimized cubes' retrieval/data load/Storage performance by carefully applying OLAP design/optimization concepts.
• Wrote automated Unix Shell scripts for data load & calculation process using ESSCMD/MaxL.
• Defined/automated/implemented the Essbase security users, groups, filters and appropriate permissions.
• Weekly review to analyze performance and identifying key areas of concern and how to address those issues.
• Coordinated the Essbase developers’ meetings to share the ideas and best practices.
• Assisted the organization in hiring/interviewing the candidates.
• Extensive knowledge in using Essbase Excel add-in and Essbase Spreadsheet Services and Custom retrieval templates to support Reporting requirements.
• Worked on creating/modifying Load Rules, Calc Scripts, and Report Scripts.

Environment: Hyperion Essbase 7.1.3, Hyperion Essbase Application Manager 6.5.5, Hyperion Essbase Administration Services 7.1.5, Essbase Excel add-in, MDX/MaxL/ESSCMD scripting, Unix Shell, Control-M

Confidential, Sunnyvale, CA

Sr. DW&BI Consultant (Hyperion) and Project Lead

Responsibilities:

• Project Management, and Technical Lead activities.
• Old CoA to New CoA mapping, Conversion, and Impact Analysis.
• Data conversion/transformation at Staging Area, using Oracle PL/SQL.
• Involved in discussions with the business users to nail down the exact need of the business and carefully applying OLAP design concepts to meet their needs and architected the Essbase applications.
• Involved in requirements gathering for Management reports and Regulatory reports.
• Involved in Design, Development, Administration, Migration and Optimization of BSO cubes.
• Involved in the complete life cycle of the Essbase Application.
• Cubes were created using the Essbase Administrative Services (EAS).
• Optimized cubes' retrieval/data load/Storage performance by carefully applying OLAP design/optimization concepts.
• Wrote automated Unix Shell scripts for data load & calculation process using ESSCMD/MaxL.
• Defined/automated/implemented the Essbase security users, groups, filters and appropriate permissions.
• Identifying CTQ’s (Critical to Quality), establishing Standard Operating Procedure and maintenance of daily metrics to evaluate performance.
• Weekly review to analyze performance and identifying key areas of concern and how to address those issues.
• Coordinated the Essbase developers’ meetings to share the ideas and best practices.
• Assisted the organization in hiring/interviewing the candidates.
• Extensive knowledge in using Essbase Excel add-in and Essbase Spreadsheet Services and Custom retrieval templates to support Reporting requirements.
• Worked on HyperRoll of EFS application, to enhance the calculation performance.
• Worked on creating/modifying Load Rules, Calc Scripts, Report Scripts, Business Rules, and Webforms.
• Worked on Appworx to automate the various Essbase jobs on UNIX environment.
• Reconciliation templates build, and reconciliation between old CoA & new CoA data.

Environment: Essbase Administrative Services (EAS) 7.1.5, Essbase OLAP Server 7.1.6, Hyperion Planning 3.5.1, Hyperion Application Link, Hyperion MDM 9.2.1, HyperRoll, Appworx 6.1, MDX/ MaxL/ESSCMD scripting, Essbase Excel add-in, VBA, Oracle PL/SQL, Unix Shell Scripts, Unix

Confidential

Sr. DW&BI Consultant (Hyperion) and Project Lead

Responsibilities:

• Involved in discussions with the business users to nail down the exact need of the business and carefully applying OLAP design concepts to meet their needs and architected the Essbase applications.
• Involved in requirements gathering for Management reports and Regulatory reports.
• Involved in Design, Development, Administration, Migration and Optimization of BSO cubes.
• Involved in the complete life cycle of the Essbase Application.
• Cubes were created using the Essbase Administrative Services (EAS).
• Optimized cubes' retrieval/data load/Storage performance by carefully applying OLAP design/optimization concepts.
• Wrote automated Unix Shell scripts for data load & calculation process using ESSCMD/MaxL.
• Defined/automated/implemented the Essbase security users, groups, filters and appropriate permissions.
• Identifying CTQ’s (Critical to Quality), establishing Standard Operating Procedure and maintenance of daily metrics to evaluate performance.
• Weekly review to analyze performance and identifying key areas of concern and how to address those issues.
• Coordinated the Essbase developers’ meetings to share the ideas and best practices.
• Assisted the organization in hiring/interviewing the candidates.
• Extensive knowledge in using Essbase Excel add-in and Essbase Spreadsheet Services and Custom retrieval templates to support Reporting requirements.

Environment: Essbase Administrative Services (EAS) 7.1.5, Essbase OLAP Server 7.1.5, Hyperion Enterprise 6.5.1, ASO/BSO Storage Models, MDX/ MaxL/ESSCMD scripting, Essbase Excel add-in, VBA, Oracle PL/SQL, Unix Shell Scripts, Unix

Confidential, Denver, CO

Sr. DW&BI Consultant (Hyperion) and Technical Lead

Responsibilities:

• Involved in Design, Development, Administration, Migration and Optimization of BSO cubes.
• Cubes were created using the Essbase Administrative Services (EAS).
• Optimized cubes' retrieval/data load/Storage performance by carefully applying OLAP design/optimization concepts.
• Wrote automated scripts for data load & calculation process using ESSCMD/MaxL.
• Defined/automated/implemented the Essbase security users, groups, filters and appropriate permissions.
• Used job scheduler to schedule data load & calculation jobs.
• Involved in the complete life cycle of the Essbase Application.
• Involved in discussions with the business users to nail down the exact need of the business and carefully applying OLAP design concepts to meet their needs and architected the Essbase applications.
• Involved in requirements gathering for Management reports and Regulatory reports.
• Identifying CTQ’s (Critical to Quality), establishing Standard Operating Procedure and maintenance of daily metrics to evaluate performance.
• Weekly review to analyze performance and identifying key areas of concern and how to address those issues.
• Coordinated the Essbase developers’ meetings to share the ideas and best practices.
• Assisted the organization in hiring/interviewing the candidates.
• Provided technical support by 24/7 basis when needed.
• Extensive knowledge in using Essbase Excel add-in and Essbase Spreadsheet Services and Custom retrieval templates to support Reporting requirements.

Environment: Essbase Administrative Services (EAS) 7.1.x, Essbase OLAP Server 7.1.x, ASO/BSO Storage Models, MDX/ MaxL/ESSCMD scripting, Hyperion Reports, Essbase Excel add-in, Batch Scripts, Windows XP

Confidential

Sr. DW&BI Consultant (Hyperion) and Leader-Technical

Responsibilities:

• Involved in the full cycle of gathering requirements, defining, designing, developing, testing and deploying the system.
• Involved in preparing the Design document detailing the data acquisition, business processes, test plans and test cases for unit testing and system integration testing.
• Supported the third party vendor conducting test processes such as User Acceptance Testing (UAT), system validation testing and performance testing.
• Involved in tuning the applications for better performance by modifying the server wise and application, database wise settings.
• Involved in design and development of Essbase Cube.
• Developed calc scripts, and business rules using Hyperion Business rules.
• Involved in designing and developing various financial reports like Cash Flow, Profit & Loss, variance reports and other management reports using the Hyperion Reports.
• Involved in designing and developing the corporate charts and other ad-hoc management reports using the Hyperion Analyzer.

Environment: Hyperion System 9 BI+ (Essbase Analytics, Interactive Reporting & Visual Explorer, Essbase Excel-AddIn), Windows 2000

Confidential

Sr. Essbase Consultant and Systems Analyst

Responsibilities:

• Analyzed user requirements and actively involved in the process of finalizing views for the existing cubes.
• Involved in developing the star schema for the EIS OLAP model.
• Created Data Load Rules for manipulating records and loading the Enterprise data Ware house using rules file.
• Developed drill-thru reports using EIS.
• Automating the entire cube build process using MaxL. The MaxL scripts build the dimensions, load data, calculate the database and to define partitions. MaxL scripts are also used to do scheduled extraction of data from Essbase cubes using Report scripts.
• The MaxL scripts are invoked through Batch files on a schedule.
• Analyzed and created the user views for internal and external users and maintained securities on those views using Hyperion Analyzer.
• Trained the users for administration of Hyperion Analyzer. Responsible in giving 24/7 hrs support to all the Essbase application and resolved the tickets on Essbase cube issues.

Environment: Hyperion Essbase 6.5.1, Hyperion Analyzer 6.5, SQL Server, Oracle 8i, PL/SQL, MS Excel Add-in, Windows 2000

Confidential

Oracle/Essbase Developer and Analyst Programmer

Responsibilities:

• Involved in gathering business requirements, defining, designing, developing, testing and deploying the application.
• ERP data is loaded into Cube from Data mart using Data Load Rule.
• Involved in Essbase Cube Building, Loading Data in Cube & Report Scripts.
• Designed and developed load rules using the Prep Editor.
• Handled backup and recovery for Essbase Database.
• Involved in designing and developing the corporate financial charts (Look and Feel) and other ad-hoc management financial reports using the Hyperion Analyzer.
• Created Ad hoc financial Reports for the end users to slice n dice the data using Hyperion Analyzer.
• Involved in tuning the applications for better performance by modifying the server wide, application, and database wide settings.
• Involved in designing mechanisms for the server and application / database security, developing Filters.
• Development of Oracle PL/SQL procedures and triggers as per Design Specifications.
• Technical/Functional guidance to the less experienced team-members.

Environment: Hyperion Essbase 6.2, Hyperion Reports 2.5, Oracle 8i, PL/SQL, Windows NT, Excel Add-in.

Confidential

Oracle Developer and Sr. Programmer

Responsibilities:

• Analyze and Study the requirement of the module.
• Development of Oracle PL/SQL procedures and triggers.
• Unit testing and Integration Testing for associated module.

Environment: HTML, JavaScript, Oracle 8i, PL/SQL, Windows NT

Confidential

Oracle Developer and Programmer

Responsibilities:

• Involved in requirement analysis and design.
• Involved in database schema design.
• Created POP3 email accounts, static and dynamic content of web pages.
• Developed Perl Object Oriented components to add, delete, and update the products as well as customer details in database.
• Involved in Data base design with Oracle as backend.
• Client Side Interaction i.e., tracking their day today activities to System and Project Implementation.

Environment: HTML, JavaScript, PERL 5.0, Oracle 8i, PL/SQL, MS Visual Interdev, Windows NT