SUMMARY

• 8+ years of experience in complete Software Development Lifecycle (SDLC) using Oracle 11g/10g/9i/8i on Windows and UNIX platforms in the phases of Analysis, Designing, Development, Production support and Testing and well versed with basic DBA activities.
• Extensive experience in writing/debugging Oracle SQL, Dynamic SQL, PL/SQL code i.e. Packages, Stored Procedures, Functions, Triggers, Cursors, Ref Cursors for Web Services, Constraints, Indexes, Views, Materialized Views, Database Links (DBLINKS), Sequences, Synonyms, and Global Temporary tables. Strong knowledge in using Oracle built - in packages (like UTL FILE, DBMS SQL), Cursor management, Exception handling etc.
• Used SQL analytical functions for customizing reports.
• Extensive hands-on experience with Client/Server technology using Reports 6i/9i/10g.
• Extensively involved in writing SQL Queries (Sub queries and Join conditions), PL/SQL subprograms and Query Level Performance tuning.
• Performing tuning of application usingADDM, AWR, ASH, SQL-Tuning Advisor, Statspack, Explain PlanandExtensive experience in Database query tuning and Performance tuning (HINTS, EXPLAIN PLAN and TKPROF utility) of pl/sql packages.
• Expert in Client-Server application development using Oracle 11g/10g/9i/8i, PL/SQL, SQL *PLUS, TOAD, SQL *LOADER.
• Exposure in using Tools like TOAD, SQL Developer and SQL*Plus for writing PL/SQL Programs.
• Experience in creating complex triggers or generate packages and indexes to increase performance and complex SQL queries for joining multiple tables.
• Extensive experience developing External tables and using Oracle utility tools like SQL*Loader, Import and Export programs.
• Extensively involved in SQL tuning, troubleshooting, debugging and fixing the codes/scripts.
• Developed Test Scripts, Test Cases and SQL QA Scripts to perform Unit Testing, System and Load Testing.
• Solid understanding of relational databases.
• Experience with data migration using BULK COLLECT.
• Experience in Cut Over Plan and Contingency Plan.
• Knowledge in Core Java Object Oriented Concept.
• Experience in providing 24x7 production support and handling and raising defects in Defect Tracker Remedy Tool.
• Experience in data modelling tool like Visio, MS Visual Studio.
• Worked in onsite - offshore model and experience in leading the technical team
• Thorough experience in oracle application SCM, TCA modules.

TECHNICAL SKILLS

ERP: Order Management, TCA, Purchasing, Inventory, Salesforce

Application Tools: Reports 6i/9i/10g, Discoverer 4i/9i/10g, XML Publisher 5.6.3/5.6.2 , Oracle Forms 6i/9i/10g

Databases & Tools: Oracle 11g/10g/9i/8i, TOAD, SQL*PLUS, SQL*Loader, SQL* Developer, Kintana, Test Director, PVCS, Visio, MS Visual Studio, svn, crontab, Erwin

Operating Systems: Windows NT/XP/2000/98, UNIX, Linux, MS-DOS

Languages: SQL, PL/SQL, UNIX (Korn, Bourne), core java, basic python

Scripting Languages: Unix Shell scripting

PROFESSIONAL EXPERIENCE

Confidential, Columbus, Oh

Oracle Database Developer

Responsibilities:

• Designed new package to add new acquisition company into existing system. Used oracle pipe function and scalar object which was used by the web service team to fetch the data.
• Created external table to load the data from external flat files.
• Used GTT (Global temporary Table) in the package to reuse in the package for various procedures.
• As a DB resource, was the point of contact for version control and deployment by creating deltas.
• Was part of JAD session and in Amigo’s meeting.
• Handling database refresh from current production version subset.
• Created new tables and modelled the data structure using Erwin.

Confidential, San Jose, CA

Lead Oracle Developer

Responsibilities:

• Design and develop PL/SQL packages, Procedures and Functions, Cursors, Ref Cursors and Triggers for the Web Services.
• Handling application DBA activities.
• Performed application Query tuning using utilitiesADDM, AWR, explain Plan,SQL Tuning Advisorand suggested the best access path for the SQL queries.
• Scheduled maintenance plans likedaily & weekly backups, rebuild indexes, update stats
• Developed complex scripts for automating batch processes which manage critical processes of the CRM system.
• Migrating database and applications to new releases and implemented changes to the Data Model.
• Worked Closely with Data Architect team to design and create scripts for objects such as tables, indexes, views, sequences, object types and collection types.
• Created new database objects like Sequences, Procedures, Functions, Packages, Triggers, Indexes and Views in Development and Production environment using PL/SQL and SQL*Plus.
• Designed Data Flow Diagrams (DFD’s) using Visio
• Assisted with required data analysis, interpretation, correction and document presentation for various assignments
• Used Ref Cursors, dynamic sqls and bulk collect concept in the packages/APIs.
• Developed complex scripts for automating batch processes which manage critical processes of the CRM system

Confidential

Lead Developer

Responsibilities:

• Review and sign off functional design document
• Design/ Review Technical design document
• Include data modeling in the design documents
• This project required a very tight integration between ERP and Legacy team (Team who developed Java based programs, called by ERP)
• Review/ Build Code
• Prepare execute test cases

Confidential

Senior Developer

Responsibilities:

• Analysis of the specifications provided by the clients, Preparation of design Docs, Test Case, and Implementation documents.
• Impact Analysis of the changes to integrate SA’s operations with Cisco’s.
• Presenting the Technical Design Document to different third parties and Cisco IT team.
• Created Views using a bunch of Joins, Union and minus operators on the reference tables which hold the data with new Cisco specifications
• Responsible for developing database objects and maintaining database deployment scripts, developing procedures, function and triggers
• Responsible as the Point of Contact (POC) for the Oracle Technical Team.
• Wrote/Modified stored procedures, Triggers for Database operations in Oracle.
• High level integration testing with the members handling the order tool with our ERP, due to cross flow dependencies involved.
• Presentations to cross-flow teams and client.
• Helping the project manager in preparing contingency plan & project planning.
• Regular monitoring the production databases and applications for any provisioning issues.
• Part of the migration team to migrate all the objects from Dev to Test and finally to PROD environment.
• Part of the production support team after the project had gone live.

Confidential

Senior Developer

Responsibilities:

• Analysis of the functional requirement and provide a high level design
• Based on the scope of the project, providing the detail requirement and complexity of the project based on which resource allocation is done
• Interacting with the client to prepare the data sheet of actual requirement based on which development starts
• Preparing the entire technical flow and helping the developers for the proper analysis and coding to achieve the requirement
• Developed database triggers to maintain audit tables
• Customized Customer Entry Form in Oracle Application to meet the requirement.
• Developed API(Pl/Sql) programs to import customer data from external system to ERP .
• Created custom PL/SQL procedures to read data from flat files to dump to Oracle database using SQL *Loader
• Migration activities for different test cycles and then to FPR (Final Practice Run) and finally to Production

Confidential

Senior System Engineer

Responsibilities:

• Analysis of new requirement and code analysis of the existing reports
• Review and sign off functional design document (MD050)
• Meeting with biz/ client to understand requirements
• Design/ Review technical design document (MD070)
• Write/ Review codes in SQL, PL/SQL, APIs etc.
• Extensively used the advanced features of PL/SQL like Subtypes, Records, Tables, Object types and Dynamic SQL.
• Tight Integration with other boundary systems & modules like Pro-Channel (CRM) etc.
• Review the code changes done by team
• Prepare & Execute the test cases

Confidential

Senior Programmer

Responsibilities:

• Tracking the status of bugs, raised after go-live and fixing it.
• Daily tracking of Defect Tracker for the production issues and fixing the same and deployment to PROD environment
• Created new reports using Report 6i and modifying the existing reports.
• Helping offshore in getting approvals from the Cisco Analyst for the fixes made by us
• Tight Integration with other boundary systems & modules
• Addressed operational problems, concerns, and questions posed by users
• Worked with Users in understanding the requirements and prepared the functional documents for the same.
• Setting up profile options values, lookups (standard and custom).
• Interacting with upper management to identify the business process and needs and with end users to identify their requirements
• Liaising with client key users and technical team, conducting testing
• Responsible for transfer of data from Order Management module to Account Receivable module by rewriting complex APIS.