Oracle PL SQL Developer ETL Developer - Information Technology Resum
Oracle PL SQL Developer   ETL Developer - Information Technology Resum
My Spider Scam Awareness Contacting Us F. A. Q.
 
Job Seekers
Search Jobs
Browse Jobs
Post a Resume
Job Alerts
 
Employers
Search Resumes
Browse Resumes
Post a Job

Oracle PL/SQL Developer / ETL Developer Resume


Desired Industry: Information Technology SpiderID: 72738
Desired Job Location: Austin, Texas Date Posted: 6/13/2014
Type of Position: Contractor Availability Date:
Desired Wage:
U.S. Work Authorization:
Job Level: Experienced with over 2 years experience Willing to Travel:
Highest Degree Attained: Willing to Relocate:


Objective:

SUMMARY:
Excellent experience with back
end database development using Oracle
9i, Oracle 10g and Oracle 11g. Strong
knowledge and experience with SQL and
PL/SQL. Completed the Oracle Certified
Professional (OCP) - (Oracle Database
11g: Advanced PL/SQL and Oracle DBA)
7+ years of Database Developer /
Data Analyst / Migration Developer /
Data warehousing/ BI Expert / ETL
Expert.
Experience focusing on Data
warehousing, Data modeling, Data
integration, Data Migration, ETL process
and Business Intelligence.
Excellent experience in Software
design, development, testing and
maintenance of complex database
application was using SQL, PL/SQL, ETL,
OBIEE and UNIX scripting.
Drawing on Experience in all
aspects of analytics/data warehousing
solutions (Database issues, Data
modeling, Data mapping, ETL Development,
metadata management, data migration and
reporting solutions) I have been key in
delivering innovative database /data
warehousing solutions to the Finance
Industries.
Strong understanding of Data
Modeling (Relational, dimensional, Star
and Snowflake Schema), Data analysis,
implementations of Data warehousing
using Windows and UNIX.
Developed mappings to load the
data from various sources into the Data
warehouse different transformations like
Source Qualifier, Expression, Lookup,
Aggregate, Update Strategy and Joiner.
Extensive experience in
developing stored procedures, functions,
Views and Triggers, Complex queries
using SQL, ETL and Oracle PL/SQL
SDLC: 7 years of IT experience
in system analysis, design, coding and
testing. Extensive experience in the
Data Warehousing implementations, Data
Migration and ETL for Financial services
Domain.
Databases: 7 years of experience
using Oracle 11g/10g, SQL, PL/SQL,
SQL*Plus, SQL*Loader, TOAD, Oracle SQL
developer, HORA keep tool.
Database Development and
Analysis: 7 years of experience in
Database Development using mainly Oracle
database. Experience with Data
Cleansing, Data Profiling and Data
analysis. UNIX Shell Scripting, SQL and
PL/SQL coding.
Extensive Database / ETL
Performance Tuning: Broad Experience in
Database Development including effective
use of Database objects, SQL Trace,
Explain Plan, Different types of
Optimizers, Hints, Indexes, Table
Partitions, Sub Partitions, Materialized
Views, Global Temporary tables,
Autonomous Transactions, Bulk Binds,
Capabilities of using Oracle Built-in
Functions. Performance Tuning of ETL
Mapping and workflow.


Experience:

NPC-Vantiv, Louisville, KY
ETL developer/Database developer/Data
analyst/Reports developer
May 2011 to till date

Responsibilities:
Working with business users and
business analyst for requirements
gathering and business analysis.
Responsible for design and build
data mart as per the requirements.
Extracted Data from various
sources like Data Files. Extensively
worked on Views, Stored Procedures,
Triggers and SQL queries and for loading
the data (staging) to enhance and
maintain the existing functionality.
Done analysis of Source,
Requirements, existing OLTP system and
identification of required dimensions
and facts from the Database.
Involved in monitoring the
workflows and in optimizing the load
times.
Used Change Data Capture (CDC)
to simplify ETL in data warehouse
applications.
Involved in writing procedures,
functions in PL/SQL.
Worked with SQL*Loader tool to
load the bulk data into Database.
Extracted data from different
flat files and transformed the data
based on user requirement using ETL and
loaded data into target, by scheduling
the sessions.
Developed mappings and also in
tuning of mappings for better
performance.
Created reusable mappings and
Transformations starting concurrent
batch process in server and did backup,
recovery and tuning of sessions.
Created sequential batches and
concurrent batches for sessions.
Developed PL/SQL
procedures/packages to kickoff the SQL
Loader control files/procedures to load
the data into Oracle.
Worked Lookup, Joiner, Sorter,
Expression, Filter and Aggregator
transformations.
Written SQL Scripts and PL/SQL
Scripts to extract data from Database
and for Testing Purposes.
Supporting daily loads and work
with business users to handle rejected
data.
Performed Unit Testing and tuned
for better performance.
Created various Documents such
as Source-to-Target Data mapping
Document, and Unit Test Cases Document.

Netspend, Austin, TX
ETL developer/Database developer/Data
analyst/Reports developer May
2010 to Apr 2011

Responsibilities:
Involved in requirement
gathering and performed ETL Process.
Created Dimension Tables and
Fact Tables based on the warehouse
design, Wrote Triggers and Stored
Procedures using PL/SQL for Incremental
updates
Integrated various sources in to
the Staging area in Data warehouse to
Integrate and for Cleansing data.
Involved in building of the Data
Warehouse which includes the Design of
Data mart using Star Schema
Created the Source and Target
Definitions in ETL tool, Created
Reusable Transformations and mappings to
use in Multiple Mappings, Developed and
updated documentation of processes and
system
Developing database objects
using packages, stored procedures,
stored functions, cursors and ref
cursors, collections.
Done Modeling and populating the
business rules using mappings into the
Repository for Metadata management.
Involved in code-reviews and
performance tuning analysis and
implementations and worked on job
scheduling and production support for
this
Implemented Triggers, Views,
Synonyms, Hints, Partitioning of Tables,
Clustered and Non-clustered indexing.
Extensive work on the performance tuning
of Oracle ETL process.
Developed Standard Reports,
Cross-tab Reports Charts, and Drill
through Crystal Reports.
Writing PL/SQL procedures for
processing business logic in the
database. Tuning of SQL queries for
better performance.

Verizon Wireless, Warren, NJ
Database Developer/ETL Developer/Report
analyst Dec 2009 to Mar
2010

Responsibilities:
Involved in requirement
gathering and performed ETL Process.
Created Dimension Tables and Fact Tables
based on the warehouse design.
Wrote Triggers and Stored
Procedures using PL/SQL for Incremental
updates
Integrated various sources in to
the Staging area in Data warehouse to
Integrate and for Cleansing data.
Involved in building of the Data
Warehouse which includes the Design of
Data mart using Star Schema. Created the
Source and Target Definitions in ETL
tool
Created Reusable Transformations
and mappings to use in Multiple
Mappings. Developed and updated
documentation of processes and system.
Developing database objects using
packages, stored procedures, stored
functions, cursors and ref cursors,
collections.


Skills:
Programming Languages SQL, PL/SQL,
Advanced PL/SQL, ETL, OBIEE, UNIX Shell
scripting, Perl Scripting, OWB
Databases Oracle-9i/10g/11g
Data warehousing Tools Oracle Warehouse
builder, Dimensional Modeling and Data
warehousing Concepts.
Reporting Tools OBIEE 10g
Data Modeling Logical Modeling,
Physical Modeling, Relational Modeling,
ER Diagrams, Dimensional Data Modeling
(Star Schema Modeling, Snowflake Schema
Modeling, FACT and Dimensions Tables),
Entities, Attributes, Cardinality
Computing Platforms Windows XP,
Windows 2003 Server, Windows 9x.

Other Tools Oracle SQL developer,
Toad for Oracle data bases and TIDAL
enterprise job scheduler


Additional Information:
CERTIFICATIONS:
Completed the Oracle Certified
Professional (OCP) - (Oracle Database
11g: Advanced PL/SQL).
Completed the Oracle Certified
Professional (OCP) - (Oracle Database
10g: DBA).


Candidate Contact Information:
JobSpider.com has chosen not to make contact information available on this page.
Click "Contact Candidate" to send this candidate a response.


    





© 2021 Job Spider
Privacy Policy | CC Marketing Sites | Site Map | Links