Anurag Tiwari Email & Phone Number

Darmstadt, Hesse, Germany

Mumbai, Maharashtra, India

• Devising and maintaining software capable of computing airline revenue, leveraging the knowledge of Global Distribution System (GDS) files such as Amadeus, Saber, and Worldspan• Acting as a critical resource in the management and operation of data warehouse and revenue management systems, employing PLSQL and UNIX skill sets• Handling inbound data loading from diverse applications into the Oracle database using SQL Loader, ensuring seamless data integration• Managing outbound data transfer to other applications, facilitating inter-application data flow• Monitoring and addressing system job failures, adept at troubleshooting, root cause analysis, and implementing practical solutions to prevent future occurrences

New Delhi, Delhi, India

• Worked on the project for McKesson Canada as a System Engineer• Led the development of batches and jobs in the Blue Yonder JDA application, leveraging extensive knowledge in PLSQL and UNIX• Played a crucial role in the management and operation of warehouse and inventory management systems, utilizing expertise in PLSQL and UNIX• Orchestrated inbound data loading from various applications into Oracle database using SQL Loader, ensuring robust data integration• Handled outbound data transfer to multiple applications, effectively maintaining inter-application data communication• Monitored and resolved system job failures, skillfully diagnosing root causes of failures and troubleshooting issues, consequently enhancing system reliability

Noida, Uttar Pradesh, India

• Spearheaded the creation of an Enterprise Resource Planning (ERP) system utilizing Oracle SQL and PLSQL, focusing on Oracle Forms/Reports and Database 11g and 12c• Executed ERP configuration on client sites, performing pre-insert runs and master creations• Administered User Acceptance Testing (UAT) to consultants and team members to ensure seamless functionality• Established branches in the ERP system and formulated procedures for data replication across branches• Executed sales and purchase order cycles, developing key documents such as Quotations, Sales Orders, Invoices, Delivery notes, Credit Notes, Requests for Quotations (RFQ), Purchase Orders (PO), Goods Receipt Notes (GRN), and Payment Vouchers• Managed the development of a multilingual ERP system to cater to global user requirements.• Installed and configured Oracle Database 12c, Oracle 12c forms, reports, and WebUtil on cloud servers• Authored procedures for master data replication and voucher history maintenance in the ERP system• Optimized query performance using indexing techniques for the Ebizframe Neo cloud project• Generated varied reports as per business requirements, including budgeted costing and Initial Public Offering (IPO) reports, using Reports Builder• Developed and maintained Oracle database elements, including tables, views, materialized views, indexes, procedures, and triggers using TOAD and SQL Developer• Improved SQL query performance by applying indexes and executing explain plans• Created and managed auxiliary databases for development and testing purposes• Demonstrated expertise in Dynamic SQL, Collections, and Exception handling• Enhanced SQL performance through Cost-Based Optimization (CBO) techniques• Exhibited sound knowledge of crucial Oracle performance-related features such as Query Optimizer, Execution Plans, and Indexes

Noida, Uttar Pradesh

Mumbai, Maharashtra

• Led the database migration efforts for 'Three' a prominent UK-based telecommunications company• Resolved technical issues and provided support for incidents raised by both internal and external stakeholders• Acted as a trusted advisor and second-line support for incident management, effectively addressing and resolving issues• Collaborated closely with the development team, offering technical expertise and guidance to ensure smooth operations and optimal performance

Bachelor Of Science - Bs, Information Technology

Hsc, Science.