Nicholas C. Email & Phone Number

Singapore, SG

• Solution Architect:
• Led data architecture, Extract Load Transform (ELT) architecture design for the program’s Financial Data Mart. The Data Mart consolidates data from 20+ source systems and manual files from end user computing inputs
• Collaborated with cross-functional stakeholders including business, infrastructure, platform, engineering and application teams to design and implement solutions
• Trained technical leads to improve project implementation efficiency and prepare for BAU handoverProject Manager:
• Created project plans for cross-functional streams and sub-streams
• Led delivery and mitigated risks to delays

Singapore, SG

• Big Data Solution Architecture and Platform Engineering:
• Designed architecture for deploying HDP clusters using Cloudbreak
• Led team to deploy HDP and Hortonworks Data Flow (HDF) clusters on AWS for self-service analytics
• Automated deployment of AWS ElasticMapReduce (EMR) clusters for “Alternative Data” analytics teamProgram Management and Solution Architect:
• Implemented projects using agile methodology
• Led teams to design architectures that align with Enterprise Architecture and business requirements

Singapore, SG

• Deployed Big Data infrastructure on the cloud
• Hortonworks Data Flow (HDF) 3.2 and Hortonworks Data Platform (HDP) 3.0.1 on AWS EC2 instances
• Integrated POC Active Directory (AD) with Ranger, Ambari, Atlas and Zeppelin for authentication and authorization
• Automated deployment of AWS ElasticMapReduce (EMR) clusters for data science using AWS Lambda and Cloudformation with IAM roles for securityDesigned and implemented ingestion and data prep framework with repeatable.
• NiFi, Avro and Hive to handle evolving schemas
• Hive Warehouse Connector to integrate Hive and Spark for data prep

Singapore, SG

KPMG Lighthouse: Innovation Centre of Excellence

Worldwide, OO

• Data Governance and Regulatory Compliance
• Data Quality (DQ) framework and implementation of framework for 5 pilot Critical Risk Measures required for BCBS 239 compliance
• Conceptual Prospect / Customer Data Model to facilitate master data management
• Assessment of risk data aggregation capabilities for BCBS 239Analytics and Information Management
• Designed data architecture, solution architecture and a data model for Tableau dashboards to visualize supply chain inventory levels
• Provided guidance on implementing Agile methodology

Worldwide, OO

• Information Management - Extract Transform Load (ETL) and Data Integration Architecture
• Guidewire ClaimCenter implementation and integration into an Enterprise Data Warehouse (EDW)
• Data model design and ETL build for business intelligence (BI) and advanced analytics
• Data migration using Datameer, a native on Hadoop self-service data prep solution
• IBM InfoSphere: DataStage 9.1, Data StudioAnalytics
• Data mining: Segmentation, predictive analytics and cluster analysis

• Designed and implemented solution to reduce processing time for processing activity by over 90%
• Created framework to track data collection
• Developed strategy to target new prospecting activities

Burnaby, British Columbia, CA

• Data Analytics
• Developed systems to incorporate empirical methods in market intelligence research.
• Designed and implemented dimensional modelling structures (star schema) to extract and combine data by querying healthcare utilization databases in MS Access.
• Empowered end-users by designing the system to load queries into MS PivotTables to promote self-service analytics in a familiar platform.
• Explored large dataset (8+ million rows) using SPSS to facilitate database system design and resource requirements for implementation.Market Research Analytics
• Led publication of syndicated market reports: market growth, competitive analysis, SWOT, PEST.

• Description: Facilitated initial implementation of $1.2 million sustainable agriculture project in the Gambia, AfricaPromoted to interim marketing manager for Improved Cook Stoves (ICS) program.
• Analyzed local ICS market to forge a new marketing strategy and generate new sales leads thus clearing 90% of inventory with a record-breaking repayment rate.
• Designed and conducted feasibility studies involving over 100 women to identify various stakeholder priorities, past project successes and challenges.
• Independently devised a creative solution which served multiple stakeholder objectives: Convinced client to replace competing technology with organization's product and expanded the functionality of our product.Led.
• Created a panel dataset and variables to track project performance.
• Reconstructed the original survey questionnaire to include appropriate data for future analysis.

Singapore, SG

• Field Research: Quantified Impact of Fuel-Type & Technology on Farmer Welfare
• Consulted with stakeholders to map supply-chain over 2 provinces for GIS and Benefit Cost Analysis.
• Designed econometric models and surveys to collect data for market analysis.
• Trained and accompanied 3 field staff to build dataset by surveying 66 farmers..
• Compared performance of 5 production technologies using OLS and logistic regressions.
• Produced SWOT analysis, case studies and econometrics reports.

• Created performance tracking system using MS Excel to monitor operations efficiency.
• Consolidated data from market analysis tools and customer profiles into MS Excel databases to facilitate improved information management.
• Designed field-marketing research plan to identify and collect data on consumer preferences/priorities categorized by location and socio-demographic factors.
• Tailored outside sales strategies from market trends and results from field research.
• Recommended strategies by predicting impact of Vancouver’s Greenest City policies.

Vancouver, British Columbia, CA

• Recruited 9 of the top student leaders (Student Assembly) in the world and facilitated the engagement of industry stakeholders to produce a list of “unsolvable” energy problems.
• Managed the Student Assembly which was tasked with establishing 10 of the world's most "unsolvable" energy problems of our day.
• Planned, obtained resources for and organized the publication of ISES 2011’s conference deliverable (10unsolvables.org).
• Generated and published content for the website.

Vancouver, British Columbia, CA

• Aided in the development of the: Oil Sands, Renewable Leap Forward, Venture Capital sessions by:* Recruiting industry experts* Hosting breakout sessions.
• Obtained sponsorship funding.

• .Dr. Nisha Malhotra’s research links socio-demographic factors to decisions made by South Asian populations that impact infant and maternal health. Supporting activities:
• Conducted literature reviews to frame research and relate findings to other studies.
• Identified inter-regional/temporal trends using Measure DHS Statcompiler.
• Merged NFHS datasets in Stata to explore viability of employing time series regressions.
• Generated and recoded variables in Stata for logistic regressions and interpreted results.
• Collaborated with Dr. Malhotra to produce working paper, Disparities in the Treatment of Childhood Diarrhea in India.

• Mitigated labour shortage over 9 weeks by voluntarily: extending contract duration; working 15 hour split-shifts; taking graveyard and 6 am start-time shifts.
• Identified and solved threat to future of department’s efficient operations by authoring company’s premier mail-room operations manual

• Planned and executed projects: real estate, small and medium enterprise (SME) start-ups.
• Socialized newly landed entrepreneurs to Vancouver’s business environment by conveying benefits of building credit, government procedures and transparent records.
• Found and collaborated with professional experts to devise solutions that could meet the needs of new SME business owners while mitigating risk to financial institutions.

• Recognized for sales ability.
• Upheld company’s standard of excellent service by providing accurate product knowledge to meet each member’s unique needs on a daily basis.

Mississauga, Ontario, CA

• Kool-Aid, Juicy Fruit, Tomb Raider, and Land Rover Campaigns.
• Raised interest in products by actively engaging the public, in a friendly and professional manner, at various events.

Master'S Degree, Food And Resource Economics

Bachelor Of Arts, Economics And Asian Studies