We provide IT Staff Augmentation Services!

Sr. Oracle Developer Resume

Chicago, IL

CAREER SUMMARY:

  • 10 plus years experience in Oracle Developer 2000 with Oracle 7.x, 8i, 9i and 10g.
  • Expertise in front - end with Oracle Forms 4.5/5.0/6i/9i/10g using pl/sql.
  • Expertise in PL/SQL, Database Triggers, Stored Procedures, Functions, Packages, Collections, Records, Bulk collect and materialized views. Also familiar with pipe lined functions.
  • Did R12 upgrade from 10.7 and well versed with Service module and other Modules like manufacturing, Inventory, Install Base, Service Contracts etc.
  • Oracle Apps 11i (GL, Receivables, Purchasing, Inventory, HRMS).
  • Experience working closely with e-business business analyst.
  • Expertise in Report Designer 2.5, Report Builder 3.0 and Oracle Reports 6i, Reports Builder 9i/10g, Oracle Discoverer 9i, Crystal Reports 9.0, JDeveloper.
  • Expertise in using Sql * Loader, from flat files & Oracle tables to Oracle tables.
  • Experienced doing migration of Forms, Reports, pll’s, menus etc. and handling post migration fixes.
  • Experience in migrating the data to and from Oracle tables.
  • Expertise in Oracle Exception handling.
  • Good experience in following Oracle’s best practices.
  • Have good programming skills to improve the performance of the queries.
  • Expertise in doing ER diagrams (ERD).
  • Thorough understanding of System Development Life Cycle (SDLC) including software requirements, database designing, system design, development and testing using Client/Server technologies.
  • Wrote many software design specifications and did database designing for the projects.
  • Interacted with the end-users in almost all the projects and have good experience interacting with them.
  • Well trained in Oracle DBA 9i.

TECHNICAL SKILLS:

Systems: Windows NT/95/98/2000/XP, IBM PC Compatible, UNIX (Sun Solaris), MS/DOS, Novell-Netware.

DBMS: Oracle 7/8i/9i/10g.

GUI/TOOLS: Oracle Developer 2000 (Oracle Forms 4.5/5.0/6i/9i/10g, Oracle Reports 2.5/3.0/6i/9i/10g, Oracle Graphics 2.5), TOAD 6.3, Power Builder 4.0/5.0, ORMIT ver. 2.3, 3.0, JDeveloper, Oracle Designer 9i, Oracle Discoverer 9i, Crystal Reports 9.0, Case Tools, ERWIN, Workgroups 2000, MS Office, Sql * Loader, VSS, Star Team (ver.5.4), Putty, WS-FTP Pro7.6.

LANGUAGES: Pl/Sql, Sql*Plus, C, JSP, HTML, Java, Power Script, COBOL, dBase 111, UNIX Shell Scripting.

PROFESSIONAL EXPERIENCE:

Confidential, Chicago, IL

Sr. Oracle Developer

Responsibilities:

  • . Worked as an Oracle Developer for Department of Water Management (DWM) for the city of Chicago.
  • . Did the upgrade of InforEAM (Enterprise Asset Management) from ver. 7.9 to 10.1.
  • . Created stored procedures, functions and packages for invoicing and parts modules.
  • . Used best practices to write sql queries.
  • . Created job schedules and created procedure to send to the user e - mail list.
  • . Did data migration from one table to another table.
  • . Created custom tables for different modules.
  • . Upgraded Cognos reports to 8.3, created and fixed reports as well.

Environment: Oracle Database 11g (Enterprise Edition Release 11.2.0.3.0 ), TOAD Ver. 12, WINDOWS 7, Cognos 8.3, Microsoft SQL Server 2008.

Confidential, Oak Brook, IL

Sr. Oracle Developer

Responsibilities:

  • Worked on lifetrack application for the Department of Defence (DoD) and for IBBI projects in blood management in healthcare industry.
  • Created and modified Oracle Forms/Reports to customize the lifetrack application.
  • Created procedures, functions and packages using Bulk Collect, collections and records for the enhancement of the application.
  • Familiar with pipe lined functions.
  • Created libraries, object libraries for global changes to the application in forms and reports.
  • Used SQL * Loader to load the data into staging tables and tables.
  • Fixed many defects from the PVCS version control.
  • Created tables, indexes, constraints, views.
  • Well experience doing performance tuning using explain plan for the pl/sql programs to minimize the execution time of the queries.
  • Followed SDLC process to customize lifetrack product.

Environment: Oracle Developer Suite 10g (Forms 10g, Report Builder 10g), PL/SQL, TOAD Ver. 9.0.1, WINDOWS XP, Oracle 10g Databases, WinSCP, Putty.

Confidential, Chicago

Sr. Oracle Developer

Responsibilities:

  • Worked on AMC application support team.
  • Created and modified oracle Forms/Reports, sql reports in .csv and .xls formats.
  • Created new procedures, functions and packages using bulk collect, collections and records to create processes and for reports creation.
  • Created and modified shell scripts and sql files, to create the reports in .csv and .xls, which are schedule to run.
  • Used SQL* Loader to load the data into oracle tables.
  • Experienced doing performance tuning (sql programs).
  • Fixed many defects from the share point request.
  • Used Oracle Designer 9i to create forms, tables, indexes and version control as well.

Environment: Oracle Developer Suite 9i (Forms 9i, Report Builder 9i), PL/SQL, TOAD Ver. 9.0.1, WINDOWS XP, Oracle 10g Databases, WinSCP, Sun Solaris 5.10.

Confidential, Minneapolis

Oracle Applications Developer

Responsibilities:

  • Did R12 upgrade from 10.7 for Manufacturing, Inventory, Service and other modules as well.
  • Migrated Forms, Reports and programs to R12.
  • Created many new custom forms (10g), reports (10g) and used BI Publisher (XML Publisher) as a report output file.
  • Did customizations to the standard forms and also did forms personalization.
  • Created packages, procedures and functions, and also used API’s as part of the extension as well.
  • Did forms and reports registration to the application and added to the menus.
  • Created UNIX shell scripts for code migration to different instances.
  • Well versed with creating .ldt files by downloading and uploading concurrent programs, data definitions, menu’s etc.
  • Created custom responsibilities as well.

Environment: Oracle Developer Suite 10g R2 (Forms 10g, Report Builder 10g), Oracle Workflow Builder 2.6.3.5, PL/SQL, TOAD Ver. 9.0.1, Oracle SQL Developer 1.5.1, WINDOWS XP, Oracle 10g Databases, WinSCP, Sun Solaris 5.10.

Confidential

Oracle Applications Developer

Responsibilities:

  • Worked on to upgrade Oracle Applications from 10.7 to 11i for AP, AR, Purchasing, Manufacturing, Service, Install Base, BOM (Bills of Material) modules.
  • Created many custom forms and reports using Forms 6i & Reports 6i in 11i.
  • Did forms personalization to the existing standard forms.
  • Created many Custom Forms, Reports, packages, stored procedures, functions, using Forms Builder 6i and Report Builder 6i.
  • Customized the standard forms and reports as required by the business.
  • Created .ldt files for concurrent programs, data definitions, forms and menus.
  • Used version control to maintain the objects of the applications.
  • Did some DBA activities, including database creation, user creation, grants, database import & export etc.
  • Deployment of forms and reports on the Oracle Application Server 10g (OAS).

Environment: Oracle Developer Suite (Forms 4.5/6i/, Report Builder 2.5/6i/), PL/SQL, TOAD Ver. 9.0.1, SQL* Loader, UNIX Sun Solaris, WINDOWS XP & 2000, Oracle 9i & 10g Databases, Microsoft Visual Studio 2005.

Confidential

Lead/Oracle Developer

Responsibilities:

  • Worked for the development of SGSE (School Grants Special Education) and SDS (Student Data Systems) for K-12, OCSM (One Client Service Model) for the privacy project.
  • Created many Forms and Reports using database packages, procedures, functions and Ref-cursors using Forms Builder & Report Builder 10g with Oracle 10g as a back-end.
  • Converted Oracle Reports 10g from SQL based to Ref-cursor by writing procedures & functions.
  • Wrote Dynamic SQL for the forms and reports.
  • Developed Financial Interfaces to load the data from flat files into Oracle tables and also migrated the data to oracle tables.
  • Fixed and troubleshooted programs in JDeveloper.
  • Did Performance tuning for many queries to improve the execution time by re-writing the queries, creating indexes, using Hints etc.
  • Created database packages, procedures, functions using Bulk collect as well.
  • Also used collections and records in the database procedures.
  • Built reports using Oracle Discoverer 9i.
  • Done QA testing also by running the test cases thru Win Runner.
  • Used to attend team meetings with the project manager on weekly basis to update the work status of the team.

Environment: Oracle Developer Suite 10g (Forms 6i/9i/10g, Report Builder 10g), PL/SQL Developer Ver. 6.0.5.931, JDeveloper ver9.0.33, Oracle Discoverer 9i, WINDOWS NT, UNIX (Sun Solaris), Oracle 10g database, WS-FTP Pro ver7.6, Putty 0.58, Star Team.

Confidential

Oracle Developer/Team Lead

Responsibilities:

  • Designed the RDS Financial Invoice system for the government Energy utilities using Forms 10g and Reports 10g with Oracle 9i as a back-end.
  • Interacted with the Business Analyst and end-users, to gather the requirements and to update them what they should expect as an end product, so that they can also give some input before the final functional/technical specification is completed for signoff.
  • Written software design specification and data modeling using Oracle Designer 9i for creating ERD, Database table scripts, Indexes etc.
  • Did Workflows for the Invoicing module.
  • Used Forms 9i & 10g to create Invoice forms using procedure based blocks..
  • Created Invoicing reports using REF Cursors and generated reports in .PDF, .xls and cvs formats, using Report Builder 10g.
  • Created database packages, procedures, functions & triggers using Ref cursors and Bulk collect.
  • Created reports using Crystal Reports 9.0.
  • Shared technical and business knowledge with others developers whenever required.
  • Used client’s time track system to enter hours worked.
  • Used VSS version control for checking-in and checking-out the source code.

Environment: Oracle Developer 2000 (Forms 6i/9i/10g, Report Builder 10g, Oracle Designer 9i, PL/SQL Developer Ver. 6.0.3.893, WINDOWS NT, UNIX (Sun Solaris), Oracle 9i database, Crystal Reports 9.0, Microsoft Office Visio Standard 2003 ver. 11.3216.5703 , VSS.

Confidential

ETL Warehouse Builder

Responsibilities:

  • Used Oracle Warehouse Builder to design source, target, and mapping metadata.
  • Designing, creating, and populating dependent data marts.
  • Extraction of data from relational and flat file sources into staging area to enterprise model and enterprise model to data marts.
  • Deployed OWB mapping scripts to extract, transform, and load data into warehouse and data mart tables.
  • Defining Source Metadata, Staging Area Metadata and deploying and populating Staging Area Objects.
  • Done incremental data loading.

Environment: Oracle 9i, ETL Warehouse Builder.

Hire Now