Narendra Malkapuram

Participated in requirements meetings and Scrum Calls to understand the Report Requirements. Used Power Query / Query Editor for Data transformation as per the reporting needs. Created Data Model in Power Pivot by Establishing the Relationship Between the tables. Created New Columns and New Measures over data models for the purpose of enhancing Power BI visuals using DAX. Developed at least two - three visual options for each report for discussion with stakeholders and customers. Integrated Custom Visuals based on business requirements using Power BI desktop. Created Hierarchies and Drilldown Reports. Created Microsoft Power BI Dashboards in Power BI Service using Reports. Installed and Configured Data Gateways to Refresh and Schedule Refresh the Dataset. Managed access of Reports, Dashboards and Data for individual users using roles. Implemented Row Level Security as part of Security. Provided continued maintenance and development of bug fixes for the existing and new Power BI Reports. Responsible for defining the scope of the project, gathering business requirements, doing analysis and documents. Importing the data from data sources and preparing the data in Power Query as per user requirement. Building the relationships between the various Tables in Power Pivot. Created New Columns, New Measures using DAX functions. Created different filters like visual level filters and page level filters and report level filters as per reporting needs. Expertise in various visualizations like donut chart, Pie chart and Bar graph, Tree map and water fall charts and Card Visualizations. Designed diverse types of reports like drill down, drill through, and Sync Slicer. Developed custom report tool tips for different reports to showcase the multiple data points in one report. Created various Customized and interactive Reports and Dashboards in Power BI. Publishing reports to Power BI service and providing the access to required users.

Acting as Business Analyst for system enhancements and coordinating, executing testing. Responsible for developing and delivering complex financial reports both internally and to our clients. Supporting the client in the procurement/analysis of relevant data. Transforming the medicaid statistical information system business analyst with a focus on testing to enhance state anti-fraud, waste, and abuse capabilities with enrollment, eligibility, and expenditure data. Preparing and supplying the state audit reports to the medicaid fiscal intermediary for use in cost to reimbursement comparisons and the calculation of final medicaid cost settlements. Responsible for the monthly preparation with budget analysis.

Responsible for analyzing data generated from the database and creating insightful reports/dashboards for senior management. Responsible for aligning BI and reporting programs with business requirements for the project. Managing data management standards and procedures, handling the various aspects of Athena data warehouse such as architectures, data sourcing, migrations, quality, design, and implementation to generate analytic reports. Coordinating and rolling out the project and resource allocation by using project management methodologies (agile). Leading several organization projects, analyze, design, and implement processes, documentation, and user training.

Responsible for analyzing data generated from the database and creating insightful reports/dashboards for senior management. Responsible for aligning BI and reporting programs with business requirements for the project. Managing data management standards and procedures, handling the various aspects of Athena data warehouse such as architectures, data sourcing, migrations, quality, design, and implementation to generate analytic reports. Coordinating and rolling out the project and resource allocation by using project management methodologies (agile). Leading several organization projects, analyze, design, and implement processes, documentation.