Sql Developer Information Technology

Suma Sri Vajinepalli

Iselin, NJ *****************@*****.*** 848-***-**** www.linkedin.com/in/suma-vajinepalli

EDUCATION

Jawaharlal Nehru Technological University

Hyderabad, India

Bachelor of Science in Information Technology: GPA 9.4

Aug 2019– May 2023

TECHNICAL SKILLS

•Languages: Python, Java, C

•Operating Systems: Windows, Linux,Ubuntu

•Databases: MySQL, Oracle, Microsoft SQL Server

•IDES: PL/SQL Developer, Oracle SQL Developer, Pycharm, Jupyter Notebook, Microsoft Visual Studio 2012, Eclipse

•ETL Tools: Oracle Data Integrator 12c

•Web Frameworks and Modules: OpenCv, NumPy, Pandas,Tkinter

•Penetration Testing & Vulnerability Assessment Tools: Nmap, Faraday, Kali Linux

•Incident Response, Forensics & Network Security Monitoring Tools: Security Onion OS, Cyberchef, Wireshark

•Other Skills: Object-oriented design, Distributed systems, Algorithms, Linear Programming

WORK EXPERIENCE

ACCENTURE Banglore, India

Software Development Engineer July 2022 – May 2025

•Involved in the whole life cycle of ETL development, which included design, an ETL approach, debugging, reporting, and identifying facts and dimensions.

•Used Python and SQL to extract data from various sources such as APIs, files, Web scrapping, relational databases and perform data transformations.

•Data migration (import & export – BCP) from Text files to SQL Server tables.

•Strong experience in designing databases, physical/logical schemas, building T-SQL stored procedures, complex SQL queries, Procedures, Shell scripts, views, triggers, normalization, performance tuning, data modelling and security implementation for SQL server databases.

•Utilized ODI 12c capabilities for seamless data integration and transformation, ensuring optimal data quality.

•Designed and developed re-usable transformations and mapplets, significantly reducing development time by re-using these components across various mappings.

•Created complex ETL mappings, implemented various transformations such as Aggregators, Lookups (connected and unconnected), Filters, Routers, Joiners, Source Qualifiers, Expressions, Stored Procedures, Sorters, and Sequence Generators to streamline data flows.

•Automated the daily, weekly, and monthly ETL job schedules, integrating complex dependencies and error handling mechanisms that minimized downtime by 30% and improved system reliability.

•Implemented comprehensive monitoring solutions for load runs that reduced data discrepancies and integrity issues, ensuring over 99% data accuracy and supporting key decision-making processes.

•Demonstrates the ability to effectively communicate complex technical challenges and solutions as well as solve the ambiguous problems by applying abstract thinking to devise innovative solutions.

PROJECTS

Penetration Testing and Network Security Assessment for a WMU internal Library

•Led a team in conducting comprehensive Penetration Testing for an internal library, evaluating network and transaction security. Utilized Microsoft Visio for network mapping, Cisco Packet Tracker for system inventory.

•Set up client organization infrastructure with LAMP stack, including Apache2, DNS Server (Bind9), and Middleware servers on Ubuntu & Windows.

•Conducted Vulnerability Assessment using Kali Linux with Nmap and OpenVas. Managed tracked vulnerabilities using Faraday and performed Web Application Testing with OWASP ZAP and SQL injection.

•Used Metasploit to identify vulnerabilities, using its huge catalog of exploits and payloads to simulate attacks and assess system vulnerabilities, hence improving overall security posture.

Facial Recognition Attendance System Using Python

•Automated attendance tracking using facial recognition from images or live video streams.

•Used Python, OpenCV for image processing, and Tkinter for the GUI. Captured photos of individuals to create a dataset.

•Used OpenCV’s Haar Cascade algorithm for real-time frontal face detection and Implemented Fisher face algorithm for recognition, updating attendance records in Excel.

CERTIFICATIONS

•Certificate of Cybersecurity (CC) by ISC2

•Professional Python, Java & SQL Programmer – Certified by HackerRank

•Certified by CISCO networking academy for completion of Programming Essentials in C & Programming Essentials in PYTHON

Contact this candidate