Project Names
TELT Dashboard, NBN Evolve Dashboard, CARE Dashboard, Inventory Management Dashboard
Organization - Client
Marktine
Role
Data Engineer and Data Analyst
Duration
Feb 2020 to Till Date
Technology used in project
Power BI, Azure SQL, ADLS, Python, Power Automate, GIT, Cognos.
Power BI services, Data Flows, Datasets, Gateways.
Project Description
Project involves moving on-prem data to Azure SQL db, building data model in Azure and develop Power BI dashboards to view and track the Telstra business
Responsibilities
- Worked on Design, Development and maintenance and Administration of Power BI
- Created Python Scripts to automate the data cleaning process of incoming csv files.
- Created Devops jobs to move CSV files to ADLS and then trigger the SP’s to load data into physical tables using Git repositories and existing DevOps framework.
- Implemented the data transformation in Python and in Azure SQL to meet the requirement.
- Build Cognos reports by adding objects and manipulating them to obtain the desired results.
- Implemented data drill down to slice and dice the data.
- Developed the and Power BI reports as per VizCap guidelines and design prototypes
- Worked on Data validation and Power BI report validation
- Designed and Developed Power BI Dashboards based on the User requirements and having multiple reviews with client to confirm the prototypes and Dashboard Navigations.
- Prepared RRD and other Application Data Flow Documents.
- Performed Data Analysis and Data validation on the Dashboards.
- Actively Involved in having Daily/Weekly Calls on the status update with Client team.
- Worked on Datorama.
Experience .
Feb 2017 To
Project Name5
Power BI Platform
Dec 2017
Company - Client
Astra Zeneca
Role BI Developer
Duration Feb17 to Dec17
Technology used in project
Power BI Desktop, Power BI Server, Embedded Power BI, Azure SQL, Cogons Oracle, MS SQL server, Hive, Tableau Desktop, Tableau server. JIRA, CISM,
Project Description
The project involves Developing dashboards to view and track the growth of each brand by HCP, F2F and Digital marketing.
Responsibilities
- Created Power BI reports and Dashboards from the scratch
- Developed the reports using Power BI Desktop.
- Designed the database in Data Lake, scheduled the batch jobs and accessed in Power BI
- Automated the reports using Microsoft flow
- Worked on creating datasets in Hive and ServiceNow as per the reporting requirement
- Involved in procuring Power BI Pro licenses
- Worked on Dashboard subscriptions to send daily report to Stakeholders with dynamic email body
- & User groups, giving access and Publishing & Scheduling reports)
- Experienced in Handling Issues Related to the reports and providing support on problem management and Incident management to Power BI Application.
- Working in Sweden shift to Support the Ongoing Issues related Power BI platform.
- Experience of Client-Interaction on onsite/Offshore.