Yogesh Dnyaneshwar Kodgire

Senior Software Engineer

8+ Years Experience in Data Analytics and Operations
Phone: 8007929284 | E-mail: y oge s hk odgi r e @ gm ai l . co m | LinkedIn: Yogesh Kodgire

Profile Summary
Passionate Data analyst with 8+ Years of industry experience in providing Analytics Driven Solutions to multiple leading
organizations & in operations, skilled with PowerBi, Tableau, Excel, R and Oracle Database, YellowfinBI, Google Data Studio,
Google BigQuery. Specializing in analyzing BI needs and translating business requirements into actionable insights through
interactive reports and dashboards. Proven ability to design and implement BI solutions, optimize data workflows, and deliver real-
time insights for data-driven decision-making. Skilled in collaborating with cross-functional teams to streamline processes,
enhance data integration, and improve overall business performance.
Skills
 Power BI  Project Management  Business Intelligence

 DAX  Tableau  Business Requirements Analysis

 Power Query  R Programming  Advanced Excel

 SQL  Data Modeling  Data Analysis & Data Visualization

 Google Big  Google Data Studio

Query

Experience

Senior Software Engineer (September 2022 - Present)

e-Zest Digital Solutions, Pune

 Leveraged advanced SQL techniques to aggregate and analyze large data sets (1,00,000+ rows), providing valuable
insights for business decision-making.
 Conducted a comprehensive assessment of the QlikView environment, including dashboards, reports, data sources, and
user requirements to replicate them using PowerBI Desktop, Power Automate, Excel.

 Played a key role in the Migration of Qliksense to PowerBi Dashboard Reports and maintenance of automated reporting
systems, ensuring that stakeholders had access to timely and accurate data by leveraging PowerBi, Power Automate, Excel

 Strong expertise in data modeling, management, and visualization, creating effective models to support business
intelligence needs.

 Optimize data models to align with PowerBI’s structure, ensuring performance and scalability by Ensuring data integrity
and consistency throughout the migration process.

 Wrote and optimized complex SQL queries for data extraction, ensuring data accuracy and performance improvements in
reporting processes.
 Extensive hands-on experience with data transformations including derived columns, slowly changing dimensions,
lookups, merges, and conditional splits.

 Utilized Power BI gateways to ensure real-time updates for dashboards and reports, improving data accessibility and
accuracy.

 Created customized charts, calculated columns, and measures using DAX to meet specific business requirements.

 Integrated data from multiple sources, built relationships, and optimized visualizations for effective analysis

 Identify opportunities for enhancing patient care and outcomes through data analysis and visualization
 Effective collaboration with healthcare providers, clinicians, IT teams, and stakeholders to bridge the gap between
technical analysis and practical healthcare applications

 Convey complex findings to non-technical healthcare professionals and executives by Ensuring compliance with
 healthcare data privacy and security regulations, including HIPAA, and implementing robust data protection measure

Data Analyst (Jan 2021 - Se p 2022)

Multi – Act Trade and Investment, Pune
 Assist Multi-Act functional teams to maintain and develop proprietary research models and applications

 Assess Fundamental market data perform data smoothing, aggregation, normalization, distribution to derive meaning
from data, prepare reports based on analysis using tableau and Present analysis to the management

 Converts requirements given by Research teams into algorithms, prepare plan of action to accomplish the given project,
back test strategy and get results

 Create & Design table’s structures using SQL as per project requirements.

 Participate in requirements meetings and data mapping sessions to understand business needs and Transform project data
requirements into project data models

Programmer Analyst (Jan 2020 - De c 2020)

Bitwise Solutions, Pune
 Design, develop Tableau and PowerBI reports perform unit testing, and maintains complex dashboards for scalability,
performance, and re-use

 Performing and documenting data analysis, data validation, and data mapping/design for projects.

 Work with team members to create useful reports and dashboards that provide insight, improve/automate processes

 Analyzed program data to provide input for key decision making and strategic planning. Performed sentiment analysis on
Customers Review data for one of the leading Hotel chains in U.S to get meaningful insights from it

Software Engineer (Oct 2017 - De c 2019)

Crisil Ltd, Mumbai
 Perform Extract, Transform, and Load operations on data to get meaningful insights from it

 Analyze transaction data to Identify Best customers group using RFM (Recency – Frequency - Monetary) Model, K-
means Clustering Algorithm and Perform Market basket analysis

 Performed data preparation and cleaning operations to get proper data for further Analysis

 Work with team members to create reports using Tableau to show updates in our project

 These reports helped us see how things were going, find any issues, and track our progress

Help Desk Executive (May 2016 - Ja n 2017)

AGS Transact Technologies Ltd, Navi Mumbai
 Offered friendly and efficient service to customers, handled challenging situations with ease

 Identified issues, analyzed information and provided solutions to problems

 Participated in team-building activities to enhance working relationships

 Handled 200+ calls per day to address customer inquiries and concerns

 Demonstrated respect, friendliness and willingness to help wherever needed Led projects and analyzed data to identify
opportunities for improvement
Associate Trainer Communication (Aug 2015 - A p r 2016)
FACE Focus Academy for Career Enhancement, Coimbatore
 Mapping Client’s requirement and coordinating, implementing the process in line with guidelines

 Demonstrated experience in the practical implementation of the detailed project plan with Zero errors

 Monitoring the overall functioning of the process, identifying improvement areas to achieve Customer satisfaction and
assist in the critical decision-making process

 Excellent at assessing the resources and identifying the opportunities

 Demonstrated respect, friendliness and willingness to help wherever needed

 Make Plans, direct and coordinate the activities of workers in branches

Key Projects

OPCW Qliksense to PowerBi Migration (Power BI, Power Automate, Excel and Qliksense)
Led the migration of QlikView dashboards, reports, and data models to Power BI for the OPCW (Organization for
Preventing Chemical Weapon)

Key Responsibilities:
 Conducted a comprehensive assessment of the QlikView environment, identifying key business metrics, KPIs, and stakeholder-
critical reports.
 Performed ETL processes to extract, transform, and load data into Power BI while optimizing data models for efficiency
 Ensured data integrity and consistency throughout the migration process
 Recreated and enhanced QlikView dashboards in Power BI, improving functionality and design
 Implemented Row-Level Security (RLS) for robust data access control
 Developed and delivered training sessions for end-users and stakeholders to ensure seamless adoption
 Provided detailed documentation on Power BI report creation, data governance, and troubleshooting
 Conducted rigorous testing to validate report accuracy and performance.
 Gathered user feedback to refine and optimize dashboards, ensuring alignment with business needs.
 Expertise in setting up Power BI Gateway for report scheduling and ensuring real-time updates has been key to enhancing
reporting efficiency
 Additionally, advanced techniques like drill-down and drill-through reports were utilized to enable in-depth data exploration.
Conditional formatting and filters were applied to tailor reports based on specific user needs.

Analyzing Trends in Patient Re-admissions (Google BigQuery, Power BI, R) – CareCognitics

Worked with Cardiac Solutions one of the famous Hospital from United States to provide Root cause analysis and decrease Patients
Re-admissions rate

Key Responsibilities:
 Leveraged SQL/BigQuery to extract and analyze EHR data, including patient demographics, diagnosis codes, hospital stays,
and medication records. Conducted statistical analysis and data visualization to identify trends in patient re-admissions
 Key findings revealed higher readmission rates among patients with chronic conditions and medication non-compliance
 Implemented automated SMS reminders for medication adherence, reducing re-admissions by 20% in three months
 Helped in Developing an appointment reminder system, leading to a 15% decrease in re-admissions due to missed follow-ups
over six months.
Impact Analysis: Hospital Diabetes Program – Power BI, Google BigQuery, Google Data Studio
As a Data Analyst/ Data Engineer for CareCognitics, the project aimed to determine if the program positively affected patient
health and reduced hospital expenses.

Key Responsibilities:
 Designed and implemented a data-driven evaluation of a diabetes management program to assess its impact on patient
outcomes and hospital costs. Identified key metrics, including HbA1c levels, blood glucose control, hospital readmission
rates, ER visits, and diabetes-related costs. empowered EMS to make data-driven decisions to enhance business performance
across various departments.
 Conducted statistical analysis comparing program participants to a control group, measuring differences in HbA1c levels,
readmission rates, and ER visits.
 Developed interactive dashboards in Power BI, and Google Data Studio to visualize program effectiveness and cost savings
 Findings showed lower HbA1c levels and reduced hospital re-admissions among participants
 Program expansion led to a 10% reduction in hospital costs within six months due to fewer re-admissions and ER visits.

Optimizing Patient Satisfaction: A Data-Driven Analysis – Power BI, Google BigQuery, Google Data Studio
As a Data Analyst/ Data Engineer for CareCognitics. This project aimed to analyze and improve patient satisfaction by leveraging
PowerBI, Google Data Studio, and BigQuery for data-driven insights.

Key Responsibilities:
 Collecting data from surveys, feedback forms, and online reviews
 Performed statistical analysis and Used visualization techniques to identify patterns, trends, and key factors influencing
patient experience.
 Created Interactive dashboards to track satisfaction trends over time, highlight correlations (e.g., wait times vs. satisfaction),
and provide actionable insights for healthcare providers to enhance patient care and experience

Automation for Quality of Earning Parameters – R Programming, SQL, Excel, Power BI

As a Data Analyst for Multi-Act Trade and Investment, This project focused on analyzing Quality of Earnings (QoE) parameters
to assess a company's revenue and expense components, enabling future growth prediction and investment decisions

Key Responsibilities:
 Designed the plan of action, algorithms, and database structure for QoE analysis using R & Python Programming, Oracle
Database, PowerBI, Tableau, and Excel
 Performed data gathering and cleaning to ensure accurate and reliable insights
 Developed a database structure to store QoE parameters for future analysis
 Created reports using PowerBI, Excel and Tableau to visualize year-over-year company performance across sectors using
key financial metrics and trends.

Analytics On cards Payment data – R Programming, SQL, Excel, Power BI, Tableau
As a software Engineer for CRISIL, This project focused on customer segmentation using the RFM (Recency, Frequency,
Monetary) model to analyze customer behavior and optimize targeted marketing strategies.

Key Responsibilities:
 Segmented customers into sub-groups based on RFM scores to enhance personalized communication’
 Utilized Tableau’s K-Means clustering to categorize customers into groups such as Best Customers, High-Spending New
Customers, and Low-Spending Loyal Customers for POC
 Used R Programming statistical Packages for K-Means clustering to Analyze spending patterns within clusters to derive
actionable insights for marketing strategies
 Implemented Market Basket Analysis (Association Rule Mining) to generate product recommendations and improve cross-
selling opportunities
 Designed and executed targeted email and SMS campaigns to enhance customer engagement and retention

Targeted Communications on Transaction Data – R Programming, SQL, Excel, Power BI, Tableau
As a software Engineer for CRISIL, This project focused on analyzing customer transactional data to enable personalized
communication strategies and enhance customer engagement for National bank of Abu Dhabi and First Gulf Bank

Key Responsibilities:
 Leveraged PowerBI, tableau and Oracle to extract insights from customer transaction history
 Categorized transaction channels (ATM, POS, Branch Banking, etc.) for the top 16 transaction types based on transaction
amounts
 Conducted customer profile analysis to identify and segment target customers based on transaction behavior
 Grouped customers by activity status (active/inactive) and internet/mobile banking registration to optimize targeted outreach
strategies

Sentiment Analysis on Twitter, News, and Customer Reviews – R & Python Programming, SQL
As a software Engineer for CRISIL. This project aimed to analyze sentiment from Twitter data, news articles, and customer
reviews to understand public perception and customer feedback.

Key Responsibilities:
 Conducted sentiment analysis to classify text as positive, negative, or neutral using R and Google's Natural Language API
 Created visualizations such as word clouds and word metrics using Tableau & R to present sentiment trends effectively
 Extracted insights from Twitter data and customer reviews to identify key sentiment drivers and improve decision-making
 Analyzed news sentiment using Google's NLP API to assess public perception of key topics and brands

Education

Post Graduate Diploma in Advanced Computing (CDAC), CDAC Mumbai (2017)

Bachelor of Engineering (Computer Science), Pune University (2015)

Awards and Recognition

CRISIL Breakthrough Initiative Award for Q1 | 2019 – Crisil LTD

CRISIL Clap Award for Q1 | 2019