Jose R Prieto Email & Phone Number

Dallas, Texas, United States

Orlando, Florida, United States

Responsible for analysis, design, code, test and implement the model backend for Pricing, Availability, Booking, Customer and Account engines for the timeshare web solution.• Designed, Modeled, Developed and support for Pricing, Accounts, Booking and CRM engines for timeshare solution interacting with product owners and development teams to generate clear and detailed understanding of business rules to be implemented in the model of the web solution. • Analyzed and ensured efficient transition of all design documents and developed Pl/Sql packages, procedures, triggers, functions to process the data and generate JSON responses for the webservices over an Oracle 12.1c in response the requests from Mulesoft Integrator Spring Boot APIs to process requests in less than 1 sec handling thousands of combinations through the engines.• Worked with Middleware team to define and implement the CI/CD procedures through Jenkins including security and versioning control.• Evaluated software architecture for Oracle applications, prepared layouts for logical and physical models and maintained database objects for application components looking to ensure integrity and data quality.• Monitored and recommended changes if required to PL/ SQL packages, procedures, triggers, functions based on troubleshooting and production performance indicators to improve the processing time on workloads as individual requests.• Developed data warehouse models and prepare reports for meta data integration into systems, draft ETL scripts and provide reports to business users.• Collaborated with Metadata Manager on quality assurance, provided updates to ETL activities within schedule, provide support to all large data volumes loads and assist in data processing.• Prepared technical and system specifications documents for ETL processes, perform unit tests, regression test, prepare required programs and automate shell scripts to generate partitions on cube models.

Juno Beach, Florida

Designed and development of Business Intelligence solutions for Trading Risk Management based on Agile Methodology. · Active participation on Stand ups, Backlog grooming, Retrospective and spring planning sessions using Jira, Confluence, · Perform relational database analysis, modeling, and design of complex processes to extract data from Oracle databases to provide reporting tools for management of trading credit exposure and control credit risk. · Interact with Credit business users to detailed client objectives, developing customized programming solutions, using complex Pl/Sql scripts, MSBI, SSAS, SSRS, Power-BI and ExcelPowerPivot, GIT. · Develop and perform detailed unit, quality assurance and regression tests to validate the readiness of internal developed code for trading credit management · Created and maintenance detailed technical design, data mappings, program logic, and flowcharting documents in accordance with business requirements. · Created detailed deployment plans for use in the migration of code from staging to production environments providing deployments. · Work closely with the Risk Credit Management Product Owner and Business Analysts to translate business needs into technical solutions · Attend routine departmental meetings to support communication around development best practices, participate in change control discussions, review code, and share technical instruction to colleagues

Orlando, Florida, Estados Unidos

Designed and development prepaid card toll payment module for National Bank of Costa Rica, some of the main tasks included.• Analysis and Design of module specifications, including data modeling, functionality, storage, processing, testing and deployment.• Inventory control of issue prepaid cards.• Link of prepaid card customer with credit cards.• Connectivity with core banking to interchange data.• Automation of dairy process.• Reports by cards issued inventory, cards assigned to customers and available at offices, transactions processed, summary of balance by office and more. • This Module was developed with Pl/Sql, Sql, Oracle Forms 11g, Oracle Reports 11g, Weblogic, connectivity, Sockets, C, Sql*Loader, Pro*C and WebServices.Developed and implemented application module for Banco Popular on new tax collection charge for credit card purchases, the following tasks were executed:• Analysis and definition of requirements.• Modified ER database model.• Developed forms, reports, procedures, functions, packages and views that support all the functionality.• This project was developed with Pl/Sql, Sql, Oracle Forms 11g, Oracle Reports 11g, Oracle Fusion Middleware, Weblogic, Sql*Loader, SqlDeveloper.

Bogota, Colombia

• Designed and Development of new requirements for credit card legacy system at Banco Popular. • Analyzed and designed changes for credit card legacy software, fixing existing bugs in forms, reports and current processes for faster response time and accuracy.• Executed data migration on legacy Credit Card application to FirstData - Vision*Plus system for Banco Popular, that include data analysis, reporting, business process analysis, data conversion, validation, integration, Tested and certified that data migrated was accurate• Performed data analysis, mapping and development of ETL process to extract data to be loaded at Vision*Plus, using Sql*Loader, Pl/Sql, Sql, Data modeling, SqlDeveloper.• Tested and certified that data migrated was accurate.• Designed, developed and implemented setup application, data processing, user reports, security and user interface forms.• Performed tuning of procedures and packages to improve data processing time.

Bogota, Colombia

• • Designed and developed credit card management system from scratch with 28 administrative and operative modules and connectivity with core banking, VISA and MASTER CARD. • Designed and implemented data warehouse solution about credit cardholders information for customer service division. • Implemented procedures to obtain the international quality certification ISO 9000 in development software processes.• Provided a functionality map of processes and PL/SQL procedures to guarantee data accuracy, integrity and to fulfill user application requirements.• Coordinated software development team during implementation process of credit card management system at Banco GNB Sudameris and Banco of Costa Rica.• Designed and Implemented procedures and standards for software development team.• Provided software application maintenance for credit card developments for customers who bought the credit card system.• Executed data migration for deployment of new credit card solution for Banco of Costa Rica and Banco GNB Sudameris.• The components of the credidt card solutions were developed using Oracle Forms, Oracle Reports, PL/SQL, SQL, BI, OWB, ETL tools, Java, Pro*C, XML, C, Oracle 10g and 11g.

Bogota, Colombia

• Managed and developed custom projects from inception to deployment for a variety of internal and external customers in the banking industry to both define and support new technical solutions• Gathered initial requirements for customization of credit card solution.• Developed credit card application with packages, procedures, scripts, Forms and Reports using PL/SQL, SQL, Pro*C, Oracle Forms and reports, Oracle Developer Suit, C, C++.• Executed tuning of PL/SQL Procedures, Packages, Functions, views and SQL scripts. • Created testing scenarios for QA team.• Developed migration process for Credit Card Systems in Financial Companies.