Data governance, data strategy, data quality, data architecture, data modeling, EDW architecture consulting services.

On contract with Universal Studios. Data architecture team member with primary duties to architect and design solutions to source data into new S3/Snowflake data lake. Primary architecture work products include: entity data models, data lineage models and diagrams, UML activity diagrams, S3/Snowflake job specs, file layout documents (file layouts, source data dictionaries and data profiling analyses, incremental feed analysis), and source-to-target maps. Sources included SQL Server, Oracle, DB2, Rest APIs, micro services. Responsible for documenting data sources in Confluence and reviewing solutions with architecture team, business stakeholders, and development and QA teams. Agile/SCRUM environment using Jira. Actively participated in data architecture community of practice.

> Senior contributor to CCG’s services and methods. This has included: full data governance implementation, RapidDG service, data quality assessment implementation, EDW health check service, full data quality program implementation, and rapid data quality program service.> Regularly participate and lead CCG pursuit and proposal efforts for the delivery organization.> Act as SharePoint Online SME, architect, and developer for the organization.Key consulting areas:> Enterprise data warehouse modeling, architecture and star schema (Kimball) design> Data and analytics governance implementations> Data and analytics strategy> Data quality program implementations> Data quality assessments> Data architecture strategy> Data warehouse health checks and assessments

Application Development Manager, JPMorgan Corporate and Investment Bank, Treasury Services Business Intelligence. Architect, designer, program lead for multi-terabyte Oracle-based star schema data marts. Participated as data warehousing and business intelligence advisor and subject matter expert to data governance council.

Served as business analyst lead for development of standard reporting for a cancer tissue inventory tracking data mart. Liaised with source system and laboratory SMEs to understand storage, inventory, sample preparation, and dissemination, distribution/shipping processes around stored tissue samples. Wrote functional requirements document and report specifications, interfaced with data mart developers on database design, led development and testing of the reports in SQL Server Reporting Services.

From Jan-09 to Aug-09, assigned as Business Analyst and Project Manager for JPMorgan call center technology group. Responsible for managing deployment of certain technology components related to call routing for new call center opening in Manila. Supported defining the technology profiles for call center roles, working across JPMorgan geographies and organizational boundaries to ensure call center desktops where configured with the appropriate versions of approximately 32 applications. In addition, served as the program plan manager across 11 technical, functional, and business project teams, integrating the milestones from all teams into a cohesive set of interdependent milestones. Tracked program progress and status, collected risk and issues across all teams, and coordinated and tracked the testing of all desktop systems in Manila.From Jul-08 to Jan-09, assigned as Business and Data Analyst to an Oracle 9i (star schema) data marts team. Member of KYC data mart team. Developed source-to-target maps from incoming sources to data mart and to Business Objects universe. Worked with business sponsors to define object hierarchy in Business Objects and several standard reports.Provided analysis to reverse-engineer existing billing ETL (little documentation existed) in order to switch to new version of billing system with new source feeds (completely new file formats) to the data mart. This included analyzing Java and PL/SQL code, documenting existing star schemas, developing data flows diagrams, documenting transformations and complex calculations in the existing ETL, documenting new mappings from the transaction code hierarchies into the billing and product hierarchies, and mappings across these hierarchies to convert historical billing data appropriately. Worked closely with developer to devise new front-end to feed into the existing ETL code and processes, making as little change as necessary (due to extreme time constraints places on the team).

Under contract at PricewaterhouseCoopersRequirements and data analysis; Database design and application development at PwC to support workforce planning project.

Under contract at PricewaterhouseCoopersProject Manager for Web-based financial data mart development. Led team of 25+ IT professionals in developing a global financial data mart.

As a principal consultant for PwC Consulting, was development manager in Global Methodology group for four years. Lead development of project data management tools. Senior technical staff responsible for enabling and employing technologies in the global learning infrastructure for the Learning and Professional Development Center for two years.

Managed development, maintenance, and operations of 20+ business applications for mid-sized telecom firm. Staff of 12+ developers, DBAs, data and process analysts.