We provide IT Staff Augmentation Services!

Senior Oracle Developer Resume

Los Angeles, CA

SUMMARY:

  • Over 9 years of experience in Software Development Lifecycle - Application Software Design, Development, Testing and Implementation.
  • Delivered project needs on time and within the agreed acceptance criteria in a hybrid methodology environment as they attempted to transition to an Agile Methodology.
  • Practiced backlog grooming, release and sprint planning, daily standups.
  • Functioned as the bridge between functional business units and IT.
  • Excellent team player with problem solving and troubleshooting capabilities.
  • Commitment to excellence proven by an outstanding career track.
  • Extensive experience in Oracle 9i/10g/11g, Oracle Application Express.
  • Proficient in use of programming languages - C, C++, XML, HTML and Oracle PL/SQL.
  • Proficient in use of Windows 9x/2000 and UNIX platforms.
  • Experience in Design, Development, Implementation and support Of RDBMS in Production, Development and Test environments.
  • Well experienced on various data design models includes Oracle Data Modeler for Entity Relationship(ER) diagrams.
  • Proficient in working with RAC, Tables, Table Partition, and Collection objects, Nested table, Record type, Cursor, Ref Cursor, View, Materialized view, Triggers, Instead of triggers, Temporary Tables, XMLTABLE.
  • Expertise in writing Wrapper/Scheduler jobs and hands on experience in Autosys Tool.
  • Also worked on MS SQL Server, Access Databases and developed T-SQL, SQL, Stored Procedures, Cursors, Triggers, Views, Indexes and Constraints, Query Optimizer
  • Proficient in working and conceptual knowledge of Oracle Forms 6i/10g, Reports 6i.
  • Expertise in writing Crystal Reports and SQL Server Reporting Services.
  • Commercial experience in Data Modeling using design tools like ERWIN and MS VISIO, created ER Diagrams, Data Flow Diagrams using Design tools.
  • Hands-on experience with source control tools like Visual Source Safe (VSS)
  • Major strengths are familiarity with multiple software systems, tools and the ability to learn quickly new technologies and adapt to new environments
  • Excellent interpersonal and communication skills, self-motivated and good team player.
  • Worked through all phases of System Development Life Cycle (SDLC): requirements gathering, analysis, design, development, testing, UAT, production and post-production support

TECHNICAL SKILLS:

Data Base: Oracle 9i/10g/11g/11i, MS-ACCESS

Language: PL/SQL, C++, XML, HTML, .NET

GUI: Oracle Apex

Web: IBM WebSphere 5.x/4.x, ASP

Operating Systems: Windows NT/XP/98/2000, UNIX

Other Tools: TOAD, PL/SQL Developer SQL* Loader, WinSCP, Remedy, PVCS, RTC, Kick Start Professional

PROFESSIONAL EXPERIENCE:

Senior oracle developer

Confidential, Los Angeles, CA

Skills/Technologies: Oracle Apex, IBM WebSphere 5.x/4.x, ASP, PL/SQL, C++, XML, HTML, .NET

Responsibilities:

  • Responsible for creating and developing highly complex applications using Oracle as back-end with expertise in design and development of Oracle PL/SQL Packages and Procedures.
  • Involved in migration of Oracle 9i database to Oracle 11g.
  • Analyze System Requirements to create a Technical Design with the assistance of other Sr. Developers/Architects/Tech. Leads.
  • Responsible for helping set development standards for database development within PL/SQL.
  • Act as a technical resource, with a high level of technical and analytical expertise in programming languages, data communications and a strong understanding of the business operation/customer. Implement and support code migration into production.
  • Constructed complex SQL queries with sub-queries, inline views as per the functional needs in the Business Requirements Document (BRD)
  • Created Views and Triggers required for the Incident, Investigation, Consequence and Action Items modules based on the business requirements.
  • Designed, developed and tested Oracle PL/SQL packages, stored procedures, and functions to push the incident data from SCIPR to FIM.
  • Developed automated SQL scripts to schedule the load of employee/contractor user information from active directory on daily basis.
  • Extensively worked on ETL (Extraction, transformation and loading) using PL/SQL to Extract, transform and load incident data into MIS (Downstream HSSE Management Information Systems) data warehouse.
  • Played a pivotal role in the migration of open Incidents from legacy application databases to Oracle 10g in a planned manner
  • A reporting data mart was created to support the MIS capabilities by designing and developing Oracle PL/SQL packages, stored procedures, functions, and triggers.
  • Designed and created Entity-Relationship diagrams, data models and other database related information by reverse engineering defined data dictionary, database entities, parent child relationship keys, identifying primary and referential integrity constraints, sequences, stored procedures
  • As part of performance tuning, used TKPROF, and Explain Plan in tuning PL/SQL code and SQL queries

Senior oracle developer

Confidential, Los Angeles, CA

Skills/Technologies: Oracle Apex, IBM WebSphere 5.x/4.x, ASP, PL/SQL, C++, XML, HTML, .NET

Responsibilities:

  • Analysis of the specifications provided by the client, Design and Development, Conducted Use Case scenarios and translated the problem domain to UML diagrams utilizing Microsoft Visio
  • Constructed complex SQL queries with sub-queries, inline views as per the functional needs in the Business Requirements Document (BRD)
  • Developed various packages, stored procedures, Views, and triggers using Oracle10g
  • Created Views and Triggers required for the Incident, Investigation, Consequence and Action Items modules based on the business requirements.
  • Designed, developed and tested Oracle PL/SQL packages, stored procedures, and functions to push the accounting data from GSAP to SHARE.
  • Involved in implementing the data integrity validation checks through constraints and triggers.
  • Performance monitoring and tuning of SQL developed by various developers.
  • Designed and developed various classes to construct the business logic using C# and ADO.NET. The middle tier contained all the business logic. The data access layer was designed on the middle tier, which would connect to Oracle10g
  • Developed Web Forms using C# Language with event handling, exception handling and Logging
  • Developed COM components in VB 6.0 for business rules and integrated with database
  • Developed various accounting reports using Crystal Reports. NET
  • Environment: Oracle 10g, PL/SQL, SQL, SQL*PLUS, SQL Loader, SQL Developer, SQL Navigator, Visual Studio.Net 2005, C#, ASP.NET 2.0, ASP, ADO.NET, VB 6.0, ADO, Java Script, VB Script, Windows Scripting Components, Crystal Reports.NET, IIS, Windows 2000, and Visual SourceSafe.

Oracle developer

Confidential

Skills/Technologies: Oracle Apex, IBM WebSphere 5.x/4.x, ASP, PL/SQL, C++, XML, HTML, .NET

Responsibilities:

  • Developed and Modified the PL/SQL Packages, Procedures, Functions and Database Triggers using the oracle advanced techniques Bulk Processing, En-queue and De-queue, Collections.
  • Develop the jobs to extract, transform and load, populating and refreshing Staging Tables from flat file and then export to Transaction Files using DI and export the files to Metvance target tables using MTV Provider Load Utility.
  • Write the scripts with in the jobs to automate the process, parameter setting / initialization for the flat files.
  • Validate the source data being processed through DI Jobs to ensure accuracy using a set of SQL queries and MTV client.
  • Analyze data in source systems to assess data cleanliness and make recommendations for addressing within the source systems or as part of the ETL process.
  • Responsible for end to end Testing and Fixing the Defects.
  • Communicate with Management and evaluating the DI Job Execution Status to guarantee the consistent performance
  • Optimizing PL/SQL code and SQL queries (Using Explain Plan, Analyze, Indexes and Hints).
  • Provide timely Production Support by quickly analyzing the root cause and by providing work around to resolve issues.
  • Assisted in maintaining and improving ETL processing efficiency for improved data quality, impact analysis and data validation. Ensured data availability to the departmental data marts on a requirement-demand basis.
  • Environment: Oracle 9i, Toad for Oracle, PL/SQL, Business Objects Data Integrator, Hyperion Essbase, Metvance (MTV), Clear Case, Clear Quest, Flat Files, UNIX and Microsoft Office Visio, Tidal

Oracle developer

Confidential

Skills/Technologies: Oracle Apex, IBM WebSphere 5.x/4.x, ASP, PL/SQL, C++, XML, HTML, .NET

Responsibilities:

  • Worked on various backend Procedures and Functions using PL/SQL
  • Created various SQL and PL/SQL scripts for verification of the required functionalities
  • Created various Database triggers using PL/SQL
  • Generated a number of reports for management to review for system functionality as against the old legacy system
  • Worked with various functional experts to implement their functional knowledge into working Procedures
  • Worked on optimizing existing procedures and functions using PL/SQL
  • Used Object Libraries and Form Template using Oracle Forms5.0
  • Designed and attached toolbar and menu bar to forms in Oracle Forms5.0
  • Involved in setting up Business Area for Oracle Objects on Discoverer, granting access to users
  • Created and registered Discoverer queries in Oracle Discoverer Administration 3.1
  • Used Oracle Reports Builder to create various Report Formats including Sub Reports, Cross Tab Reports, Standard Reports and Master/Detail Reports
  • Environment: Oracle 8.x, SQL, PL/SQL, Developer2000 (Forms5.0, Reports3.0), Discoverer3.1, Sun Solaris and WindowsNT/97, Erwin.

Oracle PL/SQL Developer

Confidential

Skills/Technologies: Oracle Apex, IBM WebSphere 5.x/4.x, ASP, PL/SQL, C++, XML, HTML, .NET

Responsibilities:

  • Identified and analyzed requirements.
  • Develop ETL process to load the data from .DAT files
  • Develop programs, scripts, and procedures for data load in ODS
  • Document all development process and methods (ETL operations) based on St John Health Standards
  • Worked on various backend Procedures and Functions using PL/SQL
  • Created various SQL and PL/SQL scripts for verification of the required functionalities
  • Created various Database triggers using PL/SQL
  • Generated a number of reports for management to review for system functionality as against the old legacy system
  • Test the programs, scripts, and procedures for data load in the test environment
  • Worked on optimizing existing procedures and functions using PL/SQL
  • Environment: Oracle 9i, TOAD, Informatica, PLSQL, Sql Loader, ERWIN, UNIX

Hire Now