Architect

• Apr 2022 - Present

Senior Technical Consultant

• Nov 2020 - Present

Business Intelligence Consultant

• Jun 2020 - Nov 2020

Design, develop, and administer data infrastructures and automate reporting systems for clients. • Developed a database model for SuccessFactors HRIS transaction database and building an analytic star schema database for automated reporting using Alteryx for data preparation, Postgres database for storage, and Tableau for data visualization. • Automated manual human resource reports for the HR director to present to the board • Reduced documentation time of fields to seconds by developing a Python solution to extract metadata from a Tableau workbook. Show less

Augmented Insights Manager

• Nov 2018 - Jun 2020

Led the development and implementation of business intelligence infrastructures, recurring automated reports, and dashboard solutions using industry-standard approaches in data storage, data integration, and data visualization to deliver objective insights that helped clients make strategic business decisions. Created and implemented processes to improve client relationship and grow and sell more work.• Managed a project team of three working with client marketing, reporting, and IT departments to deliver offer campaign analysis for a financial services company. Integrated databases with marketing efforts in Adobe and financial transactions in DB2 that the client could not integrate for decades in six months, utilizing SQL and Tableau. For the first time, the company to track the financial impact of marketing campaigns allowing them to make strategic, operational campaign decisions.• Developed and led training for regional apprentice talent management program. Responsible for administration, hiring, training, staffing, and coaching seven apprentices who reached full employment, increasing our chargeability by 10%.• Coordinated with vendors and multiple departments to exchange information and communicate issues and corrections. Show less

Business Integration Consultant

• Aug 2015 - Nov 2018

Worked with teams to design, develop and implement business intelligence environments using next-generation business intelligence tools, visualization best practices, and s• Created, modified, and launched automated, efficient, and user-friendly dashboards satisfying evolving data requirements, focusing on key performance indicators and division performance using SQL, Alteryx, Tableau Prep, or Python and various databases to build solutions.• Implemented Tableau and Redshift, pharmaceutical retail analytics platform, replacing manual reports done by hand, eliminating a $1M expense of software costs and onboarded a team of 35 to use the dashboards Show less

Market Intelligence Analyst

• Feb 2015 - Aug 2015

Led the development and implementation of repeatable processes for quarterly reporting packages to measure the health of the business and markets and inform executive decisions. • Developed reporting infrastructure to process marketing, geographic, economic, demographic, and activity data with Alteryx and Tableau, replacing manual, tedious, static reports with an automated and dynamic dashboard, increasing speed to insights from months to days. Led the development and implementation of repeatable processes for quarterly reporting packages to measure the health of the business and markets and inform executive decisions. • Developed reporting infrastructure to process marketing, geographic, economic, demographic, and activity data with Alteryx and Tableau, replacing manual, tedious, static reports with an automated and dynamic dashboard, increasing speed to insights from months to days.

Business Intelligence Analyst

• Mar 2012 - Feb 2015

Managed and coordinated business intelligence efforts to leaders to prioritize, execute, analyze and optimize reporting initiatives by building a data warehouse to integrate the company’s application databases and Salesforce CRM database into a dimensional model to deliver automated reporting, including Tableau and TIBCO JasperSoft, to provide direct analytical support to business stakeholders and • Partnered with business stakeholders in divisions including PMO, Sales, Finance, HR, Shared Services, Risk Management, and Accounting to understand requirements and identify opportunities to improve business initiative outcomes. • Provided updates to management regarding budget to actual, informing them of deviations and opportunities, economic impacts of strategies, and compliance issues surrounding priority business decisions or deals. Example audit solution in the warehouse that found over $1M in risk underpayment that the company to capture and customer utilization analytics for sales and operations.• Created and maintained reports tracking lead conversions, closed/loss reports, and territory reconfiguration for VP of Sales and VP Operations. Show less

VS Ops Analyst

• Feb 2011 - Feb 2012

Analyst

• Mar 2010 - Feb 2011

• Lead business requirements gathering, data modeling, for data warehouse build. • Provided data cleansing and analysis services to the internal operations team related to home service provider referrals and performance. • Developed internal reports for decision makers using Excel and Pivot Tables. • Designed and implemented process to auto generate monthly bills from text files using Excel and Access reducing time to process bills from two weeks to one day • Implemented Google Analytic strategy to test new markets for product launches • Chose keywords and content of ads, generating $5k in new business per quarter. Show less

FIDS Intern

• Jun 2008 - Aug 2008