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 the two companies. As part of the Fresh Start initiative, changes must be made to the existing code to allow for the rapid deployment of new companies to the Primary Repository and allow this data to be processed through the Data Warehouse.Key Deliverables:Planned and managed daily meetings with the team and in status call with the onsite team on meeting the requirements. Played a leading role in developing the mappings.Implemented the business needs technically by coding the required business logic in ETL mappings and developed executable workflows for the same with high performanceInvolved in creating and executing Test Case; delivered the project within agreed time frames; UDM Performance Tuning

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 of Reinsurance financials available to users with access to it and the Reinsurance Data Warehouse (RDW). As an income statement, the treatment of its financial amounts have, to date, used US GAAP based accounting rules for calculation of functional (base) currency and corporate (USD) currency amounts. Processes currently exist to book transactions into the FDM based on US GAAP rules, and, on a monthly / quarterly basis, apply an Income Statement Revaluation (Original Currency to Functional currency) and Translation (Functional currency to Corporate currency).Key Deliverables:Planned and managed daily meetings with the team and in status call with the onsite team on meeting the requirements. Played a leading role in developing the mappings.Implemented the business needs technically by coding the required business logic in ETL mappings and developed executable workflows for the same with high performanceInvolved in creating and executing Test Case; delivered the project within agreed time frames; FDM Enhancement

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 requirementsResponsible for developing programs and enhancements based on agreed SLAsAccountable for performing analysis, design, modification testing and maintenance of data warehouseKey role in writing moderate to complex design specifications along with suggesting innovative changes in data warehouse.Responsible for preparing Test cases along with Integration and User Acceptance Testing Instrumental in mentoring the team in building a complete deliverable product by integrating various portions created during the development cycleResponsible for interacting with customers for feedback and troubleshooting / resolving all issues and queries ensuring utmost quality serviceAchievements: Successfully tuned various mappings using Informatica thereby improving performanceEfficiently tuned numerous SQL Queries

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 resulted high load in less time.Involved in creating and executing Test Case; delivered the project within agreed time frames; PayPal Segmentation Platform

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 rules developed using a wide variety of customer segments which would be made available on-site. This will also be used by other cross functional teams including FMX, Customer Service, Risk, etcKey Deliverables:Involved in all phases of the life cycle and high and low level designsUsed Teradata to build Data Warehouse and scheduled DW jobs using UC4Involved in creating and executing Test Case; delivered the project within agreed time frames; Customer Segmentation

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 recent twelve months. The analysis undertaken by this project was to develop Value and engagement segmentations for our clients - UK – Twelve Segments, France - Ten Segments, Italy – Eleven Segments.Key Deliverables:Involved in all phases of the life cycle and high and low level designsUsed Teradata to build Data Warehouse and scheduled DW jobs using UC4Involved in creating and executing Test Case; delivered the project within agreed time frames; Personalized Data Service

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 based on the user information known to the system at the time of serving an advertisement. There exists a need for our project (PDS view creation) to share key customer information to PDS to ensure appropriate targeting marketing. Key Deliverables:Same as in the above project; Universal Auto

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 membership for agents and growth in the direct channel. Key Deliverables:Involved in high / low level designs, creating and executing test casesUsed Informatica as ETL tool for building the Data Warehouse and scheduled jobs using Autosys and ensured delivery of the project within specified time lines; Natural Perils

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 in the Catastrophe Data Facility (CDF DQ) datamart. This project will:Increase the number of data sources currently contributing to the datamartExpand the datamart to include data elements related to Natural PerilsProvide clean and accessible data to perform more accurate risk evaluationCentralize Enterprise data source for exposure analysisBusiness segments include, Workers Compensation, Auto, Homeowners, Fire Dwelling etc.Key Deliverables:Same as mentioned aboveInvolved in all the phases of the life cycle of this project; AXA-WEA Data Migration (Retail Non Life)

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 migration using Informatica based on flat files and mapping rules from AXA.; AXA-WEA Data Migration (Corporate Non Life)

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 data in two different domains - Corporate Life and Corporate Non Life. Numerous applications were present in Winterthur systems and the data needed to be migrated to numerous systems in AXA. Source applications used different databases like Oracle, DB2 etc., and target applications used DB2. The project involves migration using Informatica based on flat files and mapping rules from AXA.Key Deliverables:Same as mentioned abovePerformed performance tuning using InformaticaKey Deliverables:Same as mentioned above

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