William G.

William G.

Enterprise data architect with a record of providing solutions to advance corporate strategy.

Texas , United States

Experience: 31 Years

William

Texas , United States

Enterprise data architect with a record of providing solutions to advance corporate strategy.

192000 USD / Year

  • Immediate: Available

31 Years

Now you can Instantly Chat with William!

About Me

Last 10 years

  • 1 year Disbursements Data Lead, with 4 DBA and 4 data designer/modeler reports
  • 1 year Sr. Data/Solution Architect, with a team of Data Architects, Data Modelers, Data Analysts, QA Team and a team of off shore...
  • 5 years Project Management (MS Project)
  • 13 years Data Modeling (IDEF1, ERwin 3.4 to R8.2 Workgroup Edition, ER Studio to 9.6, Toad Data Modeler) OLTP, OLAP and Dimensional
  • 15 years Creating and updating Data Dictionary definitions, standards & implementing
  • 6 years Data Architecture (Oracle3.14c, 8.x, 9.x, 10.x, Teradata 13),
  • 8 years Enterprise Master Data Management, Reference Data Management, Data Governance, Data Stewardship and Metadata Management
  • 3 years IBM Information Analyzer of data for 75+ Kentucky Tax Systems to identify redundant data, data quality issues and define ETL rules for the Data Stage Developers and define Master Data Management, Reference Data Management.
  • 2 years Business Analysis Call Center Efficiency
  • Managed teams from 3-25, onsite and/or off-shore

My experience as a Sr. Solution Architect

  • Conduct SDLC Reviews, including framework compliance, design, code and test.
  • Note any areas of Project Risk, develop Mitigation Plans and Review with Project Managers and Project Stakeholders for concurrence.

My experience as Data Architect/Data Modeler has included:

  • Master Data Management, Data Governance, Data Stewardship
  • Reference Data Management
  • Data/Database Conversions, Data Migrations
  • Data Mapping including documenting ETL requirements for developers
  • Reverse Engineering Legacy databases into models
  • Updating/upgrading the CDM (Conceptual Data Model), LDM (Logical Data Model) and PDM (Physical Data Model)
  • Creating the initial DDL (Data Definition Language) script for DBA implementation.
  • As a Data Modeler, I design the LDM to be database agnostic and have created DDL’s for dBase 3/IV, Oracle, DB2, SQL Server, Ideal and many other databases.
  • 4 years conversion between (Oracle Designer to ERwin, IBM Data Architect to ERwin, ER Studio to ERwin …) Data Modeling tools Lead

In summary:
As an Enterprise Data Architect offering extensive experience, poised for a global role defining, driving and implementing data strategy to inform and impact senior management’s strategic business decisions. Dynamic leader of large-scale, multi-national enterprise data management engagements through all phases of the project lifecycle. True value is the ability to provide data that is current, accurate, and complete, to launch and optimize effective technical solutions. Committed to empowering organizations to leverage and transform data to achieve innovative results. Strong technical analyst; deep experience in customer-facing CRM application systems. High level of IT technical competence, and understanding of the dependencies between business applications and the underlying support technologies.

  • Enterprise Data Architecture
  • Application Design
  • Full Lifecycle Development
  • Business Intelligence
  • Master / Reference Data Management
  • Architecture Design & Development
  • IT Project Management
  • Database Normalization
  • Data Redundancy Reduction
  • Data Governance / Stewardship
  • Data Modeling / Mapping, OLTP, OLTP and Dimensional
  • Data Warehousing / Data Marts
  • Data Quality Enhancement
  • Data Strategy

Show More

Skills

Portfolio Projects

Description

Developed Data Governance and Master Data Management workflow for Trade and Supply and other Shell Trading Lines of Businesses for the projects to reduce redundant data in the systems and reduce the overhead while increasing the data quality. This DG & MDM workflow will guide the Project Managers for processing additional Critical Data Elements and procedures for data management and data life cycle management. Performed this project as a consultant through IBM/Collabera.

Show More Show Less

Description

I have the broad overview as an Enterprise Architect and have a firm grasp of the interactions between all business areas, offering suggestions for improvement along with offers to assist other areas with review and implementation. They included migrating 15+ Site Data Warehouses to two mirrored Global Data Warehouses. The inventorying is still in progress, with over 10,000+ Systems, 100,000+ Tables and 500,000+ columns, 20%+ of the systems are collecting over 10 TB of operational data daily.

Show More Show Less

Description

Managed a Y2K compliance project involving data collection and conversion in COBOL, PL/1 and JCL. Directed 10 software engineers in India, Philippines, and the US. Defined functional requirements, tracked assets from acquisition to online display, then created LDM/PDM and DDL to create the database. Coordinated progress tracking for corporate system development life cycle directives. Managed an engineer who built a database to prioritize project tasks and create an audit trail. Merited management recognition for delivering the project 3 months ahead of schedule, largely because of excellent project planning.

Show More Show Less

Description

Led the Solution design for multiple T-Mobile BI/Data Warehouse projects. Lead and develop an analytic team that delivers timely and high-quality reports that provide insights and recommended actions to drive program scale, efficiency, and effectiveness. Work with leadership teams across enterprise, including Sales, Finance and Care, to provide key reporting solutions to drive enterprise financial results. Monitor and interpret regular report results to identify business opportunities, leading indicator of risks and advise leadership team those risks and opportunities. Work with BI teams to enable data architecture and solutions that are best meeting analytics and reporting needs of various analytics groups. Frame new reporting solution, including key metrics to be reflected in the most consumable layout and coach the team to develop and QA. Provide necessary implementation reporting support on key business projects and initiatives. Conduct SDLC Reviews, including framework compliance.

Show More Show Less

Description

Manager of the Data Architects and Data Modelers while reviewing the Business requirements. Scheduled Data Architects, Data Modelers and development to support the project. Serve on the Enterprise Boards for Data Governance, Data Standardization and Meta Data Management including Data Dictionaries and Data Mapping between multiple projects. Lead the creation of the Enterprise Data Dictionary and Master Data Mapping Warehouse and defined the process to what various artifacts should be included with warehouse development. Create processes and procedures for data management and data life cycle management for the ministry.

Show More Show Less

Description

Senior Data Architect/Metadata Administrator 2016: Create processes and proceedures for data management and data lifecycle management. Including metadata management, loading, mapping metadata and create data lineage and develop data quality initiatives. Develop approval checkpoint workflow across departments, divisions and lines of business to create metrics, data elements, KPI, critical data elements and Business Glossary/Data Dictionary. Design dashboards for presenting information to senior executives showing the data quality, by date range providing insight with developed processes that monitor data quality. Oversee and align metadata portfolio with business/domain portfolio, Create Data lineage, Data architecture and manage various data sources, Monitor Data Quality rules and ensure Ongoing quality compliance of the data. Performed this project as a consultant through TCS.

Show More Show Less

Description

Developed a common data LDM and tax systems LDM for a new $35M+ Enterprise Tax Management System, to collect taxes across 100+ classifications. Established a logical conversion data warehouse to map current physical databases. Consulted with business specialists, developers, and analysts. Performed data analysis, built the data dictionary from 20-year-old documentation that was never updated, and performed data profiling, data cleansing and data mapping. Developed the long-term strategy and defined guidelines for Master Data Management, Data Governance, Data Stewardship and Reference Data Management Standardization for all 31 CIOs of the Commonwealth of Kentucky government cabinets. Conduct SDLC Reviews, including framework compliance. Environment: ERwin 4.x, 7.x, Oracle 9/10g, SQL Server, Access, FoxPro, dBase. Excel, Mainframe DB2, IMS, VSAM, ISPF. Performed this project as a consultant through Cook Systems International.
* Conducted a technical review of the RFP and outlined the evaluation criteria for responses, necessary for the non-technically oriented response evaluators.
* Conducted Detailed Data Analysis of 75+ Tax Systems Data with IBM Information Analizer identifying Data Redundency, Master Data Management candidates, Data Quality issues and defined ETL rules, confirming with SME’s, end users and stakeholders, for the Data Stage Developers.
* Detailed the requisite tests and testing timeframes, then created a database to track time. From the results, launched a dashboard for management to view tolerance variations and therefore better uphold compliance.
* Garnered contract extensions and role expansions from data architecture / modeling, to data analysis, and project management. Negotiated a 10% compensation increase with each extension and longer time frame.

Show More Show Less

Description

Led the design of a Common Disbursements Database (Master Data Management [Gold Source]), to enhance and standardize the online customer experience across disparate State Farm divisions. Evaluated the legacy disbursement data system and business requirements, and solicited input from the business analysts and stakeholders. Built a high-level LDM converted to PDM for DBAs, partnered with application architecture and technical execution architecture specialists, and liaised with the project teams implementing technical design and architecture. Managed a Lead DBA, 4 DBAs, a Data Quality Analyst, and 4 Data Modelers / Designers. Led an iterative process as new requirements emerged necessitating modifications to the models. Conduct SDLC Reviews, including framework compliance. Environment: Salesforce, CRM, ER Studio Data Architect 8.x, IBM DB2 ver 10, Oracle 11, PostgreSQL 9.1, MS Project 2010. Performed this project as a consultant through B2B Workforce, contracted with IBM.
* Met all project deliverables on time, despite a mid-project change to expand data typology into 5 separate phases.
* Completed complex data mapping not only between the legacy and target databases, but also incorporating business definitions and evolving business data names.

Show More Show Less

Description

Conceived and developed a new interdepartmental workflow, project management plan and work breakdown structure with checkpoints and milestones showing when and who should provide approval to provide an audit trail. Analyze critical data to ensure accuracy, consistency, validity, timeliness, reasonableness for quality gaps, implementing reporting processes to track progress over time. Establish overall strategy to determine, investigate and resolve data quality issues. Create and determine ongoing process for auditing and maintaining data quality. Manage data profiling and data quality tools to uncover the root cause of data quality issues.

Show More Show Less

Description

Coordinates the development of the data model. Liaison at the portfolio (Enterprise) level between Business, Data Architecture and development. Along with serving on the Enterprise Boards for Data Governance, Data Standardization and Meta Data Management specifically Data Dictionaries and Data Mapping between multiple projects in different portfolios.

Show More Show Less

Description

Redesigned the product catalog LDM/PDM to improve support for the Nike.com online store. Incorporated functionality to secure images until official release date, preview until release, or preview before sales start. Also, realigned databases from market/region/country to allow product release by country. Identified common data across the legacy databases, then engaged stakeholders to classify products required for the new consolidated catalog, to build a single database with allowable countries indicated for each product. Environment: SAP, Salesforce, CRM, ERwin 7.x, R8.x, Oracle 10g/11g. Performed this project as a consultant through VERCON, while simultaneously working remotely for Bank of America.

Show More Show Less

Description

Executed a project to create a business intelligence data warehouse for the real estate credit risk division’s monthly reporting, an enhancement from prior manual quarterly reporting. Partnered with business analysts, users, and stakeholders to determine data sources. Identified the method to reverse-engineer source systems to map to the target systems in a physical data model, including database warehouse entities for Impaired Loans, Serviced by Others (SBO), Reverse Mortgages, Correspondent Lending and Student Lending, to speed development and increase accuracy. Conduct SDLC Reviews, including framework compliance. Environment: Salesforce, CRM, ERwin 7.x Workgroup Edition (Change Management), R8.x, SQL Server 2005/2008, Teradata 13, Microsoft Project 2007. Performed this project as a consultant through ICONMA.

Show More Show Less

Description

Designed the LDM/PDM for proof-of-concept of an administrative library management (Open Library Environment) module to track Kuali Foundation financials (KFS) and funds donated to purchase library materials, and to report fund usage to the foundation. Supported the off-shore development team modifying the Oracle database structure. Conduct SDLC Reviews, including framework compliance. Environment: ERwin 7.x, R8.x, Oracle 10g/11g. Performed this project as a consultant through HTC Global Services.
* Acted as a technical architect, working with the business analyst and developers to facilitate communications regarding business requirements and technical functionality.
* Captured significant savings by leading the in-house design of a metadata repository, eliminating the need to purchase an off-the-shelf solution.

Show More Show Less

Description

Provided data modeling support for OLTP and Teradata data warehouse, strategized and completed the conversion of all LDM/PDM in Erwin 7.3 to IBM IDA (InfoSphere Data Architect), in order to facilitate integration with other IBM solutions in the environment. Delivered this project in 50% of the scheduled time frame, by using a bridge product to automate the conversion. Environment: ERwin 7.x, Teradata, IBM InfoSphere Data Architect. Performed this project as a consultant through Trianz Consulting.

Show More Show Less

Description

Led a team of data modelers and DBAs in the conversion of all data models from Oracle to Toad Data Modeler, to implement a nationwide repository for the $65 million VistA (Veterans Health Information Systems and Technology Architecture). This initiative would allow any VA medical facility nationwide to electronically access a patient’s entire record, history, and treatment plan. The new data models also impacted Repositories and Enrollment System Redesign (ESR), Person Service Identity Management (PSIM), and Administrative Data Repository (ADR). Scope encompassed documented Toad deficiencies, building the business case, and recommending an upgrade to ERwin 7.3. Also, defined guidelines for data governance, data stewardship, and reference data management standardization. Identified synchronization issues of development stream across six physical database instances. Conduct SDLC Reviews, including framework compliance. Completed interface mapping from EPIC Systems. Environment: ERwin 7.x, Oracle 10g/11g, Oracle Designer, Toad Data Modeler.
* Conducted a gap analysis to classify data being collected at certain local facilities but not others, mapped that data, and collaborated with the regional facilities to define data to be migrated to the national repository.
* Used ERwin to compare physical data models, identify differences, and more accurately track completed and pending changes, essential to effectively support 3 simultaneous development projects.

Show More Show Less

Description

Developed a common data LDM and tax systems LDM for a new $35M+ Enterprise Tax Management System, to collect taxes across 100+ classifications. Established a logical conversion data warehouse to map current physical databases. Consulted with business specialists, developers, and analysts. Performed data analysis, built the data dictionary from 20-year-old documentation that was never updated, and performed data profiling, data cleansing and data mapping. Developed the long-term strategy and defined guidelines for Master Data Management, Data Governance, Data Stewardship and Reference Data Management Standardization for all 31 CIOs of the Commonwealth of Kentucky government cabinets. Conduct SDLC Reviews, including framework compliance. Environment: ERwin 4.x, 7.x, Oracle 9/10g, SQL Server, Access, FoxPro, dBase. Excel, Mainframe DB2, IMS, VSAM, ISPF. Performed this project as a consultant through Cook Systems International.
* Conducted a technical review of the RFP and outlined the evaluation criteria for responses, necessary for the non-technically oriented response evaluators.
* Conducted Detailed Data Analysis of 75+ Tax Systems Data with IBM Information Analizer identifying Data Redundency, Master Data Management candidates, Data Quality issues and defined ETL rules, confirming with SME’s, end users and stakeholders, for the Data Stage Developers.
* Detailed the requisite tests and testing timeframes, then created a database to track time. From the results, launched a dashboard for management to view tolerance variations and therefore better uphold compliance.
* Garnered contract extensions and role expansions from data architecture / modeling, to data analysis, and project management. Negotiated a 10% compensation increase with each extension and longer time frame.

Show More Show Less

Description

Designed LDM/PDM models to create databases for multiple technical support concerns and trend analysis, primarily for the call center serving Comcast customers. Established guidelines for data governance, data stewardship, and reference data management standardization. Conducted efficiency analysis to reduce agent handle time. In standardizing documentation, provided capability to identify customer-facing issues in designated time periods on particular nodes and lines, thereby proactively solving issues to provide a seamless customer experience. Environment: ERwin 4.x, Oracle 9/10g, Microsoft Project. Captured 12 consecutive Top Performer awards (top 5%) and Employee of the Month honors. Garnered a series of promotions to high-visibility roles.

Show More Show Less