Experience
2005 — Now
Phoenix, Arizona, United States
2010 — 2015
2010 — 2015
Tempe, AZ
• Determined requirements for Application Rating tool to rate, rank and grade applications for merchandising in the Windows Phone 8 mobile store, decreasing delivery time of the tool.
• Developed project plan for delivery of new Application Rating Tool.
• Designed and built Rating Tool and Management Console based on agreed upon design, improving rater and manager efficiency.
• Used VBA/Excel Macros to create a front end rating tool for data validation error checking, improving accuracy and integrity of apps.
• Worked with management to create and design reporting software for Phone team using SQL Server Reporting Services, allowing managers to specifically measure and track team member performance.
• Created a series of dashboards for team managers using SQL Server Reporting Services / Visual Studio 2008, allowing managers to improve merchandising of applications and increase profitability of featured applications.
• Conducted ad hoc analysis using advanced SQL queries to provide detailed data for managers.
• Developed ETL tools using SQL Server/SSIS to load and aggregate data as well as to report results, ensuring data integrity.
• Created and developed internal metrics/KPIs using data from internal ticketing systems, allowing managers to improve organizational productivity.
• Defined strategic goals with Silicon Valley Operations Center manager in order to create effective daily reports.
• Created daily/weekly/monthly reports using SAP/Business Objects, letting managers use operational data to facilitate decision making.
• Created ad-hoc reports using Visual Studio 2008, enabling organization to make timely decisions.
• Trained management on Excel based pivot tables, allowing team managers to analyze their own data.
• Deployed a web-based SSRS reporting environment, increasing productivity of Ops Center employees.
• Created and maintained SSIS packages to load data for reporting environment.
2009 — 2010
2009 — 2010
Bellevue, WA
• Created automated PERL scripts to act as ETL to pull down clickthru/impression data from several 3rd party ad servers.
• Used SQL / Excel Pivot tables to reconcile internal billing metrics with Google Analytics data.
• Designed and implemented MySQL database schema to store billing data.
• Developed a series of internal billing reports, increasing billing efficiency, ensuring uniform results and increasing revenues.
• Worked with managers to create invoices, allowing external stakeholders a more detailed look into Expedia billing practices.
• Replaced legacy Excel 3rd party billing system with scalable database driven billing system, saving money and time for the organization.
• Evaluated several reporting solutions and presented findings to management.
• Created monthly billing presentation using PowerPoint. Presented results to management.
2004 — 2006
2004 — 2006
• Created and developed internal metrics within eBay Operations.
• Recognized every quarter as a top performer in Operations.
• Supported the Process Engineering staff with data analysis, report creation, distribution, and training.
• Implemented a 300 user Crystal Enterprise Premium environment with an average of 10,000 reports running weekly.
• Designed over 200 different reports / dashboards focusing Operations process improvement.
• Contributed numerous ideas for process improvement and quantified improvement opportunities.
• Regularly reviewed plans and provided options for tool design and data capture.
• Met with all Operations and Customer Management to gather reporting needs.
• Established systems and documentation to ensure reporting integrity.
2003 — 2004
Education
Arizona State University