OBJECTIVE:

• To obtain a position where I can apply, share and enhance my technical knowledge and skills in Data Analysis

SUMMARY:

• Data analytics professional with good level of experience in designing analytical approaches for business problems and deriving actionable, profitable insights from the data. Leverage data mining, statistical modeling, machine learning and data visualization techniques to drive decision making.

TECHNICAL SKILLS:

Programming Languages: R, Python, SQL, Salesforce Object Query Language (SOQL), Java

BI Tools: Tableau, Power BI, Excel Pivot, QlikSense, Microsoft Azure Machine Learning Studio, D3.js

ETL Tools: Talend, SSIS, Informatica 9.X/10.X

Databases: Salesforce, Microsoft SQL Server 2012, Redis, MySQL, Toad

Platforms and frameworks: Elastic search, Kibana, Buiding REST API, Rabbit MQ

Skills: Predictive Modeling, Machine Learning, Data Visualization & Communication, Statistical Modeling, Market Research, Data pre - processing, Data Warehousing, Text Analytics, Business Requirements Gathering

PROFESSIONAL EXPERIENCE:

DATA INTEGRITY SPECIALIST

Confidential, Hadley, MA

Responsibilities:

• Involved in data hygiene, merging and migration of the event registration data of I- Corps program funded by National Science Foundation ( Confidential ) to Salesforce CRM using Python scripts and Salesforce Data Loader.
• Migrated and pre-processed the intake survey data of 5 years to Salesforce CRM using R scripts and Salesforce Data Loader.
• Built Predictive and Classification models on survey data using R to predict the satisfaction of participants about the National Science Foundation ( Confidential ) I-Corps course structure.
• Created custom reports and dashboards in Salesforce, Tableau and Power BI upon ad-hoc requests from higher management and Marcomms.
• Designed workflow rules, validation rules, custom objects, fields, records, privacy requirements and set up the page layouts in Salesforce.
• Provided end user and support in Salesforce to find and use data for organizational needs.

DATA SCIENTIST CO-OP

Confidential, New York City, NY

Responsibilities:

• Analyzed time series data related to credit card payments of customers in Taiwan using statistical techniques.
• Performed data pre-processing, feature engineering & attribute reduction techniques to prepare dataset for modeling.
• Used Power BI, Excel Pivot and Tableau to visualize, understand and detect the anomalies in the raw data.
• Performed Cleansing and Pre-processing of raw data using R programming language.
• Built Statistical models using Logistic Regression, Regression Tress and Artificial Neural Networks for classifying each customer as a default or a non-default.
• Built interactive and intuitive dashboards using Tableau, Power BI to communicate key metrics to Risk Management team.

DATA ANALYST: PREDICTIVE MODELLER

Confidential, Boston

Responsibilities:

• Built a forecasting model to predict the energy usage of Confidential for 2016 year.
• Classified the power usage as above normal, below normal and optimal by implementing Machine Learning Algorithms.
• Performed validation of the models by running them against a data given for another school.
• Performed Data Wrangling and Cleansing using R programming language on raw data which is a real data collected in 2014 at the Confidential .
• Implemented operations such as aggregation, merging, feature engineering, handling outliers, handling NA values during Pre-processing and cleansing stage.

BI & ANALYTICS DEVELOPER

Confidential

Responsibilities:

• Implemented Dimensional Modelling for building the schema of the Confidential ts Data Warehouse in SQL Server 2012.
• Extracted, Transformed and loaded raw data from different sources into the Data Warehouse by using tools sucastalend and SSIS.
• Performed exploratory data analysis and report generation to analyze the trends of Confidential ts using BI tool such asTableau.
• Involved in gathering requirements from the business to develop a consolidated Data Warehouse.
• Performed Period over Period Analysis including YTD, QTD, YTY & QTQ using Excel Power Pivot and CalculatedFields.
• Conducted meetings from time to time to get approval on various stages of development.Designed Dashboards, Reports, Charts and Maps with Slicers, Filters, Storyboard and Drill-Down features.
• Predicted the sales amount of a product, classified a sale and provided product recommendations to customers by implementing Machine Learning Algorithms.
• Developed an end-end web application using R and Microsoft Azure Machine Learning Studio to provide the analysis.
• Achieved an accuracy of 94.4% for the classification model.
• Forecasted the results of soccer matches to be played in English Premier League for the on-going season.
• Predicted the price ranges of players during the transfer market by performing predictive modeling.
• Generated confusion matrix and developed an end-end web app to depict the analysis using R, Azure ML Studio.

Confidential

Responsibilities:

• Forecasted the energy usage of Confidential for 2016 year.
• Classified the power usage as above normal, below normal and optimal by implementing Machine Learning Algorithms.
• Performed validation of the models by running them against a data given for another school.

Confidential

Responsibilities:

• Predicted if a customer is likely to discontinue using the services of a telecom provider and prescribed the factors that drive to customer churn.
• Performed Exploratory Data Analysis, Correlation and Survival Analysis using Excel, Power BI and R programming.
• Predicted whether an image appearing on an internet page is an advertisement ("ad") or not ("non-ad").
• Implemented principal component analysis (PCA) to reduce the number of features from .
• Achieved an accuracy of 97.2% with overall error rate being 2.