Summary
Work History
Education
Skills
Work Availability
Timeline
Generic

Jahnavi Patchipalu

Data Analyst
Pembroke Pines,FL

Summary

Overall, 5.5 Years of experience in the areas of Data Science, Assistant Manager in Data Operations-Underwriting, and Customer Support Executive in Retail Credit services. Experience in Data Extraction, Data Modelling, Data Wrangling, Statistical Modeling, Data Mining, Machine Learning, and Data Visualization. Domain knowledge and experience in Retail and Banking industries. Expertise in transforming business resources and requirements into manageable data formats and analytical models, designing algorithms, building models, and developing data mining and reporting solutions that scale across a massive volume of structured and unstructured data. Proficient in managing the entire data science project life cycle and actively involved in all the phases of the project life cycle including data acquisition, data cleaning, data engineering, Exploratory analysis, feature scaling, features engineering, statistical modeling, parameter fine-tuning in supervised Machine Learning models, testing and validation, and data visualization. Expertise in transforming business requirements into analytical models, developing data mining, designing algorithms, and reporting solutions that scale across the massive volume of structured and unstructured data. Developed ML predictive models, and customer segmentation models by using Python, and R and created dashboards using tools like Tableau, and Power BI. Prepared reports and presentations to share insights and findings with Business stakeholders.

Work History

Business/Data Analyst Intern

Lufthansa Technik Component Services
Miami Lakes, FL
2023.01 - 2023.06
  • Translate customer requirements into targeted products or enhancements of existing products
  • Analyze the potential for growth and support product sales
  • Strategy for Business and Product Management
  • Performed data processing to prepare for each analytics task
  • Performed exploratory data analysis and visualization to get a better appreciation of the data
  • Developed predictive models, customer segmentation, and other analytical tasks
  • On a monthly basis created dashboards on given data
  • Prepared reports and presentations to share insights and findings with our clients
  • Strong business sense and ability to communicate data insights to both technical and non-technical clients.

Project 1:

· Explored and analyzed customer-specific features by using the R programming language.

· The objective of segmenting customers is to conclude how to identify low-hanging fruit customers in each portion to augment the estimation of every customer in the business.

· Transferred data from unstructured to structured format to make it more appropriate for analysis, creating new datasets, experimental frameworks to collect data, and building tools to automate data collection.

· Transform the raw data into a more valuable and productive.

· Created documentation in R.

· Performed Exploratory Data Analysis, Data orchestration, Data processing, Data imputation, Data Extraction, Data Wrangling, Data Mining and visualization.

· Prepared reports and presentations to share the findings with the business stakeholders.

Project 2:

· Once the data has undergone all necessary data transformations and is in an organized format.

· Structured data has been used to create graphs and an interactive dashboard is made by combining all the visualizations.

· Built a shiny dashboard using ui. R and server. R to analyze the materials purchased by the customers and based on the insights we can draw a business decision

· Prepared the reports and presented the interactive dashboard to share the findings with the Director of fulfillment & product Sales and Business Development Manager

· The organization is yet involved in using my code template to build a dashboard that shows potential customers.

Graduate Assistant

St Thomas University
- 06.2023
  • Checked books in and out at the front desk
  • Helped students locate books, reference material online, and leisure reading materials
  • Collected and cataloged library resources including books, films, and publications
  • Assisted students and guest users with internet access and ensured their technical needs are met
  • Managed inquiries at the circulation desk and via email or telephone
  • Opened and closed the library.

Assistant Manager

Hongkong and Shanghai Banking Corporation (HSBC)
Visakhapatnam, India
11.2019 - 08.2021
  • Gathered, analyzed, documented, and translated application requirements into data models and Supports standardization of documentation and the adoption of standards and practices related to data and applications
  • Underwriter requires to do Input quality and verification for Retail credit applications, has complete freedom to act within the prescribed authority, and involves screening information accurately to clarify situations that will help in making a favorable retail credit lending decision for the bank
  • Once the decision has been made, we analyze the data to see the delinquency and repayment history of the existing customer as well as the new customer
  • Generated complex calculated fields and parameters, toggled and global filters, dynamic sets, groups, actions, custom color palettes, and statistical analysis to meet business requirements
  • Designed, developed, and maintained daily and monthly summary, trending, and benchmark reports repository in MS Excel Desktop
  • Delivered and communicated research results, recommendations, and opportunities to the managerial and executive teams, and implemented the techniques for priority projects.

Customer Support Executive

Hongkong and Shanghai Banking Corporation (HSBC)
Visakhapatnam, India
06.2016 - 10.2019
  • Made Final lending decisions on unsecured products such as personal loans, overdrafts & credit cards pertaining to the Oman region
  • Reviewed and suggested amendments in policies & procedures to promote efficiency and accuracy
  • Providing support to Businesses with various Reports as per requirements
  • Handling of User Acceptance testing under testing environments and shared results for adjustments
  • Provided on-the-job training & support to other team members
  • Built and maintained relationships with branch representatives while providing expert advice
  • Suggested ideas that would make an impact on the business and Improve the Customer Experience.

Education

Master of Science - Big Data Analytics

Saint Thomas University
Opa-locka, FL
06.2023

Bachelor of Science - Mechanical Engineering

Maharaj Vijayaram Gajapathi Raj
Vizianagaram, Andhra Pradesh, India
05.2015

Skills

  • Programming Language: R, Python, SQL
  • Databases: MySQL, Azure, AWS, Postgres SQL, SQLite, MS SQL Server 2016/2014/2012/2008 R2/2008, MS Access and Snowflake
  • Statistical Methods: Hypothetical Testing, ANOVA, and Time Series
  • Machine Learning: Regression and classification analysis, Bayesian Method, Decision Tree, Random Forests, Sentiment Analysis, K-Means Clustering, and KNN
  • Data Visualization: Power BI, Tableau, Matplotlib, Seaborn, ggplot
  • Tools: MS Excel, MS PowerPoint, MS Word

Work Availability

monday
tuesday
wednesday
thursday
friday
saturday
sunday
morning
afternoon
evening
swipe to browse

Timeline

Business/Data Analyst Intern

Lufthansa Technik Component Services
2023.01 - 2023.06

Assistant Manager

Hongkong and Shanghai Banking Corporation (HSBC)
11.2019 - 08.2021

Customer Support Executive

Hongkong and Shanghai Banking Corporation (HSBC)
06.2016 - 10.2019

Master of Science - Big Data Analytics

Saint Thomas University

Bachelor of Science - Mechanical Engineering

Maharaj Vijayaram Gajapathi Raj

Graduate Assistant

St Thomas University
- 06.2023
Jahnavi PatchipaluData Analyst