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 -
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 -