Rachana Garad
San Francisco, CA +1-341-***-**** **************@*****.*** linkedin.com/in/rachana GitHub Authorized to work in USA
Objective:
Data analyst with a strong foundation in data-driven decision-making, statistical analysis, and cross-functional collaboration. Skilled in uncovering insights from complex datasets, optimizing workflows, and driving operational efficiency. Proven leadership in managing projects, collaborating across teams, and delivering actionable insights to support business growth and seeking to leverage my analytical expertise, technical skills, and leadership abilities to contribute to organizational success in a dynamic environment.
EXPERIENCE
Teaching Assistant (Data Science)
Hult International Business School, San Francisco Sep 2024 – Present
• Design and deliver SQL, Python, and KNIME-based assignments, creating practical scenarios to deepen student understanding of business analytics and data science concepts.
• Develop course materials, presentations, and case studies in collaboration with the professor, enhancing student engagement and driving improved learning outcomes.
Digital Sales Analyst
Stealth Tech Service Co, Atlanta, GA May 2023 - Aug 2023
•Analyzed customer data to uncover market opportunities, working with cross-functional teams to refine product features and enhance GCP adoption strategies that improved customer engagement and operational workflows.
•Collaborated with teams across functions to clarify client needs, contributing to developing and prioritizing cloud features that supported business goals and optimized customer solutions.
•Monitored feature performance and success metrics through SQL and Excel reports, ensuring continuous improvement of GCP integrations and alignment with customer needs and market objectives.
Technical System Analyst
IBM-KYNDL, Hyderabad, India Jul 2021 - Aug 2022
•Led the BAAS data migration, collaborating with stakeholders to migrate 10,000+ servers from on-premises to the cloud using Agile methodology and Scrum sprints, achieving 100% successful data migration.
•Coordinated across all project teams throughout the SDLC, managing production support for various tools and tickets in ITSM and Jira.
•Collected and cleaned large, structured data from IBM DB2 database and implemented robust backup strategies that reduced data failures across 200 servers through root cause analysis.
•Created and updated custom SQL and Linux scripts to serve as data sources for various reports and handled performance issues effectively on the IBM DB2 database.
Analytics Manager
S-Mart (Retail Company), Solapur, India May 2019 - Jun 2021
•Analyzed product sales and customer behavior trends using SQL and Excel, leveraging ad-hoc reporting to address immediate business queries and create visual presentations with Tableau, resulting in a 20% boost in product sales and a reduction in data access time by 3 hours.
•Designed and implemented an interactive dashboard to present sales performance trends and insights, enabling the CEO and marketing teams to make data-driven business decisions and enhance products, resulting in improved decision-making and product strategy.
•Identified pain points in the existing sales process, evaluated customer needs, and recommended enhancements to improve customer acquisition, satisfaction, and retention for the company’s SKUs.
PROJECTS
• Airbnb Data Analysis: Analyzed listings with R, NoSQL, MongoDB, and Tableau, identifying key trends and KPIs for guest satisfaction.
• Facebook Marketing: Built PCA and K-means clustering models compared 3 logistic models, selecting the original X features model (AUC: 0.726)
for optimal performance in classifying social media data.
• EY & NASA Data Science Project: Analyzed Hurricane Maria satellite images using Python and YOLO to develop an object detection model and achieve a 72% average precision score.
EDUCATION
Master of Science in Business Analytics: Hult International Business School, San Francisco, CA Oct 2023 - Apr 2024
Master of Science in International Business: Hult International Business School, San Francisco, CA Sep 2022 - Aug 2023
Bachelor of Science in Electronics and Telecommunication Engineering: Walchand Institute of Technology, Solapur, India Jun 2016 - Mar 2020
SKILLS
Technologies: Microsoft Excel (V-LOOKUP, pivot table, Power Query), SQL, Python, NumPy, Scikit-learn, Tableau, R, Machine Learning, Google Analytics, KNIME, STATA, MATLAB, PLOTLY, A/B testing, PowerPoint, Jira, ITSM, Microsoft 365, G Suite, Trello, power shell.
Skill: Data visualization, Data storytelling, Statistical Methods, Relational Databases, Regression analysis, Predictive Modeling, Data mining, Data manipulation, Data Cleaning, Hypothesis Testing, Exploratory Data Analysis (EDA), Key Performance Indicators (KPIs), Detail-oriented, Analytical skills, Agile, Problem-solving skills, Communication skills, Leadership, ETL, Pandas, ERD.
Certifications: SQL for Data Science with Python, Advanced SQL, Python, Statistics in Python, Accenture North America -Data Analytics, Introduction to R, Tableau, Database design, Google Workspace sales credentials, Project Management, Introduction to KNIME.