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.