Sql Server Node Js

Anandhavalli Thiyagarajan

Denver USA : 303-***-**** : **************@*****.***

LinkedIn: https://www.linkedin.com/in/anandhavalli-thiyagarajan-83311321b Summary

Over 10 years of experience in developing scalable web applications with a focus on backend development and programming languages. Expertise in requirements analysis, testing, and API integration, consistently delivering high-quality software solutions on schedule. Proficient in HTML, SCSS, TypeScript, Angular, Python, Node.js, PHP, and SQL Server with strong skills in writing complex SQL queries and generating reports using Tableau. Solid understanding of SDLC phases and agile methodologies, actively participating in SCRUM meetings and utilizing JIRA for project tracking. Proficient in Snowflake, SQL, ETL/ELT pipelines, and cloud platforms

(AWS).

Key Skills

• Angular and Bootstrap

• CSS and SCSS

• HTML and XML

• JavaScript and

TypeScript

• RESTful API and

SOAP

• SEO strategies

• NPM and Docker

• Node.js and Express.js

• ETL Tools: Apache

Airflow

• Python-FastAPI, PHP development

• Agile methodologies

• Confluence and Jira

• MySQL and SQL Server

• Triggers, Function, Procedure, PL/SQL expertise

• CI/CD,Version control with Git, Code Cloud

• Design with Figma

• Data visualization tools: Tableau

• Snowflake: Snowpipe, Streams, Tasks, Time Travel

• Cloud Platforms: AWS (S3, Lambda)

Professional Experience

AT&T- Remote – USA

SENIOR SOFTWARE ENGINEER - 09/2021 - 01/2024

• Project OverView: AT&T employee portal application. Using Compass application, Manager can view the technician related information like technician vehicle information, performance, reports. Website: https://attcompass.dev.att.com

• Working as a full stack developer using Angular as a frontend, Python-FastAPI as a backend and SQL Server database

• Responsible for creating efficient design and developing User Interaction screens using HTMLS, CSS3, Bootstrap, JavaScript, Angular 14 and Python - FastAPI.

• Experience with creating custom directives, decorators, and services to interface with both restful and services.

• Implemented Angular Router to enable navigation from one view to the next as customer performs application tasks.

• Implemented lazy loading and Dynamic loading in the Angular routers. Worked on Typescript for building the code.

• Implemented HTTP requests using NGRX,RxJS Observable library to handle multiple values over time.

• Used various jQuery and Bootstrap plug-in like date picker, Bootstrap selectors.

• Used HTTP Call to send request to the server to check the functionality of the websites and for storing and exchanging information between browsers and servers.

• Analyze and resolve conflicts related to merging of source code for GIT.

• Troubleshooting performance or configuration issues with Database (DB).

• Involved in peer-to-peer code reviews using crucible code review.

• Created JSON request and validated the response using postman Interceptor and Swagger UI.

• Designed and developed the application using Agile Scrum methodology by breaking down the project to several sprints.

• Use JIRA tool for tracking new requirements, enhancements, bugs, and Git for version control.

• Document all the implemented features, enhancements, and improvements in a confluence page. Educational Measures, Greenwood Village, USA

Contractor - 06/2014- 03/2020

• Project Overview: Edtrak is used to take the survey from the various customers. Educational Measures collect the data & generate various types of report based on the client requirement. Website: www.educationalmeasures.com/

• Worked on Client-side validation/ request using PHP,Angular, Node.js, CSS, Javascript.

• Validated and tested the code by writing unit testing with PHPUnit test.

• Worked on the REST/Web API to create the services and tested on postman and used in Angular service calls and bind the data in the table.

• Used Shell scripts to filter and transform the huge amount of data in troubleshooting the issues.

• Implemented REST API using Node.js, Express.js.

• Troubleshooting performance or configuration issues with Database (DB).

• Worked on Client-side validation/ request using Angular,CSS, Javascript.

• Merged and Moved the code to Testing Environment using Github.

• Involved in peer-to-peer code reviews using crucible code review.

• Built dashboards and visual reports using Tableau to support data-driven decision making.

• Optimized dashboard performance by refining queries and minimizing load times.

• Built robust ETL pipelines using Airflow, loading data into Snowflake from external APIs and internal systems.

• Designed and implemented Snowpipe for near real-time ingestion of IoT data from AWS S3.

• Developed Streams and Tasks for change data capture (CDC) and automated downstream transformations.

• Implemented zero-copy cloning and Time Travel for data recovery and testing environments.

• Developed reusable stored procedures, functions and UDFs for business-critical data logic in Snowflake.

• Collaborated with data analysts to create optimized models and dashboards using Snowflake

• Integrated Tableau dashboards with multiple data sources including [e.g., SQL Server, Excel]. Education and Training

India Gandhi College• Trichy, India I Bachelor of Science Industrial Electronics

Nehru Memorial College• Trichy, India I Master of Science Computer Science

Personal Information

• Worked in AT&T(Remote), USA as a Senior Software Engineer from October 2021 to Jan 2024

• Worked as a Contractor in Educational Measures, GreenwoodVillage, CO, USA from July 2014 to March 2020 Visa Status: US Citizen

Contact this candidate