IVAN TORRES,CCP

 

Summary of Qualifications

Mr. Iván Torres is an Information Systems 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. Experienced in Project Management, staff supervision, user support and training.
 

Development Tools and Environments

Tools:
  • Development: MS Visual Studio, Visual Basic, MS SQL, MS Access
  • Web Development: MS Expression Web, HTML, Active Server Pages .Net (ASP),  Cascading Style Sheets (CSS), Internet Information Server (IIS), MS SharePoint Services, DotNetNuke Web Content Management Systems (CMS)
  • Legacy Language Exposure: FoxPro, COBOL, PL/1, RPG
Environments:
  • MS Windows Server Networks
  • Virtualization: Microsoft and Oracle VirtualBox

 

Software

MS Windows Server 2012, MS Excel, MS Word, MS PowerPoint, MS Outlook, PhotoShop, Visio, FTP Software and other utilities.

Certifications

  • Certified Computer Professional (CCP) in Information Systems Management and in Procedural Programming 
  • Project Management
  • Customer Requirements Analysis, Master Level 
  • Relational Database Management Systems  Concepts
  • Internet Concepts 
  • MS Excel, Master Level
 
by Institute for Certification of Computer Professionals (ICCP)
01/01/94 
 by Brainbench
by Brainbench
by Brainbench
by Brainbench 
by Brainbench

Past Projects

 

Windows Server Network Implementation 
  • Configure Windows 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
  • Configure hardware routers and gateways for allowed incoming Internet traffic
  • 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, DotNetNuke
  • Design website structure and CSS page layouts
  • Create custom CSS style sheets 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 for logging visitor information, creating forms and sending email messages
  • Set up Discussion Forums
  • Integrate PayPal payment methods for eCommerce
Social Media
  • Set up Facebook business presence Pages, community Groups.  Advise on Best Use Practices.  Produce screen capture videos for demos and training.
Stock Evaluation System
  • Developed ranking system for individual stocks in MS Excel greatly decreasing research time
  • Created a user-customizable ranking method for selecting stocks based on weighted scoring of determined criteria (P/E, Growth, Liquidity, Debt ratios, etc)
  • Automated update of daily stock closing prices, portfolio market value, analyst consensus and financial ratios from sources linked to in the Web
  • 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 Smartstream 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 PC based Time and Attendance and Smartstream Payroll systems using MS Access.
  • Automated daily integrity checking of HR database using Crystal Reports and Visual Basic preventing application errors caused by data corruption.
  • 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 Analyst role supervising programmers, implementing change control, creating a development staging environment and performing Quality Assurance functions.
  • Analyzed all application change requests, interviewed users and specified change requirements.
  • Set up system for 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 this 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 some maintenance of IBM JCL and RPG application programs.

PC Application Programming
at the Puerto Rico Tennis Association in Miramar, Puerto Rico
  • Developed PC-based 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 Web Site Construction 
  • 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, Finance and Statistics.
  • Superior analytical and mathematical skills.
  • Excellent technical documentation and training abilities.

Affiliations

  • Institute of Certified Computer Professionals (ICCP)
  • Puerto Rico Dot Net User Group (prdotnet.org)
  • Puerto Rico Professional Association of SQL Server www.prpass.org
  • Microsoft Registered Partner