Guoping Liu Email & Phone Number

Chicago, Il, Us

Chicago, Illinois, United States

Support and Manage business interface solution such as Mass Add, Mass Maintenance, Related ItemPerform EDW architectural design and ETL development while maintaining consistent data load performance across new or existing infrastructureDeliver technical design, estimation for feature elaboration working closely with business owners, business analysts, and other relevant teamsIdentify and recommend changes to drive continuous improvement in quality, efficiency, and ongoing consolidation of data sourcesDesign and Develop key business product tracking architectural infrastructure solution with third party corporations such as UPS apiCollaborate with test teams to ensure delivery of global solutions on timeOngoing personal development to increase awareness of key emerging technologies helping improve business operation efficiency such as Azure and Big Data

Greater Chicago Area

Responsible for the development of enterprise, master and domain data models for usage in a metadata tool for on-going data management including ad-hoc requests; projects; programmers and requests for work. Participate in development of standard IM processes to support ongoing maintenance of master data, enterprise data model, strategic domain data models and linking of our models to data quality attributes. Collaboration with GIS/IT and all specializations within Information Management for continuous improvement of data governance processes, procedures and usage. • Develop data management processes and measurements to meet global strategic and business requirements.• Develop, create and maintain technical (i.e. data models, data transformation, data logic, and data rules) documentation; manage model exceptions and/or collaborate on data models with SMEs as required; Create Logical and Conceptual Data Models Manage enterprise model updates as required by projects• Creation and maintenance of interface tools that upload data to the AS400 or SQL Servers, such as Mass Add, Mass Maintenance, Related Item Load, and STEP Sku Create Spreadsheet.• Collaboration with SMEs and RFWs/Programmers of work to design conceptual, logical and physical models/processes to adhere to data governance practices; escalate potential data governance issues.• Stay abreast of information security policies, data quality industry best practices, and metadata tool features and functions.• Create analytical routines to identify data gaps exceptions/errors and create and maintain data extracts and data imports to various systems.

Greater Chicago Area

Process external files for product data (commercial and product attribute data) from suppliers, third parties and other sources into the SQL Servers and/or AS400 (via approved user interface methods) and/or STEP. •Analysis of data provided to determine mergeability with existing data•Mapping and transformation and loading of disparate data•Identification and creation of validation rules•Assume overall responsibility for ICG’s automated jobs•Creation and maintenance of interface tools that upload data to the AS400 or SQL Servers, such as Mass Add, Mass Maintenance, Related Item Load, and STEP Sku Create Spreadsheet,•Loading of internally created data sets•Manage user security on the SQL Server for ICG and Production DataCreation of analytical routines to identify data gaps exceptions/errors•Tracking and reporting of submitted data receipts, loads and error counts•Interface with local or global business users (e.g. Product Management, EAP, or Item Content Group, Asset Management, Resale Pricing, etc) on establishling business rules and implementing those rules as automated jobs. •Create and maintain data extracts and data imports to various systems including the STEP system•Produce recurring reports from SQL Servers, AS400, or STEP for business users

Chicago, Illinois

• Develop SQL objects such as database, views, procedures, functions, triggers• Design, rewrite and maintain Mass Maintenance Tool to improve performance efficiency• Optimize performance efficiency for various Excel applications, SQL jobs, working processes • Implement Business Processes such as Do Not Sell Tools, automation of Price File Process• Develop SSIS, SSRS as business needs• Maintain and troubleshooting STEP Product Module Marketing Sequencing Tool • Maintain and improve data integrity by utilizing data validation and user access to different department application• Work with the IT department to design, maintain, and test special project applications• Work with sister company to distribute data between servers• Work with Product Management and Marketing teams to design, develop and maintain an application to improve Product Selection for marketing efficiency (PM-Product Selection Marketing Tool)• Perform monthly vendor audits on key financial fields in our Accounts Payable department• Work with other teams (Product Management, Product Authors, Quotes, International Trade Compliance Team, Purchasing, Warehouse, Finance, etc.) in order to assist with application issues, product information issues, and any other questions and issues regarding Item Content • Assists others such as generating HTML files for internal intranet pages• Develop Web Application as business needs

Chicago, Illinois

• Specialized and handed large pricing data files from various vendors• Evaluated vendors’ website to capture precise product information (packaging, unit of measure, etc) • Communicated with vendors to acquire necessary information• Worked with various internal departments to resolve issues with incorrect data• Load accurate pricing data into company system used by numerous other departments• Analyze and resolve invoice price discrepancy issues• Developed SQL queries to optimize work efficiency• Design and recreate Vendor Description Update SQL automatic jobs to improve work efficiency• Maintained and troubleshooting Mass Maintenance Tool.• (Excel basic tool runs basic on Visual Basic Application that enables company wise users to update mass amount of product information to company BPCS system which feed directly to company website)

Chicago, Illinois

(Restriction of Hazardous Substances) • Collect and upload date RoHS Information into company system from various vendors • Resolved warehouse receiving discrepancies regarding RoHS compliance

Chicago, Illinois

• Data entry with Banner Enterprise Information System (Toad)• Maintain all computers in the office. Including installing, repairing, troubleshooting etc.• Run and distribute reports from database using SQL

Chicago, Illinois

• Assist students in resolving registration problems.• Process student data into school registration system.

Master Of Arts (M.A.), Information Technology, 3.85

Taking Night Time classes.

Bachelor Of Science (B.S.), Electrical And Electronics Engineering

Activities and Societies: Member of Golden Key International Honors SocietyComputer Administrator Operator (AIDE)

Bachelor Of Science (B.S.), Computer Information Systems & Management

Activities and Societies: The Vice President of Chinese Student Club