SUMMARY:

• Business Intelligence
• Data Warehousing
• Web Development
• Data Science
• 10+ years experience managing Enterprise BI web application implementations, covering key business processes across industry verticals.
• System implementations include Oracle BI, Microsoft, Tableau, SAP/BO, Crystal Reports, Microstrategy, +++
• I have ten years of Business Intelligence and fourteen years of enterprise technology experience.
• I have nine years of Informatica T - SQL & PL/SQL experience, which has been my primary Data Warehouse toolset.
• Over the years I have held both functional and technical roles on Developer & BI project teams, operating as a Team Lead, Project Manager, Account Manager, Business Analyst, Data Architect, Trainer and Developer.
• I have extensive experience with the Oracle Software Suite where I have configured OBIEE/Siebel Analytics data warehouses for Siebel, JDE, PeopleSoft and EBS Oracle Applications.
• I also have configured many business intelligence applications using Microsoft SSAS/SSIS/SSRS / VB / Sharepoint / etc.

TECHNICAL SKILLS:

Applications: Oracle Business Intelligence Enterprise Edition 12.x, 11.x, 10.x, Siebel Analytics 7.8.x, 7.7.x, Informatica 9.x / 8.x / 7.x, Data Warehouse Administration Console (DAC) 12.x, 11.x, 10.x, 7.x, EBS 11 & 12, JDE E1, Siebel 7 & 8, Weblogic

Business Processes: Marketing & Campaign Management, Sales Force Management, Supply Chain / Inventory / Costing, Order Management, Financials, Procurement & Spend, Project Accounting, Human Resources

Programming: SQL, PL/SQL, T-SQL, Java, HTML, JavaScript, CSS, Python, R

Database: ORACLE 12c/11g/10g/9i/8i, MS SQL Server 2012/2008/2005/2000 , Microsoft Access, mySQL

Software Packages: MS Office Products, Visio, Business Objects, Crystal Reports, Windows Servers, Redhat Linux & OEL

Tools: and Methods:: Oracle Data Integrator 12.x/11.x, Siebel Tools 7.x, MS SSIS, TOAD, ERWin ER-Modelling

PROFESSIONAL EXPERIENCE:

Technical Implementation Lead

Confidential

Responsibilities:

• Implemented BI Applications 7.9.6.3 for Financial & Procurement Analytics on OBI 11G against EBS R12 source.
• Built out OBIA Datawarehouse with additional source information from Ariba (AP/Procurement) & Salesforce systems.
• Infrastructure activities including all OBIEE/DAC and Informatica installations, patching, SSO and configuring Action Links.
• Responsible for data warehouse design and ETL solution, contributed on RPD and dashboard development ensuring successfully delivery of all technical areas.
• As Architect with one developer resource, stood up OBIA for Finance including integrating a 3rd party AP data source in four weeks solidifying Oracle BI’s position at Facebook preceding their IPO when there was much competition between tools. Continued delivering outstanding results in turn steadily growing user adoption - from POC to hundreds of production users relying on the system within months.

Solution Architect

Confidential

Responsibilities:

• Designed and developed CDH Analytics star for customer data quality, and enhanced existing OBIA data warehouse to include CDH attributes in existing stars such as Finance, Order Management, etc.
• Primary developer in all aspects of implementation, including DW design, Informatica ETL, RPD configuration and Dashboard development.
• Primary Business Analyst responsible for meeting with multiple functional groups to gather requirements for dashboard deliverables.

Solution Architect

Confidential

Responsibilities:

• Implemented BI Applications 7.9.6.3 for Supply Chain and Financial Analytics on OBI 11G against JD Edwards E1 source.
• Implemented custom Projects, HR, Fixed Assets, and Procurement Analytics for JDE source.
• Managed a team of 4 OBIEE resources and 3 offshore InInformatica ETL resources.
• Oversaw data warehouse design and Informatica ETL solution, contributed on RPD and dashboard development ensuring successfully delivery of all technical areas.

Solution Architect

Confidential

Responsibilities:

• Customized OOTB Oracle EBS-sourced Order Management Analytics to include Bookings from OM as well as Service Contracts & Project Accounting. Also implemented customized AR/AP/Revenue/GL 7.9.6.1 BI Applications.
• Was lead architect on project specializing in Infrastructure, DW & ETL layers.
• Upgraded hardware and integrated existing Siebel-sourced Analytics into EBS DW to enable advanced CRM to Cash reporting.

Solution Architect

Confidential, NM

Responsibilities:

• Customized OOTB Oracle EBS-sourced Project Analytics Informatica ETL, including extracting from in-house built Funding and Forecasting EBS modules.
• Extended BI Applications 7.9.6 Human Resources by building custom subject areas for Benefits management. Responsible for DW, ETL and RPD development.

Solution Architect

Confidential

Responsibilities:

• Customized OOTB Oracle EBS-sourced Financial Analytics Data Warehouse to source from separate EBS 11.5.10 and R12 systems.
• Trained an overseas team to be proficient in OBIEE and DAC/ETL for production support and configuration.
• Designed, developed and documented several custom Data Warehouse stars including Credit Management subject areas.

ETL Lead

Confidential

Responsibilities:

• Customized OOTB Oracle EBS-sourced Inventory & Order Management Analytics to manage the Supply Chain for a multi-national company.
• Designed, developed and documented several custom Data Warehouse stars for Cost and Product Transaction snapshots.
• Focused on performance tuning Informatica ETL solutions to optimize load times and enable increased daily refreshes.

Sr. Systems Analyst

Confidential

Responsibilities:

• Led project team on customizing OOTB Siebel CRM Analytics (OBIEE) to measure operational effectiveness of field Sales teams.
• Lead on architecture & design of several custom Data Warehouses to serve reporting needs for Campaigns, Government Pricing and various contract-related systems.
• Led regular requirements sessions with all levels of Business management including regular sessions with VP level.
• Knowledge transfer, training and continuous education to Business owners regarding the BI tool, the reports and validity of the data.

Technical Analyst

Confidential

Responsibilities:

• Primary business analyst for Operations department in building new systems to enhance Operational effectiveness
• Lead the DW design efforts to create new areas of analysis for Benefit Coordinators to validate existing restrictions in the POS system
• Project management, requirements gathering, data analysis and application administration of data management systems

Data Analyst

Confidential

Responsibilities:

• Responsible for requirements gathering, design, implementation and validation of several large-scale data storage solutions
• Extensive use of SQL Server DTS tools to extract, load and transform data
• Worked closely with C# developers to ensure data model was tuned for application performance