Power Bi Data Analytics

RASIKA SANJAY VANAGUTTE

*********.**********@*****.*** 248-***-**** Detroit, MI, USA LinkedIn Git_profile SUMMARY

• Graduate student pursuing a MS in Information Technology Management (Data Analytics) with 4 years in IT Banking industry.

• Motivated, team-oriented professional applying quantitative technical expertise to data applications.

• Eager to contribute for Full Time position with a robust analytical skill and can-do approach. CORE SKILLS

• Data Science: MS Power BI, MS Power Apps, Tableau Desktop & Server, QlikView, Qlik Sense, RDBMS

• Database Management ETL tools: MS SQL Server, Oracle 11G & 12, VBA, Ab Initio, Tableau, MS Access, SSRS, SSAS, SSIS, Snowflake, AWS cloud, Confluence JIRA, Anaconda

• Programming: SQL, Python, Hadoop, Hive, Linux Bash, Unix-shell scripting, Matlab

• Big Data Analytics: Excel (Pivot Tables, VLOOKUP, Graphs, Queries, Advanced Formulas, Data Validation, Conditional Formatting), DAX

• Statistical Methods SAS: Predictive/Quantitative Analysis, Regression Techniques (Linear/Logistic), Classification Techniques

(R-square, AUC, VIF, CART, Neural Network)

PROFESSIONAL EXPERIENCE

Enspired Solutions, MI, USA

Data System Support Intern May 2024 - August 2024

• Integrated MS Power apps and Power BI to streamline data processing, focusing on performance tuning for faster decision- making reducing financial analysis time by 98%.

• Designed Power BI pipelines, reports and dashboards using Tableau for automated dashboard refreshes and financial insights.

• Collaborated extensively with cross-functional teams to understand operations, identify key metrics (KMIs) for operation.

• Engaged with Oracle SQL for database management and querying, supporting iterative software development practices. Capgemini Technology Services, India

Associate Consultant Analyst June 2022 - July 2023

• Monitored production environments, handling millions of customer data updates and real-time test cases.

• Utilized cloud-based data sources in Tableau, including SQL Database, to facilitate seamless data analysis and visualization automizing manual tasks by 60% enhancing database accuracy.

• Played leading roles for live ad-hoc P1/P2 enterprise releases incidents impacting real-time customer data and banking transactions using Ab Initio, Python, SQL logs.

• Developed a Tableau dashboard to track project timelines and budgets, reducing project overruns by 15%.

• Actively mentored junior analysts and cross-trained team members in advanced Tableau techniques to improve team skills. Senior Software Analyst April 2021 - June 2022

• Designed test cases and optimized data extraction using Ab Initio and Tableau, improving efficiency and boosting client satisfaction by 70% for Barclays and Nordea Bank.

• Implemented AWS cloud solutions to dynamically scale reporting capabilities, enhancing system performance and reliability.

• Set up AWS as a backend for Tableau to handle high-volume data, reducing query processing time by 50%. Software Analyst March 2020 – April 2021

• Processed raw data by removing duplicates, correcting errors, and writing SQL queries for trend analysis, while enhancing error logging with Python to reduce ETL failure rates by 15% and improving system reliability.

• Applied AWS Lambda for backend data processing, reducing data extraction times by 40%. CERTIFICATIONS

• Oracle Database SQL Certified Associate. ● Tier 2 Academic Specialization in SAS Analytics

• Snowflake Hands on Essentials: Data Sharing ● Snowflake Hands on Essentials: Database Warehouse.

• Database Management Essentials. ● Cybersecurity Compliance Framework & System Administration. EDUCATION

• Masters in Information Technology Management Oakland University, USA Expected May 2025 GPA: 3.53/4

• Bachelor in Electronics and Telecommunication Pune University, India April 2019 GPA: 3/4

Contact this candidate