Project Management Manager

(Benny)To-on Pang

www.linkedin.com/in/benny-pang-b3890810

917-***-**** *******@*****.***

Summary:

An experienced, self-driven developer with a passion for technology. Extensive knowledge in back office systems of financial industry. Excellent communication and problem-solving skills. Expertise in:

Performance tuning

Data modeling

Report design and visualization

Streamline process flow

Project Management

Release Management

Technical skill:

Oracle, PL/SQL, SQL server, T-SQL, Unix shell script, Tableau, DataWatch, Control-m, Excel, VBA, TOAD, SSIS, Hadoop, Spark, Informatica, Business Objects, Cognos, DB2, Java, R, Python, SDLC, Erwin, JIRA, Confluence, TSO, JCL, CICS, VSAM, Natural/Adabas, PL/1, AWS

Experience: Credit Suisse 5/98 – 6/16

Development lead for Risk reporting 2015 – 2016

Worked in the Basel 3 BCBS 239 project which require risks are reported accurately and completely in a timeliness manner

Developed reports to show the risk measurements(VaRs) on various levels for different entities within the company

Negotiated with DBA and hardware services to fine tune the application from the infrastructure prospective to speed up performances and reduce storages by 30%

Onboarded new offshore resources to use a new technology developed in-house. Get the team up and running in a month. Liaise between the offshore development team with the in-house team to iron out the kinks and bugs of the new technology. Eventually, building a mechanism with proper procedures to prioritize and solve the issue.

Set up and manage multiple environments for database and host machines to allow for parallel developments and testings, shortening the implementation cycle

Reports use a new technology developed in-house which required repeated interaction with the in-house team to iron out the kinks and bugs of the new technology

With one project utilizing three different vendors offshore, harmonized the process, encouraged them to cross train and support each other

Sourced data from three different upstream systems and performed data analysis to handle data duplication, missing data, or bad data quality

Worked with project manager to develop test plan to find where the error originate ; not where the error show up

Liaised with QA to define test cases and organized into different cycles according to the test plan

Used JIRA and Confluence for agile development

Development lead for Product Control DataWarehouse 2012–2015

Product Control Data Warehouse(PCDW) which is the warehouse for Controllers to monitor the P&L of the firm’s trading. It allow users to drill down to see the transaction details or aggregate at higher level such as department or entity

Source funding and Repo information for the CCAR project

Benny (To-on) Pang

917-***-**** ******@*****.***

Debugged report performance issues and cut down the processing time by 70%

Automated an excel report into a new report with strong visualisation analytics which save manpower, eliminated human errors, made it available three weeks earlier, and much more versatile

Designed data model and processing flow to pick up latest reference data and avoid stressing the machine by breaking down the data into small batches

In depth knowledge of database design, table and data structure

Led a big conversion project to convert seven years of data from Peoplesoft triggered by a business re-organization

Reduced production issues significantly by designing data validation logic in ETL process to weed out data quality issue

Created technical specifications for offshore resource and drove weekly status review to monitor the progress

Created/modified tables based on project requirement while ensuring data model integrity is maintained

Worked with QA team to define the test plan and environment management plan

Managed release signoff, packaging and schedule

Received team player award for the Financial System Initiative(FSI) project

Developer lead for GL posting 2004 – 2012

Spectral is a posting engine where it looks at the characteristic of a trade such as the counterparty and maturity date to determine what GL account in Peoplesoft it should post to

Led the Spectral team in the bank wide Basel 2 effort so the bank can report its capital requirement accurately

Cut down production issue significantly by reviewing code changes done by junior developers

Provided second level production support in case of production issue

Worked with user to refine functional requirement, develop technical specifications, distribute the work to offshore team

Conducted unit test and user acceptance test; participated in division-wide integrated test

Ensure projects are executed within the specified time frame throughout the development cycle

Managed the outsource process by creating documentation, holding training session, creating KPI to measure vendor effectiveness

NTPA GCOC 1998 – 2004

GCOC calculate the funding cost for a trading positions based on the security type and maturity date

Worked with Treasury to explain to traders how the funding components affected their P&L

Designed a parameter driven approach to accommodate new products which enabled the business to trade new products in short span of time

Designed online reports to show the individual components that affect funding and provided an override function to Treasury to make correction

Education: B.S.(Computer and Information Systems), Brooklyn College/City University of New York

Professional Certification: Project Management Professional (PMP) from Project Management Institute.

Community involvement: Manhasset Bay Protection Committee member

Working status: US Citizen

Contact this candidate