Data Architect

Mary G. Knight

Mobile: 336-***-**** Location: Lewisville, NC

Email: **************@*****.*** LinkedIn: www.linkedin.com/in/marygknight

Professional References:

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

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

Email: *************@**.***.*** Email: ********@*****.***

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 who has spent several years working with large Fortune 100 Companies who have invested in transforming their Enterprise IT Infrastructure(s) with new Methodologies, Software(s) and Processes such as : ITIL, Informatica, Master Data Management (MDM), SALESFORCE, SERVICENOW, Enterprise Data Modeling, AGILE/JIRA, DEVOPS PIPELINES, CLOUD Platforms (AWS, AZURE, GOOGLE) by working with the Business and the Technical Teams to document these various Projects, Business Requirements, Gap Analysis, Technical Solution(s) via JIRA EPICs and Stories to be delivered.

Specialties: Enterprise Data Architectures including Enterprise Data Models such as IBMs BDW Model, Data Modeling – Conceptual, Logical, Physical, Data Governance, Data Integration, MDM (Master Data Management), SQL, Data Modeling, Performance Tuning, BI/Analytics etc.

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

Additional Training & Certifications :

ITIL Foundations Training & Certification

ITIL Product/Service Owner Training & Certification

AGILE (JIRA) Bootcamp & Certification

SalesForce Trailheads Training & Certification

Snowflake Cloud Training & Certification

Work Experience:

EMPLOY – Enterprise Warehouse Data Architect

October 2023 – October 2024 (1 year, 1 month)

Denver, CO – REMOTE

Worked on major project to consolidate multiple Salesforce Application Instances into one Salesforce Instance for sourcing into the Enterprise Data Warehouse for Reporting Purposes.

Worked to architect and support the various SNOWFLAKE STAR SCHEMAs existing and new within this Snowflake Warehouse. Worked to simplify and streamline SNOWFLAKES Security Architecture and securing of sensitive/PI data.

Worked with Informatica to support Data profiling, ETL work, Data Governance and Data Dictionary.

Utilized various software packages such as: Salesforce, Fivetran, Informatica, Data Architect, SNOWFLAKE, Tableau, JIRA and GITHUB.

IBM – Enterprise Data Architect

October 2017 – May 2023 (5 years 7 months)

Raleigh, NC - REMOTE

Support of numerous Applications feeding SIW - Services Information

Warehouse with most emphasis on SAP and HANA4 Project.

Supporting the data strategy and road map for implementation of critical on-premise and cloud applications with single tenancy, common tenancy & multi-tenancy, master data management (person, location, activities) and Business Intelligence enterprise reporting projects with an outstanding record of scheduling project activities for myself and the team to deliver projects on time and within budget.

Modernized ETL processes. Provided TESTING to ensure adherence to Standards. Managed Teams workload by creating/defining JIRA Epics/Stories based on Business Requirements.

AmerisourceBergen (Pharmaceutical) Corporation – Enterprise Data Architect

December 2011 - August 2017 (5 years 9 months)

Charlotte, North Carolina Area

Warehouse 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 team and Informatica Team 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 developmental 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 regularly with Business SME’s.

I also architected for Amerisource Bergen their “Orders Datamart” and “Clinical Trials Datamart, for which I received Amerisource Bergen’s “Blue Award”. These datamarts were structured to support OLTP transactions. Datamarts with Facts and Dims, architected with appropriate partitioning and indexing to support huge transactional volumes.

FCIB - First Carribean International Bank – Data Architect

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.

Contact this candidate