SUMMARY:

• I am a Sr. Report Developer Analyst with over ten years of expertise using multiple database interfaces, specializing in writing Allscripts SCM Reports using SQL Reporting Services, Crystal Reports and I’m familiar with rational database structures, multidimensional databases, OLAP, Cubes, Data - marts, Allscripts, Oracle, SQL, Teradata, SSRS, Visual Studio, and Business Objects.
• I have worked with both hosted and internally hosted applications supporting the Allscripts EMR product as well as applications such as SQL Server, MS Access based applications, MS Excel, Business Objects, MS Front Page and other local custom Application.
• I have provided upgrade support, troubleshooting, training and the subject matter expert for several EMR applications including SCM.

KEY SOFTWARE SKILLS AND PROFICIENCIES:

• Allscripts 5.5 FP1, 5.5 SP1, 6.0, 6.1, 14.1, 14.3, 15.3
• Allscripts Sunrise™ Clinical Manager Clinical Documentation, Pharmacy, Ambulatory Care, Emergency Department, Dietary Department, Rehabilitation, Wound Care, Prescription Writer, Palliative Care Report
• Epic Clarity Data Model - EpicCare® Ambulatory
• Visual Studio .NET, Crystal Reports, Business Objects, SSRS, Boston Workstation
• Oracle, SQL Server 2000 Thru 2012, Access, Teradata
• Application Development - ASP, XML, VB / VBScript / VBA, HTML, Javascript, SQL
• Microsoft Office Suite - Word, Excel, PowerPoint, Project, FrontPage, Pivot Tables, Outlook, Access

RELEVANT EXPERIENCE:

SCM Report Developer / Analyst

Confidential, Orange, CA

Responsibilities:

• Provide Legacy Support for Allscripts Reporting while the organization transitions to EPIC.
• Interface with client End Users, Supervisors, Managers, IT Staff and 3rd party vendors to gather project or report specifications and translate for custom SCM report requests, modifications to existing SCM reports and to fix reports that don’t work as intended.
• Based on the technical specifications for a project, create work estimates for client approval prior to starting a project.
• Work with the client’s Business Intelligence tools which are SSRS 2010 & SQL 2012.
• Create Adhoc Queries, Stored Procedures and Functions as needed to fulfill report requests. Also enhance Stored Procedure whenever possible by looking for redundancies and bottlenecks in the queries. Migrate stored procedures and reports between environments. Perform back end technical testing associated with upgrades or changes.
• Test all New or modified reports prior to submittal.
• Document all new or changed reports

SCM Report Developer / Analyst

Confidential, Monterey, CA

Responsibilities:

• Assist with SCM & Quality Department reports backlog helping the organization to catch up and move forward with Report Requests.
• Mentor and train personnel in SQL, SSRS, Reporting techniques and the SCM database.
• Interface with client End Users, Supervisors, Managers, IT Staff and 3rd party vendors to gather project or report specifications and translate for custom report requests, modifications to existing reports and to fix reports that don’t work as intended.
• Create Adhoc Queries, Stored Procedures and Functions as needed to fulfill report requests. Also enhance Stored Procedure whenever possible by looking for redundancies and bottlenecks in the queries.
• Migrate stored procedures and SCM reports between environments. Perform back end technical testing associated with upgrades or changes.
• Pull data from multiple environments (MS Excel, Access, SQL and Oracle Databases) and systems organizing and formatting the data, so that it is meaningful to its audience and can provide answers to business questions.
• Create Audit reports for different departments for use with state and government required reporting for different programs.
• Updated Stored Procedures/Queries from ICD-9-CM to ICD-10-CM.
• Created scripts to upload data via government web sites.

Software/Report Developer

Confidential, Olive Branch, MS

Responsibilities:

• Build a reporting data warehouse using SQL 2012 to be used for government, financial and clinical reporting needs.
• Build data models as needed for use with the Data Warehouse, Data Marts, Cubes and Reporting.
• Create a reporting module to be added to the Confidential Software using Visual Studio 2013 and C#.net.
• Build a set of canned reports to be included with the Confidential Software in a report’s module.
• Build government required reports using Visual Studio 2013 and SSRS to create UDS, Meaningful Use, HEDIS, and PQRS Reports as needed by Confidential clients.
• Add Adhoc Reporting capabilities to the reporting module.
• Gather requirements from end users or clients and build reports that meet their needs based on the requirements.

Software/Report Developer

Confidential, Germantown, TN

Responsibilities:

• Build a reporting data warehouse using SQL 2012 to be used for government, financial and clinical reporting needs.
• Build data models as needed for use with the Data Warehouse, Data Marts, Cubes and Reporting.
• Create a reporting module to be added to the Confidential Software using Visual Studio 2013 and C#.net.
• Build a set of canned reports to be included with the Confidential Software in a report’s module.
• Build government required reports using Visual Studio 2013 and SSRS to create UDS, Meaningful Use, HEDIS, and PQRS Reports as needed by Confidential clients.
• Add Adhoc Reporting capabilities to the reporting module.
• Gather requirements from end users or clients and build reports that meet their needs based on the requirements.

SCM Report Developer

Confidential, Katy, TX

Responsibilities:

• Interface with client End Users, Supervisors, Managers, IT Staff and 3rd party vendors to gather project or report specifications and translate for custom report requests, modifications too existing SCM reports and to fix reports that don’t work as intended.
• Based on the technical specifications for a project, create work estimates for client approval prior to starting a project.
• Created and modified Meaningful Use Reports for Confidential client Carson Tahoe regional Medical Center using SQL 2010 and 2012. Reports were integrated into Allscripts SCM 6.1 and also worked with a custom dashboard created for the client by a third party vender. I also recreated Meaningful Use reporting for a government audit as the client needed to reproduce the numbers reported to the government for the audit.
• Work with the client’s Business Intelligence tools which are Crystal Reports 2008, SSRS, and Visual Studio.
• Create Adhoc Queries, Stored Procedures and Functions as needed to fulfill report requests. Also enhance Stored Procedure whenever possible by looking for redundancies and bottlenecks in the queries. Migrate stored procedures and reports between environments. Perform back end technical testing associated with upgrades or changes.
• Test all New or modified reports prior to submittal.
• Trouble shoot and correct issues with client Dashboards as necessary.
• Document all new or changed reports.
• Provided solutions for issues regarding reporting and Reports delivery. Coach local team with regard to table structure changes and common practice during upgrades. Provided ongoing advice and training with the customers’ employees as requested. Participated in major go-live support for reporting issues
• Worked at Lakeway Regional Medical center on an interface system that sent LakeWay’s billing to a third party vender. The system was built previously by others at Confidential, but had stopped working. I was to troubleshoot the issue and fix the interface. Then I provided missing data to the billing vender.

SCM Report Developer

Confidential, Birmingham, AL

Responsibilities:

• Interface with client End Users, Supervisors, Managers, IT Staff and 3rd party vendors to gather project or report specifications and translate for custom SCM report requests, modifications to existing SCM reports and to fix reports that don’t work as intended.
• Based on the technical specifications for a project, create work estimates for client approval prior to starting a project.
• Work with the client’s Business Intelligence tools which are Crystal Reports 2008 and SSRS.
• Create Adhoc Queries, Stored Procedures and Functions as needed to fulfill report requests. Also enhance Stored Procedure whenever possible by looking for redundancies and bottlenecks in the queries. Migrate stored procedures and reports between environments. Perform back end technical testing associated with upgrades or changes.
• Test all New or modified reports prior to submittal.
• Document all new or changed reports
• Provided solutions for issues regarding SCM reporting and SCM Reports delivery. Coach local team with regard to table structure changes and common practice during upgrades. Provided ongoing advice and training with the customers’ employees as requested. Participated in major go-live support for reporting issues
• Pull data from numerous sources to include SQL and Oracle database, flat files, MS Access, Word and Excel.

SCM Report Writer

Confidential, Brooklyn, NY

Responsibilities:

• Assist customer with SCM Report Writing Project for the HIM Department preparing reports for use with ChartMaxx Software.
• Modify existing or create new Chart Reports as needed.
• Add Index to the top of each SCM report as required by the ChartMaxx Software.
• Convert SCM reports from SSRS to Crystal Reports and other reports from Crystal Reports to SSRS.
• Help customer with other tasks as assigned.

SCM Report Writer

Confidential, San Antonio, TX

Responsibilities:

• Enhanced numerous stored procedures and SCM reports to be used by the Medical Records Department
• Modified Crystal Reports created in Visual Studio 2005; upgraded to Visual Studio 2010
• Utilized Visual Studio 2010 and VB.Net to modify a custom application used by the Medical Records Department to deliver the Medical Record to its customers; upgraded the application from Visual Studio 2005 to Visual Studio 2010, .Net Version 4.0 to accomplish the modifications
• Provided solutions for SCM reporting and SCM reports delivery issues

SCM Report Writer

Confidential

Responsibilities:

• Interfaced with Requestors/End-users to define reporting requirements as needed by the organization
• Troubleshot and repaired existing SCM reports that needed modifications due to system upgrades/changes
• Created SCM reports, stored procedures, functions and performed functional testing and deployments

SCM Report Writer

Confidential, Houston, TX

Responsibilities:

• Modified SQL 2008 and Scheduled stored procedures
• Modified Medical Logic Module SQL scripts
• Migrated stored procedures and reports between environments

SCM Report Writer

Confidential, San Antonio, TX

Responsibilities:

• Enhanced numerous Stored Procedures and SCM Reports to be used by the Medical Records Department
• Modified several Crystal Reports to SQL SSRS 2008 Reports
• Modified a custom application used by the Medical Records Department to deliver the Medical Record to its customers
• Provided solutions for issues regarding SCM reporting and Reports delivery

SCM Report Writer

Confidential, Long Island, NY

Responsibilities:

• Created numerous custom Dietary, Orders, Worklist, Signature Manager, Nursing and Pharmacy SCM reports, Stored Procedures and Functions via customer specifications
• Participated in major go-live support for SCM reporting issues
• Customized SCM reports, stored procedures and functions as necessary

SCM Report Writer

Confidential, Birmingham, AL

Responsibilities:

• Customized SCM reports, stored procedures and functions as necessary
• Modified Crystal Report labels and converted Crystal Reports to SQL reports
• Provided ongoing advice and training with the customers’ employees as requested

SSRS Report Developer

Confidential, Utica, NY

Responsibilities:

• Developed custom Allscripts (legacy Eclipsys) SSRS Stored Procedures, Queries and SCM Reports based on specifications and instructions received
• Wrote Stored Procedures and Queries using TSQL and Visual Studio 2005
• Created SCM reports in Visual Studio 2005 and SSRS and integrated with Allscripts

SCM Report Writer Analyst

Confidential, Bremerton, WA

Responsibilities:

• Designed and programmed custom SCM reports throughout the organization
• Queried data from multiple sources to include SQL and Oracle Databases
• Maintained current SCM reports created in Crystal Reporting 10 and SQL Reporting
• Created custom queries, views, models, and stored procedures using T-SQL