AJIT VINAYAK DESAI

Irving, TX *****

Phone: 214-***-**** (Home)

267-***-**** (Cell)

Email: jj6kmy@r.postjobfree.com

PROFESSIONAL SUMMARY

 IBM DB2 700 Professional.

 Globecon Investment banking and Securities Market Level I certification.

 Association of Mutual funds in India (AMFI) certification for Mutual funds.

 More than 8 years of experience in developing applications using Mainframe technologies like Cobol, CICS, DB2, IMS, JCL, VSAM and utilities like DFSORT, Ezytrieve etc.

 Worked extensively on utilities like SAS, DYL280 etc.

 Expertise in various DB2 utilities like SPUFI, Platinum, QMF.

 Expertise in using utilities like Endevor, Changeman, CA-7 etc.

 Expertise in using debugging tools like Intertest & Expeditor.

 Experience on working with stored procedures & MQ series.

 Expertise in using Mainframe utilities like DFSORT, Icetool, File-Aid etc.

 Proficient in working with both IMS and DB2.

 Handled multiple projects working in a team as well as working independently.

 Worked extensively in onshore and offshore model. Handled big teams in onshore.

 Strong understanding and experience in using applications Microsoft products like MS Visio, Word, Excel etc.

 Strong Experience working with migration projects.

 Worked extensively creating flow charts for existing and new systems using MS Visio.

 Strong understanding of software architectures and information systems development.

 Strong experience of working with financial clients. Working with Merrill Lynch for more than 4 years and Bank of America for more than a year. Good experience in retail as well.

 Strong knowledge of Investments domain including Equities, Mortgages, Credit Derivatives, fixed income.

 Strong knowledge of Mutual Funds, Brokerage and wealth management.

 Worked in ToysRUs and lead a project to develop a new trading system called Scan Based Trading (SBT).

 Worked on trust accounting in Bank of America. Have a strong knowledge of trust services.

 Strong knowledge about Human Resources, Finance and Accounting and Marketing.

 Working on completing my PMP certification by May.

TECHNICAL SKILLS:

Languages : Cobol, SQL, JCL, CICS.

Tools : File-Aid, Intertest, Endevor, Changeman, Spufi, QMF, Platinum, CA-7.

Utilities : DFSORT, Ezytrieve, SAS, Icetool.

Database : DB2, IMS, VSAM.

Operating Systems : Windows 98/2000/NT/XP, MVS OS 390.

CERTIFICATIONS:

• IBM DB2 700 Certification.

• Globecon Investment banking & Securities Market certification.

• AMFI Mutual funds certification.

EDUCATION:

Bachelor of Engineering in Mechanical, Sardar Patel College of Engineering, Mumbai University, India

EMPLOYMENT HISTORY:

Data Inc 02/2010 – Till Date

TATA CONSULTANCY SERVICES LTD 07/2003 – 02/2010 Designation : Project Manager

Clients : Bank of America (TX), Merrill Lynch (NJ), ToysRUs (NJ)

PATNI COMPUTER SYSTEMS Ltd 07/2001 – 07/2003

Designation : Developer/Project Leader

Client : Bendix Commercial Vehicle Systems (Ohio)

PROFESSIONAL EXPERIENCE:

Bank of America, Dallas, TX Jan 2009 – Feb 2010

PACE (Profitability and Customer Enhancements) is the accounting system for Bank of America Trust accounts. PACE basically manages client’s money. It does investments in Stocks, bonds, equities, mutual funds etc. It also does special sweeps processing as well as fee and tax calculations for the trust accounts. It generates monthly, quarterly or annual statements for its customers based on the client preference. It also houses the information regarding the various privileges for all the associates i.e. who would be able to view client statements, who would be able to see pending transactions for an account etc.

Responsibilities:

 Project Manager managing a team of 2 at onshore and 6 at offshore.

 Responsible for Technical analysis and design, code and testing co-ordination.

 Maintenance and/or development of Cobol and CICS programs including DB2 as well.

 Involved in code review for code developed by both onshore and offshore team.

 Involved in regular meetings with both onshore and offshore teams and setting up priorities for both.

 Assisted in the deployment of code to Production environment and provided support for the code thereafter.

 Worked with people from Trust Operations support for any technical or business related issues.

 Wrote adhoc queries in DB2 for business partners.

 Ran data extracts from VSAM or flat files using utilities like File-Aid, DFSORT, Icetool etc for clients and business partners.

 Created adhoc reports/extracts using SAS & Ezytrieve.

 Created Prodex for special execution of jobs or on demand job requests for CA-7.

 Involved in Defect fixing at SIT and UAT stages.

 Wrote Unit Tests cases and scripts for SIT & UAT testing.

 Participated in the review of SIT/UAT plan, report and track defects.

 Document systems and programs enhanced, developed and implemented.

 Performed other functions such as systems analysis and design, user coordination, and systems documentation and technical research.

Environment: Cobol, DB2, JCL, VSAM, CICS, SAS, Ezytrieve, CA-7, TSO/ISPF, DFSORT, Icetool, File-Aid, Platinum, Spufi, Changeman, Intertest, Expeditor.

Merrill Lynch, Pennington, NJ Oct 2008 - Dec 2008

CRIS (Client Reporting and Information Systems) is responsible for generating statements for accounts held by clients at Merrill Lynch. The statements are generated either monthly or quarterly depending on client preference. The statements are generated not only for domestic clients but also for international clients. The statements give a detailed summary of the various holdings in the accounts along with the transactions done in the statement period. The statements also give some suggestions based on client’s financial standings and risk appetite. The statements are generated in different forms depending on clients net worth and account holdings.

Responsibilities:

 Project Manager managing a team of 3 at onshore and 8 at offshore.

 Responsible for Technical analysis and design, code and testing co-ordination.

 Involved in code review for code developed by both onshore and offshore team.

 Maintenance and/or development of both Cobol and CICS programs.

 Involved in regular meetings with both onshore and offshore teams and setting up priorities for both.

 Assisted in the deployment of code to Production environment and provided support for the code thereafter.

 Involved in Defect fixing in SIT stage.

 Involved in Writing Unit Tests and scripts for SIT testing.

Environment: Cobol, JCL, VSAM, Ezytrieve, CICS, TSO/ISPF, DFSORT, Endevor, Intertest, Expeditor.

ToysRUS, Wayne, NJ Jan 2008 - Sep 2008

Scan Based Trading (SBT) is a trading model in which the retailer pays the vendor based on the goods sold thru the retailer’s Point of Sale (POS) system. The items are marked for SBT using Java screens. At the beginning of each roll out the vendor buys back all ToysRUs owned inventory using Return to Vendor (RTV) process and in-store inventory would be zero. Sales will negatively impact the inventory whereas returns will positively impact the inventory. The weekly consignment process will generate the PO’s, invoice, receipts and debit memos depending on whether there is a net sale or return.

Responsibilities:

 Project Manager managing a team of 1 at onshore and 10 at offshore.

 Involved in meetings with business partners and client managers to finalize the requirements for the proposed system.

 Wrote BRS, SRS and detail designs for changed programs.

 Involved in creating mock ups for the new screens to be built using Java.

 Coded new Cobol and CICS programs with DB2 as a part of building the new system.

 Made changes to existing Cobol & CICS programs to incorporate the changes required for the new system.

 Conducted regular meetings with both onshore and offshore teams and set up priorities for both.

 Tested the new screens developed in Java to make sure all functionality was incorporated.

 Assisted in the deployment of code to Production environment and provided support for the code thereafter.

 Involved in review for all deliverables from both onshore and offshore.

 Involved in Defect fixing in SIT & UAT stage.

 Wrote scripts for SIT & UAT testing.

 Performed other functions such as systems analysis and design, user coordination, and systems documentation and technical research.

 Created documentation about the new system for the clients and business partners.

Environment: Cobol, DB2, CICS, JCL, VSAM, TSO/ISPF, DFSORT, File-Aid, Spufi, QMF, Platinum, Endevor, Intertest, Java.

Merrill Lynch, Pennington, NJ Nov 2005 - Dec 2007

The Profiling and Asset Tracking of Households (PATH) deals with collecting and maintaining client related data for all types of accounts opened with Merrill Lynch. It stores and maintains important client information like name, SSN, address, income etc. It interfaces with different other Merrill Lynch systems like Statements, Account Opening, FA compensation etc. It is the primary source of data for the Merrill Online and Merrill 360 platform.

Responsibilities:

 Project Manager managing a team of 4 at offshore.

 Responsible for Technical analysis and design, code and testing co-ordination.

 Involved in code review for code developed by offshore team.

 Coded new Cobol & CICS programs as part of the conversion of Advest accounts to ML.

 Changed some existing Cobol & CICS programs to add processing for the new accounts.

 Fine-tuned existing online screens (formats, validation edits, deletion and addition of new fields, standardization etc).

 Assisted in the deployment of code to Production environment and provided support for the code thereafter.

 Wrote adhoc queries in DB2 for business partners.

 Created adhoc reports/extracts using DFSORT, File-Aid, Icetool etc for clients/business partner.

 Involved in performance tuning for DB2 queries and stored procedures.

 Worked with Operations team for any technical or business related queries.

 Involved in Writing Unit Tests and scripts for SIT testing.

 Involved in system documentation and technical research.

Environment: Cobol, JCL, DB2, VSAM, CICS, TSO/ISPF, File-Aid, Icetool, Spufi, QMF, Platinum, DFSORT, Endevor, Intertest, Expeditor.

Merrill Lynch, Pennington, NJ Dec 2004 - Oct 2005

Consumer banking & financial systems (CBFS) deals with visa and check settlement process and calculates the credit limit, spending limit, loan balances and overdrafts for each account. It also deals with different kinds of fund processing and fee processing. It interfaces with different other Merrill Lynch systems like statements, account payable, fund agent etc.

Responsibilities:

 Project Leader managing a team of 4 at onshore and 8 at offshore.

 Responsible for Technical analysis and design, coding and testing.

 Involved in code review for code developed by offshore team.

 Maintenance for both Cobol & CICS programs including DB2 as part of various initiatives.

 Created new Cobol, IMS programs as part of the Statement Simplification process.

 Assisted in the deployment of code to Production environment and provided support for the code thereafter.

 Wrote adhoc queries in DB2 for business partners.

 Created adhoc extracts using File-Aid, DFSORT etc for clients/business partners.

 Involved in Writing Unit Tests cases and scripts for SIT testing.

 Participated in defect resolution meetings for SIT testing.

 Performed other functions such as systems analysis and design, user coordination, and systems documentation and technical research.

Environment: Cobol, JCL, DB2, IMS, VSAM, CICS, TSO/ISPF, Spufi, QMF, Platinum, DFSORT, Icetool, File-Aid, Endevor, Intertest, Expeditor.

Merrill Lynch, Mumbai, India Apr 2004 - Nov 2004

Consumer banking & financial systems (CBFS) deals with visa and check settlement process and calculates the credit limit, spending limit, loan balances and overdrafts for each account. It also deals with different kinds of fund processing and fee processing. It interfaces with different other Merrill Lynch systems like statements, account payable, fund agent etc.

Responsibilities:

 Interacted with team at onshore to gather requirements and develop program change specifications.

 Code new programs in Cobol & CICS as per the requirements as part of various initiatives.

 Responsible for unit testing the new programs as well as changes to existing programs.

 Maintenance for both Cobol & CICS programs as per the requirements.

 Assisted onshore team in the deployment of code to Production environment and provided support for the code thereafter.

 Involved in Writing Unit Tests and scripts for SIT testing.

 Involved in documentation of the changes made to the system as part of initiatives as well as the new changes that were put in.

Environment: Cobol, JCL, DB2, IMS, VSAM, CICS, TSO/ISPF, Spufi, QMF, Platinum, DFSORT, File-Aid, Icetool, Endevor, Intertest, Expeditor.

Merrill Lynch, Mumbai, India Apr 2004 - Nov 2004

Regulatory Reporting systems (RRS) generates various Tax related statements and Forms for all Merrill Lynch customers and its subsidiaries during the financial year-end. The project to be maintained comprised of a suite of modules, collectively referred as Regulatory Reporting System. The objective of the system was to generate the necessary Tax Forms, which are required by IRS (Internal Revenue Service) for Merrill Lynch customers and subsidiaries as well. Apart from the necessary forms this system was also capable of generating the Fiscal Statements which assisted its clients to understand their financial positions by capturing and maintaining purchase and sale information and providing them with the capital gain/loss information.

Responsibilities:

 Interacted with team at onshore to gather requirements and develop program change specifications.

 Responsible for coding new Cobol & CICS programs and unit testing them.

 Maintenance for both Cobol & CICS programs and unit testing the changes.

 Assisted onshore team in the deployment of code to Production environment and provided support for the code thereafter.

 Run queries in DB2 to generate reports/extracts for the clients.

 Create extracts from VSAM or flat files using DFSORT, File-Aid, Ezytrieve etc.

 Involved in Writing Unit Tests and scripts for SIT testing.

 Performed other functions such as systems analysis and documentation and technical research.

Environment: Cobol, JCL, Ezytrieve, VSAM, DB2, CICS, TSO/ISPF, Spufi, QMF, Platinum, File-Aid, DFSORT, Icetool, Endevor, Intertest, Expeditor.

Bendix Commercial Vehicle System, Mumbai, India Jul 2001 - Jul 2003

Bendix Commercial Vehicle systems (BCVS) is a US based company with its head quarter located in Cleveland Ohio, and it’s business is spread all over USA, Canada & Mexico. Manufacturing truck brake systems is the main business of Bendix. It also manufactures other automobile accessories and has a client base all over US, Canada and Mexico. To cater to its business need, Bendix maintains a central database covering the different aspects of its business. These applications are developed on various hardware platforms such as IBM mainframe, SUN Java, and software technologies such as traditional mainframe environment of batch processing, Client/Server architecture and web technology.

Responsibilities:

 Interacted with team at onshore to gather requirements and develop program change specifications.

 Responsible for coding new Cobol & CICS programs and unit testing them.

 Maintenance on existing Cobol, CICS, DB2 & IMS programs.

 Assisted onshore team in the deployment of code to Production environment and provided support for the code thereafter.

 Involved in Writing Unit Tests and scripts for SIT testing.

 Involved in 24X7 Production support from offsite.

 Involved in fixing abends and giving recommendations to resolve potential problems.

 Involved in a big enhancement for the NAFTA project which included a lot of changes for both CICS and Cobol programs as well as coding new Cobol & CICS programs with IMS & DB2.

Environment: Cobol, JCL, DB2, IMS, JCL, VSAM, CICS, TSO/ISPF, Spufi, QMF, Platinum, Endevor, Intertest, DFSORT, File-Aid, MQ series.

Patni Computer Systems Ltd Initial Learning Program, India Jun 2001 - Jun 2001

Initial Learning Program: Courses attended as a part of ILP

Requirement engineering,

Testing and Debugging

Software Engineering

Effective presentation

Programming in Cobol, JCL, SQL.

Soft Skills

Effective communication

Effective writing

Software testing

UNIVERSITY OF MUMBAI, India Apr 1997 - May 2001

Worked on several projects while completing Bachelor of Engineering Degree at Mumbai University

Mumbai University Student (MUS) Database Search Tool: Developed a user-friendly intranet search application using Win Forms for retrieving data from MUS students’ database that has more than 1 million records. The application allows users to do customized search, store subsets of data, perform bulk search by specifying input files, and generate reports.

Environment: Win Forms, C#, Data grids, ADO.NET, Visual Studio.NET, SQL Server 2000

Responsibilities:

System requirements gathering and analysis

Designed and developed GUI using C#/ Web Forms, User Controls

Extensively used T-SQL to create stored procedures, user defined functions, triggers

Used grid controls extensively

Used SQL Profiler for performance tuning of T-SQL queries and stored procedures

Used SQL Server 2000 XML features for integrating with ADO.NET XML features

Extensive usability testing

Contact this candidate