Overview

An avid Data Analytics and Science professional with 8 years of progressive professional experience in Statistical Modeling, Data Analytics, Machine Learning, Customer Relationship Management(CRM), Database design & implementation, ETL and Field-Programmable Gate Array (FPGA) design.

Professional Certifications

Data Analysis Using R, Big Data University

Introduction to SQL Fundamentals, Big Data University

Big Data Fundamentals, Big Data University

Big Data Hadoop Fundamentals, Big Data University

Informatica Mapping Designer, Informatica

Introduction to R, Data camp

ggplot2, Data camp

Professional Recognitions

Awarded Associate of Quarter at Cognizant

THANOJ KUMAR

Data Analyst /Analytics

acum47@r.postjobfree.com

732-***-*****9087

Summary

Clear understanding of the CRISP-Data Mining methodology for the lifecycle of an analytics project.

Experience working full data insight cycle – from discussions with business, understanding business logic, Exploratory Data Analysis, Identifying predictors, enriching data, working with missing values, exploring data dynamics, building predictive data models.

Extensive experience using statistical analysis techniques and building advanced/predictive models like Linear & Logistic Regression, Principal Component Analysis(PCA), K-Nearest Neighbors(KNN), Decision Trees (C4.5, C5.0, CART), K-Means clustering, Naive Bayes, Association rules (Market Basket Analysis), Support Vector Machines, Text mining and Ensemble modeling.

Experience in Excel Spreadsheet using Pivot tables and V-Lookups.

Proficiency in using SQL to manipulate data, query expressions, and join statements.

Experience in Excel Spreadsheet using Pivot tables and V-Lookups.

Experience in manipulating the data with R packages like tidyr, dplyr.

Experience in visualizing the data using lattice and ggplot2 packages.

Experience in developing reports/dashboards using Tableau and OBIEE.

Experience in developing ETL mappings, workflows and scripts using Informatica Power Center.

Extensive experience as a Techno-Functional consultant in providing CRM solutions with strong understanding of Siebel Architecture and Data Model with extensive business domain experience in Sales, Finance, Pharma, Automotive & Communications Applications.

Sincere, enthusiastic, with excellent communication & interpretation skills and appetite to learn new skills.

Technical Skills

Analytical Packages

R, Minitab, WEKA

BI and Visualization

Tableau, SAP Lumira, OBIEE, ArcGIS

Programming Languages

C, Core Java

Databases

RDBMS, MSSQL, MS Access, MySQL, SQL Server 2000, Oracle 11g/10g/9i/8i/7

Data Warehouse Concepts

OLAP, OLTP, Conceptual, Logical, Physical, and Dimensional Data Modeling

ETL Tools

Informatica, Talend

CRM

Siebel 7.5/7.7/8.1/8.2 - Sales, Automobile, Communications, Pharma, Finance

Techniques

Univariate, Bivariate and Multivariate Analysis, Linear & Logistic Regression, Principal Component Analysis(PCA), K-Nearest Neighbors(KNN), Decision Trees (C4.5, C5.0, CART), K-Means clustering, Naive Bayes, Association rules (Market Basket Analysis), Support Vector Machines, Text mining and Ensemble modeling

Others

MS-Office (Access, Word, Excel, PowerPoint), SIMIO, PHStat, VHDL, Verilog, Xilinx

Professional Experience

AIG, Berkley Heights, NJ

Data Analyst/Analytics

Aug 2015 to Present

American International Group, Inc. (AIG) is an American multinational insurance corporation with its presence in various countries. The objective of the project is to derive a typical profile of customers holding on the water Insurance policies. Such a profile (or predictive model) would help identify customers with a similar profile who do not have on the water policies. This information can then be used for a much more focused marketing of policies to both existing non-holders of water insurance policies or new customers with similar profiles.

Roles and Responsibilities:

Clearly understood the business objectives and converted into analytical problem.

Extracted data relating to demographics and insurance characteristics.

Understood structure and nature of the data using descriptive statistics.

Performed exploratory data studies to understand the nature of the data and how predictor variables are related to binary response variable.

Tracing and Treating anomalies and imputing irrelevant or missing data elements using statistical methods such as imputation.

Visualized the data using various charts to understand the trends, patterns and grouping in the data to understand overall pictures of the data.

Logistic regression is used to model the data as the responses were binary in nature.

Carried out predictive analysis using other classification techniques like Decision tree and Random Forests.

Analyzing lift charts, AUC, and ROC curves for both training and testing data.

Compared all the models applying ROC and AUC curves, and sensitivity and specificity tests.

Creating customized business reports and sharing insights to the management.

Environment: R 0.99, SQL, Tableau 9.0, Excel 2013, Oracle 11g

MICHIGAN FIRST CREDIT UNION, Lathrup Village, MI

Data Analyst/Analytics

Sep 2014 – Jun 2015

Michigan First Credit Union is one of the Michigan based credit unions with its presence in various locations in the state. The objective of the project is to identify the effective features and predict probability of default of the credit loan with the aim of decreasing the bank credit’s risk.

Roles and Responsibilities:

Clearly understood the business objectives and converted into analytical problem.

Extracted the data relating to the problem.

Validating data elements using exploratory data studies.

Visualized the data using different charts to understand the trends, patterns and grouping in the data to understand overall pictures of the data.

Imputing irrelevant or missing data elements using statistical methods using K nearest neighbor’s imputation.

Tracing and treating outliers.

Reduced the class balancing issue using SMOTE method.

Selected important features with the help of Random Forest methodology.

Built predictive model for Probability of Default response variable using classification techniques – Logistic regression and Decision tree.

Evaluated the model with the combination of hold out and cross validation methods.

Evaluated the model fitness by measures - Accuracy, Error rate, ROC and AUC.

Validating appropriateness of the model results to the nature of business.

Creating customized business reports and sharing insights to the management.

Environment: R 0.97, SQL, Excel 2013, Power Point 2013, Oracle11g

HEALTH NET, Woodland Hills, CA

Technical Data Analyst

Dec 2013 – Jun 2014

Health net is among the America’s largest publicly traded managed health care companies. Enterprise Sales and SALSA Analytics (ESSA) Commercial is an initiative is to provide the organization with a timely and standardized analytical view of sales in order to better forecast sales membership, manage the sales force, and improve Health Net business. The scope of the project was to enhance the reports as per the business requirements.

Roles and Responsibilities:

Developed functional specifications and system design specifications for client engagements.

Develop mappings from Source systems to staging (SDE) and then from staging to OLAP systems (SIL).

Monitor the workflows and performed data validation on successful loading using SQL Queries.

Updated reports with charts, dashboard prompts, and filters to display appropriate data based on new enhancements.

Developed different kinds of reports (pivots, charts, tabular) using global and local Filters.

Enhanced interactive Dashboards and Reports in Oracle BI Answers as per the reporting

specifications.

Performed Data Validation of data in the reports and dashboards.

Performed unit testing of the developed mappings and reports and prepared unit test documents.

Environment: Windows 2003, Oracle 11g, Informatica 9.1, OBIEE 11g, Excel 2010

LEXIS NEXIS, New Providence, NJ

Technical Data Analyst

Nov 2012 –Oct 2013

LexisNexis is a leading global provider of content-enabled workflow solutions designed specifically for professionals in the legal, risk management, corporate, government, law enforcement, accounting, and academic markets. Project includes analysis of current processes and systems issues and on-boarding of new customers in the current DRIVE platform.

Roles and Responsibilities:

Developed functional specifications and system design specifications for client engagements.

Experience in data collection, data cleaning and data masking.

Developed SQL Queries and Informatica mappings to load data.

Worked with different sources/Targets like Oracle, Flat files.

Developed various Reports, Interactive Dashboards with drill-down capabilities, with various charts and views, and tables using global and local Filters.

Developed Reports and Dashboards with different Analytics Views including Pivot Table, Chart, Gauges, Column Selector, and View Selector with global and local Filters using Oracle BI Presentation Services.

Create new mapping designs using various tools in Informatica Designer like Source Analyzer, Warehouse Designer, Mapp let Designer and Mapping Designer.

Monitored Informatica Workflows.

Added customization using Siebel Script and developed Inbound and Outbound web services, Virtual Business components, and HTTP transport services.

Designed and developed signals, Data Validation Rules, Application Data maps, Integration Workflows and Business services.

Environment: Windows 2003, Siebel 8.1, SQL Server 2003, Informatica 9.1, OBIEE 11g, Excel 2010

EXPRESS SCRIPTS, St. Louis, MO

Technical Analyst

Apr 2012– Sep 2012

Express Scripts, helps to make the use of prescription drugs safer and more affordable, when a group of healthcare advocates began applying the rigors of scientific research to the pharmacy benefit. The main objective of this project is to upgrade the Siebel application to 8.1 and make sure that the all existing functionalities with product configuration as the main focus, are working as expected.

Roles and responsibilities:

Worked as a Siebel Product Configurator.

Have strong understanding on how the Siebel product configuration works, and the issues and challenges that are encountered during development phase.

Understanding Siebel 7.7 Custom Siebel Configurator User Interfaces Structure and developed the same in Siebel 8.1.

Worked on post-upgrade issues related to configuration, scripting, workflows, and runtime events issues.

Fixed issues identified during all Phases of Upgrade including system integration testing and user-acceptance testing phases.

Performed the performance testing of the application.

Provided training to the users about the new version of the application.

Environment: Windows 2005 Server, Siebel 8.1.1.11, Oracle 11g

FORD MOTORS, Dearborn, MI

Technical Analyst

Nov 2010 – Jan 2012

Ford Motor Company (Ford) operates in Automotive Sector in Ford North America, Ford South America, Ford Europe and Ford Asia Pacific Africa. The project aims at Upgrade of ATLAS Siebel application from 7.5 to 8.1 and data base from Oracle 9i to Oracle 11g for entire Europe Countries. This is Multilingual Upgrade Project mainly dealing with Contacts, Opportunities, Dealers, Vehicles, and Products.

Roles and Responsibilities:

Involved in sessions for understanding the existing Siebel Automotive 7.5 application.

Worked with the deployment of Siebel multi-lingual data model in both shipped and un-shipped languages.

Involved in pre-upgrade, post-upgrade tasks in Development, Performance and Production Upgrades.

Fixed issues identified during all Phases of Upgrade including system integration testing and user-acceptance testing phases.

Developed SQL queries to load pick list values data from Oracle 9i to Oracle 11g.

Performed the performance testing of the application.

Provided training to the users about the new version of the application.

Environment: Windows 2003, Siebel 7.5/8, Oracle 11g, Excel 2010

Research Center IMARAT, Hyderabad, India

Engineer Intern

Jan 2008 – May 2010

The project aims at developing base band encoder for transmission of digital signals and involves designing and development of High Level Data Link Control (HDLC), Forward error correction (FEC) blocks with the help of Gold codes.

Roles and Responsibilities:

Architected a Baseband encoder with PN sequence and Gold codes.

Designed HDLC, FEC blocks for the encoder.

Implemented the encoder in Verilog HDL.

Environment: Windows, VHDL, Verilog, Xilinx, FPGA, C

Education Details

Advanced Introduction to Data Science, International School of Engineering (INSOFE)

Bachelor’s in Electronics and Communication Engineering, JNTU, Hyderabad, India

Contact this candidate