SQL SERVER DEVELOPER

Full Legal Name: Umesh Khanal

Current Location: Herndon, VA 20170

Email ID: ad2oo0@r.postjobfree.com

Contact no.: 1-571-***-****

Work Authorization: US Citizen

PROFESSIONAL SUMMARY

●Around 7+ years of experience with focus on Database design and Development using different tools of T-SQL DDL and DML Coding and installing, upgrading, configuring and implementation of MS SQL Server 2012/2014/2016/2017 in Windows Environment.

●Excellent experience in developing complex Stored Procedures, Views, Cursors, and Joins.

●Good experience in creating User Defined Functions and Triggers in observing Business Rules.

●Expertise in working with Version control system SVN,VSS,TFS, SYNERGY.

●Experience in creating/deploying Data Transformation Services DTS, MS SQL Server Integration Services SSIS packages, Reporting Services SSRS .

●Strong technical knowledge in MS SQL Server development including DTS, Microsoft Analysis Services, Performance tuning, Reporting, Designing logical/physical databases and Troubleshooting

●Experience in Extraction Migration of Data from heterogeneous data sources like Excel, MS Access, Oracle and to MS SQL Server by using Import Export Wizard, DTS SSIS, and BCP Bulk Insert utilities

●Expertise in creating Packages by SSIS for ETL work.

●Performed archiving and achieved automated processing of the raw data through the ETL process in SSIS.

●Expertise in using variables, property expressions, script tasks in SSIS.

●Transformed data from various data sources using OLE DB / MS ACCESS connection by creating various SSIS packages.

●Expertise in handling Errors by using Event Handler and can provide Logging, Custom Logging for SSIS Packages.

●Experienced with DTS/SQL server integration services SSIS Packages Developing, Deploying, Scheduling, Troubleshooting and monitoring for performing Data transfers and ETL Purposes across different servers.

●Experience in enhancing and deploying the SSIS Packages from development server to production server.

●Expert in extracting and transforming data using Import/Export, DTS Packages, MS SQL Server Integration Services SSIS Packages, Bulk Insert and Utilities like BCP.

●Used SQL Profiler for troubleshooting, monitoring, and optimization of SQL Server and developer database code as well as T-SQL code from developers and QA.

●Created SQL Server Integration Services packages for the ETL tasks.

●Coordinated with DBA in creating and managing tables, indexes, triggers, db links and privileges.

●Used SQL Server profiler for auditing and analyzing the events which occurred during a particular time horizon and stored in script.

●Strategized and made migration plans.

●Built, Configured, Packaging and Deployed Packages.

●Proficiency in creating different types of reports such as Cross-Tab, Conditional, Drill-down, OLAP and Sub reports, ad hoc reports, parameterized reports, custom reports and formatting them

●created Tabular reports, Matrix reports, List Chart reports, Parameterized reports, Sub reports, Ad-hoc reports, Drill down reports as well as interactive reports according to business requirements in a time restricted environment.

●Developed Linked reports and Subreports as per user and business specifications

●Used complex expressions to calculate, group, filter, parameterize and format the contents of a reports according to business user's requirements

●Expert in fine tuning the SSIS packages.

●Self-motivated and possess ability for critical thinking, analysis, good interpersonal and communication skills. Team-oriented, technically motivated and creative. User oriented with a desire to learn client's business requirements.

●Strong inclination for finishing a job before the project deadline. Flexible and versatile to adapt to any new environment and work on any project.

TECHNICAL SKILLS:

●Databases: MS SQL Server 2012/2014/2016/2017, DB2 UDB 8.X/7.X,Oracle, MS Access, Sybase

●Programming Languages: T-SQL, PL/SQL, Visual Basic 6, Asp.net, C, C, MDX, Shell Scripts

●RDBMS: MS SQL Server, MS Access, Sybase, Teradata V2R5, Oracle, IBM DB2 UDB,MS Visual Source Safe.

●Database Design Tools And Data Modeling: MS Visio, ERWIN, Star Schema/Snowflake Schema modeling Relational, Fact Dimensions tables, Dimensional and multidimensional modeling Physical logical data modeling and Denormalization techniques, MS Access, MS Project.

●Tools and Utilities: SQL Server Management Studio, SQL Server Enterprise Manager, SQL Server Profiler, Import Export Wizard, Visual Studio.Net, Visual Source Safe, DTS,

●Operating Systems: Windows XP, Linux.

●DWH / BI Tools: SQL Server Reporting Services SSRS,SQL Server Analysis Services SSAS,SQL Server Integration Services SSIS, Business Intelligence Development studio BIDS, Visual Studio, Crystal Reports 9.0, Performance Point Server, ProClarity, SQL Plus, SQL Loader, MS Visio, Erwin, Informatica 6.x.Packages: MS Office, MS Outlook Microsoft Office Suite, Microsoft Office SharePoint Server MOSS.

●Web Technologies: HTML, XML.

EDUCATION:

Bachelor’s in Computer Application (BCA) – 2015

PROFESSIONAL EXPERIENCE:

SQL/ETL Developer

Client: SeaWorld Park and Entertainment

Location: Orlando, Florida

Duration: November 2022 - Present

Responsibilities:

●Create and maintain clearly written technical, user, and system documentation.

●Worked with complex SQL, Stored Procedures, Triggers and packages in very large databases from various servers.

●Performed the Migration of the Existing DTS packages to the SSIS Batch jobs.

●Used Email Notification package success or failure. If the package is successful, send the mail with the package name, how many records inserted, updated and total records using Send Mail Task. If the package is failed it will send the mail package name and error description using On Error Event handlers in Send Mail task.

●Created and scheduled SSIS packages to pull data from SQL Server and exported to Excel Spreadsheets and vice versa.

●Created Package Configuration file with connection information source, staging and destination databases and send mail task connection information and log directory path value

●Provided Package Configuration, Custom Package Logging, Error Handling, and Email Notification to SSIS packages.

●Extensively used SSIS Packages to load data from various formats into a warehouse

●Designed and developed Star Schema in Data warehouse

●Extensively used SQL Profiler to check the performance of the database

●Created SSIS packages to pull data from different sources, like SQL server, flat files and loaded in to the Staging and destination databases

●Created User Interface reports for validating the Data through Reporting Services.

●Highly responsible for development and management SSIS projects.

●Extracting and Loading data into SQL Server Database using SSIS.

●Scheduling Maintaining ETL packages in terms of data validation and consistency.

●Designing SSIS packages to migrate data from database Hierarchical to database Relational .

●Created Mapping, Design and technical Documentation for complex SSIS packages.

●Experience in maintaining Error logging using Exceptional Handling in T-SQL and SSIS.

●Involved in Maintaining Database with Backup, Restore Strategies and scheduling those backups using SSIS packages as a Developer.

●Deployed many packages on different servers using SSIS package Configurations.

●Involved in Backup and Restoring the Databases.

●Extensively designed the packages and data mapping using Control flow task, Sequence container task, Data Flow Task, Execute SQL Task, Data conversion task, lookup, Derived Column task and Script Task in SSIS Designer.

●Responsible for scheduling the packages through Jobs.

Environment: MS SQL Server 2012/2014/2016/2017, MS Excel, MS SQL Server Integration Services SSIS, Team Foundation Server, SQL Profiler, Windows Advanced Server, Oracle SQL Developer

SQL/ETL Developer

Client: US Bank

Location: Minneapolis, MN

Duration: January 2022 - October 2022

Responsibilities:

●Involved in gathering requirements, worked closely with business users and implemented logical and physical modeling using Erwin.

●Developed various T-SQL stored procedures triggers, views, and adding/changing tables for data load and transformation, and data extraction.

●Created Database Objects like Tables, Stored Procedures, Views, Triggers, and UDFs.

●Created complex queries involving CTE's, Subqueries and Joins.

●Created Indexes for fast retrieval of the data.

●Extensively used Tasks and Transformation of Control flow and Data flow in SSIS Packages to effectively accomplish complex business requirements.

●Used SSIS to implement the Slowly Changing Transformation, to maintain Historical Data in the Data warehouse.

●Involved in Performance tuning and Query Optimization using execution plan.

●Created new databases/tables to put in the extracted data and rebuild the relationship.

●Created SSIS packages to pull data from SQL Server and exported to Excel Spreadsheets and designed SSIS Packages to extract, transfer, load ETL existing data into SQL Server from different environments for the SSAS cubes.

●Created the SSIS /DTS packages and scheduled them using Sql Server agent.

●Developed ETL packages with different data sources SQL Server, Flat Files, Excel source files, XML files etc. and loaded the data into target tables by performing different kinds of transformations using SQL Server Integration Services SSIS .

●Utilized event handling effectively to generate audits and logs for the generated SSIS packages.

●Performed archiving and achieved automated processing of the raw data through the ETL process in SSIS.

●Deployed SSIS Packages from Dev/Staging/Production using Package Configurations

●Performed Identification, analysis and resolved report defects within time scope and established development guidelines.

●Used SQL Profiler for troubleshooting, monitoring, and optimization of SQL Server and developer database code as well as T-SQL code from developers and QA.

Environment: SQL Server 2012/2014/2016/2017, MS Excel, SQL Profiler, ETL, T-SQL, MS SQL Server Integration Services.

SQL/ETL Developer

Client: Caliber Home Loans

Location: Coppell, TX

Duration: January 2020 – December 2021

Responsibilities:

●Planned, Defined and Designed data based on business requirements and provided documentation.

●Designed Database using Erwin data modeler.

●Created SSIS Packages using Pivot Transformation, Fuzzy Lookup, Derived Columns, Condition Split, Term extraction, Aggregate, Execute SQL Task, Data Flow Task, Execute Package Task etc to generate underlying data for the reports and to export cleaned data from Excel Spreadsheets, Text file, MS Access and CSV files to data warehouse.

●Created SSIS packages for data Importing, Cleansing, and Parsing etc. Extracted, cleaned and validated.

●Modified the existing SSIS packages to meet the changes specified by the users.

●Scheduled Jobs for executing the stored SSIS packages which were developed to update the database on Daily basis.

●Designed and deployed reports with Drill Down, Drill Through and Drop down menu option and Parameterized and Linked reports.

●Perform data analysis, data cleansing and source to target mappings using transformations.

●Work closely with cross functional business teams to document ETL requirements and turn those requirements into ETL jobs.

●Develop stored procedures, views, and triggers as needed.

●Work with other Developers and Computer Operations to support test, QA, and production environments including daily administration, batch processing, change management, environment migration, and tool automation.

●Created SQL Server Integration Services packages for the ETL tasks.

●Developing scripts for Exception handling for each SSIS package.

●Used Script component to derive error description from the metadata.

●Testing to ensure correct application of transformation logic from source to target.

●Automation of the ETL jobs using SQL Server Agent Job to run on a daily schedule.

●Setup email notifications incase of job failure in SQL Server Agent.

●Develop numerous drill-through and matrix reports for membership data analysis.

●Documentation for the complete conversion process.

Environment: SQL Server 2012/2014/2016/2017, SSIS, SSRS, SQL Server Management Studio, T-SQL, MS Project and MS Excel.

SQL/BI Developer

Client: Amazon

Location: Clear Brook, VA

Duration: March 2018- December 2019

Responsibilities:

•Provided back-end support for functional testing and performance testing. Developed scripts to migrate data from multiple sources to desired destination using ETL tools.

•Modified SSIS ETL packages for changed business requirements to load data from different source files to SQL Server tables in the data warehouse.

•Developed, monitored, and deployed SSIS packages.

•Experience in creating master and child packages, using package configurations (SQL Server) and SSIS logging.

•Worked on updating slowly running stored procedures with Query optimization techniques.

•Created Database Maintenance Planner for the Performance of SQL Server, which covers Database Integrity Checks, Update Database Statistics and Re-indexing.

•Analyzed and enhanced the existing ETL strategies to populate the existing data warehouse with facts and dimensions based on new requirements in a multi-application environment.

•Designed SSIS packages to migrate the data from SQL Server to the staging area.

•Created SSIS Packages for ETL process to transform and load data from flat files to the data warehouse.

•Planning Complete Back-up of Database and Restored the Database from Disaster Recovery.

•Performed data profiling, cleansing, validation, and verification with SSIS tasks. Implemented Event handlers and Logging, as necessary.

•Involved in complete Software Development Life Cycle (SDLC), which includes requirement gathering, analysis, design, development, and Implementation.

•Involved in coordinating with source systems owners to fix issues in the daily ETL supporting multiple applications.

•Created Data Sources, Datasets and Parameters as per the requirements of the reports

•Designed reports based on new requirements for Design and Project Planning with SQL report service (SSRS).

•Rendered SSRS reports to multiple formats per the business requirements utilizing subscriptions.

•Created a multitude of reports with SSRS.

•Incorporated Team Foundation Server for source control, check-in, and check-out.

Environment: Visual Studio, TFS, T-SQL, MS Access, Windows XP/2010 Server, Azure SQL, SSRS, ETL, SQL Server 2012/14, SQL Server Data Tools.

SQL/ETL Developer

Client: Shell Corporation

Location: Houston TX

Duration: June 2016- February 2018

Responsibilities:

•Worked on SSIS Package, DTS Import/Export for transferring data from Database (Oracle and Text format data) to SQL Server.

•Worked on the data warehouse design and analyzed various approaches for maintaining different dimensions and facts in the process of building a data warehousing application.

•Involved in performance tuning and optimization on SQL queries, to improve the database performance.

•Develop all the required stored procedures, user defined functions, and triggers using T- SQL.

•Experienced in installing and configuring Reporting services and assigning permissions to different levels of users in SSRS.

•Utilized SSIS (SQL Server Integration Services) to produce a Data Mart for reporting.

•Implemented SSIS data transformation scripts, created maintenance procedures, and provided data integrity strategies.

•Involved in Loading Data into Dimension Tables and Fact tables using SSIS Packages.

•Implemented Extracting, Transformation, and Load (ETL), Import, Export Activities using SSIS Package.

•Created new ETL packages to validate, extract, transform and load data into data warehouse databases, data mart databases using SSIS packages.

•Modifying existing SSIS packages and Stored-Procedures which are used in revenue data ETL process.

•Efficiently implemented Error handling in SSIS.

•Created report models to create ad-hoc reports with report builders with SSRS.

•Implemented an interface to organize SSRS reports, sort data sources, schedule report executions, and track report history.

•Deployed multiple types of reports on SharePoint and utilized dashboards with SSRS.

Environment: SSIS, SSAS, SSRS, T-SQL, Windows Server 2012/14, Oracle, Data Tools (SQL Server) DTS, SQL Server 2005/2008 Enterprise Edition.

Contact this candidate