We provide IT Staff Augmentation Services!

Sr Oracle Data Warehouse Developer/architect Resume

NC

SUMMARY

  • Overall 18 years of experience in complete software development life cycle (SDLC) using Oracle (12c/11g/10g/9i/8i/7.x). Worked as a Sr. Oracle Lead Developer for mentoring team at onsite and offshore with active participation in Database/data warehouse design, development, ETL processing, modeling, reporting and database development administration tasks.
  • Over 18 years of extensive experience working with Oracle databases (versions 7.x to 12c)
  • Expert in Oracle 10g/11g PL/SQL programming and Database Development Administration.
  • Expert in database modeling like conceptual, logical and physical models. Database physical schema designing and implementation.
  • Extensive experience in designing the schema, performance tuning, PL/SQL programming using Packages, Procedures, Functions, Triggers, DDL, DML, Indexes, Views, materialized views, Enhancing database performance, and generating ad - hoc reports with SQL*Plus.
  • Expertise in latest PL/SQL programming features, optimize the query performance (Bulk collect, bulk Binds, Materialized views, Inline views, hints etc). Well versed with DBMS Packages DBMS JOBS, DBMS SCHEDULER, DBMS PIPE, DBMS SQL, DBMS STATS, UTL MAIL and UTL FILE, DBMS OUPTUT etc
  • Good knowledge of Data warehouses/Data Marts, Dimensional modeling, Star schema, Snowflakes, slowly changing dimensions etc.
  • Performance tuning of the database queries using TKPROF, Explain Plan, dbms profilers etc.
  • Expertise in supporting very large database application systems and high volumes data
  • Performance tuning by creating indexes and gathering table and index statistics. partitioning large tables to maintain data in systematically and improve the huge data retrieval performance
  • Loading data between databases using Export, Import utility, data pump and loading data from flat files to database tables using SQL*Loader
  • Excellent knowledge of Oracle database tools such as Toad, PL SQL Developer, Rapid SQL, SQL Navigator etc.
  • In depth understanding of Oracle Architecture, memory and process structures
  • Experienced in working with Oracle Forms & Oracle Reports, Pro *C, Python, Perl scripting etc
  • Experience in all the phases of the Data warehouse life cycle involving design, development, analysis & testing of Data warehouses using ETL, Data Modeling, Online Analytical Processing & reporting tools
  • Good amount of experience in Data modeling (Dimensional & Relational) concepts like Star-Schema Modeling, Snowflakes Modeling, fact and dimension tables modeling of data at all the three levels: view, logical & physical
  • Designed and developed Informatica Mappings to load data from Source systems to ODS and then to Data Mart.
  • Extensively used Power Center/Mart to design multiple mappings with embedded business logic.
  • Creation of Transformations like Lookup, Joiner, Rank and Source Qualifier Transformations in the Informatica Designer.
  • Created complex mappings using Unconnected Lookup, Sorter, Aggregator, newly changed dynamic Lookup and Router transformations for populating target table in efficient manner
  • Experience in ETL tool like OWB, Informatica 6.2/5.1 developing Mappings, Workflows, Transformations
  • Exposure in handling different databases such as MS Access2002/2000, and SQL Server 2000
  • Domain expertise in Financials like Fixed Income, Derivatives, Cash, Wealth management etc.
  • Data modeling including conceptual, physical and logical modeling. Forward and reverse engineering using ERwin
  • Creation of logical and physical data models for OLTP.
  • Thorough understanding of Dimensional Modeling, Forward/Reverse engineering, Software Testing and Quality Assurance activities.
  • Expert in using Unix editors and utilities vi, sed and awk etc
  • Expertise in Korn-Shell scripting. Developed complex shell scripts for running warehouse jobs that can generate automated emails periodically. Extensively used job scheduling with Crontab for different periodicity levels.
  • Experienced in Operating System like Windows 98/2000/Xp/NT, Unix, Solaris 10.
  • Experience in Offshore Coordination whereby assisted many new system studies along with project /client management & logical analysis and design with PL/SQL batch processes in Development and Test area. Possess excellent problem solving, inter-personal and communication skills, proven self-starter capable of working on multiple projects

TECHNICAL SKILLS

OperatingSystems&Servers: Windows 2000, XP / NT, HP-UX 9.0/10.0/11,Solaris 10,ISS 5.1, Apache Tomcat, Oracle Web logic, Web sphere, JBOSS

Databases: Oracle 11g/10g/9i/8i/7.0, MS SQL Server 2000 / MS Access 2002/2000

Database /Dataware housingTools(ETL): Toad 9.2/8.6,PL/SQL Developer 7.1,OEM,ERwin7.0,Informatica 6.2/7.1,OWB,Designer 2000, SQL Navigator, Rapid SQL

Other packages: MS office

Configuration Management Tool: Visual Source Safe, Synergy, WinCVS, PVCS Tracker

Programming Languages: PL/SQL, SQL, Unix Shell Scripting, Pro *C

PROFESSIONAL EXPERIENCE

Confidential, NC

Sr Oracle data warehouse Developer/Architect

Responsibilities:

  • Architectural design, data analysis, planning and implementation
  • SQL and PL/SQL Programming, database administration and performance tuning
  • Data loading using SQL Loader.
  • PL/SQL Performance tuning and query Tuning.
  • Create database tables, indexes, procedures, packages, functions and other objects
  • Handling database release to production for updating patches and new enhancements
  • Preparing unit test scripts, setting up a test environment and UAT testing
  • Database maintenance and DBA activities like, export, import, creating users, tuning the queries etc
  • Tuning of database objects by creating and usage of indexes and gathering table and index statistics Develop Autosys job script to schedule the jobs

Environment: Unix, Oracle 12c, Python, Unix, Perl, Toad, SQL Navigator, SQL Developer, CVS, SQL Developer data Modeler

Confidential

Sr Oracle datawarehouse Architect/Developer

Responsibilities:

  • New Marketing and Ecom site database Architectural design, modeling and implementation
  • Support online database across the regions for various brands.
  • Designing of Ecomm sites for various brands and their regions
  • Designing new centralized repository for market analysis and business reporting for each region.
  • Create database schema, reporting schema for new markets across the globe.
  • Create tables, indexes, packages, procedures, functions etc.
  • PL/SQL programming, performance tuning and query optimization
  • Development DBA activities like, export, import, creating users, tuning the queries etc.

Environment: Unix, Oracle 11g, Toad, SQL Navigator, SQL Developer, CVS, SQL Developer data Modeler

Confidential, NY

Sr Oracle datawarehouse Developer/Development DBA

Responsibilities:

  • Architectural design, data analysis, planning and implementation
  • SQL and PL/SQL Programming, database administration and performance tuning
  • Data loading using SQL Loader.
  • PL/SQL Performance tuning and query Tuning(Generating Plan Table, Explain Plan, Optimizer with Hints, Analyze, Indexing strategy, SQL Trace, TKPROF etc)
  • Create database tables, indexes, procedures, packages, functions and other objects
  • Handling database release to production for updating patches and new enhancements
  • Preparing unit test scripts, setting up a test environment and UAT testing
  • Database maintenance and DBA activities like, export, import, creating users, tuning the queries etc
  • Tuning of database objects by creating and usage of indexes and gathering table and index statistics
  • Develop Autosys job script to schedule the jobs

Environment: Unix, Oracle 11g, SQL * Plus, Toad, Rapid SQL, SQL Loader, PL/SQL& SQL, SQL Developer data Modeler, CVS

Hire Now