Mukta Sinha

I am a Senior Data Analyst with 5+ years of experience in Power BI, Basic Python, data transformation, and security. Skilled in DAX, Power Query, SQL, Advanced Excel, and Tableau for optimized reporting and actionable insights. Experienced in data quality management, governance, HR data analytics, and stakeholder collaboration. Exceptional analytical abilities and adept at simplifying complex data for non-technical audiences with strong communication and presentation skills.

Guidehouse | Senior Data Analyst August 2024 – March 2025

• Ensured data accuracy, consistency, and reliability throughout its lifecycle
• Monitored and validated HR people data to ensure accuracy, completeness, and consistency. Worked on data dictionaries, data lineage, metadata documentation.
• Identified and corrected data discrepancies, errors, and gaps in HR data sources
• Implemented data validation checks and controls to improve data quality
• Developed and deployed Power BI dashboards for actionable business insights
• Utilized Power Query, Snowflake and Basic Python for data transformation, cleansing, and advanced analytics
• Managed MIS functions, ensuring compliance and seamless operational reporting
• Developed dynamic reporting solutions using DAX expressions for calculations and custom visualizations
• Implemented Row-Level Security (RLS) to ensure data security and compliance
• Collaborated with HR team members and business partners to understand and identify business needs, make recommendations, and deliver data
• Analyzed HR data quality metrics and created regular reports to track progress and trends
• Conducted root cause analysis for data quality issues and developed solutions to prevent future inaccuracies and compliance issues.
• Produced reports and visualizations to communicate results and interpretations of trends to all levels of leadership and provided data governance report to them 
• Proactively managed requests and client expectations, resolving issues in a timely manner and escalating issues when needed

• Designed and deployed Power BI dashboards for real-time monitoring and reporting
• Collaborated with business teams to gather reporting requirements and translate them into technical solutions. Integrated multiple data sources, ensuring efficient data transformation and modeling using Power BI
• Conducted source data analysis and developed a data warehouse to streamline data flow and enhance reporting capabilities. Implemented advanced DAX calculations for dynamic grouping and reporting. Worked on the data governance reports
• Created reports in MySQL and Snowflake using views and stored procedures for efficient data querying and transformation for Popular Bank.

• Created SQL-based reports and dashboards using BIRT, Power BI, focusing on data accuracy and performance optimization for Hospet bank.
• Streamlined data retrieval processes, ensuring efficient and timely delivery of reports
• Maintained version control and tracked changes in scripts using Tortoise SVN

• Designed custom SQL-based reports and dashboards using Yardi Spreadsheet Reporting (YSR), columnar reports and SSRS for real estate projects.
• Developed T-SQL scripts for data conversions, stored procedures, and functions to enhance reporting for the property management software called Voyager.
• Utilized SSIS for ETL processes, ensuring seamless data integration and improving business processes.

• Developed backend programs and scripts for core banking using COBOL for NABARD Banks.
• Managed database operations using PL/SQL and SQL Developer
• Supported EOD/SOD processes. Collaborated with cross-functional teams using Jira
• Maintained code integrity with Tortoise SVN.

Education BTech in Computer Science Engineering Sikkim Manipal Institute of Technology | 2015 – 2019