Mounika M

Sr Data Analyst Power Bi Developer @Citi

NY, US

Prepared comprehensive functional and technical documentation for data provisioning pipelines including source-to-target mappings, transformation rules, and data flow diagrams.• Developed and maintained data environment diagrams to ensure clarity of upstream and downstream dependencies.• Partnered with business stakeholders in retail banking and finance domains to translate requirements into data models and reporting solutions.• Conducted financial data analysis on revenue, expenses, and cost trends to identify business opportunities.• Wrote advanced SQL scripts for data extraction, transformation, and aggregation across multiple systems.• Designed, developed, and published Power BI and Tableau dashboards to provide real-time insights into key financial metrics.• Built Excel-based models and dashboards with pivot tables, macros, and VLOOKUP to support quick decision-making.• Conducted ad-hoc data analysis and deep dives to investigate anomalies in financial reports and provide corrective actions.• Applied statistical techniques such as regression and variance analysis to support forecasting and risk assessment.• Created and maintained data dictionaries and metadata repositories to improve data governance and lineage tracking.• Implemented data quality rules and profiling to detect duplicates, outliers, and inconsistencies in financial datasets.• Automated recurring reports and ETL processes using SQL, Python, and Excel macros, reducing manual effort.• Designed reporting templates and reusable frameworks to streamline BI report development.• Provided knowledge transfer sessions and training to business users on navigating Power BI and Tableau dashboards.• Recommended and implemented process improvements and automation opportunities in financial reporting workflows.• Partnered with database administrators to implement security, access controls, and performance monitoring.

Chalapathi Institute of Engineering & Technology, Lam

Bachelor's degree

Lamar University

Master's degree