Phanindra Guvvala

• Created multiple scorecards and dashboards using Power BI (Power Pivot/View) to display information needed by various departments and upper-level management.
• Involved in Data Analysis, Data Mapping and Data Modelling and Performed data integrity, Data Portability testing by executing SQL statements.
• Developed, tested, and connected from numerous databases and data sources to create various Power BI and Tableau visualizations for dashboard and ad-hoc reporting solutions.
• Implemented several DAX functions for various fact computations for effective data visualization in Power BI.
• Worked on SSIS Packages using ETL Methods for different purposes like loading Data from several external sources and internal servers used by Microsoft.
• Utilized Power Query in Power BI to Pivot and Un-pivot the data model for data cleansing and data massaging.
• The migration of SQL Server 2008, 2012, and 2014 to SQL Server 2016 was successful after creating various data sets on Azure.
• Worked on how to schedule ETL jobs to execute every night into data marts using SQL Server Agent. Data was loaded into databases using newly created dynamic SSISpackages as well as modified ones.
• Worked with the Microsoft Azure technologystack, particularly with Azure Data Factory and Azure Data Bricks, to develop, build, and analyze special solutions and applications.
• Created tables, views, indexes, functions, and stored procedures using T-SQL objects.
• Used Row Level Security with Power BI Desktop and integration with Power BI Service portal. Scala and Spark-SQL was combined to create Spark, which is used for testing and data processing.
• Worked with multi-dimensional models like Star Schemas and Snowflake Schemas to construct Cubes for Data Warehouses, Data Marts, and Business Intelligence.
• Designed, developed, and maintained end-to-end data pipelines on Azure using services like Azure Data Factory, Azure Data bricks, and Azure Synapse Analytics. Ensured efficient data movement and transformation to support various analytical and reporting needs.
• Worked on Tableau Dashboard for the top key Performance Indicators for the top management by connecting various data sources like Excel, Flat files, and SQL Database.
• Possess a thorough understanding of continuous integration and continuous deployment (CI/CD) principles and technologies like Jenkins, as well as the capacity to develop and put into practice deployment pipelines that incorporate database migrations, schema updates, and data seeding scripts.
• Utilizing the technologies of Hive, Map Reduce, and shell scripting, big data solutions were implemented on the MapR, Hadoop platform.
• Confluence was utilized for all project-related documents, JIRA was used for daily development chores, and QC was used for defect tracking during development and documentation.
• Linux and UNIXplatform experience; work has been done to resolve the problems and build the code.

Environment: Power BI, Power Pivot, Power Query, KPI, ETL, SSIS, Star Schema, Snowflake, ETL, T SQL, Power BI Desktop, Azure Synapse, Azure Data Factory, RLS, Tableau, Map Reduce, Spark, Python, Hadoop, Jira, Agile, Scrum, Excel, Power View.

Responsibilities:

• Involved in complete Software Development Life Cycle (SDLC) including system study, interaction with users & management, designing, coding, testing and deployment of the system.
• Developed BI solutions that are specifically tailored to meet the needs gathered from several cross- functional teams, and used SQL to build custom datasets by performing multiple joins on various database columns.
• Involved with the implementation of Microsoft Business Intelligence BI platforms including SQL Server Integration Services SSIS, SSRS, and SSAS.
• Merging and transforming data according to the requirements for ease of analysis in Excel by using Power query in Power BI.
• Embedded PowerBI reports to the portal. Managed and secured data and report for individual users by implementing RLS and Roles.
• Worked on measures, calculated columns, relationships and performed time series analysis using DAX in Power BI.
• Created and administrated workspaces for each project on Power BI service and published the reports from Power BI Desktop to Power BI Services workspace.
• The performance of both corporate centers and Strategic Business Units was analyzed using SQL Server Analysis Services (SSAS), which was done by designing complicated SSASsolutions employing a range of dimensions, viewpoints, hierarchies, measurement groups, and KPIs.
• Used SSIS to create ETL packages to validate, extract, transform and load data to data warehouse and data marts.
• Worked on dimensional modeling approaches, such as the Star Schema and the Snowflake Schema.
• Used Tableau formulas for a variety of business calculations, including reports against one or several tables utilizing custom SQL.
• Worked on Web jobs, AZURE data factory, Logic Apps for application and project development in Azure.
• At work was able to modify data using PySpark, Spark SQL, and data frames alongside data analysts while also comprehending the data and its intended uses.
• Implemented version control using Git for ETLprocesses, data mapping, analytics scripts, dashboard development, and report templates, ensuring collaboration and tracking changes.
• Implemented a Python-based distributed random forest via Python streaming.
• Used JIRA as a sprint tracking platform, followed the agile process, and took part in daily SCRUM meetings, sprint planning, showcases, and retrospective.
• Familiarity with Unix/Linux operating systems, including file systems, process management, and system utilities.
• Environment: Power BI, Excel, ETL, MS SQL, Tableau, GIT, Azure Data Factory, Tableau, SSRS, Python, Jira, Unix, Linux, DAX, Power desktop, Power Pivot, Azure, Agile, Scrum, SSAS, SSIS, Star, Snowflake, Pyspark, spark, SQL, KPI.