Working in IT · ~8 Years
Open to Side Projects · Evenings & Weekends

Prafull Ranjan

I work as a software engineer at SkillNet Solutions, Inc., where I've spent about eight years doing backend development and application support for retail clients. Mostly Java, Spring, Oracle, and a lot of production debugging.

On the side, I build simple websites for small businesses and schools, and write about things I learn through my blog PrafullTalks. Nothing fancy — just trying to keep learning and be useful.

0
Years Experience
0
Retail Brands
L1–L3
Support Tiers
0
Blog Articles
// About

A bit about me

I've been working at SkillNet Solutions, Inc. for about eight years, mostly on backend systems for retail clients. My day-to-day involves Java, Spring, Oracle databases, and a fair amount of application support — looking at logs, figuring out production issues, and keeping things running.

I do backend development and application support — writing Java/Spring code, working with SQL and Oracle, and handling L1/L2/L3 production support when things go wrong. It's mostly practical, hands-on work rather than anything cutting-edge.

Recently I picked up Oracle SOA Suite for a data migration project — it was new to me and a good learning experience. Outside of client work, I try to keep learning by building small projects and writing about what I learn.

✍️ PrafullTalks — My Blog

I write articles on PrafullTalks every Monday — mostly about technology, software engineering, and things I find useful or interesting.

It started as an experiment with automated publishing, but now I write and post manually each week. It helps me organize what I'm learning and hopefully someone else finds it useful too.

🌐 Visit PrafullTalks →

Prafull Ranjan
profile.status
RoleSoftware Engineer · System Analyst
EmployerSkillNet Solutions, Inc.
DomainRetail — Backend & Data
Core StackJava · Spring · Oracle · SQL
Support CoverageL1 / L2 / L3
Current FocusOracle SOA Migration
Knowledge PlatformPrafullTalks ↗
Writing FocusTechnology • Life Insights • Social Issues
Side ProjectsOpen · Evenings & Weekends
// Experience

Work at SkillNet Solutions

I've been with SkillNet since 2018, working across different retail client projects.

ASUR — Data Migration Project

Active
Jun 2026 — Present

Working on a data migration project using Oracle SOA Suite with embedded Java — extracting client data from legacy source databases and generating structured MNT output files. Built data transformation logic within SOA composites. This was my first time working with Oracle SOA, so it's been a good learning experience.

Oracle SOA SuiteCore Java

Estée Lauder Companies (ELC)

Active
Nov 2020 — Present

Working on a project for Estée Lauder Companies. My role has been around transforming legacy data into XML for the Relate system, along with backend development, application support, manual testing, and deployment tasks.

JavaSpring FrameworkOracle 12cSQL

Sally Beauty Holdings (SBH)

Archived
Aug 2018 — Oct 2025

Was part of the team supporting Sally Beauty Holdings. Mostly handled application support and manual testing, with some backend development work as needed.

JavaSpring FrameworkOracle 12cSQL

Charlotte Tilbury Beauty Ltd

Archived
Mar 2023 — Aug 2025

Worked on a project for Charlotte Tilbury. Did some backend development using Core Java and SQL, and helped with deploying a utility JAR file to UAT and Production.

JavaSQL

Blick Art Materials

Archived
Feb 2022 — Mar 2024

Worked on a project for Blick Art Materials. Did backend development with Java and Spring Framework, wrote SQL queries, and used Postman for API testing.

JavaSpring FrameworkOracle 12cSQLPostman

West Marine

Archived
Mar 2022 — Jun 2023

Worked on a project for West Marine. Backend development using Java and Spring Framework, and SQL queries for business operations support.

JavaSpring FrameworkOracle 12cSQL
// Independent & Client Projects

Side projects

A few things I've built or worked on outside of office hours, on evenings and weekends.

SPS International School — Website Design & Development

Live
2026 · Client Project

Built a website for a school (Nursery to Class 8) — includes sections like admissions info, facilities, team, gallery, FAQ, enquiry form, and Google Maps. Simple HTML/CSS/JS, hosted free on Netlify.

HTMLCSSJavaScriptNetlify

View Live Site ↗

Maa Neurotherapy Health Care Centre — Website

Live
2026 · Client Project

Built a website for a drugless neurotherapy clinic in Siwan, Bihar, run by specialist Govind Kumar. Covers services, treatments, patient info, and contact details. Simple and clean — HTML, CSS, JS on Netlify.

HTMLCSSJavaScriptNetlify

View Live Site ↗

Prafull Ranjan — Portfolio Website

Live
2026 · Personal Project

This portfolio website — a single page with dark/light mode and a contact form. Built with plain HTML, CSS, and JavaScript. Hosted free on Netlify.

HTMLCSSJavaScriptNetlify

View Live Site ↗

// Side Projects & Independent Work

What I can help with

Outside of my full-time role, I take on independent projects on evenings and weekends — primarily website development and technical writing.

Website Design & Development

Simple, clean websites for schools, small businesses, and personal use — built with HTML, CSS, JS and hosted free on Netlify.

Technical & Content Writing

I write articles on technology, software engineering, and practical topics on PrafullTalks — 50+ articles so far, published every Monday.

Small Tools & Automation

Simple workflow tools and scripts using Python, GitHub Actions, and APIs — built for personal use and learning.

All independent work is done outside of regular work hours and does not overlap with my employer's business.

// Knowledge Sharing

Writing Beyond Code

I enjoy simplifying complex technology and sharing practical knowledge. Through PrafullTalks, I publish articles that make enterprise software, life lessons, and social topics easier to understand.

📚 PrafullTalks

A personal knowledge platform focused on writing high-quality, easy-to-understand articles.

  • Enterprise Technology
  • Software Engineering
  • Life Insights
  • Social Issues
  • Growing Knowledge Library
  • Weekly Monday Posts

🌐 Visit PrafullTalks

✍️ Why I Write

Writing helps me organize ideas, explain difficult concepts, and contribute practical knowledge to a wider audience.

My goal isn't simply to publish articles — it's to create content that helps developers, students, and everyday readers understand technology without unnecessary jargon.

Technical Writing Knowledge Sharing Enterprise Tech Personal Growth
// Systems

ASUR migration — how it works

A simple overview of the data migration flow I'm currently working on — legacy data through Oracle SOA Suite to the output format.

Legacy Data → Structured Retail Output

Oracle SOA Suite · Core Java
Migration pipeline: Oracle database source flows into Oracle SOA Suite, then transformation logic, then business rules, producing MNT output files consumed by retail systems. Oracle Database legacy source Oracle SOA Suite composite + embedded Java Transformation custom Java logic Business Rules validation logic MNT Files output Retail Systems STEP 01 STEP 02 STEP 03 STEP 04 STEP 05 STEP 06
STEP 01

Legacy Source

Client data extracted directly from legacy Oracle source databases.

STEP 02

Oracle SOA Suite

SOA composites with embedded Java drive the extraction and orchestration.

STEP 03

Transformation Logic

Custom-built transformation logic reshapes data inside the SOA composite.

STEP 04

Business Rules

Business and data-processing rules validate the transformed records.

STEP 05

MNT Output Files

Structured MNT files are generated as the pipeline's deliverable format.

STEP 06

Retail Systems

Output feeds downstream retail systems as part of the migration.

// Skills & Tools

What I work with

Tools and technologies I use or have used in my projects.

Languages & Frameworks

JavaCore JavaSpring FrameworkPython

Databases

Oracle 12cSQL

Integration & Middleware

Oracle SOA SuiteREST APIsOAuth 2.0Postman

DevOps & Automation

GitGitHub Actions (CI/CD)

Support & QA

Application Support (L1/L2/L3)Manual Testing

Retail Platforms

StoreHub
0
Years Experience
0
Retail Brands Supported
0
Support Tiers (L1–L3)
0
Weekly Blog Posts · Every Monday
// Get in touch

Let's connect

Open to discussions on website projects, technical writing, collaboration, or anything else I can help with on my own time.

Or reach out directly:

prafullranjan@zohomail.in