Jeffrey Herman

Jeffrey J Herman Profile Self-driven Software Engineer with strong interpersonal skills and deep Oracle PL/SQL programming experience. Excellent verbal and written communication skills. Strong analytical, evaluation, and interpretation skills. Exceptional organization and attention to detail. History of positions of increasing responsibility. Technical Competence Knowledge of: Programming languages: SQL, PL/SQL, VB, C#, .NET, Perl, XML, CSS, ASP.NET, HTML, Java Databases: Oracle 11g/18c, SQL Server, PostgreSQL, MS Access. TOAD, Salesforce, Smartsheet, SourceGear Vault, JAMS, Oracle ODI, MS Office Tools, Experience: United Physicians August 2014 to Present Bingham Farms, MI Application Analyst Programming, software development, documentation, business analysis, healthcare data management and troubleshooting, database storage and retrieval. Develop and maintain incoming Health Plan membership, claims, and pharmacy feeds into our Oracle environment; standardizing all variables between plans. Developed SDLC description and approval documentation, including Daily Scrum, Business Analysis, Technical Design, Turnover, and Implementation documents that were adopted department wide. Created and quarterbacked the execution of a 443-step conversion process, moving production and development databases to new Oracle ODA servers. This synchronized the work of six team members and included exception handling. Approved Technical Design, Turnover, and Implementation documentation for colleagues. Authored VB and Java sections of the Programming Standards initiative. Managed two on site contract workers through a six month project. Maintain communication with clients to gather requirements, perform User Acceptance Testing, and make any adjustments. Completed outside courses on Oracle Database Tuning, Oracle ODI, and Optum analytic systems. Huron Valley Physicians Association February 2012 to August 2014 Ann Arbor, MI Database Programmer Reporting, documentation, software development, healthcare data management and troubleshooting, database storage and retrieval. Developed dashboard to track all incoming automatic provider and payer feeds. Developed custom applications to mine pharmacy, claims, meaningful use, financial, and pay for performance data. Developed Data Report Requirement specifications template to streamline reporting process. Extended internally developed patient registry to provide additional data sources that required integration of multiple unrelated systems. Developed many algorithms to identify bad claims data and identified ways to resolve them in the team of programmers and clinicians. Jeffrey Herman Consulting, Inc. November 2010 to January 2012 Livonia, MI Consultant Reporting, documentation, web application development, medical record data conversion, database storage and retrieval. Worked with local area company that was developing a system to read office Patient management systems, claims output, and scheduling data. Designed and implemented MSWord based system using OLEDB, C# and word integration for business reports. Member of development team delivering a custom data management and mining application encapsulating reports, data cleansing, and data consolidation. Developed documentation procedures and systems for the GLP environment. MS office add-in Database reporting system. Migrated legacy applications/code to support Windows Vista/Windows 7 UAC security. Developed custom solutions for reading legacy text extracts into a common format to aid customer in rapid migration of systems. The Bartech Group February 2008 to October 2010 Bingham Farms, MI Technical Recruiter September 2008 to October 2010 Full cycle recruiting for Pharmaceutical, Clinical, Professional, Automotive, and Engineering clients. Penetrated three new accounts in a stringent economic climate. Retiree Coordinator February 2008 to August 2008 Find, contact, and survey 1500 retirees in a call center setting; audit customer compliance requirements for retirees; assist in various project for other Bartech teams. Improved status tracking method leading to a 14% increase in overall group success rate. Performed data scrubbing which improved overall group accuracy 1.38%. Education Bachelor of Arts: English Concordia University, Ann Arbor