Summary
Overview
Work History
Education
Skills
Certification
Timeline
Languages and Tools
Sahil Ahuja

Sahil Ahuja

Specialist, Database Developer
Noida

Summary

SQL Developer with 7+ years of progressive experience in PLSQL, Snowflake, MySQl, MS-SQL Server databases and application programming. Dedicated to building customized technical solutions and Snow pipelines in alignment with operational needs and objectives. Critical thinker, analyst and problem solver known for continuous delivery of quality products across diverse business environments.

Overview

9
9
years of professional experience
4
4
years of post-secondary education
3
3
Certificates
2
2
Languages

Work History

Specialist Software Engineer

Fiserv India Pvt Ltd
03.2021 - Current
  • Participated in continuous improvement by generating suggestions, engaging in problem-solving activities to support teamwork.
  • Designed and implemented TSQL queries for reporting and complex solution development.
  • Developed, implemented and optimized stored procedures and functions using T-SQL.
  • Participated in requirement gathering and implementing SnowFlake.
  • Using SnowSQL, I helped in migrating on-prem databases to cloud.
  • Developed snow pipe for continuous data ingestion from S3 bucket to Snowflake database.
  • Also familiar with PUT, GET, COPY commands in Snowflake.
  • Wrote Snowflake stored procedures using Snowflake SQL scripting.
  • Dynamically create and execute SQL statements.
  • Also took part in developing ELT jobs for reporting purposes using Matillion.

Senior Development Associate

Decimal Technologies
03.2019 - 02.2021
  • Conducted tests to identify issues and make necessary modifications.
  • Implemented security measures to protect vital business data.
  • Evaluated, designed, implemented and modified databases and database applications.
  • Created and updated database designs and data models.
  • Set up and controlled user access levels across databases to protect important data.
  • Built databases and table structures for web applications.
  • Created technical documentation for database technologies, providing updates.
  • Wrote and maintained technical and functional specifications to document database intentions and requirements.
  • Identified issues within databases, performed troubleshooting and implemented effective solutions.
  • Developed scripts and processes for data integration and maintenance.
  • Developed custom database objects, stored procedures and delivered application support.
  • Designed and implemented SQL queries for reporting and complex solution development.

Software Engineer

Skil Lotto Solutions Pvt Ltd
01.2016 - 03.2019
  • Reviewed project specifications and designed technology solutions that met or exceeded performance expectations.
  • Accepted agile methodologies and development best practices to division to enhance product development.
  • Worked with customers for needs analysis.
  • Analyzed existing SQL queries to identify opportunities for improvements.
  • Developed custom database objects, stored procedures and delivered application support.
  • Designed and developed customized extract, transform and load (ETL) applications per client specifications.

QA Intern

07.2015 - 10.2015
  • Responsible for Manual Testing, Test Case Designing, Test Case execution,
  • Regression Testing, Functional Testing, Improvements and enhancements in application, Quality Assurance.

Education

B.Tech - Information Technology

ITS Engineering College, Greate Noida
04.2012 - 04.2016

Skills

PLSQL Development

undefined

Certification

SQL (Basic) Certificate Hackerrank

Timeline

Specialist Software Engineer - Fiserv India Pvt Ltd
03.2021 - Current
Senior Development Associate - Decimal Technologies
03.2019 - 02.2021
Software Engineer - Skil Lotto Solutions Pvt Ltd
01.2016 - 03.2019
QA Intern -
07.2015 - 10.2015
ITS Engineering College - B.Tech, Information Technology
04.2012 - 04.2016

Languages and Tools

  • Languages: Snowflake SQL, PLSQL, MySQL, Oracle, MS SQL Server
  • Tools: MySQL Workbench, SnowSQL CLI, Snowflake WEB UI Putty, Winscp, SSMS (SQL Services Management Studio), SQL Developer, Microsoft Visual Studio, Matillion ELT, DBT
  • Versioning: GitLab, Github.
  • CI/CD Tools: Ansible, Jenkins, Octopus.
Sahil AhujaSpecialist, Database Developer