SUMMARY:

An Information Technology Analyst Team Lead/Tech Manager with more than 20 years of experience and expertise in Fortune 500 companies in the financial, brokerage, banking sector and Resort Management Industry Applications. Experience in Managing, Leading, designing, developing and maintaining complex financial applications and databases. Very good at analysis, troubleshoot, manage and guide teams of technical people. Hardworking team player, rapid learner and result focused.

TECHNICAL SKILLS:

• IBM MVS/ESA/XA/390
• Z/OS
• TSO/ISPF
• COBOL II
• COBOL/390
• DB2
• SQL
• Storedprocedures
• CICS
• JCL
• VSAM
• MQ Series
• MS Access
• ENDEVOR
• PANVALET
• CHANGEMAN
• Transformer
• CEDF
• BMS
• GTB
• SPUFI
• PLATINUM
• QMF
• FILE - AID
• EXPEDITOR
• INTERTEST
• SYNCSORT
• CA-7
• SAR
• JES2
• FTP
• NDM
• VISIO
• MSPROJECT
• COOL Gen
• Windows
• EASYTRIEVE
• ORACLE
• SQL+
• UNIX
• REVINE
• Composite.

PROFESSIONAL EXPERIENCE:

Confidential, NJ

Technical Lead/Project Lead

• Lead a Team with Onshore and Offshore components
• Executed Projects using Waterfall & Agile Methodologies
• Project Planning, Assigning and monitoring till execution of the tasks.
• Regular interaction with Business to collect the Requirements, Scope the work and effort
• Brainstorming within the team and Designing the Application
• Triage,Resolving Production issues on a regular basis
• Was an SME for AP Compliance system
• Regularly interacting with the team and educating the team with the system knowledge
• Batch process Monitoring and resolving issues on a timely manner
• Resource Planning, Breakdown of the work, Estimation and Effort determination
• Interaction with the external dependent systems and worked collaboratively to resolve any project needs
• Performance tuning of the Application on necessary and possible avenues

Confidential, NJ

Lead Programmer analyst

• Involved in Maintenance and Enhancement of the VISION Applications
• Involved in Requirements gathering, preparing Technical design documents,Test case preparation/ reviews.
• Involved in writing extensive DB2 /cobol/Stored procedures,Frontend Applications
• Involved in Writing new Easytrieve programs to generate Customer activity, Billing, Invoice and Revenue reports.
• Modification of Easytrieve programs to add new fields/remove fields based on the User requirements
• Involved in writing extensive sql queries, performance tuning of the queries using explain to achieve the results
• Used CA7 to schedule nightly jobs,analyze jobs to create job streams .Setting up Job triggers,File triggers etc
• Coordinating the testing with different Interfacing apps.( ACSS/DVS/POS)
• Testing Using the Frontend apps and xml tags to invoke the COBOL programs.
• Unit/ System testing and Production Implementation
• Unload /Reload data from/to DB2 tables Using Fileaid & BMC utils
• Involved in writing JCLs, PROCS, testing and debugging using XPEDITER,Create packages using Endevor.
• Used DB2 fileaid Spufi to query/update db2 tables .

Confidential,NJ

Lead Programmer analyst

• Re engineering the existing SWAPS derivative system.
• Team coordination and Team guidance.
• Data conversion,Enhancing/Modifying db2 /CICS programs to accommodate calypso changes
• Modified Easytrieve programs add/modify Portfolio reports for Clients - Prime broker/Broker delears
• Extension use of Easy trieve program to generate adhoc reports for Business users.
• Unit/ System testing and Implementation
• Unload /Reload data from/to DB2 tables.
• Maintenance & Enhancement of CICS/DB2 programs
• Involved in writing JCLs, PROCS, testing and debugging using INTERTEST.
• Used CA7 scheduler for job scheduling, setting up job triggers,On demand jobs etc.
• Used DB2 platinum. Spufi to query/update db2 tables .
• Production Implementation using CHANGEMAN.

Confidential,Weehawken, NJ

Technical Lead /Senior developer

• Issue analysis and Preparation of design documents.
• Extensively designed/wrote db2 stored procedures.
• Maintenance & Enhancement of CICS /db2 programs.
• Re architecture/Fine tuning the existing account opening prefillment process.
• Monitor system performance and reliability, provide and plan production support procedures, recovery, and enforce quality standards to increase customer confidence and satisfaction.
• Unit/ System testing and Implementation
• Unload /Reload data from/to DB2 tables.
• Used Easytrive programs to generate adhoc reports.
• Team guidance and co-ordination with business users.
• Involved in writing JCLs, PROCS, testing and debugging using INTERTEST.
• Used DB2 platinum. Spufi to query/update db2 tables .
• Production Implementation using CHANGEMAN.
• Allocating GDGs, VSAM files.,Job Scheduling using CA7,Job stream analysis using CA7 etc.
• System study and Requirements gathering.
• Project Planning and Preparation of design documents.
• Involved in writing/ modifying/ enhancing COBOL, DB2, VSAM,MQ programs.
• Read/Write MQ messages and processing using batch MQ programs.
• Unit/ System/ Integration testing
• Team guidance and co-ordination.
• Involved in writing JCLs, PROCS, testing and debugging using INTERTEST.
• Running DB2 EXPLAIN for performance tuning, Using SPUFI, FILE-AID for DB2.
• Production Implementation using CHANGEMAN.
• Allocating GDGs, VSAM files, Scheduling jobs

Confidential,Brooklyn,NY

Senior Programmer Analyst

• Privilege activity system of Margin department in Bear Stearns offers their customers with a facility of Checking transactions, ACH and debit card transaction processing. Bear Stearns receives daily customer activity files from TBC Mellon Bank and PFPC bank. Privilege access system clears the check presentments, ACH transactions and debit card authorizations and generates returns file to the bank. This system also creates TIF (Transaction Input files) entries for ADP books and records processing. Also has Online systems wherein the Users clears the presentments based on the debit/Credit balance of the customers.
• SCOR portfolio is the Bear prime reporting system which provides the valuation of the customer’s positions and balances.
• Involved in Development, Maintenance, and Support & Enhancement of the system.
• Involved in developing complex COBOL/DB2/CICS programs/, Testing & Debugging
• Involved in writing Stored procedures Testing and debugging using SPB (Stored Procedure builder)
• Performance tuning of the SQLs.
• Modified /Added new Easytrieve programs to generate SCOR reports.
• Involved in transforming all mainframe reports to more published format pdf reports by using a special tool Transformer
• Provide production support 24 X 7 which included resolving production problems and coordinating with operations.
• Batch programs were written in COBOL II and DB2. Used JCL, CHANGEMAN, Stored procedure. INSYNC, SPUFI, VSAM, CA-7, SAR, JES2, PLATINUM, NDM, TSO/ISPF, SYNCSORT, Abend-Aid, MS Office, XP, SPUG, Transformer, Detector.

Confidential,Columbus, OH

Senior Programmer Analyst

• The Bank one DB consolidation project is to achieve improved business functionality, an architecturally sound CIS application with high data integrity, merger readiness and enable the system to interface the CRM applications. This would be achieved by consolidation of SBS(IMS)and enterprise index databases along customer boundaries.
• Involved in restructuring COBOL programs, writing Unload/load programs for database migration, Job scheduling Unit and System testing and Production Implementation.
• Batch programs were written in COBOL II and DB2.,DBIO exit routines, JCL, CHANGEMAN, FILEAID, QMF, SPUFI, VSAM, CA-7, SAR, JES2, PLATINUM,NDM, TSO/ISPF, SYNCSORT, Abend-Aid, MS Office, Windows XP professional, IPMS (Integrated Project management system)
• Involved in Project estimation, budgeting, Gantt Chart, Manage project deliverables, Task allocation, QA Reviews.

Confidential,IN

Lead Programmer Analyst

• The objective of this project is to implement the Siebel Call center solution over the Weeks reservation system (EVS1). The Siebel application will be the desktop application used by the Vacation counselors to capture, develop and leverage detailed customer information. To achieve this objective the legacy Mainframe CICS screens are replaced with the Siebel screens. The Mainframe team has to remove all the maps generated in the Mainframe applications and to make all the dependent CICS programs as standalone programs to issue a direct call from the Siebel environment.
• Involved in changing COBOL/CICS, DB2, VSAM batch and online programs, create/modify JCLs, Procs.
• Used SPUFI, QMF for intermittent SQL testing, formatting report, generating adhoc reports. Used CA7 for Job scheduling.
• This system was developed in CICS, COBOL, DB2, VSAM. Project involved use of FILEAID, PANVALET, EXPEDITOR, EASYTRIEVE, QMF and SPUFI.

Confidential,Florham Park, NJ

Lead Programmer Analyst

• Pershing uses CAPS to capture revenue data resulting from broker trades. As part of Global initiatives, this system is identified to capture and report revenue (in USD) from trades in foreign currencies through GLOSS. Pershing uses Funds Utilization (“Funds-U”) to perform Cash due debit, margin debit, Credit and Short Rebate Interest Calculations on U.S dollar balances in domestic accounts. The Global capabilities project has identified the need to provide the Multicurrency capabilities for this System. Hence this new system will be capable of doing Interest Calculations for all currencies held by Pershing Correspondents and their customers. Also, this system will have the ability to support both the current domestic functionality and new international specifications.
• Involved in changing CICS screens, Generating reports, create/modify JCLs, Procs, batch and online COBOL, VSAM, DB2.
• This system was developed in CICS, COBOL, DB2, VSAM. Project involved use of FILEAID, ENDEVOR, EXPEDITOR, EASYTRIEVE, QMF, SPUFI, CA7, MQ Series.

Confidential

Systems Analyst/Programmer

• The project is to design and develop a system for Fees and Interest Accruals for all the Account holders in Confidential . It mainly concerns with Fees and Interest Calculations needed for all the Individual Accounts as well as group accounts. The Fees and Interest is calculated as per the Rule of 78 used by Confidential .
• The project is to design and develop a system for individual savings account (ISA) which is a new product introduced by the government of UK in April ’99. The product has been introduced as to mainly attract lower middle class people. The Product gives good schemes and tax exemptions on having an account. The ISA has three components such as Cash Mini ISA, Maxi ISA and TESSA (Tax Exemption Special savings scheme) ISA. The system has been fit to a part of the Product Ledger Management system (PLM - 1C). This ISA system has interfaces with other systems in Confidential and has Online and Batch systems.
• The project entirely takes care of the Credit card processing system of the Confidential in UK.
• Involved in Designing and developing the Online and batch systems Using COBOL/DB2 /CICS/VSAM/Easytrieve.
• Creating GDGs, JCLs, writing Functional/Technical specifications
• Involved in generating Daily/Weekly/Monthly reports
• Developed/changed programs, gathered data for unit and system test, conducted unit tests, organized user testing
• Involved in Production Implementation, System support
• Used SPUFI, QMF for intermittent testing of SQL, formatting report, generating adhoc reports, modifying JCLs and procedures. Environment: VS COBOL II, IBM MVS/ESA, DB/2, SQL, CICS, VSAM, SPUFI, JCL, QMF, EXPEDITOR, INTERTEST, FILE-AID, OPC, CA-11, SAR, JES2, TSO/ISPF, VISIO, SYNCSORT, MSPROJECT, MS-OFFICE, WINDOWS NT/95.