BI Developer Resume Example
Over fifteen (15) years of experience as a SQL Server Developer and Database Analyst.
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 |
| Skills | Experience | Total Years | Last Used | |||
|---|---|---|---|---|---|---|
| SQL Server | Senior Level | 15 | 2015 | |||
| C# | Proficient | 5 | 2015 | |||
| SSIS | Good | 7 | 2015 | |||
| T-SQL | Senior Level | 15 | 2015 | |||
| .NET | Proficient | 6 | 2015 | |||
| SSRS | Senior Level | 9 | 2015 | |||
| SSAS | Proficient | 2 | 2013 | |||
| ETL | Expert Level | 8 | 2015 | |||
| Data Modeling | Proficient | 4 | 2015 |
Award and Bonus Received 7/2014: For the successful rollout of the BCD Travel Decision Source platform.
- 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
- 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.
- 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.
- 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.
- 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.
- 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.
Political Science, focus on Statistics and Analysis
.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
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.
How this resume score could be improved?
Many factors go into creating a strong resume. Here are a few tweaks that could improve the score of this resume:
- Completeness
- Formatting
- Word choice
- Length
- Strong summary
- Clear contact info
- Typos
Resume Overview
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
