SUMMARY

• Overall 8+ years of IT experience in development, implementation, support and maintenance of Business applications in Health care, Personal and Commercial insurance domains using Mainframe Technologies.
• 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 requirements 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

Hardware: Pentium IV, MC68HC12A Micro Controller

Operating System: Windows XP, OS/390, z/OS

Programming Languages: C, C++, REXX, CICS, COBOL, JCL

Databases & Tools: DB2, IMS, Oracle, File-Manager, Fault Analyzer, File Aid

Other Utilities: Change man, TSO-ISPF, QMF, DFSORT, Endevor, MQSeries, Xpediter, EZTRIEVE, ICETOOL, CA7

PROFESSIONAL EXPERIENCE

Confidential

DATA ANALYST

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 Confidential 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

DATA ANALYST

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

DATA ANALYST

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 Confidential 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

DATA ANALYST

Responsibilities:

• Responsible for gathering the requirements and changing the Confidential 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