We provide IT Staff Augmentation Services!

Oracle Resume

Birmingham, AL

Professional Experience:

  • Total IT experience of 7.5 years in Application Design & Development, Analysis, Performance Tuning, Testing and Production Support using Oracle database, SQL, PL/SQL, Oracle Applications Release 11i and UNIX.
  • Proficient in developing various Interface programs and APIs for migration of client’s data into the respective CRM financial modules like Accounts Receivables, Accounts Payables, Oracle Purchasing etc.
  • Worked extensively on development of Oracle PL/SQL Packages, Stored procedures, Functions, Triggers, Cursors and Ref Cursors. Also developed various applications using Oracle in-built packages.
  • Experience in Data Migration processing including data loading from flat files to the Oracle database tables using SQL*Loader.
  • Worked on Production Support, receiving production calls on troubleshooting the application and resolving bugs.
  • Used Toad as an advanced SQL - PL/SQL editor for developing PL/SQL Packages, Stored procedures, Triggers, and Functions.
  • Created and modified database tables, views, indexes, constraints, and users.
  • Experience in Tuning SQL statements using EXPLAIN PLAN and TKPROF to improve the performance.
  • Developed Test Scripts using Mercury WinRunner tool for testing the application.
  • Developed custom reports as per business requirements using Oracle Reports 6i.
  • Customized existing custom Forms in the application as per the business logic using Oracle Forms 6i.
  • Extensively worked on Microsoft Office Applicationslike Word, Excel, PowerPoint, and Access.
  • Ability to work in teams and independently with minimal supervision to meet deadlines.
  • Good communication, analytical and Interpersonal skills.
Technical skills:

Database Oracle 11g/10g/9i/8i/7.x MS-Access
Languages SQL, PL/SQL, MySQL, HTML, XML,C, C++
ERP Packages Oracle Applications Release 11i
Tools TOAD, SQL Navigator, SQL Developer, Erwin, Mercury WinRunner
Reporting Tools Oracle Forms and Reports 6i.
SQL Utilities SQL*Loader, Export, Import
Office Applications Microsoft Office (Word, Excel, PowerPoint, Access)

Operating System Windows XP/2000/NT/98

Academic Qualification:

Bachelor of Engineering in Computer Science

Professional Experience

Confidential, Jan ’11 - Present
Birmingham, AL
Senior Oracle Developer
Executive Information System (EIS):- The EIS Phase 1 system is primarily a proof of concept for a full featured dashboard application providing enterprise-wide data to the executives of BBVA Compass. The intent of the project was to design and develop a dashboard that will display the key performance indicators, graphs, charts and/or reports which are the most important to the top executives within the company in an easily understandable format that is user-friendly and easily navigable.

Responsibilities:

  • Involved in writing Data Migration scripts to load database successfully
  • Creation of database objects like Tables, Stored Procedures and Packages using Oracle tools like SQL Developer, SQL* Plus, Toad
  • Involved in creating database Triggers, Views and Materialized views based on the client requirements.
  • Used Exception Handling extensively for the ease of debugging and displaying the error messages in the application.
  • Understanding the business logic to modify existing procedures and did Performance Tuning using Explain Plan and TK-PROF Utility.
  • Used Collections with Bulk Collect and FORALL features to improve the performance of data manipulation code.
  • Involved in writing procedures, functions, triggers, and packages for new business requirements.
  • Developed new and customized existing business reports using Oracle Reports 6i as per business requirements.
  • Analyzed tables and created indexes to improve performance.
  • Involved in existing code reviews, Technical documentation, Unit testing, Integration Testing and writing Test plan.

Environment: Oracle 11g, PL/SQL, SQL* Plus, SQL * Loader, TOAD, Oracle Reports 6i.

Confidential, Tampa, FL Nov ’09 - Dec ‘10
CMS Compliance Metrics
Oracle PL/SQL Developer

Center for Medicare Services (CMS) has specific timeline requirements that must be met for compliance and the ability to conduct business.WellCare needs to construct an infrastructure allowing for accurate reporting of any Medicare member and where they are at any given time in that timeline.
This project delivers a two table solution composed of all the attributes requested by the business for tracking and reporting on Medicare members. The process will leverage the results of several external processes to build and maintain basic source data for Medicare membership.
Responsibilities:

  • As a team member interact with Business Analysts, Data architect and client representatives for requirements gathering, research and solving client specific data issues.
  • Created different schemas and maintained schema objects.
  • Wrote PL/SQL Overloading Stored Procedures, Functions, and Packages to enforce business rules.
  • Extensively used Cursors, Ref Cursors and Exceptions in developing Packaged Procedures and Functions.
  • Created control file scripts and used SQL* Loader to load data into the staging table.
  • Involved in data modeling and database design using ERwin tool.
  • Implemented complex Interface business rules using Oracle Database Triggers constructs
  • Extensively used INDEXES and HINTS for better performance of queries.
  • Optimized SQL and PL/SQL performance using Oracle utilities like Explain Plan, SQL-Trace Analysis and TK-Prof.
  • Extensively wrote UNIX Shell scripts toautomatethe data load from SQL* Loader to staging table.

Environment: Oracle 9i, Oracle 10gR2,ERwinSQL, PLSQL, TOAD.

Confidential, Oct ‘08 – Oct ‘09
Automated Client Eligibility System (ACES) Data warehouse
Oracle PL/SQL – ETL Developer

ACES is used to determine eligibility for public assistance programs, issue benefits, fraud investigation, and interfaces with multiple state and federal agencies. The ACES system has over 200 million transactions per year. ACES is the first system to be added to the Data Warehouse other one being NECSES (New England Child Support Enforcement System). This module of data warehouse involves getting the data from the source system (ACES) and doing data conversion in accordance with the business rules before loading into the respective database tables.
Responsibilities:

  • As a team member interacted with Business Analysts, Data architect and client representatives for requirements gathering, research and solving client specific data issues and data modeling.
  • Created different schemas and maintained schema objects
  • Wrote PL/SQL Overloading Stored Procedures, Functions, Packages and Package Constructors to enforce business logic
  • Extensively used UTL_FILE an oracle built in function to transfer data from the source system to flat files to conversion staging area.
  • Extensively used EXTERNAL TABLES for data conversion in staging area before loading the data into the respective dimensional tables and fact tables.
  • Extensively used Cursors, Ref Cursors and Exceptions in developing Packaged Procedures and Functions.
  • Implemented complex Interface business rules using Oracle Database Triggers constructs
  • Extensively used INDEXES AND HINTS for better performance of queries.
  • Optimized SQL and PL/SQL performance using Oracle utilities like Explain Plan, SQL-Trace Analysis and TK-Prof
  • Used oracle built in function DBMS_SCHEDULER to run jobs in parallel to improve time-constrained performance.
  • Responsible for data conversion activity for System Integration and User acceptance testing
  • Involved in Production Support to resolve end-users data related reports issues.
  • Used Toad as an advanced SQL - PL/SQL editor. Built and tested scripts, PL/SQL packages, procedures, triggers, and functions.
Environment: Oracle 10gR2, SQL, PLSQL, TOAD, Windows XP, UNIX.

Confidential, Jun ‘06 - Aug ‘08
Hyderabad, INDIA

Oracle iStore 11i Customization and Production support:
Oracle iStore is an electronic commerce application that enables companies to build, manage, and personalize powerful, global and scalable internet storefronts. iStore is seamlessly integrated with Oracle\'s CRM and ERP applications, providing all of the components necessary to create powerful internet store sites for selling Oracle products and services in a secure and personalized environment.

Responsibilities:

  • Worked on analyzing and enhancing existing Stored Procedures, Packages and Functions as per the business rules.
  • Worked on Monitoring, Investigating, Analyzing, and Resolving production support issues logged by the Oracle iStore users.
  • Extensively wrote adhoc SQL queries to analyze the production issue logged by the user.
  • Involved in SQL tuning in order to improve the performance of the iStore application using various Oracle Hints and Indexes.
  • Worked closely with the users and Product development team in resolving the iStore application issues and provided support in analyzing the bugs.
  • Worked on data fixes to resolve certain iStore production support bugs.

Oracle iStore Release 12 Testing:

Responsibilities:

  • Developed Test Scripts using Mercury WinRunner tool for testing various business flows for iStore R12 application.
  • Involved in Logging tickets and providing support to the product development team for tracking Oracle iStore R12 product issues and bugs.
  • Worked with business team in resolving issues and provide them support for UAT (user acceptance testing).

Oracle Ezorder Customization and Production support:

Oracle eZorder is a simple interface between the customer and Order Management module. It helps customers to easily place orders without having to understand the complexities in the OM module. The interface is a simple eZorder form that contains order related information, which is entered by the user and then validated. Successfully validated orders are then interfaced to OM. Any kind of validation errors in the orders are forwarded to the AIT eZorder team by a service request, which are then resolved and interfaced.

Responsibilities:

  • Worked as a part of AIT eZorder Support and development team, in solving issues related to interfacing customer’s orders to Order Management.
  • Worked on customization of existing Ezorder forms using Oracle Forms 6i.
  • Worked on analyzing existing Stored procedures and Functions and enhancing them for better performance and suite the business needs.
  • Optimized SQL and PL/SQL performance using Oracle utilities like Explain Plan, SQL-Trace Analysis and TK-Prof.
  • Involved in training eZorder users by providing guidelines, reference guides and presentations on handling the issues while entering and interfacing the eZorders to OM.

Environment: Oracle Applications 11i, Oracle Applications Release 12i, SQL Developer, PLSQL, UNIX, Oracle Forms 6i.

Confidential, Jul ‘04 - Jun ‘06
Hyderabad, INDIA

Green Spot, Upgrade from Oracle Applications Release 11.5.3 to 11.5.9 and OPM implementation:

Responsibilities:

  • Worked on developing various Oracle Stored Procedures, Interfaces and APIs for migration of data from Release 11.5.3 to 11.5.9 in Accounts Receivables (AR) module.
  • Created Conversion programs to transfer data from a legacy system to the new system for various modules of Oracle Applications.
  • Created control file scripts and used SQL* Loader to load data into the staging table.
  • Extensively worked on RICE elements - reports, interfaces, conversions, and enhancements.
  • Involved in development and customization of Business forms using Oracle Forms 6i.
  • Involved in development and Customization of Oracle Reports using Oracle Reports 6i like GST - Monthly Production Report, GST - Cost of Goods Sold Report etc.

DCI Oracle Applications Implementation (11.5.10):
Responsibilities:

  • Worked on developing Stored Procedures, Interfaces and Conversion Programs for data migration to 11.5.10 in Accounts Receivables, Accounts Payables, Oracle Purchasing and Oracle Quality modules
  • Worked closely with the data analyst and functional consultants to understand the business requirements.
  • Modifying custom forms as per business logics using Oracle Forms 6i.
Environment: Oracle 9i, SQL* PLUS, TOAD, Oracle Reports 6i, Oracle Forms 6i, Oracle Applications 11i, Windows XP, UNIX.

Hire Now