Syed Liyakath Ali

Syed Liyakath Ali

Data Analyst
India

About Me

Certified Data analyst with 5+ years of Experience and strong background in data manipulation and reporting, Dashboarding Skills. Proficient in SQL, Adv Excel, Power Query, and Python, Pandas, Numpy, Matplotlib, ETL, Pow…

Experience

Data Analyst

IntouchCX
Oct 2023 - Present · 2 years 8 months

Collected and organized large data sets from various sources like Super Punch, SAP, NICE, Excel.
• Performed data preprocessing and transformation to ensure data accuracy and consistency using Power Query.
• Identified patterns and trends in data to inform business decisions.
• Performed Data Audit , Report Discrepencies and Timely Resolve Issues.
• Automated Reports using SAP Business Intelligence, Power Query.
• Building,Maintaining reports and dashboards that provide key performance indicators (KPIs) for different operational areas.
• Present findings to stakeholders through clear and concise reports, visualizations, and presentations.
• Interacting with Clients and Working closely on Analytics Requirements and Improvements.
• Worked closely with cross-functional teams to understand business objectives and data requirements

Data Analyst

IntouchCX
Oct 2023 - Present · 2 years 9 months

Collected and organized large data sets from various sources like Super Punch, SAP, NICE, Excel.
Performed data preprocessing and transformation to ensure data accuracy and consistency using Power Query.
Identified patterns and trends in data to inform business decisions.
Performed Data Audit, Report Discrepencies and Timely Resolve Issues.
Automated Reports using SAP Business Intelligence, Power Query.
Building,Maintaining reports and dashboards that provide key performance indicators (KPIs) for different operational areas.
Present findings to stakeholders through clear and concise reports, visualizations, and presentations.
Interacting with Clients and Working closely on Analytics Requirements and Improvements.
Worked closely with cross-functional teams to understand business objectives and data requirements.
Investigate and Deep Dive to Resolve Data Quality issues.

Data Analytics - Technical Engineer

Skill-Lync
Jul 2022 - Aug 2023 · 1 year 1 month

Accomplished database development tasks like developing tables, CTE, Views, Scripted SQL queries for retrieving data from multiple tables.
Developed tables with required fields for Key Performance Indicators (KPI) reporting, which saved time spent on data extraction and cleaning of huge datasets around 1.5M rows.
Conducted data mining and accomplished ETL, to transform data in power BI query editor using various DAX measures, calculated columns and developed efficient star schema data models, by collecting data from different data sources like SQL server, Excel, Datawarehouse.
Evaluation and analysis of data by detecting, removing anomalies which prevented assumption of false insights.

Junior Data Analyst

Sid Consultants
Jul 2017 - Jul 2021 · 4 years

Worked on Sales projects, creating dashboards which highlights trends in sales, profit-loss metrics, across regions and find out touch points.
Building Monthly, Quarterly, yearly reports and Monitoring KPI, ETL data from various sources, Data Mining, Data validation.
Evaluation and analysis of data by detecting, removing anomalies which prevented assumption of false insights.
Developed monthly Power BI reports and dashboards with KPI trends and which resulted in 40% increase towards sales target and customers count.

Skills

Analytics Data Analysis Professional Information Systems Management Data Mining Microsoft Access Statistical Analysis System (SAS) Structured Query Language (SQL) Data Representation Data Analysis Skills Power BI R Programming Language (R) Tableau Python DAX Excel SAP BI SQL Server Mongo DB Snowflake Power Query SSIS Azure Data Factory Azure Storage ADF Azure Synapse Linear Algebra Statistics Machine Learning Data Modelling Forecasting A/B Testing Diagnostic Analytics Clear Communication Critical Thinking Problem Solving Collaboration Team Work
Report this Profile?