Sanket Patil Email & Phone Number

California, United States

Seattle, WA, US

Seattle, WA, US

• Healthcare Vertical Analysis Project
• Objective: Identify customers that are similar to existing healthcare customers by using machine learning classification technique of logistic regression and provide accurate sales coverage to customers
• Steps:  Led the project by meeting with healthcare sales team and gathered requirements for the project  Prepared data model in MS SQL Server/datasets in SAS and developed a logistic regression model of 88% accuracy.
• Impact: Model classified 13 customers into healthcare vertical in FY20Q1 which led to improved sales coverage
• Recognition: Received the ‘Bravo-Zulu Award’ for going above and beyond in helping Sales to cover their customers more effectivelyGlobal Sales Operations Dashboard Project
• Objective: Develop a centralized automated reporting platform for reporting 81 KPI metrics from 4 cross-functional teams

Tucson, Arizona, US

• Gathering business requirements regarding the development of BI solutions and modifications to the data warehouse architecture
• Improving decision making by developing and analyzing 20+ data reports using OBIEE/Tableau for 4k+ employees and 40k+ students
• Presented trends over the last 3 years in income, expenses and ending fund balances of colleges to the University Budget Office using 3 financial reports; Assisted the budget office in allocating budget more accurately.
• Created the reports in OBIEE by synthesizing data from 5 data sources using 10+ SQL scripts; Reports also contain financial data and student metrics for the current fiscal year and projected data for the next 3 fiscal.
• Led the requirement gathering and design discussions with the client to finalize the project scope and define the work breakdown structure including the detailed timeline; Acted as liaison between the client team and.
• Documented the workflow of the development process for the technical team in the technical design document; Mapped the functional requirements to technical deliverables for the technical team to ensure that all.

Dublin 2, IE

• Project: BGE-Meter Data Management ImplementationClient: Baltimore Gas & Electric
• Enabled the client (Baltimore Gas & Electric) to introduce “Low Energy Usage” rewards for its customers during high-usage months by presenting the energy consumption trends and analysis
• Identified customer energy consumption trends for previous 2 years through development and quantitative analysis of 10+ data reports using Tableau/Excel; Reports also contained key KPI metrics that highlighted.
• Reduced the work time of reporting team by 60% and saved 900 man hours; Automated the statistics calculation process by developing an Excel VBA tool containing 16 SQL queries that extracted data from the database and.
• Presented the reports to the key stakeholders and senior leadership and discussed the next steps in the development process
• Created an accurate understanding of the BI system in the team by developing a comprehensive dimensional data model in MS Visio

Dublin 2, IE

• Project: PTP-MRClient: Department of Works & Pension, Government of UK
• Designed Technical Design documents with reference to the Functional Design documents obtained from the client
• Devised technical solutions from the Technical design documents and incorporated the solutions in the system. Solutions mainly included modifications to the user interface of the application and the workflows.
• Performed unit testing, integration testing, performance testing and end-to-end flow testing for the solutions formulated.
• Delivered a Brown-Bag session on Siebel Task-Based User Interface feature of Siebel 8.1. Highlighted the advantages of the feature in improving the efficiency of the current project implementation.
• Attained expertise in a major functionality utilized in the project and conducted knowledge transfer session for team members. Also, assisted team members in modules related to the functionality.

Master Of Science (Ms), Management Information Systems, Business Intelligence

Bachelor Of Engineering (B.E.), Information Technology