Syed Mohammed Ali

Syed Mohammed Ali

I am Skilled in Power BI, Python, SQL, MySQL, Data Mining and Statistical Analysis, Advanced Excel, Tableau, Excel Ch...
India
Hindi, English

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…

Experience

Senior Associate Data Analyst

Corteva Agriscience Pvt Ltd. (On the 3rd Party Payroll of Quess Corp. Pvt Ltd), Hyderabad
Jul 2022 - Jun 2023 · 11 months

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

Corteva Agriscience Pvt Ltd. (On the 3rd Party Payroll of Quess Corp. Pvt Ltd)
Jul 2022 - Jun 2023 · 11 months

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

NEUERA AI Software & Analytics, Hyderabad
Jul 2020 - Mar 2022 · 1 year 8 months

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

NEUERA AI Software & Analytics
Jul 2020 - Mar 2022 · 1 year 7 months

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

TechZone IT Services & Analytics, Hyderabad
Apr 2019 - Jun 2020 · 1 year 2 months

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

TechZone IT Services & Analytics
Apr 2019 - Jun 2020 · 1 year 2 months

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

SMS FINANCIAL SERVICES Pvt Ltd. (Accounting Firm), Hyderabad
Jan 2013 - Mar 2019 · 6 years 2 months

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

SMS FINANCIAL SERVICES Pvt Ltd. (Accounting Firm)
Jan 2013 - Mar 2019 · 6 years 1 month

Assisting and coordinating with sales and marketing team. Attaining Daily, Weekly and Monthly targets. Conveying Client requirements to the team. Supporting sales staff.

Skills

Microsoft Office Python Structured Query Language (SQL) Alteryx Attention to Detail Critical Thinking Data Extraction Data Processing Data Validation NumPy SciPy Data Visualization Web Scraping Machine Learning Tableau Statistical Analysis Data Mining MySQL MS Excel Pivot Table VLOOKUP Conditional Formatting Regex Chi-square Normal distribution T-distribution Time series analysis Scrum Agile ETL Stored procedures SQL functions User defined functions Views Triggers Query performance tuning Temp tables CTE SAP Reports Spend Analysis MIS reporting
Report this Profile?