A results-driven Analytics professional with a passion for extracting actionable insights from complex datasets. Seeking a challenging role to apply advanced statistical analysis and data visualization skills, contributing to the optimization of business strategies and decision-making processes. Known for combining technical expertise with a keen business acumen to drive data-driven solutions and foster a culture of continuous improvement.
Roles and Responsibilities:
Roles and Responsibilities:
Roles and Responsibilities:
Tableau Projects
Survey Analysis Dashboard
· Developed a comprehensive dashboard in Tableau that visualized survey data across multiple regions includes Impressions, CPC, Views, Total Revenue, Total Orders etc.
Sales Performance Dashboard
· Developed an interactive dashboard to visualize sales metrics across multiple regions.
· Included KPIs such as revenue growth, sales trends, and product performance.
· Utilized filters and parameters for user-driven analysis.
Customer Segmentation Analysis
· Analyzed customer data to identify segments based on purchasing behaviour.
· Created visualizations to highlight trends and patterns in customer demographics.
· Implemented actionable insights for targeted marketing strategies.
Financial Reporting Dashboard
· Designed a comprehensive dashboard for financial reporting, showcasing income statements and balance sheets.
· Enabled drill-down capabilities to analyze financial performance over time.
· Integrated with Excel for real-time data updates.
Social Media Analytics
· Developed a Tableau dashboard to analyze social media engagement metrics across platforms.
· Visualized trends in audience growth, engagement rates, and campaign performance.
· Provided insights for optimizing future social media strategies.
Supply Chain Optimization
· Created a dashboard to monitor supply chain KPIs, including inventory levels and delivery times.
· Utilized data blending techniques to combine multiple data sources.
· Offered recommendations for improving efficiency based on data insights.
Power BI Projects
Retail Sales Analysis Dashboard
· Developed an interactive Power BI report to analyze retail sales data across different stores.
· Included visualizations for sales trends, top-selling products, and customer demographics.
· Enabled stakeholders to make data-driven decisions.
Human Resources Dashboard
· Created a dashboard to visualize employee performance metrics and turnover rates.
· Presented insights for enhancing employee engagement and retention strategies.
Marketing Campaign Performance Dashboard
· Analyzed the effectiveness of marketing campaigns using Power BI.
· Visualized key metrics such as ROI, conversion rates, and customer acquisition costs.
· Provided actionable insights to optimize future campaigns.
Monthly sales Analysis Dashboard
· Implemented a Power BI reporting solution that streamlined sales reporting processes, reducing report generation time by 30%.
SQL Projects
Retail Inventory
Created a database for a renowned retail that tracks products, categories, orders and SQL queries to view products by category, check inventory levels, and summarize sales data.
Discount and Promotion Tracking
Developed a database to track discounts and promotions applied to products. Created tables for products, promotions, and sales transactions and queries to evaluate the effectiveness of different promotions and their impact on sales volume.
Expense Tracker
Designed a database to track personal expenses. Created tables for categories, expenses, and payments with queries to categorize spending and calculate monthly totals.
Feedback Database
Designed a database to collect customer feedback on services for a renowned entertainment company. Created tables for feedback submissions, customers, and services with the queries to analyze feedback trends and average ratings.
Survey System
Design a database for managing online surveys, including tables for surveys, questions, and responses and created queries to analyze response rates and common answers.
Python Projects
Web Scraping and Data Analysis Tool
Developed a Python application that scrapes data from a website (Customer Reviews) using libraries like Beautiful Soup and Requests, stored the data in a structured format (CSV or database) and used Pandas for data analysis and visualization.
Automated Reporting Tool
Created a Python script that automates the generation of reports from data sources like Excel, CSV, or databases by using libraries like Pandas for data manipulation and Matplotlib for visualizations.
Business Card Reader
Created a Python script that helps the user to extract data from a Imaged based Business card and store the data into an excel fille by using libraries like OpenCV, Pandas, Tesseract, Tkinter.
SAS to Python migration
Converted SAS macro into equivalent python code from snowflake to Dataiku using pandas, Numpy, Statsmodels etc.
SharePoint Web Part Projects
Personalized Dashboard Web Part
Created a customizable dashboard web part that allows users to add and rearrange widgets based on their preferences, pulling information from various SharePoint lists and external sources.
Responsive Pricing Table
Designed a web part that showcases different pricing plans in a responsive table format. Used HTML for structure and CSS for styling, including hover effects.
VBA Projects
Automated Report Generation
Developed a VBA macro that consolidates data from multiple Excel sheets and generates a comprehensive report. The macro can format the report, apply filters, and create charts based on user-defined parameters.
Ilmenite Analysis, China Pigment export Analysis
Automated dashboard by developing tools for ilmenite Analysis, China Pigment export Analysis.