SQL/SSIS/SSRS Developer

Shalikram Bhandari

Phone: 571-***-****

Email: ad1rw7@r.postjobfree.com

Location: Justin, TX 76247

Summary:

Over 7+ Years of IT Experience in Business Intelligence Technologies and databases with experience in ETL processes and Reporting Services using SQL Server, SSIS, and SSRS.

Excellent command on MS SQL Server 2008/2012/2014/2016 in constructing triggers, tables, Joins, views, indexes, User Defined Functions to facilitate efficient data manipulation and consistent data storage.

Expertise in writing complex T-SQL queries involving multiple tables, joins, temporary tables, and variables.

Expertise in SQL data models like Relational models, Entity-Relationship models, and Dimensional Models.

Knowledgeable on Data Warehouse concepts such as Star Schema, Snowflake, Dimension and Fact Tables.

Experienced in writing SQL statements, code for the database objects such as tables, views, indexes, stored procedures, functions, triggers, and packages

Generated Sub-Reports, Crosstab, Conditional, Drill down reports, Drill through reports and Parameterized reports using SSRS.

Extensively worked on Analysis, Designing, Documentation and Deployment of RDBMS Concepts.

Expertise in all phases of the Software Development Life Cycle including analysis, Physical and Logical design, Resource Planning, code development & migration, testing, implementing and maintenance.

Experienced in Tuning SQL Statements and Procedures for enhancing the load performance in various schemas across databases using SQL Server Profiler and Execution Plan.

Developed various transformations in SSIS and supported Data warehouse design and development.

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

Implemented error redirection in ETL packages to closely monitor failed records.

T-SQL Coding and SQL tuning throughout the development wherever needed.

Strong knowledge of Data Ware Housing (OLAP Environment).

Expertise in development and design of ETL methodologies for supporting data transformations and processing, in a corporate wide ETL environment using Oracle T-SQL, DSS and Data warehousing with OLAP technologies.

Performed Extraction, Transformation, loading (ETL) data from various sources into Data Warehouses and Data Marts using SQL Loader for Flat files.

Extensive hands-on experience in different database models, Schema with various methodologies to handle Slowly Changing Dimensions.

Excellent communication skills, problem solving, trouble shooting skills and logical methodology. Work well in the team environment or leading a team

In addition to excellent technical abilities, possesses strong oral and written communication skills, analytical and interpersonal skills.

Technical Skills:

Databases:

MS SQL Server 2008R2/12/14/2016, MS Access, Exposure to Oracle

Operating Systems:

Windows

Languages:

Visual Basic 6.0, T-SQL, C#

Web Technologies:

ASP.NET, XML, HTML, CSS,

ReportingTools

SQL Server Reporting Services (SSRS), Power BI, Crystal Report

ETL tools

SSIS, Exposure to Informatica

Others:

MS Project, MS Office, MS Excel, MS Visio, JIRA, SharePoint, json, TFS, Bit-Bucket, Git

Professional Experiences

SQL/SSIS Developer

Client: Bank Of America

Location: Addison, TX

Duration: July 2023 – Present

Responsibilities:

Designed and molded database structures to specifically cater to the unique requirements of the banking system.

Guaranteed the integrity, security, and optimal performance of the database design.

Enhanced SQL queries through meticulous crafting and refinement, enabling adept retrieval and manipulation of data.

Ensured the efficiency of queries, particularly for extensive datasets, to maintain system responsiveness.

Worked closely with system administrators and developers to pinpoint and address performance bottlenecks.

Implemented and strengthened security measures to protect sensitive financial data.

Conducted systematic investigations and resolved work-related database issues, addressing data discrepancies, performance challenges, and connectivity issues.

Provided expert support during work-related tasks such as system upgrades, migrations, and other database projects.

Architected and engineered SSIS packages, sophisticated Stored Procedures, Triggers, Functions, Indexes, Tables, Views, SQL joins, and other intricate T-SQL codes to seamlessly implement and fulfill complex business requirements.

Developed advanced SSIS packages incorporating various data transformations, including Conditional Splitting, Merging, Merge Join, Union All, Multicasting, For Each Loop, Column Conversion, Script Components, and robust error handling. These solutions were designed to effectively meet complex business requirements and ensure seamless data flow within the organization.

Established, sustained, and orchestrated a diverse array of reports within SSRS, encompassing Ad-hoc Reports, Canned Reports, Master Reports, and Parameterized Reports, leveraging the capabilities of SQL Server Reporting Services (SSRS). This involved a comprehensive approach to reporting to cater to dynamic business needs and ensure the seamless generation of valuable insights.

Demonstrates proficiency in managing multiple tasks concurrently, exhibiting initiative and adaptability within a team-oriented environment. Exhibits an unwavering commitment to achieving organizational goals.

Environment: MS SQL Server, SQL Server Data Tools for Visual Studio 2019 (SSIS), SSRS, TFS, FTP, SharePoint, JIRA, MS Office Suite, Crystal Reports, SQL Profiler, Autosys

SQL/SSIS Developer

Client: Medisolv, Inc

Location: Columbia, MD

Duration: April 2022 – June 2023

Responsibilities:

Designed and implemented database structures to seamlessly integrate electronic health records.

Developed SQL queries to extract, transform, and load data from diverse sources into the EHR system in past roles.

Developed databases, SQL scripts, and SSIS packages to streamline the exchange of health information among diverse healthcare entities via reports.

Ensured compliance with data security and privacy standards while overseeing information sharing.

Demonstrated expertise in optimizing Stored Procedures through query tuning, enhancing performance, and resolving deadlock situations and server hang-ups in a professional work setting.

Developed reports that adhered to healthcare compliance standards and regulations, including HIPAA (Health Insurance Portability and Accountability Act).

Ensured that reports handled sensitive patient information securely and in robust compliance with privacy laws in past roles.

Established ad-hoc reporting capabilities, enabling users to generate on-the-fly reports tailored to their immediate requirements.

Empowered end-users with user-friendly tools for creating and customizing reports, minimizing the dependency on extensive technical expertise in a work-related context.

Proven capability to manage multiple tasks simultaneously, demonstrating initiative and adaptability. A self-motivated and organized team player with robust problem-solving and analytical skills, fully committed to achieving organizational goals.

Implemented security measures within SSRS to control access to sensitive healthcare information.

Configured role-based security to restrict report access based on user roles and responsibilities in previous roles.

Environment: MS SQL Server, SQL Server Data Tools for Visual Studio 2015 (SSIS), SSRS, TFS, FTP, SharePoint, JIRA, MS Office Suite, Crystal Reports, SQL Profiler

SQL/SSIS Developer

Client: MedeAnalytics, Inc

Location: Richardson, TX

Duration: April 2021 – March 2022

Responsibilities:

Designed and developed SSIS packages, complex Stored Procedures, Triggers, Functions, Indexes, Tables, Views, SQL joins, and other T-SQL codes to implement business requirements.

Successfully migrated data between the heterogeneous sources like Flat File, Excel, Oracle and SQL server using SSIS.

Hands on experience working on Extraction, Transformation and Loading (ETL) process by pulling large volume of data from various data sources using SSIS.

Created highly complex SSIS packages using various Data transformations like Conditional splitting, Merge, Merge Join, Union All, Multicast, For Each Loop, Multi Cast, column conversion, Script Components, error handling.

Implemented Triggers for checking complex business conditions, providing security for the tables.

Created views to facilitate easy user interface implementation, and triggers on them to facilitate consistent data entry into the database.

Experience in tuning Stored Procedures for query optimization to improve the performance and eliminate the deadlock situations and hang-ups on server.

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

Created, maintained & scheduled various reports in SSRS like Ad-hoc Reports, Canned Reports, Master Reports & Parameterized Reports using SQL Server Reporting Services SSRS.

Responsible for creating Complex Crystal Reports (Ad Hoc reports, Frequency reports, Summary reports, Sub reports, Drill-Down, Crosstab, Dynamic Grouping, Crosstab, Graphical, Aging reports) and modifying the existing reports using SQL Server Reporting Services (SSRS).

Extensively involved in Data Warehouse/Data mart, ODS, OLTP and OLAP implementations teamed with project scope, Analysis, requirements gathering, data modeling, Effort Estimation, ETL Design, development, System testing, Implementation, and production support.

Ability to handle Multiple tasks, Initiative and Adaptable. Self-motivated, organized team player with strong problem solving and analytical skills and total commitment to the organization goals.

Environment: MS SQL Server, SQL Server Data Tools for Visual Studio 2015 (SSIS), SSRS, TFS, FTP, SharePoint, JIRA, MS Office Suite, Crystal Reports, SQL Profiler

SQL/SSIS Developer

Client: Allstate Insurance

Location: Irving, TX 75064

Duration: Sep 2019 – March 2021

Responsibilities:

Expertise in analysis, design, and development of end-to-end business intelligence solutions using the MSBI suites such as SQL Server Integration Services (SSIS), SQL Server Analysis Services (SSAS) & SQL Server Reporting Services (SSRS).

Implemented and enhanced existing reports like Drilldown, Drill Through, Sub-Reports, List, Tabular, Matrix, Navigation Reports, Standard Parameter, Cascading Parameter and Multi-Value Parameters in SSRS.

Perform database development that includes Schema development, Stored Procedures that could be used by different Windows Services.

Used SSIS variables, parameters, & expressions to implement dynamicity of Master ETL Package, connection managers, tasks, containers, Send Mail, Row Count, Script tasks, etc.

Monitored and maintained existing ETL packages and Reports to fix issues and bugs and troubleshooting.

Maintained Data warehouse, Created ETL Jobs, Created new database objects and SSIS Packages.

Maintained SQL Script for creation of Database Objects.

Creation of ETL packages to load data from files into database by performing different kinds of transformations using SSIS.

Active participation in designing dashboards including the design of the data warehouse tables, Source to Target ETL logic and dashboard development.

Involved in writing T-SQL programming to implement Stored Procedures and Functions for different tasks and created Triggers to enforce data and referential integrity.

Involved in writing SQL batch scripts. Write T-SQL statements for retrieval of data and involved in performance tuning of T SQL queries and stored Procedures.

Performance tuning and optimization of procedures and queries and Involved in the tuning of the existing Database Objects.

T-SQL development included queries using joins, sub queries, Ranking functions, Derived tables, common table expressions (CTEs), stored procedures, views, constraints, and Database triggers.

Used to connect different data sources like SQL DB (SQL Query), Tabular Model (DAX Query), Web Trends to Power BI and generate reports with different visualizations.

Involved in development & Deployment of SSAS Cubes and Monitor Full and Incremental loads and support any issues.

MDX Coding and MDX object modeling using analysis services.

Involved in code review and preparing unit test cases.

Generated Custom ETL scripts using SSIS and develops and unit test SSIS load processes for performance check.

Creating SSIS packages and scheduled them as jobs to run automatically to Process the cube, load data etc.

Experienced in Data Extraction, Transforming and Loading (ETL) between Homogenous and Heterogeneous System using SQL tools like SSIS, Data Transformation Services (DTS), Bulk Insert, BCP, and XML.

Extensive reporting skills using SQL Server Reporting (SSRS).

Experience in Automation dealing with Azure and other Operational tasks.

Created Data Models for each module of the current OLTP system and participated in the brainstorming session to nail possible design challenges.

Performed unit and system testing, troubleshooting and bug fixing in development and QA environments.

Worked on TFS for performing tasks.

Environment: MS SQL Server 2017/16, SQL Server Data Tools for Visual Studio 2015 (SSIS), SSRS, TFS, FTP, SharePoint, MS Visio, Excel PowerPivot, MS Excel 2010/2013.

SQL Database Developer

Client: United Texas Bank

Location: Dallas, TX 75240

Duration: Sep 2017-Aug 2019

Responsibilities:

Database Performance of Index tuning with using Database Engine Tuning Advisor to resolve Performance issues.

Developed and optimized database structures, stored procedures, Dynamic Management views, DDL triggers and user-defined functions.

Created complex Stored Procedures and Functions to support the front-end application.

Involved in tuning the database and T-SQL queries using Explain Plan.

Optimize SQL queries for improved performance and availability.

Created linked servers for data retrieval using OLE DB data source and providers.

Reviewed the existing stored procedures and improved efficiency by critically evaluating the code.

Developed various transformations in SSIS and supported Data warehouse design and development.

Involved in analyzing data and clarifying data outputs with reports and models in SSRS.

Generated and scheduled on-demand reports for business analyses and management decisions with SSRS.

Designed and developed DTS packages for transferring data from flat files and Access files.

Experienced in various stages of SDLC, which includes requirement gathering, analysis, design, development, Implementation.

Upgrade enhancements, maintenance, support, and bug fixing for the product.

Performed Index analysis for tables and came up with more efficient solutions to use Clustered and Non-Clustered Indexes for significant performance boost.

Created Indexes, Views, Triggers, Stored Procedures and Packages in T-SQL.

Successfully created schema change scripts to existing objects to synchronize with changing business rules.

Monitored growth of database objects for capacity planning.

Worked with Quality assurance to develop test plans and test cases to conduct system testing.

Migrating Services from On-premises to Azure Cloud Environments. Collaborate with development and QA teams to maintain high-quality deployment

Developed DTS Packages to get the reports, routinely, in the excel sheets, required by the managers for analysis.

Environment: MS SQL Server 2012, Enterprise Manager, SSIS, SSRS, SSAS, Informatica, TFS, T-SQL, DTS, Query Analyzer, SQL Profiler, MS Visio, FTP.

SQL/SSIS Developer

Client: Vizio Inc.

Location: Dallas, TX 75126

Duration: Aug 2016-Aug 2017

Responsibilities:

Created Complex ETL Packages using SSIS for extracting, cleaning, transforming, and loading data from staging tables to partitioned tables with incremental load.

Developed, deployed, and monitored SSIS Packages.

Data ETL making changes to existing ETLs and building some new ETL processes.

Data Automation Using SSIS to automate data processes for input of information.

Implemented data validation by using T-SQL queries to confirm that SSRS reports data results that are being returned are correct.

Worked closely and communicated with project team members to achieve project goals.

Created packages using the various control flow tasks such as Data Flow Task, Execute SQL Task, Execute Package Task, File System Task.

Administered SQL Server with Client/Server tools including SQL Server Enterprise Manager, Profiler and Query Analyzer.

Created number of standard reports and complex reports to analyze data using Slice & Dice, Drill Down and Drill Through approaches using SSRS.

Participated in design discussions with Database architects and Application architects.

Designed the Data warehouse and done the mappings from Source to the Target tables.

Developed SSIS packages to extract, transform and load data from Oracle and SQL Server databases into Data Warehouse.

Identified the dimension, fact tables and designed the Data-Mart using Star schema.

Created Indexes for faster data retrieval from the database.

Wrote Stored Procedures and Functions for better performance and flexibility.

Coordinated with Users in different testing phases.

Created SQL Server jobs and scheduled them to load data periodically using SQL server Agent.

Good hands-on experience with C#.NET and VB.NET for downloading files from a remote server.

Strong skills in transformation data from DB2 to SQL Server

Worked on the Reports module of the project as a developer on MS SQL Server 2008 (using SSRS, T-SQL, scripts, stored procedures, and views).

Created reports from OLAP, sub reports, bar charts and matrix reports using SSRS

Developed Aggregations, partitions, and calculated members for cube as per business requirements.

Created Parameterized, Crosstab, Drill Down and Summary reports by Using SSRS and created report snapshots to improve the performance of SSRS.

Built Azure environments by deploying Azure IaaS Virtual machines (VMs) and Cloud services (PaaS)

Environment: MS SQL Server 2008, MS SQL Server Master Data Services 2008, SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), SQL Server Analysis Services (SSAS), MS Visual Studio/.NET 2008, BI Extractor, Microsoft Excel

Education:

Bachelor’s in business studies (2014)

Tribhuvan University Kathmandu, Nepal

Contact this candidate