PROFESSIONAL SUMMARY

• A Professional experience in the IT industry as a MS SQL Server Developer using Microsoft SQL server 2017/2016/2014/2012/2008 R2/2008/2005 in Banking, Finance, Healthcare, and Insurance Domains.
• Extensive experience in MS SQL Server 2012 and 2016, Business Intelligence technologies like MS SQL Server Integration Services (SSIS), MS SQL Server Reporting Services (SSRS)
• Experienced in installing, configuring, managing, monitoring, and troubleshooting SQL Server 2012/2014/2016/2017.
• Experienced in designing high level ETL architecture for overall data transfer from the OLTP - Online Transaction Processing to OLAP - Online Analytical Processing with the help of SSIS.
• Excellent experience in migration of data from Excel, Flat file, Oracle to Microsoft SQL Server by using SSIS.
• Expert in designing and scheduling complex SSIS Packages for transferring data manually from multiple data sources to SQL server.
• Expert in creating, configuring and fine-tuning ETL workflows designed in and MS SQL Server Integration Services (SSIS).
• Extensive work experience on creating Script task using C#, ADO.Net, Visual Basics.
• Expert in Creating and Deploying SSRS Reports on the portal for user accessibility.
• Experienced in writing Parameterized Queries for generating Tabular reports, formatting report layout, Sub reports using Global Variables, Expressions, Functions, Sorting the data, defining data source and subtotals for the reports using SSRS 2012, 2014,2016
• Expert in developing Drill through and Drill down reports using MS SQL Server Reporting Services (SSRS)
• Highly proficient in the use of T-SQL for developing complex stored procedures, triggers, tables, user functions, relational database models and data integrity, SQL joins and query writing.
• Extensively used performance monitor/SQL profiler to solve dead locks/long running queries.
• Excellent inter personal skills and communication skills and ready to take challenges with proven ability.

TECHNICAL SKILLS

Database: MS SQL Server 2017/2016/2014/2012/2008 R2/2008/2005, SSRS 2017/2016/2012/2008 R2/2008/2005, SSIS 2017/2016/2012/2008 R2/2008,2005, DB2

Software: MS - Access 2000, MS Excel, Erwin 9.6, MS Visio 2010/2007/2005, Oracle 11g/10g

Programming/Scripting Language: T-SQL, PL/SQL, HTML, XML, Java script, VB Script, C#, VB.Net, HTML, XML, XSL

Tools/Software: Visual Studio 2015/2013/2012/2010/2008, MS office, Windows 2010/2007, Server/ XP, Rally, SharePoint, Confluence, TFS, SVN, Jira, Power BI, Tableau, Desktop 9x/10x, QlikView 11/12

PROFESSIONAL EXPERIENCE

Confidential, Cambridge, MA

SQL Server/SSIS/SSRS Developer

Responsibilities:

• Created and maintained database objects (tables, stored procedures, temp tables and views).
• Filtered and Loaded data from different formats of Data sources into Database tables
• Optimized the performance of queries with modification in T-SQL queries, normalized tables, established joins, and created indexes.
• Used joins, indexes effectively in where clauses for Query optimization.
• Assisted in gathering requirements by performing system analysis of the requirements with the technology teams
• Reviewed and fine-tuned stored procedures and triggers before production migration.
• Gathered business requirements, definition and design of data source and data flows.
• Designed various dynamic SSIS Packages to transfer data from flat files to SQL Server using Visual Studio 2015 Business Intelligence tools.
• Extensively used SSIS transformations such as Lookup, Derived column, Data conversion, Aggregate, Conditional split, Pivot, Unpivot, Expression task, multi cast, file system task, row count, flat file, excel, OLEDB source, OLEDB Destination and Send Mail task etc.
• Worked with fixed width DAT files, text files, excel files to load data on daily basis.
• Experienced in working with many complex SQL queries using joins and unions, built-in and custom functions to generate various reports.
• Optimization of queries by looking at Execution Plan for better tunning of the database
• Created different complex store procedure by understanding various business logic.
• Created complex stored procedures, views for complex reports developed using SSRS 2012/2014
• Developed various types of complex reports like Drill Down, Drill Through, Tabular, Cascading parameter, Sub-Reports, Crystal Reports
• Designed and developed data warehouse, data marts and business intelligence using multi-dimensional models - star schema, snow flake schema.
• Used SSIS to create ETL packages to validate, extract, transform and load data into data warehouse databases.
• Worked with different Control flow tasks in creating SSIS packages especially For Loop and For Each Loop containers with Execute SQL and Script Tasks.
• Created stored procedures comprising of dynamic scripts using Bulk Insert, Insert and Update tasks to copy data from multiple flat files to SQL server staging tables.
• Involved in daily loads (full & incremental) into staging, troubleshooting process, issues and errors using SQL Server Integration Services (SSIS).
• Applied various data transformations like SCD (Slowly Changing Dimension) to maintain the history of the data.
• Did Extensive testing on the performance of the data on application, stored procedures, tables.
• Created SSIS deployable packages and worked with dba for deployment.
• Created externalized SSIS Configuration XML file for easier updates and maintenance of configuration.

Environment: MS SQL Server 2016 Enterprise Edition, MS SSRS 2016, MS SSIS 2016, T-SQL, Windows Server 2010, Rally, SVN, Visual studio 2015, SharePoint, MS Visio.

Confidential, New York City, NY

SQL Server/SSIS/SSRS Developer

Responsibilities:

• Planned, defined and designed data based on the business requirement.
• Designed high level ETL/SSIS architecture for overall data transfer from the OLTP to Data warehouse with SSIS and also prepared ETL/SSIS mapping processes and maintained the mapping documents.
• Developed complex stored procedure using T-SQL to generate Ad hoc reports using SSRS
• Tuned complex Stored Procedures for faster execution and Developed database structures, according to requirements
• Experienced in creating jobs Alerts, Alerts, SQL Mail Agent, and Scheduling SSIS Packages using SQL Server Agent job.
• Developed views to enforce security on critical customer information
• Developed rich visualizations with Drilldown and Dropdown menu option and parameterized using SSRS
• Designed Reports in SSRS and Power BI and published into Power Bi Report Server
• Created and manipulated stored procedures, functions, packages and triggers
• Migrated data from different sources (text-based files, Excel spreadsheets, and CSV) to SQL Server databases using SQL Server Integration Services (SSIS).
• Created SSIS packages for Dynamic ETL/SSIS flow to validate, extract, transform and load data into database using Lookup, Fuzzy Lookup, Derived Column, Conditional Split, Slowly Changing Dimension (SCD) to perform Data Scrubbing, including data validation checks during Staging, before loading the data into the Data warehouse.
• Performed Incremental load with several Dataflow tasks and Control Flow Tasks using SSIS.
• Reviewed and fine-tuned stored procedures and triggers before production migration.
• Worked on various tables to create Indexes to improve query performance
• Implemented various tasks and transformations for data cleansing and performance tuning of packages by using SSIS.
• Created C# script using script task in SSIS for loading.
• Created XML and SQL Server package configuration to make package dynamic using SSIS parameters, expressions, variables and deploy packages to production Server.
• Involved in creating various Database Objects - Tables, Indexes, Store Procedure, Trigger, Views and functions. Improved Performance by creating Clustered and Non-Clustered Indexes and by optimizing the T-SQL statements using SQL profiler.
• Designed and developed different types of reports including Tabular forms, Matrix (cross Tab report) form, Conditional, List items, Charts and Sub reports, custom report, Drill down reports using SSRS.
• Responsible for Deployment of the report-to-report server using SSRS and used Report Subscription (Data Driven and Standard) to publish reports.

Environment: MS SQL Server 2014, 2012/2008, Enterprise Edition, C#, .Net, MS SSRS 2012, MS SSIS 2012, T-SQL 2014, VB Script, Power BI Windows Server 2010, TFS, Erwin 9.6, Jira, and Confluence.

Confidential, NY

SQL Server/SSIS/SSRS Developer

Responsibilities:

• Performed Mapping for multiple related systems.
• Designed different kinds of transactions for the application.
• Developed packages using SSIS to load data into QL server.
• Generated periodic reports based on the statistical analysis of the data from various time frame and division using SQL Server Reporting Services (SSRS)
• Developed Various kinds of tabular, matrix, drilldown, drill through, charts reports, dashboard reports using SSRS.
• Generated and formatted reports using global variable, Expressions and functions designed and implemented stylish report layouts. Used SSRS to create reports and dashboards.
• Created packages and scheduled it to get data from OLTP.
• Created variety of reports for business to provide them with critical information about business status.
• Created and maintained database objects (tables, stored procedures, temp tables and views).
• Developed views to enforce security on critical customer information
• Involved in Job scheduling and alerts.
• Developed cursors and views to improve performance in data transactions.
• Experienced in integrating different Microsoft BackOffice Components such as Share Point.
• Established backup and recovery procedures for databases and implemented automated jobs for backup.
• Created and Implemented triggers in T-SQL to facilitate consistent data entry into the databases.

Environment: SQL server Integration Services (SSIS), SQL server Reporting Service (SSRS) MS SQL Server 2012, SSMS, T-SQL Windows 2010 Server, Share Point, SQL profiler, SQL Agent, Erwin tool 9.6, Jira, and TFS

Confidential, Princeton, New Jersey

SQL Server/SSIS/SSRS Developer

Responsibilities:

• Worked as a SSRS Reports Developer/Administrator and SQL Server Developer in support of Service Management System.
• Created the basic SSIS Framework Technical documents consisting of Naming conventions for packages, transformations, connection managers, log files etc.
• Imported data from text files and excel spreadsheets into SQL Server 2008 database using SSIS package.
• Implemented various types of control flow and data flow transformations in packages to handle different logics and Created SSIS package for Market Value Process feed.
• Used C# scripts in SSIS script task to run custom scripts in package flow.
• Used event handlers to send custom e-mail notifications to business users as well as technical teams.
• Tuned SQL Statements using Indexes using stored Procedures and Performed Index analysis for tables and came up with more efficient solutions to use Clustered and Non-Clustered.
• Developed and tested complex Transact SQL database objects using MS SQL Server such as stored procedures, functions, views and triggers.
• Designed and developed various Service Management Reports, utilizing Dynamic and Cascading Parameter, sub-reports, charts, parameterized reports, conditional and dynamic reports. Performed user acceptance testing on new and modified reports.
• Displayed pie charts, bar graphs for analysis by top-level management using Analyzer in the reports.
• Developed database triggers and stored procedures using SQL tables.
• Managed all indexing, debugging, optimization and performance tuning using Profiler and SQL Server Agent.

Environment: Microsoft SQL Server 2008, Visual Studio 2008, SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), Jira, TFS

Confidential

Data Analyst/SQL Server Developer

Responsibilities:

• Worked as a developer in creating complex Stored Procedures, Triggers and Functions.
• Managed index statistics, Tables, Views, cursors and optimizing queries by using execution plan for tuning the database. Implemented different types of constraints on tables.
• Implemented Performance tuning to optimize SQL queries using query analyzer.
• Tested to optimize the procedures and triggers to be used in production.
• Generated Cross-Tab, Drill-down, Drill-through and Sub-Report using SSRS. Wrote the queries for the drill down reports using SSRS 2005
• Created detailed reports for the customers to help them decide which policy to purchase by showing demographic information based on various parameters.
• Authored performance-based reports for the managers to show sales against various measures like Time, Area, and Price-Range.
• Identified and defined the Datasets for the report generation.
• Extensively used SSIS packages for performing the ETL operations and deployed SSIS packages.
• Performed database transfers and queries tune-up, integrity verification, data cleansing, analysis and interpretation.
• Developed stored procedures to transform the data from enterprise data warehouse to data mart to build dimensions and load data to fact tables.

Environment: MS SQL Server 2005, SSIS, SQL Server Management Studio, Erwin, FTP Communication, MS-Visual Studio, MS Access, Oracle 10g, UNIX, XML, ADO.Net.