Prasanna Uthamaraj Email & Phone Number

Paris, Île-De-France, France

 Region Umbrella: EMEA, Americas, LATAM, APAC., Handling full Data stack: Database Design, Data Engineering, and Data Analysis. Equipped with 2 high-performance laptops, an Azure Virtual Desktop, and 5 screens for optimal productivity. Programming Languages: Python & MySQL - Dependency level = "Full", Basis = "Daily". IDE's: JetBrains/PyCharm & Workbench/MySQL., Universal Database Manager: DBeaver 24.1.1., Cloud Database: Amazon RDS (PostgreSQL)., Database Management: 1 Oracle Database, 16+ MySQL Databases, 34 PostgreSQL Schemas., Currently managing: 1 Oracle Database, 16+ MySQL Databases, 4 Data Warehouses, 1 Data Lake, 5 Data Hubs, 2 Data Gateways, 33 Data Pipelines, 34 PostgreSQL Schemas., "Custom Built Developements (Python, MySQL)" - 1 Analytics Data Warehouse, 8 Data Marts, 22 Data Pipelines, 8 Data Sources, 20+ reusable Python libraries and continuing to develop more. Orchestrating & Building Infrastructure: Apache Airflow (via Docker) – Custom setup from scratch with YAML, configuration, Redis, Celery Executor, DB Init, Scheduler, Worker, and Webserver components. Optimization Challenge Accomplished: Managed an SQL file with 18,385,988 lines, identified and resolved errors efficiently through command-line execution. BI's: Power BI for Data Visualisation and Oracle BI for Data Intelligence. Operations & Administration: Oracle Eloqua (Segments, Shared filters, ETL processes), Adobe AEM PROD Author - 6.5 (Data collection, validation, flow check, ETL processes), Joomla (AcyMailing, Fabrik, Akeeba and +) Web Scraping: Proficient in bs4/BeautifulSoup and Selenium for automated Data extraction., Spreadsheet: Excel - Spreadsheet purpose: Presenting reports. Other open-source application: Notepad++ (REGEX, Extended, Quick Data Transformations)., Extra Curriculums: Adobe Analytics, MS Access, Power Automate, Notepad, OneNote, MS Word, SharePoint., Cloud service: Microsoft., Web & Cloud Host: SiteGround., FTP: FileZilla.,

Paris, Île-De-France, France

New Delhi, Delhi, India

Paris, Île-De-France, France

 Transformed the extracted data (with code); applied algebraic operations for loading into end target (ETL, ELT, and ETV). Queried the relational algebra concepts in IBM DB2 cloud-based data warehouse. Generated the Ad-hoc analysis reports; computed campaign analysis for product launches, pricing, and promotions. Attentively monitored 12 KPIs; figured the insights for variables in relation to KPIs. Closely Collaborated with internal stakeholders; optimized their decision-making system. Increased the monthly profit for regional sales units (0.98%) and improved the KPI metrics.

Rennes, Brittany, France

 Transformed the extracted data; programmed the set of statistical processes. Visualized the demographic data and experimented with 2 ML algorithms to predict the audience's behavior. Closely Collaborated with external stakeholders; optimized their digital campaigns.

Rennes, Brittany, France

 Summarised A* journals; documented the development strategies for agribusiness strategy and innovation sector. Worked out 5 types of statistical analysis concepts and lectured the hypothesis stories. Examined and recommended the economic, social, and environmental objectives for agriculture development strategy.

India

Coimbatore Area, India

 Established the functional dependencies, structured the data, and ensured the data relations. Streamlined the flow of information and communicated the data flow design to non-technical stakeholders. Queried the 4 DDL operations and 4 CRUD operations accurately. Programmed the data extraction (validation) processes; guaranteed the data quality [contributed for ETL]. Extracted the data to compute KPIs and comfortably enabled data democratization.

Coimbatore, Tamil Nadu, India

 Established the functional dependencies, structured the data, and ensured the data relations. Streamlined the flow of information and communicated the data flow design to non-technical stakeholders. Queried the 4 DDL operations and 4 CRUD operations accurately. Programmed the data extraction (validation) processes; guaranteed the data quality [contributed for ETL]. Mediated the product circulations between the operations and customer services team. Extracted the data to compute insights and optimized the internal organization facilities.

Master'S Degree, Data And Business Analytics(Dban)

Programming: Python, MySQL Tools: Advanced MS Excel, SPSS, Tableau, MS Office.

Master Of Computer Applications - Mca, Computer Programming, Specific Applications, First Class

Programming: Java, C++, MySQL

Bsc - Bachelor Of Science, Information Technology, First Class

Programming: MySQL, MS Visual Basic Tools: MS Excel, MS Office