Oracle Resume
Reston, VA
QUALIFICATION HIGHLIGHTS
- Over 11 years experience in the Financial, Healthcare, and Telecommunication fields.
- Over 8 years experience in Perl development and design.
- Over 11 years experience in Oracle SQL
- Over 5 years experience PL/SQL.
- Over 3 years experience with Java and J2EE development and design.
- Exceptional ability to quickly analyze and resolve complex problems.
- Quick to learn and master new technologies.
- Excellent verbal and written communication skills.
- Experienced in all phases of the SDLC.
- Experience developing, deploying, and supporting code within the Sarbanes Oxley (SOX) guidelines.
- Experience mentoring, leading, and training junior developers.
- Ability to work with little supervision.
- Experience serving as the change management coordinator performing code integration, builds, and release documentation for my team.
- Experience performing Java builds and deploying code to production environments
TECHNICAL SKILLS
- Databases
- Oracle 8, 8i, 9i, 10g, Oracle SQL, Oracle PL/SQL, Oracle SQL Loader, Oracle Export/Import, other basic Oracle database administration tasks
- Sybase (11, 12), Sybase Transact SQL
- MySql
- Programming Languages
- Perl 5.x, Perl DBI, Strawberry Perl, ActiveState Perl, DBI, DBD::Oracle, Sybperl, Log4Perl, Spreadsheet::WriteExcel, Spreadsheet::ParseExcel, Archive::Tar, Net::FTP, XML::Simple, Date::Pcalc, Date::Calc, and CGI
- Java/J2EE, JSP, Servlets, Java Beans, JDBC, JavaMail, Jakarta Commons (Bean Utils, Logging), JSTL, Threads, Sockets, Struts
- UNIX Shell Scripting (Korn/Bourne/C Shell)
- Sybase 11.x/12.x Transact SQL
- HTML, CSS, JavaScript, XML, PHP
- Tools
- Crystal Reports
- Eclipse, EasyEclipse Server, JDeveloper, Ant, Maven
- Toad, SQL Developer, RapidSQL
- Secure Shell (ssh, scp)
- Autosys, Tidal Job Scheduling
- Web and Application Servers
- BEA Weblogic (8 and 10), Apache, Tomcat, IIS
- Change Management Software
- Rational ClearCase, Rational ClearQuest, Remedy
- Operating Systems
- Linux, AIX, Windows (NT/2000/XP/Vista), Microsoft Office (2003, XP, 2000, 97)
- Billing System Software
- Comverse FX 12.0, Kenan BP (versions 8, 9,11)
PROFESSIONAL EXPERIENCE
Confidential, (Reston, VA) ? June 2009 to present
Technical Change Management/Deployment Team (Contract)
Tools and Technologies:
- Rational ClearCase/ClearQuest, UNIX, Perl, Korn Shell Scripting, Ant, Maven
Project:
- Home Affordability and Stability Plan (HASP) Project (Includes Home Affordable Modification (HAM) and Home Affordable Refinance (HAR))
Responsibilities:
- Support deployment activities for the Home Affordability and Stability Plan (HASP) and Advantage Project
- Support of more than 50 projects
- Support automation of the build and deployment process
- Document and provide status of the deployments to management
- Development and Modification of Java build scripts to automate Java build processes using Clearcase ANT tasks to extract code from the Source code repository
- Performing Java builds using Maven
- Ensuring adherence to change management controls
Confidential, (Glen Allen, VA) ? May 2008 to March 2009
ETL Developer, PL/SQL and Perl Developer (Contract)
Tools and Technologies:
- Oracle 9i and 10g, PL/SQL, Perl 5.8.2, AIX, Korn Shell Scripting, Toad 9.1.0.62, Putty, Remedy Change Management, Filezilla
Responsibilities:
- Gathering and documenting requirements for system enhancements and defects.
- Researching and determining root causes of system failure and extract issues.
- Developing and performance tuning Oracle PL/SQL, packages, procedures, functions, and triggers using parallel query, bulk collects, and Oracle Collections.
- Developing Oracle PL/SQL packages and procedures for extracting or loading of files for internal and external sources.
- Working with large Oracle databases with sizes over 1TB.
- Developing Perl Scripts to transform data and to drive execution of PL/SQL Packages and procedures.
- Perl Modules Used: Spreadsheet::ReadExcel, Archive::Tar, Cwd, Data::Dumper, DBI, File::Basename, File::Copy, File::Path, Getopt::Std, Date::PCalc, Date::Calc
- Developing Korn Shell scripts to run job streams.
- Architecture and development of an object oriented Perl script used to retrieve and load the prescriber information files received from HCIdea.
Confidential, (Beltsville, MD) ? May 2007 to April 2008
Java/J2EE/Perl/UNIX Shell Developer (Contract)
Tools and Technologies Used:
- Kenan BP 11.0, Kenan FX 12.0, Oracle 9i, Oracle Database 10g, Java, Servlets, JSP, DynaBeans, Displaytag, Struts, Easy Eclipse Server Edition, Tomcat, Ant, XML, BEA Weblogic Server, Crystal Reports, Oracle PL/SQL, Rational ClearCase, Rational ClearQuest
Project:
- Kenan System Upgrade project. Upgraded the billing system from Kenan BP 11.0 to Kenan FX 12.0. I worked on Crystal Report changes and conversion of a Perl based reporting application into a Java/J2EE based reporting application.
Responsibilities:
- Working on the Kenan BP 11.0 Upgrade to Kenan FX 12.0 project.
- Developed the architecture and design for a new user reporting application.
- Developed Oracle tables and PL/SQL packages, procedures and functions.
- Developed the reporting application using Java/J2EE, Servlets, JSP, Jakarta Commons (BeanUtils), JSTL, XML, PL/SQL, EasyEclipse Server, Tomcat, Ant, and BEA Weblogic.
- Documenting requirements and design for Crystal Reports changes.
- Changing complex views to support database schema changes in the billing application.
- Modification and unit testing of Crystal Reports.
- Modification of Perl scripts due to database changes using Perl DBI, SQL, PL/SQL.
- Troubleshooting and code fixes to a Java Applet used in an invoice viewing application.
Confidential, (Glen Allen, VA) ? September 2006 to April 2007
ETL Developer, PL/SQL and Perl Developer (Contract)
Tools and Technologies Used
- Oracle (8i, 9i, 10g), Oracle PL/SQL, Perl 5.6, AIX, Toad 9.0, Korn Shell, Object Oriented Perl, Putty, Filezilla.
Project:
- National Provider ID Project. The project was to analyze existing processes to determine the changes necessary to comply with new requirements for usage of the National Provider ID. Documented changes to the extract and load processes, made necessary code changes, and documented test results.
Responsibilities:
- Working on the NPI project to add the National Provider ID to internal and external data extracts.
- Documenting requirements for the changes needed for external and internal clients.
- Designing and documenting the changes necessary to the Oracle PL/SQL, Perl, Perl DBI, and Korn Shell code to meet the requirements.
- Updating the PL/SQL, Perl, and Korn shell code, testing, and documenting the results to ensure the changes have been implemented correctly.
- Redesigned and developed a Perl script using Object Oriented Perl to support reusability of the code.
- Providing leadership and mentoring junior developers.
- Taught an Introduction to Perl class for team members.
Confidential, (Herndon, VA) ? April 2005 to August 2006
Senior Production Support Consultant - Restatement Project (Contract)
Tools and Technologies Used:
- UNIX, Ab Initio, Korn Shell, Perl, Rational ClearQuest, Oracle 10g
Project:
- Restatement Project. I served as a member of the 24/7 production support team monitoring execution of the work streams. Coordinated emergency changes when failures occurred between the testing, development, user acceptance test, release management, environment and database support teams.
Responsibilities:
- Served as a Senior Production Support Analyst on Fannie Mae’s Restatement Project.
- Monitoring of Production Code Execution and troubleshooting of defects with Ab Initio graphs, korn shell scripts, and Autosys command jobs.
- Developing Korn Shell and Perl scripts to support ad hoc user requests.
- Working with the testing, development, database and UNIX administrators to resolve defects.
- Providing level 1 support to Fannie Mae Restatement teams.
- Coordinating code redeployment with development, test, user acceptance test, change management, and release management teams.
- Developed scripts to run end to end smoke tests of code prior to deployment to test environments.
- Developed Korn shell scripts to check for code standard violations.
- Providing leadership and mentoring junior analysts.
Confidential, (McLean, VA) ? September 2005 to December 2005
Senior Database/Java Developer (Contract)
Tools and Technologies Used:
- UNIX, Korn Shell, Perl 5.6, Perl DBI, Sybase 12.0, Oracle 9i, Java, XML, and JasperReports.
Project:
- Eagle Conversion Reconciliation Project. Development of a reconciliation system between the legacy financial reporting system and the Eagle STAR/PACE system.
Responsibilities:
- Execution of load processes for the Eagle STAR/PACE system.
- Developed a conversion reconciliation system used to verify the accuracy of the conversion from a custom built in-house accounting reporting system to Eagle STAR/PACE.
- Developed the system using Perl, DBI, Sybase, Java, XML, and JasperReports.
- Analyzed differences between outputs from the legacy system and the Eagle STAR/PACE system.
Confidential, (Herndon, VA) ? January 2005 to September 2005
Data Warehouse Developer (Contract)
Tools and Technologies Used:
- Oracle 9i, PL/SQL, Teradata, Perl 5.6, Perl DBI, Korn Shell, Informatica, Java, JavaMail, Jakarta POI, MySQL, SQL Server 2000, XML
Project:
- Upgraded a Perl/Korn Shell/Oracle data mining application to a Java/Perl/Oracle data mining application to decrease the run time. Converted data loads from Oracle to Teradata.
Responsibilities:
- Solution developer in the Enterprise Data Warehouse.
- Converted a Perl DBI and Korn Shell data-mining program to a multi-threaded Java and Perl program to decrease the processing time.
- Performance tuned Oracle SQL queries and PL/SQL Procedures using the parallel query feature, indexes, and processor hints.
- Developed Informatica workflows to load data into the Enterprise Data Warehouse.
- Conversion of the data-mining program from Oracle to Teradata.
- Developed Java program to read email using JavaMail, detach any attachments and extract spreadsheets from Excel workbooks by creating text files using Jakarta POI.
- Working with various databases such as Oracle, SQL Server, Teradata, and MySQL
Confidential, (McLean, VA) ? August 2003 to December 2004
Senior Sybase/Perl/UNIX Developer (Contract)
Tools and Technologies Used:
- Sybase (11, 12), Sybase Transact SQL, Perl 5.5, Korn Shell, Rational ClearQuest, Rational ClearCase.
Project:
- Restatement Project. Analysis and development of a new financial reporting application for the Securities Sale and Trading Group (SS&TG) to support revised business rules. Development for the Close the Books initiative for ongoing monthly close processes.
Responsibilities:
- Developer working on an ETL (extract, transform, and load) project team to design and develop a new accounting reporting system used to create accounting journal entries for the Freddie Mac Restatement Project.
- Worked with the business users and business analysts to gather and document requirements and designs.
- Design and information architecture of tables and procedures, coding scripts in Perl, Korn Shell, and Sybase Transact SQL.
- Developed a scalable, configurable solution to handle the execution of our work-steams.
- Performance tuning of SQL to minimize processing times.
- Successfully decreased the run time of a process from 3 ½ hours to 30 minutes.
- Participated in design and coding reviews.
- Created detailed documentation of the extract logic to allow auditors to follow the data from source system to extract tables, to journal entries.
- Worked with new developers to transfer the knowledge of the system for phase 2 of the development.
- Served as the deployment coordinator for my team, developing ANT build scripts to create builds of our code from the Rational ClearCase version control system.
- Promotion of code from the development region to the integration stream.
Confidential, (Beltsville, MD) ? November 2001 to August 2003
Software Engineer III
Tools and Technologies Used:
- Kenan Arbor/BP 8.1, Solaris UNIX, Java, JSP, Servlets, Java Beans, JDBC, Weblogic 8.1, Perl, Perl DBI, HTML, CSS, Rational ClearQuest, Oracle 8i, PL/SQL, XML
Responsibilities:
- Software Engineer in the Federal Billing Development and Production Support Group.
- Analyzing requirements, designing, and coding interfaces to an Oracle 8i database used by the Kenan/BP billing system.
- Developing processes and scripts to help resolve billing problems.
- Developing interactive Perl DBI programs to allow users to run common queries to assist with error correction and perform customer inquiries.
- Developing file feed utilities and revenue reports pulling information from multiple databases.
- Serving as the IT Team member of several task forces aimed at resolving billing discrepancies.
- Development of custom Perl modules to encourage code reuse.
- Conversion of Microsoft Word Operations Guide to an Intranet page using HTML and CSS.
- Developing web applications using Java Server Pages, Servlets, Java Beans, and JDBC to enable users to enter billing process setup information, and view billing process log information.
- Installation, configuration, and administration of BEA Weblogic Server 8.1.
- Developed conversion scripts to assist with conversion from a legacy change management system to Rational ClearQuest.
Confidential, (Herndon, VA) ? September 2000 to August 2001
Kenan BP Billing Developer (Contract)
Tools and Technologies Used:
- Kenan Arbor 8.1, Perl, Oracle 8i, PL/SQL, VBA, Crystal Reports, Korn Shell
Responsibilities:
- Developer/Analyst for the International billing platform.
- Configuration and support of Arbor/BP billing system.
- Configuration of recurring and non-recurring charges, discount plans, and creation of custom roles (groups).
- Developing scripts with Perl, SQL, and PL/SQL to support development, testing, and production support activities.
- Support of applications written using Visual Basic for Applications (VBA) and Seagate Crystal Reports.
- Troubleshooting of the Production, Testing, and Development environments through SQL and UNIX investigation.
- Developed and delivered an introductory UNIX class.
Confidential, (Ashburn, VA) ? January 2000 to August 2000
Kenan BP Billing Developer (Contract)
Tools and Technologies Used:
- Kenan/BP 8.1, Unix, Sybase 11.9.2, Perl, Korn Shell
Responsibilities:
- Tier-II support for CSG Kenan/BP 8.1 (for Unix/Sybase 11.9.2) billing system.
- Performed Billing System maintenance activities including updates of the Vertex tax libraries.
- Implementation and testing of system patches.
- Enhancement of various Perl programs using Perl DBI and sybperl modules.
- Implementation of the Arbor/BP collections module and associated scripts to send generated letters to the print vendor.
Confidential, (Fairfax, VA) ? July 1998 to December 1999
Consultant
Tools and Technologies Used:
- Kenan Arbor/BP, Kenan Arbor/OM, Korn Shell, UNIX, Oracle 8i, Oracle Utilities (Import, Export)
Project:
- Kenan BP and Kenan OM Billing Implementation for Cablevision LIghtpath, a subsidiary of Cablevision Systems Corp. Our team was implementing the Kenan Arbor Order Management (OM) and Bill Processing (BP) system to replace a legacy system that was not Y2K compliant. This included development of interfaces in and out of the system to support client and regulatory requirements.
Responsibilities:
- Conversion of the legacy billing and order management system to the Kenan Arbor/BP and Kenan Arbor/OM billing and order management systems.
- Developed the production implementation plan and tracked the progress of the tasks to ensure that the go-live date was met.
- Management of the development and testing databases: performed imports and exports, managed 10+ databases on 2 UNIX servers, configured the Kenan Arbor Order Management System.
- Wrote the Operations Support Manual and assisted in the training of the Operations Support and Software Support Teams.
EDUCATION
BBA - Computer Information Systems