Gunjan Gawande

Responsibilities

• Led the end-to-end development of a comprehensive database dashboard, involving data extraction, filtration, and transformation using HQL. Developed consumable data views for reporting and automation workflows. Utilized shell scripting for process automation and implemented JIL (Job Information Language) jobs to orchestrate and execute the entire pipeline efficiently.
• Developed a Python-based automation framework to streamline report generation for the business team, significantly reducing manual effort and processing time. The tool optimized data workflows, improving efficiency and enabling faster, more accurate reporting.
• Executed Business-as-Usual (BAU) activities for data transformation and loading, ensuring timely updates and seamless integration of new data into the portal.
• Optimized data processing by implementing efficient ETL pipelines and streamlining database design.
• Enhanced data quality by performing thorough cleaning, validation, and transformation tasks.
• .Fine-tuned query performance and optimized database structures for faster, more accurate data retrieval and reporting.
• Conducted extensive troubleshooting to identify root causes of issues and implement effective resolutions in a timely manner.
• Increased efficiency of data-driven decision making by creating user-friendly dashboards that enable quick access to key metrics.
• Developed and delivered business information solutions.

I have worked for Latin American Bank Project under 2 roles.

1) Python Automation Engineer.

Responsibilities

• Identifying the automation areas in banking application
• Web scrapping the banks data/transactions using Beautiful Soup
• Data extraction and Transformation using Pillow, regular expression, Pandas, Numpy
• Tabular data extraction from PDF using Camelot
• Analyzed interpreted data and prepared reports as per clients requirements
• collaborating with functional tester to fulfil the data requirements for their test scripts

2) Java Automation Engineer.

Responsibilities

• Identifying and selecting the automation test cases
• Participating in Selenium Environment Setup with an Integrated Development Environment (IDE)
• Automating the design of a Maven, TestNg, Jenkins frameworks using Java.
• Creating, enhancing, debugging, monitor and running the test cases.
• Collating and monitoring the defect management process.
• Interacting with customers/clients to solve the various issues they face and updating on the situation.