Siddharth Dheer PL/SQL, SQL, Python, Data Warehousing, Tableau
No reviews yet

Utilizing innovative teaching methodologies, I adapt curriculum content to diverse learning styles, ensuring an inclusive and stimulating educational environment. Skilled in employing technology tools like Python-RDBMS connectivity and Oracle Apex, I strive to craft dynamic lessons that encourage critical thinking and active participation. Throughout my roles at Steriware Plastic Products Pvt Ltd, Advance Car Rentals, and Excel Food Mart, I played a pivotal role in training and onboarding new team members. Leveraging my expertise in Oracle technologies and project intricacies, I've been instrumental in facilitating the seamless integration of new hires into our technical teams.
At Steriware, I designed and conducted comprehensive training sessions, enabling new team members to swiftly grasp essential technical skills for projects involving Inventory Management and Sales Forecasting. This proactive approach streamlined the onboarding process, expediting the integration of fresh talent and enhancing our team's overall efficiency in meeting project milestones.
During my tenure at Advance Car Rentals, I continued this commitment to training excellence. I crafted tailored training materials and conducted hands-on sessions to equip newcomers with the requisite proficiency in Oracle technologies and Python for the 'Ease to Reservations' project. These initiatives significantly contributed to our team's agility in responding to project requirements, accelerating our collective ability to deliver high-quality results within stringent timelines.
Similarly, at Excel Food Mart, I took the lead in coaching and training new team members, ensuring a smooth transition into the project focused on Inventory Management Systems. By sharing my expertise in Oracle technologies and optimizing data processes, I facilitated a quick and efficient learning curve for the incoming talent, enabling them to actively contribute to our project's success from the onset.

Subjects

  • Python Expert

  • SQL Expert

  • PL/SQL Expert

  • Tableau Expert

  • Oracle Apex Expert

Experience

  • Software Developer (Dec, 2021–Present) at Advance Car Rentals, Melbourne, VIC, Australia
    • Data Integration & Oracle Analytics: Ensured seamless CSV data integration into Oracle tables using SQL Loader, guaranteeing precision and completeness essential for Oracle Apex analytics and reporting.
    • Database Optimization & Query Enhancement: Orchestrated query enhancements, index creation, and master/transaction table management for superior data retrieval tailored to Oracle Apex applications.
    • Dashboard Development & KPI Emphasis: Engineered screens, parameter forms, and diverse layouts/models in Oracle Apex, highlighting Key Performance Indicators (KPIs) for comprehensive reporting.
    • Tool Integration & Functional Development: Proficiently utilized Oracle Apex for robust functional development, integrating front-end design with PL/SQL scripting for optimal application efficiency.
    • Documentation & Maintenance Excellence: Maintained meticulous operational and system-level documentation, critical for Oracle Apex application optimization and clarity during Oracle migration phases.
    • Analytical Problem-Solving & Migration Expertise: Applied advanced PL/SQL concepts, refined SQL queries, and actively contributed to Oracle migration within Oracle Apex, showcasing acute analytical skills.
    • Collaboration & Agile Team Player: Demonstrated effective collaboration within diverse teams on Oracle Apex form development, ensuring individual contributions and cohesive teamwork to meet stringent project deadlines.
  • Software Developer (Dec, 2021–Apr, 2022) at Excel Food Mart, Melbourne, VIC, Australia
    • Database Integration & Performance Enhancement: Utilized SQL Loader to seamlessly integrate CSV data into Oracle databases, enhancing data performance through index-driven query enhancements, boosting operational efficiency.
    • Forms Development & Business Alignment: Engineered user-friendly interfaces using Oracle Apex, aligning with dynamic business needs, facilitating streamlined user interactions and improved efficiency.
    • Database Customization & Adaptability: Tailored SQL scripts for diverse database elements, demonstrating adaptability and ensuring efficient management amidst evolving business requirements.
    • Analytical Aptitude & Collaborative Skills: Showcased robust analytical skills within diverse teams, playing a pivotal role in meeting project milestones and fostering effective collaboration.
    • Optimized Reporting & Design Leadership: Led the design of intuitive screens, parameter forms, and optimized report layouts using Oracle Reports & Forms, efficiently meeting comprehensive reporting demands.
    • PL/SQL Implementation & Migration Expertise: Executed intricate PL/SQL concepts and managed migrations between Oracle versions, architecting advanced database procedures and functions for seamless transitions.
    • Adaptive Oracle Proficiency: Demonstrated in-depth understanding and adaptability in Oracle technologies (Oracle Apex, PL/SQL, SQL), aligning scripts with evolving business needs for seamless integration.
  • Apex Developer (Mar, 2020–Apr, 2021) at Steriware Plastic Products Pvt Ltd, Faridabad, Haryana, India
    • Data Optimization & Predictive Analytics: Applied Oracle APEX and SQL expertise to optimize data management, streamline inventory processes, and implement precise predictive sales analytics, catalysing operational efficiency and proactive decision-making.
    • Customization & Tailoring Solutions: Fine-tuned Oracle APEX forms and SQL statements, creating a dynamically tailored data landscape aligning with evolving business demands, ensuring agility and scalability.
    • Collaborative Problem-Solving & Data Integrity: Led collaborative efforts resolving intricate data challenges, fortifying data integrity, and facilitating swift, proactive decision-making, fostering a proactive problem-solving environment.
    • Reporting Innovation & Decision Enhancement: Architected avant-garde report layouts and dynamic data models, amplifying decision-making efficacy through intuitive and actionable data representation, empowering stakeholders with actionable insights.
    • Flawless Migration & Technology Expertise: Spearheaded a seamless migration to Oracle 19c Exacc, demonstrating mastery in Oracle technologies and apex scripting, seamlessly aligning with heightened business imperatives, ensuring continuity and improved efficiency.

Education

  • Business Analytics (Nov, 2019–Nov, 2021) from La Trobe University, Melbourne, Australia

Fee details

    AU$35–40/hour (US$22.29–25.48/hour)

    Based on travelling Minimum fee 45 AUD
    Maximum Fee would be 55 AUD

Reviews

No reviews yet. Be the first one to review this tutor.