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.

TECHNICAL SKILLS

Languages: PL/SQL, t-SQL, Oracle Forms, Simulation languages, Python

Databases: Oracle, SQL Server

Operating Systems: Win NT, Unix, Windows, Linux

Design and Development Tools: ERWIN, PowerDesigner, Oracle Developer, ER Studio

ETL Tools: Informatica, SSIS, NetTracker for web log analysis

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 ACI 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, Atlanta, GA

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, Alpharetta, GA

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, Dunwoody GA

Data Warehouse/Reporting Manager

Responsibilities:

• Provided project management, scoping, planning and analysis for a CRM data mart and a CRM integration project.
• The data mart project was a new data mart for customer service metrics and reporting.
• The integration project integrated the CRM system with a central third party database by XML messaging.
• Managed development of processes to load and update reporting database using dimensional modeling, T-SQL and SSIS. Managed data cleanup of the CRM database, which had been loaded initially from several different sources and contained many duplicate records.

Confidential, Norcross GA

Software Development Manager

Responsibilities:

• Revolving credit line capability
• Tax exemption processing and reporting
• Complex customer and merchant pricing models with retail and/or cost-based components as well as networking formulas. One dual settlement program between Comdata and FleetCor resulted in a revenue increase of more than $2 million per year.
• Cash posting
• Transaction monitoring
• 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
• Working with the business to define objectives
• Initial planning, scoping and requirements gathering
• Software and database design, working with staff
• Assisted staff in coding of the software and testing
• Adherence to project schedules and resource plans
• Writing and/or overseeing both business and technical specifications, and obtaining business agreement/sign-off
• Assisting production support with researching production problems, providing solutions, designing run books and verifying data updates to the production system
• Data modeling in ERWIN including application tables and dimensional modeling for reporting
• Managed source control, releases and documentation

Confidential, Kansas City, MO

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, Overland Park

Business Project Manager and Data Warehouse 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