Conducted 20+ end user coaching sessions demonstrating best use practices and advanced features of Looker

Converted 50+ SSRS reports to Looker
Developed Data Warehouse with semantic layer in Snowflake
Designed reporting solution based on Mailchimp marketing, DW in Snowflake and BI Looker
Developed data ingestion using from AWS S3 to Snowflake using Stages and Snowpipe

Replicated Looker dashboards using AWS Aurora as a base

Performed evaluation of ETL tools and provided recommendations to the external client

Adhering to version control guidelines used by GitHub to provide relevant controls of the development
Managed projects utilising tools like Asana and Jira and assigning tasks to relevant resources
Identified project stakeholders and developed for them LookML repositories with DataBlocks
Developed Looker dashboards with scheduled and targeted delivery to augment toolset of sales team
Performed in rapidly changing environment with frequently changing requirements
Facilitated request for new features and modified Data Warehouse and Looker projects

Lead technical resource for director of sales responsible for 10,000 sales professionals

Coaching and mentoring sales personnel in best practices and process improvements
Soliciting input and converting Access and Excel based reporting to SQL and Power BI

Improving efficiency and increasing trust in the platform by developing SalesForce Einstein dashboards

Acting as subject matter expert and team coach in best practices of use of SalesForce and Power BI dashboards

Streamlining data extraction, transformation and load using VBA and SQL
Establishing process control methodology and gathering feedback to ensure client satisfaction

Interacting with stakeholders to provide them with process and efficiency improvements

Leading sales personnel in fact finding exercises and pilot studies to identify and measure rate of improvement
Measuring customer interaction patterns and creating BI insights based on them

Developing automated methodology of reporting in Power BI using SharePoint and SQL server

Resurrecting Access based applications by troubleshooting VBA code

Automating Excel based reports by converting to SharePoint and Power BI
Designing data archiving methodology to build sales history
Designing and maintaining how-do documents to preserve cumulative knowledge of the team

Responsible for intake of sales data, cleansing and aggregating it and loading to SQL
Working extended hour and weekends to deliver results in timely manner

Participated in migration of SSRS reports to Tableau

Identified discrepancies between SSRS and Tableau reports and discovered root causes

Developed error reports for Tableau development team with fix recommendations

Developed business metrics and communicated them to Tableau development team

Solicited user feedback from sales teams to identify most effective report features

Participated in Tableau development meeting to represent end user needs

Identified areas for reporting speed and interaction improvement, enhancements in user experience

Analysed division wide operations, including performance, productivity and errors

Analysed reports to identify operational issues in company wide data

Conducted ad hoc analysis of various processes and data

Delivered weekly project updates to the management team

Trained sales team on best Tableau use practices

Collaborated with various teams on report consolidation and improvement

Safeguarded Sprint customer’s sensitive data by suggesting field masking

Improved Tableau online reports by modifying formulas and functions

Interpreted results using variety of techniques, ranging from data aggregation to statistical analysis
Designed, developed, implemented and maintained business solutions and recommendations to improve performance

Managed operational process improvement projects

Maintained and published standard reports for executive operations

Developed reports in Tableau and Excel from BI Cube, SalesForce backend and SalesForce.com

Enhanced Excel reports with VBA, array formulas and macros to speedup report refresh for sales personnel, and to save time and enhance accuracy

Queried raw data sources by writing SQL with joins, unions, having, cases, subqueries, cast, coalesce, and correctly identifying data dependencies and structure

Created 20+ dashboards in frontend SalesForce.com to help sales managers more expeditely and efficiently perform daily sales reviews
Conducted training of sales personnel in best practices of using SalesForce.com reports to increase their speed of sales analysis and confidence in the tool
Created relational databases within Excel using PowerPivot to enhance existing reports and provide increased visibility to data patterns using familiar platform
Researched solutions to business problems by contacting SMEs and gathering information from multiple sources to provide targeted insights in timely manner

Interfaced with IT to point out software deficiencies and coordinate software enhancements
Coached sales managers in best practices of use of BI lead management cube to make them more technology savvy and to leverage this technology to make them more effective at their work

Researched business problems and assisted in creation of new reporting tools to bring emphasis to areas of new sales opportunities

Developed report automation methodology using R-Studio, Access VBA, and SQL Server

Streamlined data ETL, cleansing and aggregation using R-Studio and Access VBA leading to 15 hr/ week savings in analyst time

Identified need for, developed and presented director of sales BI report generated in R Studio which identified outliers, seasonality, and change points in sales lead data facilitating increased sales

Converted numerous complex (2,000 lines) SQL queries into automated reports using Access VBA and stored procedures to reduce processing time, and remove possibility for human error
Developed automated marketing email generation process using SQL and R-Studio to shorten time to launch email campaign
Prepared analysis of effectiveness of email campaigns and introduced enhancements leading to 200% improvement in marketing email intake

Aggregated email performance data from iContact and created repository of email reports to facilitate future email performance tracking
Used SQL to create queries using joined tables, create stored procedures, perform arithmetic functions, convert datatypes, order by, distinct, like, wildcards, self joins, unions, having

Developed version control model and applied it in lead cleansing process to ensure that only valid leads were distributed to vendors
Designed and implemented knowledge base / tutorial repository to allow future employees easy access to process descriptions
Identified patterns, outliers, and abnormalities in sales data to point out areas where fraud could have been committed by sales representatives

Responsible for daily and ad-hoc data aggregation and report generation for sales and marketing teams
Interfaced state agencies and private utilities to perform data gathering and to dissipate reports

Reported daily financial metrics to CEO and CFO
Performed data discovery to search to incorrect or missing data

Maintained, updated, redesigned VBA modules in Access databases (1,000+ )

Implemented migration of Access tables to DB2 (7.5 M rows)

Designed and maintained high visibility report using VBS script and displayed every 30 min on TV screens across whole company (over 10,000 refreshed exposures)

Designed geospatial data charting methodology using Google Maps and Google Fusion Tables (100,000+ data points)
Utilized Census Bureau Tiger Database data in conjunction with Google Fusion Tables to point out underdeveloped sales areas (30 highly promising new sales areas)

Converted SQL queries into automated and scheduled tasks using VBA (200+ databases ranging from simple maintenance to over 6,000 lines of VBA code functions)
Designed/implemented Access VBA to html emailing module (500,000+ emails generated. Module included email tracking, automated email analytics report, and built in tutorial)
Designed automated VBA network storage utilization analysis tool (3 TB of network drive scanned and reported on automatically every month with PDF report emailed involved parties)

Served as go to person in areas of technical expertise and during challenging projects
Developed version control methodology to track database releases and updates and to be able quickly revert to functioning version in case or errors
Implemented Cognos reports in Query Studio to provide enhancements to existing reports
Interfaced with other departments to identify methods of streamlining bonus tracking process
Utilized BI methodology to identify possible fraudulent bonus request generating very substantial savings
Performed data mining to predict sales performance and sales trends
Routinely performed data validation to identify duplicate entries and data gaps

Maintained forecasting model of financial and operational results
Developed report repository to facilitate expedited reporting
Solicited communication across teams to identify problems areas in business process

Worked with SMEs to gather technical support requirements for user acceptance testing
Maintained SharePoint site to provide PowerPoint and Excel files for team collaboration
Adhered to version control to deliver only most up to date documents

Translated financial metric terminology into plain language process tutorial

Maintained hiring forecast to facilitate Human Resources talent acquisition

Developed SSRS reports to streamline financial analysis
Performed data gathering to enhance financial forecasting

Developed applications in MS Access utilizing GPS data points, time stamps and text inputs

Participated in geospatial analysis of vehicular movement to capture data discrepancy

Developed material inventory lookup tools in MS Access to allow warehouse supervisors accurately plan work for warehouse teams
Developed packaging material tracking database with predictive usage model to facilitate timely packaging material ordering

Maintained and standardized project flowchart to allow engineers easy tracking pro project milestones

Identified areas for improvement in resource management and suggested and developed forecast model to streamline purchasing

Maintained sales incentive program for a team of 3,000 sales personnel

Augmented MS Access reports to utilize VBA, pass-through, update queries, and subqueries to streamline reporting and provide insights to sales development

Created MS Excel reports to utilize array formulas, macros, pivot tables, password protection to facilitate bonus request submissions and allow data inflow from the field

Participated in web development project consisting of flash animations, tags, script updates

Took part of long term projects aimed at expanding promotions and bonus submission and tracking

Implemented data modeling schemes and designed time saving applications