Information Technology Entry-Level It

Sophiya Yelisala

Murfreesboro, TN *****

+1-615-***-**** *********@*****.***

Education

Middle Tennessee State University Master of Science: Cybersecurity GPA: 3.953 Murfreesboro, TN Lakkireddy Balireddy College of Engineering Bachelor of Technology: Information Technology GPA: 3.30% Mylavaram, India Objective: Motivated and detail-oriented Cybersecurity Master’s student with a strong foundation in cyber threat analysis, vulnerability assessment, penetration testing, and cloud security. Proficient in identifying and mitigating security risks, with a focus on emerging cyber threats. Fluent in English and eager to apply my academic knowledge and hands-on skills in an entry-level IT or cybersecurity role. Committed to contributing to a dynamic team and further developing expertise in cybersecurity best practices. Skills

• Languages: SQL.

• Database: MySQL, SQL Server, MongoDB

• Data Analysis Tools: SAS, Microsoft Excel. Data Visualization: Tableau.

• Protocols: HTTP, SMTP, TCP/IP, UDP.

• Operating Systems: Windows, Linux, MacOS

Projects

Tableau Project: House Prices Prediction Dashboard

• Utilized advanced SQL queries to extract and cleanse house price datasets from Zillow. Conducted data preprocessing, including cleaning, transformation, and feature engineering, using Excel.

• Employed Tableau for comprehensive data exploration and visualization. Analyzed relationships between house prices and various factors such as property size, location, amenities, and market trends, deriving key insights into the primary drivers affecting house prices.

• Developed and implemented predictive models in Python using libraries such as Scikit-learn and Pandas. Integrated these models into Tableau dashboards, enabling interactive visualizations of predicted house prices under different scenarios and input parameters. Enhancing MySQL Database Security and Migration to GCP

• Spearheaded MySQL security project, integrating 2-factor authentication, access control, and role-based authentication.

• Orchestrated seamless migration to GCP, leveraging Google Computing Engine and Cloud SQL for enhanced security.

• Implemented sophisticated triggers, stored procedures to enforce robust security measures, ensuring the integrity and confidentiality of data. Experience

Middle Tennessee State University Murfreesboro, TN 08/2023 – current Graduate Assistant

• Implemented SQL logins, roles, and authentication models to enhance data protection and access control. Automated repetitive tasks with Python scripts, reducing manual effort by 30% and increasing task throughput by 20%.

• Created ad hoc and scheduled reports using SQL, including HERD, Unclaimed Properties, and student university choice analysis, supporting operational performance metrics and process improvements.

• Designed and maintained dynamic forms to streamline data collection and processing, reducing data entry errors by 40% and improving processing efficiency by 25%.

• Developed tools and reports to improve data management for distribution center and transportation operations, contributing to process improvements and cost reduction.

• Proficient in using Excel for reporting, data analysis, and visualization to effectively communicate complex information.

• Provided personalized guidance to students on using Word and Excel for problem-solving. Conducted thorough grading of assignments and generated detailed grade reports with Excel.

• Collaborated with faculty to align the curriculum with industry best practices, incorporating current trends in Microsoft Word and Excel to enrich the learning experience.

• Provided Excel tutoring and graded assignments to support students' skill development and understanding. Robert Half Nashville, Tennessee 02/2018 - 04/2019 Helpdesk and Mobile Tester

• Documented and organized files, ensuring accurate record-keeping and easy accessibility for team members.

• Managed front-desk responsibilities, including greeting clients, answering inquiries, and handling requests to support a positive client experience.

• Developed strong communication skills, fostering a collaborative environment and enhancing overall customer satisfaction.

• Functional & Regression Testing: Conducted functional, regression, and usability testing across various mobile devices, ensuring compatibility with Verizon's mobile network services. Identified, reported, and tracked defects using JIRA, ensuring high-quality application performance before production release.

• Cross-Device Compatibility Testing: Tested mobile applications across a wide range of devices and operating system versions to ensure seamless integration with Verizon’s network, services, and mobile features. Provided valuable feedback on UI/UX improvements based on testing results.

• Collaboration & Communication: Collaborated with cross-functional teams (development, QA, product management) in an Agile environment to ensure testing timelines were met and that the product met Verizon's high standards for security, performance, and functionality.

• Bug Tracking & Reporting: Used JIRA and TestRail to log, track, and prioritize bugs. Ensured effective communication with development teams to facilitate the timely resolution of critical issues and participated in daily stand-ups to update teams on test progress.

• Security Testing: Performed security testing on mobile apps to identify potential vulnerabilities, ensuring that apps adhered to Verizon’s security standards and data privacy regulations. Conducted tests for authentication, data encryption, and session management.

• Customer Experience Focus: Provided valuable insights into enhancing customer experience by identifying usability issues, performance lags, and network-related problems that could affect end-users. Visa Status: Authorized to work in the U.S. without visa sponsorship; Green Card holder.

Contact this candidate