Pinku Kumar

Pinku Kumar Email and Phone Number

Supervising Associate | Microsoft Power BI/DAX/Azure Data Factory/SQL/Azure Analysis Services | Client Technology @ EY @ EY
london, greater london, united kingdom
Pinku Kumar's Location
Noida, Uttar Pradesh, India, India
Pinku Kumar's Contact Details

Pinku Kumar personal email

About Pinku Kumar

* Have 11 years of hands-on experience in the software industry and proficient in Microsoft technologies such as MS SQL Server 2008R2/2012, Power BI, Azure Data Factory, Microsoft Azure Infrastructure and DAX Activities.* Have overall 6 years of proficient experience in creating and building the dashboards in Power BI Desktop using different kind of sources like Azure SQL database, MS Excel, SQL Server, JSON and so on. * Proficient in designing/building complex stunning reports/dashboards using Filters (Slicers), Drill-down Reports, Sub reports and Ad Hoc reports in Power BI Desktop.* Good in writing DAX queries/expressions in power BI desktop.* Ingestion of data from different sources to Azure Data Lake using Azure Data Factory.* Transformation of data in Azure Data Lake and then ingesting data to Azure SQL database.* Creation of tabular model using Visual studio in Azure Analysis services.* Improve performance of the existing Power BI reports by identifying issues and fixing them.* Experience in providing the securities for reports/dashboards by assigning roles. * Proficient in working with SQL Query Analyzer, SQL Server Management Studio and Business Intelligence Development Studio, Indexes and SQL Profiler.* Experience in creating Azure virtual machines and Azure SQL database.* Managing team members and helping them in case of any technical issue.* Working on Agile environment.* Using Devops for Product Backlogs, Tasks, Bugs and Repository.

Pinku Kumar's Current Company Details
EY
Supervising Associate | Microsoft Power BI/DAX/Azure Data Factory/SQL/Azure Analysis Services | Client Technology @ EY
london, greater london, united kingdom
Website:
ey.com
Employees:
296502
Pinku Kumar Work Experience Details
  • Ey
    Supervising Associate
    Ey Oct 2024 - Present
    Bengaluru, Karnataka, India
  • Ey
    Senior Associate
    Ey Jul 2021 - Sep 2024
    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.
  • Tata Consultancy Services
    It Analyst
    Tata Consultancy Services Oct 2018 - Jun 2021
    Noida
  • Genpact
    Consultant
    Genpact Dec 2017 - Sep 2018
    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.
  • Hcl Technologies
    Software Engineer
    Hcl Technologies Aug 2013 - Nov 2017
    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.

Pinku Kumar Skills

Sql Ip Networking Production Support Windows Server Admistrator Database Administrator Sql Server Management Studio Microsoft Sql Server Databases Web Services Business Intelligence Tools Power Bi Microsoft Azure

Pinku Kumar Education Details

Frequently Asked Questions about Pinku Kumar

What company does Pinku Kumar work for?

Pinku Kumar works for Ey

What is Pinku Kumar's role at the current company?

Pinku Kumar's current role is Supervising Associate | Microsoft Power BI/DAX/Azure Data Factory/SQL/Azure Analysis Services | Client Technology @ EY.

What is Pinku Kumar's email address?

Pinku Kumar's email address is pi****@****ail.com

What schools did Pinku Kumar attend?

Pinku Kumar attended Visvesvaraya Technological University.

What are some of Pinku Kumar's interests?

Pinku Kumar has interest in Economic Empowerment, Education, Environment, Human Rights, Health.

What skills is Pinku Kumar known for?

Pinku Kumar has skills like Sql, Ip Networking, Production Support, Windows Server Admistrator, Database Administrator, Sql Server Management Studio, Microsoft Sql Server, Databases, Web Services, Business Intelligence Tools, Power Bi, Microsoft Azure.

Who are Pinku Kumar's colleagues?

Pinku Kumar's colleagues are Balázs Ballai, Ismaele Bassani, Bo Bearse, Sneha Chaubey, Justyna Błaszczyk, Luis Sierra Bonilla, Kamel Hammi.

Not the Pinku Kumar you were looking for?

  • Pinku Kumar

    Strategic Sourcing | Vendor Development | Purchase | Supply Chain | Procurement
    Ludhiana
    2
    gmail.com, yahoo.co.in

    2 +919569XXXXXX

  • Pinku Kumar

    Software Test Engineer | Manual Automation Testing| Automation Framework | Selenium Webdriver | Java | Testng | Maven | Api Testing Postman | Agile | Git & Github | Function Testing | Regression Testing | Jira
    Noida
  • Pinku Kumar

    Linux And Aws Cloud Architect With Spanish Language At Tata Consultancy Services
    Chengalpattu
  • Pinku Kumar

    Sr. Research And Development Engineer - I At Agnisys, Inc
    Rohini
  • Ankush Kumar

    || Talent Acquisition Associate @ Kareer Hubb || #Hiring #Bulkhiring #Bpojobs
    New Delhi

Free Chrome Extension

Find emails, phones & company data instantly

Find verified emails from LinkedIn profiles
Get direct phone numbers & mobile contacts
Access company data & employee information
Works directly on LinkedIn - no copy/paste needed
Get Chrome Extension - Free

Aero Online

Your AI prospecting assistant

Download 750 million emails and 100 million phone numbers

Access emails and phone numbers of over 750 million business users. Instantly download verified profiles using 20+ filters, including location, job title, company, function, and industry.