SUMMARY:

• Data architecture artifacts, standards & compliance
• Product and program management for large scale business intelligence & analytics platforms
• Master data management & data governance framework and program implementation
• Organizational change management
• Business entity conceptual and logical data modeling
• Physical relational and multidimensional database modeling
• Business Data Domains
• Telecommunication Customer, Campaign and Marketing Analytics. Knowledge of most domains including Billing, Customer Management, Sales/Service, and Network Utilization
• Technology - Customer and Product Domain; Full understanding of Customer Lifecycle including Sales, Service and Marketing.
• Health Insurance - Knowledge of most domains including Claims, Mental Health/Chemical Dependency Programs, Inpatient/Outpatient/Primary Care/Specialist Utilization, Disease Management Programs, Regulatory
• Fashion Industry - ERP, Sales, General Ledger
• Manufacturing - Order Management, Sales/Service, Customer Management, general ledger dimensions, AP and AR
• Media Platforms- Linear television, Digital, Cable, Satellite
• Digital and Mobile Environment - Video Player, Apps, Video on Demand subscription
• Television Broadcast Media/Publishing/Digital industry concepts
• Modeling and Business Process Diagramming Tools
• SAP PowerDesigner 16.5, ER Studio Data Architect, Visio
• SQL, Database, Data Quality/MDM, Applications, Analysis, and Reporting Tools

TECHNICAL SKILLS:Microsoft: SQL Server Business Intelligence Stack, Team Foundation Server, PowerBI, PowerPivot

Teradata: Warehouse and Data Marts for Telecom

Oracle: Siebel UCM, Oracle 11.i,

SAP: SAP-CRM 7.0 for CM, SAP HANA, SAP Customer Engagement Intelligence 1.0, SAP Data Quality

IBM: IBM DB2 for I, Infor M3

Other: SAS-MA, Infor Epiphany

EXPERTISE AREA:

• Full understanding of Business Intelligence & Data Warehousing requirements, BI architectures, data modeling, dimensional modeling, data science model concepts in addition to DW/BI application functionality for several different technologies and platforms.
• Understanding of big data technologies such as Redshift, AWS and Hadoop
• Software Development Methodologies
• Agile, Kanban, Scrum, Waterfall, Iterative
• Program Management, Project Management and Business Analysis
• Data Quality/Master Data Management Programs: Includes creating Data Governance Roadmaps and Frameworks, process and change management processes, proof of concept, formal communication process for business/executive leadership and establishing Data Quality/Master Data Management processes
• Conducted workshops to elicit requirements and educate business and IT in MDM, data governance, data profiling, data lineage tracking and data analysis concepts and techniques.
• Produced formal deliverables for business requirements/user stories/business data models, BI/reporting requirements, project schedules, change management/workflow solution designs, functional specifications, proof of concept, and BPMN process models

PROFESSIONAL EXPERIENCE:

Confidential, Mountlake Terrace, WA

Data Governance Lead

Responsibilities:

• Provide leadership and education to others on data governance activities including:
• Assist with data governance communication and change efforts Lead the community of Data Stewards, providing leadership and direction
• Establish and manage Data Stewardship Program across enterprise, including development of training and education of all data governance roles Single point of contact for driving data stewardship and data quality processes forward Liaison with Data Owners, stakeholders and IT to help guide Data Stewards Assist Data Governance in developing and executing governance framework
• Identify, initiate and ensure alignment of data related efforts/initiatives to data governance vision Drive standardization of prioritization criteria for data related efforts/initiatives
• Perform program management activities including:
• Design, document and maintain processes and procedures for Data Stewardship Lead Data Stewardship Council Maintain data governance and stewardship repository of information and decisions Drive overall enterprise data quality and reliability across the enterprise Track, monitor and manage issue resolution / remediation Provide council and guidance to project to ensure project is following data governance standards
• Support Data Governance Committee and Data Governance Board meetings Definition and development of data governance measurements and track monitor and publish data governance scorecards.

Confidential, Seattle, WA

Technical Program Manager- Consumer Intelligence Planning & Integration

Responsibilities:

• Lead agile project management efforts to deliver solutions for the legacy AWS, Redshift and Hadoop based BI platform to deliver advanced analytics & business intelligence capabilities for ad sales, data science and marketing teams utilizing Jira.
• Created an agile project methodology for BI platform related projects to be used across the program.
• Educated and assisted in the initial phases of creating a data governance program for the new BI platform including creation of a data governance program proposal and the creation of a business terms glossary and initial business entity model utilizing PowerDesigner.
• Lead agile ceremonies including backlog grooming, sprint planning, estimation and other agile related tasks.
• Performed all activities to analyze and document existing processes, data attributes and workflows.
• Created business intelligence & data warehousing focused deliverables including creating user stories, developer stories, high level architectural models, conceptual data models, source system models and documents, XML based reversed engineered models and source to target mapping documents within Jira, Confluence and PowerDesigner.
• Worked closely with business stakeholders to translate their business needs into product/feature requirements and coordinated with other technical project managers to consolidate efforts to land common subject areas and business entities into the legacy BI platform.
• Performed project management activities for large scale projects spanning cross-functional teams in separate geographical locations.
• Analyzed and profiled large data sets including data containing PII and stored within in-house sourced and third party applications.
• Worked with marketing, sales, inventory and media asset related data from various media channels, including television, online video, and mobile based technologies.

Confidential, Seattle, WA

Senior Consultant - Master Data Program

Responsibilities:

• Created a solution design proposal to automate and streamline the change management process for obtaining, processing and providing data to downstream systems and collaborated in the development of information governance models.
• Performed analysis and provided reporting via PowerPivot and PowerBI.

Confidential, Seattle, WA

Data Modeler/Data Analyst

Responsibilities:

• Participated as a systems analyst, business analyst and data modeler in the design and implementation of a new enterprise data warehouse using Kanban based agile project management methodology.
• Built initial Data Governance Roadmap/Framework, and defined process, System/Domain scope tool selection process and data quality issue intake for Data Quality/Data Governance Program.
• Conducted supply chain data quality pilot to provide a proof of concept for executive leadership of success of Data Quality/Master Data Management process methodology and led workshops to educate business and IT in MDM, Data Governance, Data Profiling, Data Lineage, and Data Analysis concepts/techniques.
• Established formalized process to communicate to business when timelines, scope or system changes occurred.
• Performed full data profiling and detailed data analysis on proposed sourcing data and systems including M3.
• Analyzed and documented legacy SQL Server stored procedures and SSIS ETL to understand/document current business processes and business rules and created design documents/models for proposed fact and dimension tables and star schema redesign.
• Produced source to target mapping documentation for redesigned fact and dimension tables.
• Reverse engineered the new EDW using PowerDesigner and fully documented the enterprise warehouse including definitions, domain values, relationships, indexes and annotative information.
• Produced a multi-dimensional data model using PowerDesigner for the new SSAS cubes including full documentation of hierarchies, calculated measures, definitions and domain values.
• Established formal naming conventions for logical model attributes and tables. and formal definitions for logical attributes to be used enterprise wide.
• Implemented HTML based business facing data dictionary, IT facing technical data dictionary and business terms glossary.

Confidential, Bellevue, WA

Senior Functional Data Analyst - Converted from Contract to FTE 12/2012

Responsibilities:

• Led, mentored, and trained a team of 10 functional and system analysts.
• Managed program requirements and set expectations with business stakeholders and executive management in regards to scope, timeline, level of effort required for each iteration.
• Collaborated with marketing business units to define functional data requirements that provided system/data functionality for new marketing platform consisting of SAP-CRM, SAP Customer Engagement Intelligence 1.1, and SAP HANA applications.
• Created process to ensure data management best practices are executed and maintained.
• Interviewed business partner end users to gather and define functional, business and data requirements for data attributes and reports to ensure the creation of data attributes for use in customer segmentation/campaign qualification and for business use in creating campaign models, marketing analysis and customer scores.
• Established formalized process to communicate to business when timelines, scope or system changes occurred.
• Translated functional, product, or business requirements into functional / technical specifications, Business and logical data models and use case documents and performed system impact analysis including upstream and downstream impacts.
• Led workshops to educate business and IT in MDM, Data Governance, campaign management, customer analytics and customer segmentation concepts and techniques.
• Performed source system analysis to gain understanding of business rules, transformations, logic and latency that is being applied to the source data.
• Determined and validated potential data sources including performing data profiling and data analysis activities.

Confidential, Seattle, WA

Data Steward II

Responsibilities:

• As the team lead; worked in conjunction with the Data Governance Manager to create and establish F5’s Data Governance Program including creation of the data governance roadmap and Framework
• Participated in System/Domain scope selection and tool selection process.
• Established formal process to communicate to business when timelines, scope or system changes occurred.
• Implemented standards regarding management of customer data in source systems and socialized these standards with the technical and business communities to ensure the validity, accuracy, usability, and integrity of customer entity related data.
• Defined and implemented data quality change management process for Data Quality/Master Data Management Program.
• Led workshops to educate business in MDM, Data Governance concepts and techniques and in implementing change management process establishing data quality controls in source systems.
• Created and maintained data dictionary including transformations, business rules, system/database/application attribute location and domain values across systems for each customer entity-related attribute.
• Established valid domain values for customer related master and reference across source systems and Siebel UCM hub.
• Conducted workshops with the business to create and establish the definition of the customer business entity including defining the party, subsidiary, person and communication method models.
• Documented business process flows for customer data throughout order management, sales and customer support systems.
• Built out testing framework and performed end to end system testing to establish functionality of MDM solution.
• Performed data profiling activities within each system responsible for providing source data and created data quality metrics.
• Created and documented business rules for determining which records could be automatically standardized and cleansed within SAP Data Quality and which records should be held for manual intervention.

Confidential, Seattle, WA

Statistical Reporting Analyst

Responsibilities:

• Demonstrated ability to conduct analysis by gathering existing data, identifying the need for new data methods and sources, identifying and explaining anomalies, evaluating and drawing conclusions from data, and translating data models into clear and meaningful summaries.
• Coordinated with outside government agencies to gather business requirements and ensure the correct data extracts and reports were being produced.
• Ensured accuracy of data and reviewed work to ensure that details make sense within the broader context and was consistent with data that had been previously reported.

Confidential, Columbus, OH

Information Analyst

Responsibilities:

• Created quarterly reports for employer groups to report inpatient/outpatient utilization rates, PCP selection rates, HNA (Health Need Assessment) findings and financial/claims data in conjunction with the clients and internal departments.
• Worked with both internal/external clients to gather business requirements and conduct business interviews during implementation process.
• Assisted in development of reporting capabilities and report process improvement.

Confidential, Seattle, WA

Provisioning Data Analyst

Responsibilities:

• Responsibilities included ensuring the data entered into the TCS systems was complete, accurate and entered in a timely manner to support deployment and maintenance activities of TCS's E - 9-1-1 services.
• Created the data deployment process and gathered requirements including understanding the intricacies and impacts of each carrier's data structures and requirements.
• Produced documentation of current processes and trained new data analyst hires.

Confidential, Seattle, WA

Data Integration Project

Responsibilities:

• Created solution to produce file specifications to load data into IMEI Subsidy Unlock database

Confidential, Bellevue, WA

Data Analyst

Responsibilities:

• Researched and resolved data quality issues related to inpatient and inpatient data stored in Oracle tables using Access GUI interface.

Confidential, Bellevue, WA

Business Analyst

Responsibilities:

• Researched and resolved data problems related to business system on Oracle platform. Worked with internal and external customers to implement client programs.
• Tested software changes for Oracle platform and other business processes including Microsoft Excel, Adobe and Microsoft Access.
• Analyzed data and produced ad-hoc reports for external and internal customers.
• Produced user acceptance/test-case and technical requirements documentation. Conducted user-requirements interviews.
• Developed and tracked project plans throughout the life span of the project.