GIRISH NAGA VARDHAN CHIRUMAMILLA
Data Engineer
Overland Park,KS
Overview
5
5
years of professional experience
Work History
Data Engineer
Dataflake LLC
07.2022 - Current
- Collaborated on ETL (Extract, Transform, Load) tasks, maintaining data integrity and verifying pipeline stability.
- Fine-tuned query performance and optimized database structures for faster, more accurate data retrieval and reporting.
- Enhanced data quality by performing thorough cleaning, validation, and transformation tasks.
- Streamlined complex workflows by breaking them down into manageable components for easier implementation and maintenance.
- Increased efficiency of data-driven decision making by creating user-friendly dashboards that enable quick access to key metrics.
- Create various dashboards for data analysis using Tableau
- Build various tables in snowflake warehouse for data analysis.
- Worked on migrating pipelines from ETL1.0 to ETL2.0
- Writes ad-hoc queries to pull data out of snowflake data warehouse.
- Supports development of standard data analyses, reports and dashboards.
- Building robust and scalable data integration pipelines(ETL) using Airflow and other relevant technologies.
- Designing tableau and sigma dashboard based on requirements gathered from business partners and stakeholders.
- Fine-tuning the performance of ETL jobs, SQL queries , optimizing code and configurations.
- Documenting the pipelines, tables, configurations, and processes for reference and future use.
- Collaborating with other team members to merge the completed code, update documentation and notify business partners about completed jobs and resolved errors.
- Testing developed ETL pipelines on different environments to check and validate desired outcomes.
- Implementing solutions based on design, adhering to best practices.
- Designing, building and maintaining efficient, reusable and reliable architecture and code.
- Create, troubleshoot and maintain stored procedures, views, triggers and functions.
Data Analyst
Accenture
06.2019 - 12.2020
- Provided software support and general technical solutions for operational, database, and security requirements in applications
- Collaborated with other members of the team to handle troubleshooting and debugging
- Created and implemented application test scripts
- Expertise in working with Incident and Change Management Tool Service-Now
- Experience in Offshore and onsite team coordination and delivering the requirements on time.
- Participated in requirements meetings to understand business needs.
- Extracted and interpreted data patterns to translate findings into actionable outcomes.
- Identified, analyzed and interpreted trends or patterns in complex data sets.
- Produced monthly reports using advanced Excel spreadsheet functions.
- Utilized data visualization tools to effectively communicate business insights.
- Improved decision-making processes with accurate data analysis and visualization techniques.
Education
Master of Science - Computer Science
University of Missouri - Kansas City
Kansas City, MO 05.2001 -
Bachelor of Engineering - Computer Science And Eng -
Gandhi Institute of Technology And Management
Visakhapatnam, INDIA 05.2001 -
Skills
SQL Expertise
ETL development
Data Analytics
Python
AWS
Snowflake
Data Modelling
Data pipeline Design
Academic Projects
Credit card Fraud detection (Python, ML/DL regression Algorithm).
- Performed data preprocessing on the irregular dataset by filling the missing values and Accomplishments and converting data to the required format.
- Applied many deep learning regression Algorithms to detect whether the transaction is Fraud/Non-Fraud.
- Compared all the results of different regression algorithms by measuring accuracy and metrics.
A Secure and Dynamic multi keyword ranked search over encrypted cloud data.
- Language: Java, JavaScript
- Web Technologies: HTML, CSS, XML
- Technology: Cloud Computing
- Brief Description : The main objective was to develop and design an easy and simple approach to protecting data confidentiality that encrypts data before outsourcing
- Individual Role: I was the main lead of the project and was involved in developing the program code.
Application development of NGO donations to Ashram's ( Java, Tomcat, PostgreSQL).
- Brief Description : The main objective was to develop an application for the people who are interested in donating to Ashrams.
- Individual Role: I was the main lead of the project and was involved in developing the program code.
Timeline
Data Engineer
Dataflake LLC
07.2022 - Current
Data Analyst
Accenture
06.2019 - 12.2020
Master of Science - Computer Science
University of Missouri - Kansas City
05.2001 -
Bachelor of Engineering - Computer Science And Eng -
Gandhi Institute of Technology And Management
05.2001 -