SUMMARY:

• Senior - level business intelligence (BI) architect with expertise in Oracle database design, data modeling, mathematical modeling, statistical analysis, econometrics, business intelligence, reporting, data management, and administration. Extensive experience in working with relational databases, primarily in the Oracle Technology space. Experience also includes designing Extract, Transformation, and Load processes, and consolidating, cleansing, and filtering data. Also designed and built a number of Decision Support and Business Intelligence Systems and supporting data marts.
• Focused on Oracle Business Intelligence (11g and 10g) for the past 7 years serving as administrator, developer, and as Lead Architect. Also standardized the Confidential approach to OBIEE development, providing guidelines for RPD development as well standards to be enforced in any and all OBIEE development projects. Experience in both SQL and PL/SQL programming, and managed several large database and decision support-related implementations spanning a number of high-profile clients, from industries including: health care, finance, manufacturing, and the Federal Government.
• Over the past two years has worked for Confidential and Price Waterhouse. Started and managed a successful consulting company for 14 years prior to joining Confidential . During this time, I gained considerable experience in client-facing situations Confidential the senior management level. Subject matter expert in market evolution, particularly as it impacts information technology and IT organizational roles, and has assisted numerous organizations in managing IT changes and adapting themselves to new ways of doing business. As owner of Confidential, I managed and coordinated the work of small and medium size teams.

TECHNICAL SKILLS:

Software / Products: Oracle Databases from 6.x to 11g, Oracle Developer and Designer, Erwin, Oracle Business Intelligence Enterprise Edition 10g, Oracle Business Intelligence Enterprise Edition 11g, All other Oracle tools, such as SQL*Loader, SQL*Plus, etc., Microsoft Suite of Products

Hardware / Operating Systems: MS-DOS, Windows, Windows XP, Windows Vista, Windows 7, Oracle Linux, Unix, Solaris, Digital Unix, AIX, and others, Linux

General Tools: Microsoft Excel, Word, Power Point, Access, Visio - expert, Microsoft Project - project experience

PROFESSIONAL EXPERIENCE:

Confidential

Senior Consultant - Oracle Business Intelligence Architect

Responsibilities:

• Responsible for converting PeopleSoft nVision to OBIEE analysis and BI Publisher
• Worked extensively with Oracle BI Applications for PeopleSoft
• Have worked extensively with BI Publisher
• Responsible for gather user requirements
• Responsible for building Proof of Concepts
• Responsible for OBIEE report and data model creation

Confidential

Senior Consultant - Oracle Business Intelligence Architect

Responsibilities:

• Responsible for Business Objects reports migration to OBIEE
• Some reports were completed using Answers and other BI Publisher
• Edited the CSS style sheets to provide a custom interface for GSA/PBS
• Used HTML and XML to build out reports and refine report queries
• Responsible for modifying RPD to meet Business Objects Reports requirements
• Responsible for Answers reports creation
• Responsible for Dashboard design and development

Confidential

Senior Consultant/Team Lead - Oracle Business Intelligence Architect & Tech Lead

Responsibilities:

• Provided Administrative oversight to OBIEE custom development project in support of Confidential intelligence imitative
• Develop and extend RPD to provide custom solution for Confidential
• Deployed RPD in a Windows Server environment—2003 and 2008
• Design and develop BI Publisher reports to satisfy batch reporting requirements
• Design and developed custom answers and dashboard solutions to meet Confidential reporting requirements
• Supported a variety data warehousing and OBIEE development efforts
• 250 BIRT reports were rewritten in BI Publisher and I was personally responsible for over 70 of them
• Worked closely with the data architects and even served as data architect in an effort to implement a rational data warehouse architecture
• Supported the data modeling effort, both logical and physical data models
• Worked with Oracle Data Integrator
• Configured the OBIEE Weblogic Server and applied security appropriately
• Administered the OBIEE 11g environment, RPD Development and security setup
• Designed the business mapping and model layer for this effort
• Managed 6 people: 2 in the USA, and 4 in India
• Provided Administrative and Development oversight in providing solutions to meet Confidential business intelligence requirements.

Confidential, Tysons Corner, VA

Senior Associate - Oracle Business Intelligence Specialist

Responsibilities:

• Internal projects using OBIEE
• Installed and configured OBIEE in a Windows 2008 server environment
• Provided consultancy support for an OBIEE project Confidential Methodist Hospital in Houston, Texas. The role specifically addressed BI Architecture requirements.
• Installed OBI Applications for PeopleSoft
• Customized OBI Application per Customer Preferences
• Worked with BI Apps data models to accommodate user requirements
• Used Informatica to move data from source to target. Basic transformations and data profiling also were part of this effort
• Designed BI Publisher reports as Proof of Concept to demonstrate the breath of OBIEE

Confidential, Arlington, VA

Oracle OBIEE Business Intelligence Specialist & Data Architect

Responsibilities:

• Provided direction and leadership in building out an OBIEE solution for the Confidential
• Installed OBIEE on a Windows 2008 server
• Used Custom Style Sheets (CSS) to create a unique user interface and experience
• Performed DBA admin work on Oracle 11 as it pertained to OBIEE implementation¸ including installs, setup, user security, etc
• Provided Data Modeling expertise to support the Oracle Business Intelligence using Erwin
• Designed the ETL processes for Oracle Data Integrator 9.1 to populate the Data Marts with source data
• Provided dashboard design solutions
• Provided administrative support for the OBIEE repository and OBIEE web-catalog
• Provided support for ad-hoc query and report development

Confidential

Oracle 11g R2 DBA & Data Architect

Responsibilities:

• Provided Confidential with Oracle 11g R2 DBA services as well as Oracle Form and Oracle Designer expertise
• Developed a General Ledger Data Warehouse Model based solely on PeopleSoft documentation (no specifications or requirements)
• Provided expertise in data architecture and data modeling using Erwin
• Designed and constructed a Data Mart which was received with compliments from the client

Confidential

Compliance Monitoring Contractor

Responsibilities:

• Prepared Loss Share program documentation to resolve bank closures for the FDIC, enabling the FDIC to absorb up to 80% of a failed bank’s assets, while the other 20% was absorbed by the acquiring institution
• Automated the process via Excel macros
• Installed and configure a SQL server instance
• Managed the SQL Server environment

Confidential

Hyperion Business Intelligence Specialist & Data Architect

Responsibilities:

• Built Proof of Concept to showcase Confidential ’s capabilities in Business Intelligence to the Department of Defense
• Provided Data Modeling expertise to support this environment using Erwin
• Rolled out the Hyperion Enterprise Performance Management System
• Stood up the Hyperion Profitability and Cost Management Module
• This was a “first” Confidential and was met with broad acceptance by Partners, Principles, and Directors

Confidential

Oracle Business Intelligence Architect/Developer & Data Architect

Responsibilities:

• The DHS was using spreadsheets to report on 6 different geographical areas with over 150 input sources. This consumed the time of 2-3 people for 2-3 weeks each month
• Created an Oracle Database and imported into it 143 dimension tables and one fact table. This resulted in a real-time solution that shared the same look and feel as the spreadsheets DHS was accustomed to using
• Worked as DBA on Oracle 10g as relevant for an OBIEE implementation, including install, setup, security, etc…
• Imported these results in OBIEE and created a repository
• Built a supporting data model using Erwin
• Built a dashboard that had the same look and feel as the spreadsheet. This was no easy task and took subsidiary answers reports embedded as links in primary reports. In the end, the dashboard had exactly the same look and feel as the spreadsheet

Confidential

Oracle Business Intelligence Specialist & Data Architect

Responsibilities:

• Provided expertise in Oracle Business Intelligence requirements analysis with regard to sizing up the environment to support 1,300+ users
• Performed DBA admin work on Oracle 10g as it pertained to OBIEE implementation¸ including installs, setup, user security, etc
• Worked with Toad and SQL Plus
• Built Data Model to support this environment
• Designed the ETL processes for Oracle Data Integrator 9.1 to populate the Data Marts with source data
• Built a data model and created software and hardware development plans to support the data warehouse and business intelligence environment

Confidential, Roanoke, VA

Oracle Business Intelligence Specialist & Data Architect, ACP

Responsibilities:

• Secondary responsibility for OBIEE administration including physical and logical data modeling
• Served as SME with respect to Oracle Database Technology
• Development of the OBIEE RPD, which included design of the physical mapping layer, business mapping layer, and presentation layer. It also included identifying users and their security levels
• Built supporting data models with Erwin
• Developed OBIEE answers report and incorporated these modules into custom dashboard
• Built Data Model to support the OBIEE effort
• Developed and delivered end-user training materials

Confidential, Louisville, KY

Oracle Business Intelligence Specialist & Data Architect, TCI

Responsibilities:

• Installed and implemented the OBIEE architecture for US Army Accessions Command
• Install OBIEE on Solaris.
• Administered the environment for OBIEE 10g
• Designed and Developed the RPD.
• Built supporting data models using Erwin
• Using a pre-existing data warehouse, built data models and data marts to support the different functional reporting needs
• Built a custom OBIEE report development and dashboard environment to support analysis of the US Army’s Accession Command recruitment effectiveness by advertiser and by service line
• Provided administrative support for the OBIEE repository and OBIEE web-catalog
• Provided support for ad-hoc query and report development
• Provided Project Lead expertise for other developers and administrators

Confidential, Louisville, KY

Oracle Designer Data Modeler, Primus

Responsibilities:

• Designed and developed logical and physical data models using Oracle Designer and Erwin 7.1 for Oracle, DB2, and SQL Server Databases
• Gathered end-user requirements for new system development
• Designed and developed a crew scheduling application model
• Designed a weather advisory web application model
• Generated Oracle Forms from Oracle Designer
• Reverse engineered the Aircraft Addressing and Reporting SQL Server Database system into an Oracle Designer model to provide a data dictionary for the DBAs
• Maintained and provided periodic update to existing models
• Designed naming conventions for new data elements in accordance with standards

Confidential, Irvine, CA

Oracle Business Intelligence Specialist, hiSoft

Responsibilities:

• Designed and developed Oracle Discoverer environments (desktop and administrative)
• Set up Siebel Analytics Administration Environment
• Designed and developed Business Objects Universe
• Generated BI reports with Business Objects.
• Built an appropriate dimensional data model using Erwin to support the physical layer of Siebel Analytics, and then developed the physical layer in Siebel Analytics
• Created a business map, including custom measures and hierarchies; renamed columns and entities in accordance with business standards; and mapped to the presentation layer
• Worked with Siebel Sales Force Automation, customizing per Client preference.
• Worked with team members to implement those customizations
• Developed the Logical and Physical Data Models to support the DBAs

Confidential

Business Intelligence & Data Architect

Responsibilities:

• Designed and delivered Siebel Analytics Business Intelligence Implementations
• Installed, managed, and maintained the Corporate Oracle Application Server
• Designed and developed Business Objects Universe
• Generated BI reports with Business Objects
• Built data models using Erwin as required per customer engagements
• Designed and developed the Oracle Discoverer environments (desktop and administrative)
• Designed and developed of a series of Oracle reports
• Taught Oracle Designer to the client as well as the art of data modeling
• Trained firm consultants how to use and roll out Siebel Analytical solutions
• Delivered Oracle Discoverer training

Confidential, Green Bay, WI

Data Architect, Darwin Partners - IT Consultant

Responsibilities:

• Developed operational and transactional data models (logical and physical) using Erwin
• Generated front-end Oracle forms to test the solvency of the data models
• Designed and developed the logical and physical data model for shipment tracking

Confidential

Senior Econometric Forecasting Consultant, Business Forecast Systems

Responsibilities:

• Provided consulting and training services in the art of econometric model building and forecasting
• Build econometric models to propose to client as an approach to economic forecasting
• Developed new software components, such as covariance and correlation matrices algorithms
• Consulted with clients in best practice forecast methodologies

Functional and Technical Specifications Analyst

Confidential, Milwaukee, WI

Responsibilities:

• Gathered end-user requirements
• Set up and implemented an Oracle database to support the ERP system and developed data models based on the functional and user specifications
• Provided the technical specifications to migrate data from legacy OLTP systems to the Oracle IFS ERP system

Web Developer and General IT Support

Confidential

Responsibilities:

• Developed various access applications to support the business
• Built data models to support these applications
• Developed a website to facilitate book sales over the Internet
• Managed the corporate database environment

Environment: Windows 2003 Server, Windows XP

Confidential, Pittsburgh, PA

Oracle BI Developer

Responsibilities:

• Designed and developed a Health Care Data Warehouse based upon a 3rd normal form data model
• The data came directly from the claims processing OLTP systems
• Heavily involved in migrating system data from the OLTP environment to data warehouse environment
• Primary responsibility for Oracle Discoverer Administration
• Designed and developed Oracle Discover business intelligence reports for end-user use
• Designed of ETL processes
• Installed the Oracle Database Server
• Designed the data models to support the environment using Oracle Designer

Confidential

Oracle Data Administrator

Responsibilities:

• Dedicated for all data administration, including logical and physical models using Oracle Designer 6i and Oracle Database 8.4
• Approved all applications including both client-server and mainframe OLTP applications.
• Led business solution projects and tasks as assigned by the Business Applications Development Team.
• Designed and developed the enterprise data warehouse and business intelligence applications using Oracle Discoverer
• Enforced naming conventions and standards for the entire corporation.
• Developed and executed ETL processes using AbInitio

Confidential

Oracle BI Design Architect and Project Manager

Responsibilities:

• Led a team of 6 in the design of the logical and physical data models to support publication of Confidential ’s Annual Catalog. We analyzed the business processes that supported publication of the catalog from which we developed the functional model for data entry. I was also responsible for the life-cycle development of applications
• Developed a data model to support to support Aldrich’s Data Warehouse Imitative
• Installed and configure the Oracle Database, 9i
• Designed Aldrich’s enterprise data warehouse

Confidential

Oracle Project Manager, Data Warehouse, Business Intelligence and Forecasting System

Responsibilities:

• Played a vital role in the setup and implementation of the BAAN Triton ERP system. While BAAN is no longer in business, it was valuable experience.
• Acted in a DBA capacity, with 24/7 responsibility. In other words, it was essential that database kept running Confidential all times
• As the DBA I was involved in getting data from the legacy systems into the new Oracle Database
• In addition to implementation of the ERP system I also participated in a few other things while Confidential Snap-On:
• Led a team of 11 people to produce a business solution involving a data warehouse and forecasting system to be used in support of marketing and sales of Confidential
• Designed the Data Model in 3rd normal form, because when passing data to Oracle Express it did not matter what form the origin was in because Oracle Express required a format all unto itself
• Used the Oracle 8.4 database as the forecasting engine and Oracle Express to report the results

Confidential

Data Modeler

Responsibilities:

• Designed of the logical and physical data models to support the Customer Relationship Management and Campaign Management Systems
• Part of the team implemented the physical data mart and provided the PL/SQ procedures for data scheduled data loading

Confidential

Oracle Project Manager BI Technical Architect

Responsibilities:

• Led a team of four in the strategic technical design of a health care information data warehouse. The client benefited from this effort by being able to reduce processing costs and turn-around time through better organization of data and reporting
• Installed, Designed and developed the Oracle Express Server environment
• Mentored internal staff on administering Oracle Express as well on the design and development of Express Analyzer reports
• Constructed a data model to support the design of data warehouse
• Worked closely with administrative and senior technical staff as well as data analysts to provide a vision and solution that supported business imperatives

Confidential

Special Operations Command Instructor

Responsibilities:

• Developed and presented business process and data modeling techniques using Oracle CASE
• The goal was to teach and simultaneously develop a performance assessment system to be used by the Commander in Chief, General Wayne Downing, to assess his troops’ performance quality

Confidential

NASA Launch Systems Instructor

Responsibilities:

• Developed and presented the art business process modeling and entity/relationship data modeling techniques using Oracle Designer 2000
• The goal was to teach business process and data modeling techniques that were to be used to enhance the current NASA launch system

Confidential

Project Manager, Technical Architect, Strategist

Responsibilities:

• Led a team of six whose responsibility was the management and implementation of a production performance analysis system. This project presented a real world case of handling large volumes of claims data to manage and evaluate production performance in a health insurance company setting
• Designed a data warehouse in 3rd normal for based on claims and membership data
• Designed the enterprise data warehouse for Confidential
• Data for the enterprise data warehouse came from claims and membership processing systems, both OLTP mainframe applications. There were numerous claims systems involved
• Ensured the system architecture and design met the goals of the Confidential National Association, which is the licensing body for Confidential Plans nationwide
• Provided expertise in all facets of the project including: business case design, data modeling, benchmarking prototype, technical architecture implementation, vendor coordination, front-end tool design, and presentation coordination
• The end-result of the system was improved efficiency because now managers could manage to the numbers instead of the traditional way of just letting things take their course.
• Taught internal staff Oracle DBA skills, Oracle SQL and Oracle PL/SQL.

Confidential

Technical Architect, Strategist

Responsibilities:

• Designed and developed a claims processing forecasting system. The client benefited from the system, which forecasted claims volume more accurately and helped reduce processing costs by improved budgeting through accurate manpower planning
• Ensured the system architecture and design met the needs of the business by providing management with accurate and sophisticated forecasting with easy to use point-and-click forecasting functionality.

Confidential

Forecast Strategist

Responsibilities:

• Designed and delivered a series of statistical and analytical models, which association consultants could use to analyze Confidential Plan Performance. Some of these models were quite complex. For example one model consisted of 135 simultaneous equations, which simulated the claims flow process and then recommended the manpower necessary to meet claims processing performance goals

Confidential

Vice President Data Analysis

Responsibilities:

• Designed and built analytical models for use in the design of cost-effective, care maximizing health insurance benefit packages for Confidential
• Presented the results to potential clients

Confidential

Director of Corporate Planning

Responsibilities:

• Analyzed claims data to determine:
• If doctors were providing care in a cost efficient manner, and within cost guidelines as set forth in the contract
• If claims were being processed Confidential the lowest possible cost and in the fastest turnaround time possible

Confidential

Claims Analyst

Responsibilities:

• Analyzed claims data to determine processing patterns for daily manpower staffing requirements
• Generated corporate forecasts for claims and membership data. These forecasts were used to determine optimal staffing levels in each department in the following year
• Taught the people who were to take over the process how to use the software and how to adhere to best practice forecasting methodology.