OBJECTIVE:

I seek a technology - based leadership position to apply my analytical, problem solving, and change management skills to improve business results.

SUMMARY:

• I have over thirty - five years of experience implementing, leading, and managing technology-based projects.
• Joined a team of four other consultants involved in building, testing, developing, and applying a new Microsoft LightSwitch based metadata design tool.
• The tool generated SQL Server code to migrate numerous MS Access databases and Excel Workbooks used to process the corporate balance sheet data and provide forecasting information to management.
• Obtained requirements and developed new data architecture designs through entity relationship diagrams (ERDs) for the following financial instruments: long term debt, structured notes, preferred stock, securitizations, trust-preferred instruments, purchase accounting adjustments, swaps, reverse repos and Confidential investments.
• Supported all code promoted to Production involved in both daily and monthly processes.
• SVN Tortoise and Team Foundation Server were used as the code repository tools.

PROFESSIONAL EXPERIENCE:

Confidential, Durham, NC

IT Consultant

Responsibilities:

• Built a replacement working prototype for an existing Java/Sybase SQL Server middle tier application to improve maintainability and better service to the business.
• The new application consisted of new Sybase t - SQL code, MS SQL Server t-SQL code, Oracle PL/SQL, C# console applications, and XSLT/XPath scripts to generate the taxonomy and data for the RIXML (Research Information Exchange Markup Language) or proprietary document description files.
• The existing Java application required two months or more to add a new financial research customer as it and the Sybase back-end were not well-documented and required thorough testing. The newly-simplified architecture is expected to accomplish the same objective in one to two weeks.
• Once the successful prototype was completed, work began to migrate the C# code towards building a Production Windows Service and developing a comprehensive test plan.
• The development tools were Visual Studio 2010 MS FX Cop, MS Style Cop, JetBrains Resharper, and NDepend), Eclipse Helios, Rapid SQL, Allaround Automation PL/SQL Developer, MS SQL Server Management Studio, and Oxygen XML Editor. TortoiseSVN was used as the code management tool.

Confidential, Charlotte, NC

Web Developer

Responsibilities:

• Performed ASP.NET (C#/CSS/JavaScript/AJAX/jQuery) and Oracle PL/SQL programming for a fixed income credit and market risk web site.
• Work included conversion of existing code to the .NET 4.0 Framework using Visual Studio 2010 as well as building new code for business enhancements.
• Designed and created functional design documents encompassing code changes based on Business Requirements Documents.
• Toad and Oracle SQL
• Developers were the tools used for PL/SQL development for the Oracle 10g and 11g databases.
• Database development included building new tables, views, packages, triggers, and sequences used in support of the web site and back - end processes.
• Built Korn shell scripts and AutoSys jobs to support back-end operations.
• Developed unit tests for the QTP quality assurance tool.
• Computer Associates SCM (Harvest) was used as the code management tool.

Confidential, RTP, NC

Assistant Vice President

Responsibilities:

• Converted seven existing SQL Server 2000 Data Transformation Services (DTS) packages to SQL Server 2008 R2 Integration Services (SSIS) packages using Microsoft Business Intelligence Development Studio (BIDS).
• Converted three SQL Server 2000 Analytical Services (SSAS) cubes featuring mortgage - backed securities (MBS) and collateralized debt obligation (CDO) data to SQL Server 2008 R2 cubes through a complete ground-up rebuild through BIDS.
• The ground up changes included modifications to dimensions, calculated members, and the MDX scripts.
• The extract, transform, and load changes included converting Data Transformation Services to SSIS using new DSN-less database connections to Oracle and Sybase.
• Modified an existing ASP.NET website with an Office Web Components 11 Pivot Table control in Visual Studio 2008 to display data from the SSAS 2008 cubes.
• Performed support work for calculating and uploading forward rate curves to support trading floor operations.
• The code management tool was Microsoft Visual SourceSafe 2005.

Confidential, Cary, NC

Technical Lead

Responsibilities:

• Designed and implemented code changes to upgrade the Primavera P6 software from version 6.2.1 to 8.1 to accommodate a planned deployment of Windows 7.
• Interface applications were deployed on Red Hat 5.4 Linux and Windows 2008 Servers. Used IBM Rational Application
• Developer to modify Java applications that utilized the Primavera API, Visual Studio 2008 to modify C# applications that utilized the Primavera SDK, and Korn shell scripting/Oracle PL/SQL for code that was called through Oracle SQL*Plus and SQL*Loader.
• Converted a MS SQL Server Distributed Transaction Services (DTS) application for enterprise auditing (Oracle, Hyperion, and SQL Server Databases) to SQL Server 2008 Integration Services (SSIS) by using .NET Framework libraries for LDAP.
• Provided support for eight enterprise web applications including one with a Model - View-Controller (MVC) design pattern.
• Accepted 24/7 on-call rotation duty for the team.
• Code management tools were Confidential Repository for Java and Team Foundation Server for C#.

Confidential, RTP, NC

Business Intelligence Developer

Responsibilities:

• Obtained business requirements from business stakeholders, designed and implemented modifications and improvements for global Investment Banking Contact Resource Management/Key Account Management reporting web sites and databases through a formal SDLC process.
• The web sites were built with C#, JavaScript, CSS, and HTML4 in Visual Studio 2005/2008/2010. The backend databases were primarily Oracle 10g and Sybase 12.5/15.
• The web site code improvements included modification to the code to interact with Business Objects and to track usage of the reports.
• The Oracle/Sybase code changes included modifying stored procedures for existing reports.
• Other Oracle work included the construction of a new use data mart to replace an existing database that managed report permissions/entitlements. PL/SQL Developer was used to build the PL/SQL code and the scripts to generate tables, indexes, and sequences. Designed and constructed new Crystal Reports (2008) as part of a client dashboard for Senior Management.
• Modified and enhanced C# web services to support the management report.
• Wrote technical requirements and documentation for all new and legacy software.
• Rational ClearCase and TortoiseSVN were used as the code management tools.

Confidential, Pittsburgh, PA

Application Developer

Responsibilities:

• Obtained requirements from business users and modified or built Visual Basic 6 and Oracle 10g PL/SQL code to support or enhance back - office trading floor applications.
• Reversed engineered a C# application to design an improved LDAP-based security for all Visual Basic 6 applications.
• Many applications used Dynamic Link Libraries (DLLs) that provided an interface to fetch or retrieve data from CICS sessions.
• Implemented database transactions through use of the Active Data Object (ADO) model. Constructed Microsoft Excel VBA macros with forms to meet dynamic reporting needs and manage data.
• PL/SQL Developer was used to build the PL/SQL code and the scripts to generate tables, indexes, and sequences. Microsoft SourceSafe was the code management tool.

Confidential, Atlanta, GA

Report Developer

Responsibilities:

• Obtained requirements from business users and modified or built Oracle 10g stored procedures and database objects for Crystal Reports (Version 10) to manage a finance - related business.
• The Oracle stored procedures ranged from simple implicit cursors to the use of nested tables and collections.
• Toad was used to build the PL/SQL code and the scripts to generate tables, indexes, and sequences.
• Constructed Microsoft Excel VBA macros with forms to meet dynamic reporting needs.
• Documented technical requirements of the newly developed database and reporting software.

Confidential, Charlotte, NC

Report Developer

Responsibilities:

• Obtained requirements from business users and modified or built Oracle 10g stored procedures and database objects for Crystal Reports (Version 8.5) for an enterprise securities trading software package. Reports covered common stocks, bonds, options, futures, currency forwards, swaps, and collateralized mortgage/debt obligations.
• The Oracle stored procedures ranged from simple implicit cursors to nested tables and collections.
• Toad was used to write or modify the PL/SQL code and the scripts to generate tables, indexes, and sequences.
• Confidential was the code management tool.

Confidential, Atlanta, GA

Business Intelligence Developer

Responsibilities:

• Gathered requirements from business representatives, developed specifications, and built complex DB2/MS SQL Server queries for custom Crystal Reports (Version XI) as part of a Manhattan Associates Supply - Chain Business Intelligence software implementation .
• Built MS SQL Server 2000 data warehouse tables and DTS packages to support extract, transform, and load (ETL) functions.
• Wrote VB Scripts to modify the DTS extraction queries on-the-fly through manipulation of the DTS COM object.
• Assisted in the construction of SQL Server 2005 SSIS packages and data warehouse to extract and summarize DB2 information from mainframe and UNIX platforms.
• Supported Q/A and testing activities by performing queries, generating data sets, and documenting results in HP Quality Center.
• Assisted in training distribution center personnel and performed on-site Crystal Report support.
• Developed and presented week long training course for Crystal Reports/Business Objects XI Development.
• Completed Rational ClearCase/ClearQuest user and administrator training.

Confidential, Greenville, SC

Web Developer

Responsibilities:

• Obtained requirements from business stakeholders, developed specifications, and developed Crystal Reports (Version 9), Oracle 8/10g database objects, and Active Server Pages as part of a Metrix Field Service Software implementation.
• Work included testing code, deploying deliverables, and providing 24/7 support on rotation.
• Designed, built, and modified Oracle views, sequences, functions, procedures, packages, and triggers.
• Built Korn shell scripts to perform DBA maintenance activities (export/import Production data, rebuild statistics/indexes, shutdown/startup database) for development and Q/A Oracle databases deployed on AIX UNIX platforms.
• Built interface software consisting of classic ASP VBScript code and new Oracle 10g database/COM+ objects to manage LDAP security for connecting IBM Web Portal Software to an internal Metrix web site.
• Active Server Pages utilized VBScript, JavaScript, DOM, XML, and XSLT/XPath technologies.
• Crystal Reports were displayed through custom Active Server Pages and Crystal Enterprise.
• Generated test case documentation and supported quality assurance activities by performing queries and generating data sets.
• Used Eclipse to rebuild an existing Java interface application.
• Performed code documentation and user training activities prior to go-live.
• Used Merrant’s Dimensions as the code management tool.

Confidential, McLean, VA

Application Developer

Responsibilities:

• Reverse-engineered, upgraded, and documented a three-tiered Mortgage Securitization application that utilized a Visual Basic front end, Unix C/C++ middle tier (CORBA), and SYBASE 12 SQL Server database back end.
• Worked with business representatives to obtain business requirements for software enhancements and wrote functional specifications.
• Constructed Visual Basic classes to facilitate the creation of ODBC connections, Windows environment variables, and file transfers.
• Modified and built Crystal Reports (Versions 6 and 9).
• Responsible for designing, building, and deploying Visual Basic code, C/C++ middleware, and database objects to support the implementation of software applications related to Sarbanes-Oxley (SOX) compliance.
• Supported, modified, and deployed custom applications for trading floor workstations.
• Used Rational’s ClearCase as the code and document management tool.

Confidential, Atlanta, GA

Application Developer

Responsibilities:

• Designed and built Visual Basic 6 code and Oracle 9 Database objects required for a global corporate Human Resources Stock Options system that managed option grants for key employees.
• Changes were needed to interface with a new external brokerage option management system.
• Work included modifying and documenting a custom ActiveX control and COM+ objects, improving error handling, and implementing database transactions.
• Generated test data to support the Q/A process.
• Used PVCS Dimensions as the code management tool.