Manjusha Appari Garg

Project : APAC KYN Project - Birds Eye Visualization for CTO

• To Collaborate with functional teams and built Power BI Reports for KYN Details of entire APAC Region
• Designed and implemented end to end business intelligence using Power BI
• Collaborate with stakeholders and understand the requirements and objectives of migrating reports from Tableau to PowerBI
• Developed and maintained Data models , reports and dashboards to provide business insights
• Developed Power BI Reports using different DAX queries, visuals, filters, and configuring Dashboards with drill down Capabilities
• Working knowledge on Power BI objects like Dashboards, Reports, Power Views, Creating Workspaces, Sharing dashboards, Row Level security Implementation.
• Knowledge on Power BI Data Modeling and Data Warehousing concepts like Star Schema, Snowflake Schema, Dimensions and Fact Tables.
• Worked with testing team to create test cases for unit, link, and system testing
• Good Analytical, Presentation, and Interpersonal Skills with proficiency in demonstration, and business requirements

Project - Visualization of Audit of Metro Golden Mayer Company, California

• Involved in migration exercise from Tableau to Power BI Created documentation to support users during the transition.
• Engaged in end to end planning and execution of the migration process the involves Assessment and Planning, Data Source compatibility, Data Transformation and Modeling, Rebuilding Reports and Dashboards, Migrate Calculated Fields and Formulas, Interactivity and Filters, Security and Sharing, Testing and Monitoring.
• Trained users on how to use Power BI effectively, especially if there are significant differences between Tableau and Power BI.
• Implemented several DAX functions for various fact calculations for effective data visualization in Power BI.
• Expertise in building Power BI using large data in direct query mode
• Support development of workflows, integrations, and applications using the Power Automate
• Utilised JIRA to maitain workflows and used Teradata and snowflake databases .

Project Escrow of Loan Reconciliation

• Understanding the requirements and prepared Technical Specification documents for all the reports.
• Created insights using tableau forecasting tools and other charts like scatter plots .
• Used complex indexes , parameters , logics using case statements.
• Refreshing tables using python .
• Tableau refresh of data extracts every week .
• ETL using Google Big query which is the backend for tableau workbook.
• Adhered to font and format as specific to wellsfargo based on leadership requirments .
• Thorough testing of all workbooks in order to ensure Data Integrity and Singularity .
• Created also interactive to specifc visualisations in power BI Desktop and also required DAX Queries .