CHAITANYA KANAGALA

The Project aims at providing the Power BI Solutions to Different High-level Risk EUC’s (Reports) which are currently in different Platforms like Excel, Business Objects. It is a re platforming Project where High risk Reports mostly in Excel and other Databases like MS Access are converted to Power bi Reports as well as providing the automated solution using power automate and other power platform services. Worked on the High complex and high-risk Reports in the Student related Systems and Providing access to different departments, Head Of departments, Management of University, Financial reports Regarding Public funding.

• Acted as a team leader in group projects, delegating tasks and providing feedback.
• Identified issues, analyzed information and provided solutions to problems.
• Exercised leadership capabilities by successfully motivating and inspiring others.
• Demonstrated strong organizational and time management skills while managing multiple projects.
• Developed and maintained courteous and effective working relationships.
• Assisted with day-to-day operations, working efficiently and productively with all team members.
• Cultivated interpersonal skills by building positive relationships with others.
• Developed strong communication and organizational skills through working on group projects.
• Applied effective time management techniques to meet tight deadlines.
• Developed strong organizational and communication skills through coursework and volunteer activities.
• Proven ability to develop and implement creative solutions to complex problems.

• Developed SQL queries to obtain complex data from tables in on-site and remote databases
• Maintained consistent database security and integrity through logging, audits and transaction monitoring
• Evaluated complex data sets to identify business opportunities and threats
• Facilitated strategic decision-making by creating detailed reports across multiple data axis
• Created and refined standard queries for verifying data quality and pinpointing errors
• Gathered and defined user requirements for system updates
• Created and deployed system testing plans to back up deployments
• Scheduling the Report refreshes in Power BI Service
• Worked on Power Platform development including experience in best practices for building Canvas Apps & Flows for the sales department
• Worked on Integrating the Power Apps with Power BI and automate the flow with Power Automate
• Contribute to the development of automated reporting solutions
• Create and deliver HR reports, dashboard, and analyses for senior and executive level audiences
• Create and maintain detailed documentation on all projects/requests
• Implemented drill functionality on the reports using Drill Maps
• Implemented the migration process using object manager by creating packages
• Worked on integrity manager testing to automate the process of verifying the project components from time to time
• PROJECT, platforming, The Project aims at providing the Power BI Solutions to Different High-level Risk EUC's (Reports) which were currently in different Platforms like Excel, Tableau
• It is a re platforming Project where High risk Reports mostly in Excel and other Databases like MS Access are converted to Power bi Reports as well as providing the automated solution using power automate and other power platform services
• Worked on the High complex and high-risk Reports in the financial division
• ROLES & RESPONSIBILITES:
• Worked on building Power BI dashboards which provide department wise performance
• Scheduling the Report refreshes in Power BI Service
• Initiating on-demand refreshes in case of auto refresh fails and analyze/fixing of the issues caused for refresh failures
• Proven proficiency at Data Transformations like Conditional Split, Sort, Data type Conversion, Union All, Merge, Append, Rounding, Date/Time related transformation, Pivoting/Un Pivoting etc.
• Involved in creation of Unit testing documents which will help the QA team for further analysis in higher environments
• Worked on comparison & analysis of report results with Power Bi dashboards which run on legacy systems
• Used various sources to pull data into Power BI such as Sql Server, SAP BW, Oracle, SQL Azure etc
• Worked on writing SQL queries to pull data from sources
• Scheduling the Report refreshes in Power BI Service
• Worked on PowerApps development including experience in best practices for building Canvas Apps & Flows for the sales department
• Worked on Integrating the Power Apps with Power BI and automate the flow with Power Automate
• Able to properly understand the business requirements and develop data models accordingly by taking care of the resources with knowledge and skills for secondary tools such as Microsoft Azure, SQL data warehouse, PolyBase, Visual Studio, etc

DESCRIPTION:

• The Project aims at providing the solutions to the client Digital River which in turn works for around 400 clients in and around different locations of United States and all around the world.We as a team provided interactive dashboards and reports based on business of the clients like Avast, Logitech, Kaspersky in smooth transition and performing their businesses in e-commerce platform by providing data to individuals at department level as well as individual levels based on several factors and metrics
• ROLES & RESPONSIBILITES:
• Worked on building Power BI dashboards which provide department wise performance
• Scheduling the Report refreshes in Power BI Service
• Initiating on-demand refreshes in case of auto refresh fails and analyze/fixing of the issues caused for refresh failures
• Proven proficiency at Data Transformations like Conditional Split, Sort, Data type Conversion, Union All, Merge, Append, Rounding, Date/Time related transformation, Pivoting/Un Pivoting etc.
• Involved in creation of Unit testing documents which will help the QA team for further analysis in higher environments
• Worked on comparison & analysis of report results with Power Bi dashboards which run on legacy systems
• Used various sources to pull data into Power BI such as Sql Server, SAP BW, Oracle, SQL Azure etc
• Worked on writing SQL queries to pull data from sources
• Scheduling the Report refreshes in Power BI Service
• Worked on Power Platfrom development including experience in best practices for building Canvas Apps & Flows for the sales department
• Worked on Integrating the Power Apps with Power BI and automate the flow with Power Automate
• Able to properly understand the business requirements and develop data models accordingly by taking care of the resources with knowledge and skills for secondary tools such as Microsoft Azure, SQL data warehouse, PolyBase, Visual Studio, etc
• Converted existing BO reports to tableau dashboards
• Created different KPI using calculated key figures and parameters
• Developed Power Apps application using Common Data service, CDS, Flow, Excel, Forms and SharePoint
• Set up Microsoft Flow (Power Automate) to provide auto-approval and status update features based on predefined criteria
• Provided Production support to Tableau users and Wrote Custom SQL to support business requirements
• Utilized Tableau server to publish and share the reports with the business users.

HEALTH PLAN SERVICES

DESCRIPTION :

Health Plan Services (HPS) is the nation's largest independent provider of sales, benefits administration, retention, and reform and technology solutions to the insurance and managed care industriesHPS stands at the forefront of the insurance industry, providing exchange connectivity, administration, distribution, and technology services to insurers of individual, small group, voluntary and association plans, as well as valuable solutions to thousands of brokers and agents, nationwide

ROLES & RESPONSIBILITIES:

• Installed and configured Enterprise gateway and Personal gateway in Power bi service
• Scheduled Automatic refresh and scheduling refresh in power bi service
• Wrote calculated columns, Measures query is in power bi desktop to show good data analysis techniques
• Worked on all kind of reports such as Yearly, Quarterly, Monthly, and Daily
• Worked on all types of transformations that are available in Power bi query editors
• Contribute to the development of automated reporting solutions
• Create and deliver HR reports, dashboard, and analyses for senior and executive level audiences
• Create and maintain detailed documentation on all projects/requests
• Automated Power Query refresh using power shell script and windows task scheduler
• Used various sources to pull data into MSTR such as Sql Server, SAP BW, Oracle, SQL Azure etc
• Experience in developing the Dashboards with Drill down, Interactive filters, Visual Level filter, Page level, Report Level filters, Drill through filters in Power BI
• Experience in creating Aggregations, calculations, KPI's and Bookmarks
• Experience in writing DAX queries
• Experience in writing SQL queries to pull data from sources
• Integration of the different Power Automate flows to implement any business logics
• Branding of the SharePoint desktop version
• Experience in the analysis, design, development, testing, and implementation of enterprise scale apps
• Experience in developing new Power Apps model using Power Platform (Power Apps and Power Automate) and canvas as well as model driven apps enhancing existing apps
• Created multiple Canvas Apps in Power Apps synced with Power Automate
• Created Multiple Notification Flows using Power Automate
• Different PowerApps controls and integrations with flow ensure the data quality
• Defined the Row level security by defining the roles using Manage roles in Modelling tab along with defining the DAX expressions
• Worked on Health Care systems to Provide the automated workflows for sending notifications to end users on their Health insurance claim, end dates for renewal processes.

• Wrote clean, clear and well-tested code for various projects.
• Verified and resolved bug reports and issues.
• Produced clean, error-free code in line with internal quality standards.
• Exhibited software development best practices to achieve and surpass KPIs.
• Maintained project momentum by providing detailed progress reports and milestone updates to key stakeholders.
• Supported large-scale systems with secure, well-performing software systems.
• Created and documented maintenance procedures for developed software.
• Developed processes governing software testing, validation and defect resolution.
• Checked software for errors and coded updates to fix problems.

DESCRIPTION:

The project aims at providing the L3 admin support for the smooth running of the projects. Providing production support as well as providing required access for the users using user management along with using different MicroStrategy tools like object manager, command manager, integrity manager to maintain the integrity of the data. Along with, smooth running of the servers and connectivity of the servers to the end users so that they cannot face any glitches in accessing the data through reports, dashboards

ROLES & RESPONSIBILITIES:

• Defined and verified configurational changes through tests to meet business requirements.
• Provided technical assistance to user staff and programming personnel by writing documentation.
• Identified and implemented modifications needed in existing applications to meet changing user requirements.
• Resolved system outages with rigorous troubleshooting and patching skills, including 24/7 coverage.
• Planned and managed projects through consultations with internal and external teams to meet set objectives on time and on budget.
• Studied and documented present workflow to recommend process improvements.
• Translated business requirements into system change specifications for use by development teams.
• Designed software dashboard providing real-time updates on system performance and KPI delivery.
• Enhanced processes by analysing production performance to identify efficiencies.