Alex A. Feliz Pena

Under CGI's mandate, Sr. Feliz worked at Bank National of Canada as an ETL developer on an anti-money laundering project.

Alex Feliz was then assigned to Via Rail Canada as an ETL Developer Specialist where Sr. Feliz contributed to a CRM migration project. the goal achieved was 100% assurance of data integrity.

Finally, Sr. Feliz was assigned as an ETL Specialist for the Provincial Health Services Authority of British Columbia in their collaborative project with the Observational Health Data Sciences & Informatics. The objective obtained at the end of the mandate was the improvement in handling times thanks to the understanding of business rules and information requirements.

• Designed and created ETL code installations, aiding in transitions from one data warehouse to another.
• Delivered outstanding service to clients to maintain and extend relationship for future business opportunities.
• Supported clients with business analysis, documentation, and data modeling.
• Prepared presentations to explain revisions, enhancements and process improvements of organization's systems and programs.
• Designed integration tools to combine data from multiple, varied data sources such as RDBMS, SQL and big data installations.
• Managed data quality issues during ETL processes, directing qualitative failures to team lead for amelioration.
• Collaborated with business intelligence staff at customer facilities to produce customized ETL solutions for specific goals.
• Restructured procedures through coordination with compliance director to create and execute projects.
• Interpreted data models for conversion into ETL diagrams and code.
• Designed data models for complex analysis needs.
• Optimized broken and inefficient assets through effectively troubleshooting technical processes and workflows.
• Documented and communicated database schemas using accepted notations.

Sr. Feliz works on creating ETL for uploading information related to payments made online from different online gambling sites. Also part of his assignments was the migration of reports in SSRS to Power BI, another of his assignments was the data modeling for the new aggregated data sources

Sr Feliz performed the following tasks:

• Loaded data from different data sources
• Development and improvement of existing reports in SSRS
• Generation of data integration processes with SSIS
• Generated and drew ETL Transaction
• Build and design a Data model for the Stage table and new process.
• Migrated files from SSRS to new ones made in Microsoft Power BI.
• Contributed ideas and suggestions in team meetings and delivered updates on deadlines, designs, and enhancements.
• Designed and developed analytical data structures.
• Conducted data modeling, performance, and integration testing.
• Created proofs of concept for innovative new solutions.

Working as Senior Data Analyst, specifically working with Fico Analytic Decision Platform Platform used to build risk model, debt collection, and scoring solutions.

In this position, Alex Feliz performed the following tasks:

• Designed data model is used to create analytics about client scoring
• Built decision model for implementation in decision platform
• Corrected issues related to database performance, reliability, and scalability.
• Formulated ETL to obtain input data for decision-making rules
• Produced quality reports formatted in compliance with data quality standards.
• Implemented improved reporting techniques, resulting in performance deficiencies identification.
• Help maintain quality by using code reviews, organization, documentation, and automation
• Reviewed application design specifications and database access methods to prevent inefficient coding.
• Analyzed database schemas involved and developed approaches for accessing and updating data.
• Reviewed and analyzed systems functions and reporting processes for accuracy.

As a Data and Risk Control Analyst Sr. Feliz was in charge of the creation and maintenance of regulatory documents, delivery of information to regulatory entities, and review of the loan portfolio to achieve these objectives Sr. Feliz implemented the use of reporting tools for the creation of dashboards for the visualization of some data, tools such as Microsoft Power BI, Microsoft Reporting Services and Excel were the main ones.

In this position, Sr. Feliz was doing the following tasks:

• Creation and maintenance of regulatory information
• Delivery of information to regulatory entities.
• Review of credit portfolio.
• Produced monthly reports using advanced Excel spreadsheet functions.
• Optimized and improved existing regulatory reports.
• Developed required policies and procedures that reflected actual goals, tasks, and workflows, while meeting all regulatory compliance requirements.
• Perform proactive analysis of platform data to predict overloads and failures and correct them ahead of time.
• Utilized data visualization tools to effectively communicate business insights.
• Produced stored procedures and functions in MS SQL.
• Tested data prediction algorithms based on historical data.
• Participated in requirements meetings to understand business needs.
• Guaranteed to maintain quality of data.
• Identified, analyzed, and interpreted trends or patterns in complex data sets.
• Improved database performance.

Mr. Feliz had the opportunity to gain experience in the area of development in various programming languages for mainframe systems such as Cobol, Linc 2, and DB2 as well as system implementation and software development, obtaining an advanced level of PL/SQL and T-SQL, database enhancements through SQL Tunning.Other activities achieved during this assignment were Data Modeling, Data Structure Design, and Creation.

In this position, Sr. Feliz executed the following tasks:

• Established new features requested by the business unit
• Fixed detected faults
• Introduced adjusted business rules for the system
• Tested programs and databases to identify issues and make necessary modifications.
• Established change and applied regulatory changes to core systems
• Designed, developed, and implemented software applications for websites based on analyzed requirements and understanding of industry technical standards.
• Produced, writing, debugging, optimizing, and performance tuning of stored procedure, views, triggers
• Revised, modularized, and updated old code bases to modern development standards, reducing operating costs, and improving functionality.
• Generated Shell Script to perform tasks on Unix systems
• Translated customer requirements into written use cases.
• Migrated Data from DB2 to SQL Server.
• Documented technical workflows and knowledge to educate newly hired employees.
• Performed database optimization and performance tuning
• Collaborated on stages of the systems development lifecycle from requirement gathering to production releases.

As a senior developer, Mr. Feliz had the experience necessary to increase relational database knowledge and strengthen reporting skills while improving the performance and efficiency of database queries in distributed computing operation.

• Develop applications using Visual Basic, C #
• Designed best practice documentation for development.
• Creation of reports with Crystal Reports
• Participated in design and planning exercises for future software rollouts.
• Resolved system test and validation problems to provide normal program functioning.
• Development of operation in the database.
• Updated technical documentation, product specifications and technical training materials.
• Designed and developed application scripts for test scenarios.
• Collaborated with stakeholders regarding project capabilities and limitations to deliver optimal functionality.
• Wrote code for database applications.