SUMMARY

• 10+ years Information Technology experience in Design, Development, Testing and Implementation.
• Experience in working through all phases of Software Development Life Cycle (SLDC) including teh design, development, implementation, and maintenance of financial applications
• Proficiency and experience in a range of Hyperion products including Essbase, Hyperion Planning, HFM, HFR, ODI, DRM, FDM, Smart View and Excel Add - In.
• Expertise in building Financial Budgeting and Forecasting OLAP applications.
• Expertise in administrative tasks: Managing applications and databases, Essbase architecture, data and dimension loading, Calc Scripts, Business Rules, HFM Rules, MaxL, MDX Querying, Report Scripting, User security and Performance tuning
• Proficient in Designing and developing Essbase applications with excellent balance of dense and sparse dimensions, developing various OLAP Models & Meta-Outlines across Block Storage (BSO) and Aggregate Storage (ASO)
• Expert in designing security models for various tools depending on user’s responsibilities.
• Experienced in optimizing data loading, calculation, and retrievals.
• Adept knowledge in SQL and SSIS.
• Experienced in Anaplan, Power BI and QlikView
• Versatile team player with excellent analytical, presentation and interpersonal skills with an aptitude to learn new technologies.

PROFESSIONAL EXPERIENCE

Confidential

Info Tech Manager

Responsibilities:

• Successfully implemented teh entire Hyperion EPM 11.1.2.4 product suite including Planning, Essbase, HFM, FDMEE, DRM, HFR, ODI
• In process of implementing EPBCS.
• Experienced with all teh components of Cloud EPM like Infolets, dashboards, Approvals etc.
• Implemented complex approval process and security models.
• Experienced with EPM Automate, automated several processes with in teh clould.
• Automated several reports and books to be delivered to teh top management using report books.
• Managed and Implemented several BI projects and completed on time and in Budget
• Co-ordinate with consulting and software vendors for timings and costs involved
• Developed various dashboards in Power BI and QlikView depending on teh business needs.
• Recommends system improvements, new applications and develops plans to improve service
• Architect various data flows between systems and recommend appropriate tool for reporting various metrics
• Partner with management and process owners to align process improvement initiatives with business objectives
• Performs system design and analysis, develops complex code and testing to ensure successful delivery of system functionality and application components.
• Develops programming standards and procedures as well as programming architectures.
• Provide technical expertise on overall architecture and strategy of teh Hyperion Planning and Essbase environment
• Participate in and halp lead change management activities associated with teh automation of Finance processes and systems
• Manage technology project delivery; addressing risks and issues through TEMPeffective contingency plans and proper escalation

Confidential

Sr. Finance Analyst

Responsibilities:

• Administration and maintenance of Hyperion Planning & HFM, FDM, DRM, ODI and Essbase v.11.1.2.3
• Implement various cubes by Super Group and created a standard cube for consolidated data.
• Moved teh models to SAP BPC and maintained Hyperion environment parallelly.
• Implemented AnaPlan for Adhoc Planning and modelling needs.
• Performed system monitoring, optimization, and tuning of databases and processes.
• Performed maintenance, security analysis, development, migration and change management based on assessment of risk relative to goals.
• Performed additional system wide tuning initiatives over varied time horizons yielding highly improved performance.

Confidential

Analyst

Responsibilities:

• Administration and maintenance of Hyperion Planning & HFM, FDM, DRM, ODI and Essbase v.9
• Maintain metadata in DRM (including extracting, loading and updating teh metadata structure)
• Ensure monthly close process runs smoothly in Hyperion Planning & FDM, DRM, ODI and Essbase applications
• Coordinate issue resolution with internal and external technical support providers
• Support corporate, field and remote users with Hyperion applications and Smart View
• Load data to HFM as needed during monthly close process.
• Monitoring teh current Production environment servers for performance and stability

Confidential

Software Engineer

Responsibilities:

• Worked extensively on detailed system analysis, design and development of teh system lifecycle.
• Implementing complex Hyperion solutions including input forms, writing custom calc scripts, load rules, setting up users/groups, define access rights, performance tuning (reports, Essbase), reporting, troubleshooting and full automation using MAXL scripts, Scheduler and Autosys.
• Added all teh required dimensions for teh new cube and added members and aliases for teh dimensions.
• Analyzed raw data and converted it to valuable business information by design & development of appropriate cubes and reports, provided seamless integration of historical, projected and derived data.
• Created Web Forms in planning and as well as Smart View to provide offline access to Users.

Confidential

Hyperion Planning

Responsibilities:

• Worked with Hyperion Planning/Essbase, for creating and managing applications, databases, outline
• Worked with Hyperion Analyzer to build reports.
• Worked on Hyperion Analyzer Administrator to create users, user groups
• Implemented teh application security on Essbase.
• Achievements:
• Optimized teh cubes to perform well.
• Trained teh users on Hyperion Systems.
• Automated several tasks.
• Brought down teh close cycle drastically.
• Designed and built complicated reports.
• Received several appreciations and rewards.

Confidential

Analyst

Responsibilities:

• Analyzed user requirements and involved in teh process of finalizing dimensions.
• Worked closely with end-users and project team to acquire and analyze business requirements and translate them into multi-dimensional outlines in Essbase.
• Designed teh dimensions using teh Functional Specification Documents.
• Designed and modified Essbase database outlines, dynamic calculations, calculation scripts using teh Calc Script Editor, and rules files for dynamic dimension building and data loading.
• Generated teh Excel templates for Business user community to lock and send teh data.
• Performed source data modifications, data load, dimension build, outline changes, validations, database calculations and retrievals to meet changing user requirements.
• Optimized Data Loads and Calc Scripts by applying different techniques.
• Optimized teh Essbase Application to balance teh calc & retrieval performance needs.
• Worked extensively in developing automation scripts using Essbase MaxL.
• Performed Unit level testing.
• Maintenance of Batch Scripts, Scheduling runs through AutoSys.
• Presented detailed analytical reports to higher administrative people using Hyperion Analyzer to induce collaborative decision making.
• Provided support and training as necessary for end users.
• Data Processing Essbase Loads in Production Support (acted as a SPOC for production Support).
• Provided Support for 200 users across organization with an SLA of 24 Hrs.