Prasanth Lingisetti
Summary
Highly skilled IT professional with over 6+ years of industry experience, including 4 years of expertise in Power BI, Power Apps, Power Automate, Analytics, Tabular Editor and Paginated Reports. Demonstrated track record in delivering impactful data-driven solutions and leveraging Power BI to transform complex data into actionable insights. Proficient in creating interactive dashboards, developing paginated reports, and building efficient workflows with Power Apps and Power Automate. Committed to driving business success through innovative data visualization, analysis, and advanced analytics techniques. Experienced in creating and managing relationships between tables in Power BI for accurate calculations. Skilled in creating pipelines in Azure Data Factory for seamless data flow and automation using event-based and scheduled triggers. Deployed the code across multiple environments using automated CI/CD pipelines in Azure DevOps.
Overview
7
7
years of professional experience
Work History
Power Bi Developer /Business Intelligence Analyst
Rockwell Automation India Pvt Ltd
07.2019 - 05.2023
- 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
Hyperion Developer
Rockwell Automation
08.2016 - 06.2019
- Designed and developed consolidation applications based on business requirement documents.
- Managed metadata, defined attributes, and created application profiles.
- Created HFM applications on both desktop and web-based clients, developing data grids and data forms for data input and visualization.
- Properly configured Point of View (POV) and set up security, including users, groups, security classes, and access rights.
- Managed Foundation and Financial Close Management (FCM) components.
- Involved in changing the Metadata whenever needed. Extracted and loaded the Metadata whenever metadata changes occur.
- Created journals as per the client requirement. Managed the financial review cycle using Process Management. Ran consolidation after loading the data.
- Developed web forms using Hyperion Planning web client for the users to input Forecast, Budget, Actual, Accounting changes, and other variance explanations data.
- Uploaded metadata to Hyperion planning and data to Essbase.
- Created reports Using Hyperion Financial Reporting, Financial Reporting Web (PBCS & EPBCS), and Smart View.
- Created groups and users, then assigned security and filters to define Essbase privileges on them.
- Experience using FDMEE to map data.
- Updated, created, deleted, and modified dimension members.
- Performed full charge Account Payable, Month -End Close (FCM), and weekly bank reconciliations.
- Generation of Financial Statements through HFR for business users. Involved in year and month-end processes (FCM) and all close cycles.
- Handled HFM\FR critical, medium, and normal tickets involving interactions with users and solving issues.
- Loaded, reconciled, and consolidated key financial data with Hyperion using FDQM (Financial Data Quality Manager) and HFM consolidation.
- Performed extensive application testing of Hyperion Financial Management, FDM, Planning, Essbase, Security, and Reports.
- Experience in migrating/deploying Planning/Essbase Applications among development, testing, and production environments.
- Experience in Performance/UAT testing of Hyperion Applications.
- Constructed Visio diagrams to display the Hyperion Environment Architecture and assisted in creating the project plan for the contract.
- Prepared operational documentation for the Hyperion application administrator.
- Conducted knowledge transfer classes to IT individuals.
- Managed project progress against timeline, milestones, and budget for smaller engagements.
Education
Master of Science - Civil Engineering
Texas A&M University
06.2016
Bachelor of Science - Civil Engineering
Jawaharlal Nehru Technological University
04.2013
Skills
- Power BI Design and Development
- Paginated Reports
- Dashboard Creation, Data modeling
- Stakeholder management
- Tabular Editor
- Power Apps
- Power Automate
- Data Visualization using Power BI
- Service Now
- Agile Project Management
- Azure Data Factory(ADF)
- SQL
Timeline
Power Bi Developer /Business Intelligence Analyst
Rockwell Automation India Pvt Ltd
07.2019 - 05.2023
Hyperion Developer
Rockwell Automation
08.2016 - 06.2019
Bachelor of Science - Civil Engineering
Jawaharlal Nehru Technological University
Master of Science - Civil Engineering
Texas A&M University
Similar Profiles
Shally VermaShally Verma
Business Development Leader – Cyber Professional Services, India at Rockwell Automation India Pvt. Ltd.Business Development Leader – Cyber Professional Services, India at Rockwell Automation India Pvt. Ltd.
Manish KumarManish Kumar
Project Administrator at Rockwell Automation India Pvt LtdProject Administrator at Rockwell Automation India Pvt Ltd
Sharad KumarSharad Kumar
Lead Engineer - Projects at Rockwell Automation India Pvt LtdLead Engineer - Projects at Rockwell Automation India Pvt Ltd