Dw/bi Architect Resume
Wichita, KansaS
SUMMARY:
- Recognized Subject Matter Expert in the field of Data Warehousing (DW) and Business Intelligence (BI) with a proven track record of success and ability to strategize and architect at a high - level then subsequently manage and perform hands-on development to implement actual solution.
- Managed and architected data warehouse (DW) and BI solutions from the “ground up” for major companies in various industries; including:
- Built DW and BI practices for several organizations (including what was then Confidential ’s newly-formed Confidential ) forwarding proven methodology and best-practices
- Speaker and author of articles in the field of Modern DW and BI Architecture and Optimization for organizations such as Confidential .
- Trained by Ralph Kimball on Dimensional Modeling.
- Implemented DW and BI solutions using various tool sets including Cognos, Microsoft SQL Server, Business Objects, Oracle BI, and Essbase. Architected and modeled data warehouses using Erwin, Power Designer, Visio, and ERStudio.
- Currently authoring a book for a major publisher ( Confidential Press) on the subject of creating complete and holistic solutions using today’s modern offerings.
PROFESSIONAL EXPERIENCE:
Confidential, Wichita, Kansas
DW/BI Architect
Responsibilities:
- For major, global conglomerate (previously the largest privately-held company in the world), designed and architected custom data marts to expose operational data coming from manufacturing plants.
- Designed BI solution and analytics to provide metrics and measures such as Production Efficiency, Operations Performance and Loss Opportunity.
- Developed frontend repots and provided mock-ups for dashboards. Subsequently, with these base analytic components in place along with Market Prices and Forecast Target Plans, delivered the final product as the Opportunity Scorecard for the Financial Department.
- Provided complete strategy and documentation for successful delivery including roadmap, project plan, data models, and source-to-target mapping.
- Held Confidential sessions with business users to gather requirements. Performed presentations for knowledge sessions and transfer. Mentored staff and troubleshot technical issues for developers.
Confidential, Boston, Massachusetts
DW/BI Architect
Responsibilities:
- Led Confidential department to assess and define requirements and needs for Procurement and Spend Analytics for the business.
- Provided overall strategy for reporting and analytics to for using the Oracle BI tools and technologies.
- Presented OBIEE and Confidential analytical capabilities to Chief Procurement Officer ( Confidential ) and Directors.
- Provided business requirements and design for Oracle BI Applications modules: Financial Analytics and Procurement and Spend Analytics to pull data from Oracle EBS R11 and R12 sources.
- Authored business and technical requirements for implementation.
- Assessed integration and capabilities of Informatica and DAC .between various sources for Confidential
- Formally trained entire Confidential project team on OBIEE and relevant BI development topics such as RPD
- Implemented Oracle BI Applications for Financial Analytics, Supply Chain Analytics - Order Management and Order Fulfillment, and Procurement and Spend Analytics with Spend Classification
Confidential, Framingham, Massachusetts
Managing Partner
Responsibilities:
- Created corporation offering complete, holistic DW and BI solutions.
- The firm success focused on a proven methodology called The Confidential Framework.
- This methodology focused on first establishing the data foundation in a proper dimensional model and architect for a successful and optimal BI and Analytics solution.
- Among the firm’s successes included being the f irst implementer to use the complete set of Oracle BI tools to include OBIEE, Oracle Data Integrator ( Confidential ) and Essbase as a custom BI development platform on the Oracle On Demand cloud.
- This project established and set the standard for other clients.
Confidential, Chelmsford, Massachusetts
DW/BI Architect
Responsibilities:
- Developed and presented Proof-of-Concept ( Confidential ) to CEO and Executive Board to win project implementation contract. Provided Confidential developed in Oracle BI and Microsoft BI (with SSAS, SSRS, and Sharepoint).
- Managed and led project team consisting of consultants, internal resources, and offshore Oracle On Demand staff to deliver end-to-end BI solution.
- Assessed complexities and planned project timeline and tasks.
- Staffed project with hard-to-find resources with skills such as for Oracle’s ETL product (i.e., Confidential ).
- Strategizes, developed, and implemented enterprise data warehouse and business intelligence solution (OBIEE and Essbase) for public company from the ground up.
- Established one version of the truth and one platform for reporting and analytics for the enterprise.
- Integrated Oracle EBS modules with Salesforce data for complete Order tracking and management.
- Architected data marts and initial financial subject areas in sales and revenue forecast.
- Created corresponding revenue forecast cubes using Essbase Studio.
- Architected and managed data models and OBIEE Repository using BI Administration tool.
- Migrated repository and updates between DEV, TEST, and PROD environments.
- Configured and maintained Confidential servers and repository.
- Forwarded Confidential concept and implemented data integration between Oracle EBS and Salesforce.
- Installed and configured OBI Apps Financial Analytics and Supply Chain Analytics (Order Management and Order Fulfillment).
Tools/Technologies: Oracle Business Intelligence Enterprise Edition (OBIEE), Essbase Studio, Oracle Data Integrator ( Confidential ), Oracle 11g, ERwin 7.4, Oracle On Demand infrastructure, Oracle EBS, Oracle BI Publisher.
Confidential, Phoenix, AZ
Enterprise Architect
Responsibilities:
- Member of Enterprise Architecture Group responsible for setting standards for the IT organization and for providing guiding principles to the company’s projects and providing overall strategy and vision.
- Established best-practices to data-centric projects such as the Enterprise Data Warehouse, Membership Application, and Data Foundation.
- Architected Confidential Strategy (using a hybrid implementation of Registry and Repository) for Customer and Product in new re- architected SOA environment for the Membership Application
- Managed internal team and Confidential offshore consultants utilizing Agile approach for development.
- Utilized IBM Confidential canonical data model (for the insurance industry) to architect framework and align and rationalize data for the enterprise and associated projects.
- Created and developed presentations to the Architectural Review Board for approval of projects and their respective solutions being developed for the enterprise.
- Authored technical white papers to establish standard and provide data design patterns pertinent to the EDW and ODS structures and handling Temporal Data.
Technology/Tools: Erwin 7, Cognos 8, Sparx Enterprise Architect
Confidential
Manager, (DW/BI Solution Architect)
Responsibilities:
- Data Lead for major (100+ consultants) multi-year prolific project for Confidential for DW/ BI implementation with Cognos to Oracle BI migration
- Data Acquisition manager for Oracle /Hyperion Financial Transformation project for Confidential company
- Created materials (to educate and train) and presented to leading organizations
- Performed and provided BI Assessments and Roadmap for Confidential (Oracle and Hyperion suite) and Confidential Corporation
Principal Consultant
Confidential, Framingham, MA
Responsibilities:
- Provided best practices, methodology, and approach for DW/BI consulting firm; as well as, providing overall strategic vision for the firm.
- Created material and provided support and presentations.
Director, Technical Services
Confidential, Boston, Massachusetts
Responsibilities:
- Managed internal consultants and project teams.
- Provided best practice and principles of data warehousing and business intelligence to create marketing database solution for global Siebel consulting firm.
- Introduced and incorporated new methodology to streamline the development lifecycle for business intelligence and analytic applications.
- Created client solution for marketing segmentation and lead generation.
- Architected customer data marts for Mercury Interactive and Lawson Products.
- Performed optimization and tuning of Confidential ’s Siebel Analytics (now OBI EE).
DW/BI Architect
Confidential
Responsibilities:
- As an Confidential, architected and implemented data warehouse and business intelligence solutions; providing best practices and principles.