SUMMARY

• Strong experience in banking and financial industry with analysis, design, develop, maintain, and support applications using Z/OS, COBOL II, SQL, DB2, CICS, MVS, MQ series on mainframe applications over 15+ years, and good understanding of interfacing web technologies.
• Team player with strong managing, technical, and communication skills
• Detail oriented and good understanding of financial industry regulations
• Quick learner and adopts quickly to the environment.
• Ability to work with multiple teams
• Excellent written and communication and documentation skills
• Experience with full life cycle development in a variety of applications
• Self - starter and Highly motivated team player with ability to work independently and as well as in a team

TECHNICAL SKILLS

COBOL,: Z/OS, VS COBOL II, DB2, JCL, VSAM, Micro focus COBOL, CICS, ENDEVOR

Mainframe Software: JCL, CICS, VSAM, MQ series and ISPF/PDF

Tools: File-Aid, ENDEVOR, XPEDITOR, Changeman Strobe, Tmon, QMF, SPUFI, MAPGEN, ISPF/TSO

RDBMS: DB2, SQL Server, ADABAS, Teradata

Operating Systems: Z/OS, MVS, Windows XP/ NT

Hardware: IBM ES/9000, OS/390

PROFESSIONAL EXPERIENCE

Confidential, Newark-NJ

Sr Programmer Analyst

Responsibilities:

• Analyzed and developed new Fund Administration System for ETF’s on the legacy end. Designed database requirements, created Native and Cobol stored procedures and batch systems for the new ETF system. Interacted with .Net user interface. Successfully productionized the system.
• Working as Senior Programmer and analyst in Deposits, pricing and fee waivers in Bank of Confidential . supporting ongoing development dat enhance the current system and extend production support.
• Working as Senior Programmer and analyst in global wealth management in Merrill lynch in the development and Analysis. Analysis of and supporting ongoing development dat enhance the current system and extend production support, and year end reporting.

Environment: COBOL2, DB2, Z/OS, JCL, Endevor, CICS, VSAM, Sharepoint, Fileaid, Catalog manager, BMC, FileManager, Many proprietary tools.

Vanguard, Malvern-PA

Sr Programmer and Analyst

Responsibilities:

• Working on enterprise data application which performs Sourcing, storing and managing of data on equities and bonds from Vendors such as Bloomberg, Reuters etc. Maintain a glod copy of data of existing Vanguard mutual funds and new fund launches.
• Analyze requirements design and develop Programs, Native SQL /Cobol stored procedures and Triggers. Testing and support the production and test Cycles in agile environment and document events on daily basis.

Environment: COBOL2, DB2, Z/OS, JCL, Insync for DB2, Fileaid, Z/OS, Endevor, sharepoint, CA11, CICS, VSAM, Catalog

Confidential, Hopewell-NJ

Sr Programmer Analyst

Responsibilities:

• Working as Lead Programmer and analyst /Team lead in Managed assets in global wealth management in Merrill lynch (Bank of Confidential ).
• Worked in the development of Single Enrollment, which is a common platform to enroll into any managed wealth management product. UI is in .net technology and database is in db2. Designed, developed data model and implemented in DB2 version 9, developed Native SQL stored procedures and triggers, and lead a team of developers at offshore. Designed and developed stored procedures, batch programs in cobol/db2 and numerous batch cycles developed and scheduled in production.

Environment: S390 (multiplex), COBOL2, DB2, Z/OS, JCL, Endevor, VSAM, Sharepoint, Fileaid, Datastudio, SQLDBX, Catalog mgr, Platinum for db2

Confidential, NJ

Sr. Programmer and Analyst

Responsibilities:

• me worked in UPS Payroll Systems, a small team dat processes payrolls for all UPS 500000+ employees on Customized Vendor software on weekly, biweekly, monthly schedules.
• And process ACH transfers to all the employees on periodic basis.
• It performs salary calculations and other payments based on number of hours worked and rules defined based on each local and state.
• Support Time Cards from the UPS Districts dat are submitted throughout USA/CANADA thru Global Time card System. Developed Edit driver module dat is a long running program reading data from MQ. dis driver module calls dozens of sub programs to validate various rules me.e. Sick Pay, Vacations, rate, Overtime.
• Wrote modules to Submit payroll jobs thru CICS. dis new module creates JCL/PROC referring to various DB2 Tables and thru DB2 stored procedures. Submit the job to JES3.
• Work on time critical operations and Support the Employee systems 7/24 including
• Work with offshore teams dat are working from India, Philippines etc
• Work on Legal and statutory requirements by developing new modules into the system

Environment: S390, COBOL2, DB2, Z/OS, JCL, CICS, Changeman, VSAM, Infoman, Vagen, Sharepoint, Fileaid, Tracker

Confidential, New York, NY

Sr. Tech Specialist

Responsibilities

• Setting up and maintain batch cycles, which periodically update several hundreds of files
• Into enterprise data warehouse
• Analyze data from enterprise warehouse, validate and fix anomalies
• Run data comparison reports between Teradata and mainframe files, analyze differences
• Develop and implement programs dat renovate the existing look and feel of client statements
• Interact with multiple teams, such as .net interface group, Teradata team, business group etc. some of them are remotely located
• Support systems, which interact .net interfacing the mainframe systems.
• Developed and supported 'New Accounts system' a CICS based application and tan Integrated to web-based interface using CTG technology and DB2 stored procedures. Good understanding of open systems Particularly JAVA, J2EE AND ASP.
• Developed a system to Capture and process financial goals of clients and categorize client portfolios into fixed income investments and securities based on internal algorithm.
• Integration of Legg mason client billing system to the Smith barney's.
• Supported Mutual fund system ‘TRAK’, in evaluating the client performance, which involves complicated mathematical algorithms. And fixating the discrepancies.
• Worked with offshore teams in India

Environment: COBOL2, DB2, stored procedures, Z/OS, CICS, ChangeMan, CA11, FILEAID, INTERTEST, NDM, SAR, ASP, JAVA, J2EE, ctg

Confidential, Warren-NJ

Sr. Programmer and Analyst

My responsibilities:

• Supporting software life cycle end to end from analysis, design, development and testing. me performed extensive requirement analysis, prepared LOE’s, performed designs and wrote technical design templates, developed the software to the requirement, provided test cases and performed unit and integration testing.
• It is one of the largest DB2 environments. Which handles huge data of more TEMPthan 50+million customers. Performance is highly critical in designing and developing the applications.
• Some of the various applications me is responsible for Design, Analysis and Development are:
• Prorate calculation of taxes, surcharges and bills
• Enterprise customer data administration
• Multi-tier billing system
• Intelligent -Dial features design
• DB2 performance optimizing design using latest db2 version
• Customer credit escalation process,
• Electronic signature capture
• dis is an enterprise data warehousing project. It is a huge database application. It contains 3 teams such as Data processing, Unix ETL, Teradata dat work together. Data dat belongs to the all 11 regions of the USA enters the mainframe from various subsystems such as Powerbase, MDSW, MITAS and NORDIC.
• After processing the data, it is fed to ETL team of Data warehouse.
• Getting the data from various sub systems and process it on the mainframe as per the Business logic and format the data in the form required by ETL. And transfer files to ETL by using NDM (Connect Direct) batch jobs.
• Extensive data analysis
• Did Enhancements to the existing system by using COBOL II, VSAM, DB2
• Validated the data by using the file Utilities such as INSYNC
• Validating the File on the Unix server by running shell scripts
• Extensively used SYNCSORT for the Data processing Extensively used TMS (Tape system), ENDEVOR, JCL, VSAM, DB2 QMF and other IBM Utilities

Environment: VS-COBOL II, MF COBOL, Java, J2EE, SP2, MQ series DB2 8.0, CICS, MVS, JCL, VSAM, IBM 390, Z/OS, Tmon, Strobe, TSO/ISPF, DB2I, FILEAID, INSYNC, Dump master, Connect Direct (NDM), CA-7, Expeditor, Net express, Animator, SI, IM, SCLM, VSAM, QMF, Windows-XP, MS-Office, MS-Access, MS-Project. Connect Direct (NDM), CA-7, ENDEVOR, Teradata.

Confidential, NJ

Senior Programmer Analyst

Responsibilities

• Managed Medico spin off from stock option perspective, which involved the data of millions of shares of Merck stock, basing each on its appropriate split factor.
• Analyzed existing systems, including impact analysis and risk analysis.
• Developed plans for business continuation and contingency.
• Performed requirement analysis, extensive coding, testing and validations
• Coded number of Cobol programs to spilt and create Medco related data files.
• Formatted data as per the user requests
• Loaded these data files to MS Access internal database tables created for Medco spin off QA purpose. And maintained dis database
• Extensively interacted with users of all levels
• Directly interaction with higher management.
• Provided support to SSB and Merrill Lynch.
• Actively involved with quality check process and data consistency checks.
• Worked with ETL team
• Was primary call-up for operational problems (weekend and night calls)
• Tesseract Upgrade, member of team dat upgraded Tesseract system from version ’96 to 2001. Tesseract is Merck’s main HR and payroll processing application.
• Performed impact analysis on the data from Tesseract Corporation.
• Customized Merck modules based on business logic.
• Performed day-to-day maintenance, coding, production support & testing.
• Stock Option Administration (SOAP), converted Merrill Lynch data into an appropriate data format for Salomon Smith Barney.
• Created history files involving complicated business logic and handled changes in the data formats between vendors.

Environment: DB2, COBOL, JCL, Z/OS, HTML, ASP, IISCGU Insurance, Foxboro, MassachusettsOct. ’98 - Apr ‘00

Programmer Analyst

Confidential

Responsibilities:

• Designed and developed two commercial lines systems for the automobile insurance industry: Commercial Lines Auto Massachusetts (CAM) and Commercial Line Auto for Remaining States (CAR).
• Developed applications using COBOL II, DB2, VSAM, JCL, Natural, ADABAS and MVS.
• Prepared weekly status reports updated bimonthly project plans and coordinated system activities between different teams.
• Performed extensive batch programming and maintained existing applications.
• Converted COBOL programs to COBOL II.
• Converted Natural programs to COBOL II without effecting underlying business functionality as part of merger of CU Insurance and GA Insurance. Maintained JCL.
• worked extensively with VSAM files, DB2 and ADABAS.
• Worked on both batch and online systems.
• Extended production support for nationwide online system, based on CICS.
• Developed and tested interfaces, maintaining CICS test region.
• Ran stats and Documerge printing.
• Cleared smart logs assigned by customers by downloading Wip numbers and policy numbers to test region.
• Performed file fixes and fine-tuned application based on test results.
• Migrated programs in ENDEVOR from development region to production region through online methods by foreground options of ENDEVOR or through background option.
• Used File Aid to edit and update files.
• Used Eastyrieve as reporting language tool.
• Used Quick Job for report generation. Used QMF to generate queries on DB2 database.
• Used SPUFI as an interface to DB2 database.
• Used MAPGEN to create CICS maps.
• Used TSO and ISPF/PDF extensively.
• Designed and developed OFS, a software product for the manufacturing industry dat uses Micro Focus COBOL, CICS, DB2, Animator and Compare.
• Developed the application on Micro Focus workstations, which are connected to Local Area Network (LAN), running on Windows NT.
• Tested and integrated module on ES-9000 Mainframe.
• Performed extensive development by coding in Micro Focus COBOL, DB2 and CICS.
• Prepared test cases for online programs and maintained test logs.
• Prepared test planes such as unit testing and integration testing.
• Integrated programs at unit and module levels.
• Wrote lower-level specifications from higher-level specifications.
• Used Animator and Compare as debugging tools.

Environment: Micro Focus COBOL, CICS, DB2, Animator, Compare, Windows NT, ES-9000.