Venu Avasarala
Reporting Analyst
Hyderabad
Summary
Proactive Reporting Analyst eager to bring strong knowledge of performance metric evaluation and reporting to a new role. Highly skilled in training team members to properly execute data collection and analysis to maintain integrity and efficiency.
Overview
12
12
years of professional experience
2
2
years of post-secondary education
3
3
Languages
Work History
Reporting Analyst
Optum Global Solutions
11.2021 - Current
- Having 12+ years of work experience and 6+ years of relevant experience in Power BI.
- Evaluated effectiveness of existing reports against business objectives and made recommendations accordingly.
- Worked with cross-functional teams to develop strategies for improving overall process efficiency.
- Assisted in development of new reporting standards and policies within organization.
- Provided technical assistance in troubleshooting issues related to reporting tools.
Designed dashboards and visualizations to present data in clear and concise manner. - Gathered, analyzed and formatted large amounts of data into meaningful information.
- Prepared ad hoc reports as requested by senior management team.
Developed complex queries to extract data from multiple sources for reporting purposes. - Created visually appealing dashboards that effectively communicated key metrics to stakeholders
- Trained team members on use of reporting tools, increasing overall productivity within department.
- Developed 50+ reports by utilizing knowledge of SQL queries, SSRS and SSIS.
- Cleaned and transformed data using Power BI Query Editor to prepare ETL processes to optimize reporting datasets.
Associate Process Manager
Braodridge Financial Solutions Pvt Ltd
06.2012 - 10.2021
- Designing Farm architecture.
- Installation, configuring server environments in Microsoft SharePoint and Project Server.
- Creating SQL Server Report services environment.
- Developing automation tools in .NET to interact with Project Server environment.
- Creating project plans and maintaining timesheet for all resources.
- Streamlined processes by identifying inefficiencies and implementing solutions to optimize workflow.
- Excel rendering configuration at server to export the report data with header or without header in SQL Server Reporting services.
- Configuring SQL Server reporting services 2008R2 and 2012.
- Scheduled the SSIS packages to run at different intervals to load the data
- Created SSIS packages to generate flat files from SQL server database.
- Generated Excel reports using excel macro and VB.Net.
- Developed PowerShell scripts to automate daily activities.
- Developed complex SSRS reports using multiple data providers, Global Variables, Expressions, user defined objects, aggregate aware objects, charts, and synchronized queries
Education
M.Sc - Computer Science
Gayatri Vidya Parishad
Visakhapatnam 05.2009 - 05.2011
Skills
Power BI
Work Availability
monday
tuesday
wednesday
thursday
friday
saturday
sunday
morning
afternoon
evening
swipe to browse
Timeline
Reporting Analyst
Optum Global Solutions
11.2021 - Current
Associate Process Manager
Braodridge Financial Solutions Pvt Ltd
06.2012 - 10.2021
M.Sc - Computer Science
Gayatri Vidya Parishad
05.2009 - 05.2011
Similar Profiles
Vishal JainVishal Jain
Scrum Lead at Optum Global SolutionsScrum Lead at Optum Global Solutions
SYED MOHD ZAKI ALISYED MOHD ZAKI ALI
Senior Claims Specialists at OPTUM GLOBAL SOLUTIONSSenior Claims Specialists at OPTUM GLOBAL SOLUTIONS
Ganesh KGanesh K
Advisory Services Senior Consultant at Optum Global SolutionsAdvisory Services Senior Consultant at Optum Global Solutions