Etl Integration Engineer Resume
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