Business Intelligence Developer Resume Troy, Michigan - Hire IT People

SUMMARY

Solid experience with business intelligence solutions using SQL Server, SSRS, T - SQL and SSIS
Experience in designing, developing, enhancing, managing, and maintaining complex SSIS packages
Experience in relational database and data warehouse concepts
Experience in designing and implementing transactions and error handling
Excellent communication skills, both written and verbal

TECHNICAL EXPERIENCE

BI TOOLS: SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), SQL Server Analysis Services (SSAS), SQL job Agent

Applications: MS Office (Word, Excel, PowerPoint, InfoPath, OneNote, Publisher, Outlook, Access) MS Project 2000

Server Operating Systems: Windows NT/XP/7/10, Windows Server 2003/2008/2012

Databases: SQL Server 2005/2008/2012/2014/2016

WORK EXPERIENCE

Business Intelligence Developer

Confidential, Troy, Michigan

Create and deploy ETL (SSIS) packages for data load from multiple source systems
Work extensively with SQL Server Reporting Services (SSRS) to develop and deploy reports
Responsible for database architecture, design and development
Create and maintain database objects such as stored procedures, views and functions for database applications
Perform source to target mapping
Review, debug, modify and tune existing SSIS packages
Work with testing and production team.
Prepare technical documentation

MS SQL Server ETL/SSIS Developer

Confidential, Pittsburg, Pennsylvania

Developed ETL packages to extract data from multiple sources such as Excel, CSV, Flat files and OLTP database sources to databases using SSIS
Worked on an ETL project implementing Slowly Changing using SQL Server Integration Services
Deployed SSIS packages to test and production
Wrote SQL Queries, Stored procedures, Functions, Triggers, Indexes and Views
Scheduled and managed jobs and notifications using SQL Server Agent
Creating SSIS packages that involves migration from legacy systems such as MS Access to SQL Server database
Performed backup and restoration of databases.
Responsible for general database administration such as troubleshooting databases, servers and application issues
Developed technical documents such as source to target mapping documents

Database Developer

Confidential, Auburn Hill, Michigan

Responsible for managing multiple MS SQL RDBMS and Data Warehouse
Participated in the development of database and data warehouse projects
Developed reports using SQL Server Reporting Services (SSRS)
Wrote T-SQL programming to implement Stored Procedures and Expressions for different tasks of reports such dataset, sub Reports, Charts, Matrix, Linked reports
Scheduled reports for daily, weekly, monthly reports for various business needs using Subscription in SQL Server Reporting services (SSRS) Report Manager
Created SSIS Packages for data migration
Identified and troubleshot database issues