Work History

Work History
Jun 2009 - Present

Technical Change Management/Deployment Team

http://freddiemac.com

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

May 2008 - Mar 2009

ETL Developer

Coventry/First Health Services Corp

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.

May 2007 - Oct 2008

Senior Developer

http://www.verizonbusiness.com

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.

Sep 2006 - Apr 2007

ETL Developer

http://www.fhsc.com

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.

Dec 2005 - Aug 2006

Senior Developer

http://www.fanniemae.com

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.

Sep 2005 - Dec 2005

Senior Developer

http://www.freddiemac.com

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.
Jan 2005 - Sep 2005

Senior Developer

Network Solutions

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
Aug 2003 - Dec 2004

Senior Developer

http://www.freddiemac.com

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.
Nov 2001 - Aug 2003

Software Engineer III

Verizon

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.
Sep 2000 - Aug 2001

Senior Developer

Winstar Communications

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.
Jan 2000 - Aug 2000

Developer

UUNET

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.
Jul 1998 - Dec 1999

Consultant

American Management Systems

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.
  • Configuration Management Lead:migrated data between the development, testing, and production environments, applied software patches and database code upgrades, distributed client software to the project team.
  • Configured Arbor BP interfaces (LBX, TIP, and COM), Arbor OM interfaces (E911 and LIDB), and Arbor OM Workflows and Telephone Number Inventory (TNI).

Education

Education
Aug 1995 - May 1998

BBA

James Madison University

Delta Sigma Pi (Professional Business Fraternity), Student Government Representative

Skills

Skills

UNIX

Shell scripting with multiple shells, basic administration tasks, scheduling with cron.

Java

Java, Servlets, JSP, DynaBeans, JDBC, Displaytag, BEA Weblogic 10, Tomcat, Ant, Eclipse

Oracle

SQL, PL/SQL, SQL Loader, Import, Export, SQL Explorer, SQL*Plus

Perl

DBI, Log4Perl, Spreadsheet::WriteExcel, Spreadsheet::ParseExcel, Archive::Tar, CGI, Mod_Perl

Interest

Weightlifting, tennis, golf, hiking, kayaking, biking, travelling.

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)

Summary

·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

Courses Taken

  • A Practical Introduction to Ab Initio Software (Ab Initio)
  • Java Web Development (Learning Tree)
  • A+ Certification Course (George Mason University)
  • Arbor/BP Comprehensive Introduction (Kenan Systems)
  • Arbor/BP Products and Packages Workshop (Kenan Systems)
  • Arbor/BP Background Processing (Kenan Systems)
  • Arbor/BP Usage Processing (Kenan Systems)
  • Arbor/BP System Administration (Kenan Systems)
  • Arbor/BP Invoice Designer (Kenan Systems)
  • Developing Java Web Applications (Fairfax County Adult Education)
  • Korn Shell Programming (Mindbank)
  • Solaris 8 Administration (Northern Virginia Community College)
  • Introduction to C Programming (Verizon)
  • VB Scripts (Verizon)
  • XML Workshop (Verizon)
  • JavaScript Programming (Verizon)
  • Java Programmer Certification Course (Virginia Tech)
  • Oracle Certified Associate for 9i Certification Course (Virginia Tech)
  • Oracle Certified Professional for 9i Certification Course (Virginia Tech)