Sql Server Ms

Sures Khatri

(MSBI Developer)

ad8uqj@r.postjobfree.com 469-***-****

Euless, TX

Summary of Experience:

7+ years of IT experience in database development, design, analysis, and support of various applications. Have been involved in development, unit testing, data validation, and application production deployment.

Experienced in Data modeling up to 3 NF normalization and dimensional modeling with Star, Snowflake, and Star schemas. Well versed with T-SQL Querying concepts like different types of joins, common table expression, sub queries, group by-having, and top clauses.

Experience in writing Complex T-SQL User Defined Stored Procedures and constructing Tables, Triggers, User Defined Functions, Views, Indexes, Relational data models, and data integrity.

Expertise in optimizing the queries by reading estimated and actual execution plans, creating suggested indexes, Index views, and clustered and non-clustered indexes.

Used SQL Server Profiler to diagnose OLTP applications’ background running queries as well as performance issues. Used Database Engine Tuning Advisor to balance the workload of the database queries.

Experience in creating SSIS packages with control flow and data flow engines for integrating data using OLE DB connection from homogeneous and heterogeneous sources (Excel, CSV, Flat file, Oracle), Utilized multiple transformations like Data Conversion, Conditional Split, SCD, Bulk Insert and Merge Join, etc. to achieve data transformation as per customer’s requirements.

Extensive knowledge in Extraction, Transforming, and Loading (ETL) data using SQL Server Integration Services (SSIS), Bulk Insert.

Expert in creating various types of reports like complex drill-down reports& drill through reports, Matrix reports, sub reports, and charts using SQL Server Reporting Services (SSRS) based on Relational and OLAP databases.

Expertise in various phases of project lifecycles (Design, Analyzing, Implementation, and testing).

EDUCATION/CERTIFICATIONS

Bachelor of Education - Tribhuvan University, 2010.

PROFESSIONAL EXPERIENCE:

Database Developer, United States Department of Agriculture 04/2023 – Present

Washington D.C.

Design and develop complex databases using MS SQL Server 2016/2019 to support various applications and business needs.

Create efficient data models and database schemas based on business requirements in SQL Server.

Develop,Implement advanced queries, stored procedures, views, functions, and triggers using T-SQL in MS SQL Server 2016/2019.

Develop high-quality database solutions leveraging MS SQL Server 2019 and Visual Studio 2022 for code management and debugging.

Monitor and optimize database performance using SQL Server 2019 tools, ensuring minimal downtime and high availability.

Conduct query optimization and index tuning to improve performance.

Troubleshoot slow-running queries and resolve database bottlenecks.

Collaborate with developers, data architects, business analysts, and system administrators to meet business goals.

Develop and automate database maintenance tasks, such as backups, indexing, and monitoring,using MS SQL Server 2019.

Work with DevOps teams to implement continuous integration/continuous deployment (CI/CD) for database changes,utilizing Visual Studio 2022 and SQL Server 2019.

Create and maintain technical documentation for database systems and solutions,ensuring alignment with SQL Server 2016/2019 standards.

Environment:

MS SQL Server 2016/2019,Visual Studio 2019/2022, Azure DevOps, Devapps, SharePoint, Jira T-SQL, MS Excel.

MS SQL/SSIS/SSRS Developer, TD Bank July 2020 - March 2023

Dallas,TX

Involved in all phases of the System Development Life Cycle (SDLC) of the project.

Designed and developed data integrity and mapping solution using SQL scripts and Data

Profiler task to validate completeness and accuracy of the different source data systems.

Designed different database diagrams along with mapping of columns from source to staging and data warehouse, implemented data migration strategies for a full load, incremental load,and remigration clean up the load.

Developed different database objects to support configurable metadata driven development as per business requirements.

Extensively wrote and edited existing Stored Procedures, User Defined Functions, and Triggers using T-SQL.

Created the Best Coding Practices Document for stored procedures & amp; functions for the developers.

Created new database files and database file groups in SQL Server 2016 using SSMS and T-SQL.

Extensively involved in the full lifecycle of ETL software development-analysis, design, building, documentation, and unit testing for the project using SQL Server Integration Services.

Transferred data from various OLTP data sources, such as Oracle, Teradata, MS Access, MS Excel, Flat files, and CSV files into SQL Server 2016.

Designed and developed SSIS packages, stored procedures, configuration files, tables, views,and functions, and implemented best practices to maintain optimal performance.

Designed and tested (Unit, Integration, and Regression) packages to extract, transform and load data using SQL Server integration services (SSIS).

Created Sub Reports and Drill down Reports as per the client requirements using SSRS, T-SQL,and MDX.

Worked on parameters to generate cascaded parameterized reports along with that extensively used global variable, expressions, and functions.

Analyzed reports and fixed bugs in stored procedures on the ongoing database operations as needed, to resolve business problems.

Responsible for deploying reports to Report Manager and Troubleshooting for errors occurring in execution.

Generated reports that can handle dynamic grouping and dynamic sorting for the purpose of efficient and clear viewing of the reports.

Environment:

MS SQL Server 2016 MS SQL Server Reporting Services, Integration Services, Analysis Services,Visual Studio 2017, T-SQL, MDX, MS Excel, MS Access.

SQL/ETL Developer, Inova Health Oct 2018 - Jun 2020

Falls Church,VA

Involved in the data migration strategy from MS SQL Server 2012 to MS SQL Server 2014 during the initial phase of the project.

Design and develop Packages in SSIS and procedures in SQL for the ETL load and processing by implementing all the business logic.

Worked as a data warehouse report developer during later phase of the project, participated in Dimensional modeling.

Create store procedure specifically for cleansing and managing data and used the same in SSIS Execute SQL Task.

Developed complex stored procedures, triggers, functions, tables, views, and other T-SQL code construct to ensure efficient data manipulation.

Developed SSIS Templates for developing SSIS Packages that can be dynamically deployed into development, Testing, and Production Environments.

Maintained the physical database by monitoring performance, and integrity and optimized SQL queries for maximum efficiency using SQL Profiler and Index Tuning Wizard.

Developed Custom Reports and Various types of Charts, Matrix, Ad-hoc, Drill-down, Lists,Tabular, Parameterized, and Cascading Reports.

Identified and worked with parameters for creating cascading parameterized reports in SSRS 2014.

Deployment and testing of the SSRS across different environments and testing the reports for performance.

Deploying and scheduling Report subscriptions using SSRS to generate all daily, weekly, monthly, and quarterly Reports including status.

Environment:

MS SQL Server 2012/2014 MS SQL Server Reporting Services, Integration Services, Analysis Services, Visual Studio 2008/ T-SQL, MS Excel, MS Access.

Jr. SQL Developer, Winco Foods Jan 2017 - Sep 2018

Boise, ID

Assisted in designing database schemas and creating tables, indexes, and relationships to support application development.

Developed and maintained SQL queries, stored procedures, and functions for data retrieval and manipulation.

Supported data migration efforts by writing and executing scripts to transfer data between legacy systems and new databases.

Worked with senior developers to troubleshoot and resolve database issues, including performance and data integrity problems.

Generated reports and data visualizations using SQL and reporting tools to provide insights and support decision-making.

Worked with senior developers to migrated data from diverse sources, including legacy systems, using SSIS packages and designed custom reports in MS SQL Server with SSRS for performance-based insights.

Environment:

SQL Server 2012, MS SQL Integration Services, Analysis Services, Reporting

Services, T-SQL, MDX, MS Excel.

SKILLS SUMMARY:

RDBMS

Microsoft SQL Server 2008R2/2012/2014/2016,2019, Oracle, PostgreSQL, MYSQL

Operating System

Microsoft Windows, UNIX, LINUX

SQL Server Tools

SSMS, SQL Profiler, Query Analyzer, DTA, Enterprise Manager, Activity

Monitor, Index Tuning Wizard, SQL Trace tools, SQL Agent, Execution Plan

Bi Tools

SSIS, SSRS, Power Bi Desktop

MICROSOFT

TECHNOLOGIES

MS Office, Excel, MS Access Business Intelligence Development Studio,

Visual Studio, Azure DevOps, SharePoint Server, TFS

LANGUAGES/SCRIPT

S

T-SQL, PL-SQL, XML, C#

Contact this candidate