Data Analyst - SQL, Python, BI Dashboards, ETL Automation

JAMMULA SRILAKSHMI

Data Analyst *************@*****.*** +1-862-***-****

PROFESSIONAL SUMMARY

Data Analyst with 3+ years of combined experience in data analytics, business intelligence, and performance reporting across IT services and consulting domains. Proficient in SQL, Python, Power BI, Tableau, and Excel, with expertise in building interactive dashboards, automating ETL pipelines, and performing data modelling for decision support. Strong background in mainframe performance analytics, business requirements gathering, and stakeholder management. Adept at working in Agile environments, ensuring timely delivery of BI solutions, and driving data-driven business decisions. CORE COMPETENCIES

• Data Analytics & Visualization: Power BI, Tableau, Excel (Pivot, VLOOKUP, Macros)

• Programming & Database: SQL, Python (Pandas, NumPy, Matplotlib), SAS, JCL

• Business Analysis: Requirements Gathering, Gap Analysis, BRD/FRD, UAT, Process Documentation

• Data Engineering Tools: ETL, Data Modelling, DAX, SSIS, SSRS

• Project Management & Tools: Agile, Scrum, Jira, Confluence, ServiceNow Reporting & KPIs: Dashboard Design, KPI Tracking, Forecasting, Data Governance

PROFESSIONAL EXPERIENCE Data Analyst

Merkle, USA Aug 2025 – Present

• Designed and deployed Power BI dashboards and Tableau reports to monitor KPIs such as marketing ROI, customer segmentation, and operational efficiency, reducing reporting timelines by 40%.

• Extract, clean, and manipulate large datasets using SQL and Python (Pandas, NumPy), improving accuracy of executive reporting by 30%.

• Conduct ad-hoc analysis and forecasting using Python, enabling predictive insights into customer behaviour and campaign performance.

• Partner with business stakeholders to gather requirements, create BRDs/FRDs, and deliver BI solutions aligned with organizational goals.

• Developed ETL workflows to automate data ingestion from multiple sources (SQL Server, Excel, cloud APIs), enhancing data pipeline efficiency.

Associate Professional Software Engineer Data Analyst DXC Technology EIT Services India Pvt Ltd Aug 2021 – Jul 2023

• Monitored mainframe z/OS performance using JCL, SQL, and SAS, ensuring optimized CPU, memory, and storage utilization.

• Automated SAS reporting scripts to streamline system performance reporting, cutting manual effort by 40% and increasing accuracy of KPIs.

• Extracted and transformed datasets from DB2 databases to analyse capacity utilization trends and support forecasting models.

• Partnered with cross-functional teams to validate Disaster Recovery (DR) test runs, reducing downtime risks and strengthening compliance.

• Performed root cause analysis (RCA) on system delays, applying SQL queries and log reviews to reduce job failures by 25%.

• Created interactive Excel dashboards with macros and pivot tables for weekly performance reviews, improving stakeholder visibility.

• Ensured Agile delivery of system enhancements by participating in daily standups, sprint planning, and UAT activities. Collaborated with business teams to align reporting outputs with performance SLAs and corporate governance requirements. Data Analyst Intern

Mphasis Jan 2019 – July 2020

• Assisted in building SQL queries and stored procedures to clean and validate marketing datasets used in BI projects.

• Designed Power BI dashboards to track campaign performance, customer engagement, and sales KPIs across multiple channels.

• Conducted exploratory data analysis (EDA) in Excel and Python to identify patterns and anomalies in datasets.

• Supported data modelling and created ER diagrams to optimize reporting structures and improve query performance.

• Collaborated with senior analysts to develop KPI definitions and reporting standards, improving consistency across BI reports. Documented business processes and prepared training materials for knowledge transfer within the analytics team.

• EDUCATION & CERTIFICATIONS

Master of Science in Management Information Systems (MIS) Auburn University at Montgomery Montgomery, AL 2025 CGPA: 3.66 Bachelor of Engineering in Electronics & Communication Engineering Vel Tech Rangarajan Dr. Sagunthala R&D Institute of Science & Technology Avadi, Chennai 2021 CGPA:7.78

• Microsoft Certified: Power BI Data Analyst Associate (PL-300) 2025 PROJECTS

• Campaign ROI Dashboard (Merkle) – Built Power BI dashboards integrating SQL and cloud data sources to track marketing ROI and customer segmentation. Improved decision-making speed by 25%.

• Performance Analytics Automation (DXC) – Automated SAS-based pipelines to monitor z/OS utilization, cutting reporting cycle time by 50%.

• Customer Segmentation (Mphasis) – Conducted SQL- and Excel-based segmentation to improve campaign targeting, increasing efficiency by 12%.

Contact this candidate