OBJECTIVE

I look to provide leadership and design expertise to an organization interested in maximizing their efforts toward treating data as an asset. I am an expert at data integration and enterprise data architecture, with 20 years of experience in information technology. I have specialized in data warehousing design and both logical and physical data modeling, and am an expert at various data methodologies, including star schema, snowflake, OLTP and data hub modeling, as well as both the Kimball and Inmon approaches to data management. I have performed in many industries including Insurance, Banking, Retail, Commodities, Production, and Hospitality, understand the unique business and technical challenges in each, and am uniquely qualified to bring the highest quality Data, Infrastructure, and Technical solutions to my customers.

SKILLS

• Data Modeling, Dimensional and Normalized
• OLTP and OLAP design
• SOA Architecture and Data Services Design
• Teradata V12
• Infrastructure and Software
• Big Data
• MPP/ Parallel platform database and architecture experience.
• NOSQL experience.
• SOAP Architecture and design.
• Architecture
• Business Analysis and Project Management Experience
• Leadership and Management Skills
• SPECIFIC TECHNOLOGIES:
• Microsoft Sql Server 2000, 2005, 2008, 2008 R2, 2012
• Microsoft SSIS/SSAS/SSRS
• Dundas
• Microsoft PowerPivot for Excel
• PowerView for Sharepoint
• Mongo/Raven NOsql Databases
• Embarcadero ERStudio
• CA AllFusion ErWIN Modeling Suite.
• Toad data Modeler
• ERConcepts Data Modeler
• Teradata parallel databases
• Greenplum
• Oracle V 8,9,10,11
• SAP
• Informatica V8.5.2/9.0
• SAS Business Objects V 3.5.2
• DB2
• Informatica
• IMS
• COBOL
• MDX,
• PL SQL
• IBI Webfocus
• Microstrategy
• IBM Data Stage
• IBM Quality Stage
• IBM Profile Stage
• Biztalk
• Websphere
• Crystal Reports
• Microstrategy
• Microsoft CRM

COMMON SOURCE ENVIRONMENTS:

• AVAYA IQ v4, 5.0
• BMC Remedy
• DST AWD
• SUNGARD COMPASS
• ORACLE FINANCIALS
• CANONICAL MODELS: ARTS retail , ACORD: Insurance
• Oracle Admin Server
• Ventyx Banner
• Cisco FirstData

EXPERIENCE

Technical Architect

Confidential

• Performed Enterprise Technical assessment for large dairy Coop, consisting of a headquarters and numerous branded and unbranded partner facilities.
• Delivered complete server topography, including virtualization site info and specific hosting details after lengthy discovery process
• Delivered complete application inventory, all programs running on all systems including a platform dependency matrix identifying server and inter program dependencies.
• A future state proposal and transitional roadmap for how to get to a recommended future state for:
• Virtualization and virtual desktop delivery via Citrix
• Application and Database Management
• Data Management Program

Data/MDM/ Solution Architect

Confidential

• Designed several technical and process solutions and acted as technical lead for several initiatives engineered to revamp customer service experience in the Utilities Industry.
• These solutions used SQL Server 2012, SSIS, SSRS, Sharepoint, Oracle and Fusion
• I designed and communicated flows, lead a data governance and quality initiative and developed data cleansing processes.
• Lead development of reporting strategy to use data staging area for intermediate reporting while and enterprise warehouse was being designed.
• Designed virtual hub architecture for implementation of 'data as a service' principles.

Director of Information Architecture

Confidential

• Lead several initiatives as Director of Information Architecture in the Restaurant support vertical.
• Designed data models for a Food Management Application used for over 1000 store locations, including franchises for Applebees, IHOP, McCormick and Schmick and others.
• Developed operational model for transactional system.
• Developed Reporting strategy and designed a reporting database to support food cost analytics.
• Performed all manner of DBA tasks, such as performance tuning, peer to peer replication set up, reengineering of stored procedures for better performance, and the development of reporting views for data consumption of a wide variety of client needs in the Microsoft SQL Server 2012 database environment.
• Developed information management strategy to include design and development standards to support existing clients while positioning the enterprise for scalable growth as we brought on new clients.
• Worked with executive management on the refinement of the business model by participating in leadership boards for internal processes and the creation of new products for the industry.

Enterprise Data Architect

Confidential

• Principal IT Architect for Complete Nutrition, a fast growing retail company in Omaha, NE.
• Complete Nutrition was essentially building their IT infrastructure from the ground up, including a data warehouse and analytics project.
• Designed a working data warehouse model with load processes ready for reporting in 8 weeks using Microsoft SQL Server SSIS/SSRS.
• Developed a junior employee with no IT experience to into a very capable ETL programmer and Data Warehouse specialist.
• Developed enterprise processes for data management around customer and store data, integrating Microsoft CRM and Sharepoint into our architecture and integrating SSRS with Dundas visualizations as a dashboard and reporting tool.
• Obtained Dundas training and performed development of animated graphs and data visualizations.

Analytics Solutions Data Architect

Confidential

• Principal Data and Solutions architect for a project called Cobalttalon, an analytics solution created for a spin off of Blue Cross Blue Shield of Kansas City. The project delivered an interactive analytics reporting tool, including predictive models, using Teradata and Microstrategy to provide web based and mobile reporting as a service
• Designed the Logical/Physical Data models, Data Flows for the ETL Process, and the physical architecture and some predictive algorithms, taking historical data to make predictions of customer behavior.
• Collaborated with Teradata specialists to design the optimum infrastructure for our data repository, planning for scaling of additional clients.
• Designed predictive algorithms and ETL processes to support those requirements.
• Worked with an offshore team and multiple developers for mapping and process flow support.
• I was also loaned as a support DA to several internal BlueKC projects, and performed modeling and development tasks as necessary.

Data Architect

Confidential

• I was the principal solutions architect on a short term project for the development of a mortgage dashboard system.
• I developed and designed the visualization and graphing of data for the dashboard, determining content, placement, and front end web design features
• Worked closely with the VP of Marketing, the CEO, and the CIO to develop dashboard content.
• Developed architecture integrating SqlServer 2008 R2 features with a .net framework front end.
• Developed high level ETL design to integrate multiple data sources as a part of proof of concept.

Data Architect

Confidential

• I was the Principal Data and Business Intelligence Architect on several data warehousing and business intelligence projects for both the local bank and the overall Federal reserve system.
• Performed data modeling, analysis, and process design duties on several high importance /high visibility projects, including a Data Mart for the new centralized help desk functionality of the Federal Reserve System. The development of this mart also behaved as the beginning of a centralized business intelligence platform, which would encompass both the beginnings of an Enterprise Data Warehouse as well as shared Informatica and Business Objects development platforms. Data for this mart was sourced from Oracle, using the Avaya IQ reporting platform, as well as an Oracle database for Remedy. The data warehouse itself was built on a MS Sql Server 2008 database.
• Led design discussions with BI team, acted as design lead on business intelligence projects and final authority for architectural decisions related to these initiatives.
• Improved and enhanced the design of several existing data marts for Help Desk performance management.
• Presented and discussed our environments to bring on additional Business Intelligence projects, explaining benefits of data warehousing, data marts, and denormalization to numerous high profile potential users within the system, including the Treasury, The Commodities and Futures Trading Commission, and to the yearly meeting of the Application Developers Group for all of the Federal Reserve System.
• Worked closely with lead ETL developer to design informatica workflows and schedules.
• Contributed to several system wide development groups and councils, setting data design and development standards for all of the Federal Reserve System.

Enterprise Data Architect/Data Team Technical Lead

Confidential

• I was the Enterprise Data Architect and Technical Team Lead of the data development and integration group, coordinating and mentoring 2 DBAs, 3 ETL and data service developers, and 2 Business Intelligence Analysts.
• I designed and evangelized an enterprise data architecture framework for the organization, integrating SOA concepts with the use of industry Canonical formats ACORD to allow for the consolidation, cleansing, and master data management across numerous systems, handling disparate data domains obtained through mergers and acquisitions of different businesses.
• Designed architectural approach for warehousing and reporting, using the concept of 'Enterprise Dimensions' to coordinate shared data across multiple subject area marts for a bottoms-up data warehousing approach. Integrated the use of SSRS and IBI/Webfocus as our BI tools of choice.
• Supported and enhanced an enterprise ODS to include auditing and cleansing processes for the management of data through ETL, data services, and application services in Biztalk to support all new development.
• Developed data design and implementation standards, modeling standards, and data lineage through the modeling and BPM
• Lead an effort to redevelop the data backup and retention strategy, improving backup reliability and recoverability by 200 and reducing the overall data and backup footprint by over 50 . Developed plan for consolidation of 47 database instances using different versions of MS SQL Server 2000, 2005 into a virtual system Polyserve into 8 servers. Over 20 instances were able to be eliminated through consolidation, reducing licensing and support costs.
• Managed ETL and data quality initiatives using Informatica toolsuite.
• Developed an Enterprise Logical Model and started an initiative to bring multiple physical implementations into a single data lineage matrix to track metadata around mapping and use of data within various parts of the organization.
• Developed solutions using SSIS and SSRS to support Policy Accounting reporting.
• Developed a reporting mart for Workflow and work object reporting in AWD, utilizing the shared dimension framework I designed to bring other data sources into the mart allowing for more flexible and accurate reporting with greatly diminished development time.
• Contributed to the development of a DBA and database support plan, coordinating the support efforts of outside vendors. Developed plan for the conversion or retirement of several different reporting tools being used across the enterprise, Cognos, Business Objects, Crystal Reports to save on licensing costs.
• Developed transactional database for the management of claims, also building conversion routines for historical data using T-SQL and SSIS.
• Microsoft SQL 2000, 2005, 2008 incl SSIS/SSRS/SSAS, Embarcadero ERStudio, EAStudio, Enterprise Portal, Informatica, WebFocus, SOA, Data Architecture, Modeling, Standards, Leadership, T-SQL, SQL, ACORD Standard, Database Design, Infrastructure and backup approach design and managment., Oracle Admin Server, Websphere, Instance management.,

Data Architect

Confidential

Enterprise Data Warehouse Architect

• I was a key architect in the development of a new enterprise architectural framework to be used by organization as a part of a major systems revamp, adopting the concept of canonical data structures in xml as a shared/global messaging framework for application to application integration.
• Was exclusive data warehouse designer and performed modeling with ERStudio, performing guidance in data mapping, and etl design and support for data warehouse project on SQL Server 2000 and 2005 databases using DATASTAGE as the ETL solution.
• Performed development tasks using Datastage for the loading of film sales tracking data.
• Key architect on a business analysis project requiring the integration of multiple data sources from legacy systems, an old data warehouse, and a new third party file all at different levels of granularity.
• Performed data profiling using IBM Information Analyzer, quality analysis, and created numerous flow and business resource documents for project delivery.
• Was contributor in the data solution for major point of sale implementation, coordinating with several outsourced consulting project teams.
• Enhanced and improved IT presence and respect with executive leadership within the core business groups of marketing and store operations.
• Contributed to the adoption of Microsoft Team Foundation Server as a code management system, organizing document and code libraries for shared access within data team.
• Microsoft SQL Server 2000 and 2005, IBM Data Stage, Embarcadero ER Studio, ARTS Retail industry Canonical Model, Biztalk, XML, Data Warehousing, Enterprise Data Architecture, crystal reports, SSRS,

Enterprise Data Architect

Confidential

• I was the primary data warehouse architect, integrating the roles of the data warehouse into the overall corporate enterprise data strategy.
• Advised and contributed to Enterprise data strategy, including the development of an ODS and further development of the Data Warehouse according to Corporate Information Factory concepts.
• Worked with the development of numerous reporting solutions marts for business support related to premium, broker details, commission payments to brokers, sales and quote quotes and claims.
• I was lead data architect on the development of a web portal used to provide third party insurance brokers with details on their current business portfolio and commissioning details associated with their compensation. This portal received considerable executive commendation and was selected to be presented to senior executive management as a major IT win.
• Worked with Enterprise Integration team on the development of shared data services to our ODS towards an SOA architecture and messaging strategy.

Lead Data Architect

Confidential

• I was Lead Data Architect overseeing 4 onsite and 3 offsite India data architects on multiple data projects on both transactional and data warehouse environments in Oracle and DB2 ODB.
• Established enterprise data model and set data modeling standards
• Initiated and managed a data quality initiative to improve overall data quality, creating translation mechanisms for incoming data and developing shared data repositories and services for varying types of data.
• Setup ERSTUDIO shared model repository for the storage and retrieval of enterprise data models.
• Performed coding and support tasks for several PLSQL procedures.

Data Architect

Confidential

• I was a Data Architect working on several data warehousing projects, including a global procurement data warehouse project referencing Oracle and Teradata database platforms.
• Performed Data modeling, logical and physical database design, as well as requirements gathering and project management tasks.
• Designed processes for the administration of changes to Microstrategy metadata, especially prompts, attributes and fact development for the reporting tool.
• Consulted team on Retail Data Model initiative, performing requirements analysis against the NCR retail data model using expertise from years of retail experience to validate the processes in the model. Designed models and ETL for Item/Commodity/Buyer dimension in data warehouse, setting up a process for the grouping of products and the assignment of various item categories to support buyer/org group reporting.

Database Architect

Confidential

• Built and Maintained an Oracle multidimensional Data Warehouse used for capacity planning, market and sales analysis, and financial reporting.
• Created dimensions for Customer, invoice, and GL Account information.
• Modeled data Warehouse using ERWIN 3.5.2 and ERWIN 4.0 Also called ALLFUSION by CA . Performed forward and reverse engineering functions to keep database and model in sync.
• Performed all forms of requirements gathering, documentation, and ETL design. Etl functions are performed using COGNOS DECISIONSTREAM, SQL loader and Unix scripts. Front end reports created using COGNOS IMPROMPTU. Acted as liaison with business groups related to customer data mart validation.

Data Analyst III

Confidential

• I Maintained and designed data models for integrated enterprise data warehouse, including subject areas for marketing research and demographic data.
• Examined data for quality anomalies and coded PLSQL procs for correction.
• Designed structures and analyzed data for Oracle, AS400/DB2, Sql Server databases.

Database Architect/Analyst

Confidential

• I worked as a data architect on a project called Kaleidoscope, an analytical data warehouse to be built on top of the operational database used for the ION project. This was a large team of DAs, each working with different subject areas. Mine was Data Warehousing.
• Integrated an existing OLTP operational model with incoming data requirements from multiple enhancement projects for Sprint ION product. Most were resulting from changes to the order entry systems or provisioning processes.
• Contributed to planning and development of new ION integrated data warehouse project, including all manner of systems architecture and functions of ETL design and approach. Also, these tasks required the integration of the OLTP ordering system model with multiple external data sources into a common dimensional OLAP model.
• Handled modeling and data requirements gathering and mapping for operational reports. These included order fulfillment pipeline reports with drill down functionality. The front end software for these was Actuate.

Data Warehouse Architect

Confidential

• Was the team Data Architect for the Sprint EBI/BPR Financial Reporting Team.
• Performed all manner of data warehousing and data modeling, application design and application coding tasks as technical lead on several projects.
• Adopted support of existing system for competitor sales analysis database. Process was very unreliable and the data quality was poor when adopted. Enhanced process to run seamlessly and with complete data integrity in a fraction of the original time.
• Data modeling and table/index design in Oracle for project involving the capturing of booked revenue for several source systems within Sprint's finance division for local service, consolidating and aggregating data from these sources into a relational model consistent with Microstrategy reporting software Star Schema dimensional modeling .
• Performed logical application design for the above project and oversaw development with 4 team members.
• Performed Data modeling and design within Oracle for Activity Based Management project for Local systems, including complete table and index design responsibilities and application design roles for 8 team members. System contained over 20 tables and respective load processes for each. Worked with other teams to help fit local division process into sync with long distance and PCS.
• Performed application development duties on above project including the creation of PL/SQL scripts and Unix shell scripts for the loading and performance management of two 45 million row tables within Oracle.
• Developed Oracle application to measure the performance of field technicians. Organized and application development plan for team of 4 developers. Responsible for all data structures and application design. Helped new hires learn efficient coding techniques and planning.

Data Warehouse Consultant

Confidential

• Performed installation and administration of Promosmart Vendor receivables software, using COBOL DB2 for data extraction from the mainframe and PL/SQL and several canned Promosmart utilities for loading the data into the ORACLE database on the server.
• Performed installation and administration of Apollo Suite 7.0 software, used for the creation of store planograms a cad like document showing item placement within a shelf section in a store . This involved the creation of a data bridge between the workstation and the enterprise data warehouse located in an ORACLE Database on a UNIX server. This involved the creation of what was originally a workstation based MS/Access database, which I later moved to SQL Server, and the extracts and collaboration on the loads into ORACLE

Field Consultant Manager

Confidential

• Performed systems analysis and programming using COBOL II , SQL, and DB2 Utilities
• Consulted on and performed programming duties related to Year 2000 conversion of Sprint Human Resources system and version upgrade to Integral Payroll/HR system.
• Facilitated installation of all new personal computers for team, as well as installation of PC based Video Teleconferencing Cameras and software.
• Performed key role in numerous technical projects related to financial reengineering and the conversion of the Sprint financial systems to PEOPLESOFT format.
• Performed project involving the installation of home telecommuting systems for on call personnel.
• Consulted team on multi-tier replacement for FOCUS reporting process, utilizing cross system platform knowledge and expertise with CRYSTAL REPORTS and VISUAL BASIC.

Teradata DBA/Data Warehouse consultant

Confidential

• Performed systems analysis and programming using COBOL, SQL and Teradata utilities.
• Simplified and automated multi-platform data warehousing load processes, cutting manual intervention and run time of schedule in half.
• Later assigned to DBA area and worked as a Teradata DBA on migration and new integrated data warehouse design for 5100 database performing SQL tuning, spool management, security management and database design duties.

Sr. Programmer/Analyst

Confidential

• Designed new system for installation at logistics customer sites. Handled the integration of these systems into J.B. Hunt's preexisting transport and order entry host systems.
• Worked on support on several projects and was a key player in the installation of an 80 million dollar logistics contracts with J.C. Penney.

Confidential

Wal-mart Stores Inc Bentonville AR

• Designed, built and supported the Canned Order application, a MS Visual Basic application system that built orders to completely stock a new store with all valid replenishable merchandise. Internationalized the Canned Order system for new stores in Argentina, Brazil, China and Indonesia.
• Administered Comshare's Arthur Performance Tracking System which when used with its sister product Arthur Planning, allowed for a much improved way to handle buying plans in the merchandising departments. This included building a workstation front end for performance tracking, as well as, host bridging processors to tie this data to preexisting data kept in host IMS databases, a task that required learning Comshares's proprietary programming language AIII.
• Supported all Walmart ordering systems in an on-call rotation, correcting data and programming issues in workstation MVS batch and CICS screens.
• Handled the conversion of COBOL, DB2 and IMS programs to year 2000 requirements.
• Converted application to use an Informix database which handled the ordering of seasonal and apparel merchandise.
• Built numerous reports for store operations outlying problem merchandise distribution and assisted in the design of an automatic apparel distribution system that splits ordering workload for apparel to applicable Walmart warehouses. Team Leader
• Team leader for Teradata Operations group, setting directions, performing evaluations and hiring new associates. Handled typical managerial duties and set standard of cooperation with related applications and DBA areas in relation to daily duties.
• Upgraded the DBC1012 Teradata database system to the newer UNIX-based NCR3600. Senior Operation Analyst
• Responsible for monitoring, troubleshooting and scheduling all processes pertaining to the Teradata relational database system, including participating in the joining of the Teradata DBC1012 database systems into one 2.7 terabyte system.