Key responsibilities:

1. Reviewed and analyzed the content of over 200 pages of PDF documents to identify data patterns and structures.
2. Utilized advanced PDF conversion tools and custom-built scripts to extract text and tables.
3. Cleaned and standardized the extracted data to ensure consistency and accuracy in Excel.
4. Applied Excel formulas and pivot tables to organize data for enhanced usability and reporting.
5. Validated the data by cross-referencing it with original PDF documents to ensure 100% accuracy.
6. Delivered a final Excel file that was fully formatted and ready for analysis, saving the client significant time in manual data entry.

Used technologies & tools:

1. Adobe Acrobat Pro DC for initial data extraction
2. Python (Pandas) for automated data transformation
3. Microsoft Excel for final data organization and formatting

Skills applied:

1. Adobe Acrobat Pro DC for initial data extraction
2. Python (Pandas) for automated data transformation
3. Microsoft Excel for final data organization and formatting

Outcome:

This project resulted in a well-structured Excel file that allowed the client to easily manipulate and analyze their data, improving their operational efficiency. The data conversion saved over 50 hours of manual data entry and was completed with a 100% accuracy rate.