SKILL HIGHLIGHTS

Systems:

ERP/CRM: GEAC, 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: Access, Adabas, Datacom, DB/2, DB2/UDB, DBase III /IV, DMS, Focus, Hadoop, IDMS, IMS DB/DC, MySQL, Netezza by PureData, Oracle, SQL Server, SYBASE, Teradata, Total/TOTL, VSAM.

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.

Summary of Experience:

• Data Warehouse Analyst/Data 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 Configuration Management CM and the adoption/creation of enterprise-wise IT and process standards Best Practices
• Encouraging and leading Data Governance DG and Data Stewardship efforts
• Led 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
• Analyzing and developing complex database designs, data models, and relationship modeling
• Modeling processes, work-flows, and structures
• Designing documentation deliverables including: process models, process decomposition diagrams, network architecture diagrams, data models, data flow diagrams, entity-relationship diagrams ERD
• Rationalizing existing systems and procedures to correct deficiencies and maintain more effective data handling, conversion, input/output requirements, and storage
• Reviewing and assessing existing data processing methods and techniques
• 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.
• 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
• Performing database performance tuning and re-organizations
• Performing optimization analysis
• Analyzing procedures and problems to refine data and convert to programmable form to increase efficiency
• Working with managers and users to develop business requirements and to analyze/model current and proposed business process flows
• Working with the development teams, system analysts to ensure optimal normalization and maintain and change the logical database structure
• Administering databases and ensuring the recoverability of database structures
• Eliminating data redundancy and providing single sources of data while maintaining an enterprise-wide perspective
• 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

Data Warehouse Analyst

Confidential

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.

Confidential

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.

Confidential

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.

Confidential

Participated in the EDW-ADM team. Involved in the Human Resources Business Information HRBI data mart project. Reviewed the project specifications for a Microstrategy front-end, Teradata back-end using SAP R/3 HR data extracted via Informatica. Areas requiring further analysis were identified for build-out. Participated in implementing the transformational and semantic data models. Assisted in the performance tuning the ECTL process. Anticipated benefits include better reporting, cost control, and planning/budgetary efforts.

Confidential

Participated in the Dell Financial Services DFS data integration effort. Developed the conceptual, key-based, logical, physical, and semantic data models. Reviewed Teradata-supplied ELDMs for Manufacturing, Finance, and Retail for applicability. Applied data harmonization, data integration, and data rationalization efforts on organic, poorly-documented data sources. Involved in business rule extraction and semantic reconciliation efforts to further Master Reference Data Management. Involved in the data governance/data stewardship efforts. Integrated efforts of offshore resources.

Confidential

Participated in the National Path Data Program an effort blend the systems of the various merged and acquired companies under the corporate umbrella into a best-of-breed SOA.

Developed the Enterprise Logical Data Model ELDM . Provided thought leadership regarding Active Data Warehousing, Enterprise Data Warehousing, Integrated Data Repository, Integrated Data Stores/Operational Data Stores. Involved in the consolidations and build-outs,

Confidential

Participated in the Drug Data Processing System/Integrated Data Repository Drug Benefit Calculator DDPS/IDR DBC for Centers for Medicare Medicaid Services CMS Medicare Part D Prescription Drug Program. Led the ETL/BI Reporting Team. Handled project planning and priority management.

Confidential

Led the TRANSCOM Financial Management System TFMS project for USTRANSCOM. Designed and built the TFMS data warehouse in Teradata. Built consolidated financial reporting of TRANSCOM Working Capital Funds TWCF among the transportation component commands TCC's : Air Force Air Material Command, Army Surface Deployment and Distribution Command, and Navy Military Sealift Command. Developed the web-based decision support system DSS for USTRANSCOM. Designed the data transport layer connecting TCC-specific Oracle Federal Financials implementations, assorted legacy systems, and a centralized Teradata Data Warehouse with a WebFOCUS front-end.