Technical Specialist
CitiusTech Healthcare Technology Pvt ltd
Total years of experience :7 years, 9 Months
Client: Thermo Fisher Scientific (PPD) Project: Lab Information Management Systems
Working as a Subject Matter Expert of Oracle Fusion Middleware tech stack and helped organization in hiring and onboarding team members for the current project. Leading the team for the Lab Information System application enhancements and implementation of core concepts of Clients proposals.
Client: University of Strathclyde (Internal Operations Team) Project: Anniversary Registration
Leading a team of developers and testers while developing the Student Management System as a key Oracle developer to develop and integrate the Anniversary Registration project while enrolling students in the university. Worked with the team to accomplish application development and continuous integration tasks in an Agile environment. Implemented all phases of the SDLC (Software Development Life Cycle) from Analysis and design to Implementation of Business Application using Oracle Tools (Oracle Forms Developer 1 2c/11 g/1 0g/6i, Oracle Reports Builder 1 2c/11 g/1 0g/6i, Oracle Database 11 g/1 0g), PL/SQL and SQL, Toad for Oracle. Developed complex database objects like Tables, Views, Functions, Procedures, Cursors, Triggers, and Packages on Oracle Database using PL/SQL Programming Language. Written complex database logic and PL/SQL queries to fetch data and build applications. Created multiple Forms Reports, Libraries, and Menus using Oracle Forms and Reports Developer, as per client specifications and business requirements while ensuring the continuation and enhancements of services.
Client: Natwest Group (Royal Bank of Scotland), UK Project: Client Information System Migration
Worked as a Subject Matter Expert of Oracle Fusion Middleware tech stack and helped in migration of Mortgage application of Royal Bank of Scotland (client) including and not limited to, Training newcomers and helping them understand Oracle Fusion Middleware, especially Oracle Forms/Reports technology. Develop Oracle database objects as per client requirements. Production support in an Agile environment. Develop Forms and Reports in Oracle Forms Developer and Oracle Reports Builder Installation and Configuration of complete Oracle Fusion Middleware 1 2c tool set.
Client: Oracle Business Services, France Project: Order Management System
Migrated OPAS/MEDIATUS (legacy system) to Oracle Forms/Reports version 1 2c from version 1 0g. Completed its day to day requirement including creation of forms and reports and enhancement in current database architecture. Created user analysis tool to capture users behaviour of using the application. Implementing, customizing, troubleshooting, and supporting various modules like Order Placement, and migrating Order to other tools.
• Deployed at client location in Lubumbashi, DRC in Central Africa.
• Involved in all phases of the SDLC (Software Development LifeCycle) from the analysis, design to implementation of Business Application using Oracle Tools (Oracle Forms Developer & Oracle Reports Builder, Oracle Database 11g/10g), PL/SQL and SQL, Toad for Oracle.
• Translate business and functional requirements into technical solutions. Debugging, Error handling, and resolve technical issues related to ERP using Oracle Tools in a timely and concerned manner.
• Create Forms and Reports using Oracle Forms 10g/11g, Oracle Reports 10g/11g as per client specifications.
• Develop complex database objects like Functions, Procedures, Cursors, Triggers, Packages on ORACLE Platform using PL/SQL Programming Language.
• Interact with Customer to gather business requirement and provide Functional Consultancy to establish problem specifications and system designs.
• Fulfill change requirements of Client related to ERP and maintain the database.
• Analyze and design relational databases using PL/SQL Programming while ensuring the continuation and enhancements of services.
• Debug and modify software components.
• Modify existing software to correct errors, adapt to new hardware and improve performance.