Prem Kshatri

+91-975-***-**** adtv9w@r.postjobfree.com linkedin.com/in/premm-kshatri-48697a23a

E X P E R I E N C E S

Data Analyst Goyal Securities Services 06/2021 - 10/2022

● Gathering, combining, and processing the member data to create insightful reports which focus on developing holistic perspectives of membership trends by translating data into ready-to-use tools for executive decision-making.

● Developed tables, and views using SQL. Compiled, evaluated, and reviewed engineered data for the internal system. Pull data to build charts and graphs as needed.

● Providing analytical support for the department’s / company’s long-range strategic plan and overall performance.

● Explained data results and discussed how best to use data to support project objectives.

● Expertised in writing python scripts to scrape web data for data usage/collection using BeautifulSoup, Scrapy, Selenium.

● Worked on various complex modules in python including JSON, XML, Xpath, Request.

● Good experience in developing web applications implementing MVC architecture using Django. Jr. Data Analyst Ozyus Technologies 02/2019 - 04/2020

● Performed verification and validation for accuracy of data in the monthly/quarterly reports.

● Created a new reporting tool in Python (Stream lit) to track website usage statistics which replaced an existing system with over 100% more efficiency.

● Developed Python programs for manipulating the data reading from various DB and convert them as one CSV file, update the content in the database tables.

● Created a data warehouse using SQL Server and Excel to store, organize, and analyze large amounts of data.

Web Developer Addone Computers 01/2018 - 01/2019

● Strong expertise in Web Application development using PHP5 with OOPS, MySQL, Ajax.

● Conceived and designed database tables in MYSQL 5.

● Responsible for creating admin automated tools which make easy CRUD operations.

● Worked with MVC architectural( Laravel ) pattern, developed web applications using this pattern.

● Worked on more than 10 websites and web applications of different domains. S K I L L S

Programming: SQL, Python, Php Data Visualization: Excel, Google Sheet, PowerBI Selenium Data Analysis Web Scraping Web Development MVC Framework GIT Python libraries: Beautifulsoup, Scrapy, Selenium, Pandas, Seaborn. E D U C A T I O N

Bachelor of Engineering 03/2013 - 06/2017

Chhattisgarh Swami Vivekanand Technical University