Expertise

Languages - Visual Basic 6.0, XML, VBA, VB.Net 05, 08 , ASP, HTML, PHP

IDE - Visual Interdev 6.0

Data Access - ADO, ODBC

Backend - MS SQL Server, Oracle, Informix, Sybase, Access, MYSQL, IIS

Other - VSS 6.0

OS - Win9x, WinNT, Windows 2000, Windows XP, UNIX, MS-DOS

Case - Erwin, Rapid-SQL, Crystal Reports 7-11, SharePoint, SSRS, iReport

Office - Microsoft Office

Experience

Confidential

Contractor

Tasks:

• Created SQL Server 2008 database to warehouse all data from clients.
• Designed and Implemented Stored Procedures, Views, and table structure to provide detailed information about upgrade status.
• Administrated SQL Server 2008 database
• Administrated SharePoint Website.
• Developed and Administrated a Reporting Services site.
• Developed Cross tab and sub reports to meet client requirements.

Confidential

Contractor

Tasks:

• Created reporting application for Global Loan Services group. Application provides customized reports for Deutsche Bank clientele. Responsible for providing report content from SQL Server data.
• Designed and implemented VB 6/ VB.Net applications to extract data from the data warehouse in DB2 and insert into SQL Server 2005.
• Designed specifications and managed multiple windows 2000/2003 server implementations.
• Administrated IIS web server for production reporting web site.
• Liaison between business and development team to determine requirements and timelines.
• Maintained and Modified ASP/HTML code to generate customized reporting package based on the clients requirements.
• Documented all existing processes.

Confidential

Senior Sybase Programmer Contractor

Tasks:

• Designed and implemented robust Sybase objects Stored Procedures, Tables, Views for a market data analysis web application.
• Optimized stored procedures to ensure their optimal performance.
• Created Proxy tables using CIS, Component Integration Services, to give users ability to join different record sets together.
• Performed DBA functions on Sybase servers 12.5
• Created reports to represent customer data using Jasper iReport.
• Performed alpha testing for Sybase and Java Objects.

Confidential

Senior Programmer Analysis

Tasks:

• Designed dynamic stored procedures, tables, triggers, proxy tables in Sybase to support the Fixed Income Team. This functionality was to fill the gaps in the current system and their work requirements Common Stock, Muni, Treasuries, and Government/Agencies .
• Maintained/tuned current storied procedures to ensure optimal performance.
• Designed robust Visual Basic 6 applications to support a Fixed Income Trading System. Provided reporting solutions to display the different user requirements. These applications were to allow the users to perform their daily trading activities that Longview 2000 was unable to provide.
• The Visual Basic 6 applications communicated with Bloomberg via API and retrieved vital information about the stocks and bonds being traded.
• Participated in a conversion from Longview 2000 to Longview Trading System, including migration of all stored procedures from Sybase to MS SQL Server and development of Visual Basic 6 programs to aid in data conversion.
• Developed UNIX shell scripts to execute all overnight batch processing.
• Using Crystal Reports 10/11 designed and implemented user reports.

Confidential

Senior Programmer Analyst

Tasks:

• Designed/modeled Global reporting Sybaseand MS Server Database for all reporting needs. Created tables, stored procedures, triggers, and views to provide users with accurate and timely data.
• Extracted data from third party software, Hiportfolio, then loaded data into staging tables. From there stored procedures would format the data into the correct values using specified business logic. Views were used to allow crystal reports to print the daily results.
• Using Visual Studio, created Visual Basic 6 applications to extract data from Hiportfolio. It allowed the Back Office Accountants to modify any incorrect data. Then it created a flat file in which to send to the various children companies of Swiss RE.
• Worked closely with Back Office Accountants to acquire requirements.
• Created VBA applications using Excel XP. These spreadsheets were built with the functionality to refresh with current data, perform specific calculations, and format according to requirements.
• Created reports for NY back office using Crystal Reports 8 9. These reports displayed all aspects of the Asset Management Department.
• Created batch programs to nightly load data from text files into databases. The batch programs were also used to ensure that all nightly processing, including programs, loading, and exports, were completed on time each day.

Confidential

Associate

Tasks

• Worked closely with FX Conversion Accountants to acquire requirements.
• Created an application that allowed FX Conversion Accountants to convert the foreign securities into local securities. It performed all compliance tests and performed all FX conversions. This application used a Visual Basic front end, and Sybase stored procedures to perform all data manipulation.
• Created a Visual Basic 6 application that allowed FX Conversion Accountants to change the target percentage for a security across an account group. Then the application would rebalance the account and refresh the front end with the correct information. This application used a Visual Basic front end, and Sybase stored procedures to perform all data manipulation.
• Re-Engineered the current referential data load process. The referential data load would transfer all the accounting data from the account database Informix into the trading database Sybase . The processes included a shell script that called SQL files. The SQL files collected all the appropriate data and BCP'd the data into flat files. Then the application BCP'd the data into Sybase and initiated stored procedures to place the data in the correct place.
• Created Crystal Reports that was generated on a daily basis to provide the Compliance department with detailed information.
• Performed data modeling to correct problems with the current Sybase database. In addition, optimized current stored procedures and triggers to expedite the loading process.

Confidential

Information Systems Consultant

Tasks

• Developed reporting software for a HMO to allow the users to view debts, current billing statements, and all additional required information. The application used a Visual Basic 5.0 front end with a MS SQLServer backend. Data Dynamics performed the reporting through Active Reporting.
• Developed a VBA application that pulled all associated data from an Informix database into an Excel spreadsheet.
• Developed a COM object for Christian Broadcast Network that processed all the data coming from the official CBN website into the database.
• Created ASP web site for CBN to allow users to track and post articles, make contributions, and create forums for religious discussions.
• Re-Engineered an existing process in the City of Hampton, which allowed the users to import data from a Mainframe onto the NT server and then parse through the data, ensure that all the data is correct. Then import the data into a MS SQL Server. The front end allowed users to modify any data that was incorrect and printed detailed reports displaying all vital information.