Rishika Sharma Email & Phone Number

Docklands, Victoria, Australia

• Developed a Power BI dashboard for Saras care, integrating data from various sources on donations, donor profiles, and engagement metrics. Used Power Query (M) for data transformation and DAX for creating calculated measures and metrics. Addressed challenges in ensuring accurate data integration and real-time refresh capabilities.• Transformed and modelled the data using Power Query and Power Pivot. Created relationships and data models to consolidate information for effective analysis. Addressed issues with data consistency and accuracy.• Implemented real-time data refresh capabilities in the dashboard. Configured scheduled data refreshes and used Direct Query mode to ensure up-to-date information is always available.• Analysed donation data, revealing $150,000 in total donations with a 15% growth from the previous quarter. Identified 60% of donations from corporate contributors and 40% from individual donors.• Increased recurring donations to $45,000 (30% of total donations) and improved donor retention. Achieved a 10% enhancement in the conversion rate of single donors to recurring donors.• Enhanced Donor Lifetime Value (DLV) from $450 to $500 and optimized corporate contributions. Insights led to a 15% overall growth in donations and better-informed strategies for future campaigns.

Mumbai, Maharashtra, India

• Conducted end-to-end delivery of the "Buy Now, Pay Later" (BNPL) solution for major e-commerce platforms like Amazon and Flipkart, managing a team of 25 to design, develop, and implement the system.• Collaborated with business and technical teams to design procedures for seamless integration with the Loan Management System (LMS). Addressed challenges in ensuring secure, real-time data transfer between IDFC's LMS and partner platforms.• Produced Python APIs for secure communication between IDFC's LMS and partner platforms. Utilized Flask for creating RESTful APIs, Requests for handling HTTP requests, and SQL Alchemy for database interaction. JSON was used to parse and format data exchanged between systems.• Handled large volumes of transaction data securely and efficiently. Addressed issues related to data consistency and real-time syncing of BNPL transactions by optimizing the APIs for performance and accuracy.• Tailored the BNPL feature for festive seasons, such as Diwali and Christmas, leading to over ₹200 crore in deferred payments during the first month of launch.• Designed and devised an interactive Power BI dashboard to track BNPL metrics.• Utilized Power BI Forecast functionality to analyse sales trends, identifying a 25% growth in Diwali sales (from ₹150 crore to ₹187.5 crore). Sales forecasting insights led to an extended promotion week, generating an additional ₹50 crore in revenue.• The BNPL solution boosted the average transaction size by 18%, while insights from the Power BI analysis contributed to a 6% rise in profit margins during the campaign.

Delhi, India

• Established and Deployed procedures in Finnone’s Loan Management System (LMS), facilitating seamless data transfer between Finnone and the company’s website for over 7 million loan accounts.• Configured the data model for Finnone LMS, optimizing the digital lending process.• Automated extraction of text, handwriting, and data from over 15,0000 scanned loan documents monthly using AWS Textract.• Enhanced data entry accuracy by 40% through automated document processing. Reduced manual data processing time by 60% with AWS Tex tract automation.• Constructed a Power BI dashboard to track the Digital Lending Lifecycle, covering loan origination, processing, financing, and repayment.• Monitored and processed over 500,0000 loan applications annually.• Heightened funded application rate to 75%, up from 65% prior to dashboard implementation.• Decreased application decline rate by 15% through targeted insights and interventions.• Minimized fraud incidents by 25% and provided performance analytics to over 200 dealers, boosting dealer satisfaction by 30%.

Noida Area, India

• Assisted senior SQL developers in designing, implementing, and optimizing database queries to support the healthcare management system.• Participated in data extraction, transformation, and loading (ETL) processes to migrate patient and healthcare provider data between different systems.• Built and maintained stored procedures, views, and triggers to streamline data retrieval for reporting and analysis.• Collaborated with the IT team to troubleshoot database performance issues, identify bottlenecks, and improve query efficiency.

Master'S Degree, Information Technology, 4.7/5.0 Gpa

Achievement: - Dean’s Honour Award 2024 – Achieved a GPA of 4.7/5 in the Master's of Information Technology and Systems program.

Bachelor Of Technology - Btech, Computer Science, 8.78/10.0 Cgpa

12Th, Distinction

10Th, 9.4 Cgpa