Balram Pawar
Senior Consultant BI
Indore
Summary
Thorough Senior Consultant professional with competency in developing project and implementation plans. Gifted with strong analytical and project management skills. Successful in meeting new challenges and finding effective solutions.
Overview
10
10
years of professional experience
7
7
years of post-secondary education
10
10
Certifications
Work History
Sr. Consultant -BI
Infosys Limited
2022.05 - Current
- Creating reports and dashboards in Power BI and Tableau.
- Working on Deployment Pipeline of Power Bi.
- Working on ADF Pipeline.
- Provide Technical supporting to team.
- Communicating directly with client and working on delivery of the project.
- Connecting with MS Team to find workaround for some of the features.
- Participating in Interview as Panelist.
- Working on Data modeling using SAP Power designer tool.
- Working on Power Bi report builder to create the Paginated reports.
- Evaluated existing business processes, recommending improvements that led to increased operational efficiency.
- Mentored junior consultants, helping them enhance their skills and contribute more effectively to projects.
- Implemented data-driven approaches for assessing project success, continuously refining processes based on insights gained over time.
- Increased client satisfaction by providing tailored consulting services and effective problem-solving strategies.
- Streamlined project management processes, improving efficiency and reducing overall costs.
Sr. Systems Analyst
Speridian Technologies
2021.05 - 2022.05
- Creating reports and dashboards in Power BI and Tableau.
- Working with Power BI pro and Premium Per User.
- Designing Power Bi report with help of Power Point.
- Working Knowledge of Dataflow and Automate Power Bi reports.
- Managing ETL flows and Preparing RCA documents.
- Participating in Presales (POC) activities.
- Work on performance tuning of flows to improve execution performance of flows.
- Collecting business requirements from internal and external stockholders.
- Preparation of SOP for all projects and Preparation of checklist for QC.
- Create project plan and prepare Business requirement documents.
- Database Management and Data Modeling, Data Cleaning, Data Preparing.
- Managing and creating Row Level Security in Power BI Reports
- Writing DAX for creating explicit measures.
- Optimization of reports and Dashboards to improve performance of file.
- Help to Architecture team to design cubes and Views and Aggregation tables for reports.
- Configuration & Managing Data Gateway for data refreshing.
- Participate as interview Panelist at L2 level.
Business Intelligence Analyst
Decimal Points Analytics Nasik
2019.06 - 2021.05
- Creating reports and dashboards in Power BI and Tableau.
- Writing ETL flow in Pentaho data integration and Managing ETL flows.
- Work on performance tuning of flows to improve execution performance of flows.
- Established strong relationships with key stakeholders across organization, fostering collaboration on data-driven initiatives.
- Collecting business requirements from internal and external stockholders.
- Streamlined report generation processes by automating routine tasks using ETL tools.
- Understanding all business logics and help to ETL team to design warehouse solution.
- Create and leverage analytically approaches to perform analysis of domain-specific source data to provide accurate statements and conclusions.
- Preparation of Weekly MIS and Preparation of SOP for all projects.
- Create project plan and prepare Business requirement documents.
- Preparation of checklist for QC and Preparation of understanding documents.
- Identifies opportunities to better enhance reporting solutions easing user experience and increasing adoption.
- Develop dashboards and visualizations that empower decision-makers Build, customize, and publish interactive reports, visualizations, and dashboards using Power BI and Tableau.
- Database Management and Data Modeling, Data Cleaning, Data Preparing.
- Managing and creating Row Level Security in Power BI Reports
- Good understanding of data models - relational, stars schema, snowflake schema, Galaxy schema and OLAP as they pertain to data sources in reporting solutions.
- Writing DAX for creating explicit measures
- Optimization of reports and Dashboards to improve performance of file.
- Help to architecture team to implanting data warehouse.
- Help to Architecture team to design cubes and Views and Aggregation tables for reports.
- Converting wireframe to beautiful dashboard.
- Provided technical support for troubleshooting analytics and reporting issues.
- Developed complex dashboard and reporting tools to track business performance metrics.
Sr. Associate
WNS global service Limited Nasik
2013.11 - 2019.05
- Collaborated with business users, understood, and delivered their reporting needs.
- Prepare business SOP for each project and process.
- Worked as HR SPOC.
- Performed QC and Prepared RCA documents.
- Creation of Bill of lading for custom clearance.
- End to end handing flow of data processing, communicate with all stockholders through emails and calls.
- Communicated effectively in both verbal and written manner to client and offshore team.
- Converted business requirements into specification documents.
- Keep track of invoices and prepare necessary reports.
- To build rapport and trust quickly with work colleagues.
- Maintaining TAT of all data based on priority, urgent task.
- Defined work plans in alignment with stakeholder requirements.
- Analyzed customer data to identify trends and anticipate customer needs.
Education
Bachelor of Engineering - Computer Science
Shree Dada Ji Institue of Technology And Science
Khandwa 2008.06 - 2012.06
Higher Secondary - PCM
Government Excellence Higher Secondary School
Harsud 2006.06 - 2008.05
High School -
Government Excellence Higher Secondary School
Harsud 2005.05 - 2006.06
Skills
Power BI
undefinedCertification
Microsoft certified Data Analyst (PL -300) 2023
Personal Information
- Father's Name: Mr. Jaswant Singh Pawar
- Mother's Name: Mrs. Radha bai Pawar
- Nationality: Indian
- Marital Status: Married
Projects
1- USCM Capital Reporting (RBC) :-
Role:- Sr. consultant and Team Lead, Working on Database documentation, Analyzing the information shred by client., Working on creating Data model in SAP Power designed tool., Working on creating Paginated reports in Power Bi report builder. ADF Pipeline and Jira ticket. Helping and monitoring team and guiding them how to use best practices for development.
2- E-Learning System (BHP):-
Role:- Sr. consultant and Team Lead, Working on Database documentation, Analyzing the information shred by client., Working on creating Data model in SAP Power designed tool., Working on creating Paginated reports in Power Bi report builder., Helping and monitoring team and guiding them how to use best practices for development.
3-Tableau to Power BI Migration Project:-
Role-Business intelligence analyst and Team Lead and Sr Power Bi developer, Preparation of all business documents, Data cleaning in Query Editor, Created Data Model, creating dataflow, managing team, managing complete project, Interacting with Client, and other stakeholder to deliver the report on time Developed the BI dashboard using Power BI., Creating list of challenges/ limitation while migrating reports.
4- Panasonic Pilot Project: Panasonic India.
Role & Responsibility:- Business intelligence analyst and Team Lead and Sr Power Bi developer, Preparation of all business documents, Data cleaning in Query Editor, Created Data Model, Developed the BI dashboard using Power BI., Working closely with Panasonic team to update/modify/New Requirement.
5- Inventory Management (Appraisal and Liquidation): Tiger Group
Role and Responsibilities:- Business intelligence analyst and Team Lead, Prepared all business documents, Data cleaning, Written the ETL Flow in Pentaho, Developed the BI dashboard using Power BI and Tableau and working the architecture team to design the warehouse in snowflake., Managed the deal flow on daily basis.
6- PE deal Analysis: HIG capital
Role and responsibilities:- Business intelligence Analyst, Preparation of all business documents, Development of BI dashboard in Power BI, Data structure understanding and Data cleaning.
7- Time pulse Management:
DPA internal Project Role: Business intelligence Analyst Task: Development of BI dashboard in Power BI, Data structure understanding and Data cleaning, documentation.
8- Share Class Analysis: Quote Media
Role: Business intelligence Analyst Task: Requirement gathering, development of BI dashboard in Power BI, Data structure understanding and Data cleaning, help to create Database, migrate the DB to AWS
Training
- BSNL Khandwa 15 days
- Training in Bhusawal Signaling Office - Router, Switches, Bridges & Panels 15 days
Timeline
Sr. Consultant -BI
Infosys Limited
2022.05 - Current
Sr. Systems Analyst
Speridian Technologies
2021.05 - 2022.05
Business Intelligence Analyst
Decimal Points Analytics Nasik
2019.06 - 2021.05
Sr. Associate
WNS global service Limited Nasik
2013.11 - 2019.05
Bachelor of Engineering - Computer Science
Shree Dada Ji Institue of Technology And Science
2008.06 - 2012.06
Higher Secondary - PCM
Government Excellence Higher Secondary School
2006.06 - 2008.05
High School -
Government Excellence Higher Secondary School
2005.05 - 2006.06
Microsoft certified Data Analyst (PL -300) 2023
Microsoft Associate Data Engineer DP 203 (2021)
Python data science certification from Intellipaat online (2019)
Certification of Completion (Udemy):
1. Business Analysis fundamentals
2. Business intelligence Analyst advance
3. Power BI basics and Advance using DAX functions.
4. ETL development using Pentaho data integration.
5. Data visualization using Tableau.
6. Azure Data Factory.
Similar Profiles
Ashish RaviAshish Ravi
Senior Associate Consultant at Infosys LimitedSenior Associate Consultant at Infosys Limited
DATLA BVSPRC RAJUDATLA BVSPRC RAJU
SENIOR CONSULTANT at Infosys LimitedSENIOR CONSULTANT at Infosys Limited
Rachal Sajjan RajRachal Sajjan Raj
QA Lead/Sr. Test Engineer at Infosys LimitedQA Lead/Sr. Test Engineer at Infosys Limited