Prashant Gondule

• Managed the complete development cycle of new system functionalities as per business requirements, made modifications to existing code, addressed bugs, and created documentation (IDQ, FRS, test document).
• Performed root cause analysis for ETL job failures and data issues raised by the business.
• Created various scripts, Informatica mapping/workflows, complex queries, and Autosys jobs.
• Addressed issues/incidents within the SLA timeframe raised by downstream teams due to data issues, process failures, incorrect data from source, or bugs.
• Constructed Autosys objects such as watchers and jobs that initiate processes.
• Maintained data integrity.
• Automated several existing application processes using Unix shell script and Autosys scheduler.

Led a team of 6 individuals and managed the distribution of tasks among them.

· Gathering requirements from client

· Development of new mappings/workflows, reconciliation rules, validations to identify moneyloss for billing accounts.

· Optimization of complex SQL queries.

· Created an Automatic PDF reader loader using JavaScript which will automatically read data from pdfs and load to database tables.

UAT testing and design documents creation