Manish Patel
Camp Hill, PA C: 860-***-****
************@*******.*** www.Linkedin.com/in/manishpatel11
summary
Experienced mainframe Technical Lead/Sr. Application Developer with experience in partnering with customers to understand business requirements to deliver technical solutions leveraging years of Information Technology knowledge to significantly enhance product quality, decrease operational costs and increase customer satisfaction. Utilize a hands-on approach while working on the projects to deliver results in a defined timeframe. Experience in collaborating with cross-functional teams and leading onshore/offshore team members effectively to achieve objectives. Core competencies include:
Strong Analytical Skills
Customer Focused
Performance Improvement
Collaborative Problem Solving
Leadership
Team Player
Self-Motivated
Strong Interpersonal Skills
Deadline Sensitive
Cross Functional Coordination
Detail Oriented
Resource Management
key accomplishments
Worked on modification of several COBOL/DB2 batch programs on the premium waiver claim reserve project which required to change several actuarial formulas and decreased the reserve by 23.7 million dollars which reflected in Aetna’s first quarter 2002 for which received an “Employee of the Quarter Award – Best Performance” for the first quarter 2002.
As part of the performance improvement effort, worked on the tuning of the SQL and modifications to design of the batch program which resulted the job to complete within 50 minutes from 23 hours.
Managed a team of two to four onshore/offshore team members at various times on several projects.
Several years of experience working as a Sr. Application Developer/Technical lead leveraging COBOL/DB2/JCL/VSAM/Stored Procedures and AdvantageGen (Cool:gen application development case tool) technical skills on several projects. Core competencies include: Requirement analysis, Program analysis, design, development, Unit and Integration testing, QA testing support, Production Implementation, Problem Solving, Troubleshooting, Root Cause analysis.
Over two years of BI developer and data analysis experience using SAP Business Object Web intelligence 4.0 and universe design software tools including ETL process to extract data from mainframe DB2 tables, reformatted and populated 22 DB2 tables which were used by the business users to create Webi Reports.
Worked on two small web development projects for the provider smart front end (SFE) and Provider Directory Reporting (PDR) applications for which, developed and maintained several java classes, methods and JSPs using Web sphere Application Development tool.
Excellent system documentation skills including translating business requirements into functional specifications, detailed system design and unit testing plans.
Excellent DB2 performance improvement skills.
Completed Scrum Master training of Agile methodology.
Excellent Release Management skills
Excellent critical thinking, problem solving and troubleshooting skills.
Highly effective communication skills, and respected by colleagues.
Well organized, detail-oriented, focused and goals driven.
Strong work ethic.
Very patient and well-developed sense of independence.
technical skills
COBOL
DB2
JCL
MQ
SQL
Easytrieve
CICS(Basic level)
VSAM
IMS(Basic level)
TSO
FILEAID
QMF
ENDEVOR
Xpediter
IBM Mainframe
SAP Business Objects Universe Designer and Web Intelligence Reports developer
JAVA
API Interfaces
professional experience
Department of Labor and Industry, Harrisburg, PA
Sr. Application Developer 2015 – current
Responsible for development and maintenance of unemployment compensation system.
Currently, working as a Sr. Application Developer for an unemployment compensation claim system leveraging COBOL/DB2/JCL/VSAM/EASYTRIEVE/AdvantageGen (Cool:gen application development case tool) technical skills. Core competencies include: Requirement analysis, Program analysis, design, development, testing, QA testing support, Production Implementation, Problem Solving, Troubleshooting, Root Cause analysis.
Aetna, Hartford, CT
Technical Lead/Sr. Application Developer 2001 – 2015
Responsible for development and maintenance of Data Migrator, Member, Provider, Disability, Defined Benefits systems.
Worked as a Sr. Application Developer/Technical Lead on several projects for several systems leveraging COBOL/DB2/JCL/VSAM/Stored Procedures and AdvantageGen (Cool:gen application development case tool) technical skills on several projects. Core competencies include: Requirement analysis, Program analysis, design, development, testing, QA testing support, Production Implementation, Problem Solving, Troubleshooting, Root Cause analysis.
Managed several onshore and offshore team members to support several application development projects tasks. The tasks included requirement analysis, design, coding, unit testing, user testing support and implementation of the software programs into production.
Worked as a developer and as a technical lead to manage onshore/offshore team members to develop business intelligence reports by designing and developing universes using SAP Business Object Web intelligence 4.0 and universe design software tools including ETL process to extract data from the mainframe DB2 tables, reformatted and to populate 22 DB2 tables which were used by the business users to create Webi Reports..
Worked on the system infrastructure projects to support new development environments using Endevor software tool. Worked on the several service requests to improve the performance of the online transactions and stored procedures for which, analyzed several access paths and implemented various solutions to make them run efficiently.
Worked as a release coordinator and coordinated several releases involving multiple cross functional applications.
As part of the performance improvement effort, worked on the tuning of the SQL and modifications to design of the batch program which resulted the job to complete within 50 minutes from 23 hours.
Worked on the two small web development projects for the of provider smart front end (SFE) and Provider Directory Reporting (PDR) applications for which, developed and maintained several java classes, methods and JSPs using Web sphere Application Development tool.
Worked on modification of several COBOL/DB2 batch programs on the premium waiver claim reserve project which required to change several actuarial formulas and decreased the reserve by 23.7 million dollars which reflected in Aetna’s first quarter 2002 bottom line result for which received an “Employee of the Quarter Award – Best Performance” for the first quarter 2002.
Travelers Insurance Inc, Hartford, CT
Information Systems Consultant 1999 – 2001
Responsible for development and maintenance of CDE application system.
Worked as a consultant on the personal lines system leveraging COBOL/DB2/JCL and AdvantageGen (Cool:gen application development case tool) technical skills. Core competencies include: Requirement analysis, Program analysis, design, development, testing, QA testing support, Production Implementation, Problem Solving, Troubleshooting, Root Cause analysis.
education and training
MBA, Computer and Information Science, West Haven, CT
Diploma, Computer Science, Computer Processing Institute, East Hartford, CT
Scrum Master (Agile)
Advanced DB2 programming
Software Project Life Cycle
Release Management
Visual Basic 4.0
PowerBuilder 5.0
Microsoft C++
SAP Business Objects universe design and Web Intelligence 4.0
Advanced JAVA