Liwei Li Email & Phone Number

Boston, Ma, Us

Burlington, Massachusetts, United States

Data Lake on AWS - developed data lake ingestion ETL framework MVP with Python for Salesforce and on-prem Hive and Hana Datawarehouse with S3, Step Functions, Athena AWS Glue, and CDATA connector.Data Lake Portal on AWS – customized the Data Lake Solution from AWS with CloudFormation, CloudFront, API Gateway, Lambda microservices in Node.js, DynamoDB, CloudWatch Amazon OpenSearch Service, etc

Burlington, Massachusetts, United States

Data ETL workflow for Sales Collaborative Account Plan Data API on AWS – Developed and Deployed the dynamic account plan JSON ingestion pipeline with Python, Pandas, SPARK, and HQL to the on-prem Hadoop data platform. Developed Territory Business Report Tableau writeback API in Python to support the quarterly sales territory pipeline and key pursuits reviews by capturing all user feedback and blending it with reporting data.Acted as the lead developer for the data ingestion monitor framework in Python with Kafka, Elastic Search, and MySQL backend. Created the initial MVP of the root cause analysis (RCA) module with ChatGPT integration. Customized Bookings History API with on-prem SAP HANA XS Engine to support the Collaborative Account Planning app on AWS. Collaborated with requesters from the requirement to SQL code and database and network security provision, Postman API testing, and deployment with SAP Solman. Extended a self-recovering Tableau Sales Commission Dashboard Extract refresh mechanism with Tableau automation API in Python with Flask endpoint wrapper for data ingestion job monitor rules’ engine when failure occurred. Designed and developed a high-performance sales commission data pipeline using SAP Smart Data Integrating (SDI) parallel partitions to replicate commission data safely and promptly between SAP Callidus Cloud and on-premises SAP Hana.

Waltham, Massachusetts

Designed and established the corporate data warehouse and data mart for sales, marketing, and finance with MS SQL Server, and developed the data pipeline among Cloud ERP systems such as Salesforce, NetSuite, and SAP Callidus to on-prem data warehouse. Designed and developed the Qlik dashboards for sales ops, finance ops, and commission analysts to support various business initiatives focusing on ARR metrics around product platforms.

Waltham, Ma

Led the customer data and spatial analytics technology development team to collaborate with other tech teams to create the enterprise GIS technology standards and deploy ArcGIS systems onto shared platforms. Interfaced with the client-facing systems to understand their relevance and importance to the distribution analytics data mart. Customized data pipeline development and implementation when required by LOB. Analyzed and applied sound design and implementation to bring 10-fold speed improvement for the critical features.Performed the retail distribution analytics – Managed Distribution Channel Data Mart and ArcGIS platform. Contributed to the market plan and opportunity model development and distribution network realignment initiatives. Developed and deployed new map layers based on user feedback, supported and trained ArcGIS users. Developed the strategic consulting project with China Construction Bank (CCB) – site selection project: using presentations and hands-on workshops to advise CCB on geospatial data store design and store performance predictive modeling processes. Supported the Consumer and Small Business Customer Data and Analytics: Supported customer channel analytics and Managed the Distribution Data Mart. Developed the ETL data processes from external and internal sources with SSIS and SAS. Worked with BI COE organization to develop and deploy retail distribution analytic packages for IBM Cognos. Developed Customer Diffusion and Dispersion models, channel preference analysis, branch trade area modeling process, and distribution network footprint analysis with SAS and ArcGIS.Designed, developed, and Deployed the Retail Distribution Channel Spatial Data Stores. Created the household level channel usage aggregation table in conjunction with household by site level usage summary cube for the enterprise on Teradata with data pipelines from structured and non-structured data sources.

Lexington, Ma

Assume all technical web design and development responsibilities for the Minerva CRM application used by pharmaceutical sales personnel nationwide. Supported sales and marketing organization reporting needs via Oracle/Oracle Lite, Cognos, Java or SQL and SSRS

Boston, Ma

Being the lead Java developer on building the global income tax withholding module. Proposed and created the key functional algorithm, and managed client relationships at multiple drop sites. Performed multi-tiered architecture design and Use-Case study. Installed the system nationwide at key financial institutions such as The Northern Trust, The Depository Trust & Clearing Corporation, etc.

Lisle, Il

Participated in DCS large-scale network switch project development. Debugged network device driver; defined detailed system expansion and monitoring strategy. Developed in C for embedded real-time OS – MTOS/PSOS, in compliance with ISO 9001.Designed the emulator-simulator inter-processor communication platform. Simulated the digital cross connect system on multiple workstations using C, Perl, and UNIX shell programming.

Master Of Science - Ms, Computer Science

Master Of Science - Ms, Data Science

B.A., Computer Science And Economics