• Worked as product manager of MailScans to deliver precise scanning data and estimated forecast to customers• Performed data analysis to discover mail commingle patent and thus reduce postage cost• Created Personized URL system using Python Flask, Restful API and SQL• Managed an offshore 10 coders team to complete day to day task and deliver exceptional results• Performed A/B testing by setting different parameters and kept tracking results and performed data analysis by using Google Analysis, Facebook Pixel, SQL and Python• Created Interactive Voice Response system using Twilio, SQL and Python Restful API• Used Python and SQL to create data model to guarantee data model results and bring in customers and revenue• Used SQL and SSIS to create automations to boost work efficiencies• Created Ad-Hoc reports and dashboards by using SSRS and Tableau to track performance• Hands-on experience using Linux to do flat file operation to speed up data cleaning• Performed data cleaning and data analysis using Linux, Python and SQL• Created company big data search engine using Elastic Search and Mongo DB and write complex search queries

• Worked with our CIO and technical leader to design the database for the project and implemented data solutions including architecture design, prototyping of concepts to proof of concept • Collaborated with IT operations and testing organizations to ensure timely releases of projects and make sure database environments are sustainable.• Responsible to write complex T-SQL queries and stored procedures, functions, and designed various SQL objects and applied performance tuning to enhance the accuracy of the data. • Utilized Python including Scrapy, Pandas, Numpy and Matplotlib to automate the web scraping process and perform data cleansing and then visualize data.• Responsible for building dashboard using SSRS and Power BI tool• Assembled and converted user requirements from multiple clients into our standard reporting solution (SSRS 2012) and customized specific client requests when necessary.• Provided business instructions and worked as primary liaison with different departments. • Worked as data analyst to clean and pull out meaningful data to support managerial decisions• Develops database and software solutions by studying information needs, conferring with users, and studying system flow using ERD, besides, following the software development lifecycle.