
Reporting Data Engineer I
Kreon Financial ServicesSenior Data Engineer
ApptadAI Development Analyst
MEA Platform
Power BI

Microsoft Excel

PowerPoint

SQL

Excel

ServiceNow

ArcGIS
Azure

MS Excel

Python

PowerBI

Advanced Excel

My SQL

Data Analysis
In my recent role at my app, Ted, I was working as a data analyst, but I was able to maintain cost improvements and increase customer retention by 60%. I led a team to complete a project ahead of schedule. This experience taught me a lot about my valuable skills, my problem-solving abilities, and which I'm excited to bring to this position. Outside of work, I'm passionate about mentioning my special skills. I like learning new techniques and monitoring others in my field. As I believe, I closely align with my career goals, and I have hands-on experience working with Oracle E Business Suite, R2L, primarily in the areas of financial analysis, supply chain, HRMS, etc. Over the course of my time working with Oracle EBS, I have gained strong skills in configuring modules, managing workflows, creating custom reports, and troubleshooting issues. In my previous role at my company, I was responsible for various responsibilities, including implementing new modules, optimizing existing processes, and supporting end-to-end users. One of my key achievements was being part of a rollout and process improvement or cost-saving initiative that involved Oracle EBS, Artwell. This experience strengthened my skills in cross-functional collaboration and attention to detail. Initially, I'm familiar with the technical aspects of Oracle EBS, including SQL, PL/SQL, and using Oracle forms or reports for customization and integration with other systems. I understand the importance of ensuring data integrity and providing accurate reporting, which is why I prioritize my work with Oracle EBS.
So I have significant development experience in Oracle EBS R2, particularly with the AP, AR, and GL modules. My work has involved creating custom solutions to meet specific business needs and integrating EBS with other enterprise applications. For integration projects, I have developed and maintained APIs and interfaces to ensure smooth data flow between Oracle EBS and external systems. Often using Oracle API and XML gateway. I've also created custom stored procedures for data validation and transformation, which streamline processes and enhance data integrity. In terms of personalization, I have tailored Oracle forms to improve user experience and align them with business requirements, adjusting layouts, default values, and adding validations to reduce errors. I'm proficient in PL/SQL, allowing me to build and optimize stored procedures for reporting and data manipulation across the AP, AR, and GL modules. These customizations have contributed to more efficient data processing and helped teams gain real-time insights.
If you lack experience in development, APARTL integration projects, form personalization, stored procedures, custom reports, and configurations, APAR. My strategy for gaining expertise in those areas is both structured and proactive. First, I would start with self-paced learning to build a foundation. I'd focus on Oracle EBS training resources, especially modules on APER and GL, and any available documentation or tutorials on development, form personalization, and integration techniques. Next, I would seek hands-on experience, as I believe practical exposure is essential for technical skills. I would start working on small internal projects or environments, practicing tasks like writing simple PL/SQL scripts, building sample forms, or configuring basic API requirements and integrations. This approach will help me gain confidence in a controlled environment before working on larger projects. I would also go out to colleagues and mentors with expertise in these areas to learn best practices and gain insights from their experiences. If possible, I would shadow them on relevant projects to assist them in testing and troubleshooting, gaining real-world insights and exposures. Finally, I would commit to continuous learning, staying updated with Oracle's latest releases, participating in online forums, and enrolling in advanced courses. I'm confident that my focused effort will quickly acquire the necessary skills and add value to the team.
All the techniques for a major Oracle ERP system update, risk identification and mitigation are crucial to ensure smooth and successful rollout. So, basic techniques would be a comprehensive risk assessment and impact analysis. By starting or by starting a thorough risk assessment to identify potential issues such as data losses and integration failures or downtime. Engaging stakeholders across departments helps uncover hidden risks, assess how to update it, and that might impact each model, analyzing dependencies, and performing impact analysis helps prioritize risk based on severity and likelihood. The second technique would be the environment of progression and backup strategy. By establishing a robust backup plan including full system backups before the update and incremental backups throughout. Testing backups in source quick recovery in case of failure. Creating a separate testing environment to mirror the product, set up allowing for a safe testing without impacting daily operations. The third one includes user acceptance testing and stakeholder involvement. Engaging users in UAT ensures that the update meets business requirements and minimizes user-related issues. UAT also gives users a chance to familiarize themselves with the new features or changes, reducing resistance and promoting a smoother transition. And the last one includes data validation. I would suggest developing scripts or procedures to validate data integrity before and after the update. Reconcile key data points such as balances in the GL and the AP to ensure there's no data corruption or loss of data.