Anuvir Singh Email & Phone Number

● Main point of contact for all analytic needs for the AMER sales organization● Extensive experience in SFDC permissions, formula fields, custom objects● Requirement gathering from the executives on key business impacting projects.● Prepare Quarterly Business Review Deck to review the highlights and lowlights of the quarter.● Responsible for Forecasting Cadence which includes Clari Dashboard Development, All SFDC related reporting and requirements gathering, Snapshot Data reporting.● Collaborated with functional teams for needs analysis, determining reporting requirements, and developing detailed specifications for new reports.● Developed, tested, and deployed new/revised automated or custom reports, optimizing query efficiency for best performance.● Conducted user acceptance testing and ensured user requirements were met in a timely manner.● Provided analytical and technical support for various projects, and educated team members on BI tools and processes.● Expert in Tableau, MicroStrategy, and other BI tools

Santa Clara, California

Focus on the development and maintenance of Tableau dashboards for sales reps to VP level. Deliver analytics and recommendations for pipeline health, sales rep performance, annual planning, and QBR. Compile ad-hoc reporting and analysis with multiple partners, including IT, sales, and sales operations area managers. Leading all Channel Ops Engagements at a Global levelWorking directly with Channel Partners on metrics, enablement, process improvement, policies, and programsWorking closely with Biz-Apps on SFDC enhancements.Assisting with making Deal Registration Program more structured and simpler.Working with Channel Executives on strategy and planningCreate and maintain road map of Sales and Channel initiatives and enhancements.Produced complex analytics incorporating business metrics, KPIs, scorecards, and dashboards.Determined beneficial data structures for the entire reporting environment, ensuring optimized data mining and extraction.Provided excellent customer service, training customers on report usage, and maintaining necessary documentation for various reporting or data extract needs.

Santa Clara, California

Main point of contact for all analytic needs for CBM Managers, National Partner Managers, Channel VP Operations.Engaged cross-functionally with IT for systems enhancements , audit syndicated data sources, and implement new processes for ETL.Collaborated with the Data governance team on Territory mapping and put systems and process in place to update SFDC Partnered with regional product managers and VPs to present analysis and recommendations on channel/merchandising programs in major retailers, leading to a 25% increase in unit sales.Extensively created a tableau reporting cadence for the Channels team & National Partner Mangers.

San Jose, California

San Francisco Bay Area

Update and track company key performance indicators of Designer base; create and publish regular dashboards and self-service analytics tools Stay on top of key metrics and support the core business team with quick analysis and data-driven insights to inform key decisions. Work with big datasets to extract useful insights, perform predictive analytics and evaluate effectiveness of ongoing Designer incentives and programs Partner with technology teams to integrate data into reporting tools such as Microstrategy, Tableau Work with cross-functional teams to evaluate future programs and business opportunities Create Tableau visualizations for executive insight and present the data to the team.Reviewed business intelligence needs and provided impact analysis for pending data source or software changes.Developed internal procedures in conjunction with business intelligence and team enterprise standards.Churn AnalysisCustomer Lifetime ValueGrowth HackingMarket Basket AnalysisCustomer Segmentation

San Francisco Bay Area

Customer Data Analysis• Segmentation and targeting• Energy behavior forecasting Database Querying and Automated Reporting• Write Oracle SQL utilizing multiple customer focuseddata sourcesSummary Presentation and Visualization• Support development of summary presentations for senior management• Create visualizations for end-users in Tableau and Powerpoint

San Francisco Bay Area

• Worked a great extent with the design and development of Tableau visualizations which includes Preparing Dashboards using calculations, parameters, calculated fields, groups, sets and hierarchies etc.• Created solution driven dashboards by developing different chart types including Crosstab’s, Heat/Geo/Tree Maps, Pie/Bar Charts, Circle Views, Line/Area Charts, Scatter Plots, Bullet Graphs, and Histograms in Tableau Desktop• Worked on creation of users, groups, projects, workbooks and the appropriate permission sets for Tableau server logons and security checks.• Created Tableau workbooks with calculations, parameters, Quick Filters.• Gathered detailed business requirements by interviewing end users and translating them into use-cases.• Created Graphical User Interface (GUI) mock ups for dashboards.• Created various diagrams such as process flow, use case, class diagrams and interaction diagrams using Microsoft Visio.• Performed Data mapping, logical data modeling, created class diagrams and ER diagrams and used SQL queries to filter data. • Facilitated JAD Sessions and managed cross team collaboration with offshore testing team.

Birmingham, Alabama Area

• Delivered business requirements, high level and detailed technical specifications and lead various teams through design, testing and implementation phases.• Strong knowledge in conceptual, logical and physical design of Business Intelligence and Data Warehouse projects• Responsible for GUI design, Workflow analysis, Prototyping and Business development Enforced naming standards. Involved in jobs and analyzing scope of application, defining relationship within & between groups of data, Star Schema etc.• Created mock up diagrams using MS VISIO and provided the screenshots replicating the changes to the Dashboards as per the requirements. • Developed & executed several Optimized queries in SQL on this data.• Liaison between the technical and business/user teams. Used various tools and applications as BA that includes Visio, Microsoft Office and QA Director automated testing tools. • Developed and maintained the Micro Strategy 9.2.1 Environment including metrics, filters, views, facts and dimensions.• Work with Microstrategy administrators to troubleshoot issues related to system administration; including user configuration, security, system monitoring, and object manager migration across development, test, and production environments.• Developed MicroStrategy Dashboards, Intelligent Cubes and reporting solutions.• Trained and provided best practices for the MicroStrategy platform to the end users.• Collaborate with ETL developers and participate in data model designs.• Analyze requirements, review designs, and develop BI Solutions in and out of MSTR.

Providence, Rhode Island Area

• Gathered detailed business requirements from end user community into use-cases and produced accompanying work flow diagrams.• Business Process Re-engineering (Reverse Engineering) was performed on to churn out the Key-Business Logic (KBL’s). Produced Activity and Business Process Diagrams using MS Visio to effectively communicate with developers. • Created Process Flow diagrams, Use Case Diagrams, Class Diagrams and Interaction Diagrams using Microsoft Visio and Rational Rose.• Provide business intelligence analysis to decision-makers using an interactive OLAP tool.• Conducted user interviews, gathered requirements, analyzed the requirements using RUP methodology and documented the requirements using Rational Requisite Pro.• Managed project budget by correctly monitoring and logging resource time into IT management tool weekly and monthly to ensure accurate client billing.• Liaison between business stakeholders and technical teams to ensure proper translation of Business Requirements to System Requirements. • Responsible for installation and troubleshooting of 3rd party applications.• Trained junior analysts on requirement gathering, provided technical training to business users.

New Delhi Area, India

• Responsible for managing marketing/pricing strategy, financial analysis, sales/inventory projections, importing commits/domestic ordering, safety stock calculations, supply chain/logistics coordination, and reporting to leadership for six highly profitable and visible categories.• Balanced financial allowances for weekly spending reviews and monthly forecasting with VPs, Directors, Senior Buyer, and company accountants.• Regularly updated projections of sales and inventory levels up to 12 months into the future in order to better prepare for and capture the sales potential of the retail market and ensure profitability by optimizing inventory levels, relying upon anticipation of sales trends and consequent receipt need well in advance of actual spending• Created BO and Microstrategy Reports and Dashboards for executives.• Create ad hoc reports with SQL, perform daily and weekly report generation and maintenance procedures.• Designed and implemented sales plan strategy and rapid reaction plan to allow for greater in-season flexibility in chasing inventory, employing production quantity trigger dates, aggressive production percentage schedules, multiple vendor availability per item, and more reactive sales projections for seasonally-sensitive categories.

Master Of Business Administration (M.B.A.), Finance, General

Bachelor’S Degree, Electrical And Electronics Engineering

High School