SUMMARY

• He has over 20 years of Information Technology experience in Software Engineering Methodologies, Information Strategy Planning, Database Administration, Data Architecture, Business Analysis, Data Mining, Data Modeling, and Database Design.
• He has worked on several large Enterprise Database projects over the past twelve years to include: Trucking, Energy, Cellular, Insurance, Gas Operations, Manufacturing, Health Care, Finance, Banking, Military, Mortgage Lending, Order Processing, Telecommunications, Agile and IT Software Life Cycle Metrics.
• He has managed large multi - million dollar budgets and supervised over 55 people in his career.

TECHNICAL SKILLS

DBMS: SQL Server 2014, Oracle 11, DB2/UDB, SQLite, MySQL, SAP ECC

Operating Systems: UNIX (Sun, AIX), LINUX, IBM DB2, DB2/UDB, Windows 7

Life Cycle Expertise: Business Development, Requirements Analysis, BPR, Database

Design: Process Modeling, DBA, JAD, JRP, AGILE, Solution Delivery Life Cycle (SDLC)

Methodologies: Data Mining, Database Partitioning, Logical & Physical modeling, Dimensional modelingSTAR schema, Zachman Framework

Modeling / ETL: ERwin, SilverRun, S-Designer, Power Designer Visio, Ab Intio, Rational RoseMS Analysis Server, DESIGN/IDEF, BPWin, PILOT, Data Architect, Embarcadero, Safyr

Other Software: SOLIX, DataStage, MetaStage, SQL Compare, Odyssey Triple A, TOAD, MS Project, Apache

Web Server: Crystal Reports, SQL, MDX, MACOLA Work Flow Explorer

PROFESSIONAL EXPERIENCE

Enterprise Data Architect

Confidential

Responsibilities:

• Assists in building global-wide data strategies and visions including the migration of unstructured historical data from previous year acquisitions using information security policies; security risk assessments; information technology assessments; enterprise architectural assessments and data governance.
• Provides senior management, leadership, and oversight that ensures effective strategic planning, budget control, top-notch customer experience, global policies, standards, best practices, knowledge management, IT data architecture, solutions and infrastructure planning, and information security.
• Manages numerous data architecture solution functions within IT, such as data development, database operations management, data security management, reference & master data management, data warehousing & business intelligence management, document & content management, meta-data management, data quality management, data architecture management, and data governance.
• Leads business future visions and road maps to support current and future strategic planning for positive life-cycle development—huge wins for both IT and the business.
• Leads Confidential ’s data governance council (DGC)-- improving and governing data assets using both top down and bottom up approaches to improve the quality of data in all aspects of data architecture—working with data stewards.
• Dedicated leader--authored several business cases after creating both AS-IS and TO-BE enterprise system models to accomplish both current and future company goals.
• Uses data modeling tools, Embarcadero & Safyr to manage metadata and create data models.
• Works proactively with business units by creating process models and data flow diagrams to implement best practices that meet defined goals, policies and standards for Confidential .
• Manages IT data tools (Embarcadero Safyr) and user licenses for IT users.

Senior Data Architect, Senior Systems Architect

Confidential —Charlotte, NC

Responsibilities:

• Leads the Confidential 's Data Quality Analytics team. Responsible for….
• Creating a company wide data quality strategy and data quality program.
• Ensuring data quality is in support of accurate business analytics
• Creating techniques that measurably improve the quality of data in relation to defined business expectations
• Defining requirements and specifications for integrating data quality control into the system development lifecycle
• Providing defined processes for measuring, monitoring, and reporting conformance to acceptable levels of data quality
• Creating and defining testing and training approaches in support of data quality
• Enforces data governance/data quality--defining and documenting data architectures through gathering of requirements from end-user departments or through reverse engineering of existing data uses.
• Facilitate and document department agreements on appropriate corporate data and its usage
• Resolve conflicts between organizations
• Create logical data models for the Customer department, Power delivery department, Gas and Operations Department and enterprise logical data models.
• Designed logical data models for the Finance department and exported DDL files for DBA teams and other teams for review.
• Coach the IT team on the value and implications of data governance and data quality
• Educate end-users on the value of data and its associated attributes
• Provide support and verify quality through all stages of implementation
• Facilitator of data requirements and business rules
• Interface between end-users and IT
• Data futurist (i.e., visionary of future data uses)
• Catalyst for converting data into knowledge management.
• Sets Data Policy and the technical solution for the management, storage, access, navigation, movement, transformation, and security of data.
• Creates and maintains the Metadata Repository.
• Creates a semantically rich business model of the enterprise data domain that is independent of any technology solution using Agile methodologies.
• Compiles and maintains the Enterprise Schemas across all applications.
• Defines and enforces principles of good canonical data design.
• Examines and enforces opportunities to provide data reuse, balancing the issues of centralization and replication.
• Ensures the preservation of strategic data assets as applications and technologies of the day come and go.
• Reviews the policies and work of the other Data Architects

Senior Data Architect

Confidential —Charlotte, NC

Responsibilities:

• Responsible for the design of logical and physical data models for Confidential ’s data HUB environment using Erwin CASE tool.
• Responsible for working with project manager, solution architects, and other team members to define data requirements.
• Builds logical data models and systems methodology—normalizes data into third normal form.
• Builds data marts, data warehouses, data hubs and reporting databases.
• Works closely with vendors to understand their data model, database design and structure.
• Works closely with subject matter experts to understand their business processes and data needs.
• Designed a data hub to support the Common GIS model that merged Midwest and Carolinas Power Delivery and Gas Operations GIS data and their processes for today and future acquisitions.
• Works closely with Electrical Distribution, Electric Transmission, Electric Substation, and Gas Operation subject matter experts (SMEs) to understand their business processes and knowledge of their business and coach them.
• Designed the new Mobile Work Management System (MWMS) system for business units between Ohio/Kentucky area and the Carolinas for a common mobile platform.
• Coordinates and maintains Confidential ’s Data Governance standards, ICC, Information Management Architecture (IMA) standards, and Solution Delivery Life Cycle (SDLC) standards--briefing project teams on data methodology, data modeling and data stewardship approach process and procedures—using Agile methodology.
• Uses TOAD, ERwin, and other database tools to create, read, and verify current and future database structures.
• Multitasking--responsible for successfully managing multiple related and unrelated projects.
• Creates and follow project management processes and methodologies--ensuring projects are delivered on time, within budget, meets high-quality standards, and meet customer needs.
• Coordinates team resources with resource manager making sure the project has the right skill set for a successful complete project.
• Strong problem solving skills—works closely with programmers and end users on data integrity and meta data
• Advises and recommends senior management on key data aspects of projects to ensure successful completion-- “win-win” for all parties.
• Creates new databases from created data models and DDL scripts; working together with database administrators (DBA) by uploading scripts into ChangemanDS maintaining database integrity
• Submits new user account and passwords for team members for successful data access
• Excellent oral and writing skills—well rounded team player

Senior Business Intelligence (BI) Architecture Team Lead

Confidential —New Jersey

Responsibilities:

• Led US team and off shore team (India) with new business intelligence, database design, and database creation in support of Sales OLAP and OLTP Database system.
• Review client database system requirements--conducts requirement walkthrough with customer. Brief teams on client needs and requirements. Briefs client project manager with team progression and updates project plan.
• Using Erwin data modeling CASE tool--reviews OLTP database designs, creates OLAP data model, and CUBES using client business requirements. Conduct data mapping from source to target databases.
• Create new databases from created DDL scripts using Erwin data modeling CASE tool, creates queries, DTS scripts and packages for the migration of data between data warehouses in SQL Server 2005 and ORACLE databases.
• Created Sara Lee’s Business Information Model (BIM) using the major business functions and mapped the functions to the new business intelligence data model.
• Reviews all models for completeness and standardization.
• Responsible for designing. extracting, transforming, and loading (ETL) jobs from source to target databases.
• Integrate high level business rules with code and created a metadata repository for training source to target data.
• Designed and built a new data hub to reduce redundancy of data allowing flexibility and ease of incorporating new company mergers’ systems.
• Responsible for successfully managing multiple related and unrelated projects.
• Plans, designs, and controls various projects efforts requiring information technology support.
• Creates and follow project management processes and methodologies--ensuring projects are delivered on time, within budget, meets high-quality standards, and meet customer needs.
• Designs and executes management plans for time, cost, scope, quality, communications, and integration
• Using the SDLC process, translates customer business requirements into project objectives and tasks; creates weekly status reports on project progress throughout the project lifecycle
• Coordinates team resources with company resource manager making sure the project has the right skill set for a successful complete project.
• Develops and provide detailed project schedules, project work estimates, and status reports; tracked project milestones

Senior Data Modeler

Confidential —Charlotte, NC

Responsibilities:

• Create data models both logical and physical using ERwin, SQL and DDL scripts for business analysts and technical analysts for project deliverables.
• Create macros and map spreadsheet data templates to future data models and data warehouses and data marts.
• Reviews all models for completeness and standardization.
• Integrate high level business rules with code and created a metadata repository for training source to target data.
• Designed and built a new data hub to reduce redundancy of data allowing flexibility and ease of incorporating new company mergers’ systems.
• Responsible for successfully managing multiple related and unrelated projects.
• Plans, designs, and controls various projects efforts requiring information technology support.
• Creates and follow project management processes and methodologies--ensuring projects are delivered on time, within budget, meets high-quality standards, and meet customer needs.
• Designs and executes management plans for time, cost, scope, quality, communications, and integration
• Using the SDLC process, translates customer business requirements into project objectives and tasks; creates weekly status reports on project progress throughout the project lifecycle
• Coordinates team resources with company resource manager making sure the project has the right skill set for a successful complete project.
• Develops and provide detailed project schedules, project work estimates, and status reports; tracked project milestones
• Maintains Wachovia’s code of conduct and diversity throughout.
• Reviews various data models and provide proper data modeling techniques, standards and procedures.
• Excellent oral and writing skills

Senior Database Administrator / Senior Data Modeler

Confidential

Responsibilities:

• Using Erwin, data modeling CASE tool--Created several data models from various source files, ACCESS databases, propriety customer databases, and SQL SERVER databases in support of banking and investment data warehousing project.
• Mapped spreadsheet data to future data models and data warehouses and data marts.
• Created business flow diagrams, data maps, logical and physical data models for Wachovia’s investment fund business area. Designed a meta data repository using Erwin, MS Access & SQL Server 2000.
• Analyzed numerous data feeds and source system from propriety databases to MS Access databases in support of the Data Warehouse.
• Created macros to reverse engineer database and provided several data warehouse databases in support of Odyssey’s Triple A system. Provided keen insight and direction in the selection of the new Confidential data warehouse system.
• Using ERwin data modeling CASW and SQL COMPARE--Created numerous SQL SERVER data administration functions in develop (DEV), quality assurance (QA), and production (PROD) environment
• Support outage management using REMEDY, follow solution delivery life cycle (SDLC).
• Using SQL SERVER 2000, created new databases, created user accounts, backed up databases daily, created database jobs, implemented and tested user database objects (tables, views, stored procedures, packages), researched data load errors and failures, and monitored daily and weekly database activity.

Confidential

Senior Data Modeler

Responsibilities:

• Created logical data models using both PowerDesigner and Erwin CASE tools, business flow diagrams, METADA repository, and data maps for large investment company.
• Translated client business needs into technical solutions by analyzing system and reference data across multiple database platforms, follow solution delivery life cycle (SDLC).
• Conducted JAD sessions in efforts of designing a new employee benefit and contribution database system.
• Analyzed reference data from various systems, led JAD sessions and data model walk-throughs on findings.
• Reverse engineered company databases using macros and created several logical data models.
• Wrote SQL scripts and macros to import and export client data across SQL SERVER, ORACLE and DB2/UDB databases. Schedules database design reviews with team members. Created company documents on data methods and techniques.

Confidential

Data Architect, Database Administrator

Responsibilities:

• Managed 3 database teams across the United States, Atlanta, Georgia, Cleveland, Ohio, Melbourne Florida, and Anchorage Alaska.
• Designed several physical data models using Erwin data modeling CASE tool for major supply chain management system.
• Created interface tables that kept data integrity between data warehouse database (OLTP) in Chicago and numerous terminal trucking companies across the US, follow solution delivery life cycle (SDLC).
• Provided business development inputs to team members on potential issues and recommended solutions. Schedules database design reviews with team members on their requirements.
• Analyzed various data feeds and conducted data validation via FTP and cleaning up client data--making necessary recommendations and options for cleaning data.
• Wrote SQL scripts and macros to import and export client data across SQL SERVER databases.
• Created numerous SQL Server databases. Managed daily backups, created user accounts, analyze and wrote stored procedures in T-SQL.
• Designed new ORACLE data model and rewrote new procedure for migrating SQL Server database to ORACLE 8i database.
• Created company documents on data methods and techniques for client. Created weekly status reports and briefings to senior management in support of project plans and resource availability.

Data Modeler, ETL Developer

Confidential

Responsibilities:

• Created both logical and physical data modeling and database analysis for patient care business development using ORACLE, SQL SERVER, and ACCESS. The databases include Woman’s Health, Respiratory, Diabetes, Clinical Management, and Quality Diagnostics.
• Using ERwin, created several department logical data models---reverse engineered 8 company databases and merged them into one database for a company enterprise system. Created company standards for both logical and physical data modeling standards for implementation of both the enterprise system.
• Wrote SQL scripts and macros to import and export client data across SQL SERVER databases, follow system development life cycle (SDLC).
• Created a data dictionary to manage a Meta data repository for clinical information and woman’s health information. Analyze client data from 6 data sources and made necessary recommendations for data dimensions.
• Designed and implemented an operational data store and data marts for OLTP project using ERwin for Sales division. Used ETL tools (Pilot (third party software) and MS DTS) to load data from ACCESS databases into data marts. Used PILOT to build cubes. Used Microsoft SQL Server OLAP tools, FTP, and Crystal Reports for Sales test data. Created CUBES, and MDX scripts for senior management reports. Created SQL Server 7 databases for test environment. Held JRP and JAD sessions with database team members and programmers on database designs using models to illustrate and match business requirements.
• Created Confidential ’s Healthcare Business Information Model (BIM) using the major business functions and mapped the functions to the new business intelligence data model.
• Reviews all models for completeness and standardization.
• Integrate high level business rules with code and created a metadata repository for training source to target data.
• Designed and built a new data hub to reduce redundancy of data allowing flexibility and ease of incorporating new company mergers’ systems.
• Responsible for successfully managing multiple related and unrelated projects.
• Plans, designs, and controls various projects efforts requiring information technology support.
• Creates and follow project management processes and methodologies--ensuring projects are delivered on time, within budget, meets high-quality standards, and meet customer needs.
• Designs and executes management plans for time, cost, scope, quality, communications, and integration
• Using the SDLC process, translates customer business requirements into project objectives and tasks; creates weekly status reports on project progress throughout the project lifecycle
• Coordinates team resources with company resource manager making sure the project has the right skill set for a successful complete project.
• Develops and provide detailed project schedules, project work estimates, and status reports; tracked project milestones

Database (DBA) Team Lead

Confidential

Responsibilities:

• Accomplished physical data modeling and database analysis, including DATARUN and Information Engineering (IE) methodologies. Performed physical data modeling on a SYBASE & ORACLE distributed client server network, follow system development life cycle (SDLC).
• Used REMEDY for change management and control of software development.
• Worked on multiple projects as the database business development Team Lead. Used SilverRun and Rational Rose to create ERDs logical data models and physical data models and Object models. Created an ACCESS database and Visual Basic Front end using input form data. to assist in the management of META data repository from 15 physical databases.
• Facilitated weekly JAD sessions with team member on new physical database designs and validation of new requirements.