Daiyaan Baug
Software Developer
Summary
Proven Software Developer with a robust background in Oracle EBS optimization and PL/SQL programming, demonstrated at Dayforce and other leading companies. Expert in SQL and PL/SQL for designing, coding and testing database solutions, with a knack for mentoring teams towards excellence. Achieves significant process efficiencies through innovative solutions, showcasing strong analytical and leadership skills.
Overview
7
7
years of professional experience
1
1
Certification
Work History
Software Developer
Dayforce
03.2022 - Current
- Optimized existing PL/SQL routines using performance tuning techniques such as indexing, query optimization, bulk processing, exception handling, minimize context switching and query hints strategies.
- Managed multiple projects simultaneously while adhering to strict deadlines, maintaining a high level of quality throughout all deliverables.
- Provided critical technical support to end-users, ensuring smooth operations and minimal downtime.
- Mentored junior PL/SQL developers, fostering an environment of collaboration and continuous learning.
- Ensured compliance with industry standards by following best practices in code development, version control, and deployment methodologies.
- Developed, implemented and optimized packages, stored procedures, functions, triggers, materialized views.
- Worked closely with Singapore’s government business (PSD - Public Service Department) analysts and infrastructure specialists to deliver high availability oracle PL-SQL solutions for mission-critical In-House applications product called (Excelity) by Dayforce.
Senior Software Engineer
EClerx Services
05.2020 - 12.2021
- Collaborated with cross-functional teams to ensure successful integration of Oracle EBS systems with other platforms.
- Developed custom Oracle Reports (RDFs & RTFs), Oracle Interfaces & Conversions, XML BI/Publisher reports, Oracle Alerts, Forms Personalization, packages, stored procedures, functions, triggers and materialized views to improve business process efficiency.
- Conducted thorough testing and debugging of Oracle applications, ensuring optimal functionality and user satisfaction.
- Participated in regular meetings with project stakeholders to provide progress updates and discuss potential improvements or challenges moving forward.
- Enhanced system performance by optimizing SQL queries.
- Developed dynamic SQL for real time custom table/query generation.
- Provided exceptional technical support to clients, resolving complex issues promptly and effectively.
Senior Analyst
Capgemini Technology Services
06.2019 - 05.2020
- Documented program development, revisions and accurately maintained historical records (MD‑50, MD‑70, and MD‑120).
- Independently developed custom Oracle Reports (RDFs & RTFs), Oracle Interfaces & Conversions, XML BI/Publisher reports, Oracle Alerts, Forms Personalization, packages, stored procedures, functions, triggers and materialized views to improve business process efficiency.
- Developed custom (Basic) Unix scripts for various business needs, simplifying tasks and improving productivity across departments.
- Automated routine tasks with the creation of custom scripts, boosting team productivity.
- Implemented advanced error handling techniques in PLSQL code, resulting in robust applications with minimal crashes.
- Built databases and table structures for web applications.
Software Engineer
Clover Infotech Pvt.Ltd
10.2018 - 06.2019
- Developed Oracle WebADIs and Oracle Form Personalization from ground up for Fixed Assets module in Oracle EBS system.
- Designed and developed custom Oracle Reports (RDFs & RTFs), XML BI/Publisher reports, Forms Personalization, packages, stored procedures, functions, triggers and materialized views to improve business process efficiency.
- Created a custom Oracle Report to retrieve full information about a purchase order in Procure to Pay life cycle in Banking Financial sector.
- Managed multiple projects simultaneously while adhering to strict deadlines, maintaining a high level of quality throughout all deliverables.
Programmer Analyst
Chenab Infotech
12.2017 - 07.2018
- Authored code fixes and enhancements for inclusion in future code releases and patches.
- Provided ongoing support for users experiencing issues or requiring assistance with application functionality.
- Contributed to successful project completion with effective time management and prioritization skills, meeting tight deadlines consistently.
- Collaborated with cross-functional teams to ensure seamless integration of new features into existing applications.
- Designed objects like (Functions, Procedures, Packages, Cursor, Triggers).
- Participated in designing In-House Software Products (EMS) with clients to ascertain all project specifications for applications, databases and systems.
Education
Bachelor of Science - Computer Science
Oriental Education Society
India10.2016
Skills
- Packages, Procedures, Triggers, Functions, Materialized View, Reference Cursors, Dynamic SQL, Autonomous Transactions, Bulk Processing, API Interfaces & Conversions
- Oracle Reports (RDFs & RTFs), Alerts, SQL*Loader and Forms Personalization
- SQL Query Optimization and Advanced PL/SQL programming
- Performance Tuning Techniques
- Data Modeling and Design
- PL/SQL Exception Handling and Debugging
- Programming Languages: Python, MySQL, SQL*Lite, Unix Shell Scripting, XML BI Publisher and WebADIs
- Tools: TOAD, SQL*Developer, SQL*Plus, WINSCP & PUTTY, GitHub, IBM Watson, Anaconda, Jupyter Notebooks & Labs
Certification
- IBM Certified Data Science Professional
- Oracle Certified Associates (Oracle ID: OC1693036)
Timeline
Software Developer
Dayforce
03.2022 - Current
Senior Software Engineer
EClerx Services
05.2020 - 12.2021
Senior Analyst
Capgemini Technology Services
06.2019 - 05.2020
Software Engineer
Clover Infotech Pvt.Ltd
10.2018 - 06.2019
Programmer Analyst
Chenab Infotech
12.2017 - 07.2018
- IBM Certified Data Science Professional
- Oracle Certified Associates (Oracle ID: OC1693036)
Bachelor of Science - Computer Science
Oriental Education Society
Similar Profiles
David CartagenaDavid Cartagena
Senior Delivery Lead at DayforceSenior Delivery Lead at Dayforce
Anand PrabhaAnand Prabha
Talent Acquisition Lead at DayforceTalent Acquisition Lead at Dayforce
Mikhill Raj MarcharchandMikhill Raj Marcharchand
Services Consultant at DayforceServices Consultant at Dayforce