Meghana Mungara

Description: Our project goal is to gather data from various sources, dump it into a data warehouse whenever the necessary conditions are met, then create dashboards in PowerBI Desktop and share them with the Azure cloud using Data Management Gateway.

Responsibilities:

• Collaborated closely with clients to perform thorough Data Analysis, data validation, error handling mechanisms, and data clean-up within vast datasets.
• Worked Power BI, Power Pivot to develop data analysis prototype, and Power View and Power Map to visualize reports.
• Worked on operational, analytical dashboards and data visualization reports using Power BI.
• Used Microsoft Power BI Power Query to extract data from external sources and modify data to by calculated columns as required in Excel.
• Designed SSIS Packages in SQL Server to handle data migration (ETL Processes) from transaction System to Dimensional Model.
• Worked on Tableau and Power BI to create visualization reports from both relational and multi-dimensional data as source.
• Created complex ETL solutions using proper Control and Data Flow elements with error handling along with scheduling and deploying SSIS Packages.❖ Used SSRS reports are used for creating Dashboards, drilldown reports, Scorecards. Created various Excelreports using drop downs and v-lookups connected to the SQL server.
• Provide analytics and decision support to stakeholdersacross the organization. Partner closely with internal stakeholders to dive deep into the data to provide actionable insight.
• Enhanced Data Warehouse Architecture and Design - Star Schema or Snowflake Schema, FACT and Dimensional Tables, Physical/Logical Data Modelingand data flow diagrams.
• Design, Develop, test, and deploy ELT/ETL pipelines using Azure Data Factory. Worked on Web jobs, AZURE data factory, Logic Apps for application and project development in Azure.
• Worked with DAX queries to modify data and add new columns and measures. Work with various transformations in the Power BI query editor.
• Developed interactive dashboards and storyboards in Tableau to explore credit portfolios data and report insight to the manager.
• Designed and built several dashboards involving KPIsand trend charts comparing cumulative vs actual values to depict the client’s overall business needs.❖ Worked on Azure cloud in spinning of new resources under resource group. Worked on Azure Data factory to load the data from on premise to Azure Data Lake.
• Used a variety of tools for development and documentation, such as Confluence for all project- related documents, JIRA for daily development chores, and QC for defect management.
• Worked on Agile process with backlogs and story points who participate in daily scrum meetings

Environment: Power BI, Power Pivot, Power View, Power Map, Power Query, Excel, ETL, SSIS, SQL, Tableau, SSRS, Star Snowflake, ELT, Azure Data Factory, Git, Github, Spark, Pyspark, DAX, KPI, Azure Cloud, Azure Data Lake, Jira, Confluence, Agile, Scrum.

Description: In this project it is the capacity to comprehend customer behavior and the variables that influence it. Used predictive analytics to examine how your most profitable clients connect with one another. Used focused strategies to improve customer response, retention, and profitable growth.

Responsibilities:

• In-depth knowledge of Software Development Life cycle, having a thorough understanding of various phases.
• Worked on Power BI Visualizations and Dashboards as per the requirements.
• Developed to manage BI environment which includes Business model, Data Model, Data sources, ETL tools, target data warehouse, Data marts, OLAP analysisand Reporting tools.
• Designed and developed Power BI graphical and visualization solutions with business requirement documents and plans for creating interactive dashboards.
• Developed on Data Modeling used to define and analyze data requirements needed to support the business processes within the scope of corresponding information systems in organizations
• Used ETL tool SSIS to extract data from both external and internal sources including csv, json, excel and load data into database.
• Worked on Scripted advanced SQL queries in PostgreSQL for Redshift and MySQL leveraging Common Table Expressions, sub-queries, correlated sub-queries, window functions and complex join logic to apply business rules.
• Worked on various reports using reporting tools like Tableau and MS excel to forecast the growth of various KPI.
• Restricted access to users by creating security roles to access reports in Power BI using row level security.
• Optimized the query performance with modification in T-SQL queries, removing unnecessary columns, eliminating redundant and inconsistent data.
• Primarily involved in Data Migration using SQL, SQL Azure, Azure storage, and Azure Data Factory, SSIS, PowerShell
• Extensively worked on OLAP cubes using SSAS and Created and Managed OLAP Cubes using SSAS.
• Utilized multi-dimensional models like Star Schemasand Snow Flake Schemas for generating Cubes in the design and development of Data Warehouses, Data Marts, and Business Intelligence.
• Used Jira, epics, user stories, and tasks were created for each requirement in accordance with the sprint planning.
• Following Agile (Scrum) Methodology for developing application development.
• Linux and UNIX platform experience; work has been done to resolve the problems and build the code.

Environment: Power BI, OLAP, Power BI, Data Modelling, ETL, SSIS, SQL, Postgre SQL, MySQL, Tableau, Excel, RLS, T SQL, SQL Azure, Azure Data Factory, SSIS, Power Shell, Python, Pyspark, SSAS, Star Schemas, Snowflake, Python, Jira, Agile, Scrum, Linux, Unix.