Objective:

Seeking a position as a Reporting consultant which utilizes my skills in using Microsoft SQL Server technologies like SQL Server 2005/2008, SQL Server Reporting Services SSRS .

Professional Summary:

• 7 years of IT Experience working with Enterprise solutions with strong Conceptual, Business and Analytical skills.
• 7 years of experience in Designing, Developing and Deploying SQL Server Reports using SSRS.
• 7 years of experience in SQL Server 2005/ 2008 development.
• Experience in interacting with business analysts to develop Functional and Technical design Documents.
• Experienced in defining Query for generating drill down reports in SSRS 2005/2008.
• Design, develop and deliver dynamic reporting solutions using SQL Server Reporting Services SSRS .
• Expert in handling sub reports in SSRS 2005.
• Experienced in sorting the data, defining subtotals for the reports.
• Proficient in using global variables, expressions and functions for the reports.
• Experience creating parameterized, drill-down and drill-through reports using SSRS. Worked on creating different types of reports like Tabular, Matrix, and Charts.
• Expertise in creating stored Procedures, Triggers and Views, taking Backup, scheduling the jobs and creating alerts using SQL Server 2005/2008.
• Expertise in providing information needed to assess the risk of production deployment of a business critical application, installation and configuration readiness, performance and scalability evaluation, stability and durability evaluation, and best practice procedures.
• Implementing Organizational Standards and Coding Conventions, naming standards among the team.
• Strong experience working in Agile/Scrum environments.
• Good Client Interaction, Technical Presentation and Team Building skills.
• Excellent communication and analytical skills, a recognized team player.

Technical Skills:

Work Experience:

Confidential

Role: MSSQL SSRS/SSIS Developer

Premiere Event Tickets

This application is developed using Silverlight, SQL Server 2008 and SSRS to sell tickets, merchandise of the particular event or band to the customers and also to generate reports and charts. The users can register and search for tickets based on event name or city or in on a particular date. The users can also view the pictures videos and albums related to particular event or artist. The website also consists a blog where you can see the updates of the event and also information about the artist. Various reports are generated which involve sale of tickets of an Artist, Event center, Events and Merchandise.

Responsibilities:

• Involved in developing Functional design document and Technical design document using the requirements document.
• Participated in weekly IT status update meetings.
• Designed and developed a database to house data from various data sources for all reporting needs.
• Created Stored Procedures, User Defined Functions and Alter, Insert Update statements using SQL server 2008 and Query manager.
• Created Tables, Views, Queries, Stored Procedures, Triggers and Functions in SQL Server as part of report development.
• Generated Reports using Global Variables, Expressions and Functions for the reports.
• Created parameterized, tabular, drill-down and drill-through reports.
• Analyzed reports and fixed bugs in stored procedures on the ongoing database operations, as needed, to resolve business problems.
• Created linked reports from the initial reports.
• Involved making changes to the existing reports as per the updated business requirements of the users.
• Involved in supporting the existing application also.
• Involved in performing unit, integration and system tests.

Environment: MS SQL Server 2008 , T-SQL, SSRS, Windows 7, Silverlight 4.0, C , Visual SourceSafe , Visual Studio 2010, .Net Framework 4.0.

Confidential

Role: Reporting Services Developer

Service Excellence program

The main objective of this project is to develop a website for service excellence program using DotNetNuke and generate reports using SSRS. Generated reports on quality of the supplier, work history of the employee, Training history of the employee and quality history of the employee depending on the supplier he is associated to. Reports were generated on weekly, monthly, Quarterly and Yearly.

Responsibilities:

• Responsible for requirements gathering from business users.
• Wrote user requirement documents based on functional specification.
• Responsible for Full Report Cycle including Authoring, Managing, Security and generation of Reports.
• Responsible for creating the reports based on the requirements using SSRS.
• Developed custom made dynamic pie, bar charts and Report grids using Reporting services.
• Created Subscription of Reports in different formats like pdf, excel etc to be executed automatically on weekly or monthly basis.
• Created complex correlated sub queries to generate reports.
• Generated reports by passing parameters through URL Developed reports using SQL Server Reporting Services.
• Developed DDL scripts to create database schema and database objects.
• Developed Stored Procedures, Queries, Views and Indexes.
• Involved in the development of various different types of reports like Tabular, Matrix, and Charts
• Involved in performing unit, integration and system tests.

Environment: ASP.NET, C , DotNetNuke, .NET assemblies, Reporting Services, Visual SourceSafe , SQL Server 2008, Visual Studio 2010.

Confidential

Role: SSRS Developer

Retention Reporting System

Designed and developed reports for the Retention Department to retain customers with the company. It was designed to provide the managers with information necessary to retain the customer from the information displayed. It also reports the retention efforts made by the reps and also the reports the reduction of the Churn. Retention representatives are rated using the data displayed by the reports.

Responsibilities:

• Designed and developed a database to house data from various data sources for all reporting needs.
• Gathered reporting requirements from the users and worked on creating functional specs.
• Involved in writing Query for generating drill down reports, identified and worked with the parameters to generate parameterized reports along with that extensively used global variables, expressions and functions.
• Identified the Data Source and defined them to build the Data Source Views.
• Created Tables, Views, Queries, Indexes, Stored Procedures in SQL Server.
• Generated Reports using Global Variables, Expressions and Functions for the reports.
• Converted complex business logic into SQL Stored Procedures and user-defined functions to achieve functionality required by the UI team.
• Worked with the DBA to manage and configure the reporting database as well as securing the data warehouse and map users to their permissions and roles to enable them to operate effectively without affecting the integrity and security of the company height priority data.
• Participated in weekly status meetings, user requirements meetings and made sure the application development meets the deadlines.
• Involved in supporting business users for change in requests.

Environment: MS SQL Server 2008 Enterprise Edition, T-SQL, SSRS, Team Foundation Server, Visual Studio 2008, BIDS.

Credit Request Reporting

This process is designed to handle the display of information covering the entire routing process a credit request goes through. It is a decision support system which is used to track credit requests. It acts as a high-level, portable system that facilitates message flow within the organization and makes it easy for everyone to manage tasks, issues, and requests submitted by a community of users. The workflow has four groups Representatives, Supervisors, Managers, and Vice-Presidents. The user can belong to one or more groups as well as can be from one or more department.

Responsibilities:

• Designed and develop the database needed for the application development.
• Created various database objects like Tables, Indexes and Views.
• Created various Weekly and Monthly reports like Consolidated Report, Credit Tracking Report, Productivity Report and Credit aging Report showing detailed information.
• Reviewed and tuned queries and stored procedures before production migration.
• Involved in project status updates, issue or bug reporting and resolution during testing.
• Created scripts for the promoting the application from test to model and production environments

Environment: MS SQL Server 2008, SSRS, Team Foundation Server, Visual Studio 2008, MS Access.

Confidential

Role: SSRS Developer

Marix Servicing, a specialty loan servicing organization formed by Marathon Asset Management, a New York City-based global asset management company. Responsible for helping to design and develop a database for all of Marix's reporting needs and creating reports on top of the database.

Responsibilities:

• Gathered reporting requirements from every department.
• Participated in weekly IT status update meetings.
• Designed and developed a database to house data from various data sources for all reporting needs.
• Created SSIS packages to extract, transfer and load data into the data warehouse on a daily basis.
• Identified the Data Source and defined them to build the Data Source Views.
• Developed Query for generating drill down reports in SSRS 2005.
• Created and scheduled SQL jobs to run SSIS packages on a daily basis.
• Created complex Stored Procedures, Triggers, Functions, Indexes, Tables, Views and other T-SQL code and SQL joins for applications.
• Generated Reports using Global Variables, Expressions and Functions for the reports.
• Created parameterized, drill-down and drill-through reports.
• Created subscription to reports.
• Deployed reports to Reporting Services.
• Participated and documented all aspects of the QA process.

Environment: MS SQL Server 2005, MS SQL SSRS, SSIS, Visual SourceSafe, Windows 2003 Advanced Server.

References: Will be furnished upon Request.