SUMMARY:

• Solutions - focused professional with exemplary technical, problem solving and customer service skills.
• Detail - oriented with dependability and flexibility for meeting support needs and managing multiple projects and tasks at any given moment.
• Demonstrated history of successful technology administration in application systems and programming while providing high-quality data and process analysis.
• Team-player recognized by team members and customers for the ability to seamlessly orchestrate projects from initial conception, through development, implementation, and completion.
• Communicates complex materials in a clear and simplified manner; able to apply critical thinking and evaluation skills in finding workable solutions.

AREAS OF EXPERTISE:

• Analysis & Design
• Database Development
• Project Management
• Technology Documentation
• Software Installation
• Customer Service & Support

TECHNICAL SKILLS:

Programming Languages: Crystal Reports (9 & 10); RPG, II, III, IV, Free, ILE, CLP, SDA,DB2,DBU Visual Basic (6.0), SQL, Internet Information Server (IIS), XML, HL7; FTP, Microsoft Office 2007 & 2010, SQR, HTML, HTML5, Query, SQL Server Management Studio 2005, 2008, ASP, ASP.NET, JavaScript, AJAX, Classic ASP

Operating Systems: Windows Server/ 2000/2005/2008 , IBM AIX, IBM OS/400, PeopleSoft 8.9 - 9.1 (HMIS), PeopleSoft 9.1(ELM), QS1(Out-Patient Pharmacy Retail System), Siemens MedSeries4 AR, AP, GL, MA, EDI - GenTran EDI 835/837

Applications: McKesson RX, ACUDOSE, ADMIN-RX, Supply Scan, Connect RX, Robot system, Esker LanFax, CBORD MICRO POS System, CBORD Odyssey System, PSG Gift Shop POS, Optio Med-Forms, Daily Baby-Site of Care, Tele-Tracking, NGS Patient Scheduling, MUSE GE EKG System, Volunteer Works, InsightCS, IBM Initiate, IBM dbMotion, API (MY-Time) System, Kronos Time Management

Software: Microsoft Office Suite, MicrosoftVisualStudio 2003/2005/2008/2010 , SQR, PeopleCode, Application Engine, PeopleTools, Application Designer, Application Engine, Data Mover, Process Scheduler, Tuxedo, SSRS, Lawson S3 V9.0, V10.0, Lawson Upload template, Lawson GHR

File Transfer Protocol: FTP, SFTP, FTP/S

Network Related Hardware: Ethernet 1G/10G

Network Related Software: SMTP, SNMP

Storage: Dell, EMC

Protocol: DHCP

PROFESSIONAL EXPERIENCE:

Confidential, Toledo, Oh

HRIS System Specialist

Responsibilities:

• I recommend and select and design cost-effective technology solutions in support of HR business requirement and partner with internal and external customers and vendors to determine HR technology needs.
• Maintain custom built web-based HRIS applications, data repository, reports and analytics from multiple data sources to assist in strategic business initiative and decisions, in collaboration with IT department, employee-related data integrations with any relevant internal or external applications, and implement and maintain employee & manager self-service applications & tools.
• Serve as a system administrator and work with the Information Resources and system vendors on issues and upgrades.
• On the ground floor of imputation, the Lawson HRMS System V10 to Lawson GHR globe system with a go-live date of February 2019.
• Maintain the new hires, transfer, and rehires employee within the system and upload them to the Lawson HRMS system.

Programmer Analyst

Confidential

Responsibilities:

• Oversaw the Implementation of software Computer Assisted Coding (CAC) project within the InsightCS System, work on downloading ICD10 codes for the government website into the system and wrote SQL 2008 script and Store Procedure to pull Doctor Information from the InsightCS system to the CAC system and schedules these jobs to run nightly and work with the end users for testing and validation.
• Merge Duplicate Patient records together for our Medical Records Department using the 3M Care Innovation System.
• On the ground floor of imputation, the IBM Initiate system and the IBM DBMotion system which will replace the 3M system that has today was training on IBM Initiate Inspector, Workbench, WebQuery, and Enterprise Viewer.

Confidential, Toledo, OH

Senior Applications Systems Analyst

Responsibilities:

• Oversaw operations and maintenance for six Windows 2008 production servers and three Windows 2008 test servers using PeopleSoft HMIS 9.1 and PeopleSoft ELM system, wrote programs using PeopleSoft Programming Languages.
• Scheduled downtime when necessary to perform system maintenance tasks and validated the software with end users to ensure the system was functional after upgrades and patches were applied.
• Converted the MedSeries4 Payroll System from AS/400 over to PeopleSoft 9.1 HMIS System, created 20 to 30 programs in AS/400 and uploaded into the PeopleSoft System transferring the data from the payroll system and Kronos Time Keeping system.
• Extracted records from SQL Database using Crystals Reports and Reporting Services Configuration Manager (SSRS) software so that the end users could validate the information in detail.
• Responsible for project planning, development, testing, troubleshooting and implementation support.
• Performed on-going maintenance and support from upgrading software to fixing program errors, answering questions and helping end-users on the Payroll, Materials Management, Account Payable and General Ledger system and Admission Discharge and Transfer (ADT) system.
• Conducted 1099 processing at the year for Accounts Payable along with W2’s for payroll, which included printing, sending to the IRS and individual cities within Ohio and Michigan.
• Monitored payroll processing every two weeks to make sure that the checks were deposited in the banks and credit unions for the employees and payroll balanced at the end of the process.
• Handled Daily Backup using BRMS software on AS/400, which allowed for backup while end-users were on the system and applied PTF patches to fix microcodes along with quarterly did a reboot on computers using the IPL.
• Supported and managed the maintenance of third-party system within Confidential in different departments, such as PSG Gift Shop, QS1 Out-Patient Pharmacy System, CBORD POS system and another system within Confidential .

Applications Analyst

Confidential

Responsibilities:

• Designed and developed various AS/400 applications that interfaced with Mainframe and Windows-based systems, one of the applications was a web page that was used to interact with end-users to train them on certain software.
• Applied vendor software upgrades to the source code, made changes to the vendor code if they changed anything in their program, and would customize and apply the internal changes to the code and then test the software.
• Contacted software vendors to resolve application performance and data integrity issues for different departments such as QS1 software for Out-Pharmacy System, when the database would run slowly worked with the vendor to run reorg and synchronize the databases.
• Developed various programs on AS/400 and Mainframe that extracted data from ad-hoc and delivered software reports for use by departments such as Surgery for charges that would be posted to patients’ accounts and sending Medicare Billing to insurance companies.
• Supported maintenance on Windows 2000 and SQL server-based systems that interacted with AS/400.
• Managed projects that needed to be done, from the implementation of software enhancements and platform upgrades to running projects from start to finish, which included new server upgrades to new software upgrades.

Confidential, Toledo, OH

Senior Programmer Analyst

Responsibilities:

• Performed software maintenance regularly in correcting problems communicated by end-users, continually improved software performance and kept it usable in the ever-changing business environment.
• Designed AS/400 business application using the Jack Henry Banking software, which made it more convenient for farmers to apply for small business and low-interest loans.
• Developed various interactive file maintenance programs on the AS/400 utilizing sub-file processing and record editing functions.
• Created programs and Query in the AS/400 system, worked with the VP of Finance and wrote a query to generate reports on customer balances over a specific dollar amount.