• Collect global raw data of healthcare professionals and organizations of pharmaceutical companies data from different sources such as PDFs, websites, web links, and image formats.• Conduct data profiling to analyze the current state of the data. This involves examining the structure, content, and quality of the data. Identify issues such as missing values, duplicates, outliers, and inconsistencies.• Collaborate with stakeholders to define clear and measurable data quality standards and metrics. These standards should align with business objectives and compliance requirements.• Implement data cleansing and transformation processes to correct errors, fill in missing values, standardize data formats, data integration and ensure data consistency. This may involve using data mapping, cleansing tools, and techniques.• Maintain report of data quality rules, procedures, and processes. This report helps ensure transparency and consistency in data quality efforts.• Promote data governance practices within the organization to ensure that data quality remains a priority and that data-related policies and procedures are followed.•Collaborated with IT teams to implement data quality improvements and enhancements to existing systems and processes.• Generate data quality global reports of healthcare professionals and organizations of pharmaceutical companies using tools like Excel, improving data transparency.

• Analyze the daily/weekly/Monthly sale of different products in a particular region to determine the Target v/s Achieved percentage and its variation. And also figure out the increase/decline of products to create a strategic plan which brings us great business growth in the future.• I have also done market research related to the mobile app project. In this project, I had to make the report by researching the five best Yacht/Boat rideshare apps like LYFT, Uber, Bolt, etc.• I have also done market research related to business in which I analyzed which clients to do business with which category has more demand in the market and these products are being sold in the market.• In the field of market research, I have also done research on Amazon products. My client’s goal in this research and analysis was to get them out of the top ten sales products and extract ingredients from products.

• Create business intelligence data modeling using Excel ETL, power queries, pivot tables & data modeling for handling big data.• Create a B2B & B2C database Excel to dump big data. Arrange data B2B & B2C day-wise, analyze sales of recharges by belt, regions.• Determine B2B & B2C active target sales, monitor change from last month to current month change in percentage.• Create Ad hoc analysis reports for better results to analyze the sales monthly, weekly, yearly, and day-wise. Ad hoc reports give excellent business decisions.

• Studied Cost Analysis using cost formulas like Cost per Mile, Cost per Click, and Click-through rate.• I had analyzed it in cost per mile, cost per click, and clickthrough rate.• Using advanced excel and pivot table. Too large data file and summarize in one page and convert data into a useful term.

• Top five Competitors According to Ads Engagement & Lifetime Duration. My research work is based on united states Clients.• Top five Competitors According to Yelp Sorted by locals Requesting a Quote & Business Recommendations. Top five According to Google Maps - Based on the number of reviews and ranking. My role is Ads researcher in this Internship.