SUMMARY

• Result - oriented Oracle Business Intelligence and EPM agile professional with 12+ years experiences in reconciling financial and operational data; leading ERP, EPM, CRM, and BI initiatives to support executive’s capabilities; delivering analytic reporting solutions for CFO, FP&A, Project Accountants, Project Controls, and other corporate function teams.
• Techno-Functional GL systems requirements experience in EPM and Finance domain; converting them into design specs and architecting end to end solutions of Hyperion EPM implementation application design, chart of accounts, and data integrations at server and application levels; managing various phases of financial consolidation and reconciliation process; implementing Oracle's on premise Hyperion suite of products such as Account Reconciliation Manager and HFM.
• Experience in Oracle R12 & 11i Financials (GL, AP, AR), Sub Ledger Accounts, Projects, HR, Procure & Spend (P2P, Invoice Lines), and Supply Chain & OM (Sales, Inventories) applications; ensuring design and develop solutions meets the needs of the business with respect to data infrastructures, federated data sets, source tables, EDW target tables, business rules, ETL processes, data models, RPD structures, HFM master metadata hierarchies, attributes, metrics, scorecards, and KPIs.
• Experience in requirements gathering with the business to lead user stories sessions, perform gap analysis, author functional design documents (BRD, FRD, TDD, RTM), work with developers for the build, write test scripts, providing offshore functional support, report development (worked through multiple iterations with clients, creating and revising reports and dashboards appearance and functionalities), data quality testing via (QA, UAT, SIT, Regression, PVT), data governance, and performance tune at application, report, RPD, Metadata, ETL, server, database, and source levels.
• Experienced in multiple global implementations of upper quadrant enterprise reporting solutions of OBIEE, HFM, Essbase, Oracle PBCS, FCCS, Hyperion Planning, Hyperion Smartview, Salesforce CRM, Power BI, and Tableau; integrating functional business experiences in financial analysis, planning, forecasting, projects, and cost accounting.
• Delivered multiple full cycle SDLC projects via Waterfall and Agile scrum. Managed multiple tasks; from leading project plans and timelines; determine sprints scopes, requirements gathering, developments, testing, and trainings.

TECHNICAL SKILLS

Operating Systems: Red Hat Linux 5.8 (64bit); Oracle Linux 6.0 (64 bit); UNIX; Windows XP/2000/NT

Sources and ERPs: Oracle EBS 11i & R12 ( 12.2.2) GFS, GSS, GL, SLA, AP, AR, Projects, Assets, HR, SC, P2P, PO, INV, OM, Sales modules; Oracle EBS Federal Financials R12.2.6; GL; AP; PO; AR; Oracle Budget Execution; iExpense; AR Advanced Collections; R12 EDI Payable; R12 SAM; R12 iSupplier; Salesforce CRM; SAP R3; IPCS by EcoSys; Liquid Office; JMMS; Prolog; CER; JDOCS; P2P; AS400; PeopleSoft; MS SQL Server

Databases: Oracle Database 11g R2 (11.2.0.4), MS SQL Server, Teradata

Packaged Analytic: OBIEE 12c (12.2.1.2), OBIEE 11.1.1.7.1 ; OBIA 7.9.6.4 (Financial, Projects, Supply Chain)

BI & ETL: SQL; PL/SQL; XML; HTML; Toad for Oracle ; SQL Developer; Notepad++, OBIEE 12c; OBIEE 11.1.7.1; OBIEE 11.6.5; Server & Client Tools 11.1.1.7.1 ; DAC 11.1.1.6.4 ; Informatica 9x; ODI 11g; Enterprise Manager; Weblogic; Answers; Tableau 8.2; Power BI; SAP BO; BI Publisher

CRM, EPM, CPM: Salesforce CRM; HFM (6.5.1); Essbase; FDMEE; Hyperion Planning; Oracle PBCS; Hyperion Brio 8.5, Hyperion Smartview for Office; Hyperion Account Reconciliation Manager, FCCS, WK CCH Tagetik

Other Tools: MS Office Suites (Excel, Word, PowerPoint, Access, SharePoint); Service Now; Smartsheet; JIRA; Microsoft Projects; MS Visio; Wall Street Suites; Numerix; Bloomberg; Calypso

PROFESSIONAL EXPERIENCE

BI Senior Consultant

Confidential

Responsibilities:

• Enterprise Services Center (ESC) - Delphi Services and Program Management Support Contracts: Delphi (Oracle EBS OFF R12.2.6) production data; R12 EDI Payable Invoice; R12 iSupplier; OBIEE 11g (11.1.1.9) and 12c production support.
• Gathered Financials (GL, AR) and Projects requirements; working with the business to configure custom financial reports .

Business Systems Analyst

Confidential

Responsibilities:

• Global implementations and upgrades of Jacobs’ Global Financial Systems (GFS); driving EPM (HFM) and BI (OBIEE) capabilities. Involved at all levels of BI implementation cycle e.g. defining roadmaps, mitigate risks, resolve issues, requirements gathering, solution design and developments, validating, configuring, troubleshooting, and users trainings.
• Upgraded Oracle EBS 11i to R12, implemented and completed several internal agile sprints projects within Finances (GL, AR, AP), Project Accountants, Sales, HR, ITFM, Intercompany Cross Charges, Workshare, and Supply Chain (GSM).
• Managed multiple tasks: Elicit and document users requirements to ensure design and development solutions meet the needs of the business by developing reports, data testing and validation, standardizing business rules, providing offshore functional support, and resolving any opened Service Now data issues at Report, RPD, ETL, DW, and Sources levels.
• Produced multiple iterations of reports, showing Actuals, Budget/Plan, Trends, Var vs. PY, and Variances of Revenues, Costs, GM, G&A Expenses, DSO, AR Aging, Billable & NBH Hours, Net Income, Operating Profit, Corporate Charges, Fringe Cost, Fixed Assets, Global Intercompany Cross Charges, Workshare IWS, and etc…at MTD, QTD, YTD, PTD, ITD views from a Consolidated and Ledger views at LOBs > BUs > Regions > Subregions > PU > Tasks > Expenditure Items > Invoice levels.
• Provided functional and technical solutions, set guidelines and standards for teams, reconciliation of data with business users, and user trainings. Used Smartsheet and JIRA to track design requirements, developments, and resolve data issues.

BI Manager

Confidential

Responsibilities:

• OBIEE, OBIA, HFM, Essbase, and Tableau implementation projects (Financials, Projects, HR, Supply Chain) for…Mastec Network Solutions; Manheim, a Cox Enterprises; and FIS Department at the University of Pittsburgh.
• Gathered Financials, Projects, and HR reporting requirements for the FIS Department at the University of Pittsburgh.
• Authored (BRD and TDD) and Data Lineage documents with detailed design solutions for custom reporting requirements.
• Enhanced performance of reports by implementing aggregate tables, partitioning, indexing, and views in the database.
• Performed unit testing for each dimensions and facts to validate data at source and in EDW target tables.
• Worked with the business to develop requirements, specifications, POC (mock ups), data modeling and mapping (analyse any changes required for ETL mappings and created mapping documents for ETL developers), customized RPD, configured roles and privileges, report and dashboards developments, standardized naming conventions, customized existing dimensions, logical objects configurations, detailed testing, and end users’ trainings during and post upgrades.
• Lead IT change management and developments of ITSM processes, including documentations, security access privileges, vendor management, project (evaluation, design, implementation, management), incidents resolutions, technical resolutions, applications management, go-live management, and end users trainings pre and post go-live.

Sr. Financial Analyst

Confidential

Responsibilities:

• Financial modeling, valuations, and reporting on profitability analysis, resolve variances, and worked thru multiple iterations on YoY valuations and assumptions analysis on individual cost centers’ operational performances.
• Private Equity Portfolio’s Financial modeling using P&L data that’s extracted from the GL (NAV) and report profitability at an individual and consolidated stores level (Contribution Profit) showing Fiscal YoY Forecast by period and FY annual projections at a consolidated P&L using assumptions of YOY sales growth rate. Provide variance of YoY metrics down to the individual contributing cost centers’ profit levels and by customers’ profitability; comparing YoY Revenue, COGS, Gross Profit, and GM for each month by product types.
• Built financial modeling scenarios for strategic planning, projections, market business analysis, valuation, performance tracking, and any (on the fly) ad hoc financial reports from the GL systems.
• Data governance review of business regulatory changes and accounting policies that may impact current valuations processes, procedures, thresholds, and SOX controls.
• Perform valuation of asset and debt portfolios processes for finance receivables (wholesale, real estate and commercial loans), securitized assets (retail loans), investment securities, debt portfolio, and other liabilities.