Post Job Free

Resume

Sign in

Sql Server Information Technology

Location:
Boston, MA
Posted:
February 22, 2024

Contact this candidate

Resume:

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



Contact this candidate