Sql Server Business Intelligence

SQL/SSIS/SSRS Developer

Shalikram Bhandari

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

Email: ********************@*****.***

Location: Justin, TX 76247

Summary:

• 7+ years of IT experience in Business Intelligence Technologies and databases, specializing in ETL processes and Reporting Services with SQL Server, SSIS, and SSRS.

• Proficient in MS SQL Server (2008-2019) for constructing triggers, tables, joins, views, indexes, and user-defined functions.

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

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

• Knowledgeable about Data Warehouse concepts like Star Schema, Snowflake, Dimension, and Fact Tables.

• Experienced in creating and managing database objects such as tables, views, indexes, stored procedures, functions, triggers, and packages.

• Generated various reports using SSRS, including sub-reports, crosstab, conditional, drill-down, drill-through, and parameterized reports.

• Extensive work on analysis, design, documentation, and deployment of RDBMS concepts.

• Proficient in all phases of the Software Development Life Cycle: analysis, design, resource planning, development, testing, implementation, and maintenance.

• Skilled in designing, scheduling, and monitoring ETL workflows with AutoSys and SSIS integration.

• Managed job dependencies and configured alerts to ensure data pipeline reliability.

• Experienced in tuning SQL statements for performance enhancement using SQL Server Profiler and Execution Plan.

• Developed transformations in SSIS, supporting Data Warehouse design and development.

• Created ad-hoc report models with SSRS report builder and implemented error redirection in ETL packages.

• Strong knowledge of Data Warehousing (OLAP environment).

• Expertise in ETL methodologies using Oracle T-SQL, DSS, and OLAP technologies.

• Performed ETL operations from various sources using SQL Loader for flat files.

• Hands-on experience with different database models and methodologies for handling Slowly Changing Dimensions.

• Excellent communication, problem-solving, troubleshooting, and logical skills; effective in team environments or leading teams.

• Possesses strong oral and written communication skills, analytical abilities, and interpersonal skills. Technical Skills:

Databases: MS SQL Server 2008R2/12/14/2016/2019, 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, Autosys

Professional Experiences:

SQL/SSIS Developer

Client: Bank Of America

Location: Plano,TX

Duration: July 2023 – Present

Responsibilities:

• Designed and structured database systems to meet specific requirements of the banking system.

• Developed and scheduled AutoSys job chains for automating ETL workflows and ensuring timely data processing.

• Created AutoSys JIL scripts for managing batch jobs across environments.

• Monitored and addressed failed AutoSys jobs, performed root cause analysis, and implemented corrective actions to ensure SLAs were met.

• Integrated SSIS package execution within AutoSys for streamlined data movement between SQL Server and other sources.

• Ensured integrity, security, and optimal performance of database design.

• Enhanced SQL queries for efficient data retrieval and manipulation.

• Optimized queries for extensive datasets to maintain system responsiveness.

• Collaborated with system administrators and developers to identify and resolve performance bottlenecks.

• Implemented security measures to protect financial data.

• Investigated and resolved database issues, addressing data discrepancies, performance challenges, and connectivity problems.

• Provided support during system upgrades, migrations, and other database projects.

• Developed SSIS packages, Stored Procedures, Triggers, Functions, Indexes, Tables, Views, SQL joins, and other T-SQL codes to meet business requirements.

• Created advanced SSIS packages with various data transformations, ensuring effective data flow within the organization.

• Managed reports within SSRS, including Ad-hoc Reports, Canned Reports, Master Reports, and Parameterized Reports, using SQL Server Reporting Services

(SSRS).

• Demonstrated ability to manage multiple tasks concurrently within a team-oriented environment. 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 optimized backend components and ETL processes, including SSIS packages, SQL Jobs, and stored procedures for healthcare applications.

• Improved SQL performance on SQL Server and Teradata by refactoring queries, indexing, and optimizing execution plans.

• Worked with QA and business analysts on regression and negative testing, reducing rework by 25%.

• Ensured data integrity across systems through robust validation and error-handling mechanisms.

• Developed advanced SSRS reports with drilldowns, document maps, and dynamic groupings for claims and patient management.

• Contributed to API integration for backend services to enhance interoperability with EHR systems.

• Created technical documentation compliant with internal healthcare requirements.

• Managed CI/CD automation pipelines using Azure DevOps, deploying assets with minimal downtime. 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:

• Developed and optimized SSIS packages, complex T-SQL codes, and ETL workflows for efficient data migration and healthcare reporting.

• Designed and implemented Stored Procedures, Views, Triggers, and Indexes, enhancing database performance and query optimization.

• Created and maintained SSRS and Crystal Reports, including Ad-hoc, Drilldown, Crosstab, and Parameterized Reports for business intelligence purposes.

• Collaborated on HIPAA-compliant projects to ensure secure data handling and provided production support for critical applications.

• Contributed to Data Warehousing and OLAP/OLTP implementations, including requirements gathering, ETL design, and production support.

• Proficient in performance tuning, server troubleshooting, and enhancing database efficiency using SQL Profiler. 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:

• Demonstrated proficiency in developing and enhancing SSRS reports, including Drilldown, Drill Through, Sub-Reports, and various parameterized reports.

• Executed extensive database development tasks such as schema creation, stored procedures, ETL packages, and ensuring data integrity through triggers and constraints.

• Designed and maintained ETL workflows using SSIS, including dynamic master packages, transformations, and performance monitoring.

• Developed T-SQL queries, views, and functions utilizing advanced techniques like CTEs, ranking functions, and batch scripts for optimized data retrieval and manipulation.

• Created dashboards and data models, participated in OLAP/OLTP implementations, and deployed SSAS cubes with expertise in MDX coding.

• Provided production support, troubleshooting, and performance tuning across SQL database objects and procedures using tools like SQL Profiler.

• Integrated multiple data sources, including Azure and Power BI, to generate reports with compelling visualizations and ensured automation of operational 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:

• Performed database performance tuning and optimization using tools like Database Engine Tuning Advisor, focusing on indexes, T-SQL queries, and database structures.

• Developed complex queries, stored procedures, functions, triggers, and transformations for data processing, supporting applications, and improving system efficiency.

• Designed and developed SSIS packages for data transfer, SSRS reports for business analysis, and DTS packages for generating periodic reports in Excel.

• Worked on data warehouse development, schema changes, and capacity planning while ensuring adherence to changing business rules and requirements.

• Monitored database growth, conducted index analysis, and implemented clustered and non-clustered indexes for performance improvements.

• Collaborated on SDLC processes, including requirement gathering, testing, and deployment, while migrating services to Azure Cloud environments.

• Provided production support, troubleshooting, and maintenance for databases, ensuring high-quality deployments and operational efficiency. Environment: MS SQL Server 2012, Enterprise Manager, SSIS, SSRS, SSAS, Informatica, TFS, T-SQL, DTS, Query Analyzer, SQL Profiler, MS Visio, FTP. Education:

Bachelor’s in business studies (2014)

Tribhuvan University Kathmandu, Nepal

Contact this candidate