SUMMARY:

• Seasoned IT professional with current Hyperion experience of more than 9+ years
• Data warehousing experience of 8+ years
• Hands - on Senior Developer, Business Analyst with accounting qualifications
• Strong Interpersonal skills
• Works simultaneously on multiple projects
• Managed the Hyperion environment maintaining multiple (Dev, Test, UAT, Prod and DR) environment in stable and reliable condition.
• Each environment contains Data server, application server, web server. Production was load balanced for application server.
• Monitored the health check of the application and review of the logs for any abnormal anomalies on daily basis to take any proactive action.
• Managed proper security (access rights) for the proper artifacts so that users can access the needed information from the multidimensional cubes.
• Provided the guidance and hold the lunch - n-learn sessions for the specific tasks at different levels.
• Understood the pain points by having the group discussions and identify the gaps.
• Provided the detail analysis of the issue and implemented the solution without impacting the existing process.
• Scheduled the periodic back-up plans to backup the relevant artifacts of the application, so that in case of worst scenario the application can be restored quickly.Managed the new requirements by having JAZZ sessions to get the functional business requirements.
• Created the project plan for the steps and time lines with proper resources.
• Converted the business requirements into technical specifications.
• Pointed out the affected process and accordingly plan out the path for testing and testing with the users and stress testing.
• Hold the change management meetings to inform the changes to all the stake holders of the application.
• Publish the schedule of vulnerability patches and application related enhancements.
• Getting pre-approvals for data refreshes and code migrations between environments.
• Estimating the support process downtime, whereby the application may be inaccessible to the users.
• Provided the back-up plans to mitigate the risk. Implemented version changes of the software, by following the vendor provided steps and/or documentation.
• Managed the scripts, process & scheduler.
• Understanding all the aspects of the Hyperion environment whereby in case of issues, know where and what to troubleshoot.
• Gathered the BIG picture of the application and kept the inventory of application artifacts of each server.
• Managed the Support incidents and provided the respective support with documentation meeting the SLA.
• Ability to perform administrative activities along with Functional and Technical including performance tuning and Meta structure.

EXPERTISE AREA:

• Product Expertise: Hyperion Infrastructure & Analytics, DRM, ODI, Informatica, Oracle RDBMS
• Domain Expertise: Data Warehousing, Data Cleansing, Data Mapping, Data Migration, Data Modeling
• Functional Expertise: Accounting, Finance, Supply Chain
• Industry Expertise: Consumer Products, Automobiles, Chemicals, Banking, HealthCare
• Process Expertise: Software Development Life Cycle (SDLC), Rapid Application Deployment (RAD)
• Project Roles: Senior Developer, Technical/ Module Leader, Business Analyst, Support Consultant

TECHNICAL SKILLS:

• ESSBASE (7.1, 9.x, 9.2., 11.1.1.3, 11.1.2.X), Load Rules, Calc Scripts, Report Scripts, ESSCMD/MaxL Scripts, HAL/ODI, Planning, Smart View, Hyperion Reports, Shared Services, BSO, ASO, DRM
• Oracle Data Integrator, ERPi/FDMEE, Informatica, Oracle RDBMS, PL/SQL, SQL*Loader, TOAD, Erwin
• Exposure to Trillium, Data Cleansing tools, ETL/ELT and SAP R/3
• MVS/TSO, COBOL, JCL, VSAM, DB2, Sync sort, GENTRAN.

PROFESSIONAL EXPERIENCE:

Confidential, Piscataway, NJ

Business Analyst

Technical Environment: Hyp 11.1.2.3 (DRM, ESSBASE, Planning, MaxL, SmartView, Business Rules, Calc Scripts, Batch scripts, FDMEE)

Responsibilities:

• Introduced the Alternate Hierarchy to simplify the Confidential ( Confidential ) view and accordingly modified the Planning Forms/Reports reflecting the Confidential hierarchy.
• Simplified the complex Budgeting process by providing the options to enter the Budget % by Account hierarchy parent level information, cascading it to its children. Using complex Business Rules converted % into $ and shown it in the Planning Form to the Planners with previous years information along with Actuals for comparison.
• Tweaked and automated the Actuals Meta/data load process from DRM into EPMA, Planning/ESSBASE.
• Analyzed the dimension models for optimum performance with proper setting of Dense/Sparse, Block Size and performance evaluation order. Depending on situations recommended making use of Attributes.

Confidential, Woonsocket, RI

Business Analyst

Technical Environment: Hyp 11.1.2.2 & 4 (ESSBASE, Planning, MaxL, ODI 11.X, ODI 12C, SmartView, Business Rules, Calc Scripts, Batch scripts)

Responsibilities:

• Analyze and fine tune the long running processes to perform in optimum manner without affecting the deliverables.
• Created and Managed the ODI Topology, Models, Knowledge Modules, Interfaces, Variables, Packages, Procedures with proper security of access to the artifacts. Migrated the artifacts from one environment/version to another and at times set-up the context to point to appropriate instances. Batch scripts were created using the right Agents to perform the execution plan.
• Migrated complex workforce ODI 11.1.1.7 process to ODI 12C
• Upgraded hyperion environment for 11.1.2.2 Workforce to 11.1.2.4 workforce & Stress tested the environment.
• Handled complex Meta/data load process from Peoplesoft & SAP sources to Planning & load data into ESSBASE.
• Troubleshoot the error situations and get to the root cause to prevent the error for reoccurring in future.
• Created complex SQL views and complex mappings to provide the accurate hierarchical entities for the business.
• Installed and patched ODI 12C for ESSBASE & Planning adapters. Prod environment in Execution mode only.
• Worked on enhancing the ODI procedures for error checking & informing the business users thru email (ODI automation).
• Created the control calendar to accept parameters to pass thru the variables for executing scenario thru batch cmd.
• Maintained the documentation on the key and complex process using the layman understanding language. Pictures and back ground provided where needed.

Confidential, Salt Lake City, UT

Business Analyst

Technical Environment: Oracle Managed Cloud Services-Hyperion 11.1.2.2 & 4 (ESSBASE, EPMA Planning, CALC Manager, Reports, Smart View, ERPi/FDMEE) ESSCMD, MaxL, Oracle 11g, WebLogic, ODI (11.1.1.7), LINUX/Windows

Responsibilities:

• Structured the security process by creating Roles & Group, assigning users to groups.
• Participated in all Oracle Managed meeting to go over the RFC, SR & change management accordingly communicated to Intermountain for the impact & resolutions. This includes scheduling of Oracle published quarterly CPU patches and Microsoft published vulnerability patches.
• Converted manual driven Month End Book Close process to ODI scheduler process with the result eliminating the human error and focusing more on the business.
• Automated the Month end process, whereby during the first 8 workdays, the month end process runs every four hours, which provides almost the real time (4 hrs delay) information in ESSBASE.
• Introduced the data validation process, making sure the Source (Peoplesoft) matches with ESSBASE.
• Understood the business requirements for creation of Functional Design Document (FDD) and accordingly created the Technical Design Document (TDD).
• Implemented the Balance Sheet database using the Hybrid Aggregation Mode (BSO/ASO new option).
• Actively participated in developing plan of migrating artifacts from 11.1.2.2 to 11.1.2.4 environment making sure of all the functionality working as expected.
• Created Test Scenarios for running the Stress Test on the upgraded hyperion environment. Monitored the performance, accordingly tweaked the ESSBASE config settings and JAVA heap sizes along with calc script tunings.
• Troubleshoot Infrastructure, Functional as well as technical issues. Resolve and fix it for future. Share it with the team.
• Supported Smart view and Reports related issue for a user base of ~3K.
• Created and automated the eliminations/intra company offsets to have a true financial picture of the org.
• Explored and Created the Alternate hierarchy for reporting purposes, which was replicated using Peoplesoft Metadata, whereby cross configure reporting remains same of Peoplesoft and Hyperion.
• Data exchanged between the ESSBASE applications using the partitions.
• JIRA & Confluence was used to track the project issues and documentation of the process.

Confidential

Technical Environment: Hyperion 11.1.2.2 (ESSBASE, Planning, CALC Manager, Reports, Smart View) ESSCMD, MaxL, Oracle 11g, WebLogic, ODI (11.1.1.7)

Responsibilities:

• Upgraded hyperion 9.2 to 11.1.1.3 to 11.1.2.2 on UNIX/Windows environment.
• Replaced unsupported HAL (ETL tool of Hyperion) with ODI (ELT tool from Oracle).
• Installed & Configured ODI (Master & Work Repositories, ODI Agent), set up Topology which includes Physical, Logical architecture and context connections with Oracle & Hyperion (ESSBASE & Planning).
• Developed & fine-tuned the ODI process with automation to get feed from Oracle Financial into cubes.
• Used ODI Designer to develop complex interfaces (mappings) to load the data from the various sources into ESSBASE & Planning.
• Implemented and enhanced different ODI Knowledge Modules in mappings for loading and integrating the data from sources to targets.
• Implemented and upgraded the Hyperion to windows based with minimum down time and smooth migration from UNIX to Windows based environment.
• Created/updated the Hyperion Disaster Recovery Plan along with detail documentation on the process.
• Applied the Hyperion/ODI patches (using OPatch) to keep the industry standard hyperion/ODI environment.
• Coordinated the Smart View rollout to Financial Analysts’ machine with proper set-up instructions and potential look & feel changes, so that Analyst can adapt the new Smart View version easily.
• Coordinated the UNIX/Windows hyperion server upgrades with minimum downtime.
• Maintained the GDAIS Direct and Indirect hyperion user’s security roles & access for authorized users.
• Supported GDAIS Direct and Indirect users (all US time zone) in monthly, Quarterly and annual financial closing by providing the High Availability of Hyperion Planning, Smart view and Reports.
• Coordinated and supported enhancement in performance of CALC scripts, Business Rules, Data Loads.
• Maintained the Production, QA and Development environment as per the Service Level Agreement.
• Maintained all SOX requirements.
• Shared the hyperion related knowledge with the team and keep them abreast of any significant hyperion change managements.
• Interacted with hyperion vendor to share/gain the hyperion related knowledgebase.