Sagar Swamy Email and Phone Number

[AWS SQL, SAQL, Salesforce Einstein Analytics, R, Power BI, Tableau, Excel]• Strategic Sales Analytics – Collaborated cross functionally to make sure Pipeline & Product are optimized to where, why and how we win/lose; increasing customer retention to 95% and conversion rate by 5%• Revenue Intelligence Analysis - Built and presented various KPI and QBR dashboards to increase visibility of pipeline, pipeline hygiene, forecast accuracy, budget optimization and account reachability, thus increasing the booking attainment to 93%• Top of Funnel (TOF) Analysis – Presented dashboards identifying key issues in the TOF model; designed new full funnel model for better customer lifecycle and pipe management, reporting and data insights• Decision Analysis – Extracted Win/Loss data from various sources and performed data analysis to identify important feature requests, indeed increasing the win rate for next two quarters

[ SQL, Tableau, R, SAS, SPSS, Excel]• Data analysis and Anomaly Detection - Performed data analysis on university online data using metrics such as conversion rates and click-through rate; generated reports by analyzing behavior of users • Statistical Product Research - Performed conjoint analysis to interpret how consumers make trade-offs in product preference. Decomposed products into qualitative attributes to predict success in different scenarios. Thus, helping to pick best design and create new product lines• Customer churn analysis - Built and compared models such as random forest and logistic regression using statistic results, cost metrics; recommended 3-point plan to improve marketing ideas on which the company should focus to increase their retention of customers• Business Insights for Target Marketing - Performed segmentation on historical leads data and built regression models using external data to increase number of sales and help them expand their market• Market Mix Modeling - Implemented regression models to estimate the impact of various marketing channels on sales & based on it optimized the advertising mix for promotion of the product• Equal3 – Business Analytics and Text Mining - Enhanced ability of Equals company by building text mining models to identify the semantic content that resonate with each human personality type

Responsibility: Business Data Analyst and Developer [Java, SQL, Excel, Tableau] • Team Collaboration - Designed and developed software by understanding the business requirements in Agile (Scrum) development; assisted team members and worked cross-functionally to resolve issues.• Key Driver Analysis - Proposed KPI’s and cost optimization of B2B project to senior executives, which reduced costs by 20%, eventually helping to win competitive projects for the company • Customer segmentation - Identified key customer segments by building segmentation model (using K-means); derived valuable insights which helped 4 clients to take key business decisions• Dashboard Design - Built dashboards and presented reports that forecasts revenue and profit from bill of material sales data. This made data available across the organization for business users• Data analysis – Reduced turnaround time by 20% by developing features such as layout movement interface, pay-as-you-grow licensing by analyzing and extracting insights from bill of material big data• Clustering and Data Reduction – Modeled a data frame structure for Control Panel and Installation Parameters by grouping the data values under several categories, that helped Cisco fetch $10 mm orders from 8 clients in various industries such as telecom, healthcare, retail and e-commerce• Led team of three developers to produce $2mm in revenue, increase of 30% from prior year.

[Java, SQL]• Data Extraction and Analysis - Constructed complex queries to Extract Transform Load(ETL) unique data and presented analysis and statistical insights drawn from register sales to product line managers • Process Improvisation - Refined transaction log (TLog) for smoother data transition between point of sale (POS) and cash systems, resulting in cost reduction by 5% and time cutback by 17%• Data Analysis and Visualization - Analyzed Walmart sales finalization and business settlement reports and presented data dashboards to retail executives, helping them to make data-driven decisions