Technical Consultant Resume
SUMMARY:
- Suv Biswas has over 23 years of business application systems experience with over 15 years of experience as Technical Consultant and 4 years as Functional Consultant in Oracle E - Business Applications.
- Suv has experience in all phases of the system development and implementation life cycle.
- He has good functional knowledge of Finance, CRM, Manufacturing and distribution modules and business processes.
- His experience also includes Custom Development, Interfaces/API and Data Conversion, Customizations, Extensions, Workflows and Integrations with third party systems.
- He has prepared technical and functional design documents for customizations and conversions using AIM methodology.
- Suv has performed Requirement Analysis, GAP Resolution, Business Process Transformation and Application Configuration.
- He has conducted Conference Room Pilots and Training for business users and provided functional and technical live support for all levels of Oracle EBS users.
- He is considered to have Expert level experience in Oracle Forms, Reports, PL/SQL, Shell Script.
TECHNICAL SKILLS:
ERP Systems: Oracle E-Business Suite R12, R11i, R11, R10.7SC, R10.6
Operating Systems: MS-Windows all versions, HP-UX, AIX, Solaris
Programming/Reporting Tools: Oracle Forms, Reports, Alerts, Workflow, Discoverer, XML Message Designer, APEX, BI Publisher, SQL Developer
Data Modeling Tools: ERwin, Oracle Designer
Programming Languages: Oracle PL/SQL, Perl, C, COBOL, FORTRAN, PASCAL
Databases: Oracle 11g, Oracle 10g, 9i, 8i, 7.x on NT / Unix
Quest Software products: TOAD, SQL Navigator
Manufacturing and distribution: Advanced Pricing, BOM, Quality, Engineering, Inventory, WIP, PO, Costing, Configurator, EAM, OM, Supply Chain Planning, Projects
Oracle CRM: TCA Foundation, Oracle Service, Sales Online, Marketing, Contact Center, Service Contract
Oracle Financials: Receivables, Payables, General Ledger, Fixed Asset, Cash Management
Methods: Oracle Applications Implementation (AIM) Methodology, Scrum
PROFESSIONAL EXPERIENCE:
Confidential
Technical Consultant
Responsibilities:
- Worked as Technical consultant for 3 Oracle R12 Migration Projects including one for R12.2.6
- Designed and developed Data Conversion for Employees, Payable Invoices and Document Attachments.
- Designed and built Forms Personalization and Workflow Extension for Order Management and Purchasing module.
- Designed and developed custom Workflow solution for Capital budget expenditure approval.
- Worked as an EBS Integration specialist on a custom development Project using APEX platform for a financial company.
- Provided production and development support for Manufacturing, Financial, EDI Inbound (850) and Outbound (856, 812) solution for a manufacturing company.
- Designed and developed Warehouse EDI (940, 945) solution for Oracle EBS.
- Designed and built a purging interface to filter manufacturing transactions interfacing into Project Manufacturing for an aircraft manufacturing company
- Designed and developed an integration solution between WIP and a third party operation software Connex.
- Designed and developed BI Publisher Reports
- Oracle R12, RDBMS v11g
Confidential
Solution Architect
Responsibilities:
- Responsible for post-production support and enhancement of Oracle Financial (Account Receivables, Account Payables, Oracle General Ledger, and Fixed Asset) for a leading provider for Trip and Weather related services
- Additional responsibilities include supporting Sales Online and Oracle Service module production issues and custom application development
- Designed and built Interface between Oracle 11i & Microsoft Dynamics CRM application
- Oracle Applications 11i, RDBMS V10g, Sun Solaris
- Led all Manufacturing Data Conversion work (Item, BOM, Routing, Cost, On-hand Balance)
- Implemented the Advanced Pricing module
- Responsible for Configuration for Advanced Pricing modules
- Major responsibilities for implementing Advanced Pricing for intercompany transactions
- Oracle Applications 11i, RDBMS V8i
Confidential
Functional Lead
Responsibilities:
- Responsible for the implementation of Advanced Pricing and OM
- Responsible for Process Definition, Requirements Analysis, and Configuration for Advanced Pricing and Order Management modules
- Additional responsibilities included setting up Oracle Marketing, Oracle Sales Online, Contact Center and Service Request form enhancement using Custom.pll
- Major responsibilities included Fuel Pricing, Fuel Price Book, Pricing based on Service Contract involving multiple scenarios
- Oracle Applications 11i, RDBMS V8i, Sun Solaris
- Responsible for the implementation of Oracle Application for a leader in natural gas compression services, compression fabrication and processing, and oil & gas production equipment
- Responsible for Requirements Analysis, GAP Resolution and Configuration for Inventory, BOM, Costing, EAM modules, Data Conversion Mapping for Items, On-Hand Balances, EAM Assets, BOM, WIP Jobs, WIP Resource Costing. Participated in CRP, Application setup, writing Test Scripts for CRP
- Oracle Applications 11i, RDBMS V8i, Sun Solaris
- Responsible for the implementation of Oracle Application
- Designed and developed extensions to Advanced Pricing, OM, BOM and Configurator
- Designed and developed Form/Process to Mass Update BOM and Configurator Models using flexible Item search criteria
- The program automatically updates BOM, refreshes Configuration models, generates logic, refresh User Interface and republish models in Configurator
- Oracle Applications 11i, RDBMS V8i, Sun Solaris
- Responsible for the 11i Solution Value Assessment for an integrated manufacturers and marketers of metal building components and pre-engineered metal building systems
- Analyzed existing 10.7 Customizations, Interfaces and Extension
- Prepared 11i. Upgrade Estimates for Customizations and Extensions
- Oracle Applications 10.7SC, RDBMS V8.1.7, Sun Solaris
- Provided implementation of extensions to Inventory, WIP
- Participated in troubleshooting Supply Chain Planning, Inventory and Costing issues
- Designed and built a complex, message-based application interface using state of the art Advanced Queuing Technology
- Developed custom form to enter Inventory and work-order-less WIP transactions based on serial genealogy
- Provided post-production support
- Oracle Applications 11.0.3, RDBMS V8i, Sun Solaris
- Led the implementation of Engineering, BOM (ATO) and Quality
- Responsible for Process Definition, Requirements Analysis, and Configuration for all modules
- Participated in Prototype Environment setup, Customization Design, user training and Data Conversion for Item, BOM and Routing
- Major responsibilities included configuring the Multi Org structure, ATO process, setting up ECO Approval Workflow, Quality plans for receiving and in-process inspection, Outside Processing Setup, setting up Oracle Alerts
- Provided post-production and month end support
- Oracle Applications 11.0.3, RDBMS V7, Sun Solaris
Confidential
Programmer Analyst
Responsibilities:
- Responsible for the implementation of extensions to Inventory, WIP
- Designed and built customizations to perform WIP Cycle Count, Rejection and Scrap Process, Vendor Data Conversion program
- Oracle Applications 10.7SC, RDBMS V7, Windows NT 4.0
Confidential
Functional Lead
Responsibilities:
- Led the implementation for Inventory and Purchasing in a Financial, Manufacturing and Distribution implementation
- Participated in Operations Analysis phase, Customization Design and Data Conversion for the above modules
- Oracle Applications 10.6 Character-based, RDBMS V7, IBM AIX
Confidential
Programmer Analyst
Responsibilities:
- Developed numerous applications for the implementation of Integrated Mines Management System
- Designed and built programs for Truck Dispatch System, Equipment Management System, Materials Management System, Coal Sales Billing, Payroll, Project Costing, and Survey Data Management System
- Additional responsibilities included System Administration
- RDBMS UNIFY, C, HP-9000
- Created in-house Materials Management System
- Designed and built reports for material requirement planning based on safety stock and reorder level
- Developed shell scripts
- RDBMS UNIFY, MF-COBOL, ECIL-UNIPOWER