Sr Oracle PLSQL Developer & Analyst

Renuka Surikanti

Oracle PL/SQL Consultant

Phone: 201-***-****

Email: *******@*****.***

Summary of Experience:

Over 8 years of total IT experience in Business Requirements analysis, Application Design,Data Modeling,Datawarehousing,Coding,Development,Tuning,Testing,Oracle EBS and implementation of business applications with RDBMS,SQL,PL/SQL,Oracle Reports, UNIX Shell scripting, Java and J2EE.

Expertise in Oracle 10g/9i/8i/8.x,Oracle 9iAS, Oracle 10g AS, Oracle Forms and Oracle Reports.

Extensive experience in writing SQL Queries, PL/SQL procedures, functions, packages, Triggers, materialized views and front end java

Well experienced in Extracting, Transforming, and Loading (ETL) data for data warehouse, and data migration using excel spread sheets and flat files (CSV) data and other data conversions.

Worked on DML,DDL,TCL operations and used DLLs.

Experience in data modeling with Erwin.

Expertise in designing reports and forms using Reports 6i, Discoverer, Web and Forms 6i/9i.

Expertise in UNIX shells Scripting using korn, perl, sed, awk and scheduling using crontab.

Proficient in Oracle Tools and Utilities for Extraction, Transformation and Loading (ETL) such as Toad, SQL*Loader, Oracle streams and UTL_FILE.

Worked in Java, Servlets and JSP, JavaScript Struts Framework, JDeveloper, and XML.

Experienced in Database Optimization techniques like Performance Tuning or query tuning for Oracle RDBMS using Explain Plan and TkProf.

Experienced in Oracle RICE (Reports, Interfaces, Conversions and Extensions) development.

Worked on Financial Modules such as Account Payables, Account Receivables, Purchase Orders, General ledger.

Strong understanding of portfolio and FA performace management.

Adept at meeting deadlines, working under pressure and managing multiple tasks simultaneously.

Possess excellent communication skills and a smooth client handling and interaction with end user experience.

Strong proficiency in problem solving, Initiative taking, Time management.

Education Qualification:

Completed Bachelor of Engineering (Computer Science) from Osmania University, India

Achievements:

Perceived OCA (Oracle Certification Associate) (SQL, PL/SQL, Reports and Forms) Certification.

Perceived SCJP (Sun Certification Java programming) Certification.

Technical Areas of Expertise:

Platforms Windows 95/98/2000/NT/XP /Pro, UNIX and Linux

Languages SQL, PL/SQL, UNIX Shell( sed, awk, korn) Scripting, .Net,Java,J2EE and COBOL

Databases Oracle 8i/9i/10g, MS Access and SQL Server

Tools Forms 6i/9i, Reports 6i, TOAD , Quest, Crystal Reports, Rapid SQL, Informatica 7.1, Erwin

Utilities SQL* Loader, JDeveloper, SQL Navigator, Informatica, Formatter Plus,CVS,PVCS

Technologies ODBC, JDBC, and ADO , EDI

Web Tools HTML, XML, web toolkit, Mod PL/SQL, ASP, VBScript and JavaScript

App Servers Oracle 9iAS, Oracle 10g iAS,Apache, OC4J,IBM-Web Sphere, IIS, and Web logic

ERP Oracle Apps 11i : OM, INV,PO,AR, AP,AOL

Work Experience:

Edward Jones,St. Louis,MO Sr Oracle PLSQL Developer Nov’08-Present

Project: Data Migration and Reports

Responsibilities:

Involved in the business requirements gathering and analysis, understanding client’s requirements and system analysis.

Analyzed business process workflows and developed procedures for moving data from source to target systems.

Extensively involved in developing various PL/SQL Packages, Functions, Stored Procedures, Triggers and views.

Extensively worked on Cusrors,Refcusrsors,indexes,triggers,collections and bulk collections.

Developed Linux Scripts to automate data manipulation and data loading procedures.

Developed scripts for loading data from various systems using UNIX Shell, Oracle, PLSQL, SQL*Loader.

Involved in Performance Tuning using various tools provided by Oracle like SQL Trace and Explain Plan.

Created indexes, views to improve the performance of Pl/SQL procedures.

Provided technical leadership and complete complex system level assignments.

Developed and maodified complex procedures considering equipment capacity and limitations.

Scheduled batch jobs using Autosys and resolved the errors and alerts.

Formulated and defined system scope and objectives in Portfolio and FA Performance projects.

Prepared detailed software specifications and test plans.

Provided quality assurance reviews,conducted meetings with IS Management and end users.

Done research and prepared system time/cost estimates.

Performed Unit and integration testing of Target data.

Environment:SQL,PL/SQL,Oracle10g,Autosys,SCCS,UNIX Shell scripting,Linux Shell scripting, slick Edit,TOAD,SQL*Loader ,SQL*Plus.

CIENA Corporation, MD Oracle Developer Feb’08-Oct’08

Project: Oracle Applications Implementation

Responsibilities:

Requirements gathering, identifying business rules and Prepared technical Specs based on the user requirements and use cases.

Worked on logical and physical data modeling.

Worked on stored procedures and triggers.

Developed several Oracle Objects PL/SQL Packages, Procedures, functions to implement the business logic based on the type of labels for different customers.

Developed the Oracle Form for ship validation which will validate the correct numbers items shipping for each delivery or not.

Created and managed stored procedures, indexes,views, user defined functions, triggers, database constraints to meet business requirements and policies.

Worked on Cusrors,Refcusrsors,collections and bulk collections.

Developed Oracle reports and integrated with RTF files to get the required format properly.

Developed XML Reports, Discoverer reports.

Improved Query performance by using EXPALIN PLAN and TKPOF and SQL Trace tuning tools.

Developed UNIX Shell scripts using Kshell, awk, and sed execute the PL/SQL procedures and trap the errors and send mail using Mailx utility

Performance tuning of SQL, PL/SQL Procs using Explain Plan.

Debugged the PL/SQL procs using Toad debug utility.

Created Test plans for Unit Test, Regression Test ,UAT and reviewed the test cases with the team lead..

Done Data conversions for financial data.

Environment:SQL,PL/SQL,Reports 6i,Oracle 10g,SQL Server 2005,UNIX Shell scripting, Forms 6i,Discoverer Reports,XML Publisher Reports, SQL Navigator 5.0, Java,J2EE,Quest Software,TOAD,SQL*Plus, SQL*Loader, Oracle Applications 11i (OM,INV,Shipping,XML Publisher Administrator).

Smiths Medical, St Paul, MN Oracle Developer Nov’06-Dec’07

Project: Oracle Apps 11i implementation (Legacy system conversion and Reports):

Responsibilities:

Involved in high level design, development and implementation of all the interfaces.

Prepared program specifications for PL/SQL Packages, procedures, and functions to do the data cleansing, migration and conversion.

Designed and developed Oracle reports in modules involved in Order to cash flow.

Developed Control Files for loading staging tables from Flat Files using SQL*Loader.

Developed Pl/SQL Packages, procedures, functions to validate third party shipment file before posting into Store Order Processing System.

Wrote and integrated stored procedures to generate the special reports according to client’s need.

Participated in Performance Tuning using Explain Plan and TkProf.

Developed pseudo XML for inbound interface using informatica designer.

Have done UNIX shell scripting korn, awk, sed to process the data and scheduled them to run using crontab utility

Participated in Performance Tuning using Explain Plan and TkProf.

Performed Unit, Regression , System test and document test plan and test results.

24 X 7 On call production support

Converted financial data and inventory data.

Worked on tuning the SQL Queries by code review.

Developed and customized the front end interfaces for the users, using Forms 6i

Environment: SQL, PL/SQL, Oracle 10g, Oracle 9i AS, SQL*Plus, UNIX Shell scripting, Informatica, Reports 6i, Forms 6i, JDeveloper, Quest Software, SQL*Loader, TOAD, Oracle applications 11i (OM, INV, AP, AR, GL).

Apps Associates, Boston, MA Oracle Developer March’06-Oct’06

Project: Ship Console:Ship Console is an on top of oracle applications product in Apps Associates; it is useful for any Supply Chain Organizations.

Responsibilities:

Analysis of the specifications provided by the clients.

Created custom tables and triggers.

Worked on data modeling.

Developed Packages, procedures and functions to retrieve data from Oracle apps tables and updated in custom tables of the product.

Created the Pl/SQL tables ,Varrays and Records.

Worked on performance tuning on existing stored procedures and existing reports for the faster processing of reports.

Used the TOAD tool for data modeling and Designed ER-Diagrams for the product.

Developed the PL/SQL package and called the public API’s to ship confirm,Written Shell script to call OS commands from the Java.

Designed and Developed Oracle Reports to display product information in required format.

Developed the code in Java, given the Database connection and integrated the data base package with JSP front page of the Ship console product.

Developed front page using HTML and JSP code for AD-Hoc orders.

Written JavaScript for validation of business logic.

Tested the print labels and Performed tuning of SQL Queries.

Provide the functional inputs to Tech team for enhancements / Bug Fixes etc

Environment: Oracle 9i,Oracle 10g,SQL, PL/SQL, Quest Softwar, Oracle Applications 11i (Order Management), Apache Server, Tomcat, UNIX Shell Scripting, Java, J2EE, HTML, JSP, SQL*PLUS, SQL*LOADER, Toad, Rational Clear Case,UNIX, Discoverer 4i, Oracle streams, PL/SQL, Reports 6i, Forms 6i.

Kaz, NY, USA Oracle Developer Aug’05-Feb’06

Project: EMS (Expense Management System):Kaz believes the growth and prosperity of the Company depends on motivation, successes and achievements of their employees. We also feel that it is essential for all employees to work together as a team to guarantee success.

Responsibilities:

Created the PL/SQL procedures and packages for automation process of sending the notification to the manager to approve or reject the invoice.

Created the triggers to remove the hold on invoices if invoices are approved or remain the hold on invoices if invoices are rejected by the manager and developed form to show the information.

Created Purchase orders and invoices against each purchase orders to test the process.

Worked on the attachments to send the Invoice attachment to get approval from manager.

Created hundreds of attachments in testing process.

Created the hundreds of purchase orders and invoices against those Pos while testing the process.

Customized the product as per their requirements changed.

Solved the issues in production instance.

Environment: Oracle9i, UNIX, SQL, PL/SQL, SQL*PLUS, TOAD, SQL*Loader, Forms 6i.

Peach Direct, Los Angeles, CA Oracle Developer Feb’05-Jul’05

Project: Oracle Reports, Discoverer Reports

Responsibilities:

Designed and developed the 20 Oracle Reports as per the requirement.

Developed some of the reports in discoverer.

Displayed the information related to Sales orders, Customers, Purchase orders and vendors.

Created the DFF fields and assigned the values to the DFF fields

Worked on Oracle 10g database for discoverer reports.

Created the concurrent program for each report.

Created the required parameters to the reports and assigned the default values provided by the client and tested.

Environment: Oracle Reports 6i, SQL, PL/SQL, Oracle 10g Database, Oracle 10g AS, Discoverer Reports, TOAD,SQL Navigator, Formatter Plus, Oracle Applications 11i.

Apps Associates, Boston, MA, USA Oracle Developer Oct’03-Jan’05

Project: Ship Console

Responsibilities:

Detailed designing of product for accessing data base i.e., Oracle Order Management using UML.

Worked on logical and Physical data modeling.

Developed the code using database objects in PL/SQL and integrated the objects with the java objects to insert and get the header, line, package information in order management.

Developed HTML and JSP pages.

Written java script for validation of business logic.

Developed the java code for Label printing to print the different format of templates in different printers.

Developed Shell script to activate OS commands for printing and called the shell script from java bean file.

Written UNIX shell script to connect to the printer for print labels.

Tested the product by giving the different delivery ID and ship confirmed the deliveries through product.

Environment: SQL, PL/SQL, UNIX shell scripting, Oracle application 11i (Order management), Java, JSP, Servlets, Java script, HTML, Socket Programming, Toad, Formatter Plus, Struts Framework,JDeveloper,Tomcat,Apache server.

Stryker, Cambridge, MA Programmer/Analyst Jun’02-Sep’03

Project: Legacy system conversion to Oracle Apps:

Responsibilities:

Analyzed the legacy data received from client and Involved in the high level designing.

Prepared Conversion templates with the oracle values.

Created the tables and indexes for fine-tuning and maintenance of the database.

Developed Packages and Procedures in PL/SQL for Map Info (mapping the data values), validating and loading the legacy data of various modules into Oracle Applications 11.5.10.

Written SQL queries in TOAD and Stored Procedures for testing the process.

Tuned the performance of the programs for smooth running and better efficiency.

Created technical design documents.

Environment: SQL, PL/SQL, Oracle 9i, UNIX shell scripting, Oracle application 11i, Toad, SQL Navigator, Formatter Plus and FTP.

Contact this candidate