Candidates About

Satwik Kodangal Varala     

Summary of Qualification:

·          5 years of industry experience in data analytics (Descriptive and Predictive) using tools such as SAS, R, Excel, Tableau, and WEKA.

·         Professional experience in analytics life cycle from Data Extraction, Data Cleansing, Imputations to Modeling.

·         Proficient with RDBMS concepts, normalizing databases, querying, indexing, transaction processing, parallel databases and writing advance SQL queries.

·         Expertise in writing Stored Procedures, Triggers, Functions, Views, Constraints and complex analytical queries.

·         Experienced in Predictive Modeling, Hypothesis Testing, Regression Analysis, ANOVA, Logistic and Linear Regression.

·         Profound knowledge on Neural Networks, Decision Trees, Forecasting, Time Series Analysis, ARIMA, Clustering Techniques, Dimensionality Reduction and Principal Component Analysis.

·         Strong understanding of Direct Marketing principles and evaluation metrics, Market Basket Analysis, Association Rules, Cost Sensitive Learning, Lift Curve

·         Strong coding skills in SAS and R on concepts such as Data Manipulation, Data Visualization and Predictive Analytics and adept in using tools such as SAS Base, SAS EM, SAS EG, R- Studio and WEKA.

·         Experience in BI tools such as SSRS and visualization tools such as Tableau for dashboard and report generation; Proficient with Advanced Excel.

·         Break down complex business problems into easy procedures by writing queries, sub-queries and complex joins for generating complex stored procedures, triggers using T-SQL to extract data to analytical tools & visualization software.

Academic Qualifications:

·         Masters of Science in Management Information Systems University of South Florida              GPA 3.87/4.00 Dec 2015

·         Bachelor of Engineering in Computer Engineering Manipal University                                       GPA 3.8/4.00  May 2012

Technical Skills:

·         Programming Languages : SAS, PROC SQL, SAS MACRO, R,T-SQL, Python; Data Visualization tools : Tableau, Qlikview, Spotfire

·         Statistical Tools : SAS EG, SAS EM, R Studio, SPSS, WEKA; Reporting Tools: Crystal Reports, SSRS

·         Databases: Oracle 10G/11G, MySQL, Microsoft SQL Server 2012, MS Access; Operating Systems: Windows, Mac OS, LINUX;

·         Tools: MS Visio, MS Excel, MS Power Point, MS Project, Clear case; Data Mining; Project Management; Data Warehousing

Certifications:

·         SAS Certified Base Programmer for SAS 9.

·         SAS Certificate in Analytics and Business Intelligence.

Professional Experience:

Spirent Communications (Clients: AT&T, T-Mobile)                                                                                               Feb 2016- Present

Data Analytics Consultant:          

·         Responsible for all the reporting activities using Tableau, Qlikview & SSRS; KPIs of new handsets that will be launched into the market.

·         Developing and automating reports for major carriers and handset organizations across the country using SAS, R, VBA, MSSQL, SSRS and Tableau.

·         Created Scatter Plots, Stacked Bars, Box and Whisker plots using reference, Bullet Charts, Heat Maps, Filled Maps and Symbol Maps according to deliverable specifications.

·         Created Stored Procedures to handle duplicates and check data integrity in the Reporting and Analytics databases.

·         Generated ad-hoc reports for management by writing advanced SQL queries when needed.

·         Presented insights and advocated changes with executives to optimize sales and marketing effectiveness.

·         Transforming raw data, dealing with data quality issues using SAS Macro, loading data into data warehouse and updating mappings using SSIS and create reports on a daily and quarterly basis using Tableau.

·         Proposed a marketing strategy by providing insights into their competitive intensity, market share, marketing mix, Lifetime Value analyzing the overall market and company’s sales data.

·         Parsing QXDM log files using Python to parse files and extract portions and store it into database.

·         Assist Sales team with analysis of data and creation of scorecards, dashboards and key performance indicators (KPIs).

·         Involved in design and development of Data Marts for specific Business aspects and loaded them with mappings using expressions, aggregators and lookups.

·         Extracting test data from various Spirent tools and integrating it to data warehouse using SSIS packages.

·         Built a tool from end to end to create real time Mean Opinion Score drive route map based on geographical positions.

·         Calculating p-values, confidence intervals and determining pass fail criteria of devices compared to reference standards, implementing Fisher Exact and customized statistical tests for AT&T and T-Mobile.

·         Analyzing KPIs and produce statistical results for the sales team to make critical business decisions.

University of South Florida, Data Analyst Intern                                                                                                    Feb 2015- Dec 2015

Research Analyst – Grow Financial Credit Union

·         Worked closely with domain experts at Grow Financial Credit Union to build and test predictive models for loan quality based on anonymous data using SAS and WEKA.

·         Extensively performed data cleaning using SAS, dealt with missing values by analyzing and visualizing the data.

·         Built predictive models and performed analyze data using statistical methods such as clustering and segmentation techniques, and modeled data advance data modeling to support evidence form meaningful insights from the results.

Research Analyst – Bank of America:       

·         Involved in analyzing financial events pertaining to the bank and extracting the data for sentiment analysis to determine the characteristics that define a statistically valid sample.

·         Utilizing social media monitoring tools like Brandwatch to determine the sentiment, opinion mining and volume on twitter.

·         Providing a list of social media influencers and to determine their associated characteristics and metadata.

·         Categorizing output of influencers and publishing dashboards based on the influencers using Tableau 9.

Ericsson Global India Limited      (Clients: Reliance and Aircel)                                                                             Jan 2012- Dec 2014

Business Data Analyst:

·         Extracting the post-paid customers’ information and predicting the list of customers who are likely to default or delay their payments and submitting the data to management to act on it using SAS and visualizing the key insights using Tableau.

·         Built models like Logistic Regression, SVM and Decision Trees using SAS & R to predict the likelihood of defaulters

·         Developed Tableau data visualization using Cross tabs, Geographic Map, Pie Charts and Bar Charts and Density Chart.

·         Expertise in Tableau calculations and applying complex, compound calculations to large, complex datasets.

·         Used Tableau to construct graphs and plots to visualize Network, developed weekly and monthly dashboards.

·         Created Excel applications (VBA, Macros) to import historical data which include multiple databases and perform various statistical analyses, charts and graphs.

·         Performed Root Cause Analysis and Gap Analysis with targets and Sign Off of the contractual KPIs.

·         Direct analysis of billing information obtained from Intelligent Network and predicting the usage of Calls, Data and SMS using Tableau and Excel.

·         Created Scatter Plots, GG Plots, Matrix Plots, Box and Whisker plots using reference, according to deliverable specifications.

SQL Developer:     

·         Played a pivotal role in the development of an in-house reporting tool.

·         Worked on data validation and data quality issues by writing complex SQL queries and tested them

·         Designed logical structure of the database that serves the reporting functions of the customer, created and managed user privileges of the reporting team.

·         Developed and created new database objects including tables, procedures, advanced queries, views on the servers which led to replacement of the traditional Excel Macros in the organization.

·         Involved with Query optimization to increase the performance of reports.

Intern:            

·         Designed confidential audit reports for customers to be submitted to Telecom Regulatory Authority of India.

·         Cleansed data and involved in Tableau solution design, development, data visualization and implementation

·         Analyzed trends of KPIs for 3 Day Live Data and Monthly audit data for various locations.

Academic Projects:

·         Rossmann Store Sales (Kaggle Competition): Forecast 6 weeks store sales Rossmann Stores across Europe using promotions, seasonality, holidays and other competitor data using R .

·         Predicting a phishing website: Analyzed the data and built predictive models to predict if a website would be a phishing website or not using SAS and WEKA.

·         Renewal of Home Insurance Policy: Performed analysis on the effect of factors on the renewal of home insurance policy and built models to predict if an existing policy holder would renew it or not using R.

·         Performance testing of stock database: Built a database and tested advance database concepts like indexes, partitioning, DBA scripts and optimization techniques for reducing costs on real time stock data using Oracle 11G.