ANDY LEE

Chino Hills, CA *****

714-***-****

adnaoh@r.postjobfree.com

https://www.linkedin.com/in/leea63

CAREER

SUMMARY

Information Technology professional and Certified ScrumMaster (CSM) specialized in leveraging large-scale business solutions for enterprise environments. Demonstrated achievements in business systems analysis, leadership, project management, and application development while incorporating Agile practices to optimize the value of deliverables.

PROFESSIONAL EXPERIENCE

Unibail-Rodamco-Westfield (Consultant, Insight Global), Los Angeles, CA Aug 2020 - Present

Product Owner/Senior Business Systems Analyst

Maintained product ownership of corporate data warehouse, reporting platform, and data dictionary

Collaborated with Corporate Data Governance team to align US and Corporate metrics and definitions

Prioritized product backlog for business intelligence initiatives

Prepared functional and technical designs for reports, dashboards, and ETL processes

Designed and maintained user support for Tableau dashboards and user stories

Delivered ad hoc data requests against relational data stores using advanced SQL queries

Prepared test plans for new data warehouse requirements, reports, and dashboards

Conducted UAT sessions for reports, dashboards, and ETL processes

Key Accomplishments:

Served as Product Owner to deliver key Business Intelligence initiative to present Key Performance Indicators (KPI) for retail commercial real estate leasing activities. Metrics included deal counts, capital commitments, leasing revenue, revenue exposure, and occupancy statistics. This initiative also expanded the existing data model to include annualized contract amounts at signing in addition to actual ERP cash flow. Dashboards were delivered on a Tableau platform consuming data from JD Edwards EnterpriseOne and Salesforce.

Led Reporting initiative to realign bad debt tracking on commercial real estate leases with newly adopted SAP PlanIt Ops system. As part of the PlanIt Ops implementation, a new sub ledger was created to allow tracking of bad debts with additional accuracy and granularity. This initiative included collaborating with key stakeholders to identify requirements for Business Objects report revisions and manage development and support efforts.

Big 5 Sporting Goods, Riverside, CA May 2017 - Apr. 2020

Lead Oracle Business Systems Analyst

Maintained user support for merchandising, distribution, and store functions within Oracle Retail Suite

Prioritized backlog items for support processes to reflect stakeholder requirements

Conducted system analysis through advanced SQL queries, PL/SQL procedures, and code review

Prepared functional designs, test plans, and user stories for process and application enhancements

Managed application support tasks and supervised appropriate support teams as required

Collaborated with stakeholders and Business Intelligence team to source data requirements

Investigated support items and identified vendor support escalations

Analyzed user impact and test results for revisions, upgrades, and patches

Completed implementation tasks for training, pilot, and deployment

Key Accomplishments:

Increased enterprise operational efficiency, significantly improved customer experience, and established the foundation to accelerate growth in both traditional retail and e-commerce business segments through the successful implementation of Oracle Retail Suite and Oracle Point of Service (ORPOS) as a key contributor in a collaborative team effort. Primary focus involved business process integrations for in-store and merchandising operations.

Served as Product Owner for Oracle Store Inventory Management (SIM) support backlog. Responsibilities included collaboration with stakeholders, prioritizing backlog items, evaluating system integration solutions, coordinating with off-shore technical resources. Key functional areas included distribution, bill of lading (BOL), advanced shipping notices (ASN), item maintenance, inventory adjustments, firearm UIN management, pricing issues, and application integrations.

Minimized gross profit loss margins and reduced support overhead by standardizing business processes for merchandising and pricing. This initiative identified the root causes of common merchandising and pricing inconsistencies across Oracle Retail Suite and Oracle Point of Service (ORPOS). Solutions included devising strategies to resolve existing issues and implementing support processes to resolve further discrepancies.

AECOM, Los Angeles, CA May 2009 - May 2017

Senior Oracle E-Business Suite Systems Analyst

Maintained user support for Oracle Project Accounting, Financials, and HRMS processes and reports

Supported Oracle data conversion and system integration for Project Accounting, Financials, and HRMS

Conducted system analysis through advanced SQL queries, PL/SQL procedures, and code review

Led initiatives and delegated tasks as required, applying Agile practices where applicable

Prepared functional designs, test plans, and user stories for process and application enhancements

Engaged in Oracle Project Accounting revenue recognition support and validation processes

Collaborated with stakeholders and Business Intelligence team to source data requirements

Analyzed user impact and test results for process automation, system integration, and configurations

Validated and coordinated change management tasks

Key Accomplishments:

Significantly improved revenue recognition, invoicing, payroll, resource sharing, team collaboration, and data integration by leading multiple data conversion initiatives for major business segments across multiple geographies. This fully integrated each business segment’s Project Accounting, Financials, and HRMS functions with Oracle E-Business Suite. Responsibilities included collaboration with stakeholders and technical teams to delegate tasks, review requirements, refine processes, prepare data, and approve totals.

Consolidated Human Resource business processes and eliminated unnecessary redundancy by leading initiative to combine major HRMS reporting functions and data interfaces for Oracle HR, Payroll, and OTL into a central process. This increased the efficiency of integrating Human Resources business segments into Oracle E-Business Suite and reduced the amount of customization.

Migrated Oracle E-Business Suite from 11i to R12 as a key contributor in a collaborative team effort. This primary focused on identifying the impact of R12 schema and rule changes on Oracle Project Accounting, AP, AR, and HRMS process and reports. This included incorporating Oracle sub-ledgers into AP and AR reporting.

Implemented positive pay solution for employee and supplier procurement. This included collaboration with stakeholders and banks to determine data requirements and EDI file formats, defining validation rules, and negotiating security policies between banks and network security group.

Facilitated core business project planning and achieved improved cost management by piloting and supporting automation processes for Oracle Project Accounting, AP, AR, and HRMS modules. This included implementing processes for batch transactions and supporting configurations. Configurations consisted of flex fields (DFF), AP supplier setups, AR customers, and HRMS special information types (SITS).

Tetra Tech, Pasadena, CA Dec. 2000 - Jan. 2009

Senior Applications Developer

Developed and supported processes and reports for Oracle Project Accounting, Financials, and HRMS

Designed system integrations between Microsoft SQL Server solutions and Oracle E-Business Suite

Implemented distributed Component Services architecture and APIs for ASP web applications

Maintained support for Microsoft SQL Server solutions and ASP web applications

Administered change management solution for transactional change requests and SDLC

Collaborated with functional teams to prepare technical designs

Key Accomplishments:

Delivered enterprise change management solution in compliance with Sarbanes-Oxley requirements by leading functional design and technical development efforts in collaboration with Ernst and Young internal audit. This featured approval workflow and audit records between Software Developers, Business Analysts, Project/Functional Management, and Database Administrators for transactional change requests and the Software Development Lifecycle (SDLC). SDLC workflow included multiple approval phases for planning, testing, and staging software releases.

Designed and implemented business processes to integrate external payables bank transactions with Oracle AP. Processes included Lockbox, ACH Direct Deposit, 401k Deductions, and Positive Pay check pre-registers. This required managing the collaboration between Fiserv Health Services and business segments external to Oracle E-Business Suite.

Successfully implemented Cognos business intelligence solution for Human Resources indicative data and benefits as a key contributor in a collaborative team effort. Responsibilities included the project planning, functional analysis, and data modelling.

Delivered invoicing solution for custom construction management tool. This included developing interfaces that integrated Oracle Project Accounting with Microsoft SQL Server and coordinating incremental data synchronization schedules.

Designed and developed APIs using distributed Component Services architecture for Microsoft SQL Server solutions and ASP web applications. This streamlined Microsoft SQL Server database connectivity for improved system performance, integrated application security with Windows Active Directory, and established the platform for rapid application development.

EDUCATION

Bachelor of Arts, Economics Sep. 1998

University of California Irvine

PROFESSIONAL

CERTIFICATION

Certified ScrumMaster (CSM) May 2020

Scrum Alliance

SKILLS

SUMMARY

ERP Solutions: Oracle E-Business Suite (Project Accounting, Financials, HRMS); JD Edwards EnterpriseOne (Real Estate Management); Oracle Retail Suite (RMS, SIM, RPM, RM, BO, CO, ORPOS, Xstore)

Cloud Solutions: Salesforce

Relational Databases: Oracle 12C, R12, 11i; Microsoft SQL Server

Business Intelligence: Tableau, Snowflake, Oracle BI Publisher; Oracle Reports; SQL Server Reporting Service; IBM Cognos

Tools and Technologies: PL/SQL; XML; Visual Studio.NET; VBA; Java/JavaScript; Oracle SOA

Collaboration Tools: Jira, Microsoft Teams

Related IT Skills: Business System Analysis; System Integration; Project Management; Agile; SaaS, User Stories; Backlog Management; Requirement Gathering; Functional/Technical Design; APIs; TFS; Visio; Toad; SQL Developer; EDI; ETL; Data Modeling; SQL Tuning; AIX; Change Management; Software Development Lifecycle

Language Proficiency: English; Mandarin Chinese

REFERENCES

References available upon request

Contact this candidate