Raj Mehta

Experience

• 

  Self-employed

  Dec 2018 - Jan 2020

  Freelance

  Business Analytics Specialist• Conducted comprehensive data analysis for clients across diverse industries, extracting actionable insights to drive strategic decision-making and business growth.• Developed and implemented data visualization dashboards using tools like Tableau or Power BI, facilitating intuitive interpretation of complex datasets for stakeholders.• Collaborated with clients to define key performance indicators (KPIs) and metrics, designing customized reports and analytics solutions to monitor and evaluate business performance.• Conducted exploratory data analysis (EDA) to uncover hidden patterns and insights, guiding clients in making informed decisions and optimizing operational processes.Software Engineer• Developed and maintained custom software solutions and websites for clients across various industries, ensuring alignment with their specific business requirements.• Designed and implemented database architectures using SQL, PostgreSQL, or MongoDB, optimizing performance and scalability for client applications.• Utilized version control systems such as Git or SVN to manage codebase changes and track project progress, ensuring transparency and accountability throughout the development process. Show less

• 

  RKIT Software Pvt. Ltd.

  May 2019 - Aug 2019

  Software Engineer Intern

  • Worked on a .Net-based Windows application tailored for industrial accounting purposes.• Designed and developed business websites for clients using HTML, CSS, and JavaScript• Demonstrated ability to work effectively in a team environment and deliver quality solutions that meet client requirements.• Enhanced understanding of software development lifecycle (SDLC) processes and best practices in project management.

• 

  Wellness Space LLP

  Jan 2020 - May 2020

  Business Analyst

  • Developed a custom Tableau dashboard, enhancing investor portfolio management with daily metrics and market comparisons for a 5 million INR portfolio.• Achieved a 15% portfolio return increase for 45 clients by optimizing investment ratios using Python scripting.• Implemented a high-accuracy (98%) Long Short-Term Memory (LSTM) model for stock price trend prediction.• Built a model using Tensorflow to perform Aspect Based Sentiment Analysis which helped the client strategize business plans.• Contributed to a financial paper on “Stock portfolio management using Pareto and Quadrant analysis.” Show less

• 

  Indian Navy

  May 2020 - Jul 2020

  Data Analyst

  • Developed a python-based algorithm to extract business insights from unstructured data and organize and curate ancient legacy data for the Indian Navy's use in inventory management and upcoming AI applications.• Delivered critical operational performance indicators with Tableau and Python graphics.• Created reports automatically for each new motor data inflow to assess performance; using clustering method to identify and locate anomalies.

• 

  Bank of America

  Jul 2020 - Dec 2021

  Software Engineer

  • Designed and developed a C#/.NET Windows application and a Web application as part of the "OPTIMA" project, which aims to replace an outdated vendor product (APL) that costs $15 million annually with an in-house, scalable, state-of-the-art infrastructure for managing portfolios for managed account advisors.• Using ASP.NET, we developed desktop and windows applications that interfaced with intricate databases.• Wrote intricate stored procedures and SQL queries to maintain databases.• Reviewed and reorganized the current codebase to make it easier to read and maintain.• Set up pipelines for Jenkins CI and CD for automated deployment procedures. Show less

• 

  University of Illinois Chicago

  Aug 2022 - May 2023

  Graduate Teaching Assistant

  Instructed, mentored, and graded 200 students in statistical tests, ANOVA, regression and correlation analysis, hypothesis testing, predictive modeling (linear & logistic regression), time-series analysis & data visualization, using MS Excel, SPSS, R and Tableau. Also graded students for Project management and Vendor management assignments.

• 

  HCLTech

  Jan 2023 - May 2023

  Analytics Consultant

  • Led a consulting engagement for HCL America, conducting an in-depth evaluation of Remote Patient Monitoring (RPM) technologies.• Designed and developed PillMate, an advanced mobile medication voice reminder system, to improve patient adherence, optimize healthcare costs, and enhance health outcomes.• Performed market analysis in the RPM sector, identifying business opportunities through telehealth, wearable technology, and digital health solutions.• Created a scalable Software-as-a-Service (SaaS) revenue model for PillMate, incorporating subscription services and data analytics targeted at pharmaceutical companies, with an annual revenue potential of $1-2 million.• Coordinated with cross-functional teams to align the product roadmap with industry demands and client expectations, ensuring a user-focused approach to medication management.• Delivered financial forecasts and presented value propositions to stakeholders, emphasizing potential market reach and competitive advantage. Show less

• 

  Panorama Consulting and Engineering Inc.

  Mar 2024 - now

  Computer System Analyst

  • Collaborated with Panorama's Bio-tech engineers to develop data analysis tools for mammalian cell culture processes, using Core Java, Advanced Java,Spring Framework, SQL Server, TypeScript, Web API, React JS, Angular 10, HTML, CSS, JavaScript, Node.js, and SQL database.• Implemented effective data integration and enhanced the productivity of SQL jobs.• Designed and maintained new software systems using Java technologies, applying mathematical models and scientific analysis to predict outcomes andmeasure design consequences. Utilized UI technologies such as Angular and React, along with APIs in Java and Node.js, and supported relationaldatabases.• Executed coding, configuration, maintenance, installation, testing, and debugging tasks, while managing timelines and generating technicaldocumentation. Developed applications using UI (Angular, React), APIs (Java, Node.js), and supported relational database.• Conducted in-depth requirement analysis, utilizing SQL and RDBMS concepts to develop data models and create tailored reports that address critical business insights.• Designed and implemented data workflows and processes to optimize information flow, enhancing the efficiency of various business functions.• Acted as a liaison between technical and non-technical stakeholders, ensuring alignment on project objectives, timelines, and outcomes.• Facilitated project planning and documentation, including project implementation plans, user stories, and acceptance criteria to streamline communication and ensure project success.• Created Power BI dashboards integrating multiple data sources, providing real-time insights on key performance indicators that streamlined reporting processes by 30%.• Assisted with quality assurance by defining test cases, validating solutions, and performing user acceptance testing, ensuring project deliverables met all client specifications. Show less