• Design, build, and maintain Tableau dashboards for sales and marketing stakeholders in multiple departments, including writing custom SQL queries and dashboard calculations.• Design, build, and maintain CRMA dashboards for various teams, including preparing datasets and recipes.• Execute special data projects in multiple departments across all organizational levels.

• Designed and built agile Tableau and CRMA dashboards for all organizational teams and levels, including gathering business requirements, writing custom SQL queries, creating custom calculations and parameters, and training business leaders on dashboard use.• Built and maintained opportunity attribution model in OpenPrise, including writing complex validation queries in SQL and building complex validation tools in Excel.• Ran successful internal Tableau visualization competition including preparing dataset, evaluating entries, and selecting winners.• Used data from multiple sources to perform both ad hoc and recurring analysis on various aspects of sales and marketing operations, including account, campaign, and overall program performance.• Executed multiple ad hoc business analysis and data research projects, most of which began with "Can you figure out why...?"

• Designed and built business intelligence tools to help sales leaders manage program performance, including KPIs, measurement tools for special incentives, and summary dashboards in both Salesforce and Excel.• Designed, built, and maintained weekly sales and activity metrics package used by C-level executives and senior leadership to identify program successes and obstacles.• Designed and built reports and informative dashboards in Salesforce and Birst.• Performed Salesforce administration tasks, including creating and merging partner accounts, creating custom report types, editing field attributes, and performing mass uploads and updates using DemandTools and Workbench.

• Analyzed the performance of sales programs at all levels to determine trends, highlight successes, and make recommendations on program improvement.• Designed and built sales forecasting model that predicted program performance in a fiscal period with an average accuracy rate of 95%.• Using multiple instances of Salesforce, together with Excel, Access, and SQL, designed, built, and managed reporting systems for more than 20 outsourced sales and lead generation programs, ranging in size from 1 to 250 sales reps.• Automated existing reporting processes by migrating data queries from MS Access and Excel to data warehouse, including writing complex SQL queries and building SQL views. This project reduced file size by an average of 80%, and improved report run time by an average of 90%.• Designed and created concise, customized reports, both repeating and ad hoc, including illustrative charts and graphs, interactive Excel spreadsheets with filters and pivot tables, Salesforce reports and dashboards, and PowerPoint presentations.• Provided formal and informal training to colleagues in the use and beauty of Microsoft Excel.

• Specialized in efficient data collection, organization, management, and analysis. • Used the cooperative functionality of Excel and Access to design, create, build, and automate customized reporting solutions for clients in multiple industries. • Presented findings to clients - including city councils, commissioners courts, and other executive staff - using PowerPoint presentations with clear and concise charts and graphs. Prepared written reports for clients with analysis and data-based recommendations. • Streamlined and automated metrics-rich dashboards and reports using Visual Basic code for Excel.• Worked as a Reporting Analyst for Dell Singapore while living in Asia from 2005-2007, designing, building, and automating reports for the Pricing Group.

• Designed, created, and managed customized reporting systems for sales segment, including importing and organizing warehouse data, constructing Excel spreadsheets and Access databases, and writing Visual Basic code to automate reporting processes.• Streamlined and automated existing metric dashboards, reports, and charts using Visual Basic code for Excel, reducing weekly reporting time from three days to three hours, and reducing daily reporting time from four hours to 20 minutes.• Assisted other sales segments with reporting needs, including communicating with colleagues to determine data needs, designing and building reports, and automating processes.

• Conducted salary and benefits compensation surveys, including collecting, organizing, and analyzing data.• Created and maintained company and client databases and spreadsheets in Excel and Access.• Prepared and presented various human resources reports and related documents to governing bodies, including commissioners courts and city councils.

• Created first spreadsheet in Lotus 123, then discovered Microsoft Excel. • Created and maintained spreadsheet listing of all company contractual actions, including generating periodic and ad hoc reports for senior management personnel, Board of Directors, and State Legislature.• Wrote and administered contracts, including preparing Requests for Proposal, evaluating contractor performance, and communicating with vendors.