BAL MUKUND SHUKLA

Present Address: Shri Krishna Apartment Flat no.A403 Plot no.135 Sec-13 Kharghar 410210

Mobile no.: 986-***-****

Email Id: adgmgl@r.postjobfree.com

OBJECTIVE

Self-motivated data analyst has excellent organizational skills, highly efficient and proactive actionable taker. Has extensive experience in tableau and advanced excel. Able to play a key role in analyzing problems and come up with creative solutions as well as producing methodologies and files for effective data management. A quick learner who can absorb new ideas and can communicate clearly and effectively.

AREAS OF EXPERTISE

Advanced excel

Tableau 10.3

Telecommunications

MS Word

Project Management

MS Access

Corporate Email

MS Outlook

Data Analysis

Power Point

Dash Board

Team management

SIGNIFICANT ACHIEVEMENTS

Successfully implemented idea for development of macro to work done fast with 100 % Quality.

Received BPI Certificate for business process improvement.

Received Business analyst with excel Certificate from Simplilearn

Received quartly Spot Award for excellent work.

Provided Trainings to Subordinates and play vital role in process transition.

Received appreciation mails from Client for quick resolutions.

ACADEMIC QUALIFICATION

PGDBA Diploma, OPERATIONS, University of N.L. Welingkar Mumbai.

B.Sc. Degree in Maths V.B.S. Purvanchal University Jaunpur .

S.Sc. In Science from U.P. Board Allahabad.

PROFESSIONAL QUALIFICATION

Business analyst with excel Certificate from Simplilearn.

Key Skill: MS Office, Basic SQL, Tableau 10.3, Visual Basic Macro, Dashboard.

CURRENT EMPLOYEMNENT

ECU Worldwide (Business planning and Analysis) as Sr. Executive From 14thJan 2019 to Till date.

Corporate Account Reporting project handling on monthly basis.

Preparing Monthly reports for 65 Corporate clients

Preparing MOM and YOY region to region and country to Country, Port wise and Tradelane volumes report reports.

Providing Statistics to the CEO’s and RCEO’s to identify needs and trends in the business.

Responsible to develop various KPI reports to update management on production status.

Understand the trend of business and analyze the reasons of growth and diminution of business.

Preparing user-friendly reports of 93 offices all over world including the Volumes and profit report and productivity reports.

Interaction with internal and external clients and KAM team across the Globe.

Preparing segment wise YOY Profitability & Volumes reports and Actual vs Budget Analysis.

Trade Lane analysis report on monthly basis to Management.

Maintenance of historical data in analytical manner from which recommended information can be obtained easily.

Preparing the different Dashboard for Clients and Key accounts managers.

Optimal use of MS Excel to prepare standard formats to simplify generation of reports & analysis.

Analyzing, investigating and preparing presentations for senior management on key movements and trends in the financial statements compared to previous years and Recommend action plan in line with the analysis

Perform analysis with transactional data from the company and industry to generate insights on profitability by Region, Office, Tradelanes, and Customers.

Assessment of key performance indicators (KPIs) and provide recommendations for improvement areas

Champion continuous business process improvement initiatives in the planning process

Designing and implementing BI dashboards with the help of Vendors/IT Team to review company’s performance for operational & financial dimensions. Directing the automation of these dashboards to reduce time to insight & increase accuracy of reporting process

To liaison with various internal stakeholders for accurate and timely reporting

Other analysis as requested by senior management on time to time basis.

Precious Employment

Yes Bank Ltd (MIS & Analytics) from 23rd Oct 2017 to–9th Jan 2019.

Working for Yes Bank in liabilities Product management Team on Kelly services payroll.

Skills in SQL development and Tableau reports

Preparing Billing report for Current account Fee and charges

Great expertise in processing data and flowcharting techniques

Preparing Business Update report & Financial report for senior managers

Weekly, Monthly & Daily reports for tracking new business sourcing & activation

Presenting decision tree using predictive analysis to senior management.

Preparing annual budget and sales incentive plan analysing trends and facts

Synchronization of reports in tableau and publishing reports and history in tableau

Quantitative and Qualitative analysis of organizations business data for effective planning and productive execution.

Effective dashboards, especially on lead measures eg productivity and claims analysis

Simulation of charges for current account customer.

Preparing Branch wise business reports and CA LPM Report daily, weekly and

Monthly.

Performing Cash abuse analysis across PAN India Branches.

Dynamic tier review for product upgrade and downgrade.

Simulation of charges analysis

MoM customers transaction dump analysis.

eClerx Services Ltd as Senior Analyst from 21st Apr 2011 to– 18th Oct 2017

Maintain the guidelines on websites which was provided by client follow-up with stakeholders regarding Webpages issues across the region I.e. APJ, EMEA and AMER and also prepared the Weekly and Monthly MIS report, weekly Deck and QBR for Client.

Produce and distribute monthly Service management SLA reports as per schedules.

Produce and distribute daily, weekly and monthly internal Incident, Problem & Change reports and dashboards for the Service Lines.

Provide documentation to support reported results (SOP, CLPM and FMEA).

Mentoring new associates

Conduct research and analysis of reporting data and rectify issues raised about reports under management.

Periodically reviews the usefulness of reports produced and provides suggestions for improvement for automation.

Understanding client requirement.

Solely responsible for Monitoring Reporting Mailbox.

Monitoring automated reports due everyday

Providing timely response to report requestor.

Generating ad-hoc reports when requested by the requestor.

Informing requestor on the progress of their report request.

Audit all internal MIS reports before they are sent to client

Creating macro at beginner level, recording macro & learning in order to fulfill the client requirement.

Monitoring price and discount of client system, also check for coupon discount applicable.

Preparing weekly Deck to be discussed for client call.

Preparing report and send it to different Error owner and POC’s.

Involved in working with various teams for web page development, Pricing analytics, Rebates, Promotions and search optimization

Interfaced with clients on a regular basis to understand their requirements and identified solutions

Implemented client requested changes, on their e-Commerce websites using special tools provided by them

Reliance BPO PVT Ltd 29th Mar 2010 to 20th Apr, 2011 as Executive

Resolving the Billing disputes of Corporate Customers pertaining to Wrong Tariff Plan allotted.

Rectifying the tariff plan and updating the correct Tariff plan in billing system ADC.

Coordinating with Circle Corporate Customer desks for resolving Billing disputes of corporate customers.

Preparing MIS reports of the total SR Raised, resolved and ageing analysis.

Teletech Services Ltd 15th Oct, 2007 to 20th Apr, 2009 as Executive

To take calls of prepaid and Postpaid Airtel Rajasthan circle customers and resolving their query in the best possible time.

Acting as a link between customer service desk and documentation.

To constantly interact with CSR of different circle to provide prompt resolution to customer query.

Personal Information:

Date of birth : 15th AUGUST 1985.

Sex : Male

Marital status : Married

Nationality : Indian

Languages known : English, Hindi

Thanks

Regards

Balmukund Shukla

Contact this candidate