Swapnila Mundra

Software Engineer Intern

Globetax•  June 2019 - December 2019

• Performed Data Warehousing and ETL; created data flows, control flows, scheduled refreshed for both ETL and Power BI reports using Agent Jobs using SSMS and SSIS. • Developed operational reports by writing SQL queries (Joins, DDLs) in SQL Server, data modelling and visualizing in Power BI Desktop and Power BI Report Server to analyze systems performance and monitor overnight agent jobs • Implemented search service by developing RESTAPI using. NetCore2 and C# that established communication between internal systems to enable fast report processing from the client-side and thereby reducing the database server load by more than 50%. • Produced dynamic PDFs using XSL, XML and XHTML in a Document Management System (DMS) to aid generation of tax reclamation documents for individual clients.

Programmer Analyst

Cognizant Technology Solutions•  December 2013 - June 2016

• Enhanced enterprise application using Pega BPM by developing new logics and rules for expense capturing of drug trials as a System Architect in an Onsite- Offshore team setup. • Conducting data extraction and business intelligence in Pega BIX and Oracle 10g to generate EXCEL reports using ETL process. • Wrote SQL and PL/SQL utilizing the concepts of Joins, Views, Stored Procedures, Cursors, DDL and DML statements. • Following SDLC, performing code migration in several environments after patch fixing and unit testing in DEV environment. • Providing Production Support in incident management, ticket resolution, team and client collaboration via Agile development