Data Professional Experience

Satwik Kodangal Varala

Phone No: 813-***-****, Email ID: ******.***@*****.***

Summary of Qualification:

* ***** ** ******** ********** in System Analysis, Database Design and Business Intelligence in different domains.

Complete Software Development Life Cycle (SDLC) experience with ability to meet deadlines and maintain expected productivity levels. 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.

Proficient with the concepts of SQL for aggregation in databases, SQL for analysis and reporting, visualizing data warehouse, OLAP, data mining in data warehouse, ETL and data quality issues.

Strong understanding of data warehousing concepts, OLTP, OLAP, Normalization, Star and Snow Flake data models.

Proficient in usage of SSIS Control Flow items (For Each Loop, For Loop & Sequence container, execute package, execute SQL tasks, Script task, send mail task) and transformations (Conditional Split, Data Conversion lookup, Derived Column, Aggregate, Multicast). Experience in creating jobs, SQL Mail, Alerts and schedule SSIS Packages using SQL Server Agent.

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

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

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

Excellent communication skills with people of all levels and roles and experience working with clients from on-site to gather requirements, allocate and monitor work among the team and being responsible for successful delivery of project.

Technical Skills:

Programming Languages : SAS, Core Java, PL/SQL, T-SQL; Operating Systems: Windows, Linux

Statistical Tools : SAS, R Studio, Weka, SPSS; Reporting Tools: SSRS, Tableau, Power BI

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

Tools: Putty, Hive, MS Visio, MS Excel, Visual Studio ; Data Mining; Project Management; Data Warehousing

Certifications:

SAS Certified Base Programmer for SAS 9.

SAS Certificate in Analytics and Business Intelligence.

Citi Certified Introduction to Anti-Money Laundering and Intelligent Analysis.

Professional Experience:

Achieva I.T Inc. (Client: Spirent Communications) Dec 2016 – Present

Report Developer and Analyst: Frederick, MD

Maintaining existing SSIS packages, scheduling loads and activities and creating new ones as per business requirements

Created SSRS reports using Report Parameters, Drop-Down Parameters, Multi-Valued Parameters, Cascading Parameters, Debugging Parameter Issues, Matrix Reports and Charts.

Created Tableau Dashboards with interactive views, trends and drill downs along with user level security.

Responsible for performing T-SQL tuning, optimizing queries for reports which take longer time for execution.

Develop quality control methods and procedures to improve the quality of the data collected by Field Engineers and the reports generated

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

Responsible for developing report structure and statistically correct methods of analysis by understanding the Statement of Work for custom projects in order to help OEMs meet their research objective and improve products.

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.

Spirent Communications Feb 2016- Dec 2016

Reports and Database Developer: Frederick, MD

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

Involved in design of the data warehouse architecture for AT&T and T-Mobile tests that were conducted by Spirent. Applied data warehousing concepts (Face Constellation Schema) to build the database.

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

Developing and automating reports for major carriers and handset organizations across the country using 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.

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

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

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

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

University of South Florida, Feb 2015- Dec 2015

Data Analyst Intern Tampa, FL

Worked closely with domain experts 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.

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.3.

Ericsson Global India Limited Jan 2012- Dec 2014

Business Data Analyst:

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

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.

Academic Qualifications:

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

Data Warehousing, Advance Database Management, Data Mining, Statistical Data Mining

Bachelor of Engineering in Electronics and Communication Manipal University GPA 3.8/4.00 May 2012

Academic Projects:

Database for Telecommunication: Built an OLTP database to monitor cell towers and improve performance of data retrieval and created reports using Oracle BI extensions.

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.

Contact this candidate