SIMRAN D. MODI

adh5il@r.postjobfree.com **** Montezuma road, 14 Dorchester, San Diego, CA-92115 619-***-**** Professional Experience

Programmer Analyst at Tekfortune, USA May 2020-August 2020

• Work majorly consisted of performing RCA and managing large datasets using Hadoop( HDFS,YARN, MapReduce) and JIRA tool for creation of tasks and subtasks. Keeping a track of issues and using combination of problem-solving thinking and SQL and shell scripting knowledge, successfully addressed the issues.

• Digging deep into the problem statement and extracting all information from the team mates thereby avoiding any missing puzzle, I gained exposure to JIRA tool. This gave me an opportunity gain cross functional team experience, requirements gathering, system architectural design and knowledge of turning the requirements into final product.

• Using Hive, I could create integrate MapReduce function to SQL, this made it easier to fetch data and for this I used knowledge of detailed system design using use case analysis, functional analysis, modeling program with class & sequence, state and activity diagrams using UML.

• Using Python and MySQL, helped Tekfortune study their market trends and analyzed ways to beat the market and have functionality improved by retaining 62 clients and expanding client pool

• Ability to communicate, work effectively and create meaningful and achievable KPI’s.

• Exposure and strong background in mathematics helped in quickly associating the issues to solutions thereby opportunity to enhance my critical thinking and analytical skills. Research Analyst Student Assistant at SDSU October 2019-Present

• Doing analysis of taxation process in Real Estate by providing visualization of the factors supported by Knowledge Management and DSS which play a role while determining House rates in various States and Counties

• Performing research with team members and extensively using NumPy and pandas to do the analysis of investment of money in various projects.

Customer Service Analyst at Orange Business Services, Mumbai, India February 2019-May 2019

• Visualizing Network usage for 3 clients by using Power BI and doing RCA to eradicate issues by suggesting company solutions which resulted in consolidated saving of $8200 per month

• Worked in 3 Cross Functional teams to gain insight of SQL server database and modified company’s internal framework

• Developed Strategies to be an efficient link between Site Managers and Non-Technical Customers Business Associate at Indo Appliances, Mumbai, India July 2017-February 2019

• By using Tableau, analyzed sales made by company and performed ETL process on 3.6 Million+ records present in inventory management system to identify Most Valuable Customers

• Used Python for generation of Sales reports for Indo Appliances. Buttons were added to validate Data on the Report and to send mail to recipients using the send to option, created website using wordpress.

• Extensive usage of R programming helped me evaluate website and web resources to ensure - highest quality service was provided to customers determined by feedbacks of customers and return rate of products over the given time frame Projects

Divyang Aadhaar (The Cognitive Assistance) – Performed Analysis to meet the needs of 5 to 14-year-old dyslexic children by incorporation of Medical side and doing Knowledge Management used for inclusion of graphics and gaming concepts which were engaging for them and improved lifestyle of 92 kids until now. By usage of MicroStrategy BI, it is evident that Children’s speed of learning has increased up-to 2 times, with positive graph of retention capacity and increased confidence Insulin Dose Decision Support System – Identification of correct time to have Insulin dose for Type 1 diabetic patient and determining the change causing environment by doing Data Mining on historical data Python Projects-

• Data Analysis and prediction of Fake Job postings using python.

• Implement Principal Component Analysis (PCA) with NumPy and Python- Using Seaborn and Matplotlib created simple data visualizations and conducted exploratory data analysis (EDA) on various features of sepals and petals.

• Build, evaluate, draw and interpret a support vector machine by importing data into and manipulating a pandas data frame. Checked for missing data and performed One-Hot Encoding on data. This was done on data set to determine if the patient suffers from heart disease or not.

• Traffic sign classification using Python and Keras to perform deep learning. Skills

• Visualization and Analysis Tools- MicroStrategy BI, Tableau, Google Analytics, Power BI, PowerPoint, SAS VA

• Database and Business Related- SQL,MySQL ETL, E-Business Concepts, MS Excel, SAP, JIRA framework, SDLC

• Programming Languages- C, Java, Python, Scala, Spark, R programming, Pandas, Django, NumPy

• Big Data Eco system- Hadoop, Hive, YARN, MapReduce, HDFS

• Front-end Development- UI/UX web development, CSS, JavaScript, HTML, Adobe Photoshop

Contact this candidate