Adarsh D

Experience

• 

  Tata Consultancy Services

  Jun 2012 - now

  Project Responsibilities:• Building ad hoc & annual campaign views in Snowflake as per business requirement.• Analysing data discrepancies in complex SQL views.• Developing Snowflake procedures, tasks and UDFs with Python as per requirement.• Data ingestion from cloud & offline sources into Snowflake tables and handling failures.• Automating & Scheduling data ingestion from Snowflake to Amazon S3 & Azure data landing zone.• Supporting downstream systems for data dependencies / enablement of Snowflake views and tables.• Building pipelines to expose Snowflake DB objects / ingesting data into Snowflake tables using Spring Boot Rest API.• Developing Python scripts for consuming API responses and exporting them to CSV files.• Migrating DB Objects to production and maintaining version control using Git Hub / SharePoint. Show less Project Responsibilities:• Attending UBR (User Business Requirements) Calls• Providing Effort & Cost Estimates based on HLA.• Analysis and Designing Solution Approach• Design Document Preparation and Walk through with business users.• Splitting the development task to sub tasks and assigning to team.• Code Development, Debugging and Unit Testing• Integration Testing and Test Log Preparation• Conducting code and test log reviews• Interfacing Systems Testing and Data Setup Coordination• Facilitating UAT Demo and closing UAT comments if any.• Deployment Plan, Operations Manual Preparation• Organizing OPS & Deployment Walk through• RFC Submission and Follow ups.• Deployment & Sanity Testing• Post Deployment Support• SVN Trunk UpdateA Glimpse of Projects Handled:• Created several future proof solutions in most of the projects assigned and saved repetitive requirements cost to client.• Improved application performance by converting Single Threaded to Multi-Threaded Applications in frontend (Java) and backend (C).• Converted a bare metal RHEL OS to fully functional application server.• Migrated 6 physical application servers to 3 VMs with adequate resource planning (vCPUs, RAM and storage) for improving application performance.• Migrated application from Solaris to RHEL & RHEL to CentOS.• Migrated application from Java 1.3 to 1.7 and to 1.8• Migrated Web Server from Apache JServ to Apache Tomcat• Performed Upgrades for JRE, Web Servers (Apache HTTP & Apache Tomcat) in Application Server.• Implemented load balancing in Web Servers.• Created Java Apps for processing Excel Sheets, Converting CSV to Excel to E-Mail reports using Apache POI and Java Mail API• Optimized application performance by reducing the core file generation count from three digit to single digit per day.• Automated several trouble shooting tasks of OPS Teams with shell scripting.• Improved performance of several shell scripts by parallel processing Show less

  • SQL Data Analyst & Backend Java Developer

    Jan 2022 - now

  • Technical Lead

    Jun 2018 - Dec 2021

  • Senior Developer

    Jun 2016 - Jun 2018

  • Developer

    Jun 2012 - Jun 2016