Gunjan Dokwal Email & Phone Number

Hyderabad, Telangana, India

•Worked on integrating data from Oracle E-Business Suite (EBS) sources and loading it into Oracle Cloud Autonomous Data Warehouse (ADW).•In-depth knowledge of designing and implementing data models using dimensional modeling techniques.Involved in creating and managing complex dimensional hierarchies within the Oracle BI model.•Experience in using Oracle Analytics Cloud to develop various types of visualizations and interactive dashboards based on business requirements.•Experience in creating reports using Data Visualization (DV) reports typically use charts, graphs, and other visual elements to make data more understandable and accessible.•Emphasized the importance of quality assurance by mentioning involvement in testing reports, ensuring accuracy and reliability in the generated analytics.•Proficiency in Oracle Analytics Cloud administration tasks, such as migrating Repository (RPD), managing the catalog, and creating snapshots for version control.

Mumbai, Maharashtra, India

•Extensive experience working on the migration project from Oracle Business Intelligence Enterprise Edition (OBIEE) 11g to Oracle Analytics Server (OAS) 6.4.Informatica 9.1 – Informatica 10.4 Migration•Engaged in administration activities related to Informatica, Data Warehouse Administration Console (DAC), and Oracle Analytics Server (OAS).•Engaged in migration of OBIEE 11g Binary Analysis and Reporting (BAR) files to Oracle Analytics Server (OAS), ensuring a smooth transition of analytical assets also Responsible for migrating catalog objects which include various metadata components in the OBIEE environment.•Accountable for making changes to the Oracle BI Repository (RPD) based on business requirements, suggesting involvement in the modification of the data model and metadata.Upgrade Issue Fixes for OBIEE Metadata, Reports.•Worked on testing activities post-migration to ensure that dashboards and reports function as expected in the new environment•After migration, Have worked on enhancing Informatica mappings, suggesting ongoing improvement and optimization of data transformation processes.•Worked on implementing Act As functionality in Oracle Analytics Server, which typically involves configuring user impersonation or proxy capabilities for testing or troubleshooting purposes.Migration Support for UAT and Production.

Mumbai, Maharashtra, India

• Connected with business users for Data modelling(RPD) and enhancing the visualisations and reports.• Responsible for manipulating and transforming data according to business requirements using data integration tool.• Resolved multiple high-priority production issues, provided support in production releases, and delivered root causes through incident management, service now ticket requests, change management, and Jira stories.

Mumbai, Maharashtra, India

• Collaborated with business users to understand data needs and developed Multiple Dashboards and reports providing relevant information on HR and sales data, resulting in a 20% increase in user satisfaction.• Worked on Basic RPD designing enhancements.• Worked on OAC Admin Activities such as managing storage for instances,RPD merging,data model updating through snapshot,migration of Reports,RPD deployments.• Provided technical support to over 1K BI reports and Informatica ETL workflows.

Bachelor Of Engineering - Be, Information Technology

Higher Secondary Education, Science