Business Analyst, Project manager

Summary (just about Business Intelligence experience)

Alejandro Carrasquero

Profile

Last Update: Aug-10-2010

Name: Alejandro Heriberto Carrasquero Borges

Age: 35

Visa Status H1B (Octover 1st 2009 to October 1st 2012)

Marital Status: Married

Address: 1580 N.W. 128th Drive Apt # 301 Sunrise Fl. 33323

Country Nationality: Venezuelan

Country Residence: USA

Telephone(s): Cell +1-954-***-**-** Fort Lauderdale – Florida

Personal E-mail: mo6j1d@r.postjobfree.com and mo6j1d@r.postjobfree.com

Work E-mail: mo6j1d@r.postjobfree.com

Languages: Spanish - ( Fluid )

English - ( Technical and Conversational )

Current Situation: Business Intelligence Consultant in ACAP LLC

Presentation

He has served in Venezuela and Caribbean as leader and project manager for the analysis, design, integration, modeling, and implementation of information systems management on PRA's (SAP, BPS, JD Edwards, Baan, PeopleSoft) using OLAP tools (with Multidimensional Databases Oracle Express, Cognos, Business Object, Synera and Microsoft Analysis Services), Business Analysis, Business Rules (Artificial Intelligence) and 100% WEB technologies (Java, ASP, Dhtml, cgi-bin, perl, php, C, C + +, C #) in the areas telecommunications, finance, sales, accounting, petroleum, electronic commerce, human resources, law, public administration, among others, which has implemented development standards and methodologies reengineering, continuous improvement and total quality.

It has also contributed in the development of management support systems and expert systems for general use.

Currently serves as a consultant specialist in Web-enabled, e-Business, Business and Intelligent Business Rules offering support and advice as an expert and technologist to senior and middle management in the public and private sectors.

Work Experience

05/2008 – Present Consultant

ACAP LLC

Client Name: NetOpex

• Document Data Warehouse, fix issues and suggest modifications.

• Fix and maintain ETL process to automatic loader from ATT&T and Sprint invoices details to data warehouse.

• Fix and maintain ETL process to manual loader from CSV files to data warehouse.

• Fix and improve diagrams of circuits and relations generated by application in Silverlight and Visio.

• Create a delta view report of circuits with comparison between environments.

• Environment: Business Object Crystal Reports, SilverLight, Visual studio 2008 ASPX/C#, SQL Server 2005, SSIS, SSRS, CA AllFusion Data Modeling (ERWin), UML, Oracle 11g, OBIEE.

Client Name: Wireless Innovations

• Design and deploy ETL process to connect website to OVM Sprint.

• Designed the screens that were included in STT Trainer tool.

• Environment: PHP, XML, output in CSV/EXCEL/HTML.

Client Name: Flex Luthor

• Design, deploy and test ETL process between comparecher.com and comparison sites of insurances.

• Environment: ActiveX components and Visual Studio 2008.

Other Duties

• Developer in Visual Studio/PHP

• Resolve application Issues

• Delivery Manager with 6 developers in overseas (India/Russia/Turkey/Mexico).

12/2005 – 04/2008 Manager - director

True Web Network

Client Name: Corporación Andina de Fomento (multilateral bank)

• Define internal methodology and standard of Business Intelligences development based in Ralph Kimball methodology.

• Define internal methodology and standard of Data Modeling (warehouse, documental and relational databases).

• Define internal methodology and standard of Documentation of Integration Solutions (ETL)

• Data Model of every systems in company using reverse methodology and ERwin tool.

• Build the Corporate Data Model (high level).

• Inventory of Software Configuration Elements for Configuration Management Data Base (Remedy).

• Build the Integration Map (graphical) from CMDB though ETL software using PERL.

• Documentation of ETL applications modules.

• Instructor of Cognos, ER-Win, Data Modeling, Process Modeling.

• Environment: Cognos Suite 7.3 and 8.3, CA All fusion ERWin Data Modeling and Process Modeling 7, PERL, SQL Server 2000, Remedy.

Client Name: Central Madeirense (Retail-supermarket)

• Project Management of OBBIE for Oracle Financial deployment

• Prepare and document Discovery Reports to migration from Oracle Finance to Oracle Retail.

• Address meetings of board directors and the department headers to migration to Oracle Retail below Business Intelligence subject.

• Environment: Oracle 10, Oracle Financial, Oracle Discovery, Oracle Business Intelligence Enterprise 11g, Toad for Oracle, IBM servers.

04/2004 – 11/2005 Consultant and Instructor

IDC - Interamerican Data Consulting

Client Name: CANTV (telecommunications)

• Instructor at Oracle Tools and Operating Systems LINUX / UNIX.

• Environment: Oracle 10.

Client Name: IBM and Accenture

• Training: Administration and Support under UNIX and LINUX Operating Systems.

• Courses of UNIX Shell, PHP, PERL, Java, SQL.

09/2003 – 03/2004 Consultant

IBM de Venezuela, Software Factory

Client Name: CANTV (telecommunications)

• Consulting Business Intelligence, Business Rules, Database and Intranet / Internet site.

• Administration of “Mass Market Department” Intranet and “Channels Department” sales and performance system.

• Management “Mass Market Department” platform OLAP.

• Web Interface between “Mass Market Department” Intranet and MySAP CRM through SAP XI platform.

• Migrating Applications to PERL. NET platform in C # under ASP.

• Environment: Microsoft Analysis Services 2000, Oracle 10, Oracle Discovery, Business Objects, SAP XI Platform.

10/2000 – 09/2003 Consultant

Compañía Anónima Teléfonos de Venezuela (CANTV)

Client Name: CANTV (telecommunications)

• Consulting Business Intelligence, Business Rules, Database and Intranet / Internet site. Projects Involved:

• Design, Development and Implementation Management Module customer's Intranet CANTV Residential, cgi-bin PERL, HTML, JAVA SCRIPT, with connections to Oracle 8i, under Windows NT.

• Design of the database's intranet Residential CANTV in Oracle 8i.

• Design, Development and Implementation of CRM Application for Managing Customer Perl and Java Script, with bases in Business Rules and WorkFlow. Reach Call Centers, Telemarketing Centers, Offices Customer

• OLAP Report System of customer service, sales and management compensation in SQL Server.

• Web Interface to activate and deactivate key card UNICA (prepaid).

• Web Interface connection with CICS for consultation Balance, Orders and Auditing Call Centers.

• Web interface between the Control Order system and sales compensation system of Residential Department.

• Environment: Microsoft Analysis Services 2000, Oracle 10, Oracle Discovery, Business Objects, SAP XI Platform, CICS.

02/1999 – 10/2000 BI Consultant

LatinoBI (COGNOS Venezuela, formally Expernet Soluciones, c. a.)

Client Name: Corporación andina de Fomento (multilateral bank)

• Construction of multidimensional models Client Portfolio.

• Construction of multidimensional models for the finance and sales departments

• Environment: Cognos PowarPlay and Impromptu 6, SQL Server.

Client Name: Novartis de Venezuela (Laboratory)

• Construction of multidimensional models for the finance and sales departments

• Environment: Cognos PowarPlay and Impromptu 6, BPCS.

Client Name: Intesa (Deltaven)

• Customer Support

• Environment: Cognos PowarPlay 6, JD Edwards.

Client Name: Intesa (Intevep, Exploration and Production)

• Customer Support in a Expert system about Business Rules.

• Environment: NeuronData/Blaze.

Client Name: Revlon (Cosmetics)

• Study Forecasting tools Data Mining

• Environment: Cognos Scenario and 4thought 6.

Client Name: Telcel (Telecommunications)

• Construction of multidimensional models for the area of finance and trade.

• Environment: Cognos PowerPlay and Impromptu 6, input CSV files.

Client Name: Bigott (tobacco)

• Management Information System. Construction of multidimensional models in Finance & Sales. Portfolio reporting and automation.

• Environment: Cognos PowarPlay, Impromptu and Portfolio 6, IBM AS/400.

Client Name: Lafarge (Cementos la Vega) (Cement)

• OLAP Proof of concept

• Environment: Cognos PowerPlay 6.

Client Name: Citibank Venezuela

• Construction of multidimensional models and reports.

• Environment: Cognos PowarPlay and Impromptu 6, SQL Server.

Instructor

LatinoBI (COGNOS Venezuela, formally Expernet Soluciones, c. a.)

Client Name: Corporación andina de Fomento (multilateral bank)

Client Name: Mattel de Venezuela (toys)

Client Name: SUDEBAN (government – bank supervisors)

Education

• Bachelor (Computer Engineer), October 2006

o Universidad Simón Bolívar – Venezuela

• AllFusion ERWin Data Modeler R7 Jan 2007

• AMS, Team Work and CMM in IBM de Venezuela, Dec 2003 to Feb 2004

• Cognos 6.5: Feb 2000

o PowerPlay Enterprise

o Impromptu Web Report

• Cognos 6: Aug-Dec 1999

o Report Building with Impromptu,

o Impromptu Administrator,

o PowerPlay Data Exploration,

o Report Building with PowerPlay,

o PowerPlay Administrator

o PowerPlay Administrator Advance

• Microsoft Certified: Designing and Implementing a Data Warehouse Using Microsoft SQL Server 7.0 (Couse: 1502A) Feb 1999

Skills

• Business:

o Good communication with all organization levels, negotiation

o Resolve technical conflicts and business analysis

o Good communication with different cultures

o Project Management

o Make Presentations

o Data Modeling (Relational, documental and data warehouse)

o Process Modeling

o Customer Support

o Resolve complex Issues

o Documentation of best practices and lessons learn.

• Business Intelligence tools:

o Cognos

• PowerPlay, Impromptu, Transformer 6 and 7.3

• Cognos Suite 8.3

• Cognos Server Administration 8.3

• Query, Report and analysis studio 8.3

• Scenario, 4thought, Porfolio v6

o Oracle OBIEE / Oracle Discovery / Express

(ETL tools Informatica and Hyperion inside OBIEE)

o Business Objects / Crystal Reports (middle experience)

o Synera (now illuminate)

o Hyperion, SAS, Brio(middle experience)

o Elixir, Dimensional Insight (low experience)

• Project Management tools:

o Microsoft Project

o Microsoft Enterprise Project Management

o Dotproject

o Primavera (low experience)

• Modeling tools:

o CA AllFusion Data Modeler (ERWin),

o CA AllFusion Process Modeler (BPwin)

o MySQL Workbench 5.1 OSS

o Microsoft Viso

o Dia

• Business Rules tools:

o Blaze (NeuronData)

o VisiRules

• Web services:

o IIS 6 and 7

o Apache and tomcat

• Databases:

o Microsoft SQL Server 2000,2005,2008

o Access 2000-2008

o MySQL

o Oracle 9-11g

o Teradata

o IBM DB2

o Sybase and Informix (low experience)

• ERP (connectivity to)

o SAP BW

o SAP R/3

o JD Edwards.

o Oracle Financial

o Baan

o PeopleSoft, Sievel, Vantive (low experience)

• Operation Systems:

o Windows NT/2000/2003/XP

o Unix: HP-UX, Solaris/SunOS, AIX

o Linux: Ubuntu, Red Hat, SuSe, Fedora

• IDE:

o Eclipse

o Visual studio

• Programming Languages:

o C/C#

o Java/JSP/Javacsript

o PERL/PHP/ASP

o XML/HTML/CSS

o Prolog/Scheme,Lisp

o Dbase/Clipper

• Others:

o Leading multidisciplinary work teams with initiative, energetic and dynamic

o Installation and configuration of software

o Analysis and detection of flaws and errors as study of events

o Technical Teacher (Instructor)

Contact this candidate