SUMMARY

• Confidential is a results - oriented Senior Consultant with over thirty years of professional information technology experience with skills in data architecture and infrastructure design for a wide array of industries. He uses his extensive data and information structure design background to customize the data information solution to fit the client’s needs. He has a knack for recognizing optimization opportunities in business and project processes and the ability to develop and implement practices to ensure successful, timely completion of projects
• Confidential ’s strengths include excellent communication skills, strong organizational, analytical and time management skills, with exposure to diverse technologies, cultures and business operations. He has an extensive background in data and ETL Architecture solutions, data management, data migration data storage design(for both database and data warehouse) and data integration with emphasis in Business Intelligence, Customer Master Design and Customer Master Data Integration (CDI), MDM DRM, EPM, CIM-MDM, PIM-MDM and Metadata Design and Integration, improving efficiency, team building, and detailed project planning to determine effective solutions.
• Confidential has an extensive background in gathering, analyzing and defining business and functional requirements and designing processes, workflows, and technology solutions for IT applications and systems; with special emphasis on efficient and effective data storage designs (data warehouses, data marts, ods, and database platforms) including data quality aspects (profiling and cleansing considerations. He quickly grasps complex concepts, analyzes and interprets business concepts, needs and ideas into strategy and roadmaps.
• Confidential also has a wide range of knowledge on Data transformation and modeling tools such as Infosphere (Datastage and quality stage), Informatica, SSIS, Erwin, PowerDesigner, ErStudio and others. He also has a lot of experience in data visualization and BI tools such as Cognos, Microstrategy, Tableau, Business Objects, Pentaho, and Elastic Search.
• In addition to his technical capabilities, Confidential has shown exceptional oral and written communication skills by enabling enhanced Business and

TECHNICAL SKILLS

• Data Management
• Data Architecture
• Data Strategies
• Data Modeling
• Database Design
• Data Warehouse Design and Implementation
• Requirements Gathering
• Master Data Management
• Customer Data Integration (CDI)
• System Analysis & Design
• Data Integration
• Data Quality Processes and procedures
• Data Migration
• Policy/Procedure Development
• Client Relations
• Technical Specification
• ETL Processes
• Issue Resolution
• Team Leadership
• Reducing Data Redundancy
• Data Profiling
• Data Cleansing
• Metadata Management
• Project Management
• Business Process Improvement
• Data Governance
• Communication Skills
• Data Dictionary
• Business Intelligence Solutions

PROFESSIONAL EXPERIENCE

Senior Database Architect/Data Modeler

Confidential, Omaha, NE

Responsibilities:

• Confidential ’s role for Kiewit is to redesign the existing EDW/ODS and OLTP areas to integrate data from a new software product recently purchased by Kiewit to enhance their product line. Confidential is using ERStudio to do the data modeling and uses Visual Basic to modify existing scripts that produce items for each of the database (MS SQL/DB2 and Teradata) and data storage areas (Dev/Test/QA/Staging/Production) that are used to produce the organizations reports and BI information. The former tool Power Designer was recently replaced with ERStudio so conversions of existing data models is ongoing.
• Confidential works with data modelers, DBAs, ETL Developers and enterprise architects to ensure mapping and needed information is brought into the new system. Confidential developed a series of scripts and an automated process to bring in the new data pieces as well producing mapping reports and spreadsheets to verify conformance with requirements. The ETL tools to migrate the data are BTEQs SSIS and Informatica.
• The databases Confidential worked with at Kieiwt include MS SQL and Teradata, as SAP fed the EDW system from the projects that they were involved in; which was used for extensive BI and reporting out of both sets of Databases. There was merging of the data from the SQL Ineight system into the EDW system as well as information from SAP into that system; which resided on Teradata.

Senior Database Architect

Confidential

Responsibilities:

• Confidential ’s role for the State of Nebraska was to install all of the components of Infosphere, Cognos and DB2BLU and setup the system to allow for users to work with all of the tools in the Infosphere and Cognos suites. Confidential was the administrator as well as the developer for the datastage, quality stage, Cognos framework manager and report studio, etc. He created processes to move data from the existing SQL (Microsoft) systems to use DB2 and its new DB2BLU features and make use of the columnar features as well as creating an ODS and Datawarehouse for the state to use for the supreme court and Probation office information. He also created the new reports in Cognos using the existing Justice SSRS reports as our base to build from or clone. We also installed Cognos Analytics and BI as part of the overall package the State wanted to explore and use but had not identified where to begin with these area when I left. We also attended an IBM Watson Analytics seminar put on in Omaha and they wanted to look into that as well.
• Confidential worked with the system personnel at the state to secure needed access and VM Server setup and installed the needed IBM software for Infosphere, Cognos and DB2BLU and created the needed items to allow for the large data migration to begin. Confidential developed a series of jobs to move the data from the existing SQL Server 2012 database system for both Problem solving Court and Probation NPACS system to the new DB2BLU database. He also created the needed security groups and trained the state personnel on the tools.

Technical MDM Architect

Confidential

Responsibilities:

• West’s primary Data warehouse database is Greenplum and it is used exclusively for all reporting and BI analysis needs. All of the work Confidential did at west involved working with Greenplum and Postgres as that is what Greenplum base code is. We developed a lot of routines and scripts for working with Greenplum and the IBM tool suite Infosphere.
• Created new billing and reporting systems off of application logs versus the existing system that could only produce them off of server logs. This was to allow billing to Comcast as they did not use West servers; but only West applications. Reporting was geared to Microstrategy to show data visualization of all calls and IVR processes for the millions of calls and transactions West processed.
• Created an ODS layer where data from all applications was delivered to in order to consulate and clean it to ensure data quality was met. This area also served as the real time mechanism for reporting, as well as the staging area for all aggregations and detailed data before it was sent off to the data warehouse for historical reporting.
• Redesigned the underlying database and tables for the existing SMS system, which led to an average of 250K increase over existing SMS billing system for the client United Health Group alone, (they were the largest customer on that system).
• Led the establishment, creation and implementation of Data Governance at West. West had never had Data Governance before I arrived and it was one of the primary things we got built while I was there.
• Created various artifacts (data models, Visio architecture and data flow diagrams, DDL, stored procedures, ETL diagrams, ETL and database designs and data maps, etc.) to allow for migrating of all data items into production including business approved documentation.
• Worked with the production, development MIS, ETL, Reporting and database teams to coordinate testing and movement of items from development areas into production; conducted extensive data analysis and trouble shooting on all processes to determine if all needs were being addressed.
• West has a large amount of data and most of their data would be considered Big Data in nature. Developed the ground work and POC for building a Data lake for their data with a Hadoop database.
• Created process models and swim lanes using BPM for West IT areas.
• Created long and short term Data Architecture, and ETL Architecture vision, Strategic and Tactical roadmaps to achieve the Data Architecture Vision beginning from the current state and assisted in the overall technical roadmap. Data Architecture and ETL Architecture technical vision were geared towards the new technologies in the communications industry.

Project Technologies/ Products ER Studio XE6, EMC Greenplum Database, Microstratgy, SQL Server (2012), BPM, Oracle 11G Database products, DB2 Database products, Infosphere ETL suite, Informix Database, MySQL, Postgres, VPotgres, Cassandra, WSO2 suite, Microsoft Office, Project, and Visio.

Confidential

Lead DI Architect

Responsibilities:

• Worked with the production, UAT ETL and database teams to coordinate testing and movement of items from development areas into production; once acceptance testing had been approved and passed.
• Updated various data models and created new ones where needed as the project moved into different phases.
• Worked with the company production migration teams to create and design a plan for moving the new items into production.
• Did extensive data analysis and trouble shooting on all taggen processes to determine items were being correctly created and formatted.
• Developed for Sogeti an in-house database for dashboard creation to tie clients to candidates via skills and abilities.
• Created a Big Data presentation for Sogeti GVP to present at InfoTech.
• At All clients Confidential conducted current state analysis to capture all existing objects in the various (prod, Dev, Test, UAT) systems.
• At Vermeer he defined the MDM approach and the “Vermeer” version of the MDM reference architecture and evaluated the Metadata repository modules from vendors for their integration into the MDM and ETL streams. Assisted with initial standup and implementation of IBM-MDM tool InfoSphere and tool set suite. Designed processes and procedures for standing up CIM-MDM and PIM-MDM
• He proposed and established the ramp up of the Data Governance function and a Data Governance Board and its processes.
• At Grant Thornton Confidential created artifacts for migrating all GT Enterprise system objects over to new areas, including Databases, Tables, stored procedures, new security framework and processes to ensure everything was moved and upgraded to the new server hardware as well as validating the upgrade of the software applications.
• He created a Data Migration plan and design for moving the structures and data into the new areas along with tracking processes.
• Confidential created data models, diagrams and processes for the Companies Customer Data (Saleslogic and CSM) systems as well as the new Data and ETL architecture for the GT ERS (Enterprise Reporting Systems).
• At Sammons Confidential created recommendations on available options to tune and upgrade (to SQL2008 R2), the existing SQL 2005 databases, re-architect the existing SAN, redesign the existing applications, databases, stored procedure calls and functions, develop a true Data Warehouse, bring in new servers and software to allow for upgrading the existing SAN or replace it with a new one, as well as reconfiguring recommendations on the existing SAN.
• At AON Confidential created the QA framework including Unit, System, Functional testing approaches, Overall QA Approach and requirements, data masking strategy and designed the ETL framework architecture for the QA Audit, balance and Control (ABC) database.
• He Created the Data model for QA ABC database to track, audit and verify accurate client data Conversions.
• He also Created ETL processes, stored procedures, and technical specifications and documentation for migrating client data (conversions and Customer Data Migrations) from existing source systems onto the new Grids application system.

Project Technologies/ Products CA-Erwin, Microsoft Products: Office, (including word, excel, power point, project), Data Management Studio (2008,2005), SQL Server (2000, 2005, 2008. 2008 R2 and 2012. IBM Products: DB2, InfoSphere MDM, DataStage, QualityStage, Mysql, Oracle Admin tools Oracle 11g, Toad SQL developer, Informatica, Oracle Admin tools Oracle 11g, Netezza, Business Objects.

Sr. Database Architect

Confidential Omaha, NE

Responsibilities:

• Provided project management assistance for the imbedded architect and kept the project on track to completion of the first two phases before the completion of the initial Dollar General Data Migration to the Werner Smart application system.
• Created ETL Architecture roadmap for merging historical client data from the old system with data from the new system; as well as creating new databases and table structures for the migrated data.
• Analysis of existing data was performed to establish the quality and validity of the current data on the existing reports.
• Created Data models, ETL Architecture and ETL processes, stored procedures, and technical specifications and documentation for moving Werner’s top client on to the new system from trips as well as creating new metadata repository to map back to source. Created conceptual, logical, and physical models for IT and business.
• Designed a series of new databases and tables within SQL Server 2008 R2 for the purpose of continuing to produce the needed reports and information for Dollar General Customer Master and freight information on the Smart system.
• Created new sql server 2008 R2 stored procedures and function calls to facilitate ease of data retrieval.
• Created and designed new metadata repository, which was not implemented due to time and cost constraints. Cost benefits analysis was also prepared to show why it was needed by Werner.
• Directed/managed the work of ETL Developers in their day to day activities; Development methodology used was Agile methodology to accomplish tasks.
• Expertise inSSISandSSRSwith good knowledge onSSAS, as most reporting and analytics used SQL Server.
• Have developed many reports onSSRSfor various versions of SQL Server (2008/2008R2/2012). Sound Experience and understanding ofSSAS, OLAP cube and Architecture. Developed many cubes for reporting and analytics at Werner, like I have for various other companies.

Project Technologies/ Products CA-Erwin (Allfusion), Mysql, Server Studio, Microsoft Office, Project, and Visio, Visual Studio 2008 and 2005, SQL Server (2008 R2, 2008, 2005), SSIS (2008, 2008 R2), SSRS (2008, 2005), Data Management Studio (2008 R2, 2008, 2005), IBM Products: DB2 Control Center, Informix, DB2, DataStage and DTS packages.

Sr. Technical Data Architect

Confidential Columbus, OH

Responsibilities:

• Worked as Sr. Technical Data Architect responsible for creating Enterprise Data Strategies and Data Management Strategies for the Confidential . Strategies took into account current environment for all aspects of enterprise data and produced a future plan for new architectures (SOA). Creation of Enterprise Data Warehouse, ODS and MDM databases; beginning with the information the company had in their CRM package (Salesforce).
• Created Maturity Models for level setting baseline of where Huntington is at for Data Governance, Data Architecture, Data Security, Metadata Management, and Master Data Management as part of the overall development of an Enterprise Data Management and Data Migration Strategy. Created conceptual, logical, and physical data models from business requirements working with Huntington IT personnel.
• Created Long term and short term Data Architecture, and ETL Architecture vision and Tactical roadmaps to achieve the Data Architecture Vision beginning from the current state and assisted in the overall technical roadmap preparation that was presented to Huntington.
• Vendor selection consisted of Microsoft, IBM and Oracle; two of which (IBM and Oracle) made MDM presentations and an analysis of these solutions was critiqued and feedback provided to Huntington.
• Created Data Models for MDM solution (Customer Master) and documented where Huntington’s data (much of it from the Salesforce application software), would fit into each vendor’s MDM solution.

Project Technologies/ Products MDM, SOA, CA-Erwin (Allfusion), Microsoft Office, Project, and Visio, IBM Products: DB2, InfoSphere, DataStage, MySQL, Oracle Admin tools Oracle 11g, Toad SQL developer.

Confidential

Lead Enterprise Data Architect

Responsibilities:

• Managed staff of several teams from 3 to 7 individuals each tasked with delivering data strategy items: Data Management, Data Quality, Data Governance, Data Structure, Data Architecture, Data Security, Metadata Management, Master Data Management and Geospatial Data Strategy. Responsible for project planning/task and project reporting and working with senior business managers to develop road map and project deliverables. Gathered business requirements and reporting needs for entire USDA business applications (327+ applications across various database platforms). Implementing conversions from legacy systems (Informix) to web (oracle) platforms. Worked with senior business managers at the USDA to upgrade systems to meet business needs.
• Creation of Enterprise Data Warehouse and analyzing all existing systems and processes for FSA to allow for conversion of existing applications into SAP system - all on an Oracle platform.
• Data Architecture and ETL Architecture technical vision was geared towards Java Development and was to support Data Distribution and Data Migration to various areas and platforms including AS/400, over 3500 servers, a web farm, various data marts and several hundred DB2 databases on mainframes. All systems were classified as high availability and 24/7 support.
• Created Maturity Models for level setting baseline of where FSA was at for Data Quality, Data Governance, Data Structure, Data Architecture, Data Security, Metadata Management, Master Data Management and Geospatial Data Strategy as part of the overall development of an FSA Enterprise Data Management Strategy.
• Created FSA conceptual, logical, and business process models from business requirements and mapped all Objects to existing Relational databases or new required data storage areas.
• Define MDM approach and vision of the MDM reference architecture, including DRM.
• Evaluate Metadata repository modules and their integration into the MDM DRM and ETL streams.
• Develop processes and procedures to update the MDM hubs including working with the DRM functions.
• Developed high level and detail design documents based upon user and business requirements for the various iterations of the long term project thru different phases. Developed an Enterprise Data Warehouse from gathered business and technical requirements for areas of farm and other USDA programs.

Project Technologies/ Products: CA-Erwin (Allfusion), Power Designer, Mysql, Oracle Admin tools Oracle 11g, Oracle Exadata, Toad SQL developer, Microsoft Office, Project, and Visio, SQL Server 2008, IBM Products: DB2 Control Center, Informix, DB2, WebSphere and Informatica (8.5 and 8.6), Teradata, Netezza and an Enterprise Architecture tool called Mega (2007 and 2009 - to lay out the existing systems within FSA).

Confidential

Sr. Technical Data Warehouse Architect

Responsibilities:

• At all Clients Confidential developed naming standards for data modeling, data warehouse, databases and the data dictionary and was responsible for creation & maintenance of Data Dictionary within Power Designer and ER Studio.
• Confidential ’s accomplishments while at Fidelity included designing data information structures (Data warehouse, Data marts, Database and ODS) using ER/Studio 7.5 and Power Designer 12; as well as the overall SOA data architecture structures.
• Led the design and development of Databases, Data warehouse and ODS platforms for Fidelity Whole Life and Health Insurance and a redesign of the existing OAB system from Oracle that is used to handle healthcare and insurance items for other companies.
• Developed Oracle ESB procedures and processes for data services in conjunction with assisting in the development of the web services that moved data from almost any platform coming into the system to the various platforms Fidelity had in their enterprise system (oracle and SQL databases, the ODS and the Fidelity EDW.
• Define MDM approach and vision of the MDM reference architecture, including DRM.
• Evaluate Metadata repository modules and their integration into the MDM DRM and ETL streams.
• Develop processes and procedures to update the MDM hubs including working with the DRM functions.
• Created XML scripts for use with a standardized Fidelity file formats for input/output to/from clients.
• Developed high level and detail design documents based upon user and business requirements for the various iterations and phases.
• Worked with .net developers to create proper data storage areas (xml/xsd for Data Service calls) and most efficient data processing methods; (access, retrieval, update, etc.).
• Assisted in the creation of a presentation and proposal for where the company should go next with software and applications. Proposal showed current state and future state of Woodmen systems and architecture from an IT perspective.
• While at McKesson Confidential analyzed all existing data (profiled, analyzed, standardized using various DataStage tools) from various file platforms such as Client Server and Web applications in regards to quality, fit and need for the new MMP system. This included analyzing all the existing medical codes (for example: CPT, DRG, and ICD-9 code sets).
• Duties and responsibilities included developing models in ER/Studio, Leading the design and development of Data marts, Databases) and a Data warehouse for McKesson Health Solutions and a redesign of the existing CRMS database/data warehouse system into one with more functionality.
• Develop conceptual, logical, and business process models and mapped all Objects to existing Relational databases or new required data storage areas. Used industry standard UML models and modified accordingly to fit healthcare model needs as matched company and/or client business data.
• Developed Oracle ESB procedures and processes for data services in conjunction with assisting in the development of the other services that moved data from almost any platform coming into the system to the various areas and platforms McKesson had in their enterprise system (oracle, SQL databases, DB2 databases, the CRMS database and the McKesson EDW).
• Data Architecture and ETL Architecture technical vision was geared towards Java Development and was to support Data Distribution and Data Migration to various areas and platforms specific to each client.
• Created XML/XSD scripts for use with a standardized McKesson file formats for inputs/outputs from/to clients; as well as handling updates to McKesson medical codes from the ICD-9 code sets.
• Define MDM approach and vision of the MDM reference architecture, including DRM.
• Develop processes and procedures to update the MDM hubs (in Oracle) including working with the DRM functions.
• Developed high level and detail data and ETL architecture documents based upon user and business requirements for the various iterations of the long term project thru different phases.

Project Technologies/ Products ER/Studio tools, Power Designer, Mysql, Oracle Admin tools, Oracle 10g & 11g, Toad SQL products, Microsoft Office, Project, and Visio, Visual Studio (2005, 2008) SQL Server (2008, 2005), SSIS (2005, 2008), SSRS(2008, 2005), Data Management Studio (2008, 2005). IBM Products: DB2 Control Center, Informix, DB2, and Data Stage. Hyperion, Oracle Admin tools including RAC admin for Oracle 10g, Netezza, Teradata, Business Objects Data Services. Teradata, Agile Project Methodology. XML editors used were Liquid XML and XML Spy.