Senior Analyst/Programmer Resume

Title
Senior Analyst/Programmer

Primary Skills
T-SQL, VB6, ASP, Crystal Reports, Insurance, SQL2000/2005, DTS, Conversion, Linux, Cobol, VB6

Location
US-FL-Miami (will consider relocating)

Posted
Jan-01-09


HIGHLIGHTS
• 29 years overall experience in IT field

• 10+ Years (Current) experience in UNIX environments. SCO-Unix, SCO-Xenix, IBM-AIX, HP-UX, Red-Hat Linux. This experience is not limited to work with commands but also installing.

• 20 Years (Current) experience programming in Cobol. Microsoft Cobol, Micro-Focus Cobol, RM/Cobol, Cobol in minicomputers IBM-S/3X, Pro*Cobol (Oracle 6/7) and PL/SQL

• 15 years experience as independent consultant working as Analyst, programmer and system support.

• 20 years programming different application such General Ledger, AR/AP, Payroll, Manufacturing, Inventory, Point of Sales, Restaurants, and for the last 3 years in the Insurance/Financial industry for Life/Health business.

• 5 years giving support in computers networks administration, installation and troubleshooting. Installing servers (Windows 2000, 2003); Terminal servers and whole installation of a computer network from scratch including cabling (CAT5)

• 4+ years (Current) of heavy use of SQL-2000 DTS, T-SQL Stored Procedures and Scripts converting Cobol-based files to SQL-2000 data base.

• 4+ years performing (Current) SQL-2000 administration tasks such: Backups, restores, replication, log shipping, Stored Procedures optimization, take manual operations backups/restore process to automatic process. Also data modeling with Erwin and data base data/scheme synchronization.

• Extend experience converting data from legacy applications to SQL-2000 server, using DTS and T-SQL scripts for data cleansing, transformation and uploading to the data base.

• 4+ Years programming (Current) in VB6/ASP, with SQL server in a 3-Tier application. Reports done in Crystal Reports/Microsoft Reporting Services. (Stored procedure driven reports). 3+ Years programming complex stored procedures and functions in T-SQL.

• Easy to adapt to new environment (Work and technology wise), self starter and very user oriented kind of IT person.

• Able to perform supervisory task. Experience supervising 15 people. Experience also in training large number of personal in house and overseas.

• 1 year of exposure to mainframe (IBM-s/3090) installing Microsoft servers to IBM-3174 controller.


PROFESSIONAL EXPERIENCE
BMI BEST MERIDIAN INSURANCE
January 2004 -- Present
Industry: Insurance - Financial
Senior Analyst/Programmer (VisualTIME)
• In charge of the data conversion from COBOL/BTRIEVE files to a SQL-2000 data base using DTS.
• Developed conversion and extraction programs using MICROFOCUS COBOL, OS/2-REXX-CICS, BTRIEVE, and Windows 2000 Server.
• Data manipulation, uploading and cleansing using T/SQL scripts.
• Maintained T/SQL stored procedures for optimization.
• Developed and maintained T-SQL Stored Procedures and Functions.
• Maintained SQL-2000/SQL-2005 data base space usage.
• Maintained SQL-2000/SQL-2005 data base indexes fragmentation.
• Team member for the Disaster Recover Plan.
• Designed backups and restores for the Production, Development and Model data bases using T-SQL Stored Procedures and SQL-2000/SQL-2005 Job Agent.
• Designed automatic process to updating MODEL data base with Production data base.
• Developed and maintained programs for the Life and Health policy administration using Visual Studio 6/Visual Source Safe/Visual Basic 6.0/ASP/JavaScript and T-SQL Stored Procedures.
• Developed and maintained T-SQL Stored Procedure driven Crystal reports (version 8.5/11)
• Synchronized Schemes and Data from Development into Production environment, testing to Production using Erwin Data Modeler and Red Gate SQL Compare.
• Created SQL views to interconnect Insurance application with imaging software ONBASE.
• Training to local Miami office personal and Santo Domingo, Dominican Republic as well.
• Presentation/Support of application to Hannover RE auditors during reinsurance audit to BMI.
• Evaluated and tested conversion from SQL-2000 to SQL-2005 and final migration.
• Migration from Crystal Reports 8.5/9.00 to Crystal Reports XI.

Technical Environment: Visual Studio 6/Visual Source Safe/Visual Basic 6.0/ASP/JavaScript, ADO Connections, Crystal Reports 8.5, 9 an 11, SQL Server 2000, SQL Server 2005, Remote desktop connections.


PROCESYS CORPORATION
September 2000 -- Present
Industry: Consulting, Restaurant/Hospitality
Senior Consultant
• Designed and developed a Restaurant system.
• Programming done in RM/Cobol and installed in Red Hat Linux servers.
• Re-engineer the restaurant systems to Touch Screen using Visual Basic 6.0/ADO/MS Access 2000 (SQL-Access).
• Served independent customers for computer procurement, upgrades and installation.
• Performed Windows 2000 administration.
Technical Environment: Restaurant system analysis, develop and support, RM/Cobol Programming, Visual Basic 6.0/ADO/MS Access 2000, Red Hat Linux Administration, (VI Editor), Windows 2000 Server Administration.




MEGASOFT COMPUTACION, INC
March 2003 -- January 2003
Industry: Consulting, Water & Sewer Department
Senior Consultant
PROJECT 1 -- Megasoft
• Maintained purchase system developed in Visual Basic 6.0/ADO/MS Access 2000
• Maintained Megasoft Windows 2000 Server and NT4 server.
• Tuned network and troubleshoot problems with network traffic.

PROJECT 2 - ONDEO Puerto Rico, INC., a well-known international firm in water-related services worldwide with more than 60K staff employees, serving more than 110 Million People in over 130 countries and administrating the Puerto Rico Water and Sewer Authority.
• Configuration and deployment of 15 Windows 2000 Servers connected to mainframe via Microsoft SNA-Server 4.0. This project included changing the network topology from Token Ring to Ethernet, new cabling and switches installations, and giving support to 250+ stations connected to installed servers.
• Supported the help desk team with specific documentation of interconnected offices.
• Assigned to interconnect 30 commercial offices to central office network domain via WAN connections.

PROJECT 3 - QIPRO Puerto Rico, a Medicare/Medicaid provider.
• Audited use of MIS department computers, according to federal government rules on Novell, Windows 2000 Server and AIX environments.
• Checked user's permissions to access the network.
• Recommendation for use and installation of software at MIS Department.

PROJECT 4 - Oficina de Etica Gubernamental de Puerto Rico
Puerto Rico Government Ethics Office
• Installed Megasoft proprietary portal at Centennial of Puerto Rico Portal.
Technical Environment: Visual Basic 6.0, Crystal Reports 8.5, Microsoft Windows 2000 Server (Active Directory), Exchange 5.5, Lotus Notes, Microsoft SNA Server, CAT5/Switch/WAN Connections/Routers, Remote Administration (Terminal Server Services/VNC), Access, WAN-LAN connections.


COMPUSA/UNIVERSAL CONCRETE, Miami, FL
April 2003
Consultant
• Successfully detected and corrected communication problems between 2 remote sites and SCO-Unix Server.
• Recommended new equipment to re-establish lost communication for more than 2 months.
• Tuned UNIX server to maintain communication with remote sites.
Technical Environment: SCO UNIX Administration, UNIX Administration.


ARIAS & ASSOCIATES, INC, Miami, FL
May 2002 -- March 2003
Industry: Consulting - Accounting
MIS Consultant
Arias are an independent accounting firm serving construction companies. Contracted to serve SOARES DA COSTA CONTRACTOR, Inc. (SDC) is a subsidiary of Soares Da Costa Group, Portugal's largest contractor, and a leading contracting firm in Europe. Building projects in Europe, South America, Africa, the Middle East, and Macao.
• Installed and maintained 4 Servers (3 Windows 2000 Server, 1 NT4), 35+ Workstations.
• Maintained Microsoft Back office/Exchange 5.5.
• Help desk support for Windows and AS/400 users.
• Upgraded computers to Windows XP-Pro and Windows 2000-Pro.
• Scheduled backups with VERITAS Software.
• Installed and maintained Microsoft Office 97, 2000, XP.
• Remotely supported servers with VNC and NETOP.
• Recommended and installed high-speed connections.
• Planned and installed network (drops, connections).
Technical Environment: Microsoft Windows 2000 Server (Active Directory), Exchange 5.5, CAT5/Switch/WAN, Connections/Routers, T1/DSL procurements and installation, remote administration (Terminal Server Services/VNC/VPN), network administration and user support.


PIZZAMERICA -- PIZZAMAX, Miami, FL
1997 --2000, Owner/General Manager

CARICO INTERNATIONAL, INC., Ft. Lauderdale, FL
1995 -- 1996, Independent sales dealer


MINIMAX de VENEZUELA
1991 -- 1994
Industry: Consulting, Restaurant/Hospitality, Hardware Stores.
Software Developer/IT Director
• Developed and maintained ERP systems.
• Presentation of ERP System to potential customers in the sale process and coordinate presentations with business partners such IBM of Venezuela, Oracle of Venezuela.
• Successfully developed and installed a POS/Inventory application, programmed in RM/Cobol and UNIX, for three major hardware stores
• Installed an ERP application developed in Oracle in Unix Servers.
• Designed application specifications
• Coordinated programming team for changes in the applications. (Restaurants, POS, inventory, payroll, A/R, A/P, and general ledger).
• Test and certification of application modules.
• UNIX systems installation and maintenance.
Technical Skills: Analysis/Programming, SCO-UNIX Administration, RM/Cobol Programming, VI, Oracle 6, Analysis/Programming, IBM-S/36 administration, RPG Programming



PRIOR EMPLOYMENT
1979 -- 1991
• 1989-1991 ISC de Venezuela. An independent software developer firm. Employed as IT Director.
• 1984-1989 Frigilux Group, Venezuela, Employed as IT Manager. Frigilux is one of the major A/C, Kitchens, and Freezers fabricator in Venezuela, with more than 500 employees.
• 1981-1984 Estireno del Zulia-Plasticos del Lago-Polimeros del Lago, subsidiary of PDVSA (Petroleos de Venezuela), with over 1000 employees, employed as Analyst/Programmer.
• 1980-1981 Electronic Data Processing. Venezuela Employed as programmer.
• 1979-1980 Mat-Pool, Employed as Programmer.



EDUCATION
• 1981- Degree in Computer Programmer and Systems Analysis, Electronic and Computer Programming Institute, Maracaibo, Venezuela.
• 1981- Certificate in IBM-S/3X Concepts, programming and operations. IBM of Venezuela, Caracas, Venezuela
• 1983- 2 years at University as Public Accountant (36 Credits) Zulia University, Maracaibo, Venezuela.
• 1993- Degree in Computer Information Systems Technology. (3 Yrs/94 Credits GPA 3.23), Pedro Emilio Coll Technological College, Maracaibo, Venezuela.
• 1994- Certificate of Basic Sales concepts at Dale Carnegie.


CERTIFICATIONS AND COURSES

2008 BRAINBENCH ORACLE PL/SQL
2008 BRAINBENCH MS SQL Server 2005 Programming
2008 BRAINBENCH MS SQL Server 2000 Programming
2008 BRAINBENCH MS SQL Server 2000 Administration
2008 BRAINBENCH Visual Basic 6.0 Fundamentals
2008 BRAINBENCH COBOL-II
2008 BRAINBENCH RPG IV
2008 BRAINBENCH UNIX PROGRAMMING (GENERAL)
2008 BRAINBENCH MANAGING PEOPLE (US)
2005 BRAINBENCH Programmer/Analyst Aptitude
2006 LOMA 280
2007 CA Erwin Data Modeling

Certifications
2008 BRAINBENCH ORACLE PL/SQL
2008 BRAINBENCH MS SQL Server 2005 Programming
2008 BRAINBENCH MS SQL Server 2000 Programming
2008 BRAINBENCH MS SQL Server 2000 Administration
2008 BRAINBENCH Visual Basic 6.0 Fundamentals
2008 BRAINBENCH COBOL-II
2008 BRAINBENCH RPG IV
2008 BRAINBENCH UNIX PROGRAMMING (GENERAL)
2008 BRAINBENCH MANAGING PEOPLE (US)
2005 BRAINBENCH Programmer/Analyst Aptitude
2006 LOMA 280
2007 CA Erwin Data Modeling



You must be logged in and have a current resume access subscription. Login or Register »

Resumes in Miami, FL | Resumes in Florida

View other Senior Analyst/Programmer resumes, Programmer / Developer resumes