Ramkumar Narayanan Email & Phone Number

Duration: Apr’12 – Jul’12Team Size: 2Environment: Windows NT, Informatica, SQL server database; Fresh Start initiative will include the design of the existing primary processes from a Reinsurance Data Warehouse perspective, and all changes required to support Fresh Start. The existing code contains many hard-coded references and values that only pertain to.

Environment: Windows NT, Informatica, SQL server database; Financial Data Mart (FDM) This process will provide balance sheet values based on corporate and US GAAP rules to be applied to the FDM for analytical purposes and as reconciliation to other systems within XL (e.g. Peoplesoft) The Financial Data Mart (FDM) is currently an Income Sheet representation.

Key Deliverables: Responsible for gathering and analyzing requirements along with activities like developing, coding and unit testingResponsible for analyzing, defining and documenting requirements for data, workflow, logical processes and operating system environmentInstrumental in writing and maintaining technical specifications based on end-user.

1. Profound experience in using SQL Server, Teradata, Oracle & Informatica and integration of various data sources like teradata and Flat files into the Staging Area and scheduling of UNIX batch run using Autosys2. Responsible for gathering and analyzing requirements along with activities like developing, coding and unit testing

Environment: Windows NT, Informatica, SQL server database; Analysed existing Underwriting data mart and tuned informatica mappings and SQL queries.Key Deliverables:Planned and managed daily meetings with the team and in status call with the onsite team on meeting the requirements. Used the advanced performance tuning methods in all the ETL mappings which.

Duration: Mar’11 – Dec’11Team Size: 2Environment: Windows NT, Informatica, Oracle, Teradata database; PayPal Segmentation Platform (PSP) is an initiative to make customer segments and properties available in Site database that can be used to target real-time marketing. This will enable PayPal to create and launch marketing campaigns on the fly based on.

Duration: Jun’10 – Feb’11Team Size: 2Environment: Windows NT, Informatica, Oracle, Teradata database; This project was to support value and segmentation logic that has been built for customers based on some finite set of variables as part of the development of the aggregated single customer view. They are based on behaviour summarized across the most.

Duration: Nov’09 – May’10Team Size: 1Environment: Windows NT, Informatica, Oracle, Teradata database; Personalization Data Service (PDS) system has been developed to serve Ads (IM and Paid Search) real-time based on User Information available in the form of cookies. This project addresses the need of communicating with customers with relevant messages.

Windows NT, Oracle 9i database, Informatica Power Center 8.1, Autosys; Universal auto product expands across distribution channels allowing growing beyond current direct AARP channel. This strategy targets additional growth across larger population of direct to customer and AARP membership in 16 additional states. This maximizes the greatest AARP.

Windows NT, Oracle 9i database, Informatica Power Center 8.1, Autosys; Corporate Asset Protection (CAP) group would like to model and analyze risk for Natural Perils like Hurricane, Earthquake, Flood, Winter Storm etc., for in-force insurance policies. This project ensures the policy data needed to model and analyze Natural Perils; exposures are available.

Windows NT, Oracle 9i database, Informatica Power Center 8.1, Informatica Power Exchange; The data is migrated from Winterthur Insurance Company to AXA in two different domains - Retail Life and Retail Non Life. Numerous applications were present in Winterthur systems and the data needed to be migrated to numerous systems in AXA. The project involves.

Team Size: 7Environment: Windows NT, Oracle 9i database, Informatica Power Center 8.1, Informatica Power Exchange; AXA acquired Winterthur Insurance Company in Europe. In Belgium, AXA decided to shutdown all the Winterthur applications, migrate the policy and claim data to AXA System and then service them from AXA System. The project involves migration of.

Key Deliverables:Analyzed clients’ requirements and interacted with them to provide post implementation supportResolved and troubleshot all client related issues along with handling escalations raised by them; FDM Balance Sheet Revaluation and Translation

Mca, Computer Applications

B Sc, Information Technology