Robert A. Wilhelm

**** ********* ***, **********, ************ 19081 610-***-**** - adjru3@r.postjobfree.com

www.linkedin.com/in/robert-wilhelm-msis-msais-cisa-43b1587

PROFESSIONAL PROFILE

Senior business/clinical technology analyst with expertise in business, supply chain, clinical systems, data governance, project management, auditing, change control, quality assurance, user acceptance testing, reporting, process engineering, programming, master data and records management, contingency planning, data base modeling and application implementation, administration and development.

Software - Lawson ERP, Baan ERP, Macola ERP, SAP, Soarian, Kronos, MS-Office,

Languages & Tools – SQL, SAP Business Objects, Crystal Reports, SSIS, SSAS, SSRS, JIRA, ITIL, Visual Basic, Micro Focus Cobol, COBOLII, CICS, PL/SQL, OLAP, HTML, XML, EDI, ARIS, Rational Rose, HL7, TSO/ISPF, JavaScript, Visio, UML, Oracle Loader, Erwin

Databases – Teradata, Oracle, SQL Server, Hadoop, VSAM

Certifications – Certified Information Systems Auditor, SAP recognition, Six Sigma Green Belt

Adjunct Business IT Professor at Rosemont College

PROFESSIONAL EXPERIENCE

Consultant Accolade Corporation, Plymouth Meeting, Pa. 08/20 to Present

Create and modify SQL programs for a health insurance data warehouse schema.

Support and enhance data warehousing ETL flows and operational processes.

Perform data profiling, source to target mapping and audit data quality to ensure accuracy and security.

Work in partnership with staff to model data structures/mapping documents for new clients and operational efficiencies.

Data Management/Warehouse Analyst Trinity Health Systems Newtown Sq., Pa. 07/13 to 08/20

Maintains data warehousing systems and data governance standards for a corporate hospital system.

Support data governance standards that comprises of consumers, processes, usage, controls and technologies required to manage and safeguard data assets for a hospital system entailing of 92 inpatient entities and consisting of 22 locations.

Evaluate the design, implementation and monitoring of data accessibility controls providing improved ETL flows.

Maintain a SQL Server data warehouse that supports transactional and dimensional models providing next day data revisions.

Create SQL programs/functions, support reporting and analytical requests for business intelligence requirements and regression analysis that resulted in process enhancements and patient safety improvements.

Provide ongoing analysis, administration, security, ETL, data management maintenance and user support that maintains service level agreements.

Prepare and develop enterprise software and data for implementation in agreement within project time lines and budgets.

Collaborate with corporate staff modeling data extracts for corporate cost reduction projects and operational efficiencies.

Model validation and analyze data using SQL for external application data feeds for regulatory and HIPAA requirements.

Application Analyst Kennedy Health Systems Cherry Hill, NJ 08/11 to 07/13

Support an enterprise electronic medical records system for a three campus hospital facility.

Provide support and auditing for data policies, standards, procedures, and controls to ensure the confidentiality, standards, integrity and availability of information assets.

Create and support reporting requests employing Crystal Reports and writing SQL programs resulting in the increase of patient safety, process improvements and cost reductions.

Certify the validity, testing and quality of data extracts reducing extract times and data quality errors.

Augment and verify interfaces, reports and decision logic. Test enhancement assignments and resolve user issues.

Manager of Software Development Paychoice Corporation Moorestown, NJ 06/10 to 07/11

Prepare and administrate programming projects, ensure the adherence to Agile and SDLC processes and time lines.

Ensure completeness and quality of software releases improving installation times and user acceptance.

Maintain SQL programming projects, program and test enhancement assignments and direct the resolution of client issues.

Developed client integration programs utilizing FTP and web services reducing transmission times and increasing data quality.

Senior Business Analyst Siemens Medical Solutions, U.S.A., Malvern, Pa. 04/02 to 12/09

Advanced (from Senior Software Engineer) to Senior Product Analyst to head the development effort of integrating and enhancing processes and user interface designs within a .NET environment.

Developed user requirements, testing, revisions, enhancements and customer support issues for cardiology, patient/bed management, management of materials and admission applications.

Developed user acceptance tests and confirmed requirements agreed with design specifications.

Created business objects, data entry interfaces, SQL stored procedures and managed data analysis utilizing Agile methodology, Java and SOA

Employed domestic and off shore resources to determine requirements and developed web/SQL based reports.

Lead work flow and data requirements efforts using Crystal Reports to provide data metrics and audit controls.

IT Director L3 Communications Corporation, Philadelphia, Pennsylvania 03/98 to 04/02

Advanced (from Business Analyst / Finance Applications Project Manager) to IT Director. Managed and participated in the application development, data mapping, user interfaces, logical and physical data modeling, data base management, release/change control, contingency planning, IT operations, records management, metrics, quality assurance standards, As-Is To-Be work process studies, third party software enhancement, transition, implementation and production support for a multi-site Financial and Payroll/HR systems.

Business liaison elicited, developed and documented user’s financial and accounting requirements from multiple levels of management.

Implementation project manager delivered a Financial/CRM/MRP system within project scope, cost and schedule.

Supported, coordinated and designed data integration processes and data governance.

Technical project manager that improved production scheduling, change management, IT operations, capacity planning, lowered inventory levels and enhanced financial reporting.

Investigated and reconciled data discrepancies and testing of enhancements.

Developed and programmed contract costing and financial analysis objects for government defense program studies.

Mined financial, engineering and manufacturing data to reconcile audit issues

Extracted financial data and created data marts for in-depth financial analysis and reports for the propose of developing strategic plans and business cases

Accurately mapped, modeled, scrubbed, documented, migrated, validated and converted data into an Oracle data base.

Coordinated and participated in As-Is To-Be studies and evaluations.

Designed material control processes and computer programs that resulted in reducing inventory levels and obsolescence by 30%.

Analyzed, created functional documentation modeled data (logical/physical) and produced programming requirements to validate work flow processes.

Passed internal audits, developed contingency processes, created system documentation and processes per SOX standards.

Senior Analyst / Software Engineer Wyeth-Ayerst Corporation, Malvern, Pennsylvania 02/96 to 03/98

Analyzed, modified and user acceptance/system tested programs for the Y2K conversion and FDA validation of a MRPII system.

Provided Y2K compliance, met FDA regulations and provided uninterruptible application service to five sites.

Analyzed inventory strategies and ordering policies that resulted in logistical and cost improvements.

Manager of MIS Applications SPD Technologies, Philadelphia, Pennsylvania 04/85 to 01/96

Advanced (from Supply Control Management Systems Analyst) to Manager of MIS Applications to direct maintenance and development of batch transactional and real time financial, marketing and manufacturing systems and data bases.

Created a real time labor reporting and material movement system.

Designed inventory management cycle counting system that increased accuracy 25% and reduced costs 15%.

Implemented, tested and administrated procure to pay process and implementation.

Implemented, tested and administrated Lawson financial and accounting applications.

Developed, wrote and tested costing applications for pricing and resolving accounting audit issues.

Lead several financial, inventory control and manufacturing initiatives that improved production scheduling, lowered inventory levels, achieved cost savings and enhanced financial reporting.

EDUCATION

M.S. Accounting Information Systems - Widener University - Chester, Pennsylvania

M.S. Information Systems - Drexel University - Philadelphia, Pennsylvania

B.S. Business Administration - Drexel University - Philadelphia, Pennsylvania

Contact this candidate