SQL SERVER SSIS/SSRS ETL Developer Resume

SUMMARY:

Accumulating over 7 years of experience in IT as a Microsoft Business Intelligence Developer, has allowed for a working knowledge and thorough understanding of Database Design Development.
My proficiencies include the use of SQL Server (T - SQL), Integration Services (SSIS), and Reporting Services (SSRS).
I have excellent T-SQL development skills, including but not limited to: writing complex queries involving multiple tables; creating, designing, reviewing and maintaining stored procedures, user defined functions, triggers, views, and other SQL objects; handling business logic and functionality of various modules.
Using various SDLC life cycles, I partake in the implementation of ETL as well as the support of OLAP/OLTP/Data warehouse systems.
I excel in defining queries for generating Drill down reports, Matrix reports, Chart reports and handling parameterized reports as well as creating on demand and scheduled reports in SSRS.

TECHNICAL SKILLS:

MS SQL Server
SQL Server integration Services (SSIS)
SSRS
SSAS
Data Transformation Services
MS SQL Server Management Studio
SQL Server Business Intelligence Development Studio (BIDS)
C
C++
SQL
T-SQL
C#
.NET
ASP.NET
ADO.NET
MS Visual Studio
MS Access
HTML
DHTML
Unix
Erwin
Cogno8
VB.net

PROFESSIONAL EXPERIENCE:

SQL SERVER SSIS/SSRS ETL Developer

Confidential

RESPONSIBILITIES:

Database development with Microsoft SQL Server in OLTP/OLAP environments using integration services (SSIS) for ETL (Extraction, Transformation and Loading)
Database administrative skills including, backups, recovery, database maintenance
Experienced in Project Management and Software Development Life Cycle (SDLC) including analysis of business function, testing and documentation, and planning for redesign or transition to another platform
Generated reports in various formats like Table format and Matrix format using Reporting services (SSRS) to display in a customized format as per business requirements
Managed BI environment, which included Business model, Data Model, Data sources, ETL tools, Enterprise Data Warehouse, Data marts, OLAP analysis and Reporting tools
Configured SSIS packages using package logging, breakpoints, checkpoints and event handling to fix errors
Transformed unstructured data from various data sources using SSIS Transformations like Conditional Split, Lookup, Merge Join and Sort and Derived Column for cleaning bad data, validating data
Monitored and tuned databases through use of scheduled job creation and trace scripting.
Performed complete server installations, service pack updates, and hot fixes.
Designed complex DTS/ETL packages for loading and scrubbing vendor data.
Additional work with Replication, Analysis Services and Reporting Services.
Analyzed and converted research fundraising contact data from various sources into normalized client-server Access and SQL-Server databases, which included the ability to view and update information in a web based format.
Created Access front end and SQL-Server back end DBMS for contact and event management

SQL SSIS ETL Developer

Confidential

RESPONSIBILITIES

Involved in monitoring and troubleshooting complex packages by using data viewers, grids, debugging and maintenance of ETL packages and its optimization using SQL server best practices
Transformed database objects from one server to others server using SSIS
Used multiple transformations in SSIS to meet the business requirements by collecting data from various sources
Used efficient task objects/connections/work flows in packages based on data volumes and data sources
Performed efficient tuning of SQL source queries for data loading/ Usage of stored procedures for performance
Designed complex ETL packages for loading and scrubbing vendor data
Troubleshoot processes, issues and errors in SSIS Packages to improve their performance
Development for Reporting team involving coding, security, code reviews, metadata implementation, and replication troubleshooting
Performed capacity planning and growth prediction for government and client audit data
Query tuning based on query execution plans, statistics, and profiling
Created code based solution for application error involving composite key manipulation
Coordinated and set up new development environment using scrub scripting of production data

We provide IT Staff Augmentation Services!

We'd love your feedback!

Resume Categories

Client Services

Job Seekers

Visa Sponsorship