Company: Accenture Services Pvt. Ltd., India

Role: Programmer / Senior Programmer (Java, Oracle)

Re-engineered Credit Risk systems at a global investment bank, developed Subrogation Placement System for a US-based insurance firm, maintained Oracle e-Business Suite for a Denmark based telecom firm.

Experience in Detail

1. Oracle ERP – Maintenance of Order Management System

 Description: The client is a leading telecommunications network operator in Denmark. The company provides wireless, domestic local and long-distance landline, international, Internet, and cable television services to about 12 million consumer and commercial customers.

This is majorly an application maintenance project with some major and minor enhancements. This project uses Oracle applications, Oracle core and Core Java for building the application and for handling various processes involved. The entire Order Management cycle (Oracle Applications) is dealt with in the various modules of this project.

• Analyzed the existing system and recommended major enhancements to improve the application.
• Developed Use-Cases, Class Diagrams and Sequence Diagrams using UML.
• Developed re-usable tools for the project using JDBC.
• Have done coding using Core Java and JDBC.
• Developed Oracle Stored procedures and packages using TOAD.
• Developed Test Cases and performed application testing for the developed modules. 

2. Subrogation Outsourcing Placement System

Description: Subrogation refers to an insurance company seeking reimbursement from the person or entity legally responsible for an accident after the insurer has paid out money on behalf of its insured. When a subrogation claim is made it is assigned to vendors. As part of this project, we developed the application providing the user various functionalities like Searching Claims, Assigning Claims, Creating claims, Searching Vendors, Managing Performance of Vendors, etc.

• Developed Use-Cases, Class Diagrams and Sequence Diagrams using UML.
  Implemented the application using Struts Framework based on Model View Controller design pattern.
• Used Hibernate as Object Relational mapping framework for data persistence and retrieval.
• Used JSP and HTML in developing the user interface; used Struts custom tag libraries for creating some complex web pages.
• Used Javascript for front end validations.
• Used Log4J for logging, monitored the logs and fixed the problems.
• Used Struts Action classes and regular Java Classes to develop the middleware.
• Involved in code reviews, guiding new resources and training them.
• Developed some Java tools using JDBC and Hibernate to make modifications to the records in the database and for generating some data reports.
• Involved in the development of Oracle stored procedures using IBM DB2 Control Center and IBM Developer Workbench.
• Involved in Unit, Integration and System Testing.
• Provided post-production support and was solely responsible for the entire project;
• Analyzed and provided estimates for different enhancements.

3. Credit Risk Batch Re-engineering

Description: The project dealt with the re-engineering of end of day jobs in a particular framework (one of three frameworks) developed and defined for the client system. There is one database (in a location New York) which is linked to three servers residing in New York, London and Tokyo. At the end of each day, the data from the main Oracle database is passed to local SQL servers via informatica. The project mainly dealt with the modification of existing jobs and creation of new, more efficient jobs for the completion of above process.

I was involved in the analysis of the earlier process, design, development, authoring and creation of autosys jobs for automation of these processes.

Responsibilities:

• Analyzed the existing Crontab
• Created new JIL (Job Information Language) scripts for the above Cron jobs.
• Analyzed the commands used for manual run.
• Created shell scripts for the different replication types (three in number).
• Created Autosys-scheduled jobs for the Replication processes.
• Authored a java tool, using JExcel API for generating a JIL script from the details in an excel sheet.
• Created tables and Oracle stored procedures for the initiation of replication processes and cyclic definitions of data. These automate the entire replication process.
• Created test scripts for the automated replication processes; documented the test results.

4. Oracle Configurator – Oracle Applications

Description: Oracle Configurator provides interactive configuration and batch validation for sales, manufacturing and service applications. In the project, the work was done in monthly releases. For every release, a set of RDs (Requirement Documents) were taken up and worked upon. Every release was divided into five phases – analysis, design, development, testing and delivery.

 

Responsibilities:

• Analyzed the Request Documents.
• Created the Technical Design documents.
• Worked on various enhancements in the application using Oracle Configurator.
• Created Configurator Extension rules using Java files.
• Analyzed the already existing Java classes, fixed defects in them and documented the various processes involved.
• Worked on TOAD for running SQL queries to check the existence of BOMs and to retrieve model details.