Senior Software Engineer Resume
SUMMARY
Senior Software Engineer specializing in developing complex custom systems in C++ and Oracle. In - depth Object-Oriented development experience and excellent understanding of database concepts is complimented by a breadth of experience in additional technologies. Constant desire to learn and grow is combined with strong delivery skills, attention to detail, and a dedication to company success.
- 12 years of C/C++ experience (Object Oriented Design, STL, IPC, multi-threading)
- 15 years of Oracle database experience (SQL, PL/SQL, database design, administration)
- 4 years of Java development experience (Core Java, Swing, J2EE)
- 6 years of Visual Basic development experience
- 7 years of scripting experience (Perl, ksh)
SKILL OVERVIEW
Programming Languages:C/C++ (UNIX, Windows, MS-DOS), C#, PL/SQL, Pro*C/C++, Java 2, Visual Basic (3.0 - .NET), Perl 5, UNIX shells, sed, awk MS-DOS Script, HTML, DHTML, XML, VBScript, JavaScript, Fortran 77
Other technologies:
ASP, ODBC API and Windows API functions, ADO 2.0 - .NET DAO 3.0/3.5, ODBCDirect, RDO 1.0/2.0, JSP, JDBC, SQLJ Perl\'s DBI, Crystal Reports 4.0 - 8.5, bedrock, Instaknow 4.04
Operating Systems and Environments:
UNIX (HP-UX, DG/UX, SUN Solaris, FreeBSD), Red Hat Linux 9, Windows 95/98/2000/XP/Vista/7, Windows NT 3.51/4.0, Windows 3.11/DOS
Databases:
Oracle 7.x - 11g (SQL, PL/SQL, SQL*Loader, Imp/Exp, tkprof Oracle Forms 4.5), Informix 7.2 (Informix SPL, Informix-ESQL-C) Access 2.0-7.0/2003, MySQL 4.1 - 5.0, C-ISAM 4.10
Source Code Management:
MS Visual SourceSafe, CVS, MKS Integrity for Software Configuration Management, KnowledgeTree
ETL Tools:
DataJunction 8.0, Informatica PowerCenter 7.1.3
Additional Software Knowledge:
TOAD (Quest Software) 7.2 - 9.6, Oracle Enterprise Manager 9i - 11g Oracle SQL Developer, DB-Access 7.2, gdb,dbx,MS CodeView,Inno Setup compiler 5.1, Radmin 2.1, Reflection for UNIX & Digital 7.0, Hummingbird Host-Explorer (TN3270) version 10.0, Total Commander 5.51, JetForm Filler, VPN 5.0.1,VNC
Application/Web Servers:
WebLogic, RetrievalWare, Apache, IIS.
SYNOPSIS OF EXPERIENCE
Confidential, Mount Laurel, NJ
Lead Software Engineer / Oracle Database Programmer (Television Broadcast Industry)
Responsible for development and delivery of several components within DIVArchive, the industry-leading Content Storage Management system. Carry out all project phases from requirements gathering to system architecture, cross-team design validation, database schema design, and implementation of all tiers. Serve as the in-house Oracle expert and perform Oracle DBA activities as needed. Specific achievements include:
- Designed and implemented Storage Plan Manager and Disk Storage Manager DIVArchive components using C++ (STL, multi-threading, sockets), Pro*C, and Oracle. The components implement a highly customizable lifecycle for the users' multi-format video content, optimizing all actions for availability, reliability, and storage efficiency. Developed component implementations for Windows and *nix.
- Revamped and maintained DIVArchive Configuration and Control components using Java Swing and Oracle.
- Designed and implemented data aggregation functionality for DIVAprotect (DBMS JOB, dynamic SQL, and JDBC). DIVAprotect, a new DIVArchive option, aggregates raw storage event data, such as error and retry records, per different time intervals, and makes it available to digital storage infrastructure monitoring controls so that customers can be warned about media degradation and possible data loss.
- Designed and developed efficient custom Oracle tracing and error handling based on OraclePL/SQL best practice guidelines (ERROR package, LOG Package); defined a company-wide Oracle error-handling strategy.
- Defined database development standards and naming conventions for company-wide use.
- Performed basic DBA duties including user access management, schema design, storage management, database activity and performance monitoring.
- Provided third tier customer support. Created bug fixes, builds, releases and upgrades of the DIVArchive product to meet customer needs.
Confidential, Trenton, NJ
Senior Software engineer / Oracle Developer (Legal Data Aggregation Industry)
- Participated in design and development of the system performing daily case collection from Automated Case Management System for NJ courts (Mainframe/AS400) using C (shared memory, message queues, multi-threading, sockets) and ESQL-C Informix on UNIX.
- Participated in development of the ASCII Case Editor (ACE) using C++ with C-ISAM, shared memory, sockets, curses, and ESQL-C Informix on UNIX.
- Designed and developed CA Criminal Record collection application (Windows, Oracle, Visual C#). Designed database schema, wrote stored procedures, prepared functional and technical specifications. Developed test plans and program enhancements for the subsequent releases.
- Created Java Servlets & JSPs for the BEA WebLogic/RetrievalWare platform to develop, a search site for Criminal, Death, Bankruptcy, UCC, and other public records. Solely responsible for the database schema from initial design to production rollout.
- Used PL/SQL, ASP, Crystal Reports, ADO, and IIS to create an intranet billing system providing invoice generation and monthly and daily sales reports for credit cards and invoices.
- Designed, documented and developed the daily Instaknow collection of Mortgage/Deed records for various NJ counties. Developed NJ Real Property Editor for updating these records from external sources and loading them into the designed Oracle database using VB 6.0, Oracle 9i, DAO, Windows API functions, and Access.
- Participated in development of, a search site for Real Property, Civil Legal, and Commercial Filling records. Used C, Pro*C, Perl, JetForm, bedrock, Oracle 9i with Apache server to create the web site and Pro*C and kshell to create the billing system.
- Designed and developed multiplatform C++ utility libraries for company-wide use (G++ for UNIX and Linux, Borland C++ for Windows and DOS platforms).
- Created cron jobs for data collection and format conversion using Perl & kshell scripts.
- Developed Oracle Packages to validate incoming data according to internal business rules
- Developed kshell scripts for automated testing and for invocation of PL/SQL procedures with AutoSys.
- Developed Informatica/Data Junction ETL mappings, worklets and workflows to move data into target database.
Confidential, Jaminson, PA 9
Software Developer
- Designed and developed Corporate Database System using Oracle. Wrote database triggers, event handling triggers and local procedures as per the module specifications.
- Designed and developed Corporate Calendar, Corporate Telephone Book, Employee List, and Schedule ASP modules for the Home Care Corporate Intranet System. Created logical and physical Oracle database models for all of the Intranet System modules.
- Used Oracle Forms and PL/SQL to create a Billing and Information System for a stationery retail and distribution client.
- Designed and implemented content management modules for Carvell Home Care Company, using Visual Basic and ActiveX.
- Used Visual Basic to develop database driven content management applications for the Financial Model of The World Bank.
Confidential, Huntington Valley, PA 7
Programming and System Analysis teacher
- Designed and taught a lecture course on client-server application development using visual programming techniques, event-driven architecture, object-oriented programming (Visual Basic), ActiveX technology, data storage and manipulation concepts (Oracle, SQL, SQL*Plus, PL/SQL), database access methods (Data Controls, DAO, ODBCDirect, Remote Data Controls, RDO, ODBC API functions), and modern business application development techniques (Dynamic Data Exchange, DLL, Windows API functions, Crystal Reports).
- In lab session worked extensively with students designing, implementing, and debugging complete business application.
Confidential, Malvern, PA 6
Programmer and System Analyst
- Participated in developing of PQS (Price Quote System), which calculated costs of individual product types and total per-quite price ranges.
- Created and maintained logical and physical data models and a front-end Visual Basic application with an Oracle database as a back-end. Developed a package using PL/SQL, for handling errors.
- Developed and maintained logical and physical Oracle data models for CSC (Customer Service Center). Modified an existing database schema to repair incorrect or missing integrity constraints.
- Created PL/SQL packaged stored procedures, sequences and database triggers for CSC project.
CERTIFICATION AND TRAINING
- Expert Rating Certified Professional in C++ Programming
- Sun Certified Programmer Java Platform SCJP Java 6 in Progress
- Brain bench Certified in Java 2 Fundamentals
- Oracle Certified Database SQL Expert
- Brain bench Certified in Oracle PL/SQL Fundamentals
- BEA's class WLS-D Development with BEA WebLogic Commerce Server Version 6.0 and the J2EE Core Technologies
- Convera\'s class Developing Applications with RetrievalWare 8.1 search servers (Excalibur)