Summary

Experience

Senior SQL Developer|Dell Technologies

Austin, TXMar 2021Present

• Optimized 50+ complex SQL queries and stored procedures, reducing report generation time by an average of 35%.
• Designed and implemented ETL processes using SSIS for a new data warehouse, integrating data from 7 disparate sources and increasing data availability by 20%.

SQL Developer|Accenture

Houston, TXJun 2018Feb 2021

• Developed and deployed 20+ stored procedures, functions, and views to support new client-facing dashboards, improving data access efficiency by 25%.
• Performed database performance tuning on SQL Server instances, resolving 3 major bottlenecks and reducing query execution times by up to 50%.

Junior Database Administrator|Texas Instruments

Dallas, TXMay 2017Jun 2018

• Monitored and maintained database health for 10+ production databases, ensuring 24/7 availability.
• Assisted senior DBAs in backup and recovery operations, contributing to a 100% data recovery rate in test scenarios.

Projects

E-commerce Data Warehouse

Jan 2022Jun 2022

• Designed and implemented a star schema data warehouse for e-commerce transactional data using SQL Server, integrating sales, customer, and product data.
• Developed SSIS packages to automate daily ETL processes, handling over 1 million records per day with less than 1% error rate.
• Created Power BI dashboards based on the data warehouse, providing key insights into sales trends and customer behavior, used by marketing team.

Financial Reporting Automation

Mar 2020Sep 2020

• Developed a Python script utilizing `pyodbc` to connect to a SQL Server database, automating extraction of financial data for monthly reports.
• Implemented stored procedures to aggregate and transform raw financial data, reducing manual data preparation time by 70%.
• Scheduled script execution via Windows Task Scheduler, ensuring timely generation of critical financial reports.

Customer Feedback Analysis System

Oct 2019Feb 2020

• Built a PostgreSQL database to store and analyze customer feedback data collected from various online sources.
• Developed SQL functions to perform sentiment analysis on text feedback, categorizing comments as positive, negative, or neutral.
• Created custom reports using Tableau to visualize sentiment trends and identify key areas for product improvement, leading to actionable insights.

Education

The University of Texas at Austin|Master of Science in Data Analytics

Austin, TXAug 2016May 2018

• Completed capstone project on predictive analytics for customer churn, achieving 15% improved model accuracy.
• Awarded Dean's List for academic excellence (GPA: 3.8/4.0).

Texas A&M University|Bachelor of Science in Computer Science

College Station, TXAug 2012May 2016

• Graduated Magna Cum Laude.
• Developed a relational database for student records as a final year project.

Skills

Database Technologies

Microsoft SQL Server (2012-2019)PostgreSQLMySQLT-SQLPL/SQLNoSQL (MongoDB)

ETL & BI Tools

SQL Server Integration Services (SSIS)SQL Server Reporting Services (SSRS)SQL Server Analysis Services (SSAS)Power BITableauInformatica PowerCenter

Programming & Scripting

PythonC#PowerShellBashXMLJSON

Cloud & DevOps

Azure SQL DatabaseAWS RDSGitJiraConfluenceCI/CD

Concepts & Methodologies

Database Design & ModelingPerformance TuningData WarehousingData MigrationData GovernanceAgile/Scrum