Pratik Iyer Email & Phone Number

Greater New York City Area

New York, New York

Cambridge, Ma

• Collaborated with teams from all functional areas across enterprise and analyzed integration requirements for 990 applications.• Designed reports using Tableau, analyzing and identifying gaps in current state of 882 integrations across Biogen.• Minimized risks by performing gap analysis in application integration and suggested strategy change to all functional leads.• Analyzed different integration architectures (Point to point, Hub & Spoke etc.) and technologies and developed strategy to improve the current state of integrations.

Pune Area, India

Oracle Technical Consultant with an experience in implementing and upgrading ERP systems and supporting the same for multiple clients. Worked on Oracle Financial Services, OFSAA in both the EPM and ERM modules. Developed data driven solutions for clients by generating extracts using ETL (Oracle Data Integrator).• Performed requirement analysis and impact assessment of requirements to manage development activities to mitigate functional risk of application.• Led a team of 4 in developing ETL solutions to help bank meet regulatory standards set by APRA (Australian Prudential Regulation Authority).• Remediated 350+ interfaces of GL module of Oracle EBS for an Oracle R12 upgrade project of a bank that was mandatory for functioning of new system.• Developed and personalized forms in GL, FA and AP modules of Oracle EBS using Oracle Form Builder.• Developed complex application packages using PL/SQL, to migrate data from legacy system to Oracle Financial Services Operational Risk system, reducing overall cost of system maintenance by 60%.• Optimized application code in Oracle Data Integrator thereby reducing SLA breaches from 30 to 0.• Created UNIX shell scripts and SQL scripts to automate 150+ batch-processing jobs in development and production environments.• Designed and developed reports using Oracle Reports Builder to meet client requirements.• Conducted root cause analysis of Problem Records in Remedy thereby bringing PR count down to 14 from 53, preventing recurrence of related incidents.• Extensively used MS Excel to present monthly report of incidents and problem records to client.• Generated reports using Oracle Reports Builder to meet client requirements.• Worked on the FTP (Fund Transfer Pricing) and PFT (Profitability) modules of OFSAA.

Master'S Degree, Management Information Systems, General

Bachelor Of Engineering (Be), Electrical And Electronics Engineering

High School