SUMMARY

• Over 10 years of experience working wif Oracle. Experienced wif an Oracle E - Business Suite Release 12 implementation.
• Oracle Financials Functional Consultant wif teh design/architectural experience of teh R12 upgrade. Experiences wif Supply Chain Management, ASCP, Inventory, Purchasing, BOM, WIP, WMS, SCM, WMS, Manufacturing, Sales, Financial Modules in R12 and Projects Accounting.
• Knowledge of process manufacturing process, standard costing, reduce cost, streamline operations.
• Strong experiences in P2P cycle, OTC cycle.
• Extensive Oracle technical experiences wif PL/SQL, Oracle database (8i, 9i, 10g, & 11g), TOAD for Oracle, Oracle Reports and Forms (6i, 10g), Triggers, Stored Procedures, Oracle Enterprise Manager, Oracle Discoverer, RMAN Recovery Manager, JDeveloper and SQL performance tuning.
• Responsible for building, supporting and maintaining interfaces to Oracle E-Business Suite.
• Experience wif FDA CFR Part 11 validation process, including audits, system validations, and documentation.

TECHNICAL SKILLS

Oracle: EBS r12 Implementation, Oracle PL/SQL, SQL, Order to Cash, Procure to Pay, OM, Purchasing, SCM, WIP, Inventory, BOM

Projects Accounting: AR, AP, GL, Workflow, Oracle Reports and Forms (6i, 10g, 11g), CRM,WMS, Shipping, iProcurement, iExpenses, iSuppliers

Oracle Database: Crystal SLA, OBIEE, BI Publisher, PHP, JSP, EJB, SQL,Loader, TOAD for Oracle, SQL Developer, ETL

Data Warehousing: Oracle Enterprise Manager, RMAN Recovery Manager, performance tuning, Windows 2000/NT, UNIX, LINUX, HP9000 and Shell Programming.

PROFESSIONAL EXPERIENCE

Confidential, CA

Sr. Oracle Functional Developer

Responsibilities:

• iProcurement implementation and provide training.
• Punchout implementation for Suppliers.
• Production Support for Day-to-Day Operations/Maintenance/Data Cleanup/Troubleshooting
• Provide functional support and troubleshooting for teh Oracle R12 Advanced Procurement modules (Purchasing, iProcurement, and iSupplier);
• Provide functional assistance and troubleshooting wif Oracle Workflows for teh Advanced Procurement modules Purchasing, iProcurement, and iSupplier.
• Work wif Business System's staff and Technology in evaluating user needs and researching, analyzing and recommending process flows to improve system operations;

Confidential, Alpharetta, GA

Principal Oracle Functional Consultant

Responsibilities:

• Provide E-Business Suite functional leadership across all engagement activities and delivery phases,including production support upgrades, implementations, assessments, training workshops, etc.
• Exhibit a strong understanding and thought leadership across all EBS modules,(Financial, Order Management, Supply Chain, Inventory, and Shipping Execution), Agile and Discoverer applications.
• Participate in deal pursuit by providing subject matter expertise to solution design across all EBS modules.
• Creates Crystal Reports for multi-dimensional data analysis.
• Recent project for Demantra Demand Management to help MARTEK Power to maximize profitability, toachieve a demand-driven organization wif higher service levels and sales, more satisfied customers, and lower inventory and distribution costs.
• Using automated forecast analytics, Real-time forecast capabilities allow planner to get instant answer,
• Multi-dimensional data modeling, Chaining, attribute-based forecasting, and shape modeling—predicts new product demand and product phase-out while reducing teh overall planning effort. Provided training in,Material Management, Demand, Scheduling, MRP, and Forecasting Consumption.

Confidential, CA

Oracle Techno-Functional Analyst

Responsibilities:

• Oracle EBS r12.1.3 implementation, upgrade from Oracle EBS 11.5.10. Financial modules wif General Ledger, Accounts Payables, Fixed Assets, Purchasing, Supply Chain Management, ACSP,iProcuremnt, Inventory, BOM, SCM, HR, Projects Accounting, Order to Cash, Procure to Pay, WIP, MRP, Work Flow, iExpense Report, Hyperion, and EDI.
• Crystal Reports development.
• Support month-end closing, troubleshooting pending material transactions, uncosted issues,pending shipping transactions, as well as pending unprocessed material transactions.
• Lot Control implementation, lot control setup, system profiles, lot control item attributes, define Picking Rule for lot control, warehouse configuration, Rules, and lot control
• Support Order Management, Standard Orders, EDI Orders, Internal Orders, Drop Ship Orders,Order to Cash cycle, Process to Pay cycle, Price List, Pick Release, Ship Confirm, troubleshooting pick partialissues, release to teh warehouse issues, Back Order, cannot pick release issues, cannot ship confirm issuesOracle Warehouse Management, LPN, Delivery, Release Status, AutoInvoice, interface to A/R.
• Troubleshooting work flow issues, work flow monitor, PO Approval, AP Invoice workflow Approval, Expense Report, and Approval Management.
• Setup WIP parameters, WIP accounting classes for new Organization.
• Created Crystal Reports for multi-dimensional data analysis.
• Using Oracle Diagnostic Tool to do data collection on applications to do data analysis for problem resolutions.
• Discoverer Reports management.
• Responsible for building, supporting and maintaining interfaces to Oracle E-Business Suite.
• Evaluates business requirements and prepares detailed functional specifications that follow project guidelines required to implement package and custom developed solutions.
• Formulates, defines and documents teh functional system specifications.
• Devises or modifies procedures that solve complex business problems wif due consideration for hardware/software capacity and limitations, operating times and teh desired results
• Analyzes and revises existing functional documentation.

Confidential, CA

Oracle Functional Consultant

Responsibilities:

• Oracle EBS r12 implementation, upgrade from Oracle EBS 11.5.10. Financial modules wif General Ledger, Accounts Payables, Fixed Assets, Purchasing, Supply Chain Management, ACSP,iProcuremnt, Inventory, BOM, WMS, Sub Ledger Accounting, Multi-Org Access Control, Averaging Costing, and Order Management.
• Responsible for all functional tasks, including end-user support, setup wif Inventory, OM, Purchasing, and Financial Modules in r12. Extensive Business Intelligence OBIEE experience and BI Publisher experience.
• Support WMS, optimize warehouse resources, advanced wave and task planning.
• Oracle Hyperion, Performance Management Administration, Global Setups, Database, Data Loader, Migration, and Security.
• Provided technical support for various Oracle applications, developed business intelligence solutions using Oracle Discoverer 10g and created new customer reports to meet requirements.
• Responsible for building, supporting and maintaining interfaces to Oracle E-Business Suite.
• SQL performance tuning, code database objects in production environments.

Confidential, CA

MIS Manager

Responsibilities:

• Environment: Oracle Applications 11i.
• Managed company ERP system, CRM system, project management, Oracle database management (9g, 10g) and provided production supports. Manufacturing modules including MRP/MPS, BOM, Inventory, WMS, Supply Chain, AP, AR, OM, Projects Costing, and Projects Billing.
• Support broad based for Warehouses Processes, support for Advanced Warehousing Processes.
• SQL performance tuning, Oracle Enterprise Manager, RMAN Recovery Manager.
• Application development utilizing Oracle PL/SQL, PHP, JSP, PHP, and JavaScript.
• Used latest Oracle tools, Reports and Forms (6i, 10g), Internet Development Suite, ETL tools, PL/SQL and SQL*Loader. Implement Business Intelligence Solutions, dimensions, KPIs, reports, and dashboards.
• Hand-on experience wif BI Publiser.
• Created new reports using Crystal Reports V9, created customer formula, sub-reports, training users, graphically design data connections and report layouts. Created professional report layout for data analysis in teh areas of Inventory Control, Sales, Marketing, and Production Scheduling.
• Oracle Pricing, responsible for maintaining price list and teh rules for applying prices, model teh complex data relationships that determine teh correct price.

Confidential, CA

Sr. Oracle Developer/Systems Analyst

Responsibilities:

• Oracle database management (9i, 10g), SAP applications management, upgraded HP9000 Server memory and SQL performance tune up.
• Used Oracle tools, TOAD for Oracle, PL/SQL, SQL*Loader, ETL, data warehousing, Oracle Discoverer.
• Designed dimensional data modeling, use ETL tools for Extracting, Transforming, and Loading, Erwin, experience wif JSP, XML, JDBC, J2EE, and HTML.
• Designed and developed technical solutions to business requirements and develops components including extensions, views, customizations, modifications, reports, workflow around Oracle Applications.
• Experience wif FDA CFR Part11 validation process, including audits, system validations, and documentation.

Confidential, CA

Business Analyst

Responsibilities:

• Conduct user interviews, gather user requirements, implement technical solutions, and develop components.
• Provides support to business associates on systems use as need and make recommendations.
• Experience wif FDA CFR Part 11, Part 58 validation process, including audits, system validations, and documentation.
• Configures/Develops systems to support initial implementations and subsequent process optimization efforts.
• Comprehensive understanding of business core processes in teh areas of finance, supply chain, inventory,MRP/MPS, BOM.

Confidential, CA

System Consultant

Responsibilities:

• Responsible for Oracle database management (8i), UNIX systems administration, systems conversion, systems interfacing, Process Manufacturing, EDI implementation.
• ERP implementation, responsible for all functional tasks, and end-user supports, training.
• Performed systems analysis, gap analysis. Served as a project leader, worked wif top management and users to monitor project progress and project status.
• Responsible for coding, programming, debugging, testing, and troubleshooting.
• Developed appropriate documentation for architectural, design, technical, implementation and test activities.
• Maintained Oracle Management wif Oracle Pricing to price goods and services wif precision to meet corporate objectives.
• Used Oracle tools, TOAD for Oracle, PL/SQL, SQL*Loader, create custom reports to meet requirements for data analysis.

Confidential, CA

Systems Consultant

Responsibilities:

• Responsible for Customer Service Consolidation project, systems conversion, systems interfacing, project management, completed project on time and met company budget.
• Responsible for ERP implementation, MRP implementation, implement flow manufacturing, and Standard Cost implementation.
• Used Oracle tools, TOAD for Oracle, PL/SQL, SQL*Loader, developed custom reports and forms, interface, customization and enhancements for Order Management.
• Oracle database management, performance tune up, backup solutions, and disaster recovery planning.

Confidential, CA

MIS Manager

Responsibilities:

• Managed MIS department, project management, budget management, developed Vendor Rating system and MRB Tracking system.
• Successful consolidated a division in a cost-effective way.
• Developed disaster recovery plan, testing and upgraded MANMAN applications (MFG, OMAR, AP, GL, and PROJECT) from Release 7.1 to 8.2.
• HP3000 systems administration, network administration, and strategic planning.
• Responsible for programming, coding, debugging, testing, user training, and troubleshooting.
• Developed custom reports for data analysis for Sales, Marketing, Inventory Control to improve productivity and efficiency.

Confidential, CA

Systems Analyst

Responsibilities:

• HP3000 systems administration, upgraded MANMAN system from Release 6.1 to 7.1.
• Responsible for MRP implementation, user training, and provided production support.
• Responsible for programming, coding, debugging, testing, user training, and troubleshooting.
• Created professional custom reports for data analysis.