Chandrahas Nanduri
Frisco
Summary
Data Analyst and ETL Engineer with over 3 years of experience in advanced analytics, KPI modeling, and BI reporting for federal transportation and defense sectors. Proficient in SQL, Python, Azure Databricks, and Informatica PowerCenter, with a strong focus on data quality and integrity. Expertise in developing large-scale ETL pipelines, designing data models, and automating data workflows to enhance reporting efficiency. Proven ability to create interactive dashboards that support executive decision-making.
Overview
5
5
years of professional experience
1
1
Certification
Work History
Data Analyst/ Engineer
KPMG US LLP
06.2023 - Current
- Designed large-scale CI-CD & ETL pipelines in Azure Databricks to ingest, standardize, and transform 500K+ monthly transportation, freight, and vessel records into Govt. cloud platform, implemented Unity Catalog–based access control and data lineage tracking for sensitive federal datasets while collaborating with architects to enforce standardized KPI metrics.
- Worked as data analyst, built operational KPI models including vessel type, carrier utilization, shipment cycle time, supported and collaborated with business on quarterly financial reviews.
- Developed Excel Power Query workflows feeding financial/operational dashboards, enabling auto-refresh of shipment cost models, and monthly spend allocation summaries on Power BI.
- Developed SQL queries in SQL Server to flag anomalies such of missing shipment legs, duplicate load numbers, negative freight spend, and mismatched carrier IDs; reported findings to senior transportation leadership with recommended corrective actions.
- Authored PowerPoint presentations summarizing monthly spend variances, cycle-time improvements, and high‑impact delays requiring leadership action.
- Collaborated with cross functional teams, data architects, cross functional teams and project managers to standardized data quality and data movement strategies and processes, ensuring a single consistent version of performance KPIs across the enterprise.
- Mentored junior analysts on Databricks ETL development, KPI, SQL validation, and structured reporting methods used for financial and operational leadership reviews.
Data Analyst/ Engineer
KPMG US LLP
01.2024 - 08.2024
- Developing SQL queries on Snowflake by extracting and restructuring data from SQL Server Database (carrier tables, shipment logs, delivery datetimes, regional routing data) and building high-value Excel analytical reports using Pivot Tables, Power Query, XLOOKUP, Power Pivot, and custom measures to support leadership decision-making.
- Worked on Data Governance - Applied RBAC and row-level security in Snowflake to control access to shipment cost metrics, and regional logistics data, ensuring compliance with governance standards.
- Created and documented Data Dictionary – Developed a centralized data dictionary repository with column-level documentation and business rule definitions within Snowflake, clearly outlining shipment attributes, carrier details, and cost-calculation rules to streamline analytics and uploaded Dictionary artifacts to SharePoint.
- Developed excel reports using Pivot Tables and Bar Graphs processing 200,000+ monthly transportation records, analyzing KPIs such as, cost-per-mile, cost-per-shipment, carrier delay frequency and regional route efficiency.
- Worked on Data Quality - data cleansing using python (Pandas, Regex, datetime transformations), reducing manual processing by 20+ hours/week and improving consistency in deliveries and shipment failures data.
- Developed forecasting models predicting daily and weekly delivery volumes using Power-Bi and used visualizations like line charts, key influencers visuals, anomaly detection that supported workforce planning and resource allocation across regions.
Data Analyst/ Engineer
KPMG US LLP
06.2023 - 01.2024
- Data manipulation and cleansing of organizational roles and responsibilities of employee CSV files developed python scripts and used libraries such as openpyxl (reading/writing to files), pandas (data frames, cleaning data, filtering), and numpy (numerical, mathematical computing).
- Designed and implemented interactive heatmaps using Matrix Visuals to visualize common responsibilities across different roles, enabling leadership to identify overlapping duties and optimize workforce efficiency.
- Created dynamic role-responsibility mappings leveraging DAX functions to display the number of shared responsibilities between roles, ensuring accurate alignment between stakeholders and system access levels.
- Developed interactive click views and cross-filtering in Power BI, allowing users to click on roles and dynamically filter related responsibilities using DAX-driven measures.
- Optimized large datasets using Power Query by normalizing raw stakeholder data, applying custom transformations, and improving dashboard performance. Implemented scalable filtering mechanisms using slicers to enable users to dynamically analyze responsibilities based on predefined categories, ensuring efficient role-based data analysis.
- Ensured optimal dashboard performance for large datasets by utilizing aggregated precomputed fields, hierarchical slicers, and search-enabled dropdowns. Delivered a robust and insightful reporting framework that empowered leadership with a data-driven approach to assess stakeholder Responsibilities and role-based system access, improving workflow efficiency, reducing redundancy, and enhancing accountability across teams.
- Followed agile software development methodology in implementing project goals and deliverables, effectively communicated with team members while efficiently managing time to complete technical goals of project within deadline.
Data Science Intern
KPMG US LLP
06.2022 - 08.2022
- Supported a federal healthcare engagement under KPMG AI/Analytics by designing COVID-19 Tableau dashboards and leading OCR vendor assessment (Amazon Textract, IBM Datacap, Google Vision, Azure Read API), developing Python scripts and 600+ unit tests to extract and validate handwritten medical data, improving detection accuracy by 35% across 300+ files using Agile methodology.
Software Engineer Intern
HCL Technologies
08.2021 - 12.2021
- Designed and developed REST APIs using Java Spring Boot and microservices architecture for 5G communication systems, enabling efficient request–response handling between client and server, and implemented async callback processing.
- Built automated logging workflows to capture and store inbound/outbound API activity in SQL server.
Software Engineer Intern
CDK Global
06.2021 - 08.2021
- Designed and implemented a one-stop application using Markdown to enable CDK engineers to create and statically host webpages/sections, supported by Bash automation scripts (create/delete/edit features) and CI/CD pipelines in Bamboo—boosting deployment efficiency by 40% and reducing documentation-related productivity loss by 21.3%.
Education
Bachelor of Science - Computer Science, Finance Minor
University of Texas, Dallas
Skills
- Data Analytics
- Python
- Data Visualization
- GenAI (OpenAI, MS Co-pilot, Git-Hub Co-pilot)
- ETL
- CI/CD pipelines
- Analytical reporting
- Rest API
- Databricks
- Azure Data Engineering
- SQL-Scripting (MS Access, MySQL)
- Power-Bi
- GitHub
- Visual Studio
- Pyspark
- Jira
- SDLC
- Agile Scrum
- MS Suite 360: Word
- Excel (Power Query, V-Lookup, Pivot Tables, VBA)
- PowerPoint
Certification
- Certified SAFe 6 Agilist
- Trained AWS Databricks
- Trained Data Analyst
Work Authorization
US Citizen (No visa/sponsorship required)
Timeline
Data Analyst/ Engineer
KPMG US LLP
01.2024 - 08.2024
Data Analyst/ Engineer
KPMG US LLP
06.2023 - Current
Data Analyst/ Engineer
KPMG US LLP
06.2023 - 01.2024
Data Science Intern
KPMG US LLP
06.2022 - 08.2022
Software Engineer Intern
HCL Technologies
08.2021 - 12.2021
Software Engineer Intern
CDK Global
06.2021 - 08.2021
Bachelor of Science - Computer Science, Finance Minor
University of Texas, Dallas