Om Kushwaha

Experience

• 

  HCLTech

  Jul 2022 - now

  Technical Lead

  •Worked on USBSO Project, focusing on the MS Sales module within the Microsoft Business Sales and Operations framework. Responsible for overseeing the revenue inflow into Microsoft accounts.•Managed data flow from the Financial Data Lake (FDL), utilizing Azure Data Lake Storage Gen2 (ADLS gen2) as the source and Azure Synapse as the destination. Orchestrated data processing through three distinct layers: Staging, Processing, and Data Warehouse (DW).•Utilized Synapse pipelines and notebooks for Extract, Transform, and Load (ETL) operations, ensuring seamless data integration and maintenance of data integrity.•Oversaw the ECfact table housing approximately 1.5 billion records encompassing the US, Canada, and Latin America. Facilitated daily refreshes along with YTD and Restatement/FM Close processes, coordinating pipeline triggers accordingly.•Actively monitored Synapse pipelines for daily execution, promptly addressing any failures encountered. Conducted manual triggers and reruns as necessary to maintain uninterrupted data flow and operational efficiency Show less