SUMMARY

• Software development of both business applications and data warehouse / business intelligence. Strong mix of business and technical skills allows interaction with both the technical staff and the business clients to provide the most effective solutions. Previous development projects have involved very complex business logic.

PROFESSIONAL EXPERIENCE

Confidential

Data Warehouse Manager

Responsibilities:

• Reduced daily loading of data warehouse by half by streamlining and optimizing processes
• Implemented enterprise data warehouse to include transactions processed on 11 platforms from 8 different Confidential acquisitions
• Implemented master data management for key dimensions
• Maintained non - data warehouse functions including support of general ledger entries, customer invoicing, cash reconciliation, 1099 reporting and financial reporting
• Calculation of revenue and costs from all of the source systems
• Managed source control, releases and documentation
• Worked with business partners to establish road map for integrating banking transactions from 10 legacy systems
• Led design meetings to enable collaboration among the team, and managed projects for the group.

Confidential

Data Warehouse Manager

Responsibilities:

• Designed the ODS to include data elements from several different POS systems.
• Solution design included data structures to implement the Informatica data cleansing module.
• Assisted in evaluation and implementation of a new reporting tool. Finalists included Tableau, Qlikview and Cognos.
• Streamlined moving hard-coding of business rules into table-driven logic.
• A major part of the warehouse redesign was to establish data governance and master data management. We chose the Data Quality and MDM Informatica applications to help accomplish this.
• With seven different POS systems, developed the translation files to standardize the master data such as transaction types, store data, and customer and loan statuses. Used the Informatica Data Quality tool to assist with standardizing customer data.
• Led design collaboration among staff including ETL, BI architects and business analysts.

Confidential

Sr. Business Intelligence Manager

Responsibilities:

• Redesigned the data warehouse for data accuracy and performance using star and snowflake schemas. Reports that would not run in days were made to complete in under 30 minutes.
• Supported a major CRM system implementation by redesigning data warehouse tables and processes to receive and integrate data from Salesforce.
• Completely rearchitected two data marts into new table structures so that reports would execute in reasonable amounts of time. Data had to be migrated from several years of history including several tables with hundreds of million rows, and one with 5 billion rows.
• Integrated ad impression data from the web with pageview data in order to correlate revenue with assets. Worked to integrate user activity data with profiles to get a comprehensive view of the customer for more precise ad targeting.
• For Master Data management, used translation files to map data elements from all of the source data systems.
• Managed source control, releases and documentation
• Worked with staff to developed dashboards in Tableau, and scheduled and ad-hoc reports in Business Objects
• Led design meetings and documentation

Confidential

Data Warehouse Project Manager

Responsibilities:

• Used well-defined corporate project management methodology for each phase of the software development lifecycle.
• Managed database developers and a team of on-shore and off-shore .Net developers. Database is SQL Server, and reporting tool is Business Objects, as well as SSAS.
• Implemented SAP BPM and MDM for Finance data. Project included proof of concept and roll-out of BPM and syndication to enterprise SAP systems for Finance including cost and revenue transactions and consolidations, planning and data warehouse.
• Managed source control, releases and documentation

Confidential

Database Consultant & Infrastructure Project Mgr.

Responsibilities:

• Provided table and column definitions for all of the business application and data warehouse tables.
• Managed infrastructure projects including hardware and software upgrades.
• Defined user roles by business and IT function across several reporting databases for SOX compliance.
• Defined primary keys and assisted in implementation of replication for new reporting databases.
• Implemented archiving on SQL Server databases.

Confidential

Data Warehouse/Reporting Manager

Responsibilities:

• Automated cleanup of suspended transactions
• Conversion of major accounts Citgo and BP. Posting and authorization changes included the ability to process batch files of transactions and match with previous authorizations. Other enhancements included processing methods for credits and multiple products on the authorization/capture.
• Detailed mapping, conversion and automation of standard fuel cost for cost-based pricing
• System interfaces between business units
• Calculation and reporting of fuel taxes and tax exemptions
• Tiered rebates and discounts based on various criteria -- dollar value or quantity, products or product types, merchants or types of merchants
• Automation of customer and merchant fees and reports
• Card production
• Customer service (internal) and customer (external) user interfaces using .net and Oracle Forms

Confidential

Sr. Data Architect

Responsibilities:

• Designed the application database for the distribution system.
• Guided the development team to translate business requirements and data model into software requirements.
• Provided an enterprise data perspective and integration across several project teams within the operations, distribution and reporting data areas.
• Worked with staff to develop interfaces between legacy systems and both in-house and packaged solutions.
• Modified warehouse system designs to incorporate the international standard barcode label.
• Gathered requirements and modeled use cases for a content management system.
• Integrated object models with logical data models using ERWIN.
• Redesigned portions of the Enterprise Data Warehouse retail model and integrated data from additional sources.
• Designed tables for inclusion of distribution and traffic data in the Enterprise Data Warehouse.

Confidential

Data Architect

Responsibilities:

• Dimensional modeling included star and snowflake schemas for the ebusiness data mart
• Managed the interface between data warehouse development and business clients
• Tracked and resolved issues with development, detailed program design delivery dates and documentation
• Worked with clients to establish reporting requirements and Data Warehouse Development interfaces
• Planned and implemented web log analysis tools including NetTracker, Informatica and Microstrategy Web Business Analyzer
• Developed program design specifications to populate Data Warehouse tables from source data
• Created logical and physical models of the eStore and Wireless Web databases using PowerDesigner
• Mapped and translated source data to Data Warehouse tables
• Developed project documents including project plans using Microsoft Project
• Matched eStore customer data with enterprise customer data for comprehensive customer activity reporting
• Performed hands-on data analysis using SQL

Confidential

Adjunct Professor

Responsibilities:

• Coordinated technical review of leases and maintenance for hardware and software, and managed projects in the data center. Managed the transition of assets to a new corporate consolidated data center.
• Managed project managers for support projects in the data center.
• Data architecture of manufacturing production reporting databases.
• Installed and configured Oracle 7 and 8 databases on Windows NT and HP Unix
• Performed data migration from mainframe to Oracle on AIX using SQL*Loader
• Reorganized Oracle 7 and 8 tablespaces and set up many development and testing environments
• Performed backup and recovery on Oracle 7 and 8 and set up automated backup processes
• Designed Oracle databases for Year 2000, workstation management and manufacturing data collection using ERWIN, including logical and physical modeling and data architecture.
• Designed table reporting structures for manufacturing data warehouse.
• Wrote PL/SQL triggers and custom database replication programs to establish a data repository for manufacturing data. Also used the Oracle replication manager to set up replication. Used dimensional modeling techniques to plan for reporting.
• Provided Oracle database administration, performance tuning, security and user support on 20 databases
• Upgraded Oracle database software and installed patches