Data Analyst Power Bi

HIRAN MAYI NATHI

**************@*****.*** +1-859-***-**** Github

SUMMARY:

Data Analyst and SQL Developer with a strong background in PL/SQL development, data modeling, solution design, and business analysis. Skilled in writing complex queries, building well-tested database solutions, and collaborating across technical and business teams to support end-to-end delivery of data-driven systems. Adept in Agile environments with a strong track record of refining requirements, testing interfaces, and contributing to architecture discussions.

KEY SKILLS:

Data Analytics & Visualization: Power BI (DAX, M, Power Query, RLS, Bookmarks, KPI visuals, Data Gateways), Tableau, Python (Matplotlib, Seaborn), Databricks, Azure Synapse Analytics, SQL Server Reporting Services (SSRS)

Programming & Data Engineering: Python, Scala, Java, SQL, Spark, Hadoop

Database Management & Querying: Advanced SQL, MS SQL Server, MySQL, Mongo DB, T-SQL, PL/SQL, Azure SQL Database, Databricks SQL

Big Data & Cloud Technologies: Azure (SQL Data Warehouse, Azure Blob Storage, Azure Databricks), Hadoop, Kafka, Databricks

Scripting & Automation: SQL, Python (NumPy, Pandas), UNIX Shell scripting, Unit Testing for Data Scripts

Data Warehousing & Modeling: Dimensional Modeling, Data Marts, EDA, Hypothesis Testing, Regression, Clustering, Dimensional Modeling

Analytical & Statistical Skills: Data Cleaning, data transformation, statistical analysis, machine learning (Scikit-learn), SSAS, Excel (Pivot, Lookups),

Reporting & Dashboarding: Power BI, Tableau, Custom SQL Reports, Advanced Dashboards

Statistical & ML Techniques: Data Validation, Forecasting, Predictive Modeling, Feature Engineering

Soft Skills: Analytical Thinking, Cross-functional engagement, Independent problem-solving, stakeholder reporting

PROFESSIONAL EXPERIENCE:

Data Analyst Fifth Third Bank March 2024 – Present

Designed robust PL/SQL stored procedures and queries to support financial and onboarding systems used by operations and credit teams.

Partnered with business analysts to define and refine user stories, ensuring technical feasibility and clear interface requirements.

Created and executed test scenarios to validate data logic and interface integrity across multiple downstream systems.

Participated in backlog refinement and estimation sessions; contributed to sprint planning and helped shape delivery timelines.

Worked with stakeholders across KYC, Finance, and IT to develop documentation and validate business rules.

Built Excel-based reporting tools to support data validation and financial reconciliations.

Data Analyst Axzora Private Limited May 2021 - Dec 2022

Wrote complex SQL scripts and stored procedures to support business logic for onboarding, credit scoring, and client profiling.

Led effort to troubleshoot and optimize underperforming queries, improving response times by over 40%.

Built reusable PL/SQL components and validated them through structured testing scenarios.

Participated in technical design discussions, spike solutions, and PoC efforts to reduce implementation risks.

Interfaced with QA teams to support automated and manual testing cycles.

Regularly collaborated with business users to deliver quick-turnaround insights via Excel and query tools.

Data Analyst WinWire Technologies March 2019 – April 2021

Supported data quality efforts for onboarding and compliance projects by writing validation queries and reconciling datasets across systems.

Maintained PL/SQL functions and packages for transformation logic in client-related data workflows.

Conducted impact analysis and contributed to data mapping documentation for new onboarding fields.

Coordinated with project leads to support sprint delivery, report blockers, and adjust timelines based on backlog reprioritization.

PROJECTS:

Hotel Data Analysis Report:

Integrated and analyzed 5+ simulated hotel data sources in Power BI, identifying trends in booking patterns and room utilization to demonstrate how data-driven strategies could potentially increase occupancy by 12%.

Developed a theoretical dynamic pricing model based on seasonal demand analysis, showing how RevPAR could be optimized by up to 18% during low-occupancy periods.

Automated KPI tracking in Power BI to showcase how replacing manual Excel processes could reduce reporting time by 70% in a real-world hospitality setting.

Smart Basket:

Developed an end-to-end demand forecasting machine learning pipeline for Indian grocery data, using linear regression, feature engineering (discount %, brand/category encoding), and K-Fold cross-validation to improve model accuracy.

Conducted detailed exploratory data analysis (EDA) and created insightful visualizations of product pricing and discount patterns.

Modern Data Warehouse:

Implemented Medallion Architecture (Bronze–Gold) in SQL Server, ingesting ERP & CRM data, transforming via SQL ETL, and delivering star-schema insights for sales and customer trends.

EDUCATION:

University of Cincinnati, Cincinnati, Ohio

Master of Science in Information Technology

Malla Reddy College of Engineering, Telangana, India

Bachelor of Technology in Computer Science and Engineering

Contact this candidate