Mohan Raaj Email & Phone Number

Chennai, Tamil Nadu, India

Chennai, Tamil Nadu, India

Developed: Tailored procedures, functions, and views for Shipping and Finance services, aligning closely with client requirements and company policies.Implemented: Performance tuning concepts, leveraging in-depth knowledge to improve application performance (Tuned functions, procedures, and views, incorporating indexes and constraints to enhance database performance).Led: Migration and conversion of Oracle procedures, functions, and views to MySQL, ensuring seamless data… Show more Developed: Tailored procedures, functions, and views for Shipping and Finance services, aligning closely with client requirements and company policies.Implemented: Performance tuning concepts, leveraging in-depth knowledge to improve application performance (Tuned functions, procedures, and views, incorporating indexes and constraints to enhance database performance).Led: Migration and conversion of Oracle procedures, functions, and views to MySQL, ensuring seamless data transition.Designed: Database security triggers, establishing an auditing log table to monitor user activity and ensure data security.Executed: Complex SQL queries, including joins and subqueries for efficient data retrieval from multiple tables.Utilized: Bulk Collections for optimized data retrieval, enhancing performance and facilitating efficient data handling.Utilized: Excel extensively for data cleaning, manipulation, and analysis to support SQL-based operations.Developed: Excel-based models for data tracking and reporting purposes, ensuring accuracy and efficiency.Performed: VLOOKUP, pivot tables, and complex formulas in Excel for data analysis and visualization.Generated: Comprehensive reports using Pentaho after extensive client interaction, ensuring precision and relevance.Contributed: Actively to continuous enhancements and troubleshooting of production issues for seamless operations.Resolved: Day-to-day operational issues from the company portal, maintaining high client satisfaction.Mentored: Junior colleague, fostering skill development in SQL programming and client management.Managed: Diverse client portfolios, overseeing requirements and deliverables for 12 small travel customers, 3 major travel customers, 5 small shipping customers, and one major shipping client. Show less

Contributed: Actively to continuous enhancements and troubleshooting of production issues for seamless operations.Resolved: Day-to-day operational issues from the company portal, maintaining high client satisfaction.Mentored: Junior colleague, fostering skill development in SQL programming and client management.Managed: Diverse client portfolios, overseeing requirements and deliverables for 12 small travel customers, 3 major travel customers, 5 small shipping customers, and one… Show more Contributed: Actively to continuous enhancements and troubleshooting of production issues for seamless operations.Resolved: Day-to-day operational issues from the company portal, maintaining high client satisfaction.Mentored: Junior colleague, fostering skill development in SQL programming and client management.Managed: Diverse client portfolios, overseeing requirements and deliverables for 12 small travel customers, 3 major travel customers, 5 small shipping customers, and one major shipping client. Show less

Master Of Science In Computer Science: Artificial Intelligence And Machine Learning, Artificial Intelligence And Machine Learning

Bachelor'S Degree, First Class

Nebosh-Health And Safety, Health And Safety

Education record