EXPERIENCE SUMMARY:

• Certified Oracle Professional (OCP) with 11+ years hands on experience in Analysis ,Design and Development
• Certified JAVA professional with experience in the analysis and development with core JAVA, JSP, JavaScript, Struts.
• Strong Experience in development & tuning of packages, stored procedures and triggers using PL/SQL.
• Good Experience in Oracle Development tools like Dev6i /10g, Oracle Forms 6i/10g, Reports 6i/10g, Discoverer etc
• Experience of Working with the large databases in terabytes
• Extensive experience in working on all phases of software development life cycle including analysis, design, development, testing, implementation and support
• Extensive knowledge in requirement gathering, analysis, designing and architecting software solution.
• Experience in both OLTP and DSS applications.
• Strong experienced in third party products like TOAD, VERITAS.
• Strong Experience in administration of all database objects including tables, indexes, triggers, views, sequences, packages and procedures.
• Proven skills in relationship management with clients and effectively guiding teams during the project development life cycle and delivering the product within time, cost and quality parameter.
• Executed project management activities such as estimation and budgeting, work allocation, effort over-run calculation etc.

PROFESSIONAL CERTIFICATIONS:

• Certified Oracle Professional (OCP) in Oracle 8i Application Development. ( SQL /PLSQL, Forms and Reports)
• Certified Oracle Professional (OCP) in Oracle 10g Database Administration.
• SUN Certified JAVA Professional (SCJP) for Platform 2.
• Brain Bench test on PL/SQL on Sept 22, 2008 with 79 percentile

TECHNICAL SKILLS SUMMARY:

Programming Languages: SQL, PL/SQL and JAVA.
Development Tools: Developer 6i (Oracle Forms and Reports)
Operating Systems: Windows XP/NT/2000, Linux.
Databases: Oracle 8/ 8i/ 9i /10g.
Markup Languages: JavaScript, HTML, XML, CSS.
IDE: Toad, PL/SQL Developer, Eclipse, JDeveloper, SQL* plus.
Application Framework: Struts
Web Technologies: EJB, JSP, Servlets.

Professional Work Experience:

Confidential, San Jose, CA Title: Sr. PL/SQL DeveloperDuration: May 2008 - Till Date
Worked on the following Cisco projects as from May 2008

• BMnE: Currently working as an onsite coordinator with 2-Tier Quoting and Ordering application (SMS3) as a part of BMnE team and acting as a bridge between 2-Tier business and Development teams on the analysis of the business requirements.
• Service Offer Enablement (SOE) : Worked as an onsite technical person on this project for 2-Tier, quoting and ordering domain. Worked closely with the Analyst and offshore Development team to understand and implement the business requirements.
• Cisco International: Worked as an Analyst on C.I. project. I form a part of De-customization Team and worked on Different applications like Quoting and Ordering, OCM, SMS3, to finds out the hard-coded content and analyze the way to remove it in order to generalize the application.

Technical Environment: Oracle10g, SQL, PL/SQL, Toad, JAVA, HTML, Eclipse.

Confidential, Mauritius Title: Associate ManagerDuration: March 2007 to Feb2008
As an Associate Manager in MIDC (Mauritius Island Delivery Center) I was the center Database Lead. I also worked as a JAVA Capability and worked on a JAVA project involving core java, JSP, JavaScript
Responsibilities:

• Lead technical Consultant for CRM module development and maintains.
• As a technical consultant, responsible for preparing technical specification.
• Develop stored procedures, functions, views and triggers using PL/SQL and recommend appropriate scenarios for using these objects within the database applications for a very large database with billions of records.
• Worked on Java, JavaScript and JSP based GUI with the development team
• Work with Explain plan for SQL tuning and Hints for changing the query optimization plan.
• Administer all database objects including tables, indexes, triggers, views, sequences, packages and stored procedures.
• Instrumental in performance tuning of the system and troubleshooting of the database.
• Developed complex queries to retrieve the data
• Managed a team of 15 people involved in maintenance of the project.
• Estimation and budgeting along with the allocation of work to different resources in the team.
• I was the part of the recruitment team for the project.

Technical Environment: Oracle 10g , SQL, PL/SQL, Core JAVA, Struts, JavaScript, JSP, SQL,PL/SQL Oracle 10g, TOAD, SVN, Eclipse

Confidential, Mauritius Title: Senior Software EngineerDuration: Feb 2005 to Feb 2007
The company is involved in software development activities including ERP Solutions, tailor made software applications, web base solutions etc. Some of their clients include HONDA South Africa, JSS Solutions USA, Campus Kitchen USA etc
As a developer, I was involved in the following projects of sourceforge 
Responsibilities under POSterita

• Actively involved in the development of the business logic of the projects build mainly in JAVA using Struts as the frame work.
• Involved in the development of all SQLs and database objects like procedure, functions, triggers, views etc using PL/SQL
• Involved in the installation, maintenance and administration of Oracle database.
• Extensively worked on the Open Source ERPs Compiere and Adempiere and used them as a base for formulating web based Sales management systems
• Worked as a techno-functional resource in the installation of above said ERPs and the Sales management systems.
• Responsible for conducting user requirement meetings and gathering information from the application owners and gathering the requirements.
• Loaded and unloaded data sets from or to Oracle Databases using various kinds of data loading tools such as SQL*Loader and Oracle Import/Export Utility.

Technical Environment: Compiere / Adempiere, Core JAVA, Struts, SQL, PL/SQL JavaScript, JSP, Oracle 10g, Toad, SVN, Eclipse, Discoverer

Confidential Title: System Analyst and Developer Duration: April 2003 to Jan 2005
The company is a subsidiary of TELECIL which is the one of the largest telecom solution providers in the African region, and having contracts from Mauritius Telecom besides the contracts in Tanzania, Malawi, Zimbabwe, Nigeria and other African countriesResponsibilities

• Involved in development and maintenance applications including PL/SQL and Oracle Developer 6i
• Developed stored procedures, functions, views and triggers.
• Involved in the installation, maintenance and administration of Oracle database.
• Involved in Database Normalization.
• Part of a team that was involved in the design of the specifications of the database and the associated screens
• Communicate with the user and sort out the problems that they was confronting with the system, to make changes in the system accordingly and to formulate the different reports and the MIS of the system.
• Responsible for resolving with the application in testing phase.
• Involved in analysis, Design and development.
• Prepared High Level design documents, Technical Design and Test Specification documents.
• Creating stored procedures, packages, functions as per requirements using PL/SQL.
• Involved in Performance Tuning of reports by identifying the indexed required on the backend tables and also from the data available in the cache.

Technical Environment: Oracle 8i, Dev6i, Oracle Forms, Oracle Reports, TOAD, Red Hat Linux, Shell Script, SQL, PL/SQL

Confidential Title: Application DeveloperDuration: Feb 02 to Feb 03
I worked as an application developer for State Informatics Limited, Mauritius. The company is the one of the largest concerns who providing oracle solutions in the African Region and have contracts for developing software not only from government and private companies in Mauritius but also from other African countries. 
Responsibilities:

• Involved in development and maintenance of applications including PL/SQL and Oracle Developer 6i
• Develop stored procedures, functions, views and triggers.
• Responsible for conducting user requirement meetings and gathering information from the users and gathering the requirements
• Part of a team that was involved in the design of the specifications of the database and the associated screens.
• Writing PL/SQL code using the technical and functional specification generated SQL and PL/SQL scripts to install create and drop database objects including: tables, views, primary keys, indexes, constraints, packages, sequences, grant and synonyms.

Technical Environment: Oracle 8i, Dev6i,Oracle Forms, Oracle Reports, TOAD, UNIX, Shell Script, SQL, PL/SQL

Confidential Title: Software EngineerDuration: Aug 98 to Jan 02
I worked as a Systems Executive in the Software Solutions Business Unit of Marksoft Technologies. Marksoft leverages its partnership with Oracle Corporation with its quality processes and unique business model to deliver world-class software, knowledge management and e-learning solutions to its customers.
Responsibilities:

• Involved in development and maintenance of applications including PL/SQL and Oracle Developer 2000 as a part of the development team
• Develop stored procedures, functions, views and triggers.
• Worked with JAVA in some of the required phases of the projects
• Responsible for resolving with the application in testing phase

Technical Environment: JAVA, JavaScript, Oracle 8/ 8i, Dev6i,Oracle Forms, Oracle Reports, TOAD, UNIX, Shell Script, SQL, PL/SQL

EDUCATION AND TRAININGS:

• BS - Mechanical Engineering from Confidential University.
• Oracle DBA 10g from Confidential University.
• SQL / PLSQL and Developer 6i (Forms and Reports) from Confidential University.
• Project Management School and Delivery Methods from Accenture.