Sachin Patted

Client: IKEA

• Worked as an Oracle Senior Developer on performance tuning and DB optimization using Oracle PL/SQL for OLTP/OLAP systems
• Did the Conceptual, Physical and logical modelling in snowflake or star schema and load data in DB using ETL/ELT (Oracle Data Integrator) tool for business intelligence requirements.
• Designed and developed interface in Agile using PL/SQL, Linux shell scripting and batch script for archival solution to IBM on demand and successfully moved 35 million supplier invoices
• Extensively worked on PL/SQL code and debugging for Packages, Procedures, Functions, Triggers, Oracle Analytical functions, Materialized Views, Cursors, Ref-cursors, and Collections
• Deep knowledge and understanding of oracle SQL/DB performance tuning using partitions, indexes, hints, Explain plan, AWR, PGA/SGA, Exadata performance features etc.
• Worked and designed Basware product migration to SAP Ariba for Oracle PL/SQL code and movement of reports to Power Bi
• Experience working on processing EDI 850,855,858,810 between the trading partners for automating the accounts payable automation process
• Deep knowledge and understanding of DevOps / CICD
• Designed and delivered the flows/Changes for the client’s requirements with C4 architecture
• Prepare and conduct training material for the target audience on the changes in the system and conduct demo across client teams.

Client: AT&T

• Design the framework for the application
• The API approach for the project had three layers, DB layer, JASON Conversion Layer and GUI
• I was leading the team responsible for designing the DB layer using Oracle 11g PL/SQL through Agile methodology
• Design the Data integrity for its modifications and decide the sprints and time lines
• Design the workflow of the data in the API
• Review the code and tune the code for better performance
• Present the changes in demo to the clients after the sprint is done.

Client: IKEA

• Worked as a SME for dealing with incidents and problems for a retail merchandise handling system used within IKEA
• Do failure mode of analysis for the issues received using advanced excel.

Client: General Motors

• Worked as a tech lead for Pro
• C application
• Evaluate the changes required and design the flow and logic changes and deliver the requirements with the team.

Client: Fairpoint

• Worked as a senior Developer for PL/SQL and C development
• Involved in writing C code for Invoice formatting module Amdocs Kenan BIF
• Involved in Amdocs Kenan data configuration using oracle PL/SQL.

Client: Alcatel-Lucent

• Maintenance and production support for applications
• Involved in writing Pro
• C, Oracle Pl/SQL code for the client’s requirements for different projects.