SUMMARY

• Twenty plus years’ experience in software development, business analyses, and project management in all phases of SDLC, using Agile, JAD and Waterfall methodologies.
• Proficient at identifying archaic business procedure; map, measure per data element and data lineage; strong advocates for continuous process improvement using detail workflow analyses.
• Extensive interaction experience with internal and external clients at all levels; excellent technical and business acumen and communication skills to liaise among developers and business users.
• Working experience in global environment with offshore team in applications development, and support to resolve critical software issues in a 24/7 support model.
• Financial domain experience in wealth management, investment banking, and treasury sectors for financial and accounting applications; in middle and back office, compliance and IT department.

TECHNICAL SKILLS

• MS Office
• Visio
• Project
• MS SharePoint
• COBOL
• JCL
• PeopleSoft (HCM)
• SQL
• SAP /BI/BW
• Oracle
• Hyperion
• JIRA/Confluence
• SWIFT
• Accuity FircoSoft Trust and Continuity
• Actimize
• PayPlus

PROFESSIONAL EXPERIENCE

Confidential

Sr. Business Analyst

Responsibilities:

• Write business requirement document (BRD), test strategy and test plan for an application upgrade of a global payment system with enhanced data filtering logic to better support Corporate Compliance team result in reduction of false positive alerts via business rules, white and blacklist of customer and transactional data.
• Support Swift Alliance Access (SAA 7.2 V) upgrade for a corporate payment system, secured senior management buy in, write user’s test script, and performs unit/UAT testing.
• Enhance Star Compliance ( Confidential ’s Human Resource software) business requirement to ensure Compliance Department’s policy are met by incorporate better user interface (GUI) which enable better end users’ experience when providing regulatory reporting data: personal accounts and private trading activities, outside business activities, gift and political contributions.

Confidential

Sr. Business Analyst

Responsibilities:

• FTP to sFTP conversion: migrated all 15 systems /interfaces for internal city wide agencies and external end users; performs QA and coordinate user acceptance test (UAT). Created user - friendly procedure and support document for Help Desk, and training documents for end users.
• Created runbooks for 30+ critical systems, each includes: system architecture diagrams, data flows, configuration information, troubleshooting guide and escalation procedure. Performs functional validation using traceability matrix from Business Requirements Document (BRD) through application testing to insure support documents match with all business functions.
• PeopleSoft V9 (Human Capital Management modules): system support various NYC government agencies other than Confidential uniform personnel, functionalities include new hires onboarding, safety and training, line of duties injury ( interface with Medical System), and payroll supports.
• Worked with PMO office in preparing high level project status and steering committee report; change management workflow improvement proposal; production issues and postmortem analyses and reports for all agencies wide stakeholders.

Confidential

Sr. Business Analyst / Project Manager

Responsibilities:

• Collaborated with global development team located in HK and NY, converted a treasury client’s credit and loan system from an Oracle OBIEE system to an in-house developed .Net Web front end, SQL database, and SAP BI/BW reporting platform. Authored documents: BRD, process flow documents, users’ story, users interface (UI) screen mock up and reports template.
• Migrated a legacy Treasury Management System to Wall Street System (Software as a Service -SaaS). Participated in Request for Proposal (RFP); vendors’ systems evaluation; collaborated with vendor (GXS) to customize its middle ware and used Swift Alliance Gateway as a payment system for all Confidential banks accounts. Duties include, Swift message mapping, ACH and BAI2 file reformatting; QA,UAT and end-to-end integration testing including ERP systems, e.g. SAP Financial, and Oracle Hyperion corporate accounting system.
• Worked with 360T - 3rd party vendor for FX spot /forward and swap trades execution, and Misys Confirmation Matching System - for trades confirmation, matching and reporting; then fed these trades into Wall Street System for reconciliation, P/L and accounting functions.
• Bloomberg Request Builder connectivity upgrade and support - market data extract (FX Rate, yield curve etc.) and data load via Confidential ’s in-house developed interface to downstream ERP systems (e.g. Hyperion for P&L and balance sheet accounting), and SAP Financial and Accounting (SAP FI).
• Initiated Cash and Debt ( Confidential proprietary system) rewrite project - wrote BRD and cost estimate proposal for senior management to signoff. The new system host over 1000+ domestic and international bank accounts for Treasury cash management’s functions, plus codes upgrade to support single sign on for end users access and identity and access management (IAM).
• Assisted Chief Information Security Office (CISO) to identify, develop, implement, and maintain processes across the entire users’ communities and systems to ensure information security and SOX compliance; performed quarterly and semi-annual audit review for all financial applications.
• Extracted and formatted all Confidential owns foreign banks accounts data in order to file Foreign Bank Account Reporting (FBAR) as required by Financial Crimes Enforcement Network (FinCen).

Confidential

Business Systems Analyst

Responsibilities:

• Reviewed Test plan /Test scenarios for a SQL Server 2008 data migration project; scope included over 100+ batch jobs and 15 Web based applications for Fixed Income, Equities, AML, KYC, compliance, client reporting and auditing, and performed QA testing as required.
• Worked across multiple teams to resolve issues due to data discrepancy among different source (Referential /Static Data, Vendors supplied market data or in-house generated data).
• Participated in annual SIFMA Business Continuity Planning (BCP) exercise in SunGard disaster recovery (DR) site; duties included coordination and testing of 60 critical batches jobs, 10 web applications; defect tracking and reporting; successfully completed within 10 hours allotted time.
• Updated BRD for SEC Rule 13h-1: Large Trader ID reporting requirement, prepared test strategy document, test scripts and test cases and obtained signoff from all relevant stakeholders.

Confidential

Sr. Business Analyst

Responsibilities:

• Maintained and generated reports which were used to monitor and insure activities of all Financial Advisors were operating within corporate investment guidelines and compliance policy (e.g. KYC and investment concentration).
• Analyzed and documented an existing North America private client’s financial products reporting system (a manual and Excel based system); duties included data sourcing and mapping rules analyses; gap analysis; updated user document and the work flow.
• Products supported: Alternative Investment vehicles, Fixed Incomes, Equities, MBS, ABS and Derivatives for high net worth private banking clients.