Pavan Kumar Avvaru Email & Phone Number

Dubai, United Arab Emirates

· Ability to communicate with business as well as technical teams, Strong client management skills· Ability to learn and quickly respond to rapidly changing business environment· Be up to date about the best practices and advancements in development and design· Documenting, designing, and modelling solutions and explaining, representing, and discussing the same with the team· Applying experience and knowledge to future solution considerations· Have an analytical and… Show more · Ability to communicate with business as well as technical teams, Strong client management skills· Ability to learn and quickly respond to rapidly changing business environment· Be up to date about the best practices and advancements in development and design· Documenting, designing, and modelling solutions and explaining, representing, and discussing the same with the team· Applying experience and knowledge to future solution considerations· Have an analytical and problem-solving mind set and approach· Imported data from SQL Server DB, Oracle and Share point in Power BI to generate reports.· Explored data in a variety of ways and across multiple visualizations using Power BI.· Used Power BI Gateways to keep the dashboards and reports up to date.· Published Power BI reports in the required originations and made power bi reports available in mobile apps.· Installed and configured enterprise gateway and personal gateway in Power BI Services.· Published reports and dashboards using Power BI.· Creating row level security with power bi and integrating with power bi service portal.· Developed analysis reports and visualization using DAX functions like table function, aggregation function and iterate functions etc.· Executed dashboard setups and data manipulation using DAX Show less

Bengaluru Area, India

· Developed Dashboards and Reports using Direct Query Mode in Power BI with SAP BW (BEx Queries) as Data Source.· Expert in creating and developing Power BI Dashboards into rich look and tested Power BI reports of Database and verified it with source data.· Used Microsoft Power BI to extract data from external sources and modify data to certain format as required in excel, and created SSIS packages to load excel sheets from PC to Database.· Used Power BI, Power Pivot to develop data… Show more · Developed Dashboards and Reports using Direct Query Mode in Power BI with SAP BW (BEx Queries) as Data Source.· Expert in creating and developing Power BI Dashboards into rich look and tested Power BI reports of Database and verified it with source data.· Used Microsoft Power BI to extract data from external sources and modify data to certain format as required in excel, and created SSIS packages to load excel sheets from PC to Database.· Used Power BI, Power Pivot to develop data analysis prototype and used Power View and Power Maps to visualize the reports.· Fair knowledge on Microsoft Azure SQL (DB and DWH) and Azure Storage.· Strong communication and interpersonal skills, proficient at grasping new concepts quickly and utilizing them in Productive manner.· Created various visualizations like Waterfall, Matrix, Cards, KPI, Column and Bar Charts. Knowledge of publishing the PBI Desktop models to PBI Service, collaborate using Workspaces to get quick insights about datasets.· Provided continued development and maintenance of bug fixes for the existing and new Power BI Reports.· Familiar with DAX functions such as CALCULATE, FILTER, ALLEXCEPT and SAMEPERIODLASTYEAR.· Dashboards using advanced multiple Drill Downs, Dynamic DAX functions, Bookmarks and Alert features were designed to support complex requirement scenario.· Perform Unit testing, Role Testing and Functional User Testing in both Power BI and SAP S4 environment to ensure dashboard is working as expected.· Handled Project management tasks such as Resource allocation, Project planning, Update management on project and progress reviews.· Created Custom hierarchies for drilling down to lower levels in the reports.· Created custom corporate JSON themes to update the formatting for reports without any manual formatting for charts and slicers in dashboard. Show less

Bangalore

Bengaluru Area, India

• Gathered and documented business requirements for analytical reports. Participated in requirements meeting and sessions to understand business needs. • Developed at least two - three visual options for each report for discussion with stakeholders• Integrated custom visuals based on business requirements using Power BI desktop• Developed Complex SQL queries using Stored procedures, Common Table Expressions (CTE), Temporary tables to support Power BI reports and Excel… Show more • Gathered and documented business requirements for analytical reports. Participated in requirements meeting and sessions to understand business needs. • Developed at least two - three visual options for each report for discussion with stakeholders• Integrated custom visuals based on business requirements using Power BI desktop• Developed Complex SQL queries using Stored procedures, Common Table Expressions (CTE), Temporary tables to support Power BI reports and Excel Dashboards• Developed calculated measures using Data Analysis Expressions (DAX)• Provided continued maintenance and development of bug fixes for the existing and new Power BI Reports• Explored data in a variety of ways and across multiple visualizations using Power BI and publish the reports into Power BI Service.• Involved in trouble shooting, resolving and escalating data related issues and validating data to improve the data quality. • Manage the planning and development of design and procedures for metrics reports. Performing data mining and cleansing.• Managing incidents and issues, focusing on effective communication and follow-up with stakeholders and other technical teams • Work with manual team to understand their requirements and transforming them into automation reports by using optimization techniques like Dynamic excel formulas, VBA, Stored Procedures, SSIS and DTS Packages.• Investigate and conducted study on forecasts, Product bookings, Plan and Restated bookings for products and Services• Successfully interpreted data to draw conclusions for managerial action and strategy Show less

Hyderabad Area, India

• Generate timely and accurate reports for analysis. Creating MIS/ Dashboard report and presenting it to the concern Department.• Preparation of MIS reports regarding the Headcount and Attritions of Sites on Monthly basis.• Querying multiple internal and external data sources using a variety of database reporting applications• Performing calculations on client activity to determine any adjustments needed to account analysis billing for clients using exception processes that cannot… Show more • Generate timely and accurate reports for analysis. Creating MIS/ Dashboard report and presenting it to the concern Department.• Preparation of MIS reports regarding the Headcount and Attritions of Sites on Monthly basis.• Querying multiple internal and external data sources using a variety of database reporting applications• Performing calculations on client activity to determine any adjustments needed to account analysis billing for clients using exception processes that cannot be supported through automated system capabilities• Developing complex business unit reports with minimal direction• Monitoring timeliness and accuracy of work and introducing ways to improve efficiency• Supporting any questions raised by users of the reports with product knowledge and research of any discrepancies found in the data• Assist in identifying opportunities to increase productivity, continuous improvement and potential cost savings.• Responsible for building, implementing and supporting Microsoft BI solutions, possess experience in all stages of project work like requirements, design, Implementation, testing and deployment. Show less

Master Of Technology (M.Tech.), Computer Engineering, A

Bachelor Of Technology - Btech, Computer Science And Engineering