Sharon Storm

FireHorse, Inc.

5190 Neil Road, Suite 430, Reno, NV 89502

Vmail 888.376.5552

http://www.firehorse-inc.com

firehorse@consultant.com

Consultant:

Sharon Storm

Skillset:

Data Warehouse Analyst/Data Architect


SKILL HIGHLIGHTS

Systems:

Abend-Aid, Access Manager, AIX, BAPI, CA-EZTE, CA-Librarian, CA-Utilities, CA-VOLLE, CANDE, CBD, CMS, Cognos Connection, Cognos Tools, Cognos Utilities, Cognos Web Server, Configuration Manager, DOS 6.2, DOS/JCL, DOS/VSE, DSS, DTF, EAI (Enterprise Application Integration), EDI, Editor, Endevor, Expression Editor, File-Aid, FTP, GLOS, GuardIEn, ICCF, IDMS Utilities, Impact Analysis Tool, Infopac, Internet Explorer, Intertest, IOF, Lantastic, MetaCensus, Metrics Manager, MQ Series, MVS/ESA, MVS/JCL, Netscape, OLFU, OnBase, On-Demand Host, OOD, OOP, OLAP, OLTP, OS/2, OS/370, OS/390, OS/400, OS/JCL, OS/MVS, Panvalet, Platinum Metadata Repository, Portfolio, PREDICT, QA/QC testing, Rational Utilities, ROSCOE, SAR, SCHD, Scheduler, Script Editor, SMS, SPOC, Syncsort, Teradata Utilities, Test Case Recorder, Test Harness, Transaction Explorer, TSO:ISPF/PDF, UNIX, UNIX Scripting (Bourne, C, Korn Shell), UpFront, VBEditor, VM, VMS, VSAMUTIL, Windows 3.1/95/98/2000, Windows CE, Windows NT Server, Windows XP, Xchange, Xpediter, z/OS.

Languages:

Ab Initio, ABAP/4, Activex, Actuate, Ada, ADSO, Advantage GEN, APS, Architect, ASP, AutoCAD, BASIC, BMS, Brio, Business Objects, C/C++, CICS, Cognos Business Intelligence Suite, Cognos Query, Cognos Visualizer, CLIST, COBOL I/II/III, COBOL/370, COBOL/400, Cognos, CONSTRUCT, Cool:Gen, Crystal Reports, Data Manager, Datastage, DecisionStream, Delphi, DL/I, DTS, DYL-280 II, Easytrieve Plus, ERWin, Excel, Focus, FORTRAN, 4Thought, Frameworks Manager, HTML, Hyperion Essbase, IDEAL, IEF, Impromptu, Impromptu Web Reports (IWR), Informatica, NQuire, Java, Lotus Notes, MapInfo, MathCAD, MicroFocus Cobol, MS Office, MS Project, Microstrategy, Natural/Natural 2, Omni/SQL, Oracle Designer, Oracle Forms, Oracle Reports, Oracle Warehouse Builder, PASCAL, Perl, PL/1, PL/SQL, PowerBuilder, PowerConnect, PowerHouse, PowerPlay, PowerPlay Web (PPW), PowerPoint, PowerPrompts, Process Designer, QBE, QMF, Query Studio, Queryman, QUIKJOB, Report Studio, ReportNET, REXX, RPG III/IV, SAPScript, SAS (BASE), SAS/Connect, SAS/GRAPH, SAS Macro, SAS/SQL, SAS/STAT, Scenario, SCOBOL, SPUFI, SQL, SQL Assistant, SQL*Plus, Teradata Administrator, TOAD, Transact SQL, Transformer, Visual Basic, VB.NET, VBA, Visio, Visualizer, Visual Studio.NET, WebFOCUS, Websphere, XML.

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, IDMS, IMS DB/DC, MySQL, Oracle, SQL Server, SYBASE, Teradata, Total/TOTL, VSAM.

Education:

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

Certifications:

Cognos Framework Manager
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:

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:

Experience:

FireHorse Inc. Multiple locations 2009 to Present
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
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.

Dell, Austin, TX 2008
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.

YRCW, Chicago, IL 2007
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, source-to-target mapping, materialization/implementation, and the transitional processes.

ViPS Inc. for CMS, Woodlawn/Windsor Mill, MD 2006-2007
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.

Sumaria Systems Inc. for USTRANSCOM, Scott AFB O'Fallon, IL 2004-2005
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.

Blue Cross Blue Shield of Texas, Richardson, TX 2003-2004
Developed the Decision Support Services (DSS) for the statistical control/actuarial efforts. Analyzed the membership and claims to support pricing determinations. Handled requests in this area by internal and external customers. Areas requiring further study were identified and presented to the actuaries. Developed and administered catalogs, cubes, on-demand and scheduled reports, user classes, and security.

Travelers Insurance, Hartford, CT 2003
Participated in the Personal Lines redesign and expansion project. Modeled and developed a more universal interface appropriate for different states, countries, and assorted regulatory levels. Modeled and designed mainframe, server, and web applications (n-tier). Involved in the development of data translation, transformation, and transport layers.

National Life of VT, Montpelier, VT 2000-2002
Participated in the Commission Statement Redesign (CSD) project. Created a modular, flexible reporting system to provide customized statements with different levels and commission structures for the many companies under National Life's corporate umbrella. Extracted the business rules for the varied organizations. Developed the interface to connect/extract data from the LIDP/AMS system and the GEAC/Payroll system for commission reporting. Modeled the relationships and the flow of data within the organization.

UCLA Medical Center, Sylmar, CA 2000
Accepted the Aftercare OB/GYN project on a fixed-bid basis. Designed and developed Aftercare in Oracle. Performed the business operations, workflow, optimization, and needs analysis. Performed the data analysis, modeling, and mapping using Designer and Developer 2000, as well as Platinum ERWin. Integrated data from Access prototypes and hard-copy patient records. Designed aftercare to be scalable and expandable (breadth and depth). Identified issues to be resolved in future modules and scope expansions. Built the interface to Oracle Financials.

BAX Global, Irvine, CA 1998-2000
Led the migration from mainframe to Oracle Financials. Customized the oracle tables to meet BAX's needs. Extracted the business rules from existing applications and translated them for Oracle. Applied the masking, editing, and constraints. Set up the alarms and the user prompts. Normalized and improved data quality controls of the accounts receivable (AR) and MSA accounting systems before extracting, transferring, and loading the oracle tables using SQL Loader. Designed custom reports and forms to add functionality to the oracle financials implementation.

Sharp Manufacturing Corporation of America, Memphis, TN 1998
Participated in the legacy to SAP R/3 implementation. Provided a blend of functional and technical analysis (80-20) for the SAP R/3 implementation (Oracle as the RDBMS). Customized and configured the installed modules. Developed the database management and mining. Performed the data analysis and mapping; database normalization and clean-up; data extraction, transfer, and loading (ETL). Technical responsibilities included the platform and database migration, data conversion; prototyping and modeling; and data warehousing on the Oracle and non-oracle systems. Functional responsibilities included impact analysis and change/co-existence management; process alignment with the post-implementation system; gap analysis and enterprise application integration. Designed and added the open account system of reconciling transfers between the subsidiary and the parent corporation.

LabCorp, Burlington, NC 1997-1998
Participated in the merging of National Health Laboratories and La-Roche business into the existing LabCorp systems. Enhanced the HMO eligibility system in order to reduce the redundancy of data and efforts, centralize eligibility processing, produce more timely and accurate billing, lower processing costs, and raise client satisfaction levels.

Blue Cross Blue Shield of South Carolina, Columbia, SC 1997
Participated in the blending of IT streams to handle data processing for other Blue Cross Blue Shield organizations. Identified changes needed to comply with HIPAA regulations. Identified core issues in the system integration for expanded business area, and the database migration from TOTL to DB2 (and IMS to Oracle). Performed impact analysis and data-mapping. This led to smoother transitions and pro-active enhancements.

Burbank Housing Authority, Burbank, CA 1994-1997
Provided consulting services on a fixed-bid and fixed-rate basis on multiple, concurrent projects. Designed an integrated database system for the Burbank Housing Authority. This resulted in better tracking of participants at every level of the program, better reporting, the detection of fraud, and lower penalties imposed by US Department of Housing and Urban Development (HUD).

Burbank-Glendale-Pasadena Emergency Response System, CA 1993-1997
Participated in the collaboration of efforts involving local, state, and federal agencies, to provide a comprehensive emergency response system. Migrated data from various platforms; enforced referential integrity and normalization; implemented federal and county regulations, and integrated the data from several jurisdictions into the existing Geographic Information System (GIS). This led to more timely emergency response efforts and greater safety for emergency workers. Performed the data analysis and mapping. Designed and developed the hazmat tracking and permit system. Performed the data extraction, transfer, and loading from multiple sources on different database systems into oracle. Used Oracle for UNIX for the graphical mapping and oracle for the mainframe (MVS) for the data warehousing using embedded Oracle PL/SQL.


Valid XHTML 1.0 Strict

Valid CSS!

Member number: 9680 Additional Contact information is available on the Information Page. Software Contractors' Guild (www.scguild.com) Copyright(c) 1995 - 2014 Sharon Storm, FireHorse Inc., and Software Contractors' Guild, Post Office Box 257,Nottingham, NH USA 03290-0257