Sreenath S N K Vaidyula

With internship experience of 1 year on Data Analytical tools with Power BI,SQL, Adv. Excel and basic Python. Gathering end users/customers’ requirements and creating functional and technical specification documents. Imported data from multiple data sources into BI Tools, created relationships between data, created calculated columns and measures using DAX Query and creating data models for reports in Power Bi Desktop. Experience in creating maps like filled map, shape map and having experience in using filters like page, visual, report and drill through filters. Good understanding of advanced Power BI features including DAX, Power Query, calculations, filters, joins and actions

Maintained data system and applied data cleaning for the understanding of data and transforming raw data into useful data by using SQL and efficiency quicker than planned Managed master data including creation, updates and deletion Improved the efficiency of the data by using various data-cleaning techniques to analyze the survey data Implemented.

Developed reports and analyzed such data sources. Generated data decisions and insights to improve the response rate and scores of the project Supported initiatives for data integrity and normalization Supported the data warehouse in identifying and revising reporting requirements Worked on reports to provide data decision support through trends.

Logical data analyst skilled in requirement analysis, software development and database management. Have a good knowledge on collecting, cleaning and interpreting data sets. .

Type :E-commerce

Company: EXCELR (Internal Project)

Duration: 06/2023 - 02/2024

Tools: SQL, POWER-BI, EXCEL, Python

Summary: Effectively oversaw the OLIST Store E-commerce project's end-to-end development, meeting all deadlines within a rigid period and guaranteeing the project's prompt delivery. Modified and cleaned data using Python, SQL, and EXCEL. Several dashboards were made to provide a more comprehensive perspective of the data, assisting in the decision-making process about how to improve results. POWERBI is used to visualize data that results with YTD, QTD, and MTD with all parts of data for making improvements and deeply analyzed and optimized complex industrial processes. manipulation demonstrated proficiency in handling large datasets effectively., Utilized Power BI for visualizations as it allows clients to understand the data eventually. Visualizations based on metrics such as employee productivity, manufactured quantity, rejected quantity and profits over different time frames provide valuable insights for decision-making., Incorporated trend lines for future estimation add another layer of analysis, enabling proactive decision-making and strategic planning., Used Power Query / Query Editor for Data transformation as per the reporting needs., Created Hierarchies and Drilldown Reports., Provided continued maintenance and development of bug fixes for the existing and new Power BI Reports.

• Power BI
• SQL
• Advance EXCEL
• Python
• JAVA

• Data Analyst
• Data Scientist