Oracle Software Engineer
Resume:
VIMAL K SHARMA
**** ****** *** ** ***# *** Salem OR
jcu97s@r.postjobfree.com
Professional Summary:
9+ Years of Experience in application development using Software Architecture, Design, Analysis, Development & Implementation of Enterprise Systems.
Experience in customization of Oracle based systems: design, development, testing and implementation of relational database management systems using Oracle 11g/10g/9i/8i, Forms 11g/10g/6i/3.0, Reports 11g/10g/6i, Oracle designer oracle tools under Windows, UNIX and Solaris.
Strong expertise in Oracle development – PL/SQL, Packages, Triggers, Procedures and Functions. Good knowledge of key Oracle performance-related features.
Worked with SQL/PLSQL to create tables, views and involved in writing complex SQL queries.
Proficiency in understanding clients needs to generate and modify reports existing in Oracle Applications according to the requirements and specifications
Strong analytical and troubleshooting skills
Excellent organizational, interpersonal and communicational skills
Skills to adapt with the rapidly changing technologies and implement the same at work.
Worked in all aspects of System Development Life Cycle in Business Applications.
Education : MS Computer Science (Software) DAVV Indore Univeristy.
Technical Expertise:
Certificates Oracle Certified Professional (OCP) – Development
Development Oracle Database 8i, 9i, 10g, 11g, SQL, PL/SQL.
Tools Forms 11g and Reports 11g ,Developer suite 10g (Forms 10g and Reports 10g), Developer suite 9i (Oracle forms 9i and Report 9i), Oracle Forms 6i, Forms 4.5, Forms 3.0, Oracle SQL report writer, Oracle Reports 6i, Oracle reports 2.5, SQL * Loader, TOAD, Sql Navigator, SQL Developer, JDeveloper
Programming PL/SQL, PRO*C, Shell Programming, Java Script, HTML, mod Pl/SQL, PJC (Pluggable Java Components), Java
Design & Data Modeling Oracle Designer.
Application server Oracle Application server 10G, Web logic Server
Software Ms Office, IBM Lotus Notes
Versioning Tools Clear Case, VSS, Spectrum
Bug Tracker IBM clear Quest, Serena Team Track system, Track it.
Operating systems Windows, Solaris 8.0, Solaris Sparc, HP-UX server, HP UNIX B11.11
Professional Experience:
Legislative Administration Committee Salem, OR
Oracle Applications – (Jan, 08 – Till Date)
Senior Application Developer
Description: This project involves migration of Legacy system from version 6i to 10G and then, to Oracle forms 11G and adding new functionalities to the Oracle application system, which includes CASS (Committee Agenda Scheduling System), DESK System, Legislative counsel oracle application and Measure tracking web-based application. Also maintaining the system’s regular operations
Responsibilities:
• Involved in reconstruction and redesigning of the oracle legacy application from version 6i to Oracle Forms 10G and later to Oracle forms 11G. Also involved in system maintenance, which involves fixing bugs and regular updates and enhancements for existing applications.
• Developed new reports for the system using report developer 10g.
• Assisted in setting up the Forms and Reports Services on 10g App Server.
• Developing back-end modules, such as packages, functions, procedures, triggers, object types, views for existing application and web based application developed using Mod PL/SQL, JavaScript and HTML.
• Integration of the application while following up quality standards and procedures.
• Used Serena team tracking system and VSS for application development & Version Control.
Environment: Oracle Forms 11g/10g/6i, report 11g/10g/6i, PL/SQL, SQL Navigator, Mod PL/SQL, JavaScript, HTML, PJC, Oracle application server 10g, UNIX shell script.
Carnival Cruise Lines Miami, FL
Ship Board Management System (Jun 07 – Jan 08)
Oracle Application Consultant
Description: This project involved upgrading & adding new functionalities to the SPMS (Ship Board Property Management System) using oracle application. There were various modules including Passenger system, sale & sign, Shipboard sales. This system was used for maintaining the application across 22 ships.
Responsibilities:
• Worked as Techno Functional Consultant. Involved in the Production support performing fixing bugs and product feature enhancements.
• Active involvement in development and coding of oracle forms and reports along with stored Procedures, SQL DDL/ DML statements, functions & triggers.
• Used Clear Quest and Clear case for application defect logging & Version Control.
• Was involved in the Integration Testing, Unit Testing, and Code Review of the application.
• Deploying and integration of the application using highest quality standards and procedures.
• Documented Business Rules, Functional and Technical Designs, and User Guides.
Environment: Oracle Forms 6i, report 6i, Pro*c, PL/SQL, Oracle 10g, TOAD, UNIX shell script.
National Stock Exchange of India Limited (NSEIL)
Tata Consultancy Services Mumbai, India
Online Position Monitoring system (Mar 06 - Jun 07)
IT Analyst
Description: This is a risk management system, which monitors the Capital market trades executed by the trading members registered at NSE. Whenever they cross the trading limits, warnings are sent followed by disablements and thereafter they are not allowed to execute any trade at NSE unless they pay the required capital to NSE.
Responsibilities:
• Was acknowledged multiple times for understanding client requirements to quickly generate or modify reports existing in Oracle Applications according to the requirements and specifications.
• Conducted meetings with clients to understand the scope of the audit. Captured business process requirements through client interactions.
• Prepared weekly status report, finalized audit deliverables, shared and presented the audit deliverables to the clients.
• Performed code review for OPMS system.
• Provided techno-functional inputs to other team members for re-architecting the systems and process level improvements /suggestions for the system performance improvement.
Environment: HP UNIX B11.11, Windows NT 4.0, Oracle 8i database, Oracle 10g, Database Forms
6i and reports 6i, Pro *C, PL/SQL
Bank of Baroda & State Bank of India
Tata Consultancy Services Mumbai, India
Easy deal (Dec 05 - Apr 06)
IT Analyst
Description: The project was aimed to efficiently manage EASYDEAL, which is a comprehensive online system and is an effective solution for both, the front and back office operations. In front office, Easy deal provides information related to currency positions and exposures and for back office, Easy deal performs a number of functions such as deal completion, confirmations and generation of a variety of statements.
Responsibilities:
• Developed application using oracle forms and report builder and released the components on acceptance and production environment after testing and final inspection.
• Involved in analyzing and consolidating the client requirements and making appropriate design changes to the system.
• Involved in database tasks like database design, creation of tables and indexes, schemas, users, roles, profiles, stored procedures, functions, DDL/ DML SQL queries.
• Engaged in production support for application and provided immediate solutions since the issues handled were time-bound.
Environment: HP UNIX B11.11, Windows NT 4.0, Oracle 10g, database, Forms 6i and Reports 6i,
PL/SQL
TAG (Tata InfoTech Automation Group)
Tata Consultancy Services Mumbai, India
SID Livex and Revenue (Feb 05 - Nov 05)
Senior software Engineer
Description: TAG is a group, which supports all the systems developed for the automation of processes in Tata InfoTech. LIVEX (Living Expenses) system is a part of the integrated MIS for TIL. The LIVEX function includes the payment of foreign LIVEX to employees on projects / trips, accounting of the payments made, accounting of expense reports. The revenue function includes raising and tracking of invoices, tracking and accounting of receivables, transfer of funds from foreign bank to the local bank.
Responsibilities:
• Analyzed client requirements, consolidated them and made appropriate changes to the system.
• Involved in migration of existing MIS application to web based forms 10g. Knowledge of OC4J configuration for application server. Customized basejini.htm using JavaScript and html
• Involved in gathering of business requirements, functional and technical specification writing.
• Developed back-end logic for MIS applications, e.g. views, procedures /functions, triggers
• Provided production support for the module components in case of exceptions occurring in production environment. Business and technical induction to new team members
• Developed and reviewed components (Batch Programs, Screens, Reports), analyze changes, incorporate them, test and implement enhancements.
• Developed complex financial reports using Oracle reports 10g.
Environments: Oracle 8.1.7 and Oracle 10.1.0(10G), Forms and Report 6i, Oracle Developer Suite – Forms
10g, Oracle Application server 10g SQL, Pro*C, PL/SQL, JDeveloper 10g,
PJC (pluggable java components), HTML, Java script.
Ruchi InfoTech SID (Indore) M.P
Oracle Application (In-house Development) (Apr 03 - Feb 05)
Software Engineer
Description: This system is based on trading of oil imported by Ruchi group of companies at port locations of India and abroad. Application includes Sales Maintenance, Stock Maintenance and Financial Accounting. Reporting section covers many details like preparation of cashbook, bankbook, party ledger information, Fund and cash flow statements, trial balance report, account report and Balance sheet etc.
Responsibilities:
• Migrated oracle forms 3.0 to Oracle forms 4.5 to oracle forms 6i and Oracle SQL report writer reports to oracle reports 2.5 to oracle reports 6i.
• Created new application using Oracle forms 10g/9i/6i and reports 10g/9i/6i.
• Designed relational data models based on application system data requirements.
• Involved in developing User Interface and different type of oracle Reports involving complicated validations.
• Developed packages, stored procedures, functions and database triggers.
• Reviewed and thoroughly tested modified objects related to change request forms. Modifications existing code as per change request/enhancement.
• Creating and maintaining quality control documents.
Environment: Forms 9i and reports 9i ,Forms 6i and reports 6i,Forms 4.5 and Reports 2.5,Forms 3.0 and SQL reports writer , Forms 6i, Reports 6i, Developer suite 10g (Oracle Forms 10g and reports 10g) ,Oracle 10g
Viscus InfoTech Ltd Indore, India (Jan 02- Mar 03)
Software Engineer
Description: Delay Mechanical Maintenance: This system was developed for calculation of delay for the mechanical department. Besides this system was used for maintaining the history of item, which was used on various machines. Grinding Information System: This system was developed for keeping the tracks of rolls, which were used in the mill. The System was used for tracking the Issue of new roles their date of issue, thickness at the time of issue, New/old. It was used for calculating the total cost of the Roles used in the System.
• Requirements gathering from the line of business. Requirement analysis for feasibility and documentation
• Performed database designing, developed packages, stored procedures, functions and database triggers.
• Development of front end interface using oracle forms and reports for the application.
Environment: Form 6i, and Report 6i. Oracle designer, Pl/Sql, Sql ,Oracle 8i
Contact this candidate