We provide IT Staff Augmentation Services!

Sql Server/ssis/ssrs Developer Resume

3.00 Rating

Augusta, MainE

PROFESSIONAL SUMMARY:

  • A Microsoft Certified Professional with around 7 + years of total IT experience in the Design, Modeling, Development, Implementation and Support of SQL Server 2000/2005/2008/2008 R2.
  • Expert in analyzing, designing, developing, installing, configuring and deploying MS SQL Server suite of products with Business Intelligence in SQL Server Reporting Services 2005/2008, SQL Server Analysis Services of 2005/2008 and SQL Server Integration Services.
  • Experience in maintaining one to many and many to one relationships while moving data between two databases.
  • Experience in using recursive CTEs, CTE, temp tables and effective DDL/DML Triggers to facilitate efficient data manipulation and data consistency as well as to support the existing applications.
  • Expertise in writing T - SQL Queries, Dynamic-queries, sub-queries and complex joins for generating Complex Stored Procedures, Triggers, User-defined Functions, Views and Cursors.
  • Skilled in error and event handling: precedence Constraints, Break Points, Check points and Logging.
  • 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, Summary, Form, OLAP and Sub reports, and formatting them.
  • Experience in using SSIS tools like Import and Export Wizard, Package Installation, and SSIS Package Designer.
  • Experience in importing/exporting data between different sources like Oracle/Access/Excel etc. using SSIS/DTS utility.
  • Experience in ETL processes involving migrations and in sync processes between two databases.
  • Experience in Microsoft Visula C# in script component of SSIS.
  • Transformed data from one server to other servers using tools like Bulk Copy Program (BCP), and SQL Server Integration Services (SSIS) (2005/2008).
  • Experience in creating configuration files to deploy the SSIS packages across all environments.
  • Expert in generating writing parameterized queries, drill through reports and formatted SQL server Reports in SSRS 2005/ 2008/2008 R2 using data from ETL Loads, SSAS Cubes and various heterogeneous data sources.
  • Defining data warehouse (star and snow flake schema), fact table, cubes, dimensions, measures using SQL Server Analysis Services.
  • Worked with report manager for deploying the reports across all the environments.
  • Expertise in using global variables, expressions and functions for the reports with immense experience in handling sub reports in SSRS.
  • Experienced in installing and configuring Reporting services and assigning permissions to different levels of users in SSRS.
  • Strong Experience in creating Ad Hoc, parameterized reports, Linked reports, Snapshots, Drilldown and Drill through reports using SQL SSRS 2005/2008.
  • Ability to handle Multiple tasks, Initiative and Adaptable. Self-motivated, organized team player with strong problem solving and analytical skills and total commitment to the organization goals.
  • Good ability to quickly grasp and master new concepts and technologies

TECHNICAL SKILLS:

Operating Systems: Win 2000/NT/2003/2008 server.

RDBMS: MS SQL SERVER 2008/2005/2000 , MS Access, Oracle8i/9i.

Database Tools: SQL Query Analyzer, SQL Enterprise Manager, Management. Studio, SQL Server 2005, Query Editor, Reporting ServerMs-Access.

ETL Tools: Data Transformation Services (DTS), MS SQL Server Integration Services (SSIS).

Reporting Tools: Crystal Reports XI/X, MS SQL Server Reporting Services (SSRS).

Data Modeling: ER Win 4.0, MS Visio 5.0.

BI Tools: MS SQL Bussiness Intelligence, Business Objects.

Programming Languages: Unix,C#, Asp.Net,XHTML and XML.

PROFESSIONAL EXPERIENCE:

Confidential, Augusta, Maine

SQL Server/SSIS/SSRS Developer

Responsibilities:

  • Involved in designing, developing and deploying reports in MS SQL Server environment using SSRS-2008 and SSIS in Business Intelligence Development Studio (BIDS).
  • Used SSRS to develop different kinds of reports like canned, ad-hoc reports for the State and Local Agency users.
  • Prepared the complete data mapping and Report Definitions for the project which involved around 33 reports.
  • Involved in creating multiple parameterized stored procedures which were used by the reports to get the data.
  • Worked on formatting SSRS reports using the Global variables and expressions.
  • Created parameterized reports, Drill down and Drill through reports using SSRS.
  • Deployedanduploaded the SSRS reportstoSharePoint Serverfor the end users and involved in enhancements and modifications.
  • Used ETL (SSIS) to develop jobs for extracting, cleaning, transforming and loading data into data warehouse.
  • Involved in the Migration of Databases from SQL Server 2005 to SQL Server 2008.
  • Prepared the complete data mapping for all the migrated jobs using SSIS.
  • Created databases and schema objects including tables, indexes and applied constraints, connected various applications to the database and written functions, stored procedures and triggers.
  • Designed SSIS Packages to transfer data from flat files to SQL Server using Business Intelligence Development Studio.
  • Extensively used SSIS transformations such as Lookup, Derived column, Data conversion, Aggregate, Conditional split, SQL task, Script task and Send Mail task etc.
  • Used Execution Plan, SQL Profiler and Database Engine Tuning Advisor to optimize queries and enhance the performance of databases.

Environment: Windows 2007 enterprise,SQL Server 2008/2005,SQL Integration Services(SSIS), Business IntelligenceDevelopment Studio, Visual Studio 2008/2005, OLE DB.

Confidential, Grand Rapids, Michigan

SQL Server/SSIS Developer

Responsibilities:

  • Implementation of MS SQL Server 2008/2005 Management studio to create Complex Stored Procedures, User Defined Functions (UDFs) Views using T-SQL to evaluate result for the reports.
  • Responsible for installation and Configuration of SQL Server 2005 and 2008 database and configuration of Report manager.
  • Responsible for performing T-SQL tuning, multi tasking and optimizing queries for reports which take longer time in execution with SQL Server 2008/2005.
  • Created Complex ETL Packages using SSIS to extract data from staging tables to partitioned tables with incremental load.
  • Created SSIS Reusable Packages to extract data from Multi formatted Flat files, Excel, XML files into UL Database and DB2 Billing Systems.
  • Developed, deployed, and monitored SSIS Packages.
  • Created SSIS Packages using SSIS Designer for export heterogeneous data from OLE DB Source (Oracle), Excel Spreadsheet to SQL Server 2005/2008.
  • Performed operations like Data reconciliation, validation and error handling after Extracting data into SQL Server.
  • Worked on SSIS Package, DTS Import/Export for transferring data from Database (Oracle and Text format data) to SQL Server.
  • Created SSRS reports using Report Parameters, Drop-Down Parameters, Multi-Valued Parameters Debugging Parameter Issues Matrix Reports and Charts.
  • Generated and formatted Reports using Global Variables, Expressions and Functions for the reports.
  • Created reports with Analysis Services Cube as the data source using SSRS.

Environment: MS SQL Server 2005/2008, SQL Reporting Services (SSRS), SQL Integration Services (SSIS), MS SQL Server 2008, Ms Access2007, Office2007, Windows Server 2003.

Confidential, Tampa, Florida

SQL Server (SSIS/SSRS) Developer

Responsibilities:

  • Involved in installing and maintaining MS SQL Server 2000/2005.
  • Created Data Model or the Marketing Information System Team using Erwin.
  • Created SSIS package for loading the data coming from various interfaces like OMS, Orders, Adjustments and Objectives and also used multiple transformation in SSIS to collect data from various sources.
  • Worked on SSIS Package, DTS Import/Export for transferring data from Database (Oracle and Text format data) to SQL Server.
  • Worked on the data warehouse design and analyzed various approaches for maintaining different dimensions and facts in the process of building a data warehousing application.
  • Scheduled and maintained daily and monthly loads of OMS, Orders, Objectives and Adjustments data through jobs, tasks, and alerts.
  • Created stored procedures to build Fact tables in data mart for Multi-Dimensional analysis using (SSAS) and produced ad-hoc, standard and create super user reports using (SSRS).
  • Using SSAS created OLAP cubes for data mining and created reports from OLAP cubes using SSRS.
  • 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.
  • Created SSIS packages for File Transfer from one location to the other using FTP task.
  • Created Database Objects - Tables, Indexes, Views,Stored Procedures and User defined functions according to the requirements of the project.
  • Using reporting services (SSRS) generated various reports.

Environment: Windows XP, Windows 2003, Terminal Server, T-SQL, BCP, SQL Jobs, SQL Server Management studio, SQL Server 2005, SSIS, SSRS, SSAS, ERWIN.

Confidential, Omaha, NE

SQL Server 2005 Developer

Responsibilities:

  • Create new tables, views, indexes and user defined functions.
  • Actively designed the database to fasten certain daily jobs and some stored procedure.
  • Created SSRS reports for Franchise Health Reports.
  • Created User list first title played reports.
  • Created reports by retrieving the data from cube using MDX reports.
  • Designed reports, Graphs and deployed reports to web applications using SSRS.
  • Used Caching (Cache Technology) for fast retrieval of data to generate reports against data warehouse.
  • Designed MDX queries to retrieve data from SSAS cubes.
  • Created SSIS packages for File Transfer from one location to the other using FTP task.
  • Designed Cube partitioning and incremental synchronization for SSAS cubes.
  • Involved in performance tuning of TSQL queries and Stored Procedures.
  • Optimized query performance by creating indexes.
  • Involved in Administration of the SQL Server by creating users & login ids with appropriate roles & grant privileges to users and roles.
  • Write T-SQL statements for retrieval of data and Involved in performance tuning of TSQL Queries and Stored Procedures.
  • Use the SQL Analyzer, and Profiler for studying the SQL statements and procedures
  • Developed complex stored procedures to create various reports.
  • Worked on SSIS Package, DTS Import/Export for transferring data from Database (Oracle and Text format data) to SQL Server.
  • Designed Star Schema and Snow flaked schemas in the process of data modeling.
  • Access SQL Server using front end applications like VB.

Environment: Windows 2003 Advanced Server, MS SQL Server 2005, MS Outlook, TSQL, Erwin,, SSIS, SSRS, SSAS,VB

Confidential

SQL Server Developer/DBA

Responsibilities:

  • Backend database development in MS SQL Server, writing complex queries, stored procedures, views, triggers, cursors, UDFs.
  • Responsible for installation of SQL Server, database design, and create schema objects like tables, views and indexes.
  • Performed Database code Migration from SQL Server in SDLC environment using Bridging Scripts, Column Mapping Tool and Source Control Explorer in Visual Source Safe (VSS) and finally passing all triggers, views under Unit Testing for validating data insert, update and delete.
  • Experience in SQL joins, sub queries, tracing and performance tuning for better running of queries.
  • Extensive use of Triggers to implement business logic and for auditing changes to critical tables in the database.
  • Experience in development of extracting, transforming and loading (ETL), maintain and support the enterprise data warehouse system and corresponding marts
  • Experience with SSIS performance tuning using counters, error handling, event handling, re-running of failed SSIS packages using checkpoints and scripting with Active-X and VB.NET in SSIS.
  • Experience in SSIS script task, look up transformations and data flow tasks using T- SQL and Visual Basic (VB) scripts. .
  • Experience in generating reports using linked reports, sub reports and filters in SQL server reporting services.
  • Linked business processes to organizational objectives, performing critical path analysis, analyzing ER diagrams.

Environment: MS SQL Server 2000, T-SQL, DTS, Windows XP, 2000, MS Visio 2000, MS Projects 2000.

Confidential

SQL Server Developer/DBA

Responsibilities:

  • As a developer I was responsible for the systems study, analysis, understanding systems design and database design.
  • Designed and created SQL Databases, tables, indexes, and views based on user requirements.
  • Worked with the application developers and provide necessary SQL Scripts using T-SQL.
  • Created User Defined Functions, Stored Procedures, and Triggers.
  • Experience in creating small Packages.
  • Created Views to facilitate easy user interface implementation, and triggers on them facilitate consistent data entry into the database.

Environment: HTML,VBScript, SQL Server 2000, SQL Query Analyzer, DTS, Windows NT, MS Access,MS Excel, Erwin.

We'd love your feedback!