Oracle System Analyst / developer
Resume:
Muhammad Faisal Shaikh
********@*****.***
Summary:
Self-motivated and results-oriented senior Oracle Techno Functional Consultant with over 15 years of experience in Oracle Applications Financials R12, Oracle Fusion Cloud Financials, and Supply Chain Management applications.
Well experienced in two Full Cycle (End to End) ERP Implementations of Oracle Financials, Purchasing, Order to Cash, Accounts Payable, Accounts Receivables, and Inventory.
Very good experience in Oracle Fusion Functional Set up Manager.
Well experience in Data Conversion using FBDI – File based Data Imports, spreadsheet and ADFdi for data uploads and data migrations from EBS and customer applications to Fusion Cloud.
Well experienced in creating reports using BI Publisher, Smart View, FRS, and OTBI.
Experienced in BPM activities like Workflow Approval Rules and Approval Group Configurations as per business Specifications.
Very Good knowledge on Oracle Fusion Financials Security Rules, Cross Validation Rules, and Data Access Sets.
Worked on Oracle Revaluation, Translation, and Consolidation at month-end closing.
Well versed with procure to pay and order to cash cycles.
Expert in SQL, PL/SQL, Packages, Functions, Procedures, Triggers, Views and Database Triggers.
Experienced in System Administrator responsibility for defining users, menus, responsibilities, printer set-ups, Request Groups and maintaining ESS jobs/concurrent programs.
Certified and worked on Designing, Development, Implementation, testing life cycle, and supporting of Oracle Cloud Infrastructure.
Well versed with OCI Regions, Availability Domain, Fault Domain, Compute, Storage and Virtual cloud network
(VCN).
Certified and experienced in Oracle Integration Cloud (OIC), effectively used Adapters, Connections, Lookups, Libraries, Mappings and Fault Handlers to develop smooth and secure integrations.
Effectively worked on Adapters like REST, SOAP, FTP, ERP Cloud, Oracle EBS and Oracle ATP Database.
Experience in setting up OIC File Server, configuring Users, Groups, Folders structure and files server security.
Strengths include liaison between business users and technical team and implementing business process improvements.
Excellent analytical and problem-solving skills. Technical Skills:
Oracle Fusion Financials Cloud ERP Release R13 complete setups and functional knowledge for the options.
• General Ledger
• Accounts Payable
• Accounts Receivables
• Fixed Assets
• Cash Management
• Expenses
• Purchasing / Procurement
Interfaces: FBDI, ADFdi, API, REST API, SOAP
Integrations: Oracle Integration Cloud (OIC), Gen2/Gen3, FTP, REST, SOAP, ATP DBMS, Exception Handling
Databases: Oracle 9i, 10g, 12c, MS SQL Server, MySQL
Operating Systems: Oracle Linux, Unix, Windows Server, VMware ESXI Server Virtualization
Cloud Technologies: Microsoft Azure, AWS, Oracle OCI, Office 365 Administration
Programming Languages: SQL, PL/SQL, Python, Oracle Forms, Oracle Reports
Reporting: BI Publisher, HFM Financial Reporting, Smart View, Fusion OTBI, Power BI
Tools: PL/SQL developer, TOAD, SQL*LOADER, WebADI, Oracle import/export, Putty, WinSCP, MS Office Professional Experience:
Virginia Commonwealth University, VA April 2025 – to date Research Developer / System Analyst - Oracle
Responsibilities
Maintaining, designing, developing and testing web-based software products including multi-page applications (MPA) and browser-side single-page applications (SPA).
Report back to the team on website development progress and maintenance projects.
Maintain and update processes and procedures regarding web design, development, and maintenance to meet the demands while delivering results, from building websites to developing SEO/PPC/social media.
Database design and connection with the website using MySQL and PostgreSQL.
Creating tables, views, database triggers, functions and procedures to complement data flow between front end and back end.
Conducting research to adapt latest technologies and industry best practices. R&L Carriers, OH June 2024-March 2025
Oracle EBS/Fusion Cloud Techno Functional Consultant Responsibilities
Provide ongoing technical and functional support for Oracle Fusion Cloud Financials modules, including General Ledger (GL), Accounts Payable (AP), Accounts Receivable (AR), Fixed Assets (FA), Cash Management
(CM) and Purchasing / Procurement (PO).
Manage user roles, responsibilities, and access permissions using Security Manager in Fusion Cloud.
Develop Custom roles to cater customized business requirements and segregation of duties.
Troubleshoot and resolve user-reported issues by collaborating with both business users and Oracle support teams by raising Service Request (SR).
Plan, execute and manage Data Conversion tasks from Oracle EBS and custom applications to oracle Fusion Cloud using FBDI and ADFdi.
Configure and implement approval Rules and approval workflows using Oracle BPM to automate approval processes to improve process efficiency.
Manage approval hierarchies and business process configurations, ensuring compliance with organizational policies.
Developed many custom reports using BI Publisher, OTBI, FRS and Smart View to provide insights to management and stakeholders.
Supported month-end and year-end financial closing processes, including reconciliation and generating reports using Financial Statement Generator (FSG) and BI Publisher.
Monitored and addressed errors in payment processing, invoice matching, and cash management, ensuring accurate financial data processing.
Assisted in setting up Accounting Flexfields (GL), Subledger Accounting (SLA), and handling tax configurations within Oracle Fusion Cloud.
Developed APEX forms for some customer data capturing requirements.
Plan and developed data integrations using REST APIs and SOAP API as per business requirements.
Tested and validated system functionality after patches, including AP, GL, and FA modules.
Managed approval hierarchies and business process configurations, ensuring compliance with organizational policies.
Provided end-user training and support on cloud financial modules to improving user efficiency and reducing support tickets.
Involved in the continuous enhancements and fixing of production problems. Environment
Oracle ERP EBS 12.2.9, Oracle Fusion Cloud ERP, SQL * Plus, TOAD, SQL*Loader, SQL Developer, FBDI, OTBI Pakistan Cables Limited May 2013 – December 2022
Manager IT / Oracle ERP Applications
Responsibilities
Led implementation of Oracle EBS in liaison with A. F. Ferguson &Co.(PwC) implementation partner.
Conducted requirement gathering sessions with business stakeholders and developed AS-IS and TO-BE functional design documents.
Helped Organization to cut down monthly closing and financial reporting time, same is very critical being Public Limited Company.
Importing data in Oracle Apps modules via open interfaces and APIs.
Oracle Forms customization, report development as per Oracle EBS R12.x.x standards.
Setting up Description Flexfields, Key Flexfields, Valuesets and Lookups as per business requirements.
Defined and finalize Chat of Accounts structure and Item Master code structure in collaboration with business users.
Conducted AS-IS, TO-BE and CRP sessions for business power users. Translated business process into Oracle solutions ensuring in line with the business needs and specifications.
Participated in system upgrades and patch application for Oracle EBS R12, ensuring minimal downtime and seamless system transitions.
Worked on the prepayment Invoices and payment methods, payment process profiles.
Develop functional requirements for custom reports & programs and coordinate for the testing.
Expertise in Designing Enterprise Structure/Multi-Org Structure based on client business.
Hands on Experience working on an upgrade project from Oracle EBS to Oracle Fusion, acted as a Functional Team lead for Financials and Project Accounting.
Was Part of designing the integrations and worked on the General Ledger multi-organization design.
Load Bank Statement and Reconcile Manually and Automatically.
Creating Purchase orders in PO and working on 2-Way matching, 3- Way Matching and 4- Way Matching Invoices.
Was part of pre-sales meetings, RFP preparation, Project Charter preparation, Project Kick off meetings.
Configuring Fixed Assets module and Cash management module, Conversion of Assets and Asset Balances.
Creating Test Plans and Test Scripts.
Environment
Oracle EBS 12.2.x, SQL * Plus, TOAD, SQL*Loader, SQL Developer, Shell Scripts, UNIX, Oracle APEX. IFFCO Private Limited January 2011 - April 2013
Associate Manager Application Support – Oracle EBS Responsibilities
Played an integral role in the full-cycle implementation of Oracle EBS, transitioning from BaaN ERP to Oracle EBS by migrating financial, inventory, and procurement data.
Collaborated with stakeholders to ensure accurate data mapping, cleansing, and migration using tools like SQL*Loader, Oracle APIs, and data validation scripts to ensure a smooth transition of business-critical information.
Ensured business continuity by thoroughly testing data integrity post-migration, reconciling ledgers, subledgers, and reports between the two systems.
Conducted comprehensive analysis of both functional and technical requirements, translating business needs into technical specifications for Oracle EBS implementation.
Held workshops and requirements gathering sessions with key business stakeholders to fully understand their operational needs and to determine how Oracle EBS could meet those needs.
Developed functional design documents that detailed workflows, reporting requirements, and system configuration settings based on business objectives.
Acted as a liaison between users and technical teams, identifying necessary modifications to BaaN ERP and implementing changes such as process reengineering, system updates, and report enhancements.
Gathered user feedback to fine-tune system changes, ensuring that customizations aligned with business goals and improved system usability and performance.
Worked on system optimization, configuring settings, and making necessary adjustments to meet evolving business needs.
Created and maintained a suite of custom reports using BaaN ERP's native tools and Business Objects to meet business reporting needs across finance, inventory, and procurement.
Developed complex SQL queries to extract meaningful insights from data, helping management make informed decisions.
Built user-friendly reports that simplified financial reporting, inventory management, and operational metrics, reducing manual data manipulation efforts.
Played a critical role in the design and development of system modules by creating detailed test cases and test scripts that ensured the functionality met business requirements.
Worked closely with the development team to validate system integrations, ensuring that key processes (e.g., inventory management, order processing) were functioning correctly.
Conducted User Acceptance Testing (UAT) and participated in the creation of integration test plans to ensure seamless interaction between different system components.
Conducted an in-depth system study to analyze existing workflows, processes, and system architecture, identifying areas of improvement and potential integration points for Oracle EBS.
Authored comprehensive System Requirement Specifications (SRS) that documented both functional and technical aspects of the system, providing a blueprint for the project development and configuration teams.
Played a hands-on role in the implementation phase, configuring Oracle EBS modules and ensuring that all system components functioned as required.
Provided post-implementation support, troubleshooting issues, resolving data discrepancies, and guiding users through the transition to the new system.
Supported system users by offering training, documenting issues, and coordinating with technical teams to fix bugs and optimize performance.
Prepared detailed documentation, including technical specifications, use cases, and activity diagrams, ensuring that all system processes were well-documented for future maintenance and enhancements.
Developed workflow diagrams that visualized business processes and system interactions, helping to communicate complex system functions to both technical teams and business users.
Created and maintained release notes, summarizing changes, new features, and bug fixes for each version of the system, ensuring transparency with stakeholders. Environment
Oracle EBS, 12.2.x, BaaN ERP, SQL Server, Business Objects. MIMA Group Private Limited July 2008 - December 2010 Team Lead Software Development
Responsibilities
Led a team of software developers, system analysts and front UI/UX developers.
Translated business requirements into Detailed Design Documents (DDD), outlining system architecture, module configurations, and integrations, ensuring clarity for both development teams and stakeholders.
Developed comprehensive Unit Test Plans, detailing test scenarios, expected outcomes, and success criteria to validate the system’s functionality at the component level.
Managed the deployment of new features and system updates, ensuring that timelines were adhered to and that all stakeholders were informed of key milestones.
Coordinated with cross-functional teams, including developers, QA, and business analysts, to ensure a smooth transition from development to production environments.
Offered post-implementation support, working with users and technical teams to troubleshoot issues that arose after deployment.
Played a key role in implementing business process automation by configuring systems to automate repetitive tasks, reducing manual errors and improving process accuracy.
Streamlined workflows by implementing automated triggers and notifications within the system, improving productivity and enabling faster decision-making.
Managed the production deployment process, coordinating with teams such as DBAs, Unix administrators, and developers to ensure a smooth and well-organized deployment.
Raised Request for Changes (RFCs) and ensured all required approvals were in place before proceeding with deployments to minimize risks and prevent downtime.
Conducted comprehensive Unit Testing and Integration Testing, developing test cases that covered all possible scenarios to ensure that new developments and changes worked as expected.
Collaborated with business users to conduct User Acceptance Testing (UAT), ensuring that the system met user expectations and was ready for deployment.
Environment
SQL Server, SQL, PL/SQL, Crystal Reports, Project Planner, VSS, Toad for Oracle Software Channel Private Limited Jan 2004 – June 2008 System Analyst / Programmer
Responsibilities
Collaborated closely with clients to understand their business needs, conducting workshops and interviews to gather detailed functional and technical requirements.
Acted as the primary point of contact for offshore development teams, facilitating smooth collaboration by providing detailed technical specifications and addressing any queries.
Ensured alignment between onshore business stakeholders and offshore development teams, conducting regular meetings and status updates to monitor progress.
Managed the flow of information between teams, including code reviews, test cases, and feedback, ensuring that deliverables met the project’s objectives and deadlines.
Mapped and analyzed existing business processes, identifying inefficiencies and bottlenecks, and proposing automated solutions that streamlined workflows and reduced manual interventions.
Collaborated with stakeholders to prioritize system enhancements, ensuring alignment with business objectives and long-term strategy.
Developed detailed System Requirement Specifications (SRS), capturing both functional and non-functional requirements, use cases, and system behaviors.
Created process flow diagrams and data models to illustrate system operations, ensuring that the proposed solution aligned with business processes and technical infrastructure.
Ensured that the SRS documentation provided a clear guide for development teams, QA teams, and stakeholders, reducing scope creep and ensuring accurate delivery.
Led the design of system enhancements, ensuring solutions were scalable, maintainable, and adhered to industry best practices as well as regulatory and security standards.
Worked closely with clients to ensure that all enhancements met their specific business needs, recommending changes that would future-proof the system and support long-term growth.
Utilized knowledge of Oracle EBS and related technologies to design efficient, user-friendly solutions that minimized disruption to ongoing operations.
Oversaw the system configuration process, customizing modules and settings based on detailed design documents and client requirements.
Conducted root cause analysis to identify underlying problems with system performance or functionality, implementing permanent fixes to prevent recurring issues.
Documented all troubleshooting efforts and solutions, ensuring the knowledge base was updated for future reference.
Engaged in discussions with business users and BAs to thoroughly understand their needs, finalize project scope, and identify any gaps between current systems and desired outcomes.
Facilitated workshops and feedback sessions, ensuring that all business requirements were captured and documented for both functional and technical teams.
Conducted thorough analysis of existing systems, identifying inefficiencies and recommending process improvements that would increase overall system performance and operational efficiency.
Suggested optimizations in system architecture, database performance, and business workflows, leading to reduced manual intervention and faster processing times.
Regularly attended Design Review meetings, providing input on system architecture and ensuring that designs aligned with business goals and technical capabilities.
Participated in status meetings to provide updates on project progress, discuss challenges, and propose solutions to keep the project on track.
Successfully delivered projects within tight deadlines by managing resources effectively and prioritizing tasks to meet project milestones.
Environment
SQL Server, SQL, PL/SQL, Crystal Reports, Project Planner, VSS, Toad for Oracle Education:
Masters Computer Science – University of South Dakota, USA May – 2024
Bachelors Computer Science – University of Karachi, Pakistan July - 2001 Certifications:
Oracle Cloud Infrastructure 2024 Certified Foundations Associate
Oracle Fusion Cloud Applications ERP Foundations Certified Associate
SAP Certified ABAP Workbench Developer
Contact this candidate