FireHorse, Inc.

**** ******* ***** ***** *** Reno NV 89502

760-***-****

http://www.firehorse-inc.com ad4pga@r.postjobfree.com

Consultant: Sharon Storm

Skillset: Data Warehouse Analyst/Data Architect

SKILL HIGHLIGHTS

ERP/CRM: GEAC Millennium Series, Lawson, MSA Accounting, Oracle Financials (AP, AR, FA, FV, GL, HR, PA, PER, PO, RA), PeopleSoft, SAP R/3 (Basis, MM, FI, CO, SD, HR, BW).

Databases/Stores: Access, Adabas, Amazon Web Services (AWS), Azure, Datacom, DB/2, DB2/UDB, DBase III+/IV, DMS, Focus, Google Cloud Platform (GCP), Hadoop, IDMS, IMS DB/DC, MongoDB, MySQL, Netezza by PureData, Oracle, PostgreSQL, SAP HANA, SQL Server, SYBASE, Teradata, Total/TOTL, Vertica, VSAM.

Education: Bachelor of Science in Business Administration from California State University, Los Angeles, CA.

Certification: Cognos Framework Manager, Project Management Professional, Teradata Certified Professional, Teradata Certified Implementation Specialist, Teradata Certified SQL Specialist, Advanced Teradata Certified Professional, Teradata Certified Administrator, Teradata Certified Design Architect, Teradata Certified Application Developer, Teradata Certified Master,

Affiliations: Association of Certified Internet Business Consultants, World Wide Web Chamber of Commerce, Project Management Institute (PMI), PRO-Net/Tech-Net, Women in Technology International (WITI), Software Contractors’ Guild, Programmers Guild, Guru.com.

SBA Certifications: Minority Business Enterprise, Woman-Owned Business

Summary of Experience: Teradata Warehouse Analyst/Teradata Architect with over 20 years of proven experience in Management Information Systems (MIS). Background in finding enterprise solutions for midsize to large corporations. Led teams ranging in size from 2 - 40 FTE and contract members. Handled migrations from mainframe to client-server (and vice versa). Earned Bachelor of Science in Business Administration from California State University, Los Angeles, CA.

Sharon Storm has experience in the following industries - aerospace, banking, education, engineering, finance, government, insurance, logistics, manufacturing, medical, pharmaceutical, retail, telecommunications, and transportation. She is knowledgeable in most information processing applications including sales order processing, accounts receivable and billing, inventory, purchasing and accounts payable, sales analysis and forecasting, general ledger, hospital patient inventory and registration, material management, payroll and personnel, predictive modeling, marketing and public relations.

Some of the functions she has performed include:

●Developing and implementing Activity-Based Costing (ABC), Active Data Warehousing (ADW), Enterprise Data Warehousing (EDW), Enterprise Data Architecture (EDA), Enterprise Data Management (EDM), Data Warehouses (DW), Data Marts (DM), Decision Support Systems (DSS), Executive Information Systems (EIS) including dash-boarding, Integrated Data Repositories (IDR), Integrated Data Stores (IDS), Operational Data Stores (ODS), and Application Data Stores (ADS)

●Developing and maintaining enterprise-wide data models, Extended Logical Data Models (ELDM), Logical Data Models (LDM), Physical Data Models (PDM), Key-Based Data Models (KBDM), Canonical Data Model (CDM) and Transactional Data Models (TDM)

●Developing and maintaining the Metadata Repository and data dictionary, and supporting Enterprise Data Management (EDM, Master/Reference Data Management (MDM) and Product Information Management (PIM) efforts

●Rapid development, proof of feasibility/functionality and relative time/resource cost, and evaluation of Proof-of-Concept projects.

●Encouraging and leading Data Governance (DG) and Data Stewardship efforts

●Encouraging and leading Configuration Management (CM) and the adoption/creation of enterprise-wise IT and process standards (Best Practices)

●Leading Customer Data Integration (CDI), Customer Resource Management (CRM), Enterprise Resource Product (ERP), Supply Chain Management (SCM), and Business Process Re-engineering (BPR)/Business Engineering (BE) efforts.

●Building consensus and leading data integration, semantic reconciliation, and data harmonization efforts

●Discussing the pros, cons, and overlaps in the Ralph Kimball vs. Bill Inmon approaches, normalizations vs. de-normalization, 3NF vs. DNF (star schema or snowflake schema), top-down vs. bottom-up approaches, abstraction vs. specificity; and the hybridizations that allow for flexibility while improving performance (views, join indexes, aggregate join indexes, functions, macros, stored procedures, global volatile temporary aggregate tables, materialized views, etc.)

●Reviewing and assessing existing data processing methods and techniques

●Rationalizing existing systems and procedures to correct deficiencies and maintain more effective data handling, conversion, input/output requirements, and storage

●Designing documentation deliverables including: process models, process decomposition diagrams, network architecture diagrams, data models, data flow diagrams, entity-relationship diagrams (ERD)

●Modeling processes, work-flows, and structures

●Analyzing and developing complex database designs, data models, and relationship modeling

●Depicting the flow of data within and between technology systems and business functions/operations

●Identifying and resolving information flow and content issues

●Transforming business requirements into logical and physical data models; and transforming logical data models into physical-ized, versioned or instanced data structures

●Eliminating data redundancy and providing single sources of data while maintaining an enterprise-wide perspective

●Administering databases and ensuring the recoverability of database structures

●Working with the development teams, system analysts to ensure optimal normalization and maintain and change the logical database structure

●Working with managers and users to develop business requirements and to analyze/model current and proposed business process flows

●Analyzing procedures and problems to refine data and convert to programmable form to increase efficiency

●Performing optimization analysis

●Performing database performance tuning and re-organizations

●Developing documentation of database information, methods, procedures, tasks, and standards.

●Compliance with CMMI/Six Sigma standards.

●Critical thinking, information synthesis, priority management, and project planning and control.

Experience

- Boeing/TCS Bellevue, WA 2021 - Present

Involved in expanding and optimizing the Boeing Analytical Data Warehouse (BADW). Provided data architecture and subject matter expertise. Expanded the scope to incorporate Fleet, Boeing Global Support Lifecycle (BGS Lifecycle) Data, and other Boeing safety projects ie. Enterprise Health & Safety Warehouse (EHSW), Aircraft Reliability & Maintenance Systems (ARMS) Investigated process and data anomalies. Clarified meaning and built consensus among project stakeholders. Skill used: Azure, Databricks, Embarcadero ER/Studio, Google Cloud Platform (GCP), Hadoop, Oracle, SQL Assistant, SQL Server, Teradata 17, Teradata QueryGrid, Teradata Studio, TFS.

- FireHorse Inc. Multiple locations 2020-Present

Short-term internal and external projects. Skill refresh and refocus on soft skills - master reference data management (MDM); Product Information Management for Marketing (PIM), data rationalization, data quality management (DQM), and data curation; conceptual data modeling and canonical models; and marketing data science, implementation, and version upgrades, on Premise to cloud migrations. Provided Teradata subject matter expertise regarding scalable architecture, data blending, and performance optimization. Skills used: Alation, Atlassian Jira, Collibra, DB2, ER/Studio, Oracle, SQL Assistant, SQL Server, Snowflake, Teradata 16.20, Teams.

- Sony Pictures Entertainment/TCS Culver City, CA 2019

Involved in the Financial Projection System project. Provided Teradata architecture and subject matter expertise. Migrated the data and processes (functions, macros, materialized views, stored procedures, triggers, etc.) from the SQL Server 2014/2016 platform to Teradata 16.20. Defined and applied data warehousing standards. Resolved process and data anomalies with the Alteryx, Node.js, and Tableau integrations. Skills used: Atlassian Jira, CA ERWin, SQL Assistant, SQL Server, Teradata 16.20, Teams.

- Boeing/Infosys Bellevue, WA 2018 – 2019

Involved in expanding and optimizing the Boeing Enterprise Data Warehouse (BEDW). Provided data architecture and subject matter expertise. Expanded the scope to incorporate 2CHR, Maximo, and other Boeing projects. Investigated process and data anomalies. Clarified meaning and built consensus among project stakeholders. Skill used: Autosys, Embarcadero ER/Studio, Hadoop, Oracle, SQL Assistant, SQL Server, Teradata 16.20, Teradata QueryGrid, TFS.

- GameStop Grapevine, TX 2017-2018

Involved in expanding and optimizing the Customer Data Warehouse (CDW). Provided data engineering and subject matter expertise. Expanded the scope to incorporate ThinkGeek, Tech Brands, and other GameStop organizations. Enhanced customer marketing segmentation, universal cross band view of customer data. Investigated process and data anomalies, Product Information Management (PIM). Gathered and organized metadata. Presented performance optimization recommendations. Inventoried systems with customer PII/PCI for tokenization/detokenization of data-in-motion and data-at-rest via Protegrity. Skills used: Alation Collaborative Data Catalog, Atlassian JIRA, CA ERWin, DBeaver, MySQL, Power BI, Protegrity, SnapLogic, SQL Server 16, SSMS, SQL Assistant, Tableau, Teradata 15.10/16 in the cloud, Teradata Administrator, Teradata Studio, Teradata Viewpoint, Vertica.

- Office Depot, Inc. Boca Raton, FL 2016-2017

Involved in the Inventory Accounting Data Mart. Provided senior data warehouse resource and RDBMS subject matter expertise. Solicited information for Knowledge Management. Clarified meaning and built consensus among project stakeholders. Standardized, streamlined, and documented processes. Worked to simplify lesser-developed processes for consignments and drop-shipping. Involved in data and process rationalization; and process governance. Involved in empowering the accounting team to research issues. Gathered and organized metadata. Investigated process and data anomalies. Presented recommendations. Skills used: DB2, Essbase, Oracle EBS, Oracle, SQL Server, Cognos, SQL Assistant, SAP Business Objects, SAP r/3, SmartView, Teradata 14/15, Visual Explorer.

- T-Mobile/CapGemini Bellevue, WA 2015-2016

Worked with the CapGemini Integrated Data Warehouse team to provide solutions for enterprise integration efforts. Provided senior data warehouse resource and Teradata subject matter expertise. Built out the cLDM (Teradata Communications Logical Data Model). Crowd-developed standards and processes for review and acceptance of deliverables. Worked with project teams consisting of business users and sponsors, business system analysts, system architects, data analysts, ETL developers, BI developers, QA testers, and DBAs to ensure the successful delivery of the projects. Skills Used: Dimensional modeling (DNF), third normal form modeling (3NF), Denodo, Hadoop, Sybase PowerDesigner, Teradata 14/15.

- FireHorse Inc. Multiple locations 2013-2015

Developed the IRR Decision Support System v3.0 (Bear Market version) for the analysis of financial instruments and derivatives. Areas requiring further study were identified and appropriate enhancements were pursued. Skills used: Excel, Hadoop, MS Access, MS SQL Server, Netezza by PureData, Oracle, PL/SQL, SAS, SQL, SQL Assistant, SSIS, Teradata, Teradata Administrator, Teradata add-ons (Teradata Decision Experts [TDE], Teradata Value Analyzer [TVA], Performance Data Collection Recommendations [PDCR]), Teradata Utilities (BTEQ, MLOAD, TPT, etc.), UNIX.

- T-Mobile/Teradata Bellevue, WA 2011-2012

Worked with the Information Management Architecture/Enterprise Systems Business Intelligence (EIT ES BI Architecture) team to provide solutions for several organization-wide projects such as divestiture. Provided senior data warehouse resource and Teradata subject matter expertise. Built out the cLDM (Teradata Communications Logical Data Model). Designed logical data models, Teradata and Oracle physical data models, and semantic data models to support SAP Business Objects and SAS business intelligence reporting. Worked with project teams consisting of business users and sponsors, business system analysts, system architects, data analysts, ETL developers, BI developers, QA testers, and DBAs to ensure the successful delivery of the projects. Skills Used: Dimensional modeling (DNF), third normal form modeling (3NF), Embarcadero ER/Studio Data Architect, Informatica, Repository, SAP Business Objects, SAS, SQL Assistant, Teradata 14, Teradata Administrator, Teradata Utilities (BTEQ, FLOAD, MLOAD, OLELOAD, TPUMP, TPT), Viewpoint, WEBI.

- Amgen/ZS Associates Thousand Oaks, CA 2011

Provided Teradata subject matter expertise (SME) for the RDS/ADM (representative marketing activity/compensation reporting system) redesign efforts. The design involved supporting alignment decisions, improving the system refresh rate, supplying management and representative dashboards, and incorporating pharmaceutical data feeds (payer, physician and facility, prescription, and anonymous patient-level data). Handled logical, physical, and semantic data modeling. Provided solution architecture and application DBA support. Worked with offshore development team. Skills Used: Dimensional modeling (DNF), third normal form modeling (3NF), Embarcadero ER/Studio Data Architect, Informatica, Repository, SAP Business Objects, SAS, SQL Assistant, Teradata 12/13.1, Teradata Administrator, Teradata Utilities (BTEQ, FLOAD, MLOAD, OLELOAD, TPUMP, TPT), Viewpoint, WEBI.

- Teradata Corporation Multiple locations 2009-2010

Involved in the Tax Discovery Projects for the states of Arizona (Department of Revenue) and Ohio (Department of Taxation). Developed non-filer, under-reporter, pass-thru entity, and other specialty revenue lead generation programs for state taxing authorities. Participated in the build-outs of the EDWs and the architecture of the ECTL streams. Anticipated benefits include enhanced revenue streams, better reporting, and planning/budgetary efforts. Skills used: Cognos, DB2, MS Access, MS SQL Server, Oracle, PL/SQL, SAS, SQL, SQL Assistant, SSIS, Teradata, Teradata Administrator, Teradata Utilities (BTEQ, MLOAD, TPT, etc.), UNIX.

- United States Postal Service (USPS) Raleigh, NC 2009

- Dell, Austin, TX 2008

- YRCW, Chicago, IL 2007

- ViPS Inc. for CMS, Woodlawn/Windsor Mill, MD 2006-2007

- Sumaria Systems Inc. for USTRANSCOM, Scott AFB O’Fallon, IL 2004-2005

- Blue Cross Blue Shield of Texas, Richardson, TX 2003-2004

- Travelers Insurance, Hartford, CT 2003

- National Life of VT, Montpelier, VT 2000-2002

- UCLA Medical Center, Sylmar, CA 2000

- BAX Global, Irvine, CA 1998-2000

- Sharp Manufacturing Corporation of America, Memphis, TN 1998

- LabCorp, Burlington, NC 1997-1998

- Blue Cross Blue Shield of South Carolina, Columbia, SC 1997

- Community Development Department, Burbank, CA 1997

- City of Burbank Information Systems, Burbank, CA 1996-1997

- Burbank Housing Authority, Burbank, CA 1994-1997

- Burbank-Glendale-Pasadena Emergency Response System, CA 1993-1997

Contact this candidate