Data Manager

Location:

Posted:

April 16, 2019

Resume:

PROFESSIONAL SUMMARY

Business Analytics consultant with intellectual curiosity, and the ability to mine hidden gems located within large sets of structured, semi- structured and raw data.

Pursuing Data Analytics at the University of Toronto, with a B.Tech to leverage my background in applied statistics, interpreting the business applications of predictive analytics and statistics, and in designing and executing technical solutions.

5 years of experience in Data warehousing, Data modelling, Data Integration, Data Migration, Business Intelligence for Health Care and Retail (ecommerce)

Over 4 years experience in both ETL and business intelligence. Tools include, Microsoft Integration Service (SSIS) Decision Stream/Data Manager, Cognos 8.x

Experience in developing BI applications utilizing Excel, VBA, Python, SQL, Power BI, and Tableau

Excellent technical and analytical skills with clear understanding of design goals of Entity Relational (ER) modeling for OLTP and dimension modeling for OLAP

Business Analysis Skills including in depth knowledge of Software Development Life Cycle (SDLC), having thorough understanding of various phases like Requirements, Analysis/Design, Development and Testing

Technical Skills

Data Management

Database Design & Management, Data Quality Assessment, Data Analysis, Pattern & Trend Identification, Visualization of Data Insight

Data Visualization Tools

Tableau, Power BI, SSRS, Excel

Portal Technologies

SharePoint, Project Server

Databases

SQL, NoSQL, MySQL, MongoDB,

Programming

Python, Visual Basic for Applications (VBA)

Accomplishments:

•Designed and built statistical analysis models on large data sets (Teradata) that helped increase online sales (up to 25% overall) and lowered cart-resolution by 23%

•Consolidated data, developed operations and procedures, resulting in workflow improvement by 18%

•Introduced automation, engineering changes and materials substitutions which resulted in production increase by 39%

•Developed supply chain process improvement plans which resulted in cost savings, and process efficiency gains worth CAD$2.6 million annually

•Developed and executed plan that reduced inventory by $50K in 6 months on a key product line

•Spearheaded development of "New Data Entry System", resulting in an increase of operational efficiency by 20%

•Reduced inventory by 54% with the help of tool developed and JIT methedology for the same amount of production and resources

Professional Experience:

Company: Therapure Biopharma Inc., Mississauga

Duration: Jan 2017 – Current

Role: Business Intelligence & Analytics

Environment: MS Visio, SQL Server, VBA, Power Bi, Tableau, Cognos, Data Warehouse, Windows XP, MS Office

Project Name: MIS and Planning System including Data Warehousing

Challenges: Operational reports missing or available once per month

Short term planning not possible – too much manual work required

Solution: Dashboards & Reports available on daily basis in a Self-Service BI environment with fully automated data preparation

Weekly updates of short term plans

Front-End: Tableau, Power BI, Excel

Back-End: SSIS, Dimensional Modeling, complex business logic

Project Name: Project Planning Business Intelligence and Data Integration Processing Design

Challenges: Data collabration and too much manual work

Solution: Automate Project Planning report on Daily basis from multiple data source and identify Material requirement based on BOM for Non-Stock GMP items.

Front-End: Power BI, Excel

Back-End: SSIS

Project Name: Material Variance and Inventory BI

Challenges: Identifying usage per lot and waste

Solution: An automated solution using VBA to gather data from SharePoint and processing it and uploading the data to WMS for stock items. The users have the ability to report inventory and variance for each batch and client, where available.

Front-End: Tableau, Excel

Back-End: SQL Server, SSIS

BI & Analytics

Collaborate with managers in Business Management Office on new initiatives to determine business process re-engineering, reporting, channels needs and distribution

Accumulate business requirements from various business users and translate them into Business requirements document

Assist Project Manager with the project plan and business case documentation by identifying key business requirements, describing primary responsibilities, timelines, deliverables and key milestones

Involved in Normalization of OLTP tables up to 3rd form and De-Normalization of existing tables wherever needed, for faster query processing and using OLAP for analytical processes

Interacted with third party vendors and identified different external and internal homogenous and heterogeneous sources and extracted and integrated data from SQL Server and loaded to staging area and database/Datamart tables

Developed several complex ETL jobs for Historical data loads and ongoing data loads using SSIS and various active and passive stage of DataStage.Worked on Data integration process design

Writing and reviewing business, user and non-functional/system level requirements in the form of Use Cases, UML, and other similar structured requirements documentation

Used Tableau Desktop for blending databases and creating different interactive views and dashboards.

Company: Hudson’s Bay Company, Scarborough

Duration: May 2014 - Dec 2016

Role: Sr. Reporting Analyst / Business Intelligence Analyst – eCommerce Fullfilment Center

Environment: SSIS, Oracle, VBA, EDI

Project: To create an expandable and Flexible Data Warehouse solution from internal and external Data Source for tracking and replenishing inventory in Self-Service BI environment.

Challenges: No transparency over web data and partially unstructured external data

Responsibilities:

Created Business reports on Cognos reporting tool, Dashboard set up and end to end testing

Developed OLAP solutions by creating cubes using data from data marts/data warehouse, SSAS and starch schema techniques for deeper and faster data analysis

Generated ad-hoc reports in Excel Power Pivot and shared them using Power BI for the strategic planning

Used ETL tool SSIS and Business Intelligence DataStage Designer to develop processes for extracting, transforming, integrating, and loading data into Enterprise Data Warehouse.Also worked on Data integration process design

Developed Excel VBA application that communicated with DB using SQL

Created and implemented new Inventory Tracking system designed in Excel spreadsheet with complex formulas and pivot tables, responsible for the entire materials group for all packaging SKU’s

Reduced overall stocking locations by more than 15% by redesigning the strategic sourcing network

Optimized inventory by developing new safety stock methods designed to reduce excess by 15% with no effect on service levels

Reduced Resolution of critical issues by 10 % in a time-sensitive environment, using excellent analytical skills

Company: FGF Brands, Toronto

Duration: July 2013 - April 2014

Role: Production Analyst/ Business Intelligence Analyst

Environment: SAP, WMS, EDI

Responsibilities:

Provided quick problem resolution to daily, weekly, and monthly processing cycles executing using the ETL tool in SSIS

Developed Production, Thaw, Freezer and Delivery schedules for the manufacturing based on Sales Orders

Reviewed and Analyzed production variance reports to ensure production plans are in place to meet both customer and deliverables and minimise material obsolescence

Built and maintained SQL scripts, indexes, macros and comples queries for Data analysis and extraction

Provide organized data sets using analytics tools to provide actionable insights into customer activity, operational efficiency and other key business performance metrics

Utilized the MRP system to analyze supply and demand of raw materials and packaging, premix Kits

Developed and maintained a detailed production schedule by work centre to achieve the MPS

Managed monthly inventory and close process for all units within the region

Monitored inventory levels of materials, equipment and stock as issued, transfer within an establishment using OMS

EDUCATIONAL DETAIL:

University of Toronto, Toronto Jan 2019 - Aug 2019

Data Analytics – Boot Camp (Pursuing)

Sheridan College, Mississauga Jan 2014 - Aug 2014

Supply Chain Management

Punjab Technical University, Aug 2001 - Jun 2005

Bachelor of Engineering – Material Science and Engineering

CERTIFICATION & TRAINING:

VACS Technology Pvt. Ltd .SAP -WM Aug 2010 - Sep 2010

VACS Technology Pvt. Ltd .SAP -MM Nov-2009 - Dec 2009

Six Sigma Green Belt Certified Aug 2009 -Sep 2009

Contact this candidate