Pinku Kumar Email & Phone Number

Bengaluru, Karnataka, India

Bengaluru, Karnataka, India

1. Responsible for designing end-to end Power BI reports.2. Gathering requirements from customer/stakeholders.3. Ingesting data using Azure Data factory from different kind of sources like Oracle, SAP into Azure Data Lake.4. Transforming data in Azure Data Lake and ingesting into Azure SQL Database.5. Responsible for developing and Reports/Dashboards using Power BI Desktop and deploy into Power BI service.6. Responsible for import, reshape and model the data.7. Writing DAX queries to meet the reporting requirements.8. Responsible for creating stunning reports and visualizations.9. Creating tabular model in Azure analysis services and using this for Power BI reporting.10. Improving performance of the existing reports by identifying issues.11. Responsible for creating App Workspaces and content packs to share your insights.12. Responsible for import data from Azure and build the dashboards as per the requirement.13. Responsible for schedule the refresh of the reports according to frequency (daily, weekly).14. Responsible for creating Workspaces and share insights to specific business customers/partners and stockholders.15. Manage relationship with programmers and bridge communication between end users and development team.16. Responsible for providing the securities for reports/dashboards by assigning roles. 17. Responsible for identifying the project’s stakeholders and figures out what they need.18. Responsible for extract data from different source systems like azure SQL database, Microsoft SQL Server and Microsoft Excel.19. Responsible for managing team members to complete their work and help them in case of any need.20. Sharing knowledge with team members for any new useful power BI monthly updates.21. Using Azure DevOps for maintaining Product backlogs, Tasks, Bugs, GIT repository.22. Working in Agile methodology.

Noida

Noida

 Responsible for developing and Reports/Dashboards using Power BI Desktop and deploy into PowerBI.Com service. Responsible Import, reshape and model the data. Responsible Create stunning reports and visualizations. Responsible Create App Workspaces and content packs to share your insights. Responsible for import data from Azure and build the dashboards as per the requirement. Responsible for schedule the dashboards according to frequency (daily, weekly). Responsible for create Workspaces and share insights to specific business customers/partners and stock holders. Manage relationship with programmers and bridge communication between end users and development team. Responsible for providing the securities for reports/dashboards by assigning roles.  Responsible for identifying the project’s stakeholders and figures out what they need. Responsible for extract data from different source systems like azure SQL database, Microsoft SQL Server and Microsoft Excel.

Noida Area, India

 Responsible for analyzing data before creating the reports and discuss requirements with client managers. Responsible for Import, reshape and model the data. Responsible for creating stunning reports and visualizations. Creation of reports in Power BI desktop using data sources SQL Server DB, Azure SQL DB, TFS, and Microsoft Excel. Deployment of reports from Power BI desktop to Power BI Web(powerbi.com) and create dashboards in Power BI web. Responsible for creating calculated columns and calculated measures using DAX queries. Schedule data refresh of reports using Personal Gateway and On-Premises Gateway. Responsible for creating App workspaces. Responsible for creating SSRS reports as per requirement provided by stakeholders. Migrate SSRS reports to Power BI reports. Responsible for creating Azure SQL database and Azure SQL VM on Microsoft Azure Cloud. Designing of Databases, Optimization of SQL queries, and Increasing Performance of SQL queries. Responsible for creating SSIS packages and schedule this in SQL Jobs. Experience in Project Documents, Installation Documents and User Manuals. Installation SQL Server 2008 /2012 on Windows Server 2008, Apply service packs and security fixes. Performed daily tasks including backup & restore. Scheduled and monitoring all maintenance activities of SQL Server 2008 R2 database consistency check (DBCC) and index de-fragmentation. Fixing the issues on Log shipping, Replication, cluster Instances and Mirroring. Set up database backup and recovery strategies. Use SQL server Profiler for troubleshooting, monitoring, optimization of SQL Server and SQL code. Troubleshoot system issues, monitored scheduled jobs and set up maintenance plans for proactively monitoring the performance of SQL Server databases. Creating maintenance plans for databases. Monitoring database growth (Log/data file). Creating and monitoring Maintenance Plan. Investigating and troubleshooting Database problems.