SUMMARY

• Over 8 years of experience in development and maintenance of Integration Services (SSIS), SQLServer Reporting Services (SSRS) and SQL Server Analytical Services (SSAS).
• Expertise in writing T - SQL Queries using joins and sub queries in MS SQL Server.
• Created custom specific and efficient SQL server/Oracle Reports using SSRS/Oracle Reports.
• Expert in defining Query for generating drill down reports in SSRS.
• Hands on experience in reporting tools like SQL Server Reporting Services (SSRS), Crystal Reports.
• Created SSRS report projects in Visual studio and created, modified and managed various report models with multiple objects, source fields and expressions.
• Worked on projects using Agile/SCRUM methodology.
• Hands on experience with SQL programming and Transact-SQL in creating tables, Stored Procedures, triggers, user-defined functions, views, indexes, user profiles, relational database models.
• Worked extensively on Optimization and Tuning for increasing Query and Database performance.
• Experience in data migration between different homogeneous/heterogeneous systems and SQL Server as a part of Data Migration and Data Maintenance.
• Experienced in Extraction, Transformation and Loading (ETL) process using MS-SSIS, DTS application tools.
• Hands on experience on all phases of Software Development Life Cycle (SDLC) of Data warehousing,including requirement gathering from business users, analysis, design, creation of mapping documents, specification writing, development, testing, and implementation.
• Excellent Report creation skills in developing reports like Tabular Reports, Matrix Report, Charts, Custom Reports, using Report Designer as well as Report Builder in SQL Server Reporting Services (SSRS).
• Ability to work independently and in a team, capable of handling time-sensitive issues in distributed environments.
• Good Knowledge in Physical and Logical Data Modeling.
• Excellent analytical, interpersonal and communication skills; fast learner, hard worker and team player.
• Skilled at assessing client needs, working in groups, suggesting ideas that enhance efficiency andperformance, implementing technology solutions and end users.

TECHNICAL SKILLS

DBMS/RDBMS: MS-SQL Server 2012/2008R2/2008/2005

ETL: SQL Server Integration Services (SSIS), DTS, SSRS, T-SQL using Stored Procedures

Database Connectivity: OLEDB and ODBC

Front End: SQL Reports, C#, .Net, Python

BI Tools: SSRS / SSIS / SSAS

Languages/Office Tools: C, C++, PL/SQLMS Office, Outlook, One Note

PROFESSIONAL EXPERIENCE

Confidential, Houston, TX

Business Intelligence Developer

Responsibilities:

• Worked as a SQL BI developer with Enterprise Reporting Team.
• Designed business intelligence (BI) reports using BI reporting tool SSRS.
• Migrated the DTS packages into SSIS and create new SSIS packages to Extract, transform and load the data from old data warehouse to new data warehouse and OLTP to OLAP.
• Removed the DTS package s from stored procedures and created as SSIS packages and embedded those procedures in the SSIS package to retain the load functionality of the system.
• Involved in creating complex SSIS packages using proper control and data flow elements.
• Used Fuzzy Lookup and Fuzzy grouping transformations for improving the data quality of the existing data as well as new data that is being loaded into the database. Generated various Drill-through reports, parameterized reports, sub-reports and linked reports.
• Migrated SQL reports in SSRS to Teradata.
• Created report queries utilizing Teradata SQL.
• Created SSRS reports with drill through capabilities, Sub reports for Reconciliation Process.
• Developed reports using SSRS in different schemas.
• Created different Types of Parameters in SSRS.
• Created Parameterized Queries, generated Tabular reports, Sub reports, Cross Tabs, Drill down reports using Expressions, Functions, Charts, Maps, Sorting the data, Defining Data sources and Subtotals for the reports using SSRS 2012.
• Designed, deployed and maintained complex canned reports using SQL Server 2012 Reporting Services (SSRS).
• Used SSRS Reports to write complex formulas and to query the database to generate different types of ad-hoc reports for Business Intelligence.
• Analyzed complex data systems and business data elements, data flow, relationships and designed reports based on user's requirements.
• Experience with performance tuning of the long running queries.
• Monitored the performance of reports and worked to optimize or improve the performance of the reports when necessary.
• Created report model to help users create Ad hoc reports using report builder.
• Created custom stored procedure to generate complex canned reports and deployed them on the report manager.

Environment: SQL Server 2012, Integration Services (SSIS), Reporting Services (SSRS), Analysis Services (SSAS), DTS, C#, .Net, T-SQL, Windows XP/NT/7, MS Excel, MS visual Studio.

Confidential, San Antonio, TX

SSRS Developer

Responsibilities:

• Created new database objects like stored procedures, functions, Triggers, Indexes and Views using T-SQL in Development and Production environment for SQL Server 2012
• Worked on full life cycle development (SDLC) involving in all stages of development
• Created and Executed Stored Procedure for generation of SSRS Reports
• Creation of Report Layout and configuration of report environment using SSRS
• Physical Migration of the Developed reports onto the Development SSRS server
• Initiate code review and perform validation based of the report environment
• Execution of the report in SSRS runtime environment for a set of values
• Created Documentation of Created Reports
• Report parameters included single valued parameters, multi-valued parameters which also consisted of different parameter types like hidden, internal, default (queried and non-queried parameters)
• Worked on all types of reports types like tables, matrix, charts and sub reports etc.
• Involved in relational database modeling like designing the tables and algorithmic diagrams for the input data (entity diagrams), indexes, etc.
• Exporting the database from Local server to the remote server and importing the current running database from remote server to the local DB Server using SSIS
• Reduced the overall ETL time by SQL Query Performance Tuning

Environment: SQL Server 2012, Integration Services (SSIS), Reporting Services (SSRS), Analysis Services (SSAS), DTS, C#, .Net, T-SQL, Windows XP/NT/7, MS Excel, MS visual Studio.

Confidential, Portland City, OR

SSRS Developer

Responsibilities:

• Wrote and executed complex T-SQL queries and created Stored Procedures, Triggers, functions and Views.
• Involved in Performance Tuning of Code using execution plan and SQL profiler and added Indexes to improve performance on tables.
• Worked on creating complex queries to pull up data from various tables using Loops and creating variables.
• Developed Stored Procedures in SQL Server 2012/2014 and modified existing stored procedures as needed.
• Involved in Source Data Analysis, Design and creation of Data Mappings for Extraction of bulk data from heterogeneous sources like Flat Files, Excel and other OLEDB, ODBC data sources.
• Developed Dynamic packages using SSIS and Implemented Incremental Data Loading.
• Created SSIS packages for dynamic ETL/SSIS flow to validate, extract, transform and load data intodatabase using lookup and fuzzy lookup to perform Data Scrubbing including data validation checks during staging, before loading the data into the Data warehouse.
• Created shared dimension tables, measures, hierarchies, levels, cubes and aggregations on MS OLAP/Analysis Server (SSAS).
• Developed Query for generating Drill Down and Drill through Reports in SSRS 2012 and 2008.
• Designed and formatted SSRS Reports using Parameters and Expressions for the Reports.
• Automated the execution of SSRS reports using Subscriptions and Data-Driven Subscriptions.
• Involved in Troubleshooting system issues, monitored scheduled jobs and set up maintenance plans for proactively monitoring the performance of SQL Server databases.

Environment: Windows 2007/XP/vista, .NET Framework, MS Excel, Microsoft SQL Server 2008/2012, SSIS, SSRS, SSAS, T-SQL, MS Visual Studio, PL/SQL.

Confidential, Philadelphia, PA

SQL Server Developer/BI Developer

Responsibilities:

• Involved in gathering the business requirements.
• Experience in all phases of Software development life cycle including System Analysis, Design, DataModeling and Implementation.
• Created the tables, views, indexes, stored procedure in the database and responsible for maintaining the database.
• Extensive experience in Relational and Dimensional Data modeling for creating Logical and Physical Design of Database and ER Diagrams using multiple data modeling tools like ERWIN, ER Studio.
• Worked on creating the complex Queries.
• Strong experience in SQL Development, ETL development using Microsoft SQL Server Integration Services
• Extracted, transformed and loaded data from various heterogeneous data sources and destinations likeAccess, Excel, CSV, Oracle, flat files using connectors, tasks and transformations provided by SSIS
• Worked on the reports to pull up the finances data of the company by using the Business intelligence SQL server Reporting Services (SSRS).
• Developing Corporate Dashboard Reports using SQL Server Reporting Services (SSRS), Report Model and Ad Hoc Reporting using Report Builder functionality.
• Hands-on experience in development of Drill down Reports in SSRS & Generated daily, weekly & monthly reports for management.
• Developed Sub Reports, Matrix Reports, and Charts using SQL Server Reporting Services (SSRS).
• Experience in writing parameterized Queries for generating reports, formatting report, layout, sub reports using global variables, expressions and functions in SSRS.
• Worked on migrating the SSRS reports from SQL server 2005 to SQL server 2008 to SQL server 2008R2.
• Involved in redesign, recode and new design layout of the SSRS reports.
• Assisted with various ad hoc query requests and built the ad hoc reports.

Environment: SQL Server 2005/2008/2008 R2 Enterprise Edition, SSIS, SSRS, MS .NET Frame Work, ASP.NET, T-SQL, MS Access, Erwin, ER Studio, MS Project.

Confidential, Basking ridge, NJ

SQL SSRS/SSIS Developer

Responsibilities:

• Created database objects like Tables, Views, Indexes and Stored Procedures.
• Created Entity Relationship (ER) diagrams based on requirements.
• Worked on SSRS reports to report the Daily, Weekly and Monthly Statistics of customer transactions.
• Defined the report layout and identified datasets for the report generation. Developed reports using complex T-SQL queries, user defined functions, stored procedures and views.
• Developed drilldown, drill through, parameterized, and Ad hoc reports and charts using SSRS.
• Generated the drilldown, drill through and linked reports using the SSRS.
• Set up & configured DB mail and created jobs to send out an email whenever any SQL jobs fails.
• Created the necessary indexes to improve the query performance using SQL Server Query Analyzer.
• Worked with different Control flow tasks in creating SSIS packages.
• Built different types of chart reports using Reporting Service for the business requirement.
• Deployed and configured the reports in the Report Server.
• Designed and develop Dashboards and Reports using SSRS.
• Generated daily, weekly and monthly reports for the managers.
• Optimized SQL queries for improved Performance and availability.
• Wrote SQL queries and stored procedures to generate data for reports.

Environment: SQL Server 2005/2008, SSRS, SSIS, T-SQL, Script, JavaScript, SQL Server Query Analyzer, Microsoft Office, Windows 7/XP.

Confidential

SQL Server Developer

Responsibilities:

• Extensively involved in installing and configuring SQL server 2005.
• Transformed data using DTS packages, BCP utility and Bulk Insert statement as and when necessary.
• Gained expertise in Security Issues by creating Users and granting Permissions on various Objects.
• Creation of Triggers to perform Data validations as well as Server level and Database level monitoring and Alert the users with the field status changes.
• Created database and database objects such as index, Table, stored procedure, view, trigger and function using T-SQL.
• Served as aSSRS2005 Reports Developer and SQL Server Developer in support of Service Management System.
• Developed procedures and triggers involving extensive use of T-SQL to implement business rules.
• Interacted with Business Analysts and Project Managers to give status updates and recommend changes.
• Created complex Stored Procedures and Cursors to support applications using T-SQL.
• Generated Reports for the day-to-day as well as weekly/monthly purposes.
• Created Distributed Partition Views Using T-SQL.

Environment: MS SQL server 2005, SSRS, Query analyzer, DTS, SQL profiler.