We provide IT Staff Augmentation Services!

Mssql Ssrs/ssis Developer Resume

Atlanta, GA

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:

Operating Systems: Windows 2003/NT/XP/7.

Languages: C#, XML, XSD, HTML, and T-SQL.

Reporting Tools: SQL Server Reporting Services (SSRS), Tabular, Matrix, Drill Through, Drill Down, Charts and Crystal Reports 7.0.

Databas: es

SQL Server 2005/2008,: My SQL.

Packages/Tools: MS Office, Visual Studio 2005/2008/2010 , Query Analyzer, Management Studio, BIDS, Enterprise Manager, MS Office.

Source Control: Team Foundation Server (TFS), Visual SourceSafe 6.0/2005.

WORK EXPERIENCE:

Confidential, Atlanta, GA

MSSQL SSRS/SSIS Developer

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, Atlanta, GA

Reporting Services Developer

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, Birmingham, AL

SSRS Developer

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.
  • 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, NY

SSRS Developer

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. s: Will be furnished upon Request.

Hire Now