Divya Jyoti

• Provided pre-sales technical guidance to assist in drafting proposals.
• Led the design and implementation of innovative cloud and data solutions for diverse industries, driving business growth and fostering data-driven decision-making processes.
• Advised clients on effective Azure cost optimization strategies, utilizing IBM Turbonomic for optimal resource allocation.
• Architected and implemented a robust Azure landing zone for STIB, ensuring a scalable and secure foundation for their cloud environment.
• Introduced a comprehensive 360-degree dashboard in Tableau, enabling real-time monitoring of jobs and schedules across the Data Tribe, enhancing operational efficiency.
• Conducted workshops with clients to understand their technical requirements, pain points, and strategic goals.
• Enforced adherence to design patterns and best practices among data teams during Data Warehouse development, guaranteeing consistency and optimized performance.
• Developed and maintained the long-term architecture vision for relevant solutions.
• Aligned solution architecture with domain and enterprise architecture.
• Established rules, principles, and guidelines for solution architecture development across diverse development teams.
• Ensured seamless integration of applications on relevant platforms within the entire landscape.
• Crafted a target architecture aligned with architectural principles, collaborating with solution architects of adjacent systems.
• Created a roadmap that outlines the staged realization of the target architecture over the coming years.
• Provided technical input to refine features and user stories for new or modified digital solutions within the Solutions Team.

• Led and managed the Azure Data Lake team, consisting primarily of vendors, in the successful extraction of MS Marketing's Events data to generate an Azure Synapse data warehouse, enabling robust reporting capabilities.
• Designed and implemented multiple data pipelines to efficiently populate data into Cosmos DB, ensuring data availability and accessibility for various business use cases.
• Implemented effective data masking techniques to ensure GDPR compliance and safeguard users' personal data, prioritizing data privacy and security.

• Provided oversight and leadership to an offshore development team, ensuring the successful delivery of project objectives and adherence to established processes.
• Collaborated closely with business stakeholders to gather requirements and translate them into Agile-based user stories, maintaining accurate documentation in JIRA to facilitate effective project management.
• Architected and designed the business intelligence (BI) solution for the project, leveraging best practices and industry standards to deliver a scalable and efficient system.
• Prepared project estimates and conducted thorough capacity planning, ensuring adequate resource allocation for timely project execution.
• Delivered impactful proof-of-concepts (PoCs) to clients, demonstrating the real-time reporting capabilities of OBIEE, Tableau, and QlikView, showcasing the potential value of the proposed solutions.

• Provided leadership to the Backoffice team, fostering effective coordination among geographically and functionally dispersed team members and clients.
• Resolved production issues in PL/SQL objects and Informatica mapping within the back office and data warehousing, achieving impressive turnaround times.

• Analysed and comprehended the Regulatory Reports, providing insights on reporting feasibility to meet the required requirements.
• Prepared various documentation for the Basel Solution, including an Installer guide (User's Guide), best practices for RPD and Answers, Technical Design Document, and Test cases for Reports and Metadata of Repository.
• Ensured the development team delivered the product within the designated timelines.
• Designed the RPD for the Basel Solution, enabling the creation of Dashboards/Reports and ad-hoc Reporting using multiple data sources, such as OLAP and RDBMS, specifically tailored to risk reporting in Oracle Financials' Basel Solution.
• Extensively worked on Answers/Dashboards in OBIEE to address complex requirements and provided workarounds for specific reports (such as write back, aggregate awareness, and lookup tables).
• Collaborated closely with the BA team and data modelling team during the analysis phase, identifying functional understanding gaps and assessing the feasibility of report requirements within the existing model.

• Developed PL/SQL code for Geo-boundary creation and updating in the Sales Account View, enabling smooth data extraction across different geographies.
• Enhanced database performance by proposing and implementing multiple projects to modernize the client's outdated database model and optimize Informatica mappings (procedures on the database).
• Participated in requirement gathering, data verification, transformation (mapping), and testing activities using Informatica.
• Utilized Informatica Data Quality and Informatica Data Explorer to cleanse the data effectively.