ALEX ROQUE

17055 NE 35 Ave Apt 208, North. Miami Beach, Florida33155 / Ph: (305)788-8041 /

OBJECTIVESeeking a challenging position in the area of developer/dba to use my knowledge and skills to implement or support a mission critical system.

EDUCATIONMaster of Science in Computer Science Bachelor of Science in Computer Science F.I.U., Miami, FL F.I.U., Miami, FL

SKILLSSecurity: Routers, Hubs/Switches, Firewalls, VPNs, Intrusion Detection
Admin: Oracle 8i & 9i, Oracle App. 11, Linux, Unix, MySQL, NT, Apache, Tomcat, Websphere, Oracle Discoverer, Oracle Enterprise Manager, Oracle Toad App. Developer, OFA, Informix DBAccess, Oracle Forms and Reports 6i,Veritas

Lang.: C/C++, JAVA, PL/SQL, SQL,Perl, JSP, Unix, PHP, XML Java DOM, J2EE, .NET C# Soft. Eng. Methods: CVS, Mozilla, Rational Clearcase & Rose, UML, Unix DDTS

EXPERIENCEApplication Developer/DBA Oct-2002-Now

Visa International – Miami, FL

Team developer/dba of an online transactional application distributed to financial banking institutions which integrated tools such as Oracle Discoverer, Oracle Portal, and Oracle 9i DB R2.

  • Provided custom PL/SQL code for monthly load of tables.
  • Used Oracle Enterprise manager to manage tables, materialized views, custom packages, tablespaces.
  • Administrated Discoverer users and reports.
  • Part of design and implementation team which optimized a 7-day process to a 1-day process.
  • Created custom code for and performed QA on Oracle Portal.
  • Performed DB backups with Veritas backup application.
  • Tuned Unix script to perform crontab daily data refresh.

Lead project manager/developer in financial analytical project that retrieves information from different data warehouses and presents reports to users through Oracle Discoverer.

  • Application development and maintenance of Tomcat JSP and Java modules to perform data manipulation on Informix Transactional Data Warehouse and Oracle Transaction Data Warehouse.
  • Design website for submission of data warehouse services with HTML and JSP.
  • Build from business requirements, publish technical documentation and provide testing scenarios.
  • Oracle Discoverer Administration of EUL, users, meta-data, item classes, and summaries.
  • Create financial workbooks in Discoverer Client as specified by users.
  • Perform crucial data warehouse operations in SQL and PL/SQL such as SQL Tuning, DDL, DML, Packages, Procedures, and Triggers. Perform DBA maintenance when needed.
  • Design and implement prototypical Oracle 6i Forms and reports.
  • Assist in implementing and analyzing Oracle DBA Unix scripts.

Application Developer July 1999-May 2000; May 2001-Oct-2002

N.A.S.A.RegionalApplicationCenter – Miami, FL

Design and development of data mining J2EE Java modules.

  • Analyze structure of web sites and design algorithm solutions for parallel data mining.
  • Document,debug exp. library using XML templates;mentor junior programmers.
  • Work with management personnel to develop software according to business requirements and company software specifications.
  • Ensure application integrity, security, and compatibility with DB and QA group.

Application Developer May 2000-May 2001

Motorola, Inc. – Boynton Beach, FL

Development of a pager application that provided user translations by using a web site

  • Designed web site extraction application using Perl, Unix batch scripts & FlexScript.
  • Observed and used software engineering principles (use cases, requirements, etc.).
  • Source control management with Rational Clearcase & bug tracking with DDTS.

Development of a multimedia package for the Accompli 009 product

  • Developed real-time multimedia functions such as zooming, scaling and rotation.

Administration of Linux server and group web page

  • Implemented security: ipchains, user policies, port forwarding.
  • Developed group’s web page under Apache web server with Perl/PHP Scripts.
  • Installed and configured S.E. tools such as GUI CVS, tinderbox and mozilla.

Part of a development team that developed an embedded Linux device

  • Developed and configured applications with C

Application Analyst Nov. 1996-July 1999

Carfel Inc. (now Spx. Inc)Miami, FL

Programmed scripts to aid in user administration

  • Developed small scripts to aid transaction processes using C++ Standard library
  • Wrote PL/SQL data conversion scripts for Oracle tables

 Helped implement an Oracle ERP multi-tiered system from a legacy business system

  • Managed Oracle applications system & supported Oracle applications 11.0.2
  • Worked with consultants to resolve issues on application setups in a live environment
  • Database maintenance and tuning, including database backups and rollbacks

Supported NT server domain and Unix, users, IIS, Exchange, and proxy/firewall

  • Administrated user accounts and implemented security policies
  • Performed security audits via network scanning agents, logs, and virus containment
  • Wrote numerous batch scripts in Unix environment to support day to day operations and processes.

CONSULTING EXPERIENCE

Data Modeler/Developer June 2002-Nov 2002

Appointment Search.com – Miami, FL

Design and Implement appointment e-commerce site.

  • Database modeling through ER diagrams.
  • Worked with layout artists and MySQL database administrator to design and implement PHP pages.

LAN Admin

Wetworks LAN Games– Miami, FL Ongoing event based

Perform LAN setups, administration, and maintenance during events

  • Time sensitive network setups from scratch with routers, hubs, Windows and Linux.
  • Provide administration and tech support to LAN users during events.
  • Practice safe security habits and optimize network to minimize latency.

PUBLICATIONSArchitecture of Intrusion Detection using Intelligent Agents, -author

Mapping from XML DTD to Semantic Schema, -co-author / presenter Database on Salinity Patterns in FloridaBay, -co-author Dispatching Java agents for data extraction from third party web sites -co-author / presenter

LANGUAGESFluent in Spanish.