| | | 20,000+ Fresh Resumes Monthly | |
|
|
| |
Click here or scroll down to respond to this candidateCandidate's Name
Dallas, Texas PHONE NUMBER AVAILABLE EMAIL AVAILABLE LinkedIn GitHubSUMMARYData Analyst with 3+ years of experience in SQL, Python, Tableau, Power BI, and ETL systems. Expert in transforming data from E-commerce and retail into actionable insights, creating master data models, interactive dashboards, and ETL pipelines. EDUCATIONMaster of Science, Business Analytics, The University of Texas at Dallas CGPA 3.75 May 2024 Major - Data AnalyticsB.E Electronics and Communication, Anna University, India CGPA 3.5 May 2019 PROFESSIONAL EXPERIENCEData Analyst Intern, Sports Excitement, United States September 2023 December 2023 Formulated Data models using DBT, focusing on driving strategic initiatives in pricing, contract negotiations, forecasting. Designed dashboards and visualizations using Tableau to harness data for extracting insights for business inputs. Conducted exploratory data analysis (EDA) tasks using SQL and Python to identify patterns and trends in behaviors. Utilized industry expertise in E commerce data to deliver valuable insights that drive impactful solutions in the sales. Data Analyst, Tata Consultancy Services, India January 2020 July 2022 Leveraged SQL querying techniques and statistical analysis to extensive datasets from data lakes and data warehouses. Engineered SQL stored procedures, triggers, views, and function to enhance extraction, transformation, and loading ETL resulted in increasing the query performance optimization by 30%. Employed Python Pandas for data preprocessing, utilized Matplotlib and Seaborn for EDA generating visualizations. Analyzed data using Power BI reports to identify sales and customer trends, designing Power BI dashboards for real-time monitoring of Retail data KPIs and metrics like revenue, customer retention rate, growth margin etc. Created complex DAX calculations to derive insights from raw data, including measures, calculated columns, and time- intelligence functions using Power BI. Automated data cleansing processes with Excel VBA, reducing errors by 15% and enhancing overall data quality. Developed an interactive Tableau dashboard to track sales performance across regions, products, and sales teams, leading to targeted sales strategies and a 20% increase in revenue. Collaborated with Business Analysts in executing Proof-of-Concepts using SQL, contributing expertise to deliver insightful findings on sales and help stakeholders in making informed decisions, contributing to a 30% increase in ROI. Presented findings and recommendations to stakeholders through reports, dashboards, and presentations. Coordinated with cross-functional teams by incorporating Agile methodologies and delivered project ahead. Support Engineer, Wipro Technologies, India May 2019 December 2029 Spearheaded Database Management activities and prepared meaningful data Scripts in SQL and MS Excel for testing. Resolved technical database and data flow issues by providing optimal solutions in SQL to enhance productivity. ACADEMIC PROJECTEnhancing Sales Performance: Power BI Dashboard Analysis for Splunk Software March 2024 Designed and automated an interactive dashboard using Power BI to analyze and bring recommendations to improve sales by 20% by performing various complex transformations and calculated KPIs and measures using DAX queries. Retail Market Performance Analysis November 2023 December 2023 Applied Power BI and DAX programming to perform an in-depth analysis of a retail data, resulting in the creation of visually compelling dashboards tailored for key states to make informed decisions regarding profit, orders, revenue. Netflix Data Analysis November 2023 December 2023Utilized Tableau and SQL to analyze Netflix data, constructing dynamic dashboards that offered insights on top 10 movies and TV shows, genres, release dates, and other key data facets to get better understanding of the content. Time Series Analysis of Air Pollution in United States October 2023 - November 2023 Analyzed air pollution data for around 15 years using Python and Tableau in assessing specific pollutants and evaluating. air quality variations across states and giving recommendations to control environmental pollution. SKILLSProgramming Languages and Databases: SQL, Python, R, SAS, MySQL, PostgreSQL, MongoDB, Oracle Tools: MS Excel, Excel VBA, MS Visio, Tableau, Power BI, Alteryx, Adobe Analytics, Google Analytics, JIRA, GIT, dbt Certifications: Alteryx Designer Core, AWS Certified Data Analytics Specialty, Google Analytics Individual Qualification ORGANIZATIONSAlteryx Datathon, UT Dallas, and Alteryx August 2022 February 2023 |
