SAI GOWTHAM VASIREDDY
HOUSTON,TX
Summary
Logical Data Analyst skilled in requirement analysis, software development and database management. Self-directed and proactive professional with 2 years of vast experience collecting, cleaning and interpreting data sets. Natural problem-solver possessing strong cross-functional understanding of information technology and business processes.
Overview
2
2
years of professional experience
Work History
Database Engineer
CCS Global Tech
Poway, CA
04.2022 - Current
- Prepared comprehensive backup and recovery strategies, ensuring consistent data integrity and accessibility through scheduled backups, and verified recovery protocols
- Optimized server configurations, ensuring hardware resources were appropriately allocated to support database workloads
- Developed advanced SQL queries, utilizing subqueries, functions, and common table expressions to extract insights from complex datasets
- Utilized diagnostic tools and techniques to quickly identify root causes of database server issues, implementing effective solutions to restore service functionality
- Identified and resolved performance bottlenecks, optimizing database configurations, indexing strategies, query optimization, and resource utilization monitoring
- Incorporated dynamic SQL to develop customizable queries and enhanced existing T-SQL operations utilizing different system functions, joins, set operators, sub-queries, and CTEs
- Developed code concerning security vulnerabilities and enforced security policies, access controls, and encryption mechanisms to protect sensitive data from unauthorized access
- Monitored database activity and audit logs to detect and investigate security incidents to mitigate any risks
- Configured alerts and notifications to proactively identify and respond to potential issues, such as disk space shortages, memory leaks and other database errors
- Created various objects for the data warehouse, ensuring accuracy and integrity of data through analysis, coding, profiling, and problem resolution
- Supported data architecture and modelling tasks by gathering requirements and performing data integration and deployment activities
- Contributed to various research projects and quality improvement initiatives, assisting with data and statistical analysis
- Created documentation for database schema, code, report design, data dictionary, and report usage processes to facilitate knowledge sharing and maintainability
- Facilitated effective communication by discussing internal requirements, modifications to third party software providers based on technical needs and supported with documentation and data, accordingly.
Teaching Assistant
Washington State University
- Collaborated with the Professor and assisted in planning and executing instructional activities
- Prepared, organized materials, and conducted regular office hours to provide additional support and clarification to students
- Assisted students in understanding course content, assignments, and projects
- Responded to student inquiries through email, discussion forums, or in-person regarding course material, assignments, and projects
- Provided technical support for tools and platforms, such as online learning platforms or software and helped in troubleshooting technical issues that students may encounter.
Education
Bachelor of Science in Computer Science, Parallel Computing, Computer Security, Data Science, Introduction to Data Mining, Advanced Data Structures, Design & Analysis of Algorithms -
Washington State University
12.2021
Skills
- SQL and Databases
- Business Intelligence
- Data Modeling
- Data Analysis
- Performance Tuning
- Database Design
- Big data technologies
- Data Migration
- Database Administration
- Data Warehousing
- Interpersonal Skills
- Time Management
- Report Generation
- Team Collaboration
Technical Forte
SQL, Python, R, HTML, JavaScript, CSS, MS Visio, ER-win, T-SQL, Dynamic SQL, MDX, DAX, BIDS, SSDT, SSMS, SSIS, SSAS (OLAP Cubes, Tabular Model), Jitterbit, Precision LM, SQL Server Reporting Services, Power Platform (Power BI, Power Automate, Power Apps, Power View, Power Query), Excel Power BI, MS Azure (IaaS, PaaS, and SaaS), MS DevOps, Azure SQL, Azure Data Factory, PowerShell
Projects
SENIOR CAPSTONE PROJECT: MICROSOFT (mentor), 01/2021, 12/2021,
Gained hands-on project management and development skills by regularly participating and contributing towards weekly meetings, which were sponsored and held by Microsoft. Improved a Text-to-SQL Natural Language Processing model as a team, which automatically translates the user’s natural language English questions into an executable SQL query for a database. Played a key role in enhancing the model with a suggestion system for the next relevant word, and the model is further extended to support different forms of SQL.
Data Science: Protein Sequence Clustering, 08/2021, 12/2021,
Built similarity networks to analyze and interpret data to identify trends, patterns and classify SARS-CoV and SARS-CoV-2 proteins by using Network Clustering. Applied an all-nearest-neighbors network model to protein sequence data and examined the structural properties of the networks by comparing the model against threshold-based networks to validate their semantic equivalence.
Timeline
Database Engineer
CCS Global Tech
04.2022 - Current
Teaching Assistant
Washington State University
Bachelor of Science in Computer Science, Parallel Computing, Computer Security, Data Science, Introduction to Data Mining, Advanced Data Structures, Design & Analysis of Algorithms -
Washington State University
Similar Profiles
Iram AnwarIram Anwar
Executive Sale processer at Itech global, The nexus solution, Global I techExecutive Sale processer at Itech global, The nexus solution, Global I tech
Vishwas SrivastavaVishwas Srivastava
Software Development Engineer - III at Walmart Global Tech India Pvt LtdSoftware Development Engineer - III at Walmart Global Tech India Pvt Ltd
Charles SomervillCharles Somervill
Avionics Technician/Engineering Liaison (in Training) at Global Aviation TechAvionics Technician/Engineering Liaison (in Training) at Global Aviation Tech
SHARON GUERREROSHARON GUERRERO
Logistics Specialist at Army National GuardLogistics Specialist at Army National Guard
Mikala JaramilloMikala Jaramillo
Software Engineer - Execute Trading Platform (Web Development) at JP MorganSoftware Engineer - Execute Trading Platform (Web Development) at JP Morgan