*** ******** ***. ****** ***** C: +1-312-***-****
Union City, NJ 07087 www.linkedin.com/in/diveek *******@*******.*** Objective Seeking full time opportunity as a Data Analyst or a Business Analyst. Education Stevens Institute of Technology, Hoboken, NJ Master of Science in Information Systems December 2017 Minor: Business Intelligence and Analytics GPA: 3.7/4.0 SRM University, Chennai, Tamil Nadu
Bachelor of Technology in Computer Science Engineering May 2012 Major: Computer Science GPA: 3.2/4.0
Certification: Oracle Certified Java Programmer.
Skills Databases: Oracle DB2, MySQL, SAS, SPDS, Microsoft Excel. Programming Languages: SAS, R, SQL, Python, UNIX/Linux shell scripting, JAVA, HTML, CSS. Software: Tableau, R Studio, SAS Management Console, SAS Enterprise Guide, MS VISIO. Operating Systems: Linux, Solaris, Windows and MAC OS. Experience Tech Mahindra Ltd, SAS Developer Consultant, Bhubaneswar, India July 2013 May 2016
Developed models using SAS/STAT and SAS Macros for Classification and predictive analysis.
Experience in developing SAS SQL stored procedures and SAS Macros for Data Management.
Data mining models: Classification using K-Nearest Neighbour, Naïve Bayes Decision Tree, CART, Artificial neural network and Random Forest using R and Excel to derive analysis results and summary reports to business leaders.
Maintain data warehouses of more than 40TB by regular data cleaning and loading.
Designed and deployed ETL codes using SAS DI, SAS SMC, Deploy manager and UNIX.
Created Dashboards and Storyline using Tableau. Report automation using Tableau server for ad-hoc requests.
Experience in working with Autosys. Job scheduling and Jill scripting. Job Scheduling using Crontab.
Created various macros in MS Excel and operations such as vlookup, Hlookup and pivot.
Maintained project progress documentation for high level requirement, tracking and validation purpose.
Business requirement gathering and High level technical requirement gathering.
Used MS Visio for mapping business process and optimising processes. Academic
Projects Sentiment Analysis using twitter API (Python, R and Tableau).
Import data using twitter API using a trend hash tag. Restructure data. Create positive and negative words dictionary.
Use dictionary of words (Sad, Anger, Anxiety, Hate etc. ) to rate different emotions in every tweet, us. Rent hop: predicting level of interest a rental listing(R and Python).
Using data from kaggle, restructure data using featured engineering.
Normalize data and Apply data mining techniques (Random forest, Naïve Bayes, KNN, Artificial neural network, CART, Dtrees) to predict interest level.
Check for over-fitting and check error rate for selecting best fit predictive model. Supermarket Insight Dashboard (Tableau and SAS/GRAPH).
Retrieve data from excel, clean data and store in data marts Using SAS to create KPI dashboards.
Created reports for KPI such as best-selling product, correlation among products, sales and revenue. Loan Repayment Predictive Modelling (SAS and R).
Cleaning and Transform data using R. Normalize data and dimension reduction using PCA.
Use test and training dataset for many classification techniques (Logistic regression, Naïve Bayes, CART). Testing model for over fitting and optimise error rate. Cross Validation and best fit model. Leadership Vice president at Toastmasters Club for membership and public relations. Available December 2017
Course work
Web Analytics
Social media analytics
Data Warehousing and Business Intelligence
Data Mining and Knowledge Discovery
Multivariate Data Analysis.
Financial Decision Making.
IT Strategy.
Managing Emerging Technologies.
Organisation Behaviour and Design.
Project Management fundamental.
Process Innovation and Management.