Syed Shoaib Ahmad

Syed Shoaib Ahmad

Data Analyst
UAE
English, Hindi, Urdu

نبذة عني

Bringing four years of professional experience, I have specialized for the past four years as a Data analyst Engineer. My focus is on implementing data-driven solutions to elevate business efficiency through the applicat…

الخبرة

Data Analyst

TCS, New Delhi India
Oct 2026 - Aug 2026 · 2 أشهر

<p>Developed a python script to extract sales data from a SQL database.<br>
Mechanized data cleaning and transformation using pandas.<br>
Stored cleaned data in excel for manual checks.<br>
Used Power BI to visualize sales trends and KPIs.<br>
Deployed the pipeline using DevOps for scheduled updates.<br>
Pulled data from SQL databases using queries to analyze operational performance metrics.<br>
Used Power BI to visualize KPIs and trends, creating interactive dashboards for management.<br>
Integrated Python scripts within Power BI to perform advanced data analysis and transformations.<br>
Deployed and shared the dashboard through SharePoint for company-wide access.<br>
Established a Power BI dashboard to monitor and visualize DevOps metrics like build status, code quality, and deployment frequency.<br>
Systematized data collection using python scripts to extract data from DevOps tools and store it in SQL databases.<br>
Linked the dashboard with ServiceNow for real-time incident reporting and issue tracking.<br>
Shared the dashboard with key stakeholders via SharePoint for transparency and feedback.<br>
Extracted ServiceNow incident and change request data using python scripts.<br>
Performed data analysis using SQL to generate reports on IT service performance.<br>
Visualized results in Power BI, creating interactive reports on service trends and incident resolution times.<br>
Published the reports via SharePoint, ensuring easy access for IT managers.<br>
Developed an automated system in Python to track user access levels across Active Directory.<br>
Analyzed data using SQL to identify inactive or unauthorized users and created reports.<br>
Integrated with ServiceNow for incident management and automated notifications for compliance breaches.<br>
Ensured continuous compliance and governance through Active Directory monitoring.<br>
Utilized Python to scrape financial data from external sources and clean it for analysis.<br>
Stored and managed this data in a SQL database, performing complex queries to derive key financial insights.<br>
Generated a Power BI dashboard to track financial KPIs such as revenue, expenses, and profit margins over time.<br>
Built Financial forecasting models in python, incorporating historical trends and predictive analytics.<br>
Generated Excel reports based on SQL query outputs for finance teams to analyze in detail, with the Power BI dashboard offering a high-level view for executives.</p>

Data analyst associate

Axxeluss Mavens, New Delhi India
Aug 2026 - Jul 2026 · 1 شهر

<p>Integrated ServiceNow data for IT service requests.<br>
Used Active Directory to map users to departments.<br>
Initiated an interactive dashboard using Power BI.<br>
Set up Python scripts for automated data refresh.<br>
Shared results and reports via SharePoint for team collaboration.</p>

Senior Data Analyst & Analytics Team Lead

Twinings · Remote / UK-aligned
Jan 2025 - Mar 2026 · 1 سنة 2 أشهر

<p>Led a cross-functional analytics pod supporting Global Process Owners (GPOs); instituted agile sprint rhythms, technical reviews, and standardized Power BI/SQL development best practices across 5+ countries.<br>
Served as strategic analytics partner to senior GPO executives; translated ambiguous operational challenges into structured business problem solving frameworks, measurable KPI trees, and data architectures.<br>
Reverse-engineered legacy SAP ERP business logic and complex ABAP/reporting routines into performance-tuned SQL data manipulation scripts and unified data models hosted on SAP Cloud Server and Snowflake.<br>
Architected enterprise-grade Power BI dashboards and SAP Analytics Cloud (SAC) reporting suites; engineered complex DAX measures, automated Power Query M-scripts, and intuitive visual storytelling layouts for executive presentations.<br>
Streamlined IT service and project tracking by extracting operational logs from ServiceNow, Jira, and SharePoint lists into centralized SQL staging tables, revealing workflow bottlenecks and boosting delivery velocity.<br>
Championed an AI-first workflow utilizing Copilot and LLM prompt patterns for accelerated query design, DAX debugging, automated technical documentation, and metadata catalogs.</p>

Freelance Geospatial Data Analyst

Peroptyx · Dubai, UAE
Aug 2024 - Nov 2024 · 3 أشهر

<p>Executed advanced SQL queries and high-volume Excel data manipulations to analyze and audit multi-region geospatial POI and routing feeds, boosting map search precision for global users.<br>
Authored comprehensive data validation benchmarks and error taxonomy documentation to maintain high standards of geographic entity classifications.</p>

Data Analyst → Senior Data Analyst

Tata Consultancy Services (TCS) · India
Aug 2021 - May 2024 · 2 سنوات 9 أشهر

<p>Designed star-schema dimensional data models on Snowflake and Azure Synapse, migrating legacy relational warehouses to enhance query throughput by 40% and cut cloud compute costs by 25%.<br>
Engineered automated SQL ETL pipelines and feature engineering routines processing 10M+ daily banking transactions, integrating anomaly-detection AI models that drove a 15% increase in fraud detection accuracy.<br>
Developed executive Power BI reporting dashboards and multi-scenario Excel financial models for Sales & Marketing stakeholders, delivering strategic insights that spurred a 23% revenue uplift.<br>
Trained 4+ junior analysts in SQL optimization, Power Query, and DAX; authored reusable report templates and documentation reducing onboarding cycle times by 35%.</p>

Associate Data Analyst

Axxelus Mavens · India
Jul 2020 - May 2021 · 10 أشهر

<p>Partnered with clinical leadership to solve patient readmission and inventory shortage issues using SQL queries and Excel forecasting models, achieving an 8% drop in readmissions and 17% reduction in medication shortages.<br>
Replaced disparate spreadsheets with automated Power Query and SQL pipelines, saving over 20 hours per week of manual reporting overhead.</p>

المهارات

Python Pandas Scikit-learn NumPy Java SQL C++ Power BI Excel Google Sheets Matplotlib Tableau AWS GCP Azure Azure Data Lake Azure Synapse Analytics Azure SQL Database Continuous Integration CI/CD Jupyter Notebook Power BI Desktop Power BI Server ServiceNow Identity Management SharePoint Active Directory DAX Power Query SAP Analytics Cloud Power Pivot VBA Advanced Formulas T-SQL PL/SQL Stored Procedures Query Optimization Data Manipulation Snowflake SAP Cloud Server Azure Synapse Cloud Data Warehousing Dimensional Data Modelling Star Schema Snowflake Schema Reverse Engineering ETL ELT Data Validation Schema Design Generative AI Copilots Model Context Protocol Jira Stakeholder Management Business Problem Solving Technical Documentation Agile Delivery Team Leading Presentation
الإبلاغ عن هذا الملف الشخصي؟