SUMMARY:

• A professional IT experience as SQL server developer with experience in versions like 2017/2016/2014/2012/2008 r2 and various domain like financial, insurance.
• Strong technical knowledge in MS SQL Server development including Microsoft Analysis Services, Performance tuning, Reporting, Designing logical/physical databases and Troubleshooting.
• Extensive experience with different phases of project life cycle (Analysis, Design, Implementation, Testing, and debugging new and existing client - server-based applications).
• In-depth knowledge of T-SQL, SSRS, SSIS, Reporting and Analytics.
• Experience in SSIS (Integration Service) package design, constructing, and deployment.
• Created SSIS packages using package logging, Breakpoints, Checkpoints and Event Handling to fix the errors.
• Transformed data from one server to other servers using tools like Bulk Copy Program (BCP) and SQL Server Integration Services (SSIS) (2012/2014).
• SQL Server 2017/2016/2014/2012/2008 r2 RDBMS database development including T-SQL programming.
• ETL implementation using SQL Server Integration Services (SSIS).
• Design and Build Data Warehouse and Data Mart pulling data from different Business sources. The Data Mart was used for different Dashboard usage.
• Experience working and creating ad-hoc reports, Parameterized, Custom Reporting using SSRS for daily reports.
• Expertise in data modelling, logical, physical model, forward and reverse engineering using Erwin tool and Visual studio.
• Experienced in Data Conversion, Normalization and Data Modeling, Multi-Dimensional Modeling and involved in creation of Fact Tables, Dimension Tables, Star Schema and Snowflake dimensional schema.
• Confident in work independently and proactively. Strong leadership, good communication and excellent interpersonal skills, problem-solving and multi-tasking abilities. Demonstrated experience seamlessly learning new technologies in a short span of time, integrating well into any environment, and working well under pressure.

TECHNICAL SKILLS:

MS SQL Server 2017/2016/2014/2012/2008 r2, Transact- SQL, SQL Server Integration Services (SSIS), SQL Server Reporting Service (SSRS), SQL server Management Studio, SQL server Query Analyzer, SQL server mail service, DBCC, BCP, SQL server profiler, Erwin tool, Microsoft Visual Source Safe, Microsoft Office, MS Visio, MS Excel.

PROFESSIONAL EXPERIENCE:

Confidential

SQL Server/SSIS/SSRS Developer

Responsibilities:

• Conducted detailed analysis of each Legacy source system interface with Data warehouse (DW) including all existing Mainframe Files and Data elements to be converted from Source system to Target Pre-staging.
• Worked with Project Manager and Business Analyst to understand business requirement and involved in planning, defining and designing data based on business requirements.
• Worked with data modeling product support team on tool features, functionality and maintenance.
• Designed and developed SSIS (ETL) packages for loading data from OLTP system, DSR (Staging Database) to DW.
• Responsible for creating database objects like Table, Store Procedure, Triggers, Functions etc. using T-SQL to provide structure to store data and to maintain database efficiently.
• Developed Package Configuration by using SQL Server type for making Package dynamic.
• Modified the Existing SSIS Packages and added more audits and alerts in case of package failure
• Created Views to reduce complexity of end user.
• Involved in performance monitoring and tuning of TSQL queries using SQL Profiler and database engine tuning advisor.
• Created Index to optimize performance of TSQL queries.
• Defined report layouts including report parameters and wrote queries for drill down reports using SSRS.
• Created parameterized, drill down and drill through reports in MS SQL environment using SSRS.
• Involved in scheduling job using SQL Server Agent for SSIS Packages and Store Procedure as per requirement.
• Successfully tested all task in staging and stored all versions of data using team foundation server (TFS).
• Created documents for all Store Procedure, SSIS Package and SSRS Reports that I developed.

Environment: MS SQL Server 2017 Enterprise Edition, SQL Server Integration Service, SQL Server Reporting Services, OLAP, Visual Studio, T-SQL, MS-Access, MS Excel, Report builder, SQL server Profiler.

Confidential

SQL Server/SSIS/SSRS Developer

Responsibilities:

• Developed User Defined Functions, store procedure. Responsible for error handling in Store procedure, indexes to generate the distinct data based on the type of the customer base, wrote T-SQL queries.
• Created various SQL objects such as schema, tables, field definitions and mappings, stored procedures, CTE, Triggers, views and indexes/keys.
• Improved Performance of the database by creating Clustered and non-clustered Indexes and by optimizing the T-SQL statements using SQL profiler.
• Created SSIS Packages to perform filtering operations and to import the data on daily basis from the OLTP 2016 system to SQL server.
• Created packages to validate, extract, transform and load data to a centralized SQL server using OLEDB providers from the existing diversified data sources.
• Involved in performing incremental loads while transferring data from OLTP to data warehouse using different data flow and control flow tasks in SSIS.
• Involved in maintaining batch log tables and error logging tables to handle errors using event handlers. Also, in creating SSIS package to Export and Import data from SQL Server to Access, Text and EXCEL files and Configured SQL mail agent for sending mails upon package deployment.
• Migrated packages from development server to production server using package configuration.
• Enforced data consistency by adding data viewer to the transformations and created dynamic packages by using variables to store the data into SQL.
• Involved in creating dynamic reports using SSRS 2016 for the monthly connections and details of all locations, generated report models using report builder for the end users.
• Involved in scheduled reports on a weekly basis that was generated every Friday containing the details of weekly sales for our location for assessing the business for that week.
• Responsible for Scheduling and publishing reports using SSRS 2016, Responsible for deploying reports to Report Manager and Troubleshooting for any error occurs in execution.
• Generated reports to handle XML data using reporting services for tester to see Invoices in different environment such as Integration, Development, Test and Production.
• Experienced of working with programming concepts in a mainframe environment including with DB2 database.
• Worked closely with DBA team to regularly monitor system for bottlenecks and implement appropriate solutions

Environment: MS SQL Server 2016 Enterprise Edition, T-SQL, sql server reporting services, sql server integrating services, T-SQL, Erwin 7.1, SQL Server Integration Service (SSIS).

Confidential

SQL Server/SSIS/SSRS Developer

Responsibilities:

• Performed T-SQL tuning and optimization of queries for reports that take longer execution time using MS SQL Profiler and Database Engine Tuning Advisor.
• Created/ Maintained clustered/ non clustered Indexes for fast and efficient reporting process
• Reversed engineer backend database to change the T-SQL scripts, create Views, Index, Stored Procedures, Triggers, CTE, Constraints and UDF to improve performance drastically.
• Used DDL and DML Triggers, Stored procedures to check the Data Integrity and verification at early stages before calling them.
• Worked with User Defined Function, triggers to store data into appropriate table as and when data arrives and created indexes to the tables that have least update to improve the query performance.
• Created jobs on daily basis and schedule job to update recent data by using SQL Server Agent jobs.
• Developed and deployed SSIS packages for ETL from OLTP and various sources to staging and staging to Data warehouse using Lookup, Fuzzy Lookup, Derived Columns, Condition Split, Term, Slowly Changing Dimension and more. Performed ETL mappings using MS SQL Server Integration Services.
• Developed and deployed data transfers packages using SSIS, also maintained the jobs running on Servers.
• Worked with Tabular reports, Matrix reports, Gauges & Chart reports, Parameterized reports, Sub reports, Ad-hoc reports, drill down reports as well as interactive reports according to business requirements in time restricted environment using Sql Server Reporting Services (SSRS).
• Scheduled execution and delivery of end of the day report using SSRS.
• Participated in reviews of issues related to SSRS reports and work in troubleshooting those issues, fixing, testing and deploying them.

Environment: MS SQL Server 2014, SQL Server Integration Services 2012, SQL Server Reporting Services 2012, Erwin 7.2, SQL Server Profiler, C#, VB.NET

Confidential

Junior SQL Server Developer

Responsibilities:

• Responsible for creating database object like table, store procedure, triggers, functions etc. using T-SQL to provide structure to store data and to maintain database efficiently.
• Implemented the error handling in the store procedures and SQL object and also modified already existing store procedures, triggers, view, indexes depending on the requirement.
• Responsible for optimizing all indexes, SQL queries, stored procedures to improve the quality of software.
• Created trace in SQL Profiler and used Data base engine tuning advisor for Performance tuning on stored procedures and Scripts.
• Wrote SQL queries using joins, sub queries and correlated sub queries to retrieve data from the database.
• Optimized the query performance with modification in TSQL queries, removing unnecessary columns, eliminating redundant and inconsistent data, normalizing database, establishing necessary joins, creating useful clustered index and non-clustered indexes.
• Improved Performance of the database by creating Clustered and non-clustered Indexes and by optimizing the T-SQL statements using SQL profiler.
• Filtered bad data from legacy system using complex T-SQL statements and implemented various types of Constraints and Triggers for Data Consistency

Environment: MS SQL Server 2012, SQL server agent, MS Visual Windows and T-SQL, SQL Server Profiler.

Confidential

Data Analyst

Responsibilities:

• Involved in all phases of the SDLC (Software Development Life Cycle) from Requirement Gathering, analysis and design, development, testing, maintenance with timely delivery against aggressive deadlines.
• Involved in training session.
• Developed and customized procedures, User defined functions and Triggers.
• Created table, view, synonyms and sequences.
• Involved in ETL Data validation, count and source to target table mapping using SQL queries and back-end testing.
• Involved in Writing Backend SQL queries for source and Target Table Validation.
• Developed and deployed data transfers packages using SSIS 2008, also maintained the jobs running on Servers.

Environment: MS SQL Server 2008R2, SQL server agent, T-SQL, SQL Server Profiler.