IT Analyst - Application Developer
IT Analyst & Application Developer with a BA in (Computer Science),and more than 20 years of technology development, Quality Assurance Testing, and leadership experience in fulfilling critical corporate objectives, from conception to deployment for organizations such as MUFG Union Bank, Merrill Lynch, NYCHHC, Shearson Lehman/Smith Barney/Citigroup.
Currently, consulting at BOFA (Merrill Lynch), as a Production Support Analyst at BAML Financing & Clearing Options Management System support team. Troubleshooting and resolving Production Incidences and/or Service Requests. Writing SQL queries against Oracle databases resolving Adhoc requests; Utilizing SQL, COBOL, JCL, DB2, VSAM, Tablebase, File Manager, CICS, PODS and Endevor on Mainframe Platform for MLPRO and distributed platform for Broadcort applications.
Cobol, CICS, DB2, VSAM, and SQL
Reporting Tools: View Direct, Infopac, On Demand
Intergration Testing across various platforms
Database Experience: Oracle PL/SQL; DB2
Ability to Grasp & Utilize New Technologies
Client Tools: Oracle SQL Developer, TOAD
Strict Adherence to Quality Assurance
ETL Tools: Informatica Power Center 9x (Entry Level) TSO/ISPF, JCL, SPUFI, FILEAID, QMF, CEDF, Expeditor, Interest, Smartest, IBM Utilities, FTP, PANVALET, CHANGEMAN, LIBARIAN, ENDEVOR, Connect Direct, Tidal/Zeke Scheduler, MQ Series,
Bussiness Analyst ConsultantJan 2015 to Current Bank of America Merrill Lynch － New York, New York
Executing SQL queries against Oracle databases resolving Adhoc requests Documenting all upstream/downstream daily feeds Career Highlights____________ Designed, developed and implemented the Stable Value Fund system which was a full project life cycle.
Automated the manual process of posting SVF general ledger entries.
This improved efficiency and overall productivity for Middle Office resources.
Utilizing Cobol DB2 on the mainframe platform.
As a part of the Core Banking Replacement project, converted the Stable Value Fund system into ETL mappings, which is a full project life cycle.
This allowed the SVF feeds to be interfaced to OVS in Japan, as the Mainframe interface process is being eliminated.
Utilizing Informatica Power Center 9, Oracle PL/SQL on the distributed platform.
IT lead with 3 consultants reporting to me to head up the migration project of over 3000 MLPRO View Direct Reports into Bank America XPRTR reporting system.
Maintained spreadsheets, was the liaison between the BOA team, Scheduling and Operations.
IT lead responsible for documenting all changes/updates/additions to the Trade Upload Document User Manual, based on weekly meetings with the BroadCort Strategic Services Group, and the Product Development Group, in preparation for the Trades System Rewrite.
Instructed 12 CICS; DB2 and GTB CICS Screen Generator classes to the employee's on-site and Pro Bono, which in turn saved the firm from having to hire an external resource.
Benefit Statement____________ A strong IT analyst with a demonstrated 20+ year track record of accomplishments in large-scale application development and ongoing support initiatives.
Solely responsible for Decision Analyzer, batch and transactional processes hosted on the IBM mainframe for the Accounting/Credit Risk team.
Most recently, Project Leader for off shore team of 4 during AMRS shift; Implementing between 200 - 300 configuration changes on a monthly basis to facillate server migrations.
Deborah Grayer Page Two ____________Key Areas of Competency____________ Analyze existing applications and document processes.
IT AnalystJan 2012 to Jan 2015 MUFG Union Bank － Jersey City, New Jersey
Multinational banking and financial services corporation Primary duties focused on Application Development; DA Administrator; IT Testing Lead; Migration Technical Lead as well as Production Support.
IT Technical lead responsible for Migration tracker(s) for all integration testing (DUT SIT UAT).
This was critical and helped lead to successfully scheduling and completing the requirements for the project(s).
IT Lead / Programmer Analyst ConsultantJan 2004 to Jan 2012 Merrill Lynch Inc － New York, New York
Multinational banking and financial services corporation Primary duties focused on Application Development and Maintenance, IT Integration Testing Lead, and Production Support.
Developed Account Cross Reference Application as a part of the Options Reengineering project.
Coded all new maps using the GTB CICS Screen Generator, wrote 10 new online DB2/SQL programs.
Wrote Utility programs using REXX to identify which programs reference which Tablebase tables to determine which tables were obsolete; REXX programs to identify all details of Change Management packages for filtering purposes; Rexx program to read tab-delimited files which allowed for the generation OF ad-hoc reporting.
Technical SpecialistJan 1987 to Jan 2002 Shearson Lehman/Smith Barney/Citigroup Multinational banking and financial services corporation － New York, New York
Primary duties focused on design and implementation of the Gain Loss Analysis System, Tax Reporting, Travelers Fulfillment, Production support and developing staff training.
Analyzed, designed, developed and maintained application features and functions in both online and batch environments Developed GLAS applications, which was a full project life cycle used by the Asset Management clients;.
Collaborated with project manager to provide estimates and to assist in developing work breakdown structures for project deliverables for which we were accountable.
Facilitated troubleshooting, research and investigations of data problems, program Abends in JCL batch and online CICS environments.
Education and Training
BS, Computer ScienceProgramming Systems Institute － New York, New YorkComputer Science