Brian Lee Email & Phone Number

Irving, Texas

• Enable customized sourcing analysis utilizing an Excel add-on reporting tool, while organizing initiatives within specific product categories for individual network such as NPC.• Analyze PO line-item data submitted by the members to determine current product usage & cost through data mining, cross-referencing, and pricing application, incorporating contract details, benchmarking, and clinical considerations.• Maintained the pricing creation from internal analyst and supplier upload. Validated the price data flow into Vizient catalog• Demonstrate ownership of data collection, collaborated with the internal and sourcing team, highlight the potential saving opportunities, and help drive informed sourcing decision.• Utilize advanced formula usage, data cleansing and structured query language (SQL) detect data discrepancies and propose effective resolutions.

Irving, Texas

• Work in SAP and create comparative scenarios with multiple products across multiple vendors and contracts to capture savings opportunities• Maintain the contract creation and managing the daily tasks for price data flow. • Perform Remedy ticket research utilizing SQL and data analysis techniques to identify data issues and recommend viable solutions• Analyze member competitive pricing detail through Emptoris sourcing application and SAP.• Assist in developing custom automation solutions based on business needs for senior management, internal analyst and customers• Defect Management Tool Adoption – able to work from the ground up in a project

Dallas/Fort Worth Area

• Manage quality assurance process for all member spend analysis and reporting• Create moderately complex test scenarios and perform in verification efforts to resolve issues and test new processes• Perform Remedy ticket research utilizing SQL and data analysis techniques to identify data issues and recommend viable solutions• Help refine reports in Excel, SSRS or Tableau for external department use (ad hoc requests)• Produce and analyze member competitive pricing requests• Ability to gather, understand and interpret monthly KPI metrics and reporting• Analyze the spend/invoice data for member competitive pricing request and create Access report for senior management.

Dallas/Fort Worth Area

• Evaluate members file submission and ensure data requirement for system processing. • Perform monthly/quarterly audit schedule for individual members and network.• Collaborated with members, Sales, and internal team member to maintain the audit progress.• Report to team manager regarding the audit performance, data issues and new concept for audit improvement.• Understand the internal data processing and provide documentation of audit procedure for future reference.

Dallas/Fort Worth Area

Recovering audit and analyze pricing for retail expenses. Review clients data, contract and Po/Invoice history to find the correct pricing through out the season.

Dallas/Fort Worth Area

Freight forwarder experience with shipping line and railroad. Process shipping orders from door to door and providing report records for all shipments.

Processing PO and monitoring production schedule. Communicated with vendor and factory for production progress.

Certification, Berkeley Data Analytics Boot Camp

Activities and Societies: Integrate SQL, Python and Excel Data Workflow Optimization Automation of Data Processing Tableau with Dashboard.

Bachelor'S Degree, Fiance

Finance