SAS & Python Developer and Data Architect Resume

SUMMARY

SAS Certified programmer with 6 years experiences in Medical supplies and Telecommunication industries
Data architect - processing-reporting project from ETL processing on external raw data till the final delivery of data reporting and visualization based on the specific needs of end-user
Develop, test, optimize and deploy program, build-up automated notification functions, automate data recast project
Debug process errors, manipulate data & tables, modify programs based on updated BI rules
Apply new method of modelling using machine-learning algorithm with Python programming
Deliver inspirational comments, identify potential business opportunity based on extensive data analysis
Extensive knowledge on international supply chain & logistics, marketing-consulting, telecommunications

PROFESSIONAL EXPERIENCE

SAS & Python Developer and Data Architect

Confidential

Responsibilities:

Develop, test and deploy SAS programs / Teradata procedures from data architect, pre-processing with ETL techniques, data & tableau manipulations till the production of final data, report to requested destinations
Deliver numerous back-end programs to assure data flux among Hadoop, Oracle, SFTP, Teradata, etc. working with different data format (xlsx, csv, dat, json, xml, html, zip, table)
Develop numerous data integration projects for Bell Marketing team to provide cross platform reports using SAS / SQL / Teradata / Python, Develop SAS macros to standardize internal process
Using SAS & Machine-learning techniques with Python, to work with BI team to investigate and analyze data to identify customer’s behavior, shopping preference and generate marketing-oriented data for campaign events
Retrieve IPTV box data influx from Hadoop server, formatting information and analyze customer’s behavior
Work with BI team for business campaigns, to plan, develop, test, schedule, execute and debug SAS/SQL programs
Debug, update and optimize current programs to release system workload, data architect and governance, automate the identification, processing and archiving of input data files, the generation of reports and electronic notifications
Deliver SAS macros and ETL programs working with API documentation to retrieve meta data from Teradata / SAS EG, transfer to Collibra platform and build up data flux and objects relationships

Business & Logistics Data Architect, Developer and Analyst

Confidential

Responsibilities:

Design, architect and maintain company’s first distribution network database and data model
Create programs using SAS Data Steps & SQL to cleaning, standardizing and loading supplier’s data reports in various formats to MS Access and SAS Platform, with ETL skills, SQL queries, macros, data integrity maintenance
Create SAS programs to generate reports based on business logic, provide analytic report and data visualization with Power BI, Tableau or Excel charts
Interacting and communicating with management for routine and ad hoc analytical task, generate various reports & summaries, deliver reasonable interpretation and comments to achieve business goals successfully
Provide valuable business insights, critical thinking, suggestions on distribution network improvement, optimize the solution with balance of efficiency, profit and expenses
Experience on using Python ML algorithms to predict or classify target values
Based on internal data analysis, review, evaluate and negotiate logistic supplier’s pricing, cost simulation and comparison, propose potential cost-saving plan

Logistics & Data Specialist

Confidential

Responsibilities:

Data entry, produce periodic customer reports and analysis using SQL, MS Access, MS Excel
Freight tariff data analysis and comparison followed by negotiation with service providers
Identify potential customer, propose customized service and solution package