PROFESSIONAL SUMMARY

 Over 7 years of experience as a Database Developer with proven expertise in designing, developing, and maintaining
enterprise-level SQL Server databases and reporting solutions.
 Experienced in Agile and Waterfall Methodologies with clear understanding of Iterative & Evolutionary principles.
 Proficient in full lifecycle database development, including database design, T-SQL programming, performance tuning, data
modeling, stored procedures, triggers, views, and indexing.
 Proficient in connecting to and troubleshooting SQL Server databases, ensuring seamless data integration and connectivity.
 Experience in preparation of Test Data for positive, negative and boundary testing scenarios. Experience in writing SQL queries
to validate the data in SQL Server, Oracle and MySQL database.
 Expertise in developing scalable, high-performance ETL workflows using SSIS and Azure Data Factory.
 Skilled in performance tuning, query optimization, and indexing strategies to enhance SQL Server database performance.
 Strong understanding of dimensional modeling and star/snowflake schema design for enterprise data warehouses.
 Hands-on experience working with Azure Data Services including Azure SQL Database, Azure Data Factory, and Azure Analysis
Services.
 Excellent communication skills with a strong ability to collaborate with cross-functional teams and translate business needs
into technical solutions.
 Experience leading peer code reviews and mentoring junior developers in best practices around SQL, SSIS, and Power BI.
 Expertise in Power BI, including DAX, Power Query, tabular models, and interactive dashboard/report creation using SQL Server
and Azure sources..
 Experience in Data Analysis, Data Validation, Data modeling, Data Cleansing, Data Verification and identifying data mismatches.
 Expert in SSRS report development, including parameterized, drill-through, and paginated reports using SQL Server Reporting
Services.
 Experience in using recursive CTEs, CTE, Temp tables and effective DDL/DML triggers to facilitate efficient data.
 Experience in Extraction Transformations and Loading ETL tools like SQL Server Integration Services SSIS, Data Transformation
Services DTS, Bulk Insert, and Bulk Copy BCP.
 Experience in using SSIS tools like Import and Export Wizard, Package Installation and SSIS package Designer
 Extensive experience in monitoring and tuning SQL Server and database performance using SQL Profiler, Index Tuning Wizard
and Windows Performance Monitor.

TECHNICAL SKILLS:

 Database Technologies: SQL Server (2016/2019), Azure SQL Database, T-SQL, Stored Procedures, Functions, Triggers, Views,
Indexing
 ETL Tools: SQL Server Integration Services (SSIS), Azure Data Factory
 Reporting & BI: SQL Server Reporting Services (SSRS), Power BI (DAX, Power Query, Tabular Models, Row-level security)
 Cloud Technologies: Microsoft Azure (ADF, Azure SQL, Azure Analysis Services, Azure Data Warehouse)
 Data Modeling: Star Schema, Snowflake Schema, Dimensional Modeling, Fact & Dimension Tables
 Performance Tuning: Execution Plans, Query Optimization, Index Tuning, SQL Profiler
 Version Control / DevOps: Visual Studio, GitHub, VSTS
 Other Tools: SQL Server Management Studio (SSMS), Power BI Gateway, SQL Agent Jobs, Windows Performance Monitor
 Methodologies: Agile (Scrum), Waterfall, SDLC, STLC
 Soft Skills: Stakeholder Communication, Requirement Gathering, Mentoring, Cross-functional Collaboration

PROFESSIONAL EXPERIENCE:

Database Developer
Franciscan Health: (Client location: Indianapolis, IN): Plano, TX
March 2022 to Present
Responsibilities:

 Responsibilities for Prepared Business Requirement Documents, Data mapping documents, Functional Design documents.
 Designed and developed SSIS Packages to import and export data from MS Excel, SQL Server 2019 and Flat files.
 Monitored and troubleshot API connections to ensure seamless data exchange between applications and SQL databases.
 Automated recurring data processing tasks using T-SQL and scheduled SQL Server Agent jobs.
  Developed high-performance stored procedures and views using T-SQL to handle complex data transformations for enterprise-
scale reporting systems.
 Built dynamic SSIS packages for incremental data loading with error logging, parameterization, and event-based email
notifications.
 Created advanced DAX measures for YoY comparison, cumulative KPIs, and time intelligence in executive Power BI dashboards.
 Used Power Query M language for custom column transformations, merging heterogeneous data sources before loading into
Power BI models.
 Migrated legacy ETL processes into SSIS with optimized lookup transformations, reducing load time by 40%.
 Developed advanced SQL queries to extract, manipulate, and/or calculate information to fulfill data and reporting
requirements including identifying the tables and columns from which data is extracted.
 Built Azure Data Factory pipelines with JSON-based parameters to orchestrate ETL flow between on-prem SQL and Azure Data
Lake.
 Designed star schema models including fact and dimension tables optimized for Power BI and SSRS reporting platforms.
 Implemented SCD Type 2 transformations in staging processes to maintain historical data accuracy across dimension entities.
 Deployed Azure SQL Databases with geo-replication and transparent data encryption enabled for secure enterprise-grade
deployment.
 Collaborated with business stakeholders to define technical requirements and align data solutions with strategic objectives.
 Tuned complex T-SQL queries using execution plans and indexed views to reduce report runtime by 60%.
 Rebuilt clustered/non-clustered indexes during off-peak hours based on fragmentation analysis using SQL DMV metrics.
 Diagnosed and resolved SQL Server connectivity issues, improving uptime and application reliability.
 Worked With the help of Poly base, T-SQL queries Imported 150 GB data from Azure Data Lake Store to Azure SQL Data
Warehouse.
 Developed data quality test plans and manually executed ETL and BI test cases.
 Designed Power BI dashboards using advanced DAX and Power Query for interactive reporting from Azure SQL and on-prem
SQL Server.
 Created Azure SQL DB, Azure SQL Data warehouse, Azure Analysis Services, Azure Data Factory.
 Created Azure Data Factory Pipeline to load data from On-premise SQL Server to Azure Data lake store.
 Designed, Developed Azure SQL Data warehouse Fact and Dimension tables. Used different distributions (Hash, Replicated and
Round-Robin) while creating Fact\Dim.
 Created CTAS for Full and Incremental dim & Fact tables load in Azure SQL Data warehouse.

Database Developer
Dollar General: Goodlettsville, TN
September 2020 to February 2022
Responsibilities:

 Responsible for database tuning using normalization and application tuning results based on business requirements.
 Worked on Designed and developed web based ecommerce application.
 Worked with SQL Server to extract, load information of Customers.
 Developed T-SQL scripts for calculating KPIs and aggregating sales metrics, used directly in Power BI visualizations and SSRS
exports.
 Validated data consistency across OLTP and OLAP systems by scripting stored procedures and building intermediate views.
 Implemented interactive dashboards in Power BI with complex DAX KPIs including profit margin, trend analysis, and forecasting
indicators.
 Acted as the technical liaison between reporting developers and database administrators to align data schema designs.
 Optimized SSIS data flow buffers and sort transformations to reduce memory pressure during ETL loads.
 Built dimensional models for sales, inventory, and employee metrics supporting star-schema design in reporting.
 Optimized data model relationships to reduce circular dependencies and improve Power BI refresh speed.
 Used Azure Data Factory for orchestrating end-to-end pipelines between SQL Server and Azure SQL Data Warehouse.
 Configured incremental refresh in Power BI datasets to optimize performance on large volume datasets from Azure SQL.
 Validated API data using SQL queries to ensure accuracy during testing and troubleshooting phases.
 Diagnosed and resolved SQL Server connectivity issues, improving uptime and application reliability.
 Developed pipelines to migrate on-premise databases to Azure SQL using Azure Data Migration tools.
 Created reusable SSIS templates with logging and auditing for migrating daily transactional data into centralized reporting
databases.
 Built real-time Power BI dashboards connected to Azure SQL and Azure Data Warehouse, incorporating DAX calculations and
custom slicers
  Automated data validation testing using SQL scripts to identify discrepancies in staging and production.
 Set up resource groups, Azure SQL servers, and databases within the Azure cloud environment.
 Managed the Metadata associated with the ETL processes used to populate the Data Warehouse.
 Designed SSIS ETL packages integrating data from flat files and SQL Server, applying derived column, conditional split, and SCD
transformations.
 Established backup and disaster recovery strategies for Azure SQL databases.
 Data flow Transformations Data Conversion, Export Column, Merge join, Sort, Union all, Conditional Split and more for existing
and new packages.
 Written complex SQL queries for validating the data against different kinds of reports generated by Business Objects XIR2

SQL Developer
City of Richmond: Richmond, VA
February 2019 to August 2020
Responsibilities:

 Responsible for different Data mapping activities from Source systems to Teradata
 Responsible for monitoring and making recommendations for performance improvement in hosted databases. This involved
index creation, index removal, index modification, file group modifications, and adding scheduled jobs to re-index and update
statistics in databases.
 Published and shared Power BI dashboards securely with teams using role-based access.
 Documented SSIS failures and coordinated fixes with ETL developers during integration testing.
 Assisted in writing SQL queries to support report validations against stored procedures and ETL outputs.
 Developed SQL scripts for data validation, ensuring accurate and complete datasets in production environments.
 Tested graphical representation of reports such as Bar charts, Pie charts as per End user requirements.
 Analyzes, tune and optimize ETL packages, Stored Procedures & SQL scripts to ensure peak performance.
 Support the ongoing data quality and data integrity initiatives through the creation and expansion of audit, balance, and
control procedures, alerts and reports.
 Verified SSRS report accuracy by checking parameter logic and output consistency against SQL datasets.
 Tested layout and formatting consistency for SSRS reports across multiple export formats.
 Developed and tested stored procedures, triggers, and functions within Azure SQL to handle business logic and data
processing.
 Verified Power BI dashboards against SQL databases for data correctness and visualization accuracy.
 Worked on Azure Data Factory, Azure Data Lake Analytics, Azure SQL Database and Azure Data Warehouse.
 Created stored procedures using Common Table Expression (CTE) and various types of UDF functions.
 Created Complex SSIS packages for XML, CSV and Excel file generation from SQL Server Database.
 Setting up Connection Strings and connecting SQL Server AZURE Databases from locally Installed SQL Server Management
Studio (SSMS) for Developers.
 Worked on Incremental loading with Merge statement in Stored Procedures. Scheduled SSIS packages with SQL Agent Job.
 Serving as the team’s Application DBA as required to support database deployments and performance tuning.

SQL Developer
Intel: Atlanta, GA
July 2017 to January 2019
Responsibilities:

Responsibilities:

 Developed and optimized T-SQL scripts, stored procedures, triggers, and functions to support complex data transformations
and business logic within SQL Server.
 Created and executed SQL test scripts for validating data consistency and transformations across ODS, STG, and EDW tables,
including dimension and fact tables.
 Implemented SSIS packages to perform ETL processes, including data extraction from various sources, transformation, and
loading into target SQL Server databases.
 Conducted performance tuning of SQL queries and optimized indexes by analyzing execution plans and implementing
appropriate clustered and non-clustered indexes.
 Built SSRS reports to present data insights and worked closely with business stakeholders to design and deliver user-friendly
reporting solutions.
 Participated in all phases of SDLC and worked collaboratively with UAT teams to validate application behavior against
functional requirements.
 Developed and maintained Azure SQL Databases and participated in cloud migration projects involving data pipelines and
reporting services.
 Worked closely with cross-functional teams and business analysts to understand requirements and translate them into
optimized SQL database designs and test strategies.
 Conducted data validation and regression testing using advanced T-SQL queries to ensure integrity of data loaded through ETL
processes.
 Performed backend testing using SQL Server Management Studio (SSMS) and Toad, verifying calculations, aggregations, and
transformations.
 Wrote detailed technical documentation, including SQL query logic, data flow diagrams, and data mapping strategies for
knowledge sharing and audit purposes.
 Collaborated with QA teams to define test plans, review data mapping documents, and validate test outputs with SQL queries.
 Led code review sessions, shared performance recommendations, and coordinated with team members to resolve production
issues in a timely and communicative manner.