We provide IT Staff Augmentation Services!

Oracle Developer Resume

Raleigh, NC

SUMMARY

  • 8 years of extensive experience as a PL/SQL, Oracle Developer wif ETL expreience
  • Expertise in Software Development Life Cycle(SDLC) of client implementations including Requirements Gathering, Business Analysis, System Configuration, Design, Development, Testing, Technical Documentation and Support.
  • Well versed in developing various database objects like Packages, Stored Procedures, Functions, Triggers, Tables, Indexes, Constraints, Materialized Views and others in Oracle 11g/10g /9i database.
  • Expertise in developing and customizing Oracle Forms and Reports using Oracle Forms10g/9i/6i, Reports10g/9i/6i, Discoverer 9i/10g, XML Publisher and developing concurrent programs using SQL, PL/SQL.
  • Strong experience in providing technical documentation and status reports of teh applications as per teh requirement.
  • Solid experience in writing complex SQL queries and PL/SQL procedures to extract data from various source tables.
  • Proficient in loading data from flat files into database tables using SQL*Loader scripts.
  • Worked wif Arrays, Records, Dynamic SQL and Exception Handling.
  • Involved in Performance Tuning which included creating indexes, partitioning tables, providing Hints, modifying tables using Explain Plan, sql trace and TKPROF.
  • Worked wif tools like PL/SQL Developer, SQL Developer, SQL*Loader, TOAD, SQL plus.
  • Automating data loading, extraction, reports generation using UNIX Shell scripting.
  • Experience in handling very large data files using Export - Import Utilities and SQL*Loader.
  • Efficient in creating Test cases and performed data validation and process testing for application moving into production.
  • Good Knowledge in Oracle Applications EBS.
  • Working Experience in Data extraction, Transmission and Loading (ETL).
  • Extensively used ETL methodologies for supporting data Extraction, Transformation and Loading (ETL) process in a corporate-wide-ETL solution using Informatica Power Center
  • Experience in using Data sources/targets such as Oracle 11g/10g/9i/8i, SQL Server 2008/2005, Teradata, Netezza, DB2, XML and Flat files
  • Worked extensively on various Informatica Data Integration components - Repository Manager, Designer and Workflow Manager/Monitor
  • Vast experience in Designing and developing complex mappings from varied transformation logic like Unconnected and Connected Lookups, Source Qualifier, Router, Filter, Expression, Aggregator, Joiner, Update Strategy etc
  • Designed Source to Target mappings, Code Migration, version control, scheduling tools, Auditing, shared folders, data movement, naming in accordance wif ETL best practices, Standards and Procedures
  • Worked wif Business Managers, Analysts, and end users to correlate Business Logic and Specifications for ETL Development
  • Good understanding of Data modeling concepts like ER Diagrams, UML, Use Cases, Normalization and De-normalization of Tables.
  • Sound Skills in Report Development, Modeling (Relational, DMR) in Cognos 8.4
  • Knowledge of Principals of Data Warehouse using Fact Tables, Dimension Tables and Star/Snowflake schema modeling.
  • Highly organized and efficient to prioritize and manage multiple tasks.
  • Proven ability to work efficiently in both independent and team work environments.

TECHNICAL SKILLS

Databases: Oracle 8i/9i/10g/11g, SQL Server 2005/2007, MS Access, DB2

Languages: SQL, PL/SQL, Pro*C, C/C++, JAVA, .NET, XML, UNIX Shell Scripting, Perl Scripting

Oracle Tools/ GUI: Forms 6i/9i/10g, Reports 6i/9i/10g, Discoverer 4i/9i/10g

Tools: TOAD, SQL DEVELOPER, SQL*Loader, Oracle SQL*Plus, SQL Navigator, UNIX/LINUX Utilities

Web Technologies: HTML, Apache, Microsoft Internet Information Server (IIS), VBScript, Java Script, CSS, DHTML, XML.

Operating Systems: Windows Family, MS-DOS, Unix, Solaris

PROFESSIONAL EXPERIENCE

Confidential, Raleigh, NC

Oracle Developer

Responsibilities:

  • Involved in all phases of software development including gathering requirements, creating specifications, development of database objects, developing code and validating programs.
  • Performed various activities like creating, debugging and modifying data base objects and User defined functions and finely tuned them for performance.
  • Developed daily, weekly, monthly CAFM Reports and scheduled using Cron Jobs.
  • Developed and customized existing reports as per client specific requirements using Oracle Reports Builder 10g.
  • Worked on Unix scripting for scheduling teh jobs.
  • Created and monitored teh Oracle DBMS JOBS as a part of weekly tasks.
  • Developed PLX reports by modifying teh report template XML and created teh GWDS dashboards for moves survey.
  • Involved in various design discussions and requirement discussions wif teh end users.
  • Involved in identifying all teh Data Models for all teh applications.
  • Involved in creating reusable control table driven ETL Architecture.
  • Created ETL Process control architecture and integrated teh same architecture wif reporting applications.
  • Worked closely wif all teh application owners to know about teh functionality of these applications in a very detail level to understand teh data models being used by them.
  • Studied various Planning applications to understand teh source data for FDW.
  • Created ETL Mapping specifications using functional specifications.
  • Created Technical Specifications document based on functional specifications
  • Managed teh Web servers and Data base servers of Production system, Backup DR and Development system.
  • Involved in teh migration of data from Archibus to Tririga.
  • GoldenGatetroubleshooting using Log miner.
  • Worked wif Golden Gateto replicate data between tables
  • Involved in fixing bugs wifin Packages and Stored Procedures.
  • Involved in Tuning Database & Application performance using Explain Plan.
  • Involved in teh Daily maintenance of teh database dat involved monitoring teh daily run of teh scripts as well as troubleshooting in teh event of any errors in teh entire process.
  • Performed Unit Testing and Integration Testing of teh Application. Involved in preparing documentation and user support documents.
  • Used Perforce for Code check in, GUTS and Buganizer for ticketing system.

Environment: Oracle Database 10g, Windows 7, UNIX, SQL Developer, XML, SQL, PLSQL, Unix Scripting, Perforce, WinSCP, Putty.

Confidential, Austin TX

Sr. Oracle Developer

Responsibilities:

  • Reviewed teh Business/ Functional/ System Requirement Specs, High Level Design Documents, and Detailed Design Documents.
  • Worked wif Business Analysts and Business Objects team to understand teh requirements and translate teh requirement into technical specifications.
  • Developed officer profile module using Stored Procedures, Functions, Packages, Triggers, Tables, synonyms, Materialized Views, sequences, indexes which is compatible wif teh .NET Application.
  • Experience in application development using various features of Oracle like Bulk Collections, Table Functions, Autonomous Transactions, Dynamic SQL, Object types, Records and External tables.
  • Created Cursors and Ref Cursors in teh PL/SQL Blocks.
  • Developed complex ETL mappings dat involve parallel processing of multiple instances basing on certain parameters in control table.
  • Created complex Mappings using different Transformations like Filter, Router, Joiner, Connected & Unconnected Lookups, Sorter, Aggregator and Sequence Generator to pipeline data to Data Warehouse
  • Developed workflows wif multiple sessions and instances for same subject area.
  • Created post-sessions and pre-sessions for all teh sessions to update teh etl process table which is used to understand teh current status of ETLs.
  • Developed Dimension mappings dat load teh dimension from landing zone table involving Type 2 and Type 1 transformations.
  • Involved in tuning Informatica ETL mappings analyzing them thoroughly.
  • Involved in identifying various bottle necks at different levels (database, mapping, session, and workflow) and came up wif solution to improve teh performance.
  • Created table partitions for each of teh country, operating company and period combination which enables faster retrieval of data.
  • Validated and loaded data into Oracle Database using DB links and external tables from CSV files.
  • Autosys job scheduling- created teh jil scripts and unix shell scripts to automate teh jobs scheduling
  • Created batch jobs in regular maintenance, production support to load teh data using unix shell scripting
  • Designed and Developed scripts for uploading data from flat files and XML files into database, performing business validations on teh data using PL/SQL Procedures.
  • Improve teh performance of teh slow SQL queries by implementing indexes, using BULK LOAD, BULK COLLECT and developed various procedures, functions and packages to implement thenew business.
  • Created database triggers for audit and data validation.
  • Worked as a release coordinator, raised Work Requests and Change Requests and also deployment of code in various environments.
  • Ggs Heterogeneous replication usingGoldenGate( Oracle 11.2.0.3 to SQL Server)
  • GoldenGatetroubleshooting using Log miner
  • Migrated Database between servers using Data pump Export/Import
  • Involved in Unit testing and System Integration testing for PL/ SQLStored Procedures andFunctions.
  • 24/7 production support and involved in implementation of coding standards and Data Base change requests.
  • Used SVN for version controlling and ALM (Application Lifecycle Management) for ticketing system.
  • Involved in creating ETL model (snowflake schema), normalizing and documenting.
  • Worked wif Informatica to create source/target definitions, mappings and sessions to extract, transform and load data into staging tables from various sources.

Environment: Oracle Database 11g, Windows 7, UNIX, Toad, XML, SQL, PLSQL, Unix Scripting, SVN, ALM, PAC2000, WinSCP, Putty.

Confidential, McLean VA

Oracle Developer

Responsibilities:

  • Involved in analysis, design and coding of Oracle processes in PL/SQLto built packages.
  • Design and Development of data validation, load processes, test cases usingPL/SQL, Stored Procedures, Functions, Triggers, Cursors using Oracle 10g.
  • Validated and loaded data into Oracle Database using DB links and external tables from CSV files.
  • Developed Ref Cursors to accommodate teh business rules.
  • CreatedTables, Views, Materialized views, and constraints.
  • Created a Stored Procedure to do a partition swap from staging to FDW which is called in ETL to load teh Fact data for various tables which are passed as parameters to teh stored procedure.
  • Create Oracle Stored Procedures to implement teh ETL Process control logic.
  • Created Oracle Stored Procedures for Segment Dimension which holds all teh dimension keys.
  • Designed Oracle views dat generate these extracts for upstream applications and created ETLs to read these views and drop them in a file.
  • Created a model for Audit mechanism and included teh Audit counts in each of teh ETLs to verify teh source and target counts and sums.
  • Identified various extracts needed for upstream reporting applications and planning applications and designed structures for teh same.
  • Documented all teh ETL and Oracle Procedures developed.
  • Created Unit Test plans for various ETLs developed.
  • Performed Unit Testing and Integration testing for teh ETL’s
  • Designed and developed teh Forms and Reports for teh user Interface.
  • Customized Form filed like enabling, disabling form filed and incorporating oracle alerts using form builder 9i.
  • Handled errors using Exception Handling extensively for teh ease of debugging and displaying teh error messages in teh application.
  • Developed Grouping report and matrix reports using oracle reports 9i report builder.
  • Involved in testing backend SQL queries for query optimization.
  • DevelopedUNIX scriptsusingVI editorto create FTP Jobs and to schedule teh jobs.
  • Creating teh concurrent programs and registering teh functions to teh oracle applications (EBS).

Environment: Oracle Database 10g, Oracle EBS, Windows XP, UNIX, SQL Loader, SQL Developer, PL/SQL Developer Oracle Forms 10g, Oracle Reports 10g, Discoverer10g, XML, SQL, PLSQL, VSS, WinSCP, Putty.

Confidential, Columbus, OH

Oracle Developer

Responsibilities:

  • Gathering business requirements from end users.
  • Used various Optimizer Hints to speed up teh SQL queries.
  • Used SQL*Loaders to download teh data into warehouse database from teh flat files and other data files across different platforms.
  • Developed SQL and Shell scripts to create temporary tables and developed SQL*Loader scripts to load data into teh temporary staging tables.
  • Designed and developed forms using Oracle Forms 10g to allow teh end users to manage teh customer relation TEMPeffectively and efficiently.
  • Worked on creating Materialized Views to maintain copy of teh remote data at local node.
  • Mostly involved in code reviewing and performance tuning wif optimization techniques in PL/SQL.
  • Solving teh complicated run time errors while running teh process along wif DBA team members.
  • Involved in teh development of database objects in both OLTP and OLAP databases.
  • Addressing day-to-day issues wif business users using tools like TOAD.
  • Having good knowledge on Claims, Benefits, Provider and Contract affiliations.
  • Created documentation for migration and performed extensive testing during teh various phases of product implementation.
  • Designed and developed teh logic for handling Slowly Changing Dimension tables load by flagging teh record using update strategy for populating teh desired
  • Developed reusable mapplets and transformations for reusable business calculations
  • Used exception handling logic in all mappings to handle teh null values or rejected rows
  • Tuned teh ETL components to gain teh performance and to avoid business continuity.
  • Worked wif Persistent Caches for Conformed Dimensions for teh better performance and faster data load to teh data warehouse
  • Involved in performance tuning and optimization of Informatica Mappings and Sessions using partitions and data/index cache to manage very large volume of data
  • Performed query overrides in Lookup Transformation as and when required to improve teh performance of teh Mappings
  • Used Clear case for version controlling and Clear Quest for ticketing system.

Environment: Oracle Database 11g/10g, Oracle APEX 3.2 Windows XP, UNIX, SQL Loader, TOAD, Oracle Forms 10g, Oracle Reports 10g, Discoverer10g, XML, SQL, PLSQL, VSS, Informatica Power Center 8.1

Confidential, Chicago, IL

Oracle PL/SQL Developer

Responsibilities:

  • Created heavy stored procedures for financial transaction by using procedural parameters & worked wif packages, blocks & exception handling.
  • Designed and Developed Oracle database Tables, Views, Indexes, and Synonyms wif proper privileges.
  • Developed PL/SQL packages for generating various feeds from oracle database using UTL FILE utility in teh client’s secure data transmission server.
  • Developed UNIX scripts for transmitting files from teh secure server to teh customer specified server, using various FTP batch processes.
  • Used SQL*Loaders to download teh data into database from teh text files and spread sheets.
  • Extracted data from teh XML files transmitted to teh bank and loaded them efficiently into oracle temp tables for day to day customer financial transaction reconciliation.
  • Developed UNIX scripts for sending mails to teh bank and teh business team, when teh external feeds to teh bank are received.
  • Involved in supporting/fixing production defects and day to day business transaction issues.
  • Used SQL Navigator, a popular tool which increases user productivity and application code quality wif rich features to manage database objects, develop and debug PL/SQL and create, execute and optimize SQL queries.
  • Designed and implemented client-server application using Oracle Forms 10g.
  • Involved in teh generation of User Interface using oracle forms by extensively creating forms as per teh client requirements.
  • Developed various new reports from scratch utilizing Oracle Reports 10g for day to day validations.
  • Developed ETL mappings, transformations using Informatica Power Center 8.1.
  • Created various adhoc reports as of when required for teh production analysis and bug fixing.
  • Converted reports to browser supportable XML format.
  • Extensively utilized TOAD for performance tuning by generating explain Plans.

Environment: Oracle Database 10g, UNIX, Windows XP, SQL * Loader, TOAD, SQL Navigator, Oracle Reports 10g, Oracle Forms 10g, Discoverer 10g, PL/SQL, UNIX, Perl, XML, JSP

Confidential, NC

Oracle PL/SQL Developer

Responsibilities:

  • Involved in defining system requirements, designing & prototyping, developing, testing, and implementation of teh applications.
  • Designed and implemented teh process for loading teh monthly feeds coming from third party legacy system(in teh form of flat files, csv etc.,) into staging tables in teh Oracle Database using Shell scripts and SQL Loader.
  • Validated data loaded into teh staging tables using PL/SQL and created adhoc month end reports.
  • Developed packages for processing data in teh staging tables according to teh Client’s requirements.
  • Created complex forms for 'Customer transaction loading' (GUI) for day to day business utility, using Forms9i.
  • Imported and Exported data from one table space to another and also loaded data from flat files to teh staging area using SQL Loader in UNIX environment.
  • Written wrapper UNIX Shell scripts to wrap Perl Script, SQL queries as well as ETL jobs to automate teh process of analyzing, gathering statistical data, clearing teh alert logs, trace dump files.
  • Extracted data into comma or pipe delimited files using UTL FILE package/utility.
  • Used Exception handling extensively for teh ease of debugging and displaying teh error messages in teh application.
  • Generated reports using Pro*C and PL/SQL packages.
  • Created new aggregation tables for teh data warehouse enhancement using Materialized Views.
  • Handled production issues wif high pace and efficiency.
  • Hands of experience in using TOAD and SQL Navigator.

Environment: Oracle Database 9i, Windows XP, TOAD, SQL*Loader, Oracle Forms 9i, Reports 9i, SQL Navigator, PL/SQL, Pro*C JavaScript, Perl Scripting, XML, UNIX

Confidential

Oracle Developer

Responsibilities:

  • Involved in gathering teh requirements from users to develop teh application from teh scratch
  • Involved in working wif analysts for gather more information on data flow designs dat required for teh project to develop.
  • Developed Stored Procedures to maintain details of teh vendors and maintained them in Packages.
  • Designed database tables using various Normalization techniques and database rules.
  • Developed reports as per teh requirements collected from teh users using Discoverer and Oracle Reports 10g.
  • Good Experience working on TOAD, PL/SQL Development for database access.
  • Generate and maintain Keys, Constraints and Relationships between teh tables for OLTP & OLAP instances.
  • Developed complex SQL queries to perform teh back end testing of teh Oracle database using SQL and UNIX shell commands.
  • Created Shell Scripts for automating teh execution process.
  • Involve in migrating applications to teh new release versions.

Environment: Oracle 10g, Oracle Forms10g, Oracle Reports10g, Discoverer 10g, Perl Scripting, PL/SQL TOAD, UNIX.

Hire Now