Analyzed requirements from client. Designed Data Model for data sources like Oracle SaaS Applications, CSV data files, MySQL Database and Oracle Database. Developed ODI ELT mappings from scratch. Prepared Business Requirement Document, Test Case Document and ELT Specification Document. Monitored and validated data loads. Designed and built interactive and insightful reports and dashboards in Oracle Analytics Cloud and Oracle RightNow Analytics. Documented the validation of reports with respect to source and target data. Assigned Application roles to the users created. Led review calls with the client. Resolved tool limitations with customized SQL query. Mentored newly onboarded developers in Oracle Analytics Cloud and Autonomous Data Warehouse. Trained client to create their own reports. Created user manual for the client to navigate through dashboards easily. Due to COVID-19, we were forced to work remotely.