Business Analyst

Anik Bandhu Das

*** ******* **. * ***********, ON M1J 2M1

905-***-**** ****.*****@*****.***

Retail Management

Financial Stewardship Financial Management Project Controllership

SUMMARY of SKILLS

. High-energy, self-directed professional with the ability to prioritize

and work effectively on multiple projects.

. Over six (6) years' experience designing, managing, auditing, and

maintaining data in a database management system.

. Expertise developing and writing process procedures for technical and

non-technical users.

. Proven track record creating databases, dashboards, metrics, pivot

tables, graphs, charts, and trend reports.

. Exceptional organizational, time-management and motivational skills,

consistently able to deliver top-quality results.

. Advanced Microsoft Excel skills: Visual Basic Application (VBA),

extracting data, performing data validation cleansing, and data

analysis. Create data models, charts, graphs, formulas, and pivot

tables.

Education & Awards

. Master of Business Administration, Finance, Goodman School of

Business, Brock University, St. Catharines, ON

. Bachelor of Business Administration, Finance & Accounting, Marketing,

North South University, Dhaka, Bangladesh

. Certificate in Administrative Studies, Brock University A.A.C.S.B

Accredited, St. Catharines, ON

. Investment Funds in Canada (IFC), Canadian Securities Institute (CSI),

Toronto, ON

Professional Experience

WALMART, Scarborough, ON Oct 2012 - Present

In Stock Analyst

. Use various software applications, such as spreadsheets, relational

databases, statistical packages, and graphics packages to assemble,

manipulate and format data and reports.

. Prepare monthly executive presentations that highlight the key drivers

of expense variances vs. the budget, prior forecast and prior months.

. Review costs and perform cost benefit analysis related to stock and

inventory.

. Research, collect information, and prepare reports for Team Leads and

Managers as requested.

. Track products saleability using key performance indicator (KPI) to

verify and track product expiry dates to maintain freshest product on

hand.

. Maximize inventory levels to order the right amount of right products

based on critical analysis of past sales and product demand to avoid

an out of stock or surplus situation.

. Train and mentor new employees according to organization procedures.

. Audit warehoused inventory daily to detect missing or stolen products

and help prevent loss.

Accomplishment

. Reduced inventory loss rate by 15%.

. Optimized inventory with perfect trend analysis.

. Saved $50,000 with product selection in meat department.

BROCK UNIVERSITY, St. Catharines, ON Sep 2012 - Jul 2014

Marker-Grader

. Coordinated a fair exam environment while maintaining academic

integrity.

. Submitted grades by deadline and uploaded to the university online

system.

. Analysed test performance to create solutions for students who

experienced difficulty and required further guidance to improve their

knowledge and comprehension.

Accomplishment

. Received Best Marker-Grader award for 2013.

. Reduced cheating on exams by 10%.

. Increased average student course grade from 70% to 75%.

MERCANTILE BANK, Dhaka, Bangladesh Sep 2009 - Jul 2011

Business Analyst

. Performed data mining to maintain data integrity in MS Access database

in support of e-business division.

. Provided support to controllership and forecasting functions related

to TPs and direct operating expenses in compliance with government

accounting and financial administration policies.

. Analyzed financial data and extracted and defined relevant

information; interpreted data for the purpose of determining past

financial performance and to project a financial probability.

. Budgeted operating expenses and performed comparative analysis of

operating expenses utilizing MS Excel.

. Data mined existing databases to generate statistics and metrics, and

entered that data for tracking and application management.

. Interpreted financial transactions and events for users to make

informed economic or business decisions.

. Maintained a working knowledge of laws and regulations to verify and

ensure documents were not only complete, but compliant.

. Excellent customer relationship management to close deals and build

business.

. Determined profitability through forecasting in Terms of Procurement &

Sales incorporating data analysis

Accomplishment

. Reduced operating expenses by 20%.

. Analysis of financial statements resulted in a 20% reduction of

errors.

. Increased annuals sales 15% by introducing two side businesses into

the main business.

MERCANTILE BANK, Dhaka, Bangladesh May 2009 - Aug 2009

Financial Analyst Intern

. Calculated liquidity, solvency and profitability ratios of the bank

for fiscal years 2009-2010 and analyzed ratios to determine trends

using Excel spreadsheet.

. Managed monthly branch expense reporting, finance, invoicing, and

purchasing.

. Determined best practice solutions aligned with business goals by

using extensive finance and accounting experience to analyze business

policies and processes.

. Proven ability to work independently as well as within a team

environment.

Accomplishment

. Modified the existing customer database by incorporating data tools

like lookups, pivot tables, which resulted in reducing the data

redundancy from 20% to 5%, establishing a strong customer base.

. Decreased customer complaints by 10%.

. Increased annuals sales by 15%.

Community Involvement

. Raised $4000 arranging a semi-formal charity for a cancer support

center

. MBA Games Participant, Goodman School of Business, Brock University,

2013

. Participant of Congeniality Award event in Business English Program

(2012)

. Active participant of first ever Elevator Pitch Competition, Goodman

School of Business

. Actively participated in the Brock University intramural volleyball &

soccer team events

. Fund raiser for Salvation army events

Contact this candidate