Business Intelligence Data Analyst

ARCHANA DESHPANDE

********************@*****.*** 315-***-**** LinkedIn GitHub Portfolio Washington D.C. (Open to Relocate) WORK EXPERIENCE

Business Data Analyst CCDS Lab, Syracuse University - NY (Remote) Jun 2024 - Present

• Slashed weekly reporting time by 9 hours with automated KPI dashboards using SQL & Tableau, enabling data-driven decision making.

• Alleviated recruiting efficiency by 20% with automated ETL pipelines, streamlining data management for faster candidate identification.

• Unveiled ideal candidates by analyzing data from 10+ sources using Python & Excel, reducing recruiter hiring time by 15%. Technical Business Analyst DataKind - Syracuse, NY Jan 2024 - May 2024

• Derived 25% growth in engagement & satisfaction by developing a Python tool for 100+ webinars (5k+ attendees) with GenAI.

• Conducted data analysis on National Clearinghouse datasets (100+ universities) to build predictive models for alumni success rates.

• Enhanced data accessibility for teams by performing document analysis, enabling tool use, and providing technical onboarding.

• Collaborated with team via Asana and Slack on requirement analysis, improving business operations to align with school needs. Business Intelligence Analyst NEXIS Technology Lab - Syracuse, NY Apr 2023 - Dec 2023

• Spearheaded a data analytics project, increasing platform engagement by 20% through optimizing and enhancing user interactions.

• Developed a Power BI dashboard tracking KPIs, improving customer retention by 15% through data-driven insights and metrics.

• Led machine learning model development, reducing customer churn prediction errors by 25% using feature engineering techniques. Data Analyst MedTourEasy - Mumbai, IN Jan 2021 - Jul 2022

• Improved data quality by 30% for retail through Google Analytics & EDA on 5,000 records, enabling better decision-making.

• Increased accuracy by 25% through developing VBA to reduce manual data entry & requirements gathering, enhancing data reliability.

• Enhanced KPI reporting using data integration & business acumen by 20%, fostering sprint meetings for continuous improvement. TOOLS & SKILLS

Programming Languages: C, Java, Python, SQL, ML, R, HTML Database Management/ ETL: Microsoft SQL Server, MySQL, Snowflake, Data Warehouse, Query Tool, Azure DevOps, MS Access Machine Learning: Supervised/Unsupervised Learning, Dimensionality Reduction, Variance Analysis, Regression, Neural Networks Methodologies: Agile, Scrum, Waterfall, Salesforce, SAP, SAAS, AWS, ERP, CRM, QA, Program Management, SDLC, STLC, Cloud Computing, GCP, Project Management, Product Management, BI Tool, Dynamics AX, Marketing Automation, Marketing Cloud, Microsoft Dynamics, Pivot Tables, V-look ups, written communication, Service Management, Financial Analysis, Advanced SQL, Qlik Software: MS Power BI, Tableau, PLM, ALM, MS Project, Slack, Alteryx, Figma, Minitab, MS Word, PowerPoint, MS Excel, Outlook Product: Smartsheet, Jira, SharePoint, Confluence, MS Visio, Asana, Microsoft Office Suite, Adobe Analytics, A/B Testing, PRD, IT EDUCATION

Syracuse University - Syracuse, NY Aug 2022 - May 2024 Master of Science in Business Analytics

Coursework: Data Science, Business/Data Analysis, Database Management Systems, Project Management, Visual Analytics, supply chain Savitribai Phule Pune University - Pune, IN Aug 2017 - May 2021 Bachelor of Science in Computer Science Engineering Coursework: Statistics, Economics, Mathematics, Relational Databases structures, AI, Information systems, Data Mining, QA/SW Testing TECHNICAL PROJECTS

Energy Efficiency Analytics ML Algorithms, Data Modeling, Descriptive Statistics (Link) Jan 2024 - May 2024

• Achieved 98.17% accuracy in predicting energy loads using Logistic Regression & Correlation Analysis, boosting efficiency.

• Elevated heating and cooling loads prediction accuracy by 15.5% with SVMs & Neural Networks for precise energy optimization. Global Climate Trends Dashboard Tableau, Data Visualization, Business Intelligence (Link) Jun 2023 - Dec 2023

• Optimized climate data analysis by 30% with predictive models, improving forecasting accuracy for the future trend assessments.

• Designed a Tableau dashboard analyzing climate data from 168 countries, identifying trends to drive data-driven climate action. Food Ordering Database Management System SQL, Query Optimization, RDBMS (Link) Jan 2023 - May 2023

• Reduced meal ordering times by 20% with SQL scripts integrated with Power Apps, enhancing the process & user experience.

• Boosted restaurant efficiency by 35% through query optimization & targeted product development, streamlining operations. Movie Ratings: OTT Trend Analysis Python, Data Analysis, Data Validation (Link) Aug 2022 - Dec 2022

• Analyzed 10,000+ IMDb ratings using Python (Jupyter notebook), unveiling streaming trends across Netflix, Prime, Hulu, Disney.

• Elevated content strategy by 25% through teamwork, leveraging insights from IMDb ratings for a more engaging user experience. CERTIFICATIONS

Certified Scrum Product Owner Certified Scrum Master Google Analytics Product Analytics MySQL for Data Analytics Advanced Microsoft Excel Office Specialist Lean Six Sigma Green Belt Microsoft Certified: Power BI Data Analyst Associate Tableau

Contact this candidate