KRISHNA CHAITANYA ADAPA
Senior Data Scientist & Business Intelligence Analyst
Ottawa,ON
Summary
An experienced IT professional and an MBA with a passion to provide data driven solutions to real world business challenges. Skilled in data mining, statistical analysis,predictive modeling and creating insightful dashboards using PowerBI and Excel .Proficient in programming languages such as SQL and Python, with expertise in using libraries like Pandas and NumPy. Excellent communication skills and a proven ability to present complex findings to non-technical stakeholders.
Overview
8
8
years of professional experience
6
6
years of post-secondary education
4
4
Languages
Work History
Senior Sales Intelligence Analyst
Sekure Merchant Solutions
Montreal, Canada
07.2021 - Current
- Developed PowerBI dashboards to provide visibility on workforce management (KPIs - Attendance, Peak hour analysis, Leads generated per representative, efficiency of outbound customer reps, on screen time) and impact of launching sales campaigns (KPIs- Overall Production per sales campaign, trend analysis of hourly/weekly/monthly production per campaign, penetration rate,sales forecasts)
- Built Machine learning (Regression) models using Python to predict the outcomes of outbound calls, which optimized the dialing operations by 23%, reduced the overall investment by 20% & improved call conversion rate by 13%.
- Closely interacted with the top tier management and database team to provide data driven solutions that help management make informed decisions in improving ROI, production and sustainability for the outbound sales campaigns
- Built a predictive outbound dialing model that targets customers based on Standard Industrial Classification (SIC), States and Time-zones of the US which cut the cost per lead by 16.6 %, improved contact ratio by 20%,call conversion by 15%, dialer efficiency and increased lead sustainability over 10 months
- Extracted data from various databases using SQL Server Management Studio, MySQL Workbench and Five9 reports, automated and combined previously built Customer Relationship Management (CRM) ,Tableau and other excel reports to develop advanced PowerBI dashboards and added new features ( Trend Lines, group averages, comparison etc) to make hassle free decisions at a glimpse
- Used Excel and DAX extensively to perform advanced calculations, data analysis and to identify untapped business opportunities.
- Saved a minimum of 1.25 Million CAD $ annually by advising the leadership to discontinue one of the "New hire" spending strategies that generated negligible revenue for the company.
- Helped in building a centralized data architecture according to the needs of the business by communicating with data architects.
Business Intelligence and Data Engineering Intern
MBA CO-OP, Bombardier Transportation/Alstom
Montreal, Canada
09.2020 - 06.2021
- Developed & automated Power BI Dashboards for KPI’s, performed time series analysis to monitor key metrics, address redundancy issues and improve efficiency
- Improved data governance by building a centralized platform to organize, share, and access information, dashboards & data across the organization through MS Teams & Sharepoint
- Saved 2080 hours equivalent to 52,000$ annually by building, maintaining and operating Power BI Reports.
- Used Oracle SQL Developer for Data extraction, query building, data transformation and structuring
- Worked in Agile (Scrum) methodology- JIRA and updated scrum boards in Microsoft Teams to report progress
- Fully Automated EXCEL Dashboards through Power Queries & VLOOKUPS, and Power BI Dashboards using Microsoft Flow(Power Automate)
- Extracted and analyzed Data from JIRA, EXCEL,CSV, SAP and SQL Server.
Project Manager/Business Consultant - Part Time
Lazar Equities
Montreal, QC
08.2020 - 01.2021
- Planned, designed, and scheduled phases for a real estate Mobile & Web application project.
- Achieved project deadlines by coordinating with developers and end users to manage performance.
- Reported regularly to managers on project budget, progress and technical problems.
- Drafted project reports, insights, future recommendations. and closely monitored milestones by preparing GANTT Charts in ASANA to mark successful milestones.
- Implemented Agile (Scrum),designed test cases, prepared marketing strategies and provided feature inputs.
Senior Software Engineer, Market Research Analyst / Tester
Mindtree Ltd
Bangalore, India
07.2015 - 08.2019
- Performed market research for airline and hospitality industry- Pattern Analysis, analyzed market trends and conveyed the findings using EXCEL and SQL
- Created RPA structures to automate, design, and develop solutions to accelerate Business processes.
- Designed software requirement specification documents based on market specifications, obtained sign - offs from stakeholders for the designed artifacts and partnered with development leads to identify opportunities for better collaboration and process improvement
- Prepared and designed Test Workflows and Test Cases for SIT and UAT Testing.
- Worked with project managers, developers, quality assurance and customers to resolve technical issues.
Education
MBA - Data Science
John Molson School of Business, Concordia University
Montreal, QC 09.2019 - 07.2021
Bachelor Of Technology - Electrical and Electronics Engineering
GITAM University
Hyderabad,India 05.2011 - 05.2015
Skills
PowerBI
MySQL
SQL Server Management Studio
Python for Data Science
DAX
SAS-EG
SAS EM
Frontline Solver Data Mining
CRM
Data Vizualization
Project Management
JIRA
ASANA
Microsoft Power Automate
Agile-Scrum
Robotic Process Automation (NICE)
ALM
Functional testing
MS Suite - Excel, PowerPoint
GDS-Amadeus & Sabre
Additional Information
- JMSB-SAS Joint Certification in Data Analytics 2020-2021
- Certified by IBM - Python for Data Science and AI 2020-202
- Certified by IBM - Databases and SQL for Data Science 2020-2021
- Certified by PWC- Problem Solving by Excel-Data Analysis 2020-2021
- Certified by Udemy in R Programming 2020-2021
- Certified in “The Fundamentals of Digital Marketing” by “Google” and “IAB” 2018-2019
- Most Influential Lead Award, Best Team management 2018-2019
- Strategic Thinking Award, for efficient work on Artificial Intelligence 2017-2018
- Performance Testing-JMeter- VSkills certified 2016-2017
- Outstanding Performer Award, Employee of the Year in Mindtree 2016-2017
- A-Team SPOT ON Award, Best Contributor in the team 2015-2016
- Bronze Medalist in Shuttle-Badminton at Province Level (U-16) 2009
Timeline
Senior Sales Intelligence Analyst
Sekure Merchant Solutions
07.2021 - Current
Business Intelligence and Data Engineering Intern
MBA CO-OP, Bombardier Transportation/Alstom
09.2020 - 06.2021
Project Manager/Business Consultant - Part Time
Lazar Equities
08.2020 - 01.2021
MBA - Data Science
John Molson School of Business, Concordia University
09.2019 - 07.2021
Senior Software Engineer, Market Research Analyst / Tester
Mindtree Ltd
07.2015 - 08.2019
Bachelor Of Technology - Electrical and Electronics Engineering
GITAM University
05.2011 - 05.2015