We provide IT Staff Augmentation Services!

Oracle Etl Developer Cum Development Dba Resume

2.00 Rating

Newark, DE

SUMMARY

  • Experience in development, enhancement, implementation, maintenance and support of applications developed under ORACLE/ Exadata (12g/11g/10g/9i/8i/8.0).
  • Experience in Design, Analysis, Testing, Data Modelling, Data Extraction, Data Migration and Administration.
  • Experience in Data Modeling (Entity Relationship), Schema Design using ERWIN.
  • Excellent project management, scoping, development life cycle and implementation experience
  • Strong experience in Database Development, Administration, Enhancement and Implementation. Strong in Database Design and Development of Relational databases.
  • Experience in Data Warehousing (Star Schema), ETL Development using Ab Initio (GDE and Co>Operating System) / Informatica, Crystal Reports, Oracle, Developer 2000/ 6i, SQL Server 2008, IIS, ASP.NET, VB.NET, ADO.NET.
  • Maintained the logical and physical organization of the database, like organization of database into different table spaces.
  • Experience in implementing different options in Oracle like Parallel Query, Partitioning etc.
  • Experience with handling very large data files using export & import and SQL*Loader.
  • Experience in using OEM, TOAD, SQL Navigator, SQL Developer, and Oracle APEX etc.
  • Expertise in writing/ debugging of Stored Procedures and Database Triggers.
  • Experience in SOLARIS/ LINUX/ HP UX & Shell Programming, crontab. Used vi editor.
  • Exposure to high - level design and building efficient databases. Interacted directly with developers and end clients for translating, customizing and enhancing application for achieving maximum database throughput.
  • Strong Analytical, Organizational, Inter-personal and Communication Skills.

TECHNICAL SKILLS:

RDBMS: Oracle/ Exadata 12g/11g/10g/ 9i/ 8i/ 7.3, my SQL, SQL Server 2000, Sybase 12, FoxPro, Foxplus2.1.2, MS-Access

ORACLE UTILITIES/TOOLS: OEM, Data Guard, Oracle Streams, RMAN, SQL*NET, export / import SQL*Loader, tkprof, Toad, SQL Navigator, SQL Developer,, Oracle APEX

DESIGN TOOL: Erwin 3.5.2/ 4.0, ER Studio, MS Visio, MS Project

ETL Tools: Informatica Power Center 9.6, Ab Initio

Development Tool: Developer 6i/ 2000, IIS, ASP.NET, VB.NET, ADO.NET

BI Tools: Crystal Reports 8.0/8.5/9.0/10.0, Discoverer

OPERATING SYSTEMS: Solaris, Redhat Linux, IBM AIX 5.3/ 4.3, UNIX SVR4, Windows NT 2008/ 2003/ 2000/ 4.0

LANGUAGE: SQL Plus, PL/SQL, T-SQL, UNIX Shell Scripts

PROFESSIONAL EXPERIENCE:

Confidential, Newark, DE

Oracle ETL Developer cum Development DBA

Responsibilities:

  • Worked in CDPP team for OneSource Development
  • Created an ETL framework for migrating data to OneSource DW.
  • Modified existing ETL processes.
  • Used Power Designer for creating Logical and Physical Data Models
  • Developed packages, stored procedures, functions, tables, views.
  • Used external tables extensively for data migration
  • Fine Tuned procedures for the maximum efficiency in various schemas across databases using Oracle Hints, Indexes, Explain plans.
  • Used Oracle Enterprise Manager for monitoring
  • Responsible for Data Validation extracted from various source systems.

Environment: Oracle 12g / 11g, Exadata, OEM, SQL*Plus, PL/SQL, Power Designer, Toad, PEGA, BIX ETL process

Confidential, Owings Mills, MD

Oracle PL/SQL cum ETL Developer

Responsibilities:

  • Worked in MIDR, Accounting Data Mart, Seismic Applications
  • Worked in new development, enhancing existing features and production support
  • Worked in OLTP Application Development as well as ETL Development
  • Created and modified ETL batch jobs for migrating data to DW. Used Informatica Power Center for ETL migration.
  • Developed packages, stored procedures, functions, tables, views, triggers
  • Used external tables extensively for data migration
  • Fine Tuned procedures for the maximum efficiency in various schemas across databases using Oracle Hints, Indexes, Explain plans.
  • Created autosys ZIL scripts for batch jobs
  • Used Oracle Enterprise Manager for monitoring
  • Worked on Sybase development and support. Used T-SQL.
  • Responsible for Data Validation extracted from various source systems.
  • Used (including account setup) Sterling File Gateway (SFG) for data transfer between vendor and TRP

Environment:Oracle 12g / 11g, Exadata, Solaris, Redhat Linux, OEM, SQL*Plus, PL/SQL, External Table, Toad, Informatica PowerCenter 9.6, UNIX Shell Scripts, Autosys, Sterling File Gateway (SFG)

Confidential, Oaks, PA

Oracle PL/SQL Developer cum Data Architect

Responsibilities:

  • Worked in Global Wealth Platform.
  • Worked on both Confidential Desktop and Advisor Desktop modules
  • Worked as Data Architect, Database Development and Database Admin support to the Development and QA groups.
  • Refreshes Development Environment in the beginning of each period.
  • Maintained Windows Oracle Database instance for the developers.
  • Created and modified ETL batch jobs for migrating data to DW. Used Informatica ETL tool for ETL migration.
  • Developed PL/SQL modules for both Cash and Advisory modules using analytic functions.
  • Fine Tuned procedures for the maximum efficiency in various schemas across databases using Oracle Hints, Explain plans. Used OEM for monitoring
  • Generated and maintained Keys, Constraints and Relationships between the tables for OLTP & OLAP instances.
  • Worked on GWP metadata. Added / modified tables, indexes, views. Used ER studio.
  • Responsible for Data Validation extracted from various source systems.
  • Created Detailed Design Documents for the transformations.

Environment:Oracle 11g, AIX, Windows NT 2008 Server, HTML, SQL*Plus, PL/SQL, SQL*Loader, Toad, Informatica, ER Studio, MS SQL Server 2000, UNIX Shell Scripts, Control M

Confidential, Wilmington, DE

Oracle ETL Developer

Responsibilities:

  • Involved in the development of Card Data Warehouse in support of Data Warehousing efforts.
  • Created and modified ETL batch jobs for migrating data to CDW.
  • Developed SQL Queries to fetch complex data from different tables from different databases using database links.
  • Fine Tuned procedures for the maximum efficiency in various schemas across databases using Oracle Hints, Explain plans.
  • Generated and maintained Keys, Constraints and Relationships between the tables for OLTP & OLAP instances.
  • Responsible for Data Validation extracted from various source systems.
  • Created Detailed Design Documents for the transformations.
  • Used Datastage ETL tool

Environment:Oracle 10g/11g, Solaris 2.8, Windows NT 2000/2003 Server, HTML, SQL*Plus, PL/SQL, SQL*Loader, Toad, Datastage, MS SQL Server 2000, UNIX Shell Scripts, Control M

Confidential, Chesterbrook, PA

Oracle PL/SQL Developer

Responsibilities:

  • Worked for creating various data interfaces for Siebel SalesPro application.
  • Created interfaces for sample data, state license data and group practice data.
  • Created high level and detailed design documents.
  • Created source to target mappings.
  • Tuning existing SQL and Stored Procedures

Environment: Windows 2003/2008 servers, Oracle 11g, OEM, SQL Scripting, exp/ imp, SQL Loader, Toad, Informatica, UC4, Siebel Tools

Confidential, Malvern, PA

Oracle PL/SQL Developer

Responsibilities:

  • Worked in the 3 major software development teams i.e. VPAS, TORO and Kanban.
  • Created the full data model for TORO. It has 12 modules and app. 220 tables and has more than 100k lines of PL/SQL code. I wrote a major part of the code. Migrated data from one database to other. Refreshed development & testing databases with production data periodically.
  • Created tools for the Purge and Archive tool for selective delete, backup and restore of client data for development and QA teams.
  • Re-engineered the VPAS Application schemas. Created Prototype for the project. Created 2 secondary schemas i.e. client 54 sec & common 54 sec. with selected objects. Implemented synonym switching between primary and secondary schemas. Configured and used RMAN backup and restore for testing. Configured OEM for the test database.
  • VPAS has more than 1000 tables, 500 views and app. 150 packages and more than 1 million lines of PL/SQL code.
  • Tuned SQL, PL/SQL scripts using SQL Trace and Explain Plan.
  • Refreshed VPAS client data for VPAS QA & DEV databases.
  • Created and Modified database triggers, packages, procedures, functions for application development while working for Automation and VPAS Product Teams.
  • Worked on SQL tuning, code elevation and other issues.
  • Used External Tables, SQL Loader, exp/ imp, datapump, SQL copy utility for data refresh.
  • Worked on the TORO project database architecture. The database is Oracle and the UI is in JAVA. The job involves physical and logical design, development and guidance to other developers. Interaction with the user groups for the design. Worked on the utl mail, utl smtp, dbms scheduler, utl file, database link, rman. Created the data model in Erwin.

Environment: Sun Enterprise servers, x86 servers, Oracle (10.2), OEM, Unix Shell Scripting, SQL Scripting, exp/ imp, External Tables, Datapump, Toad, SQL Developer, RMAN, Oracle APEX

Confidential, Burlington, MA

Oracle Devlopment DBA cum PL/SQL Developer

Responsibilities:

  • Understanding of Functional Requirement, Create the Design Document and Coding.
  • Setting up the Oracle Streaming environment for Data Replication.
  • Also used materialized views for Data Replication.
  • Database administration for Development & Testing servers.
  • Worked on metadata. Creation of new schemas (including Data Modelling), Refreshing old schemas and Data Migration. Used oracle data pump (expdp / impdp). Used Eewin data modeling tool.
  • Granting privileges to users.
  • Installation of Oracle Binaries.
  • Oracle backup and recovery through RMAN utilities.
  • Used oracle flashback and OEM.
  • Reverse engineered the old oracle schema.
  • Used SQL Loader, External Tables, Materialized Views and DB link

Environment:Oracle 10.2, Solaris, Linux, Windows XP, SQL*Plus, PL/SQL, SQL*Loader, SQL Developer, Shell Scripts, Remedy, Perforce, Java, C++, OEM, Oracle Streams, Erwin, Advanced Queues

Confidential, Greenville, SC

Oracle Developer

Responsibilities:

  • Interact with business users and receive Function Requirement Documents from them. Created Detailed Design Documents including test cases as per the requirement, Detailed Project Estimate and got it approved from the business users.
  • Created new schema for the application including DDL for of new database objects like tables, views, sequences, functions, synonyms, indexes, triggers, packages, stored procedures, roles and granting privileges.
  • Reverse engineered the old oracle schema with Erwin.
  • Generated server side PL/SQL scripts for data manipulation and validation.
  • Produced data extraction and data loading scripts for various schema.
  • Changed the old linear scripts and converted them modular scripts with stored procedures, functions and packages. Pushed the code to Dimension version control system.
  • Refreshed Test environment with Production database image using full database Clone.
  • Created and modified SQL*Plus, PLSQL and SQL*Loader scripts for data conversions.
  • Developed SQL Queries to fetch complex data from different tables from different databases using database links and formatted the results into reports and kept logs.
  • Worked on ordergen script used by Stop & Shop and Giant.

Environment:Oracle 9.2, AIX 5.3/ 4.3, Windows 2000/XP, HTML, SQL*Plus, PL/SQL, SQL*Loader, SQL Navigator, Shell Scripts, Perl, Autosys, Remedy, Perl, Dimension, VB, Developer 6i, ERWIN, OEM

Confidential, Herndon, VA

Oracle PL/SQL-cum-ETL Developer

Responsibilities:

  • Worked in the $1.2 billion Restatement Project.
  • Generated DDL for creation of new database objects like tables, views, sequences, functions, synonyms, indexes, triggers, packages, stored procedures, roles and granting privileges.
  • Generated server side PL/SQL scripts for data manipulation and validation and created various snapshots and materialized views.
  • Produced SQL reports, data extraction and data loading scripts for various schemas.
  • Refreshed Test environment with Production database image using full database Clone.
  • Created and modified SQL*Plus, PLSQL and SQL*Loader scripts for data conversions.
  • Developed SQL Queries to fetch complex data from different tables from different databases using database links and formatted the results into reports and kept logs.
  • Fine Tuned procedures for the maximum efficiency in various schemas across databases using Oracle Hints, Explain plans and Trace sessions for Cost based optimization.
  • Generated and maintained Keys, Constraints and Relationships between the tables for OLTP & OLAP instances.
  • Involved in the development of Enterprise Data Warehouse using Ab Initio in support of Data Warehousing efforts.
  • Optimized critical queries to eliminate Full Table scans reduce Disk I/O and Sorts.
  • Developed Ab Initio Graphs based on business requirements.
  • Responsible for Data Validation extracted from various source systems
  • Developed Ab Initio XFRs to derive new fields and solve various business requirements.
  • Implemented Lookups, Joins and rollups to improve the graph’s performance
  • Worked with Departition Components like Gather, Interleave in order to departition and repartition the data from Multi File accordingly
  • Implemented Data Parallelism through graphs, which deal with divided data into segments and work on each segment simultaneously through the Ab Initio partition components.
  • Used air commands and EME Web Interface.
  • Developed an scheduling application using ASP.NET, VB.NET & ADO.NET with oracle 10.2 on solaris 2.8 at the back end.

Environment:Oracle 10g/9i, Sybase 12, Solaris 2.8, Windows NT 2000/2003 Server, Windows 2000/XP, HTML, SQL*Plus, PL/SQL, SQL*Loader, Toad, Ab Initio Co>Operating system 2.13, GDE 1.13.4, MS SQL Server 2000, UNIX Shell Scripts, Perl, Autosys, Remedy, IIS, ASP.NET, VB.NET, ADO.NET

We'd love your feedback!