EXPERIENCE SUMMARY:

• Having over 14 years of experience in Mainframe Technologies, ETL tools like Informatica and many databases, worked on entire Software Development life Cycle and has Team Leadership skills.
• Multiple years of experience as a SME in multiple mainframe projects in Application development, maintenance, Migration and Legacy Modernization.
• Strong experience in application development maintenance using SEI - CMM level 5 standards.
• Strong experience of providing consulting solutions to vendors.
• Strong experience in modernization of mainframe legacy system to new open systems.
• Very strong experience of presales activities in creating RFP’S and RFI’s proposal for bidding of many small and big projects.
• Worked with vendors to produce anticipated outcomes. Ensured product demonstrations fully functional and ready to address customer queries.
• Having experience in working on Batch and Online Mainframe application development, Maintenance and Production Support.
• Worked on Schedulers such as ESP, OPC, CA7 and CONTROL-M.
• 3+ years of experience in converting a System using VSAM database to Db2 and also converting the data as per the new version.
• Strong experience in presales technical presentations/demos to potential customers and partners during product launches or initial engagement.
• Worked on Configuration Management Tools like SCLM, Endevor, Changeman, and Panvalet.
• Was a Critical player in Application Upgrade of URS Insurance tool (Universal Reinsurance System) in Commercial Insurance used for Claims, Billing etc. from multiple Versions.
• Was a Critical player in designing the architecture and Application development of Wholesale Ordering systems Confidential for Confidential & Confidential for South east Regions.
• Strong experience of designing the architecture of the system involves mainframe and distributed systems.
• Experience of working with Databases like DB2, VSAM, IMS DB and ORACLE.
• Experience in creating pipeline definition for service provider using CICS explorer.
• Experience in database performance tuning. Changed Complex SQLS which was taking time into simple SQLs.
• Very good experience of conversion of data from Db2 to Oracle as well as VSAM to Db2.
• Extensively used Debugging tools like Expeditor, Fault Analyzer, Abend Aid, Omegamon and Dump master.
• Built Custom REXX Routines for the Project needs and to enhance productivity
• Having experience in batch cycle development, Production support, SLA tracking, Escalations and contingency planning
• Worked functionally very close with business team and development team. Played role similar of Business analyst, Technical writer along with technical role in different organizations. Created many technical as well as database ER diagrams using VISIO and other Microsoft tools.
• Worked on defect fixing, defect tracking with tools like Quality center, Vantive, Zira.
• Also involved in project initiation, execution and implementation encompassing activities that include requirements definition, prototyping, and proof of concept.
• Made Extensive changes to MQ Series Programs
• Worked on Data Migration and Regression Testing using File-Aid, COMPAREX utility and REXX Screens
• Used BMC utilities and Tools to Load, Unload, Import and Copy Databases in DB2.
• Involved in Server Consolidation, Changed FTP and NDM Parameters and worked on Service id Set up
• Worked on multiple SDLC methodologies like Agile, Waterfall etc...
• Strong Team Lead with excellent inter-personal, collaboration, and problem solving skills
• Has experience in Developing Stored Procedures
• Involved in Development and support of various Distributed applications
• 4+ years of current experience in critical and complex Reinsurance area of Insurance domain.
• Worked 1 year in (life insurance)Unemployment Insurance domain for Confidential .
• Having 5+ years of experience in different areas of Telecom domain with Confidential & Confidential and Confidential -systems (Wholesale ordering, Wireless Billing and collections).
• Having 4+ years of experience in Banking and Financial Services industry in different lines of business - Credit Cards, Wealth management, Asset management, Investment Banking and Core Banking.
• 6+Yrs onsite experience in various roles as Project Lead, Technical Lead, and Onsite Coordinator.

TECHNICAL AND OTHER SKILLS:

Project Management: SDLC concepts, Quality Initiatives, Estimation, Project & Resource Planning, Monitoring, Tracking, Costing/Invoicing, Release Management/Co-ordination, Client Relationship Management

MS Project, MS: Office, VISIO, PASSPORT

OPC, ESP, Control: M, CA7

Operating Systems: Windows, Z/OS, OS/390

ETL Tool: Informatica Power center

RDBMS: DB2,IMS, ORACLE, STORED Procedure

Tools: CA Tools, BMC utilities, File-Aid, CA-Endevor, Changeman, IBM Debugger, Spufi, Expeditor, MQ-Series, CSF Metavante, ESP, DB Visualizer, PowerBuilder, JJScan. CA-Abend-Aid, SYNCSORT, Informatica Power Center, Informatica Power Exchange,CrystaL Reports.

Testing Tools: Enterprise Quality Centre

Version Control: Changeman, VSS, Sharepoint, Harvest

Familiarity with: Autosys, Advanced Ms Excel

Domains: Banking & Finance(Wealth management, Credit Cards, Core banking), Telecom(Wholesale ordering, Collection, Billing), Insurance(Commercial market, Agency Market, Reinsurance, Unemployment insurance)

RELEVANT PROJECT EXPERIENCE:

Confidential

Application Development & Support

Technology: Mainframe, COBOL, JCL, VSAM, DB2, Endevor, Xpeditor, FILEAID, $AVERS, ESP, DB Visualizer, Informatica, SYNCSORT,BMC, CICS, PASSPORT

Responsibilities:

• Playing the role of mainframe architect/SME for the project.
• Creating RFP’s for the projects to convert the mainframe system to Java system.
• Create technical VISIO diagrams for system flow of current as well as future system.
• Working closely and collaboratively with customers to devise effective solutions.
• Ensuring that the company’s product can deliver on the customer’s requirements.
• Working closely with customers to understand and capture requirements.
• Replying to customers following requests for information and proposal requests.
• Presenting proposals to customers alongside members of the sales team.
• Providing ongoing support for customers post implementation.
• Producing detailed costings for customers and ensuring the contract is profitable.
• Requirement gathering and discussion with Business and Requirement Team.
• Designing architecture of the new future system where current system to be upgraded.
• Designing the technical as well as database architecture of the mainframe system.
• Upgrade of Current URS system in version 6.3 for one mainframe datacenter to 7.2 version.
• Conversion of VSAM database to Db2 database for the application.
• Conversion of data from Db2 to Oracle.
• Used BMC utilities and Tools to Load, Unload, Import and Copy Databases in DB2
• Data conversions for upgrading the current system to new upgraded system.
• Handling multiple mainframe data centers working in different URS versions
• Analysis and investigation of bugs and enhancement requests
• Developing new Informatica systems interacts with mainframe and B2B applications
• Creating mapping, Sessions, workflows.
• Estimate efforts and timelines.
• Performance tuning.
• Changed Complex SQLS which was taking time into simple SQLs. Changed SQL which has many complex outer joins. Changed the SQLs where it was pulling all the table instead of required columns. Reduced time to execute the queries.
• Improved indexes
• Changed many query where index was wrongly used.
• Used query optimizer tool and checked the query running time vs response time required and corrected the queries which were taking more time.
• Changed many sub queries and used joins to reduce the complexity and which are
• Removed many queries where we can do without queries since it will reduce the time for the system.
• Changed indexing for the INSERT, UPDATE, DELETE queries which was using more frequently.
• Building test strategies and executing test cases for various projects and enhancements.
• Participating in design sessions
• Preparation of high level and low level design documents
• Participating and providing evidence in audit and compliance activities
• Documentation of processes and building knowledge repository
• On call support and batch monitoring
• Performing production support activities
• Generating adhoc reports based on client requirements
• Onsite offshore coordination

Application Development & Support

Technology: Mainframe, Micro Focus COBOL, VSAM, DB2, Oracle, Harvest, Metavante, Dollar-Universe Scheduler, UNIX, CrystaL Reports, Stored Procedure

Confidential, Concord NH

Responsibilities:

• Business requirement gathering and preparing design documents.
• Analysis, coding and unit testing for different user raised defects and issues in the Confidential batch system.
• Used BMC utilities and Tools to Loading, Unloading the database.
• Production support for Confidential nightly batch schedules and to provide quick fixes and recoveries for batch program failures in production environment.
• Technical assistance to other team members with development of complex business logic using oracle PL/SQL and required database changes.
• Assistance to business users for successful completion of user acceptance testing for different system changes.
• Review of the program changes to ensure that they meet the requirements and standards.

Confidential

Application Development & Maintenance

Technology: Mainframe, COBOL, JCL, VSAM, DB2, HSM Crypto Processes, Easytrieve, Changeman, OPC Scheduler, File-Aid, SYNCSORT, BMC, Quality Centre, IMS, CICS

Responsibilities:

• Involved in all the project management activities.
• Creating RFI’s/RFP’s for new projects.
• Provide multiple solutions.
• Creating Design document.
• Providing Production support 24x7.
• Defect fixing, tracking the defects. Incident resolutions.
• Managing Team of 7 resources. Involved technically also in the project.
• Involved in design, coding, testing, review and deployment process.
• Managing the fixed bid and Confidential &M projects.
• Project and Resource planning, budgeting.
• Used BMC utilities and Tools to Load, Unload, Import and Copy data in database
• Timesheet approvals and involved in the quality processes involved in the project.
• SOW creation and cost estimation, forecasting the fixed bid and Confidential &M projects.
• Project estimation for the ongoing and new projects.
• Invoicing of fixed bid and Confidential &M projects.
• Client Management for the projects.
• Mentoring resources under the team

Confidential

System - Application Development & Maintenance

Technology: Micro Focus Cobol, VSAM, JCL, DB2, IMS, CICS, Changeman

Responsibilities:

• Managing Team of 20 resources.
• Creating RFP’s for new projects.
• Provide multiple solutions.
• Maintaining Quality Processes for the Project
• Involved in all the project management activities.
• Project and Resource planning, budgeting.
• Timesheet approvals and involved in the quality processes involved in the project.
• SOW creation and cost estimation, forecasting the fixed bid and Confidential &M projects.
• Project estimation for the ongoing and new projects.
• Invoicing of fixed bid and Confidential &M projects.
• Client Management for the projects.
• Mentoring resources under the team
• Communication with client for the status of deliverables
• Review of code, test cases, test results
• Tracking of on-time deliveries.
• Mentoring resources under the team
• Knowledge Transfer between application teams for effective utilization.
• Participate in Quality processes
• Functional and Verification Testing (FVT), System Testing (ST).
• Bug fixing and retesting

Confidential

Technology: Cobol, VSAM, JCL, DB2, CICS, Changeman, Stored Procedure, File-aid, QMF, SPUFI, OPC, CrystaL Reports, IMS, SYNCSORT

Module Lead

Responsibilities:

• Managing Team to deliver the project on time, on budget.
• Co-ordination with onsite Cognizant and Confidential team for day to day tasks.
• Project Management involved, managing the team, Risk management, Incident management, Problem management etc.
• Conduct effort estimation and schedule estimation for different tasks.
• Performing requirement analysis, design, code reviews, testing and implementation activities.
• Documentation of processes
• Used BMC utilities and Tools to Load, unload, Import and Copy in DB2 database
• Status Reporting to senior management and business partners
• Raise and escalate project issues and risks
• Prepare weekly status reports
• Performance tuning.
• Changed Complex SQLS which was taking time into simple SQLs. Changed SQL which has many complex outer joins. Changed the SQLs where it was pulling all the table instead of required columns. Reduced time to execute the queries.
• Improved indexes
• Changed many query where index was wrongly used.
• Used query optimizer tool and checked the query running time vs response time required and corrected the queries which were taking more time.
• Changed many sub queries and used joins to reduce the complexity and which are
• Removed many queries where we can do without queries since it will reduce the time for the system.
• Quality data tracking and matrix preparation
• Monitor and track project deliverables in timely fashion
• Day to day project management activities

Confidential

Technology: Cobol, VSAM, JCL, DB2, CICS, Changeman, Stored Procedure, File-aid, QMF, SPUFI, Stored Procedure, ESP

Technical Lead

Responsibilities:

• Creating RFP’s for new projects.
• Provide solutions for new credit card products.
• Preparing high level and low level designs
• Tracking of on-time deliveries.
• Mentoring team technically and functionally
• Performing Peer Review
• Knowledge Transfer between application teams for effective utilization.
• Attending daily status calls with client and senior management.
• Understanding of Initial Requirement Documents, Initial Analysis of project and Enhancements.
• Coordinating work with onshore team
• Client meetings for technical/functional discussions and Suggestion in design changes.
• Task allocation to the team
• Resolving queries of team members, Issue resolving.
• Management activities like Weekly status report (WSR) preparation.

Confidential

Technology: Cobol, VSAM, JCL, DB2, CICS, Changeman, Stored Procedure, File-aid, QMF, SPUFI, OMEGAMON, Quality Centre, BMC, SYNCSORT

Team Leader

Responsibilities:

• High Level Design and Analysis
• Preparing Design Specs and Program specs
• Coding and preparing Test specs
• Performing Peer Review
• Impact analysis
• Performance tuning
• Knowledge Transfer between application teams for effective utilization.
• Technical specification preparation.
• Coding of Request handler programs, batch & Sub-routine programs in COBOL and DB2.
• Used BMC utilities and Tools to Load, Unload, Import and Copy Data in DB2.
• Unit and integration testing.
• Defect logging and fixing in Mercury Quality Center tool.
• Client Communication for query resolution.
• Production fix of problems during post implementation phase.

Confidential

Technology: Cobol, VSAM, JCL, DB2, Spufi, TSO/ISPF, JCL, MQ-series, SAS, File-Aid, File-Aid/DB2, Changeman, BMC, SYNCSORT, OMEGAMON, SPUFI, QMF, XML, NDM, Vantive, Quality Centre, IMS/DC rganization

Onsite Coordinator/Project Lead

Responsibilities:

• High Level Design and Analysis
• Preparing Design Specs and Program specs
• Providing 24x7 production support of the system
• Coding and preparing Test specs
• Performing Peer Review
• Impact analysis
• Performance tuning
• Knowledge Transfer between application teams for effective utilization.
• Technical specification preparation.
• Coding of Request handler programs, batch & Sub-routine programs in COBOL and DB2.
• Unit and integration testing.
• Defect logging and fixing in Mercury Quality Center tool.
• Client Communication for query resolution.
• Production fix of problems during post implementation phase.