Sandeep Pinninti

● Supports overall data quality processes, standards and management including, but not limited to, the

annual segmentation and renewal programs

● Develops, maintains, and updates full inventory of Salesforce.com and any additional reports and

Dashboards

● To accomplish the sales closure, I work collaboratively with the New Business Leadership Team and the Retention Business Leadership.

● Created rep performance dashboards for different sub segments, which helped the leadership team understand where their team stood in closing deals

● Collaborate with the finance and sales leadership teams to define quotas for the reps in the retention business.

● Collaborate with the systems team on territory assignment and create territories in Salesforce

● Monitors data and provides analysis to illustrate sales trends, identify weaknesses in current sales

execution and support future sales strategy

● Compiles sales and renewals opportunity data and information for pipeline management

● Created Loss & Win Analysis report to understand the strategies and issues in the opportunities

● Collects and submits data for weekly finalized operational (commissionable) forecast

● Supports forecasting tools (e.g., Collaborative Forecasting and Einstein Analytics etc.) and Tableau

dashboards (e.g., Performance Health; Territory Opportunity; Account Health etc.)

● Collaborate with the finance and sales leadership teams to define quotas for the reps in the retention business.

● Supports organizational changes that impact sales processes, workflows, sales reporting, sales systems

● Assists with all sales enablement tools and systems administration including user access, sales metrics

selection, data analysis and process management, dashboard preparation, data validation, user

acceptance testing and requirements gathering

● Building and maintaining relationships with and influence at all levels within the organization

● Initiated and drove major projects involving New Business, NextGen & Renewals

● Reports Automation, Streamline & Optimization in New Business

● Also, I was the Backup for the various subsegments in Corporates

● Aided in all the Corporate subsegments in all the activities

● Involved in the NexGen Project to assist in New Logos, Territories mapping, Loss Analysis

● Involved in Renewals Process like preliminary and post vetting process, renewals case management, Territory data mapping

● There has been continued support to refine the renewal opportunity distribution and load process, including but not limited to the annual renewal vetting process.

● Data quality analysis in the projects and investigations, including partnering with the data organization and segments to streamline and optimize the process.

● Reports end to end data analysis understanding & investigated to main the data quality

● In Salesforce.com, different reports were created based on special requests from the different teams to interpret and review the sales data.

● Various reports & dashboards are created for Corporate team & other teams as well

● Involved in various CE teams to assist them in the automation of projects that they were working on manually.

• Assists and supports the Academic Sales Department, globally, by performing administrative and project- specific tasks
• Mainly supporting three projects Retail Sales, Institutional Sales & Higher Education Sales
• Retails Sales dealing with customers like Amazon, Blackwell’s, and Waterstones etc
• Institution Sales & Higher Education Sales dealing with Organizations, Universities, Colleges
• Working with various systems SAP (CRM), Salesforce (CRM), Advanced Excel (Macros), Microsoft SharePoint & Internal tools of Cambridge University Press content platforms
• Using internal data, along with market and competitor research, to help drive sales strategy and “hit the numbers
• Sales forecasting for goal setting, using past data and indicators
• Interpreting analytics and research for the company’s understanding
• Assigning work to the team members & any queries raised by team members are resolving
• Understanding of Rep’s requirements in order to pull and format the required data creating reports & dashboards with Macros (Excel)
• Planning & optimizing the process to produce more productivity from the team
• Conducting the Quality check for the entire team before delivering the task & updating in share point
• Processing orders in internal tools & using SAP (CRM) to extract invoices for the purchase orders to share the invoices with customers
• Working on Salesforce.com to incorporate the data & maintaining the dashboards for analysis
• Running Sales information reports on customers prior to Rep visits using Power BI for data visualization
• Producing Daily, Weekly, Monthly & Quarterly reports
• Macros made to reduce repetitive tasks & Identifying bugs & debugging Macros
• Creating and updating legal agreements for book and journal deals for customers using standard templates and sending them to Sales rep for checking
• Helping with, and running data cleansing activities for being systematic, thorough and accurate
• Undertake some system testing (A2R, CORE, Salesforce) when development is about to be made live
• Attend team meetings (skype, video conference, telephone conference) and take responsibility to feedback and interact with managers, colleagues and training manager
• Highly collaborative and used to working in a fast-paced, complex environment.

• Created, / Dashboard reports and presented it to the Client Relations Department
• Generated timely and accurate reports for analysis at Operational and Client level
• Using Salesforce (CRM) tool to extract integrated data for analysis to create daily, weekly, monthly reports
• Analyzes data & research all sales data in excel by pulling the information from Salesforce (CRM)
• Sing Salesforce application extracting CR Team activities captured & prepared reports as per the CR department requirements
• Created VBA macros used to simplify routine tasks for end users
• Using Salesforce Tool C-Sat Survey data of individual’s extracted & reports generated for Mail Merging
• Mail Merging in HTML documents to Clients & Customers for different regions India, Middle East & South East Asia
• Used to analyze Sales forecasting and reporting to director & Head of the Department
• Using the Talentpro application, TablentBin reports generated to the Sales representatives & CR Team to track the Clients usage of the Product
• Performed Data Visualization using features of Microsoft Excel Pivot Tables, Formatting & Functions
• CR Team Talk time data extracted by using CMS tool & generated Daily reports
• Prepared monthly Performance Status report for CR Team
• Diagnose data issues, with ability to identify root cause issues
• Handling Monthly, Weekly, Daily reports
• Scheduling CR Team activities.

• As a Team Lead allocated work to Team Members according to Time Management
• Tracking the production & Quality made by the team
• Planning & scheduling the work to complete work within the TimeLine
• Verified work aligned with service levels agreed and client requirements.
• Researched, analyzed, and projected market data for potential markets.
• Segregating different Products from different Suppliers by using Pivot Table in Excel
• Devised and implemented processes and procedures to streamline operations.
• Preparing Macro Tools for the development of Quality of a Product
• By using Macro Tools Quality of Product is improved
• Macros prepared to simplify routine tasks for end users
• Resolving Queries, raised by Team Members in Production Time
• Preparing PowerPoint Presentations for Unsolved Queries to the Client for Resolving
• Cross Check with Production & Quality within the TimeLine
• Mostly our Motto is to Produce Quality for the Product Attribute Enrichment which fulfills Customer Demand
• At Time of Delivery to Client, Supported for Production and worked in Rotational Shifts to make Product Delivery
• Attend team meetings (skype, video conference, telephone conference) and take responsibility to feedback and interact with managers from Client

• Worked for different projects like PILATUS, CH47 on MOST (Maynard Operation Sequence System) ANALYSIS and Time Study for optimization of Manpower, Preparing Line Balance & TAKT Time for more effective shipsets production
• Drafted equipment layout plans to enhance workplace efficiency for new and existing production floors.
• Supervised production workers to determine problematic areas and implement solutions for optimized production.
• Prepared Build of Sequences for Operation Optimization
• PILATUS MOST ANALYSIS for different modules- Cockpit, Wings LH & RH, Rear Fuselage
• Chinook 47 Defense Aircraft MOST ANALYSIS for modules- Tail cone, Crown Sub Assy
• Preparing Crew Load Charts to track day to day operations and validating Learning curve and Line balancing
• Preparing recovery plan and performing capacity analysis and enhancements
• Establishing time standards by using MOST for various products in machining and assembly lines
• Assisting for preparing Integrated Master Schedule (IMS) and Report
• Assisting and supporting project team to finalize and facilitate new projects
• Assisting and supporting the Ergonomic Study for Cockpit Module
• 5S Internal Audit was done for the Production Department.