Kambham

Work Experience:

Currently working as Software Engineer in MARALLA SOFTLABS PRIVATE LIMITED from Jan 2018 to till date.

Client: GSK                                                                                                                        Aug 2019 to till date

Role: SQL Server, Power BI developer                                                                         

Description:

GlaxoSmithKline plc (GSK) is a British multinational pharmaceutical company headquartered in London, England.[4] Established in 2000 by GSK was the world's sixth largest pharmaceutical company according to Forbes as of 2019, after Pfizer, Novartis, Roche, Sanofi, and Merck & Co.

Responsibilities:

●       Collaborates with business analysts, subject matter experts, and other team members to determine data extraction and transformation requirements.

●       Executing the code to ensure it gives desired results, and performing debugging for removing errors.

●       Developing and updating database as well as merging collected information from old to new systems as required.

●       Designed and documented the entire Architecture of Power BI .

●       Expertise in writing complex DAX functions in Power BI and Power Pivot. 

●       Used various sources to pull data into Power BI such as Sql Server.

●       Installed and configured Enterprise gateway and Personal gateway in Power bi service.

●       Created Workspace and content packs for business users to view the developed reports.

●       Scheduled Automatic refresh and scheduling refresh in power bi service.

●       Wrote calculated columns, Measures query’s in power bi desktop to show good data analysis techniques.

●       Weekly presentation to the business users about the reports and their changes as required.

●       Worked on all kind of reports such as Yearly, Quarterly, Monthly, and Daily.

●       Worked on all types of transformations that are available in Power bi query editor.