Madhu Venkata Ramakrishna Janjanam

I successfully designed, developed, and implemented EIDR registration from 21st Century Fox's Salesforce organization to EIDR for the registration of movies, web series, TV shows according to International rules and technical standards using REST API callouts with XML request data and an XML response.

I developed the integration between Sage CRM and Salesforce CRM using a Salesforce REST service against a C#.NET custom REST API along with a configuration tool for the users to map between each column of Sage tables to each field of Salesforce objects.

After finishing the configuration, the synchronizations starts with inserting, deleting, and updating the data against each system.

Farmers Insurance Group (informally Farmers) is an American insurer group of automobiles, homes, and small businesses and also provides other insurance and financial services products.

Using the internet and direct response marketing channels, 21st Century markets personal auto insurance to consumers throughout the United States. The 21st Century Insurance companies are subsidiaries of the Farmers Exchanges.

Products and services include:
• Auto insurance
• Home insurance, including homeowners, condominium and renters insurance, mobile and manufactured home insurance, specialty home insurance, including landlord and rental properties, seasonal homes, and vacation homes, and flood insurance through the National Flood Insurance Program
• Motorcycle insurance
• Life insurance, including term, whole, and universal life insurance
• Recreational insurance, such as insurance for boats, ATVs, RVs, and travel trailers
• Business insurance for small and medium-sized businesses, such as liability and property insurance, commercial auto and workers compensation insurance
• Financial services and products, such as mutual funds and variable annuities

RPL (Renault programming language) is the conversion based project from RPL to COBOL. A REFINE tool which will convert all RPL programs to COBOL programs. Based on the tool's accuracy, we will have to fix the code accordingly. A cataloging team will decide which programs which need to be translated into COBOL. The testing team will test the converted programs; if there are any errors, the debugging team will change the code accordingly.

This project aimed to compare the COBOL, OS (obtained situation), and RPL, ES (expected situation). The process will continue for several iterations using modified versions of the tool until these OS and ES result in a zero difference. The tools will be adjusted based on the error tickets raised either by the cataloging
team or the testing team or the debugging team. On the other hand, the debugging team can fix the code and compare OS and ES until the result is the same.

The purpose of this project is to support the replacement of Manheim's auction vehicle inspection vendor (AIM) and allow Manheim to perform vehicle inspections and transmit inspection data directly to NNA and NMAC by March 25, 2011. In effect, eliminating the "middle-man" (AIM) for auction vehicle inspections and simplifying
the condition report (CR) processing.

Work flow:
01. Set up a process to get the inspection file from the vendor.
02. Created tables to map Manheim damage codes to Nissan damage codes.
03. Converted the inspection file from the vendor to the existing inspection record format.
04. Translated the Manheim damage codes to Nissan damage codes.
05. Performed a one-time data conversion of the above, e.g., the grade of 3 would be converted to 30.
06. Modified ISMM to show the expanded grade (a grade of 32 would be shown as 3.2 on the screen).
07. Created a maintenance screen to display/edit and compute the values.

Here is the description of a straightforward project, and there are many other projects which I had implemented successfully from 2005 to 2008.