| | | 20,000+ Fresh Resumes Monthly | |
|
|
| |
Click here or scroll down to respond to this candidateCandidate's Name
EMAIL AVAILABLE PHONE NUMBER AVAILABLE USA LinkedIn/Anand TableauPROFESSIONAL SUMMARYData Analyst with over 5 years of experience in data analytics and project management in Agile environment, specializing in e- commerce, and retail sectors. Skilled in data modeling, data warehousing, market research, and analysis of large data sets. PROFESSIONAL EXPERIENCEConnecticut Foodshare, Graduate Student Data Consultant Aug 2023 - Dec 2023 Conducted statistical and root cause analysis (RCA) of Connecticut Foodshares large data sets, used trend analysis, utilized Tableau, and SQL to identify key performance indicators (KPI), potential savings of $1 million. Performed gap analysis on marketing campaigns using SQL for data retrieval. Implemented A/B testing and a binary classification model using Python to enhance customer engagement, projecting a $1.5 million revenue increase. Optimized CT Foodshare website KPIs using Google Analytics, enhancing the donation process and achieving 22% increase in landing page conversion rates.LTIMindtree, Data Analyst Jun 2023 - Aug 2023 Analyzed KPIs metrics and generated reports using SQL to share strategic insights from large data sets of ServiceNow records, designed Tableau dashboard, boosted operational efficiency through effective data visualization, and secured $1 million. Implemented financial analysis resource and client budget data using SQL and ETL, and enhanced Tableau dashboard for actionable insights, resulting in a 15% boost in forecast accuracy. Led cross-functional collaboration to create and deploy ETL (Extract, Transform, and Load) pipelines leveraging AWS Glue and S3 to load data from multiple sources into AWS RedShift resulting in a 30% reduction in data processing time. Communicated recommendations to stakeholders on AWS desktop optimization, analyzing 900+ engineering applications; through EDA using Python and Excel across 11 divisions using Tableau and Excel; achieved 60% cost savings of $1.5 million Tata Consultancy Services, Business Data Analyst Feb 2019- Jun 2022 Collaborated cross functional teams to optimize marketing campaigns by interpreting CRM and market research, built ML models in Python using scikit-learn, hierarchical clustering, and applied A/B testing to meet KPIs, securing a $50M ROI. Automated monthly Stock on Hand reporting in Tableau, standardizing inputs, enhancing data integrity, and reducing human errors, resulting in additional client billing of $200K yearly. Led a team of 5 and performed comprehensive SQL query performance tuning by creating/modifying indexes and optimizing query structure (CTEs and Windows Function): reduced dashboard loading time by 50%. North Corp, Data Research Analyst Jul 2017- Jan 2019 Collected and prepared data from CRM APIs, databases, and external sources to build and maintain 10+ automated data reports and dashboards for Sales and Customer Service teams utilizing SSIS, Power BI, Power Query, and DAX. Leveraged AWS services S3, Glue, and AWS Lambda to design, implement, and maintain highly efficient data pipelines. Employed statistical learning techniques like A/B testing and logistic Regression over customer data and e-commerce customer retention framework to generate accumulative savings of $15M, across three years. EDUCATIONUniversity of Connecticut Master of Science in Business Analytics and Project Management GPA: 3.85 Aug2022- May2024 Jawaharlal Nehru Technological University Bachelor of Technology in Mechanical Engineering GPA: 3.7 Sep2013 - May2017 TECHNICAL PROJECT EXPERIENCEForecasting Walmart Sales ARIMAX PowerBI SAS Data Mining Devised an ARIMAX model and PowerBI dashboard with detailed trend KPIs for Walmart sales datasets, driving $800k in revenue through accurate sales forecasting and key driver analysis with 82% accuracy. Flight Price Prediction PYTHON QuickSight Sklearn Built ML model and exploratory data analysis (EDA) to identify trends, anomalies, and key performance indicators (KPIs), using complex algorithms decision trees, to predict flight prices with 84% accuracy. SKILLS & QUALIFICATIONSPredictive Modeling, Data Visualization, Google Analytics, Excel (lookups, pivot), Statistics, Data Model, PostgreSQL, EC2, NoSQL, Redshift, ETL, S3, Athena, Python (Pandas, NumPy, Matplotlib), R, SQL, Spark, SAS, Pyspark, LLM, Agile, Data Warehouse, Data ScienceCERTIFICATIONSPython (Coursera), SQL (Datacamp), Jira (Atlassian), Java Advanced (TCS), Business Intelligence for Consultants, CICD (TCS), GIT(TCS), Data Analytics (IBM), Lean, Six Sigma |
