Haritha Email: adhd71@r.postjobfree.com

Oracle Developer Tel: 786-***-****

Profile Summary:

** ***** ** ** ********** in Design, Development, Customization, Integration and Implementation of client/server application using Oracle 9i/10g/11g/12c (SQL, PL/SQL Packages, Procedures, Functions and Triggers)

Possess strong communication and problem solving skills developed through a variety of projects.

Offer proven abilities in team leadership and proactive systems support.

Five years of IT industry experience in designing and developing end-to-end solutions.

Extensive experience as Oracle Developer in utilizing PL/SQL procedures, functions, packages, triggers, shell scripting, unit testing and also involved in data extraction, transformation and loading operations on oracle using SQL Loader

Experience in using Oracle Analytical functions for simplifying complex analytical queries.

Experience in performance tuning and SQL optimization using (Hints, Explain Plan, Tkprof), restructuring tables, redesign database, de-normalize tables and Materialized views.

Having good knowledge in Data Transformation and Loading using SQL Loader utility and External Tables.

Hands- on experience in all stages of system development efforts, including requirement analysis, design, testing and implementation.

Experience working on PowerShell scripting.

Fair Knowledge of Oracle9i/10g/12c installations and database creations on Windows 2000/2003 servers.

Experience in developing and modifying the UNIX shell scripts.

Extensively developed PL/SQL procedures using Ref cursors and collections with bulk bind to insert and update millions of rows into target tables.

Worked on both Agile and Waterfall model.

Fair knowledge on dimensional data modeling.

Fair knowledge in data ware housing concepts like SCD, Star Schema, metadata.

Proficiency in minor database administration skills like creating users and dropping schemas

Experience in Developing and customizing PL/SQL packages, procedures, functions and triggers

Fair troubleshooting skills of various PL/SQL bugs and extensive knowledge of data corrections

24/7 production support and involved in implementation of coding standards and Data Base change requests

Self-motivated, creative team player with effective communication and Leadership qualities.

Technical Skills:

Operating Systems: Windows 98/2000/NT 4.0/XP, Linux, UNIX.

Databases: Oracle 12c/11g/10g/9i, SQL Server 7.0/2000, My SQL, MS Access (98, 2000, 2002, XP)

Languages: PowerShell, C, C++, SQL, PL/SQL, T-SQL JAVA with JDBC, Perl

DB Utilities: TOAD, SQL Navigator 4.1/5.1, SQL Developer, SQL Loader

Utilities & Packages: Microsoft Project, MS Office XP, 2000 & 97, MS Visio, MS word, MS Excel.

ETL and Reporting: Informatica, Data Stage, SQL loader, BO

Data Modeling Tools: Erwin, Embarcadero

Web Technologies HTML, ASP, JSP, CSS

Education:

Bachelor of Technology, KL University, India. 2004-2008

Masters in Management, Kentucky 2013-2014

Professional Experience Summary:

Project #1 Nov’15- Current

Client : Charter Manufacturing

Project Type : Enhancement and Support

Role : Oracle Programmer Analyst

Location : Mequon, WI

Description:

Charter Manufacturing Company, Inc. is a family-owned steel and iron production and manufacturing company. It has four divisions Charter Steel, Charter Wire, Charter Automotive and Charter DuraBar. I supported oracle implementations at these divisions.

Responsibilities:

Interacted with the Business Users and Project Management for analyzing the business needs and develop Design Specification.

Working with cross-functional teams studying the impact analysis and was involved in converting the business requirements into technical design document.

Developed Stored Procedures, packages, Functions and Triggers using PL/SQL to implement day to day modified business rules into the current system.

Coordinating with users in functional areas for changes and amendments to the system for its improvement.

Create partitioned tables & moving data from non-partitioned tables to partitioned tables.

Created views and materialized views to resolve complex queries.

Added/Changed Tables, columns and triggers.

Executed deployment of database schema and code modules.

Extensively developed PL/SQL procedures using Ref cursors and collections to insert and update millions of rows into target tables.

Strong analytical ability and experience in developing, testing and troubleshooting SQL Queries.

Tuned long running queries using explain Plan, TKPROF, SQL TRACE, ANALYZE, HINTS etc.

Creating PowerShell scripts for ad-hoc batch jobs.

Performed Database Normalization.

Performance tuning SQL statements and PL/SQL packages using Explain Plan and OEM GRID Control.

Created and modified Oracle PL/SQL, SQL statements, procedures and functions that are called in front-end applications developed using ASP.NET, C#, VB.NET, Visual Basic 6.0.

Created customized functions & SQL queries for reports developed using Crystal Reports.

Created pipelined functions and custom objects for communication between server and client calls.

Involved in Debugging, Troubleshooting Procedures, functions, packages, customizing the existing ones.

Converted and loaded data from flat files, CSV & Pipe delimited files to temporary tables in Oracle database using SQL*Loader & External Tables.

Automated scripts that we use on daily basis using PowerShell

Worked with DBA team to resolve environmental & performance issues.

Uploaded all the business related documents to SharePoint.

Assisted in developing test scenarios, test scripts, and test data to support unit and system integration testing.

Involved in comprehensive testing of the system to check it satisfies the Functional Specifications.

Environment: Windows 10, Oracle 12c on Linux, PL/SQL procedures, functions, packages, triggers, SQL*Loader, SQL* PLUS, TOAD, Oracle SQL Developer, SharePoint, Crystal Reports, Mantis, Remedy, Rally, SVN, Remedy System, UNIX Shell scripting, Agile / Scrum environment.

Project #2 Jan’14- Dec’14

Client : UPS

Role : Sr.Oracle Developer

Location : Ramsey, NJ

Description:

United Parcel Service of North America is one of the largest shipment and logistics companies in the world. UPS provides the expertise and the scale to meet the total supply chain needs of customers worldwide, whether it requires the movement of goods, information or funds. UPS delivers more than 15 million packages a day to more than 6.1 million customers in more than 220 countries and territories around the world. This project used Agile/Scrum methodologies extensively.

There are quarterly releases that provide with enhanced application features and fixing of existing bugs. These releases mostly comprise of enhanced development strategies for performance and new modules that we provide in the EPC application.

Responsibilities

Implemented several packages, Procedures, Functions and Triggers for data transformations in the existing database.

Interacted with the Business Users and Project Management for analyzing the business needs and develop Design Specification.

Developed DDL Scripts for generating Tables, Views, and Functions etc.

Added/Changed Tables, columns and triggers.

Worked extensively with the Front-end Application team to develop the Oracle Views.

Strong analytical ability and experience in developing, testing and troubleshooting SQL Queries.

Created Indexes to speed up the queries.

Provided Low level requirements and Technical designs for Database redefinition.

Performed Database Normalization.

Created Global temporary tables to maintain session data and also to hold temporary data.

Performance tuning SQL statements and PL/SQL packages using Explain Plan and OEM GRID Control.

Involved in Debugging, Troubleshooting Procedures, functions, packages, customizing the existing ones.

Converted and loaded data from flat files, CSV files to temporary tables in Oracle database using SQL*Loader.

Extensively used UTL_FILE package, external tables to write data from flat files to Oracle Database.

Extensively developed PL/SQL procedures using Ref cursors and collections with bulk bind to insert and update millions of rows into target tables.

Executed deployment of database schema and code modules.

Developed and modified several power shell scripts.

Worked with DBA team to resolve environmental & performance issues.

Worked with DBA team to generate trace files & convert them by using TKPROF.

Involved in maintaining the Accurev, importing and exporting from Accurev and updating the design documents for the code changes.

Responsible for User training and taking write-offs of User Acceptance Tests.

Reporting on a daily basis to the project manager.

Environment: Windows XP, Oracle 12c/11g on Solaris, PL/SQL procedures, functions, packages, triggers, SQL*Loader, SQL* PLUS, Oracle APEX, TOAD, PL/SQL Developer, Accurev, UNIX Shell scripting.

Project #3 May’12- Apr’13

Client : Petrofac

Role : Oracle PL/SQL Developer

Location : Houston, TX

Description:

Petrofac is an international provider of integrated facilities services to the oil, gas and energy production and processing industries. Petrofac is mainly into two business units. One Engineering, Construction, Operation and Maintenance, the other Integrated Energy Services.

Responsibilities

Interacting with the Business Users and Project Management for analyzing the business needs and develop Design Specification.

Working with cross-functional teams studying the impact analysis and was involved in converting the business requirements into technical design document.

Developed Stored Procedures, packages, Functions and Triggers using PL/SQL to implement day to day modified business rules into the current system.

Coordinating with users in functional areas for changes and amendments to the system for its improvement.

Create partitioned tables & moving data from non-partitioned tables to partitioned tables.

Created views and materialized views to resolve complex queries.

Added/Changed Tables, columns and triggers.

Executed deployment of database schema and code modules.

Extensively developed PL/SQL procedures using Ref cursors and collections with bulk bind to insert and update millions of rows into target tables.

Strong analytical ability and experience in developing, testing and troubleshooting SQL Queries.

Tuned long running queries explain Plan, TKPROF, SQL TRACE, ANALYZE, HINTS etc.

Creating shell scripts for ad-hoc batch jobs.

Performed Database Normalization.

Performance tuning SQL statements and PL/SQL packages using Explain Plan and OEM GRID Control.

Involved in Debugging, Troubleshooting Procedures, functions, packages, customizing the existing ones.

Converted and loaded data from flat files, CSV files to temporary tables in Oracle database using SQL*Loader.

Worked with DBA team to generate trace files & convert them by using TKPROF.

Assisted in developing test scenarios, test scripts, and test data to support unit and system integration testing.

Involved in comprehensive testing of the system to check it satisfies the Functional Specifications.

Environment: Windows 7, Oracle 10/11g on Linux, PL/SQL procedures, functions, packages, triggers, SQL*Loader, SQL* PLUS, TOAD, Oracle SQL Developer, Mantis, Remedy System, UNIX Shell scripting.

Project #4 Jun’11- Apr’12

Client : Petrofac

Role : Oracle Developer

Location :

Description:

Petrofac is an international provider of integrated facilities services to the oil, gas and energy production and processing industries. Petrofac is mainly into two business units. One Engineering, Construction, Operation and Maintenance, the other Integrated Energy Services.

Responsibilities

Developed DDL Scripts for generating Tables, Views, and Functions etc.

Added/Changed Tables, columns and triggers.

Developed Views, PL/SQL procedures, functions, packages and Triggers.

Strong analytical ability and experience in developing, testing and troubleshooting SQL Queries.

Created Indexes to speed up the queries.

Creating UNIX shell scripts for ad-hoc batch jobs.

Performed Database Normalization.

Performance tuning SQL statements and PL/SQL packages using Explain Plan and OEM GRID Control.

Involved in Debugging, Troubleshooting Procedures, functions, packages, customizing the existing ones.

Converted and loaded data from flat files, CSV files to temporary tables in Oracle database using SQL*Loader.

Extensively used UTL_FILE package, external tables to write data from flat files to Oracle Database.

Extensively developed PL/SQL procedures using Ref cursors and collections with bulk bind to insert and update millions of rows into target tables

Extensive experience in designing and development of Reports (9i/10g).

Created Javascripts for web pages.

Executed deployment of database schema and code modules.

Designed and developed several web pages using HTML.

Developed and modified several UNIX shell scripts.

Involved in maintaining the PVCS, importing and exporting from PVCS and updating the design documents for the code changes.

Responsible for User training and taking write-offs of User Acceptance Tests.

Reporting on a weekly basis to the project manager.

Environment: Windows XP, Oracle 10g on Linux, PL/SQL procedures, functions, packages, triggers, SQL*Loader, SQL* PLUS, Oracle Reports(10g), TOAD 8/9, SQL Navigator, HTML, PVCS Tracker, UNIX Shell scripting.

Project #5 Jul’10- May’11

Client : United States of Pharmacopeia

Role : Oracle Developer

Location : Rockville, MD

Description:

USP sets standards for food ingredients and dietary supplements.USP establishes written (documentary) and physical (reference) standards for medicines, food ingredients, dietary supplement products and ingredients. These standards are used by regulatory agencies and manufacturers to help to ensure quality. The company migrated from Tally and decided to implement Oracle Applications R12 and implemented modules OM, PO, INV, AP, AR and GL.

Responsibilities

Interacting with the Business Users and Project Management for analyzing the business needs and develop Design Specification.

Developed DDL Scripts for generating Tables, Views, and Functions etc.

Added/Changed Tables, columns and triggers.

Developed Views, PL/SQL procedures, functions, packages and Triggers.

Strong analytical ability and experience in developing, testing and troubleshooting SQL Queries.

Strong exposure to HR Applications and experience in developing the reports on HR data both using the SQL queries and ETL tools.

Developed new hire report, Seasonal Hire Report, wages and tax info reports and modified the existing SQL reports.

Created Indexes to speed up the queries.

Creation of Stored Procedures for Batch Processing.

Skills and experience in a very-large-database environment

Performed Database Normalization.

Involved in the optimization of query performances i.e. performance tuning using TK Prof and Explain Plan

Involved in Debugging, Troubleshooting Procedures, functions, packages, customizing the existing ones.

Created views to resolve complex queries.

Developed SQL Loader scripts.

Helped the front end application developers with their queries.

Extensive experience in creating, designing Oracle forms (10g) generating Reports (9i/10g).

Executed deployment of database schema and code modules.

Designed and developed several web pages using HTML.

Oracle-to-Oracle data loading using UNIX shell scripts and PL/SQL.

Developed and modified several UNIX shell scripts.

Managing important CRONTAB jobs.

Involved in maintaining the PVCS, importing and exporting from PVCS and updating the design documents for the code changes.

Responsible for User training and taking write-offs of User Acceptance Tests.

Reporting on a weekly basis to the project manager.

Environment: Windows NT/2000/XP, Oracle 9i/10g on Linux, PL/SQL procedures, functions, packages, triggers, Windows 2000/XP, SQL*Loader, SQL* PLUS, Perl, Oracle Reports(10g), TOAD 8/9, HTML.

Awards & Recognition:

Received BRAVO Award as a token of appreciation.

Project #6 Feb’09- June-10

Client : FLSmidth

Role : Oracle Developer

Description:

FLSmidth’s cement business has always been the core activity. The major cement projects are handled by four FLSmidth Project Divisions which each cover their particular geographical region. Two project divisions are placed at FLSmidth’s main office in Valby, Denmark, one project division is located in Bethlehem, Pennsylvania, USA and one project division in Chennai, India.

Responsibilities

Working with cross-functional teams studying the impact analysis and was involved in converting the business requirements into technical design document.

Developed Stored Procedures, packages, Functions using PL/SQL to implement day to day modified business rules into the current system.

Coordinating with users in functional areas for changes and amendments to the system for its improvement.

Processed new accounts for customers and assisted existing customers with account maintenance.

Involved in development and customization of Oracle forms (4.5/6i) and reports (2.5/6i).

The front end consists of Oracle Web forms that allow the users to login and enter input the input processing information such as filename, date, month, and year and submit the form for the load process.

Created views and materialized views to resolve complex queries.

Worked with Developer/2000 Reports Designer to develop reports for validating data in system tables.

Worked with Developer/2000 forms to develop and modify the existing forms.

Responsible for User training and taking write-off’s of User Acceptance Tests.

Involved in using power builder to develop and deploy client/server applications.

Adherence to reporting procedures to provide information to Corporate Office from all regions.

Executed deployment of database schema and code modules.

Developed SQL Loader scripts for loading data from varying resources and inserting the master data into tables.

Implemented triggers to enhance functionality, supplement validation, and default transaction Processing.

Tuned the queries to improve the performance using Explain Plan, TK Prof, Auto Trace utilities, assessed the efficiency of the code modules.

Daily Backups of transaction logs and Scheduling Jobs to perform this task.

Involved in developing the ETL mappings using Informatica.

Performed database Normalization and de-normalization tasks.

Involved in developing the UNIX scripts.

Developed cronjob scripts, shell scripts for running batch jobs

Involved in maintaining version control tools like SCM (Source Control Mgmt) and Serena.

24/7 production support.

Environment: Oracle 9i on Windows 2000/XP/Unix, PL/SQL procedures, functions, packages, triggers, Shell scripting (korn shell), SQL*Loader, SQL* PLUS, Oracle Forms (6i), Reports (10g), TOAD, SQL Navigator.

Project #7 May’08- Jan’09

Client : Pfizer

Project Type : Production Support

Role : Oracle Consultant

Description:

Pfizer, Inc., American multinational pharmaceutical corporation headquartered in New York City. They implemented Oracle product called Oracle Clinical (OC) and Oracle Thesaurus Management System (TMS). This project focuses on production enhancements and production support.

Responsibilities:

Responsible for design and development

Responsible for writing database triggers to validate business logic using PLSQL

Coded Reports and programs to support Billing functions in SQL, Oracle Reports 2.5 and PLSQL.

Developed packages, procedures, and functions.

Developed java scripts for validating the data.

Developed various forms for client’s application using Developer/2000.

Developed GUI standards for fonts, text box, buttons etc using visual attributes and property classes.

Developed scripts using UNIX shell scripting (korn shell)

Query optimization through the use of diagnostic tools like Explain Plan.

Written several scripts to validate data in staging tables and developed SQL*Loader control files to load the data from flat files into the staging tables.

Executed deployment of database schema and code modules.

Developed scripts to validate correctness of data.

Assist in developing test scenarios, test scripts, and test data to support unit and system integration testing.

Involved in comprehensive testing of the system to check it satisfies the Functional Specifications.

Provided Customer Support.

Responsible for User training and taking write-offs of User Acceptance Tests.

Environment: Oracle 8i on Windows 2000/XP/Unix, PL/SQL procedures, functions, packages, triggers, Oracle Forms(6i), Reports (10g), Java scripting, Perl, C, C++,TOAD, SQL Navigator, CSS.

Awards & Recognition:

Received BRAVO Award for this project as a token of appreciation.

Contact this candidate