Mounika Rangineni Email and Phone Number

• Create and present executive level demos using Microsoft Power Point for Strategy Working Committee (SWC)• Developed and implemented PPM dashboards in Power BI, utilizing Project for the Web as the primary data source.• Leveraged Power Apps to create custom applications, enabling users to write back data to data sources directly from Power BI dashboards.• Integrated Power Automate to schedule and trigger data refreshes for Power BI reports, ensuring up-to-date insights for stakeholders.• Configured and administered Microsoft Teams for collaborative reporting and dashboard sharing, enhancing team productivity.• Involved in back-end configuration and optimization of data models, ensuring efficient data retrieval and processing for Power BI reports.• Migrated complex QlikView reports to Power BI, creating interactive dashboards that aligned with business objectives.• Utilized ALM Toolkit for merging multiple Power BI files and implemented Page Level Security based on user roles.• Deployed and managed Power BI solutions on Power BI Report Server, ensuring secure and on-premises access to critical data and reports• Utilized Power BI Service to publish, share, and distribute reports and dashboards to stakeholders, enabling seamless access to insights from any device or location• Utilized Power BI Pro to collaborate with team members, share reports, and enable seamless collaboration in real-time for enhanced decision-making• Utilized Power Apps to Write back data to the data source via Power app visualization in Power BI desktop• Responsible for Scheduling jobs for Weekly, Daily data refresh on different Power BI reports using Power Automate flows via Schedule and Trigger• Utilized DAX Studio and Performance Analyzer to troubleshoot and optimize the reports for faster performance and better rendering time.

• Migrated SAP BusinessObjects reports to Power BI.• Translated business needs into robust Power BI and Power Automate solutions, enhancing reporting efficiency.• Developed and deployed multiple Power BI dashboards, incorporating data from SQL Server, Excel, and Snowflake.• Created complex DAX measures and calculated columns to support advanced data analysis techniques in Power BI.• Written calculated columns, DAX, MDX, Measures query’s in Power BI desktop to show good data analysis techniques.• Handled One-One, Many-One, One-Many and Many-Many Relationships in Power BI Relationship Models.• Designed Power BI data visualization utilizing cross tabs, maps, scatter plots, pie, bar and density charts.• Created and developed Dynamic and Static Row-Level-Security in Power BI Desktop according to the roles assigned to the users.• Designed and developed analytics reports using SQL approach over a very large data sets, leveraging On-Prem data• Understanding the functional elements, business requirements and Conversion of the old data to the new format using Power Query.• Developed multiple Power BI Dashboards/Reports. Created Datasets using different data sources like Microsoft SQL Server, Excel, and Snowflake.• Created stored procedures and SQL queries to pull data into Power BI Desktop using Parameters• Utilized Power Automate for process automation, including scheduling data refreshes and managing workflow triggers.• Created complex data transformations and calculations using QlikView's data modeling and scripting capabilities.• Worked with Databases such as MS SQL Server, MySQL, and MS Access.• Created and Managed Parameters in Power Query Editor to work with targeted data.• Used Power BI Gateways to keep the dashboards and reports up to date.• Experience in developing several Details, Summary reports including line and pie charts, trend analysis reports and sub-reports per business requirements.

The objective of this project is to optimize supply chain operations which mainly involve co-ordination and planning across different parties both internal (Factory, Sales, SCM, Finance) and external (Customer Genpos,Vessel Liners).* Developed ETL processes using SSIS for data process, transformation and data ingestions from variousupstream systems. Worked on data profiling and data reconciliation reporting* Led the brainstorming sessions, collaborated with Technical Architects, DBA, Applicationdevelopment teams to arrive at the best Design and Interface approach* Analyzed source data and Implemented SSIS package to extract, transform and Load (ETL) data operations from multiple heterogeneous systems to SQL Server* Created staging tables for temporary processing of data, consolidating data and Loading database using Integration services. Created indexes on selective columns to speed up queries and analyses in SQL Server Management Studio* Extensively used Tasks like for Loop Container, For Each Loop Container, Sequence Container, Lookup,Merge Join, Sort, Derived column, FTP, Execute SQL, Data Conversion, conditional Split and Aggregate* Good experience in working with higher environments like SIT, UAT and Production. Also experienced increating DDL scripts like CREATE TABLE, ALTER TABLE, and DROP TABLE for Databases* Worked on testing and maintenance of the Deployed Packages. Involved in the creation and deploymentof the reports using SSRS* Coordinated with Onsite / Offshore teams to ensure execution of project as per scheduled plan* Worked with business analysts in preparing the interface definition document for projects andmaintaining the enterprise data model / dictionary* Involved in debugging the issues and providing the solution on time which reduces the impact on business operations. Co-ordinated with platform Ops team to fix the issues in case if any during the deployment and post deployment

* Built reports using Pentaho Reporting tool for ERP Solution “Advantage”* Involved in platform setup and initial setup by creating and altering various defined table structures,views, and packages. Involved in solving data discrepancies between the source and target systemsAnalyzed functional requirements, designed, and developed report prototypes and followed thestandards* Involved in creation and deployment of reports using SSRS and configuring the SQL Server ReportingServer.* Implemented various SSRS features such as drill through, sub reports, drill down, linked reports, charts,dynamic parameters, cascading parameters, lookup functions, shared data sets, and subscriptions etc.* Developed and deployed reports onto the SharePoint site for Target audience. Worked on SSIS Packagechange request to accommodate the required changes* Scheduled reports using MS SSRS to E-mail with an attachment in the desired format of report to theusers.* Involved in creating Technical Specification Document. Involved in meetings/status calls with clients toderive the accurate requirement.

* Trained and worked under the direction of 4 senior consultants* Performed unit testing & data testing* Composed Technical Designs