Surya Sivakumar Sujatha

A grown up enthusiastic kid with dreams sky high

SQL Development | Business Logic in the back-end using SQL Server

Environment: Sql Server 2008 R2 & 2012, ASP.Net, C#, ER Studio, SSIS & SSRS

Domain: Healthcare & Banking

# Involved in Data modelling, ER Modeling and created database structure for an entirely new product. The project required a star - schema databse model since it is an OLTP database that involves daily transactions and the database has to be normalized as much as possible.

# Developed Stored procedures to handle business logics at the backend. Views has been created to mask the stored procedure for security reasons, that calls the stored procedures instead.

# Developed SQL Server database objects – tables, user definedfunctions, views, indexes, stored procedures, cursors and triggers.

# Extracted and transformed data using DTS Import/Export Wizards, Bulk Insert, BCP and SQLServer Integration Services (SSIS) packages and scheduled jobs, alerts, DTS/SSIS Packages in SQL server.

# Extensively used SSIS transformations such as Lookup, Derived column, Data conversion, Conditional split, Script task and Send Mail task

Data Analysis | Reports & Dashboard development in Tableau, PowerBI & SSRS

# Visualized data by consolidating data from different data sets; Developed Tableau visualizations and dashboards using Tableau Desktop.

# Created action filters, parameters and calculated sets for preparing dashboards and worksheets in Tableau 10

# Developed Tableau workbooks from multiple data sources using Data Blending. Created story board to paint a broader picture. Created action filters, parameters and calculated sets for preparing dashboards and worksheets in Tableau 10

# Hosted developed dashboards from Tableau Desktop to Tableau Server for the use of other stakeholders within the organization

# Developed reports and dashboards from different CRM data sets like PeopleSoft, Salesforce using Report Builder (SSRS) & Power BI

# Migrated reports from Hyperion to Tableau for better insights and reporting structure within the admission services of the university

# Retrieved data from SQL server databases and reported various metrics and KPI's using SQL Server Reporting Services (SSRS). Developed Linked, Sub-reports, drill down and drill through reports and hosted it in Sharepoint and SSRS server

# Gathered expenditure and revenue data from a restaurant business and reported various KPI’s and parameters through reports in Tableau. Designed and developed Tableau workbooks from multiple data sources using data blending.

Machine Learning | Multiple Linear regression using R

Analyzed various independent variables of cars and predicted the dependent variable Miles per Gallon (MPG) using backward elimination method. Used caTools package for regression and plotted the graph with ggplot2 package in R studio.

Comparing multiple independent variables against the dependent variable using Backward Elimination method

The formula goes as:

y = b0 + b1x1 +b2x2 +b3x3 .... bnxn

y = Dependent Variable

x = Independent Variable

b0 = Constant

b1,b2.. = Co-effecients

Took sample data to analyze and implement the above formula.The sample data can be acquired from various open source sites. For this example I took data from This data is all about different models of cars with attributes and we are going to find out how these attributes are used to predict the MilesPerGalon attribute. The following steps have been performed to predict the dependent variable mpg and found out weight of the car plays an important role in predicting the miles per gallon.

Step 1: Install/Call the needed packages

Step 2: Data pre processing - preparing training set and test set

Step 3: Perform the regression analysis on the training data and then perform against the test data

Step 4: Plot the data on the graph

Text Mining | Sentiment analysis on a product using R

Analyzed twitter feeds for the Sephora product to get the user sentiments and buzz words for the product. Understood text mining techniques and used packages in R to form the word cloud. Also plotted the tweets in a map to understand the demogrpahics of the customers and to target the emerging markets and new trends in any particular country.