Christy Jain

Skilled in data warehousing tools, data mapping, unit testing, migration, and process documentation. Highly efficient associate well established in fast-paced and challenging environments. Eager to learn with aptitude for applying new knowledge with skill and efficiency.

• Project #1Domain:- Insurance
• Standard Insurance is currently using SunGard Omni Plus v5.55 for their Retirement Service record keeping purpose. Each and every transaction related to retirement products are stored in OMNIPLUS application. OMNICCW is a subsystem under the OMNIPLUS which manages check writing, pension disbursement and tax-reporting activities. The OMNI CCW System processes the payment file (RS06), other control files (flat files and VSAM files) and creates check write files daily. Standard has embarked on an initiative to upgrade the Omni Plus application from v5.55 to v6.05 and has selected Cognizant to perform the upgrade. Omni plus V6.05 is a web based application consisting of a series of comprehensive, interactive web applications designed to provide retirement plan and account management capabilities to participants, plan sponsors and call centre representatives. As part of this initiative Standard is looking to retire its existing Omni CCW application and replace it with an ETL based process for generation of downstream data feeds and reports to achieve operational benefits. Roles & Responsibilities Designied Datastage jobs. Devoloped SQL queries to perform DDL,DML and DCL. Create Data stage Sequencers to run Batch jobs. Involved in the code fix. Support during SIT and UAT. Create documents for Knowledge Transfer. Met tight deadlines and delivered quality deliverables. Used the transformations like Lookup, Filter, Aggregator, Transformer, Merge and Change capture in the development of data stage jobs. Used Data Stage Director for scheduling, validating, running and monitoring the jobs. Applied multiple lookups using lookup file set. Performed various activities like import and export of Data Stage Projects. Involved in modification and enhancement of the Application. Controlled jobs execution using sequencer, used notification activity to send email alerts. Participated in the requirement gathering sessions with client managers and onsite leads.
• Project #2 Domain :-Travel & Hospitality
• Project Description: MGM Resorts and hotel management we develop Datastage jobs and Azure pipeline to process the data we receive from different sources such as files,Teradata and Oracle tables.Used Automic for scheduling the jobs and Devops tool for migrating azure objects. Roles and Responsibilities Part of both development and support team created datastage jobs and monitored azure pipelines. Building pipelines to copy data from source to target in Azure data factory. Transforming data in azure data factory with ADF transformations. Extensively used Datastage designer and Teradata to build the ETL process which pulls data from different sources. Closely monitor jobs and handled failures within SLA. Closely worked with offshore and Business people to resolve critical issues. Managed documents in share point. Prepared documents for each modules for the knowledge handover. Domain
• Project #3 Domain :- Insurance
• Brokerage Production Support is a long term support project intended for the support of the Brokerage business of the client in Onsite/Offshore model which includes the support of both business & related batch processes Roles and Responsibilities: Provide support across multiple LOBs within brokerage and Managed accounts. Ensure that the business criticality of the applications is understood & resolve issues within the timelines defined. Incident & request handling. Ensure high availability (Close to 100%) for all brokerage applications. Understand the business for all brokerage related projects being developed within the firm for quick transition of these into support mode. Proper documentation of all major incidents, production failures & fixes, business & process flows etc. to avoid key person risks. Domain
• Project #4 Domain:- Travel & Hospitality
• A UK based client providing their services mainly to the travel industry. It is a Travelport group organization, one of the largest wholesalers of hotels, ground products and services to the Travel industry. Client is a business-to-business brand that sources and distributes hotels, apartments and a full spectrum of non-air travel products including car hire, rail, sightseeing tours and transfers to some of the biggest travel wholesalers and retailers in the world. Main two layers in the project - Enterprise and Presentation layers. Enterprise layer is an Entity Relationship Model, which will hold Booking and Allotment information. Presentation Layer is a dimensional model, which holds Allotment, Booking and Financial information of Client. Data mapping is done using OWB which is the ETL tool provided by Oracle. Reporting is done using Cognos. Data from the enterprise layer is loaded to presentation layer which uses a dimensional data model. Roles and Responsibilities Created documents on different modules of project. Analyzed Business Requirements and involved in analysis,development and testing of various tickets. To have good knowledge about the modules and their process flow. Developed SQL scripts for testing of various modules. Handled high priority tickets. Production support. Created stored procedures, functions and test queries for various tickets. Involved in various code fix and job monitoring. Take reviewing responsibility and delivered tasks with zero defects.
• Project #5 Domain:-Insurance
• Life Information Factory(LIF) is a technology platform,data management structure and governance process that will provide efficient access to consistent and accurate Life Data.LIF will be the common source of data for Connext ,downstream actuarial systems,sales reporting and financial reporting. Roles and Responsibilities Ensure that the business criticality of the applications is understood & resolve issues within the timelines defined. Incident & request handling. Experience in creating mappings in TALEND using tMap, tJoin, tflowtoIterate, tAggregate, tSortRow, tFlowMeter, tRowGenerator etc. Used Talend Administratin Centre(TAC) for monitoring the scheduled jobs and provided batch support.