Application/Reimbursement Analyst

Jane Li

Lisle, IL *****

Email: *********@*****.*** • Cell#: 734-***-****

Summary

• 5+ years Applications Analysis experience based on SQL Server, Java, C#, Crystal Report environment

• Developed the partition of application includes codes, tests, debugs, documents and maintains to satisfy the requirements of one or more user areas

• Modified / optimized the application to translate the business requirements into technical electrical version.

• Leaded the project involved throughout a project's lifecycle with a team of business analyst, system experts

• Responsible to ensure that an IT industry standard system development life cycle project management technique is used in all report development, implementation, and enhancements

• Responsible for developing and documenting the internal procedures that will be used in conjunction with reporting

• Good team player with good communication skills, interpersonal skills with trouble-shorting and problem solving capabilities.

Technical Skills:

Computer Language: MS SQL Server 2005/2008, PL/SQL, TOAD, Business Objects/Crystal Report 8.5/XI, OLAP,OLTP, C++/C/C#, JDBC, ODBC, Statistica, Oracle 8i /11i, DB2, FoxPro 6, Visual Basic/VBA, MS Excel/Macros, MS Access, COBOL, Perl, JAVA, ASP,JSP, JavaScript, COBOL,

Serverlet, XML, HTML/CSS, Dreamweaver, Flash, Fireworks, People Soft, SSIS, SSAS, SSRS

Methodology: Mathematic of Finance, Account I/II

Professional Experience:

System/Business/Reimbursement Analyst

Client: Community of Mental Health, Lansing, MI 10/06-Present

Environment: SQL Server Management Studio 2005/2008, Crystal report XI, SSIS/SSAS, Visual Studio 2005/ 2008/2010, C#, Windows XP/2003,Stored procedure, MS Excel/Macros, MS Access

Responsibilities:

• Create the complex Crystal Reports as components of lager application base on SQL Server database and Clinical& Revenue Manager data warehouses

• Designed/Developed SQL program including triggers, stored procedures, scripts, functions, and queries tuning expertise for production interfaces, queries and processes.

• Designed/ Developed documents and maintains reports using the “Echo Reporter” system to run quickly and without error. Create clear and thorough end-user report documentation.

• Designed/ Developed C# program to transfer HIPAA 834 EDI file to the Revenue system

• Built SSIS project to restore flat file to SQL server Server

• Responsible for all aspects of assigned projects, including planning, design, coding, documentation and training

• Created sophisticated reports which may involve inter-relationship of data between the databases of the various vendors, through the use of additional languages.

• Leaded assigned projects and using SDLC methodology to complete the projects

• Supported the production system and troubleshooting

• Designed/developed new windows, tables, and databases for the Revenue Manager application.

• Debugging the problems and testing the newer released RM applications

• Planed and participated in crossing-training with staff

Sr. Programmer

Accenture, Client: State of Michigan, Lansing MI 12/05-8/06

Environment: Visual Studio 2005, JavaScript, VBScript, HTML,XML, CSS, Oracle, TOAD, MS Access, Crystal Report, Windows Server 2003, Windows XP, Dreamweaver, MS Visio, Adobe Acrobat, WSS 3.0, SQL Server 2005

Responsibilities:

• Prepared technical designs, unit test plans, string test scripts, and system test scripts.

• Wrote SQL queries base on Oracle database with TOAD

• Wrote QA test scripts of the child support Oracle application

Database Internship

American Axle Manufacturing, Detroit, MI 05/04-12/05

Environment: SAP Business Object, Crystal Report, Remedy/Maximo, Statistica, VB, MS Access/Excel, Windows XP, MS SQL Server 2000, HTML/DHTML, CSS, FTP, Dreamweaver MX, Photoshop and Flash MX etc

• Upgraded the MS Access programs from 1997/2002 version to 2003

• Created the Crystal Report projects with Oracle Business Intelligence

• Created the Statistica reports to analysis the Remedy/Maximo database

• Wrote the SQL queries to generate the Remedy/Maximo database reports

• Developed the MS Excel VBA program to generate the routine report

PC/UNIX (Solaris) Lab Helpdesk,

University of Detroit Mercy, Detroit, MI 01/02-05/04

Environment: Unix Solaris 8, Lunix,Windows 2000, Oracle database, Perl/CGI, PL/SQL, JavaScript, HTML /DHTML

• Maintained the network and daily access for the Advanced Computing Facility (ACF). Performed troubleshooting for software, printers and computers, and assisted professors and students with their computer related problems.

• Troubleshooting in PC/Solaris(8i) environments

EDUCATION:

9/04-Present: Eastern Michigan University, Ypsilanti, MI

• Master Degree in Computer Information Systems (capturing)

1/02-6/04 University of Detroit Mercy, Detroit, MI

• Bachelor Degree in Computer Information Systems

7/96-7/99: HuNan Tax College, Changsha, China

• Associate Degree in Computer Information System

Certificates

MS SQL, MS SSIS, MS SSAS Certifications

HONORS: Delta Epsilon Scholarship & Dean’s List 4 Semesters

Contact this candidate