SUMMARY OF EXPERIENCE

Project Manager

Confidential

• In this role I am tasked with providing overall technical leadership and championing the go forward campaign for a retirement services and mutual funds investments Data Warehousing and Business Intelligence implementation. The effort involves the implementation of Financial Actuarial Analytics, Marketing Analytics, Sales Analytics, and Service Analytics leading the team that is designing and modeling OBIEE 11.1.1.7.1 data models and Teradata 14.10 views on top of Teradata's Financial Services Data Models FSLDM and OBIA 7.9.6.3 on Siebel 8.1 CRM.

OBIEE Architect Consultant

Confidential

• My responsibilities were to review the overall OBIEE 11.1.1.7.1 architecture, BI physical and business data models, reports, and configuration files for performance tuning and data level security design. The BI platform was sourcing from an enterprise Data warehouse called Teradata Decision Expert TDE which is a pre-built data warehouse for Oracle E-Business Suite 11i/R12. The effort involved reviewing partitioning and indexing in Teradata for performance optimization.

OBIEE Architect Consultant

Confidential

• In this role my responsibility was to deliver a custom OBIEE 11g implementation in a retail environment. I served as the go to resource for BI and Data Warehousing implementation strategy, championing the BI roadmap delivery, conducting risk analysis, and developing risk mitigation strategies for the BIDW initiative. My technical responsibilities involved reviewing the BIDW technical architecture, security configuration, data modeling, and performance tuning. Part of the effort involved migrating reports from Hyperion Interactive Reporting and developing reports in OBIEE leveraging Exalytics-TimesTen performance and building custom Data Warehouse on Teradata 13.10/14.10.
• Developed the architecture, roadmap, and the Metadata to migrate and implement vendor metrics, vendor scorecards, Order guides, and Risk analysis reports to capture vendor performance over a specified period and risks associated with engaging different vendors. On this Vendor scorecard project I saved the client over 700,000.00 in the in 6 months in the development and support fees for the third party vendor who was engaged in developing the application that provided vendor management for the supermarket chain.
• Modeled and deployed BI level Star schemas to be used for Market Basket analytics for all supermarkets.
• Installed and configured Oracle BI Mobile App Designer for iPhone, Android, and iPads reports development and publishing. Developed Mobile App reports for the executive teams.
• Patched OBIEE 11.1.1.6.0 to 11.1.1.7.0 and further patched to 11.1.1.7.1.. Patched Exalytics environment from PS1 to PS2 then PS3, upgraded OBIEE from 11.1.1.6.0 to 11.1.1.6.11, Exalytics firmware upgrade, Exalytics Base Image from 1.0.0.3.0 to 1.0.0.4.0, Oracle Exalytics X2-4 Configuration Utilities v 1.0.0.5, Oracle TimesTen from 11.2.2.0.0 to 11.2.2.4.1, and Oracle Hyperion Shared Services.
• Used Oracle Data Integrator 11g ODI to create Master and Work Repositories, develop Interfaces, creating and modifying knowledge Modules, setting Topology and Agents. Configured ODI for TimesTen incremental loads.
• Developed a Merger and Acquisition Data Integration roadmap after Albertsons acquired United Supermarkets.

Oracle BI Applications Architect

Confidential

• I was tasked with implementing Oracle BI applications 7.9.6.3 Financials Analytics, HR Analytics, Project Analytics, and Procurement and Spend Analytics for The City of Richmond, Virginia. I was tasked with configuration of all these BI-Apps modules just vanilla OOTB. Editing and updating all required source files and lookup files for all the modules, configuring DAC 10.1.3.4.1, Informatica 9.0.1, and OBIEE 11.1.1.6.0 in a Linux environment. The main Source system was Oracle E-Business Suite Release 12.1.3, running Payables, Receivables, Fixed Assets, Purchasing, Cash Management, and General Ledger.

OBIEE Architect/Oracle Financials Consultant

Confidential

• I was contracted to install OBIEE 11.1.1.6 on Linux Red Hat and patching the environment to 11.1.1.6.6 also tasked with integrating OBIEE security with the client's enterprise LDAP authentication and performance tuning. On the Oracle EBS side I was engaged in validating functional setup in GL, AP, and FA. Serving in an advisory capacity on best practice for an Oracle E-Business Suite R12.1.3 environment and OBIEE. Upgraded OBIEE 11.1.1.6.6 to 11.1.1.7.1.
• Converted Oracle Discoverer 10g reports EUL into OBIEE by running EUL Migration Assistant to create the rpd and manually converted 315 reports. Developed reports in BI publisher publishing them in OBIEE dashboards. Tuned several existing OBIEE reports to enhance performance.
• Defined complete GL functional setups inclusive of all Ledger setups defining Chart of Accounts, Accounting calendars, currency, accounting methods. I defined primary ledger and secondary ledgers accounting options, organizations from Business Group, Legal entity, Operating Units.
• Customized the BI Publisher check rtf template by adding a barcode to the seeded template and registering a custom payment process profile in AP. Completed and delivered a BR100 for the setup changes in AP and GL.

Project Manager/BI Architect

Confidential

• I was tasked with managing and championing this Oracle Business Intelligence HR Analytics 7.9.6.3 on OBIEE 11.1.1.6. 0 implementation for CSX my duties included project planning, resource management, Project Risk Management, managing customer expectations, project procurement management, and overseeing all technical activities. This Oracle BI HR Analytics initiative was sourcing from PeopleSoft Human Capital Management 9.1, Taleo, SuccessFactors, and several other custom sources.
• Developed and presented a BI roadmap that is closely linked to the overall organizational strategic objectives. Project planning, scheduling, risk analysis, and monitoring and controlling project activities working towards achievement of identified project objectives.
• Coordinating and integrating team building on individual efforts to forge a positive professional relationship with the client. Conducted a risks identification exercise and worked with management to mitigate identified risks.
• Delivered a phased project plan that details work packages and tasks required to deliver the OOTB oracle BI platform followed by tasks that builds and deliver the required customizations to meet specific customer requirements.

Lead Technical Architect

Confidential

• environment that reduced maintenance cost, eliminate redundancy, and provide clear alignment to the overall business strategy.
• I was the Project Manager/Lead Architect for upgrading Oracle BI Applications 7.9.5 to BI Apps 7.9.6.3. Part of the project was to upgrade Siebel 8.0 to Siebel 8.1 delivering a greenfield clustered OBIEE 11g environment with six Oracle Business Intelligence servers for production along with three testing environments and a development environment. This effort involved installing and configuring Oracle BI Sales Analytics and Marketing analytics with the OBAW deployed on a Teradata 13 database. The new architecture introduced sharing a single Global BI environment among the North American business group and the International business Units. This architecture was designed deliver a risk-adjusted BI
• Reviewed client's current state environment and designed a future state to align with evolving business requirements. Reviewed the Project schedule to realign with work packages changes, collaborating with the PMO office.
• Realigned the project schedule and resource requirements with revised tasks and procurement lead times for hardware and client team availability for prototyping timelines.
• Documented legacy customizations migration approach for ETL mappings, custom tables and columns, transformations, and reports rationalization comparing new OOTB reports to legacy web catalog.
• Installed and configured OBIEE, Sales and Marketing Analytics, Informatica 9.0.1, DAC 10.1.3.4.1, and configuring Repository Services along with deploying OBAW onto Teradata 13.

DW/ BI Enterprise Architect Consultant

Confidential

• In this position I was the Lead Architect for delivering an Enterprise Data Warehouse EDW and Business Intelligence platform. The EDW was based on Teradata Financial Services Logical Data Model FSLDM The EDW was sourcing from RBS's 177 worldwide data source systems. This effort was aimed at cost reduction through reducing redundancy in maintaining several duplicative systems and optimizing processes that had the potential to deliver better returns to the business.
• Recommended the client to adopt TOGAF as their Enterprise Architecture framework to baseline their current state and mapped out a future state that is strategically positioned to deliver value through a well managed IT investment life cycle management practice.
• Created a BI project plan with a Work breakdown Structure WBS listing all work packages using Microsoft Project software package. OBIEE Teradata configuration and tuning for the existing OBIEE 10g and 11g environments for different Business Units. OBIEE 10g upgrade to 11g, rpd and web catalog merging on upgrade.
• Source systems profiling, ETL strategy analysis, dimensional analysis, business glossary development and extending Teradata FSLDM subject areas analysis and customization to align with client requirements.

OBIEE Architect /Oracle Financials RICE Manager

Confidential

• In this position I was responsible for delivering a custom OBIEE implementation and Oracle R12 E-Business Suite Financials. I was tasked with functional configuration of Oracle Grants, Projects, Payables, and Receivables. Worked closely with the PMO office and Program Management to realign project work with Metropolitan Washington Airports Authority's expectations.
• Developed project plan, resource plan, test plans, and cutover plan, applying appropriate project methodology.
• Delivered Oracle Payables, Grants, Projects and Receivables setups, test scripts, along with the respective BR100 documents and migrating setups to production and test using Dataloader and FNDLOAD scripts in Oracle EBS.
• Design and development of OBIEE rpd data models, configured security by integrating OBIEE with Oracle EBS to satisfy reporting requirements for each module and/or functional area.
• Developed 34 Financial Statement Generator FSG reports for the board of directors for MWAA in Oracle E-Business Suite Release 12.1.1. Created reusable Row, Column, Content, and display Set and Row Orders for FSGs.