Systems Analyst Data

PRANAV ANAND

Systems Analyst

Irving, Texas +1-214-***-**** Email: ***********.*****@*****.***

SUMMARY

Systems and Data Analyst with 4+ years of experience streamlining workflows, managing data systems, and delivering scalable analytics solutions across AWS, Azure, and GCP. Skilled in building ETL pipelines, developing Power BI dashboards, and tracking KPIs to improve operational and compliance performance. Strong in data validation, internal controls, and using SQL, SharePoint, and Adobe Acrobat to support documentation and audit readiness. Adept at collaborating across IT and business teams to enhance system reliability and enable data-driven decision-making.

SKILLS

Data Integration & ETL: Apache Airflow, AWS Glue, Azure Data Factory, Databricks, Apache Spark, dbt, CDC, Shell Scripting, Python

Data Platforms & Warehousing: Amazon Redshift, Snowflake, Azure Synapse Analytics, Delta Lake, ADLS Gen2, Amazon S3, GCP

Programming & Querying: SQL, Python, Spark SQL, PySpark

Data Visualization & Reporting: Power BI (DAX, Power Query), Tableau (basic), KPI Dashboards, SLA Tracking

Data Governance & Quality: AWS Glue Data Catalog, Azure Purview, Data Lineage, Schema Enforcement, SLA Monitoring

Orchestration & DevOps: Apache Airflow, Jenkins, Git, Docker, Terraform, CI/CD Pipelines

Streaming & Big Data: Apache Kafka, Structured Streaming, Amazon Kinesis (basic)

Documentation & Collaboration Tools: SharePoint, Adobe Acrobat, Confluence, Jira

EHS & Compliance Tools: EHS Assistant, AMP, ATG

EXPERIENCE

Systems & Data Analyst Verizon, Texas. NOV 2023 - Present

Analyzed and restructured 15+ operational workflows across compliance and reporting teams by mapping manual data flows and recommending automated solutions via ETL pipelines, increasing process efficiency by 35%.

Developed and maintained 40+ ETL pipelines using Apache Airflow and AWS Glue to support EHS-style reporting systems; handled 500+ GB/day of departmental data with 99.8% pipeline reliability.

Integrated AWS Glue and Redshift data systems to power interactive performance dashboards, enhancing EHS incident visibility, trend analysis, and real-time decision-making across cross-functional teams.

Built Power BI datasets and KPI frameworks using Redshift and S3 layers to track real-time operational metrics and Key Effort Indicators (KEIs), improving SLA compliance and reducing audit response times by 25%.

Implemented data quality audits and anomaly detection scripts, ensuring data integrity across critical EHS indicators (incident logs, audits, compliance triggers) with 99%+ validation accuracy.

Maintained documentation and system SOPs using Adobe Acrobat and internal SharePoint repositories, ensuring audit readiness and improving knowledge transfer across IT and operations teams.

Troubleshot and optimized departmental data flows, reducing dashboard load times by 45% and eliminating bottlenecks in data refresh cycles.

Partnered with IT and platform teams to maintain access controls and secure integrations across data sources, aligning with internal compliance and governance protocols.

Junior Data Analyst – Systems Integration Accenture, India. JAN 2019 - DEC 2021

Conducted system analysis across 4 departments to document legacy data collection workflows and identify improvement areas, resulting in the implementation of scalable Azure Data Factory pipelines that reduced manual effort by 40%.

Built and optimized data pipelines using Azure Synapse and Delta Lake for structured logging of compliance audits, safety inspections, and operational KPIs, supporting monthly reporting cycles.

Standardized KPI reporting logic by creating modular data models and layered zone architecture (bronze, silver, gold), enabling consistent metric tracking across departments.

Collaborated with stakeholders to improve instrumentation and data collection coverage, enhancing audit accuracy and reducing data discrepancies by 30%.

Established column-level lineage and data governance using Azure Purview, streamlining audit requests and enhancing traceability during quarterly compliance reviews.

Authored validation frameworks and onboarding documentation, reducing pipeline deployment time by 50% and supporting training of new analysts and engineers.

Maintained internal reporting repositories and dashboards using SharePoint and documented processes with Adobe Acrobat, contributing to internal control adherence and smooth onboarding for new team members.

Academic Project

End-to-End Scalable Data Pipeline for Predictive Modeling May 2023 - JUN 2023

Built an ETL pipeline using Python and Pandas to ingest and preprocess structured data.

Performed EDA and feature engineering; trained classification model with 85%+ accuracy.

Developed version-controlled ingestion and transformation scripts, simulating enterprise-grade data wrangling and reconciliation logic.

Implemented validation checks for schema mismatches, missing values, and outliers.

EDUCATION

Campbellsville University, Campbellsville, KY. Dec 2023

Master of Science – Computer Science, GPA: 4.0/4.0

Sphoorthy Engineering College, Hyderabad, India. JUL 2021

Bachelor of Technology – Computer Science and Engineering, GPA: 3.2/4.00

CERTIFICATIONS & TRAINING

Microsoft Certified: Azure Database Administrator Associate (2024)

Microsoft Certified: Power BI Data Analyst Associate (2025)

Databricks Accredited: Databricks Fundamentals – Databricks Academy (2025)

Contact this candidate