SUMMARY:

Highly motivated Developer who is able to learn applications and systems quickly, work through complex issues and thrive in various environments.

TECHNICAL SKILLS:

Languages: , MSSQL, MySQL, C#, MVC, SQL Reporting Services, SSIS, MS Access, Domo, VBA, XML, Web Services, Javascript, Ajax, PDF (Creation)

Technologies: SQL Server (2012, 2014, 2016), Visual Studio, TFS, IIS, SharePoint, Confidential PaceArt (GCII, GC3, & Optima), Confidential CareLink, Boston Scientific Latitude, St. Jude Medical Merlin, Microsoft Office (Outlook, Word, Excel, Project, PowerPoint, Visio), Office 365, Adobe Acrobat, Open Office

Operating Systems: Windows Server (2005, 2008, 2012), Windows (7, 8, 10)

PROFESSIONAL EXPERIENCE:

Confidential

Report Developer

• Report development - Modified about around 150 SSRS reports as well as the stored procedures for them to import data from new data sources to prepare for an upgrade from Infor version 9 to version 10. Resolved other issues with reports and their stored procedures, including reports pulling incorrect data and removing hard-coded values from stored procedures.
• Documentation - Created documentation on changes made to stored procedures.

BI Developer

Confidential

• BI Development - Modified Access databases which used Excel files as a source, then separated, aggregated, and summarized the data with MySQL, and created XML files as an output.
• Report Development - Used Domo business intelligence application with MySQL on the back end to filter, transform, validate, and display data.
• Documentation - Created documentation on all projects I worked on as well as for existing processes.

Confidential

ETL Developer

• SSIS Development - Discovered why some scheduled jobs were failing and how to get them working again and also authored some new SSIS packages.
• ETL Development - Created functions, stored procedures, and views in SSMS.
• Report Development - Modified and rewrote some SSRS reports and authored new ones.
• Team training - Trained team members on how to use SSMS, write SQL queries, and how to pivot and aggregate data in SSRS.
• Database Administration - Set user permissions, backed up & restored databases, and scheduled SSIS packages to run as scheduled jobs. Implemented email notifications to alert team members when the VPN connection to True North was down.
• Documentation - Created documentation on all projects I worked on.

Business Intelligence Developer

Confidential

• SSIS Development - Used SSIS to automate processes that were previously being handled manually, including incremental loads and configuring connection managers.
• Report Development - Authored and edited reports in SSRS, using stored procedures and cascading parameters.
• ETL Process – Extracted, transformed, and loaded data between various data sources, such as Excel, CSV, and other flat files.
• Testing – Tested new processes to validate data and to verified that scheduled jobs ran reliably.

Confidential

SQL Developer & Report Developer

• Report Development – Used SQL Server Management Studio and a proprietary report building software to author reports using XML and PDF output.
• Requirements Gathering – Collected requirements from internal teams based on outside vendor requests that demanded updates to existing reports and new reports.
• SQL Development – Created reusable functionality for reports by writing standardized stored procedures that included temporary SQL table use.
• Validation – Verified that all requirements were met and that the reports passed quality control. Wrote documentation with information about how to alter parameters and run the reports.
• Report Development – Met with multiple business units to gather requirements or change requests for reports. Took requirements or changes and implemented them within test SSRS environments. Acquired validation from business units for report correctness and moved them to production once proper acceptance was received. Once reports were placed in production, provided business explanation of data and metrics and trained users in interpreting the results properly. Diagnosed issues dealing with reports due to data, changes in data sources or underlying systems. Optimized reports using SQL and SSRS optimizations. Integrated security into reports to ensure users could not see data they were not authorized to see.
• Health East Systems, Production Support – Using complex analysis, led data clean up and scrubbing of account and report tables by working with the external vendor and an internal team. In addition, also built an interface for properly inserting accounts and data into the tables.
• ETL Development – Maintained and documented the majority of the ETL processes within BRAC to ensure fast troubleshooting. Upgraded SSIS packages when business needs required changes, including gathering business information process requirements. Modified and corrected data feeds. Provided production support for active ETL processes and diagnosed errors with files and transfers when they occurred. Created new packages when the business dictated need for it.
• Database Administration – Setup user security and permissions on SQL objects throughout a SQL server farm. Managed the SQL jobs, tables, and stored procedures including stored procedures that drove SSRS reports. Wrote example and framework scripts and SQL for other team members to leverage for their tasks. Handled the company’s backups, restores and database maintenance including SQL migration from MSSQL 2008 to MSSQL 2012 (on Server 2012). Configured system software on SQL servers including secure FTP, PDF creating tools and others.

Confidential

Product Support Analyst

• Scanned, modified, and supported PaceArt databases for hospitals in the United States and Canada
• Extracted SQL reports and data from production databases for analysis of medical and system data and forwarding to external groups.
• Assisted customers with the report customization system within the PaceArt application
• Gathered requirements needed for database merges and validation of database merges
• Setup and trouble shot interfaces for the PaceArt application services, including implantable device programmers, electronic medical records databases, and remote monitoring websites
• Maintained knowledge base with training materials and solutions
• Managed break/fix requests for customers through email, phone and ticketing systems
• Managed SQL Server security and user access
• Backed up, restored, and migrated databases