Savinay S

Data Analyst

MoneyTree Realty Services • Full-time

Jul 2024 - Present • 2 yrs 2 mos

Oversee CRM systems like Salesforce and Microsoft Dynamics, ensuring data accuracy and workflow customization.  Develop MIS reports and dashboards using Excel, Power BI, and SQL to support business decision-making.  Collaborate with cross-functional teams to translate business requirements into technical solutions.  Implement data automation processes to enhance operational efficiency.  Maintain data integrity and security, ensuring compliance with organizational policies.  My primary responsibility is to track and update payments made by the company’s clients to the builders. I collect confirmation from the builder’s side regarding received payments and maintain detailed records showing how much has been paid for each individual client.  I regularly coordinate with the company’s Team Leaders to get daily updates on their bookings. I follow up with them regarding payment timelines and the expected closure dates of each case.  I prepare and maintain all related reports and presentations based on my work. This includes organizing data, preparing visual presentations, and clearly explaining the entire process and updates in a structured format.  I also support finance-related activities at the management level. I create presentations for financial reviews and R&R meetings, and I handle all reporting and presentation-related tasks from the finance side.  Additionally, I create visually engaging presentations using Canva, including 3D presentation designs and video creation/editing whenever required as part of my role.

Fraud Analyst

Paytm Payments Bank • Full-time

Jun 2023 - Jul 2024 • 1 yr 1 mo

 Utilized advanced Excel functions (VLOOKUP, PivotTables, INDEX-MATCH) and SQL queries to analyze large-scale transaction data for potential fraudulent activities.  Investigated suspicious financial transactions reported through the NCRP portal, identifying behavioral fraud patterns and flagging high-risk accounts.  Developed and optimized SQL-based fraud detection models, improving accuracy in identifying repeat fraud offenders.  Generated comprehensive fraud analysis reports using SQL-based BI tools and interactive Excel dashboards, aiding internal audit and compliance teams.  Managed the Police Vertical and acted as the primary handler for fraud cases reported by law enforcement agencies across India via the MHA portal.  Served as the Single Point of Contact (SPOC) for coordination with PAN-India police departments, ensuring timely case resolutions and legal support.  Responded to live law enforcement requests by providing timely transaction details, KYC documentation, and internal investigation findings.  Facilitated regular coordination with Cyber Crime Units, SP offices, and CBI/ED, supporting the resolution of high-value and sensitive fraud cases.  Ensured strict compliance with RBI guidelines, internal SOPs, and MHA protocols while dealing with financial fraud cases.  Created and maintained a structured tracker of all law enforcement interactions, case statuses, and internal escalations for regular reporting to senior management.  Supported internal risk, legal, and compliance teams by providing fraud intelligence for enhanced due diligence (EDD) cases and customer verification.  Contributed to training modules and SOP documentation for internal teams to handle NCRP cases and law enforcement coordination efficiently.

MIS

DigiTech BPO • Full-time

May 2022 - Jun 2023 • 1 yr 1 mo

 Generated and presented comprehensive Monthly and Quarterly reports using Excel, Power BI, and SQL to support strategic business decisions.  Designed and maintained dynamic dashboards and live data sheets for real-time performance monitoring.  Created custom SQL queries to extract, transform, and analyze data across various sources.  Built interactive Power BI dashboards to visualize KPIs and uncover actionable insights.  Expert in advanced Excel functions such as VLOOKUP, HLOOKUP, SUMIF, COUNT, DSUM, PivotTables, Conditional Formatting, and Macros.  Streamlined reporting processes, reducing manual effort and increasing data accuracy and delivery speed.  Managed the Management Information System (MIS) with a focus on data reliability, security, and system performance.  Conducted regular data audits to ensure integrity and resolve discrepancies across systems.  Administered user access controls and enforced security policies to safeguard confidential data.  Delivered Excel and Power BI training sessions to internal teams, improving overall data literacy.  Used MS PowerPoint to create engaging and informative presentations for senior leadership.  Maintained clear documentation using MS Word for data procedures, reports, and SOPs.  Leveraged CRM tools for efficient data management, analysis, and custom reporting.  Collaborated cross-functionally with departments to gather reporting requirements and translate them into functional dashboards.  Recognized for consistently delivering accurate, timely, and actionable insights that support executive decision-making.