نبذة عني
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.
الخبرة
Senior Associate Data Analyst
Collect, analyze data and provide in-depth reports showing market trends, key reference points
Excellent secondary research skills including efficient use of paid/free databases and other industry associations / websites
Assist in guiding and analyzing research requests on key supply markets using a prescribed supply market research process in each business/domain
Providing Strategic, Analytic & Reporting (MIS) support to Global Service Centers and S&L across regions
Proficient in providing SAP Reports, Spend Analysis & Internal SLA MIS reporting
Competent in Analysis & Judgment, Customer Relationship Management, MIS, BI tools & Microsoft Excel
Have basic Supply Chain knowledge
With Microsoft SQL server and SQL based queries
Running scheduled production queries/reports
Simple SQL query creation
Query Performance tuning & Different types of Temp tables and CTE
Moderate MS SQL skills, able to evaluate SQL statements involving numerous tables and joins
Experience in maintaining and modifying ETL and stored procedures
Able to utilize SQL functions, user defined functions, views, triggers, and other common database objects
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
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
Auto classification of health care resources using python functions and regex
Automating manual workflow and increasing time to market
This work improved SLA for the classification process from 50 minutes to 2 minutes per document
Prepared various BI dashboards in Tableau for month on month insurance business reports
Evaluation and analysis of insurance claims dataset using Excel V-lookup, Chi-square, Normal and T-distribution
Removed outliers using python and Pandas
Help business to decide in dynamic pricing by identifying business insights and forecasting the trends for future months using time series analysis using Excel
Worked closely with the engineering and business team using scrum/agile methodology
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
Downloaded restaurant data from Zomato website for more than 10000 restaurants across India
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
For analysis of Hyderabad restaurants, used Excel, VBA macros and pivot table
Figured out best restaurants for Telugu and south Indian cuisine based on reviews
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
Prepared a data story and presented that in our annual meeting data
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
Assisting and coordinating with sales and marketing team
Attaining Daily, Weekly and Monthly targets specified by the Process
Conveying the Client requirements to the team with regards to the Process
Supporting sales staff in handling and documenting customer accounts
Documentation and reporting to the marketing department
Analytic & Reporting (MIS), Advanced Excel, Pivot Table, VLOOKUP, Data Entry & Computer Operator
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.