Perike Mohan
SQL Developer • Markapur, Andhra Pradesh • m*********@gmail.com • +91*******270 • linkedin.com/••••• • drivetube.ai/•••••
Career Objective
SQL Developer with 0 years of professional experience, skilled in Oracle 19c SQL and PL/SQL development through academic projects and hands-on certification training. Experienced writing complex SQL queries, stored procedures, functions, triggers and cursors; practiced in data modeling, normalization and CRUD operations. Familiar with Oracle SQL Developer and SQL*Plus, version control with Git/GitHub, and front-end basics (HTML5, CSS3, JavaScript ES6). Seeking an entry-level SQL/PLSQL Developer role to apply strong analytical, debugging and query-optimization abilities to production database applications.
Education
Dr. Samuel George Institute of Technology and Science, Markapur (Affiliated to JNTUK)
Bachelor of Technology (B.Tech) • Markapur, Andhra Pradesh, India • 2025
Technical Skills
Programming Language: SQL,JavaScript
Frontend Technologies: HTML5,CSS3
Databases: Database Design,Normalization,CRUD Operations,DBMS,RDBMS,Oracle,PL,Stored Procedures,Stored Functions,Views,Indexes,Sequences,Constraints,Joins,Subqueries,Exception Handling
Version Control & Development Tools: Git,GitHub
Data Warehousing: Data Modeling
Generative AI & LLMs: Cursor
Project Management & Collaboration: SQL*Plus
Platform Development & Configuration: Triggers
Projects
Predicting Mobility Patterns of Tourists | Feb 2025 – Apr 2025
Tools Used: SQL, Oracle 19c, Data Modeling, Normalization, PL
- Designed and normalized relational schema for tourism datasets, reducing redundancy and enabling efficient analytical queries using Oracle 19c.
- Wrote complex SQL queries and joins to aggregate travel records and extract movement features used for mobility analysis.
- Implemented PL/SQL procedures to preprocess and clean large travel datasets, improving downstream query performance and data reliability.
- Optimized slow-running queries by adding appropriate indexes and rewriting subqueries, reducing average query execution time during analysis.
- Documented ETL steps, data model and query logic; maintained versioned SQL scripts in Git for reproducibility and review.
LeetCode Metrics Dashboard
Tools Used: HTML5, CSS3, JavaScript ES6
- Developed a responsive web dashboard to track LeetCode problem progress using HTML5, CSS3 and JavaScript (ES6).
- Built dynamic UI components to display problem categorization, difficulty and solve-status, enabling quick visual tracking of practice progress.
- Implemented client-side logic to persist and update progress state in-browser and reflect analytics in real time.
- Structured front-end data flows to map user interactions to logical entities (problems, categories, status), demonstrating understanding of CRUD-like operations.
- Documented code and user interactions; stored project source in GitHub for version control and portfolio presentation.
Certifications
SQL and Oracle PL/SQL Certification Training
Achievements
- Applied PL/SQL Concepts Across Academic Projects: Implemented joins, cursors, triggers, procedures and functions in coursework and projects to solve real data problems and automate processing.
- Completed Hands-on Database Projects: Delivered multiple end-to-end academic projects involving schema design, query optimization and PL/SQL scripting.
- Consistent Self-Learning and Tool Adoption: Quickly ramped up on Oracle tools and version control through self-study and practice, maintaining clean code and documentation.
Powered by Drivetube · Create your own profile at drivetube.ai