SALEHA SHAIKH

+1-289-***-**** adhfr8@r.postjobfree.com

Data Scientist / Data Analyst / BI Consultant

Professional Summary:

●Around 5+ years of professional experience in design, development and delivering IT solutions to complex enterprise problems in Banking, Capital Markets, Insurance, and Utilities domain.

●Data analyst with 5 years’ experience executing data driven solutions to increase efficiency, accuracy and utility of internal data processing.

●Experience of working on Python 3.5/2.7 (Numpy, Pandas, Matplotlib, and Scikit-learn).

●Have excellent knowledge and thorough understanding of SDLC phases like Requirements gathering, Design/Analysis, Development, Testing and Deployment.

●Experienced with machine learning algorithm such as Linear Regression, Logistic Regression, Decision Tree, Random Forest and KMeans.

●Experienced in building ETL pipelines for performing feature engineering on large and complex dataset

●Highly skilled in Excel pivot table, graphs, V-lookup, micros Data Structure

●In depth knowledge of Machine Learning, Data cleaning and Mining, visualization, storytelling techniques

●Sound understanding of Logistic regression, support vector machines, Naïve Bayes, decision tree, Linear regression, Random forest model in python

●Excellent Tableau Developer, expertise in building, publishing customized interactive reports and dashboards with customized parameters and user-filters using Tableau.

●Experience in implementing data analysis with various analytic tools, such as Anaconda 4.0 Jupiter Notebook 4.X and Alteryx.

●Comprehensive knowledge and experience in normalization/de-normalization, data extraction, data cleansing and data manipulation.

●Experienced at managing relational and non-relational database software such as MySQL, SQLite3, Oracle, Mongo DB and Influx DB.

●Working knowledge in Python and Scala.

●Excellent experience developing REST APIs in Scala.

●Extensive experience with Tableau Desktop and Tableau Server in Tableau 8.x, 9.x and 10.x as a Consultant

●Excellent problem-solving skills that arise, such as customer complaints and on-going support.

●Worked on creating various dashboards based on business requirements.

●Created solution driven dashboards using different chart types like Crosstab's, Heat/Geo/Tree Maps, Pie/Bar Charts, Circle Views, Line/Area Charts, Scatter Plots, Bullet Graphs, and Histograms in Tableau Desktop.

●Experienced in technical support, troubleshooting, report design and monitoring of system usage.

●Expert in design and deploying rich Graphic visualizations with Drill Down feature and Parameter.

●End to End experience in designing and deploying data visualizations using Tableau

●Excellent speaking and written communication skills

●Able to manage multiple projects

Skills:

Languages: Python, R, Java

Machine Learning: Logistics Regression, Naive Bayes, Decision Tree, Random Forest, KNN, Linear Regression, SVM, Regression Tree, K-means, Probability, Statistics

Analytic/Predictive modeling Tools: Alteryx, Knime

Deep understanding of Data Visualization and data processing toolkits: Tableau, Numpy, Pandas, Matplotlib, Tensorflow, Keras, PyTorch, Seaborn

Operating systems: Windows, Unix, Linux

Infrastructure Tools: Command Line, PowerShell, Git and Version Control

Cloud Providers: AWS EC2, Microsoft Azure

RDBMS: MS SQL Server 2008/2005, Netezza, RedShift, SQL, Oracle

MS- Office (Word, Excel, Power Point)

CORE EXPERTISE

Machine Learning

Analytic/Predictive modeling

Visualization Tools

Data Mining and Modeling

Matplotlib, Seaborn, Sklearn

Business Process Improvement

Rest API

Python, R

Technical Documentation

Achievements:

Achievement of reducing productivity losses by 10% through data analysis leading to optimizing use of available resources.

Best Trainer Award for training the junior resources on Tableau.

Client appreciation for developing complex dashboards.

Received several accolades for solving Tableau Desktop and Tableau Server Related critical issues at the earliest time for important.

Professional Experience:

Client: Canadian Western Bank February 2019 – Present

Role: Data Scientist / Data Analyst / Tableau Developer Consultant

Project: This project was focused on customer clustering based on Machine Learning and statistical modeling effort including building predictive models to support customer classification and segmentation. Also, the scope of the project is to implement CWB bank financial reports and Dashboards from Business Objects, excel to Tableau enabling users to have new features and functionality previously unavailable. Second project is on Fraud transaction detection based on Machine Learning.

Responsibilities:

●Identified patterns of behavior in customer migration to products and services.

●Collected historical data and third-party data from different data sources.

●Perform data cleansing, data imputation and data preparation using Pandas and Numpy.

●Worked on outlier’s identification with boxplot using Pandas, Numpy

●Participated in features engineering such as RFE feature selection, Feature normalization and Label encoding with Scikit-learn preprocessing library.

●Modeled customers to discover untapped business opportunities.

●Recommended product strategies to minimize attrition of profitable customers, enhance retention of promising customers and encourage migration towards profitable segments.

●Used various metrics like Confusion-Matrix, F-Score, Precision, Recall, Stats Model api, VIF etc. to evaluate model performance

●Real time analysis of customer’s financial profile and providing recommendation for financial products best suited.

●Prepared and presented data quality report to stakeholders to give understanding of data

●Facilitated release/sprint planning, grooming, daily stand-ups, retrospective meetings and demos

●Design, develop, test, and maintain Tableau functional reports based on user requirements.

●Mastered the ability to design and deploy rich Graphic visualizations using Tableau.

●Developed Tableau data visualization using Combo charts, Heat maps, Box and Whisker charts, Scatter Plots, Geographic Map, Cross tabs, Histograms etc.

●Created different KPI's using Table calculations and calculated key figures Manipulating strings, arithmetic calculations, aggregation options and logical functions

●Worked extensively with Advance analytics like Reference Lines and Bands, Trend Lines.

●Expertise in working with data building Groups, Hierarchies and sets.

Environment: Python, SQL server, Hadoop, Spark,Hive, HDFS, MongoDB, Tableau Desktop, Tableau Server, Unix/Linux.

Client: Intact Financial Corporation April 2016-January 2019

Role: Data Scientist /Data Analyst Consultant

Project was focused on analyzing large data sets to develop multiple custom models and algorithms to drive innovative business solutions. Data profiling, preliminary data analysis and handle anomalies such as missing values, duplicates, outliers, and imputed irrelevant data. The data is coming from the sources related to Loan, Deposit, Security and Off-Balance Sheet. Based on the mapping specification the request will be sent to SQL server which interacts with source interfaces. SQL export will provide the data in excel files.

Responsibilities:

●Develop an estimation model for various products & services bundled offering to optimize and predict the gross margin.

●Built sales model for various product and services bundled offering.

●Prototyping and experimenting ML algorithms and integrating into production system for different business needs.

●Design, built and deployed a set of python modeling APIs for customer analytics, which integrate multiple machine learning techniques for various user behavior prediction and support multiple marketing segmentation programs

●Segmented the customers based on demographics using K-means Clustering.

●Used classification techniques including Random Forest and Logistic Regression to quantify the likelihood of each user referring.

●Designed and implemented end-to-end systems for Data Analytics and Automation, integrating custom visualization tools using Python, Tableau.

●Develop enterprise Business Intelligence (BI) solutions using Tableau

●Create dashboards and reports within Tableau, developing impactful presentations and documents

●Created new reports based on requirements.

●Blended data from multiple databases into one report by selecting primary keys from each database for data validation.

●Created views in Tableau Desktop that were published to internal team for review and further data analysis and customization using filters and actions.

●Created Heat Maps showing current service subscribers by colour that were broken into regions allowing business user to understand where we have most users vs. least users.

Environment: MS SQL Server, Python, Redshift, MS Excel, Tableau, XML, MS office 2007, Outlook.

Client: Infosys Limited, Pune, India April 2015- February 2016

Role: Senior System Engineer / Data Analyst Consultant

Having experience of data cleaning, analyzing and visualization using Excel & python

Prepared and presented presentations and monthly project reports to the client

Proven ability of Machine Learning frameworks, libraries, and techniques like Regression, Clustering, Dimensionality Reduction, Recommendation Systems

Experienced in manipulating data sets with structured and unstructured data

Developed metrics and KPIs (key performance indicators)

Experienced in analyzing large datasets

Worked on SQL to perform CRUD operations on the database

Provided server and application support to the client

Education, Certificates and Training:

Post graduate certificate in Data Analytics for Business Decision Making Durham College, Durham, ON

Post graduate certificate in Information System Security – Computer & Networking Durham College, ON

Bachelor of Engineering in Electronics and Communication Engineering

Gujarat Technological University, Gujarat, India

CERTIFICATION

Data Analyst in Python (Dataquest - certification track)

Data Analytics Virtual Internship Experience Program (Quantium)

Tableau 10 Essential Training

Google Analytics for Beginners Certificate of Completion

DAT206x: Analyzing and Visualizing Data with Excel

DV0101EN: Visualizing Data with Python

Willing to Relocate: yes

Job type: Permanent or Contract

Contact this candidate