Summary
Overview
Work History
Education
Skills
Timeline
Generic

Surya Teja Kamisetti

Austin,TX

Summary

Logical Data Analyst skilled in requirement analysis, software development and database management. Self-directed and proactive professional with 4+ years of vast experience collecting, cleaning, and interpreting data sets. Natural problem-solver possessing strong cross-functional understanding of information technology and business processes. Qualified Business Intelligence Analyst versed in data mapping and user acceptance testing to solve complex problems in high-pressure environments. Activates strong analytical skills to investigate trends in large amounts of data and formulate conclusions based on findings. Excels at cultivating, managing and leveraging client relationships to foster extended engagements and business opportunities. Meticulous SQL Developer with expertise in processing data and knowledge of various flowcharting techniques. An excellent understanding of database structures, theories, principles, and practices. Superb problem-solving and analytical skills.

Overview

6
6
years of professional experience

Work History

Data Analyst

Google
Austin, TX
08.2023 - Current
  • Collected, tracked and evaluated current business and market trend data.
  • Leveraged SQL queries to extract, transform and load data into databases.
  • Optimized existing database structures for better performance on analytics tasks.
  • Maintained documentation of all the processes related to Data Analysis.
  • Assessed programs to identify risks or problems to determine appropriate responses.
  • Recommended metrics and models based on observed trends.
  • Gathered and organized data to analyze current industry trends.
  • Utilized advanced analytics tools such as SAS, SPSS, Excel PowerPivot, to manipulate large volumes of structured and unstructured data sets.
  • Conducted live demonstrations of Tableau dashboards to internal stakeholders.
  • Prepared test data for string, unit, and parallel testing.
  • Developed and maintained Tableau dashboards for clients to visualize data.

Data Analyst/Tableau Developer

Dish Networks
Denver, CO
05.2023 - 07.2023
  • Gathered and organized data to analyze current industry trends.
  • Designed automated ETL processes for efficient data extraction, transformation and loading in order to improve accuracy and reliability of reporting systems.
  • Assessed programs to identify risks or problems to determine appropriate responses.
  • Utilized data analysis to monitor process efficiencies and identify data integrity exceptions.
  • Interacted with non-technical stakeholders to deliver analyses and answer questions on deliverables.
  • Translated raw data into meaningful information using statistical techniques.
  • Recommended metrics and models based on observed trends.
  • Integrated external APIs with internal systems for improved analytics capabilities.
  • Leveraged SQL queries to extract, transform and load data into databases.
  • Defined KPIs based on collected data sources.
  • Analyzed large datasets to identify trends, patterns and correlations for business insights.

.NET Developer/SQL Developer

Callippus Software Solutions
Hyderabad, Telangana
11.2020 - 08.2021
  • Integrated object-oriented design and development techniques into projects to support usability goals.
  • Worked in MVC .Net to maintain the ration shop dealers ui
  • Maintained the data base and worked on SQL stored procedures
  • used LINQ queries to integrate the DataBase to stored the data for the new entries
  • created Grid views to display the data which is presented in the ration shop dealers regional wise
  • used jquery ,Ado.net ,Html5,CSS,Java Script to maintain the UI for the ration shop dealers
  • used SQL,MYSQL,DynamoDb,PostgresSql to store the data and retrieve the data used LINQ
  • Worked on Stored Procedures for the code re-usability
  • Designed complex reports using SQL Server Reporting Services.
  • Developed ETL processes using SSIS packages for loading data from various sources into a data warehouse environment.
  • Created database objects like tables, views, indexes and synonyms in Oracle 11g and 12c databases.

.Net/Sql/Productionsupport

BostonLogix
Hyderabad, Telangana
07.2020 - 02.2021
  • Worked on production environment for the client J&J to maintain and generate the reports using SQL as per the tickets assigned in the Amazon work spaces
  • Created reports from the J&J data bases which has dev,pre-prod,Prod environments data
  • created UI for the J&J scientists to represent their formula's status such as obsolete ,active,ready to go,prod
  • written SQL queries to retrieve the data from the data base as per the scientists requirement
  • Aligned the reports into a particular rows and columns by using the SQL queries
  • Integrated multiple tables using join queries as per the scenario
  • involved in prod support on calls to address the issues .

Data Analyst

Adwait Algorithm
NELLORE, AndhraPradesh
07.2018 - 06.2019
  • Provided technical support for existing reports, dashboards or other tools.
  • Defined KPIs based on collected data sources.
  • Generated standard or custom reports summarizing business, financial or economic data.
  • Generated reports and obtained data to develop analytics on key performance and operational metrics.
  • Worked with internal teams to understand business needs and changing strategies.
  • Designed automated ETL processes for efficient data extraction, transformation and loading in order to improve accuracy and reliability of reporting systems.

Education

Computer Science

Texas A&M University - Commerce
Commerce, TX
05-2023

Bachelor of Science - Computer Science

JNTUA
AndhraPradesh
03-2018

Skills

  • SQL Reporting
  • Data Modeling
  • Data Storage and Retrieval
  • Databases: Oracle, MongoDB
  • Database Management Software
  • Software Documentation Control
  • star Schema ,snow flake modelling
  • Tableau 8,2/81/80
  • Amazon Web Services
  • Programming Languages: Java, C#, Net, Python

Timeline

Data Analyst

Google
08.2023 - Current

Data Analyst/Tableau Developer

Dish Networks
05.2023 - 07.2023

.NET Developer/SQL Developer

Callippus Software Solutions
11.2020 - 08.2021

.Net/Sql/Productionsupport

BostonLogix
07.2020 - 02.2021

Data Analyst

Adwait Algorithm
07.2018 - 06.2019

Computer Science

Texas A&M University - Commerce

Bachelor of Science - Computer Science

JNTUA

Similar Profiles

CREATE PROFILE
Surya Teja Kamisetti