Dennis Ramirez Email & Phone Number

Tampa, Florida, United States

• Oversee Data File exchanges for completion.
• Gather technical requirements, for file transmission protocol and assist Development Team decipher file errors.
• Gathered requirements for the automation of the company’s Payroll Calendar process, working directly with the Salesforce Administration Team in a UAT environment.
• Manage ticketing portals (Salesforce/JIRA) to document and resolve client/provider issues in a timely manner.
• Audit Client accounts through the use of MS Excel and MS Access to validate the Billing and Reconciliation of employee history
• Organize, plan and schedule activities associated with the timely processing of customer data

Greater Chicago Area

• Streamlined support of premium billing, reconciliation, and accounts receivable processes, ensuring accuracy of all transactions
• Gathered requirements and specifications to develop system to update information in MS Access databases, altering queries, creating forms, and reports, with data exports in order to calculate pro-rated premiums.
• Utilized databases to perform broker and eligibility audits, reconciling commissions, identifying errors, and updating member records for billing validity
• Expert level knowledge of MS Excel design and build reports, spreadsheets, utilizing Pivot Tables and VLOOKUPs
• Facilitated continuous interaction between Client Accounting and Finance Departments to develop ad hoc reports for Clients.
• Analyzed current system functionality and developed process improvement recommendations to improve business processes

Greater Chicago Area

• Utilized Agile techniques to facilitate management of high priority projects for clients including 4 of Allied’s largest clients. (Daily short calls and with updates, verifying progress in sprint like intervals)
• Extensively focused on the utilization of TriZetto provided software to manage invoice production, setup, and maintain custom-client workflows.
• Efficiently prepared, audited, and posted monthly client invoices using project management strategies to optimize maintenance of the billing process while improving customer satisfaction and hitting month end deadlines.
• Utilized MS Access Databases for the effective creation of aggregate counts, counts by benefits, general census count reports, optimizing the ability to generate reports summarizing client totals by location. Lead team.
• Owned relationship of all client issues resolving billing and related issues to their satisfaction.
• Developed and designed training manuals encompassing policies and procedures to assist new hires in the business processes.

Greater Chicago Area

• Computer Consultant Assigned to Ameritech May 1998 – Apr. 2001
• Supported telecommunications retailers in a 5-state region in regards to EMI and ASEBS bill data formats.
• Coded JCL and modified existing COBOL programs to edit data and create files in a TSO/ISPF platform for invoice reconciliation purposes.
• Used Excel and Access to integrate reseller files from mainframe
• Maintained production files, transferred data and monitored the status of jobs. Computer Consultant Assigned to Allstate Oct. 1997 – May 1998
• Designed test conditions to correspond with new coding logic.

Greater Chicago Area

• Monitored device operations such as IBM 3380 DASD drives, 3420 Tape Drives, and 1215 Printers in order to detect errors, machine stoppage and facility output.
• Controlled the scheduling and production of jobs using OS/VS1 commands in a MVS mainframe environment.
• Notified programming staff of any issues and resolved them by making updates to programs which allowed them to run through completion.
• Coded JCL programs to perform data appends, record reformatting, merge/purges and modified existing COBOL programs to fulfill production orders from sales staff.