Post Job Free

Resume

Sign in

Software Engineering Sql Developer

Location:
McLean, VA
Posted:
April 12, 2024

Contact this candidate

Resume:

Haritha Injam

+1-571-***-**** ad4yq5@r.postjobfree.com linkedin.com/in/harithainjam/ https://github.com/human999-hub Education

Master of Engineering (M.Eng.) in Computer Science, VirginiaTech GPA: 3.90/4 Expected: May 2025 Relevant Coursework: Software Engineering, User Interface Software, Information Visualization, OS, Cloud Computing, Mobile App Dev Bachelors in Technology in Electronics & Communication Engineering, V R Siddhartha Engineering College, CGPA: 8/10 Relevant Coursework: C & Data Structures, Java, Python Aug 2014 - Aug 2018 Technical Skills & Certifications

Programming languages: C, Python, Java Databases: Oracle Database, SQL, PLSQL Web Development: HTML, CSS, JavaScript Tools/Frameworks/Libraries: GitHub, SQL Developer, VSCode, PyCharm WinSCP, Gantt Chart, Balsamiq WireFrames, Putty Familiar: Unix, MongoDB, JQuery, Django, React

Certifications: “Python for Everybody” from John Hopkins in Coursera, Certification in Java & Advanced Java from Naresh Technologies. Professional Experience

Associate Consultant, Capgemini Application Development Team Nov 2019 - July 2022

• Skillfully designed intricate SQL queries and PL/SQL functions, procedures and packages leading to the successful deployment of 5 major modules within the Toolkit Application.

• Engineered stored procedures in PLSQL that merged data and performed insert, update DML Operations and deletion of duplicate records; increasing the data accuracy by 95%.

• Modified queries as part of performance tuning to reduce the runtime from more than a minute to 2.5 secs.

• Worked with Python libraries like Pandas, NumPy for acquiring data from different input database sources, reporting the overview and dispatch emails using python libraries.

• Good experience in creation of Indexes and Constraints, Scheduler jobs and External Tables to migrate data from flat files.

• Implemented Synonyms, Sequence, User Defined Data Types and Nested Tables for the requirements. Database Compliance Analyst, Capgemini Cybersecurity, Database Compliance Team May 2019 – July 2022

• Designed the queries to fetch the list of 5 million+ users, corresponding roles & privileges three level down.

• Automated users list extraction process using SQL & PLSQL to assist access review team to perform database reviews reducing the time needed for extraction by 90%.

• Applied various Database Controls such as IDM Integration, IDM Linking, Default password reset for built in accounts, Audit enabling, profile reorganization, unidentified account cleanup in accordance with regulations like SOX, GDPR, IP, EC on 100+ Databases reducing non-compliance risks by 70%.

• Documented SOP for OS Data load into application, Functional Specification creation for Automation of DB Data load into application.

Examination & Evaluation System (Project), Capgemini Backend Team Dec 2018 - April 2019

• Devised an examination and evaluation system that performs several functions such as calculating the grade, finding out top performers, fetching required scores and handles any exceptional cases.

• Handled the creation and insertion of data into the database, Query resolving, Documentation of the project work, project presentation and resolved the maintenance updates.

Projects

PTCollab (User Interface Software): This web application is a collaborative platform between teachers and parents facilitating the exchange of student academic update information.

• Utilized HTML5, CSS and JavaScript to create a responsive and user-friendly interface including search functionality and dynamic content presentation.

• Implemented advanced user interaction features using jQuery and AJAX including search results display, real-time data manipulation and CRUD operations in an "Academic Updates" module.

• Created a secure multi-role user account system for Teachers, Parents and Admins in Django supporting customized views, profile management and interactive features like commenting and activity feeds and hosted the application on Heroku. Myntra Fashion Analytics Dashboard (using Dash Framework – Information Visualization) – View Dashboard

• Employed Pandas and NumPy for data manipulation and preprocessing on dataset exceeding 5 lakh+ records, including handling missing values, performing complex data transformations and aggregations improving data reliability by 95%.

• Developed a comprehensive web application using Dash, Plotly featuring custom user interactivity and real-time data analysis. Integrated various Plotly graphs and interactive elements to enhance user engagement and data exploration capabilities.

• Incorporated advanced statistical and machine learning methods like PCA and statistical tests (Kolmogorov–Smirnov, D'Agostino's K-squared, Shapiro-Wilk) for data analysis. Launched the application on Google Cloud Platform (GCP). Eventease (Software Engineering): Developed a web-based event management application for efficient host-guest communication and personalized event planning with features like custom invitations, dynamic data forms and interactive response tracking.

• Architected user-centric front-end interface using ReactJS, HTML, CSS, integrating with a Java-based backend using Spring Boot and MySQL for event creation and response management.

• Contributed to database design and setup, configured APIs for seamless image uploading and event data processing and deployed the application using AWS Cloud.

Awards & Honors

Appreciation from Client: Release of various Modules for IAM Toolkit Application, Query/Code Optimizations, POC - Establishment of Connection, IDM Integration of (AWS Oracle, AWS Postgres) Databases, Compliance of all in-scope Databases in SOx.



Contact this candidate