Marcio J.Back-end and Systems Engineer
Skills
Software Developer specializing in Oracle technologies, including Oracle Forms/Reports, PL/SQL, Oracle Apex, and Jasper Ireport. Demonstrates in-depth knowledge of PL/SQL fundamentals, cursors, composite variables, packages, stored procedures, functions, triggers, and exceptions. Proficient in the use of Forms 12c, 11g, and 6i, with a focus on module and block relationships, as well as canvas design elements such as text items and checkboxes. Skilled in developing Reports 11g and 6i, particularly in crafting various report types, data models, querying, formulas, groupings, frames, and object elasticity. Extensive experience in application development using Oracle Apex versions 4 and 5. Possesses a comprehensive understanding of the system lifecycle, from demand identification through support and maintenance. Proven track record as a systems analyst and ERP system implementer, with a strong focus on business rules modeling and expertise across Financial, Commercial, Inventory, Fiscal Accounting, and PCP modules. Experienced in business analysis, system integration, and knowledgeable in Business Process Management (BPM).
Developer Analyst
4/2/2015 - 7/2/2018
Developed expertise in the analysis, development, and implementation of systems for the healthcare sector utilizing Oracle Apex and iReports. Demonstrated proficiency in comprehensive system documentation to ensure clear project outlines and workflows. Managed projects effectively using PMBOK methodologies, focusing on structured planning and execution phases. Provided extensive help desk support to address and resolve user issues promptly, ensuring seamless system operation.Systems Analyst
4/2/2014 - Present
Developed applications using Oracle Forms/Reports, ensuring robust and efficient user interfaces. Created and optimized packages, procedures, functions, and views in PL/SQL, facilitating seamless backend operations. Proved expertise in developing applications in Oracle Apex versions 4 and 5, employing PL/SQL to ensure tight integration and high performance. Generated detailed reports using IReports JasperSoft, providing critical business insights. Engaged in gathering functional requirements directly with business units, ensuring solutions met end-user needs. Provided ERP Systems consulting, offering strategic advice and implementation support. Demonstrated strong skills in modeling and mapping BPM processes, enhancing organizational workflows.Analyst
4/2/2014 - Present
During the tenure from September 2011 to April 2014, developed extensive expertise in Oracle Forms/Reports and Oracle Apex (versions 4 and 5), including the creation of applications using PL/SQL. Proficient in designing and implementing packages, procedures, functions, and views in PL/SQL. Successfully developed IReports using JasperSoft reports. Played a critical role in gathering functional requirements in collaboration with the business area, offering ERP systems consulting and services. Demonstrated strong capabilities in modeling and mapping BPM processes, ensuring streamlined business operations and process improvements.Developer Analyst
1/2/2014 - Present
Developed software using Oracle Forms/Reports, PL/SQL, Oracle APEX, Java, and IReport, gaining proficiency in Oracle Database 10g. Acquired foundational knowledge and skills in PL/SQL basics, including cursors, composite variables, packages, stored procedures, functions, triggers, and exception handling. Worked extensively with Oracle Forms 12c, 11g, and 6i, managing modules, blocks, and relationships between blocks, and handling canvas items such as text, options, check-boxes, displays, LOVs, lists, windows, triggers, procedures, functions, and packages. Produced detailed reports using Oracle Reports 11g and 6i, encompassing various report types, data models, layout models, mailing systems, queries, formulas, groupings, frames, repeat frames, and object elasticity. Developed applications in Oracle APEX versions 4 and 5, showcasing a solid understanding of both technical and operational aspects.Systems Analyst
12/2/2010 - Present
Gained extensive expertise in analyzing, designing, and implementing automated systems to enhance business efficiency. Demonstrated proficiency with SQL Server, Oracle, and MySQL, ensuring robust database management and optimization. Advanced proficiency in Java, Python, and C# for backend development, with a strong understanding of various frameworks such as Spring, Django, and .NET. Leveraged tools like JIRA, Confluence, and Trello for effective project management and collaboration. Utilized UML diagrams, flowcharts, and DFDs to document and communicate system requirements. Developed strong problem-solving skills and the ability to translate complex technical concepts into user-friendly processes. Conducted thorough testing and debugging using automated tools like Selenium and JUnit to ensure system reliability and performance. Ensured data integrity and security compliance, adhering to GDPR and other regulatory standards. Fostered effective communication with cross-functional teams and stakeholders to align system solutions with business objectives.Functional ERP Analyst
1/2/2010 - 12/2/2012
Achieved extensive application development proficiency using Oracle Forms and Reports. Successfully developed packages, procedures, and functions views in PL/SQL. Gained experience in application development within Oracle Apex, specifically versions 4 and 5, utilizing PL/SQL for backend processes. Created detailed IReports using JasperSoft reports. Conducted functional requirements gathering in collaboration with the business area to ensure project alignment with organizational needs. Provided ERP systems consulting, offering insights and optimizations. Demonstrated expertise in BPM process modeling and mapping to streamline business workflows.Functional Analyst
6/2/2006 - 3/2/2007
Achieved proficiency in Protheus 10, with a focus on system configuration and process automation. Demonstrated expertise in SQL for data querying and manipulation, and applied knowledge in APD (Advanced Protheus Development) for custom modules development. Managed system integrations using REST and SOAP APIs, ensuring seamless interoperability with third-party systems. Developed and executed test plans for system enhancements, optimizing performance and functionality. Leveraged Agile methodologies to enhance project management and team collaboration. Conducted thorough requirements analysis and documentation, facilitating clear communication between technical and non-technical stakeholders. Utilized debugging tools and performance monitoring to maintain system stability and troubleshoot issues. Contributed to continuous improvement efforts through post-implementation reviews and user feedback sessions.IT Coordinator
1/2/1997 - 1/2/2006
Developed applications using Oracle Forms/Reports and Oracle Apex versions 4 and 5, employing advanced PL/SQL for creating packages, procedures, functions, and views. Designed and implemented IReports with JasperSoft. Facilitated the elicitation of functional requirements from business areas and provided ERP systems consulting. Demonstrated expertise in modeling and mapping BPM processes.
Information Technology Management at Methodist University of São Paulo
2002 - 2006Bachelor at Methodist University of São Paulo
2000 - 2004Business Intelligence at Impacta Technology College
2008 - 2010Information Technology at TI Educacional
2017 - 2017
Marcio is available for hire
Hire Marcio J.
All Howdy Candidates are vetted for skills and english proficiency.
