Big Data Solution Architect
Resume:
FUNCTIONAL ROLES
Account Lead Pre-Sales Lead
Business & Technical Consultant
Big Data Team & Project Leader
BI Requirements & Design
Big Data Solution Architect
Data Modeling (Logical, Physical)
Database Design Data Modeler
Data & Analytics Solution Architect
DBMS Implementation & Performance Tuning
DevOps Implementation Planning
ETL Architecture & Design
Project Leader
Project Manager
Senior Director
Trainer
TECHNOLOGIES
AWS Cloud Services
Databases
Hadoop HIVE, IBM DB2
Greenplum 3.1 – 4.1
Oracle/Oracle Exadata v2
Postgres, AWS Redshift
SQL Server (2005/2008/2016r2)
Teradata
ETL/DQ Tools
AWS Glue, Lake Formation
Dataflux Powerstudio, Datastage
Informatica, ODI, Wherescape
SQL Server IS (SSIS & DTS)
Teradata BTEQ/TPT, Talend
BI Tools
Business Objects
Cognos,
Hummingbird BI Studio
Microsoft SSRS/SSAS
MicroStrategy,
Oracle Discover/OBIEE Suite
Tableau
INDUSTRIES
Airline/Travel
Banking/Finance/ Insurance
Gaming/Hospitality
Government (State & Federal)
Health Care
Petroleum/Energy
Retail/CPG
Telco
SUMMARY OF EXPERIENCE
Over 25 years of data and analytics domain focused experience in business management and technical roles, demonstrating excellent analysis, problem solving, solutioning and leadership capabilities. An expert in data governance, data management and data integration solutions. Working experience with C-Level executives and senior management across a broad range of public and private sector business domains and industries. Expert in recovery of data and analytics centric projects and programs with a history of building strong in-house and customer delivery teams. I bring a unique mix of experience on data and analytics projects with the ability to drive business and technical discussions with business owners and convert those conversations into technical solutions. Recent roles include Senior Big Data Solution Architect, Cloud Solution Architect, Director and Big Data Principal Consultant.
Extensive experience with all aspects of data and analytics focused solutions: scoping and requirements, solution design and development, testing, deployment and implementation, operations planning, training, documentation, project, program and account management of petabyte scale, enterprise-class environments.
Expert Big Data & Business Intelligence consultant (technical and business) on a broad range of engagements (data governance, strategic analytics planning, roadmaps and tactical delivery) on a variety of Hadoop and RDBMS technologies.
Experienced in guiding customers in the development of Data Governance Programs, from organization planning (process definition, process improvement, procedures, roles, standards) to execution (strategic and tactical) with an emphasis on Data Security & Compliance (PII, PHI and Data Classification)
Skilled pre-sales lead on big data and analytics customer opportunities, with expertise in problem definition, scoping, solutioning and commercials.
Record of building high performance big data and analytics teams internally and for clients.
Technical and program/project lead across a wide variety of industries and Public Sector Agencies utilizing on-shore, off-shore, and hybrid delivery models.
Experienced in project management: resource planning, budgeting, and forecasting as well as strategic go-to-market planning; working with senior management to develop big data and analytics service offerings.
Programming Languages
Experience with a variety of language including Python, SQL (T, PL, ANSI), PERL, Basic, C, COBOL, Javascript, Unix Shell (Bourne, Bash, C) and Visual Studio.
Methodologies
Broad expertise including JAD, RAD, Agile, Iterative and Waterfall in data management engagements. Experienced in Dev-Ops feasibility and implementation planning. Preference of PRINCE2 Methodology for agile delivery.
EDUCATION
Bachelors of Science, Purdue University, West Lafayette, Indiana, USA
PROFESSIONAL CERTIFICATIONS & ACCOMPLISHMENTS
AWS Certified Architect and Cloud Practitioner, Teradata Certified Professional
AEA Philippines Conference Guest Speaker, 2018
TECHNOLOGIES
Developed proficiency in AWS technologies with a focus on Big Data and Analytics solutions
Athena
Aurora
Airflow
Data Migration Service
Lake Formation
Redshift
RDS
S3
DynamoDB
Kinesis
Glue
Glue Data Brew
Macie
Quicksight
Sagemaker
Eventbridge, SNS, SQS
Step Functions, Lambda
IaC: Terraform, Cloudformation
Cherry Road Asia: Aug 2023 – July 2024
Principal Big Data Solution Architect
As Principal Consultant, I providing senior level architecture and design skills to Cherry Road Clients for data and analytic centric solutions. Systems included Hadoop and Teradata RDBMS implementations in Asia and the Middle East.
Roles & Responsibilities
Design, Development and Implementation of Big Data (Hadoop) solutions
Requirements gathering and solutions design
Development of standardized design patterns for data extraction and acquisition, job scheduling, data validation, error handling, CDC processing
Conducting architecture and design review sessions
Conducting source to target mapping review sessions
Leading the development, testing and implementation of solutions
Working closely with PM to advise on blockers and activity status
Major Accomplishments:
Provided subject matter expertise to Cherry Road technical lead for the strategy to key design criteria to implement a comprehensive MDM solution
Completion mapping of new rated call processing system to Teradata DW
Completion standardized design patterns for Oracle to Hadoop data pipeline solution
Customization of industry standard data model to support new entities and attributes for GL and ERP systems
Design and development of Airflow Jobs to make paginated API calls to extract and parse and load flat and hierarchical data into HIVE tables
Clients:
Digi (Malaysia)
Customization of industry standard data model to support new entities and attributes for GL and ERP systems
Completion mapping of new rated call processing system into the Teradata DW Telco Model
City of Makati (Philippines)
Provided subject matter expertise to Cherry Road technical lead for the strategy to key design criteria to implement a comprehensive MDM solution
Saudi Telecom (Malaysia)
Completion standardized design patterns for Oracle to Hadoop data pipeline solution
Design, development and testing of Airflow Jobs to make paginated API calls to extract and parse and load flat and hierarchical data into HIVE tables
Amazon Web Services - Professional Services: Aug 2020 – March 2023
Senior Big Data consultant/Cloud Solution Architect
As a specialist on the AWS ProServe Senior Leadership team, my contributions focused on building and maturing the delivery of cloud solutions in the Data and Analytics domain. In this customer facing role I provided guidance and leadership on data governance, data management and analytics solutions development and delivery, contributing to a nearly 4x growth in revenue in just over two years. This role required hands on activities with respect to solution development and project management in addition to the AWS internal strategic and tactical activities.
Roles & Responsibilities
Providing guidance and expertise to the AWS sales and AWS partner organizations in the development of solution proposals and for Big Data and Analytics opportunities. Working directly with customer, confirming business and technical scope and requirement for the development and presentation of solutions.
Creating SOW for customer sign-off, complete with activities, effort, resources, timelines and pricing for Big Data and Analytics opportunities.
Engagement and project manager for the delivery of big data and analytics projects.
Technical team lead, providing solution design, guidance and recommendations to the delivery team, managing activities and supporting the team in addressing specific technical issues and roadblocks. Hands on solution development and delivery including solution architecture, logical and physical data modeling, ETL process and error handling, code reviews and testing.
Program & Project Management
External (Client facing): Responsible for managing delivery and provided regular status updates. Facilitating Delivery and status meetings. Developing mitigation plans with Client as changing project dynamics required. Providing technical guidance and solution recommendations as needed in addition to “forward thinking” guidance and recommendations for client’s big data and analytics programs. Responsible for keeping projects on track and delivering to plan
Internal (AWS ProServe): Responsible for providing and managing forecast estimates (monthly) and actuals, updating management when delivery dynamics warrant. Responsible for managing timelines, budget and project status. Provide technical guidance, advice, updates and solution recommendations to ProServe team members on all things big data related
Major Accomplishments:
Developed Packaged Solution Offerings for Big Data and Analytics Engagements
Led the development of a big data delivery team which had no big data project delivery experience to one which was able to implement big data solutions with little to no oversight, attaining a perfect 10 Customer Satisfaction Rating on Big Data and Analytics project delivery.
Became proficient on AWS’ Well Architected Framework and delivery of Well Architected Reviews with a focus on security and vulnerability analysis and remediation and AWS services for big data and analytics solutions.
Contributed to hiring, mentoring and development of an amazing AWS Professional Services Team that doubled in size while providing revenue growth of nearly 4x over the past two years.
Infosemantics Asia: August 2017 - August 2020
Senior Director, Principal Consultant for Big Data Solutions
Continuing to build upon my years of consultative technical and business management consulting by providing technical knowledge and leadership to the Infosemantics Asia team and Clients. With a heavy focus on Big Data and the Big Data Ecosystems around Hadoop, aspects of this role included pre-sales coordination with clients and vendors in scoping, architecting and planning Big Data Solutions and technical consulting for implementation and management as well as hands-on technical assessments and project implementation.
Working extensively with client’s C-Level management, business and technical unit department heads as well as the end users in a consultative role to assess their data management, integration and analytics environment, needs and challenges. The end goal being to formulate and implement the appropriate end-to-end solutions going beyond technology, providing the appropriate organizational and technical recommendations to enable organizational efficiency and effectiveness for their data governance program and data management and analytics projects. As Principal Consultant I would also provide hands-on support, delivering key business and technical artifacts required by clients for project delivery.
The outcome of these activities are providing end-to-end delivery of data integration and business intelligence projects. These project included hardware, software and project delivery and management components, including roadmaps, use cases, conceptual architectures, gap analysis, project implementation plans, operation and training plans, providing architecture design and recommendations on the tools, resource planning, delivery model and the skillsets required to implement the solutions. Also provided non-technical recommendations regarding organization structure, communications plans, business process efficiency with data governance program and data management best practices in mind.
In addition to conducting PoC’s and internal performance testing and product evaluations, I provided hands on as Senior Consultant on the follow engagements:
Senior Consultant. City of Hope (Azusa, Ca.) July 2019 – January 2020
Responsibilities:
-Big Data Infrastructure Planning
-SQL Development
-PowerDesigner Data Modeling (Logical, Physical (Dimensional), Semantic)
-Database Optimization
-SQL Server Performance Tuning
-Data Management Policies & Standards
Principal Consultant. NT Asset (Bangkok, Thailand) May 2018 – June 2018
-Data Management Assessment providing the customer with Implementation Roadmap and Delivery Model
Senior Consultant. Tanay Rural Bank (Manila, Philippines) April 2017 – June 2017
-Data Management Assessment
-BPM (Business Process Management) Analysis Report
-Data Management Optimization & Recommendations with Roadmap
Big Data Environments
Cloudera/HW Hadoop
MAPR Hadoop
Tools
ErWin Data Modeler
Toad Data Modeler
SAP PowerDesigner
Oracle Data Modeler
Visual Paradigm BPM
Python, Perl, BASH
Ant, GIT, Jenkins
Confluence, Jira
Excel, Powerpoint, Word
Microsoft Project
VirtualBox, VMWare
Teradata Studio
Infosemantics (MPP Consulting) Philippines: Feb 2016 – July 2017
Solution Architect & Pre-Sales Consultant
Responsibilities included providing technical leadership and support to the Infosemantics teams for the design, implementation and management of Big Data and Advanced Analytics Solutions. Activities include project scoping, planning and delivery. Working with staff and clients on the selection, implementation and testing technical options for Big Data & Business Intelligence architectural solutions. Hand on activities include project planning and management, the development of technical solutions, use cases, data models (3nf, dimensional and semantic), development of requirements documents and conducting design and analysis activities. Mentoring junior staff is also a component of this role.
Teradata: Mar 2015 – Jan 2016
ASEAN Area Solution Architect & Management Consultant
Providing Solution Architecture design and technical support to Teradata Clients, Teradata Pre-Sales and Professional Services (Implementation) Teams throughout Southeast Asia for traditional RDBMS, Hadoop and Aster Advanced analytics ecosystems. Responsible for working directly with various clients and Teradata Account Managers, Project Management, Professional Services Partners, Technical Team leads and Senior Management for analysis, development, review and approval of client solutions and proposals.
Keystone activities: Working directly with Client’s Senior Business & IT Management and SMEs to understand current challenges and future needs to conceptualize and development data management and business intelligence architectures and roadmap strategies. Clients supported in this role include:
Standard Chartered Bank
Petronas
HSBC Bank (Hong Kong)
JG Summit (Retail/CPG)
San Miguel Corp (Pure Foods)
ABS-CBN (Media)
Meralco (Energy)
GLOBE (Telcom)
SMART (Telcom)
Optus (Telcom)
Philippine Airlines
Westpac Bank
Key Responsibilities:
Pre-Sales Support
Assessments
Database Design (Logical, Physical, Semantic data modeling)
Query Analysis and SQL Optimization
Database Performance Tuning
Environments
Teradata DBMS Versions 14.0 – 15.1
Hadoop (HortonWorks)
Aster 6.x
Oracle Exadata
Oracle 11
DB2
Tools
Teradata Studio
SQL
Perl, BASH
Ant, GIT, Jenkins, Jira
Powerpoint
Word
ErWin
Teradata MDM
Teradata TAS
Toad Data Modeler
Oracle Data Modeler
Visual Paradigm BPM
Python, Perl, BASH
Ant, GIT, Jenkins
Confluence, Jira
Excel, Powerpoint, Word
Microsoft Project
VirtualBox, VMWare
Teradata Studio
Applications
Custom Applications from numerous Upstream Source and Downstream Analytic & Operational Systems
Teradata Thailand June 2014 – Dec 2014
Lead Solution Architect for Teradata Thailand Professional Services
Responsible for providing career planning, mentoring, technical guidance and team leadership to Thailand Professional Services Solution Architects and Database Administrators. Additional responsibilities include providing planning, resource and cost estimates and conduct internal cost and risk reviews (CREST) for new projects.
Lead Solution Architect/Project Manager - DTAC (June 2014 – Sept 2014)
Key Responsibilities:
Project Management, Communication, Issues Tracking & Escalation and Finances
Reviews performance issues and make recommendations to correct ELT performance (primarily on Abacus project).
Redesign source system load strategy to improve performance
Conducting data model reviews with data modelers
Assist program manager in escalating project, process and methodology issues with the customer
Work with program manager to re-baseline project activities and timelines
SQL Coding
Mentoring BI Report Analysts on report design and SQL optimization
Review financials and project run-rate with Professional Services Manager
Professional Services RFP response preparation for DTAC’s Data Offloading Project. Identification of implementation activities, resources required, project planning, resource and cost estimations and risk application. Responsible for conduction internal reviews with Thailand and Regional Management Teams for internal bid approval.
Lead Solution Architect - Bank for Agriculture & Ag. Co-ops (June 2014 – July 2014)
Conduct ELT solution design review and make recommendations with project Solution Architect on ETL design, test plan and test plan strategy.
Lead Solution Architect - Bank of Ayudhya – Bangkok (Aug 2014 – Sept 2014)
Develop new project estimates. Activities included reviewing and refining scope with Sales Team. Identification of activities, resources required, project planning, resource and cost estimations and risk application. Responsible for conduction internal reviews with Thailand and Regional Management Teams for internal bid approval.
Lead Solution Architect - Standard Chartered Bank – Singapore (Oct 2014 – Dec 2014)
Lead on Standard Chartered DevOps Initiative for their Data Warehouse/Business Intelligence Platform. Conducting feasibility study and implementation plan for Dev-Ops environment. Development and presentation of deliverables.
Design & Development of Teradata Application Resource Usage Report on Standard Chartered Teradata System to identify the amount of latency and resource usage of each applications ELT job using query banding. (Development of shell, BTEQ, TPT scripts and SQL coding.
IBM Thailand Jan 2013 – FEB 2014
Senior Solution Architect for GBS Thailand Professional Services
This role included account management activities as well as technical expertise for IBM’s GBS Professional Services Group. Responsible for project and resource planning, status and issue management as well as technical leadership in the area of data management and analytics.
Key Accomplishments:
Selected to IBM's Asean EDW/BI Center of Competency Team. One of six team members, speciality domain on Data Governance and Management framework and methodology
Managed team of over 40 resources (on-shore/off-shore model) to complete IBM’s Enterprise Data Warehouse at Thai Airways
Client Engagements:
True Corp (Netezza Analytics EDW with comScore Solution implementation)
Thai Airways (IBM DB2 EDW Recovery)
Baseline Consulting Group Oct 2010 – July 2012
Senior Consultant – Data Engineer
Returned to BCG (acquired to become SAS-Dataflux Professional Services Organization) as Senior Business & Technical Consultant to support several high priority engagements which needed senior leadership and technical management skills.
Focus of roles were to provide engagement leadership and subject matter expertise for Data Governance, Data Warehousing and Master Data Management engagements. Became proficient in agile delivery methodology and further developed my project management skills.
Client engagements:
Citizens Financial Group (Data Governance and Data Management Assessment)
The assessment was conducted to compare the IT organization’s current state to best practices and provide recommendations in the following area:
-Program Management & Business Alignment
-Project Delivery Methodology
-Data Management
-Organization, Roles & Responsibilities
-Production Management & Support
-MDM & BI Delivery Strategy
-Data Integration Strategy
-Database Platform & Architecture Recommendations
Group Health Cooperative (MDM Solution Implementation)
ScotiaBank (Data Governance and Data Risk Management Assessment)
Ferntree Asia Feb 2008 – June 2010
Principal Consultant
As principal consultant I led multiple pre-sales and technical data and analytics projects, converting prospect into customers on several opportunities. Responsibilities expanded on previous experience in the data governance and data management space.
Clients included:
Thai Airways (EDW Solution)
Philippine Airlines (EDW Solution)
Standard-Chartered Bank (EDW Solution)
AIS (EDW Migration: Teradata to Greenplum)
Baseline Consulting April 2006 – Aug 2008
Pinnacle Entertainment (Las Vegas, Nevada) April 2006 – Aug 2008
Senior Consultant
Project lead for Pinnacle’s data integration & data warehousing project. This was a marketing driven initiative which required the integration of CMS and ACSC gaming systems and LMS hotel systems for Pinnacle properties across the country. Led business focused and technical activities, from business requirements gathering and analysis to the design, development and implementation of the EDW and analytics system utilizing Microsoft SQL Server tools.
Hong Leong Bank (Kuala Lumpur, Malaysia) Aug 2005 – Oct 2005
Principal Technical Consultant
Brough in as technical team lead on a recovery project for a Teradata Data Warehouse which had ETL design and performance issues utilizing an new to market ETL tool (Wherescape “Red”). Worked with development team and Wherescape engineers to redesign ETL jobs and apply critical software patches to fix bugs found on the project.
Advanced Info Services (Bangkok, Thailand) April 2004 – July 2005
Principal Consultant
Led Data Warehouse recovery project. Daily ETL jobs initially taking 22-26 hours were redesigned to deliver consistent results in the 2-3 hour range upon completion. Initial engagement was extended beyond one year to expand and redesign the database and ETL jobs to support additional data domains and long term viability.
Baseline Consulting Nov 1995 -– Dec 2003
Principal Consultant
Senior technical and business consultant for Baseline Consulting. Lead on business and technical projects and pre-sales opportunities including assessments, design, development and implementation teams across a broad range of public and private sector organizations with a focus on Data Governance, Data Management and Integration (DW, Data Marts) and Analytics Dashboards (multiple tools and environments).
Customer facing activities was a key component of this role, leading conversations with C-Level Executives, departmental stakeholders, developers and support personnel. Projects delivered for:
State of Michigan (Human Services Division)
CheckFree
Utah Department of Health (multiple engagements)
Verizon
Syncra
GTE Wireless
Toyota
The Meyers Group
Provident (Unum) Insurance
Getty Images
Southern New England Telephone
AT&T Wireless
BellSouth Residential
BellSouth Business Systems
Health Systems Resources (Atlanta, Georgia) Dec 1994 – Nov 1995
Software Development Lead/Manager
Responsible for leading the development and support of HSR’s Hospital care and billing system. Primary responsibility and accomplishment was the migration of the application from AS/400 to Novell Unixware platform utilizing Progress DBMS and Progress application UI.
ComputerLogic (Macon, Georgia) Jun 1993 – Dec 1994
Product and Development Manager
Product Manager & Lead Developer/Analyst for ComputerLogic, Inc. Managed the development and installation of the unix based “ProfitLogic” Automotive Parts Inventory control system for automotive parts distributors and sellers. Provided pre-sales support to field sales representatives.
TSI Systems (Fort Wayne, Indiana) March 1991 – May 1993
Technical Project Manager
Technical Manager and Developer for two time Inc. 500 Fastest Growing Companies; Tech Sales, Inc. Planned and managing all IT projects from design through equipment delivery and managed installation and setup. Responsible for CAD blueprint development.
Marriott International (Bethesda, Maryland) Jan 1986 – March 1991
Technical Operations Manager, Programmer Analyst
Member of the original IT team member for the Fairfield Inn unit of Marriott Corporation as programmer. Progressed my career to be the Manager of Technical Operations and Support for over 50 Fairfield Inns across the USA utilizing Unix based systems.
Clark Equipment Corp. (Niles, Michigan) May 1985 – August 1985
Associate Developer
Responsible for assisting the conversion team on the migration and upgrade of Clark Equipment’s Inventory Control COBOL code base to the COBOL 1985 standard.
Completed project in less than 1/3 the estimated time. Put on a project to develop Pascal application (completed early) and learn/write IBM 370 JCL.
(This page intentionally blank)
Contact this candidate