Shourya Punj

Business Technology Analyst

ZS Associates•  July 2018 - July 2019

•Created the cloud-based data warehousing solution for commercial analyticsfor Australia based client. •Primarily worked as ETL developer creating Postgresql queries on AWS cloud databases such as redshift, rds.Built the different layers of data warehousing for different data sources. From loading data from s3->ec2->rds into base tables then creating stage tables after cleaning datain level 1. Generated sk’s for different Dimensions and populated them in Fact tables in level 2. After creation of reporting tables, datawas sent to redshift using s3and then to Microstratedgy to create detailed dashboards. •Was involved in the whole software development lifecycle (requirement gathering -> developing -> testing -> deploying) with the other 8 core team members.

Software Engineer

Reflexis Systems•  January 2018 - June 2018

•Programmed Reflexis Workforce Scheduler as a backend and front-end developer in Java and Angular. •Product was built using Java, Spring Framework, Angular JS, DB2 and SVN was used for version controlling. •Developed team working skills, gained experience in the field of software development.Learnt about new tools such as Eclipse and SVN and new technologies such as Spring Framework

Software Engineer

Ofbusiness.com•  July 2017 - December 2017

•Coded Tender Crawler Framework as a back-end developer in Java.Technologies involved were Java, Spring Boot, Git Hub and IntelliJ was used to develop the product. Jsoup library was used for crawling the data