Sachin Govindraj Hosur
Bengaluru
Summary
Seasoned Analytics Consultant with background in leveraging data-driven solutions to drive business improvement and optimize overall performance. Possess skills in various analytics tools, big data analysis, predictive modeling, and strategic planning. Notable achievements include streamlining processes, enhancing system efficiency and providing key business insights through comprehensive reporting.
Overview
5
5
years of professional experience
Work History
Strategy & Analytics Consultant
Deloitte Consulting
07.2024 - Current
- Company Overview: Prominent regional bank based in Southeastern region of the United States
- Led data analysis and transformation for a $3 billion portfolio -Directed efforts across three SORs to enable accurate regulatory and profitability reporting for customers and commercial lines of business (LOBs)
- Collaborated with client’s technical and business teams - Worked closely with technical teams to understand the data architecture and partnered with business teams to address data issues impacting operations
- Prominent regional bank based in Southeastern region of the United States
Summer Intern
Kellogg India Private Limited
Mumbai
06.2023 - 09.2023
- Designed and orchestrated an event-driven data processing pipeline, leveraging AWS services like EventBridge, Step Functions, and AWS Glue, and deployed using AWS CloudFormation and a CI/CD pipeline.
- Executed efficient data transformations, converting CSV files to Parquet format through Glue jobs, and seamlessly loading them into the Redshift landing table and Apache Hudi.
- Implemented Slowly Changing Dimension Type 2 (SCD2) transformations to ensure historical data integrity and maintenance in the Redshift-processed table.
Data Analyst Intern
Optum Global Solutions
04.2023 - 06.2023
- Utilized PySpark and SQL to analyze enrollment and disenrollment data within the U.S. healthcare system for Medicare and Medicaid programs provided by the CMS (Center for Medicare & Medicaid Services).
- Uncovered valuable trends and patterns in the data, with the potential to enhance member retention by up to 1%, equivalent to a substantial $120 million in estimated value.
Data Engineer
Larsen & Toubro Infotech
09.2019 - 05.2022
- Generated 10+ ad hoc and dynamic dashboards using QlikView for the United States based Insurance client
- Developed a dashboard to measure the metrics of the Insurance brokers in the United States and Canada which helped the client to measure the performance of the Insurance brokers across US and Canada Yearly, Quarterly, and Monthly and optimizing spending on the brokers by 18%
- Structured Missing Claims and Policies by creating a data model which helped the client to identify a 2 Million USD mismatch
- Mentored a 3-member team, anticipating customer requirements and ensuring success for the client
- Key Contributor in the Business Intelligence & Analytics team generating 15% of the revenue of the Insurance Vertical at Larsen & Toubro Infotech
- Awarded as “Most Valuable Player” of the Insurance Business Unit for the month of January 2022 for resolving a high-priority claim issue
Education
MBA - Big Data Analytics
Goa Institute of Management
Goa04-2024
B.E - Computer Science & Engineering
SJB Institute of Technology
Bengaluru08-2019
HSC - Science
Chetan Pre University Science College
Hubli, Karnataka06-2015
SSC - General
K E Board’s High School
Dharwad, Karnataka05-2013
Skills
- QlikView
- QlikSense
- MS Office Suite
- MS Excel
- Python
- SQL
- Pyspark
- Amazon Web Services
- AWS S3
- Glue ETL
- State Machine
- Athena
- SNS
- Redshift
- Apache HUDI
- Cloud Formation
Positionsofresponsibilities
Core member of Cognition - Data Science & Analytics club of Goa Institute of Management.
Corecompetencies
QlikView, QlikSense, MS Office Suite (MS Excel), Python, SQL, Pyspark, Amazon Web Services (AWS S3, Glue ETL, State Machine, Athena, SNS, Redshift), Apache HUDI, Cloud Formation
Extracurricular Activities
Finalists of 'Viz-Quest' an Analytics Case Visualization Competition held by the Indian Institute of Nagpur, August 2022.
Projects
COVID–19 India Vaccination Dashboard, An interactive Power BI dashboard showing the KPIs state wise of the Vaccination data from Kaggle. The dashboard was able to depict the effectiveness of vaccination on the number of cases recorded daily. According to data 17% of the Indian population was fully vaccinated by the end of September 2021. Resume Recommendation System, Using LinkedIn data, built a resume recommendation system as a part of the Give Goa Project. Used the concept of Cosine Similarity and Spacy between the Job Description and Candidate Description. Factor Analysis of United Breweries, Using R, conducted a factor analysis on the Kingfisher beer brand of United Breweries. Through the study analyzed the market requirement of beer products in India.
Academicachievementsandcertifications
- Statistics for Data Science & Business Analysis, Udemy
- Programming in Python, Udemy
- Product Management: Building a Product Strategy, LinkedIn
Personal Information
Age: 25
Languages
English
First Language
Hindi
Intermediate (B1)
B1
Accomplishments
- Top 5% of the batch during post-graduation for Goa Institute of Management
- Most Valuable Player for the month of January 2022 at LTI
Timeline
Strategy & Analytics Consultant
Deloitte Consulting
07.2024 - Current
Summer Intern
Kellogg India Private Limited
06.2023 - 09.2023
Data Analyst Intern
Optum Global Solutions
04.2023 - 06.2023
Data Engineer
Larsen & Toubro Infotech
09.2019 - 05.2022
MBA - Big Data Analytics
Goa Institute of Management
B.E - Computer Science & Engineering
SJB Institute of Technology
HSC - Science
Chetan Pre University Science College
SSC - General
K E Board’s High School
Similar Profiles
Herman Van BrakelHerman Van Brakel
Specialist Lead at Deloitte ConsultingSpecialist Lead at Deloitte Consulting
Amaha Bekele AdmassieAmaha Bekele Admassie
Consulting Leader for East Africa at Deloitte ConsultingConsulting Leader for East Africa at Deloitte Consulting
Tejas BadeTejas Bade
Analyst at Deloitte ConsultingAnalyst at Deloitte Consulting