EXPERIENCE Summary

• IT professional with over 7 years of experience i Enterprise Solutions at Insurance, Finance and ERU Energy Resources Utilities domains.
• Oracle Essbase 11 Certified.
• Expertise i Hyperio Planning and Enterprise Performance Management Architect Workflow design
• Experience i analyzing, designing, developing, implementing, tuning and supporting the Hyperio Suite of tools, including Hyperio Essbase, Hyperio Planning and Hyperio Reporting.
• Experience i writing Essbase Scripts and maintaining multidimensional database.
• Experience i Essbase database design, cube design, Essbase Calculatio Scripts, business rules, security filters and Report Scripts.
• Hyperio planning and Essbase applicatio optimizatio for better performance.
• Experience i creating and managing ASO/BSO essbase application.
• Developed and implemented planning, budgeting and forecasting applications using Hyperio System 11
• Experience i exporting/importing managing large number of users through Hyperio Shared Services.
• Experience i Migrating applications from one environment to other using LCM.
• Expertise at creating shell script to automate data loads and dimensional hierarchies i UNIX environment.
• Experience i defragmentatio of database caused due to frequent deletio and insertio of data i database.
• Knowledge of RDBMS tables of Hyperio planning.
• Experience i developing extensive reports using Hyperio Intelligence Explorer 8.5. Interactive reporting, Financial Reporting and Hyperio Web Analysis.
• Experience i creating drill through reports using EIS.
• Exposure to Extended Excel Essbase VBA Interface.
• Conducted training sessions for Hyperio Planning and Essbase basic concepts.
• Exposure i Data warehousing, Oracle servers and Business Object basic concepts.
• Worked i multiple functional, technical and industry domains.
• Handled Client Interactio during support hours.
• Experience i Functional Technical Requirement gathering from client for Minor Enhancements i the system s .
• Desig and configuratio of LDAP with AD and TAM servers.
• Configuratio of batch through Autosys and Crontab.
• Knowledge of configuring Disaster Recovery DR environment.
• Experience of supporting large scale Documentum applicatio and working with multiple partners.
• Key area improvement i Support processes for better SLA management and applicatio health monitoring.
• Working closely with multiple stake-holders during high priority/severity incident and providing regular updates to key business/IT stake-holders.
• Experience at Onsite-Offshore delivery model.

Achievements

• Received Client appreciations i writte e-mails while working overseas at Client location.
• Got good feedback Gems while conducting Hyperio planning training at oracle COE level.

Technical Skills

Other Skills

• Good command over Oral and Writte Communication.
• Process improvement experience.
• Conducted training sessions.
• Development, Support and Good Client Handling capabilities.
• Experience i working with Large Cross functional Teams.
• Experience i maintaining Business Continuity Pla BCP , Risk Management Report RMR and Project Management.
• Ca work i a Cross culture team.

ExperiEnce

Confidential

Hyperio Planning Essbase Developer, HFR Reports Development for client

My Responsibilities:

• Worked o Hyperio Planning and Essbase 11.1.2.3
• Worked as Hyperio planning essbase developer.
• Developed Hyperio Planning applicatio with three cubes and one aso cube.
• Designed forms, task lists, business rules and validatio rules i Hyperio planning.
• Involved i Essbase database design, cube design, essbase scripts, and security filters.
• Worked o report scripts i order to extract data from aso reporting cube to send the financial data to HQ application.
• Designed complex security system i very efficient way by making use of inheritance betwee many groups.
• Created shell script to automate data loads and dimensional hierarchies.
• Technical expertise i writing essbase scripts, security administration, connecting essbase with SQL server.
• Managed thousands of users using shared service.
• Involved i migrating the Hyperio planning application/Artifacts using LCM.
• Involved i writing Maxl scripts and creatio of batch files for automatio of running different rule sets.
• Involved i optimizing the cube size by setting various cache sizes i essbase.
• Designed highly formatted reports using hyperio financial reporting.
• Used different style of charts and highlights i order to do data analysis.
• Made all reports dynamic using various functions and formulas.
• Developed smartview reports using built i functio .
• Worked o technical and functional document.

Environment: Hyperio system 11.1.2.3, Hyperio Essbase 11.1.2.3 ASO BSO Cubes , Hyperio Financial Reports 11.1.2.3, EAS 11.1.2.3, Hyperio Planning 11.1.2.3, SmartView, Oracle 11g, Linux Red Had .

Confidential

Hyperio Planning Essbase Developer /Admin

My Responsibilities:

• Worked o Hyperio Planning and Essbase 11.1.2.0
• Worked as a Essbase admi and also responsible for doing development work coming as a minor enhancements.
• Responsible for resolving tickets using SASHA ticket system withi defined SLAs.
• Designed forms, task lists, business rules and validatio rules i Hyperio planning.
• Involved i maintaining transparent partitio by automating the process for regular updates from the Master applicatio for the following :
• Metadata
• Security filters
• Involved i Essbase database design, cube design, essbase scripts, and security filters.
• Designed Essbase ASO applicatio for particular set of group users to perform aggregatio and reporting .
• Involved i writing report scripts to extract data from the cube for designing some of the reports.
• Designed complex security system i very efficient way by making use of inheritance betwee many groups.
• Technical expertise i writing essbase scripts, security administration, connecting essbase with SQL server.
• Managed thousands of users using shared service.
• Involved i migrating the Hyperio planning application/Artifacts using LCM.
• Involved i writing Maxl scripts and creatio of batch files for automatio of running different rule sets.
• Involved i optimizing the cube size by setting various cache sizes i essbase.
• Developed user interface i excel using VBA scripting.
• Designed extensive and user friendly reports using Hyperio Interactive Reporting, Financial Reporting FR .
• Knowledge of Smart View and Excel -add I for connecting essbase and Planning from Excel.
• Involved i making technical documents for Balance sheet and Pnl cube
• Involved i making OPS Manual Operations Manual for the entire project activities.

Environment: Hyperio system 11.1.2.0, Hyperio Essbase 11.1.2.0 ASO BSO Cubes , Hyperio Financial Reports 11.1.2.0, EAS 11.1.2.0, Hyperio Planning 11.1.2.0, SmartView, Oracle 11g, Linux Red Had .

Confidential

Hyperio Reports Development for Client

My Responsibilities:

• Worked o Hyperio Interactive Reporting and Hyperio Intelligent explorer for Reports development.
• Involved as a primary developer for two Daily Reports which are regularly see by the Clients and got many appreciations from them for presenting the reports i the most readable manner.
• Client Interactio during Functional, Technical Requirement gathering.
• Involved as a developer i making extensive Dashboards with the help of Java Scripts i which user gets most choices to filter to produce a output.
• Also involved i making Technical Functional Specificatio Document.
• Made the Reports interactive with the help of Pivots, this helped to view the data from different perspective o the basis of Crews, Work packets, Individual .
• Wrote packages PL/SQL to retrieve data as per the Clients requirement and designed the Hyperio Reports.

Environment: Hyperio system 9, Hyperio Essbase 9 ASO BSO Cubes , Hyperio Interactive Reporting, , Oracle 11g, Windows 2003 Server.

Confidential

Documentum RTB Maintenance and Development for client

My Responsibilities:

• Documentum system administration
• Coding of custom Java utilities as per changed business requirement or data-fix
• Deployment of Documentum patches and custom releases such as DAR and JAR
• Working and maintaining Content Server 6.5 and 6.7, Webtop 6.7, Documentum Adminitrator, IBM Websphere Applicatio Server 7.1, JBoss 4.3.0 5.1.0 , Oracle 11g
• System configuratio and migratio of Fulltext Search engine from FAST to xPlore 1.1
• Maintaining of fulltext search engine i.e. FAST later migrated to xPlore 1.1
• Desig and configuratio of LDAP server with synchronizatio to Active Directory AD
• Maintenance of ADTS
• System upgrade of Content Server 6.5 to 6.7
• Configuratio of High Availability Content Servers
• Configuring JBoss as Java Method Server of Content Server
• System upgrade of xPlore 1.1 to 1.2
• Configuratio of batch through Autosys and Crontab.
• Working with Documentum Foundatio Classes DFC
• Support Documentum Foundatio Services/Web Service and MQ.
• Study of Oracle Database AWR report to analyse any long running queries
• Identificatio of key areas of system performance improvement such as building Indexes o Oracle tables or configuratio changes
• Recommendatio and identificatio of key areas for daily system monitoring through Spectrum and Alertsite
• Impact analysis of requirement and changes recommended
• Working closely with other teams/vendors during high severity issues and providing regular update to key business/IT stake-holders
• Working closely with Documentum product vendor EMC for product related issues
• Preparatio of Software requirement Specificatio SRS and Use Case
• Preparing High Level Desig HLD
• Functional Technical Requirement gathering from client for Minor Enhancements i the system s .
• Tracking defects and enhancements through IBM Clear Quest
• Direct Client Interactio during support hours.
• Fostering a good working relationship betwee client and Documentum team.
• Resolving Documentum incidents o a daily basis.
• Emphasing o Process development so that work ca be done much smoother.
• Worked i multiple functional, technical and with different partners such as AES, DBA and Network Team.
• Mentoring new associates who joined our project as the team was initially started by two of us and the grew to five i numbers with increasing number of minor enhancements.
• Managing the configuratio and controlling the versions using VSS
• Performing performance analysis of program components
• Preparing the System Test Pla STP as per standard Marsh- STP Template
• Preparing the Traceability Matrix as per the Marsh standards
• Logging Incidents and maintaining resolutions with Unicenter tool
• Managing, coordinating and executing project
• Reviewing offshore deliverables and adherence to standards.
• Reporting status to the management
• Training and Mentoring of juniors
• Communicating betwee the offshore and onsite, also giving status to Client.
• Maintaining codebase and other deliverables through IBM ClearCase.

Environment: Documentum Content Server 6.5, Xplore, FAST, ADTS, IBM Websphere, LINUX Red Hat , Windows 2003 Server, Composer, Eclipse, Oracle 11g.

Confidential

PS Enterprise Payroll/HR/Training Upgrade and Support.

My Responsibilities:

• Preparing the Software Specificatio Documents and Use case.
• Requirement gathering for a new Appraisal system devised by the HR Team.
• Developing a End to End performance monitoring and appraisal system for HR department called STAR Appraisal.
• Upgraded PS Enterprise developed by Northgate from versio 3.9.5 to 4.1.0.
• Resolving re-occurring problems with the instability of the applicatio at the previous version.
• Client interactio to gather problems faced after upgrade.
• Resolving those incidents during warranty support and giving client confidence i the product and its stability.

Environment: PSE Payroll 11, Windows 2000 server, VB Studio, Oracle 9i