Rafael Arismendi

Highly motivated Team Leader offering 25 years of deep expertise across database architecture, data migration, and Business Intelligence. Proven ability to develop, optimize, and maintain complex systems and large-scale migrations. Expert in data modeling and ETL pipeline development (SSIS), consistently ensuring data integrity, peak performance, and regulatory compliance. Focused on driving process improvements and delivering measurable IT results.

PROFESSIONAL EXPERIENCE:

Kelmar Associate – Crossfire Consulting                                                        Remote, Albany, NY. USA 02/2023 – 08/2025

Database Conversion Specialist – SQL developer

• Successfully analyzed, transformed, and migrated over 528 million records from NYS clients’ CRIS legacy Unclaimed Property systems into a staging database, where data formats were standardized, equivalent IDs assigned, and referential integrity validated, before final migration into the KAPS production database, ensuring data integrity, completeness, and accuracy
• Designed and implemented robust migration logic leveraging the staging database to streamline transformations, enforce business rules, and prepare data for seamless integration into KAPS.
• Developed and optimized SQL scripts and stored procedures, reducing execution errors, improving maintainability, and enhancing control over migration activities.
• Built and executed SSIS ETL workflows, orchestrating parallel and sequential processes to maximize throughput, completing full migrations within 12 hours.
• Performed comprehensive reconciliation and validation reporting, enabling next-day verification and minimizing post-migration issues.
• Tuned database performance and optimized queries while managing key database objects (functions, views, indexes), ensuring efficient and reliable system operations

New York State Office of Information Technology Services - Greycell Lab Inc    Albany, NY. USA      02/2022 – 02/2023

Senior Programmer –  TSQL developer

• Provided Level III support for the New York State Early Intervention Program (EIP).
• Developed Oracle scripts to support internal clients and monitor production environments.
• Monitor and maintenance New York State Early Intervention Program services.
• Evaluated production environment active and pending requests.
• Created a comprehensive library of automated scripts that significantly improved system efficiency, reducing pending support tickets to nearly zero.

3M Health Information Systems - Experis. Manpower Group                       Albany, NY. USA           01/2020 – 01/2022           

SQL Data Developer  / IT Developer II                     

• Write, debug, maintain, and test major healthcare application software and supporting data structures.
• Build data pipeline enhancements, automated tests, and automated deployments that meet the requirements defined by the Product Owner.
• Work with JIRA (work tracking), TortoiseSVN (version control), Deployment Wizards and Job Manager Tools.
• Improved deployment reliability and reduced post-release incidents through automation and continuous integration enhancements.

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 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.
• Act as the primary ETL technical liaison working with technical infrastructure teams to resolve problems and implement solutions to technical issues impacting application performance.
• Manages and administers ETL solutions for medium to large scale OLTP and OLAP projects
• 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.
• Act as Development DBA / Business Intelligence DBA for all BI Databases servers.

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.   

•      Act as Business Intelligence DBA / Development DBA for all BI Databases servers.

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.

University of Dr. Rafael Belloso Chacín 

B.S. in Computer Science