We provide IT Staff Augmentation Services!

Ms Sql Server Developer Ssrs/ssis Resume

0/5 (Submit Your Rating)

Washington, DC


  • Over 7 years of experience in MS SQL Server 2012/2008R 2/2008/2005/2000 with Business Intelligence in MS SQL Server Reporting Services (SSRS), MS SQL Server Integration Services (SSIS) and MS SQL Server Analysis Services (SSAS).
  • Interacting with Business users to perform analysis of business requirements, document the user requirements and translate requirements into system solutions.
  • Excellent ability in writing specifications and gathering requirements from the user to develop Reports as per the needs of the client and maintain documentation of the reports for future .
  • Involved in the full System Development Life Cycle (SDLC) of a Data Warehouse and responsible for designing, coding, testing, implementing and supporting the ETL processes for data warehouse solutions and related data marts.
  • Expert in planning, modeling, designing, developing, implementing, administering, and maintaining Microsoft SQL Server 2008/2005/ 2000 and Access 97 - 2007 databases. Some experience with Oracle and MYSQL Databases.
  • Highly proficient in the use of T-SQL for developing complex Stored Procedures, Triggers, Tables, Views, User Defined Functions, Relational Database models and Data integrity, and SQL joins.
  • Excellent experience in creating Indexes, Indexed Views in observing Business Rules and creating Effective Functions and appropriate Triggers to assist efficient data manipulation and data consistency.
  • Experienced in Logical and Physical Database design & development, Data Conversion, Normalization and Data modeling using Erwin and SQL Server Enterprise manager.
  • Expertise in working on all activities related to the development, implementation, administration and support of ETL processes for large-scale Data Warehouses using Bulk Copy Process (BCP), Data Transformation Services (DTS) and SSIS with MS SQL 2008/2005.
  • Experienced in creating many complex SSIS packages with complicated transformations using SQL Server Integration Services.
  • Experience in Importing/Exporting Data from various data sources like Excel, XML and Flat file using SSIS utility. Involved in transformation of OLTP data to the Data Warehouse using SSIS and SQL commands.
  • Experienced in normalizing databases for OLTP environments and de-normalizing tables for use in OLAP environments.
  • Strong knowledge of Data Warehousing methodologies and concepts, including star schemas, snowflakes, dimensional modeling and reporting tools, worked with high volume databases with partitioned data.
  • Expert knowledge and experience authoring, managing and deploying reporting solutions using SSRS.
  • Expert in designing complex reports like reports using Cascading parameters, Drill-Through Reports, Parameterized Reports and Report Models and ad-hoc reports using SQL Server Reporting Services (SSRS) based on client requirement.
  • Hands on experience in Database Installation, Configuration, Maintenance, Monitoring, Backup and Disaster Recovery procedure and Replication.
  • Worked on administration tasks such as Data loading, Batch Jobs, Data unloading, Backup & Recovery, User and Application Table Management, upgrades, creating Databases/File groups/Files/Transaction logs.
  • Demonstrated experience seamlessly learning new technologies in a short span of time, integrating well into any environment, and working well under pressure.


Operating Systems: Windows Server 2000/2003/2008 , Windows XP/Vista

Languages: T-SQL, PL/SQL, C#.Net, VB.Net, ASP.Net, XML, HTML, Java Script

Tools: /Utilities SQL Server Management Studio(SSMS), Query Analyzer, Business Intelligence Development studio, DTS, Analysis Manager, SQL Profiler, SSIS, SSRS, SSAS, Visual Studio 2005/2008, SQL * Plus, Toad, Ervin

Databases: MS SQL Server 2012/2008/2005/2000 , Oracle10g/9i, MS Access, Foxpro, Visual Foxpro, Filemaker, dbase

Data Modeling Tools: Microsoft Visio, UML

Software: MS Office, Adobe Dreamweaver, Adobe Photoshop, Ms Excel, MS-Project 2000

Reporting Services: Excel, MS SQL Server Integration Service (SSIS), MS SQL Server Analysis Services (SSAS), MS SQL Server Reporting Service (SSRS), T-SQL, PL-SQL, SQL Server Management studio (SSMS), MS SQL Server Index Tuning Wizard, SQL Profiler/Analyzer, Bulk Copy Program (BCP),Database Engine Tuning Advisor, SQL Agent, Service Manager, Crystal Reports, Business Objects, Excelcius


Confidential, Washington, DC

MS SQL Server Developer SSRS/SSIS


  • Used ETL (SSIS) to develop jobs for extracting, cleaning, transforming and loading data into data warehouse.
  • Develop, Deploy and Monitor SSIS Packages.
  • Involved in designing, developing and deploying SSIS packages in MS SQL Server environment using SSIS-2008(BIDS).
  • Involved in Migration of Databases from SQL Server 2008 to SQL Server 2012.
  • Widely used SSIS transformation such as Derived Column, SQL Task, Script Task, Send mail task, Fuzzy lookup, Fuzzy Grouping, Data Conversion, Aggregate, Condition Split etc.
  • Developed auto generated system to schedule packages.
  • Involved in upgrading SQL server 2008R2 to SQL Server 2012.
  • Upgrading all SSIS 2008 Packages to SSIS 2012.
  • Scheduled Jobs and Alerts using SQL Server Agent.
  • Scheduled Jobs for executing the stored SSIS packages which were developed to update the database on Daily basis.
  • Execute SSIS 2012 package in SQL Server 2008 R2 usingDTEXEC.EXE Command Line Utility.
  • Designed, Developed and Deployed reports in MS SQL Server environment using SSRS-2005.
  • Generated Sub-Reports, Drill down reports, Drill through reports and Parameterized reports using SSRS 2008.
  • Used Execution Plan,SQL Profiler and Database Engine Tuning Advisor to optimize queries and enhance the performance of databases.
  • We used Agile Methodology for our Project.

Environment: MS SQL Server 2005/2008R2, SQL Server Integration Services 2008(SSIS), SQL Server Reporting Services 2008(SSRS), SQL Server Analysis Services 2008(SSAS), Microsoft Visual Studio, SSMS, ASP.NET, MS Excel, T-SQL, HTML

Confidential, Piscatway, NJ

Senior SQL Server/SSRS/SSIS Developer


  • Involved in Planning, Defining and Designing data based on business requirements and provided documentation.
  • Used SSIS and T-SQL stored procedures to transfer data from OLTP databases to staging area and finally transfer into data warehouse.
  • Performed various SSIS tasks such as Conditional Split, Derived Column, lookup which were used for Data Scrubbing, data validation checks during Staging, before loading the data into the Data warehouse.
  • Developed and deployed data transfers packages to the appropriate destinations using SSIS.
  • Experience in creating Jobs, Alerts, SQL Mail Agent, and schedule SSISPackages.
  • Created SQL server configurationsforSSISpackages.
  • Responsible for creating reports based on the requirements using SSRS 2008.
  • Identified the database tables for defining queries to generate reports for analysis of data using SQL Server Reporting Services in Report Builder.
  • Defined the report layout and identified Datasets for the report generation.
  • Successfully created different type of reports including Cross-tab, Conditional, Drill-down, Sub reports also parameterized reports.
  • Created numbers of complex formula in sub report.
  • Designed and created Report templates, bar graphs and pie charts based on the financial data.
  • Scheduled the monthly/weekly/daily reports to run automatically.
  • Developed, implemented and maintained various database objects such as Stored Procedures, Triggers, Functions, Indexes and Views.
  • Successfully Developed and implemented procedures to ensure the quality, usability and accuracy of reports.
  • Implemented Star Schema for OLAP cubes using SSAS.
  • Created Packages to group logically related column types and to transfer data.
  • Used VSS to store, run, view, edit and revert back to different versions of the design in case of a system crash.
  • Designed both logical and physical data models in Erwin r 7.2

Environment: MS SQL Server 2005/2008, SQL server Reporting Services 2008, SQL Analysis Server 2008, VSS, Microsoft Visual Studio, SQL Server Management Studio, MS Excel, T-SQL,ERWIN.

Confidential, Secaucus, NJ

SQL Server SSRS/SSIS Developer


  • Involved in gathering the report specifications by interacting with the business users
  • Created SSIS packages for Dynamic ETL flow to validate, extract, transform and load data into database.
  • Performed Incremental load with several Dataflow tasks and Control Flow Tasks using SSIS.
  • Created OLAP models based on Dimension and Facts for efficient loads of data based on Star Schema structure.
  • Reviewed and fine-tuned stored procedures and triggers before production migration.
  • Experienced in creating jobs, Alerts, Alerts, SQL Mail Agent, and Scheduling SSIS Packages.
  • Improved Performance by creating Clustered and Non-clustered Indexes and by optimizing the T-SQL statements using SQL profiler.
  • Increased query performance, necessary for statistical reporting by more than 25% after performance monitoring, tuning, and optimizing indexes using Performance Monitor, Profiler, and Index Tuning Wizard.
  • Created various Database Objects - Tables, Indexes, Views, and Roles.
  • Planned, defined and designed data based on the business requirement.
  • Designed and developed different type of reports including: Tabular forms, Matrix (cross Tab report) form, Conditional, List items, Charts and Sub reports, Drill down reports.
  • Upgraded MS SQL Server 2005 databases to 2008, using Detach/Attach, Back up & Recovery and by Replication.
  • Used various SSIS tasks such as Conditional Split, Derived Column etc., which did Data Scrubbing, including data validation checks during Staging, before loading the data into the Data warehouse.
  • Scheduled Jobs for executing the stored SSIS packages which were developed to update the database on Daily basis.

Environment: MS SQL Server 2005/2008R2, SQL Server Integration Services 2008(SSIS), SQL Server Reporting Services 2008(SSRS), SQL Server Analysis Services 2008(SSAS), Microsoft Visual Studio, SSMS, ASP.NET, MS Excel, T-SQL, HTML.


SQL Server Developer


  • Determined the SQL Server Installation. Installed SQL Server Management tools using SQL Server Setup Program.
  • Tested the Installation of SQL Server.
  • Logical Data Modeling using ER-Win to fit business requirement.
  • Implemented Triggers for checking complex business conditions, providing security for the tables.
  • Physical Implementation of database into SQL Server 2000 using T-SQL.
  • Worked on Client/Server tools like SQL Server Enterprise Manager and Query Analyzer to administer SQL Server.
  • Created Database Maintenance Planner for the Performance of SQL Server, which covers Database Integrity checks, Database Statistics update and Re-indexing.
  • Created check constraints to maintain data integrity.
  • Created views to facilitate easy user interface implementation, and triggers on them to facilitate consistent data entry into the database.
  • Created Business-Crucial stored procedures and functions to support efficient data storage and manipulation.
  • Worked on Import/Export for transferring data from heterogeneous database.
  • Data migration (import & export/BCP) from Text to SQL Server.
  • Migrated from SQL server . Installed SSIS and SSRS systems.
  • Created AD-Hoc reports using Report Builder and maintained Report Manager for SSRS.
  • Involved and coordinated with users to gather new requirements and resolved existing issues.

Environment: MS SQL Server 2000, MS Access, DTS (Data Transformation Service), BCP, Query Analyzer, SQL Profiler, Erwin3.5, Windows Performance monitor, text files, Windows XP.

We'd love your feedback!