Supported the implementation of new and existing HR systems, including HRIS (ADP), iCIMS, OnBase document management, TrakStar performance management and others. Led the development of baseline HR metrics from employee master record, applicant data, engagement survey data and key Weekly Business Review metrics. Analyzed and audited payroll processes, procedures and results to optimize administrative function. Acted as subject matter expert during development of employee and leader performance incentive metrics. Assisted with security reviews of new applications and consulted with other Amazon teams looking to leverage Care Medical employee data.

Design and deploy Tableau dashboards spanning the full spectrum of Human Resources data - turnover, vacancy, diversity, compensation, recruiting, leaves and payroll results. Represent Seattle Children's Hospital in national conference presentations on HR metrics and uncovering institutional systems of implicit bias, Create peer-to-peer national network of pediatric hospital analysts to provide a monthly turnover benchmarking effort. Design SQL Server database that integrates native Lawson HR with cross-functional, custom data to expose hidden trends and relationships between data sets through intuitive and interactive visualizations and dashboards. Consult as a subject matter expert with teams implementing applications that incorporate HR data and respond to day-to-day ad hoc information requests and analyses. Maintain a 150-report library of Lawson HR Crystal Reports. Administer Tableau site for Human Resources Information Systems, including security, dashboard publishing and scheduling. Assist HR consultants with employee investigations by mining and presenting data that informs corrective actions and policy implementations.

Develop and maintain Lawson Business Intelligence report library using Crystal Desktop and suite of SmartNotes (automated email notifications and reminders to employees). Research industry best practices and HR data to advise and develop a suite of HR metrics to assist executives in operational excellence and decision-making.

• Gather, analyze and document business requirements and user acceptance criteria for North American B2B Consumer Packaged Goods, Licensed Stores and Foodservice OBIEE reporting solutions through the BI Enterprise Data Warehouse• Develop and leverage Oracle ERP and AP, AR, OM, ODM and Pricing process expertise to analyze and troubleshoot ETL, presentation layer or end user issues, determining root cause and solution proposals• Coordinate development prioritization between Finance, Accounting, Sales Forecasting, CPG Operations, Pricing and Promotions, development team and broader BI organization to ensure effective and responsible resource utilization• Incident Management documentation, tracking and regular updates to initiator, Product Owner and development team• Participate in technical design discussions with developers to ensure delivery of desired functionality• Develop and groom user story backlog for sprints; lead daily scrums and story sizing sessions as needed, prepare demos for Product Owner; assist with quality assurance testing on major or resource-constrained deliverables• Subject matter expert for employee data in EDW• Key accomplishments:- First phase of “Gross-to-Net” B2B metrics by Plan-To, Brand and period, consolidating trade and non-trade spend at divergent grains from multiple current and historical data sources- Accurate Brand-level revenue and volume metrics fully resolving grocery display items with BOM’s having mixed brands and units of measure- Excel-based Google Earth KML file generator that transforms store or B2B customer transaction data sets into animated, three-dimensional geospatial data visualizations and analytics – at zero cost- Complex reconciliations between EBS and Siebel actuals to inform the business of variance drivers- Identification of a seven-figure GL discrepancy, root cause and solution- Excel-to-Outlook integrated LDAP membership maintenance tool for OBIEE security administration

• Design and deliver - from conception to finish - a Starbucks “Moneyball” workforce correlation and predictive analytics database, supporting the information needs of Starbucks data scientists• Design, automate and document the ETL of multi-grain, Type I and II, internal and external data sources from SAP Payroll and Benefits modules, Succession Planning, Taleo (formerly Recruitsoft) recruiting, employee satisfaction surveys, customer surveys, store attributes/revenues/comps, US Census and many others• Utilizing SAP query, Crystal Reports, MS Access/Excel, VBA and SQL, work with in-country leads, survey vendor, and statisticians to design, document, collect and deliver the base organizational hierarchy and attribute data and system needed to plan, administer and report on our global (13 country) employee satisfaction surveys, exit surveys and custom departmental surveys/assessments• Lead the initial design and requirements gathering for a Convergys global HR data warehouse and reporting solution• Application and reporting support for Starbucks Succession Planning annual process• Mentored and trained HR business systems analysts• Key accomplishments:- Innovated an automated and secure Crystal Reports and VBA reporting solution that erased an annual $1,000,000 employee satisfaction survey vendor contract by bringing survey design and reporting in-house- Developed a small-scale decision and administration tool under a high-pressure deadline for 2008 workforce reductions; collected, cleaned and consolidated the data sets of impacted employees prior to their notification

• SAP and Taleo report developer for Staffing, Total Pay, Legal, Global Communications, Compliance, SCCO and Partner Insights employees with standardized and ad hoc requests• Utilize SAP Query, Business Objects WebIntelligence (Taleo WebI), MS Access/Excel, VBA and SQL to automate recurring reports and dashboards, elevating them to presentation quality• Partner with Staffing, Staffing BUIT, IT and Taleo IT to scope, design, test and deliver Taleo reporting data warehouse refreshed nightly with applicant tracking data (DM and above)• Design initial suite of daily Taleo reports and dashboards for Staffing organization and EEO Compliance team• Design MS Office Executive Staffing application (Taleo alternative) to support the highly customized recruiting and hiring requirements for senior leadership positions• Perform annual extractions of recruitment, hire, termination, transfer and promotional data for EEO data submissions• Design MS Office Succession Planning application and analytical support for annual review of critical succession pools• Design and support revisions to annual performance review forms used for all retail and non-retail employees• Provide analytical support and survey pool identification for submissions to Fortune Magazine Best-Places-To-Work survey• Key accomplishments:- First to generate key Starbucks metrics of time in job and position- Designed MS Access recurring SAP report scheduling, formatting and delivery application