IVAN TORRES,CCP


SUMMARY OF QUALIFICATIONS

Mr. Iván Torres is a consultant with progressive experience as an Analyst / Programmer of database and financial applications since 1984. Certified Computer Professional (CCP) in Management and in Procedural Programming by the Institute for Certification of Computing Professionals (ICCP). Technical skills include analysis, design, client/server and web page development, and network administration. Experience in supervision, user support and training.

DEVELOPMENT TOOLS AND ENVIRONMENTS

Tools:
  • Development: SQL, Visual Basic, MS Access,  FoxPro, COBOL
  • Web Development: FrontPage, MS Expression Web, HTML, CSS, Internet Information Server
  • Exposure: Active Server Pages,  PL/1, RPG,  Pascal
Environments:
  • Windows Server 2003 Network
  • Sybase SQL Server (HP/UX)
  • Alpha Micro AM-3000
  • MVS - IBM /3090

PC SOFTWARE

Crystal Reports, Sybase SQL Server Manager, MS Windows 2003/XP/9X, MS Excel, MS Word, MS PowerPoint, MS Outlook, MS PhotoDraw, PhotoShop, Visio, FTP Software and others.

CERTIFICATIONS

  • Certified Computer Professional (CCP) in Information Systems Management and in Procedural Programming 
  • Project Management
  • Customer Requirements Analysis, Master Level 
  • MS Front Page 2000
  • Relational Database Management Systems  Concepts
  • Internet Concepts 
  • MS Excel 2000, Master Level
  • MS Visual InterDev 6.0 
01/01/94 by Institute for Certification of Computer Professionals (ICCP
03/09/01 by Brainbench
12/19/00 by Brainbench Certification by Brainbench
12/17/00 by Brainbench
11/12/00 by Brainbench
11/12/00 by Brainbench 
10/10/00 by Brainbench
09/12/00 by Brainbench 

PAST
PROJECTS

 

Windows 2003 Server Network Implementation 

  • Configure Windows 2003 Server: DNS, DHCP, File Replication Services, IIS,FTP, Fax Services, User Accounts, Shares, Printers
  • Set up Remote Routing and Access Service (RRAS) for Internet connection sharing and remote access, Virtual Private Network (VPN) connectivity
  • Set up MS SharePoint Services and Portal
  • Prepare and schedule scripts and data backup jobs
Web Site Construction
  • Build corporate presence websites using MS Expression Web Designer, MS FrontPage,
  • Design website structure and CSS page layouts
  • Creat custom CSS style sheets and MS FrontPage themes with customer color scheme, custom buttons and graphics
  • Compose graphic elements using  PhotoShop and MS PhotoDraw
  • Program web forms for visitor feedback
  • Incorporate Active Server Page (ASP) scripting logging visitor information and sending email messages
  • Set up Discussion Forums
Stock Evaluation System for individual investor
  • Developed ranking system for individual stocks in MS Excel greatly decreasing research time
  • Created a user-customizable ranking method for 150 selected stocks based on weighted scoring of selected criteria
  • Automated update of daily stock closing prices, portfolio market value, analyst consensus and financial ratios from sources linked to in the Internet
  • Provided graphs for historical daily portfolio value, performance of portfolio compared to major indexes, historical net gain/loss and others

Geac Smartstream Human Resources and Payroll Technical Support
at a major Health Insurance Provider in San Juan, Puerto Rico

  • Provided technical support to users of GEAC/Smartstream Human Resources application in a client/server environment using Sybase SQL Server.
  • Assisted in implementation of HR module. Performed data migration using SQL, MS Access, and other tools.
  • Developed system extension for Payroll bank account reconciliation using Visual Basic.
  • Built interface between Time and Attendance and Payroll systems using MS Access.
  • Automated daily integrity checking of HR database using Crystal Reports and Visual Basic preventing application errors.
  • Created and maintained custom data views and tables using SQL Server stored procedures, facilitating end-user construction of queries and reports.
  • Developed queries and reports for Personnel, Training, Benefits and Payroll modules using Crystal Reports, MS Access and Smartstream Decision Support tools.
  • Trained users on Decision Support tools: Smartstream Query and Reporter.
Lease Accounting Systems Administration and Development
at a Major Leasing Company in Hato Rey, Puerto Rico
  • Administrated Lease Contract Origination System developed in FoxPro running on Novell Netware and serving 60+ users.
  • Performed Lead Programmer role supervising two programmers, implementing change control and performing Quality Assurance function.
  • Analyzed all requests, interviewed users and specified change requirements.
  • Organized tracking, prioritizing and scheduling of user requests.
  • Stabilized unreliable application by systematically eliminating program errors, restoring user confidence in the system.

Lease Accounting Systems Administration and Development
at a Major Leasing Company in San Juan, PR
  • Administrated Lease Accounting System serving 50 users on an Alpha-Micro 3000 minicomputer.
  • Effectively coordinated user efforts in implementation of new lease accounting package.
  • Provided assistance in handling user requests for support and directing staff (Junior Programmer, Operator, Data Entry clerks).
  • Educated users and MIS staff on operation and functionality of application software, AMOS operating system, and Novell Netware basics.
  • Designed and implemented online transaction balancing procedures, setting up proper controls of input into system.
  • Developed and maintained applications using AlphaBasic and COBOL.

Financial Accounting System Operations and Programming
  • Handled operations on Honeywell GCOS-6 OS and IBM 3090 MVS environment.
  • Performed light maintenance of IBM JCL and RPG application programs.

PC Application Programming
at the Puerto Rico Tennis Association in Miramar, Puerto Rico
  • Developed tournament registration and billing applications in Basic, greatly reducing time needed to register players for tournaments and account for their fees.

USER TRAINING

Prepared course material and taught groups in
  • Introduction to the Personal Computer, Windows, Word, Excel and FrontPage 
  • Relational Database basics and reporting using Crystal Reports and other reporting tools

LANGUAGES

Excellent written and verbal communication skills in English and Spanish.

ADDITIONAL SKILLS

  • Oriented towards producing high quality work with attention to detail.
  • Knowledgeable in Accounting and Finance.
  • Superior analytical and mathematical skills.
  • Good technical documentation and training abilities.

AFFILIATIONS

  • Institute of Certified Computer Professionals (ICCP)
  • Puerto Rico Developer Group (PRDG)