Data Analyst Analysis

Iqra Shazia

Email: *************@*****.***

Mobile: +1-475-***-****

Data Analyst

PROFESSIONAL SUMMARY:

Over 5 years of experience as a Data Analyst with expertise in analytical thinking, attention to detail, and innovative problem-solving, delivering actionable insights across industries. Adept at connecting dots across applications and businesses to understand the end-to-end view, ensuring comprehensive solutions.

Proficient in query tools, including strong PL/SQL skills for writing and analyzing complex queries and stored procedures, supporting data analysis and strategic decision-making. Expertise with Microsoft Office suite usage for effective communication.

Proven expertise in exploratory data analysis, cleaning, and processing large datasets to identify trends, patterns, and anomalies, while applying an analytical mindset to support organizational goals. Good at identifying priorities.

Strong aptitude for translating complex business requirements into efficient technical solutions, working well in a team environment with minimal supervision, and managing multiple projects simultaneously. Willingness to ask questions.

Built interactive dashboards enabling real-time monitoring of key performance indicators and driving data-informed decision-making, while possessing strong communication and presentation skills for technical and non-technical audiences.

Hands-on experience designing, developing, and managing data pipelines, demonstrating know-how in effort and financials estimation for project planning and resource assignments. Experience with Oracle Exadata or 10g and above.

Implemented secure practices, ensuring compliance with data governance and regulatory frameworks, while demonstrating the ability to effectively communicate across the organization depending on the audience. Team player.

Developed automated ingestion frameworks that enhanced data freshness, improved operational efficiency, and reduced data latency, showcasing innovative thinking skills and a commitment to continuous improvement. Agile mindset.

Built predictive models and delivered real-time analytics, driving critical business insights and forecasting capabilities, while demonstrating proficiency in connecting dots across various applications. Team player.

Designed real-time streaming pipelines, enhancing the timeliness and reliability of data for downstream analytics and business intelligence, while demonstrating attention to detail and problem-solving skills. Agile mindset.

Managed highly scalable datasets through advanced techniques to optimize performance and cost-efficiency, while demonstrating expertise in analytical thinking and a commitment to delivering measurable outcomes. Team player.

Created optimized ETL workflows using data orchestration tools to ensure data accuracy, consistency, and minimal system downtime in production environments, while demonstrating strong PL/SQL skills. Agile mindset.

Integrated third-party APIs to enrich datasets with external insights and support enhanced reporting and machine learning use cases, while demonstrating proficiency in connecting dots across various applications. Team player.

Regularly contributed to Agile/Scrum project environments using Jira for sprint planning, backlog refinement, and cross-functional collaboration to meet delivery timelines and stakeholder expectations. Agile mindset.

Versatile experience working across banking, healthcare, and e-commerce sectors, applying data analytics to drive process improvements and strategic business outcomes, while demonstrating innovative thinking skills. Team player.

Excellent communication skills with the ability to clearly present technical findings and recommendations to non-technical stakeholders and executive leadership, while demonstrating proficiency in Microsoft Office suite usage.

Detail-oriented and committed to continuous improvement, consistently upskilling in new tools and frameworks to stay current with evolving data trends and best practices, while demonstrating analytical thinking skills. Agile mindset.

Collaborative team player who can influence and guide the team for success, thriving in dynamic environments, proactively contributing to shared objectives and organizational success through data-led initiatives. Team player.

Delivered value by supporting enterprise-level data initiatives with well-documented analysis, measurable outcomes, and practical recommendations grounded in rigorous data exploration, while demonstrating attention to detail. Agile mindset.

TECHNICAL SKILLS:

Languages - SQL, Python, R, HTML, CSS, PL/SQL

Tools - Power BI, Tableau, Excel, Jupyter, VS Code, GitHub, Microsoft Office

Databases - MySQL, PostgreSQL, BigQuery, Oracle Exadata, Oracle 10g

Cloud Platforms - Google Cloud Platform (GCP), AWS (basic)

Other - Jira, Confluence, Git, Agile & Scrum methodologies

PROFESSIONAL EXPERIENCE:

M&T Bank May 2023 – Present

Data Analyst

Responsibilities:

Demonstrated expertise in analytical thinking by developing automated Power BI dashboards, enabling stakeholders to track real-time KPIs and enhance decision-making across various teams, showcasing innovative thinking skills. This involved strong communication and presentation skills to both technical and non-technical audiences.

Utilized strong PL/SQL skills to craft complex queries for extracting, transforming, and loading structured data from enterprise data warehouses, supporting scalable analytics solutions and operational dashboards, demonstrating attention to detail. This required proficiency in connecting dots across applications.

Collaborated within Agile/scrum teams to define key metrics, establish standardized data definitions, and align on data quality benchmarks for consistent enterprise reporting, showcasing problem-solving skills. This involved identifying priorities and managing multiple projects simultaneously.

Spearheaded GCP migration of analytics workflows from on-premises infrastructure to BigQuery, optimizing SQL scripts and transforming legacy systems for cloud-native performance and reliability, demonstrating innovative thinking skills. This required willingness to ask questions.

Led recurring stakeholder sessions to define metric interpretations, ensure consistency in terminology, and align business units on data usage, KPIs, and performance dashboards, showcasing strong communication skills. This involved working well in a team environment.

Managed version control and collaboration tools like Git and Confluence to document workflow changes, maintain reproducibility, and provide robust onboarding resources for analysts and data engineers, demonstrating attention to detail. This required minimal supervision.

Improved BigQuery query performance by over 30% through applying best practices in partitioning, clustering, and SQL optimization, resulting in faster reporting and reduced cloud resource costs, showcasing problem-solving skills. This involved know-how effort and financials estimation.

Conducted GCP and BI platform training for business users, increasing user independence, improving adoption rates, and enabling self-service analytics for real-time access to decision-critical insights, demonstrating strong communication skills. This required proficiency with query tools.

Supported data governance initiatives by enriching metadata, tagging data assets, and enhancing catalog accuracy to promote transparency, trust, and discoverability across analytics systems, showcasing attention to detail. This involved ability to write and analyze complex queries.

Integrated real-time financial datasets using external APIs to enhance reporting capabilities, drive up-to-date analysis, and improve monitoring of operational performance and investment risks, demonstrating expertise in analytical thinking. This required strong PL/SQL skills.

Northwell Health May 2022 – April 2023

Data Analyst

Responsibilities:

Created interactive dashboards and predictive models using Looker and Power BI to analyze claims data, enabling improved cost forecasting and optimized clinical decision-making, showcasing innovative thinking skills. This involved strong communication and presentation skills.

Led comprehensive data quality audits across healthcare claims workflows, improving data accuracy, identifying inconsistencies, and ensuring compliance with regulations, demonstrating attention to detail. This required proficiency in connecting dots across applications.

Collaborated with actuarial teams to build statistical models, identify key cost drivers, and support data-driven financial forecasting initiatives using historical claims data, showcasing problem-solving skills. This involved identifying priorities and managing multiple projects.

Managed scalable data pipelines using Google Cloud tools like BigQuery and Dataflow, streamlining real-time data ingestion, processing, and transformation across multi-source datasets, demonstrating innovative thinking skills. This required willingness to ask questions.

Developed centralized data repositories and established access control protocols, ensuring secure storage, standardized schema definitions, and compliance with healthcare data regulations, showcasing strong communication skills. This involved working well in a team environment.

Refactored existing GCP pipelines and queries, improving performance by 40% through query optimization, resource scaling, and streamlined transformation logic across large volumes of datasets, demonstrating attention to detail. This required minimal supervision.

Built patient segmentation models in BigQuery ML, helping population health teams identify high-risk patients, tailor outreach strategies, and predict future healthcare utilization patterns, showcasing problem-solving skills. This involved know-how effort and financials estimation.

Worked closely with engineering teams to enhance ETL efficiency, restructured job dependencies, and automated error handling to increase pipeline stability and reduce manual intervention requirements, demonstrating strong communication skills. This required proficiency with query tools.

Automated daily reports and dashboards for risk stratification, providing clinical teams with actionable insights on patient severity, comorbidities, and intervention prioritization in real-time, showcasing attention to detail. This involved ability to write and analyze complex queries.

Conducted root cause analysis on claims discrepancies, traced data anomalies to source systems, and collaborated with IT teams to implement long-term corrective measures for data integrity, demonstrating expertise in analytical thinking. This required strong PL/SQL skills.

Amazon August 2019 – July 2021

Data Analyst

Responsibilities:

Built dynamic customer behavior dashboards using Power BI and SQL, enabling marketing teams to assess campaign effectiveness and engagement metrics, showcasing innovative thinking skills. This involved strong communication and presentation skills to technical audiences.

Analyzed sales funnel performance data to identify high drop-off stages, collaborated with product teams to redesign workflows, and improved customer conversion rates, demonstrating attention to detail. This required proficiency in connecting dots across applications.

Defined marketplace KPIs in partnership with product managers, standardizing performance metrics to ensure consistency across regional dashboards and decision-making processes, showcasing problem-solving skills. This involved identifying priorities and managing projects.

Conducted in-depth pricing analysis across multiple product categories, helping business leaders identify pricing gaps, competitor trends, and opportunities for margin optimization, demonstrating innovative thinking skills. This required willingness to ask questions.

Designed and executed SQL queries to monitor seller performance, flag non-compliance issues, and track key metrics including order fulfillment and customer satisfaction, showcasing strong communication skills. This involved working well in a team environment.

Developed complex Excel-based models for demand forecasting and inventory optimization, reducing stockouts and improving planning accuracy for high-demand SKUs, demonstrating attention to detail. This required minimal supervision and strong PL/SQL skills.

Automated repetitive reporting processes using Python scripts, increasing analyst productivity and reducing delivery time for weekly and monthly stakeholder reports, showcasing problem-solving skills. This involved know-how effort and financials estimation.

Contributed to global analytics best practices repository by sharing reusable dashboards, SQL snippets, and documentation for cross-regional knowledge transfer, demonstrating strong communication skills. This required proficiency with query tools and Oracle Exadata.

Worked on SQL query performance tuning by restructuring joins, optimizing indexes, and applying partitioning strategies to accelerate reporting across large datasets, showcasing attention to detail. This involved ability to write and analyze complex queries.

Performed segmentation and cohort analysis to identify behavior patterns, assess lifetime value, and support customer retention strategies across various demographic clusters, demonstrating expertise in analytical thinking. This required strong PL/SQL skills.

Educational Details:

M.S. in Computer Science - University of Bridgeport, CT

B.Tech in Computer Science - Keshav Memorial Institute of Technology, India

Contact this candidate