Paul John Novelero

• Design, build and configure applications to meet business process and application requirements using MSSQL and Collibra • Define the interface and data requirements for Risk and Compliance vendor applications using Business Process Design and Development. • Assists with the data migration blueprints, encompassing the relevant data migration platform components and assets. Collaborates with the Integration Architects and Data Architects to ensure cohesive integration between systems and data models.

• Senior Informatica Lead (ETL) that creates simple to complex mappings for multiple frameworks • Creates Technical designs of complex functionalities for Bank Regulatory Reporting based on multiple German documents from the client • Creates a Unit test plan and conducts a functional and technical test of mappings and workflows • Performs Defect Analysis and Defect Fixing using SQL queries (DB2 and Oracle Database) • Supported Functional Designers during system integration testing for data validation

• Performed data deduplication using Identity Resolution and Data Quality. Data migration and consolidation using Oracle Data Integrator as ETL Tool. • Data Migration using INFA 9. Performed Unit Testing and QA to ETL mappings created. Performed Proof of Concept of Informatica Power Center 9. Develop and enhanced SAP Upload scripts by converting Teradata Scripts into Oracle PL/SQL. • Migrated data from the legacy database (Oracle 7.3.4 to Oracle 11g) • Recruited well-qualified candidates to fill vacancies.

• Created reports using Business Intelligence tools such as Pentaho Design Studio, • Power Analyzer, Brio Query, Informatica PowerCenter • Performed data migration from Ingres database to Data Warehouse (Oracle) - • Generates and creates ad hoc reports using shell scripts and Reflection Unix as a reporting tool • Communicate with customers / end users to better understand the requirements for filed issues and requests.