About Me
Detail-Oriented Data Analyst with a Strong Background in Statistical Analysis, Data Visualization and Data-Driven Decision-Making, Proficient in using Tools like Python, SQL, Excel, Alteryx, Power BI and Tableau for Data…
Detail-Oriented Data Analyst with a Strong Background in Statistical Analysis, Data Visualization and Data-Driven Decision-Making, Proficient in using Tools like Python, SQL, Excel, Alteryx, Power BI and Tableau for Data Visualization Software to Extract actionable insight from complex Datasets. Experienced in Farming, healthcare resources, Online Marketing and familiar with banking & financial practices industries. Experienced in creating and Maintaining Data Pipelines and Dashboards that have improved operational Efficiency and Decision-Making Processes. Proven ability to communicate Complex Findings in a clear and accessible manner to both technical and Non-technical Stakeholders. Passionate about leveraging Data to Drive Business growth and support Strategic initiatives.
Experience
Senior Associate Data Analyst
<p>Collect, analyze data and provide in-depth reports showing market trends, key reference points<br>
Excellent secondary research skills including efficient use of paid/free databases and other industry associations / websites<br>
Assist in guiding and analyzing research requests on key supply markets using a prescribed supply market research process in each business/domain<br>
Providing Strategic, Analytic & Reporting (MIS) support to Global Service Centers and S&L across regions<br>
Proficient in providing SAP Reports, Spend Analysis & Internal SLA MIS reporting<br>
Competent in Analysis & Judgment, Customer Relationship Management, MIS, BI tools & Microsoft Excel<br>
Have basic Supply Chain knowledge<br>
With Microsoft SQL server and SQL based queries<br>
Running scheduled production queries/reports<br>
Simple SQL query creation<br>
Query Performance tuning & Different types of Temp tables and CTE<br>
Moderate MS SQL skills, able to evaluate SQL statements involving numerous tables and joins<br>
Experience in maintaining and modifying ETL and stored procedures<br>
Able to utilize SQL functions, user defined functions, views, triggers, and other common database objects<br>
Closely work with Internal and External stakeholders in order to calibrate/support & execute the Analytics & Reporting activities within Global Service Centre’s and S&L</p>
Senior Associate Data Analyst
Collect, analyze data and provide in-depth reports showing market trends, key reference points. Assist in guiding and analyzing research requests on key supply markets. Providing Strategic, Analytic & Reporting (MIS) support.
Associate Data Analyst
<p>Auto classification of health care resources using python functions and regex<br>
Automating manual workflow and increasing time to market<br>
This work improved SLA for the classification process from 50 minutes to 2 minutes per document<br>
Prepared various BI dashboards in Tableau for month on month insurance business reports<br>
Evaluation and analysis of insurance claims dataset using Excel V-lookup, Chi-square, Normal and T-distribution<br>
Removed outliers using python and Pandas<br>
Help business to decide in dynamic pricing by identifying business insights and forecasting the trends for future months using time series analysis using Excel<br>
Worked closely with the engineering and business team using scrum/agile methodology</p>
Associate Data Analyst
Auto classification of health care resources. Prepared various BI dashboards in Tableau. Evaluation and analysis of insurance claims dataset. Helped business to decide in dynamic pricing. Worked closely with the engineering and business team.
Associate Data Analyst
<p>Downloaded restaurant data from Zomato website for more than 10000 restaurants across India<br>
Ingested this data in SQL database and performed ETL to remove outliers, clean up bad records, normalize revenue numbers to standard format using python, jupyter notebook and two standard deviation along with some other statistical techniques<br>
For analysis of Hyderabad restaurants, used Excel, VBA macros and pivot table<br>
Figured out best restaurants for Telugu and south Indian cuisine based on reviews<br>
Used Tableau and Microsoft Power BI to build various BI dashboards that can show revenue growth in different restaurants based on cuisine, how people’s preferences have changed over a period of 5 years<br>
Prepared a data story and presented that in our annual meeting data</p>
Associate Data Analyst
Downloaded restaurant data from Zomato website. Ingested data in SQL database. Prepared data for analysis. Used Excel, VBA macros, pivot table, Tableau and Microsoft Power BI to build BI dashboards.
Team Lead
<p>Assisting and coordinating with sales and marketing team<br>
Attaining Daily, Weekly and Monthly targets specified by the Process<br>
Conveying the Client requirements to the team with regards to the Process<br>
Supporting sales staff in handling and documenting customer accounts<br>
Documentation and reporting to the marketing department<br>
Analytic & Reporting (MIS), Advanced Excel, Pivot Table, VLOOKUP, Data Entry & Computer Operator</p>
Team Lead
Assisting and coordinating with sales and marketing team. Attaining Daily, Weekly and Monthly targets. Conveying Client requirements to the team. Supporting sales staff.