Prasanth Lingisetti

Being a thought partner to the business/leadership of Market Access, creatively solving problems by bringing insights, working with business stakeholders to identify business intelligence needs, and performing data analysis while designing, implementing, developing, and maintaining BI reports & dashboards utilizing Power BI platform. Steering the process of dataset ingestion, the single data model for faster & automated data refresh catering to multiple reports and stakeholder needs to maintain consistency among reports and document reporting requirements. Liaising with IT to support development and maintenance of data governance artifacts using enterprise data management tools, including data dictionary, data models, data lineage, and data quality rules to implement BI projects. Administering projects, preparing updates, and implementing all phases of the project to achieve all project objectives. Proficient in designing and configuring Row-Level Security (RLS) in Power BI to restrict data access based on user roles or attributes. Proficient in designing, developing, and delivering Paginated Reports in Power BI, catering to various business reporting needs. Performing an assessment of all reporting requirements and developing a long-term strategy for various reporting solutions. Experienced in Power BI desktop to create dashboard visualizations. Strong knowledge of Data Warehousing methodologies and including star schemas, snowflakes concepts. Generated ad-hoc reports in Excel Power Pivot and sheared them using Power BI to the decision makers for strategic planning Explored data in a variety of ways and across multiple visualizations using Power BI. Strategic expertise in design of experiments, data collection, analysis and visualization Utilized in Power Query in Power BI to Pivot and Un-Pivot the Data Model for Data Cleansing and Data massaging. Explored data in a variety of ways and across multiple visualizations using Power BI. Proficient in configuring and managing on-premises data gateways in Power BI to securely connect to local data sources. Created Scorecards, Bookmarks, and QR Codes for Reports. Expertise in Publishing Power BI Reports of Dashboards in Power BI Server and scheduling the dataset to refresh for live data in Power BI Server. Worked with both direct query and Import data into Power BI for creating Reports. Created calculated columns and measures with the use of DAX Expressions like Aggregate, Time & Date Functions. Writing DAX, Power Query formulas, and creating Kpi's based on client requirements. Designed, developed, and supported Power Platform applications. Created custom forms using Power Apps forms. Integrated Power BI reports/tiles and dashboards into Canvas Apps Created Power Automate flows to automate business processes. Analyzing all complex data and identifying requirements for business enhancement in the project. Good experience in creating pipelines in Azure Data Factory to enable smooth data flow between source to destination and automating the flow by creating event-based and scheduled triggers. Deploying the code in all the environments using automated CI/CD pipelines in Azure DevOps. Involved in Troubleshooting, resolving and escalating data related issues and validating data to improve data quality

Master of Science: Civil Engineering Texas A&M University- Kingsville