SUMMARY

• Having 6 years of experience in IT, Involved in MSBI projects wif extensive usage of SQL Server, SSIS and SSRS.
• Responsible for creating new reports as well as modifying the existing reports using SQL Server Reporting Services (SSRS).
• Created various SSRS Reports involving variety of features like Reports, Charts, Gauges, Filters, Sub - Reports, Drilldown, Drill-Through, Multi-valued parameters etc.
• Excellent experience in Designing, Maintaining & Tuning various RDBMS like T-SQL & MS SQL Server 2005/2008/2008 R 2/2012/2014.
• Involved in designing, developing and deploying reports in MS SQL Server environment using SSRS-2008/R2 in Business Intelligence Development Studio (BIDS).
• Expertise in designing the Packages using multiple sources and destinations wif different types of tasks and transformations according to client requirements.
• Rich experience in designing and deploying Drilldown, Drill through, Parameterized, Sub reports and Dashboards (Contains Bar, Pie and Charts) using SSRS 2008.
• Experience in fine-tuning the database queries, creating indexes on tables.
• Having good experience wif SQL Server in constructing tables, functions, views, joins, stored procedures.
• Expertise in managing Event Handlers, Implementation of logging, Configuration, Deploying & Scheduling the packages.
• Expertise in creating Stored Procedures, Functions, Views, Triggers, Joins, CTE.
• Having good knowledge in creating Indexes, Constraints on tables and fine-tuning the database queries.
• Expert in Data Extraction, Transforming and Loading (ETL) using various tools such as SQL Server Integration Services (SSIS), Bulk Insert.
• Skilled in all areas of RDBMS concepts like scripting T-SQL (DDL, DML) queries & complex stored procedures, designing and implementing views, indexes, functions & triggers.
• Experience in testing and deploying code through several Software Development Life Cycle environments like TEST, UA/UT, Production and DEV.
• Extensive understanding of managing and automating Control flow, Data flow, Events and Logging for SSIS packages.
• Extensively worked wif SSIS tool suite, designed and created mappings using various SSIS transformations like OLEDB Command, Conditional Split, Lookup, Aggregator, Multicast and Derived Column.
• Proficient in solving problems related to Troubleshooting report processing, Subscription, Delivery.
• Strong analytical ability. Proficiency in quickly identifying the cause and solution of particular problem.
• In-depth knowledge of all the widely used operating systems. Able to install and operate databases on different OS platforms.
• Excellent interpersonal skills wif problem solving and analytical skills.
• Strong communication skills (oral and written) along wif good organizational skills.

TECHNICAL SKILLS

RDBMS/DBMS: Microsoft SQL Server 2005, 2008, 2008R2, 2012,2014, MySQL, MS Access

Database Tools: Microsoft SQL Server Management StudioSQL Query Analyzer, SQL Server Profiler.

BI Tools: SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS)SQL Server Analysis Services (SSAS),Business Intelligence Development StudioSQL Server Development Tools (SSDT).

Languages: Structured Query Language (SQL), Transact-SQL, PL-SQL, C, and C++.

Application Tools: MS Office Suite 2003/2007/2010/2013, MS Visio, MS Outlook.

Operating Systems: Windows 2000/2003/2008/ R2/2012/2012 R2 Server, Windows NT, XP, Vista, Windows 7,8,10.

PROFESSIONAL EXPERIENCE

Confidential, Chicago IL

Senior SQL Developer

Responsibilities:

• Created reports (tabular, matrix, chart, drilldown, parameterized) according to business requirements using SSRS.
• Wrote complex SQL queries using table joins (inner and outer).
• Worked on SQL Server Reporting Services (SSRS) to author, manage, and deliver both paper-based and interactive Web-based reports.
• Created Tablix reports, Tabular/Matrix reports based on requirements.
• Prepared Report modules as a developer on MS SQL Server (SSRS, T-SQL, stored procedures and views).
• Developed stored procedures and triggers to facilitate consistent data entry into the database.
• Imported the various files provided by the clients into the relational database systems.
• Simplified complex queries using temporary tables, table variables and stored procedures.
• Created SSIS packages for uploading of different formats of files (Excel, Access, flat files) and databases into the SQL Server.
• Worked on SSIS performance tuning using error handling, event handling, re-running of failed SSIS packages using checkpoints.
• Worked on Sub Reports, Graphing, Data Drill-Down, and Data sorting/grouping.
• Expert in Data Extraction, Transforming and Loading (ETL) using various tools such as SQL Server Integration Services (SSIS), Bulk Insert.
• Extracting and Loading data into SQL Server Database using SSIS.
• Extensively involved in designing the SSIS packages to export data from different sources to SQL Server database.
• Created dashboards using SSRS.

Environment: Microsoft SQL Server, Microsoft Excel, SSIS/SSRS, Microsoft Office, BIDS, Visual Studio, Report Builder 3.0.

Confidential, Mt Laurel NJ

SQL Developer

Responsibilities:

• Wrote different complex SQL queries including inner, outer join and update queries.
• Created database objects likeTables, User Defined Functions, Triggers, Procedures, IndexesandViews as per the team’s request through team tracks.
• Involved in supporting database & BI (ETL and Reporting) activities for various applications and teams across all business units.
• Used differentControl Flow Tasks and Data flow Taskfor Creating SSIS Packages. Used different types ofTransformationsfor Data Conversion, Sorting and cleaning the data from different Sources into Company Format.
• Created Monthly portfolio reports using SQL Server Reporting Services (SSRS).
• Designed physical and logical database structures/diagrams.
• Used SQL Profiler to estimate the Slow Running queries and performance tuning purpose.
• Created Tabular, Matrix, and Drill down reports for different levels of risk officers and sectors.
• Written queries for the matrix and drilldown reports.
• Involved in Creating Complex ad-hoc Reports, Sub Reports, Linked Reports, Charts, Drill through, and Report Models Drill Down Reports.
• Designed large number of reports using table filters, single value parameters, multi value parameters, dependent Parameters using SSRS.
• Worked on Incremental /delta data changes.
• Queried against Heterogeneous Data Sources like SQL Server, Oracle, to retrieve records for data loads using SSIS 2008R2.

Environment: MS SQL Server 2008R2, SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), Business Intelligence Development Studio (BIDS), MS Excel, Windows XP, SQL Server Management Studio (SSMS)

Confidential

Software Developer

Responsibilities:

• Created Tables, Stored procedures and defined functions. Created SQL scripts for tuning and scheduling.
• Developed physical data models, data warehouse models and created DDL scripts to create database schema and database objects.
• Worked wifT-SQLtocreateTables, Views, Triggers and Stored Procedures.
• Created complexjoinsand implementedConstraintson tables for maintainingData Integrity.
• Worked on extracting, transforming and loading data using SSIS Import/Export Wizard.
• Migrated all DTS packages to SQL Server Integration Services (SSIS) and modified the package according to the advanced feature of SQL Server Integration Services.
• Extracted data using SSIS packages (ETL) from different server locations and data sources.
• Created packages to validate, extract, transform and load data to a centralized SQL server using OLEDB providers from the existing diversified data sources.
• Worked wif integration services for transferring and retrieving data from heterogeneous sources like Excel, CSV, flat file, Text Format Data.
• Involved in creating high levelETLarchitecture for overall data transfer to OLTP, ODSwif the help ofSQL Server 2005, 2008Integration services.
• Involved inrelational database modelinglike, designing the tables, algorithmic diagrams for the input data (entity diagrams), indexes etc.
• Worked on retrieving data from Legacy sources, retrieve files on daily, weekly and monthly basis,file-transfersfrom one location to other.
• Created various geographical and time dimension reports of fiscal year, quarter month, week and daily reports for all domains and published through Report Server.
• Improved Performance of the database by creating Clustered and non-clustered Indexes and by optimizing the T-SQL statements using SQL profiler.
• Created Tablix reports, Tabular/Matrix reports based on requirements.
• Created Dashboards using SSRS.
• Conducted user training sessions and supported the requests for enhancements, modifications and new reports.

Environment: MS SQL Server 2008R2, Reporting Services (SSRS), Integration Services (SSIS), T-SQL, MS Access and Excel