Andrew Bosch Email & Phone Number

Vancouver, Washington, United States

Modesto, California, United States

Achievement Highlights:* Project Managed colocation of servers, ensuring proper replication, service / application fidelity, continued vendor connectivity and internal network integrity* Developed refreshable Excel spreadsheets for Bookkeeping Auditors that integrate with AS400 (DB2), Oracle, and external vendor feeds, replacing 10 labor hours per week.* Refactored merchandising web portal, replacing Flash UI with Node.js / Bootstrap UI.* Developed automated Rebate Analysis report, integrating multiple IBM i (AS/400) data sources and using heuristics to identify manually entered ledger entries, to eliminate 120 hours monthly from the previously manual process used to pull this data.* Developed Python scripts to extract employee data from HR, compare and update IT security to facilitate off/on-boarding.Experience and Skills:* Node.js, Bootstrap, CSS, Python 3, MS Visual Studio* SQL (Oracle and DB/2), SQL/PL* IBMi Command Line and RPG program interpretationProject and Analytics‣ Project Management‣ Business process documentation and validationLeadership and Communication‣ Communicate to all levels of business‣ Cross-functional teams‣ Facilitate business and team meetings

Modesto, California, United States

Achievement Highlights:* Converted legacy weekly custom vendor billing to daily allowing more flexibility with inventory, audit and financial close schedule.* Delivered solutions to compatibility issues in upgrading from IBMi v6 to v7.3, allowing all financial processes to continue after OS upgrade.* Developed automated extract of all transactions and sales for budgeting software as a service.* Project Managed Real Estate software upgrade, filling all gaps identified from previous solution.* Researched, developed and delivered enterprise-wide application and integration map, showing the details about the servers and applications (costs, business and vendor contacts) and data flows between all servers and applications.Experience and Skills:* IBMi Command Line, profile management, UNIX shell, and DB/2* Infor Infinium financial software* Townsend Alliance FTP and PGP scripting and automation* IT Systems and scripting analysis and job scheduling* Visio and Excel integrationProject and Analytics* Project Management, Business requirement elicitation‣ Process and flow mapping‣ Process improvement and prioritization‣ Test case development and execution‣ Business process documentation and validationLeadership and Communication‣ Communicate clearly and appropriately with all levels of business‣ Collaborate with cross-functional teams‣ Facilitate project team meetingsRetail Industry, Grocery and Finance‣ Billing and Auditing vendor/supplier data feed import/extracts* Pharmacy EDI 835 remittance advice integration with Sales and Receivables‣ Accounting (Receivables/Payables and General), Bookkeeping, Treasury and Real Estate* Logistics and Warehousing support

El Dorado Hills, Ca

Achievement Highlights: * Solved Critical Member Privacy Data Exceptions - 100% accurately matched individual data* Retrofitted Website Compatibility To Support Modern Platform - 100% contracts supported online from new back-end platform* Implemented Custom Web Display Switchboard - 100% support of custom accounts online* Designed Enterprise Benefits Narrative Application - 100% benefits displayed and supported online* Delivered Changes To Support Healthcare Reform - 100% compliance with mandates* Increased National Audit Accuracy - 3% increased national audit score (95% to 98%)* Improved Online Directory Usage - 30% more searches completed* Decreased Facility Claim Reprocessing - 80% reduction in reprocessing for complex claims* Reduced Trouble Ticket Reporting - 80% decrease in ticket rateExperience and Skills:Project and Analytics‣ Business and systems analysis‣ Process and flow mapping‣ Articulating functional and non-functional requirements‣ Agile and waterfall project methodology‣ Process improvement‣ Agile epic and story development‣ Test case development‣ Fit / gap analysis‣ Business process documentation and validationLeadership and Communication‣ Communicate to all levels of business and customer relations‣ Cross-functional teams‣ Proxy for senior management‣ Facilitate business and team meetings‣ Supervision of a 12-member team‣ Training and personnel developmentHealthcare Industry and Public Sector‣ Health plan website production support‣ Supported CalPERS, Federal Employees, Medicare, and Medicare supplemental, Individual and group health plan product life cycle‣ Medical claims EDI and adjudication‣ Escalated customer grievance resolution‣ Compliance with national organizations‣ Online provider directory managementTechnical‣ Enterprise software development‣ Application and database design‣ Large data set ETL from multiple data sources‣ Develop custom data analysis tools‣ XML and web services

Folsom, Ca

* Trained multiple customer service representatives and claims adjudicators in fast-paced 3-month course sessions, in an 8 hour/day classroom (10-15 student) setting.* Audited and provided feedback to team members* Provided leadership to customer service teams* Supported benefits and claims inquiries for custom and priority groups

Folsom, Ca

* Provided customer service as a grocery cashier and service deli clerk.* Achieved 100% in all code testing and showed attention to detail.