Data Architect Resume Profile
SUMMARY:
27 years of in-depth experience in data processing. A solid analyst and technician who has participated in all phases of project development: from project management/leadership management, training, support, feasibility studies including Request for Information in Buy vs. Build cost/benefit analysis projects, Request for Proposals, product presentations , budgeting, planning, gap, impact, data business analysis and requirements gathering definition with users through systems analysis, functional specifications, process mapping, data mapping, process flow generation, reengineering, video conferencing, backend and frontend developer design, coding, detail oriented automated and manual testing from data testing to look/feel testing , quality assurance, implementation, disaster recovery, technical architecture, technical writing handbooks, runbooks , workflow and document management. Extensive online experience with several database systems and Object Oriented data modeling DBA on multiplatform computer systems IBM, ORACLE, UNIX, UNISYS PC networks . Excellent communication skills in English, French, Hebrew and Arabic fluent speaking, reading and writing . Able to describe problems and explain behavior with other team members. Not afraid to approach others or ask questions. Self-Motivated, solutions engineer, outside of the box thinker, problem identifier cross-department facilitator in all industries such as Publishing, Broadcasting, Financial, Manufacturing, Pharmaceutical Government.
HARDWARE:
IBM Z/OS, OS390, 30XX, 370, ES9000, 3090, 3390, 3880, 3480, 4300, PRINTER 3800/4245/4248, XEROX PRINTER EPS 180, UNISYS PRINTER 8250, PC, XT, AT, PS/2, 386, 486, PENTIUM, COMPAQ, INTEL 8080, LAPTOPS, MACINTOSH W/HYPERCARD , SERIES/1, STRATUS, SUN SPARC STATION, MULTIPLATFORM DISTRIBUTED COMPUTING
SYSTEMS:
MVS / XA/ ESA, TSO/ISPF, VM/CMS, RACF, ENDEVOR, WYLBUR, ROSCOE, JCL/UTILITIES, DOS/VSE, VOLLIE, XEDIT, REXX, SMS, SAR, CA-SCHEDULER, CA-1, CA-7, CA-11, DIALOG MANAGER, UNIX, NOVELL NETWARE LAN, OS/2, WINDOWS 3.1, 95, 98, 2000, XP NT, .NET, NETSCAPE, MS OFFICE
LANGUAGES:
COBOL II, PL/l, COBOL REPORT WRITER , NATURAL 1 2, BAL W/MACROS , FORTRAN, C, C , XML, MICRO FOCUS COBOL, ALGOL
SOFTWARE:
CICS COMMAND, MACRO, BMS, MRO, ISC, SDF, INTERTEST, DMS, EDF, XPEDITER, ONLINE TEST DEBUG , ASG SMART TEST, IMS/DB, ADABAS NATURAL 1 2 , PREDICT, ADASCRIPT, ADAMINT, DIRECT CALLS , SYSTEM 2000, DB2 EMBEDDED SQL, SPUFI, QMF, PROEDIT , BMC SYNCSORT, VTAM / TCAM MESSAGE SWITCHING, XDB, SQL/DS DBSU, ISQL , IDMS ADSO , FILE-AID, APS, HPS, FOCUS, IRMA, RUMBA, BACHMAN, VSAM/DB2 CONVERSION, PL/SQL, KNOWLEDGEWARE IEW ADW, WORDSTAR, MULTIMATE, SPSS, MS OFFICE/PROJECT/WORD/EXCEL/
OUTLOOK/ACCESS/VISIO/POWERPOINT, PHOTOIMPRESSION, CA E-SECURITY,VISUAL BASIC, COMMUNICATIONS MANAGER, LOTUS NOTES, OMEGAMON, RMFMON, PLATINUM, POWERBUILDER, MANTEC, Misys/CMS, MUREX, METASTOCK, ESIGNAL, REUTERS, BLOOMBERG, SYSTEMATICS, ORACLE ORACLE SPL WORLD/CC B CUSTOMER CARE AND BILLING , INFORMIX, INFOMATIX/MSA, IBM CPCS
APPLICATIONS:
BANKING TRUST/CUSTODY, FTI RE-AL, MONEY TRANSFER SWIFT, EDI , COMMERCIAL LOAN, RISK RATINGS, SWAPS, OPTIONS, MULTI-CURRENCY FOREIGN EXCHANGE, WHOLESALE, CAPITAL MARKETS, RISK, BANK MERGERS, RETAIL, CREDIT CARDS, FINANCIAL , BROKERAGE PORTFOLIO MANAGEMENT SYSTEMS, FIXED INCOME, ASSET MANAGEMENT, CAGE, GAIN/LOSS, TREASURY, SECURITIES, OPTIONS, DERIVATIVES, CREDIT DEFAULT SWAPS CDS , REPOs, RECONCILIATION, CORPORATE ACTIONS, REATAIL. TRADE SETTLEMENT PROCESS T 5, T 3 , MUTUAL FUNDS, TAPS , BUSINESS PROCESS REENGINEERING, TRANSPORTATION, HEALTH MEDICAID , PHARMACEUTICAL HIPPA , INSURANCE, TV, PUBLISHING, GOVERNMENT, CLAIMS, PERSONNEL, PAYROLL, BILLING, PENSIONS, DATA DICTIONARIES, INFORMATION ARCHITECTURE, WIREFRAMING, PROTOTYPING, MANUFACTURING DATAWAREHOUSING, DATA MIGRATION, PURSHASING, INVENTORY, BUDGETING , CHECK PROCESSING, ORDER ENTRY, QUALITY ASSURANCE, UTILITY TELEPHONE/TELECOM/ ELECTRIC , ADVERTISING, ACCOUNTING A/P, GL , AUDITING, DATA MODELING, CONSTRUCTION, JAD/STRADIS/YOURDON, SIX SIGMA, SDLC, SLAs , DISASTER RECOVERY, REGULATORY, COMPLIANCE
EXPERIENCE:
- Confidential
- DATA ARCHITECT, SENIOR PROGRAMMER ANALYST, SDLC, SLAs, ACCESS, DB2, SQL, CICS, COBOL II, VSAM, BMC SYNCSORT, QMF, CONNECT, FTP, JES2, ADABAS, NATURAL, ACTIVE X, .NET, C, C , ADO.NET, HTML, XML, MS OFFICE WORD, EXCEL, VISIO, POWERPOINT, PROJECT, SIX SIGMA, Z/OS, MVS / XA/ ESA, ENDEVOR, XPEDITER, ONLINE TEST DEBUG, EASYTRIEVE, FILE-AID, JCL, UTILITIES, XPEDITER, EMC, SMS, SAR, CA-SCHEDULER,CONTROL-M, MQSERIES, IBM THINKPAD
- As Business Analyst, auditor, tester, developer, interviewed managers and Licensing, customer service triage, counter operations, Adjuducation of trial cases Vehicle/Base Inspections personnel, researched technically TAMIS WEB based ACCESS , gathered business requirements, generated workflows vehicle inspections and specification write-ups documenting the business processes for driver, vehicle, business base, medallion licensing. Presented current state and future state recommendation using Service Oriented Architecture SOA top down best practices patterns relating to design decisions to be made, ranging from data-orientation to the problems of legacy integration and security to deputy and assistant commissioners. Recommendations were made after monitoring other government agency systems such as Workmen's Compensation, Department of Motor Vehicles and the Buildings Information systems. Worked closely with the users to understand implement business needs, Adjudication DMV interfaces, translated business needs into detailed requirements VISIO workflow diagrams WORD narrative documentation , extracted appropriate information from rich data sources, analyze results, and present findings and recommendations. Responsible for reviewing requirements, analyzing the impact of the requirements on development, and bringing any resulting issues to the attention of the project manager. Developed COBOL/CICS programs and SQL queries to extract license renewal candidates from tables containing data extracted from TAMIS. Performed manual testing of computer systems and human work processes.
Confidential
- DATA ARCHITECT, SENIOR PROGRAMMER ANALYST, DB2, COBOL, ALGOL, ECL, JCL, FTP BMC SYNCSORT, MS OFFICE WORD, EXCEL, VISIO, PROJECT, IBM, UNISYS, AQUANTA, UTILITIES, XPEDITER, ARCHIVING, SMS, SAR, DEPCON, OUTPUT, SDLC
- As business Analyst/Facilitator/Tester/Educator, coordinated efforts to develop Welfare Management System subsystems and their System Reference Manual chapters. Conducted interviews and training sessions with users, team leads and programmers of projects that support the mainframe systems, running and monitoring reports. Performed reviews of current documentation, business processes, Mainframe runbooks, workflows, development of COBOL programs and testing of subsystems using SDLC methodology., Disaster Recovery, CPU, virtual tape and DASD requirements. Generated Local/Host Worker Mode Application, Eligibility, Transaction Cancellation, Electronic Benefits Transfer EBT Pull, Automated E-check Issuance and Archive Retrieval subsystem chapters using WORD, EXEL with VISIO diagramming and data modeling. Performed manual testing of computer systems and human work processes of Welfare Public Assistance and Medicaid coverage.
Confidential
- DATA ARCHITECT, SENIOR PROGRAMMER ANALYST, SYNCSORT, DB2, CICS, COBOL II, QMF, CONNECT, VSAM, FTP, .NET, C, C , ADO.NET, HTML, XML, MS OFFICE WORD, EXCEL, VISIO, POWERPOINT, PROJECT, Z/OS, MVS / XA/ ESA, ENDEVOR, EASYTRIEVE, FILE-AID, JCL, UTILITIES, XPEDITER, EMC, SMS, SAR, CA-SCHEDULER,CONTROL-M, MQSERIES, LOTUS NOTES, POWERBUILDER
- As business analyst, production support QA engineer, implemented retail banking conversion of accounts regulatory Compliance, involving the transaction swapping Bank of New York retail account business with the JPMorgan Trust Investment accounts. Developed new COBOL programs for feed functionality. Performed manual testing of computer systems and Human Resources Billing work processes. Utilized ASG-SmartTest ENDEVOR XPEDITER for interactive source-level debugging of the COBOL application programs.
Confidential
- DATA ARCHITECT, SENIOR PROGRAMMER ANALYST, DATACOM, DB2, CICS, PL/1, COBOL II, DOS/VSE, VOLLIE, QMF, CONNECT, FTP, .NET, C, C , ADO.NET, HTML, XML, MS OFFICE WORD, EXCEL, VISIO, POWERPOINT, PROJECT, Z/OS, MVS / XA/ ESA, LIBRARIAN, ENDEVOR, XPEDITER, ONLINE TEST DEBUG, EASYTRIEVE, FILE-AID, JCL, UTILITIES, VSAM, XPEDITER, EMC, SMS, SAR, CA-SCHEDULER,CONTROL-M, MQSERIES, IBM THINKPAD
- As business analyst, production support engineer and developer, developed tested PL/1, COBOL update and report functions and programs to support FX MANTEC application, Compliance, Fixed Income, options derivatives, the conversion to Cash Manager application and MQ, FTP and SWIFT feeds. Performed manual testing of computer systems and human work processes. Utilized ASG-SmartTest, ENDEVOR XPEDITER for interactive source-level debugging of the COBOL PL/1 application programs.
Confidential
- DATA ARCHITECT, SENIOR PROGRAMMER ANALYST, DB2, CICS, COBOL II, VSAM, IMS, CONNECT, FTP, JES2, .NET, C, C , ADO.NET, HTML, XML, MS OFFICE WORD, EXCEL, VISIO, POWERPOINT, PROJECT, Z/OS, MVS, ENDEVOR, FILE-AID, JCL, UTILITIES, XPEDITER, EMC, SMS, CA-SCHEDULER, CA-7, CA-11, CA-1, UNICENTER, CONTROL-M, SOX, MQSERIES, IBM THINKPAD, ORACLE
- As Mainframe Support Engineer, coordinated auditing efforts to generate current state assessment documentation of the Infrastructure systems and operations. Conducted audit by interviewing SMEs, team leads and programmers of projects and shadowing operations shift managers and operators that support the mainframe systems, running and monitoring reports and analyzing cost/benefits. Reviewed current documentation, business processes, Mainframe runbooks and JCL standards/operation, current processes, workflows, staff skills, change management effectiveness, Disaster Recovery, CPU, OS, CICS, tape and DASD requirements. Generated documentation using WORD and VISIO diagramming.
- Generated an audit scorecard of systems and applications update and reporting efficiency, job run concurrency and future state recommendations along with business continuity SYSPLEXinng and Capacity Planning. Performed technical analysis across time zones, data centers, installations and applications. Performed manual testing of computer systems and human work processes.
Confidential
- DATA ARCHITECT, SENIOR PROGRAMMER ANALYST MS OFFICE, SYNCSORT APS, DB2, CICS, VSAM, COBOL II, DOS/VSE, VOLLIE, QMF, CONNECT, FTP. MS OFFICE WORD, EXCEL, VISIO, POWERPOINT, PROJECT, Z/OS, MVS / XA/ ESA, LIBRARIAN, ENDEVOR, EASYTRIEVE, FILE-AID, JCL, UTILITIES, XPEDITER, EMC, SMS, SAR, CA-SCHEDULER,CONTROL-M, MQSERIES, IBM THINKPAD
- Online and batch programming and testing of PHOENIX Group Insurance system/Property and Casualty Insurance Billing applications.
Confidential
- DATA ARCHITECT, SENIOR PROGRAMMER ANALYST, DB2, CICS, COBOL II, SYNCSORT QMF, FTP, MS OFFICE WORD, METASTOCK, REUTERS, EXCEL, VISIO, POWERPOINT, PROJECT, ERWIN, .NET, C, C , ADO.NET, HTML, XML, MERCURY WINRUNNER, LOADRUNNER, VSAM, Z/OS, MVS / XA/ ESA, FILE-AID, JCL, UTILITIES, XPEDITER, EMC, SMS, SAR, CONTROL-M, MQSERIES
- Coordinated efforts to convert LU6.2 to MQ/IP inter-company communication i.e. SIAC new correspondent companies merger . Performed analysis, design and implementation of P L Customer/Street Trades Batch Match reconciliation in Retail Brokerage, Data Migration cutting down the evening run window from 4 hours to 1 hour. Performed Data Modeling, analysis, design and implementation of Prime Broker Self Directed Broker SDB By Plan Id Risk reporting system, CICS menu driven online Inquiry system and ALERT Memo, Audit .NET online interfacing with DB2 extract programs. Coordinated Trades Firm Pricing interfacing with correspondents Market Data. Utilized Unified Modeling Language UML to draw Use-case to Platform diagrams, Rational Unified Process RUP for program development.
Confidential
- DATA ARCHITECT, SENIOR PROGRAMMER ANALYST, DB2, CICS, COBOL II, QMF, ONLINE TEST DEBUG, FTP, MS OFFICE WORD, EXCEL, ACCESS, MESSENGER, VISIO, ADW, POWERPOINT, PROJECT, UNIX, VSAM, MVS / XA/ ESA, FILE-AID, JCL, UTILITIES, XPEDITER, VM, EMC, PBX, SMS, SAR, CA-SCHEDULER, CA-1, CA-7, CA-11, CA E-SECURITY UNICENTER, ACF2, RACF, MQSERIES
- Coordinated efforts to convert multiplatform security of 17 CICS regions, MQSERIES and DB2 from IBM RACF to CA-ACF2.
- Generated project plans, performed systems analysis and development technical support as lead tester and programming also maintaining batch cycles at night. Generated Statement of Work and Detail Design documents. Managed 20 person staff assigning functional and detailed specifications. Performed manual testing of computer systems and human work processes.
Confidential
- DATA ARCHITECT, SENIOR PROGRAMMER ANALYST, CICS, COBOL II, VSAM, DB2, JES2, MS OFFICE WORD, EXCEL, ACCESS, MESSENGER, VISIO, POWERPOINT, UNIX, SPUFI, SYBASE, PL/SQL, PERL, FTP, NDM, MVS / XA/ ESA, STRATUS, FILE-AID, JCL, UTILITIES, ADABAS NATURAL 1, 2.8 , RACF, XPEDITER, VM, EMC, PBX, SMS, SAR, METASTOCK, REUTERS, E-SIGNAL, CA-SCHEDULER, CA-1, CA-7, CA-11, CA E-SECURITY UNICENTER, MQSERIES, VTAM / TCAM MESSAGING, COMPAQ SERVERS, BRIDGE
- Designed and implemented TAPS Delivery and Allocation of Securities batch and online reports to replace the equivalent reports generated by BTSI package Multi-Currency Foreign Exchange Gain/Loss transactions and reports . Involved in processing of Trade Settlement Process T 5 , Continuous Net Settlement DTC tapes, FTI Security Master and in the segregation processing of securities. Coordinated and implemented test plans and a STRATUS machine interface for Index Pricing. Extensive problem solving situations around the clock 24/7 .
- Performed analysis, design using VISIO, WORD and programming of Disaster Recovery system DRIP utilizing new 4 byte UCB format at the pack level clipping VOLSERs . Required a series of batch job streams and online menu driven functions with test plan coordination. Extensive production support problem solving situations around the clock 24/7 . Worked with Storage Management Systems SMS and IBM / TIVOLI ADSM ADSTAR Distributed Storage Management facility for mainframe, PC and zip drives .
- Lead Business Analysis using VISIO, WORD , project management and interviewing comptroler users defining system current state, future state enhancements and technical writing handbooks and runbooks onto specifications documents, design and programming NATURAL 2.8 1, COBOL II of 2 CIS FX Multi-Currency Revenue Budgeting update and reporting Gain/Loss transactions system projects: a Front Sales Registered Representative Coverage. b New CAPRI-CIS TAPS trades feed replacing the old RV trades feed Data Migration. Extensive production support problem solving situations around the clock 24/7 . Both projects interface with UNIX SYBASE SQL tables. Determined Currency Re-evaluation Rules and Rates. Batch job streams and online menu driven programs. Coordinated planning/budgeting/technical product selection/ evaluation/cost-benefit, product presentations, total cost of ownership analysis, test plans, high level acceptance testing, quality assurance, vendor, candidate interviews and task assignments to programmers. Met with users in the effort to implement Business Process Reengineering of their Asset Under Management using Enterprise Resource Planning ERP Goals streamlining Components and Boundary, Derivatives and Risk business procedures videoconferencing and eventually translating the results to new technology. Determined Currency Re-evaluation Rules and Rates. Converted VSAM NATURAL access to DB2 on Trade Completion project. Functioned as data modeling DBA. Utilized SWIFT for message formatting, data mapping and retail banking funds transfer VTAM / TCAM MESSAGE SWITCHING . Used VISIO for data mapping of the SWIFT variable size tagged messages process flow generation. Utilized FPL FIX Protocol/SWIFT to improve STP Straight Through Processing for message formatting and transfer in pre-trade, trade execution and post-trade domains.
Confidential
- DATA ARCHITECT, SENIOR PROGRAMMER ANALYST, COBOL II, APS, CICS, VSAM, SAR, DB2, STORED PROCEDURES, SPUFI, QMF, VSAM, PROEDIT, FILE-AID, MS OFFICE, OUTLOOK, EXCEL, VISIO, WORD, POWERPOINT, ACCESS, PROJECT, LOTUS NOTES, FTP, JCL, UTILITIES, XPEDITER,VM/CMS, ENDEVOR, RACF, DMS, METASTOCK, REUTERS, E-SIGNAL 3rd project at co.
- Business analysis and interviewing users of existing Multi Currency Foreign Exchange Financial Control System Risk Management, Global Credit Risk Based Capital Markets netting regulatory compliance financial Gain/Loss transactions reporting system. Produced current state processing, future state enhancement specifications and technical writing handbooks, SOPs, SLC and runbooks using VISIO for data mapping process flow drawing, WORD documentation of Asset Management, Credit Derivatives, Credit Default Swaps CDS REPOs premium determination reduced modeling vis- -vis credit risk per issuer as compared to treasury bonds default-free benchmark, Currency Re-evaluation Rules and Rates, Interest Rate Currency Swaps, FX Spot Forward, Precious Metals, Interest Caps Floors, FX Options, Swap Options, London Swap Options, Equity Options, Future Rate Agreements FRAs and Equity Swaps. Extensive problem solving situations. Converted VSAM access to DB2 QMF. Coordinated bank merger planning/budgeting/technical product selection/evaluation/cost-benefit, total cost of ownership analysis in choosing the JPMorgan Glamour comptroler FCS system vs. the Chase GES counterpart FCS system test plans, high level acceptance testing, quality assurance and candidate interviews. Utilized SWIFT for message formatting, data mapping the variable size tagged messages and transfer VTAM / TCAM MESSAGE SWITCHING . Performed impact analysis and production Change Management interfacing with all management levels.
Confidential
- DATA ARCHITECT, SENIOR PROGRAMMER ANALYST, COBOL, CICS COMMAND , VSAM, ORACLE SPL WORLD/CC B
- Performed business analysis, designed, programmed implemented a complete Data Dictionary system from data element forms through VSAM file structure for INFOMATIX/MSA General Ledger system interfacing with the billing systems. Wrote documentation and completed implementation plan utilizing the STRADIS Structured Analysis methodology.
Confidential
- DATA ARCHITECT, SENIOR PROGRAMMER ANALYST, COBOL II, MVS / XA/ ESA, COBOL, CICS, DB2, SPUFI, VSAM, PL/1, NATURAL, QMF, PROEDIT, FILE-AID, HPS, MS OFFICE, EXCEL, OUTLOOK, POWERBUILDER, FTP, JCL, UTILITIES, XPEDITER, RACF, CA-SCHEDULER, CA-1, CA-7, CA-11, AFP, COMPAQ SERVERS, BLOOMBERG MARKET DATA
- Business Analysis, design and programming of Trade Entry Operations vis- -vis the trade settlement process T 3 , Fixed Income, Prime brokerage, Billing, Hedge and Firm Pricing interfacing with Bloomberg Market Data, Multi-Currency Foreign Exchange, Gain/Loss transactions and regulatory compliance reporting, IDSI International Dataline and SIRS. Used VISIO for data mapping process flow drawing. Determined Currency Re-evaluation Rules and Rates. Converted VSAM database to DB2. Functioned as data modeling DBA. Coordinated planning/budgeting/technical product selection/ evaluation/ cost-benefit, total cost of ownership analysis, test plans, high level acceptance testing, quality assurance, vendor and candidate interviews. Met with users in the effort to implement Business Process Reengineering of their business procedures videoconferencing eventually translating the results to new technology. Performed manual testing of computer systems and human work processes.
Confidential
- DATA ARCHITECT, SENIOR PROGRAMMER ANALYST, COBOL II, DB2, SPUFI, CICS, VSAM, FILE-AID, PLATINUM, PROEDIT, INTERTEST, MS OFFICE, OUTLOOK, VISUAL BASIC, XPEDITER, JCL, UTILITIES, MVS / XA/ ESA, EASYTRIEVE
- On the Commercial Loan Management Information System CLMIS , responsible for: 1. The full development of the Multi Currency Foreign Exchange Global Portfolio Credit Risk MIS Telescopic and Historical CICS/ADABAS/PC system. Credit Default Swaps CDS premium determination vis- -vis credit risk per rating sector as compared to treasury bonds default-free benchmark. Supervised and assigned tasks to programmers. 2. The incorporation of major enhancements to the Accounting Adjustments online and batch Gain/Loss Transaction systems. Determined Currency Re-evaluation Rules and Rates. Generated specifications document of existing system for business and systems analysis purposes. 3. Recovery processing using image backup. Involved in conversion from CICS 1.6 to CICS 1.7. Functioned as data modeling DBA. Applied Business Process Reengineering techniques to user business procedures videoconferencing eventually translating the results to new technology.
Confidential
- DATA ARCHITECT, SENIOR PROGRAMMER ANALYST, COBOL II, DB2, SPUFI, VSAM, CICS, FILE-AID, SYSTEMATICS RECEIVING, FABRICATION, SHIPPING , VISUAL BASIC, MS OFFICE, OUTLOOK, XPEDITER, JCL, UTILITIES, CA-SCHEDULER, CA-1, CA-7, CA-11, MVS / XA/ ESA,
- Performed Retail Banking Merger analysis, design and implementation of Branch Information Delivery Systems Information Processor Host Re-Engineering to concurrently process merged data from the two banks cutting down run time by 6 times. Converted DB2 database access to VSAM. Applied Business Process Reengineering techniques to user business procedures videoconferencing eventually translating the results to new technology.
Confidential
- Data Modeler, DATA ARCHITECT, SENIOR PROGRAMMER ANALYST, ADW, DB2, XDB, COBOL II, MICRO FOCUS COBOL, FTI RE-AL, EXCEL, RUMBA, COMM. MAN., XPEDITER
- Reformatted incoming Multi Currency Foreign Exchange SWIFT messages and Gain/Loss transactions into FTI RE-AL message format. Utilized online Interface Generator IFG and ADW business analysis and design workstations to generate IFG SWIFT FTI Security Master data model mappers, controllers and extraction methods. Functioned as data modeling DBA. Created Data dictionary. Determined Currency Re-evaluation Rules and Rates. Used EDI Imaging for funds transfer.
Confidential
- PROGRAMMER ANALYST, DATA ARCHITECT, SENIOR PROGRAMMER ANALYST, COBOL, IMS/DB
- Designed and coded an End-Of-Year Audit Trail subsystem for the Advertising Broadcasting Accounting Department.
- As business analyst liaison, met with users in the effort to implement Business Process Reengineering of their business procedures videoconferencing eventually translating the results to new technology. Performed manual testing of computer systems and human work processes.
Confidential
- DATA ARCHITECT, SENIOR PROGRAMMER ANALYST, FILE-AID, APS, DB2 SPUFI, QMF, PROEDIT , COBOL, COBOL II, CICS, FOCUS, VSAM, XPEDITER, ORACLE
- Responsible for the business and object oriented systems analysis, design and implementation of online and batch programs for Trademark, Benefits, Pensions TEFRA , Human Resources, Billing, PAC Political Action Committee Regulatory Compliance , Electronic Funds Transfer systems for expense check processing using IBM CPCS Check Processing Control System . Functioned as data modeling DBA. using EDI Imaging. Applied Business Process Reengineering techniques to user business procedures videoconferencing eventually translating the results to new technology.
Confidential
- PL/l, CICS COMMAND , VSAM , SERIES/1
- Coordinated, designed and programmed Scheduled Billing of microprocessor meters DSU's found at customer sites. Implemented SERIES/1 interface.
Confidential
- SENIOR DATA ARCHITECT, SENIOR PROGRAMMER ANALYST, Data Modeler NATURAL 2, DB2, SPUFI, IEW/ADW WORKBENCH Case Tool, CICS, JAD, BACHMAN, IDMS
- Performed business and systems analysis, design and coding of a Marketing, Spending, and Tracking Promotion system Budgeting, Release Processing . Utilized IEW Analysis, Design, data mapping, Re-engineering DA LINK and BACHMAN workstations to generate DB2 Logical Data Design. Applied Business Process Reengineering techniques to user business procedures videoconferencing eventually translating the results to new technology. Functioned as data modeling DBA.
Confidential
- DATA ARCHITECT, SENIOR PROGRAMMER ANALYST, COBOL, CICS COMMAND, MRO , VSAM, IDMS, ADSO, XPEDITER
- Designed and implemented Money Transfer UNIFORM message switching system that provided communication between external to the bank Multi Currency Foreign Exchange SWIFT IBM DSL and the bank's internal Domestic, Retail and International Money Transfer systems. Worked on Federal Reserve and CHIPS message processing online systems including VTAM / TCAM MESSAGE SWITCHING. Converted IDMS access to VSAM.
Confidential
- DATA ARCHITECT, SENIOR PROGRAMMER ANALYST, PL/1, COBOL, CICS MACRO, COMMAND, MRO , VSAM, XPEDITER, IMS/DB DL/1
- Analysed, researched and documented DCAP and backoffice trade processing system.
Confidential
- DATA ARCHITECT, SENIOR PROGRAMMER ANALYST, NATURAL 1 2, PREDICT, VSAM, CICS, IEW, DOS/VSE
- Designed and implemented online Inventory, Order Entry, Co-oprative Advertising and batch Invoicing Purchasing systems. Project Leader responsible for training programmers.
Confidential
- APPLICATION DEVELOPMENT: CICS, DB2, SPUFI, VSAM, COBOL, VM/CMS, REXX
- Performed analysis, design and implementation in an HP to IBM conversion of an online and batch Accounts Receivable system.
Confidential
- APPLICATION DEVELOPMENT: SQL/DS, COBOL, REXX, VM/CMS
- Designed, coded and tested programs on a Marketing, Research and Planning system.
Confidential
- DATA ARCHITECT, SENIOR PROGRAMMER ANALYST, MS OFFICE, MULTIPLATFORM MF, PC RELATIONAL DATABASE MANAGEMENT SYSTEMS
- On the Commercial Loan Management Information System CLMIS , responsible for: 1. The full development of the Risk Management Multi Currency Foreign Exchange Global Portfolio MIS Telescopic and Historical CICS/ADABAS/PC system. Supervised and assigned tasks to programmers. 2. The incorporation of major enhancements to the Accounting Adjustments online and batch Gain/Loss Transaction systems. Determined Currency Re-evaluation Rules and Rates. Generated specifications document of existing system for business and systems analysis purposes. 3. Recovery processing using image backup. Involved in conversion from CICS 1.6 to CICS 1.7. Functioned as data modeling DBA.
Confidential
- APPLICATION DEVELOPMENT: DB2 SPUFI, QMF , COBOL, COBOL II, CICS
- Designed and coded a Residual Customer Payment system using IBM CPCS Check Processing Control System . Created a high level test plan and tested Residual processing vis-a-vis agreements in effect and account subsetting over a two year period.
Confidential
- PROGRAMMER ANALYST, DATA ARCHITECT, SENIOR PROGRAMMER ANALYST, PL/l, CICS MACRO , VSAM
- Designed and implemented an online system to track election results, analyze current key precinct and historical data projecting election outcomes on election night broadcasting. As business analyst liaison, met with users in the effort to implement Business Process Reengineering of their business procedures videoconferencing eventually translating the results to new technology vis- -vis promotions, sales and rating systems. Performed manual testing of computer systems and human work processes.
Confidential
- Trust Division: BUSINESS ANALYST, MAINFRAME DATABASE MANAGEMENT SYSTEMS
- Developed the Trade Order Processing System TOPS for Repo's, buy rights instruction entry during the Trade Settlement Process T 5 , Allocation Processing and Commission Reporting. Met with users to do business analysis and presentations. Designed the CICS application Restart/Recovery mechanism including Imaging for recovery. Converted performed manual testing of computer systems and human work processes. Determined Currency Re-evaluation Rules and Rates.
Confidential
Designed and implemented an online Planning and Budgeting system for the international and national Multi Currency Foreign Exchange banking divisions vis- -vis Gain/Loss transactions. CICS/BMS instructor. Evaluated SYSTEM 2000 - IMS/DB DL/1 similarities. Functioned as data modeling DBA.
Confidential
- APPLICATION DEVELOPMENT: PL/l, DB2, SPUFI, QMF, CICS, VSAM
- Designed and coded Personnel Payroll and Insurance Claim Exception reporting programs. Converted VSAM to DB2.
Confidential
- DATA ARCHITECT, SENIOR PROGRAMMER ANALYST, PC FILE SERVER
- Impemented enhancements to the Trading, Reconciliation, Accounting and Clearance System TRACS an online international Multi Currency Foreign Exchange brokerage system having to do with the Trade Settlement Process T 5 .
Confidential
- DATA ARCHITECT, SENIOR PROGRAMMER ANALYST, MULTIPLATFORM MF, MACINTOSH DATABASE MANAGEMENT SYSTEMS
- Performed Business Analysis and design of an online Mutual Funds system.
Confidential
- DATA ARCHITECT, SENIOR PROGRAMMER ANALYST, MAINFRAME RELATIONAL DATABASE MANAGEMENT SYSTEMS
- Applied data security onto an existing Multi Currency Foreign Exchange Global Exposure system. Performed business analysis of the system. Converted VSAM database and access to DB2. Functioned as data modeling DBA.
Confidential
- APPLICATION DEVELOPMENT: PL/l, ADABAS ADAMINT
- Coded and tested programs on a Retail Banking Credit Card system interfacing with HOGAN software.
Confidential
- APPLICATION DEVELOPMENT: COBOL REPORT WRITER , ADABAS DIRECT CALLS, ADAMINT, ADASCRIPT, NATURAL , VSAM, ISAM, CICS MACRO , DMS, FORTRAN, PL/1, SPSS, VM/CMS, ALGOL, C
- Involved in the design of MEDICAID claim processing and an online Medical Information system interfacing with users. Used NATURAL and ADASCRIPT to inquire and update the Lead Poisoning ADABAS file in online and batch modes. Designed, programmed and directed implementation of a batch system to grade lab test facilities against reference lab guidelines. Documented and updated a system of FORTRAN programs. Interfaced with NYC agencies such as FISA and the Bureau of Labs.