Vishal Loharkar

Working as Big data analyst on Spark scala, Hadoop ecosystem.

Worked for British Telecom Client as Hadoop and Big Data developer on Hdoop, Spark Scala

In this project we are developing an upgraded DB & DW product of gPharma on AWS cloud. gPharma is an product developed by Model N Inc for their Healthcare domain clients like Allergan. It has customized configuration specific to every client and it is very cumbersome and difficult to add new clients. An effort involved in configuring the same product for different clients with different configuration is time consuming process.

Written PIG Latin scripts as per the business requirement. SQOOP tool was used to import/export data. • Performed migration of dimensions and facts from Postgres database to AWS Redshift database, used Amazon S3 storage Services. • Conducted research and evaluation of alternative database solutions to recommend effective solutions. • Prepared automated reports for delivery of information to take effective business decisions.

Worked for Microsoft Hyderabad as in SQL Monitoring Team. Roles/Responsibilities: • Provide support in the following components : o SQL Jobs troubleshooting. Worked for BMW in EDW dev & support line: Development and Production support was owned by different teams. Roles/Responsibilities: • Implemented ETL using Hive, Sqoop, Pig, and UNIX shell scripts for task automations. • Worked efficiently in Scrum an agile software development framework.

Computer Programming, Operating System I & II