I have been developing Excel VBA solutions for over 15 years and have extensive experience with VBA, knowledge of SQL (including sub queries, joins, and dynamic SQL). I am also experienced with custom reporting tools, as well as creating Excel dashboards, accessing multiple applications to collect data and clean it up before building reports using a variety of tools. I am in constant contact with my clients throughout the entire process to ensure that they are receiving what they need from me - both efficiently and within their desired time frame – so that everyone is satisfied.
1) Dashboards, Scorecards, and Executive Summaries
2) Automation: Using VBA macros and advanced lookups/formulas
3) Advanced calculations and Pivot Tables.
4) Processing, manipulating, and analysing large sets of data.
5) Formatting: Making things look good while guiding the user to the important data points.
6) Optimizing files for size and speed - Taking files from 5 Minutes to under 1 second calc time.
7) Using the simplest solution possible - make it faster, easier to understand, and easier to modify if needed.
I am a skilled Tableau development professional with more than 7+ years of experience. I have perfected my skills and can now create advanced data visualizations using Tableau, the world's leading business intelligence tool. As an employee, I put in a lot of effort to make sure that your organization gets timely access to useful, interesting and reliable business intelligence reports. My work in Tableau includes creating compelling visuals to help express complex data in a clear and simplified way by:
1) Framing the right questions,
2) Generating the right insights
3) Generating actionable strategies for improvement.
4) Developed and published over 50+ executive level and operational Tableau dashboards using data from a variety of business areas and data sources.
Some of the technologies I most frequently work with are:
MS Excel | MS Excel VBA | Tableau | SQL | HTML | CSS | JavaScript