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

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, MICRO Focus Cobol

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:

Confidential, Jersey City, NJ

Business Systems Analyst

Responsibilities:

• For Confidential ’s 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 in corporate 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.

Confidential, Jersey City, NJ

Business Systems Analyst

• For Confidential ’s 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.

Confidential, Pennington, NJ

Business Systems Analyst

• For Confidential ’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.
• 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.
• 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.
• 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.
• Review of testing defects twice weekly, Root Cause Analysis of problem resulting in requirement changes. All defects tracked on HP Quality Center.

Confidential, Jersey City, NJ

Business Systems Analyst/Developer

• 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.
• 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.

Confidential, Jersey City, NJ

Senior Developer/Analyst

• For Confidential., 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 in corporate DB2 stored procedures, Enterprise COBOL, JAVA on UNIX server and CICS WEB Services.

Confidential, Jersey City, NJ

Senior Developer/Analyst

• For Confidential., 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.

Confidential, New York, NY

Business Systems Analyst

• For Confidential, 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.

Confidential, Parsippany, NJ

Business Systems Analyst/Developer

• For Confidential, 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.