Summary:

• 8 years of experience in Healthcare, Life and property casualty insurance applications
• Designed and developed many applications in IMS and CICS environments
• Worked extensively with VSAM, IMS and DB2 databases
• Expertise in utilities EZTRIEVE, DFSORT, File Manager, File Aid, QMF, Fault Analyzer, ICETOOL
• Expert in business analysis for analyzing the user requirements.
• Result oriented team player with ability to learn, implement latest technologies and has strong inter-personnel skills.
• Have excellent communications skills with good analytical, logical and problem solving ability.

Technical Skills:

Professional Experience:

Confidential

business analysis

ENVIRONMENT : DB2, VSAM, MQSeries, EZTRIEVE, DFSORT, OS390

Responsibilities:

• Interaction with client for understanding the requirements and the data to be recorded in the system
• Performed analysis on the feasibility of the project
• Analysis and design for synchronizing CIF database with the Centralized Repository Database
• Preparing Program Specification documents
• Setup Message queues to furnish communication interface between online application and two different backend systems
• Developed applications to record the online transactions in the message queue
• Implemented applications to read from the message queues and synchronize the data into backend systems
• Applied trigger settings on the message queues to automatically trigger the synchronization applications
• Performed integrated testing with other applications
• Identifying data synchronization issues
• Supported business owners during requirements phase providing mockup reports and subject matter expertise in several applications.
• Preparing Status report and the project metrics for every month

Confidential

business analysis

ENVIRONMENT : DB2, IMS DB/DC, MQ Series, File Manager, Fault Analyzer, File Aid

Responsibilities:

• Perform business process analysis on the details required to price a claim using NetworkX by interacting with the business users or claims operators
• Document the analysis details
• Prepare technical design document with detail description of technical changes being made to the system and conduct walk-through to the design review team
• Co-ordinate with various teams involved to establish the connection between NetworkX and Pricing Systems Application
• Implement the requirements to send required claim details to NetworkX for pricing
• Develop code to interpret the results from NetworkX pricer and send priced claim details to the calling applications, in the existing pricing system format
• Support the integration testing team in preparing Test Plan, Test evaluation summary to complete SIT in time
• Support user acceptance testing team to complete testing activities in time and obtain sign-off
• Provide post production support
• Develop code to support new reimbursement types
• Applying changes to rate formulas by modifying code

Confidential

ENVIRONMENT : DB2, IMS DB/DC, MQ Series, File Manager, Fault Analyzer, File Aid, PL/SQL

Responsibilities:

• Perform business process analysis on the details required to price a claim by interacting with the business users or claims operators
• Document the analysis details
• Prepare technical design document with detail description of technical changes being made to the system and conduct walk-through to the design review team
• Co-ordinate with various teams involved to establish the connection between NMS and WGS Pricing Systems Application
• Design and development of PL/SQL objects such as Packages, functions, procedures, triggers for special rate calculations
• Implementing the change
• Support the integration testing team in preparing Test Plan, Test evaluation summary to complete SIT in time
• Support user acceptance testing team to complete testing activities in time and obtain sign-off
• Provide post production support

Confidential

ENVIRONMENT : DB2, IMS DB/DC, VSAM, MS Access, QMF, EZTRIEVE, DFSORT, File Manager, Excel Macros, MS Visio, CA7

Responsibilities:

• Responsible for gathering the requirements and changing the Profit Sharing Application to process the data from Specialty feed instead of RP feed
• Contributed to re-design of the database and application to make it flexible on its features and for performance improvement
• Re-designed the method to generate Calculation statements
• Scheduled jobs for payment cycles every month
• Involved in performance tuning of Commercial Lines calc sheet generation process which reduced 50 of CPU time and 3 hours of execution time
• Participated in analysis, design and development of other enhancements to cater to business needs
• Performed end-to-end validation of the application after every production run during the commission payout cycles
• Provided quick solutions or work around when there is a show stopper issues in running the application
• Fixed production defects
• Developed excel macros for automating the validation process of payouts for accuracy of results and benefit for audits
• Developed REXX tools to automate the monthly tasks
• Co-ordinated the activities of the team at offshore. With meager amount of knowledge transfer, was able to deliver the results in time
• Tracked the defects and generate project metrics every month
• Assisted team members in trouble shooting the application and provided technical help
• Improved the stability of the system. Greatly reduced the number of production abends

Confidential

ENVIRONMENT : VSAM, File Master, File manager, ICETOOL, MS Visio, Windows 95, PeopleSoft

Responsibilities:

• Ensuring quality of deliverables
• Sending Weekly Status Reports
• Initiate/Attend Teleconferences with client/onsite team on a need basis
• Monitor progress of the project on a regular basis
• Overall Technical Guidance to the project team
• Allocate work and monitor all activities
• Co-ordinate training specific to the project
• Estimating efforts and Assigning tasks to offshore team members
• Consult with QR and conduct audits
• Create and maintain all quality documents
• Tracked Defects and performed Fish bone Causal analysis to improve the process in the project
• Extensive research on the features of File Manager compare utilities to best suit the validation process
• Design and development of tools to compare the information repository in the Merger application and various source feeds
• As part of the Automated testing development team involved in
• Preparing Resource Utilization and Load Factor metrics for Management team
• Developed REXX programs to generate reports of the comparison
• Execution of the tools for test approaches and reporting discrepancies
• Analyzing the results of comparison
• Implementation of requirement changes to rule based and full automation approaches
• Implementing Enhancements in the Tool User Interface
• Performance improvements to the tool by splitting data into logical portions as many compare and sort utilities had limitations on the volume of data that could be handled
• Imparting REXX training to Entry Level Associates
• Defect Fixing

Confidential

ENVIRONMENT : DB2, MS Access, OS 390, Windows 95

Responsibilities:

• Design and Development of the User Interface to the tool.
• Imparting REXX training to Entry Level Associates
• End to End testing of the automated tool.
• Defect Fixing
• Analysis of Enhancements
• Implementing Enhancements

Confidential

ENVIRONMENT : DB2, IDMS, CICS, ADSO, Xpediter, Change Man, File Aid, IBM OS390, Windows 95

Responsibilities:

• Development of REXX Automated Conversion tool which converts ADSO-IDMS Programs to CICS DB2 Programs.
• Conversion of DC COBOL programs, IDMS to DB2.
• Conversion of ADSO Dialogs to CICS Programs.
• Integration, Testing and Bug-fixing.
• Data Migration Activities.
• Analysis and Development of Tools for the Parallel Processing Activity where both the old and new systems had to work in Parallel
• Generalized the Data Migration tool to be used for any Database Migration applications
• Involved preparing the installation packages for the generalized Data Migration tool