Tejal Sadanand Tandel
Boston, MA Ó 774-***-**** R ad3t9s@r.postjobfree.com LinkedIn ÿ Tableau Public EDUCATION
Northeastern University Boston, MA September 2021 - May 2023 Master of Science in Information Systems
Coursework: Database Management and Design, Business Analysis and Information Engineering, Agile Development, Accounting and Budgeting University of Mumbai Mumbai, India July 2016 - May 2020 Bachelor of Engineering in Information Technology
Coursework: Python Development, SQL Lab, OLAP Lab, Business Intelligence, Data Mining, ERP, Business Communication and Ethics TECHNICAL SKILLS
Programming Languages: Python3, R, SQL, HTML5, CSS Databases and Tools: SQL, Microsoft Access, SQL Server Management System (SSMS), Snowflake, MongoDB, Airtable Visualization Tools: Tableau, PowerBi, Google Analytics 4, Microsoft Excel (Pivot Tables, VLookup, Power Query), RStudio Project Tools: Atlassian JIRA, Dynamics 365, SurveyMonkey, Figma Techniques: Data Interpretation, Market Research, Root Cause Analysis, Business Strategy, Inventory Management, Statistical Modeling, SCRUM Certifications: Dell EMC- Data Science and Big Data Analytics, Google Analytics Certification, NPTEL- Data Mining WORK EXPERIENCE
Pro Bono Business Analyst August 2023 - Present
Bright Mind Enrichment and Schooling Boston, MA
• Leveraged SQL and Microsoft SQL Server for effective data interpretation and A/B testing in product pricing, achieving an 8% increase in merchandise revenue
• Applied advanced Microsoft Excel and Tableau for preparation and visualization of business reports, enhancing strategic planning and decision-making
• Created SCRUM boards and Power Automate pipelines for process improvements resulting in an overall boost in operational efficiency Business Management Analyst July 2020 - June 2021
Ruby Consulting Mumbai, India
• Utilized Python and Google Analytics to analyze market trends, achieving a 20% increase in online revenue for a retail client through customer pattern analysis
• Implemented Six Sigma for process optimization, yielding a 14% improvement in operational efficiency within the supply chain sector
• Deployed and managed end-to-end data warehousing processes on Microsoft SQL Server, ensuring efficient storage, retrieval, and management of large datasets
• Facilitated market research and data analysis using Python and Jupyter Notebook and setting up automated Power BI updates for real-time CEO insights
• Conducted in-depth profitability analysis on product lines, for cost reduction and revenue enhancement, resulting in a 15% increase in net income Data Analyst May 2019 - August 2019
DKNT Connect Pvt Ltd Mumbai, India
• Improved inventory turnover by 10% by addressing slow-moving items using SQL queries and Microsoft SQL Server for inventory analysis
• Crafted annual budgeting with Excel and Power BI, utilizing data interpretation techniques, achieved a 5% increase in forecast accuracy
• Managed end-to-end data warehousing on SQL Server, creating Tableau visualizations enhancing stakeholder engagement and financial forecast reliability Digital Marketing Analyst April 2018 - July 2018
Bell Pepper Productions Mumbai, India
• Optimized website performance and user engagement metrics using Google Analytics and Power BI, achieving a 7% increase in marketing efficiency through ROI analysis
• Designed Power BI dashboards for website traffic and user demographics, leading to a 10% improvement in user engagement and customer retention
• Implemented segmentation strategies, resulting in around 9% increase in email open rates and growth in organic reach ACADEMIC PROJECTS
Netflix Competitor Analysis February 2023 - April 2023
• Employed market research, feature analysis, and brand perception using surveys, Figma, and feedback analysis for Netflix against other OTT platforms
• Performed Root Cause Analysis using user surveys and feedback, effectively refining content discovery and personalization, which elevated user satisfaction scores
Olist E-Commerce Marketing Analytics January 2022 - February 2022
• Conducted data analysis and dashboard creation using Python, pandas, and Tableau, resulting in enhanced customer segmentation and improved CLTV-based marketing strategies
• Initiated comprehensive data analysis and customer lifetime value assessment, leading to optimized resource allocation and improved customer retention strategies, markedly enhancing campaign impact
Analysis on COVID-19 Epidemiological Data using Snowflake September 2021 - October 2021
• Demonstrated proficiency in Snowflake’s cloud-based data warehousing, utilizing its features for data storage, querying, and analysis
• Streamlined data from AWS S3 to Snowflake using Snowpipe to ensure real-time data analysis of hospitalization rates, ICU admissions, and regional NPCs