Jayendra Rana

Experience

• 

  NIT SRINAGAR

  Dec 2016 - Apr 2017

  Internship Coordinator
• 

  T&P CELL, NIT SRINAGAR

  May 2017 - Jul 2018

  Campus Recruiting Manager

  For Batch passing out in 2018

• 

  LTI - Larsen & Toubro Infotech

  Aug 2018 - Sept 2021

  • Software Engineer

    Sept 2019 - Sept 2021

  • Graduate Engineering Trainee

    Aug 2018 - Aug 2019
• 

  Kipi.bi

  Oct 2021 - now

  - Engineered automated data ingestion processes utilizing OOB Connectors and Custom APIs, enabling seamless data flow into the Snowflake environment; reduced manual data entry errors by 30% and enhanced data retrieval speed for analytics.- Optimised data pipeline from 1 hour to just under 4 minutes, saving approx 500 Matillion credits equivalent to $1200.- Worked on Data Pipeline design and Data Modelling - Worked on Python, Azure Data Factory, Matillion ETL, SQL, API Integration, Power Automate- Built data pipelines using ETL/ELT tools like Fivetran and Matillion for data sources such as SharePoint sites, FTP, SFTP, custom APIs, web-scraped data- Engineered a robust data transformation process that converted 1M+ raw data points into actionable insights, successfully integrating them into Sigma via MTT Architecture and enhancing data accessibility for key stakeholders.- Minimizing costs of transaction processing and reporting.- Fast transactions to enable responsiveness to market change and building Dynamic, near-real-time decision support system Software Engineer Show less - Building data pipelines to streamline data from various sources into a Snowflake data warehouse using OOB Connectors, Snowflake Partner Connect, and custom APIs.- Expertise in data pipeline design and data modeling.- Utilizing Python, Azure Data Factory, Matillion ETL, SQL, and API integration for efficient data processing.- Developing data pipelines with ETL/ELT tools like Fivetran and Matillion for diverse data sources.- Transforming raw data for easy access and analysis on Sigma using MTT Architecture.- Focus on minimizing transaction processing and reporting costs while ensuring fast and responsive decision support systems.- Conducting proof-of-concepts (POCs) for Snowflake Public and Preview features, collaborating with architects and researching business use-cases. Show less

  • Lead Engineer

    Nov 2023 - now

  • Senior Software Engineer

    Oct 2021 - Oct 2023