-
Citibank Europe Plc
- App Support Sr. Analyst
2016 - maintenant
Citibank Europe plc provides various financial products and services to individuals, corporations, and small and medium-sized enterprises worldwide. It offers current and savings accounts; term deposits; money market funds, mutual funds, bonds, and structured investment products; and wealth management services. The company also provides consumer banking products, such as debit cards and credit cards; retail banking products and services, including personal loans and intermediation of investments to mutual funds, as well as private banking services; and corporate banking services.
Feb-2016 to Present
o Responsibilities:
• Part of the Compliance Technology Services EMEA team and providing Technical Specialist skills on Anti-money Laundering projects for EMEA and EMEA Virtual Hubs
• To build environments and implement off-the-shelf applications – Mantas and Actimize – which are used within the financial industry to monitor such transactions. A self-starter with have the ability to learn quickly and be able to liaise with various other Compliance, Operations, Technology and Infrastructure groups within the EMEA region to configure and implement the applications.
• Develop in-depth knowledge of AML behavior detection as it applies to the banking industry.
• Understand Compliance and Operations business needs and Mantas and Actimize product data requirements.
• Assist in defining, execution and implementation of solutions that satisfy AML business objectives.
• Build and maintain application environments to support AML projects.
• Building and maintaining excellent relationships across Business, Development and TI groups.
• Ensure all issues are escalated / documented according to Citigroup Information Technology Management Policies.
o Technologies
• Actimize Intelligence Server
• Actimize Server Monitor
• RCM Designer
• Autosys / Crontab Jobs
• Linux / UNIX
• Shell Scripts, Autosys and job scheduling.
• Middleware (Websphere, Connect:Direct, etc)
• ETL tool (Informatica)
-
Macquarie Offshore Services Pty Ltd
- Actimize Developer
2014 - 2016
Macquarrie Group Ltd. provides financial, banking and funds management services globally. It is headquartered in Martin Place, Sydney, Australia. It is the larges investment bank. It was founded in January 1970 as Hill Samuel Australia. Macquarie Group has more than seventy offices in over twenty eight locations throughout the world.
Jun-2014 to Jan-2016
Project: BFS Releases
o Data Gathering
• Brainstorm with other teams regarding the change.
• Analyze the effects of the changes from the ETL to AIS, RCM and reports.
• Analyze how the data mapping changes will affect the transition to the staging environment and the expected volume
o Setting-up database environment
• Knowing the business dates to be used for testing
• Requesting the Oracle “Application / Profile” DMP files to be restored to the environment
• Requesting the SQL Server “RCM” .bak file to be restored to the environment.
• Running synonyms / views to point to the TEST environment.
• Running scripts to allow grants to the users in UAT.
o RCM Setup
• After DB Refresh, connections should to be pointing to the TEST environment.
• Turning On / Off rules required for the release.
• Updating thresholds (user values / population thresholds) required for the release.
• Updating scoring (user values / population scoring) required for the release
o AIS Setup / Trigger / Run
• Point the AIS connection packages to the TEST environment.
• Run the jobs for the EOD batch.
• Compare end results from TEST vs PROD.
• Explain the difference between TEST and PROD (
> Normally, it is because of the missing data in UAT on the data loading of the current business day.
> The expected changes for the release.
> Or the rules that were turned-on or turned-off.
> Or the learning scores from previous days.
o SignOff / Implementation
• Raising Change Control Documents for the release
• Acquiring approvals the release
• Attending change control meetings to explain the necessity of the change.
• Obtaining resources for the release such as DBA and Wintel resources.
o Technologies
• Actimize Intelligence Server
• Actimize Server Monitor
• RCM Designer
• Control-M Jobs
• SQL Server 2008
• Oracle 11G
• Batch Jobs
• Tomcat Server
Dec-2014 to Dec-2015
Project: SAM Optimization / Upgrade
o Upgrading SAM v3.1.1.4 to SAM v8.2.4 / RCM 4.6 to 5.7 / AIS 4.5 to AIS 4.14.1
o Assisting 3rd party vendor on the details of the AIS.
o Development and support of existing SAM solution.
• RCM Threshold & score updates/modification
• RCM – Out of the box rules modifications
• AIS changes in DEV / SIT / UAT
• Technologies: Actimize Product, Batch Jobs, Oracle 11G / SQLServer 2012 / Control-M, Tomcat 7, SSIS, PowerShell
o Testing of new and existing rules
• Unit testing of new and modified rules being deployed.
o Creating objects in the AIS even without the certified password to accommodate new reports for the business.
o Supporting existing SSIS/SSAS/SSRS for reporting purposes.
o Website : http://www.macquarie.ph/
-
United Overseas Bank Limited
- Analyst Programmer
2013 - 2014
United Overseas Bank Limited (UOB) is committed to providing quality products and excellent customer service. Founded in 1935, UOB has a well-established regional presence, particularly in Asia where we have banking subsidiaries in Singapore, Malaysia, Indonesia, Thailand and China.
Project : Anti-Money Laundering via NICE ACTMIZE products
o Implementation of the SAM Solution for Indonesia.
• Taken part in the requirements gathering for the solution.
• Prepare the enhanced Control-M jobs for Indonesia (patterned from Malaysia jobs).
• Setup the AIS in the DEV / SIT / UAT for the solution via ClearCase / ClearQuest.
• Setting-up the RCM in WebLogic.
• Setting-up the configuration, process dates, thresholds, scores for testing in the RCM.
• Run the jobs in each environment before making sure expected output is providing before proceeding to the environment.
o Supported post implementation fixes for the SAM & CDD Malaysia
• Cosmetic changes in the ACM Designer
o Technologies
• Actimize Intelligence Server
• Actimize Server Monitor
• RCM Designer
• Control-M Jobs
• Unix
• Oracle 11G
• Batch Jobs
• WebLogic
o Website : www.uob.com.sg
-
DBS Bank Ltd
- Software Engineer
Hong Kong
2011 - 2013
DBS is uniquely placed to deliver banking the Asian way. As a bank that specialises in Asia, we leverage our deep understanding of the region, local culture and insights to serve and build lasting relationships with our clients.
DBS provides the full range of services in corporate, SME, consumer and wholesale banking activities across Asia and the Middle East.
Project : Anti-Money Laundering & Fraud Prevention via NICE ACTMIZE products
o Development and support of new and existing solutions.
• Actimize (RCM development / enhancement | RCM Designer setup and configuration | AIS Modeler configuration / execution / testing | RCM Websphere setup and installation)
• Understanding the Actimize Solution to support
> Re-creating the scripts for staging / application / profiles / rcm via the MSDOS as per instructions from the pdf document.
> Running the DB scripts to create the databases.
> Installing the AIS to the server and importing the .apk packages.
> Importing the license for the AIS.
> Configuring the Connection Packages or setting up the external .ini configuration file.
> Installing the from scratch the RCM (importing the .apf files to designer)
> Creating the workflows in the designer. Hiding unnecessary fields and adding filters as well and etc.
> Setting-up the container for the new RCM in Websphere (this also includes importing the diagrammer and app_gui_items)
> Configuring the RCM Connections and AIS Connections
> Setting up the rules and thresholds.
> Importing
> Setting up the process dates for the initialization.
> Creating Batch Scripts that will call the AIS Processes.
> Triggering the AIS Process via the Batch Scripts.
> Knowing the schedule job timings for the solution for the different countries.
> Read previous errors or common errors that occur in the solution and know how to quickly resolve the issue.
• AIS Modifications
> Certain banks requirements require modification and creation of new objects in the AIS.
> It involves creating or modifying channels / flows / process / variables and other objects.
> This involves obtaining the “actimize certified password” on the monthly basis for you to be able to modify or create the objects.
• AIS Solution Upgrades & Patches
> All vendor solution comes with a patch to address certain issues and enhanced the solution via the upgade.
> Tested patches and upgrades for Remote Banking / Employee Fraud and Deposit Fraud solution. Created the steps on how to import to the prod environment.
> Also deployed patches and upgrades for other team members (provided that they have the instructions for application.
• Extract-Transform-Load (VB.net / C#.net)
> Creating custom ETL windows .net applications to Extrat / Transform / Load data from files to the staging database.
> Creating batch files to call the .net files that will do the ETL
> Creating Tivoli jobs that will the batch file on a scheduled time.
o Testing of new and existing solutions
• Unit Testing of new and modified solutions being deployed.
• Regression Testing of existing solution when there are changes done in the upstream solutions that might impact our solutions.
o Technologies
• Actimize Intelligence Server
• Actimize Server Monitor
• RCM Designer
• Batch Jobs
• VB.net / C#.net
• SQL Server 2005
• VBScript/Javascript
• WebSphere
o Website : www.dbs.com
o List of Solutions supported
Fraud Prevention Solutions
• Remote Banking
> The Actimize Remote Banking Fraud solution provides high volume, cross-channel transaction monitoring across multiple remote channels including web, phone, mobile and more.
• Deposit Fraud
> The Actimize Deposit Fraud solution helps institutions minimize deposit fraud losses by providing comprehensive account activity monitoring for both On-Us and deposit fraud risk.
• Employee Fraud
> The Actimize Employee Fraud solution provides systematic and prioritized detection of employee fraud activity, with best practice rule sets for common employee fraud scenarios and advanced models to detect more complex attacks.
Anti Money Laundering Solutions
• Suspicious Activity Monitoring
> The Actimize Suspicious Activity Monitoring solution provides end-to-end coverage to identify and report suspicious transactions related to money laundering and terrorist financing, ensuring firms can meet current regulations and quickly adapt to the evolving regulatory environment.
• Watch List Filtering
> The Actimize Watch List Filtering solution provides firms with enterprise-wide, multi-jurisdictional, and multi-business unit coverage for screening customers and transactions against sanction, PEP, and internal lists and managing regulatory requests, such as FinCEN 314(a).
• Customer Due Diligence
> The Actimize Customer Due Diligence (CDD) solution provides complete lifecycle assessment and re-assessment of customer risk as part of know your customer (KYC) applicant on-boarding and ongoing customer due diligence processes, allowing firms to better identify, manage, and mitigate customer-related risks.
-
V.S. Software
- Software Developer
2011 - 2011
V.S. Software Development is an online based company that manages and supports the custom software applications, integration of existing company resources, debugging and software troubleshooting. The company also accepts consultation on hardware and specifications as well as software editing and upgrading. Company Website : http://vssoftware.net.
Client : AAStar.net
o Knowledge transfers of the online horse race betting account
o Development & support of new and existing systems.
o Data scraping of horse race results from other website and directly injecting it to AAStar.net database.
o Technologies: VB.net / C#.net, SQL Server 2005 & VBScript/Javascript
o Website : http://racing.aastar.net/
-
LoanWorks Technologies
- Analyst Programmer
2010 - 2011
Loanworks Technologies is a market leading technology provider specializing in proven turnkey solutions for lead management, loan origination, mortgage servicing, CRM, commission processing and B2B integration.
Established in 1998, Loanworks Technologies’ experience, responsiveness and innovative approach means that it is the trusted solutions partner of choice for some of the premier brand names in the financial services industry.
Oct-2010 to Dec-2010
Client : Macquarie Telecoms (Sydney, Australia)
o Knowledge Transfers of all Macquarie Telecoms systems
o Primary agile development & support of all Macquarie Telecoms systems
o Unit Testing and Regression Testing via Mercury (HP Quality Center)
• Unit Testing is done for every changes
• Automated Regression Testing
> Creating the test cases
> Running the test cases
> Recording the output results of the testing
o Technologies: C#.net, SQL Server 2008, TFS
Jan-2011 to Jul-2011
Client : Macquarie Telecoms (Manila, Philippines)
o Offshore agile development & support of all Macquarie Telecoms systems
• CRISP – Main web system used by Macquarie Telecoms.
• MacquarieView – The online tool used by Macquarie Telecoms client.
• SalesView - ASP classic web application used by Macquarie Telecoms salesrep to tract their sales and commissions.
• CRS – The web reporting tool used by Macquarie Telecoms.
o Technologies: C#.net, SQL Server 2008, TFS
-
JPMorgan Chase
- Applications Developer
Paris
2008 - 2010
Other Tasks:
o Creation and enhancement of Oracle Reports build in reports builder.
o Application & Web development and support in intranet websites (.Net (VB/C#) and APEX).
o Design and develop relational databases in Oracle 10/11G including Keys, Indexes, Constraints, and Defaults.
o Develop and maintain stored procedures, functions, triggers and jobs Oracle 11G. (PL/SQL)
-
Accenture
- Software Engineer
Paris
2006 - 2008
Accenture is a global management consulting, technology services and outsourcing company. Combining unparalleled experience, comprehensive capabilities across all industries and business functions, and extensive research on the worlds most successful companies, Accenture collaborates with clients to help them become high-performance businesses and governments.
Client: Washington Mutual (WaMu)
WaMu was previously a leading retailer of financial services for consumers and small businesses. Retail Banking & Financial Services, Home Loans, Commercial Banking, and Card Services.
WaMu was one of the United States leading financial services companies – leading retailer of financial services for consumers and small businesses. Their business span four primary business lines: Retail Banking & Financial Services, Home Loans, Commercial Banking, and Card Services. It was a leading provider of credit cards to middle market consumers throughout the United States. They’ve entered the credit card market through the acquisition of San Francisco-based Financial Company in October 2005.
Previously a member of the project’s Build/Development Team wherein the main task includes the following:
o Perform Code Changes and Application Enhancements and fixes
o Provide support and maintenance for applications owned whenever there are issues in production
o Create Functional Specs and Detailed Design Documents
o Provide timely resolution for Trouble Tickets
o Perform Unit and Assembly Testing
o Provide support for issues encountered during Product, End to End and User Acceptance Test
o Provide Post Production Support
Nov-2007 to Jan-2008
Project: PEPCRM
o The PEPCRM was back-end application that focuses payment processing of credit users. The project was enhanced performance the application because of the expected raised of volume incoming into the application. As well as updating old process that are considered void.
o Assigned as the developer one of the two java developers. We enabled the java application to run concurrently to pull off the performance-improving feat by using the multi-threading function.
o As primary systems analyst/programmer, was involved in requirements gathering, prototyping, analysis and design, development/coding, testing, build, deployment, and documentation of project artifacts.
o Unit Testing was also done via excel sheet. QA peers create the test cases based on the requirements.
o Bugs, recommendation and comments listed in HP Quality Center were acknowledge and responded.
o Technologies: Java, Oracle10G, Perl, UNIX
Mar-2006 to May-2006
Project: FCMS (Fraud Case Management System)
o The FCMS (Fraud Case Management System) was front-end application build in VB6. It was designed for CSR to support suspected fraud cases or fraud cases of WaMu credit users.
o Assigned as the developer for enhancing the VB application by creating new functions for the computation of the monetary disputes and post back.
o As primary systems analyst/programmer, was involved in requirements gathering, prototyping, analysis and design, development/coding, testing, build, deployment, and documentation of project artifacts.
o Unit Testing was also done via excel sheet. QA peers create the test cases based on the requirements.
o Bugs, recommendation and comments listed in HP Quality Center were acknowledge and responded.
o Technologies: VB6, Rumba, MSSQL2000
Client: Providian Financial Corporation
Providian Financials was a company that sold credit in the subprime market. Providian provided credit cards primarily to the lowest income group at high interest rates.
Nov-2005 to Jan-2006
Project: DMA (Debt Management Application)
o The DMA (Debt Management Application) was an existing backend application that runs on a UNIX box on a certain time which is triggered by CRON jobs. It purpose is mainly in the collections of debt of consumers and determining the amount to be paid to the merchants for their service.
o Was assigned as the developer to enhance the java application by creating new functions for the computation of the APR (annual percentage rate).
o Was involved in modifying Perl and UNIX scripts for testing purposes.
o Took part in the requirements gathering, prototyping, analysis and design, development/coding, testing, build, deployment, and documentation of project artifacts.
o Unit Testing was also done via excel sheet. QA peers create the test cases based on the requirements.
o Bugs, recommendation and comments listed in HP Quality Center were acknowledge and responded.
o Technologies: Oracle 8i, Java, UNIX, Perl
List of Tasks completed under both clients:
o Participated in the application development, maintenance and support in the complex financial service application software.
o Created SDLC documents for projects such as functional specification documents, detailed design documents, Unit/Assembly test cases documents and Implementation documents etc.. As well as test code changes and other team processes.
o Designed and developed relational databases in SQL Server including Keys, Indexes, Constraints, and Defaults.
o Developed and maintained stored procedures, user-defined functions and jobs in SQL Server. (T-SQL)
o Developed and maintained (PL-SQL) Oracle Packages, functions and procedures.
o Developed and maintained back-end applications created in JAVA, UNIX and Perl scripts that use Oracle Packages.
o Participated in application support for Oracle upgrade to 10G.
o Developed and maintained Front-end applications created in Visual Basic applications.
-
Pilipinas Crown Maritime, Inc
- Computer Programmer
2003 - 2005
Pilipinas Crown Maritime, Inc. is engage in the management of vessels as well as manning or supply of competent Filipino officers and crew for its foreign Principals. (Shipping industry)
The Shipping agency decided enhanced their system by upgrading their workstations and converting their DOS mode applications to a visual application.
Dec-2004 to Oct-2005
Other Tasks
o Develops / installs computer application programs for all employees.
o Performs technical repairs on hardware, software and networking problems.
o Assist other personnel in usage of software applications.
o Schedules system software and hardware upgrade.
o Maintains systems backup for all departments.
o Handles updates of company forms (Adobe PageMaker 6.5 and Corel Draw 12)
o Prepares staff attendance summary reports & reports of Japanese “Principal”
o Prepares monthly requisitions / purchase orders of office supplies and computer necessities which will be endorsed to the Administration Manager for proper disposition.
o Assist the Administration Manager in ensuring that purchases are carried-out as specified.
o Performs duties and function in the absence of the Admin Officer (Communications).
o Maintained the existing company website (third party).
Oct-2004 to Nov-2004
Project: Voucher Systems (Disbursements)
o Converted the existing manual voucher systems using Microsoft Excel to an automatic database system for enhancement of retrieval and computation of ledger.
o The system was built and design in Microsoft Visual Basic 6.0 using Microsoft Access as the database and Crystal Reports 8.5 for the reports.
Aug-2004 to Sep-2004
Project: AEE “Applicants (CREW) Entrance Exam”
o Converted the existing manual seafarer’s entrance examination to a flexible, fast & efficient computerized examination.
o The system was built and design in Microsoft Visual Basic 6.0 using Microsoft Access as the database and Crystal Reports 8.5 for the reports.
Jan-2004 to Mar-2004
Project: Check System Upgrade
o The “Check System” is an existing system that records, verifies and prints the company’s debit and credit.
o Converted the existing system (FoxPro DOS) to Visual FoxPro 6.0. And also altered table structures in the database for better enhancement of retrieval and reduced redundancy.
o Upgraded the application system from a single user to multi-user application and enhanced the reports for improved outputs.
o Reallocated the application to a server instead of having it installed in the local workstation.
Oct-2003 to Dec-2003
Project: Networking(LAN) & Software/Hardware Upgrade
o Rewired the Network configuration in all workstations for stability purposes.
o Reformatted and maintained installed software in each workstation.
o Upgraded hardware and software in each workstation for better performance.
o Ensured that all workstations are installed with licensed Microsoft OS & Office products and properly documented.
