📚 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
- AI-assisted Daily Publishing Workflow
STATUS: OPERATIONAL · 8+ YRS UPTIME
Prafull Ranjan
Backend-focused software engineer with close to eight years at SkillNet Solutions, Inc.,
building and supporting production systems for global retail brands—from legacy data
migration to Java/Spring services that keep real stores and storefronts running.
Beyond engineering, I actively share practical knowledge through
PrafullTalks, where I publish articles on enterprise technology,
software engineering, life insights, and social issues. My goal is to make complex
topics simple, practical, and useful for everyone.
// About
Backend systems, kept running.
I'm a backend-focused software engineer with close to eight years of experience at SkillNet Solutions, Inc., primarily working in the retail domain. Over that time I've supported and built systems for international retail brands — helping them migrate legacy data, keep production systems running, and deliver features reliably under real business deadlines.
My core strength is backend development and application support — writing and maintaining Java/Spring services, working with Oracle databases and SQL, and providing L1/L2/L3 production support: investigating live issues, reading through logs under time pressure, debugging defects, and coordinating fixes to keep critical retail systems running.
I've also taken on work outside my usual stack when a project needed it — including picking up Oracle SOA Suite for a data migration project with no prior hands-on experience, and delivering it on time. Outside of client work, I build and maintain personal engineering projects to keep learning new tools on my own terms.
✍️ Beyond Software Engineering
Alongside my professional work, I actively write practical articles through PrafullTalks, my personal knowledge platform.
I enjoy simplifying enterprise technology, software engineering concepts, productivity, life lessons, and social topics into practical articles that are easy for anyone to understand.
✍️ Knowledge Sharing
Outside my professional work, I enjoy simplifying complex technology and sharing practical knowledge. Alongside my professional work, I maintain PrafullTalks, a personal knowledge platform where I document what I learn and publish practical articles on enterprise technology, software engineering, life, and society.
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 Platform
PrafullTalks ↗
Writing Focus
Technolog • Life Insights • Social Issues
// Experience
Client engagements at SkillNet Solutions
One continuous employer, six retail-brand engagements — spanning data migration, backend development, and production support.
SPS International School — Website Design & Development
Live2026 · Client Project
Designed and built a complete admissions and marketing website for a school (Nursery to Class 8) from scratch, self-initiated outside my usual client work. Delivered an animated hero with live counters, About/Principal's message/Team sections, a facilities showcase, a transparent "Today / In Progress / Future Vision" growth story section, an academic journey timeline, a notice board, WhatsApp update integration, a photo/video gallery, testimonials, an FAQ accordion, a spam-protected admission enquiry form, and a contact section with embedded Google Maps — deployed and hosted entirely free on Netlify.
ASUR — Data Migration Project
ActiveJun 2026 — Present
Designed and implemented a data migration solution using Oracle SOA Suite with embedded Java, extracting client data from legacy source databases and generating structured MNT output files as part of an end-to-end migration pipeline. Built custom data transformation logic within SOA composites and automated the fetch-and-generate process, reducing manual effort. Delivered on schedule despite starting with no prior hands-on Oracle SOA experience.
Estée Lauder Companies (ELC)
ActiveNov 2020 — Present
Contributed to a project for Estée Lauder Companies, an American multinational manufacturer of skin care, makeup, fragrance, and hair care products. Worked primarily on transforming legacy data into XML for consumption by the Relate system, alongside backend development, application support, manual testing, and deployment.
Sally Beauty Holdings (SBH)
ArchivedAug 2018 — Oct 2025
Supported a project for Sally Beauty Holdings, an American international specialty retailer operating 4,000+ stores across more than 6,000 beauty products. Focused on application support and manual testing, with additional contributions to backend development tasks.
Charlotte Tilbury Beauty Ltd
ArchivedMar 2023 — Aug 2025
Contributed to a project for Charlotte Tilbury, a UK-registered cosmetics company. Worked on backend development using Core Java and SQL to support business and data-processing requirements, and handled deployment of a utility JAR file to UAT and Production as part of the release process.
Blick Art Materials
ArchivedFeb 2022 — Mar 2024
Contributed to a project for Blick Art Materials, one of the oldest and largest U.S. art supply retailers, with 65+ stores and 90,000+ products online and in-store. Worked on backend development with Java and Spring Framework, wrote and optimized SQL queries, and used Postman for API testing and validation.
West Marine
ArchivedMar 2022 — Jun 2023
Contributed to a project for West Marine, a leading U.S. boating supply and fishing retail chain. Worked on backend development using Java and Spring Framework, and wrote and optimized SQL queries to support business operations and data management.
// Featured Build
PrafullTalks — AI-Assisted Publishing Platform
A production-ready automation platform that researches, generates,validates, publishes, and archives SEO-friendly blog content with minimal manual effort.
Self-Initiated
AI-Assisted
Runs Daily
OAuth 2.0
GitHub Actions
A fully automated content pipeline — no manual intervention
This project combines AI-assisted content generation, automated validation, Blogger API publishing, OAuth 2.0 authentication, image integration, scheduled GitHub Actions workflows, and automated content archiving into a single end-to-end publishing platform.
- AI content generation: integrated the Anthropic Claude API with structured, multi-step prompting and automatic model fallback.
- Publishing automation: integrated the Google Blogger API — OAuth 2.0 with full refresh-token lifecycle management — to publish content programmatically.
- Self-healing internal linking: fetches live post data from the API to generate and verify working internal links, and automatically re-queues content if a linked post is later removed.
- CI/CD: scheduled and monitored via GitHub Actions, with automatic failure alerts, dry-run testing modes, and validation checks before anything goes live.
- SEO tooling: built diagnostic and bulk-repair scripts — including an automated internal-link auditor — to keep the live site healthy at scale.
Built independently — including debugging real production issues such as OAuth token expiry, third-party API breaking changes, and data-consistency bugs across a multi-service pipeline.
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.
✍️ 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.
// Systems
ASUR migration — architecture
A genuinely sequential pipeline: legacy retail data moves through Oracle SOA Suite and custom transformation logic before it ever reaches a downstream system.
Legacy Data → Structured Retail Output
Oracle SOA Suite · Core JavaSTEP 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
Technical toolkit
Grouped by where each tool actually shows up in the stack — not a flat tag cloud.
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 Owned (L1–L3)
0
Automated Runs · Daily Pipeline
// Get in touch
Let's connect
Open to discussions on backend engineering,enterprise applications,automation,technical writing,or collaboration opportunities.
linkedin.com/in/prafull-ranjan