SUMMARY

• Highly analytical and detail - oriented data analyst with strong experience in and knowledge of database types and research methods.
• Over 8+ years of experience examining and interpreting data to drive growth for companies and clients.
• Utilized SQL Server, Power BI, Tableau, Jet reporting and Excel to analyze and solve large data sets to support business decisions.

TECHNICAL SKILLS

• Power BI
• Tableau
• Jet Report
• Jira
• Python
• DAX language
• SQL
• Detail Oriented
• Data Analysis
• Data Modeling
• Decision-Making Skills
• Reporting
• Data Visualization
• Interpersonal Skills
• Process Improvement
• Time Management
• Project Management
• Agile Methodology

PROFESSIONAL EXPERIENCE

Confidential

Senior Data Analyst

Responsibilities:

• Developed and implemented data collection and data analytics best practices that optimized efficiency and quality.
• Extracted raw data from various data sources and aggregate it into cohesive and accurate datasets via ETL process.
• Responsible to identify, analyze, and interpret trends or patterns in complex data sets and develop graphs, reports, and presentations of results to stakeholders.
• Developed, Deployed, and managed Power BI dashboards to visualize core business KPI’s saving 10 hours per week of work manual reporting work.
• Scheduled the monthly/weekly/daily reports by automating and reduced the manual effort by 95%.
• Developed complex SQL queries using stored procedures to support Power BI and SSRS reports.
• Advanced complex calculated measures using DAX language.
• Utilized Jira board to keep track of projects and work.

Confidential

Business Analyst

Responsibilities:

• Maintained and enhanced the operational relations with suppliers and contributed to the competitiveness of business by optimizing purchases within the respective entity.
• Developed and managed numerous supply chain KPI's including freight cost rate, fuel surcharge, order tracking, forecast volume, various inventory reports, backorders, internal customer service report using SQL etc.
• Collaborated with external/internal stakeholders to set the reporting expectations and perform executive ad-hoc reporting.
• Responsible for managing inventory, cost, and efficiency of the movement of goods in both Canadian and U.S. locations.
• Reduced the processing time for monthly reports by 55% with 12 improved reporting tolls and automation.
• Analyzed demand metrics to optimize demand andsupplyplanning, and leverage data to forecast sales and inventory movement using SQL and Power BI.
• Increased fill rate with our top customer by ~5% after the first year while maintaining a consistent level of inventory investment
• Participated in inventory analysis, reconciliation, and adjustments which resulted in 95% accuracy

Confidential

Senior Data Analyst

Responsibilities:

• Worked collaboratively with the sales department and ensured audits for finance and operational review.
• Created Sales Transactions and Purchase Transactions for multiple vendors and sales department for the available stock and equipment needed for future projects using IQ Reseller Database.
• Maintained strong vendor relationships, negotiating pricing and terms resulting in lower investment and longer payment terms.
• Given convenient and exact data and announcements for reviews/stocktaking and on-location check.
• Monitored monthly Purchase Price Variance reports and took necessary action as required.
• Forecasted inventory requirements, assessing risks, and purchasing inventory which significantly reduce carrying costs, capital investment in inventory costs.
• Created matrix to monitor daily incoming and outgoing activities, which improved inventory integrity by 40% and resulted in 80% inventory accuracy.
• Established on-going communication with warehouse personnel to identify and manage slow-moving inventory. This resulted in a 30% reduction in obsolete stock.
• Provided inventory analysis to the sales and operations team with information to maximize sales and profit.

Confidential

Inventory Reporting Specialist

Responsibilities:

• Extracted and organized large-scale raw datasets from different sources, distilled the validdatafor in-depthdataanalysis using SQL.
• Participated in monthly financial reports, forecasting reports, and reduced time spent on inventory by 20% by reorganizing the physical storage of supplies.
• Supervised and coordinated the appropriate processing of production planning, shipping, and receiving of raw materials and maintaining accurate inventory levels promptly.
• Reduced inventory levels monitored and adjusted safety stock of slow-moving, obsolete materials, and aged inventories.
• Maintained and implemented reports for Production (raw materials) and Demand (Finished Goods) including the Work in Progress material using Microsoft Dynamics NAV.
• Reviewed and evaluated KPI achievements by generating reports weekly and monthly to internal departments within the organization using Tableau.

Confidential

Retail Supervisor

Responsibilities:

• Planned, organized, directed, controlled, and evaluated the operations ofthe inventory and retail department providing administrative support and strategic stock analysis.
• Worked collaboratively with GM, Inventory Manager, Buyer, and vendors to create positive outcomes that foster, developed, and grew our business relationship in future needs.
• Consistently worked with the sales department for promotions, product requirements to satisfy customer needs on time.
• Coordinated effectively to make changes for the on-demand product changes to manage the inventory.
• Managed warehouse and inventory management including item budgets, reducing overstock, responding to inquiries for inventory control using Microsoft dynamics NAV and Electronic Scanning Devices.
• Maintained company reports &records on top sales for daily/week/monthly crystal reports using SAP Business Objects for the available inventory in the warehouse.