SUMMARY

• 10 years of experience in IT industry with emphasis on Analysis, Design, Development, Implementation and Managementof projects usingOracle (Sql, PL/SQL), Forms, Reports 6i/9i/10g/11g and Unix
• Strong Exposure in writing Simple and Complex SQLs, PL/SQL Functions and Procedures, Packagesand creation of Oracle Objects - Tables, Materialized views, Triggers, Synonyms, User Defined Data Types, Nested Tables and Collections.
• Extensively used Shell Scripts for doing manipulations of the flat files
• Experience in compiling the FMBs using UNIX shell script and deploying forms and reports on the application server.
• Developed PL/SQL triggers and master tables for automatic creation of primary keys.
• Created PL/SQL stored procedures, functions and packages for moving the data from staging area to data mart.
• Created scripts to create new tables, views, queries for new enhancement in the application using TOAD.
• Created indexes on the tables for faster retrieval of the data to enhance database performance.
• Involved in data loading using PL/SQL and SQL*Loader calling UNIX scripts to download and manipulate files.
• Performed SQL and PL/SQL tuning and Application tuning using various tools like EXPLAIN PLAN, SQL*TRACE, TKPROF and AUTOTRACE, AWR, ADDM.
• Extensively involved in using hints to direct the optimizer to choose an optimum query execution plan.
• Used Bulk Collections for better performance and easy retrieval of data, by reducing context switching between SQL and PL/SQL engines.
• Created PL/SQL scripts to extract the data from the operational database into simple flat text files using UTL FILE package.
• Creation of database objects like tables, views, materialized views, procedures and packages using oracle tools like Toad, PL/SQL Developer and SQL* plus.
• Very Good experience withUNIX Cron Jobs,Batch Processing
• Experience withPerformance Tuningfor Oracle RDBMS usingExplain PlanandHINTS and also worked on CBO & RBO.
• Significant experiencein24/7 ProductionEnvironment Support.
• Expertise in working with built-in packages like DBMS LOB, DBMS SQL, DBMS SHEDULER, DBMS DDL, UTL FILE

TECHNICAL SKILLS

Databases: Oracle SQL, PL/SQL 12c/11g/10g/9i/8i, SQL Server, Teradata

Scripting: UNIX Shell Scripting

GUI: Oracle Forms 6i/9i/10g and Reports 6i/9i/10g

Languages: PLSQL, CORE JAVA, UNIX, C, C++

Tools: SQL Developer, TOAD, SQL plus, PUTTY, WINSCP

EBS: Oracle CRM (Teleservice, CRM foundation, Install Base, Service Contracts, Call center, Field Services), oracle PIM, oracle Inventory, Oracle workflow Builder

Operating Systems: Windows 7, Windows Vista, XP, UNIX, Linux, and Solaris

Ticketing Tools: BMC Remedy

Version Control: PVCS, VSS, Clear Case

Data Modeling: ERwin

PROFESSIONAL EXPERIENCE

Confidential, New York, NY

Oracle PL/SQL Developer

Responsibilities:

• Developed PL/SQL Packages, Procedures, Functions and Triggers as per Business Requirements.
• Tuning SQL queries by using EXPLAIN PLAN.
• Performance tuning of the stacking application.
• Worked mostly on Interface issues
• Prepared the documents and posted in Share point
• Developed process improvements using the Bulk Collect and FORALL (Bulk Bind) methodology.
• Completing unit and integration testing of the jobs for GP Archiving.
• Performed SQL tuning using Explain Plan, Hints and indexes.
• Used WITH clause to improve the performance of Cognos Reports queries
• Coded for accessibility - ADA/Section 508/WCAG 2.0 compliance.
• Debugging Procedures & Functions and improving the Performance of Application.
• Involved in performance tuning (SQL, PL/SQL) using oracle tools Explain Plan, TKPROF, auto trace, AWR etc.

Environment: Oracle 11g, UNIX, Toad, Putty, Revitas

Confidential, San Jose, CA

Oracle PL/SQL Developer

Responsibilities:

• Be the first Point of Contact for all the client escalations, Be the bridge between onsite and offshore team and responsible to handle the sync up calls between onsite and offshore.
• Developed various configuration plans and build to deploy in diff environments.
• Identifying and documenting the technical issues and the approach to resolve the same.
• Assigning and working on incidents to team based on priority/Availability.
• Handled/ monitored all movement of codes (code-migration) to several testing and Prod environments.
• Using BMC Remedy tool to accept tickets raised by various Business/IT-Users and converting them as IT enhancement requirement by discussions with the business representative.
• Groomed fresher’s on the functionality of the application
• Attended the bridge/ Onsite/Offshore Sync up calls.
• Preparing the management updates by sending the daily status report
• Got knowledge on various CISCO tools
• Attending and driving the P1/P2 Bridge Calls.
• Involved in data replication for multiple environments like QA, TRG & UAT etc.
• Lead development team and addressed/resolved Development, Production and UAT issues.
• Finding Performance bottlenecks using STATSPACK, EXPLAINPLAN, SQLTRACE, TKPROF, AWR, and ADDM.
• Interacted with client team to Provide Post Go-Live support after every release and resolve Functional/Technical issues
• Helped Team members on Business and Technical issues and give and Presentation to Clients and New team Members.

Environment: UNIX, Oracle 10g, Oracle Apps R12, PIM, Inventory

Confidential

Oracle PL/SQL Developer

Responsibilities:

• Involved in many major CR’s development
• Provided SIT and UAT Support.
• Played a Key Role in improving the current process.
• Providing Adhoc Reports
• Used materialized views for remote instances.
• Wrote Unix Shell Scripts to process the files on daily basis like renaming the file, extracting date from the file, unzipping the file and remove the junk characters from the file before loading them into the base tables.
• Involved in the continuous enhancements and fixing of production problems.
• Created PL/SQLstored procedures, functions and packagesfor moving the data from staging area to main tables.
• Worked with DBA for getting trace files
• Involved in data loading usingPL/SQLandSQL*Loadercalling UNIX scripts to download and manipulate files.
• Review and test projects for Section 508 and WCAG 2.0 compliance.
• PerformedSQL and PL/SQL tuningand Application tuning using various tools likeEXPLAIN PLAN, SQL*TRACE, TKPROFandAUTOTRACE.
• UsedBulk Collectionsforbetter performanceand easy retrieval of data, by reducing context switching between SQL and PL/SQL engines.
• CreatedPL/SQL scriptsto extract the data from the operational database into simple flat text files usingUTL FILEpackage.
• Creation of database objects liketables, views, materialized views, procedures and packages using oracle tools likeToad, PL/SQL DeveloperandSQL* plus.
• Proactive monitoring of jobs
• Helped to DBA with long running queries
• Used profiler utilities for performance tuning
• Proactive follow-ups with other teams to resolve the issues faster
• Batch job automation with shell scripting
• System monitoring through auto mailer reports
• Used SQL Loader extensively with shell scripting in processing flat files in batch jobs and loading data into tables from flat files/ tables.

Environment: UNIX, Informatica, Obiee, Sap Bo, Teradata, Oracle 11g

Confidential

PL/SQL Developer

Responsibilities:

• Leading a team of 5 and coordinating and managing offshore database activities. Tasks assigned by onsite coordinator were logged as tickets to me. I was to manage completion of these on time with my team. I also conducted s and monitored team members and provided updates in daily status calls to onsite coordinator.
• Interacted with application team to understand functional requirements that were logged as tickets in Espresso and Radar.
• Developed/tuned complex procedures. This also involved developing database objects like procedures/packages, functions, triggers, dblinks, bulk updates/inserts. Also was involved in writing scripts for scheduling autosys jobs.
• Tuning activities involved looking through application logs generated by apps team and identifying the procedures that were time consuming or breaking, creating TKPROF and then tuning the same after analysis, analyzing AWR reports to identify bottle necks based on CPU utilization and elapsed time.
• Worked closely with a front JAVA team to make develop procedures as required. This also involved understanding which classes the procedure is being called, setting up local application environment to see input values being passed and performance tuning.

Environment: Mac OS X 10.5.3, Oracle 10g and 11g- PLSQL, SQL Developer, UNIX Scripting, Espresso, Radars, AWR Reports, Autosys jobs

Confidential

Oracle PL/SQL Developer

Responsibilities:

• Involved in configuration and processing designing of many new Service Requests.
• Represented CRM team in the meetings with business regarding Operational Issues.
• DevelopedMaster Detail reportsin Reports 6i to meet the requirements of end users within the system
• Played a Key Role in improving the current process.
• Coordinating with other Modules wrt to Interfacing issues
• Support to IVR, Scripting & SMS applications.
• Worked extensively on Dynamic SQL, Bulk loading, Bulk processing.
• Worked in Production Support Environment as well as QA/TEST environments for projects, maintenance requests, bug fixes, enhancements, data changes, etc.
• Performance tuning of Oracle Databases and User applications.
• Improved the performance of the application by rewriting theSQL queries.
• Wrote packages to fetch complex data from different tables in remote databases using joins, sub queries and database links.
• Involved in brain storming sessions with the Business Users to gather requirements.
• Prepared and Documented the technical specifications
• Prepared requirement traceability matrix in order to map the business requirements to functional specifications.
• Involved in knowledge transfer sessions for other dependent/cross functional and support teams to ensure that the application under development confined to the business requirements and any changes in design/requirement are communicated and shared.

Environment: UNIX, Oracle 9i, Forms 6i, Reports6i, Oracle CRM11i (Service contracts, Telesales)