Home

Mounika - Power BI Data Analyst

[email protected]

Location: Novi, Michigan, USA

Relocation: Open

Visa: H1B

Resume file: Mounika Panditi_Data Analyst - CV_1746465075474.docx Please check the file(s) for viruses. Files are checked manually and then made available for download.

Mounika Panditi Email ID: [email protected] Ph No: 313-451-2172 --------------------------------------------------------------------------------------------------------------------- PROFESSIONAL SUMMARY Around 7+ years of Development experience in Data Analysis, Design, Data Modeling, Power BI and Implementation of Business Applications using Microsoft products. Experienced in MS Power BI Desktop and Power BI Service. Organized and enforce data standards, data definitions, and data lifecycle management. Extensive knowledge in writing DAX queries to measure the calculated columns. Perform data analysis to support decision-making and provide actionable insights to stakeholders. Migrated existing self-service reports and ad-hoc reports to Power BI. Extensive knowledge in Transform and combine the data using Query Editor in the Power BI and publish to Power BI Service. Good Experience in creating compelling reports and dashboards using advanced DAX. Integrated custom Visuals based on business requirement using Power BI. Good knowledge of Microsoft Azure, Cloud Services, Azure Storage, and Azure performance optimization. Proficient in creating SQL Server reports, handling sub reports, and defining queries for generating drill down reports using SSRS. Hands on Experience in creating OLAP cubes using Analysis Services (SSAS) and ETL packages using Integration services (SSIS) Proficient in Power BI data visualization to analyze and obtain insights into large datasets, create visually powerful and actionable interactive reports and dashboards. Experienced in STLC and good at database testing, regression testing, Production testing and manual test procedures. Programming Tools C#, SQL, PL/SQL, Python RDBMS SQL Server, Oracle, My SQL. Databases Oracle, SQL SEVER Reporting Tools Power BI, SSRS, Oracle Reports, Tableau Operating Systems Windows Azure Cloud Azure SQL Database, Azure Data Lake, Azure Data Factory (ADF) V2, Azure Blob Storage, Azure SQL Data Warehouse Professional Experience: Client: Ryder, Novi, MI Jun2024 Till Date Role: Sr. Power BI Data Analyst Responsibilities: Involved in various stages of SDLC like Requirement gathering, high level design, low-level design, Coding. Imported data from SQL Server DB and Created Dashboards using Power BI. Worked on Date Trim in Power BI. Import, shape, and transform data for business intelligence (BI), Visualize data, author reports, schedule automated refresh of reports and create and share dashboards based on reports in Power BI desktop. Design comprehensive System Design Documents (SDDs) incorporating functional and nonfunctional requirements, resulting in streamlined data integration processes. Conduct UAT and API testing using Postman, validating system functionality before deployment. Identify opportunities for process improvements related to data management and business analysis. Developed Complex calculated measures using Data Analysis Expression Language. Performed data analysis to support decision-making and provide actionable insights to stakeholders. Published Power BI Reports in the required originations and made Power BI Dashboards available for customers. Improved query performance and reduced costs by creating appropriate clustering keys, partitioning strategies, and tuning Snowflake queries and data loading processes. Scheduled Automatic refresh and scheduling refresh in Power BI service. Explore data in a variety of ways and across multiple visualizations using Power BI. Creating relationships between different data sources in Power BI to visualize the data and build the reports. Developed multiple reports using Reports for listing the customers who visited the center. Environment: SQL Server, Power BI, Snowflake, Power BI Service, DAX, MDX, Microsoft Sql Server Management Studio, Azure Data Studio, Windows. Client: AT&T, Atlanta, GA Sep2023 May 2024 Role: Sr. Power BI Data Analyst Responsibilities: Created geographical data visualizations and graphical representations of the data. Strong knowledge in Power BI on how to import, shape, and transform data for business intelligence (BI), Visualize data, author reports, schedule automated refresh of reports and create and share dashboards based on reports in Power BI desktop. Collaborate with cross-functional teams to ensure alignment of data initiatives with business goals. Experience with Snowflake services like Snowpipe (continuous data ingestion), Data Sharing, and Snowflake Tasks for automating data pipelines and maintaining up-to-date analytics. Implemented SSIS packages for ETL tasks such as data cleansing, merging, and transformation. Worked with cloud platforms such as Azure to deploy and manage Snowflake instances, integrate with other cloud services, and automate deployment pipelines. Processed large amounts of financial data for data visualization and statistical modeling and report results of statistical analyses, in the form of graphs, charts, and tables. Wrote Calculated Columns, DAX Measures, and Queries in Power BI desktop to show good data analysis techniques. Modified insights and formulated basic coding and scripting to be utilized for reports within the organization. Performed discussions with data modeler to update the data model for new requirements. Extracted data from the source views by writing the procedures to load the data into staging tables Created materialized views on remote source database and automated scheduler of refreshing of materialized view on source side. Created the integrity constraints and database triggers for complex data validations Responsible for Unit, System and UAT testing the data and provided the test evidence reports. Involved in UAT testing, Bugs fixing and the code was sent to Production. Environment: Oracle 11g, Oracle Forms 6i, Reports 6i, SQL Server, Snowflake,Power BI, Power BI Service, PL/SQL, SQL*Plus, SQL*Loader, PL/SQL Developer 6.0, DAX, MDX, Toad 9.1, UNIX, Erwin r4, XML, SVN, Informatica power center tool 8.1.1, QC 10.0, Windows. Client: ProQuest, Ann Arbor, MI July2022 - Aug2023 Role: Data Analyst Responsibilities: Created Power BI and Tableau dashboards for sales performance, marketing campaigns, and operational KPIs. Ensured data security and privacy by implementing role-based access in all dashboards. Developed and implemented several types of Financial Reports by using SSRS. Validated reports and resolved issues in a timely manner. Developed Dynamic packages using SSIS and Implemented Incremental Data Loading. Designed and built Python-based ETL scripts to clean, transform, and merge multi-source datasets. Responsible for writing SQL queries, stored procedures, views, triggers, T-SQL and SSIS. Processed large amounts of financial data for data visualization and statistical modeling and report results of statistical analyses, in the form of graphs, charts, and tables. Wrote Calculated Columns, DAX Measures, and Queries in Power BI desktop to show good data analysis techniques. Modified insights and formulated basic coding and scripting to be utilized for reports within the organization. Environment: Oracle 11g, SQL Server, MS Azure, SQL * Plus, TOAD, Power BI Desktop/Service, SQL*Loader, SQL Developer, flat files, SQL server, Business Objects, SAP Power Designer, Teradata 15, and Python 2.7. Client: Emergtek Solutions, India Sept 2016- Dec 2021 SQL Developer Responsibilities: Gathered requirements from Business users and created a Low-level technical design document using high level design document. Participated in the design meetings, and prepared technical and mapping documentation. Wrote SQL scripts to create temporary tables and developed control files for SQL*Loader to load from legacy system into the temporary tables. Created several types of procedures using PL/SQL and SQL queries for data validation and data cleansing. Designed and developed the scripts to create tables, views, indexes, and sequence. Maintained source and target mappings, transformation logic and processes to reflect the changing business environment over time. Involved in using dimensional modeling, created fact tables, dimensional tables, and other database objects in the Star schema model. Created indexes on the tables for faster retrieval of the data to enhance database performance. Handled errors using Exception Handling extensively for the ease of debugging and displaying the error messages in the application. Assemble client programming prerequisites and create related programming applications and projects in C#. Design, build and keep up capable, reusable and strong C# code. Research and assess programming related advances and items. Outline and create testing and support strategies and exercises. Worked on improving the Performance of SQL queries by extensive usage of Explain plan and various hints and indexes. Participated in performance tuning, unit test case preparation and execution. Environment: Oracle 10g, Informatica, C#, flat files, SQL Loader, SQL * plus, PL/SQL, Erwin 4.0/3.5.2 and Unix Shell Scripting. EDUCATION QUALIFICATION Master of Science in Computer Science from Wichita State University Bachelor of Technology in Computer Science and Engineering from Narasaraopet Institute of Technology & Technology affiliated to JNTU University, Kakinada CERTIFICATION Microsoft Certified: Power BI Data Analyst Associate Keywords: csharp business intelligence database active directory microsoft procedural language Georgia Idaho Michigan