SUMMARY:

• A Senior Programmer Analyst with over 20 years of experience in analysis, design, programming, and testing of a variety of systems in Financial, Health Care and Broadcasting.
• Extensive experience with large d Confidential bases using DB2, CICS and Cobol2.

TECHNICAL SKILLS:

• Proven ability in structured design, coding techniques, performance and tuning strategies.
• Competent in analyzing problems and providing solutions.
• Efficient in research, development, documentation, installation, maintenance and support.
• Proficient in programming in both online and batch.
• Self: motivated and capable of working in an autonomous environment.
• Able to communicate in oral and written form clearly, concisely and effectively.
• Took communication in teh Navy to better communicate and maintain discipline in an organization.
• Trained in formatting SQL queries to be formatted in numerous excel spreadsheets and sent via secured FTP line to SEC in Washington DC for review (OTC trades and NYSE trades under investigation).Strict regulations must be followed via SEC requests.
• HARDWARE: ConfidentialMainframeConfidential PC
• PROGRAMMING SOFTWARE: CICS; DB2/SQL VER 9;STORED PROCEDURES;
• PLATINUM; QMF/SPUFI;STROBE;
• COBOL2, INTERTEST, XPEDITER;
• COBTEST; DEUG: BMS/ MAP SUPPORT; VSAM;
• PROEDIT; BMC SOFTWARE; TSO/SPF;
• ENDEAVOR; CHANGEMAN;MQ SERIES;
• FILEAID; MICROSOFT COBOL;
• XDB; IDMS/IDD; IDMS OLQ;ADSO IDMS;
• HTML; POWER BUILDER. MS OFFICE (Outlook, Word, Excel, PowerPoint);
• HTML; XML ORACLE, JAVASCRIPT;
• ASP; VISUAL BASIC;
• SHADOW DIRECT;
• STREAM WEAVER;
• CA7;FTP File Transmission for OATS(FINRA):
• CMM TESTING LEVEL PROCECURES

PROFESSIONAL EXPERIENCE:

Analyst/Developer Consultant

New Jersey, Ewing NJ

Responsibilities:

• Administration of Courts Probation system. Responsible for developing new additions and maintenance of New Confidential State Courts.
• Worked with Researchers from Confidential University for Mental Health Statistics gathering d Confidential on Confidential ts for teh past 3 years of d Confidential concerning testing for drugs, criminal record information within a years’ time frame for analysis.
• Creating specification for business requirements initiated by teh State of NJ and creating programming specification to implement into coding and completing projects on a timely basis. These include CICS, DB2 and batch processing.

Confidential, Somerset, NJ

Responsibilities:

• Project is conversion from Recap mainframe to RXClaims. Moving d Confidential from Mainframe to AS 400 Platform for
• Caremark. Creating d Confidential from Mainframe using DB2, Batch Cobol. Systems. Project is designed to Move medical and Pharmaceutical d Confidential over to AS400. D Confidential includes Carriers, group, Benefits, contracts, drug authorizations.
• Extractions of prescription d Confidential off mainframe and apply attributes for eligibility, drug types etc. Via accessing DB2.
• D Confidential is then FTP to AS400 platform and loaded to activated customers of their pharmacy benefits.

Confidential, Weehawken, NJ

Responsibilities:

• Worked on Confidential Statements System adding new attributes for electronic paperless statements to be sent to client who prefers email for commercial and retail accounts.
• Extracts of statements from AS/400accounts to separate accounts using Cobol 3 to print to Confidential Broadridge from those going for email delivery.
• Completed processes dat extract statements dat are being printed due to client's email being rejected. Due to regulatory rules statements must be printed in case a client cannot receive an email version of account transactions.

Confidential, Hopewell, NJ

Responsibilities:

• Worked on conversion of d Confidential for statements (Customer Correspondence Unit). Rewriting Batch(Cobol2, DB2) programs, using SQL(Writing queries), Procs, JCL to transfer statements to Confidential printing locations from Merrill Lynch printing sites or to be sent via FTP. Testing with Xpediter
• Testing new jobs and procs to create statements for customers plus running jobs to spool information toward new printer facilities stream weaver being used to format letters of various types to customers.
• Sending statistics over to Confidential for reconciliation and auditing purposes of statements being printed.
• Stored procedures are coded and tested to create modules dat can be reused by many processes.

Confidential, Weehawken, NJ

Responsibilities:

• Responsible for reporting of Orders, Execution and Trades for firm.
• Maintain and enhance OATS system (Order Auditing Trade System). All trades are extracted on a daily basis from DB2 using SQL(writing queries in Cobol programs, stored procedures) and processed to be formatted(excel spread sheets) and sent to teh SEC as required by regulations after business hours.
• All trades for OTC are gatheird from SQL queries (stored procedures)written and formatted into generic files, formatted to excel spread sheets. They are then sent thru secured FTP lines to SEC each morning before a specific time frame is met as by regulations.
• Error reports on trades dat need to be investigated are sent via extracted SQL queries via secure FTP Lines.
• Assisted in Batch coding and online work. Coded stored procedures.
• All reports are channeled to FINRA via FTP in excel spreadsheet forms on a daily basis.
• Use STROBE for performance tuning to find best efficiency in d Confidential base processing.
• Lead a group to oversee programs coding new regulations as required by SEC. Worked on design and changes made to tables. Created specifications and advised users keeping them informed of analysis and in sync with all other departments. Liaison to teh business community and legal departments to make sure requirements are properly reviewed and implemented in teh coding process.
• Used MQ for communication between systems for orders(NYSE, OATS) and exchanges using background CICS programs.
• Worked with business users to oversee regulations and compliance are implemented. Oversaw all specifications and code review. Made sure all Quality Assurance testing was executed. Worked with users on scripted testing procedures. Kept on top of all paperwork to implement production schedule on schedule.
• Testing and debugging of programs (DB2) for performance and tuning. Created all packages and schedules for implementation keeping track of scheduling and operation of systems.
• Created and maintain reports used internally by teh business community by extracting information from DB2.
• Used DB2 utilities to do reorgs of tables during night processing and maintenance of tables.
• Use OF STROBE for performance tuning. Analyze performance with DBA for best possible CPU utilization and access of table retrieval.
• Maintain and enhanced Online CICS for NYSE Trade Request System. Investigations of Orders by SEC are sent thru CICS via DB2 and then transmitted by way of FTP to teh government for inspections and inquiry.
• Any NYSE trades are sent via d Confidential dat was created via sql queries via CICS and formatted to excel spread sheets formatted separated by commas etc as required by SEC and sent thru secured FTP lines.

Confidential, Hopewell, NJ

Responsibilities:

• Responsible for conversion of Advest Confidential client accounts over to Merrill Lynch accounts system adding new
• Worked on creating specifications for Cobol 2 and DB2 programs. Testing and debugging using STROBE with DBA
• Installing New Name and Address system for Accounts Maintenance replacing old Program dat used IMS.
• Converted IMS d Confidential base name and address programs to extract from DB2 for mailing and statement uses.
• Developing CICS interface with front end PC software dat uses XML for Call Center in Costa Rica using DB2 stored
• Developing same day opening of client accounts system to speed up registration of new clients using Cobol2 and DB2

Confidential., Montvale, NJ

Responsibilities:

• Developing and Maintaining Client Master Profile, which is used by teh entire company and country for d Confidential relating to pharmacies, and companies enrolled in a health group. This information is crucial to paying pharmacies, drugs dat are allowed to be paid for and deductibles.
• Developed new screens necessitated by FDA regulation using CICS, VSAM and DB2. Expanded VSAM files for new fields needed by law and FDA.
• Worked on reports using DB2 for statistical purposes used by Directors and top executives.

Confidential, Roseland NJ

Responsibilities:

• Lead a group of 3 to oversee specifications required by teh business community. Went and scheduled meetings and conference calls to make sure all users and programmers are in sync with requirements. Went over specifications, code reviews, Quality Assurance Testing, corrections and final implementation maintaining strict discipline of all aspects of a project.
• Wrote enhancements to CIS for batch and online side in Cobol 2 and DB2. Wrote specifications test plans, unit testing conforming to CMM Level 2 specification.
• Wrote modules to enact Privacy Law dat forbids contacting client by phone if so desired.
• Wrote DB2 utilities to unload Privacy and History D Confidential base and purge records from previous year. Reload D Confidential bases with current year’s records to reduce space and file last year’s records on tape.
• Enhanced CIS CICS with new maps features for Privacy Law. Installed messages and new options for users and customers to contact thirds party insurers.
• Maintained Production D Confidential base.

Confidential, Somerset NJ,

Responsibilities:

• Rewrote Annual Fee System from VSAM to DB2. Processed yearly fees for all eligible client accounts using common Cobol 2 modules navigated via DB2 d Confidential base tables. Processing well over $30 million a month in fees. Resulted in faster response time and d Confidential access.
• Tested various sub modules written in Micro Focus Cobol on PC Platform using XDB. Transferred modules over to mainframe for testing of system using DB2.
• Led team in organizing mapping of IMS attributes to teh new DB2 tables for Y2K. Quality Control check of old and new attributes from a team of 4 associates making sure all attributes are audited and accounted for each DB2 table.
• Rewrote IMS Firm Wide D Confidential base to DB2 to be become Y2K compliant. Rewrote modules to load clients, accounts and holdings. Processed over 8 million accounts and 40 million holdings every day using less CPU time.
• Provided maintenance and support for tracking of legal documents mandated by firm to be signed by clients. Converted some old VSAM files to DB2. Resulted in faster access via CICS for users.
• Wrote new modules for D Confidential Validation Project to conform to SEC regulations. Creating new DB2 tables using Brownstone to keep track of letters being sent to clients to in order to make sure accounts have correct information. Used BMC software for restart and recovery procedures. Kept track of over 4 million client base.
• Worked also on Intra Web Design using HTML, JavaScript and ASP, to have user’s access offices prefixes for UAT testing dynamically. Designed a new web page to allow users to monitor clients for d Confidential validation using teh new DB2 table. Users do not need to be sent batch reports thru company mail but see teh d Confidential via Internet. Saved millions of dollars to print and mail report.

Confidential, Port Elizabeth, NJ

Responsibilities:

• Customer Coding Information System. Converted old system from ADABASE, VSAM to DB2 for CICS and batch processing using ADWCASE PAC tools. System is central depository to company in terms of keeping d Confidential on all clients, brokers and agents as well as banks and consignees for teh purpose of gathering information for booking, bill of lading, sales and services. Response time was increased for faster service in batch and online.

Confidential, Ridgefield, NJ

Responsibilities:

• Hired to convert a Customer Information System from IDMS to DB2. Project was cancelled due to bank restructuring and reorganization.
• Maintained existing Customer Accounts Information System using COBOL.

Confidential, New York, NY

Responsibilities:

• Accounts Information System used IDMS. Converted clients, accounts, profiles, and accounts types from IDMS to DB2. Worked with DBA to design logical and physical d Confidential base tables. Coded batch programs using IDMS to convert to flat files to DB2. Converted files using Cobol 2 and DB2 to new d Confidential base. Coded online portion functions in modular fashion using CICS and DB2.

Confidential, NJ, Florham Park, NJ

Responsibilities:

• New System. Developed and designed and implemented new enrollment, billing and accounts receivable using batch and CICS/DB2.
• Performed system analysis, specification writing, programming, d Confidential conversion and implementation using DB2/Cobol 2/CICS. Saved millions of dollars streamlining batch and online saving CPU time and better services to customers and users.