We provide IT Staff Augmentation Services!

Sr. Etl Developer Resume

Glendale, CA

PROFESSIONAL SUMMARY

  • Over 9+ years of experience inApplication Development, Data Warehouse Development and Implementation using ODI, OBIEE, Oracle 11g/10g/9i, SQL, PL/SQL, Java technologies, Query Optimization, Performance Tuning and Troubleshooting
  • Extensive experience in writing SQLqueries and PL/SQL Stored Procedures, Functions, Packages, Database Triggers, Exception Handlers, Database Objects and Collections, by using PL/SQL
  • Implemented ETL logic for Oracle DB using ODI by building Packages, Procedures and Interfaces.
  • Created Dimension, Facts Measures, and Derived Measures as well as administering all layers in OBIEE Admin Tool.
  • Developed Reports and Dashboards in OBIEE based on Requirements.
  • Monitoring and optimizing the Database Performance through Database Tuning using Explain Plan and TKPROF
  • Monitoring and optimizing the Database Performance through Database Tuning, and Application Tuning
  • Developed Shell scripts in Korn/Bash and used Cron Jobs for Automation
  • Developed Perl Scripts for working with Oracle Objects and handled error logic
  • Proven ability to plan, coordinate and implement Software Development Life Cycle processes.
  • Handled database server tuning, application tuning, maintaining documentation, capacity planning and database security
  • Managed Release cycles in Development, Testing and Production environments.
  • Ability to handle multiple tasks and to work independently as well as in a team, experienced in interacting with Business/Technology groups
  • Multi-talented with excellent communication skills, strong decision making, organizational, coordination, planning, and execution skills.

TECHNICAL SKILLS

Languages:PL/SQL, SQL, Java, UNIX Shell Scripting, Perl

RDBMS : Oracle 10g/9i/8i, SQL Server 2000/7.0, MS Access

Database tools : Oracle ODI 11g, Oracle OBIEE 11g

Operating Systems : Windows 7/NT/XP, UNIX (HP, Solaris), Linux

Other Tools/Utilities : ERWIN Data Modeling, Informatica Power center

Web Development Tools : HTML, Java Script, XML, ASP 3.0, VBScript 6.0ls.

Work EXPERIENCE

Confidential

Glendale, CA

Role: Sr. ETL Developer

Responsibilities:

  • Participated in requirement gathering session with business users to understand and document the business requirements as well as the goals of the project.
  • Analyzed the source system (Claim Center) to understand the source data and table structure along with deeper understanding of business rules and data integration checks.
  • Created the normalized logical and the physical model with transactional facts, aggregated fact tables and the dimensions.
  • Developed ODI interfaces for loading the dimensions and facts.
  • Developed ODI variables and Packages for creating monthly snapshots.
  • Developed ODI Procedures and Packages an implemented the data integrity rules for the load.
  • Created ODI Agent and configured it for automating the jobs through the ODI Studio and Weblog Application Server.
  • Developed new ODI Package, interfaces, procedures and variables for Policy Monthly Snapshot.
  • Assisted in Developing the Report Logic based on the Warehouse data in OBIEE Admin tool.

Environment: Oracle 11gR2, ODI, Oracle OBIEE 5.2, Weblogic, Windows 86x, Windows

Confidential

Dallas Texas

Role: Application Architect

Responsibilities:

  • Developed new ODI Package, interfaces, procedures and variables for Policy Monthly Snapshot.
  • Developed new ODI Package and multiple Interfaces and implemented ETL and data Validation for Historical load of Claims Data.
  • Developed custom reports using Oracle Answers and assigned them to application specific dashboards.
  • Created connection pools, physical tables, defined joins and implemented authorizations in the physical layer of the repository.
  • Created Dimensional Hierarchy, Level based Measures and Aggregate navigation in BMM layer .
  • Performance tuning of Dashboard/Reports and made changes to database by implementing materialized views and partitions, rebuilding of indexes.
  • Developed new logic and ODI Package, interfaces, procedures for Earned Exposure.
  • Developed new Data Model for OII for 8.0 release based on Requirement by Business.
  • Fixed bug regarding Earned Premium join for LOB and Transaction based tables for WP Agent using Java.
  • Fixed Performance Bug using Oracle database techniques and also implemented Application level logic to reduce ETL load runtime.

Environment: Oracle 11gR2, ODI, Oracle OBIEE 5.2, Java 1.6, Windows 86x, Windows

Confidential

Houston, TX

Role: Oracle Application Consultant

Responsibilities:

  • Worked on FBW conversion project to implement new GRA to old GRA conversion e-Hub. Moved over 100k transactions during the change.
  • Developed new Oracle Packages, Procedure, and created new staging tables for FBW conversion to implement the logic.
  • Developed new Perl scripts for FBW conversion for implementing the loading process and the running Oracle Procedures and scripts handling the complex transactions processing for the conversion process.
  • Developed Packages for bulk updating of transaction table.
  • Incorporated validation process along with Oracle tuning incorporated in the packages.
  • Developed New Packages for updating of User Validation tables implementing data validation process along with different criteria’s for update process for different tables.
  • Developed a Perl script to load the data as well as handling validations and errors.
  • Developed Shell scripts for reporting new files in the specified directories and also implemented email functionality and automation using Cron Jobs.
  • Worked with the Business team for gathering requirements for providing High level estimations and precise logic was applied and converted into Functional Documentation and Technical design documentation.

Environment: Oracle 10g, SQL, PL/SQL, TOAD, Perl, UNIX Shell Scripts, Remedy 7.5,

Confidential

Fremont, CA

Role: Database Developer/Analyst

Responsibilities:

  • Involved in analysis, requirements gathering, functional/technical specification and development, deploying and testing.
  • Analyzed customer data and loaded data into multiple tables by using ETL procedure using External Tables.
  • Generate SQL and dynamic PL/SQL scripts to install, create and drop database objects including tables, views, primary keys, indexes, constraints, packages, sequences, grants and synonyms.
  • Created Materialized Views for database for faster queries.
  • Extensively involved in writing SQL queries (Sub queries and Join conditions), PL/SQL programming.
  • Developed Unix Shell scripts for running jobs in Unix.
  • Automated jobs by running Shell scripts in Cron Jobs.
  • Performed Performance tuning using EXPLAIN PLAN and Oracle HINTS.
  • Written many database triggers for automatic updating the tables and views.
  • Created indexes on tables and Optimizing Stored procedure queries.
  • Used Java Classes to produce Reports in Excel from Oracle Database.
  • Extensively used PL/SQL in reports to perform calculation and to get desired output.
  • Helped in development for front End – backend communications using JSP and Servlets on Tomcat 5.0
  • Testing, Integration System test, Implementation (test with users) and documented the entire project.

Environment: Oracle 10g, UNIX Shell Scripts, PL/SQL, TOAD, Java, Tomcat Server 5.0,

Confidential

San Francisco, CA

Role: Sr. PL/SQL Developer

Responsibilities:

  • Worked on implementation of the new CA Tools interface by interacting with Materialized views via Data pump.
  • Created complex Materialized views for CA Tools based on the different type of wholesale loans as specified by the business.
  • Involved in developing a new application architecture framework that is data driven to replace the current process driven.
  • Worked on Creating new PL/SQL Packages and Procedures for the AU-SU Changes for the LNU reports to run on the architecture framework.
  • Developed Stored Procedures, Packages, and Functions for CMS interface using PL/SQL for the batch framework
  • Worked on implementing the data movement strategy using the Oracle 10g feature of DBMS Data Pump API over the network to replace the legacy NDM and Oracle Export/Import process.
  • Worked on enhancements for flat file loading from Mainframe to Oracle database.
  • Responsible for loading multiple forms of data from Mainframe source using SQL*Loader.
  • Involved in converting the business requirements into technical design document.
  • Involved in tuning the long running PL/SQL queries for maximum efficiency in various business schemas of batch processing.
  • Worked with Business teams to make sure requirements were converted to Functional Documentation and the precise logic was implemented in the technical design and code.

Environment: Oracle 10g, SQL, PL/SQL, TOAD, SQL Loader, UNIX Shell Scripts,

Confidential

Fresno, CA

Role: Sr. Application Developer

Responsibilities:

  • Participated in gathering the user requirements and involved in writing technical design documents.
  • Worked on ticketing system where problem tickets were assigned to the respective developers.
  • Worked with more than 20 clients to deliver new products, upgrades and program fixes.
  • Responsible for coding stored procedures, functions and triggers and other scripts based on functionality of the domain using PL/SQL.
  • Improved Query performance by using EXPALIN PLAN and TKPOF and SQL Trace tuning tools.
  • Created table partition and indexing for large tables to improve performance.
  • Proactively monitor, preempt, diagnose and rectify database-related issues.
  • Development of several PL/SQL stored procedures using varied table structure to generate detailed reports based on timelines.
  • Developed ETL using SQL*Loader for importing data into tables.
  • Developed Unix Shell scripts for production, communicating with oracle servers and other servers to run processes and automate jobs using Cron jobs.
  • Developed Java code for creation of Excel based reports.
  • Resolved application problems to maintain high level of customer satisfaction.
  • Responsible for definition and management of schemas and objects and monitoring, tuning and troubleshooting of Oracle databases.
  • Create database links between production databases.
  • Migrated tables and indexes to different table spaces to store in the appropriate tables using PL/SQL and Shell Scripts.
  • Participate in data sourcing, extract data investigation process, work with teams to develop PL/SQL, code to extract, clean and sort data for flat file generation.

Environment: Oracle 9i, SQL, PL/SQL, TOAD, SQL Loader, UNIX Shell Scripts, UNIX

Confidential

Hyderabad, India

Role: Database Analyst

Responsibilities:

  • Participated in the requirements, designand implementation, integration, testing and documenting the system.
  • Designed and developed triggers and views to support the application. PL/SQL, Oracle.
  • Designed and developed a stored package and procedures to manage contract escalation. PL/SQL, Oracle.
  • Designed and assisted with test procedures.
  • Conducted code reviews and data model walkthroughs.

Environment: Visual Basic 6.0, ORACLE 7.x/8.0, PL/SQL, Windows NT.

Confidential

Role: Database Analyst

Responsibilities:

  • Created the application database using RDBMS concepts.
  • Performed coding, testing, debugging and deploying.
  • Designed the database using relational database management systems.
  • Coded SQL, PL/SQL generating triggers and procedures.
  • Developed Front-End Applications and Reporting System.
  • Performed application deployment and user training .

Environment: ORACLE 7.x/8.0, PL/SQL, Windows NT

Hire Now