Shishir Kumar Regmi

SQL/ETL Developer

CONTACT

Pittsburgh PA, 15227

ad2z7j@r.postjobfree.com

412-***-****

TECHNICAL SKILLS

SQL Server Tools: SSMS, BIDS, Enterprise Manager, DTS, Profiler, DTA

ETL and Reporting Tools: SSIS, SSRS, SSAS, BIDS, DTS, Business Objects, PowerPivot.

Databases: SQL Server, MS Access, Oracle

Cloud Tools: AWS

Operating System: Windows, MS DOS, Linux.

Scripting: HTML, JavaScript, ASP.NET, Python

Tools: Erwin, Visual Studio and Report Builder

Industry Experience: Healthcare, Retail, Banking

Industry Experience: Healthcare, Retail, Banking

Education

Bachelor in Computer Engineering

Thapathali Campus Institute of Engineering

Tribhuvan University, Nepal

Experience

November 2021 - Present

SQL/SSIS Developer Compassion Care Clinic Dallas, TX 75211

● Followed the Software Development Life Cycle throughout the project and used the Agile methodology.

● Involved in reviewing the Investments application and interacting with business users to understand the user requirements.

● Created SSIS packages to extract data from OLTP to OLAP systems and Scheduled Jobs to call the packages and Stored Procedures.

● Created logging for ETL load Confidential package level and task level to log number of records processed by each package and each task in a package using SSIS.

● Analysis of the business system design, studied detail changes that need to be made to each business process, modified existing columns of new tables and prepared detailed T-SQL scripts.

● Involved in Creation of Dimensions using STAR and SNOWFLAKE Schema.

● Actively involved in creating SSIS packages to transform data from OLTP database to a data warehouse.

● Migrated data from Oracle to SQL Server data warehouse and to generate the reports using SSRS for different SSAS Cubes.

● Created and maintained databases, tables, views, users, logins, indexes, check constraints, and business rules using Confidential -SQL.

● Involved in SSAS Cubes design by creating KPI, Actions and Perspective from a huge dataset using SQL Server Analysis Services (SSAS).

● Developed MDX Queries against SSAS cubes to generate reports.

● Implemented Event Handlers and Error Handling in SSIS packages and notified process results to various user communities.

● Tested, Cleaned and Standardized Data meeting the business standards using Fuzzy /exact lookups using SSIS tasks.

● Designed and developed matrix and tabular reports with drill down, drill through and drop-down menu and used gauge reports with KPI’s in SSRS.

● Generated and consolidated monthly reports and budget analysis to drive forecast production plan with SQL report service (SSRS).

● Designed and implemented various reports using Crystal Reports and responsible for the migration to SSRS.

● Designed, developed, tested, deployed, supported, maintained, and documented (KPIs), Scorecards, Time Aware Dashboards and accompanying Analytical Grids and charts with URL actions using PerformancePoint Server and SQL Server Analytical Services.

● Designed and built the OLAP cubes using Star schema and Snowflake Schema using native OLAP Service Manager.

● Performed maintenance duties like performance tuning and optimization of queries, functions, and stored procedures.

● Used SQL Profiler for troubleshooting, monitoring, optimization of SQL server and SQL code.

● Worked on SQL Profiler and Query Analyzer to optimize DTS package queries and stored procedures.

● Optimized the database by creating various clustered, non-clustered indexes and indexed views.

● Automated and enhanced daily administrative tasks including space management, database backup and recovery. Involved in setting up SQL Server Agent Jobs for periodic Backups with backup devices, Database maintenance Plans and recovery.

Environment: SQL Server, T-SQL, PL/SQL, SQL Profiler, Report Builder, SSIS, SSRS, SSAS, OLAP, OLTP, C#, Agile, Scrum, Toad, Visual Studio, XML, Crystal Reports, and MS-Excel.

January 2020 - October 2021

SQL Database Developer BhatBhateni Super Market Anamnagar, Kathmandu

● Involved in SDLC of the project from requirements gathering from Business users to perform technical design, development, and testing using AGILE methodology (SCRUM).

● Created complex SQL queries, stored procedures, functions, triggers, joins and SSIS/DTS packages.

● Extensively involved in designing the SSIS packages to export data of flat file source to SQL Server database.

● Involved in creating SSIS jobs to automate the reports generation, cube refresh packages.

● Designed high level ETL architecture for overall data transfer from the OLTP to OLAP

with the help of SSIS.

● Performed complex SSIS ETL operations to validate, cleanse, transform and load data to data warehouses.

● Excellent hands-on experience with SQL Server Integration Service (SSIS), SQL Analysis Services (SSAS) and Reporting Services (SSRS).

● Involved in designing cubes in the SSAS environment using Snowflake/ and Star Schemas.

● Extract Transform Load (ETL) development using SQL Server Integration Services (SSIS).

● Created complex SSIS packages using proper control and data flow elements with error handling.

● Installation and configuration of SQL Server.

● Created Tablix Reports, Matrix Reports, Parameterized Reports, Sub reports using SQL Server Reporting Services.

● Wrote complex T-SQL queries, stored procedures, triggers, cursors and user definedfunctions (UDF’s).

● Created SQL Server Analysis Project using MS SSAS.

● Querying and manipulating multidimensional cube data through MDX Scripting.

● Enhancing and deploying the SSIS Packages from development server to production server.

● Created complex SSAS cubes with multiple fact measures groups.

● Created Drill-down, Drill-through and Sub-Report using RDL. Promoted RDLs to Reporting Service Server.

● Developed the chart type, Tablix, matrix reports in SSRS (SQL Server Reporting Services) like enrollment status, Financial Aid, Degree Objective from the OLAP system.

● Involved in Performance tuning of SQL queries and stored procedures using SQL Profiler and Database Engine Tuning Advisor.

● Created reports with different features like drill through capabilities, jump to another report, use of pie charts and bar charts.

● Developed dashboard reports using Reporting Services, Report Model and ad-hoc reporting using Report Builder.

● Modified report content and exported reports in multiple formats based on the business requirements.

● Designed and implemented Parameterized and cascading reports using SSRS.

● Developed data model based on the BA’s and the reporting Team using SSAS, SSRS.

● Created derived columns on the final fact and dimension tables as per the business requirements.

● Created dashboards using Performancepoint Server, combining scorecards and reports generated in SSRS, PPS, and Excel Services.

● Played a major role in production support of SSAS (cube refresh), SSIS jobs.

● Understanding the OLAP processing for changing and maintaining the Warehousing Optimizing Dimensions, Hierarchies and adding the Aggregations to the Cube.

Environment: SQL Server, SQL BI Suite (SSAS, SSIS, SSRS), VB Script, Enterprise manager, XML, MS PowerPoint, OLAP, OLTP, MDX, Erwin, MS Project, MS Access and Windows Server.

October 2018 - December 2019

SQL Developer Siddhartha Bank Limited Kathmandu, Nepal (October 2018 - December 2019)

● Held daily scrum meetings with the Project team and change management team to discuss the requirement updates, change requests, tasks, and assign/re-assign man hours daily.

● Designed dynamic SSIS Packages to transfer data crossing different platforms, validate data during transferring, and archived data files for different DBMS.

● Involved in designing, developing, debugging, and testing of reports in SQL Server Reporting Services (SSRS).

● Used SSIS to unite data from existing systems and performed transformations on MS SQL.

● Created Complex SQL Queries using Views, Indexes, Triggers, Roles, Stored procedures, and User Defined Functions.

● Extract Transform Load (ETL) development Using SQL server, SQL Integration Services (SSIS).

● Involved in Data Model design and enhancements of Data Marts based on the ETL project requirements.

● Wrote many TSQL Stored procedures to perform specific tasks as per the requirements.

● Extensively used T-SQL in constructing User defined Functions, Views, Indexes, User Profiles, Relational Database Models, Data Dictionaries, and Data Integrity.

● Designed Logical and Physical data models using ERWIN data modeling tool.

● Used Query Analyzer, Index Wizard, DB Engine Tuning and SQL Profiler for performance tuning.

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

● Improved Performance by creating Clustered and Non-clustered Indexes and by optimizing the T-SQL statements using SQL profiler.

● Worked with SQL loader and control files to load the data in different schema tables.

● Generated drill down and drill through reports using SSRS.

● Experience in using SQL Server tools like SQL Server Management Studio, SQL Server Profiler, and SQL Server Visual Studio.

● Bulk inserted data from huge files to different destination tables in SQL server using SQL Server Integration Services (SSIS).

● Understanding the OLAP processing for changing and maintaining multi-dimensional data warehousing, Optimizing Dimensions, Hierarchies and adding aggregations to the OLAP Cubes.

● Developed dashboard reports using Reporting Services, Report Model and ad-hoc reporting using Report Builder.

● Created Parameterized Reports and Linked Reports and thorough knowledge of report server architecture using SSRS.

● Identified the data sources and created source to target mapping documents to be used by the packages in SQL Server Integration Services (SSIS).

● Worked with Technical Architects and Database analysts for the Design of Summary tables required for efficient Report Design.

● Designed the functional and technical documents, report templates and reporting standards for the developers to work on the report development.

Environment: MS SQL Server, T-SQL, SSAS, SSIS Packages, SSRS, SQL,Visual Studio, SQL Profiler, Erwin, XML, OLAP, OLTP and MS Office.

References

[Available upon request]

Contact this candidate