SUMMARY

• A passionate, dedicated and resourceful SAFE 4.0 Certified Agile consultant with over 12 years of work experience out which for 10 years in Mainframe technologies and 3 years in Middleware Integration space and ETL reporting technologies.
• Current Experience encompasses of around 9.5 years of US experience as Onsite coordinator, lead designer & developer, and 2.5 years of offshore experience in WMQ/WMB/IIB and Mainframe & Hyperion projects using Integration technologies WMQ, WMB, IIB, ESQL, Mainframe technologies DB2, VSAM, JCL, COBOL, CICS, DB2 Stored procedures, triggers and ETL reporting technologies Hyperion SQR & BQY and Cognos with strong expertise in handling the production support projects and Development projects.
• Very rich experience in Analysis, Design, Development and implementation of delivery projects. Also having proven experience in production support activities with major and minor enhancements.
• Solution Concept to Execution - Unique competency in translating business issues into customer solutions including opportunity identification, requirements development, software development management, delivery, support, and analysis.
• Excellent verbal and written communication skills, works well with people of all levels within organization. Good Project Management Skills, Good communicative with demonstrated proficiency in steering committee meetings, resolving challenging issues and performing tasks in time.
• Production Support - Maintaining and performing production support activities, fixing business issues, providing technical solutions to business problems, generating various adhoc reports using Mainframe technologies like DB2, JCL, VSAM file processing. Created client specific reports using reporting tools like Hyperion SQR, BQY and Cognos reporting.
• Delivery expertise - Wide experience in handling delivery projects with end to end responsibility, provided excellent solutions for clients with very good technical knowledge in Mainframe technologies, Hyperion & Cognos technologies and Integration technologies like WMQ, WebSphere Message Broker and IBM Integration Bus.
• Agile expertise - Delivered projects in Scaled agile architecture to provide esteem benefit to company from cost perspective using Agile scrum, DSU, retro and SOS meetings.
• SDLC Experience - Experienced in managing all facets of the SDLC ranging from Planning, Specification, Design, Development, Acceptance and Implementation, with timely delivery against aggressive deadlines.
• Mainframe Experience - Worked on small and big Mainframe projects using various mainframe technologies. Integrated with other teams in capturing the requirements, working thru dependencies and deliver defect free code for production.
• ETL migration experience - Worked on Hyperion to Cognos reports migration.
• IIB Migration Expertise - Worked on Message Broker migration project from WMB7.5 to IIB10.0 for migrating message flows, message sets, creating and deletion of Message Queues.
• IIB/WMB works like creating new broker flow, sub flows, calling web services, creating BAR file deployment, Message set changes deployment, BAR file UDP properties comparison, MQ queues names and clusters validation.
• Making Database calls thru ESQL for getting table information while processing the messages, used MQ, FTP, HTTP and SOAP/REST protocols.
• Create MQ topology for the message broker migration project from WMB8.0 to IIB10. Also create adhoc & temporary solutions by creating message flow and deploying bar files in production.
• Adept at working with internal & external teams including offshore teams and coordinating for on-time delivery of solutions and support activities.
• Excellent Presentation, Communication, Interpersonal, Leadership, Decision Making, Influencing, Problem Solving and Motivational Skills
• Strong quantitative analysis skills to lend insight to highly ambiguous and sensitive business problems.

TECHNICAL SKILLS

Mainframe Tools: NDM (Connect Direct), FILE-AID, ENDEVOR, QMFPANVALET, ALCHEMIST, SPUFI, ABEND AID, PARALLEL DEVELOPMENT MANAGER, SDF, Topaz, IBM Data Studio.

Programming: COBOL, CICS, JCL, ESQL, SQL, DevTest and EASYTRIEVE.

Integration Tools: WMB 7.0, IBM Integration Bus (IIB)10.0, WMQ 7.5 & 8.0SoapUI, Winscp, RfhUtil, Putty.

Databases: DB2, Oracle 9i/10i and IDMS.

Code Repositories: Endevor, Panvalet, Git and Svn.

Online: CICS, MQ Explorer, IIB Explorer.

ETL tool: Knowledge in DataStage

Reporting Tools: Hyperion SQR, BQY and COGNOS 10.0/11.

Operating Systems: MVS/z-OS, Windows NT 4.0, Windows 9x/2000/XP/7Knowledge in UNIX, Linux & Connect Direct (NDM).

Scheduling Tools: CA-ESP and CA7

Automation Tools: CA-DevTest, TotalTest, uDeploy, Nexus.

PROFESSIONAL EXPERIENCE

Confidential

Sr. Consultant

Responsibilities:

• Work closely with Business Users, external banks and internal teams to gather functional requirements, prepare mapping documents and interface contracts.
• Prepare mockup report formats for business reporting and obtain consent from business users community.
• Participate in external team meetings and external clients & vendor meetings to understand changes at bank/vendor/PBM end and gauge their impacts to core Confidential applications.
• Prepare low level design after doing mainframe code analysis and requirements analysis, work with team to deliver things on time.
• Create new B2B gateway setup for new file transmissions between Confidential and external banks.
• Design develop and Unit testing of new COBOL, JCL, Easytrive modules and DB2 stored procedures to perform various interfacing functionality of the applications.
• Create new DB2 objects for processing, storing & updating data transmitted between Confidential and banks from eligibility & claims perspective.
• Work with IIB partners & MQ partners to expose the new stored procedure for them to use in IIB flow for processing business logics on Mainframe side of it.
• Deliver projects on time with quality code, and serve the warranty period with effective jobs monitoring and data analysis, handover the deliverables to production support team for smooth execution.
• Implemented projects in agile framework to effective and efficient delivery of business requirements in timely manner.
• Prepare and share ESP scheduling for jobs as part of delivery process.
• Onsite coordinating - Get business requirements, add additional information required to start work, assign to offshore team, get work delivered in time with highest productivity.
• Reviewing the work items at different phases, peer reviewing before sending deliverables to clients.

Environment: Mainframe: COBOL, DB2, SPUFI, JCL, VSAM, EASYTRIEVE, DB2, Topaz and TotalTest.

Confidential

Sr. Consultant

Responsibilities:

• Capture the existing Hyperion reports functionality and prepare functional document with details.
• Prepare road map for migration process, identify & highlight the improvement areas across various places while processing the events.
• Create new DB2 stored procedure for logging events.
• Create new Cognos reports to generate reports in Cognos tool.
• Update existing Mainframe COBOL programs, jobs, SYSIN members to improve the performance of data extract and loading process.
• Create global groups for Cognos users, grant permissions, create projects within Cognos environment to grant access based on roles.
• Create metadata, query objects and query items using Cognos framework manager, test the changes and deploy packages to Cognos portal for reporting.
• Extensively used Cognos reporting studio for creating the reports using packages and published over various test environments for QE testing.
• Deployed the packages and reports in production thru migration process for seamless reporting.
• Created new MQ objects and established connection with CCF-UI to place messages from Cognos report for replay functionality by business users.
• Created new service IDs and obtained accesses for ESP batch scheduling process of Cognos reports.
• Created .bat files for new Cognos 11 reports to kick them from ESP application triggers for controlled run of these jobs after ETL process.

Environment: ETL Tools: Hyperion SQR reports & Cognos V10.0

Confidential

Sr. Consultant

Responsibilities:

• Work closely with Business Users, and system analyst to gather functional requirements, and prepare solutions for business requirements thru High level design.
• Participate in external team meetings and external clients & vendor meetings to understand changes at bank/vendor/PBM end and gauge their impacts to core Confidential applications.
• Prepare low level design after doing mainframe code analysis and requirements analysis, work with team to deliver things on time.
• Design develop, deploy and Unit testing of new message flows, sub flows, libraries UNIX scripts and File transmission NDM jobs to perform file processing and transmission.
• Analyze and identify queues and get them created with the help of WMQ admin team.
• Prepare message broker flows for creating the temporary data for testing production flows before actual production data arrives.
• Implemented projects in agile framework to effective and efficient delivery of business requirements in timely manner.
• Handling abends & Production fallouts - Proactively monitor the test cycle execution, scenarios and results that QA team is performing to identify, communicate, fix and retest the gaps identified.
• Build and prepare bar files, deploy bar files thru Jenkins & UDeploy automated process for various test & production environments.
• Prepare and share ESP scheduling for jobs as part of delivery process.
• Onsite coordinating - Get business requirements, add additional information required to start work, assign to offshore team, get work delivered in time with highest productivity.
• Reviewing the work items at different phases, peer reviewing before sending deliverables to clients.
• Build automated test services using CA-DevTest automation tool.
• Create new Cognos report and update existing Hyperion reports to populate the events in dashboard reporting.

Environment: Middleware: WMQ7.5, WMQ8.0, WMB7.0, IIB10, SoapUI, RfhUtil, Putty, SVN, MQ ExplorerJenkins, UDeploy, Unix, ESP, IIB Explorer and CA-DevTest.

Confidential

Sr. Consultant

Responsibilities:

• Work closely with Business Users, and system analyst to gather functional requirements, and prepare solutions for business requirements thru High level design.
• Provide effort estimates and Tier level dollar estimates for the efforts including onshore and offshore teams.
• Participate in external team meetings and external clients & vendor meetings to understand changes at bank/vendor/PBM end and gauge their impacts to core Confidential applications.
• Provide long term solutions for business issues and requirements and short term & tactical solutions when time/budget/testing supports are not enough to deliver long term solutions.
• Create new COBOL program, JCL jobs, DB2 stored procedure, triggers, new tables, views and new NDM jobs for file transmission process.
• Design develop and Unit testing of new Message broker flows, sub flows, services and fix production issues by changing ESQL code, updating existing flows & nodes within flow.
• Create MQ topology for WMB applications as part of migration project.
• Production implementation activities like creating BAR files, validating the BAR file UDP properties before and after deployment, working closely with production support team for deploying the right BAR files and message sets in production.
• Analyze and identify queues and get them created with the help of WMQ admin team.
• Prepare message broker flows for creating the temporary data for testing production flows before actual production data arrives.
• Deliver projects on time with quality code, and serve the warranty period with effective jobs monitoring and data analysis, handover the deliverables to production support team for smooth execution.
• Implemented projects in agile framework to effective and efficient delivery of business requirements in timely manner.
• Handling abends & Production fallouts - Proactively monitor the test cycle execution, scenarios and results that QA team is performing to identify, communicate, fix and retest the gaps identified. Monitor production data after release and address any issues or gaps identified. Propose and apply temporary tactical solutions for smooth production execution in case of major gaps or show stopping gaps are identified.
• Prepare and share ESP scheduling for jobs as part of delivery process.
• Onsite coordinating - Get business requirements, add additional information required to start work, assign to offshore team, get work delivered in time with highest productivity.
• Reviewing the work items at different phases, peer reviewing before sending deliverables to clients.

Environment: Mainframe:COBOL, JCL, DB2, VSAM, DB2 Stored procedures, DB2 Triggers, ESP.

Confidential

Sr. Software Engineer & Consultant

Responsibilities:

• Gathering business service requirements and provide solutions and design for every requirement without any gaps.
• Opening Service request for various business requirements, issues coming in production cycles, Preparing Technical Design Document for service request.
• Evaluate production run details for critical jobs, identify the problems and reasons for run times, and provide solutions to improve performance.
• Followed SDLC Process and Implemented Best Practices in fixing issues, providing the work around solutions as quick fix to production fallouts, prioritizing the abends and resolving them on time without crossing SLA time.
• Handling Incidents - Validate the incidents coming in daily, analyze them, resolve and present best possible solution to clients every day.
• SR life cycle - Move major code fix into SR, create, assign, prepare design documentation, develop solutions, code, unit test, regression testing, walk through results and install the elements into production.
• Production at high priority, providing technical solutions to business issues, creating various business reports using DB2, JCL, VSAM and other Mainframe technologies.
• Custom reporting - Create various reports as per client’s request, generate adhoc requests using JCL, EASYTRIEVE and SORT utilities.
• Business reports - Worked on various reporting tools like Hyperion SQR reports designing, construction, and enhancing and production supporting.
• Onsite coordinating - Get business requirements, add additional information required to start work, assign to offshore team, get work delivered in time with highest productivity.
• Attending status meetings, organizing the internal team meetings.
• Reviewing the work items at different phases, peer reviewing offshore work items.

Environment: Mainframe:COBOL, VSAM, JCL, EASYTRIEVE, DB2, CICS, ENDEVOR, FILE-AIDABEND-AID, SDF, QMF and SPUFI.

Confidential

Software Engineer

Responsibilities:

• Worked closely with Business Users, discussed and gathered the requirements from different user groups to perform various payment methods t apply in Confidential system.
• Analysis of requirements document, preparing BSD from them.
• Coordinating and gathering requirements from onshore team for the deliverables those need to be coded from offshore.
• Preparation of MCR documentation, Unit testing, functional testing and regression testing.
• Preparation of unit test documentation, giving walk through to clients on change requests that have been worked, getting business sign off for the results.
• Moving elements into production, production installation, doing technical checkout.
• Attending status meetings, organizing the internal team meetings.
• Reviewing the work items at different phases, peer reviewing before sending deliverables to clients.

Environment: COBOL, VSAM, JCL, DB2, and SPUFI.

Confidential

Software Engineer

Responsibilities:

• Worked closely with Onsite team in gathering requirements, sharing ideas about solutions, meeting client expectations, and presenting offshore status.
• Analysis of high level design document, and preparing low level design document.
• Coordinating and gathering requirements from onshore team for the deliverables those need to be coded from offshore.
• Constructing the requirements in efficient and effective way to save run time and follow standards.
• Preparation of MCR documentation, Unit testing, functional testing and regression testing.
• Preparation of unit test documentation, giving walk through to clients on change requests that have been worked, getting business sign off for the results.
• Moving elements into production, production installation, doing technical checkout.
• Attending status meetings, organizing the internal team meetings.
• Reviewing the work items at different phases, peer reviewing before sending deliverables to onsite.

Environment: COBOL, VSAM, JCL, DB2, IDMS, PANVALET, QMF and SPUFI.