Database engineer with over 14years of experience in Database, ETL, Reporting, AWS Cloud, Hadoop, Data Bricks. Innovative thinker with a proven track record of building adaptable data driven solutions.
Overview
12
12
years of professional experience
1
1
Certification
Work History
AWS Database Engineer
VerraMobility
Mesa
08.2024 - Current
Worked on Oracle database migration from Oracle on Perm to AWS Aurora
Setting up S3 buckets and update the code to write the files appropriate Aws Buckets
Create Lambda functions to load Court Dispositions and DMV Data as soon it landed in S3 Buckets
Invoke API’s using Python to write citations files to client SFTP locations using AWS Transfer Family
Setting up automated scripts to on board new clients into the system
Created new procedures and Packages in Database to display Data on the dashboards
Setting up data interfaces with clients and collection agencies to send/Receive violation information
Technical Lead/Project Lead
Apple Inc
Austin
06.2020 - 03.2024
Implementation of various services to support multiple recon projects for Apple Products Reconciliation internal to apple
Work on Expansion strategy and Enhancement requests from various business stakeholders across including EMEIA, AMR and APAC regions
Designed and implemented scalable data ingestion pipelines using Azure Data Factory, ingesting data from various sources such as SQL databases, CSV files, and REST APIs
Developed data processing workflows using Azure Databricks, leveraging Spark for distributed data processing and transformation tasks
Ensured data quality and integrity by performing data validation, cleansing, and transformation operations using Azure Data Factory and Databricks
Designed and implemented a cloud-based data warehouse solution using Snowflake on Azure, leveraging its scalability and performance capabilities
Created and optimized Snowflake schemas, tables, and views to support efficient data storage and retrieval for analytics and reporting purposes
Developed and optimized Spark jobs to perform data transformations, aggregations, and machine learning tasks on big data sets
Senior Database Engineer / Technical Lead
Bimbo Bakeries
Islandia
03.2015 - 06.2020
Designed and deployed scalable and fault-tolerant streaming data pipelines on AWS, processing over large volume of data daily with sub-second latency
Involved in developing delta lake solutions using data bricks and DLT tables
Developed Spark Programs using Python APIs to load customers daily sales for ordering and forecasting
Proficient in managing Snowflake objects and resources using Snowflake's native interface, Snow SQL CLI, or Snowflake's web interface for administration and monitoring
Involved in designing and implementing a custom ETL solution in Java to allow for near real time sync between disparate systems
Create snow pipe to move data from S3 to snowflake
Data Engineer
Tiaa-Cref
Charlotte
03.2014 - 03.2015
Integrated Code with Oracle Real Time Decision maker for Predictive analytic solutions
Set Up Data Pipelines to load data from different internal systems
Worked on Siebel opportunities and activities data to salesforce using Siebel mapping tool
Worked on loading semi structed data using leveraging Hadoop for data analytics
Worked on loading data from RDBMS to HDFS using Sqoop
Database Developer
Quill.com
Chicago
11.2012 - 03.2014
Worked on Oracle database migration from Oracle 10i to Oracle 11g
Analyzed and Implemented ODS, DataMart’s, Datawarehouse for Staples Europe
Worked on Performance Tuning slow running queries during migration
Gained very good business knowledge on Predictive analytics encompasses a variety of statistical techniques from predictive modelling and data mining
Worked on Data Loading and transformation and views for creating SAS statistical models for additional Product recommendations
Education
M.S. - Electrical Computer Engineering
SIUC
12.2012
B.Tech. - Electrical and Electronics Engineering
Narayana Engineering College
06.2010
Skills
LINUX
Python
Shell Scripting
Hadoop
Map Reduce
HDFS
HBase
Zookeeper
Hive
Spark
JMS
Apache Kafka
Mongo DB
MySQL
Oracle 19c
Redshift
Postgres
DynamoDB
Snowflake
Git
Svn
AWS
Jenkins
SSIS
Informatica power center
IBM Data Stage 85
Autosys
Control-M
Airflow
API integration
Cloud architecture
Data migration
Certification
Oracle PL/SQL Certified, Oracle, 11/01/17
SnowPro Core Certified, Snowflake, 06/01/24
AWS Cloud Practitioner, 07/01/24
Data Bricks Fundamentals, 07/01/24
Databricks Certified Data Engineer Associate, 12/01/24