Lead IT Analyst
Resume:
MOHAMMAD SHADAN
Lead IT Analyst
Bachelor of Technology, IIT Guwahati
******.*@*****.***
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