Sql Server Computer Science

ANANTH RANGARAJAN

+1-602-***-**** • ad7swv@r.postjobfree.com • https://www.linkedin.com/in/ananthrangarajan/ • https://github.com/rananth99 EDUCATION

Arizona State University, Tempe, AZ Aug 2022 – May 2024 Master of Science — Computer Science GPA – 4.00/4.00 PES University, Bengaluru, India Aug 2017 – May 2021 Bachelor of Technology — Computer Science and Engineering GPA – 8.63/10.00 SKILLS

Programming: Python, SQL, C++, Javascript, HTML

Databases: MySQL, Microsoft SQL Server, PostgreSQL, MongoDB, SQLite Frameworks: TensorFlow, Keras, Django, Flask, NodeJS, FastAPI, SDLC, Agile, DevOps, OOPs, CI/CD, Selenium, JUnit, SDLC, Linux Tools/Software: Tableau, Docker, SAS, SSMS, SSIS, SSRS, Git, Figma, Amazon Web Server (AWS), Azure, Postman, Excel WORK EXPERIENCE

Knipper Health, Somerset, New Jersey Jun 2023 – Aug 2023 Data Engineer Intern

● Engineered a robust automated ETL solution utilizing SSIS and SSMS to seamlessly migrate data from Excel files to SQL Server database, reducing manual effort by nearly 40%.

● Designed an error-logging mechanism for SSIS package to simplify debugging, and troubleshooting reducing manual debugging time by ~70%.

● Established an efficient reporting system using SSRS and SSMS software for data visualization, enabling clients to generate reports seamlessly on front-end, saving significant manual effort and improving overall efficiency by 60%. Deloitte USI (Offices of US), Hyderabad, India Feb 2021 – Jul 2022 Analyst

● Orchestrated implementation of an end-to-end ETL process leveraging SQL Server, SSIS, Excel VBA, and UI Path to streamline Excel-based reporting; resulting in a 50% reduction in manual labor and bug resolution time for team.

● Spearheaded cross-functional collaboration among a team of 6 to create interactive data visualizations utilizing SQL Server, Tableau, and SharePoint; empowered clients to make informed decisions.

● Collaborated with team to contribute to financial dashboard using .NET, Azure, and Microsoft SQL Server to reduce manual effort of generating financial reports by close to ~40%.

● Mentored 2 colleagues, providing strategic support and insights on team activities and ongoing projects within 4 weeks. Invendis Technologies India Pvt.Ltd, Bengaluru, India Jun 2020 – Jul 2020 Data Analyst Intern

● Architected an agile data pipeline utilizing Python, SQLite, Numpy, and Pandas to fetch and process massive data volumes from SQL Workbench seamlessly; optimized computational efficiency and attained a 30% reduction in processing time.

● Devised and implemented interactive data visualization dashboards using SQL Workbench and Tableau, enabling clients to uncover actionable insights and drive data-informed decision-making. ACADEMIC PROJECTS

Temporal and Spatial Reasoning with BERT Aug 2023 – Dec 2023

● Spearheaded optimization of BERT's temporal and spatial reasoning using ~2500 training samples generated using GPT-4.

● Engineered and curated a comprehensive dataset leveraging prompt engineering techniques to train and test BERT model resulting in improved model accuracy by 30%.

● Achieved 55% accuracy on BERT model using manually curated and annotated data from large language models (LLM) such as GPT-4. Clickbait Detection in YouTube Jan 2023 – May 2023

● Fetched YouTube video metadata such as title, description, thumbnail, comments, likes, and view count using Google YouTube API.

● Employed data preprocessing techniques such as vectorization, and standardization on obtained data, improving data quality.

● Led development and implementation of a Semi-supervised+XGBoost model nearly achieving 93% accuracy and a Semi-supervised+Random Forest model achieving close to 89% accuracy in classifying a video as clickbait or non-clickbait. RideShare Application Jan 2020 – May 2020

● Built backend functionalities for a ride-share application for maintaining rides.

● Established Client and Server functionalities such as creating, joining, and deleting rides.

● Devised a cutting-edge backend solution using Python, Flask, MySQL, Docker, Zookeeper, and RabbitMQ; accomplished seamless deployment on an AWS EC2 instance, resulting in enhanced system performance.

Contact this candidate