Rod Lopes

Background

About Rod Lopes

I am a qualified IT professional with over ten years’ experience in different IT areas. A results driven software professional with 5+ years of progressively responsible experience in Data Analysis, Design, Implementation, Administration and Support of Business Intelligence, Data warehousing, Data mining and Data Modeling using Confidential SQL Server 2012/2008R2 /2008/2005, SSIS, SSRS and SSAS. I have substantial experience in many work areas, such as Banking/Financial (Toyota Financial, Brazil Bank, Caixa Seguros – Brazilian Superfund company), Utilities (Electricity) and public sector. Recently, I was working at Toyota Finance, giving support to their Collections, Hardship, Customer Service and Operations teams, supplying them with the reports. TECHNICAL SKILLS Data Analyst & Microsoft Developer Skills • Cloud: azure Sql database via import data and AWS Redshift • Data Integration: using SSIS – ETL • Database Technologies: SQL Server (tables, Views, Constraints, Triggers, Joins, Cursors, Temp Table, Table Variable, Functions, Batch Scripts and numerous stored procedure consumed at various stages of migration/cleansing process, reports or data validation, the data warehouse (Oracle, MS SQL Server, Azure SQL DB, and Snowflake). DBA tasks doing Installation, configuration, maintenance, upgrading, tuning for Oracle, DBA, SqlSever for SAP Systems. • Data Modelling: SAP PowerDesigner Desktop Client for Solution Manager 7.1 • Reporting and Business Intelligence: Power BI, SSIS, SSRS, SSAS DAX, SSAS, Excel, VBA • Access Security: 8 years working as SAP Security dealing with confidentiality, integrity, and availability of user access. End user training to how to you’re their access on the System. System Operation: Maintenance of SO such as (Sql Server, Linux, Unix, Solares) PRACTICES • Team Manager – 3 people directly and 10 indirectly. • Migrated existing self-service BAU reports and adhoc reports to Power BI • Responsible for designing, development, testing, and deployment of Power BI Dashboards • Developed reports and visualizations using DAX functions such as table function, aggregation function, iteration functions and complex calculated measures • SSAS - Created Functions, queries, Storage Procedures, Views to manipulate data and Business Requirements to improve performance on the Power BI Dashboards. • Experience in Migrating databases from SQL 2008 R2 to SQL 2012 • Created SSIS packages to import data from Access, Excel, XML and Flat Files. • Performed Extraction & Migration of Data (ETL) from heterogeneous data sources using SSIS.