Systems Analyst Resume Profile Wauwatosa, WI - Hire IT People

Summary Qualification

Skills

Relative Work Experience

Systems Analyst

Confidential

Engaged in supporting home grown OnCall Scheduler timekeeping system with SQL database and Crystal Report for Physician Support Department.
Analyzed data and table structure from database to troubleshoot issues on OnCall Scheduler per given criteria/situation.
Provided project management coordination with EPIC Bridges technical support, the state analyst, and partners from other departments on the Wisconsin Immunization Registry WIR .
Created and supported applications on the home grown custom interface engine, using UNIX, Perl, and HL7 messaging. Also converted a C program for lab interface to a Perl program.
Collected/analyzed requirements and engaged in defining, designing, implementing, testing and supporting applications in interface engine.
Assisted teammate on SQL coding and store procedure issue.
Communicated with professional partners on their specific requests and requirements.
Cross-trained for lab, data captor/medical device interface for on-call support.
Documentation on all the projects and specifically for WIR, due to its complexity and data issue.
Created user's documentation and provided training to users based on their skill level.
Supported multiple web pages and used SourceSafe for web pages versioning.

Interface/Application Analyst

Confidential

Worked on Wisconsin Health Information Exchange project for ER, clinical and manage care use.
Engaged in defining, designing, implementing, testing and supporting Microsoft Amalga interfaces based on C from various stakeholders in the health care environment with the WHIE.
Engaged in design, development, test and support of various SQL databases and views, Microsoft Amalga User Interface and Crystal Report. Also worked with HL7 messaging and CCD/XML.
Investigated and debugged incoming HL7 messages that prevent system from running smoothly.
Analyzed data and written reports for executive director, various clinical and committee needs.
Created audit reports and processes for consistency, quality check before running reports.
Provided feedback on reports that are out of ordinary.
Provided feedback on processes that may need improvements.
Experienced on testing and validation for system migration, database migration process and other project need.
Created a new database and data collection/entry feature within the system for clinical communication among ERs.
Coordinated with Project Manager on project implementation process and documentation.
Communicated with health care partners on the quality of project requirements.
Communicated, validated and test code with offshore team consultants on project requirements.
Communicated with Microsoft Amalga operation team vendor on project needs.
Used Team Foundation Server for code versioning.

Programmer / Report Analyst

Confidential

Understand Disease Management, Health and Wellness Incentive, and Utilization Management, with some claims data.
Created audit reports and modified existing outcome reports for accuracy and quality purposes.
Assisted on creating book of business and system migration process.
Communicated with user for requirements, follow workflow and deliver accurate reports to clients.
Guided/trained new employee on standard process and provide assistant on their projects.
Worked as an IT coordinator with vendor on gather information for coding and networking need.
Participated in design and implementation process of a project.
Used SQL Profiler and Activity Monitor to troubleshoot SQL activity.
Experience using T-SQL/MS-SQL, including stored procedures, functions, DTS packages and ETL.
Analyze audit data Pay attention to detail Able to read data to confirm not following workflow.
Created and automated reports with Crystal Reports 10/Crystal Enterprise/SSRS, DTS/SSIS Jobs, SQL server agent Microsoft SQL Server Management Studio.
Created program for barcode labels, tested and assisted user on how to use the application on-site.
Able to multitask, have sense of urgency and meet deadlines.
Documentation with Visio and other MS Office Suite tool for both user and within department.
Used SourceSafe for code versioning.

Programmer Analyst

Confidential

ETL process with Oracle Warehouse Builder.
Created Care Management and other healthcare related forms and reports with Oracle Discoverer and Excel, display graphic reports.
Created automation feature on Access 2000 user friendly and minimize the unnecessary support.
Designed, created, tested and validated clinical database on Access 2000 help client collected data to maintain department's practice with benchmarking setting, also created related graphic reports.
Communicated with client to specify the detail of the requested database and report criteria.
Written down workflow when user shows me how nurses use the application and apply to the report.
Data migration from Access 97 to Access 2000, editing forms and VBA code.
Experience using Oracle PL/SQL, including stored procedures, functions, materialized views.
Experience with process on Cerner System.

Programmer Analyst

Confidential

Designed, created and fully tested QA CD and web applications in JAVA, JSP, Javascript and in VB .NET.
Created Excel reports through JAVA and JSP.
Created reports with Crystal Reports 8.5.
Created forms with JDeveloper.
Used Magic Help Desk for problem/job requests including applications and reports related to JAVA, JSP, ASP, Unix Shell script and for on-call record.
Communicated with users, application analysts and managers.
Helped estimator to solve the Excel problem with VBA.
On-call every two months to help troubleshooting PC problems with the production floor.
Experience using SQL Server 2000, Informix, and Oracle.
Documentation with Visio and other Microsoft Office Suite tools, including using flowcharts and UML diagram.
Used SourceSafe for code versioning.