Prem Kshatri
+91-975-***-**** ************@*****.*** 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