Data Analyst I
CurrentPerform data analysis and visualization on live production data to detect geolocation data anomalies and anti-fraud purposes. Monitor application releases, configuration, and database changes. Present core findings and propose anti-fraud solutions with immediate impacts.Core accomplishment:- Developed numerous Python scripts integrated with Elasticsearch query leveraging automated data retrieval, analysis workflow, and streamlining reporting processes for reducing manual tasks in DA teams.- Developed PySpark script on Databricks for complex data transformations to support high-performance analytics and advanced fraud detection.- Built and maintained dashboards in Elasticsearch and Kibana to track key performance metrics, providing stakeholders with real-time insights. - Leveraged SQL within Databricks to perform complex queries and data analysis, enabling efficient data exploration and reporting. Designed and developed interactive dashboards in Databricks to visualize insights and track key metrics.- Conducted daily extensive investigations and monitoring of live production data for geolocation anomalies, device tampering risks, and product key performance metrics.- Produced immediate data-driven solutions for fraud risks and breaches. Formulated long-term preventative measures to combat spoofing attempts.- Performed comprehensive analysis of ad-hoc cases with Kibana, SQL, and Python to collect actionable insights and propose data-driven solutions for Customer Support, Release Deployment, and Internal Development teams.Tech Stack: Python, MySQL, XPath, Elasticsearch, Kibana, PySpark, Databricks, Excel, Google Sheets etc.