Shahid Shah
Alexandria,VA
Summary
Over ten years of extensive experience in analysis, architecture, development, implementation, reporting, and migration of complex applications within client/server and Oracle EPM Cloud environments. Expert in Oracle EPM Cloud Products, including EPBCS, PBCS, FCCS, EDMCS, ARCS, EPRCS, alongside on-premises Hyperion Essbase, Planning, Financial Management (HFM), Shared Services, Interactive Reporting, and Smart View. Proficient in OneStream XF solutions, specializing in robust metadata hierarchy builds, member formulas, and application migrations across Development, QA, and Production environments. Expert in business process engineering and SDLC, with a strong focus on agile deployment processes. Certified Scrum Master (Scrum Alliance Certified Professional). Proven expertise in data analysis, data management, and systems integration, including leading the integration of Oracle Fusion ERP and Oracle HCM with EPM applications to optimize data flow for budgeting, planning, and reporting. Skilled in designing and implementing EDMCS solutions, including automated data sharing subscriptions, complex workflow/approval policies at the dimension level, and robust security configurations. Managed cross-functional teams (developers, analysts, stakeholders) to deliver integrated financial planning and reporting solutions, ensuring strict adherence to industry's best practices. Adept at creating complex Calculation Scripts, Groovy Business Rules, and Data Forms to meet intricate business requirements. Experienced in optimizing application performance, including implementing cube defragmentation processes and tuning HFM consolidation/data loading via Java API. Strong communicator with experience conducting demos, workshops, and comprehensive training sessions for business and end-users, enhancing adoption and efficiency. Active SECRET CLEARANCE (DOD-Active).
Professional developer with strong experience in system development and a focus on delivering impactful results. Known for excellent problem-solving skills, adaptability, and collaborative teamwork. Expertise includes coding, debugging, and system optimization. Reliable and responsive to evolving project needs, ensuring quality outcomes and client satisfaction.
Overview
11
11
years of professional experience
1
1
Certification
Work History
DAI Hyperion/EPM SME
Copper River Tech
08.2023 - Current
- Spearheaded the implementation and maintenance of Hyperion Planning and OBIEE applications, directly supporting WHS and OSD budget formulation processes.
- Collaborated extensively with WHS and OSD financial analysts to integrate budget data, ensuring seamless alignment with defense priorities and regulatory standards.
- Designed and led comprehensive training sessions for WHS and OSD analysts, significantly boosting adoption and efficiency by 30%.
- Streamlined the budgeting workflow, achieving a 70% reduction in errors and a 90% reduction in report generation time.
- Conducted comprehensive system and business analysis, including process and solution design, delivering detailed fit/gap assessments and actionable solution options with impact analyses.
- Guided the seamless transition from Hyperion to a cutting-edge EPM application, serving as the pivotal liaison between FMD OPS teams and developers, optimizing performance management.
- Architected dynamic Forms and Flex Forms, revolutionizing the spend plan process and compressing timelines from several months to mere hours.
- Familiarized WHS analysts with defense budgeting cycles and regulations, enabling compliance and precision in financial reporting.
- Demonstrated proficiency in data extraction, quantitative analysis, and large-scale project management with a focus on scalability and troubleshooting.
- Managed project planning, risk assessment, and stakeholder engagement for major EPM modernization efforts within WHS and OSD.
- Innovatively enhanced system efficiency and user satisfaction for government agencies through custom solutions and optimized workflows.
- Designed and developed custom reports and executive dashboards within Oracle EBS to support federal financial reporting, audit readiness, and decision-making.
- Partnered with government finance teams to configure and implement Oracle EBS in alignment with regulatory standards, optimizing workflows to mimic NGRMS submission processes.
- Managed end-to-end data integration between Oracle EBS and other financial systems, ensuring accuracy, efficiency, and timely reporting across platforms.
- Established best practices for knowledge sharing, fostering a culture of continuous learning and improvement.
- Served as a liaison between technical experts and business stakeholders to ensure alignment on project objectives and deliverables.
- Served as go-to expert for resolving technical challenges, enabling smoother project progression.
- Provided reporting for forecast analysis and ad-hoc reporting in support of decision-making.
EPM Consultant (DOD)
FedAnalytics
02.2022 - 07.2023
- Designed and developed a complex reporting system, providing end-user, production support, and administration for Accounting, Financial Reporting, and FP&A groups.
- Managed Planning (PBCS) applications, including data exchange, Smart Push jobs, and data mapping and hierarchies.
- Created data load rules in Data Management, configuring source and target applications, and data mappings for seamless data flow.
- Developed complex business rules and built custom calculations to automate financial processes.
- Created automation processes using EPM Automate for routine tasks and data loads.
- Responsible for application design, development, deployment, configuration, and support of Hyperion Planning / PBCS applications.
- Provided production and user support, managed metadata and data loads, user provisioning, and executed monthly and quarter-end operations for forecast and budget cycles.
- Developed Operational and Financial reporting packages in Narrative Reporting (EPRCS), including Dockets for Income Statement, Balance Sheet, and PPE reports.
- Created complex business rules for expense allocations based on multiple allocation methods.
- Performed Month-end close processes and reconciled data between source and target applications.
- Managed and maintained application security across various EPM modules.
- Participated in business requirements gathering for new financial report enhancements and coordinated multiple projects.
- Responsible for configuration installations, migrations, upgrades, and performance tuning of the EPM software stack.
- Gained experience in Workforce, Capex, and Financial EPM planning modules, with a focus on integrating Oracle HCM data for comprehensive workforce planning.
- Responsible for conducting end-user training & documentation for EPM Products, including SmartView, Webforms, and Financial Reporting Studio.
- Analyzed source and target systems for data requirements and gathered requirements for new enhancements.
- Developed Essbase calc scripts, business rules, EPM Automate, and shell scripts for automation.
- Designed and developed webforms and reports according to business requirements.
- Created ad-hoc analysis reports in Excel using SmartView for dynamic data exploration.
- Oversaw the integration and validation of point-of-sale (POS) data in Oracle RESA to ensure clean, reliable sales auditing.
- Built audit rules to catch transaction errors like mismatches and duplicates, helping improve data accuracy and compliance.
- Connected RESA with Oracle RMS to seamlessly update inventory and financial records after audits.
- Streamlined daily sales reconciliation by automating key processes, cutting down manual work, and speeding up month-end close cycles.
- Collaborated with cross-functional teams to successfully deliver comprehensive solutions for clients.
- Identified areas of improvement for clients operations, implementing targeted solutions to increase productivity.
Hyperion/OneStream Developer (DHA)
Definitive Logic
11.2020 - 01.2022
- Led end-to-end development of OneStream solutions, specializing in both Consolidation and Planning functionalities.
- Designed and implemented robust metadata hierarchies across key dimensions such as Account, Location, Product, Department, and Entity using the OneStream metadata build template.
- Developed and configured cubes tailored for Consolidation and Planning, ensuring accurate financial reporting and analysis.
- Adapted quickly to new technologies and programming languages, enhancing overall team productivity.
- Created and optimized Workflow Profiles, enabling corporate users to input budgets and forecasts directly into forms.
- Designed cube views to support streamlined forecasting, focusing on Income Statement and sales event analytics.
- Authored member formulas within supplemental dimensions to drive key metrics such as monthly and yearly variance percentages.
- Built automated Data Management jobs to align Actuals with Planning data and enhance financial accuracy.
- Developed ad-hoc reports using Quick View for executive-level financial analysis.
- Managed ongoing metadata maintenance and supported key administrative tasks such as security updates and critical forecast cycle data copies.
- Created workflow dashboards with custom-calculated business rule buttons to enhance planning efficiency.
- Designed Transformation Rules and Confirmation Rules for file-based data loading processes.
- Built dashboards, web forms, and workflow profiles to facilitate user input and data adjustments.
- Utilized Jira for progress tracking and organized testing processes, creating comprehensive End User and Administrator Guides.
- Worked closely with clients to gather requirements and translate them into technical specifications for implementation.
- Documented software development methodologies in technical manuals to be used by IT personnel in future projects.
Financial System Analyst
BI TECH SOLUTIONS INC
08.2016 - 10.2020
- Provided production support for Hyperion Financial Management, Planning, Essbase, and Financial Reporting applications.
- Collaborated with the functional team to enhance existing processes for continuous improvement.
- Created financial reports, planning web forms, and Excel templates on SmartView for various business needs.
- Managed the change management system, created test scenarios for UAT, and facilitated migration to production environments.
- Scheduled monthly variance reports and trend reports using Workspace with the bursting option.
- Created composite forms for improved data visualization after data submission.
- Translated strategic business needs into practical consolidation and reporting solutions.
- Defined systems strategy; developed system requirements; designed, prototyped, implemented, and launched solutions.
- Created necessary project plans during client design sessions to ensure alignment with business objectives.
- Proactively and frequently communicated with customers to build and maintain solid working relationships.
- Designed and built required reports using Hyperion reporting applications, including SmartView.
- Performed optimization of Planning and Essbase applications to enhance performance.
- Maintained the security of the system using Shared Services for all components.
- Supported users for their SmartView and Excel add-in issues.
- Maintained and monitored the nightly backup process and weekly maintenance.
- Utilized LCM for migration on an ad-hoc basis for application artifact security.
- Managed multiple projects simultaneously while adhering to strict deadlines and maintaining high-quality deliverables.
- Collaborated with cross-functional teams to implement process improvements, reducing manual tasks and increasing productivity.
- Streamlined budgeting and forecasting processes for increased efficiency and reduced errors.
- Supported finance team members with ad-hoc analysis requests, enabling data-driven business decisions.
Data Analyst
WHITE FEATHER GROUP
05.2014 - 07.2016
- Developed and maintained financial statements using Microsoft Excel.
- Utilized Hyperion Financial Reporting Studio to provide financial statements and reports to management.
- Created SQL queries to run reports for data analysis and validation purposes.
- Managed, updated, and manipulated report orientation and structures with the use of advanced Excel functions, including Pivot Tables and V-Lookups.
- Utilized data visualization tools to effectively communicate business insights.
- Created various Excel documents to assist with pulling metrics data and presenting information to stakeholders for concise explanations of best placement for needed resources.
- Conducted ad-hoc analysis to address urgent business questions, facilitating rapid response to market changes.
- Assisted with creating data cubes and OLAP models to improve data analysis.
- Improved decision-making processes with accurate data analysis and visualization techniques.
Education
Bachelor of Science - FINANCE
SOUTHEASTERN UNIVERSITY
Washington, DCSkills
- Oracle EPM Cloud
- EPBCS
- FCCS
- EDMCS
- ARCS
- Narrative Reporting
- Data Management
- EPM Automate
- Groovy Scripting
- REST APIs
- Hyperion Planning
- Essbase
- HFM
- Financial Reporting Studio
- Smart View
- OneStream XF
- Quick View
- OBIEE/OAS
- ADVANA
- SQL
- SQL Server
- Essbase Calc Scripts
- Power Shell Scripts
- Batch Scripts
- VBNET
- JIRA
- ERP Systems
- Oracle Fusion ERP
- Oracle EBS
- Oracle ReSA
- Oracle HCM
Certification
- Security Plus certification, CompTIA, 2027
- Project Management, PMP, 2027
- Certified Scrum Master, 2027
Clearance
SECRET CLEARANCE (DOD-Active)
Timeline
DAI Hyperion/EPM SME
Copper River Tech
08.2023 - Current
EPM Consultant (DOD)
FedAnalytics
02.2022 - 07.2023
Hyperion/OneStream Developer (DHA)
Definitive Logic
11.2020 - 01.2022
Financial System Analyst
BI TECH SOLUTIONS INC
08.2016 - 10.2020
Data Analyst
WHITE FEATHER GROUP
05.2014 - 07.2016
Bachelor of Science - FINANCE
SOUTHEASTERN UNIVERSITY
Similar Profiles
Michael MendozaMichael Mendoza
Server/Bartender at Copper River Country ClubServer/Bartender at Copper River Country Club
TENEISHA BROWNTENEISHA BROWN
Senior Lead CAD Specialist at Copper River Technology LLCSenior Lead CAD Specialist at Copper River Technology LLC
Tell HandTell Hand
Prevention Technician at Copper River Native AssociationPrevention Technician at Copper River Native Association
Jabari NeddJabari Nedd
Linux System Administrator (contract) at Army National GuardLinux System Administrator (contract) at Army National Guard
Alyson NashAlyson Nash
Director of Business Development at Price ModernDirector of Business Development at Price Modern