Project Sql Server
Resume:
Introduction
IT professional having core experience of 8+ years in Oracle
• 10+ Years of IT experience in various phases of software development including System Analysis & Design, Development, Integration Testing, Implementation, User Training and Documentation.
• Analytical skills to solve complex, cross-functional and technical issues – acquired from working in different projects.
• Proficiency in Power Builder 5.0/6.5/7.0/8.0/9.0/10.2/11.0/12.0 and Object Oriented Methodologies.
• Expertise in client – server technology, developed business applications using Power Builder as front end and Oracle8i as back end.
• Expertise in Oracle 9.x/8.x, Oracle 10g, Sybase 12.5, SQL Server 2000/2005/2008, PL/SQL (including stored packages, procedures functions and database triggers) and SQL programming.
• Good knowledge of UNIX and shell scripting.
• Good knowledge of Oracle 8i Database Administration.
Domain Trade Tax / Commercial Tax Functionality, Medical Domain, Financial Domain
Tools /DB/Packages ORACLE 8i/9i/10g/11g, Power Builder 5.0/6.5/7.0/8.0/9.0/10.2/11.0/12.0, VISUAL BASIC 5.0, MS Access, SQL Server 2000/2005/2008, Sybase12.5
Programming Languages SQL, PL/SQL
Operating System Windows-95/98/2000/XP/7, Windows NT4.0,UNIX and MS Doss
• Master of Business Administration with specialization in Information Systems
• Bachelor of Engineering with specialization in Electronics.
• Three years diploma in Russian language
• Oracle certified Associate, DBA track (Oracle – 9i)
Company SunGard Solutions Software (India) Pvt. Ltd
Project Name iWORKS - Reinsurance Team Size 11
Start Date April 2010 End Date Till Date
Description
ProCede and ProSume are two existing products for the reinsurance domain. SunGard’s iWORKS solution enables insurance and reinsurance companies to manage all facets of their ceded reinsurance process.
Reinsurance is a contract of insurance whereby one insurer (called the reinsurer or assuming company) agrees, for a portion of the premium, to indemnify another insurer (called the reinsured or ceding company) for losses paid by the latter under insurance policies issued to its policyholders.”
Role & Contribution
Role: Project Lead – Product Development
Contribution:
• Responsible for s/w development/enhancement activities.
• Responsible for project planning and resource management.
• Client interaction and team interaction
• Responsible for Analysis and estimation for the enhancement proposed.
• Responsible for testing and user acceptance for the changes and enhancement proposed.
• Responsible for writing Queries, Packages, Procedures, Functions and Triggers as required.
• Responsible for mentoring Team members.
Technologies Intel Pentium m/c, Oracle 10g/11g, SQL Server 2005/2008, Power Builder 11.0/12.0, Star Team 2005, Plastic (source control), OnTime (Manage defects and tasks)
Company KPIT Cummins Info Systems
Project Name Order Management System Team Size 15
Start Date Sept 2007 End Date March 2010
Description
OMS (Order Management System - FLASH) is an application which is used for the order management of funds and supports the EIS (European Securities Services) business activity for BP2S.
An investor approaches a distributor (network) directly or through an agent to buy or sell funds and places an order accordingly. The distributor sends the orders electronically, in the form of swift messages or through fax to the LTA (Paribas branches at different location).
The LTA enters the orders (dispositions) into the Flash application and depending on the setting at the UCITS level and the Fund level, the NAV, tax, fees etc is calculated for the dispositions.
Role & Contribution Role: Information Analyst
Contribution:
• Responsible for s/w development/enhancement activities.
• Responsible for Analysis and estimation for the enhancement proposed.
• Responsible for testing and user acceptance for the changes and enhancement proposed.
• Responsible for writing Queries, Procedures, Functions and Triggers as required.
• Responsible for mentoring Team members.
• Responsible for Unix and shell scripting part also.
Technologies Intel Pentium m/c, Oracle 10g, Sybase12.5, UNIX, Power Builder 9, Shell scripting, Star Team 2005
Company Electronic Data Systems Pvt. Limited
Project Name Generic Origination Engine
Team Size 12
Start Date March 2006 End Date Sept 2007
Description
GOE (Generic Origination Engine) was developed by EDS to replace OS (Origination System) for all EDSCS users. Note that OS is still used in Westpac Branches to create new loan applications. Although OS and GOE are different applications they basically have the same functionality.
GOE is used to progress loan applications for a specific EDS Tenant (eg Westpac) from the initial customer application through to Settlement. This is managed by progressing though different status levels for each application (3 Tier Architecture)
Role & Contribution Role: Information Analyst
Contribution:
• Responsible for s/w development/enhancement activities.
• Responsible for testing and user acceptance for the changes and enhancement proposed by EDSCS.
• Responsible for writing Queries, Procedures, Functions and Triggers as required.
• Responsible for mentoring Team members.
Technologies ORACLE 9i, SQL, PL/SQL, Power Builder 8, EA Server, UNIX
Company Birlasoft India Limited
Project Name Enterprise - Real Time System (COMFIN – GE) Team Size 10
Start Date Nov 2005 End Date March 2006
Description
GE Commercial Finance offers an array of financial services and products worldwide. With a particular expertise in the mid-market segment, GE Commercial Finance provides loans, operating leases, financing programs and other services.
Enterprise ensure the provision of substantially enhanced services to clients, major improvements in productivity and enhanced risk management. This will provide GE with a powerful and comprehensive platform on which to base its business as it moves into the twenty-first century.
Enterprise’s Risk Management functionality aids GE to collect and maintain information about clients, debtors and facilities in order that all risks arising from an GE investment may be understood and evaluated
Role & Contribution
Role: Senior Software Engineer
Contribution:
• Responsible for s/w development/enhancement activities.
• Responsible for testing and user acceptance for the changes and enhancement proposed by GE.
• Responsible for writing Queries, Procedures, Functions and Triggers as required.
• Responsible for Database Administration.
• Responsible for mentoring Team members.
Technologies SQL Server 2000, SQL, PL/SQL, Power Builder 7.0
Company Techspan India Limited
Project Name Surgery (AdvantX) for Source Medical Team Size 5
Start Date Feb 2005 End Date Nov 2005
Description
Source Medical is the world's leading provider of outpatient information solutions used in more than 3,200 healthcare facilities in USA. As an application outsourcing partner TechSpan would be engaged in providing enhancements & maintenance support for Source Medical applications.
AdvantX® is a fully integrated package of information management tools pertaining to the various areas of healthcare organization developed by Source Medical Solutions, Inc. It enables healthcare providers to quickly and easily collect information about their patients using the latest computer technologies, dramatically reducing paperwork and errors associated with more traditional methods of medical documentation.
The package is meant for small and medium industry and looks into the following areas of the healthcare organization:
* Practice Management
* Surgery Center
* Surgical Hospital.
Role & Contribution Role: Consultant
Contribution:
• Responsible for s/w development/enhancement activities.
• Responsible for testing and user acceptance for the changes and enhancement proposed by Source Medical.
• Responsible for writing Queries, Procedures, Functions and Triggers as required.
• Responsible for Database Administration.
Technologies Power Builder 6.5, ORACLE 9i, SQL, PL/SQL, SQL Server 2000
Company CMC Limited
Project Name COMITRAX (COMputerized Information system for TRAde taX) Phase 2 Team Size 10
Start Date Sept 2004 End Date Jan 2005
Description
UP Trade Tax (UPTT) Department is responsible for collection of Trade Tax on sale or purchase of goods for the state of Uttar Pradesh. These are required for internal and external agencies (such as Dealers, Transporters) related to tax assessment, collection. Also the transfers, amendments and cancellation of dealer registration and monitoring of unregistered dealers are required.
Role & Contribution Role: Module leader
Contribution:
• Responsible for studying the requirements and for Phase 2 of the project.
• Responsible for s/w development/enhancement activities.
• Responsible for testing and user acceptance for the TAS (Tax Assessment System) module.
• Responsible for Database Administration and for Installation of ORACLE on server and client m/c & troubleshooting.
Technologies PowerBuilder 6.5, ORACLE 9i, Jdeveloper, Windows NT.
Company CMC Limited
Project Name COMITRAX (COMputerized Information system for TRAde taX) Phase 1 Team Size 12
Start Date Oct 2001 End Date Aug 2004
Description
In this direction CMC conducted the study and identified 16 integrated modules for covering the different functionalities. The various modules are Trade Tax Registration, Assessment of Dealers sub-system, Arrears Collection sub-system, Revenue Collection sub-system, Enforcement on Dealer sub-system, Case and Appeal Monitoring sub-system, Trade Tax Accounts sub-system (TACTS), Training sub-system, Library sub-system, Dak Receipt & Dispatch Management sub-system, Consignment & Weeding sub-system, Asset Accounting sub-system, Personnel Information sub-system, Forms Inventory sub-system, Document Referencing sub-system and MIS Reporting System.
Role & Contribution Role: Team Leader / Module Leader
Contribution:
• Responsible for Development & Testing of sub-systems of COMITRAX.
• Responsible for Backups and Recovery of database.
• Responsible for Database Administration.
• Analysis of client requirements and impact for different purpose.
• Support to the team in various activities during, Development and Implementation of project.
• Client support during acceptance testing and Implementation.
• Documentation and Training.
• Project monitoring and control throughout the development and implementation phase.
• Responsible for System Administration on Windows NT.
Technologies Power Builder 5.0, ORACLE 8i, Windows NT.
Contact this candidate