SQL Database Developer

Work Authorization: US Citizen

Full Legal Name: Rameshwar Niraula

Current Location: Fort Worth, TX, 76131

Email ID: ad2ocl@r.postjobfree.com

Contact no.: 817-***-****

PROFESSIONAL SUMMARY

Over 5 years of professional level experience in Database Design, Development and business intelligence of Microsoft SQL Server 2012/2014/2016/2017 in Development, Staging and Production Environments on various business domains like Logistics, Banking, and Healthcare.

●Experience in MS SQL Server with SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS) and T - SQL.

●Exposed to all phases of software development life cycle SDLC including in-depth knowledge of Agile methodology, Enterprise Reporting Life Cycle, SQL Server Migrations, Change control rules, problem management and escalation procedures.

●Experience in High-Level Design of ETL - DTS Packages & SSIS Packages - for integrating data using OLE DB connection from heterogeneous sources (Excel, CSV, flat file, Text Format Data) by using multiple transformations provided by SSIS such as Data Conversion, Conditional Split, Bulk Insert, merge and union all.

●Created and formatted Crosstab, Conditional, Drill down, Top N, Summary, Form, OLAP, Sub reports, ad hoc reports, parameterized reports, interactive reports and custom reports.

●Excellent T-SQL Developer skills working with Stored Procedures, Views, User Functions, Triggers, SQL Agent jobs.

●Experience with SQL Performance tuning and transactions analysis, thorough understanding of indexes and statistics.

●Experienced in managing and automating Control flow, Data flow, Events and Logging programmatically using Microsoft .NET framework for SSIS packages.

●Experience in providing Logging, Error handling by using Event Handler, and Custom Logging for SSIS Packages.

●Expert in designing complex reports using SQL Server Reporting Services (SSRS) and Excel Pivot table based on OLAP cubes which make use of multiple value selection in parameters pick list, cascading prompts, matrix dynamics reports and other features of reporting service.

●Expertise in generating reports using SQL Server Reporting Services, Crystal Reports and MS Excel spreadsheets.

●Expert in generating Drill down reports, Parameterized reports, Linked reports, Ad-Hoc reports, Sub reports and filters, and charts in SSRS.

●Knowledge on Active Directory Administration and Good understanding of the Change Control process.

●Experience in providing SSRS server level, Item level Security & Accessibility to various reports in multi-user environments.

●Experience in developing reports using Microsoft SharePoint Server Enterprise Edition.

●Good SQL Server Administration skills including, Backups, Disaster Recovery Model, database maintenance, user authorizations, Database creation, Tables, indexes.

●Experience on TFS (Team Foundation Server), Visual Source Safe.

●Configured database mail to send messages when jobs failed in SQL Server 2012/2014/2016/2017.

EDUCATION:

Bachelor Degree, Tribhuvan University, Kathmandu

TECHNICAL SKILLS

Business Intelligence Tools: SQL Server Integration Services (SSIS), SQL Server Analysis Services (SSAS), SQL Server Reporting Services (SSRS)

Data Visualization Tools: Power BI, Tableau Desktop

Database Management Systems: Oracle SQL Developer, Microsoft SQL Server, MS SQL Server Management Studio, Microsoft Visual Studio, MySQL

Programming: T-SQL, PL-SQL, C, C#, .NET, PowerShell Scripts

Web Technologies: HTML, DHTML, Visual Studio

Operating Systems: Windows, Unix, Linux, Mac OS

Project Management Methodologies: Agile, Scrum, Six Sigma, PMBOK, Waterfall

Software Skills: Microsoft Office Suite, Microsoft Project, Microsoft Visio, SharePoint, JIRA, Confluence

Business Domains: Logistics, Banking and Healthcare

PROFESSIONAL EXPERIENCE

SQL Database Developer

GXO Logistics, Inc.

Greenwich, Connecticut

07/2022 - Current

Responsibilities:

●Designed a complex SSIS package for importing data from SQL Server.

●Use ETL to implement the slowly changing dimension Transformation, to maintain Historical Data in the Data warehouse.

●Created packages in SSIS with error handling and event handling.

●Worked with different methods of logging in SSIS like flat file, SQL Server table, and event viewer.

●Implemented data views and control tools for guarantee data transformation using SSIS.

●Used various transformations like Multicast, Conditional split, OLEDB Command, Script Component, and Lookup while loading the data into Destination.

●Experience in migrating data from on-premise SQL Databases into Cloud Azure.

●Involved to write complex T-SQL queries and Stored Procedures for generating reports.

●Defined parameters for parameterized Reports using SSRS.

●Designed and developed various Service Management Reports, utilizing Dynamic and Cascading Prompts, sub-reports, charts, parameterized reports, conditional and dynamic reports using SSRS.

●Successfully worked with Report Server and configured into SQL Server.

●Extensively worked with OLAP cubes to generate drill through reports in SSRS.

●Designed DAX queries in accessing cubes and hands-on experience in query structuring, performance optimization.

●Involved in the analysis, design, development, testing, deployment and user training of analytical and transactional reporting systems.

●Extensively worked on TFS (Team Foundation Server) for version control.

●Used stored procedures, wrote new stored procedures and triggers, modified existing ones, and tuned them such that they perform well.

●Experience in Power BI Desktop and Power BI Pro.

●Experience creating and developing Power BI Dashboards.

●Created calculated columns, complex Measures in Power BI Desktop using DAX to show data analysis techniques.

●Scheduled Automatic refresh and scheduling refresh in Power BI service.

●Used JIRA as an issue tracking tool.

●Tuned SQL queries using execution plans for better performance.

●Scheduled the monthly/weekly/daily reports to run automatically.

Environment: MS SQL Server Management Studio, MS Visual Studio, SQL Server Integration Service, SQL Server Reporting Services, T-SQL, OLAP, OLTP, Jira, Power BI.

SQL SSIS Developer

01/2020 - 06/2022

Bank of America

Charlotte, North Carolina

Responsibilities:

●Worked with Business Analysts and Users to understand the requirements.

●Extensively worked on Data Flow tasks like for each Loop Container, Execute process task, Transfer SQL Server Objects task, Transfer Jobs task, Transfer Logins task.

●Worked with SSIS packages involved FTP tasks, Fuzzy Grouping, Merge and Merge joining, Pivot and Unpivot Control Flow Transformations.

●Used SQL Server Package Configuration technique to make Dynamic configurations.

●Used Text Files/ SQL Server Table Logging for all SSIS packages.

●Used Excel Power Pivot and Power view to build Scorecards and Dashboards.

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

●Generated reports from the cubes by connecting to the Analysis server from SSRS.

●Extensive knowledge of designing, developing and deploying various kinds of reports using SSRS using relational and multidimensional data.

●Worked with DTS packages and MSOLAP Services.

●Experienced in SQL Server Analysis Services OLAP Cubes and Data Mining.

●Created On-demand (Pull) and Event-Based delivery (Push) of reports per the requirement.

●Created Tableau worksheet which involves Schema Import, Implementing the business logic by customization.

●Deployed and configured the reports in the Report Server.

●Developed Power BI reports using query logic based on business rules, and visuals selected by United stakeholders.

●Embedded Power BI reports on the Salesforce portal page and also managed access of reports and data for individual users using Roles.

●Used Excel Power Pivot and Power view to build Scorecards and Dashboards.

●Extracted Data from various Heterogeneous Databases such as Oracle and Access database, DB2, flat files to SQL Server using SSIS.

●Used SSIS to create ETL packages to validate, extract, transform and load data into the data warehouse and data marts.

●Created ad hoc reports to users in Tableau by connecting various data sources.

●Handled Tableau admin activities granting access, managing extracts and Installations.

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

●Worked with various SSIS packages which involve Transactions, restart ability and roll back techniques.

●Configured SQL mail agent for sending automatic emails when SSIS packages fail or succeed.

●Created Databases, Tables, Cluster/Non-Cluster Index, Unique/Check Constraints, Views, Stored Procedures, Triggers.

●Created User Defined Functions to encapsulate frequently and commonly used business logic making the system more modular, secure and extensible.

●Optimizing Stored Procedures and long-running SQL queries using indexing strategies and query optimization techniques.

●Schedule the packages to keep extracting the data from OLTP at specific time intervals.

●Responsible for rebuilding the indexes and tables as part of performance tuning.

●Built cubes for a production application, Partitioned Cubes to decrease the processing time and increase the performance of the queries running on the front end application.

●Used SQL Server Agent for scheduling jobs and alerts.

●Configuration and Deployment of all reports across various SDLC environments.

●Deployed the packages to production using XML package configuration.

Environment: MS SQL Server Management Studio, MS Visual Studio, MS Excel(Power Pivot), Tableau, DB2, Oracle, .NET, XML, OLAP, OLTP, Power BI.

SQL ETL Developer

Tenet Healthcare Corporation

Dallas, TX

11/2018 - 12/2019

Responsibilities:

●Created an SSIS Package (works for transactional and canonical data that works as a template for every interface).

●Created Automated Job steps to process daily and weekly Data.

●Created various complex SSIS packages and deployed to Development, QA and Production environments.

●Extensively used various Red gate tools.

●Used SQL Compare for comparing and deploying SQL objects.

●Source control that keeps the team in sync with easy access to the latest database version.

●Worked closely with the Business Team during the development of the Interfaces.

●Created Technical specification documents for each SSIS package developed.

●Administered and monitored SSIS packages.

●Solid understanding of Data Modeling, Evaluating Data Sources and strong understanding of Data Warehouse/Data Mart Design, ETL, BI, OLAP, Client/Server applications.

●Good experience and understanding of Database Design, Relational Integrity Constraints, OLTP, OLAP and Normalizations.

●Experience in Data Modeling, Database Design, SQL Scripting, Development and Implementation of Client-Server & Business Intelligence (SSIS, SSAS, SSRS) applications.

●Delivered BI reporting solutions in Power BI, Reporting Services (SSRS), Tableau and MicroStrategy.

●Extensively used various SSIS objects like Control Flow components, Data flow components, Connection Managers, Shared Data sources.

●Efficiently used Configuration files for changing the connection managers while deploying packages to different servers.

●Created several Linked Servers to load data into different locations.

●Used Dynamic SQL for different variables while developing SSIS packages.

Environment: MS SQL Server Management Studio, MS Visual Studio, T-SQL, SQL Server Integration Service, SQL Server Reporting Services, OLAP, OLTP, Power BI, TFS, SharePoint

CERTIFICATIONS:

Microsoft Certified: Azure Data Engineer Associate

Contact this candidate