Experience

Sidecar Health

• United States
• Insurance
• 1 - 100 Employee

• Data Engineer

  • Jul 2020 - Present

  California, United States



Rossi Labs, LLC

• United States
• Software Development
• 1 - 100 Employee

• Software Engineer

  • Mar 2019 - Jun 2020

  Morristown, New Jersey · Developed Reports on Pentaho and published on Pentaho Server. Connected to and Retrieved data from AWS Aurora and modeled the relational data using SQL to develop reports. · Worked on AWS Lambda. Written a lambda function read the files from AWS S3 bucket and load them into AWS RDS. Used triggers to detect if the file is uploaded to S3 bucket to trigger Lambda function. · Used AWS Cloudwatch to monitor the log files and create an AWS SNS event to notify once the data is… Show more · Developed Reports on Pentaho and published on Pentaho Server. Connected to and Retrieved data from AWS Aurora and modeled the relational data using SQL to develop reports. · Worked on AWS Lambda. Written a lambda function read the files from AWS S3 bucket and load them into AWS RDS. Used triggers to detect if the file is uploaded to S3 bucket to trigger Lambda function. · Used AWS Cloudwatch to monitor the log files and create an AWS SNS event to notify once the data is completely loaded. · Worked on AWS Glue. Created a crawler for the CSV/Excel file in S3 bucket and created a job event which will push the data in the file to AWS Aurora RDS table. Tracked the cloudwatch logs to create an Event Rule to send a notification once the process is complete. · Worked on Periscope to create data frames using Pandas and Numpy for Regression Analysis of data. · Worked on a project for Ecosense Lighting. Extracted the data from Netsuite into Sisense Elasticube. Made custom tables using SQL and mapped the tables accordingly. · Worked on Sisense Elasticube for multiple projects. Connected to different data stores to pull the data into Elasticube manager. Modeled the data using star schema and connected them based on client's requirements. · Created a foreign-data wrapper for REST API on PostgreSQL using Multicorn to execute SQL queries to retrieve data from the API. · Developed Dashboards and Graphs on Sisense user interface using the Elasticubes developed. Show less



Persistent Systems Limited

• Softwate Intern

  • Jan 2015 - Jun 2015

  Pune -Developed the employee management application using Salesforce for CRM, using Agile methodologies - Created visualizations and representations using Salesforce Analytics Cloud and GitHub for version control - Collaborated on a project for OpenTable, used TeamCity for build-management and continuous integration