Senior Etl Developer Resume
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.