PROFESSIONAL SUMMARY:

• 6+ years of extensive experience and hands on working knowledge in various domains of IT industry like Financial office, supplies Insurance, CCAR as SQL BI Programmer.
• Hands on experience in T - SQL Server with Business Intelligence in SQL Server Integration Services, SQL Server Analysis Services and SQL Server Reporting Services.
• Excellent understanding of T-SQL (DDL and DML), SQL Server Integration Services (SSIS), SQL Server Analysis Services (SSAS), SQL Server Reporting Services (SSRS), SQL Server (2012, 2008R2, 2008).
• Experienced in Extract, Transform and Load (ETL) process using MS-SSIS, DTS application tools.
• Experience in data migrating between different homogeneous/heterogeneous systems and SQL Server as a part of Data Migration and Data Maintenance.
• Experience in migration of Data from Excel, Flat file, to MS SQL Server by using SQL Server Integration Services (SSIS) and DTS utility.
• Created stored procedures for generating reports using SQL Server Reporting Services (SSRS), Crystal reports, Excel reports and Hyperion reports.
• Experience in Tableau reporting with extensive business analysis.
• Expert in creating Ad-hoc Reports, Parameterized Reports, Drill down, Drill through and Matrix Reports.
• Expertise in implementing business logic using Triggers, Views, Indexes and Stored Procedures.
• Experience in administrative tasks such as data loading, batch jobs, data unloading, Backup, Recovery and scheduling SQL Server Agent Jobs.
• Expertise in defining Database Backup and scheduling the backups, Recovery and Disaster Recovery Procedures. Experience in Replication, Clustering, Mirroring and other distributed data issues.
• Experience with SQL Server Security and SQL Server Auditing.
• Created different types of encryptions and decryptions in SQL Server as per the client requirement to secure the data and also use it in flexible ways by a group of users.
• Extensively used tools like SQL Profiler, Index Tuning Wizard, and Windows Performance Monitor for monitoring and tuning MS SQL Server performance.
• Extensive experience on Optimization and Tuning for increasing Query and Database performance.
• Built dashboards using techniques for guided analytics, interactive dashboard design, and visual best practices.
• Actively participated in team building and involved in many operations for maintaining healthy work environment, good interpersonal relations and strong communication skill.

TECHNICAL SKILLS:

Databases: SQL Server 2008/2012/2014/2016 , MS Access, Excel.

Database Utilities: Enterprise Manager, DTS, SSIS, SQL Profiler, SQL Query Analyzer, SQL Agents, SQL Jobs, SSAS

Reporting Tools: SQL Reporting Services (SSRS), Crystal Reports, Business Object.

Operating Systems: Win 2003, Win 2000, Win NT, XP, Mainframes.

Application Packages: MS-Office

Web Tools: MS-Front Page, Internet Information Server (IIS), MS-Outlook Express.

Other Tools: Microsoft Visual Studio

PROFESSIONAL EXPERIENCE:

Sr. SQL/SSIS Developer

Confidential, Princeton, NJ

Responsibilities:

• Analyzing and understanding the business requirements, definition and design of the data sourcing and data flows.
• Developing ETL packages with different data sources SQL Server, Flat Files, Excel source files, FTP servers and load the data into target tables by performing various kinds of transformations using SSIS.
• Developing complex and customized Stored Procedures and Queries for implementing business logic and process in backend, for data extraction, reports and other client interfaces.
• Created master - child packages to consolidate data from data sources into SQL server.
• Experience in Microsoft Visual C# in script component and script task of SSIS.
• Experience in supporting Microsoft Azure systems including SQL Server hosted on Azure Virtual Machine (IaaS) and Azure SQL Databases (DBaaS).
• Designed systems to store and process data in a way that can be used by applications and BI systems using Azure Managed Services.
• Created new database objects like Stored Procedures, Functions, Packages, Triggers, Indexes and Views using T-SQL in Development and Production environment for SQL Server.
• Involved in Report Design and Coding for Standard Tabular type reports, including Drill down and Drill through functionality and Graphical presentations such as Charts and Dashboard type metrics using SSRS.
• Actively involved in System Performance by tuning SQL queries and stored procedures.
• Schedule and maintain SSIS packages daily, weekly and monthly using Task Scheduler.
• Involving in developing test cases for Unit Testing.

Environment: SQL Server 2012/2008 R2 Enterprise Edition with Clustering, OLTP & OLAP environment. Replication, Migration, SSAS, ETL, databases in SQL Server, Microsoft, Windows 2003/2008R2 Server, SSIS, SSRS, Erwin, Oracle 11g, and Teradata

T-SQL/SSIS/SSRS Developer

Confidential, Newark, DE

Responsibilities:

• Gathered user requirements and analyzed and designed software solution and database.
• Designed the Entity Relationship(ER) models and logical data (LDM), physical data (PDM) models based upon the design documents.
• Extensively worked on full Software Development Life Cycle (SDLC) of the project from Database Design and Modeling to implementation and maintenance.
• Designed and Developed SSIS Staging Packages to Stage Source files to SQL Server Source Database
• Developed ETL packages with different data sources (SQL Server, Flat Files, Excel source files, etc.) and loaded the data into target tables by performing different kinds of transformations using SQL Server Integration Services (SSIS).
• SSIS Components used extensively in the project are Merge join, Derived Columns, Look UP, Conditional Split and Multicasting.
• Designed various packages using various task e.g. For Each Loop, File System Task, Execute SQL task, Execute Process Task, Execute Package Task, Send Mail Task.
• Performed Index analysis for tables and came up with more efficient solutions to use Clustered and Non - Clustered Indexes for significant performance boost of the existing product databases.
• Worked on all activities related to the development, implementation and Support of ETL processes for large-scale Data Warehouses using SQL Server SSIS
• Created and developed query for Tabular and Matrix Reports using SQL Server 2008 Reports Services (SSRS)
• Created Drill-through reports, parameterized reports and linked reports using SSRS 2005 and 2008.
• Worked on Report generation using SQL Server Reporting Services (SSRS) that could be used to send information to Client.
• Excellent report creation skills using Microsoft Reporting Services (SSRS) with proficiency in using Report Designer as well as Report Builder.
• Developed custom reports and deployed them on server using SQL Server Reporting Services (SSRS).
• Generated periodic reports based on the statistical analysis of the data using SQL Server Reporting Services (SSRS).
• Promoted RDLs to Reporting Service Server (SSRS).

Environment: SQL Server 2012/2008 R2 Enterprise Edition with Clustering, OLTP & OLAP environment. Replication, Migration, SSAS, ETL, databases in SQL Server, Microsoft, Windows 2003/2008R2 Server, SSIS, SSRS, Erwin, Oracle 11g, and Teradata

SQL BI Developer

Confidential

Responsibilities:

• Created Tables, Views, Indexes, Stored Procedure and Triggers. Used multiple join statements to retrieve data and update the tables. Created Backend validations using Insert/Update and Delete triggers.
• Involved in full Software development life - cycle (SDLC) followed by Agile methodologies to produce high quality software model
• Utilized Integration Services (SSIS) to produce a Data Mart for reporting.
• Strong experience in working with BCP, SSIS (DTS, DTSX) packages for Data Integration Services.
• Migrated DTS objects to SQL Server Integrated Services environment, migrated data from SAS environment to SQL Server 2008 via SQL Server Integrated Services
• Implemented SSIS data, created maintenance procedures and provided data integrity strategies.
• Developed custom reports and deployed them on server using SQL Server Reporting Services (SSRS).
• Actively involved in generating Matrix, Sub reports and complex reports with multi value parameters for the analysis of Performance.
• Maintained production OLAP cubes, wrote MDX queries to generate reports using SQL Server 2008 Reporting Services (SSRS).
• Created reports using stored procedure and Experience in building Reports on Analysis Services cubes (SSAS).
• Worked with Report Builder 2.0, Report Models and Ad Hoc Reports.
• Managing the Report Server contents with Admin privileges and Report Manager for Subscriptions, Snapshots and Security Content on the reports.

Environment: SQL Server 2012/2008R2/2005 Management Studio- Enterprise Edition, T-SQL, BIDS, SSIS, SSRS, SSAS, ProClarity, OLAP, XML, SharePoint, Agile, Microsoft Visual Studio 2008 w/.NET Framework 3.5, Windows XP.