Sunil Paudel

SQL/SSIS Developer

Northlake, Texas, United States

+1-225-***-****

adx992@r.postjobfree.com

SUMMARY

*Software Developer with over 4+ years of progressive experience in Database Design, Database Optimization, Java Applications Programming, and Performance tuning.

*Proficient 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.

*Extensive knowledge and Experience in dealing with Relational Database Management Systems, including Normalization, Stored Procedures, Constraints, Querying, Joins, Keys, Indexes, Data Import/Export, and Triggers.

*Extracted, transformed, and loaded data from heterogeneous data sources and destinations like Access, Excel, CSV, Oracle, flat files using connectors, tasks, and transformations provided by SSIS.

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

*Sophisticated grasp of SQL code generation, analytics, reporting, and business intelligence.

*Diverse knowledge and experience of complex scripting T-SQL queries, Complex Stored Procedures, User Defined Functions UDF, and Database Triggers, using tools like SQL Profiler and Database Tuning Advisor DTA.

*VB .Net and C# used for scripting in Script Tasking in SSIS to control the flow of the SSIS package.

*Accomplished deadlock troubleshooting and resolving issues by debugging programs and managing databases.

*Worked on administration tasks such as data loading, batch jobs, data unloading, backup & recovery, user and application table management, upgrades, and creating databases/file groups/files/transaction logs.

*Automated the process through the UNIX Shell Scripting and auto sys job scheduling.

*Hands-on experience in Atlassian Jira tool, Git, and GitHub

*Technologically savvy and focused SSRS developer with a strong background in advanced data management and troubleshooting skills.

*Extensive knowledge of MS Excel (Power Query, Macros, Pivot Table) WORK EXPERIENCE

August 2022-Current

SQL/SSIS Developer

Farragut Systems

Durham, North Carolina, United States

Worked on LR-CAMA application for North Carolina Property Tax System Environment: MS SQL Server 2019, SQL Server Integration Services, SQL Reporting Services, Microsoft Visual Studio, SQL Server Management Studio, MS Excel, T-SQL, TFS Responsibilities:

•Involved in securing the database transactions and information inside the database.

•Used various SSIS tasks such as Conditional Split, Derived Column, and lookup which were used for Data Scrubbing, and data validation checks during Staging, before loading the data into the Data warehouse.

•Applied various types of Control Flow tasks and Data Flow tasks like Container, execute the task, Script task, Transfer for Loop Container, Aggregate, Derived column, and Transfer Database Task according to the need of Data Transform and Data Cleansing and insert new data into Database using SSIS 2014.

•Tune various packages for reducing their processing time by using a parallel processing approach and using MS SQL Profiler, Index Tuning Wizard, and SQL Query Analyzer in MS SQL Server 2019.

•Involved in Planning, Defining and Designing databases based on business requirements and provided documentation.

•Transformed data from various data sources using OLE DB connection by creating various SSIS packages.

•Optimized the performance of queries with modifications in T-SQL queries, removed unnecessary columns, and eliminated redundant and inconsistent data.

•Responsible for creating parameterized and drill down reports based on the requirements using SSRS 2012.

•Provided query and database scripts for clients to resolve data and application issues.

•Translated requirements, designs, and functional specs into effective test plans and test cases. February 2022-July 2022

SQL Developer

Systems Technology Group (Client: Ford Motor Company)

Troy, Michigan, United States

Worked on optimizing FBMS (Fleet Business Management System) application. Environment: Microsoft SQL Server 2019, SSIS, SSRS, SSAS, XML, ETL, OLTP, OLAP, FTP. Responsibilities:

•Developed ETL Database model to carry out new procedures and create database warehouse dimensions to accept ETL outputs.

•Developed Data Dictionary for FBMS database.

•Created stored procedures, triggers, views, functions for application while utilizing joins and sub-queries to simplify complex queries and optimize procedures and triggers.

•Gathered business requirements, develop physical data models, create DDL scripts to design database schema and database objects.

•Executed different types of Control Flow tasks and Data Flow tasks like Container, execute task, Script task, Transfer for Loop Container, Aggregate, Derived column, and Transfer Database Task according to need of Data Transform and Data Cleansing and insert new data into Database using SSIS 2019.

•Worked with SSIS to load data files to SQL Server and the other way. Maintaining the data, database Backups and Restoration, backup strategies, scheduling backups. April 2021-December 2021

Software Developer (Java)

Apex Systems (Client: Wells Fargo Bank)

United States

Worked on Origination applications focussing on Small Business Applications for small business customers applying for loans.

Environment: Java, J2EE, Spring, Hibernate, Web Services (SOAP and RESTful), XML, CSS3, Javascript, ReactJs, SVN

(Tortoise SVN), SOAP UI, SQL server 2014, JDBC, Eclipse, Web logic Windows, Tomcat 9, Web services. Responsibilities:

•Designed and coded application components in an Agile/TDD environment utilizing a test-driven development

•Integrated spring DAO for data access using Hibernate

•Developed application using spring framework that leverages model view layer architecture, configured dependency injection

•Utilized spring MVC and HibernateJPA framework for development

•Wrote spring services in the service layer for Oracle data retrieval operations using Hibernate

•Used spring AOP, and Spring IOC frameworks extensively during the development

•Used Hibernate for object Relational Mapping and used JPA for annotations

•Implemented static, dynamic, and distributed caching, used LRU (Least Recently Used) cache eviction policies into the project

•Used Gradle scripts for building and deploying the application in web/App servers

•Wrote Junit test cases for testing all spring service calls and spring MVC validations

•Worked in SQL 2019 to utilize new features like Change Data Capture CDC, Transparent Data Encryption TDE, and Policy-based Management.

•Worked with various tasks of SSIS including Transform Data Task, Execute SQL Task, FTP Task, For Each Loop containers, etc.

•Interacted with clients to analyze business needs. Provided software product design and developed technical roadmaps for the solution through the project lifecycle and beyond.

•Created SSIS packages for Uploading of different formats of files (Excel, Access, dbf) and databases (SQL server, Flat files) into the SQL Server data warehouse using SQL Server Integration Services (SSIS). August 2019-March 2021

SQL Developer

CareFirst

Baltimore, Maryland, United States

Involved in Maryland Plans- Individual and Family Healthcare Plans. Environment: Microsoft SQL Server 2016/14, SSIS, SSRS, SSAS, XML, ETL, OLTP, OLAP, FTP, ASP.Net, C#, VB.Net, SQL Profiler, Windows XP, and Bit Bucket

Responsibilities:

•Designed and developed hundreds of SSIS packages for different ETL projects both programmatically and using GUI.

•Applied various types of Control Flow tasks and Data Flow tasks like Container, execute the task, Script task, Transfer for Loop Container, Aggregate, Derived column, and Transfer Database Task according to the need of Data Transform and Data Cleansing and insert new data into Database using SSIS 2016.

•Worked with SSIS to load data files to SQL Server and the other way. Maintaining the data, database Backups and Restoration, backup strategies, and scheduling backups.

•Developed Tablix Reports, Matrix Reports, Parameterized Reports, and Sub reports using SQL Server Reporting Services

(SSRS).

•Developed and created new database objects including tables, views, indexes, stored procedures and functions, Advanced queries, and updated statistics using Query Analyzer and Enterprise Manager on the existing servers.

•Created Ad hoc and Sub-reports using Report Designer and Report Builder based on the requirements.

•Used Git as version control, created repositories, and merge requests to push the SQL codes, Power BI templates, and Tabular model solution file on a daily basis.

•Imported text files, and CSV files data from FTP through SSIS to the local environment.

•Deployed the SSIS Setup and Database Setup in production environments.

•Optimized the performance of queries with modification in T-SQL queries, removed unnecessary columns, eliminated redundant and inconsistent data, normalized tables, established joins and created Clustered/Non-Clustered indexes wherever necessary.

•Created Temporary Table and Common Table Expression (CTE) for query Optimization and performance tuning.

•Use ADO.net to connect SQL Server with the application.

•Resolved Bugs in the production Environment created by Quality Assurance. EDUCATION

2013-2019

Ph.D. in Entomology

Louisiana State University

Louisiana, United States

• Biological Sciences/Life Sciences

2011-2013

MS in Entomology

University of Idaho

Moscow, Idaho, United States

• Biological Sciences/Life Sciences

SKILLS

Database Database Engine Database Modeling Data Models Database Design DDL MS ADO ADO.NET MS SQL Server Microsoft SQL Server SQL Server Mysql OLE DB OLTP Oracle Relational Database SQL SQL Queries Stored Procedures .NET Microsoft Visual Studio Visual Studio Application Programming C# Code Generation Git GUI Javascript MSVC SCSI PHP Reporting Tools Scripting Shell Scripting VB.NET Visio XML Microsoft SQL Server Reporting Services SQL Server Reporting Services Microsoft SSRS SSRS OLAP SAS T-SQL FTP Data Cleansing Data Management Data Sources ETL Microsoft SQL Server Integration Services SQL Server Integration Services Online Analytical Processing Power Bi CSS HTML MS ASP ASP.NET Data Warehouse BMC Helix BMC Remedy Gather Business Requirements JIRA JOB Scheduling Version Control Backups Graphical User Interface User Interface UNIX Unix Shell SAP R2 Optimization BCP Eclipse Crystal Reports MS Office Data Validation Scheduling Production Environment Performance Tuning Test Cases Test Plans Quality Assurance Analyzer Serial Attached Scsi Statistics Business Intelligence Import/Export Translated Business Requirements Documentation Database Management Biological Sciences Life Sciences Excel MS Excel Microsoft Office Photoshop Microsoft Windows Windows 10 Windows XP Java React.js CERTIFICATIONS

SAS Programmer (Base Certified)

LANGUAGES

English - Fluent Hindi - Fluent Nepali - Fluent

Contact this candidate