Epm Technology Lead Resume
Dallas, TX
SUMMARY:
Diverse experience in due diligence, business valuation, budget/planning, sales reporting, financial analysis, database management, and Hyperion Applications in various industries. Excellent analytical, problem solving, project management, teamwork and interpersonal skills.
COMPUTER SKILLS:
- Oracle Hyperion Planning/OBIEE Repository Certifications.
- Expertise in Hyperion Products such as HFM, Essbase, EPMA, Planning, DRM, FDM; Oracle Cloud Services (EPRCS/PCMCS/EPBCS).
- Hyperion Reporting tools: OBIEE, Interactive Reporting Brio, Financial Reporting Studio: Reports, Dashboards, KPIs;
- Administration and automation: JavaScripts, VisualBasic, shell/batch scripting MSAD setup, SSO.
- Excel, Access database, MS SQL, Microsoft on AWS Immersion Training, Power BI training
PROFESSIONAL EXPERIENCE
Confidential, Dallas, TX
EPM Technology Lead
Responsibilities:
- Led the offshore team on developing and performing the SIT and performance testings (Fiddler) of EPBCS applications, coached the team in testing methodologies
- Worked with the developers and clients to address their concerns, developed and presented SIT Test Plans, Scenarios, Cases and all other aspects of testing
- Finished testing on a timely basis, personally identified 90% of the defects in a team of three
Confidential, Nashville, TN
Senior Essbase/Hyperion Planning Developer
Responsibilities:
- Administered and configured Oracle Cloud Services (EPRCS/PCMCS) SSO and security, configured FDM data load rules, and created process automation using shell scripts
- Managed repositories (rpd), administration/security, configured MSAD, setup SQL, SISS, Micro Strategy data sources, and developed backup and recovery processes for OBIEE; expertise in front, middle, and back - ends of OBIEE
- Involved in version upgrades of Hyperion (LCM), migration to Exalytics, migration of an allocation model to PCMCS
- Developed Hyperion Planning models for accounting/finance department, created processes for budget/forecast variance analysis, developed user documentation, worked closely with end users to ensure a smooth yearly budget process and monthly forecast processes
Confidential, Nashville, TN
HFM/Essbase Administrator
Responsibilities:
- Assisted consultants in implementation of EPMA/FDM/HFM/Essbase, reconciled metadata and data against the legacy systems
- Developed and documented daily maintenance and month-end closing process for administrators and accountants, cross-trained co-workers on different aspects of Hyperion
- Administrated HFM/Essbase to ensure data integrity, user security, and timely, accurate reporting for 100 plus users
- Served as a guru/problem solver/mentor in HFM, Essbase, Smartview, FR Studio
Confidential, Nashville, TN
Senior Financial Analyst
Responsibilities:
- Managed multiple projects, spearheaded in database migration from relational-based to multi-dimensional
- Created metrics/dashboard for operations, designed Access/Hyperion/OBIEE reports, automated distribution of these reports using JavaScript, mxl and batch script, resulting more timely and accurate reporting for senior management
- Performed due diligence/business valuation for sale of multiple stores
- Improved budgeting/forecasting process, completed budgeting on a timely manner for 40 plus departments
- Developed a detailed financial model, enabling senior management to conduct strategic business planning, and helped raising funds from venture capital investors and stock IPO
Confidential, Nashville, TN
Business Analyst
Responsibilities:
- Developed a business improvement plan by modeling and simulating call centers using Arena Software, analyzed costs and benefits of consolidating call centers.
Confidential, Nashville, TN
Financial Analyst
Responsibilities:
- Heavily involved in due diligence (operating/financial stats, leases) on a $350 MM acquisition.
- Main contributions include financial modeling, industry analysis, offering memorandum drafting/proofing, summarizing and tracking terms and covenants, preparing and issuing covenant compliance certificates on a timely basis.
- Performed peer comparison/bench marking in the hospital management and health insurance industries, using operating and financial measures.