Sql Server Visual Basic

Angel Lopez

**-** *** *** **** [pic] Woodside, NY 11377 [pic] Office: 201-***-****

[pic] cell: 201-***-****[pic] ***********@*******.***

PROFESSIONAL SUMMARY

I have more than 6 years of C# experience, my background involves all

aspects of relational database design/System administration and software

development, with extensive work in Visual Basic, ADO, VB.NET, MS Access,

WCF, WPF, Crystal Reports and VB development, Oracle, MS SQL Server, and

SQL programming. Administer Windows NT, 2K, XP in a Multiple Domain Model.

I have outstanding communication skills, strong leadership abilities, and a

keen talent for quickly learning and applying new programming languages and

tools; with expertise in the following areas:

. Software Life Cycle

. Debugging

. Programming

. UML & CIS Validation

. Peer Leadership

. System Configuration

. System Deployment

. Data Management/Migration

. Troubleshooting

. Tuning/Enhancements

. Data Backup/Recovery

. Business Analysis

. Project Management

. User Training

. Documentation

COMPUTER SKILLS

Languages: Visual C#, Visual Basic 6.0, VB.NET, Java, DCOM, Oracle 9/10G,

PL/SQL, Transact SQL, MS Access 97/2002, VBA, PHP, JavaScript, ASP.NET, MS

SQL Server 2000, FoxPro, ODBC, ADO ActiveX

Software: MS Access, SQL Navigator, Crystal Reports, Lotus Suite, Lotus

Notes, MS Office 2000/XP, TOAD, Outlook, PC Anywhere, IE 8, IIS 6, Apache,

Flash, Dreamweaver, Relational Rose UML, Business Objects, MTS, MSOffice

XP/2007, Remote Desktop

Operating Systems: MS Windows 2000/XP/ System 7, Ubuntu, Sun Solaris, Sun

UNIX, Red Hat Linux, OS/2

Databases: Oracle 7/8i/9/10G, MS SQL Server 2005/2008, MS Access, MySQL,

Sybase, Data Mining

Web Technologies: Web Services, COM/COM+, AJAX, JavaScript, XHTML,

ASP/ASP.NET, Cold Fusion

PROFESSIONAL STRENGTHS

> 14+ years of experience in relational database design and

administration, with a concentration in software development

> Specialty in the following technologies: Visual Basic, C#, ASP.NET,

Access, VB.NET and Oracle.

> Proven expertise with all phases of software development cycle,

including requirements analysis, application design, debugging,

implementation, data conversion, design review, and system testing

> Adaptability and willingness to learn new skills/technologies

> Ability to communicate effectively with individuals at all levels of

technical knowledge

> Commitment to superior customer service and the highest standards of

quality

> Proven track record of project completions within time and budget

constraints

> Ability to work equally well independently or collaboratively

> Emphasis on continual professional development and advancement

> Analytical approach to solving technical challenges utilizing OOAD

> Demonstrated skill at applying leading-edge technology to automate and

improve systems for enhanced productivity, reduced costs, and

increased profitability by 20% in the first 3 months

PROFESSIONAL ACCOMPLISHMENTS

. Pipeline: Customized financial billing tracking system to support bid

and management decisions for Chase Manhattan Bank (Technologies:

Visual Basic, MS Access, SQL, VBA)

. Examiner: Examination application for Chase Manhattan Bank

(Technologies: Visual Basic, Oracle 7)

. Swiftline: Deployment of application to 650 locations, including

troubleshooting, configuration and implementation support

. ATS Plus: Programming and modification of existing bank teller

application (Technologies: UNIX Shell scripting, C++, NT scripting)

. Procedure documentation control system (Technologies: VBA, MS Word,

Visual Basic, Visual C++)

. EasyPay: Multimedia software application installed in public kiosks

for the purpose of allowing bank customers to scan and pay their bills

using debit/credit cards (Technologies: Visual Basic, BASE24 with

Crystal Reports, UDTP, DLL, C++, Oracle, MS Access, TCP/IP ActiveX

controls for RAS)

. Time Attendance/Payroll system for bank employees based on magnetic

card use; subsequent migration of system from MS Access SQL to Oracle

(Technologies: Visual Basic, SQL, Access)

COMPUTER EXPERIENCE

Western Union, Inc 2/2008 - PRESENT

Application Architect

. Created customize Crystal Reports reports, performing testing in

report server creating VB COM as the middle layer where SQL and

business rules resides.

. Modified websites of clients using ASP/ ASP.NET with C# making changes

depending on functional specs on the ticket reports

. Worked with ADO.NET using the dataAdapter, dataReader, daTables,

dataRows, and commandObjects.

. Created C# classes with inheritance, delegates and interfaces to

prepare business objects for clients web sites

. Embedded transact SQL 2005 and LINQ in ASP.NET code and in Crystal

Report to return payment information.

. Prepared system requirements for architectural planning team during

design and implementation stages.

Nextec Group

11/2007 - 2/2008

C#/VB.Net Developer

. Created customer customize screen, and GUI using windows forms and MAS

500 Core Apps (Sage Software)

. Coded and debugged stored procedures and functions for use on Crystal

Reports and C#.

. Implemented lifecycle methodologies such as RUP/ UML for software

projects.

. Worked with Infragistics controls for the GUI, and with ADO.NET with

DataAdapter, DataTables etc.

. Coded classes, properties, methods, web services, and events, web

forms using Visual C#

. Worked with COM and Sage Software accounting VB Library to maintain

existing financial applications.

Lloyds TSB BANK 12/2006 - 06/2007

Business Analyst/Software Developer

. Performed Analysis of user and business requirements to create

accounting applications using C#.

. Coded Oracle PL/SQL stored procedures and functions for use on Crystal

Reports and C#.

. Debugged Oracle PL/SQL troubleshooting and fixing bugs in Business

Objects reports.

. Modified financial web applications using ASP.NET, C# with SQL server

creating stored procedures

. Created Payroll, General Ledger, Bank Accounts and other reports using

Business Objects, Excel & C#.

. Created forms, combo box, list box, buttons, textbox, classes and code

modules using VB.NET and MS SQL Server in the backend for Investment

and trading reports applications

MASTERCARD WORLDWIDE, INC. - White Plains, NY 09/2006 - 12/2006

Senior Business Analyst - Global Operations

Created SQL Server Database imported PDF, ASCII, and Excel files,

normalizing data & primary indexes

. Cleaned 1099 Tax data from Banks, corporations, suppliers and

MasterCard Card holders using C#.

. Performed Business Analysis on TIN Validations, assisting the IRS QPCA

program for Banks & Corps.

. Coded, tested Tin validation reports with percentage of missing Tax ID

using Excel, VB, Crystal Reports and Ms Access

. Programmed a Multi-Dimensional TIN Validation system of banks and

their customers that enrolled into EMR system using Excel VBA,

ActiveX, VB.NET, Ms Access VBA., Oracle and SQL server

. Created web application using ASP.NET and C# to accept and import data

validation from users

JPMORGAN CHASE BANK. - Manhattan, NY 06/2005 - 1/2006

Business Analyst - Investment Bank

Added modifications on existing C# modules, attached to FXO

commodity and trading reports

. Improved energy report process utilizing C#/MS SQL Server and

decreasing time by 70%

. Tested business rules on Crystal Reports, saving many hours of tedious

calculations with Excel formulas.

. Coded and tested many trading reports on schedule with deadlines using

Visual Basic for Excel.

. Worked with a Multi-Dimensional Data structure of hierarchy reports

using Excel and Oracle

. Created report web application allowing users to monitor report status

using C#, SQL Server, ASP.NET

JPMORGAN CHASE BANK. - Iselin, NJ 08/2004 - 12/2004

VB/VB.NET programmer - Home Finance

Added modifications on existing C# modules, attached to home

Mortgage forms with Oracle

. Improved home mortgage conversion process utilizing Visual Basic/

Oracle and decreasing time by 40%

. Tested business rules on PACS entry screens, and change new bank name

adding fields on Reports

. Performed upgrades/modifications of existing utility applications

using VB.NET to perform conversion

METLIFE, INC

1/2001 - 06/2004

New York, NY

VB Programmer/System Analyst - Image Workflow

. Developed code modules for BA software applications for 800+ users

using Visual Basic 6, Oracle 8i (PL/SQL) and MS SQL 2000 (Transact

SQL) in the backend, generating Business Objects Reports

. Created GUI front end with data entry screens using C# and SQL server

in the backend

. Wrote supporting routines in VB.NET for data processing including DTS

for data feeds/database servers

. Designed Crystal Reports 9/10 enhancements and bug fixes, and

configured version control system

. Performed migrations of existing applications to VB.NET from Visual

Basic 6.

JPMORGAN CHASE

6/1998 - 11/2000

New York, New York - (Full time position)

Technical Officer

. Developed examination application using Visual Basic 6 and Oracle 7/8i

(PL/SQL) with Crystal Reports 8

. Participated in global deployment of Swiftline VB Enterprise

application, supporting 650 branches with testing, configuration,

troubleshooting, parameters, database conversion and providing vendor

with bank requirements

. Developed architecture for/administered Windows NT domain and

coordinated domain migration

. Prepared system policies and performed directory replication, UNIX

shell scripting, C++ programming and software modification

. Coded and Debugged Document Repository Web Server using JavaScript

HARTZELL OF PUERTO RICO

1/1998 - 3/1998

Las Piedras, Puerto Rico

VB Programmer/Analyst - Consultant

. Developed documentation control system for all departments and

installed it in Windows NT 4.0 file server supporting 400 users (used

OLE automation with MS Word, Visual Basic 5, VBA and Visual C++)

BIOMETRICS IMAGINEERING, INC.

6/1997 - 12/1997

Hato Rey, Puerto Rico

Senior Software Engineer

. Developed computer kiosk system for Banco Popular (Puerto Rican bank)

utilizing VB, to provide banking capabilities to customers in public

malls, thereby decreasing wait line in 40 branches and improving

customer satisfaction (used Visual Basic 5 in Windows NT/Oracle

environment, Crystal Reports 6)

. Performed remote computing, monitoring and troubleshooting of kiosks

via dialup network

CHASE MANHATTAN BANK

1/1997 - 5/1997

New York, New York

MS Access Programmer/Computer Consultant

. Devised Bid Software System using VB/MS Access and created SQL

Queries, forms with controls for GUI design and created Projection,

detailed and cross tab reports to support 40+ users

CITIBANK CITICORP CENTER

10/1996 - 12/1996

New York, New York

Help Desk Support Analyst / System Administrator - Computer Consultant

. Provided LAN support and performed data backup and workstation

installation, configuration and troubleshooting

. Installed software/hardware and set up protocols in various network

topologies

. Administered NT servers and added/removed/modified user accounts

. Set up print servers

CANTOR FITZGERALD

6/1996 - 9/1996

New York, New York

PC/Help Desk Support Analyst - Computer Consultant

. Performed file server TAR backups, installed operating systems, and

configured Internet connectivity using TCP/IP and other technologies

. Upgraded and configured hardware, installed software, and fulfilled

MAC tickets

COMPUSYSTEM

4/1996 - 7/1996

Aguada, Puerto Rico

VB Developer/MS Access Programmer

. Developed system to record and process employee attendance and payroll

checks for Western Bank of Puerto Rico based on Win 3.1, Win 95 and NT

platforms

. Migrated system and data to Oracle database and designed modules in

Visual Basic to program modem for downloading timesheets from each

bank branch and merge them with fileserver in central office for check

generation using Crystal Reports 5

. Performed all necessary analysis, design, coding, debugging, testing

and research

HOSPITAL CENTRO MEDICO/DEPT. OF HEALTH

10/1994 - 3/1995

Mayaguez, Puerto Rico

VB Developer/MS Access Programmer

. Designed and developed payroll information system and performed data

validation, eliminating duplicate information

. Delivered user training and wrote user guide

HEWLETT-PACKARD OF PUERTO RICO

8/1994 - 11/1995

Aguadilla, Puerto Rico

Data Entry/Software Feedback Support

. Participated in design of bar coding system for generating bar code

labels (used Visual Basic and Access)

BAXTER BENTLEY, INC.

5/1990 - 2/1995

A asco, Puerto Rico

VB Developer/MS Access Programmer

. Developed multiple applications for label generation, inventory

control, and other purposes (used Quattro Pro, Visual Basic 3.0,

Crystal Reports 1.0, Access 2.0, Fox Pro, QuickBasic 4.5)

EDUCATION

Regional College of Aguadilla - Puerto Rico

1992 - 1993

Major: Marketing/Sales

Coastal Training Institute

1991 - 1991

Major: Computer Programming

Interamerican University of Aguadilla - Puerto Rico

1986 - 1990

Major: Business Administration/Computer Science

PROFESSIONAL DEVELOPMENT

. MCTS: .NET 3.5 Framework Foundation, and .NET 3.5 Framework Advance

. MCSE: Supporting Windows NT Core Technologies

. MCSE: Supporting Windows NT Server Enterprise Technologies

. MCSD: Visual Basic 6 Intermediate and Advanced

. MCSE: Administering Windows NT 4.0

. Java JDBC Programming

. Java and Oracle Development for the Enterprise

AFFILIATIONS AND HONORS

Achievement Award from Chase Manhattan Bank for Deployment of Swiftline in

Global Y2K Effort

Contact this candidate