Software Engineering Sr Analyst
Current1)Led and orchestrated the comprehensive migration of the entire backend infrastructure from .Net Core to Python, leveraging FastAPI and supplementary libraries. The migration culminated in the successful deployment of the backend in a production environment, significantly enhancing both performance and scalability. This initiative also laid the groundwork for a future transition of the application from on-premise infrastructure to a cloud-based environment.2) Worked on the development of WebAPIs for efficient data retrieval, facilitating seamless report generation.3) Initiated and executed the setup of a novel ETL process utilizing Python, enhancing data extraction, transformation, and loading procedures.4) Involved in the migration of legacy ETL processes from SSIS to Python utilizing PySpark, SQL, and Autosys jobs, ensuring modernization and improved efficiency.5) Replicated complex SSIS logic into Python and SQL scripts, maintaining data integrity and system reliability throughout the migration process.6) Implemented rigorous unit testing procedures using QTest to validate functionality and ensure a smooth transition, guaranteeing minimal disruption to operations.