Experience

Collage Group

• United States
• Market Research
• 200 - 300 Employee

• ETL / Data Engineer

  • Feb 2016 - Present

  • Develop ETL jobs using Pentaho Data Integration, Java and Python scripts to ingest company web metrices through REST APIs, survey and census data parsed from XML and CSV. • Design, tune and maintain AWS Redshift schema which powers organization’s reporting tools. • Led the development of organization’s geospatial tool which emulate organization’s survey data and U.S. population data in a tabular format and U.S. geographical heat map. Involved from the development of data pipeline, requirement gathering, tool interface design, server architecture design, development of tool in Node.js, D3, Leaflet and testing of the tool through unit, integration and regression tests using Jenkins. • Built a program to record survey respondents’ emotion when watching an advertisement using WebRTC technology and store the video to S3. Wrote Python script to analyze the videos through machine learning model from Kairos. • Develop a dashboard which visualize company’s web metrices data integrated with salesforce data in a tabular and charts format. The tool is built with Java as the backend framework, and AngularJS for the frontend framework. • Responsible in production deployment of organization’s tools hosted in AWS EC2 instance with Ubuntu Linux image. • Created a data model using rim weighting algorithm in R used to merge population data with organization’s survey data based on their demographics. • Work in an agile environment with two weeks sprint cycle, daily scrum standup and responsible for creating tasks in Atlassian JIRA based on the stories created at the end of the sprint cycle. • Stand-up Apache Hadoop 2.0 multi-node clusters and developed Apache Spark application in Java to ingest, transform and load data from semi-structured data to Amazon RDS. Show less



Amtrak

• United States
• Rail Transportation
• 700 & Above Employee

• Web/BI Intern

  • Jul 2015 - Nov 2015

  • Re-designed, rebuilt and launched department’s intranet wiki site using Confluence wiki to serve as a portal for business intelligence reporting and dashboards. Worked closely with the department’s team members, end users and the intranet manager for business and technical requirements gathering. Trained and created user admin guide for novice users to maintain the site after internship ends. • Dedicated team member for the organization’s process improvement initiatives. Provided analysis, testing and legwork that eliminated bottlenecks, reduced processing time and created a better user experience of reporting system. Built web intelligence report for management use. • Acted as team lead for administrating business intelligence schedule reporting functions. Maintained organizations tracking spreadsheet, migrated, tested and managed reports and dashboards in BOBJ. Responsible for updating report parameters and distribution list for over 500 scheduled reports for all business lines. • Technology Stack used: SAP BusinessObject, Informatica, Tableau, Oracle Exadata, Atlassian Confluence, JavaScript, HTML, Microsoft Excel. Show less



Neptune Orient Lines (NOL)

• Singapore
• Transportation/Trucking/Railroad
• 100 - 200 Employee

• IT Intern

  • Mar 2011 - May 2011

  • Re-developed organization’s internal incident reporting website using Java Servlet Page (JSP) with Eclipse. • Secured organizations data by organizing, maintaining and deleting 50,000 old, inactive employees’ accounts. • Deployed agents to secure all departments’ computers using McAfee Portal. • Scheduled and organized important events through SharePoint calendar. Technology Stack used: Java Servlet Package, Oracle, Microsoft SharePoint, McAfee Portal • Re-developed organization’s internal incident reporting website using Java Servlet Page (JSP) with Eclipse. • Secured organizations data by organizing, maintaining and deleting 50,000 old, inactive employees’ accounts. • Deployed agents to secure all departments’ computers using McAfee Portal. • Scheduled and organized important events through SharePoint calendar. Technology Stack used: Java Servlet Package, Oracle, Microsoft SharePoint, McAfee Portal