| | | 20,000+ Fresh Resumes Monthly | |
|
|
| |
Click here or scroll down to respond to this candidateRay DillingerAurora, IL. PHONE NUMBER AVAILABLE LINKEDIN LINK AVAILABLE EMAIL AVAILABLEMicrosoft: Project, PowerPoint, SharePoint, Visio, VBA, S3, Azure, Excel (vLookups, Pivot Tables)Programming: Visual Basic, HTML5, CSS, SQL, Stored Procedures, APIsDatabase: Oracle, SQL Server Management Studio, Access, Quickbase, ToadSoftware: Service Now, Kronos, Kenexa, Vantive, Planview (ERP), Agile CRM, JIRAMethodologies: ETL, ITIL SWOT, SDLC, AgileFinance (Oracle/Peoplesoft/SAP): SOX compliance, AR, AP, OE, GL, Revenue Recognition, Invoicing, HREDI/eCommerce: SPSCommerce, SAP by Design (iConnect), XML, SFTP, FileZilla810 Invoice, 850 Purchase Order, 856 Advance Shipment Notice, 940 Shipment Requested, 945 Shipment Sent, 997 AcknowledgementAsset Systems Naperville, ILTechnical Support, Quality Assurance, Release Management, and Training 2021-PresentSoftware support and tracking through resolution (I independently support over 100 clients)Schedule, plan, tailor, and execute training (on-site and virtual)Unit and regression testing in PreProduction environmentsScrum/Sprint Release Management using JIRAAgile Customer Relationship Management (Profiles, Contacts, Notes, Tags)Facilitation of installs, upgrades, and bar code reader technologyLicense renewal processing, documentation, administration, and communicationAnalyze, plan, and execute data conversionsFacilitate fixed asset management and depreciation calculation software as a service (SAS)On board clients to our cloud based Ingenium Fixed Asset Management software via Microsoft Azure, Swagger, and CloudflareResearch issues using Artificial Intelligence (prompting via ChatGPT)Robert Half/UniBall Corp Wheaton, ILIT Consultant/EDI 2020-2021Hands on proficiency with creating, editing, filtering, monitoring, and processing incoming and outgoing EDI files to increase throughput and eliminate roadblocksAetna/Coventry/First Health Downers Grove, ILManager, Applications Development 20002018Development and technical support of claims processing, invoicing, and accounts receivable application that supports Workers Compensation, Network Rental, Carrier, and Third-Party AdministratorsUnder pre-determined date constraints, tactfully planned and upgraded the application user interface (VB 6 to VB.Net) and middleware (Tuxedo to JAVA Web Services)Delivered monthly Steering Committee presentationsI negotiated the de-scoping of non-critical functions and fast-tracked the project to be completed 3 months ahead of schedule and reduced the budget by $50,000.Ray Dillinger PHONE NUMBER AVAILABLEFocused on solutions, analytics, and process improvements for example, when the business indicated that financial reporting time was jeopardizing the completion of month-end close, I recommended the implementation of a Data Archiving strategy to mitigate risk. The resulting strategy:Reduced database footprint by 50%Saved 100 GB of disk spaceImproved system response time by 20%The month-end closure times were moved up 2 critical business days.When Aetna acquired Coventry, that acquisition required a data conversion of PeopleSoft GL Accounts into Oracle GL Accounts within a tight 3-month period. I directed the project team to:Create As Is and To Be application roadmapsProduce source-to-target data mapping documentsThe acquired PeopleSoft software was retired saving $225,000 in annual licensing fees.Collaborated intentionally with the business to identify IT solutions that support business processes for example, the government Office of Foreign Asset Control (OFAC) mandates that all corporations comply with economic trade sanctions.Selected as the IT manager for implementing periodic OFAC screenings of all internal data sources against a national fraud databaseThis saved the company from substantial losses through pro-active fraud prevention.Project ManagerWhen Coventry acquired Concentra Workers Compensation, that acquisition required integration into the existing Coventry Workers Comp suite of applications. I was:Selected as project leader for the financial application conversionDirected the A/R conversion and consolidation of client invoicingGuaranteed requirements were documented and implemented in accordance with the project planThis project enabled the company to retire its Oracle Financial software, saving $250,000 annually.As the application owner of multiple high-profile financial systems, my teams were accountable to ensure that the associated Development, Testing, and Production environments adhered to the highest standards.Authored and maintained our Sarbanes Oxley 404 (SOX) General Computer and Controls documentationAddressed critical audit controls such as Application Monitoring, Change Control, Risk Mitigation, User Access, and SecurityAs a result of my due diligence, these applications consistently met compliance requirements of annual internal and external audits.Bachelor of Science in Computer ScienceAmerican University Washington, DC |
