Internship Overview: Served as a Data Analyst at Ozibook, adhering to stringent confidentiality guidelines, and played a key role in lead generation through meticulous data analysis and automation. Data Scraping: Implemented a VPN for secure data scraping of LinkedIn IDs, ensuring compliance with data security and privacy standards. Ensured accuracy and reliability through a rigorous data cleaning process.Lead Generation: Transformed scraped data into meaningful leads aligned with client specifications. Contributed to the development of targeted lead generation strategies based on cleaned data. Automation with NLP: Utilized Natural Language Processing (NLP) to automate lead generation tasks, demonstrating proficiency in cutting-edge technologies. Developed an efficient system for generating detailed lead PDFs with minimal input.

1. Excel for data analysis and reporting : To create and maintain Excel spreadsheets to organize and analyze data. Generating reports and visualizations to support decision-making which included accuracy and consistency. Using Excel functions (FILTER, SORT) to clean and organize data. Remove duplicates and handle missing or erroneous data. Leverage Excel functions for basic analysis SUM, AVERAGE, COUNT). PivotTables to analyze and summarize data quickly. Implementing advanced excel formulas for calculations, such as profit margins, growth rates, or ratios. Utilize VLOOKUP or INDEX-MATCH for data retrieval. Applied conditional formatting to highlight trends, variances, or outliers. Set up data validation rules to ensure accurate data entry.2. Use of advanced Excel functions for complex data manipulation : Combining INDEX and MATCH functions for more flexible and powerful lookups. Wrap formulas with IFERROR to handle errors more gracefully and improve the robustness of the spreadsheet. Used OFFSET to create dynamic ranges that adjust automatically based on changes in data. Combine OFFSET with INDIRECT for more advanced dynamic referencing.