SUMMARY:

• Strong IT experience in Mainframe Involved in complete Software Delivery Life Cycle (SDLC) in Banking, Securities, retail and Insurance domain. 16 plus Years of Core Mainframe development experience. 5 plus years on CICS development and support project.2 years on mainframe modernization. DB2 DBA over 8 years on mainframe and LUW.
• Onshore experience worked at Client site closely with business stakeholder and managing and technical leadership for the delivery in USA, Europe and Nordic over a decade.
• Certified Scrum Master and DevOps, ITIL Certified software professional and Certified DBA with illustrious career of 3+ years in driving Software project management / Delivery Management / IT Application development & maintenance.
• Supported application developers in using COBOL, DB2, MQ Series and CICS resources as lead and DBA.
• Expertise of ITIL to support maintenance project &agile process and SAFE certified.
• Good technical knowledge as Database architecture, programming and Administration on database on Mainframe, LUW environment on database such as DB2, SQL Server, Oracle and NoSQL DB involved in Performance Tuning, etc.
• Have good expertise in Mainframe modernization including migration to Linux bases system as well as building host DevOps pipeline using IBM SCM such as Endeavor, Change man and RTC. Involved in continuous integration, builds and deployment using RTC, RDZ and RD&T.
• Certified ITIL, IBM DB2 Z/os - Developer/DBA Certified, Oracle -12G Certified.
• Responsible for Technology solution development from capability responding to RFPs delivery using mainframe legacy, database, Cloud Computing and DevOps.
• Implemented Synthetic test data solution using test data manager, created Conceptual and data modeling for data virtualization.
• Good hands-on experience in SQL, PL/SQL programming alongside Automation tools, frameworks and methodologies etc.
• Worked on Diagnosing performance problems in WebSphere MQ, BMW MQ for z/OS and then tuning subsystem.
• Install, maintain and use the CA-TDM tool and the TMON and Omegamon monitoring tool for Z-series resources.

SKILLS & ABILITIES:

Operating System: Windows 7/10, Linux, Ubuntu, Z/os

Technology: Mainframe, Data warehouse, Big Data

Programming Languages: CICS, Cobol, JCL, z/OS, DB2 Z/os

Databases: Oracle, IBM DB2, VSAM, TDM, IMS DB DC

Other Utilities: IBM Data Studio, RDZ, Main view, Platinum

Functional: SWIFT, Target2, Securities, Banking

PM Tools: MSPS, Confluence, JIRA, QC, MS Visio

DevOps Tool: GIT, SVN, CI/CD, Jenkins, AWS

WORK EXPERIENCE:

Confidential, Austin, TX

Lead Mainframe and DB2 Developer

Responsibilities :

• Responsible for developing and testing code per project requirements for migrating vendor feed for Conduent , developing complex logic for data processing and chunking data also mentored junior team members.
• Design and created DB2 database objects for development and maintenance project at the Conduent worked on creating DDL and DCL.
• Migrated the flat files from Conduent to db2 database using load utilities for quick efficient access and written specs and program to fetch the data for the downstream application.
• Directly involved in the database design and create DB objects and worked on performance tuning, writing complex heavy SQL such as creating worklist and temporary table for heavy data processing. Optimization of heavy SQL.
• Production Support and data refresh and loading into different test and production environment using jobs and data studio. Created and changed the procs and JCL for release and production support.
• Created test data model and Implemented Synthetic test data solution using test data manager as technical/ data Architect, created Conceptual, logical and physical data modelling for data virtualization
• Managed the team in Test case/data preparation, execution and verification of the test results in the Unit, System, Integration and regression testing.
• Created complex SQL stored procedures both native as well as external to manipulate data in real time in large, highly transactional
• Coordinated with a team of 5 Developers to initiate Advance procedures, triggers, functions, Indexes & exception handling.
• Assisted in User Acceptance Testing (UAT) and Conduct UAT review meetings with business owners.
• Worked on MQ messages on z/OS to setting up new remote queues and Production support activities.

Confidential, Minneapolis, MN

Mainframe / IT Ops Infra /DBA Lead

Responsibilities:

• Analyse the requirements and develop detailed specifications for the requirements/ enhancements.
• Design and Creation and Maintenance of all DB2 Objects and their associated Utilities.
• Handling Major Incident Issues and exposure on data movement Utilities i.e. import, export and load
• Application development and Application Maintenance work for L2/L3 Participate in application design reviews and creating data models for the GEP database.
• Created complex SQL stored procedures to manipulate data in real time in large, highly transactional
• Created and optimized indexes and queries to ensure peak performance at all times.
• Preparing high level design and low-level design document and conduct review meetings with the business user and the team.
• Analysis of a new client request, prepared a technical design, document of understanding, and the estimates of resources for the same.
• Prepare documentation on the newly developed applications and educate the team by conducting Knowledge sharing sessions.
• Assist in User Acceptance Testing (UAT) and Conduct UAT review meetings with business owners.
• Lead Team and Mentor Juniors in this assignment. Monitor and asses the Risk within the project and develop risk mitigation plan.
• Co-ordinated with all stake holders during every Hotfix and Main releases. Managed DevOps and IT Ops team for Confidential ABSi projects.
• As a part of Environment and Incident management teams, worked in various new environment setup and decommission activities and fixed many issues within DevOps from lower Environment to Higher Environment till Production for Mainframe, MQ Series, .NET & JAVA applications.

Confidential

Database and Mainframe Lead

Responsibilities :

• Setup the Accenture Development support and database support service line for the client on dev and test
• Install, configure, and maintain the WebSphere MQ messaging software, worked on WebSphere extender (WTX) using XML for Confidential settlement system.
• Implemented Synthetic test data solution for GDPR using test data manager as technical/ data Architect, created Conceptual and data model for the TDM implementation demo.
• Analyse the requirements for development and maintenance detailed specifications for the requirements and create and work on HLD, LLD, FRS and BRD documentations.
• Created complex SQL stored external and native db2 procedures to manipulate data in real time in large, highly transactional
• Responsible for the high-level and low-level design, coding and review of the whole system in Mainframe in COBOL, CICS, DB2 and JCL.
• Worked in the setup of Rational Developer for ZOS, Rational Team Concert and Subclipse Plug-in (used to connect RDZ with SVN)

Confidential, FL

Development and Mainframe Lead

Responsibilities:

• Created TDM, RDZ and RD&T implementation plan test data roadmap with key stakeholders and alignment with the customer’s, team’s, department’s and organisation’s strategic roadmaps.
• Assign the Work breakdown to the team and monitor the progress of the project.
• Conduct weekly meetings within onshore team and review the lessons learnt document and made the team aware of critical analysis requests.
• Design and Code Peer Review
• Drive and Participate in Daily Onshore Call with Onsite and Customer
• Prepare Estimation Model for project
• Mentoring and trained technically the new joiner in the project
• Drive Asset Creation in the team for automation and documentation
• Conduct SLL interview for project demand
• Designed, developed, and maintained all database related changes.
• Automation of development and testing.

Confidential, Newark, NJ

Advisory System Analyst

Responsibilities :

• Developed new codes, jobs, documents, QMF procs, QMF forms, and Sort cards etc., Enhancement/Debugging of existing codes as per client requirement.
• Performed and reviewed Root Cause Analysis of several critical client requests which involves analysis, suggesting a possible fix, preparing a comprehensive test plan, testing, and production install of the modified code and post install activities.
• Handled primary On-call support responsibility which includes monitoring daily job cycle, resolving abends (unsuccessful terminations), sending daily reports and pager messages to the client.
• Handled every part of Software Development Life Cycle right from analysis of Client's requirements, preparation of detailed designs to testing the modified logic, installation and post install reviews
• Assign the Work breakdown to the team and monitor the progress of the project. co-ordinate all offshore and onshore teams and third part Infrastructure from onshore and co-ordinate with all vendor teams to maintain releases (Hotfix and weekly/live), Managed releases hotfixes and main releases.

Confidential, New York

Module Lead Consultant

Responsibilities :

• Design, Coding and testing as per Design and Technical specifications and as per the business requirements.
• Analysis of a new client request, prepared a technical design, document of understanding, and the estimates of resources for the same.
• Assist the team in Test case/data preparation, execution and verification of the test results in the Unit, System, Integration and regression testing.
• Prepare implementation strategy and provide the support for implementation of the application.
• Onsite Coordination and Technical lead for offshore team.
• Design, Coding and testing as per Design and Technical specifications and as per the business requirements.
• Coding fresh COBOL, CICS and VSAM batch/Online using BMW MQ Series program for settle unit conversion.
• Online Testing of securities trade in test environment for location readiness as per the business requirement for the change.
• Unit testing and System testing for application, running the conversion cycle.

Confidential, Columbus

Module Lead Consultant

Responsibilities:

• Worked as Senior Developer for Confidential, based at Columbus (Ohio), USA on conversion and integration projects. Onsite Coordination and Technical lead for offshore team.
• Worked and planned strategy for on Migration from table base database to file based database system.
• Writing tech specs for the changes proposed in design for development.
• Design Screen and Panel Changes for House hold comp, Add and remove the fields from panel by changes in map, edit and display program.
• Unit testing and System testing for Auto, Dwelling Fire and Home owner application, running the dual cycle.

Confidential, St Louis

Module Lead Consultant

Responsibilities:

• Lead Analysis and design for project to reduce the dependence on a unique brewery code and avoid the cost of expanding the two digit brewery codes and modifying all applications, files and data sources that contain the brewery codes.
• Prepared Test Plan, Test Data & Assist in Test strategy development.
• Build the knowledge repository about the application and organize knowledge sharing session within the team

Confidential

Project Engineer

Responsibilities:

• Worked as Developer in different development/enhancement and support projects in Lehigh Valley and Parsippany.
• Worked on bugs or problems as it arises. Enhancements and changes to the code.

Confidential

Software Developer and Database Admin

Responsibilities :

• Design, Implementation and Testing
• Application development and Database Administration
• Server Performance & Maintenance.
• Real time Replication Monitoring and Troubleshooting.