MIS Executive

Amol Bhailume

Email id: ************@*****.***

Contact No.: +91-966*******, 91-917*******

Career summary:

Having good experience with working on Power BI, Microsoft Advanced Excel and Intermediate in Micro excel. Have knowledge about E-commerce business process and orders, inventory and operational work. Always ready for the new challenge work to grow myself with the organization. Love to work and learn, where opportunity for innovation and enhancing my skills is available.

Educational Qualification:

Education

University

Institute

Year

Grade

BCA

Pune

D P College, Karjat.

2012

57%

HSC

Pune

S J School, Rashin.

2008

54%

SSC

Pune

S J School, Rashin.

2005

48%

Computer Knowledge:

Advance Excel

Power BI

SQL Server

Experience:

Organization Name : CandorWorks Private Limited.

Designation- : MIS Executive..

Duration- : 12th July 2021 to Current Date.

Role and Responsibilities:

Experience on Power BI (Desktop and Service) along with DAX.

Worked on the Power Bi Reports & Dashboards with SQL Server.

Used Table, Matrix, Bar, Card, Gauge, Slicers Visualizations.

Worked on Custom Visualizations like multi slicer and Hierarchy slicer.

Worked on DAX expressions like filters, Aggregate, Mathematical Functions etc.

Created New Calculated Column and Measure using DAX Expression.

Comfortable in working with filters/calculated columns/measures/relationships and transformations of Edit Query section.

Published/shared the reports by creating Content Pack/Sharing the pbix file.

Implemented Role Based Security as part of security in Power Bi.

Experience in Using multiple join statements to retrieve data from multiple tables.

Designed different types of reports like drill down, drill through, sub reports, parameterized reports.

Expert in removing the Duplicate (De-duplication) rows from a table and applying Fuzzy lookup in SSIS.

Prepared monthly status reports of delivery team.

Web research on the client requested data.

Excellent in MS Excel ( Hlookup, Vlookup, lookup, Pivot Table & PivotTable Chart, data validation & Scenarios).

Perform quality checks whenever required.

Ensure deliverables (Daily, Weekly & Monthly MIS Reports & Dashboard) are prepared to satisfy the project requirements cost and schedule.

Organization Name : Shiva Info Tech India Pvt Ltd.

Designation- : Data Specialist.

Duration- : November 2017 to June 2021.

Role and Responsibilities:

Various partner portal support and report handling.

EDI True commerce support – Acknowledgment, ASN submission.

E-commerce order entry in to the Sage ERP.

Analysis the Product price and create the report for the Marketing team.

Create product stock report by partners

Web research on the product.

Creating price difference sheet to find MAP violation Report.

Excellent in MS Excel ( Hlookup, Vlookup, lookup, Pivot Table & PivotTable Chart, data validation & Scenarios)

Ensure deliverables (Daily, Weekly & Monthly MIS Reports & Dashboard) are prepared to satisfy the project requirements cost and schedule

Data downloading, processing, cleaning and formatting (Using cleanup, Trim, Proper, Data Consolidate, Substitute etc formulae).

Publishing process related graphical presentation & reports for each and every team member and senior management.

Publish Hourly Production Report.

Organization Name : NovelVista Learning Solutions Pvt. Ltd. Baner, Pune.

Designation : Operations Executive

Duration : Jun 2014 to November 2017.

Role and Responsibilities:

Coordinating examination and assessment processes;

Supporting to the sales team, marketing team & management team.

Managing day to day processing of organization.

Handling Email Marketing, Data Research &Back office related work.

Handling queries of customer through mail and resolve them.

Maintaining branch records and MIS report.

Generate reports as requested by the sales team & Management team.

Good hands on with MS Word, MS Excel (Hlookup, -Vlookup, Match, Pivot Table, Chart & Data validation

Hobbies:

Listening to music.

Traveling, Swimming.

Strengths:

Positive attitude, Good listening ability and patience

Good analytical skills to understand and adopt domain knowledge.

Very good understanding of new technology and applications of any platform.

Good analytical and problem solving skills.

Personal Details:

Father name: Dattatray

Date of Birth: 29/11/1990

Gender: Male

Passport No: P2048972

Marital Status: Married

Languages Known: English, Hindi, Marathi.

Current Address: Chandan Nagar, Pune.

Declaration:

I hereby declare that the information furnished above is true to the best of my knowledge.

Thanking you

Mr. Amol Bhailume

Contact this candidate