We provide IT Staff Augmentation Services!

Sr. Oracle Developer Resume

Rosemont, IL

SUMMARY:

  • Over six years of IT experience in software development, analysis, design, production support and implementation with major focus on Databases and Data Warehousing, Business Intelligence and Database Applications.
  • Excellent design, development and maintenance experience of applications using Oracle 12c,11g/10g/9i, SQL, PL/SQL, Oracle Forms 10g/9i/6i, Reports 10g/9i/6i.
  • Expert in designing, developing, testing, and implementing PL/SQL triggers, cursors, stored procedures, packages, functions at database level and reporting level.
  • Experience in development of complex query reports according to user requirement using Oracle Reports.
  • Expertise in requirements gathering, software requirements specifications, systems development, testing (unit, performance), reporting, application maintenance, application / production support.
  • Expertise with Data Migration, Bulk Data loading and exporting using SQL*Loader, Import/Export, and UTL File Utilities.
  • Good understand of APEX.
  • Experience in using SSIS tools like Import and Export Wizard, Package Installation, and SSIS Package Designer.
  • Adept in key Oracle performance - related features such as Query Optimizer, Execution Plans, Hints, Indexes, Clusters, Partitioning.
  • Proficient in tuning SQL queries using Explain Plan, Trace (TKPROF, SQL TRACE)
  • Excellent data modeling skills. Good knowledge in using data modeling tools like ERWIN, and adept at Normalization Techniques for designing database with Relational technology on N-Tier Architecture.
  • Great understanding of OLAP Data Warehousing processes and techniques on Oracle platform.
  • In depth understanding of Dimensional Modeling techniques, Star and Snow Flake Schemas, Slowly Changing Dimensions, Late Arriving Facts.
  • Generated various Monthly, Quarterly, Bi-Yearly, Yearly reports by different type of reports using SSRS.
  • Extensive experience with creating Oracle ETL Scripts utilizing SQL Loader, Import/Export, External Tables, DBLinks, Materialized Views, Merge command etc.
  • Exposure to scheduling processes using UNIX Shell scripts, Cron jobs and other third party tools.
  • Excellent understanding of SQL and OLAP functions for Business Intelligence purposes.
  • Migration to Oracle Database from various data sources.
  • Team player with excellent communication, problem solving organizational and interpersonal skills.
  • Maintain positive communications and working relationships at all business levels.

TECHNICAL SKILLS:

Relational DBMS: Oracle 9i 10g 11g, 12c, MS SQL SERVER 2005, Teradata V2R5

Operating System: Red HAT LINUX, Windows

Programming Language: SQL PLSQL, Java, Java Script, C, HTML, XML

Oracle Tools: Oracle Developer, SQL Loader, Import/Export, SQL*Plus, SQL Developer, Toad, PL/SQL Developer 6.0, SQL Navigator, Oracle Discoverer 2000, Oracle Forms/Reports, ODI

Software Application: Microsoft Suite (Word, Excel, Power Point and Access), In Design, FrontPage and Dream weaver

PROFESSIONAL EXPERIENCE:

Confidential, Rosemont. IL

Sr. Oracle Developer

Responsibilities:

  • Worked on designing, coding, testing and maintaining database objects, table, views, packages, functions, procedures, indexes, sequences and triggers using Oracle PL/SQL.
  • Attending client meeting to discuss functional design for conversion programs.
  • Worked on raising, handling and fixing defects in HP QC (Quality Centre).
  • Created Oracle PL/SQL stored Procedures, Functions and Packages to develop.
  • Worked on writing programs for Data Conversions.
  • Worked on Bulk loader utilities like Sql loader for moving data from external files into the Oracle database.
  • Extensive knowledge on HINTS and complex queries.
  • Created database tables, indexes and partitioned existing tables.
  • Performed unit, system and Integration testing.
  • Design, develop and unit test new features, enhancements and interfaces for APEX web application
  • Used Oracle APEX 4.0 for designing application structure.
  • Expertise in Oracle APEX design and application.
  • Created Oracle reports on demand.Enrollment count summary report, Billing report and other insurance/payroll/COBRA file transfer reports by using SSRS and SQL Server 2008/2012.
  • Worked on checking log files on UNIX while working on support for production environment.
  • Experienced on the tasks required to establish, to a high degree of assurance, that a system is performing its intended functions according to pre-defined specifications.
  • Ensured timely completion of development projects within estimated costs and standards.
  • Assisted in the implementation of programs to educate management and users in information processing and system capabilities, uses and requirements.
  • Tasked to review and evaluate proposed system design resolutions (such as table structure, table relationships) and determine feasibility and practicability in real time environment.

Environment: Oracle 10g/11g/12c, PL/SQL, SQL Developer, Oracle Reports 10g, APEX, UNIX, MS Word, Ms Excel, Servers.

Confidential, Bingham Farms, MI

Oracle PL/SQL Developer

Responsibilities:

  • Coordinated with the front end design team to provide them with the necessary stored procedures and packages and the necessary insight into the data.
  • Created Oracle PL/SQL stored Procedures, Functions and Packages to support ETL process.
  • Worked on SQL*loader to load data from flat files obtained from carious facilities every day.
  • Created database External tables, views, and indexes and partitioned existing tables.
  • Performed unit, system and Integration testing for a given task.
  • Involved in the continuous enhancements and fixing of production problems.
  • Extensively involved in using hints to direct the optimizer to choose an optimum query execution plan.
  • Creation of database objects like tables, views, and materialized views using oracle tools like toad and PL/SQL developer.
  • Ensured timely completion of development projects within estimated costs and standards.

Environment: Oracle 11g/10g, PL/SQL, SQL Developer, TOAD, UNIX, Forms Oracle Reports 10g, MS Word, Ms Excel.

Confidential, Seven Hills, OH

Oracle PL/SQL Developer

Responsibilities:

  • Gathered the requirements and documented high level documentation for the project.
  • Involved in the business requirements gathering and analysis, understanding client’s Data Warehousing requirements and system analysis.
  • Designed Logical data model and Physical conceptual data model using Erwin.
  • Developed user entry screens and master-detail forms using Oracle Forms.
  • Created and designed reports based on complex queries using Oracle Reports according to the requirements.
  • Responsible for overseeing all aspects of the databases. This includes installation, management, performance tuning, backup/restore, stored procedures.
  • Worked with other developers in performance tuning of Databases and SSAS Cubes.
  • Performed database design, tuning using Oracle Job Scheduler, Oracle Advanced Queuing.
  • Applying constraints and writing triggers to apply the business rules.
  • Involved in handling Errors and Transaction Processing in the Procedures.
  • Created Records, Tables, Objects, and Error Handling.
  • Performed Data Migration using SQL* Loader from flat files in to data base tables.
  • Extensively involved in Writing PL/SQL Stored Procedures, Triggers, Functions, and Packages to meet the business requirements.
  • Created custom partition tables for reporting.
  • Created and maintained SSIS ETL packages to extract data from different systems, and load variety of large volume data into data warehouse from different sources like flat file, Excel file.
  • Responsible for SQL tuning using explain plan and optimizer hints.
  • Used Ref-cursors and Collections for accessing complex data resulted from joining of large number of tables.
  • Moved data from the old tables into the new tables using SQL*Loader.
  • Handled exceptions for the ease of debugging and displaying the error messages in the application.
  • Performed code reviews and acceptance testing of the application.

Environment: Oracle 10g/11g, PL/SQL, TOAD, UNIX, Oracle Forms 10g, Oracle Reports 10g, SQL*Loader, Oracle SQL Navigator, MS Word, Ms Excel.

Confidential, San Diego, CA

Oracle PL/SQL Developer

Responsibilities:

  • Assisted in designing Logical data model and Physical conceptual data model using Erwin.
  • Extracted data from different sources like flat files and loaded into Oracle data warehouse according to the specifications.
  • Analyzed business process workflows and developed ETL procedures for moving data from source to target systems.
  • Created stored procedures, triggers, tables, views.
  • Documented all the packages, procedures and functions involved in ETL process.
  • Developed Shell Scripts to automate file manipulation and data loading procedures.
  • Unit and integration tested the target data.
  • Worked with the team members in developing the Test Plan and Test cases for Unit testing for validation.
  • Performance optimization, procedure definition, queries tuning, database design.
  • Use SQL*Loader utility to upload data files into tables, Export and Import Oracle Utilities to move tables between Schemas.
  • Gathered reporting requirements from business end users/clients. Identified key dimensions and facts for analytical reporting and decisions support reporting to develop custom reports.
  • Developed forms and reports according to the specifications.
  • Conducted technical/non-technical presentations to the management and training workshops for the clients.

Environment: Oracle 11g/10g, Toad for Oracle, Oracle Reports and Forms 10g, SQL*Loader, Windows, UNIX, Cron tab

Hire Now