Summary
Highly accomplished SQL Developer with 6 years of experience specializing in robust database solutions, complex query optimization, and efficient data warehousing. Proven track record in designing, developing, and maintaining critical databases to support business operations and analytical needs. Adept at collaborating with cross-functional teams to translate business requirements into scalable data architectures and deliver high-performance data-driven applications.
Experience
Senior SQL DeveloperDell Technologies
- 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 DeveloperAccenture
- 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 AdministratorTexas Instruments
- 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
- 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
- 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
- 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 AustinMaster of Science in Data Analytics
- 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 UniversityBachelor of Science in Computer Science
- 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