As a Principal Consultant at Genpact, I apply my expertise in Power BI and SQL to design, model, and document solutions for various clients and business scenarios. I have a Master of Technology (M.Tech) degree in Computer Engineering from Sri Krishnadevaraya University, and I am always eager to learn and adapt to the rapidly changing business environment. Some of my recent achievements include developing dashboards and reports using Direct Query Mode in Power BI with SAP BW as data source, creating and testing Power BI reports of database and verifying them with source data, and extracting data from external sources and modifying them to required format using Power BI and SSIS. I also have fair knowledge of Microsoft Azure SQL and Azure Storage, and I am proficient at using DAX functions, custom hierarchies, and JSON themes to enhance the functionality and appearance of Power BI reports. I have strong communication and interpersonal skills, and I collaborate well with technical and business teams, as well as manage client expectations and feedback. I am passionate about process improvement and data analysis, and I aim to deliver high-quality and impactful solutions that meet the needs and goals of my clients and organization.
-
Principal ConsultantGenpact Jan 2022 - Jul 2023Dubai, 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 -
Senior Project EngineerWipro Technologies Jun 2019 - Nov 2021Bengaluru 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 -
Software EngineerAccenture Jun 2016 - Jun 2019Bangalore -
Senior Data AnalystAccenture Jun 2016 - Jun 2019Bengaluru 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 -
MiRandstad India Feb 2015 - May 2016Hyderabad 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
Pavan Kumar Avvaru Skills
Pavan Kumar Avvaru Education Details
-
Computer Science And Engineering
Frequently Asked Questions about Pavan Kumar Avvaru
What is Pavan Kumar Avvaru's role at the current company?
Pavan Kumar Avvaru's current role is Technical Manager - Data Analytics | Immediately available | Microsoft 3x Certified | Power Platform, Power BI, Data Analytics, BI, Process Improvement, Data Governance.
What schools did Pavan Kumar Avvaru attend?
Pavan Kumar Avvaru attended Sri Krishnadevaraya University, Jntua College Of Engineering, Anantapur.
What skills is Pavan Kumar Avvaru known for?
Pavan Kumar Avvaru has skills like Microsoft Power Apps, Microsoft Power Platform, Project Management, Sql Server Integration Services, Microsoft Sql Server, Data Analysis, Microsoft Excel, Process Improvement, Transact Sql, Microsoft Power Automate, Visual Basic For Applications, Sap Bo.
Free Chrome Extension
Find emails, phones & company data instantly
Aero Online
Your AI prospecting assistant
Select data to include:
0 records × $0.02 per record
Download 750 million emails and 100 million phone numbers
Access emails and phone numbers of over 750 million business users. Instantly download verified profiles using 20+ filters, including location, job title, company, function, and industry.
Start your free trial