|
|
Data Analysis
Planned Parenthood Federation of America
• Championed and reviewed effort to document business rules and processes populating source data environment. Articulated acceptance criteria. Deliverables included documentation resolving discrepancies between schema definitions and data values.
• Championed and reviewed effort to document data flows within data warehouse environment. Articulated acceptance criteria. Deliverables included set of leveled data flow diagrams for undocumented application consisting of 300+ Microsoft Access database files.
• Analyzed demographic, expenditure, and revenue data across enterprise to understand cost of services rendered to customer segments and revenue derivation.
• Championed and reviewed effort to profile 9 source data systems. Articulated acceptance criteria. Deliverables included documentation describing overloaded attributes and entities in source systems. Source platforms included Oracle, DB2, SQL Server, Microsoft Access, and Microsoft FoxPro.
• Reviewed conceptual and logical data models for completeness, consistency, accuracy, and fitness for use. Identified missing entities and relationships.
• Reverse-engineered data source systems to obtain data definition language for entities, attributes, and relationships.
• Identified and interviewed subject matter experts and data stewards to validate data dictionary definitions.
Blue Shield of California
• Analyzed demographic and revenue data across enterprise.
• Reviewed Business Objects universes (schema, facts, and measures) for conformance to business requirements.
• Reverse-engineered data flows (leveled DFDs) of extraction processes feeding 14 terabyte data warehouse environment. Source system environments included Oracle, DB2, Sybase, SQL Server, Microsoft Access, Microsoft FoxPro, and Microsoft Excel.
• Collected, documented, and published technical/business metadata (data dictionary).
• Created, published, and maintained enterprise-wide data management standards, methods, procedures, and best practices (including HIPAA).
AT&T
• Analyzed data from disparate sources and their relationship to business processes to ensure completeness, consistency, and accuracy of data warehouse. Source environments included Oracle, DB2, SAP, Peoplesoft, SQL Server, and Microsoft Access.
• Created gap analysis to demonstrate overlap between source and target fields and among 3 source system fields.
Charles Schwab & Co.
• Performed activity-based costing analysis of fundamental operating expenses--including personnel, capital, and leased expenditure items--and reported results to other company areas.
• Assisted in developing, managing, and monitoring $12 million quarterly budget at divisional level.
|
|
|
|