Home

Mohammed Zeeshan Ali - Data Analyst

[email protected]

Location: Atlanta, Georgia, USA

Relocation:

Visa: H1B

MOHAMMED ZEESHAN ALI Contact: +1 551-226-3838 Email: [email protected] LinkedIn: linkedin.com/in/mza01 PROFESSIONAL SUMMARY Over 5+ years of professional experience as a Data Analyst with strong exposure to Transportation, Retail and Healthcare industries Expertise in all stages of data cycle which involves Data research/exploration, acquisition, data modelling, data cleansing, processing, analyzing and Visualizing Highly Motivated Leader, Quick Learner and Curious thinker with strong Analytical & Logical reasoning Experienced in building ETL data pipelines combining data from different sources which are in different formats into a single entity and managing data integration tasks, resulting in improved processing efficiency and reduced latency. Created advanced reports and dashboards in visualization tools like Tableau, Power BI and presented the data findings and insights developed to multitude of business stakeholders including executives and assisted them in taking informed business decisions Proficient with Snowflake, Teradata, UNIX, SQL, SQL Server, and AWS. Experienced in using JIRA for support ticket management and agile project facilitation. Demonstrated ability to lead and mentor teams, improve operational efficiency, and implement automation to streamline tasks. Skilled in diagnosing and resolving complex data issues, leading to significant reductions in system downtime and resolution times. Proficient in optimizing long running queries and stored procedures for effective data retrieval, improving performance and reducing costs to the organization Translated complex business requirements gathered from different stakeholders across teams into Business Requirement Document (BRD), Functional Specification Document (FSD), use case document and business logic flow charts Experienced in both Agile and waterfall methodologies and lucid understanding of all phases of SDLC Qualified professional with a master s degree in information systems with specialization in Data Science from Pace University TECHNICAL SKILLS Programming Advanced SQL| Teradata SQL| Python| Unix | Snowflake SQL | R | PySpark Databases Microsoft SQL Server |Teradata | MySQL Tools Informatica Power center| SQL Workbench | Jira | Tableau Server | Tableau Desktop| Power BI | MS PowerPoint | BitBucket | MS Excel Cloud AWS IAM, S3, Cloud Watch, Lambda | Azure Teradata, Databricks | Snowflake, Snowflake SQL Data Skills Data Modelling | Data Profiling | Data Analysis | ETL | Query Optimization |Data Archiving Algorithms Regression | Classification | Clustering | Hypothesis Testing | Neural Prophet PROFESSIONAL EXPEREINCE Senior Data Analyst Feb 2023 Present Client: Anthem Inc (Elevance Health), Atlanta, GA Responsibilities: Evaluated and optimized relationships between Anthem members and 500+ contracted providers, enhancing affinity matching and visit pattern analysis. Supervised the performance of application loads handling over 1 million records daily, ensuring 99.9% system uptime and efficient data management. Diagnosed and addressed 150+ complex data-related issues per month, implementing short-term fixes that reduced system downtime by 30%. Spearheaded 20+ SWAT calls to resolve critical issues, collaborating with cross-functional teams to deploy immediate solutions and reduce issue resolution time by 40%. Oversaw ad hoc file loading from various environments into S3 buckets, handling datasets up to 500 GB as needed, and utilizing AWS to run integration jobs for system updates. Enhanced ETL scripts and data pipelines, increasing processing efficiency by 25% and reducing data latency by 15%. Led and mentored a team of 10 offshore analysts, providing insights and recommendations that improved team performance and operational efficiency by 20%. Directed offshore analysts to develop automated email notifications for daily variance reporting and to eliminate redundant manual tasks, resulting in a 35% reduction in repetitive work and increased operational efficiency. Utilized Snowflake, Teradata, UNIX, SQL, SQL Server, and AWS to support data management and ensure robust application functionality. Managed and resolved 200+ support tickets per month using JIRA, delivering detailed root cause analysis and impact assessments to maintain stakeholder satisfaction. Updated tickets with root cause analysis, resolutions, and impact assessments, enhancing stakeholder communication and decision-making efficiency by 30%. Worked with 15+ business users to address and resolve their issues, providing data-driven solutions that improved operational efficiency and decision-making processes. Identified and implemented 10+ process improvements, contributing to a 15% increase in data handling efficiency and better alignment of member-provider relationships. Environment: SQL, ETL, AWS, Unix, Jira, Snowflake, Teradata, Informatica PowerCenter Data Analyst July 2022 Jan 2023 Metropolitan Transportation Authority (MTA), New York, NY Responsibilities: Collaborated with a development team to enhance the functionality of the LIRR Train Time application by integrating predictive modeling techniques, leading to a 15% improvement in forecast accuracy. Collected and processed over 5,200,000 observations of runtime data from the LIRR Train Time application (2020-2022). Executed data cleaning and preprocessing on the Azure cloud platform, reducing data inconsistencies by 30%. Reorganized runtime data using PySpark, merged train schedules, and investigated delays across 50+ branches. Identified and analyzed factors contributing to delays, resulting in a 10% reduction in average delay times. Utilized Python for data analysis and manipulation. Implemented Neural Prophet for predictive modeling, developed 20 supervised regressive models to forecast passenger counts and station crowd levels. Integrated the most accurate model, improving crowd prediction accuracy by 20%. Explored and visualized operational data on train hardware conditions with PySpark and Plotly. Diagnosed maintenance issues, leading to a 25% improvement in predictive maintenance accuracy and a 15% reduction in unplanned hardware failures. Produced detailed reports and visualizations that communicated findings and recommendations to stakeholders, resulting in a 20% increase in data-driven decision-making Environment: PySpark, Python, SQL, Azure Databricks, Machine Learning, Shell scripting Data Analyst Feb 2022 July 2022 CIEK Solutions, East Hanover, NJ Responsibilities: Collaborated with the Product Owner to enhance a scorecard reporting application by integrating data from upstream systems, resulting in a 20% increase in report accuracy. Executed data cleaning and profiling tasks using Python and SQL, improving data integrity and consistency by 25% for downstream reporting. Utilized data from various source systems to generate and format over 100 reports monthly in Excel, streamlining the distribution process and reducing report preparation time by 30%. Supported the development team by identifying and resolving over 50 application failures and data inconsistencies, enhancing system reliability and reducing downtime by 15%. Monitored data quality and implemented corrective actions, leading to a 15% improvement in overall reporting accuracy and ensuring timely delivery of critical business insights. Environment: Python, MS Excel, SQL, Tableau Data Analyst Sep 2020 Dec 2020 AOHR, Hyderabad, India Responsibilities: Performed data profiling and analysis using SQL queries and Informatica IDQ tool, enhancing data quality and consistency across various systems. Developed comprehensive mapping documents to illustrate data flow from source to target, incorporating various transformations and joins between multiple tables. Maintained reference data to standardize data across disparate sources, improving data uniformity and reducing discrepancies by 20%. Created visually impactful dashboards in Excel using pivot tables and VLOOKUP, and prepared PowerPoint presentations to effectively communicate data insights and findings. Produced basic Tableau reports and dashboards for stakeholder reviews, providing valuable visualizations to support decision-making. Provided post-production support for application issues, utilizing JIRA to create and track user stories, resolving over 30 issues and ensuring smooth application performance. Collaborated with the Scrum Master, facilitating agile processes and ensuring timely delivery of project milestones. Environment: Jira, SQL, MS Excel, MS PowerPoint, Tableau Junior Analyst Nov 2019 Aug 2020 Primoris Systems India Private Limited, India Responsibilities: Raised 100+ successful effects with supporting test documentation and effectively coordinated with onsite development teams and assisted in resolving it within a span of a year Formatted, Cleansed and consolidated healthcare data from 3 disparate inbound systems into a single entity using advanced joins, sub queries and transformed it as per requirements for business understanding Completed 100+ ad hoc data requests which include complex data pulls from different sources and granularity, and analyzed it to answer questions from Business Principals and senior executives in a timely manner and assisted in making important business decisions Identified ways to optimize the Formulary tool in MS Excel by automatically populating fields using stored procedures in MS SQL thereby increasing efficiency by 18% Optimized long running queries and stored procedures for effective data retrieval and improved its performance which eventually improved efficiency by 30% Hands-on experience in Jira, AWS S3, Cloud watch, IAM during the initial Infrastructure design phase of a new data mastering product Environment: AWS, SQL, SQL Server, PowerBi, ETL, SQL Workbench EDUCATION Masters of Information Systems from Pace University, 2022, New York, NY Bachelors of Engineering in Electronics and Communication from New Horizon College of Engineering, 2020, India. Keywords: business intelligence sthree active directory rlang information technology microsoft Georgia New Jersey New York