**** ******* ***** ***** *** Reno NV 89502
Consultant: Sharon Storm
Skillset: Project Manager/Senior Analyst
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, Datacom, DB/2, DB2/UDB, DBase III+/IV, DMS, Focus, Hadoop, IDMS, IMS DB/DC, MongoDB, MySQL, Netezza by PureData, Oracle, PostgreSQL, 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), 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), and Transactional Data Models (TDM)
Developing and maintaining the Metadata Repository and data dictionary, and supporting Master/Reference Data Management (MDM) efforts
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.
- Sony Pictures Entertainment/TCS Culver City, CA 2019 - Present
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
- 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.
- 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. 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.
- 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.
- T-Mobile/CapGemini Bellevue, WA 2015-2016
Worked with the CapGemini Integrated Data Warehouse team to provide solutions for enterprise integration effort. 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.
- 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.
- 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.
- 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.
- 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.
- United States Postal Service (USPS) Raleigh, NC 2009
- Dell, Austin, TX 2008
- FireHorse Inc. Multiple locations in the U.S. 2007-2008
- YRCW, Chicago, IL 2007
- ViPS Inc. for CMS, Woodlawn/Windsor Mill, MD 2006-2007
- FireHorse Inc. Multiple locations in the U.S. 2005-2006
- 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
- City Attorney, Burbank, CA 1993-1997
- City Manager, Burbank, CA 1993-1997
- East-West Investments, San Gabriel, CA 1994-1996