We provide IT Staff Augmentation Services!

Technical Lead Resume

3.00/5 (Submit Your Rating)

SUMMARY:

  • Over 22 years of IT consulting experience in design, development, project management and implementation
  • Over 16 years of experience in Oracle Hyperion Planning and Essbase
  • Implementation experience with Oracle EPM Cloud - PBCS and EPBCS
  • Oracle Hyperion Certified Planning and Essbase Consultant.
  • Implemented Hyperion solutions-based projects at numerous clients (including many fortune 500 clients)
  • Designed and developed various application prototypes, models for Hyperion Sales team (such as Hyperion Public Sector Planning and Budgeting application prototypes, Essbase Log-based usage application, etc.)
  • Worked with people at different level of management, business and technical people across different teams
  • Areas covered (but not limited to): Project scoping, Server architecture and sizing, Business requirement gathering, Fit-gap analysis, prototyping, detailed solution design (Functional and Technical designs), development/implementation, Test, Migrations, Version Upgrades, Performance Optimization, troubleshoot, Security architecture, (Server, Application, Security and Data) - Backup and Restore, process automation, Administration and support.
  • Expertise in function and technical (hands-on) roles
  • Over 25 Hyperion Planning and Essbase projects implemented - in roles of technical consultant, Functional / technical Lead, Solution Designer, Senior architect, Principal consultant, administrator, Support, mentor & management advisory
  • Performed Hyperion Planning implementations (Version 3.3 to 11.1.2.4) using Classic, EPMA and Cloud-based (EPBCS, PBCS) technologies
  • Expert at identifying and defining Dense/Sparse dimensions, attribute dimensions, custom (user defined) dimensions
  • Performed Hyperion Essbase implementations (Version 5.0 to 11.1.2.4) using BSO, ASO and Hybrid technology
  • Implemented Hyperion Planning applications in areas of FP&A, Forecasting, Budgeting (various types), Strategic planning, workforce planning (custom as well as out-of-box solution), CAPEX (custom as well as out-of-box solution), for client’s unique planning requirements as well as for Public Sector Planning
  • Developed event-based scripts for FDMEE using Jython to interact with source and target environments
  • Expertise and hands-on experience in process automation in Windows, UNIX environments with MAXL and ESSCMD for all types of Hyperion (and required ETL) process automation and system backups.
  • Expertise and hands-on experience in Hyperion applications upgrade (migrate/re-develop solutions to newer versions with valuable enhancements), or design/upgrade them in Hyperion from other technologies
  • Expertise and in Essbase/Planning configuration, Performance tuning and Optimization in processes such as - dimension build, data load, indexing, calculations, MDX, cache management, partitions, Shared services, Security, server configurations, Active Directory, EAS, EPMA, DRM, LCM, Planning web and other several low level utilities.
  • Configured Hyperion environment, set backup/recovery processes, set security using Hyperion Shared Services, Active Directory (SSD) configuration, LCM, etc.
  • Expert at supporting existing Hyperion environments, applications, system and substitute variables
  • Expertise in preparing and optimizing dimension build processes, data load processes and user management using interfaces of flat files, SQL tables, as well as ADS files for DRM and EPMA
  • Expert at preparing processes to manage hierarchy maintenance and slowly changing dimensions from EPMA and DRM
  • Prepared various dimension-based models for multiple Hyperion products in EPMA/DRM

TECHNICAL EXPERTISE

Oracle Hyperion Suite of Product: Hyperion Planning (v. 3.3 - 11.1.2.4 ): Oracle EPM cloud (PBCS, EPBCS), Hyperion Planning(Classic, EPMA Planning), Calculation manager (Business Rules), Web Forms (Simple, Composite and Customized Forms), Workforce, CAPEX, PSPB - Public Sector Planning and Budgeting, Outline Load and EPMA dimension build (tools, utilities), Custom Menus, Workflow and Approval process, Security Hyperion Essbase (v. 5.0 - 11.1.2.4 ): BSO, ASO, MaxL (MAXL, MSH, ESSCMD) scripting, MDX, Calc Scripts, Report Scripts, EAS, Load rules, Dimension build Rules, Essbase Studio, Custom-defined functions (CDF), scripting, Security architecture, ESSBASE studio etc.

Other Hyperion tools: Workspace, Smart View, Hyperion Shared Services, LCM, FDMEE, DRM, ODI, HAL, FDM, HFM, Jython Scripting, EIS, Excel Add-In, Report Scripts, Hyperion Financial Reporting Studio, Data integration (between Hyperion applications as well as with other data sources), Security (architecture, definition, design), etc.

Relational Databases: Oracle 5.x-12c (SQL, PL/SQL, Procedures, Packages, and many other tools from Oracle) MSSQL (SQL, T-SQL, and many other tools from MSSQL), DTS, DB2, MS ACCESS etc

Scripting and other tools: Hyperion MAXL and MSH Scripting Automation, Batch scripting in Windows (DOS)/UNIX (Shell) with many batch schedulers, JIRA, Excel, VBA

ETL Tools: MS SQL Server Integration Studio (SSIS), MS SQL DTS, Oracle Warehouse Builder, Data Stage, SPSS ER, etc

Operating Systems: Windows 2003, 2008/NT, UNIX, Sun Solaris, AS/400, DOS

PROFESSIONAL BACKGROUND/EXPERIENCE:

Confidential

Technical Lead

Environment: Oracle EPBCS, PBCS, Hyperion 11.1.2.4 (Hyperion Planning, Essbase), Essbase (BSO/ASO/Hybrid), MAXL, Essbase Studio, Smart View, Windows 2008, Sun Solaris (UNIX), Linux, MS Excel, JIRA, Oracle (SQL, PL/SQL, ODI)

Responsibilities:

  • Worked as a Lead Consultant / mentor for Client’s major Hyperion Planning implementation project
  • Global Capital Markets related planning application was built over cloud (EPBCS)
  • Solution was around planning, budgeting and forecasting (including multi-layer workflow process) for Scotia bank’s different business areas from geographical locations, customer segments, products, and departments in multiple currencies (since bank has global banking business) consisting 15 standard dimensions and 3 attribute dimensions.
  • Responsible for functional and technical design, development areas in client’s Hyperion Planning and reporting (Essbase) implementation during Scotia’s tier-4 build process
  • Worked with Oracle, Deloitte and Infosys advisories to resolve heavy dimensionality and partition related issues by using hybrid outlines in applications to bring optimized performance
  • Designed layout and trending for planning solution with certain business-centric calculations for Financial Planning areas
  • Built complex calculation rules from provided business rules and logics to populate and calculate data
  • Prepared different source feed for Hyperion projects as per project requirements
  • Set dimension build and data load processes from EBS and user spreadsheets using DRM, ODI/FDMEE tools
  • Designed required web forms, calc manager rules, seeding calculation scripts, automation process, menus, task lists, workflow/approval process etc.
  • Helped Financial Planning team dependencies and reworks, bring transparency in calculations, ease users planning and budgeting tasks, and help management reduce resource overhead and efforts

Confidential

Lead Consultant

Environment: Oracle Hyperion 11.1.2.2 and 11.1.2.4 (Hyperion Planning, Essbase), Essbase (BSO/ASO), ODI, MAXL, Smart View, Windows 2008, Sun Solaris (UNIX), Linux, MS Excel, Oracle (SQL, PL/SQL, APEX)

Responsibilities:

  • Played Solution designer, Administrator, project manager and lead consultant’s role to bring stability in highly complicated applications and enhance process/design as a part of Hyperion implementation improvisation
  • Worked in mentor’s role for 7 consultants in the team as needed to bring support, comfort and success
  • Solution was to provide budgeting and forecasting grant-based payment
  • Defined and built Schedules and calculations based on seeding, allocations and driver-based values, grants related parameters, populate reports for calculated values using Map reporting application
  • Prepare data transactions and payment related transactions with help of FDMEE and ODI
  • Prepared web forms and calculations for each grant cycle to input/calculate different level of data forms and calc
  • Data were sourced from Oracle EBS (Oracle Financial and other modules) and other data sources using FDMEE
  • Design required web forms, calc manager rules, seeding calculation scripts, automation process, menus, task lists, workflow/approval process etc.
  • Helped Financial Planning team dependencies and reworks, bring transparency in calculations, ease planning work, and help management reduce overhead from planning overtimes as well as team size.

Confidential

Technical Lead / Solution Architect

Environment: Oracle Hyperion 11.1.2.3.500 (Hyperion PSPB / Planning), Essbase (BSO/ASO), PBCS, FDMEE, Essbase Studio, Workforce, ODI with Oracle EBS, MAXL, Smart View, MS Excel

Responsibilities:

  • Went thru business sessions and gathered client’s Financial planning/forecasting needs in areas of P&L, Balance sheet, Labor / Workforce.
  • Designed layout and trending for planning solution with certain business-centric calculations for Financial Planning areas.
  • Managed BRD and solution design sessions and prepared prototype solution in Hyperion PSPB to fit with clients needs
  • Provided fit-gap analysis using PSPB vs. classic planning application with necessary customized implementation (Client chose custom solution, looking at limitations of PSPB and after discussing with Oracle sales/ Solution team)
  • Design required web forms, calc manager rules, seeding calculation scripts, automation process, menus, task lists, workflow/approval process etc.
  • Helped Financial Planning team dependencies and reworks, bring transparency in calculations, ease planning work, and help management reduce overhead from planning overtimes as well as team size.
  • Data were sourced from Oracle EBS (Oracle Financial), PeopleSoft HR and other sources using FDMEE
  • Worked with management to reduce employee overtime costs and bring complete planning process with more efficiency and transparency.
  • Joined this project 3 months late with constant deadlines in focus (when project was about to explode).
  • Took a challenging role on client’s major Hyperion implementation project and delivered
  • Functioned in multiple roles of Technical Lead, mentor and Solution Architect
  • Provided best solutions in areas of Workforce, P&L strategic planning, budgeting and forecast process, including various planning models, KPI and reporting solution
  • Worked with Web-based reports, interfaces, Conversions, Extensions and other objects within Hyperion planning and PSPB
  • Project had many hurdles and complications. I brought ease in this high-octane project, dealt with business users as well as end users and delivered quality solution with strict deadlines (very much in one-man show) where everyone in the team had already gave up.
  • Worked in role of project manager/co-ordinator as and when required (from Confidential side)
  • Apart from this, I also worked with Confidential in their pre-sales and POC area for PBCS implementation at University of Manitoba during this period of time
  • Implemented Labor Workforce solution to cover areas of:
  • Salary, Bonus, various types of commissions, deductions (taxes, CPP, EI, Pension plans, union fees etc)
  • Covered transfer in/transfer out, start/end dates for Full-time, Part-time, Interims, Co-ops, and Contract positions
  • Calculated Expected salary increments, bonus and ranks and more

Confidential

Functional Lead

Environment: Oracle Hyperion Fusion 11.1.2.3 (Planning and Essbase), ODI, MAXL, Smart View, MS Excel, Windows 2008, Oracle, SQL Server, PeopleSoft

Responsibilities:

  • Designed and implemented solution with certain business-centric enhancements for this migration project (from legacy Hyperion application to newly proposed solution)
  • Removed all overheads such as XREFs between multiple applications and merged applications in one reporting application as a part of solution
  • Split and defined account and entity level members of forecasting, budgeting and strategic plan to propose FP&A related optimal solution for Hyperion planning.
  • Defined seeding calculations with help of business users (existing seeding calculation was good for only 4 months and was not producing expected results in business spreadsheets for next 20 periods).
  • Identified required parameters that can affect forecasting calculations
  • Data were sourced from Oracle Financial, PeopleSoft HR using ODI modules/procedures
  • Identified users input and adjustment areas for budgeting, strategic plan and forecast solution
  • Designed / developed required web forms, calc manager rules, seeding calculation scripts, automation process, menus, task lists, workflow/approval process etc.
  • Defined process for monthly and yearly Essbase and planning application maintenance
  • Implemented complex data seeding process for forecasting (Calculation is spanning next 21 periods with different calculation for each of periods. Developed 20 different calc scripts to organize each of those account/entity based calculation and set them in automated process with such an efficiency that, the full seeding automation process takes only 6 minutes to run / loop thru required calc scripts for each of 21 periods. Manually this process used to take 3+ user-weeks per period.)

Confidential

Project Lead Consultant & Solution Designer

Environment: Oracle Hyperion Fusion 11.1.2.2 (Planning and Essbase), ODI, MAXL, Smart View, MS Excel, Windows 2008, Sun Solaris (UNIX), Oracle (SQL, PL/SQL, APEX)

Responsibilities:

  • Provided innovative solutions for migration of historical data from legacy systems to newly proposed solution
  • Built optimal solution to integrate with existing systems that will either provide input e.g. Enhanced Data Collection Solution (EDCS), USER, No Name solutions) to feed fund disbarment to transfer payment authorization system e.g. PFIS-TP (Postsecondary Finance Information System - Transfer Payment) Module using ODI
  • Built system screens (forms), task lists, workflow, menu, data access etc
  • Conducted unit/integration testing to ensure full coverage of source code and component level testing is in place before handing over the solution to quality assurance analyst.
  • Liaised with IT specialists, unit leads and work closely with project team members and relevant stakeholders.
  • Participated in conducting feasibility analysis, project scoping and providing project work estimates to effectively manage change requests resulting from requirements elaboration phase
  • Participate in joint requirements planning and joint application design sessions to ensure that final solution is built as per client expectations.
  • Used ministry mandated requirement tools and templates for documenting system source code.
  • Identification and resolution of problems/issues throughout project life cycle
  • Proactively identified and proposed remediation strategies for project technology related risks.
  • Liaised with other project teams technical resources to coordinate project interdependencies
  • Documented of all artifacts in a shared project library utilizing tools in use at CSC
  • Conducted and/or participated in walkthroughs at each project milestone.
  • Reported status to and followed overall direction from the Project Manager and/or IT Lead.
  • Conducted research and provided input into the development of presentations for ministry and cluster staff and executives.
  • Provided innovative solutions to any identified limitations of the proposed technologies in meeting any of the business requirements or non-functional requirements related to security, privacy, accessibility, common look and fell and other applicable GO-ITS standards
  • Performed fit-gap for public sector planning for the client (Not fit in clients requirement due to additional functionality, reporting and dimensional needs )
  • Effective knowledge transfer to FAAB and I&IT Cluster at all stages of this project.

Confidential

Senior Lead

Environment: Oracle Hyperion Fusion 11.1.2.1 (Planning and Essbase), Oracle Enterprise, EAS, LCM, MAXL, Smart View, MS Excel, Windows 2008, Oracle (RDBMS), Oracle Warehouse Builder, Sun Solaris (Unix)

Responsibilities:

  • Involved in project scope, project and servers sizing, server architecture, system / application design, development, implementation, test, backup/recovery process, DR setup, security architecture and migration
  • Led multiple projects with requirement gathering, design, developments and other project tasks
  • Responsible for servers and applications scoping and optimization
  • Responsible for providing solution and documentation from every level of project that includes but not limited to above mentioned area.
  • Worked on client’s Financial reporting applications, GL summary and KPI related key Hyperion projects.
  • Defined process for each yearly Essbase and planning application maintenance
  • Delivered overall automation processes such as preparing LCM backup process, Essbase and Planning metadata build, data load, security and application integration related all processes to make admin role easier.
  • Prepared automation process to bring data from Oracle Financials GL and stage / load them into Essbase applications with set of codes to audit load and data aggregation results.
  • Prepared Hyperion backup process in such a way that can provide an ability to recover all applications and full Hyperion environment (including security) from last backup within couple of hours to support DR needs
  • Prepared web forms in order to make them efficient and compact, to fulfill client needs.
  • Prepared processes to auto-generate calculations and report scripts to integrate applications for data needs.
  • Optimized Essbase and planning applications from source and server side.
  • Worked in project management area as per requirements on RAD development model
  • Worked on application, process and database optimization, and server configuration where applicable

Confidential, Basking Ridge, NJ

Hyperion Planning and Essbase Consultant

Environment: Oracle Hyperion Fusion 11.1.1.3 - Planning, EPMA, EAS, Workforce, MAXL, MS Excel, Windows 2008, Oracle RDBMS, UNIX (Korn Shell)

Responsibilities:

  • Worked on Hyperion workforce application implementation project as part of the Ranzal/ Confidential Team
  • Worked on technical design and development part of Verizon’s Hyperion planning’s customized workforce solution.
  • Converted one Essbase reporting application with large dimensionality from BSO to ASO data structure

Confidential, Tampa, FL

Hyperion Planning and Essbase Consultant

Environment: Oracle Hyperion Fusion 11.1.1.3 - Planning, EPMA, EAS, Workforce, Workspace, Web Analysis, Financial Reports, MAXL, MS Excel, Windows 2003/NT, DRM, HFM, Oracle RDBMS, Sun Solaris (Unix)

Responsibilities:

  • Worked as part of the Ranzal Team, worked on Hyperion application implementation project
  • With Confidential performed numerous functions including production support, process hardening and a review/advisory role for applications prepared by a different consulting company
  • Was tasked to make applications more stable, workable and efficient
  • Provided recommendations towards application and process architecture / redesign given the less than desirable work done by previous consultants

We'd love your feedback!