Professional Profile

• Nearly 9 years of IT experience in all stages of SDLC - Requirement Analysis, Design, Development, Testing Implementation.
• Good understanding of Oracle Architecture.
• Experience in Oracle Development tools Oracle Developer Suite 10g/9i Oracle PL/SQL Oracle Forms Reports 6i/10g Developer TOAD Oracle Import / Export Utilities SQL Loader Oracle SQL Developer.
• Involved in database design and data modelling using Erwin Data Modeler tool.
• Experience in analysis and design of database, coding, query optimization, technical reviews and team handling.
• Experience in UNIX Shell Scripting.
• Experience in Migrating Data from Legacy systems to Oracle database.
• Experience in Unit testing, Regression testing, Integration testing and User-Acceptance testing.
• Provided support for RDBMS in Development, Test and Production environments using Oracle Tools.
• Experience in preparing technical documentation user manuals
• Ability to cope up with team with good analytical, communication, organizational and interpersonal skills. An effective communicator with strong leadership, people management, analytical and Problem solving skills who believes that learning and sharing is the foundation of all organizational growth. An effective team-player with proven abilities in guiding teams towards achieving organizational goals and corporate objectives.

Software / Applications Known

Database : Oracle 10g/9i/8i

Development tools : Oracle Developer Forms 6i, Reports 6i/10g , SQL, PL/SQL, Unix Shell Scripting

Database tools : SQL PLUS, SQL Loader, TOAD, SQL Developer

Version Control : Tortoise SVN, VSS

Operating Systems : Windows XP/98/95, UNIX

Verticals : Retail, PSI Purchase, Sales, Inventory , Manufacturing, Health Care

Career Highlights

Technical Lead

Confidential

Skills Used : Oracle 11g

• Involved in coding for new enhancements and SR's.
• Involved in gathering and creating requirement documents.
• Involved in writing crisp and precise technical documentation.
• Created SQL Loader Control Files for moving data from Flat Files Fixed Record Length to temporary tables.
• Managing tables, indexes, constraints, views sequences, synonyms and stored program units in the form of SQL PL/SQL.
• Worked on resolution for the issues logged by customer.

Confidential

Role in Project : Lead Engineer

Skills Used : Oracle 11g

• Coding for new enhancements and unit testing.
• Involve in gathering and creating requirement documents.
• Involve in writing crisp and precise technical documentation.
• Managing tables, indexes, constraints, views sequences, synonyms and stored program units in the form of SQL PL/SQL.
• Works on resolution for the issues logged by customer.
• Monitoring daily Batch jobs.

Confidential

Role in Project : Lead Engineer

Skills Used : Oracle 11g

• Involved in coding for new enhancements and SR's.
• Involved in gathering and creating requirement documents.
• Involved in writing crisp and precise technical documentation.
• Managing tables, indexes, constraints, views sequences, synonyms and stored program units in the form of SQL PL/SQL.
• Worked on resolution for the issues logged by customer.

Confidential

Role in Project : Lead Engineer

Team Size : 5

Skills Used : Oracle 10g, SQL Loader, Oracle Report 10g and UNIX Scripting.

• Created New Reports using Oracle reports 10G.
• Involved in gathering and creating requirement documents.
• Created SQL Loader Control Files for moving data from Flat Files Fixed Record Length to Staging Area Tables.
• Involved in writing crisp and precise technical documentation.
• Developed UNIX shell scripts for automating oracle report.
• Implemented Export/Import Oracle utilities to move data to different testing environments.
• Made use of AUTOTRACE and EXPLAIN PLAN for monitoring the individual query performance.
• Developed Stored Procedures, functions and triggers to customize oracle report

Confidential

Role in Project : Technical Lead

Skills Used : Oracle 10g, SQL Loader, CAF Scripting.

• Involved in gathering and creating requirement documents.
• Involved in writing crisp and precise technical documentation.
• Developed CAFE scripts for automating oracle DB object.
• Created database objects like Tables, Views and Triggers Procedures, Packages using Oracle tools like SQL Loader, SQL Plus and PL/SQL

Confidential

Client : ARTEMIS and MEDANTA Hospitals .

Role in Project : Developer L3.

Team Size : 5

Skills Used : Oracle 10g, SQL Loader, Oracle Forms/Report 10g.

• Worked with team to design, develop, test and implement system.
• Created database objects like Tables, Views and Triggers. Created Procedures, Packages using Oracle tools like SQL Loader, SQL Plus and PL/SQL.
• Involved in Data Loading and Data Migration. Used SQL Loader to load data from flat/Excel file into the temporary table and developed PL/SQL program to load data from temporary table into base Tables.
• Created web based Forms and Reports using Oracle Developer 6i.
• Modified existing codes and developed PL/SQL packages to perform Certain Specialized functions/enhancements on oracle Application.
• Used Export and Import to transport data from production to testing and to other databases.
• Participated in development, testing and migration of oracle objects from development to testing and production environments.
• Involved in QTP automation using 9.5.

Confidential

Skills Used : Oracle 10g, SQL PLUS, PL/SQL, Toad 9.5, Oracle Forms/Report 10g.

• Involved in gathering and creating requirement documents.
• Involved in writing technical documentation.
• Developed Database Triggers, PL/SQL Packages, Stored Procedures, Functions.
• Created / modify new and existing oracle forms /reports as per the user requirement.