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