ETL Development and Optimization: Create and implement efficient ETL processes to gather and integrate data from various sources into the data warehouse, enhancing its usability.Data Purging Strategies: Develop and execute data purging plans to manage the data lifecycle while complying with regulations, improving database performance by removing unnecessary data.Data Monitoring Practices: Use effective monitoring techniques to ensure data quality and integrity, allowing for reliable data usage and optimal system performance.Management of Data Growth: Manage data growth effectively to optimize storage costs while maintaining system performance, ensuring the database operates smoothly even with increasing data volumes.Partitioning Strategies: Plan and implement data partitioning methods to improve query performance and efficiently handle large datasets.Oracle Application Support: Provide support for Oracle applications, including Oracle OAS, troubleshooting issues and optimizing performance to enhance user experience.Query Optimization: Focus on optimizing SQL queries to improve system performance and reduce execution time.Report Development: Generate reports in RDF and RTF formats using the Report Builder tool and through procedures, ensuring accurate and timely data presentation.

Underwriting Module Development: Collaborated with cross-functional teams to design and implement an intuitive underwriting module that streamlined risk assessment and policy issuance, significantly reducing processing time.Claims Module Implementation: Directed the development of a robust claims management system, allowing for efficient claim submission, tracking, and resolution. This initiative improved customer satisfaction and reduced claims processing time.Agile Project Management: Utilized Agile methodologies to oversee project timelines, manage resources, and facilitate regular team meetings to ensure project milestones were met on schedule.Stakeholder Engagement: Effectively communicated with stakeholders to gather requirements, provide project updates, and gather feedback, ensuring alignment with business objectives and customer needs.

User support for all modules: Provided total support on all MIS modules, including the guidance of users to their ability to navigate the system, troubleshooting difficulties, and the improvement of the user experience, which implies effective achievement of operational efficiency.BAU Task Management : The practical day-to-day operations and routine tasks were well managed in a way that issues were sorted out promptly. This ensured that the information systems worked well, which furthered the normal workings of business operations.In Jasper Reports: Initiated the migration of the existing MIS reports into Jasper Reports, ensuring accuracy and aesthetic appeal of these reports. Data migration for these reports helped improve the accessibility and presentation to stakeholders.Data Analysis and Reporting: Analysed data from a variety of sources to create reportful insights for strategic decisions and performance evaluation by senior management.

Optimized Automated Reporting Processes: Enhanced reporting efficiency by 40% through process automation, significantly improving data accuracy by 20%. This optimization resulted in timely, actionable insights that empowered informed decision-making across the organization.Data Integration for Advanced Analytics: Successfully integrated structured and unstructured data sources to create comprehensive dashboards, enabling advanced analytics and facilitating deeper insights into business performance.Collaboration with Business Analysts: Worked closely with business analysts and end-users to define and refine requirements for schema design and object deployment on BI platforms, ensuring alignment with business goals and user needs.Data Validation and Integrity Assurance: Conducted rigorous data validation across multiple phases of the BI Data Warehouse to guarantee the accuracy and integrity of data utilized for reporting and analysis.Development of Interactive Power BI Dashboards: Created engaging and interactive Microsoft Power BI dashboards, effectively visualizing key insights derived from data analysis and enhancing stakeholders' understanding of performance metrics.Project Management for BI and ETL Initiatives: Managed multiple Business Intelligence (BI) and Extract, Transform, Load (ETL) projects concurrently, ensuring smooth implementation, adherence to timelines, and delivery of high-quality outputs.Automation through Stored Procedures: Designed and optimized Stored Procedures, Packages, Views, and Triggers to automate post-process tasks, streamlining operations and improving data processing efficiency.

ETL Process Development: Designed and implemented an Extract, Transform, Load (ETL) process for the migration of the Individual Life Takaful System, ensuring seamless data transition and integrity throughout the migration.Data Integrity Checks: Conducted thorough data integrity checks to guarantee the reliability of data and prevent corruption, establishing a foundation for accurate reporting and analysis.Data Retention Testing: Performed data retention tests to verify compliance with storage requirements, ensuring adherence to regulatory standards and internal policies.Email Automation System: Established an automated email system for client servicing letters directed to customers, agents, and dedicated branches, reducing manual processing time by 23% and overall operational costs by 40%.MIS Report Design in SSRS: Designed and developed Management Information System (MIS) reports and letters in SQL Server Reporting Services (SSRS), tailored specifically to meet the needs of Persistency users and enhance decision-making capabilities.Migration to Power BI: Successfully migrated existing QlikView reports to Microsoft Power BI, improving data visualization and accessibility for stakeholders.Data Cleansing and Preparation: Executed comprehensive data cleansing and preparation processes to ensure high-quality, accurate datasets for Key Performance Indicator (KPI) dashboards.Interactive Persistency Dashboards: Architected and developed interactive Persistency Dashboards using Microsoft Power BI, enhancing data representation and facilitating deeper analysis of key metrics.Collaboration on Core System ISF: Collaborated with cross-functional teams to define the scope for the core system ISF development for the Enterprise Data Warehouse, ensuring alignment with organizational objectives.

Core Application Maintenance: Maintained the core eCorporate (ERP) application by troubleshooting issues, ensuring optimal performance and user satisfaction across the platform.Development of New Objects: Collaborated with clients to develop new application objects based on their specific requests, enhancing the functionality and usability of the ERP system.Forms and Reports Creation: Created and updated forms, reports, procedures, functions, and views to meet evolving client needs, ensuring a seamless user experience and efficient data management.