Experience Summary

I am associated with Tata Consultancy Services since May 2008 having IT experience of 6 year in Development and Production support at client location.

• My work experience pertains to NBFC, banking domain, financial services domain and Insurance.
• Involved in architecture, modelling design for data Warehouse.
• Have strong programming and analytical skill, onsite customer facing experience can handle complex situations.
• As a quick learner and possessing a strong understanding capability, open to and capable of switching to other domain or functional areas and skill set within a limited time frame.

Technical Skills

Primary Skill : ORACLE , UNIX

Data Base : Oracle 9i, 10g , 11g

Tools : Toad Data Modeler , OWB 10.2.0.1, COGNOS 8 / 10, Toad, Oracle SQL, Developer,Data Cleaning, IntelliVIEW

Confidential

Operating System : Red hat Linux 2.4.21

Databases : Oracle 11g

Tools : OWB 10.2.0.1, Toad Data Modeler , COGNOS 8 / 10, Toad, Oracle SQL Developer

Scripting Languages : Linux Script

Confidential

Operating System : Red hat Linux 2.6

Databases : Oracle 10g

Tools : Toad Data Modeler, Data Cleaning, IntelliVIEW, Oracle SQL Developer

Scripting Languages : Linux Script

Confidential

Operating System : UNIX

Databases : Oracle 10g

Tools : PVCS Version Manager , Toad, Oracle SQL Developer

Programming Language : COBOL, PL/SQL

Scripting Languages : UNIX Script

Projects/Assignments - I

Confidential

Role : Team Leader

Description: Confidential is a global data ware house of Xerox corporation person data mainly used for Xerox enterprise reporting and productivity applications. ADP SAP HR systems place the encrypted Inbound feeds in the file servers. We used to decrypt the Inbound feeds and loaded those date into the EPIW after performing the various transformations based on the business logic. Based on the requirement we will provide the outbound feeds to the end users of EPIW By giving access to the views build on EPIW data or SFTP the flat files generated build either views or flat files .The various applications in XEROX interacts with the EPIW to get the employee information

Responsibilities:

• Apply naming conventions
• Identify attributes
• Identify entity types
• As a data modeller, responsible for
• Developing stored procedures, Unix Shell scripts.
• Developing OWB Mappings and Process flows based on the new change requests.
• Denormalize to improve performance
• Normalize to reduce data redundancy
• Assign keys
• Apply data model patterns
• Identify relationships
• Developing SQL loader scripts to load the source data.

Hardware : IBM Server

Operating System : Red hat Linux 2.4.21

Languages : Shell Scripting, Oracle 11g,

Special Software : Toad Data Modeler, Oracle PL/SQL Developer, OWB 10.2.0.1, COGNOS 8

Projects/Assignments - II

Customer : IRDA, GIC

The initiative of Insurance Information Bureau IIB aligns with the vision mission of the GIC and IRDA. The IIB will serve all lines of business like Fire, Engineering, Health, Industrial Risks etc. The IIB aims to achieve following objectives spanning the socio-economic spectrum of non-life insurance sector:-

• Insurance Regulatory and Development Authority IRDA , which is constituted by act of parliament performs the duty to regulate, promote and ensure orderly growth of the insurance and re-insurance business in India.
• The Council is an Industry body constituted as per provisions of Insurance Act to represent the interests of all non-life insurance companies in India. The council is funded by equal contribution from its members - Non-life insurance companies licensed by IRDA to operate in.
• Enable efficient underwriting of the policies. This can be achieved by providing details on the claims history to the insurer.
• Aid in prevention of uninsured driving. This can be achieved by deploying recognition algorithms to identify suspect vehicles from the databases received from the insurers and making the information accessible to the law enforcement agencies like Police, RTA.
• Aid in prevention of automobile theft. This can be similarly achieved by deploying recognition algorithm and making the information accessible to insurers and law enforcement agencies.
• Aid in fight against fraudulent claims. The insurance information bureau can provide a one-stop facility to enquire about the insurance status of a vehicle. MIS would be provided for other lines of business that will help law enforcement agencies to detect fraudulent cases.

Responsibilities:

• Interact with Business Owners.
• Preparation of Technical design document
• Involved in Data Modeling Conceptual Logical Physical
• Extraction and loading of historical data.
• Automation of Data Cleaning Linux scripting .
• PL/SQL Programming.

Projects/Assignments - III

Customer : Tata Capital Ltd TCL

Description:, Worked at the client site with close interaction with client regarding solving the production issues, running EOD in production environment and promotion of components to production region.

Responsibilities:

• Running EOD in production and UAT environment.
• Automation of code promotion process.
• Store procedure writing.
• Writing Oracle Store procedure.
• Environment setup UAT,Replica
• Code promotion in production environment and provide post production support.
• Lead some modules ALM, Bill Discounting, Trade Finance , configure environment for the same and to provide support during UAT.