We provide IT Staff Augmentation Services!

Data Warehouse Analyst/data Architect Resume

2.00/5 (Submit Your Rating)

Boca Raton, FL

SUMMARY:

  • 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).
  • 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.
  • 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.)
  • Data profiling, metadata analysis and documentation, source-to-target mapping, and data lineage and transformation modeling.
  • 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.

TECHNICAL SKILLS:

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, Confidential, Total/TOTL, VSAM.

EXPERIENCE:

Confidential, Boca Raton, FL

Data Warehouse Analyst/Data Architect

Responsibilities:

  • 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.

Confidential, Bellevue, WA

Data Warehouse Analyst/Data Architect

Responsibilities:

  • Worked with the Confidential Integrated Data Warehouse team to provide solutions for enterprise integration effort.
  • Provided senior data warehouse resource and Confidential subject matter expertise.
  • Built out the Confidential .
  • 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.

Confidential

Data Warehouse Analyst/Data Architect

Responsibilities:

  • Developed the Confidential 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.

Confidential, Bellevue, WA

Data Warehouse Analyst/Data Architect

Responsibilities:

  • Worked with the Information Management Architecture/Enterprise Systems Business Intelligence team to provide solutions for several organization-wide projects such as divestiture.
  • Provided senior data warehouse resource and Confidential subject matter expertise. Built out the Confidential Logical Data Model).
  • Designed logical data models, Confidential 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, Thousand Oaks, CA

Data Warehouse Analyst/Data Architect

Responsibilities:

  • Provided Confidential 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, Raleigh, NC

Data Warehouse Analyst/Data Architect

Responsibilities:

  • 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, Confidential back-end using SAP R/3 HR/Peoplesoft 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.

We'd love your feedback!