AugmntX

AugmntX is the world’s largest network of pre-vetted talent.

Contact Info

305, IRIS Corporate Centre,
Hiranandani Meadows, 400610.
hello@augmntx.com
+919820045154

Follow Us

Home / Developers / AXF34441
profile image
Yagnam J AXF34441 Active
PLSQL developer in hyderabad
Highly skilled Database Developer with 4 years of experience in designing developing and optimizing relational databases Proficient in PLSQL programming SQL query optimization and database design Seeking a challenging SQL and PLSQL Developer role in a dynamic professionally managed company that offers growth and learning opportunities where I can contribute to the company success while advancing my own career
Industries : Entertainment, Food and Beverages
Share
Hire Yagnam J
Download PDF
Availability
Full-time
Total experience
4 years
Technical skills
PLSQL
4 Years & 1 Months
SQL
4 Years & 1 Months
Oracle
4 Years & 1 Months
unix
4 Years & 1 Months
Github
4 Years
SAP Business Objects
3 Years
Java
2 Years
Python
1 Years
PL/SQL, SQL Developer, SAP BusinessObjects (BO), JIRA, Putty, ServiceNow (SNOW), Git, SVN, Agile
Projects
Digital Entertainment Exchange(DEX)
July-2022 to March-2026
Description
Developed a comprehensive web application enabling users to book theaters for movie releases efficiently. Designed and implemented key modules including booking creation, billing and payment processing to enhance user experience. Managed and optimized over 100 dynamic screens, ensuring seamless navigation and system scalability.
Roles and Responsibilities
Collaborated with stakeholders to gather business requirements, define user stories, estimate story points and manage tasks using JIRA for efficient Agile project execution. Developed and enhanced new features for the DEX SaaS product, addressing product tickets to enhance functionality across multiple studios. Independently managed the DEX production support queue, resolving support tickets and production issues to ensure system stability and timely resolution. Communicated regularly with clients through emails and calls, providing detailed extracts, technical solutions and information to managers and directors across multiple regions. Identified defects, performed root cause analysis (RCA) and implemented permanent fixes to prevent recurring issues. Automated go-live data loading for new clients in the DEX application, reducing manual effort and improving efficiency. Learned SAP BusinessObjects (BO) to manage client reports and contributed to migrating reports from SAP BO to Java, resulting in reduced project costs. Designed and developed database schemas for APIs, ensuring smooth data integration and post-implementation support. Developed database schemas and created ETL workflows in PL/SQL for mini-projects to facilitate data exchange between internal systems and external sources. Conducted code reviews, provided constructive feedback and supported team members in resolving technical challenges. Worked independently while collaborating effectively with cross-functional and multi-location teams in high-pressure environments. Received multiple appreciations from both managers and clients for consistently providing high-quality work and effective solutions.
Technologies: PL/SQL, SQL, Java, SQL Developer, SAP BusinessObjects (BO), JIRA, Putty, ServiceNow (SNOW), Git, SVN, Agile
Industry: Entertainment
Restaurant file management (RFM)
February-2022 to June-2022
Description
W Worked with a top CPG client, utilizing an RFM application with modules such as menu items, pricing, administration and reporting to streamline operations.
Roles and Responsibilities
Played a key role in the RFM migration from Oracle 12c to 19c, delivering effective solutions to address client issues during the migration process. Handled support tickets from clients across different countries, delivering comprehensive extracts, scripts and solutions. Focused on identifying defects, analyzing root causes and implementing permanent fixes to prevent recurrence of issues.
Technologies: PL/SQL, SQL, Java, SQL Developer, SAP BusinessObjects (BO), JIRA, Putty, ServiceNow (SNOW), Git, SVN, Agile
Industry: Food and Beverages
Work history
PLSQL developer • February-2022 to March-2026
Description: Analyze business requirements and design technical solutions using SQL and PL/SQL. Develop, test, and optimize complex SQL queries, stored procedures, functions and packages. Create and manage database objects such as tables, views, indexes, sequences and triggers. Perform query optimization and performance tuning using Explain Plan and indexing strategies. Handle production support by debugging PL/SQL code and resolving database-related issues. Conduct root cause analysis (RCA) and implement permanent fixes for recurring database problems. Develop and maintain ETL workflows using PL/SQL for data integration between systems. Automate data loading and processing tasks using PL/SQL scripts to reduce manual effort. Work on data validation, data extraction, and report generation for business needs. Collaborate with stakeholders to clarify requirements and provide technical solutions. Support report generation and migration activities (SAP BO to other platforms). Participate in code reviews and ensure best practices in PL/SQL development. Work in Agile environment using JIRA to manage tasks and track progress
Certifications
PLSQL by Capgemini
2026
Agile Software Development by Coursera
2025
Oracle Cloud Infrastructure 2023 Foundations Associate by Oracle
2024
Education
Bachelors degree in CSE
JNTUK
2018 to 2022
Language
English - Advanced