Financial Services It Project

David Manning

NY, ***** 516-***-**** **********@*******.***

IT Programmer Analyst & Consultant: Financial Services

Proven technical leader with experience aligning enterprise systems with company goals to drive profitability, performance, and stability. Demonstrated skill developing highly complex systems in strongly regulated, demanding environments, leading and mentoring diverse onshore and offshore teams. Advanced expertise in large-scale enterprise application architecture, mainframe technology platforms, online payment processing, and IT security issues within financial services industry. Advanced ability to translate product requirements into detailed system functionality as key liaison between client leadership and elite technical teams.

Expertise

Strategic Planning Change Management IT Project & Program Management Optimization Testing Software Development Lifecycle Digital Payment Systems Data Collection & Analysis Agile Resource Allocation Risk Management IT Architecture & Infrastructure Vendor Management Access Management FINRA / SCC & Regulatory Compliance Disaster Planning IT Security Report Design & Development Systems Integration Database Design & Migration Technical Support Cost-Benefit Analysis IT Documentation Mainframe Technology Platforms Team Mentorship Stakeholder Management Easytrieve User Experience Testing Coding & Code Review AJAX C / C# Sybase & UDB Fixed Income Certified Scrum Master ServiceNow

Technical Skills

Operating Systems: MVS UNIX Windows VM / CMS Mac

Mainframe Software: Enterprise Cobol CICS TS 6.2 SQL Assembler JES2 Intertest BMS SDF JCL VSAM OLQ Culprit QMF TSO / ISPF DMLO MQ Series FDR NDM & IBM Utilities DB2 Stored Procedures Endeavor Changeman SFTP

PC Software: Visual Basic HTML XML Perl JavaScript MQ Series SQL FTP Protocols Microsoft Office Project Workbench Microsoft Project Visio Informatica TIBCO General Interface VBScript Agile ASP WINSQL Toad

Databases: DB2 UDB Sybase Microsoft Access IDMS

Professional Experience

PNC Bank, Fully Remote May 2022 – April 2025

Software Engineer Lead

Maintained batch and online programs for the Genesis application, a major banking application for PNC Bank being replaced. Created multiple Db2 views to access and extract information from the Genesis database and customizing views to meet specific data extraction requirements. Transferred data to the Edge application via NDM.

Maintained Batch/JCL and CICS online programs for the Genesis real time banking application.

Created customized Db2 views and Cobol programs to extract data from the Genesis database.

Completed the decommissioning of the Genesis application, a major banking application for PNC Bank

While maintaining the Genesis environment we monitored the MQs that communicated with other applications

The main objective was to ensure the customer information in the db2 database was available for the new applications replacing Genesis.

For each application group a unique db2 view was required to be created along with an application Cobol program accessing that view. Numerous programs were written in one year by me to extract db2 data and utilizing NDM to push the data to the existing application.

Agile/Scrum meetings were held daily to resolve outstanding issues

All programs were Unit and volume tested before sending data downstream

QA teams validated the results by entering the data in the Genesis application

Used Changeman and Servicenow to promote all changes to the production environment.

One of my task was to extract the results from the database to assist QA in their validation

The downstream application group validated the data before signing off.

Tech Mahindra Consulting, Dallas, Texas February 2021 – April 2022

Senior Consultant

Created and modified Batch/Db2 programs for the Account Master group, with support for Cobol, CICS, DB2, and VSAM applications. Responsibilities also involved modifying DB2 stored procedures as part of update processing and supporting the assimilation of Etrade accounts into the Morgan Stanley database. All major projects are managed using Agile methodology, with stories written, tracked, and updated through Jira.

Created and modified Batch/Db2 programs for the Account Master group.

Provided support for Cobol, CICS, DB2, and VSAM applications.

Modified DB2 stored procedures as part of update processing.

Supported the assimilation of Etrade accounts into the Morgan Stanley database.

Utilized Agile methodology for project management, with stories tracked and updated in Jira.

Morgan Stanley, New York City, New York 2010 - 2019

Global investment bank and financial services firm with over 55,000 employees in 42 countries worldwide.

Project Leader

Spearheaded development, upgrade, and deployment of business-critical margin system software, serving as key point of contact between development teams and end users within Margin Operations division of Morgan Stanley. Managed teams of 5-8 onshore and offshore technical staff for individual projects. Coordinated full project lifecycle in accordance with strict SDLC guidelines. Managed customer statements and disclosure records in preparation for internal audits. Oversaw code review, directed teams in developing test scripts and evaluated results of user initiated UAT tests. Coordinated access management projects using Entitlement Provisioning and Reporting (EPR) tool, managed access of all files and databases, customized CICS screen access for user groups. Communicated with management teams to establish enterprise roles for tiers of approximately 100 users, coordinated with internal audit staff to ensure proper entitlements for each user as key manager of highly complex access requirements. Acted as key point of contact with FINRA and external regulatory bodies as needed.

•Implemented technical repair to initial rate override system, introduced solution that re-engineered override alert process and eliminated major issues.

•Overhauled full disclosure statements based on internal audit alert, while introducing changes across multiple systems that ensured accuracy of rate and debt balances on daily basis.

•Responsible for TLS certificate management for Margin servers.

•Upgraded online screen design to eliminate gaps in security, which ensured full compliance with high levels of security required by internal audit.

•Utilized SFTP to transfer Margin account details to Finra

•Utilized SFTP to receive data from Vantage Software

•Led initiative to submit FINRA extensions in XML format via FTP, ensuring on-time, accurate submission.

•Overhauled margin slate report, eliminated major bugs while improving intuitive design, expanded records to include both regular and margin accounts, accommodating additional 2 million records.

•Developed reliable system of transmitting incentive compensation to all Exxon employees with Morgan Stanley accounts, ensuring consistent daily updates for high volume of users.

Barclays Bank / CGI Consulting, Jersey City, New Jersey 2008 - 2010

Multinational investment bank and financial services firm with over 79,900 employees worldwide.

Senior Programmer / Analyst

Recruited to lead technical support for all applications acquired during Lehman Brothers bankruptcy. Served as key point of contact for ad-hoc reporting requested by legal team during information-gathering phase of bankruptcy proceedings.

Lehman Brothers, Jersey City, New Jersey 2000 - 2008

Global financial services company with over 26,200 employees worldwide.

Assistant Vice President

Directed 14-person team in ensuring optimal operations of back-office fixed income application. Coordinated multiple large-scale conversion, implementation, upgrade, migration, and launch initiatives. Communicated with DBA teams to identify all programs that required modification during database design. Managed business and regulatory compliance while implementing solutions that ensured transparent and on-time trade reporting in fast-paced environment. Managed nightly batch cycle.

•Led large-scale conversion of global company database from IDMS to DB2 and migrated programs to Cobol II, while converting bank funds transmittal process to MQ series.

•Saved $1million by developing robust government / mortgage-backed securities system with web-based front-end platform enabling FICC trading, designed to handle high traffic volume.

•Automated post-trade processing procedures and centralized date matching developed legally binding confirmations in real time, while eliminating earlier error-prone process and reducing risk.

•Designed and launched interactive system that submitted government and MBS trades to DTCC for comparison system, complying with DTCC ISO swift message formats.

•Introduced trade history system that captured and stored 7 years of trade information on DB2 database.

•Implemented JavaScript / VBScript / ASP application to outstanding results, developed key playbook empowering offshore teams to develop similar applications.

Education

Bachelor of Science in Economics

York College, City University of New York, New York City, New York

Contact this candidate