patelpunitb

Objective: To be part of a dynamic and prolific working environment, this provides the opportunity to make strong contribution to organizational goals through continued development of professional skills. Professional Background: • 3+ years of professional experience in database operations. • Involved in complete Software development life cycle. • Responsible for various database activities like creation, table space management, taking export & import of the database and performance tuning of the same. • Involved in project presentation to the onsite coordinator / client and also conducting the knowledge transferring sessions for the project. • Experience in developing projects in Oracle D2K and reports 6i with oracle 9i / 10g as backend. • One of the key member in development of Online Risk Management System for Trading member in STOCK HOLDING CORPORATION OF INDIA(client) for its clearing services. • Coach for trainees, on the fundamentals of programming and guide them in using tools like ERWIN for data Modeling and TOAD for SQL query performance monitoring. Technical Background: • Operating System : Windows XP, Working knowledge of UNIX • Languages : D2K , Reports 6i • Tools : ERWIN, TOAD, SQL NAVIGATOR. • Databases : ORACLE 9i, 10g. Educational Background: • B.E. (Electronics & Telecommunication-60%), 2003, G S Moze College of Engineering, Pune University, Pune. • Diploma (Digital Electronics-60%), 2000, Bombay Institute of Technology, Maharashtra State Board. Mumbai. • SSC (64%), 1997, S.V.P. High school, Mumbai, Maharashtra Board. Work Details: • Company Name : Cognizant Technology Solutions India Pvt. Ltd. • Duration : Aug 2006 – Till Date The ’Cognizant Technology Solutions India Pvt. Ltd.’ is the fastest growing IT company with total employee strength of 33000+ IT professionals and leading IT solution provider in Life science domain with clients like Novartis, Merck, Pfizer etc. It also have the broad client base with various verticals like BFS, Manufacturing and Logistics, Insurance etc. Projects Undertaken At Cognizant: • Project Title : Key Process Indicator – KPI • Client : Novartis - Germany • Duration : till date • Team Size : 8 • Software : Oracle 10g and tools like ERWIN and TOAD. • Scope Of Project: The project is developed for the process monitoring of complete Drug testing and reporting process by the client sites located across the world. The KPI system provides the facility to handle the entire the submission process and also to determine the root cause and necessary corrective action to avoid the late submission in future. Thus this system helps the client to improve the process. • Project Title : Clinical Data Repository - CDR • Client : Merck - USA • Duration : 2 months. • Team Size : 6 • Software : Oracle 10g and tools like ERWIN and TOAD. • Scope Of Project: The CDR project is developed for the Merck for its drug manufacturing phase III process which involves the testing of the drug on Human Beings and collecting the information from various sites located across the globe. This clinical process contains the stages like subject event reporting, loading the patient data and converting the entire information into FDA approved format and submitting the same before the timing guidelines given by the FDA. So CDR is the data repository which collects the information regarding the clinical trials on human being in different countries and thus submitting the same to FDA for the approval. So this project has very big impact the Drug production life cycle. Role/Responsibilities: Team Leader. § Responsible for gathering requirement from onsite coordinator and client and present the same to development team. § Involvement in planning and scoping of modules. § Handling complex database development and space management involved in project and also creation of data model and design specification for the same. § Also granting and monitoring the various database privileges like system level, Object level for the DB Developer as well as Java Developers. § Responsible for looking after day-to-day activities and resource management of team. § Involved in the database objects creation with strictly following the clients coding standards and testing the same. § Maintaining the version of source code with the help of version control tool like Visual Source safe. § Reporting to Project Manager for development status of Project. • Company Name : Akshay Software Technologies Pvt. Ltd. (Deputed at Client Site Stock Holding Corporation of India Limited.) • Duration : Jan 2005 - Aug 2006 SHCIL is India's largest Custodian and Depository Participant (DP). The company has always been in the forefront of quality in systems. SHCIL-IT is a SEI-CMM levels 3 company. SHCIL-IT projects are related to various Financial Market activities, covering Clearing & Settlement, Security lending, Depository & Dematerialization and various Client reporting modules. The company currently maintains a database distributed across 127 branches, and provides online connectivity to over 1000 functional users. Projects Undertaken At SHCIL: • Project Title : WebDeriv Exchange Traded Equity Derivatives • Client : Stock Holding Corporation Of India Ltd. • Duration : 12 months. • Team Size/Role : 4 / team member. • Software : D2k , Reports 6i , Oracle 9i • Scope Of Project: WEBDERIV-ED is the software for Clearing Members in Financial Equity Derivatives. The software handles Clearing of trades and Settlement of money for the Trading Members and Financial Institutions. It is also designed for Collateral Risk Management. WEBDERIV-ED is an Intranet based three-tier system wherein users from different locations can log in and perform daily activities like Settlement Processing, Collateral Management and Accounts Interface. The project covers major modules like Trade Confirmation, Settlement Processing, Collateral Risk Management. • Project Title : Online Exposure sheet and Risk Management System • Client : Stock Holding Corporation Of India Ltd. • Duration : 6 months. • Team Size/Role: 4 / team member. • Software Tools : D2k , Reports 6i , Oracle 9i • Scope Of Project: The Online Exposure sheet is all about the overall balances of the entire trading member in terms of collateral like BG, FD, Securities and Case given by the client and monitoring the each and every inflow/outflow of the same. And Risk Management system is also related to the same in the event when particular balance for the client goes below the minimum required amount. In this event system sent email to respective client informing about the shortage of Collateral and shutting down the trading terminal. Role/Responsibilities: Team Member. § Responsible for gathering requirement from user and developing the same once the requirement gets signed off by the user. § Handling the Accounting module for its audit reporting the also involved in developing the AUDIT reporting module in Reports 6i.. § Day to Day monitoring of the billing processing after the market hours and generating the reporting FILE and uploading the same to Exchange server. § Responsible for creating the entire SDLC documents like requirement gathering, design specification creation , technical specification document, creation of the low level design and algorithm for the same. § Reporting to Project Manager for development status of Project. • Company Name : Access Information System Pvt. Ltd. • Duration : Feb 2004 - Jan 2005 ACCESS is IT company which has it’s own product ACCESS INSURANCE MANAGEMENT SYSTEM (AIMS) which is currently used by Cholamandalam MS General Insurance Company - Chennai (HO) for its insurance business through out the India in it’s more than 26 Branches. The product AIMS covers the wide range of Non-insurance products like Fire, Motor, Marine etc. Also there are different modules like Underwriting, Endorsement, Claims, Re-Insurance etc. • Project Title : Access Insurance Management System • Client : Cholamandalam General Insurance Ltd. • Duration : 11 months. • Team Size/Role: 12 / team member. • Software Tools : D2k , Reports 6i , Oracle 9i • Scope Of Project: AIMS is a decision support system for Underwriting, Claims, Re-insurance and Accounting. It is tailored to improve and enhance Insurance Business processes and other aspects of General Insurance Company. AIMS9i is based on the Client Server technology with the Application being accessed from multiple locations using Windows Terminal Services. The personal involvement in the development of the Endorsement Module which is all about the changes done in the original Policy by Clients in terms of Period of Policy, increase/decrease in Sum Insured, changes in the product covered. Mainly the premium calculated depend upon the Government Act for Insurance, if endorsement done as reduced Sum insured than the Refund amount also calculated on the same Government Act basis which was actually paid at the time of payment of the premium. Role/Responsibilities: Team Member. § Responsible for developing the change request given by the client. § Developing and maintenance of the entire report module for underwriting, endorsement and claims module. § Creating the documentation for the developed modules with help of senior member in the team. Personal Particulars: o Date of Birth /Age : 7th April 1982/25 years o Nationality : Indian. (Passport No: F3686811). o Gender : Male o Marital status : Single o Languages Know : English, Hindi, Gujarati, Marathi o Hobbies : Music, Tennis Miscellaneous: o Representative of ‘Cultural Committee’ for the company ‘Akshay Software Technology’ that conducts several cultural and social activities in the company. o Stood 1st in Badminton Championship in 10th in school.