We provide IT Staff Augmentation Services!

Senior Etl Developer Resume

2.00/5 (Submit Your Rating)

SUMMARY

  • I am a professional Programmer/Developer with over 28 years of experience in IT.
  • I have over 10 years of programming experience and e xpertise in Client - Server application development using
  • Oracle 11g/10g/9i, PL/SQL, SQL PLUS, TOAD and SQL LOADER with strong experience in Data Warehouse concepts and ETL.
  • I have been involved in all phases of the SDLC (Software Development Life Cycle) from analysis, design, development, testing, implementation and maintenance with timely delivery against aggressive deadlines.
  • Other areas of expertise include: data flow diagrams, data dictionary, database normalization theory techniques, Entity relation modeling and design techniques.
  • I have excellent communication, interpersonal, and analytical skills and enjoy being part of a team.

TECHNICAL SKILLS

Databases: Oracle 9i/10g/11g (SQL, PL/SQL, Stored Procedures, Triggers)

ETL Tools: Talend, SQL Loader

Reporting Tools: Cognos Suite

Operating Systems: UNIX (Sun Solaris, LINUX, HP UNIX, AIX ), Windows NT/98/95/2000 & Windows XP/Vista/7/8/10

Languages/Utilities: SQL, PL/SQL , UNIX shell scripts, Java , XML, Perl, COBOL, and Korn shell scripts

Other Tools: PVCS, WIN CVS, Subversion, PL/SQL Developer, Toad, FTPSFTP

Applications: Oracle E-Business Suite version 11.5.10.2

PROFESSIONAL EXPERIENCE:

Confidential

Senior ETL Developer

Responsibilities:

  • Wrote a PL/SQL package to load two HR scorecard data flat files in text format from HealthCare Services into the data warehouse.
  • Wrote a PL/SQL package to copy data received from an outside vendor from an existing table into a new table while ensuring duplicate records were not copied.
  • Currently working on a PL/SQL package to import data from a SQL Server database maintained by an Ardent
  • Solved numerous production problems involving the loading of data received in text and XML formats from outside vendors into the data warehouse.

Confidential

Senior PL/SQL Developer

Responsibilities:

  • Wrote a PL/SQL package to provide data for a front-end screen using a ref cursor.
  • Wrote a SQL script to add metadata for a new Medicaid national payer.
  • Wrote a SQL script to restage claims for processing after the new payer was added.
  • Trained myself on Confidential ’s claims processing system written in PL/SQL.

Confidential

Programmer/Analyst

Responsibilities:

  • Worked with the state’s Edison Software (ERP) System.
  • Used Oracle SQL and PL/SQL to write applications for use in the PeopleSoft ERP system.
  • Wrote UNIX scripts to update PeopleSoft Oracle tables.
  • Made changes to PeopleCode using PeopleTools Application Designer.

Confidential

PL/SQL Developer

Responsibilities:

  • Wrote PL/SQL code to manipulate data stored in an Oracle 11g data warehouse.
  • Developed UNIX scripts to execute PL/SQL packages and procedures.
  • Used Cognos 10 to write reports after consulting with users to gather requirements.
  • Wrote message flows using IBM WebSphere MQ to interface with Sterling OMS.
  • Developed ETL jobs using Talend.
  • Reduced the processing time of the main overnight batch job by an hour.

Confidential

Application Developer

Responsibilities:

  • Primary company-wide contact for Oracle E-Business Suite 11i Purchasing, Payables, iProcurement, and iSupplier modules.
  • Designed, developed, and tested programs written in PL/SQL to meet customer's requirements.
  • Wrote Red Hat Linux scripts to perform tasks as required.
  • Used SDLC process to gather requirements and implement complex systems.
  • Worked extensively with Oracle Support and My Oracle Support to solve system problems.
  • Proficient in Oracle 11g DBMS, PL/SQL packages/ triggers/ stored procedures, SQL Plus, Oracle SQL, AME, XML, PL/SQL Developer, Oracle Workflow, XML Gateway, Oracle Message Designer.

Confidential

Computer Programming Supervisor

Responsibilities:

  • Developed, tested, and debugged applications programs using COBOL, SPEEDWARE (4GL), IMAGE, VPLUS, RPG and FORTRAN on an HP 3000 computer running MPE/iX.

We'd love your feedback!