Senior SQL and SSIS BI Developer Resume

SUMMARY

Senior BI Developer with 18 years of SQL / ETL and DBA experience who is well versed in leading support tools.
Adept in creating precise, uncomplicated solutions ahead of schedule. A great team player in a wide array of environments

TECHNICAL SKILLS

MS SQL Server development and administration, Data Architecture, ETL (SSIS), Reporting (SSRS, Crystal), Data Warehouse design and maintenance, C#, VB.NET, ASP.NET, HTML, Agile/Scrum development environments
Mid - Level DBA experience. Installing, patching, maintaining servers and all data objects. Query tuning.

PROFESSIONAL EXPERIENCE

Confidential

Senior SQL and SSIS BI Developer

Responsibilities:

All phases of data warehouse lifecycle - gathered requirements, Identified source data reporting gaps
Lead ETL(SSIS) developer, helping others with package design and slowly changing dimensions best practices
Created/maintained databases, tables, stored procedures, run jobs, as well as indexes and performance tuning
Created automated, hourly reconciliation job to audit newly refreshed dimensions to source data on key metrics
Delivered first ever data warehouse to Eagle, allowing report writers and PowerBI users to use effortlessly

Confidential

Senior SQL and SSIS Developer

Responsibilities:

Designed, built and tuned numerous SSIS ETL jobs resulting in 99% up time for key divisions.
Management of all MS SSIS package version control and production migration
Developed and maintained MS SQL scripts, stored procedures, triggers, tables and indexes .
Extensive C # and VB scripting usage in MS SQL 2008 and 2012 SSIS packages
Responsible for data analysis ensuring data transformation and cleansing of all data anomalies
Received Company's ACE for outstanding performance in database and ETL project design

Confidential

Senior SQL Developer / DBA

Responsibilities:

Designed and maintained MS SQL databases and SSIS ETL jobs supporting OLTP and Data Mart
Created T-SQL ETL integration and data cleansing functions before loading into data mart.
Built SSRS Reports and served on SharePoint server, allowing improved decision-making
Database Administration included performance query and index tuning, data backup and security
Helped maintain the main student online system in VB.NET, ASP.NET and MS SQL Databases

Confidential

Senior Developer / Engineer

Responsibilities:

Created extensive ETL (SSIS) packages and MS SQL complex queries to load the data mart
Designed tables, procedures, views and triggers in MS SQL 2000,2005 and 2008
Managed all ETL integration and data cleansing and SQL database versioning and changes to production
Development of several systems using VB.NET, C #, ASP, and my T-SQL skills.
Lead programmer of the department’s Web Services used with business partners

Confidential

Developer / SQL Server DBA

Responsibilities:

Designed and maintained a Data Warehouse on MS SQL Server 2005, supporting the website.
Designed DTS / ETL(SSIS) jobs using SQL2005 and SYBASE databases
Built tables, indexes, stored procedures, functions, triggers and views in MS SQL
Designed reports with MS SQL Reporting Services (SSRS) and Crystal Reports.
Built a data-driven intranet system utilizing VB.NET, ASP.NET, SQL 2005 and SSRS
Database Administrator for MS SQL2000, MS SQL2005 and Sybase databases
Performed backups, recovery, utilization, scheduling, security and performance monitoring.