Oracle Resume Profile
Qualifications Profile
- Solutions-oriented Oracle Applications with notable success working in qualified, productive teams throughout implementation of a broad range of fully integrated Oracle-based solutions, while participating in development, analysis, implementation, strategy, and planning of robust systems supporting core business needs.
- Success in the analysis and design of innovative Oracle-based solutions directly leading to increased revenues, significantly reduced expenses, improved systems capabilities, and cross-functional business growth.
- Diligent and precise at authoring procedures and specifications, as well as performing tuning and training and supervising teams in all development, administration, and support arenas.
- Influential communications and relationship building abilities successfully prepare and facilitate communications between business and technical teams, cohesively articulating IT solutions to clients and staff at all levels of technical proficiency.
- Exceptional leadership and supervisory abilities, with experience assembling, motivating, and supervising productive, cohesive teams to consistently exceed business goals.
- An accomplished career of increasing industry responsibilities providing full-lifecycle project and program management on large-scale initiatives, specializing in fully integrated Oracle Applications solutions.
- Recognition by clients and employers as a top rated professional attaining the Bravo Award for service excellence from IBM in 2007 and a performance rating of 1 for top performer in both the years 2009 and 2010.
Core Competencies:
|
|
|
|
|
|
Functional Background
| Modules: |
|
Technical Background
| Platforms: | UNIX, Windows NT/2000/XP,7 and 8 |
| Tools: | Oracle JDeveloper, Oracle SOA 11g, XML, XSLT 1.x and 2.x, PL/SQL, SQL, Oracle 7.x 11g , Oracle Applications 11i and 12, Mercury IT Governance, Oracle Portal, Oracle workflow, Oracle XML Publisher, Java including JSP and JDBC , Oracle OA Framework, Oracle MWA Framework, HTML, C, Pascal, Ada |
Professional Experience
Confidential
Owner and EBS / SOA Consultant
Worked on complex E-business implementations and integration projects using Oracle E-business R12, Production scheduling, and Oracle Transportation Management
Key Achievements:
- Setup and configure Oracle Order Management and Purchasing modules to work with OTM integrations. E.g. Shipping parameters, and system profiles.
- Setup and configure OTM to integrate with EBS and production scheduling modules. E.g. external systems, agents and web services.
- Create ne SOA 11g BPEL processes and customized existing seeded processes to integrate Oracle OTM with E-business R12, other legacy systems and production scheduling. This included requirements gathering, setup, and design and development tasks.
- Created several complex transformation objects using XSLT 2.0 and XML to transform the data coming from production scheduling into the XML schema required by OTM GLOG schema .
- Created several database adapters to call various custom PL/SQL programs from SOA 11g BPEL processes.
- Created several file adapters to poll for system files, convert it to XML and pass it from one application to the other inside SOA 11g BPEL processes.
- Work on MD70 and MD 50 documentation using AIM methodology.
Confidential
Managing Consultant
Provide technical and functional expertise to complex Oracle Applications R12 and R11i implementation projects Financials/Supply Chain/AR/AP/GL/OM/WMS/OTM/MSCA/Purchasing/iSupplier , while applying Oracle's methodology in documentation, design and development.
Key Achievements:
- Performed systems analysis, and gathered requirements from functional users and documented using BR 100 documents, MD 50 documents and MD 70 documents as per AIM methodology.
- Setup and configure Oracle Warehouse management Systems WMS to facilitate inventory ASN receipts, warehouse task automation and order fulfillment processes. E.g. Setup putaway rules, strategies, shipping parameters and inventory locators. Documented WMS setup using BR 100 documents as per AIM methodology.
- Setup personalization in Oracle E-business to add ne DFFs to existing mobile supply chain planning screens.
- Developed ne mobile screens to extend Oracle Mobile Supply Chain MSCA applications using MWA Framework and Java beans technology for a major IBM manufacturing client.
- Customized existing Oracle MSCA Java screens to automate various LPN consolidation, splitting and optimization functionality. This development used Java beans and Oracle seeded APIs. These screens were accessible from RFID mobile devices used to scan LPNs at the warehouse.
- Setup and configure Oracle Accounts Receivable to work with Oracle GL and OM. E.g. Setup transaction types, receipt sources and auto accounting rules, and create BR 100 documents using AIM methodologies.
- Led a team of functional and technical resources to migrate and convert all AR invoices, receipts and applications from Oracle R10.7 to Oracle R11i. This involved configuration, design, and testing of key deliverables using CMMI methodology.
- Managed and led offshore development teams towards increased collaboration and productivity.
- Worked on a first phase of a successful client engagement to completely redesign their pricing systems in Oracle Order Management using Oracle advanced pricing module, Oracle Accounts Receivable and Oracle Cash Management. This included setting up complex business rules and various pricing models. Business requirements were documented using CMMI methodology.
- Supported sales efforts and demos for R12 of Oracle Applications including using SOA invocation framework, which is part of the integrated SOA gateway to communicate with third party web services.
- Maintained and enhanced Oracle EBS seeded Java concurrent programs that integrate with Oracle SOA BPEL processes using SOAP calls. e.g. The Outbound integration program with OTM .
- Worked on customizing the out of the box SOA BPEL processes that integrates shipping execution and OTM using SOA BPEL 10g. This included customizing the BPEL database adapters, the PL/SQL programs called by BPEL and the XSLT based XML transformation programs that come with the BPEL processes.
- Customized several E-business workflo objects. E.g. customized the out of the box auto creation purchase order workflo to only auto create POs when the order type is a specific one.
- Provided on-hand development to a number of projects on tools ranging from PL/SQL, Oracle Forms 6i, Oracle Reports 6i, Oracle Discoverer Desktop and Administrator, and Oracle workflow.
- Provided on-hand development to a number of projects on tools ranging from Java Struts, OA-Framework using JDeveloper, Oracle SOA 11g and 10g, Oracle Forms 6i, Oracle Reports 6i, Oracle Discoverer Desktop and Administrator, and Oracle workflow.
- Provided technical estimates of work required for various functionalities to the project management Office based on Oracle AIM templates and estimating standards.
- Worked on design and code reviews to ensure the quality of the deliverables for a number of client projects.
Confidential
Systems Analyst
Developed programs that are compatible with the client's multi organizational, and multi currency applications environment, while applying Oracle's methodology in documentation, design and development.
Key Achievements:
- Worked on an inventory quantities report, aged inventory report and inventory lot traceability report out of Oracle Inventory.
- Implemented a customized a version of the Oracle margin analysis program to integrate with the client's unique business setup. The program pulls cost of goods and revenue information from Oracle inventory and Oracle GL for margin calculation and assessment.
- Successfully customized Oracle bills of material to provide business analysts with a tool to assess ho well their material forecasting matches with real production composition.
- Created a budget control report to align procurement needs with the budget and help the organization avoid costly budget overruns in a timely manner.
- Authored functional design of ne interface that will compute the cost of sales for each product by ra material category, and developed the ne interface.
Confidential
Project Manager
Performed full lifecycle project management throughout development and implementation of large-scale banking and financial initiatives for corporations throughout the region. Coordinated and oversa efforts of cross-functional teams, including business analysts, solution specialists, designers, and developers to ensure fulfillment of unique customer needs. Participated in status meetings, articulating risks, project scope, budgets, assumptions, and resource needs based on needs analysis and requirements gathering sessions.
Key Achievements:
- Spearheaded successful implementation of Core Banking System for a major commercial bank, recognized as firm's most complex system to-date and including Phoenix Core Banking System, Mosaic, Trade Wind, and Sybase 12.
- Supervised multidisciplinary teams in design and implementation of Consumer Finance Solution, including Oracle Applications implementation GL/AR/AP/INV supporting Oracle database, for International Commercial House.
- Led successful Oracle-based implementation for a financial company.
- Established firm's first project management methodology, based on ITS solution, as well as participating in technical design of ERP solutions, and development of conversion scripts.
Confidential
Principal Consultant
Recruited to provide consultative services, applying expertise in Oracle design, development, and administration while working with customers on ERP implementations, customized Oracle solutions, and Oracle Forms/Reports development. Completed large-scale projects for clients across broad range of industries, including insurance, manufacturing, and financial services, performing all development phases including needs analysis, project scope definition, development and customization, and implementation. Applied process model, entity relationship model, and functional hierarchy model to ensure fulfillment of client business needs, while leading technical teams in adherence with best practices and standards.
Key Achievements:
- Implemented customized version of Oracle iStore and Oracle Financials supporting large Business-to-Business eCommerce initiative for the Bank of Montreal.
- Successfully customized Oracle Human Resources and Payroll for high-profile ERP application initiatives, enabling 100 automation of actions.
- Designed custom interfaces, reporting schemas, and modules for Home Hardware Limited.
- Served instrumental role in analysis and design of stock options system for Research in Motion, enabling monitoring and management of options grants, as well as monitoring of transactions.
- Recognized for outstanding performance and commitment to customer satisfaction with Consultant of the Quarter award regularly requested to fulfill escalated technical issues.
- Additional Notable Clients: Ontario Municipal Employees Retirement Systems, University of Waterloo, Home Hardware Limited, Guarantee Company of North America, AIM Mutual Funds.
Confidential
Programmer/Analyst
Gained expertise in Oracle systems design, development, and administration while participating in development activities for financial services provider. Served key role in design of fully integrated Bank Automation System, including functionality for bank transfers, letters of credit, and loans discounted bills. Created numerous forms and reports to ensure full integration, while programming PL/SQL code packages and functions. Successfully reverse engineered solution into Oracle Designer repository.
