SUMMARY

• 9+years of experience in IT industry with emphasis on Analysis, Design, Development, Implementation and Managementof projects usingOracle (Sql, PL/SQL), Forms and Reports 6i/9i/10g/11g.
• Solid experience in translating business requirements into creation of Database Objects.
• 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
• Extensively used Sql*Loader for loading data into tables
• Automated nightly Batch Summary reports, converting 3½-hour manual task to two minute automated process, using UNIX shell scripts and utilities, resulting in considerable manpower savings.
• Worked on Forms Triggers, Alerts, Data Blocks, LOVs, and Parameters, visual attributes, object libraries and Program units by using PL/SQL procedures and functions of OOPS methodology.
• Analyzed, designed and developed Oracle forms 10g, layout, report triggers, parameter form, data models etc.
• Developed Complex Forms andReportsusingOracle Forms/Reports6i/9i/10g builder.
• Extensively worked on debugging & Testing of the forms to find out the root cause.
• Experience in creating master detail forms and adding alerts.
• Experience in compiling the FMBs using UNIX shell script and deploying forms and reports on the application server.
• Experience in developing forms based on views, tables and procedures in tabular and form layouts.
• Extensively worked on form triggers like Pre-Form, Pre-Block, Pre-Record, Pre-Text-Item, When-New-Form-Instance, When-New-Block-Instance, When-New-Record-Instance, When-New-Item-Instance etc.
• Extensive experience on using SQL, PL/SQL, ORACLE Database, and many other ORACLE facilities, such asImport/Export, SQL*Loaderand SQL*PLUS.
• Proficient intuning queriesused in the application.
• Experience in advanced PL/SQL concepts likeBulk collectandForall.
• Expertise inDynamic SQL, Records, Arrays and Exception Handling.
• Very Good experience withUNIX Cron Jobs,Batch Processing
• Experience withPerformance Tuningfor Oracle RDBMS usingExplain PlanandHINTS and also worked on CBO & RBO.
• Significant experience working with clients, technical teams for executing concurrent multi-technology projects.
• Possess excellent oral / written communication and interpersonal skills.
• Good ability to quickly grasp and master new concepts and technologies.
• Strong problem solving & technical skills coupled with confident decision making for enabling effective solutions leading to high customer satisfaction and low operation costs.
• Significant experiencein24/7 ProductionEnvironment Support.
• Excellent expertise in Shell and Unix programming
• Exceptional understanding of inheriting, casting and converting PL/SQL objects
• High proficiency in developing Oracle PL/SQL packages
• Expertise in working with built-in packages like DBMS LOB, DBMS SQL, DBMS SHEDULER, DBMS DDL, UTL FILE
• Good knowledge in front end development usingoracle forms/reports6i/9i/10g.
• Developeddata entry forms, complex and template forms in Forms 6i.Creation of Pop-up Menus and maintaining Master Detail relation-ship.
• Used variousLOVS(List of Values) and record groups at various points in runtime.
• DevelopedMaster Detail, Detail reports usingtabular and Group above reports.
• DesignedReportoutput formats, complex filtering and formula calculations, as well as the rendering of multi-band and multi-grouped reports.
• Developedcomplex triggersinreportsbefore/after for validation of user input.
• DevelopedForms Screensused by Oracle Developer Suite forforms procedures, functions and packagesgenerate to end product of forms.
• Analyzed data, designed and developedOracle forms 10g queries, layout, report triggers, parameter form, data modelsetc.
• Worked on FormsTriggers, Alerts, Data Blocks, LOVs, Parameters, and Program unitsby using PL/SQL procedures and functions
• Programed inUNIXshell scripts to provide a user interface toOracle formsandreports.
• Created Cron jobs inUNIXfor scheduling file preprocessing.
• Oracle Forms developed and deployed in allUNIX environmentthrough Dev, Test, and Prod in an Oracle Applications environment.

TECHNICAL SKILLS

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

Scripting: UNIX Shell Scripting and JavaScript.

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

Languages: PLSQL, XML, HTML, CORE JAVA, UNIX, C, C++, Pro*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

Other Knowledge: Hadoop, Tableau, Informatica9.x, Cognos10.x, Sap BO

PROFESSIONAL EXPERIENCE

Confidential, North Brunswick, NJ

Oracle PL/SQL Developer

Responsibilities:

• Creation and Enhancements in PL/SQL code for Packages.
• Created shell scripts and updated the scripts as per the requirement.
• Developed scripts for inbound and outbound of the data on servers.
• Experience in deploying forms and reports on the application server.
• Created Tables, Views, Constraints, Index (B Tree, Bitmap and Function Based).
• Doing Impact Analysis and prepared impact Analysis document.
• Developed customizedFormslike customer and supplier maintenance, bill, receipt, invoice, debit and credit notes.
• Involved in Unit Testing, Integration Testing and UAT Testing.
• Extensively used the form level triggers, block level triggers & item level triggers.
• Developing forms based on views, tables and procedures in tabular and form layouts.
• Worked on forms customization as per the business requirements.
• Involving in daily scrum calls and provides the status update in project meetings.
• DevelopedReports and PL/SQL Packagesto monitor revenue earnings and expenses.
• Preparing technical document from functional document.
• Provided data fixes for existing data.
• Responsible for Data Migration to CRM.
• Tuned some time taking queries.
• Worked on Performance Tuning.
• Test case Reviews and unit testing.
• Involved in Customizing and development of Reports as per the requirement.
• Extensively worked on Oracle supplied packages, Dynamic SQL, Records and PL/SQL Tables.
• Loaded Data into Oracle Tables using SQL Loader.
• Performed performance tuning using the DBMS PROFILER package, this checks the run time behavior.
• Atomized routine jobs using DBMS JOB. On completion of these jobs an email will be sent out automatically with the help of UTL MAIL.
• Experienced with Oracle Supplied Packages such as UTL FILE.

Environment: Oracle 11g/10g, SQL, PL/SQL, SQL*Loader, Data Pump, Forms 10g, Reports10g, Erwin, Informatica, SQL Developer, SQL Navigator, TOAD, UNIX/LINUX, Windows

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.
• Involved in the up gradation of the database from oracle 9i to oracle 10g.
• Prepared the Unit test plans and Integration Test plans.
• 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.
• Involved in data loading usingPL/SQLandSQL*Loadercalling UNIX scripts to download and manipulate files.
• 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
• 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, Oracle 10g, Forms 10g, Reports10g, Informatica, Obiee, Sap Bo

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.
• Prepared Non-Functional testing report after every deployment
• 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.
• 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 Training and Presentation to Clients and New team Members.

Environment: UNIX, Oracle 10g, Forms 9i, Reports9i, Oracle Apps R12, PIM, Inventory

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.
• Provided SIT and UAT Support.
• Production Support and Enhancements to CRM End Users
• Monitoring scheduled jobs
• Providing Adhoc Reports
• Bug fixes and Performance Tuning
• Coordinating with Oracle CRM Vendors
• 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
• Implemented the solution as per the business requirements.
• 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)