Biswabhusan Moharana

Dynamic Senior Analyst with extensive experience at Mphasis Ltd, adept at optimizing ETL processes and leveraging SQL for impactful data analysis. Proven ability to translate complex data into actionable insights, showcasing strong problem-solving and collaboration skills. Passionate about driving data-driven decisions and enhancing business outcomes through innovative analytics solutions.

• Technologies: MS Excel, Power BI, DAX, Report Builder, SQL Server

Roles and Responsibilities

• Skilled in data modeling techniques to support strategic planning and operational improvements, recognized for identifying trends, performing statistical analysis, and generating actionable insights
• Experienced in coordinating with stakeholders to gather business requirements, and translate them into effective analytical solutions
• Seasoned Power BI practitioner with a strong track record of developing intuitive, dynamic dashboards that convert complex datasets into clear, actionable insights
• Proficient in Power BI features such as DAX calculations, custom visuals, and advanced data modeling to enhance dashboard functionality and user experience
• Generated actionable insights from statistical analysis to optimize performance, improve processes, and enhance operational efficiency
• Proven ability to lead data projects end-to-end, ensuring delivery aligns with organizational goals, and meets deadlines

Technologies: Proficient in MS Excel, Power BI, DAX, Report Builder, and SQL Server for data analysis, reporting, and dashboard development

Roles and Responsibilities

• Worked in the production domain, specializing in data analysis using Excel and production datalogs from Splunk, focusing on system uptime, resolving business requirements, and process optimization
• Collected and analyzed data to evaluate the impact of service downtimes, including customer impact, transaction volumes, and alert frequencies
• Developed monitoring systems to track key business metrics across multiple operational levels
• Proficient in MS SQL, with expertise in writing complex queries for data retrieval, manipulation, and analysis to improve database performance and efficiency
• Created and presented insights to management using Power BI, leveraging visualizations to highlight trends, and support strategic decisions around service improvements and downtime risk mitigation
• Experienced in using cloud services for data querying and manipulation, with a strong understanding of cloud-based data workflows to support data-driven decisions, and operational efficiency

Technologies: Proficient in MS Excel, Power BI, DAX, Report Builder, and SQL Server for data analysis, reporting, and dashboard development

Roles and Responsibilities

• Analyze source and target systems to define data migration requirements and strategies
• Design and develop ETL processes to extract, transform, and load data between systems
• Collaborate with stakeholders to gather business and technical requirements
• Perform data mapping, and ensure accurate translation from source to destination
• Conduct data validation and reconciliation to ensure data accuracy, completeness, and integrity
• Identify and resolve data quality issues, discrepancies, and transformation errors
• Document data migration plans, processes, and testing results
• Work with cross-functional teams (IT, business, and vendors) to ensure smooth migration execution
• Use tools like SQL, SSIS, Python, Power BI, or cloud platforms (Azure, AWS) to perform migration tasks
• Ensure compliance with data governance, security, and privacy policies throughout the migration process