SUMMARY

Over 10 years of SQL Developer experience using SQL, SSRS and SSIS tools with a strong background in report development and visualization. Database development includes using advanced t-sql, stored procedures, functions, common table expressions and ETL development. Over 15 years of progressive .NET consulting experience in design and development of multi-tier Windows/Web applications.

EXPERIENCE

Confidential

• SQL Developer / SSRS Report Developer Consultant, project completed
• Member of the ATOS Business Intelligence/Analytics team 28 individuals .
• Developed several ETL SSIS packages to load data into data marts.
• Create SSRS reports from several BI Analysis Cubes in data warehouse
• Automated several large reports taking hours each day to create manually from other reports.
• Converted several Crystal Reports to SQL Server Reporting Services 2008 R2 report format.
• Create data mart combining three different help tickets systems to create open ticket and change ticket reports across all systems.
• Utilizing T-SQL skills, created stored procedures, temp tables, common table expressions to generate complicated reports and charts.
• Created a new BIDS solution to contain all SSRS projects and implemented Team Foundation for source control.
• Technologies Used: SQL Server 2008R2, Reporting Services, Integration Services, Analysis Services, Business Intelligence Development Studio - BIDS, Team Foundation

Confidential

SQL Developer / SSRS Reports Developer Consultant project completed

• Worked with Business Intelligence team members to design, build, and develop custom reports for NextGen EHR and NextGen EPM medical software.
• Created complex SQL queries to solve reporting issues.
• Created Medicaid Cost Settlement reports for qualifying encounters.
• Developed trending reports for Meaningful Use.
• Worked with BI team to help create reporting standards, to guide the company with their Business Intelligence road map.
• Developed several trending reports for Marvel Help Desk system for management.
• Utilized skills for all areas of Report Development, from design, test and deployment.
• Implemented Microsoft Team Foundation Services as primary source control.
• Technologies Used: SQL Server 2012, SQL Server Data Tools, Team Foundation Services

Confidential

.NET Development Lead Consultant project completed

• Developed and designed requirements for C Web application utilizing Entity Framework.
• Oversaw two developers on the team for coding process.
• Designed screens and developed code behind for data access.
• System imported data from Excel for creating loads and freight bills in SQL Server.
• Integrated Comdata Web services into paying drivers.
• Integrated PC Miler web services into getting miles, state miles and routes.
• Final pay drivers and create invoices.
• Technologies used: SQL 2005, BIDS 2005, Visual Studio 2010, C ASP.net, Telerik Reporting and SourceSafe.
• March 2012 - December 2012

SQL/SSRS Developer Consultant project completed

• Created HIT Metrics Data Warehouse cube.
• Stage data from ChangePoint time management system, import weekly into data warehouse via SSIS.
• Created numerous management reports in SSRS for HIT managers.
• Created SSRS functional reports for in-house TBS Thermocoupler tracking Asp.net C web app.
• Tested data for data warehouse exported from Oracle and imported into Microsoft SQL.
• Developed requirements definitions for Supply Chain Management for daily snapshot of bookings and shipments.
• Created Mold Sheet ASP.net Visual basic Web App for Engineering Department - created requirements documentation, function design, code web app, test and create user documentation.
• Technologies used: SQL 2005, BIDS 2005, Visual Studio 2008, Team Foundation.

Confidential

SQL SSRS/Developer Consultant project completed

• Created SSRS management reports for in-house Tempo employee time tracking software.
• Created product, release, employee, team, functional area and executive summary reports.
• Integrated into existing Tempo web app developed in C .
• Created administrator maintenance screens for completing the Tempo project.
• Technologies used: SQL 2005, BIDS 2005, Visual Studio 2008, SVN code control.

Confidential

.NET Developer/SQL SSRS Developer Consultant project completed

• Designed and developed ASP.net web application for dealer soil sampling management.
• Dealers placed work orders on-line for their growers, farms and fields.
• Lab management for receiving samples and uploading results to SQL server tables.
• Dealers then receive email for results for each field.
• Created several SSRS reports for management.
• Technologies used: SQL 2005, SSRS, SSIS, Visual Studio 2010, Visual Basic .Net, AJAX.

Confidential

.NET Developer Consultant project completed

• Designed and developed ASP.net website for booking Mobile Video Game Parties.
• Created booking calendar, shopping cart integrating multiple party fee structures, travel fees and sales tax.
• Technologies used: SQL 2005, Visual Studio 2008, Visual Basic .Net.

Confidential

SQL SSRS Developer Consultant project completed

• Designed and developed SQL 2005 Reporting Services reports for ActionWay Software program for corrective actions.
• Tested and validated data for ActionWay software compared to INDUS mainframe application.
• Documented all aspects of project.
• Worked with data warehouse to validate reports.
• Worked in team environment on converting current systems to ObservationWay and Dashway.
• Technologies used: SQL 2005, Visual Studio 2005, Visual Studio 2008, C and SQL Reporting Services.

Confidential

Consultant

FoxPro / Visual Basic / Database / Crystal Reports Developer