Ajay More

AJAY BALKRISHNA MORE Software Developer CAREER SUMMARY: Experienced PL/SQL Developer with 5+ years of expertise in developing and maintaining Oracle databases and database-driven applications. Skilled in PL/SQL, SQL, and Oracle Database, with a focus on performance tuning, query optimization, and data analysis. Adept at writing complex SQL queries, creating stored procedures, and automating repetitive tasks to improve efficiency. Passionate about ensuring high data quality and providing robust solutions that meet both business and technical requirements. STRENGTH: Ability to Multitask. Time Management of Work. Hardworking towards goal until it gets achieved. PERSONAL INFORMATION: Nationality :- Indian Hobbies :- Kabaddi, Cricket, Chess, Carrom, Reading Books Languages Known :- Can Speak, Read & Write English, Hindi and Marathi WORK EXPERIENCE: Nextgen Data Clearing Pvt. Ltd. PL/SQL Developer | 20 December, 2022 - Present Possess extensive knowledge of the telecommunication industry, with practical experience in handling roaming data processes and ensuring adherence to industry standards. Designed and implemented an automated file processing utility using Windows Batch Script shortly after joining, streamlining data handling processes. Developed automated processes for installer deployment on servers, improving efficiency and reducing manual efforts. Enhanced database performance by analyzing and optimizing SQL queries, procedures, and execution plans. Worked closely with cross-functional teams, including business analysts and QA, to ensure seamless project delivery and adherence to requirements. Designed and implemented advanced business logic to accurately rate Call Detail Records (CDRs) in the IoT Separation module. Contributed to the BCE project by performing advanced data segmentation and summarization, optimizing data workflows and reporting accuracy. Supervised and mentored junior developers, facilitating clear requirement gathering and ensuring effective ticket resolution. Created and maintained detailed documentation of workflows, processes, and projects in Confluence, ensuring clear communication and knowledge sharing across teams. HCL Technologies Software Engineer | 1 August, 2021 - 19 December, 2022 Responsible for deploying changes across production and non-production environments in the pharmaceutical domain, ensuring smooth transitions and minimal downtime. Analyzed system issues, implemented solutions, and proposed workarounds to maintain business continuity in medical and pharmaceutical applications. Took proactive actions to resolve critical issues promptly. Collaborated with users to prioritize tickets and enhancements for quarterly application releases, ensuring alignment with business needs. Provided support to the development team during UAT, ensuring functionality met business requirements. Delivered weekly and monthly incident trend reports to client managers and development managers, contributing to performance analysis and decision-making. Managed the release of components to the production system after performing high-level verifications and ensuring all requirements were met. Worked closely with development teams to test enhancements and fixes in test environments, ensuring successful production releases after signoff from business and support teams. Utilized Service Now and Remedy for efficient incident tracking and ticketing management. G-Tech Solutions Production Support Engineer | 22 May, 2019 - 31 July, 2021 Provided end-user communication for critical service disruptions and delays, ensuring timely resolution and minimizing business impact. Conducted daily system and application health checks to ensure seamless operations and identify potential issues proactively. Addressed user queries related to reports, job schedules, and database management, delivering solutions within defined SLAs. Developed audit and user reports using Oracle SQL/PLSQL, ensuring accurate and efficient data retrieval. Gained strong technical and functional knowledge of Loan Originating System (LOS) and Loan Management Systems (LMS) in Rsystem and FinnOne. Managed and maintained Oracle Database systems, ensuring data integrity, availability, and optimal performance. Automated routine tasks by writing PL/SQL queries and creating jobs to enhance efficiency and reduce manual effort. Streamlined the deployment process through automation scripts, improving deployment speed and consistency. Developed and maintained SSRS (SQL Server Reporting Services) reports to deliver business-critical insights. SOFT SKILLS: Reading Books Solving Cubes Problem solving Teaching Communication skill TECHNICAL SKILLS: Operating System :- Linux/Unix (Ubuntu,CentOS), Windows. Programming Languages :- Python, Java, JavaScript, Shell Scripts. Databases :- SQL (Oracle PL/SQL & Postgres), MySql, ORM (Object Relational Mapping), Oracle APEX. Version Control :- Git, GitHub, GitLab. Application Development Tools :- Net Beans IDE, Eclipse IDE, PyCharm IDE, Visual Studio Code. Software Development Tools :- PL-SQL Developer,SQL Developer, TOAD, SSRS Reporting Services. Containerization :- Docker. CI/CD Tool :- Jenkins, Gitlab. Cloud Technologies :- AWS(EC2, S3, Lambda, RDS). Front-end and back-end development. Code structure and architecture. Database performance optimization. EDUCATION: 2014 - 2018 | Padmabhushan Vasantdada Patil College of Engineering Bachelor of Engineering - Electronics Passed with First Class | CGPA :- - 2014 | Sandesh College of Art, Commerce and Science 12th Grade Passed with First Class | Percentage :- - 2012 | Little Flower English High School 10th Grade Passed with First Class | Percentage : 75.64 CERTIFICATIONS: Python Programming Machine Learning