SEARCH

BI Developer Resume Example

Resume Score: 90%

Love this resume?Build Your Own Now
BI DEVELOPER
Career Overview

Over fifteen (15) years of experience as a SQL Server Developer and Database Analyst.

Qualifications

SQL Server 2008\2012, Stored Procedures, Triggers, UDFs, T-SQL, SSIS, ETL tools, OLTP\OLAP, SSAS, data marts, Database design concepts, VS 2010 data tools


Languages and related technologies: C#, ASP.NET, Entity Framework 6, ADO.NET, LINQ, Visual Studio 2010\2012\2013, XML, HTML, JavaScript, .NET 4.0, T-SQL, MDX


Reporting software: SQL Server Reporting Services (SSRS), LogiAnalytics, MS Access, Crystal Reports XI, Business Objects XI R2


Data visualization tools: Power BI

Technical Skills
SkillsExperienceTotal YearsLast Used
SQL Server Senior Level152015
C#Proficient52015
SSISGood72015
T-SQLSenior Level152015
.NETProficient62015
SSRSSenior Level92015
SSASProficient22013
ETLExpert Level82015
Data ModelingProficient42015
Accomplishments

Award and Bonus Received 7/2014: For the successful rollout of the BCD Travel Decision Source platform.

Work Experience
August 2013
to
Current
BCD TravelAtlanta, GABI Developer
  • Member of BI development team for new BCD Travel enterprise product (Decision Source Platform).
  • Utilized SSIS for internal data extractions, ETL processes and analysis.
  • Identified and analyzed data discrepancies and data quality issues.
  • Work with existing data warehouse, stored procedures, functions, CTEs, support data warehouse and provided mentoring to other team members.
  • Created advanced business logic reports, dashboards, indicators and critical analytics for both the new platform, and internal clients from a data warehouse using SSRS technology.
  • Accomplishments and duties: Created complex analytic queries and dashboards using SSRS, for new BCD Travel product Utilized complex T-SQL, Stored Procedures, and Views, and functions, extracting from the data warehouse for reports and data extractions.
  • Performance tune queries and ETL processes, utilize execution plans.
  • Created SSIS packages and code batches to run ETL process for internal reports, import and analyze data.
  • Monitor and optimize OLAP development databases Technologies used: SQL Server 2012/2008, C#, VS2010/2012, SQL Server SSRS,SSIS, .NET
April 2013
to
August 2013
3M Health Information Services HISAtlanta, GASQL Engineer
  • Application and database development for new 3M health information product using .NET technologies and SQL Server 2012.
  • Support of existing Medicare patient health information (PHI) data warehouse.
  • Accomplishments and duties: Created user utility to crosswalk application mapping hospital EMR values with 360Analytics application.
  • Analyze and update Patient Safety Indicators (PSI's) analytics database using SQL Server 2012.
  • Monitor and debug data warehouse ETL processes, SSRS reports, and reporting deployment to SharePoint.
  • Technologies used: SQL Server 2012/2008, C#, VS2010/2008, SSRS, SSIS, SSAS, .NET 4.0, LogiAnalytic reporting tool.
June 2012
to
April 2013
Wellstar Health SystemAtlanta, GASenior BI Developer
  • Provide Business Intelligence and Data Analyst support to implement an enterprise data warehouse of 120+ terabytes, using Microsoft BI Stack Technologies (SSRS, SSIS, SSAS).
  • Support existing applications in: Business Objects XI R2, Crystal Reports XI, Oracle 10g.
  • Accomplishments and duties: Create ETL SSIS Packages to extract various data sources into data warehouse, working with slowly changing dimensions, data conformity, and varied data types.
  • Working with large database environments (100+ GB - 1+ TB).
  • Installed, configured and Administer SQL Server 2008 R2 SSRS reporting site in native mode.
  • Analyze data, create SSRS reports, aggregating data, dashboards.
  • Assisted in data modeling, and ETL architecting using ER Studio and Visio.
  • Provide DBA support to team databases, performance tuning (indexes, partitioning), backups, DMVs Work with PHI data.
  • Support existing Business Objects reports and universes Technologies used: SQL Server 2012/2008, C#, VS2010/2008, SSRS, SSIS/ETL, ER Studio, Business Objects XI, Crystal Reports, Tableau 8.3, XI, Oracle 10g, Mckesson Star, Allscripts EPSI module, and associated systems, knowledge of hospital revenue cycle.
April 2009
to
June 2012
Tanner Medical Center HospitalCarrollton, GADatabase Analyst
  • Provide database, report development, and application support for regional hospital using SSRS, SSAS and .NET technologies.
  • Develop ASP.NET applications and data models for business teams.
  • Support Clinical Informatics department (EMR data).
  • Accomplishments and duties: Installed, configured, and administered our enterprise SQL Server Reporting Services in native mode and integrated mode (Sharepoint 2010).
  • Created and automated SSIS packages for ETL functions for hospital patient data from (then) 600 gig data repository in SQL Server 2008.
  • Provided data modeling for SSRS Report Builder for users to create own reports.
  • Created data marts and SSAS Cubes for various business and clinical areas of the hospital.
  • On database administration team; supporting databases, backups, setting permissions, providing support for staff database needs, upgrades of databases.
  • Developed in house ASP.NET applications and scripts using C# language.
  • Analysis and extraction of large sets of data for various departments, displayed in reports, SharePoint, Excel.
  • Created PHI data extraction scripts for Press Ganey data.
  • Technologies used: SQL Server 2005\2008,T- SQL, Visual Studio 2008, C#, VB.NET, ASP.NET, SSRS, SSAS,SSIS, ADO.NET, LINQ, Visual SourceSafe 2005, Meditech 6.4 EMR.
September 2007
to
February 2009
Georgia Pacific LLCAtlanta, GASenior Programmer/Analyst
  • Provided technical and application support to the legal team as a Microsoft application\database developer.
  • Performed database programming and administrative functions.
  • Accomplishments and duties: Technical lead for upgrading Georgia-Pacific's trademark database, consolidated trademark data.
  • Developed a debt records tracking database and application using C#.NET.
  • Created and normalized database, application, and reports.
  • Installed and configured certificate contract risk proprietary software, maintained database.
  • Technologies used: SQL Server 2000\2005,T- SQL, Visual Studio 2008, C#, VB.NET, ASP.NET, SSRS, ADO.NET, IIS, HTML, JavaScript, AJAX, Visual SourceSafe 2005, Worksite 8.0, Imanage 8.0, LawManager.
June 2000
to
August 2007
Atlanta Regional Commission ARCAtlanta, GAProgrammer/Analyst
  • Created reports and performed ETL functions for Population and Housing data; supported Transportation department and Environmental planning databases used for transportation modeling.
  • Maintained and developed agency wide internal and external ASP.NET custom applications and their databases.
  • Accomplishments and duties: Designed and built VB.NET\ASP.NET 2.0 with SQL Server back end.
  • Performed DBA, backup and restore of SQL Server 2000 databases, optimizing and monitoring databases in a clustered environment.
  • Support internal applications.
  • Provided support to GIS department with TIGER data for geocoding, installed and configured ESRI products.
  • Installed and configured ArcIMS GIS website Assisted in geocoding population and housing data.
  • Technologies used: SQL Server 2000\2005, T-SQL, VB.NET, C#, ADO.NET, ASP.NET, Crystal Reports, VS 2005, SSRS, IIS, ESRI GIS, ArcIMS, XML\XSLT, HTML, SharePoint 2003, Visual SourceSafe.
Education and Training
Rutgers UniversityNew Brunswick, NJB.A: Political Science, focus on Statistics and Analysis

Political Science, focus on Statistics and Analysis

Work History
August 2013
to
Current
BCD TravelAtlanta, GABI Developer
Skills

.NET 4.0, VB.NET, C#.NET, .NET, ASP.NET 2.0, ASP.NET, administrative, ADO, Analyst, agency, automate, backup, BI, Business Intelligence, Business Objects, Crystal Reports, clients, data analysis, data modeling, data warehouse, database administration, databases, Database, database design, database development, database programming, dimensions, ESRI, ETL, GIS, HTML, IIS, JavaScript, Languages, legal, logic, Meditech 6.4, mentoring, MS Access, C#, Excel, modeling, enterprise, OLAP, Oracle, DBA, developer, Press, processes, quality, reporting, Safety, scripting, scripts, Visual SourceSafe, SQL Server, SQL, SQL Server 2000, tables, T-SQL, T- SQL, Transportation, upgrades, upgrading, Visio, Visual Studio, website, XML, XSLT

Build Your Own Now

DISCLAIMER

Resumes, and other information uploaded or provided by the user, are considered User Content governed by our Terms & Conditions. As such, it is not owned by us, and it is the user who retains ownership over such content.

Resume Overview

Companies Worked For:

  • BCD Travel
  • 3M Health Information Services HIS
  • Wellstar Health System
  • Tanner Medical Center Hospital
  • Georgia Pacific LLC
  • Atlanta Regional Commission ARC

School Attended

  • Rutgers University

Job Titles Held:

  • BI Developer
  • SQL Engineer
  • Senior BI Developer
  • Database Analyst
  • Senior Programmer/Analyst
  • Programmer/Analyst

Degrees

  • B.A : Political Science, focus on Statistics and Analysis

Similar Resumes

View All
BI-Developer-resume-sample

BI Developer

Minneapolis, Minnesota