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 in Python  Presented the model results to Healthcare Vertical Vice-President to gather his feedback• 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• Steps:  Adopted agile methodology and led the project by partnering with the business teams to define KPIs, structure of data reports and their update frequency  Developed 32 KPI dashboards in TIBCO Spotfire based on a data model developed in MS SQL Server; Data from multiple data sources (Excel, Oracle and Teradata database) was gathered and fed into the data model  Automated the process of frequently updating the data in the dashboards by creating 4 SQL scripts/jobs in MS SQL Server  Performed data verification/validation of the reports to ensure the reports have accurate data  Presented the dashboards to the senior management to discuss metric results and obtain their feedback on the dashboards• Impact: Centralized reporting platform enabled the management to view the impact of one team’s performance on other teams thus allowing them to quickly identify root causes of issues and also improved team efficiency by 65% by eliminating manual reporting

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 to the colleges for the next fiscal year• 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 years• 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 technical team• 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 requirements were clearly met• Creating a data model comprising 20 SQL data sets in Oracle BI Publisher to supply data to the report from the Oracle database• Leading a 4-member team in the project that involves planning, development and deployment of the financial reports• Working with the client to determine the project scope, timeline and report design for effective reporting of revenue data/metrics• Assisting the ETL team in creating 6 ETL jobs in IBM DataStage to load data into the Oracle data warehouse using 10 SQL scripts• Identifying trends in the usage of the University of Arizona website by measuring KPI metrics using Google AnalyticsAccomplishments – Received 2 client recognition awards for displaying excellent team work and problem-solving skills

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 location-based energy usage• 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 calculated energy metrics• 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• Elicited and translated client requirements into 10 technical design documents as part of an agile SDLC process• Collaborated with cross-functional teams to resolve 50+ issues across 3 applications as part of QA team and ensured data integrity• Reduced effort by 70% per test case by devising an automation application that used 10 extensive SQL queries & 5 stored procedures. It assisted the testing team in test data set up and in carrying out easy comparison of test results.• Gathered and analyzed requirements from the onshore team for system enhancements; designed and implemented the technical solutions using the Oracle Lodestar application.Accomplishments – Earned the “Out-Perform Award” - FY14 Q2, Q3 for displaying exemplary critical thinking and problem solving skills

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 underlying it. Technology employed was Oracle Siebel 7.7 Configuration.• 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.• Developed an Issue-Tracking tool using MS Excel macros to calculate the outage time of the systems used in the project. The outage time was later used in determining the severity of the issue and it's impact on the team's performance.

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

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