Prathamesh Viralekar

Technical Analyst at Equifax Analytics

Equifax Analytics

Feb 2024 - Present -1 yr, 4 months

Job Details:Working on enhancement and support for Oracle EBS R12, ensuring system reliability and business continuity. Designed and implemented custom solutions to address recurring issues and improve system stability. Conducted performance tuning of SQL queries, PL/SQL packages and reports. Collaborated with functional consultants to analyze and resolve system issues. Developed and maintained shell scripts, SQL loader, custom packages, lookups, and Oracle reports to meet business needs. Assisted business users during month-end, quarter-end, and book-closing processes, resolving critical issues efficiently. Investigated and resolved business user-reported issues, ensuring minimal downtime and process improvements. Collaborated with Oracle support to resolve complex technical issues and apply patches.

Tata Consultancy Services

Apr 2021 - Feb 2024 -2 yrs, 10 months

Job Details:Developed and optimized complex PL/SQL scripts, packages and Oracle reports for data processing and reporting. Worked closely with business analyst and IT teams to gather requirements and integrate Oracle application with external systems, ensuring data integrity and efficient workflow. Created custom web ADI, lookups, value sets, concurrent programs as per business needs. Customized standard Oracle EBS interfaces and APIs for integration with third party system. Assisted in data migration activities including data cleansing, mapping and validation. Coordinated business SIT, UAT sessions and prepared technical documentation for customizations, workflows and reports. Provided post implementation support and training to end users.

Bachelor's Degree in Computer Science
Ashokrao Mane Group of Institutions
Jan 2020