We provide IT Staff Augmentation Services!

Etl Integration Engineer Resume

3.00/5 (Submit Your Rating)

Cincinnati, OH

SUMMARY:

  • A software engineer with 15+ years of combined software development and technical support experience
  • Background includes software development, web development and maintenance on distributed systems and PCs
  • Experience in networking, system administration, OLAP tools. Major strengths include:
  • Problem Solving
  • System Administration
  • Analytical Skills
  • Consulting Experience
  • Communication Skills
  • Systems Integration

TECHNICAL SKILLS:

HARDWARE: Sun SparcStation 5, Pentium/Pentium II/III/IV

SOFTWARE: Solaris 2.5x, Windows 95/98/NT 4.0/2000 Server/XP, Linux, MS FrontPage 97/98/2000/2003, Macromedia Dreamweaver 8, COGNOS BI v8.1.2/8.2, MS Access 97/2000/2003, Visual InterDev, Java v2.0, JavaScript, VBScript, ASP, HP TestDirector for Quality Center, Netscape Enterprise Server 2.x/3.6x, MS IIS 5.x/6.x, Oracle v7.3x/8.1.x/9i/10g, TOAD for Oracle v8.6, Oracle SQL Developer, PERL 4.0/5.0, C/C++, RogueWave Tools v6.x/v7.x, Visual Basic v4.0, Omnimark v4.0, Macromedia Flash 4.0, Macromedia Dreamweaver 8, SABLIME Configuration Management for UNIX, PVCS Configuration Management

EXPERIENCE:

Confidential, Cincinnati, OH

ETL INTEGRATION ENGINEER

Responsibilities:

  • Performed development and maintenance on PL/SQL packages and stored procedures for an integration effort to load SAP data into an Oracle 9i online retail database
  • Modified and developed Unix Korn shell scripts to automate the integration effort to work with IBM AS/400 Control - M job scheduler software
  • Responsible for configuration management of scripts, PL/SQL packages and stored procedures

Confidential, Cincinnati, OH

WEB DEVELOPER

Responsibilities:

  • Performed maintenance and development on secure website using ASP (VBScript), Javascript, Macromedia Dreamweaver 8, with an Access 2003/HP 3000 Image DB backend
  • Assisted with the architectural redesign of website to increase security of login process and eliminate database inconsistencies and errors
  • Performed setup and configuration of IIS v6.0 development server

SR. CONSULTANT

Confidential

Responsibilities:

  • Developed 25 ETL applications in PL/SQL to load XML data into an Oracle 10g pharmaceutical database
  • Wrote custom reports in SQR for management data tracking
  • Performed limited Oracle administrator duties using Oracle SQL Developer
  • Wrote process automation scripts on a UNIX platform

Confidential

SR. SYSTEMS APPLICATIONS INTEGRATOR

Responsibilities:

  • Installed and configured COGNOS 8.1.2/8.2 BI within a US Air Force secure server environment
  • Wrote COGNOS reports using Report Studio
  • Performed COGNOS administration duties, including account creation and management
  • Integrated COGNOS technology with custom web applications using Macromedia Dreamweaver 8, ASP, Javascript and Oracle 10g to meet customer-specific needs
  • Performed web administrator duties using Microsoft IIS 5.0
  • Performed limited Oracle administrator duties using TOAD and native Oracle development tools

Confidential, Fairborn, OH

WEB APPLICATIONS DEVELOPER

Responsibilities:

  • Developed, supported and performed maintenance on Weighted Guidelines (WGL) website using Active Server Pages (ASP), Javascript, Microsoft FrontPage and Oracle 9i/10g
  • Performed limited Oracle administrator duties such as table creation and account administration
  • Assisted WGL users by providing telephonic support and performing system administrator duties
  • Performed backups and archival of development, test and production application software
  • Tasked with evolving the WGL web application to meet future environment and system integration needs
  • Performed data migration for government legacy systems using ETL methods with PL/SQL for production Oracle 9i/10g data warehouse
  • Actively worked with Functional Analysts to ensure accuracy of data mapping and profiling
  • Participated in code reviews to ensure software was designed within functional specifications
  • Performed version control and configuration management using PVCS
  • Created documentation for support of back-end systems and databases
  • Developed custom UNIX scripts to automate manual processes
  • Provided support for government websites, using ColdFusion and JavaScript
  • Developed custom, dynamic ColdFusion application for secure web server
  • Performed system administrator duties for web and file servers
  • Provided to staff on support of government web sites, support personnel using Microsoft FrontPage, Microsoft IIS, ColdFusion Server and ColdFusion Studio
  • Created support documentation for future support

Confidential, Miamisburg, OH

SENIOR SOFTWARE ENGINEER

Responsibilities:

  • Developed, tested and implemented software in Omnimark to convert SGML formatted vendor data into Confidential proprietary data format
  • Developed/supported intranet web tools using HTML, JavaScript, PERL and Oracle to process data and increase productivity of data technicians and engineers
  • Administrated Netscape Enterprise Server (NES v2.x, 3.6x) for departmental intranet
  • Responsible for configuration management, troubleshooting and user
  • Developed telecommunication scripts in PERL, Bourne shell and C shell, to transfer data via FTP and E-mail

Confidential, Miamisburg, OH

SOFTWARE ENGINEER

Responsibilities:

  • Developed, tested and implemented software written in C, C++ and Flex in a UNIX environment to convert vendor data Into Confidential proprietary data format
  • Performed maintenance on production software applications and scripts (bug fixes, re-engineering and software enhancements)
  • Wrote UNIX shell scripts to automate vendor data collection and data loading processes
  • Developed support documentation for conversion software
  • Acted as PC/Workstation test lab administrator (telecommunications troubleshooting, data analysis and hardware/software testing)

Confidential, Franklin, OH

WEB DEVELOPER/SYSTEMS ENGINEER (Part Owner)

Responsibilities:

  • Developed custom web sites and solutions for customers using Microsoft FrontPage, IIS, JavaScript and CGI scripts in PERL
  • Performed system administration duties (including system maintenance, system installs and file backups) on a Linux internet server
  • Performed hardware and software upgrades/installs on a 5-node workstation network
  • Configured web server software, including Apache 1.4x/1.5x and Microsoft IIS 3.0
  • Uncovered new business opportunities

Confidential, Miamisburg, OH

TECHNICAL CONSULTANT

Responsibilities:

  • Resolved customer technical problems telephonically within various environments such as Windows, UNIX, DOS, Macintosh, and DEC VAX
  • Experienced in troubleshooting various systems, from individual dial-up, TCP/IP, X.25 and Private Nodes
  • Performed and developed materials and documentation for new staff members
  • Developed materials for continuing programs

We'd love your feedback!