SUMMARY:

• Industries: Auto Insurance Health Care Insurance, Distribution, Manufacturing as System software development.
• Over 14 years of IT experience with Application Design, Documenting, Coding Debug, Analytical and focus on all phases of the software development cycle and implementation Coordination and Production Support.
• Experience in AS/400 I-series V7R1 WDSC, SQL Embedded/Dynamic , Free-RPG, ILE RPG IV , RPG/400, RPGIII, CL/400and DB2/400, SUBFILE, SQL/400, Query/400, RLU, DFU ALDON, MKS, PFE, PDM, RSF, HAWKEYE, APLUS, STRANT, DBU40,ALDON,COBOL/400, MQ, Lotus Notes, i series
• Experience in Web Technologies JAVA2.0, WebSphere, Tomcat, Eclipse, DAO, HTML and XML.

Technology Details:

• Language: RPG III, RPG IV, RPG ILE, RPG/FREE. iseries
• Job Control: CL Programming CLP , SQL-Triggers, iSeries Navigator
• Implemented Database constraints primary, unique, referential and check , SQL Stored procedures, Triggers.
• DB2/400: DDS-Physical Files, Logical Files, Join Files, Data Dictionaries
• Screen Design Aid SDA : Menus, Display Files, Sub-file Programming
• File Transfer Protocol FTP : Query/400 and Open Query File OPNQRYF
• System Administration-PTFs : System Values, Basic Configuration
• Security Administration-User Profiles, Authorization Lists, Object Authority
• ROBOT Job Scheduler
• Operations- Backup Restore, Print Management, Job Scheduler
• UIM User Interface manager, IBM MQ Series API set
• DDM Distributed Data DS, DDM, DDL HTML, XML
• VISIO Flowcharting Software,
• ALDON, MKS Implementer Change Management software MKS
• Clarity, Lotus Notes, HP-ALM , Service Now, Peregrine

PROFESSIONAL EXPERIENCE:

Confidential

Technical Lead/Developer

• Lead to Offshore team by providing Detail Design Documents and Program Specification-PGS
• Implementation coordinator and Responsible in Code management and Deliverable.
• Unit Test Plan, Unit Test reports and corresponding Document of Understanding.
• Coding/Testing the programs written in RPG/COBOL/CL.
• Assuring quality in the deliverables and collection of data for metrics.
• Coding several new programs and modifying many existing programs depending upon release requirement as per the CIGNA standards and compilation.

Technical Environment: AS/400, ILE-RPG, SQL/400, ILE-COBOL, RPG/400, CL/400, COBOL/400, EMBEDDED SQL, DB2/400, ALDON, HAWKEYE, HP-Quality Center, GUI, i series

Confidential

Technical RPG Lead/Developer:

• Lead Off shore team with code Design, and technical documents.
• Involved in designing and developing server side component called Reverse Mapping in Web Based Endorsement projects for varies states.
• Designed and developed Effective Date driven functionality in AgencyPort application.
• Involved in designing and developing various server side components to implement Business rules J2EE
• Involved in maintaining application, rules engine which is a vendor application.
• Involved in developing various server side components called Forward Mapping in Agency Port application that interacts with legacy system's middle-tier.
• Involved in developing DAO DataAccessObjects and SIS-T21 Agency Port will initiate Policy Quote transaction and will send ACORD XML request to XTS Server then it will be Parse Agency Port XML to T21 format and populated to T21 data queue. Finally populated policy info in SIS database.
• Involved in developing certain functionalities like Viewing Policy Billing Information , Agency Payment Report and View Policy Documents for Agency Port application.
• Last but not least Production Support.

Environment: AS/400, ILERPG, RPG/400,SQL/400, AgencyPortal, SIS, J2EE Servlets, JSP, JavaScript, HTML,XML , WebSphere, Tomcat, Eclipse, DAO,Tech21, i series

Confidential

Specialty Insurance System SIS

Senior Programmer Analyst:

• Extensive exposure to application programming in RPGLE, SQL/400
• Main developer for MVP/Artius Rater Engines Java Script .
• Developing MVP Instructions and validating MVP and Artius tables and Uploading to SIS System
• Actively involved in New Rate Filling Projects.
• Other adhoc activities like preparation of Implementation plans and source comparisons using MKS

Environment: OS400, RPG/400,RPGILE, CL/400, SQL/400 on AS/400, Lotus Notes, ADM, MKS Implementer , Java, i series

Confidential

American Business Solutions

Programmer Analyst:

• End- to-end Production support and enhancement within the SIS AS/400 package
• Developed application prototypes utilizing new technology Java, JavaScript,ILE
• Planned and facilitated design meetings with clients supported cross team efforts
• Extensive exposure to application programming with Sub files, display files Programming RPG400.
• Developing test Plans and conducting the Unit system testing
• New developments according to user requirements.
• Other adhoc activities like preparation of Implementation plans and source comparisons using MKS.

Environment: OS400, RPG/400, RPGILE, CL/400, SQL/400 on OS/400 Lotus Notes, ADM, MKS Implementer , JWalk, Java, Java Script, i series

Confidential

Programmer Analyst:

• Created new ILE Programs and Service Programs
• Written various Trigger programs based on the Business flow
• Created SQL to the extent of designing and creating tables and indexes.
• Automated programs to update Files different systems
• Created Webservice Programs to get for address cleansing Stop Id and Stop Id type
• Written complete DIRE process
• Created BrokerQue Programs to for Extract and Transform Multiple DATAQ for Varies Jobs

Which in terns Update and insert Business Objects

Environment: AS/400,SQL Embedded/Dynamic , Free-Format, ILE, SQL/400, RPG/400, CL/400, DB2/400, Query/400, DBU/60,Lotus Notes, using I-Series V5R4 WDSC 7.0, i series

Confidential

Programmer Analyst:

• Facilitated Requirement gathering sessions with business users Departments like Underwriting, Premium accounting and Claims.
• Liaised with Tech lead and other team members in analyzing the system, files, programs and reports, and prepared the System Impact Analysis Document
• Extensive use of programming abilities in SQL/400, ILE, RPG/400 CL/400, QUERY/400.
• Designing the screens and menus using Screen Design Aid and Sub file programming.
• As part of Quality assurance and testing Using Report Layout Utility generate reports or generating it through programs.
• Testing every Application, Jobs and program fixes and module.
• Compare the test reports with production data to ensure the system is validated.
• Written data pulling Programs and refreshing the Environment.

Environment: AS/400,SQL Embedded/Dynamic , Free-Format, ILE, SQL/400, RPG/400, CL/400, DB2/400, Query/400, ALPLUS, STRANT, DBU/40,Lotus Notes, using I-Series V5R3 WDSC 6.0, i series

Confidential

Programmer Analyst:

• Debug/Design/Modify System Fixes and Programming,
• Modification and Creation of new ILE Programs for RF Scanner and BARCODE Printing
• Actively involved in bug fixing across the system
• Warehouse Management Custom invoices with A/R Statement Information.
• Done the modification of' Pick batch module for verifying the item description and SKU of the merchandise item matches the Pick / Unpick items
• Creating package slips, Stock reports for various locations
• Unit testing, Aggressive testing DMMS system in AS/400

Environment: AS/400,RPG/400, ILE, CL/400, DB2/400, Advanced DDS, Query/400, ALDON, WRKDBF, PFE, PDM, F, ACMS, HAWKEYE, RSF, , i-Series V5R3

Confidential

Programmer Analyst:

• Involved in Analysis and Design of the automated agent to agent selling application.
• Development of interface programs using RPG ILE and CL on IBM AS/400
• Analysis and design of CLUE display programs and screens development
• Rater and Report generation.
• Upload the data files to the system file through interfaces
• Setting up different tables defined in the system, developing complex coverage formulas involving the driver information, discounts, and surcharges.
• Developed programs in RPGIV CL/400 to interact with the tables to generate the premium for different coverage defined for policy and/or business functionality
• Production support and custom modification of the SIS 250 system that includes billing, claims, policy administration, and SRS reporting.

Environment: AS/400, RPG/400, ILERPG, CL, DB2/400, Query/400, MKS, i series

Confidential

Programmer Analyst:

• Involved in designing and developing the User interface.
• Involved in developing middle-tier components.
• Designed and developed various custom JFC/Swing components.
• Developed Help System.
• Developed a Print Interface.
• Used to document the Object design models and their interactions

Environment: JDK 1.4, JDBC 2.0, SQL Server 2000

Confidential

Responsibilities:

• Worked on the part of analysis, design development, testing
• Designing database in DB2/400.
• Designing screens in SDA and DDS.
• Programming in CL/400, RPG/400.
• Sub-File Programming

Utilities like SDA, DFU, and RLU were extensively

Environment: AS/400, RPGIII, CL/400, DB2/400, SQL/400and Query/400, i series

Confidential

Programmer Analyst:

• Involved in Analysis and Design for the front end Application
• Development of interface programs using RPG ILE and CL
• Created the interactive and batch programs
• Design of crystal reports for the clients for various outputs from the database files.
• Developed the process to generate the data for Invoices.

Environment: AS/400, RPG/400, CL/400, DB2/400,SQL/400 and Query/400, i series

Confidential

Programmer:

• Involved in designing and developing the user interface.
• Involved in developing middle-tier components.
• Designed and developed various custom JFC/Swing components across the application.
• Developed help system.
• Developed a print interface.

Environment: JAVA2.0, DHTML, JDK 1.4, JDBC 2.0, SQL