Dilip R. Thapa

ad13gl@r.postjobfree.com

214-***-****

US Citizen

SUMMARY:

Over 7+ years of IT experience in Database Development, Administration, Data Analysis, System Analysis, Design, Development and Support of MS SQL Server 2019, 2017, 2016, 2014, 2012, 2008 in Production, Testing and Development.

Extensive experience in interacting with business users, gathering requirements, data analysis, data mapping, gap analysis and documentation.

Experience with software development life cycle (SDLC), Agile / Scrum and Project Management Methodologies. Extensively involved through the Software Development Life Cycle (SDLC) from initial planning through implementation of the projects.

Experience in writing Complex T-SQL Stored Procedure and constructing Tables, Triggers, user functions, Views, Indexes, Relational data models, Cursors and data integrity, SQL joins and writing Sub Queries.

Well versed in designing highly flexible Database Architectures and Data Modeling, Data Mapping, Table Normalization, performance tuning and optimization of SQL scripts and SQL queries.

Expertise in creating and managing Package Configurations, Logging system, Package deployment and User-defined Variables for SSIS Packages.

Experience working with Data Cleansing technique, different types of Dirty Data from different sources.

Expertise in Merging data from various Heterogeneous sources, Populating Dimension and Fact tables in Data warehouses and Data Marts, Cleaning and Standardizing data loaded into OLTP and OLAP databases using SSIS.

Strong knowledge in designing Extraction, Transforming and Loading (ETL)data flows using creating mappings/workflows to extract data from SQL Server and Data Migration and Transformation from Oracle/Access/Excel Sheets using SQL Server SSIS.

Experience in using Performance Monitor, SQL Profiler and optimizing the queries, tracing long running queries and deadlocks

Hands on experience in creating and migrating AOL objects such as Concurrent programs, Value sets, Menus, functions.

Working Knowledge in Agile development methodologies like TDD and BDD

Experience in DTS Migration and Metadata Management: Migrating DTS packages to Package Migration Wizard, and Storage Management using SSIS (SQL Server Integration Services).

Experience in installation, configuration of Oracle, MySQL, MS Access, MS SQL Server, MongoDB and DB2.

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

Working Knowledge on CI/CD Technologies

Experience in cubes construction based on data volumes mostly adhering to Star Schema using strong knowledge of Data Warehousing, Star Schema, Fact and Dimension Tables. Frequent use of ERWIN to design Normalized and De-Normalized Data Models.

Excellent communication skills with capability to form and maintain positive and productive working environment as an individual or a team player.

Educational Details:

Bachelor’s in business administration (May 2012), Tribhuvan University.

Kathmandu, Nepal.

TECHNICAL TOOLS:

Operating systems

Windows 98/NT/2000/XP/Vista/Windows7/8/10

Databases

MS SQL Server 2005/2008,2012/2014,2017/2019, MS Access, MongoDB

Database Tools

SQL Enterprise Manager, SQL Profiler, DTS Import/Export, SQL Client Configuration utility, Backup Server, Replication Server, OLAP Services, SQL Server Management Studio, SQL Server Business Intelligence Development Studio (BIDS)

ETL Tools

DTS, SQL Server Integration Services, SQL Server Analysis

Reporting Tools

SSRS, R studio, Crystal Reports, Congo's, Micro Strategy

Development Skills

Transact SQL (T SQL), PL/SQL

Languages

C, C++, HTML, XML, VB.Net, Asp.Net (C#)

Application Packages

Microsoft Office Suite

PROFESSIONAL EXPERIENCE:

SQL Developer

Elevance/Antham Health

VA

March 2023 – Current

ROLES AND RESPONSIBILITIES

Created Database objects – Table, views, and Function and developing procedures for implementing application Functionality at the database side for performance.

Worked on DataMart

Created database objects like tables views, materialized views, procedures, and packages using oracle tools like SQL Developer.

Code review with Lead and Manager before deploying.

Using of Edition of SQL Server 2017 and 2019 to develop highly optimized stored procedures, functions, and database views to implement the business logic and created clustered and non-clustered indexes.

Developed, implemented, and optimized stored procedures and functions using T-SQL.

Created SQL scripts to extract the data from the operational database into simple flat text files using UTL_FILE package.

Developed SQL Queries and Procedures for storage and retrieval of data.

Environment: SQL Server 2017/2019 Edition, SQL scripts, SQL Queries,

PROFESSIONAL EXPERIENCE:

SSIS/SQL Developer

US Bank

Meridian Crossing Building 2

MN

Feb 2022 – Feb 2023

ROLES AND RESPONSIBILITIES

Created Database objects – Table, views, and Function and developing procedures for implementing application Functionality at the database side for performance

Created SSIS package to Export and Import data from SQL Server Edition 2017 and 2019 to Access, Text and EXCEL files and Configured SQL mail agent for sending automatic mails.

Deploy and run application in Big Data Clusters using SQL Server Edition 2019.

Developed data interface layer using ASP.NET and C# for data access.

Experienced in Automating, Configuring and deploying instances on AWS, Azure environments and Data centers, also familiar with EC2, Cloud watch, Cloud Formation and managing security groups on AWS.

Wrote python scripts to manage AWS resources from API calls using BOTO SDK and also worked with AWS CLI.

Using of Edition of SQL Server 2017 and 2019 to develop highly optimized stored procedures, functions, and database views to implement the business logic and created clustered and non-clustered indexes.

Created SSIS packages for ETL flow to validate, extract, transform and load data into database. Involved in performing migration of DTS packages to SSIS packages.

Developed, implemented and optimized stored procedures and functions using T-SQL.

Created SQL scripts to extract the data from the operational database into simple flat text files using UTL_FILE package.

Developed SQL Queries and Procedures for storage and retrieval of data using ASP.NET.

Developing and maintaining ETL jobs for the Data Warehouse using SQL Server Agent.

Environment: SQL Server 2017/2019 Edition, JavaScript, SQL scripts, TDD, SQL Queries, Project, Windows 2003 Server, ETL(Extract, transform and load), .NET Framework, C#, ASP.NET, SSIS, SSRS, SSAS.

SSIS/SQL Developer

RNDC,

Lubbock, TX

Feb 2020 – Jan 2022

ROLES AND RESPONSIBILITIES:

Responsible and active in the analysis, design, implementation, and deployment of full Software Development Lifecycle (SDLC) of the project.

Coordinated with the front-end design team to provide them with the necessary stored procedures and packages and the necessary insight into the data.

Created database objects like tables views, materialized views, procedures, and packages using oracle tools like SQL Developer.

Created SQL scripts to extract the data from the operational database into simple flat text files using UTL_FILE package.

Worked on SQL Loader to load data from flat files obtained from various facilities every day.

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

Created and executed SSIS packages to populate data from the various data sources for different data loading operations for many applications.

Migrated data between different heterogeneous sources such as Flat file, Excel using SSIS.

Partitioned the fact tables and materialized views to enhance the performance.

Extensively used bulk collection in SQL objects for improving the performing.

Created records, tables, collections (nested tables and arrays) for improving Query performance by reducing context switching.

Worked extensively in various kinds of queries, Sub- Queries, Correlated Sub-Queries, Dynamic SQL, and Union Queries.

Used SQL hints and indexes to improve SQL performance and analyzed the schema tables to get the better performance.

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

Designed packages which utilized tasks and transformations such as Execute SQL Task, Data Flow Task, Sequence container and Conditional split, Data conversion, Derived column and Multi casting.

Designed Web-based ASP.NET Internet applications linked to firm-wide SQL databases.

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

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

Developed Sub Reports, Matrix Reports, Charts, and Drill Down Reports, using SQL Server Reporting Services (SSRS).

Worked on querying data and creating on-demand reports using Report Builder in SSRS reports and send the reports via email.

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

Performed Server level tuning, performance monitoring, Index Tuning, Query Tuning.

Environment: SQL Server 2012/2016 Enterprise Edition, Enterprise Manager, JavaScript, DAX, ERWIN, UML, MS Project, Windows 2003 Server, .NET Framework, C#, Mongo DB, ASP.NET, SSIS, SSRS, SSAS.

MSBI Developer

KMD Corporation

Dallas, Texas

Aug 2018- Jan 2020

ROLES AND RESPONSIBILITIES:

Involved in Design and Development phase meetings for Business Analysis and requirement gathering.

Developed Database application to meet business need using Oracle SQL features. Created Packages, Procedures, Functions and Triggers.

Implemented parallel processing using DBMS SCHEDULER, DBMS JOBS and SQL Hint. Created parallel pipelined Table functions.

Fixed dead lock occurred in existing application due to un-indexed foreign keys. Modified logic in existing application to ensure strict ordering of updates are performed.

Tuned SQL packages and views to optimize performance and resolve bottlenecks, problems, and space utilizations in acceptable time frame

Tuned queries doing repeated PL/SQL function calls, used scalar sub-queries instead. Created views embedding function logic into SQL.

Assisted with Troubleshooting and corrections for availability and performance of database objects such as views and packages

Removed unwanted fields from query to use index, modified code to replace aggregates with analytical functions.

Wrote script to find unused index in overly indexed environment. Monitored environment for a week and dropped unused index, performed index rebuild as required after data archival.

Tuned queries using nested views and analytic functions. Wrote pagination queries for generating different reports.

Involved in Dimension Modeling, Star Schema, designing Dimensions, facts for Data Warehousing, ETL and OLAP Cubes.

Prepare ETL Architectural Documents, Process flow diagrams and Mapping Documents.

Involved in Regression Testing, Throughput Testing and Performance Testing during Oracle 11g Upgrade. Tuned some of the long running queries and applications to use Oracle 11g features.

Performing data management projects and fulfilling ad-hoc requests according to user specifications by utilizing data management software programs and tools like Excel and SQL.

Involved in extensive DATA validation by writing several complex SQL queries and involved in back-end testing and worked with data quality issues.

Environment: SQL Server 2010, Visual Studio-2010, SSRS, SSAS, SSIS, T- SQL, and TFS, MS SQL Server 2005/2008, Visual Studio-2006, T-SQL, MS-Office, MS-Excel, VSS

ETL Developer

SHELL COORPRATIONS

Seattle, Washington

NOV 2016- July 2018

ROLES AND RESPONSIBILITIES:

Played role in design of scalable, reusable, and low maintenance SSIS templates.

Build efficient SSIS packages for processing fact and dimension tables with complex transforms such as Lookup, Fuzzy grouping and Row Count Transformations and type 1 and type 2 slowly changing dimensions.

Developed, monitored and deployed SSIS packages and user Defined Functions for giving Scores and views for the application. Generated reports from SSRS SQL server reporting services and SSAS.

Created SSIS packages for application that would transfer data among servers and perform other data transformations.

Scheduled SSIS packages by creating the jobs using job scheduler.

Created SSIS package to Export and Import data from SQL Server to Access, Text and EXCEL files and Configured SQL mail agent for sending automatic mails.

Created Scorecards and added them to dashboard using Dashboard Designer and deployed the dashboard to SharePoint.

Generated parameterized reports to enable/disable the parameters based on user selection in SSRS.

Worked on performance tuning, writing stored procedures and creating indexes.

Implemented complex stored procedures and automated them using SQL Server Agent.

Created triggers (Instead Of and after) for auditing purposes.

Used SQL Server Profiler to trace the slow running queries and tried to Optimize SQL queries for improved performance and availability.

Proficient in creating and tuning database, developing views and having good exposure of C# and .NET Framework.

Created SSIS packages for ETL flow to validate, extract, transform and load data into database. Involved in performing migration of DTS packages to SSIS packages.

Configured Connection Manager files for SSIS packages to dynamically execute on QA server and Production server.

Environment: MS SQL Server, T-SQL, PL/SQL, SSIS, SSRS, SSAS, SQL Server BIDS, MS- Visual Studio, ASP.Net, C#.Net, ADO.Net, XML, MsVisio2003/2007, MS Project.

SQL/SSIS Developer

ABM AVIATION,

Irving, TX

Feb 2014 - Oct 2016

Responsibilities:

Assisted in the definition of the database requirements; analyzed existing models and reports looking for opportunities to improve their efficiency and troubleshoot various performance issues.

Developed highly optimized stored procedures, functions, and database views to implement the business logic and created clustered and non-clustered indexes.

Involved in performance monitoring, tuning and capacity planning.

Advised optimization of slow performance queries by looking at Execution Plan for better tuning of the database.

Translated business requirements into BI application designs and solutions.

Involved in complete life cycle in creating SSIS packages, building, deploying, and executing the packages in both the environments (Development and Production).

Program queries using Python/SQL scripts to get data from different databases such as ERP, OPLA etc and, build REST API and NoSQL queries using Flask web-framework and MongoDB

Created SSIS package to load data from Flat Files, Excel and XML Files to Data warehouse and Report-Data mart using Lookup, Derived Columns, Sort, Aggregate, Pivot Transformation, and Slowly Changing Dimension.

Used various SSIS tasks such as Conditional Split, Multicast, Fuzzy Lookup etc., which did Data Scrubbing, including data validation checks during Staging, before loading the data into the Data warehouse.

Extensively used Control Flow elements like For Each Loop, Sequence Container, Execute SQL Task, execute package Task, Script Task, File System Task, Send mail Task and process Task.

Responsible for implementation of data viewers, Logging, error configurations for error handling the packages.

Environment: SQL Server 2014, SQL Server Integration Services (SSIS), SQL Server reporting services (SSRS), SQL Server Analysis Services (SSAS), Power BI, Microsoft Visual studio 2010.

Contact this candidate