Information Technology United States

ADITI TIBREWAL

Texas, United States **********@*****.*** *******@****.***.*** LinkedIn website 682-***-****

PROFESSIONAL SUMMARY

Dynamic database Engineer with seven years of industrial experience, skilled at developing complex solutions possessing strong creative thinking skills, high energy and enthusiastic team player dedicated to streamlining processes and developing innovative solutions to unusual and difficult problems.

EDUCATION

University of Texas at Arlington, US MS in Information Systems Graduation: May 2023

St. Thomas’ College of Engineering & Technology, India B. Tech in Information Technology Graduation: May 2013

Coursework: Business Statistics, Data Science, Data Mining, Data Warehouse, Database Management, Business Intelligence, Information Technology, Analysis & Design, Project Management, Python programming, Software Engineering

SKILLS AND PROFICIENCY

•Programming Languages: SQL, Python, PL/SQL, PySpark, UNIX, Shell Script

•Database Management Systems: Snowflake, AWS, SSIS, SSMS, SQL Profiler, GCP, Informatica, Databricks

•Databases: SQL Server, Oracle, MySQL, PostgreSQL

•Modeling: Excel (financial modelling & reporting), ETL, ERD, SDLC, Tableau, Power BI

•Management Tools: Jira, Git, Confluence, Bitbucket, Streamsets, Kafka, Github, Gitlab

•Operating System: Windows, OS X, Linux

PROFESSIONAL EXPERIENCE

Data Engineer CSAA, California State Automobile Association Glendale, AZ United States Sep 2023-Sep 2024

Hands-on experience with Snowflake for complex projects on data enhancement.

Code enhancement on snowflakes to fulfill business requirements.

Continuous collaboration with Product owner for business communications. Attending business meetings to understand effective product needs.

Experience in architecting and implementing designs for data storage.

Support the downstream tasks for deployment.

Evaluate high level business requirements on Snowflake by advanced code transformations.

Assist with production issues in Data Warehouses like reloading data, transformations, and translations.

Work on standard data quality and QA task to confirm data quality checks.

Stream set pipeline enhancement followed with job scheduling using atomic job structure and maintaining the pipeline for job any job failures.

Establish Snowflake connector with python to work on Jupyter notebook environment. Handling authentication login, fetching data for specific environment and working with databases using Python libraries.

Working with complex stored procedures for code enhancement to solve complex issues with outputs.

Working with AWS for file storage. Building AWS stages in Snowflake to move files for reporting.

Handling power BI report by working on the data flow to populate the business reports.

Working with existing informatica mapping to link the databases and tables to solve problem statements.

Presented excel reports to business review using pivot tables/ csv data load for Snowflake outputs to support the implemented development.

Hands on with the following additional skills confluence documentation, Agile, Jira, Kanban, Bitbucket, Gitbash, NFR’s, code review, code walkthroughs

Data Engineer PayPal Bengaluru India Aug 2019-Aug 2021

Ingestion of data from and to databases using CLI command window/ python connector/ SQL query. Creating stages with complete file format to confirm the file check.

Track tasks history and work on zero-copy cloning.

Experience in writing and optimizing complex SQL queries, materialized views, dynamic queries, sub-queries and complex joins for stored procedures, triggers, views, and cursors.

Expertise in importing, exporting data between different sources like Oracle, Excel, SQL Server, PostgreSQL, NetSuite, Salesforce using SSIS utility.

Developed server maintenance and daily operations plans, running daily full backups and hourly transaction log backups; maintained database mirroring for critical servers.

Use OnPost Execute and OnError event handlers to log each task in SSIS log table.

Senior Database Administrator Altisource Bengaluru India Mar 2017-Aug 2019

Provided L1/L2 support for managing & monitoring SQL Server instances.

Daily on-call server administration and support for production and internal Microsoft SQL Servers and other database systems, including performance optimization strategies, profiling, disaster recovery planning, security, and system status.

Designed and implemented backup and restore databases strategies and recovery.

Performed mission critical or point-in-time databases recovery whenever needed.

Performance tuning (using DMV's, SQL profiler, Perfmon, index tuning wizard and query analyzer), and optimized indexes to reduce logical disk

I/O for effective performance.

Developed and maintained in-house written utilities using SSIS and T-SQL.

Cleaned and maintained the database environment by archiving old data for better accessibility.

Implemented process changes in production after UAT in the development environment.

Senior Software Engineer BankBazaar.com Bengaluru India Mar 2014- Mar 2017

Designed ETL workflows on Informatica PowerCenter and SQL, optimizing 50 databases (10 TB total) for Oracle and SQL Server.

Ensured data accuracy, integrity, and timeliness with performance tuning, stored procedures, and regular index rebuilding.

Managed user access, storage, and incident support while documenting ETL processes.

Led data integration and migration projects, ensuring seamless data transfers and collaborating with cross-functional teams.

Provided SQL Server consultation, addressing locking and blocking issues and devising disaster recovery plans.

Utilized Tableau for sales metrics and storytelling.

Software Engineer Kochar Infotech Pvt. Ltd. Kolkata India June 2013- Mar 2014

Wrote T-SQL, stored procedures, views with 24/7 monitoring and support to client in production environment where DB size ranges from 50GB to 500 GB.

Involved in troubleshooting application with respect to database issues using SQL Profiler.

Handled server performance and management, disk space utilizations, sizing, and capacity planning.

Using Performance Monitor tool performed SQL server daily health check and preparing a report based on it.

Wrote scripts for automating alerts (ex- Space issue, Job Failure, Partition Failure) using PowerShell, T-SQL

Monitored and troubleshoot the routine jobs, alerts, and maintenance plans.

•

Contact this candidate