Laxmi Ramshankar Kanojia

Experience

• 

  CitiusTech

  Nov 2019 - Apr 2021

  Senior Software Engineer | Business intelligence, Microsoft SQL Server, SQL, GIT, ETL

  • Created Table Types in SQL to add and test functionality like multi-select in the product using US Healthcare data warehouse.• Adding Healthcare configurations based on functionality using advanced SQL queries.• Leveraged software engineering expertise in the development of SSIS packages to load data from Excel into SQL tables.• Implemented Jira to track Scrum stories and defects if any, while using GIT for version control.• Developed and deployed Scrum stories working closely with the API, User Interface and QA teams.• Designed and implemented data repository solutions, enhancing data accessibility and usability across the organization.• Collaborated with cross-functional teams on Agile projects using Microsoft DevOps for planning and estimating delivery of BI solutions.• Examined problems to diagnose and resolve BI-related issues to minimize downtime by 60% and ensure continuous operations. Show less

• 

  JPMorgan Chase & Co.

  Apr 2021 - Apr 2022

  Data Analyst | Microsoft SQL Server, SQL, Tableau, Excel, Banking

  • Prepared data for the project by performing ETL process using advanced SQL to breakdown different entities of data such as Lending, Mortgage, Investment, Banking, etc.• Created and maintained reports and BI dashboards using Tableau based on end user specifications, extracting Banking data from sources including SQL Server databases and Excel files.• Rendered analytical and technical support for complex projects and initiatives, working closely with stakeholders to understand requirements and deliver effective solutions.• Automated the process to generate data for different business units using a single process thereby reducing 60% of the development time.• Conducted data validation with the Data Warehouse Manager to ensure accuracy and reliability of reports, addressing any discrepancies promptly. Show less

• 

  WPP

  Apr 2022 - Mar 2024

  Data Engineer | Azure Synapse Analytics, Azure Data lake, Azure Databricks

  • Built an Azure Synapse solution to extract and transform data from sources (ADLS/ Rest API) and load to staging.• Led the design and execution of data integration pipelines leveraging Azure Dataflows and Databricks in conjunction with senior developers, which streamlined data processing, resulting in a 30% improvement in efficiency.• Created Notebook using PySpark to create Delta/Parquet tables, external tables and views in Azure Synapse.• Designed a framework to automate source to stage data extraction for entities thereby reducing the extraction time by 70%. Show less

• 

  Innovoco

  Mar 2024 - now

  Data Engineer