Mainframe Analyst/Lead

Shaily Fotedar

Email Id: - ac5w26@r.postjobfree.com

Phone No: - 614-***-****.

Professional Summary

More than 5 years of experience as a Software engineer in Banking and Financial services which involves working in all the phases of Software Development Life Cycle – Requirement gathering, designing, developing, testing, deployment of the product and maintenance using Mainframe technology (COBOL, CICS, DB2, JCL, VSAM) and various tools including VISIO, Microsoft office, QMF, FileAid etc. Have hands-on experience on working with Ruby Cucumber automation scripts.

Very good knowledge of working with Change Management and Service now.

Worked on Converting Credit Card systems from TSYS to First Data which involved activities like understanding the existing TSYS system. Understanding the requirements and then converting the existing processes from TSYS to First Data.

Working as design analyst for Credit Cards system, which involves gathering requirements from the business and creating an optimal solution.

Worked in different areas of Banking and financial services which includes Data security, Credit cards and Line of Credits, Loans, Merger and acquisitions etc.

Worked on multiple applications that involved development using COBOL, CICS and DB2 along with working on automation scripts created with Ruby-Cucumber.

Created and enhanced COBOL, CICS modules with a web interface using Containers functionality.

Extensively worked on creating COBOL Db2 modules as well as stored procedures as per the functionality requirement.

Well versed in SQL queries to create mainframe programs as the functional requirement.

Worked on creating designs using VISIO and IBM’s rational rose as a tool.

Worked on some basic enhancements and running the scripts using RubyMine as a tool and Ruby Cucumber as the language.

Experience in working as a team member for Merger and acquisition project which involved understanding the requirements, creating the mapping document and converting the data from one format to the other.

Have been actively involved in various aspects of business development, project support and project management

Good knowledge and understanding of Software Development Life Cycle (SDLC).

Extensive knowledge on SQL/PLSQL and very proficient in working with very large databases.

Excellent communication skills and the ability to work individually as well as in a team environment.

Adept in planning & establishing an apt communication channel with clients for requirement gathering.

Experience preparing of Status reports and Code review documents & Maintaining Minutes of Meeting.

Leadership Skills:

Worked as design and system analyst for Credit card Management systems.

Worked as a Process Improvement Officer and have helped several teams to conceptualize and implement process improvements

Conducted cross-domain knowledge sharing session for 40+ associates to help them understand the business requirements and functionality of Credit Cards and Loan systems.

Worked as a team lead and led a team of 3 members for a very important assignment which involved requirement gathering and successfully implement and complete the requirements given by the customer and providing the best possible solution.

TECHNICAL SKILLS:

Tools: TSO/ISPF, ISPW, ChangeMan, FileAid, Zeke Scheduler, DBT, STAR tool, Easytrieve, Intertest, Endevor, Expeditor( batch and online),TOM, TWS(Tivoli work scheduler), QMF, FA, INFOX, Omegamon, Spoofi, RubyMine 6

Data model: VISIO, IBM Rational Rose.

Databases: Oracle 7.x/8i/9.x/10g, SQL developer 1.5

Languages: COBOL, CICS, SQL, JCL, C, C++, Visual Basics, Java, .Net and PL/SQL, Ruby Cucumber.

Operating Systems: UNIX, Linux, Microsoft Windows 95/98/00/NT/XP/7/8/10, MS-DOS.

Domain Experience: Banking Applications and Financial sector for Retail Banking and Wealth Management.

Foundation Banking Certificates: Consumer Lending, Clearing and settlement, Canadian Banking.

Professional Experience:

Working as a Computer Programmer with Tata Consultancy Services, India from January 2013.

EDUCATION:

Bachelor’s degree in Computer Science from University of Pune, Pune, Maharashtra, India.

PROJECT EXPERIENCE:

Tata Consultancy Services, India March 2017 – Till Date

Client: Huntington National Bank, OH

Responsibilities:

Working as a Business Analyst and technical lead for one of the very crucial TSYS to First Data conversion and several other small projects for Credit Cards IT team.

Working on designing and developing components along different application streams within credit cards.

I was actively involved in processes like ACH, Credit card rewards and promotions. They involved understanding the process at TSYS and creating a requirement document for First Data to implement it.

Very good knowledge of COBOL, JCL and VSAM used to develop and run the modules to carry out the required functionality.

Created Jobs using Easytrieve technology.

Designed data mapping documents as per the requirements of conversion process using VISIO.

Created documentation and conducted meetings to gather user/business requirements and also carried out quality reviews with the Users.

Created and maintained all the required documents which involve mapping documents, balancing reports, event schedulers etc.

Environment: TSO/ISPF, ISPW, ChangeMan, FileAid, Xpeditor( batch and online), Spoofi,COBOL, JCL, VSAM, CICS screens, Service now, Zeke Job scheduler, VISIO.

Tata Consultancy Services, India February 2016 – March 2017

Client: Huntington National Bank, OH

Responsibilities:

Working as an active team member of one of the very crucial Merger and Acquisition projects.

Extensively worked in creating multiple modules from scratch, which will convert the data from one format to the other required by the bank.

Very good knowledge of COBOL, JCL and VSAM used to develop and run the modules to carry out the required functionality.

Designed data mapping documents as per the requirements of conversion process.

Created documentation and conducted meetings to gather user/business requirements and also carried out quality reviews with the Users.

Worked closely with the customer to analyze the requirement and come up with the best possible solution.

Provided technical support whenever required to resolve any issue or defect.

Created and maintained all the required documents which involve mapping documents, balancing reports, event schedulers etc.

Worked in multiple areas involving Risk Systems(involving Fraudlink and Anti Money Laundering), Wire transfer and ROL systems using COBOL, VSAM and JCL. Was actively involved in maintenance and running the Automation scripts for TMIS(Treasury Management) systems as a past of Merger and Acquisition Of Huntington National Bank with First Merit Bank

Environment: TSO/ISPF, ISPW, ChangeMan, FileAid, Xpeditor( batch and online), Spoofi, RubyMine 6,COBOL, JCL, VSAM, Ruby Cucumber.

Client: Bank of Montreal, Canada Jul 2014 – Jan 2016

Responsibilities:

Experienced knowledge in working for Credit Card and Line of Credit systems for Bank of Montreal.

Responsible for communicating with the customer to understand the business needs and provide a feasible yet best possible solution.

Actively involved in coding, unit testing and successful implementation of the creditor insurance system and multiple other projects for Bank of Montreal.

Interacted with business users extensively in gathering the requirements and translated them into designs to work on along with my team.

Worked on providing the implementation support every time once the code was successfully deployed.

Modifying the existing code to adapt the changing business requirement and make sure that the existing functionality is not hampered.

Maintaining the effective quality process and standards. Was involved in thorough unit testing of the code and providing QA support to the testing team.

Was awarded with “On the Spot” award 2 times. Also was appreciated by client multiple time for my work.

Environment: ISPW, STAR, DBT, Xpeditor(Batch & Online), QMF, SPUFI,CICS, COBOL, JCL, VSAM, DB2.

Foundation Banking Certificates: Canadian Banking, Consumer Lending, Clearing and settlement.

Client: Morgan Stanley Smith Barney LLC Jan 2013 – Apr 2014

Responsibilities:

Actively involved in all the phases of Software Development Life Cycle.

Was a part of 11 months decommissioning project operating on all the applications in the bank.

The project concerned with the security, authorization and authentication of the bank and was one of the very important projects.

Interact with business users and managers for gathering, analyzing, documenting business requirements, functional requirements and data specifications.

Worked on designing the complete flow of the process of how to decommission an existing functionality and create a new one to handle the authorization and authentication system.

Involved in interacting, gathering information and working with the owners of all the applications in the bank, understanding their security process and implementing the new process.

Development and Maintenance of the application using COBOL, CICS, DB2 JCL, VSAM, Stored proc and Web interfaces for Morgan Stanley Wealth Management and decommissioning of an existing functionality causing potential risk to the Bank.

Ensuring documentation of all programming and design changes.

Verification and validation of the code being developed.

End to End testing for each code modified.

To Support, maintain and resolve the issues after the implementation if any.

Maintaining the effective quality process and standards.

Environment: TSO/ISPF, ISPW, ChangeMan, FileAid, DBT, Intertest, Xpeditor(batch and online),TOM, TWS(Tivoli work scheduler), QMF, FA, INFOX, Omegamon, Spufi, JCL, COBOL, DB2, CICS, C, C++, JAVA

ACADEMIC PROJECTS

Network Intrusion Detection and Prevention system using Support Vector Machine: A research-based project developed using .net and Oracle database system.

Online Hospital Management System: Developed online application using Visual Basics and Oracle.

HONORS AND AWARDS

Achieved 2nd position Final Year of Undergraduate course.

Received “On the spot” award thrice for handling critical issues at Tata Consultancy Services.

Received Award for “Outstanding Service” and Award for “Outstanding Support” at Tata Consultancy Services.

VOLUNTEER EXPERIENCE

Pelatonia 2017 : Worked as an active volunteer from Huntington national bank to help the Pelatonia riders complete their goal.

Shivanjali, AISSMS COE Pune – Student Volunteer for event planning and administration for University level cultural and technical festival during undergraduate course.

Nivasi Matimand Vidhyalay, Pune – As a member of Corporate Social Responsibility (CSR), organized painting & dance competition for kids with special needs. Managed CSR team meetings, activity sheet & work allocation.

Prerna Bhavan Mother Teresa Mission, Pune - Organized recreational activities for orphan kids and people in old age homes.

Contact this candidate