Now you can Instantly Chat with Prabhat!
About Me
Experienced Software Engineer/Sr. Software Engineer with over 6.4+ years experience of Software Development in Agile & SDLC, Database Development in Telecom, Supply Chain/sales, Manufacturing/ Order Process Engineering, wide range of experience provi...
Show MoreSkills
Portfolio Projects
Description
Oracle has recently moved from Oracle EBS to Oracle Fusion Cloud, Its one of the finest ERP cloud solutions in the world. The Oracle Fusion service-oriented platform and applications suite joins next-generation enterprise technologies, applications, and services, including Oracle Fusion Applications and Oracle Fusion Middleware, to change the dynamics in the applications marketplace and revolutionize business.
There are many modules in Oracle fusion financial, Tax Engine one of the finest core module, which developed using Oracle PL/SQL, ADF, Apex, and others, which integrated with other module if there is a tax calculation involved.
As a Senior Software Engineer in Oracle financial tax team involved in
- Analyzing the requirement gathered from customer/ Business Partner /Strategic team
- Development of PL/SQL code to meet the requirement and deliver to QA team
- Performance enhancement of existing Application
- Patch bundle creation for weekly, monthly , quarterly patches , which then pushed to oracle cloud
- Adhered to Agile Development methodologies
- Code development, UT case design, documentation etc.
Description
Oracle has recently moved from Oracle EBS to Oracle Fusion Cloud, Its one of the finest ERP cloud solutions in the world. The Oracle Fusion service-oriented platform and applications suite joins next-generation enterprise technologies, applications, and services, including Oracle Fusion Applications and Oracle Fusion Middleware, to change the dynamics in the applications marketplace and revolutionize business.There are many modules in Oracle fusion financial, Tax Engine one of the finest core module, which developed using Oracle PL/SQL, ADF, Apex, and others, which integrated with other module if there is a tax calculation involved.As a Senior Software Engineer in Oracle financial tax team involved inAnalyzing the requirement gathered from customer/ Business Partner /Strategic teamDevelopment of PL/SQL code to meet the requirement and deliver to QA teamPerformance enhancement of existing ApplicationPatch bundle creation for weekly, monthly , quarterly patches , which then pushed to oracle cloudAdhered to Agile Development methodologiesCode development, UT case design, documentation etc.
Show More Show LessDescription
Bell TV Subscriber Promotion system is built as DB application, aims to provide Bell TV customer various offers in terms of Hardware (Receiver) or Programming offer (DTH channel package/bundle).It synchronizes with other Order Entry or Billing application to provide discount to customer at the final billing. Application connects with upstream and downstream for data dependency, it validates customer data against upstream, apply discount and send credits to downstream application.As a Software Engineer involved inInvolved in analyzing BRF/CR documents.Code development in Oracle SQL , PL/SQL , Unix shell ScriptsUnit test code and Test execution with testing teamCreating impact analysis document and production guideCode deployment and post deployment monitoring
Show More Show LessDescription
Test Service Virtualization (TSV) program uses virtual test services called vAssets which fetch test data stored in multiple vData spread sheets. Going forward, the new vData database used to store the test data. The data from existing vData spread sheets will be loaded into the vData databases EAV model tables by data load process and Data mapping process creates logical layer tables and views from EAV modeled data, which are accessed from vAssets and the vData Search application. Data extraction process extracts the data from logical layer views to a spreadsheet, which used by the TSV data management team to modify or add test data and submit them for data load again. This document describes vData Database and corresponding DB processes and provides the instructions to operate the DB processes and setup a new/recycled release database.As a Software Engineer involved inAnalyzing SRS for the current requirementDesigning SDS for business requirements and Data modelDevelopment of PL/SQL , Unix Script and other python / Perl module code and unit testTest execution with testing team and fixing defect of existing codeCode deployment and post deployment monitoring
Show More Show LessDescription
Client : Deutsche Bank, UK
Team Size : 5 Members
Role : Software Engineer
Duration : Nov 2016 to Aug 2017
Tools : SQL Developer, GIT repository, putty
DB Layer : Oracle 11g, SQL PL/SQL
Others : UNIX shell Scripts, Perl, Eclipse
Description:
In Deutsche Bank, security lending business adds huge revenue close to 60% of total in each year. ALD is an important application, which validates all securities given to different vendors/Agents. So Agent sends all securities which are received from Deutsche bank, usually this activity is done by SunGard. Finally ALD system validates both Agent and own data, all validated securities send to downstream, in case anything invalidated then failure report sends to business to take necessary correction/action.
ALD system built using Oracle SQL, PL/SQL, UNIX scripts, Perl Scripts, Control-M scheduler and GIT repository.
As a Software Engineer involved in
- Analyzing the requirement gathered in scrum call
- Development of PL/SQL , Unix Script and unit test
- Performance enhancement of existing Database Objects
- Development of SQL queries for various business reports as per client requirement
- Adhered to Agile Development methodologies
- Code deployment and post deployment monitoring
Description
E-DELL is a Dell internal project managing all internal applications like Next Gen, Strom-ware, DMA and Global SNP. Its responsible for the team member to investigate the existing PL/SQL code and finding new solutions and bug fixing/code development for new requirement .Writing and re-developing the existing SQL and PL-SQL programs which runs in backend databases enabling the tools for faster and secure access of data. Intern it helps DELL for managing the application easily.In the similar way front-end up-gradation and enhancement need to perform with different client requirements (Dell Auditing team, customer facing teams and Dell Internals)
Show More Show LessDescription
Client : Dell International Services
Team Size : 8 Members
Role : IT Dev. Program
Duration : Jan 2014 to June 2016
Tools : Oracle OMEGA E-business Suit, TOAD for oracle 11g,
Putty, Linux, SQL Developer, OFS, GFX, DOMS
DB Layer : Oracle 11g
Description:
Processing of the order starting from dell.com website to customer services comes under Dell order management / Order Flow. Developer responsibility to handle the order processing in backend PL/SQL codes GII, OMEGA, OFS, GFX are the major application under OM. Passing messages from one source to another is most difficult part. There could be lot of bugs and error fixing happen and even redevelopment of the existing program done in day today job through CRQ (Change request management tool).
Checking database PL/SQL programs are my responsibility. Regular feedback comes from users/business/program-audit team of those tools and enhancement/re-development performed accordingly in the modular way.
As a Programmer involved in
- Involved in modifying (or) developing new packages, procedures, functions, triggers, views and other database objects.
- Interacting with the users/business and troubleshooting the problems involved with the development of different database objects.
- Involved in developing scenarios for Unit, Integration testing to ensure that all the components work correctly when integrated.
- Trained and mentored fresh Joined Developers through KT-session ( Knowledge-Transfer session)