Developer Oracle

Consultant Name: Sri Mridula Matta

Skill Set: OWB,Oracle Apex, PL/SQL Developer

Professional Summary:

• SQL developer with seven years of experience in analysis, design and development of

software applications in client/server environment using Relational Database concepts.

• Extensive experience in Oracle 10g,9i, 8i and hands on experience writing SQL

queries and PL/SQL Stored Procedures, Functions, Packages, Database Triggers,

Exception Handlers, Cursors, Database Objects and Collections, by using PL/SQL.

• Working knowledge of Oracle Apex.

• Experience in Front end development tools like HTML, JAVASCRIPT and XML.

• Experience in Core JAVA (Collection, Thread, Exception, Packages, Interfaces and

others), Servlet JSP.

• Experience in ETL tools with importing tables from different database or from flat files,

transform them according to target and finally load in target database.

• Proficient in creating bar graphs, charts, details and pages in Oracle Apex.

• Proficient in Oracle Tools and Utilities such as SQL Developer and Toad.

• Good knowledge in Unix Shell Script.

• Strong Data Warehousing concepts and capable of deriving Logical, Physical and

• Dimensional Data Models.

• Proficient with Oracle Forms and Reports 9i.

• Working experience in data modeling (Entity-Relationship and Dimensional Model) and

logical and physical database design

• Exposure to the entire process of Software Development Life Cycle.

• Expertise in Testing phase planning, preparation and execution.

• Excellent Interpersonal and Communication skills, coupled with strong technical and

problem solving capabilities.

Technical Skills:

• Operating Systems : Unix, Sun Solaris, HP UX, Red Hat Linux 3.0/4.0

Windows 2000/2003/XP

• RDBMS : Oracle 8i/9i/10g, SQL Server 7.0

• ERP : Oracle Applications 11i (11.5.8/11.5.9/11.5.10/11.5.10.2)

• DB Tools : SQL* Plus, SQL Server, SQL*Loader, Oracle Apex,

Export and Import.

• Data warehouse Tools : Oracle Warehouse Builder 10.

• Languages : PL / SQL, Java, Java Script.

200 S. Wacker Drive, Suite 3100

Chicago, IL 60606

www.senryo.com Phone 630-***-****

• Web Tools : Front Page and HTML, XML.

• Software Applications : MS Office, Dream Weaver MX, Adobe Photoshop, Visio, MS

Project

Professional Experience:

Piocon Technologies for Chevron Corp. – Oakbrook, IL Nov ’08 – Present

Data warehouse Developer & Apex Programmer

Details:

• Worked on Chevron’s OERI Implementation. Developed metrics for Chevron’s

refineries in El Segundo, Salt Lake City, Hawaii, Pembroke and Richmond.

• Used Oracle Warehouse builder 10g R2 and SQL Developer to perform DDL

scripting, modify tables, create views, materialized views, deploy mappings and

execute them.

• Extensively used Design centre (OWB Client) to create mappings and Control

Centre to execute them.

• Created and analyzed metrics for machinery which need ‘Preventive Maintenance’,

‘Operator Routine Duties’, ‘Process Control Days’ etc.

• Used various operators such as joiners, set operator, union, key lookups, constants,

de-duplicators, pivots and aggregators.

• Worked on Oracle Apex to create reports, bar graphs, pie-charts and details for

these above metrics.

• Wrote SQL and PL/SQL queries and packages to generate graphs and dials in Apex.

• Created pages with text fields, reports in Apex and wrote Java Script validation

against them.

• Extracted source data from Chevron’s different source systems like ‘Meriduim’,

‘Xans’ and ‘Passport’ and staged them.

• Analyzed spreadsheet and flat file data and automated the procedure of loading

thousands of rows to the database.

• Performed migration of SQL Scripts and tables from Dev to Test.

• Wrote triggers and sequences against tables to update table with IDs and pop up in

the bar graph to reflect rows once entered into the database.

• Performed data-load, data validation, data cleansing,data migration and pre-prod

support.

• Interacted with the client to gather requirements about different metrics.

Diebold Inc – North Canton, OH Sep ’07 - Sep ‘08

Oracle Developer

Details:

• Extensively worked in writing SQL Queries (Sub queries and Join conditions,

Co- related sub queries) .

200 S. Wacker Drive, Suite 3100

Chicago, IL 60606

www.senryo.com Phone 630-***-****

• Worked on Oracle Application Express (APEX) formerly called HTML DB which is a

rapid web application development tool for Oracle Database.

• Developed and deployed the application by creating a screen (with date, amount etc) and

a submit button to run the report using HTML DB tool.

• Wrote Stored Procedures, Functions, Packages etc. in SQL*Plus.

• Performed development and Testing of advanced SQL and dynamic PL/SQL code tuning

based code in support of Reports.

• Wrote database triggers for automatic updating of the tables.

• Worked in creation of Sequences for automatic generation of voucher numbers.

• Worked in creation of Views and Synonyms for hiding of actual Tables and Queries.

• Created indexes on tables and Optimizing Stored procedure queries.

• Developed and tested all the backend programs and update processes.

• Created Reusable Transformations and Maplets and used them in Mappings to develop

the business logic for transforming source data into target.

• Developed shell scripts for job scheduling.

University Hospitals, Cleveland, OH Jan ’07 - Aug ‘07

Oracle Data warehouse and PL /SQL Developer

Details:

• Performed program data extraction, data creation, updating multiple files using

Oracle procedure builder.

• Coded, tested, debugged critical batch programs.

• Designed and debugged several client-server applications for end users relative to

database access.

• Used Oracle packages like UTL_FILE to open, read and write files to OS

directories.

• Updated database, developed packages and form level triggers.

• Wrote numerous stored procedures, functions and database triggers.

• Used SQL tuning (cost-based optimization) to improve query performance; used

SQL trace, tkprof and explain plan

• Involved in creating web reports using Business Objects Web Intelligence

• Coded database nested queries used SQL and PL/SQL languages.

• Designed and developed business applications with Oracle Form Designer.

• Designed and developed several matrix and master-detail reports with Oracle

Report Designer.

•

De Lage Laden, Wayne, PA Jan 05 – Nov 06

Oracle PL/SQL Developer

Details:

• Imported data from flat files into the database using SQL Loader and external

tables (for moving data from excel files less than 2 GB)

• Developed database PL/SQL triggers, packages, procedures and functions to meet

the business rules for data consistency.

200 S. Wacker Drive, Suite 3100

Chicago, IL 60606

www.senryo.com Phone 630-***-****

• Used SQL tuning techniques like Explain Plan, SQL Trace and TKPROF for tuning

queries that took longer than anticipated.

• Designed and developed outbound interface to extract 401k deductions for all the

employees and 401k loan deductions (for all employees who have taken a loan)

within the specified dates and for a specific payroll name and transmit the data in

the required format to Putnam.

• Developed and modified the “Bi-weekly report” to retrieve the information of all

active restaurant managers by the various conditions provided and to be run on a

bi-weekly basis.

• Developed and modified various other reports like upcoming due reviews for all

corporate employees and for all the other employees filtered according to the

specified criterion

• Used reporting features like drill-through and drill-down.

• Used Oracle packages like DBMS_SCHEDULER in 10g to register jobs that

required to be executed at a particular frequency based on business logic.

• Oracle Packages like UTL_MAIL in 10g to maintain email using the SMTP

protocol.

TCS. Chennai, India Aug 03 – Oct 04

Oracle Developer

Details:

• Analyzed all business functionality related to back end database interfaces and utilized

PL/SQL developer tool in developing all back end database interfaces.

• Defined the Primary and Foreign keys for the Entities.

• Defined the relationships as the identifying and non-identifying relationships ensuring

integrity constraints.

• Developed various Oracle forms and reports for the business users using forms 6i and

reports 6i.

• Used JDBC as middle layer to connect to database to retrieve data from Oracle tables.

• Coordinated with frontend developer in making enhancements to the application.

• Analyzed and designed tables based on small and large database transactions.

• Developed complex reports based on oracle views using running totals, sub totals and

conditional formatting.

• Developed Corn shell scripts to kick off back end PL/SQL, SQL programs. Changes

made to improve performance or process of existing programs, using PLSQL advanced

technologies like Collections and Dynamic Cursors.

• Developed automated Corn shell scripts to schedule load of flat files on daily, weekly and

monthly basis.

• Prepared required reports using Oracle Discoverer tool. Responsible for performing code

reviews.

• Interacted and coordinated with various application teams for resolving issues, patch

movements.

• Responsible to keep production test machine in sync with production.

• Wrote test plan documents and unit testing for application modules.

200 S. Wacker Drive, Suite 3100

Chicago, IL 60606

www.senryo.com Phone 630-***-****

Education:

Bachelors Of Engineering in Computer Science and Engineering from Anna University

Reference:

Available on request.

200 S. Wacker Drive, Suite 3100

Chicago, IL 60606

www.senryo.com Phone 630-***-****

Contact this candidate