Summary
Overview
Work History
Education
Skills
Certification
Timeline
Generic

Sai Priya Gunukula

Franklin,ACT

Summary

A results-driven Data Engineer with a strong foundation in data analysis, pipeline development, and cloud integration. Proven ability to streamline data ingestion workflows, optimize SQL processes, and enhance performance across large-scale datasets. Adept at collaborating with cross-functional teams, automating processes, and maintaining high standards of data governance. Currently contributing to audit automation and optimization at Rassure, Sydney, with experience in BI development and analytics.

Overview

5
5
years of professional experience
1
1
Certification

Work History

Data Engineer

Rassure
10.2023 - Current
  • Managed data sourcing, designing, and normalizing data structures to meet specific business requirements, improving the accuracy of audit processing.
  • Developed batch processing workflows to buffer and process data in groups, optimizing execution based on time or record counts.
  • Developed Python, PySpark ingestion scripts and scheduled using Airflow, automating data ingestion workflows.
  • Involved in creating new stored procedures and optimizing existing queries, improving SQL processes and data workflows, which resulted in a 96% reduction in processing records (from 11 million to 400K) and a 30% reduction in response time, enabling faster and more accurate data selection.
  • Automated alerts and generated statistics with Python scripts for enhanced monitoring during production processes.
  • Standardized workflows through collaboration with stakeholders, resolving blockers and ensuring alignment in daily stand-ups and sprint planning.
  • Fostered a culture of regular documentation and testing, including unit tests and E2E integration testing for reliable data.
  • Utilized AWS Glue to design and manage ETL pipelines that enable seamless data transformation and loading for efficient data.
  • Utilized Atlassian JIRA and Confluence for efficient project management, tracking progress, and ensuring smooth collaboration.

Power BI Developer

Nissi Consult
10.2022 - 04.2023
  • Imported data from SQL Server DB and Azure SQL DB to Power BI, enabling seamless report generation.
  • Created DAX queries to generate computed columns, tables, and calculated measures, enhancing insights and user engagement in Power BI.
  • Performed ETL activities using Power Query, reducing processing time by 20% through efficient column addition, splitting, pivoting, and data type changes.
  • Optimized Power BI dashboard performance with indexing and partitioning, reducing load time by 30%, and implemented row-level security for enhanced data privacy.
  • Employed advanced data modelling in Power Pivot, improving accuracy and responsiveness in data analysis.
  • Used Power BI, Power Pivot, Power View, and Power Map to develop data analysis prototypes and visualize reports.
  • Used Power BI Gateways to keep dashboards and reports up to date.
  • Installed and configured Enterprise and Personal Gateways in Power BI Services for seamless integration and data refresh.

Data Analyst

Capgemini
11.2020 - 04.2022
  • Collaborated with clients to gather and analyze data requirements, performing comprehensive source-to-target data mapping and leveraging SQL to transform raw datasets in the bronze layer into clean, curated datasets in the gold layer.
  • Used SNOW PIPE for continuous data ingestion from the S3 bucket into Snowflake, ensuring real-time data availability.
  • Proficient in SQL query writing and Snowflake database management, including creating tables, views, and developing JavaScript stored procedures, streams, functions, sequences, and tasks for efficient data migration and transformation.
  • Designed ER diagrams (Physical and Logical using ER Studio) and mapped data into database objects for effective data modeling and database design.
  • Applied data security measures, including encryption and dynamic data masking, to protect sensitive information.
  • Established role-based access controls to ensure compliance and secure data governance.
  • Created Pipeline’s to extract data from on premises source systems to azure cloud data lake storage gen2; Extensively worked on copy activities and implemented copy behaviors such as flatten hierarchy and Merge hierarchy; Implemented Error Handling concept through copy activity.
  • Exposure on Azure Data Factory activities such as Lookups, if condition, for each, Set Variable, Append Variable, Get Metadata, Filter and wait.
  • Configured and implemented the Azure Data Factory Triggers and scheduled the Pipelines; monitored the scheduled Azure Data Factory pipelines and configured the alerts to get notification of success and failure pipelines.

Education

Bachelor of technology - Electronics and Communication Engineering

Jawaharlal Nehru Technological University Hyderabad
11.2020

Skills

  • Leadership and Team Development
  • Data Engineering
  • Pipeline Automation
  • SQL scripting & Optimization
  • Relational Databases
  • Python & PySpark Scripting
  • Azure Data Factory
  • Snowflake data warehousing
  • Emotional Intelligence and Resilience
  • Data Security & Governance
  • Power BI & DAX Modeling
  • Batch Processing & Data Ingestion
  • Data Cleansing & Transformation
  • Documentation & Testing (Unit/E2E)
  • Agile, JIRA, and Confluence Collaboration

Certification

  • AZ-900: Microsoft Azure Fundamentals - Certificate
  • PL-300: Microsoft Certified: Power BI Data Analyst Associate - Certificate
  • DP-203: Microsoft Azure Data Engineer Associate – In progress

Timeline

Data Engineer

Rassure
10.2023 - Current

Power BI Developer

Nissi Consult
10.2022 - 04.2023

Data Analyst

Capgemini
11.2020 - 04.2022

Bachelor of technology - Electronics and Communication Engineering

Jawaharlal Nehru Technological University Hyderabad

Similar Profiles

CREATE PROFILE
Sai Priya Gunukula