We provide IT Staff Augmentation Services!

Oracle Resume

St Louis, MO

PROFESSIONAL SUMMARY:

  • Ten plus years of professional experience in Analysis, Design, Modeling, Development, Support and Implementation of applications in the client/server environment using Oracle 11i/11g/10g/9i/8i/8.0/7.x, Developer 2000, Designer 2000, SQL, PL/SQL, Forms 11g/10g/6i/6.0/4.5,3.0 Reports 10g/6i/6.0/2.5, SQR Reports, PRO*C.
  • Work effectively in a team and also individually. Extensive experience in PL/SQL Stored Procedures, Database Triggers, Toolbars, Performance Tuning and Batch Processing.
  • Extensive knowledge of the Oracle architecture, Oracle Memory structures, Logical & Physical Structures, Data Dictionaries and with PL/SQL.
  • Experience numerous Oracle implementations through full infrastructure and performance optimizations including I/O optimization, SQL Tuning and Backup and Recovery Planning, Testing and Implementation.
  • Extensive experience in using Oracle Reports 6I & Forms 6I.
  • Proficient in Installation, Setup, Configuration, Maintenance and Tuning of Oracle 8i /9i//11i/11g/8.0/7.x/ under UNIX (Sun Solaris 2.6, 7, 8) and Windows NT environment.
  • Extensively worked in Oracle based application software Design, Development, and Implementation and application Maintenance.
  • In-depth knowledge of SQL and PL/SQL, PRO*C.
  • Proficient in developing PL/SQL packages, stored procedures and triggers.
  • Good knowledge and understanding of Data Warehousing.
  • Worked on all phases of development lifecycle, from gathering requirements to testing, implementation, and support.
  • Design and develop Oracle packages, store procedures, configuration files, tables, views, and functions; implement best practices to maintain optimal performance.
  • Created system for capturing, reporting, and correcting error data.

EMPLOYMENT HISTORY:

Confidential,St Louis, MO. August 2012 – Till Date
Project-ICHS (Integrated Cost History System)
Role-Technical Lead, Developer

Description:
The ICHS is used for labor hours, labor dollars and non – labor dollars, Estimating, Financial, and Business Management Purposes. The application supports with number of standard reports and Estimating and Business Operations of the company.

Highlights:

  • Provided Customer support in code building, deployment.

Design and Development Activities:

  • Requirement gathering for the requested change from customer.
  • Analysis of the requirements
  • Design and develop Oracle forms/reports, Oracle packages, store procedures, configuration files, tables, views, and functions; implement best practices to maintain optimal performance.
  • Provide configurations changes to Oracle application server 10g.
  • Build efficient Oracle packages for data transfers between different layers.
  • Created system for capturing, reporting, and correcting error data.
  • Performance Tuning of Queries and Packages.

Solution Environment-Solaris 10, Oracle 10G SQL/PLSQL, Tools-Oracle developer suite, MS-VSS, Toad, SQL Navigator, Windows NT., Oracle Reports/Forms

Confidential,Austin, TX 01/2012 – 06/2012
Consultant

  • Working on TIERS project which is a real-time system which helps DHS eligibility staff in delivering services and benefits for the needy people. The application is based on the SOA architecture for connecting to different systems.
  • Created Partitions for large tables.
  • Designed and developed complex PLSQL packages and SQL loader scripts that can load, process
  • Developed scripts using SQL loader to load data into tables.

Environment: ORACLE 10g,11g, Oracle PL/SQL,SQL, REPORTS 10g, SQL Navigator, UNIX, HTML, Windows XP, SQL, SQL LOADER, batch process.

Confidential,Woodland, TX 03/2011 – 11/2011


Senior Data Analystand Developer
  • Develop and maintain databases and data systems necessary for projects and department functions in conjunction with other team members
  • Analyze and problem solve issues with current and planned systems as they relate to the integration and management of clinical/financial data
  • Acquire and abstract primary or secondary data from existing internal or external data sources
    Develop and implement data collection systems and other strategies that optimize data quality and completeness
  • Interpret data and develop recommendations based on findings
  • Monitor data dictionary statistics
  • Create and present quality dashboards and ad hoc reports
  • Works under general supervision of Technical Lead on all phases of SDLC lifecycle on large Data centric implementation.
  • Responsible for reviewing data accuracy, completeness and produce high quality software that fits business needs.
  • Responsible for maintaining SQL standards and design documentation.

Environment: ORACLE 10g,11g, Reports, Oracle PL/SQL,SQL, REPORTS 10g, TOAD, UNIX, HTML, Windows XP, SQL, SQL LOADER, batch process.

Confidential,Saint Louis, MO 10/2010 - 01/2011
Technical Consultant and Developer
Panera Bread operating 1,421 company-owned and franchise-operated bakery-cafes in 40 states

Responsibilities:

  • Developing forms, reports for Order Entry sales system. This system automated sales and inventory functions. This system elimination of manual tracking of inventory and sales data. Preparing stored procedures, packages, functions and database triggers to implement required functionality.
  • Developed REPORTS for vendor details, their contact details, and notes using REPORTS 6i /10g.
  • Developed interface screens for data entry and data validations using FORMS 6i/10g.
  • Developed REPORTS for transaction details, item details, stock availability and fast/slow/non-moving stocks using REPORTS 10g.

Environment: ORACLE 10g, ORACLE /9i/10g, PL/SQL, FORMS 11i/10g, REPORTS 10g, Discoverer Plus, Discoverer Viewer, SQL Navigator, HTML, Windows XP, SQL LOADER.

Confidential,Augusta, ME 04/2010 – 09/2010
Technical Consultant and Programmer/Developer

Designing Child Support Enforcement System for Maine (CSEME) is a web based application developing using application development framework provided by Oracle forms and Oracle reports. Main programming language and execution environment is pl/sql accessing Oracle 11g database and applications 11g.

Responsibilities:

  • Wrote and modified Oracle PL/SQL, SQL statements, stored procedures and functions
  • Tuned the SQL using Explain Plan to increase performances of Reports.
  • Used PL/SQL extensively to create extract from Data Warehouse for Down Stream System
  • Used SQL-LOADER extensively to load data to small Data Mart
  • Used SQL/TOAD to query complex relational databases and validate reporting results
  • Fine-tuned PL/SQL Procedures for better performance
  • Used the EXPLAIN_PLAN to fine-tune the complex query.
  • UNIX shell script to create environment variables and load data.
  • Developed SQL*loader scripts to load the data from flat files to the Oracle Tables
  • Extensively involved in Analysis, Design, Development and Testing.
  • Modeling and Logical/Physical design of database schema.
  • Used Reverse Engineering in ERWIN to identify the problems in previous data model.

Environment: ORACLE 10g/11g, PL/SQL, FORMS, REPORTS, SQL Navigator, UNIX, HTML, Windows XP, SQL LOADER.

Confidential,Houston, TX 09/2009 - 02/2010
Technical Consultant and Developer Developing forms, reports for manufacturing, HR & Payroll, Order Entry sales system. This system automated sales and inventory functions. This system elimination of manual tracking of inventory and sales data. Preparing stored procedures, packages, functions and database triggers to implement required functionality.

Redesigning existing Reports to Oracle Reports 10g

Customizing different reports in GL, AR and AP such as Account Analysis Reports, as per user requirements.

Environment: ORACLE 10g, ORACLE /9i/10g, PL/SQL, FORMS 11i/10g, REPORTS 10g, Discoverer Plus,Discoverer Viewer,TOAD, UNIX, HTML, Windows XP, SQL LOADER

Confidential,Dallas, TX 04/2007 -01/2009
Software Developer

  • Developed and improved various key modules of the custom built Store Automation Project delivering measured improvements in efficiency and productivity in day to day operations in the areas of ordering, receiving, inventory, management, merchandise planning, POS Integration and Price management.
  • Responsible for rescue maintenance as needed across a spectrum of store developed applications built on Oracle*Forms, Oracle*Reports, Oracle PL/SQL, and Oracle Pro*C.
  • Worked in Retek Merchandising System (RMS) and modified vendors order receiving for the Store Automation Project.
  • Application development in forms and reports using oracle 10g and converted oracle 9i to 10g.
  • Complete programming and/or analysis and design assignments given by the customer for any effort associated with the Store Automation Project.
  • Manage problem tickets assigned to my group and acted as the primary developer during a production crisis to manage other resources with resolving the issues reported.
  • PL/SQL is used to process data input and output for the web based.
  • Developed REPORTS for vendor details, their contact details, and notes using REPORTS 6i /10g.
  • Developed interface screens for data entry and data validations using FORMS 6i/10g.
  • Developed REPORTS for transaction details, item details, stock availability and fast/slow/non-moving stocks using REPORTS 6i.
  • Designed and Developed user interface screens using FORMS.
  • Designed and implemented several REPORTS for invoice, purchase order, stock levels and inventory accounting using REPORTS.
  • Created stored procedures, functions and triggers using PL/SQL, TOAD.
  • Expert skills in using TOAD, Explain Plan, TKPROF for Performance & Tuning.
  • Experience in using various PL/SQL features of Table Functions, PL/SQL Tables, VArrays, Partitioned Tables, REF Cursors in the Development of Stored Procedures.
  • Worked on Business Intelligence tools like Business Objects and Crystal Reports.
  • Data Modeling experience in Entity-Relationship Model, Dimensional Data Model, Fact and Dimensions tables, Conceptual, Logical and Physical data modeling.
  • Developed user-interface screens for data transactions using FORMS.
  • Implemented FORMS involving master/detail relationship between the blocks.

Confidential,Redmond, WA 08/2006 - 03/2007
Sr. Programmer

  • Responsible for CDRlive, this product is designed to capture and analyze the call details.
  • Analyzed using CDRlive for MSC performance, route optimization, subscriber usage performance, handset usage performance, cell site, traffic usage performance, Inter - network roaming, call failure analysis and market information.
  • Analysis/design custom reports requests from customers using SQL & PL/SQL.
  • Developed user-interface screens for data transactions using FORMS 6i.
  • Designed and implemented several REPORTS for invoice, purchase order and inventory accounting using REPORTS 6i.
  • Designed the database architecture using ERwin (Entity-Relationship tool for Windows)
  • Developed reports using SQL, PL/SQL, TOAD and Business Objects for T-Mobile network and Cingular network to capture the roamers who came into the market. Traffic growth analysis and planning.
  • Identified and analyzed worst performing areas in the network and subscriber issues and experience.
  • Effectively communicate network/handset issues to engineer and customer support.
  • Worked with JAVA developers to repair and enhance current base of PL/SQL packages to fix production issues and build new functionality and improve processing time through code optimizations and indexes.

Confidential,Arlington, VA 10/2005 - 07/2006
Applications Developer/ Software Engineer

  • Responsible for the analysis, design and development Radio Station Information, application development in forms and reports using oracle 8i,TOAD, PL/SQL,SQL for Arbitron Washington/Baltimore.
  • The software changes to expedite program crediting in diary processing. The program numbering and reaccrediting is primarily performed in the market analysis.

Confidential,Minneapolis, MN 08/2005 - 10/2005
Applications Developer / Performance Engineer

  • Responsible for Retek Merchandising System (RMS) performance testing, functional areas under various data volumes for RMS 11.0.x.
  • Fully familiar RMS Functional areas including scenarios with new product transformation and testing modules. All tests performed in Retek’s Performance Lab in Minneapolis, Minnesota.
  • Significant performance tuning (i.e., code enhancements, recapturing code, SQL tuning, table partitioning and indexing) for all areas tested for the RMS.
  • Wrote stored procedures, packages, functions and database triggers to implement required functionality, and also performed unit testing and system integration.
  • Tuned PL/ SQL procedures and function for better performance results.
  • Participated in testing and troubleshooting of the applications.
  • Designed required views and SQL statements to access data in an efficient way. Designed and developed various Reports and complex forms. Designed and developed primary database objects (tables, views, indexes).
  • Designing of the Logical and Physical Database Objects using ERWIN.

Confidential,Baton Rouge, LA 07/2004 - 06/2005
Information Technology Applications Programmer/Analyst 1

  • Responsible for users need reports, programming, analysis, designs and tests.
  • Designed, developed and implemented various applications using MS-SQL and Web FOCUS.
  • Created Stored Procedures, Views and Database Triggers using SQL & PL/SQL, TOAD. Developed PL/SQL Procedures for Advanced Targeting Tool.
  • Developed complex queries to extract and manipulate data. Performed query analysis and enhanced Query performance by taking advantage of Oracles indexing features and table partitioning features
  • Fully familiar with unemployment Insurance operations and needs, worked closely with users divisions in the areas of Policy services, claims delivering the information on schedule by creating either new or modifying the existing reports using COBOL, MS-SQL, SQL, JCL, TSO, DB2, Excel.
  • Enhanced and modified database packages and stored procedures, functions and triggers, to ensure compliance with business specifications.
  • Designed Web-based ASP.NET Internet applications linked to firm-wide SQL databases.
  • Migrated a VB6 imaging application to ASP.NET (VB.NET). Volunteered to write a web application (VB.Net) to allow users to change their Oracle passwords from the intranet.

Confidential,Baton Rouge, LA 07/1999 - 01/2004
Associate Software Engineer

  • Responsible for the analysis, design and development needs of the company’s underwriting sub system and goldmine sub system using Oracle, SQR and HTML, PRO*C.
  • Designed, developed and implemented the underwriting sub system that supported the functional areas of policy creation, invoicing, payment processing, cancellations, reinstatements, etc. The sub system is integrated with quotes, claims, and audit management sub systems of the Lagniappe. The entire system is web enabled and accessible to policy holders nationwide
  • Designing of the Logical and Physical Database Objects using ERWIN.
  • Familiar with Workers Compensation Insurance operations and needs, worked closely with the Quality Assurance and End User Divisions in the areas of Policy Holders Services, Audits, Claims and Collections delivering the information sought on schedule by creating either new or modifying the existing Oracle Forms, Oracle Reports, SQL Reports, Structured Query Reports (SQR\'s) using Oracle 8.x, 9i, Oracle Discoverer, Oracle Forms & Reports 6i and SQR 4.3.5 respectively.
  • Converted Oracle Forms and Reports from Versions 4.5 and 2.5 to Oracle Forms and Reports Versions 6i.
  • Designed ODBC connection to Oracle 8.x.
  • Created PL/SQL scripts to convert Oracle Database Tables to Powercomp System (Power Builder dependent) usable Database Tables to enable the implementation of a New Powercomp System for the policyholder Services in the areas of Audits, Collections and Documents.
  • Application development in forms and reports using oracle 8i and Oracle Discoverer.
  • Responsible for the timely conversion, testing and implementation of the existing Oracle Forms and Reports from 4.5 and 2.5 to Oracle forms and Reports 6i.
  • Converted Oracle Database Tables to Powercomp System Usable Database Tables.
  • Responsible for the timely generation, testing and implementation of PL/SQL script for conversion and testing of various Policy Holder Services documents and Audit functional tables from the existing data base to Powercomp database.
  • Created new SQR reports as well as converted some existing reports in close discussions with the Data Users and Quality Assurance Divisions to generate valuable reports for Policy Holder Services using the Powercomp database.
  • Designed and developed a fully data driven system with menus created dynamically from the database.
  • Worked with Business Analysts to help define and set overall project development priorities.
  • Designed required views and SQL statements to access data in an efficient way.
  • Designed and developed over 70 forms using Oracle Forms Builder and Designer.
  • Developed over 50 reports using Oracle Reports Builder.
  • Developed a customized data access toolbar which appears on all the forms making data access easier.
  • Identify various types of external data sources, decoding, migrating data to newly designed Oracle RDBMS tables after solving bad data errors.
  • Developed a script to load data from external sources using SQL*Loader.
  • Developed script for weekly database backup, as well as for forms and reports
  • Created data flow diagrams in MS Visio.

Hire Now