Summary
Overview
Work History
Education
Skills
Certification
References
Timeline
Generic

Aditi Sharma

Fairfax

Summary

Accomplished Senior Data Engineer with a track record of enhancing data operations, notably automating data ingestion processes at SWIFT, leading to a 90% reduction in manual entry. Expert in Python programming and data pipeline design, I excel in transforming complex data insights into actionable strategies. My leadership in project management and Agile methodologies drives cross-functional teams toward data-driven decision-making.

Overview

14
14
years of professional experience
1
1
Certification

Work History

Senior Data Engineer

SWIFT
Fairfax
05.2023 - Current
  • Developed a data ingestion process using Python & DBT (ETL) to automate the transfer of data from multiple sources into a single database, resulting in a 90% reduction in manual data entry.
  • Integrated diverse data sources like AWS Security Hub, JIRA, Bitbucket, and ServiceNow into a unified data platform.
  • Designed and implemented Tableau dashboards, providing critical insights for business decision-making.
  • Constructed DBT models to transform raw data into meaningful dimensions and facts, enhancing data utility.
  • Skilled in translating complex data insights into actionable strategies, regularly presenting to stakeholders and guiding cross-functional teams towards data-driven decision-making.
  • Proficient in using JIRA for Agile project tracking, adept at managing backlogs, sprints, and user stories to align with project goals.

Analytics Engineer

AMAZON
Fairfax
01.2021 - 05.2023
  • Streamlined data extraction and loading processes from S3 to Redshift, using AWS Glue and Kinesis.
  • Automated data pipeline processes using Python, improving data accuracy and operational efficiency.
  • Developed and implemented a system for automated trend, pattern, and anomaly detection using technical analysis techniques.
  • Conducted workshops on constructing DBT models for transforming raw data.
  • Leveraged data analytics to identify areas of improvement and develop actionable plans to address those needs.
  • Performed exploratory data analysis on structured and unstructured datasets utilizing statistical methods such as regression, correlation, clustering.
  • Developed and implemented predictive analytics models using Python and SQL to identify customer trends and improve operational efficiency.
  • Deployed analytical solutions in production environment while ensuring scalability and reliability.

Senior BI Developer

Fannie Mae
Fairfax
01.2019 - 01.2021
  • Spearheaded the integration of cybersecurity applications into AWS Redshift, enhancing data security and analysis.
  • Orchestrated the creation of efficient data pipelines using AWS Glue, Kinesis, and Firehose.
  • Mentored staff in Python for advanced ETL processes.
  • Utilized Python for complex ETL processes, significantly improving data handling and transformation.
  • Learned and created Microsoft Power Flow and Power Automate application to develop process automation products, receiving director appreciation for these contributions.
  • Analyzed user requirements to design effective data models that meet specific business objectives.

Data Engineer (contract)

CGI
Fairfax
01.2018 - 12.2019
  • Developed a comprehensive Data Warehouse using SQL stored procedures and SSIS, centralizing critical business metrics.
  • Collaborated across Sales, Finance, Project Management, and HR departments to integrate key performance indicators.
  • Implemented and maintained scalable data storage and retrieval systems, supporting enhanced data-driven decisions.
  • Created SQL applications to automate the manual process to reduce the manual work.
  • Designed and developed dimensional models for OLAP cube processing in Hadoop environment.
  • Designed and developed scripts for loading and analyzing large datasets from text files.

BI Architect (Contract)

CACI International Inc.
Fairfax
01.2016 - 07.2018
  • Coordinated server installation, configuration, and provided training in Cognos Analytics, boosting BI capabilities.
  • Led the migration of sister companies acquired by CACI with junior developers to merge the Cognos and Crystal Reports environment.
  • Developed a self-service BI platform that allowed end-users to create their own reports and dashboards with minimal technical support.
  • Automated the deployment of BI solutions, resulting in a 80% reduction in development time.
  • Optimized the performance of existing BI solutions, resulting in a 80% decrease in query execution time.
  • Worked closely with project stakeholders to ensure successful delivery of projects within budget constraints.
  • Provided production support for existing DW and BI solutions when needed.

BI Developer (contract)

GDIT
Fairfax
01.2015 - 01.2016
  • Oversaw the installation and configuration of distributed architecture for Cognos Analytics, Transformer & TM1 on Windows servers.
  • Engaged in ETL processes using Informatica 9.5 power center, enhancing data integration and reporting capabilities.
  • Developed a data catalog to improve data discovery and enable self-service analytics.
  • Developed a data governance strategy to ensure data integrity and security across the organization.
  • Analyzed business requirements to design and develop dimensional models in SSAS for reporting purposes.
  • Created complex SSIS packages to extract, transform, and load data from multiple sources into the data warehouse.

Application Support Engineer

Logi Analytics
Fairfax
01.2012 - 01.2015
  • Created documentation on processes, procedures, troubleshooting steps and workflows.
  • Assisted team members in solving application related problems.
  • Provided critical support in developing Business Intelligence and Analytics tools, focusing on user-specific requirements.
  • Facilitated effective data warehousing environments using Oracle, SQL Server, and MySQL, optimizing data utility.
  • Provided technical support to customers over the phone and via email, resulting in a 100% customer satisfaction rate.
  • Developed scripts to automate the resolution of common customer issues, resulting in a 75% reduction in response time.
  • Developed a knowledge base of common customer issues and their solutions.

Education

Bachelor of Engineering -

RGPV University
India

Skills

  • Cloud Computing
  • Data Security
  • Data Warehousing
  • Data Modeling
  • Data Pipeline Design
  • ETL Development
  • Data Integration
  • Advanced SQL
  • Data Visualization
  • Project Management
  • Agile Methodologies
  • Python Programming
  • Performance Tuning
  • Data curating
  • Amazon Redshift

Certification

  • Solution Architect Certification
  • Splunk Fundamentals
  • ITIL Foundation Certified
  • AWS Data engineer
  • CompTIA Security+

References

References available upon request

Timeline

Senior Data Engineer

SWIFT
05.2023 - Current

Analytics Engineer

AMAZON
01.2021 - 05.2023

Senior BI Developer

Fannie Mae
01.2019 - 01.2021

Data Engineer (contract)

CGI
01.2018 - 12.2019

BI Architect (Contract)

CACI International Inc.
01.2016 - 07.2018

BI Developer (contract)

GDIT
01.2015 - 01.2016

Application Support Engineer

Logi Analytics
01.2012 - 01.2015

Bachelor of Engineering -

RGPV University
Aditi Sharma