About Me
Skilled in Redshift, S3, Other AWS components, Oracle, SQL, Perl, Java, HTML & PHP and developed multiple applications using these technologies. I worked for Amazon for 3.6 years where I was responsible for moving data from different sources and ...
Show MoreSkills
Web Development
Database
Programming Language
Operating System
Development Tools
Others
Graphic Design
Portfolio Projects
Company
Building Data Marts
Description
• 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.
Show More Show LessTools
SQL DeveloperCompany
Migrating data from Oracle to Redshift
Description
• 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.
Show More Show LessTools
SQL Developer