We provide IT Staff Augmentation Services!

Pl/sql Developer Resume

Ashburn, VA

SUMMARY:

  • I have fifteen years of experience in IT with data analysis, datawarehousing, web application development, procedure & database development.
  • Associated with complete life cycle of software projects including Database development, Datawarehousing and Web applications from documentation to production.
  • Worked Extensively on PL/SQL, Oracle Discoverer, Oracle Warehouse Builder, SQL*Loader, Oracle Export and Import utility, Toad.
  • Worked on Extraction, Transformation and Loading (ETL) with (OWB) at migration projects.
  • Worked on complete Life Cycle of Projects including Software documentation, Flow charts, coding, testing, User manual, the User.
  • Worked on Entity Relationship Diagrams with ERWIN for Database development.

TECHNICAL SKILLS:

Databases: Oracle 7.x/8.x/9i/10g,11g.

Languages: SQL, PL/SQL, UML, HTML, Java

Web Interfaces: Oracle Discoverer 10g/11g, Oracle Forms 10g, Oracle Reports 10g, Java.

Oracle products: Oracle Discoverer 10g/11g, Oracle Warehouse Builder 10g, OBIEE 11g, Toad, SQL*Loader, Oracle Export & Import.

Operating Systems: Toad, Windows XP, NT, Server.

Other Tools: Erwin, Visio, FTP, Excel.

TECHNICAL EXPERIENCE:

Confidential, Ashburn, VA

PL/SQL Developer

Responsibilities:

  • Worked on PL/SQL procedures, functions, triggers, packages.
  • Wrote Procedures and Functions depending on the Project requirements.
  • Consolidated Packages and organized Procedures and Functions.
  • Worked on Modifying Procedures and Functions according to requirements.
  • Worked on altering database objects and creating object synonyms in different schema.
  • Worked on dblinks to access data.
  • Worked on tuning queries using hints for faster access.
  • On - going maintenance of existing project.

Environment: Oracle Database 11g, PL/SQL, Toad.

Confidential, Alexandria, VA

PL/SQL Developer

Responsibilities:

  • Modified PL/SQL procedures and created database packages.
  • Consolidated existing packages for reusability.
  • Wrote Master script to execute different procedures.
  • Wrote script for revoke and grant privileges for different database objects to database users.
  • Wrote script for creating roles for different database users.
  • Wrote script for creating objects in different schema.

Environment: Oracle database 11g, PL/SQL, Toad.

Confidential, Tallahassee, FL

PL/SQL Developer

Responsibilities:

  • Wrote PL/SQL Stored procedures, functions and packages.
  • Created Materialized Views.
  • Wrote database triggers.
  • Worked on ER Diagrams with Erwin.
  • Worked on SQL*LOADER scripts for loading data.

Environment: Oracle database 10g, PL/SQL, Toad.

Confidential, Tallahassee, FL

Sr. Project Analyst

Responsibilities:

  • Data Migration from MS Access to Oracle 10g.
  • Reverse-engineering of database diagrams from legacy systems
  • Re-engineering the requirements to database development.
  • Data Conversion with PL/SQL.
  • Generating Access Reports.
  • Development of Web Forms using Oracle Forms.
  • Development of Web Reports using Oracle Reports.

Environment: Oracle database 10g, PL/SQL, Toad, SQL*Loader.

Confidential, Tallahassee, VA

Database Engineer

Responsibilities:

  • Development of Oracle Discoverer reports (Desktop, Plus, Viewer, Administration)
  • Working with Oracle Warehouse Builder (OWB )
  • Created Oracle Discoverer End User Layer (EUL or Repository),
  • Business areas for Reports development, Folders including reports and tables, Custom Joins as Oracle Discoverer Administrator.
  • Upgraded Oracle Discoverer 4.1 EUL(End User Layer) to Oracle Discoverer 10g EUL.
  • Exported and Imported End User Layers (eex files), Business Areas(eex files), Workbooks (group of reports).
  • Scheduled the Reports for running automatically at fixed time.

Environment: Oracle Discoverer 10g, Oracle Database 10g, PL/SQL, Toad.

Confidential, Tallahassee, FL

Computer Engineer

Responsibilities:

  • Reengineered the Health Care database.
  • Developed flow charts with visio.
  • Implementation of Oracle Discoverer.
  • Web based Report Application Development with Oracle Discoverer 10g.
  • Extracting reports from Oracle database with SQL, PL/SQL,Toad.
  • Requirement analysis and Flow charting of HCPR(Health Care Practitioners) project for developing reports.

Environment: Oracle Database 10g, PL/SQL, SQL*Loader, Oracle Discoverer 10g.

Confidential, Tallahassee, FL

Government Operation Consultant

Responsibilities:

  • Developing database design and drawing ERD.
  • Development of flow charts with Visio.
  • Worked with Oracle Discoverer (Desktop, Plus, Viewer, Administration) for developing reports.
  • Created database tables, views, packages, procedures, functions, triggers with PL/SQL and Toad.
  • Authentication to users, creating user groups that have access to specific reports.
  • Worked on troubleshooting and fixing problems of the team.

Environment:, Oracle Discoverer10g, Oracle Database10g, PL/SQL.

Confidential, Tallahassee, FL

Computer Engineer

Responsibilities:

  • Worked on flow charts, ER diagrams, forms and reports.
  • Worked on Discoverer portlets with group of reports.
  • Developed ER Diagrams with erwin.
  • Created database objects like tables, functions, packages, procedures, views, indexes.
  • Created user manual and provided .
  • Troubleshooting problems of the team.

Environment: Oracle database 10g, Oracle Discoverer 10g, Oracle Forms & Reports10g, PL/SQL, Toad, Oracle export & import.

Confidential, Tallahassee, FL

Computer Engineer

Responsibilities:

  • Development of flowcharts and Creating ER Diagrams
  • Development of reports.
  • Data Migration from flat files with SQL*Loader.
  • Data was loaded from files into Temporary tables with PL/SQL procedures, functions and packages.
  • Introduced and implemented Oracle Discoverer (Desktop, Plus, Viewer, Administration) for web based reports.

Environment: Oracle 8i, PL/SQL, Toad, Oracle Discoverer.

Confidential

Computer Engineer

Responsibilities:

  • Based on functional specs, wrote technical specifications and created programs to generate flat files and load data into temporary tables.
  • Worked on Oracle Warehouse Builder mappings to load data from staging tables to target tables.
  • Implementation of business rules in Datawarehouse database with PL/SQL procedures and Toad.
  • Worked on Report integration to Oracle Applications.
  • Worked on Oracle Financials (GL, AP, AR)- developing forms and reports for the financial processes (General Ledger, Accounts Payables, Accounts Receivables) and integration into Oracle in-built Applications, according to the Workflow of the business.
  • Worked on developement of Web based reports using Oracle Discoverer.

Environment: Oracle Warehouse Builder, Oracle Database 8i, PL/SQL, Toad, Oracle Applications, Visual Source Safe.

Confidential

Computer Engineer

Responsibilities:

  • Requirements Analysis and Designing of the application.
  • Worked on Architecture of the application.
  • Creation of Entity Relationship Diagrams using ERWIN.
  • Flowcharting using Visio.
  • Developed forms and reports using Java Servlets.
  • Documenting the Life Cycle of the project (Requirement Analysis, Coding and Testing) and providing to the end users

Environment: Java, Java Servlets, JDK, JSDK, Oracle 8i, Erwin, MS Visio.

Hire Now