Rachana Sontakke

+1-469-***-**** ad3q0a@r.postjobfree.com http://www.linkedin.com/in/rachanasontakke ad3q0a@r.postjobfree.com CAREER OBJECTIVE

A highly driven Data & Business Intelligence Analyst with 5.7 years of strong analytical and technical experience, passionate about the field, with a love for uncovering valuable insights from complex data sets & business requirements, performing statistical analysis and communicating to stakeholders, is a proven expert in Data Gathering, Data Manipulation, Data Analysis, Data Visualization, Statistical Analysis, AI & ML Modeling and is seeking a role in the Analytics TECHNICAL SKILLS & TOOLS

Python SQL R Programing Tableau Alteryx Power BI MS Visio Excel KNIME JIRA QlikSense ETL SharePoint Confluence Databricks Azure EDUCATION

Southern Methodist University, Cox School of Business Dallas, Texas Master of Business Analytics May 2023

EXPERIENCE

Delta Global Services, LLC Dallas, Texas

Business Intelligence Analyst July 2023 - Present

• Managing and performing A/B testing, utilizing different statistical models on an Azure platform, and conducting Strategic Financial Planning and Marketing for Sales Analysis ML techniques like clustering, test hypotheses, decision tree, neural network, contributing to a 15% increase in overall Sales revenue

• Applying data cleansing techniques on customer behavior data, implementing transaction dashboards Qliksense and delivering insights and pricing strategies

• Developed and optimized analytical business tools while collaborating with cross-functional teams to enhance efficiency, which included automating Excel reports using SQL queries and Python scripts, and gathered and documented business requirements for ServiceNow, ensuring alignment with organizational objectives North Texas Food Bank Dallas, Texas

Data Analyst Intern Jan 2023 - April 2023

• Developed and maintained 60+ graphs/maps and 15+ dashboards in Tableau and PowerBI, extracted data using Alteryx to map a 13-county service area and identified food access gaps, resulting in actionable insights and documenting process flow

• Leveraged APIs for data scraping, rectified inaccuracies and utilized advanced data analytics techniques to compute latitude and longitude in R Studio

• Utilized SQL window functions to define "food swamp" and "food desert," created a food access map for operational insights, and collaborated cross-functionally to correlate food insecurity with disability and unemployment rates while recommending 5 new agencies in rural areas employing the Random Forest model Here Technologies Mumbai, India

Spatial Data Analyst II Jun 2019 - Jul 2022

• Automated mapping facilities for global customers and location data using advanced geographies database techniques and conducting research with MS SQL queries

• Managed GIS database as the data administrator, creating data models for analytical decision-making like Random Forest, Decision Tree, Regression Analysis, and Cluster Analysis, conducted regression analysis using R studio data modeling techniques, and developed SQL queries for data extraction

• Conducted A/B/C testing on the website to enhance map features based on customer behavior analysis and led the team in research and development, providing Best Practices for process, product, and tool improvements while practicing agile methodology for team management Hinduja Global Solution Mumbai, India

Process Consultant Intern Apr 2017 - Oct 2018

• Led the design of data warehouse and ETL processes for insurance claim processing in the health industry, enhancing efficiency and productivity while providing stakeholders with KPI reports, audit reports, and Tableau dashboards, resulting in a 95% data accuracy rate

• Pioneered workshops for claim adjudication, ensured compliance, and optimized data handling, including support for data pipelines

• Developed SQL queries to control, manipulate, and extract data, maintained data integrity, and passed claims per contact and documentation requirements while mentoring a 20+ member team for cross-functional collaboration and project success ACADEMIC PROJECTS

Data Visualization, SMU Aug 2022 - Sep 2022

• Collaborated with Six Flags and worked on the real-time consumer data and performed EDA to provide insights and developed dashboards in Tableau

• Utilized a combination of data analytics tools, statistical analysis, time-series analysis, and data visualization to support data-driven decision-making process Database Management & R Shiny App, SMU Sep 2022 - Oct 2022

• Designed and developed a SQL database used SSMS for student housing, enabling integration with R for an interactive R Shiny App and created SQL tables

• Crafted a Restaurant search application using R code and Shiny, incorporating CRUD operations for efficient data management Data Driven Marketing, SMU Feb 2023 - March 2023

• Determined the most effective treatment for ticket and concession revenue for the Dallas Stars hockey team by conducting A/B/C testing, Naive Bayes, KNN

• Utilized statistical methods such as chi square, proportion, and Welch's T tests to evaluate impact of different offers on fan response and revenue Programming for Analytics – Geographies World Bank March 2023 - April 2023

• Analyzed 1+ million records of world financial institutions income details and built reports on data

• Performed statistical analysis using python Prescriptive and Predictive modeling to understand trends of banks revenue across the geological data sets provided CERTIFICATION

• PwC Switzerland and Forage New world. New skills: PowerBI Virtual Case Experience

• UDACITY SQL for Data Analysis

• KPMG and Forage Data Analytics Consulting Virtual Internship