SUMMARY

• Having around 8 years of experience in performing software analysis, design, development, support and performance tuning of the applications in Finance, Health, Manufacturing and Telecom sectors.
• Strong skills in Oracle server side programming which includes SQL, SQL*Plus, PL/SQL Packages, Stored Procedures, Functions, Cursors, Triggers, Views, Materialize Views, Temporary tables, Object Oriented PL/SQL Programming, PL/SQL Web - services, Java Stored Procedures and very good knowledge in Oracle 10g Developer Suite modules.
• Expert in application development using Oracle 9i, 10g/11g, SQL, PL/SQL, SQL*loader, Oracle Forms and Reports 6i/10g and Crystal Reports.
• Experience in designing & creating databases in Oracle 8i/9i/10g/11g for OLTP applications.
• Experience in identifying bottlenecks for scalability and performance using Oracle AWR and ADDM reports.
• Extensive experience in identifying performance issues, debugging and performance tuning using SQL Trace, Explain plan, Indexing, Hints, Partitioning, TKPROF, Profiling and Oracle Code Coverage Utilities.
• Detailed depth Knowledge in Oracle Architecture, Data Dictionary and DBMS Packages.
• Strong working experience in Oracle Advanced SQL, PL/SQL and RDBMS concepts.
• Strong in usage of SGA, PGA, Shared Pool, Redo log and Buffer cache concepts.
• Good knowledge in Oracle E-business suite, Modules (OM, PO, AP, AR, GL, WIP, BOM, INV, Projects).
• Expertise in customization and creation of new Forms and Reports in R12/11i
• Strong Functional knowledge in ERP Modules (Purchase, Stores, Material Management, Sales, Production, Warehouse, Planning and Accounts). Oracle Apps Techno Functional knowledge.
• Good exposure on Oracle Applications Implementation Methodology.
• Worked on interfaces using XML parser and DOM API.
• Having strong experience in large size database (4 TB) like AMDOCS.
• Well versed with AGILE and SCRUM process.

TECHNICAL SKILLS

ERP Applications: Oracle applications R12 (PO, AP, AR, OM and INV)

Language: SQL, PL/SQL, Core Java

Databases: Oracle 9i/10g/11i and SQL Server 2008

Reporting Tools: Oracle Reports 6i, 10g, XMLP Reports and Crystal Reports.

GUI: Developer 2000(Oracle Forms)/6i, 10g

Tools: Toad, SQL Developer, SQL*loader, SQL*plus, SVN, WINSCP, PUTTY and SSMSE

Operating System: Windows XP, LINUX and UNIX.

PROFESSIONAL EXPERIENCE

Confidential, Irvine, CA

Technologies: Oracle 10g and 11g, Oracle Forms and reports 10g Java, JSP and UNIX

Tools: SVN, TOAD, SQL Developer, FTP, WINSCP, Putty and Apps Server

Oracle Development Team Lead

Responsibilities:

• Involved in gathering the functional requirements from functional team.
• Working with Java development team during requirement gathering and Database designing phase.
• Creating and modifying the PL/SQL procedures and packages for the Java Calls.
• Creating objects like packages, tables, indexes, views, triggers, procedures, sequences, objects, types, cursors, ref- cursors, v-arrays etc. as part of development.
• Uploading data from flat files to database tables using SQL Loader and External tables.
• Generating Daily and Weekly Flat files using the UTL Packages and sending to Data Warehouse (ETL) (maintained by DELL).
• Implemented coding standards and code review process flow.
• As a lead prioritization and distribution of CRs and issue tickets to team.
• Organized few sessions on Functional and Technical topics
• Used partitioning and sub partitioning of tables to improve performance.
• Re written several procedures using advanced PL/SQL and 10g new features concepts and analytical functions.
• Implemented several tools with the coordination of java team for functional team users.
• Customizations and creation of new forms for the third party oracle application
• Created several reports which include drill down reports and complex matrix reports.
• Added new menu options for new modules.
• Preparing test plans for system and user acceptance test.
• Leading and mentoring the team.
• Implemented various inbound and outbound interfaces.
• Created various Cron Jobs and Oracle scheduler jobs.

Confidential, Irvine, USA.

Technologies: Oracle 10g and 11i, Sqlserver2008, Java, JSP and UNIX

Tools: SVN, TOAD, SQL Developer, SSMSE, FTP, WINSCP and Putty

Oracle Development Team Lead

Responsibilities:

• Identifying the gaps in the process and improve and optimizing the process.
• Automated several manual process using oracle scheduler and cron jobs.
• Created single dynamic program to handle all logical process by configuring table driven values.
• Working with Java development team during requirement gathering and database designing phase.
• Identifying the performance issue areas and proposed code optimized solutions
• Creating objects like packages, tables, indexes, views, triggers, procedures, sequences, objects, types, cursors, ref- cursors, v-arrays etc. as part of development.
• Wrote various SQL*loader control files and external table scripts.
• Creating stored procedures to send automated email notifications.
• Implemented common bug tracking mechanism across the project.
• Implemented coding standards and code review process flow.
• As a lead prioritization and distribution of CRs and issue tickets to team.
• Organized sessions on functional and technical topics
• Used partitioning and sub partitioning of tables to improve performance.
• Designed tables and relationships in SQL Server environment for INVENT product.
• Created various views and procedures (using T-SQL) in SQL Server environment.
• Designed database ER diagram for INVENT product.
• Created documents for all database relationships and ER diagram.
• Coordinating with Java and .Net GUI teams and distributing tasks to peers.
• Implemented several tools with the coordination of java team for functional team users.
• Preparing technical process flow documents.
• Preparing test plans for system and user acceptance tests.

Confidential

Technologies: C, Java, Oracle 9i/10g, UNIX Scripting, SQL Loader

Team Member

Responsibilities:

• Developing and customizing packages,
• Involved in creating and modifying Unix Shell scripts.
• Performance Tuning of Oracle based applications
• Ensuring error free high quality delivery by translating tickets to solutions.
• HLD, DSD and Deployment preparation.
• Involved in the development of SQL*loader scripts.
• Troubleshooting the Oracle based Applications.
• Requirement analysis, provide estimates and propose solutions for CRs and Trouble/Issue Tickets.
• Worked on typical migration project i.e. Oracle-C (language)-PowerBuilder application migrating from UNIX box to AIX box.
• Worked on large database AMDOCS billing.
• Test case/data preparation, execution and verification of the test results.
• Preparing deployment plans and deployment support.
• Updating functional documents in line with new changes.
• Worked on XML parser and DOM API to build interface between CHS and java legacy system.

Confidential

Technologies: Oracle Apps R12, Oracle 9i/10g, .Net, Forms 6i, Reports 6i& Crystal Reports

Responsibilities:

• Development and customization of reports, interfaces, conversions and forms.
• Designing the technical documents.
• Created several inbound and outbound interface.
• Developed various Crystal reports and configured in the .Net environment.
• Modified existing forms and reports.
• Development of XMLP reports as per the business requirement.
• Mapping functional specifications to technical for customizing existing reports.
• Developing reports, Interface programs and registering them as concurrent.
• Involved in the development of SQL*loader scripts.
• Involved in developing interfaces to load data from legacy systems to the base table.
• Creation of Values Sets in the Application.
• Involved in writing PL/SQL packages, procedures and triggers.
• Developed Invoice Interface to import the flat file data into base tables.
• Developed outbound interfaces to extract the data from base tables to Flat files.
• Prepared migration plan documents.
• Created DB links between the databases to synchronize the data.
• Prepared and submitting weekly migration status reports.

Confidential

Technologies: Oracle 10g, Oracle Forms and Reports 6i/10g, Crystal Reports.

Responsibilities:

• Implemented software at client place.
• Involved in creation of new tables, synonyms, various PL/SQL programs such as Stored Procedures, Functions, Triggers and Packages.
• Creating new Forms as per the customer requirement.
• Created several tree view forms.
• Developed several drill down reports.
• Performance tuning of SQL and PL/SQL Programs.
• Document preparation like technical designs, unit test scripts and review documents.
• Developed and customized additional Forms and Reports as per the client requirement.
• Prepared User Manual and Flow charts
• Executed User Acceptance Testing
• Involved in support and enhancements of all modules, User creation, Database Enhancements
• User training & on line technical support
• Integrated other technologies within the system.
• Developed several Crystal reports.
• On time Delivery of deliverables to the client,
• Installation of ERP products in user machines.
• Involved in performing periodic cold backup of the databases