Career Object
I Have Total 5 years of experience in Power BI development and Data Warehousing as ETL. I have extensively worked on data ware housing projects with major skill set as Power BI, SQL SERVER and ETL .
Professional Summary
Having 5.10 years of Experience in POWER BI development and ETL Testing.
Experience in Business Objects is a good plus. May look at converting some BO reports to PBI
Good communication skills and ability to work independently
Building Analysis Services reporting models.
Developing visual reports, dashboards and KPI scorecards using Power BI desktop.
Connecting to data sources, importing data and transforming data for Business Intelligence.
Excellent in analytical thinking for translating data into informative visuals and reports.
Able to implement row level security on data and have an understanding of application security layer models in Power BI.
Adept in developing, publishing and scheduling Power BI reports as per the business requirements.
Able to properly understand the business requirements and develop data models accordingly by taking care of the resources.
Able to integrate Power BI reports into other applications using embedded analytics like Power BI service (SaaS), or by API automation.
Also, one must be experienced in developing custom visuals for Power BI.
Having experience on preparing test cases, executing the test cases and documenting the test results.
Hands on experience in performing data validation between source and target database after ETL process in order to confirm correct execution of all transformations, Cleansing operations.
Good knowledge on data warehouse concepts like Star Schema, Snow Flake, Dimension and Fact tables.
Tested initial and incremental/Delta loads.
Having experience in DWH, SQL, Software Testing Life Cycle and Defect Life Cycle, Agile process.
Validated Slowly Changing Dimensions.
Knowledge on Structure validations on source to target tables.
Knowledge on Data validations and count validations.
Having experience in Oracle SQL.
Experience on Defect tracking & Management tool HP ALM.
Good communication, interpersonal, analytical skills and strong ability to perform in a team...
Using Database Transformation Services (DTS) for Import as well as Export of Data to & from Other Applications being used by the Organization.
Installation, Configuration of SQL Server 2000 and 2005 on Local System and Remote System.
Experience in performing regular Backups , scheduling tasks and restored the databases
Strong interpersonal skills, with the ability to easily and effectively interact with technical, non-technical, support, and business staff at all levels
Working Experience of on-permise BI Server and cloud BI server
Experience on Dax Calculations
Developing Star, snow flake and mixed modelling skills
Working experience on MSBI tools(SSIS/SSRS/SSAS)
Strong understanding of data modelling and ETL full, incremental and Change data capture loads
Documentation of requirements and writing user stories and tasks in Agile Methodology
Different domain understanding like healthcare, Banking, Retail …etc
Technical Skills
Languages
:
SQL,POWER BI
Databases
:
MS SQL Server DBA,MySQL.
Tools
:
POWER BI, Microsoft SQL server 2012,HP ALM, Rally.
Operating Systems
:
Windows XP, Windows7, Unix.
Database Utilities
:
SQL Developer
Educational Qualification
Graduated Bachelor of Technology in IT from JNTU Hyderabad .
WORK EXPERIENCE
Working as a senior software Engineer (SSE) in PWC, Hyderabad from MAY 2020 to till today.
Worked as a senior software Engineer (SSE) in ACCENTURE, PUNE from JAN 2017 to Jan 2019.
Worked as a Software Test Engineer in 3i InfoTech, Pune from August 2013 to Jan 2017.
PROJECTS HANDLED
Project: #1 :-( Pepsico)
Client : Pepsico
Environment : POWER BI
Role : Power BI development
Description:
PepsiCo, Inc. is an American multinational food, snack and beverage corporation headquartered in Harrison, New York, in the hamlet of Purchase. PepsiCo has interests in the manufacturing, marketing, and distribution of grain-based snack foods, beverages, and other products. PepsiCo was formed in 1965 with the merger of the Pepsi-Cola Company and Frito-Lay, Inc. PepsiCo has since expanded from its namesake product Pepsi to a broader range of food and beverage brands, the largest of which included an acquisition of Tropicana Products in 1998 and the Quaker Oats Company in 2001, which added the Gatorade brand to its portfolio.
As of January 26, 2012, 22 of PepsiCo's brands generated retail sales of more than $1 billion,[3] and the company's products were distributed across more than 200 countries, resulting in annual net revenues of $43.3 billion. Based on net revenue, PepsiCo is the second largest food and beverage business in the world, behind Nestlé. Within North America, PepsiCo is the largest food and beverage business by net revenue. Ramon LaGuardia has been the chief executive of PepsiCo since 2018. The company's beverage distribution and bottling is conducted by PepsiCo as well as by licensed bottlers in certain regions.
,
Roles:
Power BI development.
Building Analysis Services reporting models.
Developing visual reports, dashboards and KPI scorecards using Power BI desktop.
Connecting to data sources, importing data and transforming data for Business Intelligence.
Excellent in analytical thinking for translating data into informative visuals and reports.
Able to implement row level security on data and have an understanding of application security layer models in Power BI.
Proficient in making .Dax queries in Power BI desktop.
Expertise in using advance level calculations on the data set.
Responsible for design methodology and project documentation.
Able to develop tabular and multidimensional models that are compatible with warehouse standards.
Adept in developing, publishing and scheduling Power BI reports as per the business requirements.
Able to properly understand the business requirements and develop data models accordingly by taking care of the resources.
Should have knowledge and experience in prototyping, designing, and requirement analysis.
Should have knowledge and skills for secondary tools such as Microsoft SQL DBA, SQL data warehouse, Visual Studio, etc.
Working Experience of on premise BI Server and cloud BI server
Experience on Dax Calculations
Developing Star, snow flake and mixed modelling skills
Working experience on MSBI tools(SSIS/SSRS/SSAS)
Strong understanding of data modelling and ETL full, incremental and Change data capture loads
Documentation of requirements and writing user stories and tasks in Agile Methodology
Different domain understanding like healthcare, Banking, Retail …etc
the Test status reports
Project: #1 :-( : Press Ganey )
Client : Press Ganey,
Environment : MS Power BI Desktop,MS SQL Server .
Role : Power BI Development
Project Description:
Transforming the Patient Experience
For more than 30 years, Press Ganey’ mission has been to support health care providers in understanding and improving the entire patient experience. As a strategic business partner to more than 26,000 health care organizations, we lead the industry in helping clients transform the patient experience and create continuous, sustainable improvement. Our associates are professionals with deep health care experience and are strongly committed to our clients' success and mission to reduce suffering. Our client teams are locally-based experts with in-depth knowledge of the patients and communities our clients serve to help us better understand and deliver cutting-edge performance improvement strategies.
Roles and Responsibilities:
Power BI development.
Building Analysis Services reporting models.
Developing visual reports, dashboards and KPI scorecards using Power BI desktop.
Connecting to data sources, importing data and transforming data for Business Intelligence.
Excellent in analytical thinking for translating data into informative visuals and reports.
Able to implement row level security on data and have an understanding of application security layer models in Power BI.
Proficient in making .Dax queries in Power BI desktop.
Expertise in using advance level calculations on the data set.
Responsible for design methodology and project documentation.
Able to develop tabular and multidimensional models that are compatible with warehouse standards.
Adept in developing, publishing and scheduling Power BI reports as per the business requirements.
Able to properly understand the business requirements and develop data models accordingly by taking care of the resources.
Should have knowledge and experience in prototyping, designing, and requirement analysis.
Should have knowledge and skills for secondary tools such as Microsoft SQL DBA, SQL data warehouse, Visual Studio, etc.
Working Experience of on premise BI Server and cloud BI server
Experience on Dax Calculations
Developing Star, snow flake and mixed modelling skills
Working experience on MSBI tools(SSIS/SSRS/SSAS)
Strong understanding of data modelling and ETL full, incremental and Change data capture loads
Documentation of requirements and writing user stories and tasks in Agile Methodology
Different domain understanding like healthcare, Banking, Retail …etc
Project: #2 :- ( PNC BANK)
Domain: FS
Client : PNC Bank
Environment : Power BI, MS SQL SERVER DBA.
Role : Power BI development
Project Description:
PNC Bank is a Pittsburgh -based financial services corporation. In the U.S., PNC is the fifth largest bank by number of branch offices, sixth largest by deposits, eighth largest by total assets, and fourth largest in number of ATMs. Accenture provides its high-performance services to PNC Bank.
Roles and Responsibilities:
Power BI development.
Building Analysis Services reporting models.
Developing visual reports, dashboards and KPI scorecards using Power BI desktop.
Connecting to data sources, importing data and transforming data for Business Intelligence.
Excellent in analytical thinking for translating data into informative visuals and reports.
Able to implement row level security on data and have an understanding of application security layer models in Power BI.
Proficient in making .Dax queries in Power BI desktop.
Expertise in using advance level calculations on the data set.
Responsible for design methodology and project documentation.
Able to develop tabular and multidimensional models that are compatible with warehouse standards.
Adept in developing, publishing and scheduling Power BI reports as per the business requirements.
Able to properly understand the business requirements and develop data models accordingly by taking care of the resources.
Should have knowledge and experience in prototyping, designing, and requirement analysis.
Should have knowledge and skills for secondary tools such as Microsoft SQL DBA, SQL data warehouse, Visual Studio, etc.
Project: #3 : ROYAL BANK
Client : NATWEST
Environment : MS SQL SERVER DBA.
Role : Power BI development
Description:
NatWest is one of the prestigious banks located across Europe and several other continents. Being a child member of Royal Bank of Scotland group NatWest Bank offers various banking services including personal loans, home loans, credit cards etc
Roles:
Power BI development.
Building Analysis Services reporting models.
Developing visual reports, dashboards and KPI scorecards using Power BI desktop.
Connecting to data sources, importing data and transforming data for Business Intelligence.
Excellent in analytical thinking for translating data into informative visuals and reports.
Able to implement row level security on data and have an understanding of application security layer models in Power BI.
Proficient in making .Dax queries in Power BI desktop.
Expertise in using advance level calculations on the data set.
Responsible for design methodology and project documentation.
Able to develop tabular and multidimensional models that are compatible with warehouse standards.
Designing databases and ensuring their stability, reliability, and performance.
• Design, create, and implement database systems based on the end user's requirements.
• Impove application's performances.
• Prepare documentations for database applications.
• Memory management for database systems.
• Develop database schemas, tables and dictionaries.
• Ensure the data quality and integrity in databases.
• Fix any issues related to database performance and provide corrective measures.
• Create complex functions, scripts, stored procedures and triggers to support application development.
• Take regular database backup.
• Test databases and perform bug fixes.
• Provide authentication and authorizations for Database
• Develop best practices for database design and development activities.
• Analyze the requirements and column mapping document.
• Involved in Preparing the Test Cases as per the business requirements.
• Involved in uploading the test cases prepared in Excel into Quality Center by using QC add-ins.
• Involved in Preparing the SQL Queries to validate the flow of data from Source to Target.
• Involved in test case review meetings and attending weekly status meetings.
• Involved in raising the defects in QC and in preparing the Test status reports
Project: #4 : Walgreens
Client : Walgreens
Environment : MS SQL SERVER DBA.
Role : MS SQL DBA & POWER BI
Description:
Walgreens is an American company that operates as the second-largest pharmacy store chain in the United States behind CVS Health.[3] It specializes in filling prescriptions, health and wellness products, health information, and photo services.[4] As of August 31, 2019, the company operated 9,277 stores in the United States. It was founded in Chicago, Illinois, in 1901. The Walgreens headquarters office is in the Chicago suburb of Deerfield, Illinois.
In 2014 the company agreed to purchase the remaining 55% of Switzerland-based Alliance Boots that it did not already own to form a global business. Under the terms of the purchase, the two companies merged to form a new holding company, Walgreens Boots Alliance Inc., on December 31, 2014. Walgreens became a subsidiary of the new company, which retains its Deerfield headquarters and trades on the Nasdaq under the symbol WBA.
Roles:
Installation & configuration of SQL Server 2000
Backup user databases and perform database restore and run consistency checks from SQL Server and application
Creating Indexes and Maintenance, checking the fragmentation percentage and running the Defragmentation procedure
Scheduling of maintenance Jobs (Daily, Weekly, Monthly) As per the as client request
Implementation of SQL Logins, Roles and Authentication Modes as a part of Security Policies for various categories of User Support
Involved in Log shipping - making data available to all the resources using the log shipping
Identifying slow-execution queries by Tracing and perform troubleshoot
Making data available to all the resources using the Replication Techniques
Installation & configuration of SQL Server 2000
Backup user databases and perform database restore and run consistency checks from SQL Server and application
Creating Indexes and Maintenance, checking the fragmentation percentage and running the Defragmentation procedure
Scheduling of maintenance Jobs (Daily, Weekly, Monthly) As per the as client request
Implementation of SQL Logins, Roles and Authentication Modes as a part of Security Policies for various categories of User Support
Involved in Log shipping - making data available to all the resources using the log shipping
Identifying slow-execution queries by Tracing and perform troubleshoot
Making data available to all the resources using the Replication Techniques
Power BI development.
Building Analysis Services reporting models.
Developing visual reports, dashboards and KPI scorecards using Power BI desktop.
Connecting to data sources, importing data and transforming data for Business Intelligence.
Excellent in analytical thinking for translating data into informative visuals and reports.
Able to implement row level security on data and have an understanding of application security layer models in Power BI.
Proficient in making .Dax queries in Power BI desktop.
Expertise in using advance level calculations on the data set.
Responsible for design methodology and project documentation.
Able to develop tabular and multidimensional models that are compatible with warehouse standards.
SIGNIFICANT HIGHLIGHTS
Achievements:
1. Received appreciations from client in every release for completing the given work within time by extending working hours.
2. Received Recognition from FS Duck Creek Insurance in May 2017 for database detecting defects in database testing.
3. No Production issues in the application for which I have tested.
4. Took responsibility of entire team after senior team member left from project.
Environment: Power Bi , HP ALM,Rally,SQL Server-2008, , , Windows –XP,7.
PERSONAL DETAILS
Name:Dasi Reddy Burri
Date of Birth: 11th July 1986
Gender: Male
Marital Status: Married