Lai Wang
Cleveland, OH
********@*****.***, 216-***-****, https://www.linkedin.com/in/lai-wang-0594137a/
Oracle Solutions Architect
Oracle EBS Implementation, Global ERP Enhancement, and Cloud Integration
Accomplished Oracle ERP professional with over experience of full lifecycle implementations, global rollouts, and system enhancements across Oracle E-Business Suite R12 and Oracle Fusion Cloud. Recognized for bridging technical expertise with business needs to deliver reliable, scalable ERP solutions that drive process efficiency, data integrity, and operational excellence across finance, supply chain, and manufacturing. Skilled in PL/SQL, Oracle APIs, and integrations, with a proven record of leading data conversions, optimizing performance, and supporting enterprise-wide digital transformation in complex, global environments.
PROFESSIONAL EXPERIENCE
SHERWIN-WILLIAMS CORP IT, Cleveland, OH
Sr Full Stack Application Developer, Enterprise Platform Deliver Team 2024 – 2025
Oracle Fusion Cloud BIOS Project using Oracle Cloud OIC, BIP Reports, PowerApps.
SOA Upgrade Project.
IT Developer Lead, Global Supply Chain IT 2019 – 2023
Oracle ERP Support and Enhancement. Develop, test, and maintain PL/SQL code including packages, functions, procedures, cursors, views, and tables used in company’s ERP system and applications. Perform job scheduling, data analysis and modeling, SQL tuning, report enhancement, etc.
Work and coordinate with business users, local IT and functional teams, assist users with their problem and issue solutions, provide timely technical support and deliver the solutions.
Work on many support projects and enhancements that helped many international and domestic divisions to be efficient, operational, and successful in completing their tasks on time.
Sr IT Developer, Global ERP Team 2010 – 2018
Oracle ERP Implementations globally in APAC, LATAM and EMEA for approximately 25 sites.
Lead Data conversion activities: creating staging tables, validation programs, and data migration from legacy systems.
Design, develop, and maintain complex Oracle PL/SQL packages, procedures, functions, triggers, and cursors.
Conducted unit testing, CRP, SIT, UAT testing and go-live cutover testing.
Closely work with functional team and business users to gather requirements, work with DBA and PPM team for tech object migration.
Design documents preparing MD50 & MD70, conversion program development.
Post go-live support and troubleshooting.
Global Blending project and applications, as report track lead.
IT Developer, Sherwin Automotive Division IT 2006 – 2009
Using Oracle Forms and Reports to customize many technical objects in Oracle EBS applications to meet user requirements.
PL/SQL Custom programs development, concurrent programs setup in Oracle EBS systems.
ADDITIONAL RELEVANT EXPERIENCE
KEAN CONSULTING, Detroit, MI, Oracle Developer
ADVANCED INFORMATION SERVICES, Peoria, IL, Oracle Developer
EDUCATION
Master of Science (MS), Engineering, Marquette University
BS, Mechanical Engineering, Shandong Polytechnical University, China
CERTIFICATIONS
Oracle Cloud Infrastructure (OCI) Certified Foundations Associate, 2023
Oracle Developer Certification (Forms/Reports/SQL/PLSQL), 1999
SKILLS
Expertise in PL/SQL, SQL, Oracle APIs and Open Interfaces
Oracle EBS R12 Architecture, modules of finance (GL AP AR FA), SCM (PO OM INV MRP), OPM manufacturing (GMD GME QC CST)
Oracle Forms, Reports, BI and XML Publish, Concurrent Programs, OAF, ADF, Workflow
Tools: SQL Developer, Toad, JDeveloper, SQL Plus, SQL Loader
Oracle Cloud, OCI, OIC, BIP Reports