Jhona T. Sarmiento
Singapore
Summary
To seek and maintain full-time position that offers professional challenges utilizing interpersonal skills, excellent time management, problem-solving, programming and analytical skills while working for the company’s mission and vision
Overview
14
14
years of professional experience
Work History
SAS/Data Analyst
NSearch (deployed At DBS)
09.2022 - Current
- Ensure successful and timely completion of assigned data analytics projects and tasks within Wealth Management sector, encompassing Private Banking and Treasures Private Client business segments.
- Collaborate with Finance Team and Performance Management Team to identify analytics and Balance Scorecard reporting requirements for tracking Relationship Managers' KPIs (revenue, net new money, acquisition, cash-to-conversion conversion, portfolio diversification)
- Translate business requirements and explore data/source systems to address analytics requests
- Collaborate with Technology team to implement business analytics solutions
- Assist business in discovering insights through thorough analysis and communicate recommendations to stakeholders.
- Support Relationship Managers by addressing their inquiries regarding their KPIs
Assistant Vice President
CIMB Bank Berhad
06.2022 - 09.2022
- Ensured Consumer Banking portfolio management analytics, BI, as well as other analytics-related requirements (including analytics and BI-related infrastructure)
- Performed Incentives computation and drive Sales Analytics capabilities
- Collaborated and worked closely with business units to understand, clarify and interpret business dashboards and data analytics for effective portfolio monitoring
- Provided support for CBS reports and related processes
SENIOR CONSULTANT
NTT Data Singapore (deployed At DBS)
07.2021 - 05.2022
- Ensured 100% data accuracy of data marts and reports for Intelligent Banking in-house use cases and Control Group Report
- Evaluated stakeholders' needs and creates plan of action to provide solutions
- Monitored technology use and program functionality, creating, updating and automating jobs and making changes to enhance and optimize outputs and data marts
DATA ANALYST
NTT Data Singapore (deployed At DBS)
07.2019 - 06.2021
- Served as one of the key players in SAS migration activities from BIP to ADA platform.
- Collaborated with developers and analysts to enhance supportability and identify performance bottlenecks.
- Ensured completion and accuracy of reconciliation reports between ingested data and migrated data and ensured proper documentation to capture audit trail.
- Lead Sales Incentive Project, migration from manual process in Excel to automated computation of scores in SAS needed for CBG incentives and rewards program.
- Lead the development and testing using SAS EG on Revenue Mart and Datamart migration and enhancements specifically for deposits data.
- Provided support on the preparation and validation of product related data marts needed by modelling team
SAS DEVELOPER
Robert Walters (deployed At SCB Singapore)
01.2019 - 06.2019
- Collaborated with team members for adhoc requests and testing conducted by internal and external parties for Inherent Risk Scorecard (IRS) related projects under Group FCC Business Risk Assessment.
- Ensured that Functional Specification Document for Inherent Risk Scorecard is well reviewed and up-to-date.
- Prepared mapping documentations that will enable users to understand association of IRS SAS Scripts and FSD.
- Developed scorecards for tax evasion risk assessment.
- Implemented upgraded Client Risk Assessment model for Non ICDD Retail Individuals.
SAS DEVELOPER
Encora Technologies (deployed At SCB GBS)
12.2016 - 12.2018
- Collaberated with cross-functional team members on data warehouse projects which produce datamarts and reports needed by users for their regulatory and internal reporting.
- Key player in project implementation activities to ensure successful implementation of the project (from preparing of dispensation necessary for production data download, chasing SIT and UAT signoffs, raising change requests, preparing migration steps documents, application implementer guide, performing TVTs).
- Ensured that Technical Specification Documents are in accordance to project specifications and mapping documents are based on the new business requirment logic provided by the users.
- Designed, developed tests cases and test scripts using Base SAS and Unix and participated in all testing phases (unit testing, system testing, regression testing, UAT).
SAS PROGRAMMER/ANALYST
Brady Philippines Direct Marketing, Inc.
07.2014 - 11.2016
- Spearheaded and managed SAS projects which were delivered with 100% accuracy and on time to sales management, providing added value to some existing reports to help business meet their targets, give deep dive analysis on how current sales performs, and track agents' perfomance for incentives and bonuses
- Performed data preparation, cleansing, manipulation and summarization of large data sets using SAS.
- Ensured the completion and maintenance of existing and new reports, and adhoc requests which tracks KPIs in a timely manner using SAS ODS, SAS AMO.
- Provided list pulls needed for inbound/outbound telesales campaigns, and adhoc analysis such as market segment analysis, gross margin decline analysis, return rate/backlog analysis, pricing analysis, and correlation analysis to help identify areas of growth.
RETAIL RISK ANALYST
ANZ Global Services And Operations (Manila), Inc.
04.2013 - 04.2014
- Provided timely, accurate and relevant information, reports and analysis for secured lending product portfolios (Personal Loans and Mortages) using SAS to the team and stakeholders.
- Provided general MIS and technical support, including maintaining and integrating various databases and keeping the tables accurate and up to date.
- Prepared and enhanced Credit Packs and Executive Packs/Decks which tracks the performance of products which are being used by the managers in making strategies.
- Participated in projects and analysis such as streamlining of KPIs across regions and countries and creating vintage graphs for Personal Loans and Mortgages and optimizing processes in reporting and development in SAS
- Developed documentation and run guides for existing and new reports.
JUNIOR CONSULTANT
Indra Philippines, Inc
05.2012 - 04.2013
- Provided SAS programming support for data management, report generation and program validation in a telecommunication company.
- Tracked the number of availers per brand to assess top-level performance of registration based promos.
- Tracked the SMS and voice promos registered by consumers.
- Monitored monthly churn of consumer postpaid and determined the key drivers of the churn.
- Developed reports that will identify registration profile and usage behavior of Prepaid and Postpaid subscribers.
- Provided insights about the behaviour of Postpaid and Prepaid subscribers.
- Ensured that MIS tables and SAS datasets are created correctly and up to date.
ACCOUNT EXECUTIVE
TNS Philippines, Inc./Kantar Worldpanel
07.2011 - 04.2012
- Managed clients in the FMCG industry to look into market trends and nsights that will enable them to make better business decisions.
- Prepared insightful and creative presentation stories to some of the biggest names in the local market and internal presentation to line manager and other senior colleagues.
- Provided switching analysis from one brand to another and comparative analysis of promos offered by different brands.
- Collaborated with the rest of the team to ensure that high levels of insights are delivered to the clients.
REVENUE & YIELD ANALYST
Aboitiz One, Inc
07.2010 - 06.2011
- Ensured proper/accurate documentation and evaluation of sales proposals by providing financial assessment through contribution margin analysis.
- Prepared Profitability Analysis with recommendation every time there is new/prospective business and monitored profitability issues and concerns (including action plans).
- Provided reports enhancements/optimization if needed.
RESEARCH EXEC/STATISTICIAN
Asia Pacific Centre For Research
10.2009 - 05.2010
- Provided research proposals, design and pricing/quotation to possible clients.
- Spearheaded research projects such as conducting political surveys and socio-economic surveys analysis, involvement from requirement gathering, data management and analysis using SPSS and preparing of presentation decks
- Assisted in managing the overall needs of the client by directly coordinating with them on deliverables/expectations and data requests.
Education
Bachelor of Science - Statistics
UNIVERSITY OF THE PHILIPPINES LOS BAÑOS
LAGUNA, PHILIPPINES04.2009
Skills
- Base SAS
- SAS EG
- SAS WRS
- SAS AMO
- SAS Miner
- SAS DI
- SAS Viya
- SPSS
- STATA
- Teradata SQL
- Oracle
- Spark
- Python
- Unix
- Superset
- JIRA
- Confluence
- Bitbucket
- GIT for SAS
- AWS
- Visual Basic
- Microsoft Office
- DOMO
- Collibra
- ADA
- ThoughtSpot
- Qlikview
- Avaloq
Affiliations
UP CATANDUNGAN LOS BAÑOS
Academic Committee Head (A.Y. 2007-2008)
President (A.Y. 2008-2009)
UPLB STATISTICAL SOCIETY
Secretary (A.Y. 2008-2009)
Records Committee Head (A.Y. 2008-2009)
Languages
English
Bilingual or Proficient (C2)
Filipino
Bilingual or Proficient (C2)
Timeline
SAS/Data Analyst
NSearch (deployed At DBS)
09.2022 - Current
Assistant Vice President
CIMB Bank Berhad
06.2022 - 09.2022
SENIOR CONSULTANT
NTT Data Singapore (deployed At DBS)
07.2021 - 05.2022
DATA ANALYST
NTT Data Singapore (deployed At DBS)
07.2019 - 06.2021
SAS DEVELOPER
Robert Walters (deployed At SCB Singapore)
01.2019 - 06.2019
SAS DEVELOPER
Encora Technologies (deployed At SCB GBS)
12.2016 - 12.2018
SAS PROGRAMMER/ANALYST
Brady Philippines Direct Marketing, Inc.
07.2014 - 11.2016
RETAIL RISK ANALYST
ANZ Global Services And Operations (Manila), Inc.
04.2013 - 04.2014
JUNIOR CONSULTANT
Indra Philippines, Inc
05.2012 - 04.2013
ACCOUNT EXECUTIVE
TNS Philippines, Inc./Kantar Worldpanel
07.2011 - 04.2012
REVENUE & YIELD ANALYST
Aboitiz One, Inc
07.2010 - 06.2011
RESEARCH EXEC/STATISTICIAN
Asia Pacific Centre For Research
10.2009 - 05.2010
Bachelor of Science - Statistics
UNIVERSITY OF THE PHILIPPINES LOS BAÑOS
Similar Profiles
PHUA WEI JIEPHUA WEI JIE
Full Stack Software Engineer at nSearch Global Pte Ltd Partner with GovTech/Ministry of ManpowerFull Stack Software Engineer at nSearch Global Pte Ltd Partner with GovTech/Ministry of Manpower
Shehabun SaaqebShehabun Saaqeb
Director at nSearch LimitedDirector at nSearch Limited
ANKIT SENGARANKIT SENGAR
Assistant Vice President - Product Marketing at DBS Bank, IndiaAssistant Vice President - Product Marketing at DBS Bank, India
Carol LimCarol Lim
AR Credit Control Officer at TP ICAP Management Services Pte LtdAR Credit Control Officer at TP ICAP Management Services Pte Ltd
Mohammad Nazim Bin AtanMohammad Nazim Bin Atan
Facilities / Accounts Manager at Newtech Technology (South Asia) Pte LtdFacilities / Accounts Manager at Newtech Technology (South Asia) Pte Ltd