SUMMARY

• 10 + Years of experience in Database Design, Development and business intelligence of Microsoft SQL Server 2005/2008/2012 in Development, Test and Production Environments
• Having exposure in working various domains like Banking Financial Services, Insurance and Health Care
• Having knowledge and experience in implementing SQL Server Integration Services (SSIS)
• Extensive knowledge in commercial RDBMS such as MS SQL Server and MS Access.
• Excellent knowledge in creating Databases, Tables, Stored Procedures, DDL/DML Triggers, Views, User defined data types, functions and Indexes using T - SQL.
• Great ability to create and manage various database objects like tables, views.
• Worked Extensively on ETL process using SSIS package.
• Experience in Data Conversion and Data Migration using SSIS and DTS services across different databases
• Experience in using T-SQL in SQL Server 2000/2005 and 2008 platforms.
• Experience in maintenance and Administration of SSIS by creating Jobs, Alerts, SQL Mail Agent, and schedule DTS/SSIS Packages.
• Experience in SQL Server Integration Services package design, constructing, and deployment
• Proficient in creating and tuning SQL queries to extract data from different databases (SQL Server, Teradata) for timely reporting and Validation.
• Having good knowledge and experience in reporting technologies like SQL Server Reporting Services (SSRS) and Microstrategy Reporting tool
• Having good knowledge and experience in Analysis service like SQL Server Analysis Services (SSAS)
• Having good knowledge in Data visualization technologies like Tableau Reporting tool
• Having good knowledge in Microsoft Power BI
• Excellent analytical, problem solving, communication and inter-personal skills to manage and interact with individuals at all levels.
• Strong understanding of project life cycle and SDLC methodologies including Waterfall and Agile.
• Strong experience in client interaction in understanding business applications, business data flow, and data relations.
• Strong team handling and offshore co-ordination experience

TECHNICAL SKILLS

Technologies worked on: Microsoft Business Intelligence(MSBI) Microsoft SQL Server Reporting Services (SSRS), SQL Server Integration Services (SSIS), SQL Server Analysis Services (SSAS), Tableau Reporting and Microstrategy reporting Tool

RDBMS: MS SQL Server 2000/2005/2008/2012 , MS Access

Front End Tools: Visual Studio / 2010/2008/2005/2013

Web & Application Servers: Internet Information Server 6.0 and 7.0

Languages: C#, ASP.NET, .NET Frame Work

Operating Systems: Windows XP, NT, Windows 2003 Server, Windows 2000, Windows 7, Windows 10

Source Control: SVN (Sub Version), Visual Source Safe, TFS

Specialized Tools: MS-Office, Visio

Object-oriented Design: Agile Scrum, Waterfall SDLC, Test-Driven Development, Data-driven Design, Onshore-Offshore development Model

PROFESSIONAL EXPERIENCE

Confidential, Charlotte, NC

Lead SSIS SQL Developer

Responsibilities:

• Wholesale Flood Operating System (WFOS) - It’s an integrated enterprise solution across wholesale banking to provide complete life cycle of loan booked and it falls under the Flood Zone .The application receives the borrower case information along with the loan information from system of record (SOR).Once fully deployed the application will provide a single global view of client credit relationships, mitigate operational risk associated with varied and platform-centric processes and meet the demands of increased regulatory scrutiny across the portfolio.
• Flood reporting provides detail on Insurance for real estates which are in flood zone. There are 3 actions associated with Flood Reporting
• Involved in analysis, design and development of OLTP/OLAP system.
• Involved in troubleshooting and fine-tuning of databases for its performance and concurrency.
• Designed and developed stored procedures, triggers and user defined functions in SQL Server for OLTP system.
• Maintaining records in Excel Spread Sheet and exporting data into SQL Server Database using SQL Server Integration Services.
• Extensively used T-SQL to create triggers and stored procedures used by the enhancements modules to update the SQL Server database.
• Performance tuning, query optimization and execution plan of queries for better performance.
• Build efficient SSIS packages for processing fact and dimension tables with complex transforms and type 1 and type 2 changes.
• Implemented TYPE 1 and TYPE 2 dimensions to maintain current and historical information
• Created packages using SSIS for data extraction from Flat Files, Excel Files, and OLEDB to SQL Server.
• Involved in Capturing Requirements, Preparing Business Blocks, UML Use Cases, Collaboration Sequence, and Activity diagrams, defined and Managed as Part of CMM
• Written and executed complex T-SQL queries using SQL Management Studio for back end data validation testing.
• Implemented the AGILE Method of Development in team with best practices.
• Worked in Agile Scrum Methodology with daily stand up meetings.
• Tracking Issues and Actions Log.
• Maintained the technical/functional articrafts in the TFS
• Technology platform and environment: T-SQL, SSIS, SSRS, SQL server, C#.Net, SQL Profiler, SQL Server Agent, MS Excel, Visual Studio 2008/2010 and Sales Force Integration with SQL

Confidential Charlotte, NC

Lead SSIS SQL Developer

Responsibilities:

• Panorama - Panorama is a whole sale reporting application tool and it extracts the data from various environments approximately we are migrating 15 application source data into Panorama reporting business layer.
• Responsible for Creating and managing schema objects such as tables, views, indexes, stored procedures, and triggers & maintaining Referential Integrity.
• Administering the MS SQL Server by creating user logins with appropriate roles, monitoring the user accounts, creation of groups, granting the privileges to users and groups.
• Identified and worked with Parameters for parameterized reports in SSRS 2008 R2
• Developed, deployed and monitored SSIS Packages.
• Developed different types of Tabular Reports, Matrix Reports, Chart and Graphs Reports, Ad-Hoc Reports using MS SQL Reporting Services (SSRS) and Tableau Reporting
• Designed, developed initiatives and special projects databases.
• Created clear documentation as per the requirement within the programs and application documentation repository.
• Maintenance and Administration of SSIS by creating Jobs, Alerts, SQL Mail Agent, and schedule DTS/SSIS Packages.
• Involved in conversion ofDTS to SSISpackages and troubleshooting the migration issues
• GeneratedAd-Hoc, Drill down, Drill Through reportsusingLocalandGlobal Variables, Expressionsand Filters inSSRS.
• Created packages using SSIS for data extraction from Flat Files, Excel Files, and OLEDB to SQL Server.
• Involved in fine Tuning and Performance and Query optimization of the Database as required by the application
• Technology platform and environment: SQL Server 2005/2008, SQL Server Integration Services (SSIS 2008), SQL Server Reporting Services (SSRS 2008, Windows Server 2003, T-SQL, SQL Profiler, SQL Server Agent, MS Excel, Visual Studio 2008/2010.

Confidential

Technology Analyst

Responsibilities:

• Responsible for Creating and managing schema objects such as tables, views, indexes, stored procedures, and triggers & maintaining Referential Integrity.
• Administering the MS SQL Server by creating user logins with appropriate roles, monitoring the user accounts, creation of groups, granting the privileges to users and groups.
• Identified and worked with Parameters for parameterized reports in SSRS 2008 R2
• Developed, deployed and monitored SSIS Packages.
• Developed different types of Tabular Reports, Matrix Reports, Chart and Graphs Reports, Ad-Hoc Reports using MS SQL Reporting Services (SSRS) and Tableau Reporting
• Designed, developed initiatives and special projects databases.
• Created clear documentation as per the requirement within the programs and application documentation repository.
• Maintenance and Administration of SSIS by creating Jobs, Alerts, SQL Mail Agent, and schedule DTS/SSIS Packages.
• Involved in conversion ofDTS to SSISpackages and troubleshooting the migration issues
• GeneratedAd-Hoc, Drill down, Drill Through reportsusingLocalandGlobal Variables, Expressionsand Filters inSSRS.
• Created packages using SSIS for data extraction from Flat Files, Excel Files, and OLEDB to SQL Server.
• Involved in fine Tuning and Performance and Query optimization of the Database as required by the application
• Technology platform and environment: SQL Server 2005/2008, SQL Server Integration Services (SSIS 2008), SQL Server Reporting Services (SSRS 2008, Windows Server 2003, T-SQL, SQL Profiler, SQL Server Agent, MS Excel, Visual Studio 2008/2010 and Microstrategy Reporting tool

Confidential

Sr SQL BI developer

Responsibilities:

• Confidential Services is a multinational Organization it is based in the United States & India. Its focus is exclusively on the US health insurance industry. Confidential provides end-to-end Health insurance application support the project needed Customization & Implementation of a large & complex US based healthcare Product “QNXT” & “Facets”. TGI Composite project is maintenance/ Support project for Confidential . Project is needed to Support for BPO activities carried out at Confidential . This includes creation of new SSIS Packages and SSRS reports, developing tools which will help to analyze data, modification of existing Reports.
• Responsible for Creating and managing schema objects such as tables, views, indexes, stored procedures, and triggers & maintaining Referential Integrity.
• Administering the MS SQL Server by creating user logins with appropriate roles, monitoring the user accounts, creation of groups, granting the privileges to users and groups.
• Identified and worked with Parameters for parameterized reports in SSRS 2008 R2
• Developed, deployed and monitored SSIS Packages.
• Developed different types of Tabular Reports, Matrix Reports, Chart and Graphs Reports, Ad-Hoc Reports using MS SQL Reporting Services (SSRS).
• Designed, developed initiatives and special projects databases.
• Created clear documentation as per the requirement within the programs and application documentation repository.
• Maintenance and Administration of SSIS by creating Jobs, Alerts, SQL Mail Agent, and schedule DTS/SSIS Packages.
• Involved in conversion ofDTS to SSISpackages and troubleshooting the migration issues
• GeneratedAd-Hoc, Drill down, Drill Through reportsusingLocalandGlobal Variables, Expressionsand Filters inSSRS.
• Created packages using SSIS for data extraction from Flat Files, Excel Files, and OLEDB to SQL Server.
• Involved in fine Tuning and Performance and Query optimization of the Database as required by the application
• Technology platform and environment: SqlServer2005/2008, SQL Server Business Intelligence Development Studio, Windows XP, T-SQL, SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), SQL Server Analysis Services (SSAS), Asp.net, C#.net

Confidential

SQL BI developer

Responsibilities:

• Client Audit Vigilance (CAV): This Audit tool is help to identify the status of claim for different health payer’s and hospitals
• Developed, deployed and monitored SSIS Packages.
• Developed different types of Tabular Reports, Matrix Reports, Chart and Graphs Reports, Ad-Hoc Reports using MS SQL Reporting Services (SSRS).
• Designed, developed initiatives and special projects databases.
• Created clear documentation as per the requirement within the programs and application documentation repository.
• Maintenance and Administration of SSIS by creating Jobs, Alerts, SQL Mail Agent, and schedule DTS/SSIS Packages.
• Involved in conversion ofDTS to SSISpackages and troubleshooting the migration issues
• GeneratedAd-Hoc, Drill down, Drill Through reportsusingLocalandGlobal Variables, Expressionsand Filters inSSRS.
• Created packages using SSIS for data extraction from Flat Files, Excel Files, and OLEDB to SQL Server.
• Involved in fine Tuning and Performance and Query optimization of the Database as required by the application
• Technology platform and environment: SQL Server 2005/2008, SQL Server Integration Services (SSIS 2008), SQL Server Reporting Services (SSRS 2008), Windows Server 2003, T-SQL, SQL Profiler, SQL Server Agent, MS Excel, Visual Studio 2008/2010.

Confidential

Software Engineer

Responsibilities:

• Document Management System (DMS): Document management system is help to understand the complete flow of a claim document in various environmental condition and follow the business rules based on federal laws
• Developed, deployed and monitored SSIS Packages.
• Developed different types of Tabular Reports, Matrix Reports, Chart and Graphs Reports, Ad-Hoc Reports using MS SQL Reporting Services (SSRS).
• Designed, developed initiatives and special projects databases.
• Created clear documentation as per the requirement within the programs and application documentation repository.
• Maintenance and Administration of SSIS by creating Jobs, Alerts, SQL Mail Agent, and schedule DTS/SSIS Packages.
• Involved in conversion ofDTS to SSISpackages and troubleshooting the migration issues
• GeneratedAd-Hoc, Drill down, Drill Through reportsusingLocalandGlobal Variables, Expressionsand Filters inSSRS.
• Created packages using SSIS for data extraction from Flat Files, Excel Files, and OLEDB to SQL Server.
• Involved in fine Tuning and Performance and Query optimization of the Database as required by the application
• Technology platform and environment: SQL Server 2005/2008, SQL Server Integration Services (SSIS 2008), SQL Server Reporting Services (SSRS 2008),C#.Net, ASP.Net, Windows Server 2003, T-SQL, SQL Profiler, SQL Server Agent, MS Excel, Visual Studio 2008/2010