Prabha Nair
Senior Mis Analyst And Power BI Expert
Kalyan,MH
Summary
- Expertise in Advance Excel, End to end reporting in Power BI Fair understanding of ETL process, Data Modeling, DAX, Visualizations etc. Analytical and Problem-solving Mind-set Proficient in converting data into information (using Excel & Power BI) which can be used for decision making Real-time dashboard creation in Power BI service preparation of high-quality project deliverables that are valued by the business and present them in such a manner that they are easily understood by project stakeholders Convert analyses into actionable recommendations to drive decisions. Sum, Count, Concatenate, Sum if, Count if, Macros , Sales analysis Gained knowledge of PowerPoint Knowledge of Power Query, Power BI and Macros. An innovative professional with strong analytical, communication, Received Appreciation from Two Organizations Knowledge to create a simple Website, Google Analytics, Adwords , Supermetrics , Data Studio Handson Experience in all concepts regarding Excel Knowledge and Expertise in Relationships Database Management System concepts Understanding of Data Modelling Understanding of Primary Key, Foreign Key, and its concept Analyze Data Insights using Power Bi Handling Measures, Quick Measures, Dax formulas, Key indicator, Star Schema and Snowflake schema concepts in power bi Deep understanding of Relationship cardinality Certified in Power BI Certified in SQL fundamentals Certified in VBA Applications Expertise as Analyst Page 1 of 5 Data Cleaning using ETL tool such as Power Query Power BI Dashboard and Power BI Report Expert Understanding of Row level Security in Power BI Knowledge of Visualization Tools such as Data Studio and Power BI Understanding of Online Marketing What if analysis using Power BI
Overview
18
18
years of professional experience
20
20
years of post-secondary education
Work History
Senior Mis Analyst and Power BI Expert
NAVGRAHAA JEWELS PRIVATE LIMITED
Mumbai , maharashtra
2017.12 - 2019.12
- Established better quality reports, and simplification of Dashboard Procedures
- Working in E commerce Department: Reporting to E commerce head Working daily Sales and projection sales report in Navgrahaa Jewels Weekly, Monthly and periodical reports.
- Preparing Ad Words reports, Google Analytic's reports,
- Category wise, User wise, spend and profit Dashboard preparation. Implementation of VBA macros where and when required in report, Hands on experience on Power Query.
- Having in-depth knowledge of formulas, with Accurate perfection. Worked in Visualization Tools such as Data Studio, and Power BI Certified in SQL Fundamentals
- End to end reporting in Power BI
- Fair understanding of ETL process, Data Modeling, DAX, Visualizations etc.
- Analytical and Problem-solving Mind-set
- Proficient in converting data into information (using Excel & Power BI) which can be used for decision making
Management Information System Executive
Sanda Group (Division Eureka Supplements) Outbound
Mumbai , Maharashtra
2017.12 - 2019.12
- Data Mining: One of the key responsibilities is to perform data mining. Data mining helps the operations team to get the raw data and turn it into the prospective lead. This process is generally adopted for sales and marketing. By using data mining we can get a good amount of lead
Data Analysis: Analyses the reports
Shrinkage and Attrition Calculation as required by management Average Handling Time, Average Call Work, Average Talk Time Looking after sales analysis and sales dashboard
Allocation of associates Preparing master data - Handling all MIS queries
Preparation of Sodexo vouchers to employees Creating Purchase orders
Coordination with HR dept. for offer letters,
Maintaining Travelling expenses and arrangement of birthdays for employees Maintaining Leaves and Late mark - Implementing cost-saving initiatives that addressed long-standing problems
Sales Coordinator
Phillip Morris
Mumbai, India , India
2016.01 - 2017.03
- Coordinating with the different team and collecting the information on various activities
- Collating the information received from various teams and preparation of Miscellaneous MIS reports
- Other Ad-hoc requests on MIS activities.
- Coordinate sales team by managing schedules, filing important documents and communicating relevant information
- Interdepartmental coordination
- Regular follow up with Territory Sales Executive for various reports
- Handle the processing of all orders
Management Information System Executive
Moscow Agency
2015.01 - 2016.01
- Mumbai.
- Liaised and followed-up with different agencies with regards to pending payments.
- Accountable for preparation of MIS Report Dashboard regarding outstanding payments and to day-to-day presentations.
- Entrusted with the responsibility of coordination with the concerned manager with regards to different sales and purchase reports as well as maintained sales and purchase reports.
- Responsible for extracting ad-hoc reports with regards to sales made by a different sales representative.
- Examined different customer reports and the progress of sales.
Executive
Tata Chemicals Ltd
2013.03 - 2014.12
- Preparing daily / fortnightly / monthly MIS.
- Preparation of Primary Consolidation for both Primary Sales and Secondary Sales once in a Month and updating the figures as and when required by HOD.
- Handling New distributor Files and Co-ordaining with concerned officials for creating SAP CODE.
- Co-ordination with Accounts dept.and ZSMs as and when required for various MIS reports.
- Extracting Reports from SAP as and when required for various MIS purposes.
- Interacting with Sampark team and giving feedback to them for Enhancement of the Sampark software, which will further help them to give better services.
- Preparation of MIS report for a better analytical view of Sales figures which gives better overview to concerned Departmental Head.
- Assisting the Sr.Manager (Sales Operation) and National Sales Manager on the following aspects: Daily preparation of MIS formats and Changes as per the requirement.
- Daily Sales Dashboard Preparation Preparing MOM’s and Powerpoint Presentation of concall meetings with Sampark team also daily upgrading it.
- Daily Follow-ups with ZSM’s for various and Consolidation of different MIS report as per requirement.
- Page 4 of 5 Consolidation of Rolling Sales Plan every month.
- Consolidation of Travel Plan every month.
- Updating Stock Statement as and when required.
- Preparing Reports and Dashboards instructed by HOD.
- Analysis of Sales figures (Primary and Secondary).
- Emphasis on certain aspects of reports which is required by Management.
- Preparing Powerpoint Presentations as and when required.
Management Information System Assistant
Myco Polycom pvt ltd
Mumbai, India , India
2003.03 - 2012.12
- Preparing Dashboards for all Brands Preparing Various type of Reports such as Area manager, Region and Store wise report Expense management Interaction with Banks Assisting Management for Dashboard and Reports .
Education
High School Diploma -
SICES High School
Ambernath 1982.03 - 1997.03
Bachelor of Commerce -
RKT College
Ulhasnagar 1997.04 - 2002.03
Skills
Microsoft Power BI
Websites
Timeline
Management Information System Executive
Sanda Group (Division Eureka Supplements) Outbound
2017.12 - 2019.12
Senior Mis Analyst and Power BI Expert
NAVGRAHAA JEWELS PRIVATE LIMITED
2017.12 - 2019.12
Sales Coordinator
Phillip Morris
2016.01 - 2017.03
Management Information System Executive
Moscow Agency
2015.01 - 2016.01
Executive
Tata Chemicals Ltd
2013.03 - 2014.12
Management Information System Assistant
Myco Polycom pvt ltd
2003.03 - 2012.12
Bachelor of Commerce -
RKT College
1997.04 - 2002.03
High School Diploma -
SICES High School
1982.03 - 1997.03
Similar Profiles
Jitendra Kumar SolankiJitendra Kumar Solanki
Diamond Buyer Specialist at ODI Jewels Private LimitedDiamond Buyer Specialist at ODI Jewels Private Limited
KANCHAN PATHAKKANCHAN PATHAK
HR Executive at Indera Textiles (Indera Jewels Private Limited)HR Executive at Indera Textiles (Indera Jewels Private Limited)
KULDEEP CHAUHANKULDEEP CHAUHAN
ACCOUNT MANAGER at R O Jewels LimitedACCOUNT MANAGER at R O Jewels Limited