We provide IT Staff Augmentation Services!

Senior Oracle Database Etl Developer Resume

2.00/5 (Submit Your Rating)

Glendale, AZ

SOFTWARE DATABASE DEVELOPER

  • Software Developer with a focus on ETL, Informatica, Oracle, SQL and PL/SQL, Forms and Reports, UNIX, SAS, Windows, Perl, Data Warehousing, SQL Server Certified, Teradata, Postgres SQL in VM and Cloud environments.
  • Experience using such applications as VI, MS Office Suite, TOAD, and SQL Developer.
  • SVN & GIT Tortoise, work on multiple platforms including Solaris UNIX, Windows, DOS, Cloud. ERD Data Modeling with TOAD, ERWIN and VISIO.
  • Comfortable working in SDLC Agile or Waterfall environments and working directly with Business and Customer groups.
  • API, Query Optimization, Performance Tuning, System Monitoring, Data Archiving, Oracle System and User Session Monitoring and Load Balancing

TECHNICAL SKILLS

  • Oracle SQL; PL/SQL; ETL Advanced Intermediate 10+ Years
  • TOAD Advanced Intermediate 10+ Years
  • UNIX/Linux Advanced Intermediate 10+ Years
  • Korn Shell Scripting (ksh) Advanced Intermediate 10+ Years
  • SQL Optimization Intermediate 5 Years
  • Query Performance Tuning Intermediate 5 Years
  • SAS Intermediate 4 Years
  • ERWIN, VISIO, TOAD Modeler Intermediate 4 Years
  • Forms and Reports Intermediate 2 Years
  • SQL Server Intermediate 1 Year
  • PostgreSQL Intermediate 1 Year
  • Informatica Intermediate 2 Years
  • Teradata SQL Assistant Intermediate 1 Year
  • Perl Intermediate 2 Years

PROFESSIONAL EXPERIENCE

Confidential, Glendale, AZ

Senior Oracle Database ETL Developer

Responsibilities:

  • This position is working in an Oracle 11g Linux environment, creating ksh scripts for staging law enforcement data for ETL processing.
  • Working on PL/SQL Packages, Procedure, Functions, Triggers, Views and Optimization. Query Tuning, System Performance and User Session Monitoring.
  • Toad Optimization, APIs, Backup Sr. DBA role. Using Microsoft TFS for reversion control in a full SDLC Agile Software Development environment.
  • Troubleshooting and providing solutions to current production workflow.
  • Project management using JIRA in Agile Kanban on a small team to plot future venues for company objectives and best practices.
  • Agile adoption in April 2018 under new management from the main office

Confidential, Phoenix, AZ

Solutions Analyst

Responsibilities:

  • This position is within an Agile environment, primarily focused on predict emerging customer needs and develop innovative solutions, proposing simple and effective solutions to meet the business needs, working closely with both business partners and developers to solve unique and complex problems with comprehensive results, participating and contributing to the development of constructive application design, leading large, complex projects to achieve key business objectives, isolating performance bottle necks and recommending technical solutions, translating significantly complex models to simplify for given audiences.
  • I must be the development point of contact for end - to-end project delivery, with strong analytical and problem-solving skills to work well as a team player with excellent communication skills. Using SVN Tortoise

Confidential, Tempe, AZ

ETL Database Developer

Responsibilities:

  • This position was primarily focused on ETL Informatica with Teradata and Oracle development and adjustments, along with creations of Oracle Forms and Reports, 6.1, 10g and 11g.
  • The company provides healthcare solutions for prescription drug validation and RX claims retention, using JIRA in an Agile and Waterfall environment, using Request Tracker (RT) ticketing system.
  • Developed ETL workflows with Informatica and also worked on homegrown Oracle Forms/Reports PBM application, working on a team of 10 - 12 developers to collaborate and resolve issues quickly to maintain a smoothly running production environment, developing in Oracle PL/SQL, SQL, Forms and Reports; KSH scripting with Informatica on Teradata to support job scheduling. Proficient with Kimball’s Dimensional Modeling, Performance Tuning of procedures and functions in Data Warehouses environment, creation of database objects, (tables, triggers, packages, views, materialized views and partition tables, etc.)
  • Modeling using ERDs in TOAD Modeler and Visio. Using SVN Tortoise

Confidential, Scottsdale, AZ

Database Developer

Responsibilities:

  • This position was very diverse and involved working with Oracle, SQL Server, and PostgreSQL development, within VM and Cloud environments.
  • Projects are designed and managed based on the Agile methodology.
  • Provided troubleshooting within their in - house Java Database Application Team for Immunization and Vaccine repository for 18 States, for hospitals and private practices participating in the ASIIS program in collaboration with the CDC at State Level.
  • Much of the work being done is on the cutting edge for this industry and is very well received and growing.
  • Many new products and clients are in process with a bright future for the company.
  • Last project involved working on a BI tool called SMaRT DSP which runs in the SQL Server model built within the Microsoft SSRS environment.
  • This product will allow Health Information to be displayed not only on PC and Laptop, but also Smart Mobile devices. Skills Used: Oracle PL/SQL, SQL Server, PostgreSQL, SVN & GIT Tortoise

Confidential, Tempe, AZ

ETL Developer

Responsibilities:

  • This position was ETL development within a 6TB 24/7 accessible Oracle 10g/11g Data Warehouse Environment.
  • Projects were produced within a mostly Agile with some Waterfall SDLC environments, and interactive role in working with business groups to gather project parameters based on customer requirements.
  • Tasks included utilizing Oracle PL/SQL and KSH scripts to process data from the Mainframe source for transformation and aggregation for Custom Data Marts. Daily tasks included creation of PL/SQL packages, procedures, functions, and triggers to complete project requirements and assisting with BI projects in SSRS.
  • Data was provided from the Mainframe and sent to the Unix Server, then processed as an external table or SQLLDR into staging tables and processed per requirements.
  • Also, as part of the conversion to Informatica ETL processing using Data Exchange and Power Center, my role involved creating work flows, mappings and transformations to complete custom projects. Moreover, as the new environment evolved, data was being pulled via power center into Informatica and processed per requirements into business data marts.
  • Creation of documentation of project specifications and test results made available to QA and UAT groups.
  • Received training with Informatica University on Development Level 1 and Level 2, with hands on experience transitioning to Informatica as that environment matured. Skills Used: PC Putty, Solaris UNIX, Oracle SQL, PL/SQL, SQL*Plus, KSH Scripts, TOAD, Text Pad scripting editor, Power Center, Informatica, SSH and RSA Admin. SVN Tortoise

Confidential, Phoenix, AZ

PL / SQL Developer

Responsibilities:

  • Provided PL/SQL and ETL Development for customer in - house reporting application called IPS.
  • Creating PL/SQL Packages, triggers, procedures and KSH and modifying JAVA scripts as required by business ETL requirements in an Oracle 10g Data Warehouse.
  • Role was very interactive and involved working with business groups to gather specifications for modification of existing reports. Skills Used: PC Putty, Solaris UNIX, Oracle SQL, PL/SQL, SQL*Plus, KSH Scripts, TOAD, Text Pad scripting editor, Java, PL/SQL Developer, SQL Developer with SVN Tortoise

Confidential, Tempe, AZ

Senior Database Programmer Analyst

Responsibilities:

  • Primary job responsibilities included development and production support of Manugistics Supply Chain Management Software.
  • Java based application front - end to Oracle 9i Data Warehouse residing on Solaris 10 Server.
  • Developed Korn shell and XML UNIX scripts in unison with Oracle SQL and PL/SQL scripts to integrate business ETL logic and rules to create and maintain a smooth operating production environment.
  • This role involved gathering specifications from business groups for creating ad-hoc and automated SQL Reports based on requirements.
  • Starting with a 10 Arizona Store pilot program in 2006, application was rolled out to over 620 Arizona Stores; provided support to continue roll out to the entire United States.
  • Rewrote the entire data feed for the application after discovering 5 separate feeds out of sync and was able to rectify and normalize the entire data warehouse.
  • Skills Used: PC Putty, Solaris UNIX, Oracle SQL, PL/SQL, SQL*Plus, KSH Scripts, TOAD, Text Pad scripting editor, Manugistics, Java, XML, assisting Cognos BI processing.
  • Modeling with ERDs in ERWIN and TOAD Modeler with SVN Tortoise.

We'd love your feedback!