• Built datamarts in Redshift using Star Schema and supporting the new requirements which includes addition of new country reports or modifying the existing data structures as per the business needs. • Migrated all the Oracle based reports to AWS Owned redshift. This involved conversion of Oracle table structures and SQLs to redshift. • Developed Perl scripts to connect to Redshift and generate the CSV/HTML reports for tax filing purpose. • Built an end-to-end system in Java to make API calls to 3rd party website and get the data to validate the Amazon’s data with European government website to perform taxation. • Developed multiple OBIEE reports along with designing the Physical, Business and Presentation Layer for OBIEE in RPD. • Designed and Developed an internal website for Amazon, which is used for analyzing and creating dashboards based on the data. • Integrated 3rd Party BI tool “SuperSet” to work with Amazon’s eco system and is now widely used across the company for Analytics purpose. • Designed and developed a solution to eliminate the process of manual checks while creating a service request ticket using ReactJS. As ReactJS cannot perform backend operations, I developed the RestAPI service for the same which creates a new ticket or extracts the list of existing tickets.

• Developed applications to bring data from multiple sources using ETL process

• Designed end-to-end application which reconciles the data between multiple and huge sources and sends out the notification

• Trained newly joined interns on existing architecture

• POC for migrating the Oracle Based Reports to AWS Owned Redshift.