Developer Insurance

I have ** years of experience in Information Technology

Alexander Romero

New Jersey – The U.S.A.

Phone Number: 551-***-****

E-mail: ******@*******.***

DOB: 02/04/1975

Green Card Holder

***Analysis and development of custom systems (Client/Server and Web) with 14 years of experience.

Consulting in Information Technologies - IT

- I am of analytical, strategic, creative, and innovative thinking. 100% proactive.

- I can work under pressure in team and alone. I learn fast.

Major SKILL

- 14 years of experience - Oracle Pl/Sql: Stored Procedures, Functions, and Packages. Triggers. External tables, External Procedures(with C or Java programs). Oracle Sql Loader. Tuning Complex Queries(using Hints). Partitioned of tables/index. DBLinks, Sequences, Jobs, etc.

- 14 years of experience - Data Base Design and Data Base Developer with Oracle 8/8i/9i/10g/11g/12c, and SqlSERVER 7/2000/2005/2008R2. Wih ERWIN.

- 8 years of experience - Data WareHouse, Data Marts, ETL process, ODS, Exploration & Mining.

- Java, C, C++, C#. .Net.

- Optimal resource management for different projects.

- Computer Training.

PROFESSIONAL EXPERIENCE

JULY 2015 – NOWADAYS

Module / Business

Computer Training

UCEDA SCHOOL – NJ, U.S.A.

http://www.ucedaschool.edu/

Phone: 201-***-****

Training of Computer Information Systems

JAN. 2009 – NOWADAYS

Área

Module / Business

***I‘m in the United States since March 2011 for family reasons, however I still work using www.logmein.com for make my jobs like controlling servers Linux, Unix, SQLServer, Oracle, and application development..

Project Management / Senior Systems Analyst

ATENTO GROUP – LIMA, PERU

http://www.atento.com

TELECOMUNICATIONS

Department of Solutions. Management of Systems and Technology.

Project Manager/Leader Solutions. Leader an Engineering Group of 16 persons: 7 Analyst Systems, 6 Technical, 3 Assistant

Achievements Main

-Design, development and implementation WebService with Ajax and Apache, and another with JBOSS, these Pool Connection Managements in SQLServer2008R2, Oracle11g, PostGreSQL, MySql.

-IP Telephony Reporter Java Web Online with flow 50,000 calls per hour. Converting FRL (binary) to plane files from Unix server-> Linux-> Java Web (Front-End). Using UDP Socket (Language C/C Shell Scripting, Oracle 8i/11g(with external procedure in JAVA/C/C

-Design, development and implementation of CRM in two versions Delphi and JAVA in DB SqlServer2008R2 with online backup in DB PostGreSQL.

Tools

Java(JDeveloper/Eclipse/NetBeans): Servelts, Beans, JSF, J EECA, Applets, JSP, Swing, Threads.

UNIX/LINUX: Cron-Shell, shell scripting, C, C++, Pro C, Sockets UDP/TCP.

Oracle: PL/SQL development, External JAVA Procedure, External Procedure.

SQLServer: Transact-SQL, DTS, SSIS.

Microsoft Visual Studio .Net, C#/C++, ASP .Net.

Other: Delphi 7, Asp, PHP, BI, Macros in Excel.

MS Project. JavaScript.

Data Base

Oracle (8i, 9i,10g, 11g), SqlSERVER (2000, 2005, and 2008R2), PostGreSql, MySQL, Informix,

Methodology: RUP

Modeling: UML

Management Methodology: PMI

OCT. 2007 – DEC. 2008

Area

Module / Business

Area

Module / Business

Senior Systems Analyst

RIPLEY – LIMA, PERU

http://www.ripley.com.pe

BANK

Attention to normative SBS(Superintendency of Banking and Insurance of Peru), Interfaces SAP Oracle

RETAIL

Project SAM - Peru

Interfaces between MPS and PMM, Interface OFA(Oracle Financials) :

INTERFACE MPS – AP,INTERFACE PMM – AP

Tools

Oracle Developer (Forms and Reports), Developer PL/SQL, Macros in Excel, COBOL, ASP. MS Project.

Data Base

Oracle (8i, 9i,10g)

Methodology: RUP

Modeling: UML

Management Methodology: PMI

JUN 2004 - OCT 2007

Module / Business

Module / Business

Senior Systems Analyst Programmer

INSURANCE RIMAC – LIMA, PERU

http://www.rimac.com.pe

VEHICLES AND SOAT(compulsory insurance for traffic accidents)

ACSEL/X and WEB

Systems: Broadcast, Plans, Clearance, Claims.

HEALTH

Issuance System of Insurance Policies (AM)

System Plans Insurance Policies (AM)

Interconnection System with Health Provider (AM and EPS)

Liquidation System of Insurance Policies (AM and EPS)

Documentary Control System (AM and EPS)

Liquidation System (AM)

Online Consultation System (AM and EPS) Request of Benefits Web, Siteds, System of Support Operations SISO,

Management/Query Systems: Audit Sample, Alert & Statistics, SIG-Querys, Medical Conventions System.

SITEDS : Systems Interconnection between Insurance Rimac, EPS(Health Lender), Clinics of Health, and SEPS(Superintendence Health Lenders)

AM: Medical Assistance

EPS: Health Lender

Others: Support for Project Data WareHouse using DataStage.

Achievements

Stabilization of different systems and interfaces, as well as being responsible for the maintenance of these systems.

Intercommunication of the full range of systems developed with different tools.

Tools

Oracle Developer (Forms and Reports), Developer PL/SQL, Java J2EE(Studio Application Developer 5.1 - Web Sphere), Crystal Report, Clipper, Visual Basic, .NET, Visual FoxPro, Cobol, Macros in Excel. MS Project.

Data Base

Oracle (8i, 9i, 10g), Dbf, MSAccess, Excel, SQLSERVER, Flat Files.

Methodology: RUP

Modeling: UML

2000 – 2004

Area

Module / Business:

Systems Analyst Programmer

Omniscience Consultants S.A. – LIMA, PERU

Systems Development – Turnkey Projects.

ACCapitales System – APOYO Group- Power Builder & SqlSever

Project Management System of Buenaventura Engineering s.a. - .Net & SqlServer

Synchronization of signals alarm of vault of Banks from Peru (BANCARED) to Internet (Hosting TelMex). Intranet(ASP y Clipper DBF) e Internet(ASP y SQLServer) http://www.cuestor.com – Alarm Monitor

Accounting System "Costo y Distribución" from “Fondo Mi Vivienda” - Power Builder

Car Workshops System – AUTOALDIA - ASP & Visual FoxPro

http://www.autoaldia.net

SITEDS - Development of Data Base of SITEDS – Entities Superintendency of Health Care Providers (SEPS) - (2002-2003) - UNÍX, Oracle, C, C++

ASC X12N - Integrated Information System of Entities Superintendency of Health Care Providers (SITEDS - SEPS) (2002) – Electronic Transactions. References http://www.seps.gob.pe/proyectos/sistemainformacion.htm

SITEDS - Clínica Vesalio - Power Builder

SITEDS - Clínica San Pablo - Power Builder

SITEDS - Clínica Angloamericana - FoxPro2.6

SAT - Tourist Assistance System from Peru – PROMPERU - (2001) - ASP & SqlServer

Online Consultations - LFE Multimodal S.A. - (2001-2002)(offline http://www.lfemultimodal.com.pe) - ASP & FoxPro

Online Consultations - Aduamérica S.A. - (2001-2002)

http://www.aduamerica.com.pe - ASP & FoxPro

Association of Banks from Perú - ASBANC - (2002) http://www.asbanc.com - Intranet - Internet - ASP & SqlServer

Financial Crimes System of Association of Banks from Perú – ASBANC - (2002)(http://www.cuestor.com) - ASP & SqlServer

Online Consultations E-Brokers of Royal SunAlliance Insurance http://www.royalsunalliance.com.pe

Achievements

Development and analysis professional of the experiences gained in the analysis and development with different business/platforms and professional relationships Exchange of experiences. In addition to gaining knowledge of analysis frames X12N standard american of Health information transactions. Interfaces between differents systems.

Tools

Power Builder, SQLServer, Visual Basic, ASP, Clipper5.3,

Visual FoxPro6.0, Foxpro2.6, MSAccess, Crystal Report, Excel, PHP, Visual C. Ms Project.

Data Base

Oracle (8, 8i, 9i), Dbf, MSAccess, SQLServer, Excel, MySQL

Metodología: RUP

Modelamiento: UML

2004

Area

Module / Business

Independent Consultant – LIMA, PERU

Customs

Online Consultations System (Tr@nselNet)

http://www.transel.com.pe

Achievements

Aduanas Web Portal(e-business)

Tools

ASP

Data Base

SQLServer, Dbf, Archivos Planos

1996 – 2002

Area

Module / Business

1997 - 1998

Area

Module / Business

Professor of Computer Information Systems

National University of Engineering UNI – LIMA, PERU

Center Extension and Social Projection - CEPS/UNI - (2001-2002)

Computing and Informatics Institute - ICI/UNI - (2001)

Computer Center – Sciences School – FC/UNI - (1996-2002)

Head of Technical Support

National University of Engineering UNI – LIMA, PERU

Computer Center – Sciences School – FC/UNI

Achievements

Course Development and Teaching Structure

Tools

Power Builder 5.0, 6.5, 7.0, 8.0

Excel Avanzado y Access Avanzado Visual FoxPro 6.0, Visual Basic 6.0

Ofimática, Internet, Redes Windows

Base de Datos

SQLServer 7.0 Y 2000, Oracle

Others

INTEL - (2000-2001) – Perteneciente al Grupo IPI e-Business Network - Cod. 010027362

MAIN TOOLS

Environment ORACLE

* Persistent Modeling: Erwin

* Tools: Oracle Developer (Forms y Reports), PL/SQL - (PLSQL Developer/TOAD)

* Database Engine: Oracle 8i, 9i, 10g, and 11g

Environment MICROSOFT/.Net

Web Development, MVC

* MVC (Model View Controller): ASP.Net, ASP

* Persistent Modeling: Erwin

* IDE (Integrated Development Environment): Visual Studio 6.0, PowerBuilder (5.0, 6.5, 7.0, 8.0), Visual Studio 2005, Delphi 7.

* OS; Windows NT 4.0, Windows2000, Windows2003

* Web Server: IIS

* Other Tools: Visual FoxPro 6.0, Visual Basic 6.0, Visual C++, Macros in Excel y Access, Visual InterDev 6.0, Asp, PowerBuilder (5.0, 6.5, 7.0, 8.0)

* Database Engine: Oracle 8i, 9i, 10g, and 11g. SQLServer (7.0, 2000, 2005, and 2008R2), Dbf, MSAccess, MSExcel

Environment JAVA/J2EE

Web Development, MVC, CRM Solution

* MVC (Model View Controller): Struts, JSON, Servlet

* Persistent Modeling: Erwin

* IDE (Integrated Development Environment): Studio Application Developer 5.1 – WebSphere, NetBeans, JDeveloper, Eclipse.

* Database Engine: Oracle 8i, 9i, 10g, and 11g. SQLServer(7.0, 2000, 2005, and 2008R2). MySQL. PostGreSQL.

Environment LAMP

Web Development, MVC, CRM Solution

* OS Linux/Unix: Red Had, Ubuntu, etc.

* Web Server: Apache

* Database Engine: MySQL. Postgre. Oracle 8i, 9i, 10g, and 11g. SQLServer(7.0, 2000, 2005, and 2008R2).

* Programming Language: Python, PHP, Shell Script, Language C/C++/C Sharp.

Environment DOS

OTHER TOOLS

Clipper5.3, Foxpro2.6

Database Engine : DBF

MSProject, Language C/C++/Pro C, Unix - SunSolaris – Shell Scripting, Pascal, Phyton.

EDUCATION

2012 - Now a Days

1994 – 2000

2007

2006

2003

[ UNIVERSITY ]

Fairleigh Dickinson University – NJ, U.S.A.

National University of Engineering – Lima, Peru

Applied Mathematics – Science School

Systems Engineer – Industrial and Systems School

[ OTHER ]

JAVA/J2EE y .NET – CIBERTEC

Rational Rose - RATIONAL UNIVERSITY - SCM 290 y SCM 490

ClearQuest - Rimac Insurance

CISCO SYSTEMS NETWORKING ACADEMY

Ver 3.0 – Lima, Peru

Contact this candidate