Mohan Rangam Email & Phone Number

Chennai, Tn, In

Chennai, Tamil Nadu

Description: Insurance Integrated Platform (IIP) is an Insurance based application in which users can apply for claims, new policies and thereby they can view the status of their claims and policies. Roles and Responsibilities: • Providing support to load claims and policy to the application.• Involved in analyzing the existing process flow, so as to accommodate the new changes that are described in the process• Developed ETL job to generate report in .csv file in name of… Show more Description: Insurance Integrated Platform (IIP) is an Insurance based application in which users can apply for claims, new policies and thereby they can view the status of their claims and policies. Roles and Responsibilities: • Providing support to load claims and policy to the application.• Involved in analyzing the existing process flow, so as to accommodate the new changes that are described in the process• Developed ETL job to generate report in .csv file in name of the client.• Involved in Data analysis with respect to out of balance records, so that we can re-pull those claims from respective database.• Developed ETL job to identify the rejected records with error description for Business Analyst.• Enhanced a mapping to allow particular endorsement code, which is previously disabled.• Involved in scheduling the jobs using Lotus Notes in autosys. Show less

Chennai, Tamil Nadu

US Standard for Rehabilitation requires accessible contents for web products, services, online tools, and websites. I have 2+ years of experience in Lumina Datamatics, with one year as freelancer and one year, two months as full time employee.

My responsibilities are to process the customer data into the application for clients review and handle the clients requests.

Bangalore

Aggregate Spend 360 - April 2015 to September 2016Description : Aggregate Spend is the process used in the USA to aggregate and monitor total amount spent by healthcare manufacturers on individual healthcare professionals and organizations (HCP/O) through payments, gifts, travel and other means.Responsibilities• Active participation in performing data loading for the client within SLA.• Interaction with the partners , respective to their requests, load the… Show more Aggregate Spend 360 - April 2015 to September 2016Description : Aggregate Spend is the process used in the USA to aggregate and monitor total amount spent by healthcare manufacturers on individual healthcare professionals and organizations (HCP/O) through payments, gifts, travel and other means.Responsibilities• Active participation in performing data loading for the client within SLA.• Interaction with the partners , respective to their requests, load the data accordingly.• Handle the issues with respective to the client request.• Analyzed the Source and Target databases to understand the business logic.• Import the data using Golden Benthic 6 from flat files in other formats such as .dsv,.imp• Involved in generating Quarterly business report and handle End to End process. Show less

Chennai Area, India

Global Integrated Music Mart - February 2014 to March 2015Description :This project deals with various musical products selling by various online or offline shopping like AMAZON, YOUTUBE, APPLE, etc. It is having various types of accounts such as Digital, physical, Spotify and Streams. It is maintaining incremental load of sales data on daily basis. The partners will be posting the sales data as flat files into FTP server and Perl script is used to consolidate the files… Show more Global Integrated Music Mart - February 2014 to March 2015Description :This project deals with various musical products selling by various online or offline shopping like AMAZON, YOUTUBE, APPLE, etc. It is having various types of accounts such as Digital, physical, Spotify and Streams. It is maintaining incremental load of sales data on daily basis. The partners will be posting the sales data as flat files into FTP server and Perl script is used to consolidate the files based on Subject_Area_ID and Feed_ID, then loading these informations into table using Informatica tool..Responsibilities• Development of PL/SQL procedures to Load MS SQL data base• Identification and debugging of the errors while loading data into target.• Active participation in Unit testing.• Congruence with the process of data validation.• Interaction with the partners regarding their requirements and load requests as per their comforts for data.• Activity of scheduling Workflow and preparing the CTRL-M DOC Show less