MOHAMMAD SHADAN

Lead IT Analyst

Bachelor of Technology, IIT Guwahati

acx90f@r.postjobfree.com

+971-*********

PROFILE OVERVIEW

8.11 Years of experience in IT and Analytics

Managing IT Operations for Abu Dhabi Division of Bhatia Brothers Group for Deployment, Operation and Support

Working closely with Business Heads, IT Management, Developers, Business Users, Vendors and other Business Analysts on requirements, system analysis, design and implementation of new modules, features, reports and business processes

Managing support of Microsoft Dynamics CRM, Google Apps, Orion & SUN ERP, Focus Procurement Module, DMS and Infrastructure

Ensuring continuous process compliance and process improvements, assisting in Business Process Mapping and Reporting

Involved in technical assistance/advices to all stake holders to minimize overheads expenses and maximize productivity in all areas

ACADEMIC DETAILS

INDIAN INSTITUTE OF TECHNOLOGY (IIT), GUWAHATI 2003-2007

Bachelor of Technology, Department of Mechanical Engineering

JOHNS HOPKINS UNIVERSITY, Coursera Jul 2016- Dec 2016

Data Science Specialization

CERTIFICATIONS AND TRANINGS

Statistics for Business, IIM Bangalore, edX

The Data Scientist’s Toolbox, R Programming, Getting and Cleaning Data, Exploratory Data Analysis, Reproducible Research, Statistical Inference, Regression Models, Practical Machine Learning, Developing Data Products, Data Science Capstone as part of Data Science Specialization by Johns Hopkins University, Coursera

Data Visualization and Communication with Tableau,

Managing Big Data with MySQL by Duke University, Coursera

Trained in Project Management Professional (PMP, PMBOK 5), ITIL Foundation, Lean Six Sigma

KEY STRENGTHS

Expertise in understanding business processes, solution designing and process re-engineering.

Strong Quantitative & Analytical skills, delivery focused and able to motivate teams

Excellent interpersonal skills, good communicator, high personal standards & attention to detail, flexible & adaptable with a calm & positive temperament

KEY SKILLS

Microsoft Dynamics CRM

Sales, Service, Marketing Modules

Lead, Accounts, Salesperson, Daily Customer Visits, Phone Call Activity, Quotes, Orders, Account Budgets, Account ERP Mapping

Automated Workflow

SSRS Report Development (Customer Coverage Report, Six Sigma - Sales -Effectiveness Report etc.), Advanced Find

SQL Server Management Studio, Microsoft Visual Studio

Document and Manual Preparations

Machine Learning

Predicting with trees, Bagging, Random Forests, Boosting, Model Based Prediction

In and out of sample errors, Prediction study design, Types of errors, Receiver Operating Characteristic, Cross validation

Caret package in R, Data slicing, Training options, Plotting predictors, Basic preprocessing, Covariate creation, preprocessing with principal components analysis(PCA), Predicting with Regression, Predicting with Regression Multiple Covariates

Data Analytics with R

Raw and Processed Data, Subsetting and Sorting, Summarizing Data, Creating New Variables, Reshaping Data, Managing Data Frames

Analytic Graphics, Exploratory Graphs, Hierarchical Clustering, K-Means Clustering, Dimension Reduction, ggplot

Regression

Statistical Linear Regression Models, Basic Least Squares, Linear Least Squares, Regression to the Mean

Interpreting Coefficients, Linear Regression for Prediction, Residuals, Residual Variance, Inference in regression, Prediction

Multivariable Regression, Adjustment, Residuals and Diagnostics, Model selection

Basics of GLM, Logistic Regression, Poisson Regression, Variance Inflation Factors(VIF), Overfitting and Underfitting

Inferential Statistics

Probability mass and density functions, Conditional probability, Bayes' rule, Independence, Expected values, Expected values for PDFs

Variability, Standard error of the mean, Binomial distribution, Normal distribution, Poisson, Asymptotics and LLN, Central Limit Theorem (CLT), Confidence Interval

T confidence intervals, Independent group T intervals, Hypothesis testing, T tests, two group testing, P-values

Power, Calculating Power, T test power, Multiple Comparisons, Bootstrapping, Permutation tests

Infor SUN System

Sales, Purchase, Accounts and Inventory Modules

Month End & Year End Activities

New Report Development

Reporting &

BI Tools

VISION, SQL Reporting, SSRS

Tableau,

Project Management

Microsoft Project, Gantter, Smart sheet

Languages

C, R, Shiny

Databases

MS SQL Server 2008 R2, SQL Server 2012, 2008, 2005, Oracle 9i, MySQL

Process Optimization

Six Sigma: Process Mapping for different division for "As-Is and To-Be" processes resulting in process optimization

Microsoft Visio

Other Tools

R Studio, GitHub, Rpubs, R Markdown

MS Office Tools

Advanced user of MS Excel, Word and PowerPoint

PROJECTS

Project : Predictive Text Engine

Objective

Building Shiny Word Prediction Application using Natural Language Processing in R

Exploratory Data Analysis and Modeling

Predictive model using Stupid Backoff Algorithm to do the prediction after creating required n-grams

Packages used: shiny, tm, RWeka, stringi, wordcloud, ggplot2, slam

Project : Reporting - SQL & SSRS (CRM)

Company : Bhatia Brothers Group – Dubai/Abu Dhabi

Responsibilities

Analyze the business requirements and design reporting solutions

Prepare and execute the functional testing activities (test plans, scenarios and tests results)

Ensure understanding and user acceptance of the reporting solution

Maintain and update all the functional documentation

Project : Procurement Application (Aug 2015 – Nov 2015)

Vendor : FOCUS (www.focussoftnet.com)

Company : Bhatia Brothers Group – Abu Dhabi

Responsibilities

Requirement Gathering, Implementation and Roll out across Abu Dhabi group of divisions

Training to the end users.

Objective

Implementing Pre-Purchase Cycle (PR, RFQ, Quotation, Quote Analysis, Quotation Importing, Purchase Order, PO Importing, Shipment Advice, GRN)

Product and Supplier Masters, Item Code/Supplier Code Creation/Approvals

Work Flow for PO Approval through DMS

Integration with SUN ERP

Project : Fleet Management – Vehicle Tracking (June 2012 – Aug 2014)

Vendor : VZONE International (www.vzoneinternational.com)

Company : Bhatia Brothers Group – Abu Dhabi

Responsibilities

Vendor Selection and Negotiation, POC, ROI Calculation, Pilot Run, Deployment, Report Analysis

Objective

Real Time Geographic Location of Vehicle

Detailed Reports on vehicle usage, idling time, downtime, speed violations, distance travelled and event log.

Alerts for vehicle movement to business users whenever vehicle is going in and out of pre-defined boundary.

Reduce Operational Costs through better planning of routes, preventing unauthorized usage.

Improve Deliveries by close monitoring of idling time, better vehicle utilization.

WORK EXPERIENCE

Company

Location

Job Title

Period

Bhatia Brothers Group

Dubai, AUH, UAE

Lead IT Analyst

Oct 2011 - Present

CSC India Pvt Ltd

Chennai, India

Engineer – Application Development

Aug 2007 – Aug 2011

EXTRACURRICULAR ACTIVITIES and HOBBIES

Mentor for Exploratory Data Analysis Course, Data Science Specialization, Coursera

Conducted multiple workshops and trainings in advanced excel

Vice President – Public Relations (VP-PR) for CSC Chennai Toastmasters for the year 2010-2011

Represented CSC and won multiple prizes in Humorous Speech Competition held in Toastmasters Club

PERSONAL DETAILS

Address : 405, EMR03, Emarati Cluster, International City, Dubai, UAE

Nationality : Indian

Passport : N1831994

LinkedIn : https://ae.linkedin.com/in/mohammad-shadan-954909a

Contact this candidate