RAFAEL E. ARISMENDI ac9hpb@r.postjobfree.com

Troy, NY 12182 C: 518-***-****

Legal status: Lawful permanent resident

DATABASE ARCHITECT / BUSINESS INTELLIGENCE TEAM LEAD / BPM DEVELOPER /SQL DBA

Highly motivated and self-driven team leader with 16 years of experience currently seeking a career position that provides the opportunity to learn new technologies while utilizing experience and technical skills.

Strong experience in developing and implementing information system processes and SQL Database systems to identify and solve applications performance issues. Extremely organized with the ability to learn and share knowledge with team members while working in fast-pace work environments.

Dedicated and passionate about helping companies to become more efficient in processes that will translate into measurable IT results.

TECHNICAL SKILLS:

Microsoft SQL Server

Administrative Systems

Transact-SQL

AS400

Database Design

Bilingual: English & Spanish

ORACLE

Business process expertise

Business Intelligence

Strong Team Player

Networking

Strong Analytical skills

BPMS

Attention to details

Ultimus BPM Workflow Suite 7+

Improve Performance in applications

ETL develop

Integration Services (SSIS)

PROFESSIONAL EXPERIENCE:

Banco Occidental de Descuento (Western Discount Bank, BOD) Maracaibo, Venezuela. 11/2006 – 11/2018

Business intelligence Team Lead 11/2017 – 11/2018

• Led a team of four junior Database Analysts in several programming projects to improve SQL / Oracle database system and business intelligence reports.

• Worked with the assigned IT team and the business stakeholders to gather project scope, timelines, ensure resource alignment and oversee all phases of the project and ensure project deliverables which allowed a 40% of improvement in the existing production environments in just 3 months after the project was assigned.

Analyzed the behavior and performance of many ETLs Processes to get the transactional data from many source (Credit card core, agencies transactions, Debit card, ATM, Pos and other channels) around the all bank databases and cores to build the data warehouse information and cube and figure out any problems during the Etls process, resolve issues and relaunch.

Managed and tested any new or modified ETLs.

• Oversaw all projects and activities to ensure delivery of a quality product.

• Supervised activities and identified opportunities to make recommendations oriented to the optimization of the business intelligence platform.

• Supervised resolution of Production environment keeping with established SLA’s (service level agreement).

• Supervised dba’s interactions with end users to ensure quality of interaction.

Analyzed the performance of high demands SQL databases, solving 100% performance issues for existing and future databases.

Delivered project statuses at the high levels of the organization to help make decisions that will contribute to the success of the organization.

Database Architect 10/2015 – 11/2017

• Analyzed past issues and / or experiences in order to provide more effective business intelligent solutions.

Created, modified and tested any new ETLs requirement to get new data from a new source to build new reports.

• Created, developed, analyzed and delivered pre-scheduled and client ad hoc reports.

• Developed, defined and analyzed data security and integrity strategies of stored data and data farms.

• Managed data warehouse emergency contingency plans.

• Received, processed and solved user’s issues using business intelligence tools.

Business Analyst / BPM Monitoring Specialist 09/2010 – 10/2015

• Provided support to internal clients with the creation and use of database queries.

• Analyzed SQL database and ULTIMUS workflow BPM production environment issues to provide support and resolution.

• Provided technical support to the ULTIMUS workflow application.

• Developed reports for senior management to identify in advance critical paths and potential issues.

• Monitored and provided maintenance to over 15 SQL databases.

• Evaluated production SQL / BPM environment processes behavior, active requests, completed requests, pending requests and number of users that participated in the problem-solving process for each request.

System Specialist / BPM Developer 11/2006 – 09/2010

• Created and maintained organizational charts and sub-charts of 1300+ employees and its departments within two banks.

• Developed reports for senior management using the ULTIMUS workflow suit.

• Participated on brainstorm sessions to create special activities, updates and migrations plans using the ULTIMUS workflow tool.

Consultores Arismendi de Souza,C.A Maracaibo, Venezuela

IT Consultant 07/2004 - Present

As IT consultant, I have been working remotely with my clients in different cities in Venezuela such as Maracaibo, Valencia, Puerto la Cruz and Maturin. My job consisted in providing IT support, creating Reports and indicators for administration system.

• Migration, configuration, and management of SQL databases servers.

• Creation or changing Ad-Hoc Reports on SQL administrations programs.

• Installing, configuring or upgrading workstations.

• Building or configuring LAN network.

• Installing and configuring Windows servers.

• Active Directory management.

• Creation and configuration virtual workstations.

• Configuration of equipment, email accounts, printers, and other devices as routers, cams, wireless repeaters, NAS (Network-attached storage) and fingerprints.

• Disaster recovery, recover deleted files, repair Personal Storage Table (.pst)

Computer Output Microfilm, C. A. Caracas, Venezuela.

Senior Software Analyst 07/2005 – 10/2006

UNITECH, Servicios profesionales. Maracaibo, Venezuela.

Senior SQL Programmer. 01/2004 – 10/2005

M+R Consultores Asociados. Maracaibo, Venezuela.

Jr. Analyst BPM/SQL 07/2000 – 02/2002

HIGHLIGHTED PROJECTS:

Project: VPN connection

Year: 2019

Role: Designer, Developer and Administrator

Description: Created a VPN connection to ensure safe transmission of documents for Ted Trout Architects and Associates in Houston, Texas.

Project: Ultimus BPMS implementation.

Year: 2005

Role: Designer, Developer and Administrator

Description: Designed, developed and deployed 4 BPMS processes utilizing Ultimus Workflow suite for Occidental de descuento Bank about personal credit requisition. The ROI was initially planned for a two-year return but was completed within 6 months, improving the company profitability by 4 times. This BPMS processes is currently been used by 1300 users at the bank agency and at credit department as well. This project was exposed on the Latinoamericana de Bancos Federation (FELABAN) as a successful BPM project implementation.

ENVIRONMENT: SQL 2000, Ultimus Workflow 7.1 and Microsoft Windows server 2003.

EDUCATION:

University of Dr. Rafael Belloso Chacín Maracaibo, Venezuela

B.S. in Computer Science Graduated in 2000

Contact this candidate