Techno/functional Lead Resume
SUMMARY:
- Proactive, analytical, and dedicated professional offering more than 18 years of exceptional record in successful implementation of business systems across United States, Canada, Europe, and India. Highly innovative person with extensive hands - on experience in automating multi-billion dollar enterprises. Self-motivated and results-driven with proven expertise in delivering IT advantages to address business issues and achieve outstanding results while effectively managing costs and risks. Certified Six Sigma Green Belt Professional. Demonstrates unique combination of technical and functional expertise.
- Successfully implemented Oracle Business Systems in United States, Canada, Netherlands, Belgium, Luxembourg, Spain, France, Germany, Austria, United Kingdom and Switzerland for construction company in a project based environment; Successfully implemented processes to support shared service centre business model
- Experience in providing 24/7 support of business systems
- Acted as a Techno/Functional lead for optimizing operational efficiency of manufacturing Organization in a project based environment
- Performed requirements gathering and Techno/functional design for highly challenging accrued billings project and improved company bottom line by $5 million; Reduced Unbilled Receivables by $10 million
- Performed requirement gathering and Techno/functional design for Revenue generating click charge project and improved revenues of a division by $3 million/year
- Performed analysis and design for complex performance improvement project and improved system performance without additional investment in hardware
- Successfully upgraded Oracle Applications in record time
TECHNICAL SKILLS:
Tools: Oracle Applications 12, 11i, 10SC, 10.7, 10.5, MS Project, Hyperion 5.x, Vertex, Oracle 10g, 9i, 8i, Oracle 7.x, Reports, Forms, Java, SOA 11g, OAF, Work flow, OBIEE and SAP
Modules: Oracle Projects, Order Management, Receivables, Purchasing, Payables, Inventory, General Ledger, Cash Management, Intercompany, Mobile Supply Chain Applications, Fixed Assets, Service Contracts, Install Base, Field Service, Work In process, Bill of Materials, MRP, Quality, Project Manufacturing, Time and Labor, Advanced Supply Chain Planning, Human Resource Management Systems, Territory Management, Stratix and SAP R3
Platforms: UNIX, Linux, AIX, Solaris
Hardware: Sun SPARC 5, IBM R24, IBM R390, HP-UX
PROFESSIONAL EXPERIENCE:
Confidential
Techno/Functional Lead
Responsibilities:
- Configured Demantra worksheets, created series and levels
- Developed integration interfaces and configured workflows
- Performed BAL migration from one instance to another instance
- Designed and developed interfaces between Demantra and ASCP; Developed interfaces to collect data from Order Management, BOM, WIP and Inventory
- Designed and developed reports using XML publisher
- Performed Unit testing, module testing and integration testing of Demantra and Oracle EBS
- Handled production deployment and User acceptance testing for Demantra and Oracle EBS
Environment: Demantra, Oracle 12, Oracle MSCA, Oracle Inventory, Oracle Quality, Oracle ASCP, Oracle Depot Repaid, Oracle Purchasing and Oracle Order Management, WIP, BI Publisher, XML, OAF, Prince-2
Confidential
Techno/Functional Lead
Responsibilities:
- Conducted workshops and Gathered business requirements; Performed gap analysis and configured Advanced collections for various collection strategies
- Gathered US Sales Tax requirements and configured Oracle AR to meet needs of client
- Did functional design for integrating Oracle EBS with external collection agencies
- Did functional design for converting collections data from legacy systems into Oracle EBS
- Trained on-site and off-shore team on Oracle Advanced Collections and Oracle AR
- Co-ordinate off-shore development work
Environment: Oracle 12, Advanced Collections, Oracle Territory Management, Oracle AR, Oracle Order Management, Oracle EBS Tax, AIM
Confidential
Solution Architect
Responsibilities:
- Conducted workshops and gather business requirements; Evaluated various options for integrating Oracle Transportation Management (OTM) with Oracle Service Contracts/Oracle Projects
- Presented solution using Oracle Service Contracts to manage logistics of a transportation company
Environment: Oracle 12, OTM, Service Contracts, Projects, AIM
Confidential
Techno/Functional Lead
Responsibilities:
- Tuned Demantra forecasts by enabling and using metrics such as MAPE, MAD for forecast accuracy measurement.
- Automated Demantra forecast run via EBS Concurrent Requests allowing complete scheduling of Collection/Forecast/Archive workflows.
- Created buyer/planner processes to implement Demand Management functionality to allow full utilization of the tool’s benefits.
- Enhanced Demantra Infrastructure to provide Developmental and Quality Assurance platforms
Environment: SOA 11g, Oracle 12, Oracle Demantra
Confidential
Techno/Functional Lead
Responsibilities:
- Managed delivery and acted as an architect for developing web based mobile supply chain applications
- Used new Demantra interfaces for reverse supply chain planning
- Implemented of kits for distribution planning, and integration of legacy applications to Demantra and ASCP
- Used forecast as supply in ASCP, inventory re-balancing, end-item substitution
- Evaluated different solutions for developing mobile supply chain applications
- Did functional design and technical design for Item Inquiry and warehouse applications
- Configured ASCP to improve pipe/fittings on-time delivery
- Designed and developed mobile applications for Oracle Quality
- Designed sub-inventory transfer, PO Receipt, Org-Transfer applications
Environment: Oracle 12, Oracle Demantra, Oracle MSCA, Oracle Inventory, Oracle Quality, Oracle Depot Repair, Oracle Purchasing and Oracle Order Management, WIP, Oracle ASCP, BI Publisher, XML, OAF, Prince-2
Confidential
Applications Manager
Responsibilities:
- Acted as a point of contact to all business owners, consultants, developers, and users. Provided end-to-end project service and architectural support while ensuring that functional and technical requirements were met
- Designed interfaces to integrate other business units with Oracle Purchasing and Accounts Payables; Provided support for Oracle EBS and exceeded service level agreements
- Performed set-up of Oracle Projects and Integrated Oracle Projects with Oracle Payables and Receivables
- Defined various burden schedules; Defined various accounting rules for Costing and Cost Recovery
- Verified set-up of auto-accounting rules using auto-accounting verification screens (built in-house)
- Resolved various Project revenue generation and project billing issues
- Performed integration testing of Project Billing and Project costing
- Reconciled revenue accounts between Project Billing and General Ledger
- Led Billing Initiative and reduced Service Contracts billing issues and AR stuck errors by $1.2 million and Developed processes to streamline Invoice Interface Errors; Resolved various tax (vertex) issues
- Integrated Oracle Fixed Assets with Install Base and General Ledger
- Integrated Oracle Install base, Service contracts, Oracle TCA with Siebel CRM
- Architected solution for integrating SAP with Oracle EBS and provided single view of Receivables
- Led Billing improvements initiative, reduced billing errors, reduced DSO and reduced manual effort in processing payments
- Designed various reconciliation reports to reconcile Oracle EBS with external systems; Designed reports to measure health of Oracle EBS and external modules
- Integrated Oracle EBS with Vertex; Designed custom AR application to provide single view of AR; Improved cash application processes and Led implementation of Amex Credit Card systems
- Evaluated various Data Archiving and Purging applications
Environment: Oracle 12, 11i, Oracle Payroll, Advanced Benefits, Service Contracts, Install Base, Order Management, Receivables, TCA, Payables, General Ledger, Cash Management, Purchasing, Accounts Payables, BOM, Advanced Pricing, Fixed Assets, Workflow, AME Rules Engine, OA Framework (OAF), Vertex, SAP, OBIEE, Prince-2
Confidential
Project Manager
Responsibilities:
- Gathered requirements, performed GAP analysis and did Techno/functional design to calculate Estimate at Completion cost (EAC) for Projects.
- Did Technical design and development for Oracle Project Integration and Oracle Budgeting tools.
- Performed analysis for Project dash board reporting system.
- Performed analysis for bringing labor cost into Oracle Projects and did set-up of various burden schedules
- Performed set-up of Oracle Projects, Oracle work in process, Oracle Mobile Supply chain, Oracle Payables, General Ledger, Purchasing, Depot Repair and Oracle Quality
- Performed requirement analysis and did Techno/Functional design to provide supply chain visibility in a project based environment.
- Implemented Oracle Mobile Supply Chain Applications, Oracle Work in Process, Oracle Projects, Oracle Payables, General Ledger, Purchasing and Oracle Quality.
- Integrated Oracle Payables, Purchasing, Inventory with Oracle Projects
- Implemented systems to track serialized units on shop floor.
- Implemented Depot Repair for maintaining serialized units.
- Designed and developed dash boards to give visibility to units that are being repaired
- Implemented Quality Collection plans for Serialized and non-serialized units.
- Designed and developed supply chain planning system to improve on-time delivery
- Implemented systems to integrate third party test software with Oracle MSCA and Oracle Work in Process.
- To improve planning process, implemented systems to provide visibility of Work in Process to various departments.
- Implemented project dash boards which give comprehensive information for managing Shop floor Operations.
- Implemented systems to manage stock room and to reduce on-hand inventory.
- Implemented systems for generating labels for Defence Manufacturer
- Upgraded Oracle applications
Environment: Oracle 11.5.9, PA, MSCA, WIP, Quality, MRP, BOM, INV, Depot Repair, Oracle Quality, ENG, PO, OM, AP, AR, GL, AIM and Agile/scrum
Confidential
Architect/Lead
Responsibilities:
- Analyzed statutory/legal requirements of various countries in Europe
- Implemented Oracle Business Systems in Switzerland, United Kingdom, Netherlands, Belgium, Spain, France, Germany and Austria
- Implemented Oracle Project Accounting, Project Contracts, Oracle Receivables, Oracle Order Management, Oracle Project Manufacturing, Oracle Inventory, Oracle Payables, Oracle HRMS, Oracle Cash Management, Oracle Fixed Assets, Oracle Purchasing and Oracle General Ledger.
- Designed compensation systems to measure performance of project managers and to compensate accordingly.
- Designed processes to bring material, labor and sub-contractor cost into Oracle Applications.
- Designed and implemented labor cost rules for construction industry. Implemented burden schedules to capture various components of labor cost.
- Integrated internal suppliers (factories) with Oracle Purchasing, Oracle Inventory, Oracle Payables, Oracle Project Accounting, Oracle Order Management and Oracle Receivables
- Integrated employee expense systems with Payables. Implemented systems to integrate Oracle HRMS with Hyperion and Insurance carriers.
- Designed processes to reconcile various accounts between General Ledger and Sub-Ledgers.
- Performed Techno/functional design to convert data from legacy systems to Oracle Applications.
- Customized Oracle HRMS to handle contract costing and cost recovery.
- Implemented OTL to meet needs of various lines of business and language requirements of several European countries. Implemented workflow for time approval in OTL module. Integrated PDA with OTL for Unscheduled service line of business.
- Implemented systems to handle employee privacy requirements of various countries. Designed various employee and consultancy services reports to meet statutory needs.
- Implemented systems to capture sales compensation related information and to calculate compensation for Sales Persons and Sales Management.
- Implemented workflow for Oracle Purchasing and Payables.
- Tuned complex Revenue generation and AR reports
- Designed and developed processes to integrate Oracle Applications with corporate data warehouse.
- Designed and Developed processes to meet Intrastat, VAT reporting requirements in Europe.
- Designed processes to meet G-Account requirement for Netherlands; Implemented Oracle Financials to meet Document Sequencing rules.
- Prepared test plans and performed integration and module tests. Designed processes to monitor health of Oracle Application data.
- Designed software to migrate Oracle Applications set-up from one instance to another instance.
- Did analysis on functionality offered by various versions of Oracle Applications.
- Designed web based contract booking system. Integrated contract booking system with Oracle Projects using Activity Management Gateway.
- Designed web based project estimation tools. Integrated cost estimation tools with Oracle Projects.
- Worked on Oracle Projects - Billing, Costing and integration of Oracle Projects with Oracle Receivables.
- Designed processes to integrate Oracle Projects with Oracle Receivables.
- Performed logical and physical design to calculate Sales Tax for invoices generated by Oracle Projects.
- Designed and implemented sub-contractor and retention processes for Projects line of business.
- Integrated various purchasing tools like e-counterline with Oracle Applications.
- Integrated Astea’s products with Oracle Payables, Oracle Projects and Oracle A/R to handle service line of business.
- Implemented purchasing and payables to handle unscheduled service line of business.
- Developed user interface to test auto accounting rules. Designed and developed interface programs to bring legacy billing data into Oracle Projects. Developed interface programs to send data from Oracle Projects to other systems.
- Led Legacy-PA Data Conversion team. Developed interface programs to bring sales tax data from legacy to Oracle Projects. Defined auto accounting rules for various functions of Oracle Projects.
- Worked on Oracle Order Entry and Oracle Manufacturing, providing production support for Logistics. Studied existing systems in Logistics and redesigned shipping document system.
- Performed logical and physical design of shipping document system.
- Prepared test scripts to automate testing. Developed and maintained various reports for shipment status, carton tracking, delivery and performance reports. Developed and maintained EDI 856 outbound and EDI 214 inbound systems.
- Worked on integration of Oracle Order Entry and Metasys Shipping Manifest System. Developed reports and programs for Rapid European Delivery. Tuned various reports and programs. Worked on Replication of data.
Environment: Oracle 10.7, OE, INV, Manufacturing, BOM and ENG
Confidential
Systems Analyst
Responsibilities:
- Developed tax engine to integrate Oracle Receivables and Vertex's Quantum software. Customized on-line, recurring, auto invoice database views to meet business requirements.
- Developed database packages to select additional data from Created and customized various profile options.
- Defined Auto Accounting to generate valid Accounting Flex fields for invoices and credit memos.
- Customized Receivables to capture additional data using descriptive flex fields. Modified invoice entry form to display additional data.
- Developed reconciliation program to reconcile taxes stored in Oracle Receivables and Vertex's Register database. Developed a program to calculate and store taxes in Vertex's Register database for adjustments & credit memos.
- Developed a Tax Queue system to find out taxability of an order.
- Developed four Pro*C programs and an event control server to integrate Oracle Order entry and Vertex's Quantum Software.
- Developed forms using Power Builder to review failed incorrect/incomplete orders.
Confidential
Software Specialist
Responsibilities:
- Installed Oracle 7.1 and Oracle Financials 10.5.
- Received on Oracle Applications.
- Developed interface programs to transfer data from legacy to Oracle General Ledger.
- Customized descriptive flex fields to capture additional data. Modified standard reports to display additional data.
- Created and maintained multiple databases. Developed custom reports using Oracle Reports.
Confidential
Senior Systems Officer
Responsibilities:
- Developed logical and physical design of the system like preparing entity relationship diagrams, data flow diagrams, structure charts and program specifications.
- Carried out code review and testing. Developed database triggers to maintain integrity of database and implementing business rules.
- Developed shell scripts for downloading and uploading data. Installed Oracle and its related tools. Created multiple databases required for production and development purposes. Performed user administration. Trained personnel in user departments and management services department on Oracle and DENIS package.
- Involved in analysis and design of the system. Prepared ER diagrams, data flow diagrams and program specifications.
- Developed around 25 programs Pro*C for on-line explosion, on-line implosion, transaction processing and calculations.
- Designed and developed around 20 data entry and transaction processing forms using SQL*Forms 3.0. Developed around 20 programs in Pro*C and SQR for generating reports like technical parts list, design modification list, customer requests, bill of material.
- Carried out code review. Created system test plan and conducted integrated system test.
- Studied structure of .inp files generated by Oracle SQL*Forms 3.0.
- Wrote a parser to convert prototypes developed in Turbo Analyst into .inp files using C.
- Used various string handling functions of C for writing the parser. Prepared system test plans. Carried out testing of the entire module.
Confidential
Contracts Officer
Responsibilities:
- Carried out requirement analysis of existing physical systems at various sites.
- Designed and developed software to help monitor projects
- Improved operational efficiency of contracts execution department and helped in reducing project bottlenecks