Oracle Technical Manager/consultant Resume
Summary
Over 13 years of experience with Oracle Applications in the fields of Manufacturing, Utilities, Retail, Consumer Products, Health care (Pharmaceutical) and Information Technology.
Some of my recent successes are highlighted with the implementation of Oracle 11i for all North American operations, Service Oriented Architecture (SOA), Disaster Recovery and Project Management Office in a multi-billion dollar heavy building materials company.
My most recent leadership role was to integrate the IT and business systems of the NAM operations of the largest merger in the heavy building materials industry. This accomplishment reduced the main system complexities down from 25 ERP systems to 3 (Oracle 11i, SAP R/3 and JDE Enterprise1) for the back office functions and standard versions of the operational systems by major business line. My leadership was integral in reducing operational costs through these and other initiatives by more than 10 million dollars.
Leadership & Management
- More than 5 years in technical management, program/project management and leadership responsibilities.
- Managed 18+ direct reports (contract and full time) and third party outsourcing teams.
- Worked on Global implementations and managed teams internationally - USA, Canada, Germany, India and Malaysia
- Ability to lead a team to accomplish goals/assignments and create team atmosphere.
- Strong negotiation, conflict resolution and influencing skills.
- Managed Projects with proven PM Methodology’s (PMBOK, AIM, Agile and Six Sigma methodologies)
- Experienced in performing all or part of the Software Development Life Cycle (SDLC) ranging from analysis and design to construction, implementation and maintenance.
- Expert in analyzing business processes, process re-engineering, and recommending solutions and implementing necessary solutions to insure automated functionality.
- Manage vendor relationships with key information systems and applications suppliers and contractors.
- Ability to deliver high quality results with attention to details. Excellent Analytical skills and ability to work efficiently in a multi-tasked environment.
- Advise the V.P and higher management regarding application trends, opportunities, investments, and risks; assist in gathering requirements including ROI information to evaluate projects.
- Quick learner who loves challenges and is at his best when under pressure.
Oracle E-Business Suite & SOA
- Experienced Oracle professional. Worked as Technical Manager, Program/Project Manager, Project Lead, Technology Specialist, Technical Consultant, Techno-Functional Consultant, Senior Systems Analyst and Software Programmer/Analyst mainly related to Oracle E-Business Suite.
- Possesses both Technical and Functional knowledge of Oracle E-Business Suite.
- Managed/Lead Multiple Implementations, Upgrades and Support of Oracle Applications.
- Excellent understanding of Oracle architecture and modules.
- Worked as Oracle eBusiness suite technical Consultant on multiple projects.
- Experienced in Oracle Applications Development, Customization, Testing, Debugging and Support of Oracle Applications.
- Experienced with systems integration between Oracle ERP and third party or custom solutions on a variety of platforms
- Thorough understanding of Sarbanes Oxley (SOX) Controls, Standards & Policies to ensure oracle applications are compliant and remain in compliance.
- Experienced in SOA and Web Services including SOAP and related XML technologies. Implemented Oracle Portal and good exposure with Oracle Application Server administration.
- Oracle Applications/Oracle E-Business Suite R12/11i(11.x)/10.x
- Oracle Application Modules: Oracle General Ledger (GL), Oracle Payables (AP), Oracle Receivables (AR), Project Accounting (PA), Oracle Assets (FA), Oracle Purchasing (PO), Inventory (INV), Order Management (OM), Bill of Material (BOM), Work in Process (WIP), Oracle Payroll, Oracle HRMS, Oracle Identity Manager, Oracle Universal Content Management, Oracle iSupplier Portal.
- Oracle System Administration, Application Object Library (AOL), Oracle Workflow Administration, ADI and EDI/e-Commerce Gateway and Oracle 9iAS Portal
- Oracle Database 11g/10g/9i/8i/8.1.7/8.1.6/8.1.5/8.0.x/7.3.x
- Oracle SOA suite, Oracle Fusion middleware, Oracle BPEL, Oracle EBS, XML and Web Services.
- SAP, PeopleSoft Financials/HR, Power Plan, IRAS (Invoice Routing and Approvals), WMG (Work Management Gateway), IRS (Interruption Reporting System) and BANNER.
- Oracle Applications Framework, Oracle J Developer, Oracle Workflow, Oracle iDeveloper/Oracle Forms & Reports, XML Publisher, OBIEE+, Cognos, Webfocus and Business Objects.
- SQL*PLUS, PL/SQL, SQL * Loader, UNIX shell scripting, awk and sed Programming.
- Oracle Enterprise Manager, SQL Navigator, SQL * Trace (tkprof), Explain Plan, TOAD, Oracle Discoverer, Oracle Browser and Eureka Query Tool.
- Command Alkon, IAvenue, Banner CIS (Customer Information System - Billing for Utility companies).Power Plant, IRAS, OTE, WMG, IRS, Payformance, Pay base and Mercator.
- HTML, Business Objects, Java, C/C++, Pro*C, Basic, Pascal and Mathlab
- Exceed, Hummingbird Neighborhood, Citrix Metaframe, Autosys Scheduler, AppWorx Scheduler, Connect Direct, Connect Mailbox, Valicert STS, FX- Easy access and PGP
- PVCS (Version Control)
- Linux, HP-UNIX, AT&T UNIX, SCO-UNIX , Sun Solaris, Windows, MS-DOS
- Executive Education in Leadership and Management (Massachusetts Institute of Technology)
- Master of Business Administration (In Progress)
- Certified Business Intelligence Professional
- Certified/Experienced - Project Management Professional
- Certified/Experienced - Six Sigma Green Belt Professional
- Certified/Experienced – ITIL Professional
- Certified/Experienced - Oracle ERP Professional (Oracle - 11i, R12, Fusion and Portals)
- Certified/Experienced - Oracle R12 Business Accelerators
- Diploma in Advanced Computer Technology.
- Bachelor of Science/Technology (Engineering).
- Multiple presentations in Oracle & APICS Conferences
- 25+ Professional Recommendations available on Confidential
Professional Experience (In reverse chronological order)
Confidential,
Oracle Technical Manager/Consultant (Oracle EBS, SOA)
[Aug 2011 to Till Date]
- Oracle EBS – 11i & R12
- SOA & R12 Upgrade Planning
- i Supplier Implementation
Confidential, Confidential,is one of the largest suppliers of heavy building materials to the construction industry in North America. Our companies produce a broad range of building materials, including cement, aggregates (crushed rock, sand and gravel), ready mixed and precast concrete, asphalt, concrete pipes, pavers, tiles and clay bricks.
IT Manager/Project Manager (Oracle EBS, SOA, BI and Infrastructure)
[June 2008 to July 2011]
- Manage all aspects of the application development life cycle, including systems analysis, design, development, deployment, maintenance and enhancements.
- Managed various Projects related to Oracle E-Business Suite - Implementations, Conversions and Upgrade.
- Projects included transitioning business units with various legacy systems to centralized Oracle ERP system in USA and Canada.
- Handled large-scale projects and interacted effectively with business and stakeholders to translate business requirements into IT deliverables. Demonstrated Project Management Methodologies and projected strong interpersonal skills leading to effective team building and delivering projects on time and within budget.
- Lead the requirements gathering workshops to drive unique global footprint for each of the different business units: Gravity Pipe & Precast, Pavers, Pressure Pipe, Block, Brick & Tile and Structural PreCast.
- Production Support, Conversions, Upgrades, Implementation, System Administration, Change Control, Audits, BCP, Disaster Recovery related to Oracle eBusiness Suite.
- Demonstrated the ability to interact with all levels of management. Consult with business management to identify and prioritize opportunities (projects and enhancements) to enhance the use of applications in support of their business objectives.
- Organizes, prioritizes, coordinates, and administers the activities and workload of the application support/development team.
- Managed the following Programs/Projects –
- Brick and Tile - Oracle EBS Implementation/ Ross to Oracle Conversion
- Structural Precast - Oracle EBS Implementation/Conversion – This involves decommission the 3 main systems for Structural Precast: Timberline, Advantage (formerly ProMation) and a custom built AS/400 application and leverage the existing Oracle architecture. Implemented Oracle Projects Costing, Billing and Project Manufacturing to streamline Project Accounting
- Building Products - Oracle EBS Implementation/ Epicor to Oracle conversion
- Bank Interface System and ERP Bank Conversions - Implement the bank system changes that result from the HC selection of a single banking entity for the worldwide group. Development of a standard Bank Interface System that can be configured to operate with any Banks and software applications. Implementation for Accounting: SAP, JDE and Oracle EBS (US operations only). Implementation of an enhanced and proven Data Recovery/Business Continuity Plan for the new Bank Interface System.
- Oracle EBS Database Upgrade from 9i to 10g
- BI Reporting – Implement Oracle EBS Noatic Views and Business Objects reporting.
- Command Series Implementation in Malaysia.
- Oracle EBS Integration with Universal Content Management (Document Management).
- PSeries Replacement and Disaster Recovery Project/Program.
- SAP BI – Labor Reporting Project
- SAP BI – Security Model Project
- JWS Apex – San Diego JWS Implementation
- Oracle EBS 11i - Upgrade to R12 (In progress)
- Windows7, Client Refresh projects (In Progress)
Environment: Oracle EBS (11.5.10.2) - GL, AP, AR, FA, PA, OM, INV, PO, BOM & WIP.
SAP, JD Edwards, GAAP, ROSS, Command Series, JWS, IAvenue , Oracle 9i/10g, Oracle Workflow, Oracle Developer Suite, OBIEE+, Cognos, Business Objects, Kintana, ADI, Oracle XML Publisher, SSIS (ETL Tool), SOA, Oracle Fusion middleware, Oracle BPEL, ESB, XML, Web Services.
Oracle E-Business Technical Lead/SOA Consultant
[Feb 2008 to June 2008]
- Lead and Participated in designing and developing application interface programs, conversions and various customizations. Served as a technical lead for the forms personalization, workflow customization and building extensions.
- Involved in trouble shooting production issues (Day-to-Day production support), performance tuning and provided techno functional support for existing Oracle application modules in a multi-org and multi-currency environment.
- Responsible for defining and enforcing standards and best practices to be adopted by different development efforts and teams. Maintained overall responsibility for quality of solutions/code in Oracle Applications production deployments.
- Architected, designed and developed successful Enterprise Application Integration (EAI) solutions using Service Oriented Architecture (SOA),
Environment: Oracle EBS (11.5.10.2) - GL, AP, AR, FA, PA, OM, INV, PO, BOM & WIP.
SAP, JD Edwards, GAAP, ROSS, Command Alkon, IAvenue , Oracle 9i/10g, Oracle Workflow, Oracle Developer Suite, OBIEE+, Cognos, Business Objects, Kintana, ADI, Oracle XML Publisher, SSIS (ETL Tool), SOA, Oracle Fusion middleware, Oracle BPEL, ESB, XML, Web Services.
Confidential,
Development Lead - Oracle EBS R12
[Jan 2008 to Feb 2008]
- Developed the mapping from Legacy System to Oracle Apps for loading the Supplier Open Interface Import for Wolverine.
- Designed a PL/SQL Interface, which updates Purchase Order information on each Sales Order Line after being Drop Shipped successfully.
- Resolved Web ADI and Check Format XML Publisher issues.
- Involved setting up of Workflow Notification Mailer for inbound and outbound processing, Workflow administration.
- Coordination with the onsite Team in Issue Resolution and Expediting the Deliveries.
- Techno Functional support with Accounting Setup Manager, Sub ledger Accounting (SLA), Financial Reporting for Multiple Ledgers (FSG) and Integrated Web-based Spreadsheet Interface (web ADI).
Environment: Linux, Oracle Applications R12 - GL, AP, AR and PO, 10g, XML Publisher, Web ADI and Oracle Developer Suite.
Confidential,
Oracle EBS Consultant / Project Lead
[August 2005 to Jan 2008]
- Lead multiple projects performing various technical and functional tasks related to the Oracle e-Business suite.
- Was the first point of contact for Production issues, 11i projects, development, customization, testing, debugging and support of Oracle applications.
- Developed/Customized Reports, Forms, Interfaces, Conversions and Enhancements.
- Worked with Open Interfaces and was involved with Application Programming Interface’s (API) related to Oracle Receivables and HRMS.
- Involved in development of shell scripts & PL/SQL stored procedures, functions, packages and Oracle Reports with different output formats like PDF.
- Addressed operational problems, concerns, and questions posed by users.
- Involved in Day-to-Day production support and month end Book Close assistance to the users.
- Participated in year end 1099 reporting process, auditing projects and developed a thorough understanding of Sarbanes Oxley (SOX) controls, standards & policies to ensure oracle applications are compliant and remain in compliance.
- Worked as an AppWorx Scheduler Support Lead, Oracle Applications Sysadmin with the ongoing production support. Monitored Concurrent Managers/Programs and performed various System Administration and database activities.
- Participated in systems integration between Oracle APPS, PeopleSoft Application and third party Applications. Resolved various issues related to Oracle APPS and data flow between other legacy systems.
- Supported the organization’s configuration management and systems engineering procedures.
Team Lead Activities:
- Responsible for utilizing a formalized project management lifecycle - Interacting with users, requirement gathering, identifying functional and technical gaps, application design, functional/technical specifications, configuration, module setup, programming, scheduling, documentations, test script generation, training end users and production move.
- Lead a team of six programmers and two Business Analysts.
- Assisted the project manager on mission-critical software development and production support projects.
- Lead all aspects of the design, development and deployment of the Oracle solution and related components (interfaces, conversions, etc.).
- Was responsible for setting the timelines, assigning project resources, and determining and managing the scope of various projects.
- Projected thought leadership, technical/functional expertise and was actively involved in Planning, priority setting, instructing, monitoring, promoting team development and managing multiple efforts concurrently.
Environment: Oracle 11i (11.5.8/10), Oracle General Ledger, Oracle Payables, Oracle Receivables, Project Accounting , Oracle Payroll, Oracle HRMS, System Administration, Application Object Library (AOL),Oracle Time Entry, PeopleSoft Financials/HR , Power Plan, IRAS (Invoice Routing and Approvals), WMG(Work Management Gateway), IRS (Interruption Reporting System), BANNER, ADI(Application Desktop Integrator), AppWorx Scheduler, Mercator, Forms/Reports 6i, Oracle 6i/9i, SQL, PL/SQL, SQL * Loader, TOAD, Query Tool, UNIX shell scripting, awk and sed Programming, Windows XP and HP-UX
Confidential,
Oracle Technical Consultant
[Feb 2005 to Aug 2005]
- Analyzed, Prepared Functional and Technical design documents and Data mapping documents for the interfaces.
- Modified the GL Extract program to redirect output to a specific directory.
- Developed a new host program that picks up the output file and renames it with timestamp on it and moves to a custom directory. Developed a Request set for these two programs.
- Developed new program in pl/sql and modified old PRO*C programs for Payables Open Interface to import invoices from two different sources.
- Extensively worked on several issues including setups, data integrity issues, forms errors and report errors in GL & AP modules.
- Worked on Forms Personalization using Oracle E-Business Suite 11i.
- Demonstrated the usage and benefits of Discoverer 4i with Oracle Applications to the client. Involved in Installing, Configuration and Setting up of Discoverer 4i with Oracle Applications 11i. As Discoverer Administrator created EUL, Business Areas, Business Folders, Setup joins between folders, Registered PL/SQL functions, LOV’s etc. Maintained user security and privileges.
- User training on Oracle E-Business Suite 11i and did involve in Forms Personalization, Invoking the Personalization screens with Oracle E-Business Suite.
- Set up Application Desktop Integrator to submit, view reports, FSG reports, journals etc. Resolved several installation and runtime issues with ADI.
- Helped the client to uncover knowledge gaps in the current client resources and provide training recommendations to support the resolution of those gaps
Environment: Oracle 11i (11.5.8), System Administration, General Ledger, Accounts Payable, Forms/Reports 6i, Oracle 8i/9i, Oracle Developer 2000, SQL, PL/SQL, SQL * Loader, Unix shell scripting, TOAD Windows XP and HP-UX
Confidential,
Senior Systems Analyst/Oracle Applications Lead
[Jan 2000 to Feb 2005]
- Actively Involved in Multiple Projects like Multi org, 11i upgrade, patch upgrades, modules implementation and participated in customizing, testing, debugging, maintenance and support of oracle applications.
- Involved in the Implementation of Order Management, Inventory and Purchasing modules. Posses both technical and functional knowledge related to data flows and back group processes.
- Supported the Workflow in Order Management and helped users in resolving various related issues.
- Involved in most of the stages of project development including requirement analysis, design, code development, enhancement, implementation and documentation.
- Developed/Modified interfaces and data conversion programs for various applications.
- Wrote database triggers, Stored Procedure/function and packages using PL/SQL.
- Involved in Development/Customization of forms, reports and UNIX shell scripts.
- Developed Workflow in Purchasing for approval hierarchy level.
- Coded the EFT, Positive Pay programs and was the owner of the transmission process to the bank.
- Maintained and customized the Paybase, Payformance check printing software.
- Involved in using ADI for front end to perform General Ledger full cycle accounting.
- Performed Data Validation code to clean data before transferring into Interface tables.
- Worked with Application Programming Interface’s related to Oracle Assets.
- Used AMG (Activity Management Gateway) in Project Accounting and developed a script to load Projects data into Oracle Projects
- Defined value sets, menus, concurrent programs, report sets, registering custom build forms, reports and PL/SQL Procedures, Triggers and Packages and creating executables using Application Object Library (AOL).
- Provided user assistance in Defining new flexfeild segment values, Assigning accounting flexfield child values to parent values, Assigning flexfield security rules and defining cross-validation rules. Added flexfields to Oracle applications so that customer sites can configure it to display one or more fields for use by the organization.
- Responsible for the year end 1099 reporting process.
- Pre Production testing, and related documentation and deliverables.
- Day-to-Day production support and month end Book Close assistance to the users.
Team Lead Activities:
- Primary contact to application owners and support personnel, project teams, and others issues related to Oracle databases and the Oracle Applications technology stack
- Provided technical support for project development andparticipated in the technical and business consultation as well as research and analysis of business requirements for ERP Applications.
- Provided coaching and mentoring to team members on project methodology and execution.
- Other major role’s include interfacing with users, identifying functional and technical gaps, estimating work, architecting system interactions, designing custom solutions, programming, leading developers, scheduling, producing documentation, and providing production support.
- Lead the Implementation of Oracle 9ias Portal.
Environment: Oracle Applications 11.i/11.x/10.x, Oracle General Ledger, Oracle Payables, Project Accounting, Oracle Assets, Oracle Purchasing, Oracle Inventory, Order Management, System Administration, Application Object Library, Oracle Workflow 2.5/2.6.2, ADI, Concurrent Manager, Flex fields, Oracle 9iAS Portal Release 2, Oracle Database 9i/8i/8.1.7/8.1.6, Oracle Developer 2000, SQL, PL/SQL, SQL * Loader, Unix shell scripting, OEM, SQL Navigator, Toad, HTML, Java, Exceed, Hummingbird Neighborhood, Citrix Metframe, Autosys Scheduler, Connect Direct, Connect Mailbox, Paybase, Payformance, Valicert STS, FX- Easy access and PGP.
Confidential,India/USA
[Jan 1996 to Jan 2000]
Client - Confidential,
- The Project involved Upgrading, Testing and Maintenance of Oracle Financials Modules
- (GL & FA) from 10.6 to 10.7.
- Handled Report layout issues during the upgrade and testing stages.
- Involved in Customization of Oracle Financials for the client.
- GL Support and Development.
- Created the GL journal interface program, which feeds the GL interface. The program uses the parameters Set of Books and Period Name.
- Y2K Complaint testing of the financial modules.
- Modification and testing of various system functions and reports within the GL, AP, AR and FA modules.
- Designed and developed GUI front-end using Oracle Forms for user interaction with the database.
- Created SQL, PL/SQL for data retrieval and validation.
- Participated in Budget Load Process and year end 1099 reporting process.
- Involved in research and patch application recommended by Oracle Corp.
- Created test scenarios for the final testing of the application.
- Created Hyper ion Balance Extract report with PTD Balances.
- Modified FSS Process to run for multiple files.
- Created AR customer information and AP Payments information reports.
- Modified the script for exchange rate program to move current USD to CAD rates to the MVS system
- Documented system flow and functions.
Environment: Oracle Financials [GL, AP, AR, FA], Oracle RDBMS- 7.3, SQL, PL/SQL, Developer 2000, Perl Scripts, PVCS, Windows 98 and HP-UX
Client - Confidential,
- Upgrade of Oracle Financials from 10.5 to 10.7.
- Involved in all pre-and post-upgrade steps during the Upgrade Process.
- Identified and created legacy interfaces and customizations.
- Created SQL, PL/SQL & Shell Scripts for data retrieval and validation during the upgrade process.
- Corrected and compiled invalids which occurred during the upgrade process.
- Developed a separate scheme for the client to facilitate the architectural difference.
- Developed PL/SQL programs to validate and load data into Oracle Payables and General Ledger modules.
- Analyzed and resolved data corruption issues by creating necessary SQL scripts and shell scripts.
- Debugged various problems existing in the system.
- Created script to load GL balances.
- Coded the Payables Interface to bring the Open Payables items from the legacy system
Environment: Oracle Financials [AOL, GL, AP], SQL, PL/SQL, UNIX Shell Scripts, Windows 95 and HP-UX.