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• Produced materials for executive leadership meetings

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• Led design and build teams to simultaneously deploy Qlik Sense, Tableau and HDP on firm’s Secure Cloud Platform built on AWS• Led team of data engineers to migrate data from legacy application for consumption in Qlik Sense

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 code patterns• NiFi, Avro and Hive to handle evolving schemas• Hive Warehouse Connector to integrate Hive and Spark for data prep• Oozie for automation and orchestration• Demonstrated Atlas' data management capabilities (data lineage and catalogue)Capacity building of a data science business unit in technology practices• Trained team members to create and utilize mapping documents• Trained team members to use JIRA for coordinating / managing project tasksData Architecture and Engineering• Designed data model for rapid prototyping analytical datasets used in data science for “Alternative Data”• Built automated data pipelines for data scientists

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• Data visualization: Tableau• SAS Certified Base Programmer• Certified Datameer Analyst• AWS Cloud Architecture - Launched AWS EMR clusters to create repeatable Extract, Load and Transform (ELT) patterns to: * Ingest data from AWS S3 and AWS RDS using Sqoop * Perform data prep using Hive, Impala and Presto * Automate and orchestrate jobs from Hue using Oozie * Benchmark performance of various data architecture designs / storage types, including Kudu, using Tableau

• 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. • Forecasted markets using reimbursement rates, population growth and historical trends. • Developed algorithm to accurately extrapolate Meidcare patient data to total population.• Exceeded quota for cold calling (executive level) stakeholders by almost 100%.• Praised for strengthening relationships with clients and developing sales leads. • Conducted market analyses using SEC filings, primary and secondary research.• Co-authored article for Med Device Online: Effects Of The Affordable Care Act On Urological Procedures And Associated Device Markets.

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 analysis and production of baseline Socio-Economic Survey Report.• Created a panel dataset and variables to track project performance.• Reconstructed the original survey questionnaire to include appropriate data for future analysis.• Facilitated comparisons of 15 crop varieties at intra- and inter-village levels using MS PivotTables.Supported project management through the planning and implementation of activities to achieve project targets and deadlines.

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.• Recommended R&D and marketing strategies based Systems Analysis: Improving Logistics Efficiency and Reliability (Shipments from Ende, Flores to Lombok)• Applied M&E training to build trust with stakeholders throughout the supply-chain.• Identified threat through stakeholder analysis: late deliveries lead to cancelled contracts.• Performed Benefit Cost Analysis of supply-chain’s processing and distribution activities.• Proposed shifting of task which halved STC’s costs & raised rural incomes upstream.• Solved threat by channelling increased margins to employ faster transportation methods.

• 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