Michael Hall
********@*****.***
Professional Skills
Document Management/Reporting: OnBase Certified Application Programming Interface, Crystal Reports, SQL Server Reporting Services, OnBase versions 13/15/16/17/18, EPIC, KOFAX, FoxIT, ANYDOC, OpenText/Captiva
Programming Languages: JavaScript, VB.NET, ASP.NET, ADO.NET, C#.NET, XML, XSLT, XPath, o:XML, SQL, T-SQL, PHP, Web API, .Net Routing, Web Forms, API
SQL Server 2000, 2005, 2008, 2008/R2, 2012; MySQL; SAP R/3 (FI/HR/SD/PP), IIS 3.0, 4.0, 5.0, 6.0, 7.0
XML Related Technologies: XML, SOAP, Window Services, Web Services (SOAP/REST)
Development Tools: Microsoft Team Foundation Server, JIRA
Application Servers: AS/400, Microsoft Server 2000, 2005, 2008, 2012
Other Technical Skills: WPF, UML, HTML, TallPDF, AJAX, PowerBuilder, UNIX, MVC, VBScript, PERL, Windows PowerShell, ASP, CSS, SOAP, LINQ, LINUX, Blackbaud, CRM, Paradox, JSON, JQuery, PeopleSoft, ETL data warehousing, Vault, SourceSafe
Professional Experience
Cognizant(CareFirst/FEPOC) March 2020 to Present
Senior OnBase Consultant
Remote
Hired to implement Advance Capture, Capture Process Designer (CPD), Workflow design for Scanned, Faxed and Emailed documents/forms. Also, to write API’s to replace current CaptureIT, ExchangeIT and AnyDoc processes.
Created multiple Scan Queues and corresponding CPD.
Installed and implemented Mailbox Importer to route emails and attachments to CPD processes and workflow queues. Created actions and rules to correctly identify and route to proper Document Types.
Created multiple Reporting Dashboards for Management to monitor Workflow queues and Status Step Queues
Wrote an API to combine email message and multiple email attachments into one TIFF image, then push the document through advanced capture into workflow queues.
Wrote a PowerShell script to create a DIP file from an ExchangeIT GTO file.
Created multiple Advance Capture Templates for document/form classification and extraction of data/keywords. All documents and forms in AnyDoc were converted to Advanced Capture.
Wrote multiple Custom Queries to leverage in API development.
I converted multiple AnyDoc VBscripts to C# Unity Scripts within OnBase.
Texas Woman’s University November 2019 to March 2020
ECM Manager/OnBase Consultant
Denton, TX
Hired because OnBase system was a failure. No departments wanted to use it.
Wrote EDI system for High School and College transcripts.
Created XSL stylesheet for the EDI XML.
Used Oracle (Colleague) and OnBase SQL databases
Revised AD accounts and OnBase User Groups
Created TEST and DEV environments because they only had PROD.
Created and Revised Autofill Keyword Sets for indexing.
Created departmental Document Type Groups and Document Types for importing/scanning.
Torchmark/Globe Life November 2018 to November 2019
Senior OnBase Developer
McKinney, TX
Worked on an OnBase environment with 2 billion documents, 12,000 Document Types, over 10,000 users
Upgraded system to OnBase 2018.55
Implemented Distribution Service for workflow emails, Mail Box Importer to ingest emails into OnBase and created an Auto-Redaction process for multiple departments using VB Script.
Wrote a Restful API service for a companywide project. This service will search keywords against single or multiple custom queries and/or document types. Also, will stream any type of document back to the caller from the process listed above.
Worked with Captiva creating scanning workflows for identification, validation and verification.
Set up Load Balancing for 4 OnBase application servers behind a F5/BigIP.
Set up and maintained 5 Full Text servers.
Andesa Services June 2018 to November 2018
Senior OnBase Developer
Allentown, PA (remote)
Assisted in OnBase upgrade from OB 2017 to OB 2018.
Created AnyDoc templates and form families for multiple lines of businesses to index keywords and scan documents into Onbase through DIP process.
Designed, Developed and Implemented entire client line of business (Keywords, KTG single and multi-instance, Autofill Keyword sets, Document Type Groups, Document Types, Custom Queries, File Cabinets, Folder Types (auto-foldering & dynamic), Ordered DIP processes, OB 2018 unity client timers, workflows, Unity Management Console/Task Scheduler/Workflow Task service setup, API calls, Unity hooks, .Net Assemblies, web services, setup User Accounts and User Account permissions and privileges)
Used Config/Utils/Change Management to Export and Import changes between Dev, Test, UA and Prod environments.
Worked with clients to design, develop business logic for each line of business.
Wrote a Powershell script for Cigna image conversion to automate the ingestion of over 50,000,000 documents and corresponding metadata.
Created multiple EForms to replace existing Filebound processes allowing Andesa to move away from Filebound saving Andesa money.
Baylor Scott & White June 2018 to September 2018
OnBase Consultant
Dallas, TX
Hired to covert Unix Bash Scripts to PowerShell Scripts that create DIP files from complex Bank of America Excel spreadsheets.
Wrote supporting PowerShell scripts to UnZip multiple zipped folders in a given directory, create appropriate folders and corresponding csv files, create emails for successful processing and error logs, parse csv data and create a tagged and ordered DIP files, moved files and images to appropriate folders and directories.
Pioneer Natural Resources May 2017 to April 2018
OnBase Consultant
Irving, TX
OnBase Consultant for Pioneer OnBase Support.
Maintained daily OnBase processes for Land Department.
Worked with the Land Department staff on Unity Client issues and OnBase Workflow issues.
Set up and Installed Kofax and VRS scanning processes to enter OnBase repository through DIP process.
Worked in OnBase Configuration creating new Document Types, Keyword Types and Folder Types
Wrote numerous Ad Hoc tasks for multiple workflows.
Created Autofill Keysets with SQL queries and Web Services.
Wrote and ran registry scripts to create User Profiles and maintain consistency for all OnBase Users.
Created print Ad Hoc tasks with API Unity Scripts and FoxIt Application for different workflows.
Created an Auto Redaction Process and an Auto Redaction service to remove personal info from various documents with regular expressions.
Assisted in OnBase 16 to OnBase 17 upgrade.
University of California, San Diego November 2016 to May 2017
OnBase Consultant
La Jolla, CA
OnBase Consultant for UCSD EPIC/ONBASE integration build.
Upgraded USCD OnBase System from OnBase 14 - OnBase 16 and OnBase 16 - OnBase 16.0.2.71 (both test and production)
Upgraded Application Servers, Web Servers, Disk Group Servers, Processing Servers and OnBase SQL database. Installed all OnBase software (Advanced Capture, Front Office Scanning, DIP, etc…), OnBase applications (Configuration, OnBase and Web Client, Studio,etc..), configuration files, digital signature suite, disconnected scanning workflow and set up, encryption. (both test and production)
Installed Microsoft Windows Server 2012 R2 Standard and configured IIS to run Application Servers and Web Servers. (both test and production)
Wrote custom queries for Report Services, Unity Client, and OnBase Studio.
Created multiple Advance Capture Templates.
Designed and automated multiple DIP processes. Wrote scripts converting unstructured data into structured data that could be used as keywords during DIP ingestion.
Created and Configured Disk Groups, Document Type Groups, Document Type, Keyword Type Groups, and Keyword Types. Installed Distributed Disk Services on Disk Group Server
Set up HL7 services and set message input and output.
Set up User Groups and User Groups Rights
Set up all users to use AD account login into OnBase.
Workstation registration for OnBase licenses.
Blue Cross Blue Shield of South Carolina September 2015 to September 2016
OnBase Consultant
Nashville, TN
Worked on the Appeals Solution at Blue Cross Blue Shield. Used OnBase 15 Workflow and Workview to track workload end to end activity for CMS.
Worked on J15 RADAR Phase 2 creating numerous Doc Comp letters for ReOpenings, Overpayments, Claims and Appeals.
Used DIP to archive large volumes of files and index the corresponding metadata.
Used OnBase Unity Client, OnBase Configuration, OnBase Client and Onbase Studio to complete complex, multi-department business processes.
Developed VBScripts, Custom Queries and Unity API Scripts to be used within the Onbase Systems.
Designed and Implemented EForms, Sort Forms & Unity Forms to collect and manipulate data.
Developed Workview solutions with Workview designer using classes, filters, actions and views.
Created ad hoc tasks, rules, actions, rules to route documents through queues and lifecycles.
Used log tables to create maintenance reports like concurrent users, failed logins, duplicate case/claims, manager privileges, Delete/Update/Add privileges
Created letters/templates/fragments with Doc Comp. Ingesting document data from keywords, XML, Queries and Doc fragments.
Designed lifecycle ingestion and routing logic from scanners, fax, CD, Web portal documents.
Worked with the Workflow Timers Service to execute timers for multiple queues and across multiple lifecycles and monitor timers.
First Merit Bank August 2015 to October 2015
OnBase Consultant
Akron, OH
Writing SQL queries, functions and procedures to produce numerous reports for the OnBase Report Services Module.
Design OnBase reports from specs. Map specs against the OnBase database and create workflow and workviews to populate keyword (keyitem, keyxitem, keysetdata, keytable) tables.
Calculate parameters and data points to return precise data
Monitor eForms and uForms to verify keyword population for testing data.
Work with end users to examine big data datasets resulting in OnBase Reports being imported to Report Services Client for authorized vendor/usergroup consumption.
University of Illinois Foundation July 2006 to July 2015
Senior Application Developer (OnBase)
Urbana, IL
Implemented new OnBase EDMS and new BlackBaud CRM systems for the U of I Foundation.
Accessed Onbase APIs through VB.NET and C# for several Onbase projects.
Lead the team to convert all legacy documents (over 10 million) into the new OnBase system and maintain the work from our legacy ECM.
Intergraded Banner and XML to create real-time Word Documents for donor information to assist in gift development
Use Banner data with AS400 to generate reports for specific area and demographics based on filters requested by the gift developer.
Collaborated, designed and developed numerous OnBase Workflows like Travel Voucher, Leave/Vacation requests, New Employee Orientation, etc.
Configured numerous OnBase Work Views to display requested data, query results and populate Eforms.
Configured OnBase Doc Pop and Unity Pop objects to display OnBase Documents in BlackBaud CRM and numerous other UIF applications.
Developed multiple VB.NET client applications and ASP.NET web applications during the Brilliant Futures Campaign that surpassed the original goal of 2.5 Billion dollars
Used Visual Studio VB.NET and C# to design in the MVC platform and wrote, tested, and debugged the code
Created and maintained the first Orange Krush website that has resulted in 4.5 million dollars
Wrote the Make-A-Gift application that used AS400 donor information and .NET technologies that has brought in over 65 million dollars using Windows Services and Web Services to interact with Paypal’s APIs.
Developed multiple file sharing web applications (Files and Reports/Briefing Sheet and ID Profiles) to assist in research and support development officers when they are in-the-field and need access to donor data
Helped design the company’s document manager and records manager before the purchase of OnBase
Wrote a search engine for UIF Online
Developed a Payroll Deduction application to assist in the reconciliation of U of I Payroll Deductions
Maintained and enhanced UIF’s Record Manager Application, Training website, Gift Transmittal website and numerous other UIF sites and applications
Redesigned SQL views, functions, stored procedures and table structures for greater efficiency
Generated multiple reports with Crystal Reports and Reporting Services
Health Alliance Medical Plans June 2000 to June 2006
Web Developer
Urbana, IL
Created Health Alliance Medical Pans first Web Site MCNET public internet and private intranet
Created MCNET with XML/XSLT/XPATH/XQUERY logic, plus SQL, LINQ, AJAX, .NET and the AS400 iSeries
Wrote SQL and HTML so other developers could access data and providers in the area
Created MC .NET done in XML and XQuery to create a web portal where members could access their claim data
Served as a mentor to other developers
Contributed to the hiring and performance management of other developers
Worked on Health Alliance Medical Plans new interactive health web site by using Visual Studio, MVC.NET, and ASP
Developed the Custom Choice “Get A Quote” website
Solo Cup Company September 1997 to June 2000
Benefits Coordinator
Urbana, IL
Served as a Client and Project manager of hosted Cloud Services inclusive of hosted VoIP and hosted email systems
Completed successful hosted VoIP implementations over 1000 desktops
Completed successful hosted email implementations over 10,000 mailboxes
Acted as single point of relationship management for District Superintendent
Marketed the voice product offering to teachers and staff at all District locations
Improved and implemented new training process for desktop phone system
United States Navy June 1989 to June 1992
Disbursing Clerk
Alameda, CA
Processed daily financial returns and reports for PSA Treasure Island, Calculated enlisted/officer payroll
and kept 2000+ military pay records up to date.
Worked as the only Military Personnel in the NAS Alameda fiscal office. Handled 90% of check production for NAS Alameda. Calculated travel per diem, advanced pay, separation pay, etc.
Participated in the establishment and demobilization of 2,550 recalled Desert Storm reservists.
Education and Certifications
EDUCATION:
University of Illinois 1993 to 1997
Bachelor of Science in Program Management
Champaign, IL
CERTIFICATIONS:
OnBase Certified Application Programming Interface
WPF and Silverlight
References
Joseph Canter
IT Manager
University of California, San Diego
6333 Greenwich Dr.
San Diego, CA 92122 858-***-****
*******@****.***
Bill Reynen
Chief Technology Officer
Callibra, Inc
Suite 838
150 N. Martingale Road
Schaumburg, IL 60173 847-***-****
*******@************.***
Naneera Vidhayasirinun
Director of IT Application Development
University of Illinois Foundation
507 East Green
Champaign, IL 61820, mc-415 217-***-****
*******@*******.***