SUMMARY:

• Enterprise Data Warehouse Director/Enterprise data architect/ Data integrator with over 18 years experience in the design, development and management of large enterprise - wide data solutions. Projects have been implemented utilizing industry leading best practices, management approaches, methodologies, standards and techniques that are required to successfully manage and implement large-scale data warehouse and data integration projects and teams
• Core competencies include: ROI and business value identification, functional/requirements analysis, enterprise-level data architecture experience; full life-cycle experience on all levels of large/complex enterprise projects; team mentorship and development; strong relational and multi-dimensional modeling experience; customer data integration; mobile Business Intelligence and architecture, master data management (MDM), ability to build consensus within a complex organization; fluent technical and business strategic orientation; collaborative management skills; and strong technical/business communication skills.
• Led a large team that created reports and dashboards which provided a client a 360 view of their customers and members of their frequent use program (Technologies: Business Objects, DataStage, Oracle, SQL Server, and Informix)
• Led a BI initiative that enabled a client to solicit present client customers for new business and product sales (Technologies: Business Objects, Ab Initio, Oracle)
• Led and architected a large BI project that enabled a client to view near real-time customer claims and activities (Technologies: Business Objects, DataStage, Oracle, SQL Server, and Informix)
• Developed a BI strategy that enabled a large pharmaceutical company to identify customers that met product usage requirements (Technologies: Cognos, Informatica, Oracle)
• Led a DW team that captured and consolidated OEM “spend” and identified the major suppliers of these materials. Reports were then created for the spend analysis process (Technologies: Business Objects, ETI, DB2)
• Created a B2B portal that enabled a client's customers to analyze products sold in client’s stores and analyze advertising effectiveness by region and store (Technologies: Essbase, AlphaBlox, Informatica, Oracle)
• Designed and rolled out a strategy and data architecture for capturing tactical and strategic level decision support data for and from over 30,000 restaurants worldwide
• Helped create a fully functional offshore data movement and migration practice
• Implemented a BI platform that enabled a client to realize over $5 million in annual savings by identifying patterns in OEM spend
• Created several enterprise-wide Governance and Master Data Management strategies
• Controlled and managed multi-million dollar DW engagements
• Was a part of a five man team that created, staffed, trained and developed a 50 person division in a large consulting practice

TECHNICAL SKILLS:

Data Warehouse/BI: OBIEE(mobile), Tableau, Hadoop, NoSQL, SAP BW, Qlikview(Mobile), HP Autonomy, HP Vertica, Oracle Reporting Suit, Business Objects Data Integrator, Erwin, Embarcadero ERStudio, DataStage, Business Objects, Business Objects FirstLogic, Informatica, WebMethods, Ab Initio, Hyperion, Essbase, Microstrategy, AlphaBlox, Rational Rose, Dataflux, Veeva, Exalytics, Exadata, SAP Hana ( and bootcamp)

Databases/ERP: Oracle, DB2, UDB, SQL Server, Informix, Teradata, Sybase

PROFESSIONAL EXPERIENCE:

Confidential

Senior Enterprise/Data Architect

Responsibilities:

• Developed system that enabled mobile business intelligence as well as cloud-based business intelligent solutions
• Architect a large data federation/virtualized data warehousing solution that includes the following architectural layers: portal, security, active data model(s), appliances(Exalytics, Exadata), and mobile business intelligence and analytics
• Defining the following standards: Data Warehousing, Data Management, Teradata and SAP BW integration, Data Governance, Master Data Management, Data Quality
• Defined large enterprise Operational Data Store

Confidential

Senior Manager

Responsibilities:

• Developed system that enabled mobile business intelligence as well as cloud-based business intelligent solutions
• Served as a thought leader, mentor, coach, and career development manager for both employees and contractors, resulting in retention and improved productivity with teamwork.
• Served as one of the top thought leaders in the following disciplines: Data Warehousing, Data Management, Teradata and SAP BW integration, Data Governance, Master Data Management, Data Quality
• Developed enterprise level strategies for our clients
• Manage large data related projects
• Defined NoSQL/Hadoop solutions
• Represented our firm on sales calls and at partner and industry specific conferences

Confidential

Acting Enterprise Data Integration Manager

Responsibilities:

• Build and staffed the data integration and data warehouse team for a large utility company
• Managed all data related aspects of a large Smart Grid project
• Designing and implementing the data governance practices
• Communicate status of project to high level management
• Provide visible, visionary leadership to the Enterprise in all data and migration-related subjects
• Designing efficient processes based on usage, best practices around Smart Grid and the use of ETL and ESB
• Develop and communicate project plans, work assignments, target dates and other aspects of Data Architecture-related projects to management and the business units
• Manage and set the overall strategy for the company’s data related initiatives
• Enterprise-wide technical leader for Data Architecture providing coaching, and career development
• Write / review agreements for contract employees. Hire, manage, mentor and provide annual performance reviews for full-time employees

Confidential

Senior IT Manager

Responsibilities:

• Managed a large data, datacenter, system, and database migration for a Fortune 50 company
• Controlling budget for a multimillion dollar implementation
• Lead a 50 person team
• Communicated status of project to high level management
• Designed efficient processes based on usage, best practices and technical environment
• High-level technical expert in addressing data and migration related issues
• Developed and communicated project plans, work assignments, target dates and other aspects of Data Architecture-related projects to management and the business units
• Enterprise-wide technical leader for Data Architecture providing coaching, and career development
• Wrote / reviewed agreements for contract employees. Hire, manage, mentor and provide annual performance reviews for full-time employees

Confidential

Project Manager/Data Architect

Responsibilities:

• Managed the design and implementation of a large financial data warehouse used to track pension
• Migrated a data environment from mainframe to UNIX
• Designed data mining strategy and the RDBMS needed in order to support SAS processing
• Implemented data warehouse strategy using Business Objects, Informatica, Siperian,Oracle and SQL Server database platforms

Confidential

Enterprise Data Architect

Responsibilities:

• Defined data governance, stewardship and ownership program
• Technical lead on the blueprinting phase of a SAP implementation
• Created corporate wide data architecture strategy
• Created MDM Center of Excellence
• Designed corporate MDM strategy
• Created corporate wide data management strategy
• Conducted Data Management Maturity Model analysis
• Lead technical resource on a SAP dat migration project
• Defined approach and scope of migration

Confidential

Director

Responsibilities:

• Performed source system to target system mapping enhancement and correction to keep the correctness of EDW data element mapping from source system
• Conducted a ETL tool selection process
• Cross subject area integration analysis
• Key Constraint and Primary Index modeling
• Identified data model enhancement / impact Analysis for captured requirements
• Conducted a system and data flow analysis
• Conducted Data Management Maturity Model analysis
• Customized the Oracle Data Warehouse data model to support Darigold’s data needs while leveraging Oracle BI products:OBIEE, Siperian,Oracle Financial Analytics and Oracle Business Indicators,

Confidential

Data Management Lead/Data Architect (contract)

Responsibilities:

• Lead the implementation and redesign of the Teradata Point of Sale ODS and datamart
• Lead the implementation and redesign of the Teradata supply chain ODS and datamart
• Scoped out the Teradata RDBMS environment
• Redesigned the Teradata indexing and partitioning strategy
• Aligned business priorities with analytics applications
• Worked with business teams to formalize the enterprise definition of KPIs (Key Performance Indicator) and business metrics
• Responsible for review and management of modeling deliverables based on data specification;
• Responsible for managing and reporting status on modeling deliverables
• Performed Data Modeling Responsibilities
• Identified Existing Teradata Data Model Objects for captured requirements
• Identified data model enhancement / impact Analysis for captured requirements
• Built New Logical Data Model for captured requirements in Erwin and implemented them in Teradata
• Identified Data creation and captured points and document in Data Dictionary maintained in Erwin
• Cross subject area integration analysis
• Key Constraint and Primary Index modeling
• Maintained and enhanced enterprise Teradata data model development standards
• Maintained and administrated enterprise data model tool - ERWin data mart
• Maintained data model subject areas to match major business subject areas in Erwin
• Performed routine source system to target system mapping enhancement and correction to keep the correctness of EDW data element mapping from source system
• Understand subject areas overview and review of all modeling objects; including customer marketing data model

Confidential

Data Warehouse Lead/Data Architect

Responsibilities:

• Managed the conversion of a large data warehouse from mainframe to UNIX environment
• Profiled the mainframe data warehouse and the staging data loaded into the data warehouse
• Designed data transformations and processes for capturing and redefining metrics and facts
• Implemented data warehouse strategy using Business Objects, DataStage, Oracle, SQL Server, and Informix database platforms

Confidential

Project Manager/Data Architect (contract)

Responsibilities:

• Managed the design and implementation of a large data warehouse to mine customer-centric data
• Created data models and designed the messaging hub and data integration strategy
• Designed data mining strategy and the RDBMS needed in order to support SAS processing
• Implemented data warehouse strategy using Business Objects, DataStage, Oracle, SQL Server, and Informix database platforms

Confidential

Project Manager/Data Management (contract)

Responsibilities:

• Managed the creation of the technical infrastructure for a $150 million budgeted organization
• Managed the design and implementation of a large data warehouse to support financial reporting
• Designed data mining strategy and the RDBMS needed in order to support SAS processing
• Designed integration strategy and created data models. Performed application and data integration.
• Implemented Data Warehouse strategy using Business Objects’ ETL tool-Data Integrator and the Oracle, DB2 and UDB database platforms
• Implemented data govenance program that insured Sarbanes-Oxley and Fair Credit Act compliance

Confidential

Director of MIS

Responsibilities:

• Managed the design / implementation of a large data warehouse supporting CRM and financial reporting
• Selected ETL, reporting, RDBMS as well as hardware in order to support data warehouse architecture
• Designed integration strategy and created data models. Performed application and data integration.
• Helped design a security data model that will be used in the horseracing industry
• Implemented data warehouse strategy using DataStage, MS OLAP, SQL Server and Oracle

Confidential

Project Manager/Tech Lead (contract)

Responsibilities:

• Managed the design and implementation of a large PeopleSoft CRM/ Financials project.
• Performed application and data integration, data modeling and designed the integration strategy
• Facilitated user sessions and interviews with Senior Management, end users and technical staff

Confidential

Data Architect/ Data Modeler (contract)

Responsibilities:

• Designed a Teradata data warehouse that integrated data from KFC, Pizza Hut, Taco Bell, and Long John Silvers
• Designed a Teradata data warehouse that captured transaction level data from over 30,000 restaurants
• Created a master data management (MDM) strategy that enabled YUM to more easily integrate their acquired restaurants companies using Teradata
• Created ETL specifications in order to load the Teradata RDBMS from PeopleSoft and GEAC sources
• Created an integrated platform for all client business units
• Requirements gathering from end-users and Rational Rose documents
• System design and database optimization using Teradata enterprise tools
• Created data models using Erwin and performed application and data integration
• Designed integration strategy using Rational Rose and ERwin
• Research historical data using Teradata Queryman and QMF for Windows
• Report requirements creation for Microstrategy reporting tool

Confidential

Data Architect/ Data Modeler (contract)

Responsibilities:

• Business Objects development. Wrote preliminary ETI ETL scripts to access source data from PeopleSoft, i2, and Ariba and load it into the DB2 and UDB RDBMS
• Created file layout for D&B Duns data and assisted in development of strategic sourcing database design
• Analyzed target source data repositories for data quality. Recommended/executed target source data system cleanup where existing data quality is not adequate.
• Developed, coded, tested and implemented strategic sourcing software based on approved business requirements for levels of data quality using SQR, PeopleCode and SQL
• Issue/problem management for data management
• Coordinated data quality improvement efforts with appropriate IT and business unit teams
• Contributed to system design effort/ design documentation for development, customizations and configuration
• Identified/documented business process changes to maintain adequate data quality in target data sources
• Identified/documented data auditing practices
• Ensured documentation and resolution of issues for strategic sourcing software functions
• QA strategic sourcing software vendor customizations per design specifications (if applicable)
• Performed strategic sourcing software development and configurations per design specifications
• Support test planning, preparation and execution. Performed/documented testing for all testing phases.
• Resolved assigned bugs identified in the various test phases. Migrated software from develop to test (QA) to production environments.

Confidential

Business Analyst/ Data Modeler (contract)

Responsibilities:

• Informatica development and Lead Business Analyst/Data Modeler on a customer data warehouse/ECRM
• Developed reports, ECRM product features and data models needed to meet business requirements
• Created data models and designed the integration strategy
• Loaded data into the Oracle data warehouse using Informatica
• Created application and data integration specifications, report requirements and mapped client requirements with existing product functionality. Designed additional features.

Confidential

Project Lead

Responsibilities:

• Technical lead on a large CTI/Call Center project creating agents and agent skill sets utilizing Siebel Employee Relation Management (ERM) module
• Designed integration strategy and performed application and data integration
• Interviewed end users, Senior Management and client technical resources. Also facilitated user sessions.
• Created and designed an external database that supplied Genesys with ACD and account data

Confidential, Atlanta, GA

Principal Consultant

Responsibilities:

• Led a Siebel eCRM team during the requirements gathering phase of large Siebel Call Center, Incentive Compensation and Sales Force Automation engagements
• Technical/functional lead on the design phase of the Call Center and Incentive Compensation projects
• Managed the development phase of the CTI and Incentive Compensation portions of the engagement
• Lead in the development of a large integration strategy emphasizing Siebel EAI and Vitriautlilizing Siebel EIM, Siebel Connectors. The data sources that were integrated with Siebel were: ICOMS, PEOPLESOFT, Remedy and Metasolv.
• Designed integration strategy and performed application and data integration
• Handled Siebel administration and configuration
• Chaired functional and technical meetings
• Gathered requirements and facilitated user sessions with Senior Management and end users
• Helped identify and create solutions to address a large eCRM integration enterprise

Confidential, Chicago, IL

Principal Consultant

Responsibilities:

• As an architect, developed data strategies and IT architectures to support large scale eCustomer Relationship Management (eCRM), CTI and Sales Force Automation (SFA) projects
• Perfomed IT assessments, gathered requirements and GAP analysis
• Data architecture and modeling to support Siebel architecture
• Handled package selection, application development, project management, customer management and
• As a functional analyst, helped clients define business processes, set account and organizational hierarchies, and helped map requirements to the chosen eCRM tool
• Business Analyst and Developer roles working with Siebel CTI and Sales Force Automation
• Acted as implementation manager for the implementation of Sales Force Automation and CTI
• Developed a customer-centric data model and developed data warehouse schemas
• Architected the integration of Siebel Call Center module with SAP r/3 Order Entry and Financials
• Performed application and data integration, data mapping and Siebel configuration

Confidential, Chicago, IL

Principal Consultant

Responsibilities:

• Managed, designed, developed and deployed AlphaBlox's web-based Analytical Server for customers and implementation partners utilizing JavaScript and DHTML. Created a B2B portal that enables a client's customers to analyze products in inventory, place orders and sold in their stores. This system was also used to track budgeting and advertising effectiveness. Because of the product's ability to render any data source (SQL Server, Oracle, Essbase, and MS OLAP) also provided data management support.
• Managed budget and resources. Performed requirements and GAP analysis. Created data models.
• Developed web-based analytics and managed data sources
• Mentored development partners during their implementation of the AlphaBlox Server
• Developed web-based solutions using XML, HTML and XML
• Handled customer management and

Confidential, Louisville, KY

Project Manager

Responsibilities:

• Helped create and manage all phases of data warehouse and datamart project development
• Responsible for the development of the datamart methodology and Oracle Express Suite
• Implemented a data warehouse utilizing data from I2 as the data source
• Created data warehouses and datamarts by utilizing third party tools to extract and model data from ERP systems such as Oracle applications and PEOPLESOFT
• Created OLAP reports utilizing Microstrategy DSS Agent, Oracle Express Suite, Cognos Suite, Oracle Discovorer, Essbase and Forest and Trees
• Developed large data warehouse that integrated data from PeopleSoft, SAP R/3 and over ten other data sources
• Created best practices for Oracle Express Suite
• Development of proposal collateral and presentations
• Project management, sales presentations, product development, and performance evaluations
• Created processes to improve data warehouse performance

Confidential, Louisville, KY

Sr. Principal Consultant/Project Lead

Responsibilities:

• Involved in the design, installation, development and implementation of Confidential ' data warehouse offerings to clients. Involved in all phases of data warehouse development and management.
• Specialized in the Express Suite of OLAP products
• Performed project management and managed all phases of OCS data warehouse engagements
• Installed and implemented Oracle ROLAP and MOLAP products. Web enabled Express products such as Sales Analyzer and Express Server. Rolled out DSS support tools to end-users.
• Led a team of Oracle Consulting Group partners as well as the client in developing a large data warehouse that used SAP R/3 Financials and Accounting modules as data sources
• Assisted with tuning and optimizing the data warehouse Oracle8 RDBMS and built two datamarts using MOLAP and OLAP tools such as Oracle Sales Analyzer and RAA/RAM
• Redefined RDBMS indexing strategies and redesigned IT and data architectures used to support the data warehouse. Developed data load and data quality procedures.
• Managed testing and customer assurance meetings and phases
• Created data models and redesigned analytical data modeling schemas

Confidential, Chicago

Consultant/Project Mgr

Responsibilities:

• As a consultant at PIMC, formally known as Confidential, Inc. (one of the world's first data warehousing firms), supported PIMC's goal to remain a global industry leader in the delivery of quality data warehouses, metadata management and vertical data warehouse consulting
• As a consultant and project manager, helped PIMC realize this goal by concentrating on the business intelligence and metadata management portions of the data warehousing architecture
• Developed end-user interfaces and applications to data warehouse data via OLAP and DSS tools
• Managed client metadata through the use and implementation of Platinum's client/server and MVS repository OLTP
• Created interfaces to the Century Date Change Repository via OLAP and DSS tools
• Corrected and established client/server protocols and communications for BI tool access to data warehouse data and metadata
• Helped build ever-improving methods and best practices in all PIMC offerings
• Performed data modeling and management
• Utilized data extraction programs to move data from the operational data source to the data warehouse

Confidential, Chicago, IL

Information Technology Consultant

Responsibilities:

• As a consultant in Confidential & Confidential Center for Technology Enablement (CTE), developed client/server and IT architectures for clients across all functional areas and industries
• Recommended architectures that met the client's requirements. Also, as a member of the CTE practice, used laboratory facilities to examine and identify new technologies.
• Created and designed Request For Proposal (RFP) to solicit favorable services and pricing for clients seeking to maximize WAN, MAN, and LAN services
• Created custom IT and client/server architectures based on a client’s Confidential and future requirements
• Analyzed new technologies and identified their fit in the Confidential & Confidential practice
• Conducted vendor selections and operated as vendor liaison