Chandra goud

SQL BI SSRS SSIS Developer

Email ID: chandrasbi05@gmail.com
Ph: (346)352-7035.

Summary

 Involved in all phases of the SDLC (Software Development Life Cycle) from analysis, design,
development, testing, implementation, and maintenance with timely delivery against aggressive
deadlines.
 Expert in establishing relationships between tables using Primary Key & Foreign Key Constraints.
 Thorough knowledge in all phases of Software Development Life Cycle (SDLC), including requirement
gathering from business users, analysis, design, creation of mapping documents, specification writing,
development, testing, and implementation.
 Expert in RDBMS concepts, Data warehousing concepts, OLTP & OLAP.
 Master in creating Databases, Tables, Joins, Stored Procedure, DDL/DML Triggers, Views, user-defined
functions, and Indexes using T-SQL.
 Knowledge of Crystal Reports, Impact, QNXT applications and experience with of database
management and spreadsheet software.
 4+ years of experience as a Data Engineer working for a complex and fast-paced organization.
 Extensively used Joins and sub-Queries to simplify complex queries involving multiple tables and
optimized the procedures and triggers to be used in production.
 Experienced in Extraction, Transformation and Loading (ETL) process using MS-SSIS, DTS application
tools.
 Implemented Restart-ability feature in ETL Applications and One-bit input based ETL Applications for
Incremental and full load capabilities.
 Excellent Knowledge of Integration Services (SSIS), Extracting, Transforming and Loading (ETL) data
from Excel, Flat file, etc.
 Excellent in High Level Design of SSIS Packages for integrating data using OLE DB Connection from
heterogeneous sources (Excel, CSV, Oracle, flat file, Text Format Data) by using multiple
transformations provided by SSIS such as Data Conversion, Conditional Split, Bulk Insert, Merge and
Merge Join.
 Experience in enhancing and deploying the SSIS Packages from development server to production
server.
 Expertise with T-SQL in writing complex queries, triggers, tables, user functions, views, indexes, user
profiles, relational database models, data dictionaries, and maintaining data integrity
 Created data sources, connection strings and defined the datasets for generating the report.
 Excellent T-SQL Programming skills. Experience in Performance Tuning (Index creation, Table
Partitioning, Database Statistics), Query Optimization.
 Proficiency in creating different types of reports such as Cross-Tab, Drill-down, Drill-through,
Parameterized reports, Linked reports, and Sub reports, and formatting them using both SSRS
 Experience in defining query for generating Cascaded Reports, Custom Reports and creating stylish
report layouts in SSRS.
 Skilled in identifying and resolving performance issues, using techniques like indexing and query tuning.
 Good knowledge in deploying created reports in various sources like Web browser, XML and PDF.
 Experience in providing SSRS server level, item level Security & Accessibility to various reports in
multi-user environment.
 Good experience in using tools such as SQL Profiler, Index tuning, Windows Performance for
monitoring and tuning MS SQL Server performance.
 Experience in performing Back-up/Recovery, running Database Consistency Checks using DBCC,
implementing security, configuring replication.
 Having excellent communication skills, analytical skills, understanding of business requirements in
various domains.
 Actively participated in team building and led many operations for maintaining healthy work
environment.
 Having knowledge in Dimensional Data Modelling, Cube development and manipulations in SQL
Server Analysis Services (SSAS)

Technical Skills:

Database SQL Server Management Studio, Query Analyzer, Business Intelligence Development
Tools Studio, SQL Profiler, QNXT
ETL Tools Data Transformation Services (DTS), SQL Server Integration Service (SSIS)
Reporting
SQL Server Reporting Services (2012/2008(R2)/2008,2005), MS Access, MS Excel.
Tools
Database MS SQL Server 2012/2008/2005, MS Access.
Languages C, T-SQL.
Operating
Windows 2008/2012 server.
Systems
MS Office Suite (Microsoft Word, Power Point, MS Visio), Visio, Team Foundation
Other Tools Server, Data Engineer

Professional Experience:

Columbian Financial Group, NY July 2022 –

Current
SQL BI Developer (SSRS/SSIS)

Responsibilities:
 Creating Reports using Microsoft SQL Server Reporting Services (SSRS) with proficiency in using
Report Designer as well as Report Builder
 Developing highly optimized stored procedures, functions, and database views to implement the
business logic.
 Creating reports to retrieve data using Stored Procedures that accept parameters.
 Administering interface to organize reports and data sources using SSRS.
 Developing Drill down Reports, Drill through Reports and Matrix Reports by using SSRS.
 Generate various Monthly, Quarterly, Bi-Yearly, Yearly reports by different type of reports using SSRS
and SQL server Management studio 2017
 Writing Parameterized Queries for generating Tabular reports using Expressions and Functions, Sorting
the data and Subtotals for the reports using SSRS.
 Developing Charts (Pie Charts) and Graphs like Bar Chart using SSRS and Collaborated with teams to
integrate systems.
 Develop and optimize SQL queries, stored procedures, and functions to extract, transform, and load
(ETL) data from various sources into data warehouses and data marts.
 Actively participate in Agile development processes, contributing to daily stand-ups, sprint planning,
and retrospectives.
 Conduct performance tuning and query optimization to improve the overall efficiency and
responsiveness of BI applications.
 Develop and Execute database queries and conduct analysis.
 Design, build and deploy reporting solutions.
 Translate business needs to technical requirements.
 Managed and developed existing and new ETL processes for Enterprise Reporting, Refreshed staging
tables with ETL. Scaled SSIS to make it work more reliable.
 Created complex Stored Procedures, Functions, SSIS packages, triggers, cursors, tables, and views and
other SQL joins and statements.
 Using SSIS, building high performance data integration solutions, including extraction, transformation,
and load (ETL) packages for data warehousing.
 Implemented data partitioning to improve the performance of large table, reduces contention and
increases availability of data
 Successfully used Agile/Scrum Method for gathering requirements and facilitated user stories workshop.
Documented User Stories and facilitated Story Point discussions to analyze the level of effort on project
specifications.
 Using SSIS, building high performance data integration solutions, including extraction, transformation,
and load (ETL) packages for data warehousing.
 Performed Incremental load with several Dataflow tasks and Control Flow Tasks using SSIS.
 Extensively used SSIS Import/Export Wizard for performing the ETL operations and various containers
to do the looping operations.
 Setup and configured Database mirroring in High Performance, High availability mode as standard DR
strategy.
 Performed Multi File Imports, Package configuration, Debugging Tasks and Scripts in SSIS and
Scheduled package execution in SSIS and Installing packages on multiple servers in SSIS.

Environment: SQL Server 2008/2012, Microsoft Visual Studio 2013/2012, MS Server Integration services,
SSRS (MS server Reporting Services), SSIS QNXT, T-SQL

CVS Health, Texas August 2021 – June

2022
MSBI Developer (SSIS/ SSRS)

Responsibilities:
 Performed System Study and Requirements Analysis, prepared Data Flow Diagrams, Entity Relationship
Diagrams, Data Diagrams, Table Structures.
 Involved in Database design & Data modeling various databases.
 Generated DDL scripts for database schema and created all other database objects.
 Involved in merging existing databases and designed new data models to meet the requirements.
 Developed highly optimized stored procedures, functions, and database views to implement the business
logic and created clustered and non-clustered indexes.
 Designed and developed SSIS (ETL) packages to validate, extract, transform and load data from OLTP
system to the Data warehouse and Report-Data mart.
 Used various SSIS tasks such as Conditional Split, Derived Column etc. which including data validation
checks during Staging, before loading the data into the Data warehouse.
 Created SSIS Packages to perform filtering operations and to import the data on daily basis from the
OLTP system.
 Developed and maintained SQL Server Integration Services (SSIS) packages to automate data
extraction, transformation, and loading processes, reducing manual efforts by 30%.
 Utilized T-SQL to create and optimize complex queries for ad-hoc data analysis, facilitating informed
decision-making.
 Installed and upgraded from SQL Server 2008 to SQL server 2012 on Various Servers.
 Created DDL scripts to create Database schema and Database objects like tables, stored procedures,
views, functions using T- SQL.
 Created Triggers to enforce data and referential integrity, on the specific table which helped users to
prevent inserting invalid data or to respond to a certain event like INSERT, UPDATE and DELETE.
 Involved in database designing using Normalization and Normalized the entities and De-Normalized for
data warehousing purpose.
 Worked with Integration services for transferring and reviewing data from heterogeneous sources like
Excel, CSV, flat file, and Text Format Data.
 Implemented various tasks and transformations for data cleansing and performance tuning of packages
by using SSIS.
 Assisted in the migration of BI applications from on-premises to the cloud, optimizing performance and
scalability.
 Experienced in creating jobs Alerts, Alerts, SQL Mail Agent, and Scheduling SSIS Packages using SQL
Server Agent job.
 Identifies transition opportunities between various systems such as Case Trakker or IMPACT to QNXT
and with other solutions, including development, crosswalks, SQL programming, system integration
requirements, timelines, and departmental updates
 Responsible for implementation of Data viewers, SSIS Logging, Error configurations for Error handling,
Try Catch Blocks in the packages.
 Wrote Parameterized Queries for generating Tabular reports and Sub reports using Expressions and
Functions, Sorting the data and Subtotals for the reports using SSRS.
 Created reports to retrieve data using Stored Procedures that accept parameters.
 Administered interface to organize reports and data sources, schedule report execution and delivery, and
track reporting history using SSRS.
 Created and deployed Adobe reports, drill down reports as required. Performance tuning the existing
reports.
 Developed various Charts (Pie Charts) and Graphs like Bar Chart using SSRS.
 Responsible for Performance Tuning of the SQL Commands with the use of the SQL Profiler and
Database Engine Tuning Wizard.
 Advised optimization of slow performance queries by looking at Execution Plan for better tuning of the
database.

Environment: SQL Server 2008/2012, Microsoft Visual Studio 2013/2012, MS Server Integration services,
SSRS (MS server Reporting Services), QNXT, T-SQL

ING GROUP, Hyderabad, INDIA May 2018 - July

2021 Application/SQL server Developer

Responsibilities:
 Involved in complete SDLC, which includes requirement gathering, analysis, design, development,
Implementation.
 Created Database Objects like Tables, Indexes, Views, User defined functions, C#, Cursors, Triggers,
Stored Procedure, Constraints and Roles.
 Experienced with SQL Server Reporting Services (SSRS) to author, manage, and deliver both paper-
based and interactive Web-based reports.
 Involved in tuning of database by creating efficient stored procedures and T-SQL statements.
 Development of Business rules implemented as Constraints, Triggers and or Stored Procedures.
 Created Clustered and Non-Clustered Indexes for improved performance.
 Worked closely with business stakeholders to gather requirements and translate them into
comprehensive data models and data flows.
 Documented the data flow and the relationships between various entities.
 Created new Database logical and Physical Design to fit the new business requirement and implemented
the same using SQL Server.
 Developed new Stored Procedures, Functions, and Triggers.
 Implemented Backup and Recovery of the databases.
 Actively participated in User Acceptance Testing, and Debugging of the system.
 Designed dynamic DTS packages to transfer data between servers, load data into database and achieved
data file from different DBMS.
 Created and developed stored procedure, Triggers, functions to handle complex business rules.
 Involved in generating reports from scratch using SQL Server Reporting services.
 Worked with development teams in the design of physical database and in modification.

Environment: Microsoft SQL Server 2008R2 Enterprise edition, SSIS, SSRS, T-SQL, BIDS, visual C#,
MS Excel 2007, Windows Server 2003/2008, Reporting services, DTS, MS Access.

Client: CITI Group, India May 2015 – April 2018

SQL Developer

Roles and Responsibilities:

 Installed and configured SQL Server 2008.
 Designed dynamic DTS packages to transfer data between servers, load data into database and achieved
data file from different DBMS.
 Created and developed stored procedure, Triggers, functions to handle complex business rules.
 Created users and logins and granted the permissions at server and DB level.
 Developed DTS packages to pull data from data sources.
 Developed packages to extract and cleanse the data.
 Involved in developing different reports in Pdf format.
 Designed and implemented database structures, including tables, views, and indexes, to support
reporting and analytics needs.
 Assisted senior developers in the design and development of BI solutions for internal projects.
 Gained proficiency in writing SQL queries, SSIS package development, and report generation using
Microsoft Excel.
 Contributed to documentation efforts, including creating user guides and technical specifications for BI
projects
 Involved in scheduling and monitoring all maintenance activities.
 Involved in database consistency checks and index fragmentation.
 Developed stored procedures, UDF and triggers.
 Involved in tuning system stored procedures for better performance.
 Involved in generating reports from scratch using SQL Server Reporting services.
 Involved in implementing high availability strategies.
 Worked with development teams in the design of physical database and in modification.
 Created clustered and non-clustered indexes.
 Involved in tuning of stored procedures for better performance.
 Implemented disaster recovery plans (Log shipping).

Environment: Windows Server 2003/2008, MS SQL Server2008, T-SQL, Reporting services, DTS, MS
Access, MS Excel.