Sql Server Microsoft

Kazue McHugh

*** ***** ** ******

Colorado Springs, CO 80904

E-mail: ***********@***.***

719-***-**** (mobile)

PERSONAL OBJECTIVE:

I am a highly motivated and flexible IT professional with a strong background in analysis, design, building, testing, and implementing systems applications in both financial and healthcare environments. My logical thinking and common-sense approach provide efficient task completion and prompt problem resolution. I excel in both individual and team environments.

TECHNICAL EXPERIENCE:

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

Database: Microsoft SQL Server 2019, Oracle 12c, Sybase, RDBMS, Microsoft Access 2007

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

Operating Systems: Mac OS, Windows 10, UNIX, DOS

TECHNICAL TRAINING AND CERTIFICATION:

Salesforce Administration Certification at Idaho Falls

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

EDUCATION:

Bachelor of Science in Computer Study, University of Maryland, College Park in May 1996

SUMMARY OF QUALIFICATIONS:

Three years of experience in Administrating and developing Salesforce applications.

Five years of experience creating Data warehousing with ETL process.

Six months of experience in developing Tableau reports.

Six years of experience in Health Level 7 (HL7) messaging.

Seven years of experience in Visual Basic .Net, C#, ASP .Net, XML and XLST.

5 years of experience in Windows Service with TCP/IP socket.

Six years of experience in OOP (Object-Oriented Programming).

Fifteen years of experience developing and maintaining Relational Database, Stored procedures and queries utilizing SQL Server Databases.

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.

EXPERIENCE DETAIL:

July 2023 to Feb 2024 Augusta University Health Augusta, GA

Sr. Software Developer - ALKU

Created ASP.NET with C# for the Ophthalmology doctors to review the historical clinical notes.

Extracted information form the clinical notes using Python.

Worked on the tickets in ServiceNow to reserve issues that customers are experiencing for the 34 web applications.

Converted the Oracle databases to the SQL Server.

December 2017 to July 2022 Idaho Central Credit Union Chubbuck, ID

Software Developer, Data Warehouse Developer

Developed the Data Warehouse by extracting financial data from the Oracle database and the SQL Servers using AppWorx.

Salesforce Software Development using JavaScript, HTML, JSON and Apex.

Modified and created PHP reports.

Used GitHub as a source control system.

Became certified on the Salesforce Administrator.

April 2014 to April 2017 Johns Hopkins Health System Baltimore, MD

Sr. Project analyst (SQL Server Developer/Clinical Analytics)

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 2014 and updated and created the SSIS packages.

Created Data warehousing with ETL process for the reporting.

Developed Windows Service Application for processing HL7 Messages using C#.NET based on the concept of OOP and updated the Analytics database tables.

Uploaded files from the EDI translator through SFTP to the database tables using 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.

June 2006 to April 2014 Johns Hopkins Hospital Baltimore, MD

Software Engineer

Developed Windows Service Application for processing HL7 Messages using VB.NET, TCP/IP socket, XML and multi-threaded programming based on the concept of OOP. Back-end developed in SQL Server 2000 based on the concept of OOP.

Converted the International Billing System from Oracle Database to SQL Server 2005 and converted Oracle SQL loaders to SSIS packages.

· Used Powershell scripts to administrate some mainframes services and filesystem environment.

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.

Worked on Medicare & Medicaid Services (CMS) forms that print out from the International Billing System.

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.

Converted some of MediLinks Crystal reports to SSRS.

Developed the MS SQL Server Reporting Services reports for MediLinks and gave presentation to the team.

February 2006 to June 2006 InPhonic, Inc. 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.

June 2005 to February 2006 Northrop Grumman Corporation Rockville, Maryland

Senior Software Engineer - Independent Consultant

Participated in the design and development of a complex benefit payment system, VETNET, for the US Department of Veterans Affairs based on the concept of OOP.

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 in training for new team members in the learning process.

July 2004 to April 2005 Legg Mason Owings Mills, Maryland

Software Developer – Soft World, Inc. Waltham, Massachusetts

Modified, enhanced, and supported the Client Reporting Framework for Legg Mason Capital Management using Actuate.

Wrote and developed 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.

May 2004 to June 2004 MetraTech Corporation Waltham, Massachusetts

Crystal Report Developer – Soft World, Inc. Waltham, Massachusetts

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.

January 2004 to April 2004 Quris Denver, Colorado

SQL Server Developer – Compri Consulting Inc, Denver Colorado

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

December 2003 to January 2004 QED (Quality Education Data Inc.) Denver, Colorado

Software Developer – MicroStaff Corporation, Englewood, Colorado

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

June 1999 to July 2003 MSS Group Inc. 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.

September 1998 to December 1998 JCI (Japan Communication, Inc.) Colorado Springs, Colorado

Technical Support Position for Telecommunication Billing System

Wrote a C++ program that reads a CDR (Comma Delimited Record) of cellular telephone calls. The program reformatted the CDR into a standard telephone billing system format.

Developed implementation documentation 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.

January 1998 to August 1998 EDS Customer Solution Center 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.

November 1997 to December 1997 MCI Telecommunication Corporation Colorado Springs, Colorado

Software Developer – Aerotek Engineering Services, Inc., Colorado Springs, CO.

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.

January 1997 to March 1997 Digital Equipment Corporation Colorado Springs, Colorado

Customer Critical Center – TechAid, Colorado Springs, CO

Responsible for supporting gold and silver team members and managers in system use, crash recovery, and system upgrades.

REFERENCES

Excellent references available upon request.

Contact this candidate