Home

Pavithra Yetrintala - POWER BI

[email protected]

Location: Newark, New Jersey, USA

Relocation: yes

Visa: H1B

PAVITHRA YETRINTALA E-mail: [email protected] Expertise: POWER BI Mobile No: 770-628-5675 Experience: 7+ years Career Objective: To associate with an organization that progress dynamically, provides me an opportunity to update my knowledge and enhance my skills in new technologies, and be part of a team that excels in work towards the growth of the organization which gives me personal and professional satisfaction thereof. Professional Summary: Having 7+ years of professional software development experience in the areas of Report Design, Analysis, Data integration and development in client server environment with focus on Data warehousing applications using ETL tools like SQL server Integration services and Implementation of Business Intelligence reporting & data visualization tools like SSRS and Power BI. Hands on experience in development using Power BI and Experience in Power BI Desktop. Experience on understanding DAX Functions in Power BI. Experience on gathering and translating end user requirements into efficient dashboards. Experience in Data preparation in Enter Data and shaping data in Edit Query like add column, split column, pivot column, unpivot column, changing data type, and Merge queries and Append queries. Have good knowledge on Formatting visuals and creating Filters in Visual level, page level, Drill through and Report level in Power BI. Experience on conditional formatting and all components of Power BI. Imported data from multiple data sources into BI Tools, created relationships between data, created calculated columns and measures using DAX. Experience in Creating Data Visualizations like Line chart, Bar Charts, Pie Chart, Table, Matrix table, Area Charts, tree map, Line and Stacked column chart and Creating Visuals like Donut chart, Waterfall chart, Gauge chart, Funnel etc. in Power BI Desktop. Working with team of developers designed, developed and implement a BI solution for Sales, Product and Customer KPIs. Imported data from multiple data sources into BI Tool, created relationships between data, created calculated columns and measures using DAX Query. Experience in creating Parameters, formatting, sorting and grouping. Created Customized and interactive dashboards using multiple data sources. Experience in publishing reports to Power BI services and setting up the necessary connection details and scheduling. Knowledge on sharing reports, gateways, creating content packs, giving credentials for scheduling, solution for troubleshooting of tiles, reports, dashboards. Summary of Work Experience: Worked as Senior Power BI developer for Tech Mahindra, Pune, India from Oct 2016 to Sept 2023. Educational Qualification: Completed Degree with B.sc (Computer science) from V.S.U, Andhra Pradesh, India. Technical Skills & Tools Technologies Used: Microsoft Business Intelligence Tools (MSBI), SQL Server Management Studio, Microsoft Visual studio, Power BI, Team Foundation Server. Operating Systems: Windows 2000 / XP, Windows Server 2003, Linux Databases: Databases: Sql Server 2012/2008 R2, Oracle, Postgres ETL Tools: Sql Server Integration Services. BI Reporting Tools: Sql Server Reporting Services, Power BI. Knowledge on Technologies: Microsoft Azure. Projects: Project: FRESH DIRECT -USA Dec 2021 Sept 2023 Role: Senior Power BI Developer Fresh Direct company had a large customer base but lacked insights into their customers' behavior and preferences. As a result, they were struggling to effectively target their marketing campaigns and retain customers. The goal of this project was to analyze customer data and segment the customer base for targeted marketing campaigns. Responsibilities: Development of Power BI reports & dashboards after gathering and translating end user requirements. Used different data sources such as Text/CSV, MS Excel, MS SQL Server using Live Connection as well Importing data. Power BI with DAX query, Multiple Data Sources, and Relationships of data. Operationalized business intelligence solutions and conducted advanced analytics to identify business requirements. Expertise in creating opportunities and strengths to meet business goals. Integrated Power Virtual Agent to power BI Dashboard Used Oracle Database as Data Source for importing data into PBI. Participated in daily stand-ups with clients on daily design and development effort... Good Experience in loading SQL Queries with Variables into Power BI using Power Query. Organizing scrum calls for testing activities with stakeholders. Excellent communication and leadership Skills. Created Filters, parameters, table calculations, calculated measures for purpose of monitoring business analysis. Build a ticketing system using Microsoft PowerApps and integrated with Microsoft flow and Power BI through which helps business clients were able to successfully track the issues happening in manufacturing plants. Environment: , MS Power BI,SQL,MS SQL Server, SQL server Integration Services(SSIS) and Windows Team Size : 6 Project: ESSAR OIL -UK Dec 2020 Nov 2021 Role: Senior Power BI Developer The Essar Oil UK customer analytics project aimed to gain insights into customer behavior and preferences in order to optimize the company's loyalty program and improve customer retention. The project involved analyzing customer data from multiple sources, developing customer segments, and providing recommendations for targeted marketing campaigns and loyalty program improvements. The goal was to increase customer satisfaction, loyalty, and repeat business through a more personalized and optimized customer experience. The project also involved developing a dashboard to track customer behavior and loyalty program metrics over time, providing ongoing insights for future optimization. Responsibilities: Gathering the requirements from business users and analysing those requirements and providing estimates. Designed different types of reports like drill down, drill through, and Sync Slicer.. Designing and developing power BI scripts for importing data from source. Working on Power BI desktop and service development. Working on the Power BI reports & dashboards with data sources like , Flat filesSQL Server. Accessed various data sources to pull data for reporting and analysis. Using DAX for data transformation in Power BI desktop. Created various customised and interactive Reports and dashboards in Power BI Publishing reports to Power BI service and providing the access to required users. Implemented Role Based Security as part of user level security in Power BI. Environment: MS Power BI, MS Office, SQL Oracle, SQL server Integration Services(SSIS),Pl/SQL, Windows Team Size : 5 Project: Integrated Decision Support (IDS)-Microsoft Aug 2019 Nov 2020 Role: Power BI Developer IDS is an Xbox 360 and Xbox One support application, which is used to track the XBOX related products and Offers status, here we will provide the details of all products related to XBOX 360 with current status of products. This will help project managers to track the status and follow up with the respective team. Here we also providing Offers on each product in different levels like country region with the help of SSAS and Power BI Reports and Web application. Responsibilities: Migrated SSAS to Power BI Reports using Power BI Service. Created Rich visualized Pie Charts, Tree Map, Tabular and Matrix Reports from OLAP Cubes by using Power BI Service. Extensively worked on Power BI Personal Gateways and Enterprise Gateways. Created rich visualized Dashboards in Power BI. Environment: Power BI, SQL Server 2008 R2 / 2014 Team Size : 4 Project: National Car Parking, UK May 2018 July 2019 Role: Power BI Developer Parking had, and continues to, become ever more expensive and more difficult to find. Congestion and traffic is on the increase, whilst the government actively discourages the provision of parking spaces to try and encourage people out of their cars and into crumbling public transport. Unused private parking spaces in areas where parking was in high demand. Over the years the team has grown, and our systems evolved to enable us to become the UK's leading agent for parking spaces and garages. We currently have in excess of 20, 000 spaces advertised to let, across the whole of the UK. Responsibilities: Analyzing the requirements and discussed with managers and leads on the functionality. Extract data from different kind of source systems into Power query and then cleansing the data by applying business rules and loading it into Power Pivot I Have experience on Power BI desktop and service development. I have worked on the Power Bi reports and dashboards with SQL Server I used table/matrix/trendlines/bar/card/gauge/slicers etc and custom visualizations. Comfortable in working with filters/calculated columns/measures/relationships and transformations of edit Query section Published/shared the reports by creating content pack/sharing the pbix file. I Implemented RLS as part of security. Environment: Power BI, SQL Server 2008 R2 / 2014 Team Size : 5 Project: Black Knight Financial Services. Oct 2016 April 2018 Role: Power BI Developer The Empower loan origination system (LOS) is an enterprise-wide platform that provides a seamless integration of capabilities to support the retail, wholesale and consumer direct channels. Empower eliminates errors and the need for duplicate entry associated with multiple systems. Further, lenders can improve data integrity and security to overcome evolving compliance challenges. Responsibilities: Analyzing the requirements and discussed with managers and leads on the functionality. I Have experience on Power BI desktop and service development I have worked on the Power Bi reports & dashboards with SQL Server/Tabular SSAS sources I used table/matrix/trendlines/bar/card/gauge/slicers etc and custom visualizations. Comfortable in working with filters/calculated columns/measures/relationships and transformations of edit Query section Published/shared the reports by creating content pack/sharing the .pbix file. I Implemented RLS as part of security. Environment: Power BI, SQL Server 2008 R2 / 2014 Team Size : 4 Keywords: business intelligence information technology microsoft procedural language South Carolina