Rushabh Vakharia - Resume
Rushabh Vakharia
PROFESSIONAL EXPERIENCE
Business Intelligence Developer November 2019 � Present
iCube Consultancy Services, Inc, Jacksonville, FL
Building HIPAA compliant healthcare applications by automating ETL processes across thousands of rows of data which reduced manual workload by 23% monthly.
Spearheading the data ingestion efforts for our 4-person team to communicate findings and solutions to the end-users.
Ingesting 125000+ health data records from disparate sources using a combination of SQL and Python to create data views for BI tools like Tableau.
Collaborating with clients to understand business needs and translating those business needs into actionable reports in Tableau saving 3 hours of manual work each week.
Producing meaningful executive dashboards with effective business metrics and KPIs to help senior leadership draw insights.
Data Analyst Intern March 2019 - May 2019
Munich Reinsurance America, Inc, Princeton, NJ
Integrated data from 200 PDF files and 23 JPG files into the Pandas data frames using Python library tabula-py.
Streamlined the process of data loading in MySQL by optimizing Python codes.
Customized SQL procedures and queries to generate reports for clients and stakeholders saving 2 hours each week.
Software Developer Intern May 2018 - August 2018
Acord Solutions Group, Pearl River, NY
Programmed Lambda functions in Python to fetch insurance data from AWS S3 buckets to MySQL and simplify data modification.
Structured and defined insurance data by compiling tables, stored procedures, and views.
Tuned queries and performance of relational databases by proper usage of indexes and reduced fetch time of records by 40%.
Administered error logs using CloudWatch and controlled AWS services using CLI.
Software Engineer June 2015 - July 2017
BNP Paribas India Solutions Pvt. Ltd, Mumbai, India
Extracted trade and price feeds from upstream systems into Sybase and consolidated access time to the data.
Programmed sophisticated SQL queries and revamped the existing business logic for the stakeholders.
Automated the existing intermediate system and enhanced its trade processing capabilities using Bash scripting.
Developed Shell Scripts to automate regression testing and increased productivity by 33%, saving 5 hours of manual work.
SKILLS
Programming Languages: SQL, Python, R, Bash.
Frameworks & Technologies: Hadoop, Apache Hive, Apache Spark, HDFS, Flume, Sqoop, HBase.
Other Tools and Software: Tableau, SAS, Advanced Excel, PowerPoint, JIRA, Confluence, Git, SSIS.
Core Strengths: Data Analytics, Business Intelligence, Data Visualization, Data Engineering, Data Warehousing, A/B Testing
Soft Skills: Problem-solving, Adaptability, Leadership, Attention to detail, Curiosity.
EDUCATION
Stevens Institute of Technology, Hoboken, New Jersey May 2019
Master of Science, Information Systems.
University of Mumbai, Mumbai, India May 2015
Bachelor of Engineering, Computer Science.
Rushabh Vakharia
PROFESSIONAL EXPERIENCE
Business Intelligence Developer November 2019 � Present
iCube Consultancy Services, Inc, Jacksonville, FL
Building HIPAA compliant healthcare applications by automating ETL processes across thousands of rows of data which reduced manual workload by 23% monthly.
Spearheading the data ingestion efforts for our 4-person team to communicate findings and solutions to the end-users.
Ingesting 125000+ health data records from disparate sources using a combination of SQL and Python to create data views for BI tools like Tableau.
Collaborating with clients to understand business needs and translating those business needs into actionable reports in Tableau saving 3 hours of manual work each week.
Producing meaningful executive dashboards with effective business metrics and KPIs to help senior leadership draw insights.
Data Analyst Intern March 2019 - May 2019
Munich Reinsurance America, Inc, Princeton, NJ
Integrated data from 200 PDF files and 23 JPG files into the Pandas data frames using Python library tabula-py.
Streamlined the process of data loading in MySQL by optimizing Python codes.
Customized SQL procedures and queries to generate reports for clients and stakeholders saving 2 hours each week.
Software Developer Intern May 2018 - August 2018
Acord Solutions Group, Pearl River, NY
Programmed Lambda functions in Python to fetch insurance data from AWS S3 buckets to MySQL and simplify data modification.
Structured and defined insurance data by compiling tables, stored procedures, and views.
Tuned queries and performance of relational databases by proper usage of indexes and reduced fetch time of records by 40%.
Administered error logs using CloudWatch and controlled AWS services using CLI.
Software Engineer June 2015 - July 2017
BNP Paribas India Solutions Pvt. Ltd, Mumbai, India
Extracted trade and price feeds from upstream systems into Sybase and consolidated access time to the data.
Programmed sophisticated SQL queries and revamped the existing business logic for the stakeholders.
Automated the existing intermediate system and enhanced its trade processing capabilities using Bash scripting.
Developed Shell Scripts to automate regression testing and increased productivity by 33%, saving 5 hours of manual work.
SKILLS
Programming Languages: SQL, Python, R, Bash.
Frameworks & Technologies: Hadoop, Apache Hive, Apache Spark, HDFS, Flume, Sqoop, HBase.
Other Tools and Software: Tableau, SAS, Advanced Excel, PowerPoint, JIRA, Confluence, Git, SSIS.
Core Strengths: Data Analytics, Business Intelligence, Data Visualization, Data Engineering, Data Warehousing, A/B Testing
Soft Skills: Problem-solving, Adaptability, Leadership, Attention to detail, Curiosity.
EDUCATION
Stevens Institute of Technology, Hoboken, New Jersey May 2019
Master of Science, Information Systems.
University of Mumbai, Mumbai, India May 2015
Bachelor of Engineering, Computer Science.