Data Management Power Bi

Md.Salim Ansari

Kannur,

State Beach Resort

E: ******.**********@*****.*** T: +91-639*******

Professional Summary

I am Bachelor of Commerce Graduate 11years plus experience with Administrative Asst. Specialty in good knowledge in Data Analytics, Data management, MIS skills. Seeking a position as Power BI/ Tableau Developer leverage organizational and research skills to support internal and external communication.

Skills

Excellent written and verbal communications skills, including dealing with customer complaints politely.

Proficient in all Microsoft Office applications, Oracle PeopleSoft, Advance Excel, PPT etc.

Data analysis with Excel & Dashboard Reporting, Data Management, Data Visualization Software like Tableau & Power BI Developer & Problem -Solving Skills, Team working & Delegation.

Adept in technology, time management according to organization, Cost & Reports Analysis.

Data Analysis like Business, Finance, Sales, Marketing, Performance etc.

Performing a variety of roles, including payroll support, billing, strategic planning & statistics. Professional Experience

Currently working in State Beach Resort Unit of Payyambalam Beach Resort as a Cost

& Reports Analyst in Kannur (Kerala). From 01st FEB 2023

Verify purchase prices of all day to day kitchen items and compare market or standard price.

Verify the purchaser dept. Make vendor quotations for high value items

All revenue invoices including rooms & SPA, Shops, mini bars etc. to be vouch and cross verify its deposits into bank on daily basis .audit check bank deposit / credit card slips with bills

Verify and audit check all housekeeping cleaning chemicals, toiletries, laundry chemicals etc. allocated on each room cost or total daily rooms cost

Daily cost of guest breakfast to allocate in room cost

Perpetual inventory stock taking to be carried out random basis through stores & accounts dept. and with other staff assistance and verify and report stock variance

Daily material consumed vs. sales. Daily purchase vs. sales

Daily purchase vs. consumption. Daily wastage. Month end report will be elaborate

Etc. some quick capsule report daily. Also any banquet cost immediately provide

Many cases daily food cost reports are preparing.

Able to effectively control the Food & Beverage Cost.

Control the Food and Beverage outlets in terms of wastage, pilferage and efficiency.

Prepare variance analysis for food & beverage and communicating with relevant parties.

Update and maintain receipts into the systems (FMC).

Check and verify voids in the POS systems.

Check and verify discounts on the POS systems.

Check and verify all complimentary sales in POS systems.

Check and verify all staff meals and staff discounts.

Check and verify all Package meals.

Check and verify all settlements done on the POS system.

Check and cross verify if all sales have been transferred correctly to the PMS.

Check and verify for any lost postings.

Check the cost of sales in all F&B outlets and ensure that the costs are within budget.

Check the menu pricing on the POS systems and ensure the correct prices are loaded.

Check the restaurant and bar checks on daily.

Check the complimentary and confirm that all are approved.

Daily Import of Micros Sales to Materials Control system.

Tally all end of shift reports generated from all POS tills.

Continuously study weaknesses in F&B control implemented at the Hotel and provide suggestions for improvements.

Check the daily Food & Beverage revenues report submitted by the income audit for the accuracy of covers and average check.

Responsible for linking the articles and Recipes in Material Control.

Responsible for preparing daily Food and Beverage Report and distribute to management.

Responsible for monthly F&B Report and distribute to management.

Responsible for surprise spot checks at all F&B outlets.

Prepare Duty Drinks and management report and confirm that this is as per entitlement.

Prepare the daily and monthly cost report department in relation to cost of sales.

Prepare daily staff meal cost report. Participate in stock taking at the restaurants.

Spot check on the receiving department to ensure that the scales are correct and goods are checked for quality.

10 Months Exp. Tulsi Hospitality LLP as a Cost & Reports Analyst in Hyderabad. From 25th Mar 2022

The role of a cost analyst is to examine and manage the expenses of a company. These highly- analytical specialists study a company's costs and report analysis to management. Their main tasks include tracking project budgets, establishing product costs, and analyzing changes in company costs.

Collecting and analyzing financial data

Estimating costs and comparing budgets with actual expenses

Determine standard costs and investigate variances with actual costs

Help management make important decisions based on costs and benefits (e.g. investments, market growth, pricing changes) and Create and manage budgets, and monitor spending

Conduct audits on financial processes and transactions

Monitor changes in processes or methods to calculate effects on overall costs

Forecast and analyze costs of processes, labor and inventory 1.5 Yrs. Exp. in Midland Credit Management an encore capital group company as a Data Analytics in Gurgaon. From 20th Feb 2020

Encore Capital Group, Inc., through its subsidiaries, is a specialty finance company providing debt recovery solutions for consumers and property owners across a range of financial assets. The Company operates through Portfolio Purchasing and Recovery segment. The Company's geographical segments include the United States, Europe and other.

Using automated tools to extract data from primary and secondary sources

Removing corrupted data and fixing coding errors and related problems

Developing and maintaining databases, data systems – reorganizing data in a readable format

Performing analysis to assess quality and meaning of data

Filter Data by reviewing reports and performance indicators to identify and correct code problems

Generate reports and dashboard using data and analysis of data.

Analyzing local, national, and global trends that impact both the organization and the industry

Preparing reports for the management stating trends, patterns, and predictions using relevant data

Preparing final analysis reports for the stakeholders to understand the data-analysis steps, enabling them to take important decisions based on various facts and trends Kuwait Food Company as an Administrative Assistant in Kuwait. 2015-2019

Administrative assistant interns in office management procedures and schedule on-the-job mentoring with multiple departments.

To file and retrieve official documents, records, and reports & to maintain records management systems.

Created a new system for following up with potential clients in an efficient and effective manner.

Handling office tasks, such as filing, generating reports and presentations, setting up for meetings, and reordering supplies.

Maintain polite and professional communication via phone, e-mail, and mail. Chhatra Shakti Construction Company Pvt.Ltd as a MIS Executive in Luck now. 2013-2015

MIS Report generation & Database Management.

Analysis of monthly / weekly spends and revenue data, identifying the issues and the errors and work with the team to solve for them

Maintain reports & spreadsheets for historical data, manage email requests

Work closely with Operations for daily, weekly & monthly reports

Provide insights on existing data to internal/external stakeholders

Ability to validate and identify issues on vendor related pay-outs

Extracting of data into spreadsheet and preparing monthly consolidation of accounts using analytical and excellent spreadsheet skills

Preparation of monthly Financial MIS (Daily / Weekly / Monthly / Quarterly / Annual)

Creation of multiple Excel based Dashboards for Reporting and analysis of Finances/Revenue/Payments

Analytical monthly variance reports comparing Budgets vs Actuals and apply analytical reasoning skills to identify reasons for variances

Provide insights on existing data to internal/external stakeholders

Superior analytical skills practiced at drilling down to transaction/ workflow details Soft Age Information Technology as a MIS in Ballia. 2011-2013

Develop strategic plans and information systems. Maintaining, managing, and updating software.

Evaluate and improve information processes and perform data checks.

Generate and distribute management reports in accurate and timely manner.

Provide customer support and assistance in issue troubleshooting and resolution.

Perform data analysis for generating reports on periodic basis.

Provide strong reporting and analytical information support to management team.

Develop and implement strategies to achieve organizational goals Mirah Group as a Cashier cum Accounts in Bangalore. 2010-2011

Customers to create orders, resolve issues, initiate refunds, and modify account information.

Listened calmly to complaints and resolved issues in a professional and accommodating manner.

Receive payment by cash, check, credit cards, vouchers, or automatic debits.

Issue receipts, refunds, credits, or change due to customers.

Count money in cash drawers at the beginning of shifts to ensure that amounts are correct and that there is adequate change. Compute and record totals of transactions.

Calculate total payments received during a time period, and reconcile this with total sales. Education

Distance Education MBA with Data Analytics from Symbiosis. 2018

Bachelor of Commerce Estimated Graduation Summer 2009

From Veer Bahadur Singh Purvanchal University Jaunpur

Passed 12th from UP Board in 2005

Passed 10th from UP Board in 2003

DFA- Diploma in Financial Accounting

TALLY 9.0 (VAT (VALUE ADDED TAX), SERVICE TAX

TDS (TAX DEDUCTED ON SERVICE), FBT (FRINGE BENEFIT TAX)

TCS (TAX COLLECTED ON SERVICE), PAYROLL ETC.

Certification

Learn Exploratory Data Analysis in completed by Coursera.

Data Analysis with Excel, Power BI completed by Edu nix Learning Solution. Computer IT Skills:

Advance MS-Excel=Pivot Table, V-Lookup, Conditional Formatting, What If Analysis, Data Validation.

MS Access, Power Point, HTML, Micro Soft Power Business Intelligence, Python Beginner Language.

My SQL, Tableau & Power BI Developer etc.

Hobbies and Interests

Enjoy with listening Music & Play Badminton.

Area of Specialization: Data Analysis in Excel & MIS Report, Data Visualization Reports. Personal Skills &Strength:

Inter-personal & Communication skills

Computer handling skill.

Self- motivated patient cheerful with surplus enthusiasm

Capable of doing job well and can work under demanding environment.

Self-confidence and efficiency in my work are my core strength.

Fast learner and hard worker, set my standards beyond company expectation.

Team work, creativity, dedicated, trustworthy.

PERSONAL DATA

Father’s Name : MD. MUSHTAQUE

Date of Birth : 1 AUG 1988

Nationality : Indian

Marital Status : Single

Languages known : Hindi, English

Passport No

Pan Card No

:

:

V0384254

CWNPS4157F

Place

Date (Md. Salim Ansari)

Contact this candidate