Mary G. Knight

**** ******* ***** ******: 336-***-****

Lewisiville, NC 27023 Home: 336-***-****

Email: adzif0@r.postjobfree.com

LinkedIn: www.linkedin.com/in/marygknight

Professional References:

James (Jim) Benscoter – Manager at IBM David Buchman – CoWorker at IBM

Mobile: 607-***-**** Mobile: 845-***-****

Email: adzif0@r.postjobfree.com Email: adzif0@r.postjobfree.com

Education:

M.B.A., Embry-Riddle Aeronautical University Major: Bus Admin GPA: 3.6

B.A.S., Florida Atlantic University Major: Computer Science: GPA: 3.2

Experienced Data Architect in all facets of Data Warehousing and BI Analytics

and Master Data Management including:

Requirements: Gathering, Understanding, GAP Analysis, Solutioning, Data Analysis, SQL, Relational Databases: DB2, SQLSERVER, Teradata, Oracle, Data Modeling : Logical, Physical, Naming Standards, Data Governance, KPIs, ITIL, ETL, BI Analytics with the last several years focused on very large Enterprise IT Transformations including various software(s) such as: Salesforce, CRM, ESB, Mulesoft, Erwin, MDM Master Data Management, IDA, Informatica, Azure Cloud, Data Fabric, ServiceNow, JIRA, SAP/HANA4, Slack, etc.

Certifications:

Agile (JIRA) Bootcamp Training Certificate, ITIL Foundations Certified

Honors-Awards: AmerisourceBergen True Blue Award (For Architected Datamarts)

Specialties: Enterprise Data Architecture, Enterprise Data Models such as IBMs Banking Datawarehouse Model, Data Modeling (Conceptual, Logical, Physical), Star Schema, Snowflake, utilizing Erwin, Data Governance, Data Integration, MDM (Master Data Management), DB2

Work Experience:

IBM - Data Architect

October 2017 – May 2023 (5 years 7 months)

Raleigh, NC

Support of numerous Applications feeding SIW - Services Information

Warehouse with most emphasis on SAP and HANA4 Project/data flowing to

SIW. Involved in updating older ETL processes as well as TESTING to ensure Standards were adhered to. I also supported IBM’s SIW OLAP, Online Analytical Processing. This particular Services Information Warehouse was an operational datastore, fed by MANY different applications. I also helped to manage the SIW Workload by analyzing the requirements and creating the necessary JIRA EPICS/STORIES based on Business Requirements.

AmerisourceBergen (Pharmaceutical) Corporation - Data Architect

December 2011 - August 2017 (5 years 9 months)

Charlotte, North Carolina Area

Data Architect Lead supporting multiple projects and initiatives.

Last project was focused on architecting w/Erwin, the Business’s Enterprise Conceptual, Logical and Physical Data Models and also working with the ETL and Informatica Teams to start implementing Master Data Management, which started with the ‘Business Partners’ Domain, which included attributes such as: NAICS, SICS, D&B, etc. Involved in various aspects such as: Application Inventory, Data Profiling, Golden Records, etc. Also participated in the creation and meetings of their Data Governance Council which identified and met with Business SME’s.

I also architected for Amerisource Bergen their “Orders Datamart” that was structured to support OLTP transactions. Datamarts with Facts and Dims are architected with appropriate partitioning and indexing to support huge transactional volumes. Datamarts are by definition, OLTP based.

I also architected for AmerisourceBergen their “Clinical Trials” Datamart, for this Clinical Trials project, I received AmerisourceBergen’s “Blue Award”.

Additional Education & Training:

ITIL Foundation Training & Certification.

ITIL Service Owner Training.

AGILE (JIRA) Bootcamp.

SalesForce Trailheads

FCIB - First Carribean International Bank – Data Architect

July 2011 - December 2011 (6 months)

Barbados

Consultant helping to guide implementation of IBM’s BDW- Banking Data Warehouse Model.

Data Integration Analysis in support of MDM. SSIS tool suite, Data

Stage, SQL Server, etc.

First Tennessee Bank – Data Architect

January 2011 - June 2011 (6 months)

Memphis, Tennessee

Utilized ERwin in support of IBM BDW Model on Oracle database. Helped in

design of Distribution Infrastructure, as well as data analysis required for MDM

implementation.

Bank of America - Data Architect

August 2007 - December 2010 (3 years 5 months)

Data Architect supporting implementation of BDW – Banking Data Warehouse Project as well as many other Banking related warehouse applications. Erwin, Teradata, IBM BDW, Repository, Business Glossary, etc. Supported the Banks Team of 50 Data Modelers to ensure Erwin was regularly upgraded/maintained, etc.

RJ Reynolds – DBA/Data Admin Lead

November 1997 - April 2007 (9 years 6 months)

Winston-Salem, NC

Installed and supported the new Erwin Data Modeling Software as well as

Acting as Lead Architect with a team of folks to create RJReynold’s first Datawarehouse, very successful, all architected using Erwin Data modeling software.

USAirways - DBA

June 1996 - November 1997 (1 year 6 months)

Winston-Salem, NC

Oncall DBA with regard to all Databases: ADABAS, DB2, CICS, IMS.

Palm Beach County School Board - Systems Technical Support

September 1993 - June 1996 (2 years 10 months)

Palm Beach County, Florida

Responsible for new software installations and upgrades, including ADABAS and Natural.

Pratt & Whitney - Senior Systems Programmer

December 1983 - September 1993 (9 years 10 months)

Responsible for various Software installations, upgrades and technical support.

Implemented DB2 DRDA, ISPF/PDF, NATURAL, CA-DISPATCH, GDDM, GDQF, etc.

Contact this candidate