• Designing and building robust, scalable, and high-performance data pipelines to ingest, process, and transform data from various sources into usable formats. • Writing and optimizing ETL (Extract, Transform, Load) processes to prepare data for analytics and business intelligence purposes. • Refining and transforming extensive and heterogeneous datasets utilizing tools like SQL and Python. • Facilitating seamless CI/CD pipeline integration by managing Git and Snowflake version control systems for code review, development, testing, and deployment. • Standardizing data manipulation and retrieval by engineering robust stored procedures and UDFs using SQL and Python. • Coordinating implementation and maintenance of data warehouse with developers and analysts by conducting design reviews and release notes.

Nordic Global | Dec 2021 - Dec 2022

Data Engineer

• Designed and coded lambda step functions for migration of Epic/Caboodle data tables to Athena data catalog • Improved data pipeline scalability and performance by implementing AWS Glue Jobs and Step Functions, integrating Snowflake and Databricks for seamless data flow. • Reduced transaction times by 25% by developing and refactoring SQL UDFs and Stored Procedures using SQL, Java, and Python for Snowflake, SQL Server, and AWS Redshift, ensuring data integrity. • Ensured compliance and data security by utilizing Git and Jenkins for CI/CD processes during code review sessions and documentation efforts, aligning with HIPAA standards. • Optimized system performance through data management best practices by conducting regular system checks using dashboards and alerts, leveraging Terraform and Infrastructure as Code principles.

Tripoint Solutions | Jan 2021 - Dec 2021

Data Engineer

• Improved data processing efficiency by 30% through constructing and scheduling workflows using Glue Crawlers and custom ETL jobs in PySpark, Python, and Spark within a robust AWS Data Lake. • Enhanced ETL operations by leveraging external Python and Java API libraries such as Pandas, Spark, Textract, sqlalchemy, and PDFBox for seamless data ingestion into Glue Catalog and AWS Redshift. • Optimized data accessibility and retrieval by configuring Amazon Redshift clusters and implementing parquet files within AWS Redshift staging schema for ingestion into Azure SQL Database. • Streamlined data ingestion processes by managing AWS Glue, Redshift, and S3 resources using AWS CLI and Boto3, enabling efficient extraction and processing of XML-formatted documents and PDFs. • Increased cloud infrastructure efficiency by 25% by boosting performance through expert database administration and optimization of AWS resources.

Marieke Consulting, Inc | Jun 2020 - Dec 2020

Analyst (FAA - REGIS)

N/A

CPMC-LLC | May 2019 - Jun 2020

Program Management Analyst

• Streamlined data analysis processes by automating Pivot Tables and Charts/ Graphs creation using ODBC DATABASE resources and VBA, incorporating SQL for data manipulation, enhancing reporting efficiency. • Improved system performance by 30% through enhancements on Department of Treasury legacy system and efficient cloud resource management, utilizing Terraform for optimization. • Facilitated seamless data transfer and integration by deploying AWS EC2 instance with Oracle database, linking to MS Access ODBC connection, and managing cloud technologies. • Enhanced data quality and insights for decision-making by developing and implementing Python scripts for data cleansing and analysis, serving as SME for data integration and mapping, employing Python and Jenkins for CI/CD. • Optimized performance of data processing tasks by implementing strategies to efficiently manage cloud resources using Azure and Google Cloud.

GSA | May 2016 - May 2019

Data Analyst

• Saved $1 million in labor costs by developing an in-house application using SQL, Python, and cloud technologies, addressing cost estimation inaccuracies. • Enhanced data accuracy and alignment by identifying and communicating gaps between paper documentation and data-driven systems using SQL and data analysis with Snowflake and Databricks. • Optimized efficiency and reduced manual workload by 30% by automating data extraction processes using SQL queries, Python, and Jenkins for CI/CD. • Improved decision-making and strategic initiatives by translating business requirements into actionable insights using Azure and Google Cloud through cross-functional collaboration. • Ensured timely and accurate delivery of insights by conducting data collection and analysis using MS Access SQL/VBA and integrated with Terraform for infrastructure as code.

The Bozman Group, Inc. | Jul 2013 - May 2016

Database Analyst and Developer

N/A

Ecosystems Services | May 2013 - Nov 2013

Value Engineer (contract)

N/A

International Monetary Fund | May 2012 - May 2013

Economic Data Support Specialist

• Provided technical support for proprietary economic systems • Assisted in development of in-house economic and statistical software applications • Assisted in implementation of new data storage system that assisted economists with research and IMF publications • Created ad-hoc tables, charts, graphs, and pivot tables at request of economists • Trained macroeconomists with in-house platforms for monetary, fiscal, and balance of payments data • Quality checked, audited, and migrated economic data in to proprietary relational database management system

Aston English | Sep 2010 - Aug 2011

English Teacher

• Instructed 130 Chinese students 5 to 18 years) in basic to advanced level English • Created lesson plans for 12 classes to cover course objectives • Graded and marked course work per student • Conducted private tutoring for individual students

American University Office of the Registrar | Sep 2007 - Sep 2008

Associate

N/A

My Education

Take a look at my formal education

Master of Applied Economics, Econometrics and Quantitative EconomicsUniversity of Maryland College Park | 2015

Bachelor of Science, Information Technology ManagementAmerican University - Kogod School of Business | 2010

SKEMA Business School | 2008

High School Diploma Long Reach High School | 2006

Create Your Data Portfolio for Free