Data Management

Gary J. Silk

** ********* ********** *** #*

Old Bridge, New Jersey 08857

Cell: 917-***-**** EMAIL: acy4jb@r.postjobfree.com

US Citizen

Technical Skills

Development Methods: Agile/Scrum, Waterfall

Documents: Business Requirements Document, Business Functional Specification, Business Viability Assessment, Technical System Requirements/Design, Project Plan

Diagrams: Entity Relationship, Use Case, Data Flow, Process Flow, Context, Current/Future State, Activity, Sequence, Data Flow, Data Structure Diagram

MS Office Outlook, Excel, Word, MS Project, Power Point, VISIO, MS Access

Hardware: IBM Mainframe, PC, MAC

Operating Systems: MS Windows, ZOS, Microsoft Server, Apache/Tomcat, UNIX

DBMS: DB2, IMS DB, Oracle 8I, IDMS, DATACOM, Sybase

File Storage: VSAM, ISAM, Windows PowerShell

Languages: COBOL, C/C++, PL/I, FORTRAN, Case Tool, JCL, SQL, Utilities, JAVA, HTML, PL/SQL, QMF, EZTRIEVE

Transaction Manager: CICS, IMS/DC, CICS WEB Services, Spring

Testing Tools: Mercury Quality Center, HP Quality Center

Messaging: IBM MQ Series, IMS DC, JBOSS MQ

Change Management: ENDEVOR, INFOMAN, CHANGEMAN, REMEDY, Mantis, Librarian

Disaster Recovery: DR Testing

Market Data: IDC, S&P, FED, Fund Serve, DTCC

Scheduling: CA7

Security Manager: Top Secret Security (CA-TSS), Resource Access Control Facility (RACF)

Development Tools: TSO/SPF, Toad, DB Artisan, Share Point, Micro Focus Animator, DATA-XPERT, XPEDITER, FILEAID, CICS/IMS EXPERT, SPUFI

File Transfer: HTTP, FTP, NDM

PROFESSIONAL EXPERIENCE

10/2015 – 05/2016

Axis Technology LLC Business Systems Analyst (Jersey City, NJ)

For Bank of America’s Operations and Technology Compliance Group, following the Agile/Scrum process analyzed regulatory test scripts for sampling independence for each operational stakeholder’s business requirements. Identified gaps in the documentation for the data source and procedures for sampling the data. Remediation of procedures required to incorporate statistical sampling. Identified the law, rule or regulation being tested by the script. Remediation documents developed on two SharePoint sites, sampling and test scripts. SharePoint data downloaded to EXCEL where VLOOKUP was used to include reference data needed for status reporting. DCPs (Data Collection Plans) were created for each test.

02/2015 - 09/2015

Oxford Solutions Inc. Business Systems Analyst (Jersey City, NJ)

For Pershing, LLC’s Product Analyst Group, following the Agile methodology for the Bank Custody project developed business requirements for acquiring end client’s banking products for the web-based advisor Nextx360 platform. Designed DB2 tables as operational data store and mapping to the brokerage profile. This would provide Investors and Advisors with a seamless view of account balances and holdings. Balances for brokerage, bank custody with loan and deposit accounts made available for desktop and mobile trading applications processing on .net/.com and mainframe platforms. All business requirement documents were written in MS Word, which included VISIO process and workflow diagrams for current and future state and wire frame definitions (Collaboration with UX designers) and use cases. All data requirements were included as EXCEL spreadsheets. SharePoint used as depository for all documents.

Analysis of WEB based trading platform functions for the implementation of role based entitlements for bank custody data. Trading functions included Equities, Fixed Income (Bonds, CLO), Mutual Funds and Options. As part of the effort, Order Balancing, Reconciliation and Order Import were analyzed for Functional and Data Type Entitlements. Requirements were gathered for each Entitlement type and role. EXCEL spreadsheet created for each function and sub-function and the Entitlement required. SharePoint used as depository for all documents.

Analysis of the web-based Netx platforms for Globalization of data formats by locale for currency, dates, time, addresses, text, phone numbers and numerical data. This would be applied to base, local, security and account for geographic location, country and currency codes. VISIO was used to create wire frame definitions for the required changes for each data format. EXCEL spreadsheets with the application and functions per wire frame and data mapping definition for the type of required format changes were also created. SharePoint used as depository for all documents. Cost Benefit Analysis was performed for each trading platform.

12/2013 – 07/2014

Princeton Information LLC Business Systems Analyst (Pennington, NJ)

For Bank of America’s Global Wealth & Investment Management and Credit Risk Technology, following the Agile/Scrum process was responsible for the analysis of business requirements and the specifications of a High Level Designs. All design documents were written in MS Word. SharePoint used as depository for all documents.

Document all requirements both business and technical.

Processing was on both mainframe/distributed platforms utilizing COBOL/DB2 and JAVA/Windows 2008 Server.

Collateral Risk Evaluation

The system evaluated market value for various brokerage and banking products across various business units. Single and multiple strategies were used in the allocation of the accounts assets and the evaluation of Credit Risk. Application Context Diagrams were created using VISIO for current and future state. Responsible for the wire frame and use case definition for the various interfaces required.

Move-Money

This allowed clients to transfer cash from Brokerage to Brokerage, Banking or third party accounts using the web-based Merrill Edge platform. Responsible for the wire frame, use case definition and state diagrams for the various interfaces required. All wire frame definitions were created using Visio.

Mortgage Data

Analyzed commercial and consumer mortgage data for best platform (Oracle vs. SQL Server) for required information by defining SQL queries to extract data for data mapping analysis. Cost Benefit Analysis was performed for migration to recommended platforms.

Test Review

Review of testing defects twice weekly, Root Cause Analysis of problem resulting in requirement changes. All defects tracked on HP Quality Center.

6/2010–08/2013

Axis Technology LLC Business Systems Analyst

For Citibank (Warren, NJ), following the Agile/Waterfall process NA the Mainframe Entitlement Simplification Project analyzed existing roles and associated entitlements for Citi Cards and Retail Banking for distributed (Active Directory and LDAP) and mainframe platforms to create an RFP to determine overlapping and uniqueness of resource entitlements granted across all applications associated with functional usage of each entitlement. Documented all application and business owners for each role used. Determined implementation options and target design for entitlements provisioning for reducing over entitlement, separation of duties and toxic combinations. Data Analysis of both CA-Top Secret and RACF security masters by extracting Entitlement information (CFILE) to MS Access tables (SQL) for reporting profile and resource relationships for each acid. Application information was extracted to MS Access tables for determination of obsolete entitlements per security master and to remediate over entitled users by defining SQL queries for targeted result. Project followed the SDLC and documentation standards as required by the PMO. The scope of the project was global with stakeholders in multiple geographic regions. ROI calculation required for each phase.

Review of testing defects twice weekly, Root Cause Analysis of problem resulting in requirement changes. All defects tracked on HP Quality Center.

For Morgan Stanley (New York, NY), data analysis of three (3) security masters, Top Secret Security for the mainframe applications (AD), Entitlement Table I (Oracle) for Client Server applications and Entitlement Table II (Sybase) for WEB applications, for an RFP for a solution to merge the three (3) masters for account entitlements only. This entitlement is at the application level requires combining the attributes for account entitlements into a new single table invoking a new common API across all platforms for user entitlements. This would ensure consistent account entitlement for users across all platforms and applications. This will also ensure authorizations for all current and future accounts in the enterprise regardless of structure.

3/2010- 5/2010

M&B Software Solutions Business Systems Analyst (Jersey City, NJ)

For Jefferies & Co., a major investment bank, following the Waterfall process analyzed trade, settlement and accounting data and processes for a complete system re-engineering effort. This is an Enterprise wide Trading and Settlement system, which processes Trades, Equities and Fixed Income (CLO, Bonds), originating internally and externally from correspondents using FIDESSA, OMEGO and ADP trading platforms. The scope of the project was to re-engineer all applications batch and online infrastructure to a CICS/DB2 (SQL) platform. Documentation standards were followed for analysis, process resolution and data integrity/entity relationship models. This would incorporate DB2 stored procedures, Enterprise COBOL, JAVA on UNIX server and CICS WEB Services.

10/2008-10/2009

M&B Software Solutions Programmer/Analyst (Jersey City, NJ)

For Jefferies & CO., a major investment bank following the Waterfall process re-engineered the Enterprise applications platform from the mainframe host to a WEB service. Based on gathered business requirements and data analysis process requirements and Infrastructure changes were determined. This ultimately enabled Trade distribution and retrieval, auto-allocation and cancel and correction for Equities and Fixed Income instruments (Bonds, CLO). In addition, developed an LDAP/SSO for Authorization and Entitlement for the WEB based functions. Responsible for the wire frame definition and data mapping for the various interfaces required. Documentation standards were followed for analysis, process resolution and data integrity (Current and Future State Flow Diagrams, etc). The system operated under ZOS running COBOL/CICS 3.1, CICS WEB Services using channel and containers with SOAP and WSDL generation using JAVA/JAX-WS on Apache/Tomcat UNIX server with IBM MQ Series. Responsible for UAT testing with business users. Review of testing defects twice weekly, Root Cause Analysis of problem resulting in requirement changes.

03/2008-05/2008

Vedic Consulting Business Systems Analyst (New York, NY)

For Active Health Management, a major health Management Company, managed new requirements and production issues for the Operational Data Store and the Personal Health Record product for commercial clients. The system managed a members health record combining self-entered data with data retrieved from medical care providers. Test defect review with Root Cause Analysis resulting in requirement/design changes. The system presented this data to the member via internet WEB Services. The system leveraged JAVA and Oracle PL/SQL on Microsoft Network servers.

02/2008-3/2008

VIVAT Consulting Inc. Business Systems Analyst (Parsippany, NJ)

For Dunn and Bradstreet, a leading provider of business intelligence as part of an RFP developed an SOA to the mainframe legacy systems to enable leveraging of this data at multiple points in the distributed architecture. Requests were dynamic for specific data elements. The architecture incorporated JAVA running on Microsoft servers and COBOL /CICS/IDMS on the mainframe Z/OS. Cost Benefit Analysis was performed for recommendations.

06/2001-12/27/2006

United Information Technologies Programmer/Analyst (Jersey City, NJ)

For US Trust Company/ Charles Schwab:

ACATS

Responsible for developing business and technical requirements for an account transfer system which interfaced with the Global Wealth/Asset Management System. This project utilized the RUP software development process. UML for use cases, activity diagrams and process flows. Development incorporated the use of the NSCC/ACATS system, IBM MQ Series, Web Client and DB2 (SQL) running ZOS and Windows NT using COBOL and JAVA. GUI design followed standard model for development of WEB applications. Transactions transmitted to and from NSCC for transitioning accounts via NDM for the transfer of equities, fixed income, options and physical securities. Review of testing defects twice weekly, Root Cause Analysis of problem resulting in requirement changes. All defects tracked on HP Quality Center

Mutual Fund Trading

Responsible for business and technical requirements, data mapping and process review for a NSCC/FUNDSERV Mutual Fund Trading system, which interfaced with the Global Wealth/Asset Management System. This project utilized the RUP software development process leveraging Client/server and Mainframe Infrastructure technologies running MS/NT and ZOS using DB2 (SQL) and IMS DB/DC as the database management. GUI for the client/server front end followed a standard model for presentation. Mainframe screens also followed a standard format. System transmitted Mutual Fund Trades to FUNDSERV via NDM and processed trade confirms price and settlement data. Corporate actions were processed by investment type. Review of testing defects twice weekly, Root Cause Analysis of problem resulting in requirement changes. All defects tracked on HP Quality Center

Custody

Following the Waterfall process responsible for business and technical requirements for a custody platform for the parent company. This interfaced with the Broker systems for settlement of REPOs, Mortgage Backed Securities with the FED and provided corporate actions data feedback for accounting purposes from the Global Wealth/Asset Management System. System was written in COBOL using IMS DB/DC as the database management. The system operated in a batch and online mode. Review of testing defects daily, Root Cause Analysis of problem resulting in requirement changes. All defects tracked on HP Quality Center

Acquired Business

Following the Waterfall process responsible for business and technical requirements for the processing of acquired account positions. This required re-engineering trade entry and settlement architecture, which was part of the Global Wealth/Asset Management System to process free, receives/delivers in excess of 500,000 transactions. This required settlement with DTC and the FED with a trade volume of 20,000+ and internal receives and delivers of 500,000 for all security types. The depositories involved settlement of an omnibus position for each security and the execution of internal transactions for each client position. Operating platform included IMS DC/DB/DB2 (SQL) and CICS/DB2 (SQL) using COBOL/LE. During the transition provided support to middle/back office areas for trade settlement and accounting.

Global Wealth/Asset Management

Responsible for the development and support which included front, middle and back office (PNL, GL) online and batch processing for Trade Entry, Settlement (T+2) (FED, DTC, and OTC) and corporate actions (Equity, Fixed Income (Corporate, Government, MBS, ABS, Repos) mandatory/voluntary). Market data (Reference, Pricing data, Corporate Actions) and cost basis accounting are key components. DR testing with DTC and the FED. For SOX compliance developed a wash sales process for Mutual Fund transactions. Operating platform included IMS DC/DB/DB2 (SQL) and CICS/DB2 (SQL) using COBOL/LE. Responsible for the scheduled deployment of software changes to production and daily support. Review of testing defects daily, Root Cause Analysis of problem resulting in requirement changes. All defects tracked on HP Quality Center

03/1997–6/2001

Chase Programmer/Analyst (New York, NY)

Global Wealth/Asset Management

For the bank’s Global Information Systems managed the support and development of a Global Wealth/Asset Management System, which provided front, middle and back office (PNL, GL) online and batch processing. The core-integrated systems are Trade Entry, Trade Settlement (T+2) (FED, DTC, and OTC), Corporate Actions (Equity, Fixed Income (Corporate, Government, MBS, ABS, Repos), mandatory/voluntary, Market data (Reference, Pricing data, Corporate Actions), cost basis accounting.

Responsibilities included requirements gathering, design and software architecture, DR testing, DTC and the FED. Application development included Data Warehouse, trade transmissions (ISITC, SWIFT), EURO re-denomination, Y2K, acquired business, regulatory upgrades, client transmissions and business platform transfers (Titan). Upgrade of Real time settlement of securities through DTC using MQ Series. Responsibilities included performance reviews, project budgets, and the ordering of desktop equipment and software. Operating platforms included IMS DC/DB/DB2 (SQL) and CICS/DB2 (SQL) using COBOL II.

01/1988-3/1997

Financial Technologies International Programmer/Analyst (New York, NY)

Wealth/Asset Management

Responsibilities included the support and enhancement of front, middle and back office (PNL, GL) online and batch processing. Four client banks required change management for base and custom software. The Core-Integrated systems are Trade Entry, Security Movement and Control, Settlements, Corporate Actions (Equity, Fixed Income (Corporate, Government, MBS, ABS, Repos,) mandatory/voluntary, Reference and Pricing data, Physical Transfer and Cost Basis Accounting. Responsibilities included the response to RFI and RFP requests, scheduling of enhancements, maintenance and production issues and the review of all requirements with the client's business owners. Responsibilities included the delivery of base and custom software to client sites. Operating platform included IMS DC/DB and DB2 (SQL) using COBOL II.

GL Proof and Control

Following the Waterfall process was responsible for developing business and technical requirements for a Proof and Control Reporting System for a multi-currency GL accounting product using Client/Server Architecture. The construction was accomplished using Knowledge Ware’s ADW case tool. PC based testing was accomplished using Micro Focus Animator and XDB for the Relational Data Base Management. The system operated on a Mainframe platform using Micro-focus COBOL under CICS/DB2 (SQL) and running Client/Server under OS/2.

Global Wealth/Asset Management

Managed the development of multi-currency features for the Corporate Actions (Equity, Fixed Income (Corporate, Government, MBS, ABS, Repos), mandatory/voluntary, Market data (Reference, Pricing data, Corporate Actions), Bankers’ Acceptance. After implementation was the responsible for valued-added enhancements and daily production issues including Trade Entry, Settlement and Accounting (PNL, GL), online and batch in addition to QA and change control. Responsibilities included the response to RFI and RFP requests, business and functional requirements, technical specifications. All development followed clients required SDLC. Operating platforms included IMS DC/DB using VS COBOL.

EDUCATION

B.A. Brooklyn College Cognitive Psychology/Computer Science 2004

Personal Skills

Mentoring, team player, dedicated, self-starter, proactive, multi-tasking and responsible.

Contact this candidate