Sree Ranganayakulu Doddi
Leander,TX
Summary
10+ Years of experience. 6+ Years of experience in MS Power BI Development, Power Apps, and Power Automate, 4 years prior experience in SQL Server Database, IBM Cognos, and MSBI Development.
Overview
1
1
Certification
Work History
Power Bi Architect
Cognizant Technology Solutions (CBRE Client)
- Developed Power BI report as per the user requirement.
- Create the Power App application for the user.
- Create the API power BI link so, report can be embedded to the Power APP application.
- Create Power Automate flow to trigger the dataset refresh as per user click on the flow button.
- Apply row level security.
- Attended team meetings to resolve technical and project issues and review project schedules.
Senior Power BI Architect
Cognizant Technology Solutions (McDonald)
- My primary responsibilities involved designing, developing, reviewing, and testing major core modules developed using best practices
- Requirements clarification with BA and clients
- Evaluating system performance and design and its effect on data quality
- Documenting processes and maintaining data records
- Design and document the requirements for understanding the BRD
- Review the Power BI report design once the developer completes development
- Review the test scenarios document prepared by the QA team member
- Oracle views analysis and interactions with the DB team
- Create gateway connections and set up with our dataset
- Provided report-level access to the users
- Schedule refresh in Power BI Service.
Power BI Architect
Cognizant Technology Solutions (Akers Solutions)
- Requirements clarification with BA and clients
- Creating a story and task in Azure DevOps
- Connecting to the users whenever we have some queries on the requirement
- Develop reports and dashboards using Cosmos DB as a data source
- Provide API link to the frontend team for integration into the application
- Schedule refresh in Power BI Service
- Daily status call with the whole team.
Power BI Architect
Cognizant Technology Solutions (Volvo Cars)
- Getting requirements in the quarterly planning and distributed amongst developers
- Creating a story in Azure DevOps
- We have weekly Sprint planning where we need to deliver something on the requirement and explain
- Connecting to the users whenever we have some queries on the requirement
- Power BI model pointing to the file in the Azure blob
- Creating Row-level security with Power BI and Integration with Power BI Service
- Schedule refresh in Power BI Service
- We have moved all Azure blob files to SQL developer so that we can point all reports to SQL in the future
- Daily we have status calls with the whole team.
Power BI Developer
Cognizant Technology Solutions (Stearns Lending)
- Analyze their old Power BI model, which has an issue with a scheduled refresh, and provide recommendations
- As per the recommendations, we removed unused tables and columns, that are not used in their reports, and moved duplicated measures to the model level
- Pointed all their reports to the new Data model
- Development of new reports/Dashboards out of scratch as per the Business requirement
- Creating Row-level security with Power BI and Integration with Power BI Service
- Schedule refresh in Power BI Service
- Created reports using time intelligence calculations and functions
- Migration of Excel report to Power BI, understanding all the queries and calculations and converting into Power BI
- Weekly, once we have a business call, we will show them the progress and if they give any new or change requests, then we will work on those changes and publish them
- Daily we have status calls with the Client.
Senior Power BI Developer
Cognizant Technology Solutions (Kantar Media)
- Understanding the Requirements of the client with the user story and Mockup
- Created aggregated table in Azure Databricks
- Imported all Aggregated tables into Power BI and created a dashboard
- Developed Power BI reports using Line and clustered charts, stacked bar charts, and some custom visuals
- Working on conditional formatting for showing KPIs
- Calculated a measure to compare data with 2 date filters by DAX
- Ensuring formulas & Parameters work as expected, if required need to change formula accordingly
- We twice had a call with the client for any clarification or demo of the dashboard, which we prepared
- Unit testing
- Publish reports to Power BI service.
Associate
Cognizant Technology Solutions (Allergan Client)
- Understanding the Requirements of the client
- Created Mapping document
- As per the change request we did UI changes on all reports
- Modified the existing reports as per Client requirements
- Developed Power BI reports using Cross tabs, bar, Pie, Area Chart, Line Chart, and Scatter Charts
- Working on conditional formatting for all the SVT performance reports
- Ensuring formulas & Parameters work as expected, if required need to change formula accordingly
- Changing Data source and column references
- Unit testing
- Publish reports to Power BI service.
Power BI Developer
Cognizant Technology Solutions (AAP Client)
- Worked as a Power BI developer to create reports, Dashboards, and Visualizations
- Understanding the Requirements of the client
- Created Metadata modeling in Power BI Desktop using Fact and Dimension Tables
- Ensuring formulas & Parameters work as expected, if required need to change formula accordingly
- Publish reports to Power BI service
- Post-production support.
Power BI Developer
Cognizant Technology Solutions (Walmart Client)
- Worked as a Power BI developer to create reports, Dashboards, and Visualizations
- Understanding the Requirements of the client
- Created Mapping document
- Developed Power BI reports using Lists, Matrix, bar, Pie, Area Charts, etc
- Ensure all Columns are present from source destinations
- Ensuring formulas & Parameters work as expected, if required need to change formula accordingly
- Changing Data source and column references
- Unit testing
- Post-production support.
Cognos Report Developer
Cognizant Technology Solutions (UBS Client)
- Some enhancement work on the reports which are already in production and the development of new reports
- Requirements clarification with clients
- Creating a drill trough report to get the details of the report
- Prepare Tasks and manage the Agile JIRA board
- Unit testing in QA and UAT
- Daily we have status calls with the team
- Deployed reports in QA, UAT, and Production
- Drive the daily call with QA and Business to discuss defects and requirement changes.
Cognos Report Developer
Cognizant Technology Solutions (UBS Client)
- Enhancement work on old reports
- Requirements clarification with BA and clients
- Prepare sprints/stories and manage the Agile JIRA board
- Some SQL changes have been done and SQL has been used in Cognos
- After deployment compare the Excel output with production and DEV
- Deployed reports in QA, UAT, and Production
- Drive the daily call with BA to give the details of the work done.
Cognos Report Developer
Cognizant Technology Solutions (UBS Client)
- My primary responsibilities involved designing, developing, reviewing, and testing major core modules developed using best practices
- Requirements clarification with BA and clients
- Design and document the requirements for understanding the BRD and FSD
- Prepare sprints/stories and manage the Agile JIRA board
- Sybase/Oracle stored procedure analysis and interactions with the DB team
- Completed the transition KT from HCL on the current project
- Followed by providing reverse KT to client and peer members
- Completed Migration from Cognos 8 to Cognos 10
- Drive the SCRUM and represent the delivery in QA defects review calls.
Education
MBA -
JNTU
Hyderabad09.2012
Bachelor of Science -
Osmania University
Hyderabad05.2010
Skills
- MS Power BI
- SQL Server Database
- Power Automate
- Azure Data Factory
- Azure Databricks
- Power Apps
- SQL Server Integration Services
- SQL Server Analysis Services
- SQL Server Reporting Service
- Azure Blob Storage
- Azure Cosmos DB
- IBM Cognos
- ServiceNow
- Jira
- GitHub
Certification
- MS Power BI data analyst
- MS Power platform developer
Additional Information
10+ Years
Timeline
Power Bi Architect
Cognizant Technology Solutions (CBRE Client)
Senior Power BI Architect
Cognizant Technology Solutions (McDonald)
Power BI Architect
Cognizant Technology Solutions (Akers Solutions)
Power BI Architect
Cognizant Technology Solutions (Volvo Cars)
Power BI Developer
Cognizant Technology Solutions (Stearns Lending)
Senior Power BI Developer
Cognizant Technology Solutions (Kantar Media)
Associate
Cognizant Technology Solutions (Allergan Client)
Power BI Developer
Cognizant Technology Solutions (AAP Client)
Power BI Developer
Cognizant Technology Solutions (Walmart Client)
Cognos Report Developer
Cognizant Technology Solutions (UBS Client)
Cognos Report Developer
Cognizant Technology Solutions (UBS Client)
Cognos Report Developer
Cognizant Technology Solutions (UBS Client)
MBA -
JNTU
Bachelor of Science -
Osmania University
- MS Power BI data analyst
- MS Power platform developer
Similar Profiles
Deepak KhatriDeepak Khatri
Deputy Manager EHS at CBRE SOUTH ASIA PVT. LTD AT COGNIZANT TECHNOLOGY SOLUTIONSDeputy Manager EHS at CBRE SOUTH ASIA PVT. LTD AT COGNIZANT TECHNOLOGY SOLUTIONS
Ravidarshi BhaskarRavidarshi Bhaskar
Cyber Security Specialist at Cognizant Technology Solutions (Google Client)Cyber Security Specialist at Cognizant Technology Solutions (Google Client)
Kavya NagarapuKavya Nagarapu
Senior Front End Developer at Cognizant Technology Solutions - Client: VerizonSenior Front End Developer at Cognizant Technology Solutions - Client: Verizon