We provide IT Staff Augmentation Services!

Ssis Developer Resume

0/5 (Submit Your Rating)



  • 7 years of experience in IT, Financial and Healthcare environments with primary skills on the Analysis, Design, Development, Implementing and Testing Client/server application using Microsoft SQL Server and BI suite.
  • Good hands on exposure with SQL Server 2008R 2/2008/2005/2000.
  • Strong technical knowledge in MS SQL Server development including DTS, Microsoft Analysis Services, Performance tuning, Reporting, Designing logical/physical databases and Troubleshooting.
  • In - depth knowledge of T-SQL, SSAS, SSRS, SSIS, BI suite.
  • Experience in Database Development, modeling, Data Warehousing, Design and Technical management.
  • Involved in full Software development life-cycle (SDLC) followed by Agile methodologies to produce high quality software model.
  • Extensive development experience in Microsoft .NET based application using .net, ASP.Net and in database access using ADO.Net (Data Adapter, Reader and Dataset Classes), and best practices.
  • Experience with Microsoft Active Directory, Exchange 2007, SQL 2008 Clusters
  • Experience in administration of SQL and install, setup and manage windows products and install, setup and manage Linux servers
  • Experience with AJAX for interactive communication with a database.
  • Experience in setup and manage IIS and Other IT needSQL Server Services (DTS, SSIS, SSRS, SSAS)
  • Good ETL skills, Data modeling, Dimensional Modeling knowledge with experience in developing data movement, data cleansing and data integrity processes for the purposes of loading decision support applications utilizing advanced knowledge of DTS packages and Transact SQL, design and support/enhancements/maintenance.
  • SQL Server 2005/2008/2008 R2 RDBMS database development including T-SQL programming.
  • ETL implementation using SQL Server Integration Services (SSIS).
  • Experience in Extracting, Transforming and Loading (ETL) data from Excel, Flat file, Oracle to MS SQL Server by using BCP utility, DTS and SSIS services.
  • Experience with file transfer protocols, including standard FTP and SFTP
  • Experience in creating packages, Jobs, Sending Alerts using SQL Mail. Used Microsoft Source Safe for version control.
  • Experience in creating SSIS packages using Active X scripts and with Error Handling.
  • Expert in creating the MDX cubes and dimensions (SSAS).
  • Worked in Data modeling, creating star and snowflake schemas in SSAS.
  • SQL Server 2005 OLAP database development including KPIs, Data mining, working with changing dimensions.
  • Good knowledge with Data-warehousing concepts, MOLAP/ROLAP cubes structure.
  • Developing reports on SSAS & SSRS on SQL Server (2005/2008). Sound Experience and understanding of SSAS, OLAP cube and Architecture
  • Supported team in resolving SQL Reporting services and T-SQL related issues and Proficiency in creating different types of reports such as Cross-Tab, Conditional, Drill-down, Top N, Sub reports, Ad hoc reports and formatting them.
  • Experience in administrating the created reports and assigning permission to the valid users for executing the reports.
  • Experience in deploying created reports in various sources like Web browser, XML and PDF.
  • Good understanding of system tables in Oracle 10g and performance tuning them.Stored Procedure, Functions, Views, Joins and Cursors, linked Server
  • Experience in creating indexed views, cursors, indexes, complex stored procedures, effective triggers, and useful functions to facilitate efficient data manipulation and consistent data storage.
  • Experience in writing complex T-SQL queries using Inner, Outer and Cross Joins.
  • Implemented complex business logic into database design and maintained the referential integrity via triggers and constraints.
  • Created linked server for load balancing and increasing the performance of the Database.
  • Experience in using Try Catch block introduced in SQL Server 2005.Query Optimization and Tuning
  • Experience in Creating and Updating Clustered and Non-Clustered Indexes to keep up the SQL Server Performance.
  • Experience in Creating and Updating Statistics to improve the SQL Server Performance.
  • Experience in Analyzing Execution Plan and managing indexes and troubleshooting deadlocks.
  • Good knowledge in using system tables such as sysindexes, sysprocesses, sysobjects and syscomment in various queries and using Database Console Commands (DBCC).
  • Good Knowledge in managing Data and Transaction log files, Files Groups.
  • Experience in using profilers, Index Tuning Wizard and performance monitor to monitor SQL ServerDatabase Design and Implementation
  • Experience in using Data Modeling Tools like Erwin, MS access and Microsoft Visio.
  • Good knowledge in Normalizing and De-normalizing the tables and maintaining Referential Integrity by using Triggers and Primary and Foreign Keys.
  • Good knowledge of System Development Life Cycle (SDLC).
  • Good in implementing SQL Server Security and Process Control.
  • Experience in Creating Roles and Assigning Permissions to the users.
  • Good team player, strong interpersonal and communication skills combined with self-motivation and the ability to think outside the box


Languages: SQL, Transact SQL, PL/SQL, HTML, XML, C, C++,VB.Net, WCF

Databases: SQL Server 2008/2005/2000/7.0 , MS Access, oracle

Reporting Tools: SQL Server Reporting Service (SSRS),crystal Reports

ETL Tools: SSIS(SQL Server Integration Services), DTS(Data Transformation Services), Import Export Data, Bulk Copy Program (BCP)

Web technologies: .Net, ASP.Net, Ado.Net, Silver light

Data Modeling Tools: Erwin, Visio

Other Software: MS Office- 2007/2003/2000 , Adobe Professional.

Operating Systems: Windows / 98/2000/2003/ XP/Vista, UNIX, Perl

Database Tools: SQL Query Analyzer, SQL Enterprise Manager, Management Studio, SQL Server 2005 Query Editor, Solution Explorer, Analysis Manager, Reporting Server


Confidential, PA



  • Translated business requirements onto technical designs to map and load data from source systems to the data warehouse
  • Extensively used T-SQL in constructing user functions, views, indexes, user profiles, relational database models, data dictionaries, and data integrity.
  • Transformed data from one server to other servers using tools like Bulk Copy Program (BCP) and Data Transformation Services (DTS).
  • Worked as a developer in creating complex Stored Procedures, SSIS packages, triggers, cursors, tables, and views and other SQL joins and statements for applications.
  • Created packages in SSIS with error handling.
  • Worked with different methods of logging in SSIS.
  • Experienced in creating complex SSIS packages using proper control and data flow elements.
  • Worked on SQL Profiler and Query Analyzer to optimize DTS package queries and stored procedures.
  • Created and maintained SQL Server Agent jobs for automated processes.
  • Experienced in documentation of packages.
  • DesignedSSIS Packages to perform Data profiling, Data Cleansing, and Data Transformation.
  • Designed and developed SSIS ETL processes, test, deploy and quality assure the content.
  • Worked on SSIS configuration and trouble-shooting.
  • Participated in enhancing processes for ETL design, source code control, integration testing, defect management, database standardization and tuning.

Confidential, Bethesda, MD



  • Responsible to create customized reports in SSRS using SQL Server 2008 R2 with different type of properties like Chart Controls, filters, interactive sorting, SQL Parameters
  • Creating MDX Query or expression for retrieving and manipulating the multidimensional data stored in OLAP Cubes in SSAS as well as for various calculated members and generating parameterized/Drilldown reports usingSSRSand Crystal Reports and Using dynamic parameters inSSRSto enable/disable the parameters based on user selection.
  • Rewrites existing Legacy reports into SSRS 2008R2.
  • Responsible for developing graphically rich dashboard reports on the Microsoft SQL Server 2008 R2 platform in a way that users can access, based on role or business function within the organization and user skill sets.
  • Design and build custom integrated reporting solution to optimize fast information transfer across all business functional areas, supporting strategic and tactical objectives.
  • Involve in Agile Methodologies to produce high quality results
  • Created Report Models for Ad Hoc reports on different perspective.
  • Creating Dynamic Drill-down, Drill- through, toggle and filtering capabilities to provide insights into specific areas of interest
  • Wrote VB script for user define functions in SSRS.
  • Applying conditional formatting inSSRSto highlight key areas in the report data by using custom code using VB script and developing an automated report subscription process usingSSRS.
  • Created PowerPoint reports in SSRS with the dynamic parameters.
  • Developed several detail and summary reports including line and pie charts, trend analysis reports and sub-reports according to business requirements using SSRS 2008 R2.
  • Done strong architecture and programming inVisual Studio 2010
  • Used Report Builder or Report Designer in Business Intelligence Development Studio (BIDS) to create new reports based on PowerPivot workbooks.
  • Created new ad hoc reports based on PowerPivot workbooks that are published to the same location.

Environment: SQL Server 20 R2, SSAS, T-SQL, SSRS, MDX Cubes, .Net, Visual Studio 2010

Confidential, Chicago, IL



  • Designed high level ETL architecture for overall data transfer from the source server to the Enterprise Services Warehouse which encompasses server name, database name, accounts, tables and direction of data flow, Column Mapping, Data dictionary and Metadata.
  • Wrote T-SQL code for creating cursor and handling the data validations.
  • Expertise in Designing and implementing stored procedures and triggers for automating tasks.
  • Worked on SQL Profiler and Query Analyzer to optimize DTS package queries and stored procedures.
  • Created databases and schema objects including tables, indexes and applied constraints, connected various applications to the database and written functions, stored procedures and triggers.
  • Involved in performance tuning using indexing (Cluster Index, Non Cluster index) tables.
  • Created Indexes, Constraints and Rules on database objects.
  • Created Linked Server to transfer data to legacy systems
  • Involved in scheduling the backups
  • Performed daily tasks including backup and restore by using SQL Server 2005 tools like SQL Server Management Studio, SQL Server Profiler, SQL Server Agent, and Database Engine Tuning Advisor
  • Involved in ER diagrams and mapping the data into database objects.
  • Worked as a developer in creating complex Stored Procedures, SSIS packages, triggers, cursors, tables, and views and other SQL joins and statements for applications.
  • Involved in administrative jobs like Back-ups, data loading and unloading.
  • Developed SSIS Templates which can be used to develop SSIS Packages such a way that they can be dynamically deployed into Dev, Test and Production Environments.
  • Involved in creating DTS packages to copy tables, schemas and views and to extract data from Flat files, Excel and Oracle using SSIS.
  • Involved in extracting the data using SSIS from OLTP to OLAP.
  • Worked on other packages of the SQL server 2005 Edition SSRS (SQL Server Reporting Services), SSAS (SQL Server Analysis Services).
  • Created data mapping between two distinct models.
  • Designed data models using Erwin. Developed physical data models and created DDL scripts to create database schema and database objects.
  • Designed and developed Star and Snow Flake Schema as a data analyst.
  • Reviewed Cube with End user and changing the cube and documentation according to their requirements.
  • Created components, tools, techniques, methods and procedures used in an on On-Line Analytical Processing (OLAP) environment for accessing and translating data into understandable and usable business information using SSAS
  • Maintained production OLAP cubes, wrote MDX queries to generate reports using SQL Server 2005 Reporting Services.
  • Migrated and recreated existing Dimensions and Cubes using Star schema on 2005 Server to achieve the efficiency of SQL Server Analysis (SSAS).
  • Experience in constructing cubes dimensions, DSV’s, fact tables, aggregations, KPI’s, Perspectives etc.
  • Used Microsoft Visual Studio to develop console and graphical user interface applications along with Windows Forms applications, in both native code together with managed code for all platforms supported by Microsoft Windows, .NET Framework, .NET Compact Framework.
  • Involved in providing information to functional segments of the organization using Data marts.
  • Created new XML tags in order to execute new business rules.
  • Involved in Installation, Configuration of Share Point Form in Cluster Environment.
  • Created reports with Analysis Services Cube as the data source using SQL Server 2005/2008 Reporting Services.
  • Used Performance Point Server to create interactive reports with an ability to drill down into details
  • Developed complex Stored Procedures and views to generate various Drill-through reports, parameterized reports and linked reports using SSRS.
  • Implemented site information architecture utilizing various SharePoint resources including Document Libraries, Lists, Form Libraries, Content Types, Column, Information Management Policies and Version Controlling.
  • Used and developed Visual Basic for Applications (VBA) routines in Excel and Access.

Environment: SQL Server Reporting Services 2005/2008, SSAS, MS SQL Server 2005/2008,, SSIS, Front Office 8.3 / 10.2 / 10.3 , MDX Cubes, Windows XP / NT / 2000/2003, MS Office 2003/2007,.Net

Confidential, New York

BI Developer/SSAS Developer


  • Involved in converting all existing DTS packages of MS SQL by adding SSIS task using the different tools like SSMS (SQL Server Management Server), BIDS (Business Intelligence Development Server) and SQL Server Manager.
  • Involved in data warehouse development environment using Microsoft DTS, SSIS, and SSAS technologies and developing system Entity Relational (ER) diagrams.
  • Migrating SQL Server 2000 databases into SQL Server 2005.
  • Involved in designing Data marts.
  • Involved in converting DTS to SSIS and development and implementation of SSIS on an enterprise level.
  • Expertise and Interest include Administration, Database Design, Performance Analysis, and Production Support for complex Databases up to 1 Terabytes.
  • Created ER diagrams (physical and logical using Erwin) and mapping the data into database objects.
  • Expertise in SQL Server Analysis Services.
  • To analyze complex queries and tune the same to optimize application and system performance
  • To set up SQL Server configuration settings.
  • Rebuilding the indexes at regular intervals for better performance.
  • Designed and implemented comprehensive Backup plan and disaster recovery strategies Implemented.
  • Involved in trouble shooting and fine-tuning of databases for its performance and concurrency.
  • Transformed data from one server to other servers using tools like Bulk Copy Program (BCP) and Data Transformation Services (DTS).
  • Responsible for creating batches & scripts for implementing logical design to T-SQL.
  • Developed complex stored procedures using T-SQL to generate reports using Crystal Reports 9.0.
  • Monitored and modified Performance using execution plans and Index tuning.
  • Using log shipping for synchronization of database.
  • Developed Complex Stored Procedures and Views to generate various Drill-through, Drill-down reports, Custom Groups, Dynamic, Parameterized reports and linked reports using SSRS.
  • Extracting the fixed length format files from DB2 databases.
  • Maintaining the database consistency with DBCC at regular intervals.
  • Involved in database design process and data modeling process using Microsoft Visio 2003.
  • Involved in creation of data modeling techniques.

Environment: SQL Server 2000/2005, T-SQL, Windows 2003, ASP.net, Windows 2003, Oracle, SQL Profiler, Erwin, SQL Server Reporting services, SQL Server Analysis Services, Visio, .Net

Confidential, Pittsburgh, PA

SQL/SSIS Developer


  • Experience in Data Management processes, modeling and standards
  • Experience in Data validation, standardization, consolidation, enrichment, cleansing and Data warehousing concepts, including information management and decision support
  • Extensively used T-SQL in constructing user functions, views, indexes, user profiles, relational database models, data dictionaries, and data integrity.
  • Excellent report creation skills using Microsoft Reporting Services (SSRS).
  • Worked with development teams in the design of physical databases and in modification.
  • Managing the use of disc space, memory and connection.
  • Running DBCC consistency checks, and fixing data corruption in application databases
  • Configure and manage database maintenance plans for update statistics, database integrity check and backup operations.
  • Maintain disaster recovery strategies for the database and failover methods.
  • Designed cubes with star schema using SQL Server Analysis Services (SSAS).
  • Understanding the OLAP processing for changing and maintaining the Warehousing Optimizing Dimensions, Hierarchies and adding the Aggregations to the Cube.
  • Created packages in SSIS with error handling.
  • Worked with different methods of logging in SSIS.
  • Experience in creating complex SSIS packages using proper control and data flow elements.
  • Have deployed packages on different servers by configuring it.
  • Installed and configured SQL Server 2005 in Test environment with latest service packs and migrated few databases.
  • Used System tables, System Stored Procedure, DBCC commands for Database maintenance.
  • Implemented computational sensitive queries Stored Procedures.
  • Migrated DTS packages from SQL Server 2000 to SQL Server 2005 as SSIS Packages.
  • Created SQL Server Profiler traces & used with Database Tuning Advisor (DTA) for optimum performance of queries.
  • Developed DTS packages to extract, transform and load into the Campaign database from OLTP database using of SQL Server 2005 Integration Services (SSIS)
  • Experience writing T-SQL scripts, dynamic SQL, complex stored procedures, functions, triggers, SQLCMD, and SMO.

Environment: SQL server 2005, Windows 2000 Advanced Server, Windows 2000 Datacenter, Lumigent Log Explorer, VSS, SQL Diagnostic Manager, SQL LiteSpeed.


Jr. SQL Developer


  • Involved in ER diagrams and mapping the data into database objects.
  • Design of the database and tables.
  • Installed and Configured SQL Server 2000 successfully.
  • Built table relationships and wrote stored procedures to clean the existing data.
  • Coordinated with the front-end developer to put in the business rules.
  • Wrote procedures to check some of the rules at the backend at the time of entering data.
  • Developed SQL scripts to Insert/Update and Delete data in MS SQL database tables.
  • Evaluated database performance and performed maintenance duties such as tuning, backup, restoration and disaster recovery.

Environment: Server 2000 Enterprise Edition, T-SQL, Enterprise manager, Crystal Reports, ERWIN, MS Office and Windows 2000.

We'd love your feedback!