PROFESSIONAL SUMMARY:

• 9+ years of Industry experience as a developer & technical lead in Mainframe technology with Investment Banking, Financial and Utility domain.
• Comprehensive experience in preparing mandatory documents required as per SDLC mandate.
• Very Good exposure to all stages of Software Development Life Cycle (SDLC).
• Extensive technical knowledge in Mainframe technologies like COBOL, JCL, CICS, DB2, DB2 Stored Procs & MQ series.
• Experience in DB2 Performance tuning/Admin tools and MIPS reduction to improve performance.
• Proficient in MS Office Tools - Excel, PowerPoint, Word.
• Expertise in Financial Domain.
• Possessing a strong knowledge on Investment banking.
• Expertise in agile methodologies.
• Good experience in project development and support activities.
• Good experience in managing team and resources across different time zones.
• Excellent communication and analytical skills.
• Possess experience in Requirement Gathering, Impact analysis, Preparation of various documents like BRD, FRD, Technical Assistance, Testing and Post Production implementation verification.
• Hands-on experience in Process improvement techniques within the team (Six Sigma certified).

SKILLS:

IBM Mainframe S/390 & Z-OS with primary expertise in COBOL, DB2, SQL, Stored Procedures and APIs(Application Program Interface), JCL and tools like Changeman, SPUFI, QMF, Query monitor (QM Tools), MQ, TWS, TOM, File-Aid, IBM Data studio and INFO/X, CICS and Easytrieve.

WORK EXPERIENCE:

Confidential, New York

Project Technical Lead

Environment: COBOL,DB2 Stored Procs, APIs, SQL, SPUFI, IBM Data Studio

Responsibilities:

• Requirement Gathering and Impact analysis activities.
• Preparing Business documents like BRD, SRS, providing walk - throughs of the same with the team and the Stakeholders.
• Designing architecture and writing high level and low-level documents.
• Development of complex modules and enhancement of existing modules that impacts the changes needed for the project.
• Coded new Cobol-DB2 modules, Stored Procedures and APIs online modules for the Trade Redesign model that enabled the new functionality. Built JCLs to invoke those newly designed Cobol modules.
• Execute/Invoke the Stored Procedures from IBM Data Studio
• Discussion with the Business users to understand the change requirement and Business user testing.
• Providing Technical support, preparation of UAT test plans, coordinating UAT testing, tracking and resolving technical issues.
• Coordinating team at different time zones by managing, providing technical support and tracking progress daily within the team.
• Ensuring the timelines and overall quality of the deliverables.
• Preparation of technical and business documents and sharing the same within the team.

Confidential

Technical lead

Environment: COBOL,JCL,DB2 Stored Procedures, Changeman, SPUFI, IBM Data Studio

Responsibilities:

• Analysis on the various pieces of code to look for Optimization scope.
• Discussions with Upstream UI application team on the data usage provided by the back end Stored procedure.
• Various document preparation like BRD, MDD with complete technical and analytical scope.
• Made Technical code changes required to enhance the performance of the modules.
• Coded changes to the Cobol/Db2 Stored Procedures and worked along with the Distributed team who invokes the Stored Procedures during the various stages of the entire project.
• Worked along with the team on the Query optimization and Technical changes that falls into the scope of Optimization/performance tuning.
• Measured the query/code improvements using Query monitor (QM) tool via DB2 in lower environments.
• Worked along with the Performance testing team in creating N number of executions to measure the improvement.
• Also worked with DB2 Performance teams to measure the changes.
• End to end support of the projects along with QA, UAT and Production implementations.

Confidential

Technical Lead

Environment: COBOL, JCL,DB2,Stored Procedures, APIs, CICS/MQ transactions, SPUFI, IBM Data Studio

Responsibilities:

• Analysis and technical design and architecture.
• Preparation of documents to be shared with external upstream applications.
• Development/ Code changes of Cobol/Db2 modules, new JCLs to invoke the programs and various new set up including MQ, CICs transaction entries etc.
• Worked along with external teams for the new MQ/CICS transactions set up.
• Providing end to end support from Requirement gathering, development of code changes, preparation of unit testing, along with QA,UAT testing/support and finally on Production support with Business application users.

Confidential

Environment: COBOL, JCL,DB2,Stored Procedures, APIs, CICS/MQ transactions, SPUFI, File-Aid

Responsibilities:

• Maintenance of Fees application by enhancements as per Project requirements.
• Worked on various ad hoc changes in the Cobol programs and JCLs as per business needs.
• Worked on the DB2 Stored procedures changes that maintains /provides the Fees details to Financial advisors through UI screens.
• Fixing all Production/QA defects that were raised as per Business needs/changes.
• Providing various queries and clarifications raised by End customers on the various Fees details.

Confidential

Environment: COBOL, JCL,DB2, SQL SPUFI,VSAM,MQ/CICS transactions, Changeman, Stored Procedures, Easytrieve

Responsibilities:

• Requirement gathering and impact analysis and design architecture.
• Preparation of various documents like BRD,MDD and technical design documents.
• Development activities along with offshore teams and coordinating the same across the project along with Upstream and Downstream vendors. Create New Cobol/Db2 programs, JCLs, Easytrieve reports for downstream applications and new MQ/CICS transactions needed for the vendor feed.
• Created many DB2 Utilities related JCLs for the backup of DB2 tables like LOAD,UNLOAD,REORG,RUNSTATS etc.
• Built many GDG creations using IDCAMS utility for all the files and their backup.
• Preparation of Unit test plans and working with the team on Regression, Integration and Unit testing.
• Coordinating with QA and external upstream and consuming applications in verifying the changes.
• End to end support and Production deployment of the changes in different phases of release.

Confidential

Environment: Cobol,DB2,SPUFI, File-aid,IBM Data studio, Query Monitor

Responsibilities:

• Analysis on the DB2 objects used and the application owned.
• Various analysis and thorough understanding of all the SQL queries within the modules to be needed changes.
• Worked on the technical architectural design changes needed and shared the same with clients. Built new Cobol/DB2 Stored procedures and APIs to be invoked from front end distributed systems.
• Developed DB2 Query Optimization techniques for faster processing by monitoring the performance using the Query monitor tool.
• Worked with the consumers of the data provided by the module to understand better and provide what is needed and not provide any extra information which consumes more time/money.
• Successfully implemented the Rewrite of the Positions page with Financial data alone and provided other applications owned details to respective teams.
• Involved many teams on the project deployment and successfully coordinated the project.

Confidential

Environment: COBOL,DB2,SPUFI,Changeman

Responsibilities:

• Analysis of the existing module and thorough understanding of the same.
• Coordinating with the external team for their requirements and providing details.
• Create documents related to the changes like L0 Estimate, High level design doc etc and share with the respective teams.
• Coordinate with offshore in explaining the requirements, development of various COBOL/DB2 module changes.
• Built new SQL queries within the modules to extract the required data from the DB2 tables/databases. Ran various SPUFI results to provide the users the required data.
• Implement the changes to QA regions and coordinate QA testing.
• Reach out to all existing consumers regarding the production deployment changes.
• Successfully implement the changes in Production by working with the respective teams for support.