Tejas Shelar
Pune
Summary
To be able to utilize the knowledge already gained, in a responsible and proper manner to increase the growth of the organization by using my skills and abilities.
Experience in e-shopping system. Have hands-on experience in SQL Server and Snowflake. Excellent experience in Installation and configuration of different databases on Operating Systems LINUX and WINDOWS. An effective communicator with excellent interpersonal, logical thinking & analytical abilities.
Overview
7
7
years of professional experience
1
1
Certification
Work History
Data Analyst
Pharmarack Technologies PVT. LTD.
06.2022 - Current
- Executed SQL queries to extract, clean, and transform raw data from multiple sources, ensuring data integrity and accuracy
- Conducted exploratory data analysis to identify trends, patterns, and outliers, providing valuable insights to stakeholders
- Developed and maintained SQL scripts for automated data processing tasks, improving efficiency by 25%
- Created interactive dashboards and reports using SQL and visualization tools to communicate key findings to management
- Analysed customer purchase history to identify high-value segments and recommend targeted marketing strategies
- Utilized SQL queries to segment customers based on demographic and behavioural characteristics
- Presented findings to the marketing team, resulting in a 15% increase in customer engagement
- E-shopping system Pharmaceutical Industry (B2B)
Data Analyst
Qualsquad Infotech PVT. LTD.
11.2017 - 04.2022
- Developed robust software to generate reports for client use
- Participated in the entire project life cycle, interacting with clients, and contributing to performance monitoring, tuning, table design, and query optimization
- Resolved database-related queries, generated reports using SQL, and managed daily operations
- Executed Oracle database queries with various joining conditions, performed DML, DDL, DCL, and TCL on Oracle database tables
- E-shopping system Walmart (B2C)
Education
Bachelor of Engineering - Information Technology
Sinhagad Institute of Tech & Science
Pune01.2017
Diploma in Information Technology -
Government Polytechnic Pune
Pune01.2014
SSC -
Panchakroshi Adarshya Vidyalay
Nere01.2011
Skills
- Languages: SQL, Python
- Database Management Systems: MySQL, Microsoft SQL Server, Snowflake Database
- Tools/Technologies: SQL Server, Snowflake, Microsoft Excel, Looker studio (Data Studio), Blinker
- Data Analysis: Data Cleaning, Data Visualization, Statistical Analysis
- Reporting: Creating Dashboards, Report Generation
Certification
- Python Course: SEVEN Mentor
- SQL Database Certification: SEVEN Mentor
Disclaimer
I hereby declare that the above-mentioned information is correct up to my knowledge, and I bear the responsibility for the correctness of the abovementioned particulars.
Languages
Languages Known : English, Hindi, Marathi.
Timeline
Data Analyst
Pharmarack Technologies PVT. LTD.
06.2022 - Current
Data Analyst
Qualsquad Infotech PVT. LTD.
11.2017 - 04.2022
Bachelor of Engineering - Information Technology
Sinhagad Institute of Tech & Science
Diploma in Information Technology -
Government Polytechnic Pune
SSC -
Panchakroshi Adarshya Vidyalay
Similar Profiles
J.JENNIE PRINCEJ.JENNIE PRINCE
MARKETING EXCECUTIVE at PHARMARACK TECHNOLOGIES PVT LTDMARKETING EXCECUTIVE at PHARMARACK TECHNOLOGIES PVT LTD
VIJAYAKUMAR BVIJAYAKUMAR B
Regional Sales Manager at Pharmarack Technologies Pvt LtdRegional Sales Manager at Pharmarack Technologies Pvt Ltd
DIPAK PATILDIPAK PATIL
Business Analyst at Cognizant Technologies Pvt LtdBusiness Analyst at Cognizant Technologies Pvt Ltd