Summary
Overview
Work History
Education
Skills
Projects
Timeline
Generic
Meet Joshi

Meet Joshi

Ahmedabad

Summary

Strategic Consultant and Analyst Goal-driven Analyst polished in managing and breaking down large volumes of information. Proactive at heading off issues in operations, workflow and production by uncovering trends affecting business success. Over 3 years of experience in IT industry. Detail oriented analyst with 3 years of experience conducting analysis and research to come up with solutions to common business problems. Polished in formulating business improvement strategies and overseeing new technology and system implementation. Commercially-aware professional with in depth knowledge of computing systems and project management techniques.

Overview

5
5
years of professional experience

Work History

Analyst

Tata Consultancy Services
Waukegan
06.2023 - 03.2024
  • Working on application called SAM (Smart auto Mapper) which consists of a data repository that allows storage, conformance, and archival of clinical data from systems internal to the Above environment and from external sources such as clinical data management systems
  • Writing SQL queries to fetch relevant data from different repository and further doing analysis on it
  • Working with Business stake holders for understanding requirements and then creating Jira stories and use confluence documentation
  • Creating the ERD diagrams
  • Perform deployment activities in Prod environment using Azure pipeline
  • Manage the process of requirements from client and communicate them to development team.

Techno function consultant and Analyst

Amazon Web Services (AWS)
Seattle
09.2022 - 02.2023
  • Engaging in functionality and User acceptance testing for both website and mobile applications
  • Translating the abstract concepts and ideas of business users into clear and understandable requirements and process models
  • Analyzed and defined business requirements to research and gather information to translate them into functional specifications that guide the development team
  • Worked on AWS Technologies like Dynamo DB, AWS Lambda for optimization AWS predictions
  • Created the Jira story for production releases, worked with software developers for analyzing the use of our AWS service
  • Worked on No SQL for fetching the data from AWS Dynamo dB and created the dashboard for presenting to our stakeholders.

Jr Analyst

Techmicra IT Solutions
Ahmedabad
12.2018 - 12.2020
  • Collaborated closely with business stakeholders to gain a deep understanding of their requirements and goals
  • Gather records and scrutinize business demands, procedure, and operational sequences
  • Created detailed documentation including business requirements, process flows, user cases, and user stories
  • Converting stakeholder requirements into various deliverables, including business requirements documents (BRD) and software requirements specifications (SRS) among others and crafting business proposals.

Education

Master of Science in Management Information Systems -

University of Houston-Clear Lake

Bachelor of Technology in Information Technology -

Dharmsinh Desai University

Skills

  • Microsoft excel Agile methodology, Presales, Post sales, Project Elicitation, Technical Commercial proposal, Solution architect, RFP/RFI, CRM
  • Python
  • AWS, Jira, Confluence, Wireframing, Flow charts, User stories, User cases, Gap analysis, SAP
  • Oracle Database, MySQL, MSSQL, Google big query, SQL, NoSQL
  • Tableau, Power BI
  • DynamoDB, Lambda, EC2, Cost explorer, RDS
  • Communication, Microsoft word, Inter-personal skills, Problem-solving, Analytical thinking, Project management, Team Management, Leadership, Product management, Strategy consultation

Projects

Realized Accuracy Calculator (RAC)

  • Create script for deleting old data from forecasting-metrics table using DynamoDB with AWSlambda CDK.
  • For deleting the rows scan whole table and find rows which do not have TTL and update TTL torows. DDB will delete them automatically when time reaches TTL. This time reaches every 30 days. Additionally, Developed the command line for this script.

Private Pricing 

  • Implemented multithreading logic in the back testing API script.
  • Recorded the execution time for a fixed number of requests with the thread value of 2, 5, 10 and how it was initially with the single thread.
  • Implemented the long-term fix of calling the back testing script via AWS services instead of dev-desktop. Additionally, developed the command line for this logic.

Credit Card Fraud Detection 

  • Directed a team of four to assess dataset of 284,807 transaction utilizing python SVM to find fraud on credit card.
  • Developed system for that ad attained 94.3% accuracy detected 492 frauds from the dataset.
  • Delivered product solution to institutional and corporate clients, done balanced model performance tuning.

Telco Customer Churn 

  • Predicted which telecom service (phone service, internet service, streaming TV, Online Backup) used frequently with an accuracy of 82%
  • Utilized Python for running xGBoost, Random Forest, SVM, and ADA Boost to figure out the churn.
  • Reduced the cost of the project to 20% by using smart devices set up and making the system fault-tolerant and scalable.

Predict request on Sulekha 

  • Led a team of 4 to predict and analyze from which area most requests are made to use the product on the website.
  • Applied Machine Learning algorithms SVM, Random Forest, and ANN in RStudio and achieved an accuracy of about 86% for prediction.
  • Utilized Google Analytics, AdWords and merged them with the prediction model to get the companies with the highest rating and their contact information.

Timeline

Analyst

Tata Consultancy Services
06.2023 - 03.2024

Techno function consultant and Analyst

Amazon Web Services (AWS)
09.2022 - 02.2023

Jr Analyst

Techmicra IT Solutions
12.2018 - 12.2020

Master of Science in Management Information Systems -

University of Houston-Clear Lake

Bachelor of Technology in Information Technology -

Dharmsinh Desai University
Meet Joshi