Oracle Sql Developer Resume
SUMMARY:
- Information technology professional with over 15 years of experience.
- Proficient working with relational databases.
- More than 15 years of Oracle backend programming experience.
- Experience database designing and tuning process.
- Performed analysis and translated business needs to create high - quality business requirements and functional specifications documentation.
- Experience in full circle application programming, implementation and support.
TECHNICAL SKILLS:
Environment: s: MS-DOS, OS/2, Windows 3.11/95/98/2000/ XP/NT, UNIX
Languages: Crystal Report 9.0/8.0/6.0/5.0/4.6 , Oracle Forms 6i/4.5,PowerBuilder 10.0/8.0/5.0/4.0 , Visual Basic 6, EDGE Development.
Database Related: ORACLE 8.x, 9i, 10G, SQL, SQL* Plus, PL/SQL, Sybase 10.02, Watcom SQL 4.0. Neteeza
Applications: Oracle Enterprise Manager, Business Objects 5.1, PL/Vision 98.1,Toad 10, SQL Navigator 4.4, InfoMaker 5.0/4.0., Discoverer 10.1, Warehouse Builder 10g, SQL Developer, PL/SQL developer
EXPERIENCE:
Confidential
Oracle SQL Developer
Responsibilities:
- Creating new and optimizing existing complicated SQL statements, creating PL/SQL packages, procedures and functions for dataload into reporting(staging) tables on Oracle 11g (Data Warehouse) for marketing reports and dashboards.
Confidential
Oracle Developer, Consultant
Responsibilities:
- Created and modified packages, stored procedures and functions for preparing data for marketing analysis reports using Oracle 11g on large size databases.
- Creating complicated SQL statements and PL/SQL scripts for packages, stored procedures, functions and triggers on Windows NT platform using Toad, SQL Developer and PL/SQL Developer.
- Performed SQL statements optimization and created materialized and log views for optimizing data extract process. Participating in data modeling for existing and new reports.
Confidential
Programmer/Analyst
Responsibilities:
- Created scripts for data loading, producing auditing merchandise reports using Oracle 9i/10G(10.2) on large size databases . Wrote complicated SQL statements, PL/SQL packages, stored procedures, functions and triggers on Windows NT and Unix and Linux platform.
- Participated in data modeling for existing and new reports.
- Created tables, views, indexes , triggers, Oracle stored procedures, functions, packages, PL/SQL scripts using Oracle 9i/10G(10.2) .
- Was heavily involved in all stages of moving process to Oracle RMS package. Participated in project discussions, created scripts using SQL, PL/SQL and Unix shell scripts for data transferring, provided QA testing for different stages of moving process. Participated in creation and support of replenishment system.
- Performed tuning of PL/SQL scripts and SQL statements optimization for large database.
- Analyzed business data using Toad software on Oracle databases and Squirrel software for verifying correctness of data loads into Neteeza database.
- Creating reports using Discoverer 10 .
- Communicating with users in order to collect requests improving the data quality.
- Creating auditing reports using SQL*Plus .
- Creating technical and user’s documentation.
- Creating and making enhancements to Unix and Linux scripts, using Tarantella software.
- Creating ETL maps, using Warehouse Builder 10g .
- Creating scripts for data migration in Oracle Retail Package project frame.
Confidential
Oracle Database Developer
Responsibilities:
- Creating backend scripts for producing quality reports using Oracle10G.
- Create PL/SQL packages , procedures, functions, triggers on Windows NT and Unix platform.
- Participating in data modeling for existing and new reports.
- Creating Oracle stored procedures, functions, packages using Oracle 10G .
- Analyzing business data using SQL Navigator software.
- Using the Tortoise SVN for proper distribution and updating scripts and documentation.
- Communicating with users in order to collect requests improving the data quality.
- Creating statistical reports using SQL*Plus , Crystal Reports.
- Creating detailed technical and user’s documentation.
Confidential, Philadelphia, PA
Oracle Developer Consult
Responsibilities:
- Heavily involve in data maintenance process on large size databases ( over 1TB ) using Oracle9i/10G(10.2), PL/SQL procedures, functions, triggers on Windows NT and Unix and Linux platform.
- Participating in logical and physical design of data loads for data repairing tasks.
- Creating Oracle stored procedures, functions, packages using Oracle 9i/10G .
- Performed tuning PL/SQL scripts and SQL statements to process large data volume.
- Analyzing data in daily data loads using TOAD, SQL Navigator software.
- Communicating with users in order to collect requests improving the data quality.
- Creating statistical reports using SQL*Plus .
- Creating detailed technical and user’s documentation.
Confidential, Glen Mills, PA
Senior Consult
Responsibilities:
- Playing a key role in designing and creating data flow process using SQL Server, Oracle10G, PL/SQL procedures, functions, triggers on Windows NT and Unix and Linux platform. Participating in data base design.
- Create SQL Server database procedures, views, using SQL Enterprise Manager.
- Participating in logical and physical design of data loads for new users.
- Creating Oracle stored procedures, functions, packages using Oracle 9i/10G .
- Creating VB Scripts for effective data loads into Oracle data base.
- Analyzing data in daily data loads using TOAD software.
- Communicating with users in order to collect requests for creating new and improving the performance of existing applications.
- Creating statistical reports using Crystal Reports and SQL*Plus .
- Creating detailed technical and user’s documentation.
Confidential, Oaks, PA
Senior Staff Consult
Responsibilities:
- Maintained SQL Server database using SQL Enterprise Manager.
- Created triggers, database procedures and functions utilizing PL/SQL .
- Performing maintenance and enhancements for applications utilizing PowerBuilder 8.1, 10.
- Analyzed data in daily data loads, reprocessed loads using Paragon software.
- Created schedules in order to process daily data loads using Main Frame .
- Created VB scripts in order to process daily tasks.
- Made enhancements, created new forms and modules for existing project using Visual Basic 6.
- Created statistical reports using Crystal Reports .
- Created technical and user’s documentation.
Confidential, Bristol, PA
Oracle Application Developer
Responsibilities:
- Performed Tracker, Inventory database design, created indexes, keys, database procedures and triggers.
- Fully supported and maintained production Design Tracker, GSP Mailing Tracker, GSP Web Tracker, Inventory System, and Event Notification System applications.
- Built and supported Fashion Tracker application.
- Created database objects, indexes, data files, table spaces, partitions using shell scripts and Oracle
- Enterprise Manager for test and production databases.
- Creating, testing and implementing Oracle PL/SQL procedures, functions, packages and triggers utilizing ORACLE 8.0, 9i & 10G on Unix and Windows NT platform .
- Analyzing and maintaining style’s mailing and shipment data.
- Loading daily shipment, sale and inventory data from AS400 system into Oracle Data Base using SQL*Loader and Oracle PL/SQL procedures.
- Created new forms, modules for new and existing projects using Visual Basic 6.
- Performing enhancements for existing applications utilizing PowerBuilder 8.1, 10.
- Insuring the proper data integrity.
- Communication with users in order to determine the incoming data problems
- Creating reports using Crystal Report Professional 8.0, creating universes and report templates using Business Objects 5.1
- Managing user’s accounts for Design Tracker, GSP Mailing Tracker, GSP Web Tracker, Event Notification System, and Business Objects.
Confidential, Langhorne, PA
Programmer/Analyst
Responsibilities:
- Design of database utilizing ORACLE 7.3 & 8.0, SQL*Plus 3.2, PL/SQL 2.2, SQL*Loader and build in Oracle packages.
- Create Stored Procedures, Triggers, Functions using PL/SQL .
- Meet with users to determine job specifications and client’s marketing requirements.
- Create applications using EDGE Development System, a product proprietary to the telemarketing industry, that works on Windows NT and Unix platform .
- Create EIS applications under UNIX environment.
- Create reports utilizing SQL*Plus, Crystal Report Professional 5.0 & 6.0.
Confidential, Torofare, NJ
Programmer/Analyst
Responsibilities:
- Participated in the full - cycle design, development, implementation and maintenance of the following systems
- Imprint Management System, Warehouse Tracking System and Company Benefits System utilizing PowerBuilder 5.0/4.0, SQLSybase Engine, SQL and SQL*Plus.
- Created triggers, database procedures and functions utilizing PL/SQL .
- Met with users to gather specifications, business direction and flow of application.
- Designed, developed, implemented and maintained multiple systems utilizing PowerBuilder, SQL Sybase Engine and SQL.
- Created reports using SQL*Plus, Infomaker and PowerBuilder.
