Career Object
I Have Total 5 years of experience in Power BI development and Data Warehousing as ETL tester. I have extensively worked on data ware housing projects with major skill set as Power BI and ETL Testing.
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
Technical Skills
? Languages : SQL,POWER BI
? Databases : MS SQL Server DBA.
? Tools : POWER BI, 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 ACCENTURE , PUNE from JAN 2017 to Jan 2019.
? Working as a Software Test Engineer in 3i infotech, Pune from August 2013 to Jan 2017.
PROJECTS HANDLED
Project: #1 :-( : Press Ganey )
Client : Press Ganey,
Environment : MS power bi desktop.
Role : Power BI Development
Duration : May -2018 to JAN-2019
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.
Project: #2 :- ( PNC BANK)
Domain: FS
Client : PNC Bank
Environment : Power BI, MS SQL SERVER DBA.
Role : Power BI development
Duration : JAN -2017 to JUNE 2018
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 : ETL Testing
Duration : OCT 2014 to DEC-2016
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:
• 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 ADMIN
Duration : Aug 2013 - Oct 2014
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:
? 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
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