LUIS SORIANO
Computer Systems Engineer
Melvindale,MI
Summary
Highly motivated IT professional with expertise in data engineering, IT auditing, and software testing. Excels at diving into new challenges and using data and technology to deliver smart solutions. Thrives in collaborative team environments and constantly seeks opportunities for growth and making a positive impact on the company.
Overview
13
13
years of professional experience
Work History
Data Engineer Specialist
Banesco
Santo Domingo
02.2024 - 08.2024
- Converted stakeholder needs into IT solutions.
- Enhanced organizational capabilities by modernizing BI report generation using AWS Data Lakehouse.
- Maintained data integrity by developing processes for both structured and unstructured data.
- Managed ETL processes with AWS Glue and Apache Airflow for optimal data transformation.
- Automated complex reporting processes with SQL queries and Python scripts.
IT Audit Manager
Banesco
Santo Domingo
08.2023 - 02.2024
- Developed audit programs to assess the effectiveness of processes within the organization.
- Enhanced audit procedures through collaborative efforts and Computer-Assisted Audit Techniques.
- Met with stakeholders to discuss compliance audit plans and results, explaining options for improvement.
- Performed follow-up reviews to ensure corrective actions were implemented properly by management teams.
IT Continuous Auditing Sub-Manager
Santa Cruz Bank
Santo Domingo
03.2022 - 07.2023
- Streamlined continuous monitoring processes through dashboard automation.
- Conducted regular meetings with staff to discuss progress, identify new scenarios, and areas of improvement.
- Implemented RPA for detailed automated business process reviews using ACL Robotics, SQL, and Python.
- Enabled non-IT auditors with data analytics for better insights.
Senior IT Auditor
Santa Cruz Bank
Santo Domingo
02.2021 - 03.2022
- Assisted in the development of audit plans and strategies based on risk assessment procedures.
- Enhanced compliance by meticulously evaluating controls and routines.
- Collaborated with IT process owners to develop actionable recommendations based on audit findings.
- Managed audit project paperwork, utilizing TeamMate+ audit tracking tool.
- Ensured secure generation and use of cryptographic keys.
- Enhanced precision of reports through comprehensive data examination.
Senior Information Technology Auditor
Asociacion Popular de Ahorros y Prestamos (APAP)
Santo Domingo
06.2019 - 07.2020
- Compiled documentation, work papers, and findings in TeamMate+ audit tracking tool for completion of audits.
- Assessed information technology processes and technological platforms to ensure accuracy and security.
- Thoroughly validated evidence to enhance IT governance.
- Assessed testing phase, aligning with disaster recovery plans, to guarantee success.
- Generated detailed reports summarizing audit results.
Senior Business Intelligence Analyst
Scotiabank
Santo Domingo
11.2017 - 06.2019
- Converted business needs into robust technical solutions for reports and visualizations.
- Designed and implemented ETL processes in SSIS packages to extract data from multiple sources into a data warehouse.
- Increased report accuracy through targeted KPI creation and SQL fine-tuning.
- Created and managed data models in IBM Cognos Framework Manager.
- Worked with teams to build self-service business reports using IBM Cognos Report Studio.
- Assisted users with ad-hoc requests related to data extraction from the Data Warehouse using complex SQL queries.
Senior QA Software Tester
Dominican Bank Progreso, Now Scotiabank
Santo Domingo
04.2015 - 11.2017
- Created detailed and structured test cases, cutting down production flaws by 95%.
- Conducted functional, smoke, regression, white-black box, exploratory, and integration test protocols.
- Executed manual tests on applications to identify issues in the design or functionality of a system.
- Developed automated testing tools to streamline repetitive tasks.
- Teamed with developers for quick resolution of application issues.
- Identified and addressed usability issues in applications being tested.
- Checked that past issues remained absent in subsequent revisions.
- Completed post-implementation evaluations, confirming project goals met.
Functional Test Analyst
BHD Bank
Santo Domingo
03.2011 - 04.2015
- Analyzed requirements documents to create detailed test scenarios and conditions.
- Developed test plans and test cases to ensure the quality of software products.
- Configured test environments to mirror production scenarios.
- Documented results of each test case run with detailed steps taken to reproduce any issue found during execution phase.
- Verified that all reported issues were resolved before final release on bug tracking tool, JIRA.
- Performed regression testing to boost system reliability and user experience on Core Banking (IBM AS/400), credit card processing, Siebel 8 CRM platforms.
Education
Diploma - Data Engineering With AWS
Smart Data
Peru05.2024
Workshop - Preparation of IT Risk Matrices Using COBIT 2019
ISACA Santo Domingo Chapter
Santo Domingo, Dominica Republic05-2023
Diploma - Data Sciences Foundation With Python
Smart Data
Peru04-2023
Certificate - SCRUM Foundation Professional Certificate (SFPC)
CertiPro
USA08.2022
Bootcamp - Basics of ACL Analytics - Applying Filters & Creat
Diligent Academy
Canada05.2022
Bootcamp - ACL for Audit, Data Analysis and Visualization
Udemy
USA04.2022
Bootcamp - Champion Training For The TeamMate+ Audit Solution
Gorico Advisory Group
Santo Domingo, Dominican Republic09.2021
Certificate - SCRUM Foundation Certificate (SFC)
CertiPro
USA08.2020
Diploma - Data Sciences With RStudio
Technological Institute of The Americas (ITLA)
Santo Domingo, Dominican Republic01.2020
Diploma - Risk-Based IT Audit
Institute of Internal Auditors (IARD)
Santo Domingo, Dominican Republic09.2019
Diploma - Fundamentals of Cybersecurity
Technological Institute of Santo Domingo (INTEC)
Santo Dominigo, Dominican Republic01.2019
B.S - Computer Systems Engineering
Dominican University O&M
Santo Dominigo, Dominican Republic12.2017
Workshop - OWASP Web Application Security Project
Sistemas Aplicativos (SISAP)
Santo Domingo, Dominican Republic10.2016
Workshop - Mastering Requirements Management With Use Cases
Argentum Inc
Santo Domingo, Dominican Republic06-2014
Workshop - Introduction to Quality System ISO 9001:2008
Management Consulting Group SRL (MCG)
Santo Domingo, Dominican Republic05.2014
Bootcamp - Java Programming
Technological Institute of The Americas (ITLA)
Santo Domingo, Dominican Republic11.2010
Diploma - Fundamentals of Oracle Database Programming PL/SQL
Autonomous University of Santo Domingo (UASD)
Santo Domingo, Dominican Republic07.2010
Skills
- Critical Analysis
- Analytical Problem-Solving
- Data-driven insights
- Strategic planning
- Detail-Oriented Focus
- Cross-Functional Team Engagement
- Persistence in Challenges
- Commitment
Languages
English
Professional
Spanish
Native/ Bilingual
Accomplishments
Analysis | May 2018 | Dominican Bank of Progreso Project Management Team: For your valuable contributions to the Bizagi Claims and Services project, helping the bank become more efficient.
Analysis | Oct 2016 | Dominican Bank of Progreso - Orlando Díaz: For your performance, dedication, and results during the testing cycles for our Progreso Mobile Banking App.
Excellence | Dec 2015 | Dominican Bank of Progreso - Miriam Badia: For demonstrating contributions to solutions and responsibility during the execution of the "Mobile Banking" project.
References
References available upon request.
Software
Microsoft Integration Services (SSIS)
Microsoft Reporting Services (SSRS)
Microsoft SQL Management Studio (SSMS)
Oracle SQL Developer
ACL Analytics
ACL Robotics
Microsoft Azure Data Studio
DBeaver
Anaconda Jupiter Notebooks
Visual Studio Code
AWS Cloud Services
Selenium WebDriver
Atlanti JIRA
Canvas
Bizagi
Oracle Siebel
IBM AS/400
IBM DB2
IBM Cognos Framework Manager
IBM Cognos Report Studio
Cypress
Postman
TeamMate Audit Tool
Microsoft Office
AWS Athena
AWS Redshift
AWS Glue
Work Availability
monday
tuesday
wednesday
thursday
friday
saturday
sunday
morning
afternoon
evening
swipe to browse
Quote
It is never too late to be what you might have been.
George Eliot
Work Preference
Work Type
Full TimeContract WorkWork Location
RemoteHybridImportant To Me
Company CultureCareer advancementWork from home optionTeam Building / Company RetreatsPersonal development programsWork-life balanceHealthcare benefitsSimilar Profiles
Vivian D. PrietoVivian D. Prieto
VPE Marketing-Experiencia-Canales-PMO Y Procesos at Banesco Panamá Y Banesco SegurosVPE Marketing-Experiencia-Canales-PMO Y Procesos at Banesco Panamá Y Banesco Seguros
Andy LeonAndy Leon
Promoter at Banesco Universal BankPromoter at Banesco Universal Bank
Yulianela MasYulianela Mas
Client Service Specialist at Banesco USAClient Service Specialist at Banesco USA
Yousef BenhadiYousef Benhadi
Busboy / Bar at Turkish Village Restaurant & CafeBusboy / Bar at Turkish Village Restaurant & Cafe
Vanessa EvansVanessa Evans
Server/Waiter at Corner Taproom Comerica ParkServer/Waiter at Corner Taproom Comerica Park