Summary
Overview
Work History
Education
Skills
Accomplishments
Certification
Work Availability
Affiliations
Quote
Work Preference
Software
Languages
Interests
Timeline
Generic
N v s k Rao

N v s k Rao

Aspiring Data analyst
Vishakhapatnam

Summary

  • Aspiring Data analyst with strong expertise in Power BI, SQL, and data visualization tools. As an intern I have demonstrated proficiency in analytics,visualization, management, and leadership. Possess strong communication skills and a keen eye for detail, ensuring accurate interpretation and presentation of findings to stakeholders. Dedicated to continuous learning and staying updated with emerging trends in data analytics to drive innovation and business success.

Overview

15
15
years of professional experience
9
9
years of post-secondary education
4
4
Certificates

Work History

Research Scientist

Jubilant Biosys Limited
3 2018 - 9 2021
  • Design and synthesis of novel chemical entities in drug discovery programs such as target to hit, hit to lead and lead optimization
  • Designing novel chemical entities (in collaboration with Silico Molecular Modelling Group)
  • Biological profiling of the designed compounds (In collaboration with our in-vitro and in- vivo biology groups)
  • Responsible for optimal utilization of resources in the specific project team through monitoring, measuring and reporting on scientific issues, opportunities and developmental plans.

Internship

Data Mites
01.2021 - 12.2021
  • Power BI Expertise: Developed reports and dashboards using Power BI and SQL.
  • Data Visualization: Completed 10+ projects on data visualization and analysis.
  • Effective Communication: Presented complex concepts to non-technical stakeholders.
  • Machine Learning Knowledge: Developed models and provided business solutions.

Senior Research Associate

Jubilant Biosys Limited
10.2006 - 03.2018
  • Complex molecules from grams to multi kilos

Education

MBA - Finance

Andhra University
01.2012 - 05.2015

PG - Organic Chemistry

Depaul College
01.2002 - 05.2005

B.Sc - MPC

Gayatri Degree College
01.1998 - 05.2000

Skills

Methodologies: Agile Methodologies

Accomplishments

Project 1:Human Resource Analysis Report using Power BI

  • Employee Count and Departments: 64 employees across 15 departments, with an average salary of $6M.
  • Gender Distribution: 34 males and 30 females, indicating near-equal gender representation.
  • Education Levels: Most employees have advanced degrees, with 22 Doctorates, 15 Masters, and 14 Bachelors.
  • Performance Ratings: Majority rated as good or outstanding, showing high employee performance levels.
  • Tech Stack: Microsoft Power BI
  • Solution: Designed and developed interactive dashboards using advanced analytics tool Power BI

Project 2: Customer Financial Behavior

  • Monthly Sales Trends: October and December peak in sales, indicating successful year-end promotions.
  • Product Performance: Paseo and VTT lead sales at $12.65M and $11.75M, respectively.
  • Customer Segmentation: Government and Small Business segments drive 78% of total sales.
  • Discount Impact: Low discounts result in $30.01M sales, proving minimal discounting is effective.
  • Geographical Insights: Germany and France lead in sales, highlighting regional succes
  • Tech Stack: Microsoft Power BI
  • Solution:Designed and developed interactive dashboards using advanced analytics tool Power BI

Project 3:Tech Edge Healthcare Analysis Report

  • Molecules by Vendor: Zydus and Sunpharma dominate molecule supply with 40 and 20 units respectively.
  • Product Sub-Category: Pediatric products lead with 133 IDs, followed by 71 adult and 23 infectious disease products.
  • Product ID by Location: Chennai and Nashik are top locations with 85 and 55 product IDs respectively.
  • Pack Price by Brand: Aluvia and Viramune are highest priced, indicating a focus on premium brands.
  • Tech Stack: Microsoft Power BI
  • Solution: Designed and developed interactive dashboards using advanced analytics tool Power BI
  • Used Microsoft Excel to develop inventory tracking spreadsheets.

Certification

Certified Data Scientist @ IABAC™ - International Association of Business Analytics Data mites, Bangalore- DEC 2021

Work Availability

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

Affiliations

  • Association of Information Technology Professionals

Quote

Each small task of everyday life is part of the total harmony of the universe.
Saint Thérèse de Lisieux

Work Preference

Work Type

Full TimePart TimeInternshipContract Work

Work Location

RemoteOn-SiteHybrid

Important To Me

Healthcare benefitsCompany CultureWork-life balanceCareer advancementPaid sick leaveFlexible work hoursWork from home optionPersonal development programs401k matchPaid time off4-day work weekTeam Building / Company Retreats

Software

Methodologies: Agile Methodologies

Database: MySQL, MS Access, Database Systems

Programming Languages: Python, SQL Queries

Data Visualizations: Microsoft Power BI, Tableau

Languages

English
Bilingual or Proficient (C2)
Hindi
Advanced (C1)
Telugu
Bilingual or Proficient (C2)

Interests

Writing Blogs

Author

Timeline

POWER BI Specialization with DAX@ PAWAN LAL JUN-2024

01-2024

Odin School Data Science boot camp DEC-2023

01-2023

Business intelligence using POWER BI@SKILL NATION DEC-2023

01-2023

Internship

Data Mites
01.2021 - 12.2021

Certified Data Scientist @ IABAC™ - International Association of Business Analytics Data mites, Bangalore- DEC 2021

01-2021

MBA - Finance

Andhra University
01.2012 - 05.2015

Senior Research Associate

Jubilant Biosys Limited
10.2006 - 03.2018

PG - Organic Chemistry

Depaul College
01.2002 - 05.2005

B.Sc - MPC

Gayatri Degree College
01.1998 - 05.2000

Research Scientist

Jubilant Biosys Limited
3 2018 - 9 2021
N v s k RaoAspiring Data analyst