Amol Khedkar

About Amol Khedkar

Experienced Senior Consultant with a demonstrated history of working in the information technology and services industry. Strong consulting professional skilled in Oracle Database, Management, Oracle Financials, Unix, and PL/SQL.

Experience

1. Oracle Financial Consultant

   Synechron

   Aug 2019 — Present · Charlotte, NC, US

   Wells Fargo Bank - OFSAA Technical Consultant for OFSAA FSDF and Platform 8.0.9 with following responsibilities: • Create Oracle PLSQL Packages, Triggers, Stored Procedures, Data Quality rules and T2T Changes. • Customize FSDF data model (new Tables, Columns, Table Partitions and Indexes) as per business requirements. • Create Metadata for RRF Rules and create table structure for changes and design logic as per quarterly change request or New business logic. • Develop Visual Basic macros within Excel to process weekly/monthly data upload to reduce data errors. • Develop OFSAA Excel upload utility to upload user created data. • Develop PLSQL to move User inserted data with appropriate logic in Target custom tables to process required logic and lookups. • Maintain User security module within OFSAA. • Create Shell scripts to schedule OFSAA Batches in AutoSys. • Migrate all the custom code as per business schedule release and perform unit/integration testing on delivered code. • Maintain GitHub Code version and sync developed code per release in lower environments. • Update LDAP configuration after OFSAA environment clone. • Follow up with Business/BI teams for new business requirements testing and validation. • Participate in technical solution design discussions and Create technical design document for new business requirements. • Perform complex data analysis, performance tuning for any OFSAA application related bugs reported by the business teams. • Perform OFSAA Infrastructure upgrade and OFSAA metadata migration. • Monitor OFSAA batches and perform analysis on batch failure and fix issues as per FSD/TSD documents for new requirements and change requests. • Help Production Team to fix or find root cause for OFSAA Production environment. • Perform knowledge transfer on custom developed objects to the client resources.

Education

• St. Francis Institute Of Technology

  Bachelor of Engineering (B.E.), Information Technology

  2004 — 2009

Skills

• Management
• Oracle
• Pl/Sql
• Unix
• Oracle Database
• Ofsaai
• Microsoft Office
• Software Project Management
• Sql