Devender Singh
Data Analyst
Gurgaon
Summary
Adept Power BI Developer with a proven track record at Wipro Technologies, enhancing data-driven decision-making through advanced Power BI dashboards and SQL query optimization. Demonstrates exceptional teamwork and analytical thinking, significantly improving report generation efficiency. Skilled in leveraging Azure Data Factory and Agile methodologies to streamline data processes and insights.
Complex problem-solver with analytical and driven mindset. Dedicated to achieving demanding development objectives according to tight schedules while producing impeccable code.
Overview
12
12
years of professional experience
5
5
Certifications
Work History
Power BI Lead
Wipro Technologies
11.2021 - Current
- Power BI dashboard development:
- 1. Design, develop, and maintain Power BI dashboards, reports, and visualizations.
- 2. Implement row-level security (RLS), RBAC (Role based access control) and manage Power BI datasets.
- 3. Optimize Power BI solutions for performance and usability.
- Data Modeling and ETL:
- 1. Design and develop efficient data models in Power BI.
- 2. Collaborate with data engineers to extract, transform, and load (ETL) data from multiple sources.
- 3. Ensure data accuracy and integrity by implementing robust validation mechanisms.
- Stakeholder Collaboration:
- 1. Work with business analysts and stakeholders to gather requirements and translate them into technical solutions.
- 2. Provide training and support to end-users for Power BI tools.
- 3. Integrate Power BI with other data tools and platforms, such as AWS, Azure, SQL Server, and SharePoint.
- 4. Automate report generation and distribution processes.
- Governance and Best Practices:
- 1. Develop and enforce best practices for Power BI development and deployment.
- 2. Stay updated on Power BI updates and emerging trends in BI tools and technologies.
- 3. Understanding of Customer Data / Event Data
- 4. Understanding of data sourcing in a pipeline setup - AWS s3, redshift or Azure SQL DB for dashboard development.
Data Analytics Lead
Huawei Technologies
12.2020 - 11.2021
- Used statistical methods to analyze data and generate useful business reports.
- Improved decision-making processes with accurate data analysis and visualization techniques.
- Utilized data visualization tools to effectively communicate business insights.
- Collaborated with cross-functional teams to ensure data integrity and accuracy, resulting in better-informed decisions.
- Enhanced business efficiency by identifying trends and patterns in complex datasets.
- Provided actionable insights through comprehensive reports and dashboards, supporting strategic initiatives.
- Integrated multiple sources of disparate data into cohesive datasets using ETL processes, improving overall analytic capabilities.
- Managed large-scale databases to ensure timely access to critical information for key stakeholders.
- Developed custom algorithms to optimize data mining, increasing the effectiveness of analytical insights.
- Implemented robust control measures to improve analytical output reliability.
- Design, develop, and maintain Power BI reports and dashboards for business users
- Run large data platform and other related programs to provide business intelligence support
- Translate business requirements into effective visualizations using various data sources
- Create data models, DAX calculations, and custom measures to support business analytics needs
- Optimize performance and ensure data accuracy in Power BI reports
- Troubleshoot and resolve issues related to data connections, transformations, and visualizations
- Stay up-to-date with Power BI features and best practices
- Train end-users on using Power BI for self-service analytics
- Trained team members on best practices in data analytics, fostering a culture of continuous improvement.
Data Analyst
M.T.G Learning Media Pvt. Ltd.
11.2018 - 06.2020
- Implemented business intelligence solutions to increase operational efficiency.
- Identified patterns and trends in large data sets and provided actionable insights.
- Collaborated with stakeholders to identify business needs and data sources.
- Optimized data access and storage to improve performance of analytics systems.
- Generated standard and custom reports to provide insights into business performance.
- Updated and developed scripts and queries to extract and analyze data from multiple sources.
- Developed complex dashboard and reporting tools to track business performance metrics.
- Created dashboards to monitor and track key performance indicators.
- Utilized data visualization techniques to present and explain complex data sets.
- Requirement gathering and evaluation of clients’ business situations in order to implement appropriate analytic solutions.
- Designs, generates and manages reporting frameworks that provide insight as to the performance of clients’ marketing activities across multiple channels.
- Be the single point of contact on anything data & analytics related to the project.
- QA process: Maintain, create and re-view QA plans for deliverables to align with the requirements, identify discrepancies if any and troubleshoot issues.
- Prioritize tasks and proactively manage workload to ensure timely delivery with high accuracy.
- Active contribution to project planning and scheduling.
- Create and maintain project specific documents such as process / quality / learning documents.
SQL Developer
Vidya Softwares
11.2016 - 09.2018
- Enhanced database performance by optimizing SQL queries and indexing strategies.
- Designed and developed customized extract, transform and load (ETL) applications per client specifications.
- Maintained high-quality code standards through rigorous testing and peer code reviews, minimizing potential bugs and security vulnerabilities.
- Developed efficient stored procedures for complex business logic, reducing processing time and improving system stability.
- Analyzed existing SQL queries to identify opportunities for improvements.
- Participated in regular status meetings with project stakeholders to provide updates on progress and address any concerns or feedback promptly.
- Provided technical support for end-users by addressing SQL-related issues, enhancing overall user satisfaction with the application.
- Optimized server resource usage by monitoring performance metrics and making necessary adjustments to SQL Server configurations.
- Performed regular database backups to prevent information loss.
- Evaluated new technologies related to SQL development for potential implementation opportunities, facilitating innovation within the team''s workflow.
- Developed custom database objects, stored procedures, and delivered application support.
Senior MIS Executive
Digital Marketing Education Academy
06.2013 - 10.2016
- Contributed to strategic planning sessions by providing critical business intelligence derived from detailed data analysis.
- Streamlined report generation for improved decision-making with efficient data extraction and analysis techniques.
- Collaborated with IT teams to ensure seamless integration of MIS tools and applications into existing company-wide systems.
- Planned and led administration of management information system for achieving threshold-level performance.
- Lead data analysis to extract actionable insights and drive decision-making.
- Explore and visualize datasets to uncover patterns, trends, and anomalies.
- Analyze historical data to identify trends and develop forecasts for future performance.
- Investigate and identify root causes of issues or discrepancies in data.
- Provide training and support to team members and users on data analysis tools and techniques.
- Communicate findings and insights through compelling data visualizations and narratives.
- Lead data-related projects by providing analytical expertise and insights.
- Ensure data accuracy, completeness, and integrity through quality assurance processes.
Education
Master of Computer Applications - Computer Engineering
Sikkim Manipal University
New Delhi, India 04.2001 -
Skills
Power BI
SQL Query
Tableau
DAX
MS Fabric
Azure Data Factory
Python
Alteryx
Teamwork and collaboration
Problem-solving
Decision-making
JIRA
Analytical thinking
Data analysis
Agile
Data Modeling
Certification
Microsoft Certified: Power BI Data Analyst Associate (PL-300)
Timeline
Microsoft Certified: Fabric Analytics Engineer Associate (DP-600)
09-2024
Microsoft Certified: Azure Data Fundamentals (DP-900)
08-2024
Microsoft Certified: Power BI Data Analyst Associate (PL-300)
07-2024
Tableau Desktop Specialist
07-2022
Alteryx Designer Core Certification
05-2022
Power BI Lead
Wipro Technologies
11.2021 - Current
Data Analytics Lead
Huawei Technologies
12.2020 - 11.2021
Data Analyst
M.T.G Learning Media Pvt. Ltd.
11.2018 - 06.2020
SQL Developer
Vidya Softwares
11.2016 - 09.2018
Senior MIS Executive
Digital Marketing Education Academy
06.2013 - 10.2016
Master of Computer Applications - Computer Engineering
Sikkim Manipal University
04.2001 -
Similar Profiles
Sourav PalSourav Pal
Senior Software Engineer at Wipro Technologies, WiproSenior Software Engineer at Wipro Technologies, Wipro
Abhishek PawarAbhishek Pawar
Financial Analyst at Wipro TechnologiesFinancial Analyst at Wipro Technologies
PRIYANKA GOPUPRIYANKA GOPU
Manual QA Engineer at Wipro TechnologiesManual QA Engineer at Wipro Technologies