Ali Q.

Hi there, This is Ali from the land down under. I am a technology enthusiast and a software professional, experienced in a wide variety of skills. Software Developer: =================== • Backend development using Java, Springboot • Front end development using Angular, React and StencilJs. • Javascript, Typescript and styling using CSS, SASS, TailwindCSS Transcriptionist: ================= • Native speaker. • Professional level audio/video to text transcription with filler words removed. • PDF/Image to text transcription. • Experience in identifying multiple speakers within the context of an interview Microsoft Excel: ================ • Data Analysis: Analyse and manipulate data in Excel, including functions like SUM, AVERAGE, VLOOKUP, and PivotTables, to derive meaningful insights from raw data. • Data Cleaning: Cleaning and organizing messy datasets, ensuring data accuracy and consistency through techniques like data validation, text-to-columns, and removing duplicates. • Data Visualization: Creating compelling data visualizations using Excel's charting tools, helping stakeholders understand complex information at a glance. • Formula Proficiency: Creating complex formulas and custom functions to automate calculations, making data processing more efficient. • Data Import/Export: Seamlessly import data from various sources into Excel, such as CSV, databases, or web data, and export data to different formats for reporting purposes. • Conditional Formatting: Use conditional formatting to highlight important trends, outliers, or anomalies within datasets, making it easier to spot key insights. Microsoft Word: =============== • Document Formatting: Have a strong grasp of Word's formatting features, allowing to create professional documents with consistent fonts, styles, and layouts. • Mail Merge: Merging data from Excel or other sources into Word documents for personalized communication. • Tables and Charts: Inserting and formatting tables and charts within Word documents to present data and information in a visually appealing manner. • Data Integration: Integrate data from Excel into Word seamlessly, such as embedding Excel worksheets or linking tables and charts to ensure up-to-date information. • Document Automation: Leverage Word's macros and templates to automate repetitive tasks and create standardized documents, enhancing productivity. SQL Query Writing for Data Retrieval from databases: ==================================================== • Strong foundation in SQL fundamentals, including SELECT statements, WHERE clauses, JOIN operations, and GROUP BY for data retrieval and manipulation. • Familiar with SQL development tools like SQL Plus, SQL Developer, or TOAD, which aid in query development, debugging, and optimization.