Ujjwal Sonkar

Experience

• 

  Your Bookologist

  Jun 2020 - Mar 2023

  Founder

  • Developed custom designs in alignment with client preferences, showcasing proficiency in crafting logos, carousels, and UI elements.• Formulated and executed targeted marketing campaigns for books, achieving significant outreach to approximately 800k individuals. At Your Bookologist, we're your narrative allies and design wizards, crafting captivating stories and aesthetics.From milestone-driven marketing to eye-catching book covers, we're here to make your tale shine.

• 

  Indian Institute of Remote Sensing (IIRS), Indian Space Research Organization (ISRO)

  Jun 2022 - Aug 2022

  Intern
• 

  Celebal Technologies

  Feb 2023 - now

  • Contributed to a team in migrating 30 legacy SAS jobs to PySpark . Ensuring seamless transition by meticulously understanding SAS logic and implementing it in SQL/PySpark.• Developed comprehensive data flow diagrams for client and team understanding, simplifying ETL job flow • Tested converted jobs with sample and historic data, achieving 90-100% accuracy by identifying and rectifying logic discrepancies.• Orchestrated integration of ETL jobs into Synapse pipeline, automating workflows of converted jobs .• Documented data and testing changes in Excel sheets, maintained data transfer from Cognos to SFTP, and facilitated data ingestion into ADLS via ADF pipeline.• Implemented an autoloader script to automate incremental data processing, enhancing efficiency and reducing manual intervention.• Successfully implemented auto-scaling for dedicated SQL pool DWUs in Azure Synapse Analytics. The solution dynamically adjusts maximum allocated resources based on usage, increasing them when DWUs usage exceeds 80% and decreasing when below 5%. This has led to an estimated 80% time savings for the team and a 50% reduction in overall costs. Show less • Provided expertise in Slowly Changing Dimensions and Change Data Capture, optimizing Spark code for scalable data processing.• Proof of Concept on Unity Catalog on SAP to Databricks transition, standardizing terminology, promoting data governance, and boosting operational efficiency with Unity Catalog.• Involved in the R&D team exploring Microsoft Fabric's potential over existing analytical platforms, facilitated the integration of new features, enhancing the platform's capabilities and usability. Show less

  • Data Engineer

    Jun 2023 - now

  • Data Engineer

    Feb 2023 - Jun 2023