Project Lead:

1. Setting up & tracking Executive dashboard from scratch providing the cabinet visibility to marketing performance updated on a regular cadence (Quarterly).
2. It includes marketing pipeline report by Business Unit (BU), sales target & achieved, bookings by quarter, win rate, opps created by quarter, average days to win, high priority leads, sales activity, YTD BU bookings to goals, forecast etc
3. Collecting the correct data from various team across the organization and from internal Salesforce database
4. Cleaning of data & calculating what needed
5. Monitoring my team, followup
6. Going the project live

1. Connecting the data from Cube using Microsoft Analysis Services
2. Creating reports and dashboards helping team understand Risk Analysis (future) in a project management
3. Main focus: Time management, project deliverables analysis, time sheet management based on team & employee, cost analysis
4. Review & Redesign after discussion with Management

1. Created a dashboard which includes competitor data
2. Extracting data from HIMSS Analytics in excel and .csv, importing in tableau
3. Dashboard included reports like: Top N competitor, Sales Profit by Customer segment, competitor by sales, Profit n sales of each competitor, Sales by state by product, monthly sales by region, swapping between monhly sales and profit etc

1. Objective- To track large events in real time - pre event analysis & post event analysis
2. Connecting Salesforce & excel data to Tableau, cleaning n working on registrant list
3. Understanding how many new registrants, if repeatitive, how many opps turned in revenue, amount, which product, new clients by region and month, leads, etc.

Launched a Market and Competitive Intelligence Report-

1. Bimonthly newsletter which provided actionable intelligence on key trends and uncertainities, monitor competitors important to our company and keep updated with what is going on in the marketplace
2. Started from scratch with the idea what to include in the report which would benefit the Marketing & Sales team
3. First few versions were in Word document and html, then gradually made it live in Salesforce which was on the fly easily available
4. Used Salesforce chatter for updates

Provide website statistics for product pages and guidance on keyword planning to help BU teams build relevant content

1. Provide website statistics for product pages and guidance on keyword planning to help BU teams build relevant content
2. Tracking social media & advertising
3. Engage metrics from Google Analytics
4. Adding Google Keyword Planner and Trends as a measure of success
5. Created a Powerpoint of the analysis with their bid value using Google Adwords

1. Generated weekly ‘Win/Loss Report’ in Salesforce which provided significant visibility to product marketers, their cross –functional stakeholders, and other parts of marketing
2. Created a Dashboard in Salesforce using various report types where I showcased - YTD closed opps, YTD Top 5 Loss reasons, YTD Top 5 WIn reasons, Top 10 Open Opss (above $100K) in various stages, Last 30 days closed opps etc

1. Created client heat maps using Batchgeo and Power Map to support Sales & Marketing Team
2. Analysing client's products by region and their detailed information
3. Fetching the data from Salesforce

1. Tableau dashboard - Competitor Analysis by software product implementations in US hospitals
2. Tableau dashboard - Various Campaign Analysis for Marketing BUs
3. Providing registrant pipeline analysis for ongoing strategic events using Pivot table