SUMMARY:

• Six month of experience in developing Tableau reports.
• Six years of experience in Health Level 7 (HL7) messaging.
• Six years of experience in Visual Basic .Net, C#, ASP .Net, XML and XLST.
• Fifteen years of experience developing and maintaining Relational Database, Stored procedures and queries utilizing SQL Server 2008 / 2012.
• Eight years of experience using SSRS (SQL Server Reporting Services) and SSIS (SQL Server Integration Services).
• Five years of experience maintaining and creating stored procedures, queries, tables and SQL Loaders utilizing Oracle.
• Three years of experience in web development using ASP, Java script and HTML
• Twelve years experience programming Full Life Cycle Development applications for financial tracking, Health Care system, human resources, telecommunications and reporting applications using VISUAL BASIC v.5/ v.6.
• Thirteen years of experience creating custom end - user and in-house reports using Crystal Reports v.6, v.8, v.9 and v.10.
• Two years of experience in C++ and C.
• One year experience in Actuate 7.0 development and Microsoft SQL Server 2000 Reporting Services.
• One year experience in COBOL, COBOL II, JCL and TSO/ISPF.
• Knowledge in UNIX platforms, Shell programming and Perl.
• Bilingual in Japanese and English.

TECHNICAL EXPERIENCE:

Languages: ASP, Visual Basic .Net, C# .NET, ASP .Net, XML, XLST, Java script, HTML, C, Visual Basic v.5 / v.6, Visual C++, Transact SQL, PL/SQL, COBOL, COBOL II, JCL, UNIX shell scripts

Database: Microsoft SQL Server 6.5 / 7 / 2000 / 2005/ 2008/ 2012 , Oracle 9i/ 10g, Sybase, RDBMS, Microsoft Access 98 / 2000/ 2003/ 2007

Development Tools: Microsoft SQL Server 2012 Reporting Services, Microsoft Visual Studio 6.0/2008, Microsoft .Net Framework, Actuate 7.0, Crystal Reports v.6 / v.8 / v.9, v.10/v.11, Tableau, TSO/ISPF, Star Team, Rational software, Dimensions, Microsoft Visual Source Safe

Operating Systems: Windows 7 / NT / 95 / XP, UNIX, DOS

TECHNICAL TRAINING:  MS2780 Maintaining a Microsoft SQL Server 2005 Database from System Source at Colombia MD, Oracle Database 10g Administration Workshop 1 Ed 3 from System Source at Colombia MD, September 2008

PROFESSIONAL EXPERIENCE:

Confidential, Baltimore, MD

Sr. Project analyst

• Created the Discharge Summary dashboard and the Impact of EMMI Education Modules on HCAHPS Responses Dashboard using Tableau.
• Migrate the Clinical Analytic Database server and the Reporting server from MS SQL server 2008 to 2012 and updated all the SSIS packages. 
• Developed ICD10 Comorbidity table and analyzed Behavioral Health intervention program.
• Developed the RAC (Medicare’s Recovery Audit Contractors) Activity reports using SSRS (SQL Server Reporting Services).
• Developed and Modified URC (Utilization Review committee) reports using SSRS (SQL Server Reporting Services).
• Developed/Converted readmission logic for the previous All Cause Intra-Readmissions Reports to utilize new readmission logic from the HSCRC (Health Services Cost Review Commission) using SSRS  and SQL Server stored procedures
• Worked with MCCM software (Morrisey) to develop/modify Crystal reports.
• Developed, modified, and maintained SSIS packages for importing patient data from multiple systems to the Clinical Analytic Database server.

Confidential, Baltimore, MD

Software Engineer

• Developed Windows Service Application for processing HL7 Messages using VB. NET, TCP/IP socket, XML and multi threaded programming. Back-end developed in SQL Server 2000.
• Converted the International Billing System from Oracle Database to SQL Server 2005.
• Developed multiple revisions to the International Billing System using VB.NET, Crystal Reports, and SQL Server 2005.
• Developed and maintained Crystal Reports for EBB (Electric Bed Board), IBS (International Billing System), and MediLinks Rehab System,
• Provided on-call support for clinical production systems including EBB (Electric Bed Board), IBS (International Billing System), MediLinks, SRM (Sunrise Record Manager), Wristband Printer System and Colorflex.
• Supported the New Clinical Building wristbands installation to include documentation and setup.
• Developed the Fiscal Year Billing Files Adjustment application using C#.NET.
• Revised to the ICD 9 update process for the SQL Server 2008. Created SSIS packages to replace DTS packages and rewrote ICD 9 process documentation.
• Modified the Plasma Screen project using ASP.NET with AJAX.
• Revised the Electric Bed Board Application using VB.NET and ASP.NET.
• Created Excel versions of the MediLinks Crystal reports.
• Developed the MS SQL Server Reporting Services reports for MediLinks and gave presentation to the team.

Confidential, Reston, Virginia

Configuration Management Deployment Engineer

• Worked as part of a team that was responsible for providing Technical Configuration Management and deployment support for ASP .NET, C# .NET and VB .Net applications and XML files.
• Managed the software configuration, the deployment of software to stage and production environments via internal ticket system identify and control configuration items, and document changes to the applications.
• Utilized Visual Source Safe to manage version control and used Problem Tracker for documentation, tracking of bugs and defects.
• Created robust CM processes to increase value and solve problems in software development.
• Analyzed code, wrote stored procedures, tracked metrics, resolved problems, compiled code and conducted the user acceptance testing.

Confidential, Rockville, Maryland

Senior Software Engineer

• Participated in the design and development of a complex benefit payment system, VETNET, for the US Department of Veterans Affairs.
• Responsibilities included business logic analysis, design, modeling and documentation using object-oriented techniques and tools used the Rational Rose. Responsible for developing complex business logic code in Visual Basic.
• Utilized Dimensions to manage version control and used Clear Quest for documentation, tracking of bugs and defects.
• Participated training for new team members in leaning process.

Confidential, Owings Mills, Maryland

Software Developer

• Modified, enhanced and supported the Client Reporting Framework for Confidential Capital Management using Actuate.
• Wrote and develop logic for stored procedures to Sybase, capable of keeping data manipulations and financial calculations confined to server side.
• Created a new subsystem within the Client Inquiry Framework to maintain the default starting performance values for various benchmarks used by Capital Management. The subsystem supports adding, changing and deleting benchmark prices for a specific initial date. Subsystem was written in ASP using VB 6 Com DLLs to encapsulate the business logic. All data was stored in Sybase tables.

Confidential, Waltham, Massachusetts

Crystal Report Developer

• Translated invoices that written by Crystal report 9 and part of XML code from English to Japanese.
• Troubleshoot existing financial reports and enhanced Stored Procedures for financial report.
• Assisted in finalization of web site.
• Acting as liaison for Japanese team at Premier Conferencing in Tokyo for completion of Billing System.

Confidential, Colorado

SQL Server Developer

• Developed web base financial reports using Microsoft SQL Server 2000 Reporting Services, Microsoft Visual Studio .NET, PL/SQL, VBA and Oracle as the backend.

Confidential, Denver, Colorado

Software Developer

• Modified, enhanced and supported Confidential State School Guides and Onyx customer Center application using VISUAL BASIC v.6, Microsoft SQL Server 2000 and Crystal Reports v.9.

Confidential, Castle Rock, Colorado

Software Developer for Telecommunication Financial Management System

• Demonstrated ability to prioritize and manage multiple projects to meeting timelines for project delivery.
• Modified, enhanced and supported MSS Group proprietary telecommunication financial management application using ASP, VISUAL BASIC, SQL Server and Crystal Reports.
• Designed, developed and deployed Human Resources application. Front-end developed in Visual Basic version 6. Back-end developed in SQL Server 2000. Designed this application in VB .Net, C# .NET and ASP.net which was deployed as an Intranet application.
• Wrote and developed logic for stored procedures to Microsoft SQL Server, capable of keeping data manipulations and financial calculations confined to server side.
• Developed EDI application using Visual C++.
• Converted MS Access queries to SQL Server stored procedures ensuring portability, Internet and Intranet readiness and security of software.
• Created concise detailed financial reports using Seagate Crystal Reports.
• Developed efficient intuitive GUIs according to specific customer specifications.
• Translated C code program to VISUAL BASIC code.

Confidential, Colorado Springs, Colorado

Technical Support Position for Telecommunication Billing System

• Wrote a C++ program that read a CDR (Comma Delimited Record) of cellular telephone calls. The program reformatted the CDR into a standard telephone billing system format.
• Developed implementation documentation's for a new electronic payment method.
• Created test data and conducted stress testing on a new telecommunication billing system. Also tested the user interface to an Oracle database as part of the system test.
• Used C++, Windows 95, UNIX.

Confidential, Colorado Springs, Colorado

Programmer for GTE Financial System Y2K Renovation

• Analyzed GTE Financial Application written in COBOL for Y2K modifications.
• Developed unit test cases for the Y2K corrections.
• Coded corrections to COBOL programs and JCL modules.
• Conducted unit testing for modified modules.
• Documented the result of unit testing.
• Used COBOL,JCL,TSO/ISPF and several other Mainframe utilities.

Confidential, Colorado Springs, Colorado

Software Developer

• Responsible for analysis and conversion of System One application from OS/2 to Ms Windows NT for intelligent Services Platform development team.
• Supported enhancement of System One application written in a C++ program.

Confidential, Colorado Springs, Colorado

Customer Critical Center

• Responsible for supporting Gold and Silver team members and managers in system use, crash recovery, and system upgrades.