Sai Priya Gunukula
Sydney,Australia
Summary
Experienced Data Engineer skilled in SQL, Snowflake, and Power BI, adeptly transforming raw data into actionable insights. Collaborative and detail-oriented, I excel in ensuring data precision and quality through meticulous validation and testing. With a solid foundation in data quality and security, I bring a comprehensive approach to data analysis. Seeking opportunities to contribute my expertise and passion for data analysis in a dynamic and growth-oriented environment.
Overview
4
4
years of professional experience
Work History
DATA ENGINEER
Rassure
Sydney
10.2023 - Current
- Conducted detailed audits of airline ticket refunds to refine processes and improve efficiency by analyzing passenger data and applying rules to confirm eligibility, while using SQL to validate data quality . This resulted in accuracy across multiple airline databases and enhanced data handling efficiency.
- Managed aggregated data from multiple sources, using Excel workbooks in the decision-making process to cross-check airline calculations against agent records and ensure refunds.
- Used Amazon EC2 to manage instances and create EBS snapshots, ensuring data backups and availability for audit workflows.
- Automated data loads from MySQL to S3 using Python scripts, enhancing data accessibility and reliability for downstream processes.
- Employed AWS Glue to design and manage ETL pipelines for seamless data transformation and loading, contributing to efficient data processing.
- Utilized Airflow for scheduling and maintaining DAGs, optimizing task automation and streamlining audit operations.
- Maintained AWS Auto Scaling groups to dynamically adjust resources based on system demand, ensuring optimal performance and cost efficiency.
- Collaborated with internal stakeholders and cross-functional teams to align on best practices and enhance workflows, ensuring operational readiness and adherence to established guidelines, while fostering a culture of continuous improvement.
DATA ANALYST
Nissi Consult
Canberra
10.2022 - 10.2023
- Engaged in client collaboration to comprehend data requirements, meticulously mapped source-to-target, and upheld data integrity
- Conducted comprehensive analysis of employee and customer data to unveil trends, resulting in well-crafted, informative reports for data-driven decision-making
- Proficient in SQL query writing and Snowflake database management, including creating tables, views, and developing Javascript stored procedures, streams, views, functions, sequences, and tasks for data migration and transformation
- Highly skilled in unit testing to validate scenarios, with expertise in end-to-end testing
- I excel in creating comprehensive test cases and have hands-on experience with CI/CD pipelines for deploying the latest code versions to higher environments
- Following data analysis, I embarked on the subsequent phase of creating clear and comprehensible Power BI reports and developed interactive dashboards summarizing vital insights, thereby empowering stakeholders to make informed decisions
- Additionally, I conducted forecasting by leveraging historical data and trends to facilitate proactive decision-making and resource planning
- Demonstrated a consistent record of successfully executing data cleansing, transformation, and normalization processes to uphold data accuracy and integrity
- Oversaw complete data projects, encompassing requirements gathering, data collection, thorough analysis, and timely delivery of high-quality results
- Working closely with highly skilled teams, I have developed a creative problem-solving approach and fostered effective collaboration with Subject Matter Experts (SMEs)
- Continuous improvement is at the core of my work, and I have a track record of documenting feature design in tools like Confluence and Jira
- Consistently achieved data accuracy rates of over 90% through meticulous validation, cleansing, and quality assurance techniques, ensuring robust and reliable insights for informed decision-making
DATA ANALYST / POWER BI
Capgemini
Bangalore
11.2020 - 04.2022
- Expertly performed ETL activities using Power Query, achieving a 20% reduction in data processing time through efficient column addition, splitting, pivoting, and data type changes
- Successfully published Reports and Dashboards to Power BI Service, accompanied by the application of row-level security measures for enhanced data privacy
- Employed advanced data modeling techniques in Power Pivot, resulting in a improvement in data accuracy and responsiveness, while executing DAX queries and creating calculated measures, enhancing overall insights
- Implemented various filters (Visual, Page, Report, Drill Through) to efficiently control and enhance data representation within reports, ensuring enhanced user engagement
- Orchestrated the design, development, and deployment of data products (Visualizations, Reports, Dashboards, Data Warehousing), contributing to valuable insights and decision-making
- Led end-to-end development of data products (Visualizations, Reports, Dashboards, Data Warehousing), driving 2 successful product releases, resulting in informed decision-making and faster insights delivery
Education
BACHELOR OF TECHNOLOGY - ELECTRONICS AND COMMUNICATION ENGINEERING
Jawaharlal Nehru Technological University
Hyderabad11.2020
Skills
- ETL Processes
- SQL
- Snowflake
- Data Visualization: Power BI and Excel
- Cloud: AWS and Azure Fundamentals
- Python Scripting & Automation
- Communication and Collaboration
References
References available upon request.
Timeline
DATA ENGINEER
Rassure
10.2023 - Current
DATA ANALYST
Nissi Consult
10.2022 - 10.2023
DATA ANALYST / POWER BI
Capgemini
11.2020 - 04.2022
BACHELOR OF TECHNOLOGY - ELECTRONICS AND COMMUNICATION ENGINEERING
Jawaharlal Nehru Technological University
Similar Profiles
DIVJYOT KAURDIVJYOT KAUR
Retail Assistant at Michael HillRetail Assistant at Michael Hill
LUBNA FATIMALUBNA FATIMA
Casual Childcare Educator at Montessori AcademyCasual Childcare Educator at Montessori Academy
Amey SapleAmey Saple
Training Operations Specialist at SAS AustraliaTraining Operations Specialist at SAS Australia