TECHNICAL SKILLS

SUMMARY:

Confidential has 160 months of experience in Information Technology. As part of his assignments, he has been in Application Maintenance, Development, Testing, Proposals, planning, Estimations and Design. He has worked on projects for clients such as Confidential Experian, First data merchant service. He has strong exposure to Mainframe based applications and has gathered valuable experience in all the lifecycle stages of a standard software development. He possesses excellent analytical, communication, presentation and team work skills.

OTHER SOFTWARE COURSES/CERTIFICATION COMPLETED THROUGH COGNIZANT ACADEMY:

PROJECT PROFILE:

PROJECT DESCRIPTION:

Lowe's has launched a repair service strategy that controls and actively manages the repair process As part of this Siebel Call Center was enhanced in order to support OPE BOR Balance of Repairs products along with Major appliances. As part of the Data Integration project, the following integrations were built for Siebel:

Product

OEM Vendor

Warranty

Claims Payments

Service Providers

EPP

Asset Purchase History

• Scheduled processes were built to provide the feed to Siebel staging environment from source systems so that these feeds are consumed by Siebel and loaded into Siebel base tables.
• The mission is to improve core EPP / RP retail selling, Case Management and Repairs Appointment Scheduling capabilities by expanding the Store POS system to sell Lowe's administered EPP's / RP's and the Siebel CRM application to include support for OPE and the balance of the serviceable products including products eligible for Replacement Plan coverage BOR for residential and / or commercial customers.
• In R6 EPP Asset Purchase history projects, the Asset Purchase history database which holds historical assets and EPP information have been enhanced to support the Move the Line MTL initiative which is aimed at decoupling the payment authorization and fulfillment process and moving the settlement to the point of fulfillment. With this, EPPs would be activated when item is fulfilled and also it supports the Bundle EPP sales.

CLIENT DESCRIPTION:

Confidential

Confidential-based chain of retail home improvement and appliance stores. Founded in 1946 in North Wilkesboro, North Carolina, the chain now serves more than 14 million customers a week in its 1,710 stores in the United States and 20 in Canada. It has also expanded into Canada in 2007. Lowe's started the construction of two stores in the Mexican city of Monterrey officially entering the Mexican market in 2011, Lowe's released plans to build over 150 stores in Australia over the coming 5 years, hoping to compete with the AUD 46 billion industry. Lowe's Companies, Inc. is 43 on the Fortune 500 list.

The chain is based in Confidential is the second-largest hardware chain in the U.S. behind The Home Depot and ahead of Menards. Globally, Lowe's is also the second-largest hardware chain, again behind The Home Depot and ahead of the European stores B Q and OBI.

ROLES AND RESPONSIBILITIES IN THE PROJECT:

Confidential is onsite manager and engages in understanding the requirements from Business User, developing Functional Specification document and assist the offshore team to prepare the Technical specs, Build and provide SIT , UAT Deployment support. He has been the team lead of 2 successful large size projects with Lowe's These projects were extremely complex in nature and involved multiple integrations where each integration is developed by a separate vendor. Co-coordinating with vendors and working together with them to meet the project goals and objectives are one of the most challenging tasks. In addition to his day to day tasks, Saikat also helped the offshore team to come up with detailed design document, code Test results review etc. His in-depth domain knowledge coupled with sound technical knowledge in mainframe area helps him to understand the complex business requirements clearly and design technical solution around it. He also studies the system and suggest ways to remove manual intervention in Business processes.

He also estimates the task and plan the work so that the team can assume task within its capacity. During the course of the project Saikat also capture effort, schedule defect metrics to track the health of the project and participates in delivery quality audits to ensure compliance.

TECHNOLOGIES USED IN THIS PROJECT:

COBOL, JCL, DB2, VSAM, Teradata

EXPERIENCE IN THE TECHNOLOGIES USED:

COBOL : 139 Months

JCL : 126 Months

DB2 : 88 Months

VSAM : 95 Months

Teradata : 10 Months

DURATION OF THE PROJECT:

22 Months

PROJECT DESCRIPTION:

• The Small Project Request System in the Corporate Benefit Funding area of MetLife Institutional Business has several applications. The Pension Closeout Tracking System PCTS is the administrative system for Annuity Contracts. Its primary functionality includes maintaining individual participant eligibility record, calculating benefits, Retirement Death processing to feed the repetitive payment system and providing the data for reserve calculation.
• The Group Payment System GPAY is a payout system for annuity and pension business. It processes the payments at individual level and tracks the payment details, takes care of accounting, Tax processing Regulatory mailing.
• PCTS GPAY supports two types of contracts
• IPG Immediate participant group - In this contract the employees can be added at any point of time and the period may change. The premium charges, expenses, etc. are calculated at different time frames, say monthly/quarterly/annually. MetLife is not liable to pay the annuitants if the company goes bank corrupt.
• Closeout contract - Once the contract is established it is frozen. No changes can be made to contract. Employees cannot be added to the contract and the period is well defined. Advantage of Closeout contract is that MetLife is liable to pay some percentage of annuities to the annuitants even if the employer goes bank corrupt.
• The project scope is take care of small enhancements like to load new deferred contracts in PCTS, commence payment in either Bulk Check or Group Payment system during retirement processing, one time issuance of Bonus for certain groups, yearly Cost of Living Allowance processing, enhancements on Year-end Tax Calculation, Tax Form creation and Privacy Mailing generation.

CLIENT DESCRIPTION:

Confidential

• MetLife Metropolitan Life Insurance Company based in US is a 140-year-old company and has its presence in 12 countries across the globe. It is the nation's largest life insurance company with approximately 1.7 trillion of life insurance in force. MetLife provides individual insurance, annuities and investment products to approximately nine million households, or one of every 11 U.S. households.
• MetLife looks forward in increasing its policyholders from the current 43 million to 100 million in 10 years and to expand the individual channels through Banks, Brokers and to reduce the non-agent workforce by 5 . In order to achieve this goal and to serve its customers better and grow its business, MetLife has outsourced number of its application systems to Cognizant for better management and maintenance of the systems.
• In 2001 MetLife was the first insurance company to establish a financial holding company with a nationally chartered bank. Leveraging its unparalleled distribution channels, MetLife entered the retail-banking arena with the launch of MetLife Bank. This will make an easier and more convenient way for MetLife's customers to realize their financial goals.
• MetLife has developed and implemented a secure online enrollment system that have integrated with a customer's existing web-based benefits application, as well as allow for future functionality, such as employee self-service. This helps MetLife in Institutional Business to improve the customer experience, Reduce processing costs, Enhance service capabilities for plan sponsors, Increase operating earnings, Implement cutting-edge technology, Enrich and energize MetLife employees.
• Headquartered in Confidential and its affiliates offer a full range of insurance and other financial products and services. In addition to life, non-medical health and property and casualty insurance, MetLife is a leader in savings and retirement products and services for individuals, small businesses and large institutions. MetLife is the largest life insurer in terms of life insurance in-force in North America, and offers financial products and services to 88 of the Fortune 100SM companies.
• Confidential is a major force in financial services: asset management, investments, financial advice, banking and insurance. With more than 46,000 employees and over 32 billion in operating revenue, MetLife is the largest life insurer, with over 2 trillion in life insurance in force as of December 31, 2001. MetLife stands behind its mission to build financial freedom for everyone by offering a variety of products and services to individuals and employers. MetLife's goal is to have over 100 million customers by 2010.

ROLES AND RESPONSIBILITIES IN THE PROJECT:

• Confidential is onsite functional lead and responsible for understanding the requirements from Business User, developing Functional Requirement document and assist the offshore team to prepare the Technical specs, Build and provide QA , UAT Deployment support. Once Business raises a new requirement , he always ensure to understand in details all the functionalities behind the requirement and helps the offshore team to translate it intro technical design document. His in-depth domain knowledge coupled with sound technical knowledge in mainframe area helps him to understand the complex business requirements clearly and design technical solution around it. He also studies the system and suggest ways to remove manual intervention in Business processes which results in substantial cost savings.
• He also estimates the task and plan the work so that the team can assume task within its capacity. During the course of the project Saikat also capture effort, schedule defect metrics to track the health of the project and participates in delivery quality audits to ensure compliance.
• Apart from the project related activities he was also involved in business development Whenever there is a new RFP in CBF area, Saikat is involved in estimation, profitability , timeline and also the solution of the client requirement.

TECHNOLOGIES USED IN THIS PROJECT:

COBOL, CICS, JCL, DB2, VSAM

EXPERIENCE IN THE TECHNOLOGIES USED:

COBOL : 117 Months

JCL : 104 Months

CICS :30 Months

DB2 : 66 Months

VSAM : 73 Months

DURATION OF THE PROJECT:

15 Months

PROJECT PROFILE:

PROJECT DESCRIPTION:

The VANTAGE-ONE Repetitive Payment System RPS provides automatic calculation and preparation of repetitive payments that become due under fixed and variable annuity contracts and supplemental contracts. RPS supports all forms of annuity payments. The system also provides for the varied and complex payment administration of structured settlements. Once an annuitant and one or more payees are established on the database, the payments due on the contract are under control of RPS. Payments are made according to parameters contained on benefit segment records which are subsidiary to the annuitant record, or to parameters on the Annuitant Record in the case of interest only, fixed payment, life expectancy or trust options.

It has a CICS based online system that is used for both financial and non-financial updates and inquiries.

CLIENT DESCRIPTION:

Confidential

• MetLife Metropolitan Life Insurance Company based in US is a 140-year-old company and has its presence in 12 countries across the globe. It is the nation's largest life insurance company with approximately 1.7 trillion of life insurance in force. MetLife provides individual insurance, annuities and investment products to approximately nine million households, or one of every 11 U.S. households.
• MetLife looks forward in increasing its policyholders from the current 43 million to 100 million in 10 years and to expand the individual channels through Banks, Brokers and to reduce the non-agent workforce by 5 . In order to achieve this goal and to serve its customers better and grow its business, MetLife has outsourced number of its application systems to Cognizant for better management and maintenance of the systems.
• In 2001 MetLife was the first insurance company to establish a financial holding company with a nationally chartered bank. Leveraging its unparalleled distribution channels, MetLife entered the retail-banking arena with the launch of MetLife Bank. This will make an easier and more convenient way for MetLife's customers to realize their financial goals.
• MetLife has developed and implemented a secure online enrollment system that have integrated with a customer's existing web-based benefits application, as well as allow for future functionality, such as employee self-service. This helps MetLife in Institutional Business to improve the customer experience, Reduce processing costs, Enhance service capabilities for plan sponsors, Increase operating earnings, Implement cutting-edge technology, Enrich and energize MetLife employees.
• Headquartered in New York, MetLife and its affiliates offer a full range of insurance and other financial products and services. In addition to life, non-medical health and property and casualty insurance, MetLife is a leader in savings and retirement products and services for individuals, small businesses and large institutions. MetLife is the largest life insurer in terms of life insurance in-force in North America, and offers financial products and services to 88 of the Fortune 100SM companies.
• Today, MetLife is a major force in financial services: asset management, investments, financial advice, banking and insurance. With more than 46,000 employees and over 32 billion in operating revenue, MetLife is the largest life insurer, with over 2 trillion in life insurance in force as of December 31, 2001. MetLife stands behind its mission to build financial freedom for everyone by offering a variety of products and services to individuals and employers. MetLife's goal is to have over 100 million customers by 2010.

ROLES AND RESPONSIBILITIES IN THE PROJECT:

Saikat was offshore project Leader and responsible for the understanding the business functionality for Compensation calculation, developing technical specifications and impact analysis based on same. He was involved in preparing project plan, co-coordinating resources to meet objectives. He is also involved in Developing code, reviewing the test results of other team members, delivering the task to onsite, preparing project status report and communicating same to onsite. He was also involved in quality related activities like Metrics preparation, audit and review Apart from the project related activities he was also involved in business development Whenever there is a new RFP in CBF area, Saikat is involved in estimation, profitability , timeline and also the solution of the client requirement.

TECHNOLOGIES USED IN THIS PROJECT:

COBOL, JCL, DB2, VSAM

EXPERIENCE IN THE TECHNOLOGIES USED:

COBOL : 103 Months

JCL : 90 Months

DB2 : 58 Months

VSAM : 51 Months