Rajita Ganti Email & Phone Number

Bengaluru, Ka, In

Bengaluru, Karnataka, India

• Oversee the design, development, and implementation of complex analytical solutions, ensuring accurate and insightful reporting to support informed decision-making.•Design comprehensive Business Intelligence (BI) solutions that align with organisational needs and relevant data sources for optimal performance.• Work closely with relevant teams to integrate BI solutions effectively, enhancing user experience and streamlining data flows for better accessibility.• Implement robust security measures to protect data privacy and establish appropriate access levels for different user groups, ensuring compliance with relevant standards and policies.• Maintain and optimise ETL flow design to ensure accurate data extraction, transformation, and loading, enhancing data quality and performance.• Design and implement data models that meet business requirements, enabling efficient data aggregation, transformation, and visualisation for enhanced decision-making.

Bengaluru, Karnataka, India

• Lead the design, development, and implementation of complex analytical solutions using Oracle Analytics Cloud, ensuring accurate and insightful reporting.• Integrate Salesforce data with Einstein Analytics to provide advanced insights, predictive analytics, and recommendations for sales and marketing strategies.• Design end-to-end BI solutions using Oracle Analytics Cloud, Tableau, and Einstein Analytics, aligning with business needs and data sources.• Collaborate with Salesforce administrators to seamlessly integrate BI solutions, enhancing user experience and streamlining data flows.• Implement robust security measures, ensuring data privacy and appropriate access levels for different user groups.• Design and implement robust data models that align with business requirements, enabling efficient data aggregation, transformation, and visualization.

Bengaluru, Karnataka, India

• Collaborate with teams to design and develop OBIEE reports, leveraging BIP and OTBI, to provide actionable insights that drive informed business decisions.• Design interactive and user-friendly dashboards tailored to stakeholders' needs, enabling real-time monitoring of key metrics.• Assist in data modeling activities, creating and maintaining logical and physical data models that ensure accurate and efficient reporting structures.• Translate complex data into clear, intuitive visualizations using OBIEE's powerful features, enhancing data-driven storytelling and understanding.• Develop and execute SQL scripts to validate data accuracy, troubleshoot inconsistencies, and ensure reliable data sources.• Contribute to the development and maintenance of data warehousing solutions, supporting the organization's analytical and reporting needs.

Hyderabad, Telangana

Designed an automated customer loyalty TIER Model, enhancing customerengagement by offering rewards based on their transactions and mileage.Engineered a standalone API for seamless voucher/reward redemption. Thisinnovation not only replaced the previous manual process but also doubledthe productivity of airline staff. This functionality is currently operational atairports across Canada.Constructed and managed over 50+ intricate reports, resulting in a 30%improvement in revenue estimation accuracy. Additionally, maintained andenhanced existing reports using BI Publisher.Developed system alerts for successful or unsuccessful completion ofscheduled jobs, offering administrators 100% visibility. This advancesignificantly improved efficiency in tracking, identifying missed tasks, andmanaging operations.Built and integrated Web Services into the Siebel File System for readingphysical vouchers/coupons. This functionality triggered the API forredemption and transitioned customers into the TIER system.Automated the marketing module, including setup for 7+ mega salecampaigns and email templates for marketing outreach. This was achievedusing Siebel Escript, Campaigns, and Promotions, with local testing of SOAPrequests to ensure optimal performance.

Hyderabad, Telangana, India

Installed OBIEE, Informatica, and BIP to optimize reporting processes,following native Middleware.Led requirements gathering, ETL specification writing, and design documentpreparation.Developed mappings and ETL procedures, streamlining data loading processesby eliminating cross-queries and increasing data transfer speed by 30%.Executed daily data publishing procedures using Informatica DAC and creatednew ETL procedures for data extraction and transformation.Enhanced data integrity by creating PL/SQL stored procedures for dataextraction and transformation, leading to a 30% reduction in data errors.Designed templates (RTF, Excel, Flash, EText, HTML) using XSLT code torender report templates in various formats for end-user ease.