Pawan S Email & Phone Number

India

Pune, Maharashtra, India

Project – PRA Airline - Passenger Revenue accounting, Flight operations and Cargo solutionsEnvironment: Oracle 12c R2, Red Hat Enterprise Linux (RHEL)Oracle Applications: Oracle Applications 11i/11x/10.7, GL, AR, AP, FA, Cash, Project Billing, PO, ON, INVTools: PL/SQL Developer, Putty, WinCVS, WinSCP, GDB, crontab, Oracle scheduler, Git.A product based company having airline domain product for Passenger Revenue Accounting. It generates final accounting of a ticket considering all related factors like total fare of ticket, agent fee and commission, full or partial reissue of ticket, full or partial cancellation of ticket, variety of taxes in effect for an airport in a country, total number of sectors in journey and whether all sectors flown by same airline or by other airline, Inward and outward billing incase of sectors flown by airline other than ticketing airline.Project - TREnvironment: MS SQL Server, ETL Tools: SQL Server, ECE ETL, Service Now, Jira, Git.Elite Conversion Engine (ECE) at Elite (TR), a standard ETL tool crucial for seamless data conversions from Elite Enterprise to Elite 3E and other non-Elite platforms to 3E.Proficient in PL/SQL programming, including stored procedures, functions, triggers, and packages. Experience with version control systems such as Git and SVN. Ability to write efficient SQL queries and optimize database performance. Excellent problem-solving skills and attention to detail, with a commitment to delivering high-quality solutions on time and within budget.Strong knowledge in Full stack development capabilities, technology evaluation, vendor selection and technology vendor management.Experience in establishing and managing technology platforms for DevOps, Code Management, Testing, Continuous Integration and Continuous Deployment and providing production support for business solutions.

Pune, Maharashtra, India

• Implemented the Permissions and Privileges module in Citi Private Bank that captured all the details of the HNW account holders via paperless process.• Developed and tested regional solutions for Citi Bank Personal Banking module.

Pune Area, India

• Develop and enhanced MNET system for scheduling programs on AIR. Broadcasting the tv shows, movies and live shows. Maintaining all shows schedule time and contract in M-net system.• Designed and developed content sales management application for maintaining the records of Broadcasting the tv shows, movies and live shows.

Mumbai Area, India

• Analyse the business requirements & understanding the Functional Specification Design (FSD).• Writing Technical documentation (includes FSS-Functional Specification Requirements, TSD -Technical Specification Requirements) for the application.• Implementation of SQL & PL/SQL code.• Involve in preparing/reviewing Test Documents (Unit & System test plan & test cases).• Execution of Unit test cases as per the Unit test plan.• Execution of System test cases as per the System test plan.