| | | 20,000+ Fresh Resumes Monthly | |
|
|
| |
Click here or scroll down to respond to this candidateCandidate's Name
Senior BI Consultant Email: EMAIL AVAILABLE
Mobile: PHONE NUMBER AVAILABLE
PROFESSIONAL SUMMARY
Microsoft Certified : PL-300 Power BI Data Analyst.
Microsoft Certified : DP-900 Azure Data Fundamentals.
Over 7.6+ years of IT professional experience in Data Analytics and Data Visualization in various technologies such as Python,
Numpy, Pandas, MySQL, Knime Analytics, Power BI and Analytical reporting.
Well-qualified Business Intelligence Developer with technical knowledge to design, develop and implement data and analytical
solutions.
Worked with Business Owners and Stakeholders to gather requirements for the report and implement those in Power BI and build
visuals which shows meaningful insights to the Business.
Proficient in building the different building blocks of Power BI, such as Visualization, Datasets, Reports, Dashboards, and Tiles.
Excellent analytical thinking for translating data into informative visuals and reports.
Involved in Extracting data from multiple data sources into Power BI applications.
Experience in developing power BI Reports using different DAX queries, visuals, filters and configuring Dashboards with drill down
capabilities.
Working knowledge of Power BI (Power Pivot, Power View, Power BI Online, Power BI Desktop, Power BI Publisher) and DAX.
Hands-on experience in SQL server Database. Good Knowledge of Power BI Data Modelling and Data Warehousing concepts like Star
Schema, Snowflake Schema. Dimensions and Facts tables.
Experienced in Python and VBA scripting for Automation and maintenance to extract data from different sources.
Familiar with Azure Data Factory, Azure Databricks and Data warehousing concepts for data ingestion and processing.
Experience at creating, configuring, and maintaining system databases.
Knowledge on different machine learning models for statistical analysis on complex data to gain insights.
Strong problem-solving, organizing, communication and planning skills with ability to work in a team environment.
EDUCATION
Masters of Business Administration - Operations (MBA), University of Mumbai, Mumbai, India Aug 2016 - Dec 2018
Bachelor of Engineering in Information Technology (BE-IT), K C College of Engineering, Thane, India Aug 2012 - Aug 2016
SKILLS
Programming Language: Python, VBA, Core Java, Basic R, SQL, DAX, Power Query Editor.
Database: MySQL, SQL server database, MySql
Web Technologies: HTML, XML, CSS
Tools/Softwares/App: PyCharm, Jupyter Notebook, Netbeans, Github, Visual basic, Power BI, Knime Analytics, Azure DataBricks,
Azure Data Factory, Azure services,Tableau, Microsoft SharePoint, Onedrive, MS Office.
Platforms: Microsoft Windows, Linux
EXPERIENCE
Client: Flagstar Bank | Employer: Kaizen Technologies Edison, NJ, USA
Senior BI Consultant April 2022- Till date
Responsibilities:
Created report page level filter in Power BI Desktop to visualize data according to requirement for analysis.
Utilized Power BI to create self-service BI capabilities and used tabular models.
Implemented role-based security for reports with DAX expressions in Power BI.
Worked on integrating data from Excel sheets, SQL server, SharePoint, and Office 365 for app building.
Built Power Apps using SharePoint as a data source and utilize SharePoint lists to access, share and collaborate around structured
data.
Created and customized various mobile layouts using Power Apps Studio.
Designed and developed complex reports in Power BI using different visuals and used DAX functions and measures to implement
transformations in Power Query.
Wrote multiple DAX expressions to create calculated columns and measures in Power BI.
Automated the data refresh of Power BI datasets using Power BI gateway by implementing DAX functions.
Created DAX expressions and date-to-yearly columns; implemented partitions in tabular models for Power BI.
Prepared a user manual explaining all features and functionalities of Power BI reports possible for the users.
Built the pipelines to copy the data from source to destination in Azure Data Factory.
Recreated existing application logic and functionality in the Azure Data Lake, Azure Data Factory, Azure SQL Database and Azure SQL
Data Warehouse environment.
Creating Stored Procedure and Scheduled them in Azure Environment Optimized SQL queries using indexes and execution plans for
maximum efficiency and performance.
Led performance tuning of the database by rewriting SQL Scripts, created indexes and partitions, and changed locking strategies.
Managed relationships and created new measures utilizing DAX and quick measures for required calculation in Power BI reports,
scripted new measures and calculated tables in Power BI Desktop utilizing DAX.
(Skills: Power Bi Apps, Azure Data Factory, Azure Data lake, Azure services, SQL, ETL, Analytical Reporting, Power Bi Desktop, DAX,
Power Query editor, R)
Client: Proctor and Gamble | Employer: E Team Inc Mumbai, India
Senior Consultant (Consultant) Mar 2021- Apr 2022
Responsibilities:
Created, analyzed and distributed ongoing reports as key stakeholders by turning multiple datasets into valuable and interactive
insights.
Participated in meetings with the business, experience owners in understanding the business requirements and analyze use cases.
Responsible for building valuable visualizations to identify patterns,trends and exceptions which enable business executives and
senior leaders to take data driven decisions.
Designing, Maintaining and Publishing Dashboards[ Covid Analysis, Monthly sales target data] using Power BI.
Producing Monthly and bi-weekly reports on the sales Analysis.
Key Takeaways Dashboarding, Retail Analytics, Reporting and Automations.
Creating Row-Level security with Power BI Desktop and integration with Power BI service.
Experience in optimizing reports and setting up Power Bi Service,Gateways and Scheduled Refreshes.
Finding Correlations in data to discover meaningful insights.
Evaluating analysis of share value on various PG products sold across different Accounts all over India.
Assist in planning and managing changes to dashboards because of new or improved business.
Working on Knime Analytics for data manipulations transformations and automation for creating Visual reports.
Identifying key performance indicators(KPI) to help adjust and fulfill objectives..
(Skills: Power Bi Apps, Knime Analytics, SQL, Analytical Reporting, Power Bi Desktop, DAX, Power Query editor, R).
Client: Tata Communications Ltd | Employer: Prompt Personnel Ltd Mumbai, India
Data Analyst (Consultant) Jan 2019-Dec 2020
Responsibilities:
Requirement gathering and Analysis of SLAs claim penalties with vendors during Outage case.
Communicate with all stakeholders on problem statements, possible solutions, intermediate issues and overall status of work
assigned.
Responsible for developing automated interactive visual reports with Microsoft Power Bi/Tableau.
Managing multiple priorities and meeting tight deadlines as per SLA s.
Worked extensively on Data visualization and Data analyzation using Power BI
Designing and Developing the Dashboard Reports in Power BI using DAX.
Automation of manual MS Excel tasks with Python using various python packages as per Requirements.
Implemented Email Automation for tracking SLA penalties to update files in a timely manner.
(Skills: Python, Power Bi Apps, Analytical Reporting, Power Bi Desktop, DAX, Power Query editor, R)
Employer: Eclerx Services Ltd Mumbai, India
Data Analyst Apr 2017-Jan 2019
Responsibilities:
Created Python based scripts which will Crawl / Parsed the website using beautiful soup and LXML packages.
Worked on several python packages like Numpy, pandas, lxml, beautifulsoup, urllib etc.
Responsible for handling adhoc requests and Data reporting to meet business needs.
Responsible for regular maintenance of Python and VBA Script to conduct daily Client Crawling activity.
Hands-on experience in SQL for uploading databases, creating tables. Joins etc
Experience of Automation- developing web-based automations using Python.
Design and develop Dashboards that give clear visibility of trends for important metrics.
Experience in creating VBA code (IGents) for data mining from various Retail websites.
(Skills: Python, Pandas, Numpy, SQL, Analytical Reporting, SQL, VBA, R)
Employer: R. K Projects Pune, India
Junior Software Developer Aug 2016-Mar 2017
Responsibilities:
Involved in analysis, design, development and implementation of this application.
Developed User Interface using HTML, JSP.
Developed Servlets for retrieving/updating the data from tables in the database.
Wrote PL/SQL stored procedures and triggers
Trained the users on using the software.
(Skills: Java, Html, Css, JSP, PL/SQL)
CERTIFICATIONS
Microsoft Certified : PL-300 Power BI Data Analyst.
Microsoft Certified : DP-900 Azure Data Fundamentals.
Participated in Big Data Hadoop Training Held in Sinhagad Institute, Pune.
Pursued Data Science ProDegree Certification in Python, R and Power BI from Genpact in Imarticus Learning.
|
