Pinku Kumar Email and Phone Number
Pinku Kumar personal email
- Valid
* 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.
-
Supervising AssociateEy Oct 2024 - PresentBengaluru, Karnataka, India -
Senior AssociateEy Jul 2021 - Sep 2024Bengaluru, Karnataka, India1. 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. -
It AnalystTata Consultancy Services Oct 2018 - Jun 2021Noida -
ConsultantGenpact Dec 2017 - Sep 2018Noida 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. -
Software EngineerHcl Technologies Aug 2013 - Nov 2017Noida 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
Pinku Kumar Education Details
-
Computer Science
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 | ProcurementLudhiana2gmail.com, yahoo.co.in2 +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 | JiraNoida -
Pinku Kumar
Linux And Aws Cloud Architect With Spanish Language At Tata Consultancy ServicesChengalpattu -
-
Ankush Kumar
|| Talent Acquisition Associate @ Kareer Hubb || #Hiring #Bulkhiring #BpojobsNew Delhi
Free Chrome Extension
Find emails, phones & company data instantly
Aero Online
Your AI prospecting assistant
Select data to include:
0 records × $0.02 per record
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.
Start your free trial