SUMMARY:

• Data architecture artifacts, standards & compliance
• Project and Program Management for large scale BI Platforms
• Master Data Management/Data Governance Framework and Program implementation
• Reference Data Management Change Management Process Implementation
• Business Conceptual and Logical Modeling
• Physical Relational and Multidimensional Database Modeling
• Metadata Management and Program Management implementation
• Business Intelligence & Analytics System Design
• Design of complex dimensional models for data marts and data warehouses in Teradata and SQL Server.
• Design of analytic, calculation and attribute views in SAP HANA to provide data attributes to SAP ADT for marketing segmentation purposes.
• 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.
• Software Development Methodologies
• Agile, Kanban, Scrum, Waterfall, Iterative
• Program Management, Project Management and Business Analysis
• 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

TECHNICAL SKILLS:

Microsoft: SQL Server 2000 - 2012, Visual Studio 2012, SQL Server Reporting Services, SQL Server Integration Services, SQL Server Analysis Services, Team Foundation Server, PowerBI, PowerPivot

Teradata: Teradata SQL Analyzer, Teradata Administrator

Oracle: Siebel UCM, Oracle 11.i, Oracle SQL*Plus, SQL Navigator

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

IBM: IBM DB2 for I, SEQUEL Viewpoint, Infor M3

Other: SAS Marketing Analytics, Infor Epiphany, Aginity Workbench for Redshift, Redshift, AWS, Hadoop

PROFESSIONAL EXPERIENCE:

Confidential, Seattle, WA

Technical Program Manager

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 utilizing Confluence.
• 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 functional 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

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

Responsibilities:

• Participated in the design and implementation of a new enterprise data warehouse using 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/Master Data Management 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.
• Worked with internal team to gather business reporting requirements using the BUS Matrix methodology.
• 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.
• Created HTML based Business Data Dictionary detailing EDW and SSIS Cube physical design for consumption by business.
• Installed and deployed PowerDesigner to be used by business analysts and developers across the enterprise.

Confidential, Bellevue, WA

CRM Functional Data Analyst

Responsibilities:

• Partnered 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.
• 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.
• Managed requirements and set expectations with business stakeholders and executive management in regards to scope, timeline, level of effort required for each iteration.
• 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.
• Created process to ensure data management best practices are executed and maintained.
• Determined and validated potential data sources including performing data profiling and data analysis activities.
• Worked with IT partners to translate logical data model to physical data model including the definition of Fact and Dimension tables, calculated measures, and data attribute definition within the legacy enterprise data warehouse.
• Worked with IT partners to define and support build of semantic views within the Teradata marketing data mart to supply data to legacy marketing systems SAS-MA and Epiphany.
• Led, mentored and trained a team of 10 Functional and System analysts.

Confidential, Seattle, WA

Responsibilities:

• Created and maintained 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.
• Assisted the Data Governance Manager in establishing and executing the newly created Data Governance Program including creation of the Data Governance Roadmap/Framework and served in an advisory capacity for System/Domain scope selection and tool selection process.
• Defined and implemented data quality issue intake for Data Quality/Master Data Management Program.
• Led workshops to educate business in MDM, Data Governance concepts and techniques.
• Led workshops to educate the business in understanding and implementing process changes to establish data quality controls in source systems.
• Established formalized process to communicate to business when timelines, scope or system changes occurred.
• 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 entity including defining the party, subsidiary, person and communication method models.
• Worked with business users to create and document business process flows for customer data throughout order management, sales and customer support systems.
• Assisted with writing test cases, creating test data and performed end to end system testing to establish functionality of MDM solution and perform data validation.
• Performed data profiling activities within each system responsible for providing source data.
• 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:

• Analyzed statistical plans for Commercial Lines and Personal Lines products and recommended reporting solutions for on-going data calls.
• Extracted data from mainframe and database applications (DB 2 platform) and performed data analysis in MS Access/MS Excel to report statistical information to state and local government agencies.
• 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, Confidential selection rates, Confidential 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.
• Manipulated raw data into usable, actionable information for management purposes with high attention to accuracy.
• Created and modified various Crystal reports for use in monthly/quarterly reports.
• Created ad-hoc queries for departmental use in month-end/quarterly reports.
• Served as a resource for specialized data analysis projects to both internal work groups and external clients including employers, healthcare providers, stop loss carriers, business partners.
• Assisted in development of reporting capabilities and report process improvement.

Confidential, Seattle, WA

Provisioning Data Analyst

Responsibilities:

• Responsibilities included ensuring the proper data was entered into the Confidential systems and that the data was complete, accurate and entered in a timely manner to support deployment and maintenance activities of Confidential 's E - 9-1-1 services.
• Provisioned data to support a deployment on internal and external systems.
• Collected, analyzed and quality checked all data related to a deployment or ensured these functions were being performed by appropriate resources on the deployment team.
• Coordinated with deployment managers, implementation specialists and wireless engineers to obtain data and ensure entry into Confidential systems.
• Maintained a thorough understanding of the deployment data process and requirements including understanding the intricacies and impacts of each carrier's data structures and requirements.
• Interacted effectively with appropriate internal and external personnel to resolve issues within area of responsibility and escalated issues in a timely fashion as necessary.
• Produced documentation of current processes and trained new data analyst hire.

Confidential, Seattle, WA

Responsibilities:

• Created SQL scripts in Query Analyzer, macros in Excel and TextPad to produce file specifications and cleaned and manipulated data and loaded data into IMEI Subsidy Unlock database
• Worked with manufacturers to obtain the correct data formats and to acquire missing data and modified database to accommodate a new data format from an existing client.
• Produced documentation of current process and recommended changes to automate and streamline data processing procedures
• Import/export of data using SQL Server Data Transformation Services to clean data and perform ad-hoc analysis of data.

Confidential, Bellevue, WA

Data Analyst

Responsibilities:

• Researched and resolved data problems related to inpatient data stored in Oracle tables using Access GUI interface.
• Worked with external clients, Account Managers, and departments within IT to fix or modify file specifications.
• Analyzed data and produced ad-hoc reports for external and internal customers.
• Processed data monthly for 60 Clients, including datasets for 3 Hospital Associations.
• Performed extensive QA of incoming and outgoing data streams.

Confidential, Bellevue, WA

Business Analyst

Responsibilities:

• Researched and resolved data problems related to business system on Oracle platform. Worked with clients, Client Relations Department, and departments within IT to implement client programs.
• Tested software changes for Oracle platform and other business processes including Confidential Excel, Adobe and Confidential Access.
• Analyzed data and produced ad-hoc reports for external and internal customers.
• Performed project management for small and medium-sized projects using Confidential Project and Clearquest software programs.
• 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.

Confidential, Seattle, WA

Data Analyst

Responsibilities:

• Created and administered several databases on Access platform to analyze data using SQL Server.
• Created several templates for use by Case Managers to increase efficiency within the department.
• Created efficiencies in the protocols of the Expecting the Best and Mental Health programs to reduce turnaround times of referrals and increase productivity of both programs.
• Created and produced daily, weekly and monthly reports for all insurance products via Access Database using SQL Server platform.