SUMMARY

• IT professional with 18+ years of extensive experience in application design, 发展, and implementation of 甲骨文 EBS (11i/R12) projects for Oil and Gas, 信息技术服务, manufacturing and engineering industries with OMCS (甲骨文 Managed Cloud Services) platform.
• 甲骨文 Certified Professional Application Developer (SQL, PL / SQL, 甲骨文形式, 甲骨文报告), certification for ITIL foundation.
• Extensive experience with providing end - to-end solutions for RICEWF components for EBS R12.1.3 modules related to P2P, 场外, 和MFG - 发票,物料清单, 英格, 在制品数量, PO, AR, AP, CM, FA, GL, OM, WSH (Warehouse Shipping Handling), and Advanced Pricing.
• Experience of being on implementation team for oracle EBS R12 rollouts at different NOV plants and involved in design/发展/testing/implementation/war-room support as well as post-产品ion support tasks.
• Ability to understand functional design document and underlined business requirements for RICEWF+呆子 components and converting into Technical design, writing technical specs, 代码开发, writing test scripts for unit testing, writing UNIX shell script for deployment FUT coordination with BAs and end-users.
• Work experience as a developer/technical lead with PL / SQL, 甲骨文 Developer Suite (Forms/Reports), XML / BI出版商, 呆子, SOA, BPEL, ADF, 工作流, Web ADI, Unix Shell scripting, 个性化, Application Developer and System Administrator responsibility tasks including AOL, DFF, 凯萨, 值集, 业务事件, 警报, Concurrent Programs setup and scheduling etc.
• Good knowledge of 甲骨文 EBS customization/extension methodologies, developed many complex interfaces for Bank, 工程, 制造业, OM, and PO using BPEL component of 甲骨文 SOA as middleware, 分析, 调试, and resolving issues, working on 产品ion support tickets, creating SRs and working with oracle support, writing data fix scripts.
• Expertise in data conversion/migration, open interfaces using APIs, customization of RICEWF components, ETL architecture - dataextractions, 清洗, 转换, and loading to build enterprise DataWarehouse / DataMarts using Informatica PowerCenter. Designed and developed materialized views and 包 for outbound interfaces to cater custom data warehouse.
• Adept at understanding business processes/requirements, 数据库设计, entity relationship (ER) modeling and dimensional modeling using Star and Snowflake schemas, creating mappings and 转换, tuning mappings and sessions for better performance.
• Extensive experience in oracle database programming in PL / SQL for creating Packages, 数据库触发器, 功能, 异常处理, 调试 and tuning PL / SQLcode, tuning complex queries utilizing Indexes, 提示, 和解释计划, TKPROF for performance and optimization.
• Proficient working with Collection objects, 嵌套表, 记录类型, 游标, Ref游标, 物化视图, 大量收集, 原则,, 代替触发器, Autonomous Transactions, 动态SQL等.
• Experience with working in different capacities as developer, 带领开发人员, 团队领头人, HP-QC管理, 业务分析师, 发布经理, working with local team as well as offshore 发展 team in India and delivering the projects on schedule within budget.
• Also have worked as release manager - coordinating with global 发展 team for source control procedures, check-in and promoting the code, preparing implementation plan, coordinating deployment with SysAdmin/DBA team, monitoring deployment, and post deployment testing.
• Good understanding of AIM documentations, 项目生命周期, SDLC aligned to waterfall as well as Agile/ scrum methodology, requirement gathering, 功能分析, and effort estimation for customization.

技术技能

• 甲骨文 EBS 11i/R12 RICEWF+呆子 Components
• 甲骨文 10 g / 11 g / 12 c
• SQL
• PL / SQL
• 甲骨文形式
• 甲骨文的报告
• BI/XML Publisher Reports
• 甲骨文公司工作流程
• 呆子
• ADF
• JAVA
• UNIX Shell脚本
• Informatica Power Center 9x
• 甲骨文 SOA (BPEL)
• SQL *加载程序
• 数据加载器
• 有WINSCP
• 腻子
• AOL (Application Object Library) Architecture
• Business flow and data flow knowledge for SCM
• FIN and MFG Modules
• Data Conversions/Migrations
• Open Interfaces/APIs
• EAI (Enterprise Application Integration)
• ETL Processing for Data Warehouse/Data Marts
• 甲骨文J-Developer
• 甲骨文 seeded 形式 customization using CUSTOM.锁相环
• 性能调优

PROFESSIONAL EXPERIENCE

保密

Sr. 甲骨文 Application Developer

职责:

• Being part of implementation team for oracle EBS R12 rollouts at different plants of NOV. Involved in design/发展/testing/implementation/and post implementation support.
• Worked on data migration while cut-over activity and going live with EBS rollouts for different plants as well as war-room support after go-live and then day-to-day 产品ion support.
• Wrote test plans and executed different types of testing - CRP/FUT/UAT/SIT. Worked with QTP developer for developing automated test scripts for unit testing different functional scenarios and load testing using QTP.
• Worked on conversions and interfaces related to Bank, SO, PO, 期刊, 项目, bom, 工艺路线, and ECNs using PL / SQL and BPEL process as middleware.
• Developed SO interface between Glovia ERP and 甲骨文 RBS R12, Bank Statement interface between global banks and EBS for bank statement reconciliation, Auto Lockbox interface between WF bank and EBS to collect and process all the receipt instruments, Two way Shipping interface between FedEx and EBS sending shipping details and collecting shipping labels from them, Cronos interface to send manufacturing data to Cronos system. BPEL Components are used in all these integrations/interfaces.
• Developed Item interface and dynamic ECO interface between Team Center engineering application and EBS. This engineering interface will sync the master bom with Team center engineering application, but also take care of differences maintained at different plants and their multiple operation sequence requirements. So creating ECO for the delta by comparing the two bom and will implement the ECO as per org preference.
• Upgraded Vertex-Q series to Vertex O-series and modified the hook to customize for NOV requirements for ultimate destinations, invoice exemption rule, modifying post-calc message for credit memo against Q-series invoice etc.
• Modified the invoice report to print short attachment notes from OM/Project/Manual invoices and credit memos as well as ultimate destination and deliver to instead of ship-to, showing dynamic log etc.
• Worked on many financial and manufacturing 报告 for creating hooks in PL / SQL for BI cognos reporting, developed new 报告 and modified existing 报告 for enhancement requirements using XML Publisher and oracle report. Translated financial and manufacturing 报告 into Russian language for Russia implementation.
• Worked on numerous form and report modules, developed custom oracle 形式 and personalized the seeded 形式 for extended functionality. Incorporated complex personalizations thru PCG and CUSTOM.锁相环 for seeded oracle 形式.
• Also worked on 呆子 personalizations as well as 呆子 components to customize/add search page, 值列表, adding regions to show additional info, uploading files through 呆子 page etc.
• Providing daily 产品ion support for the modules related to P2P (purchasing, iSupplier, i采购, 应付账款), O2C (order management, 应收账款, 现金管理), and manufacturing (inventory, 物料清单, 路由, work-in-process) modules involving 分析 the issue, providing work-around or fixing the root cause, writing data fix scripts in PL / SQL, if required then logging SR and working with oracle support.
• Worked on data extractions (ETL) projects for data warehouse and BI reporting. Good knowledge of Informatica and moderate knowledge of cognos reporting tool. Created few hooks in PL / SQL for cognos.
• 担任QC行政. Quality Center is used for help desk system at NOV to log day to day issues and RICEWF tickets. Also worked on AOL objects like values sets, flex字段, 注册菜单, 形式, 报告, 并发程序, 和打印机, application user setup, defining responsibilities as well as providing support to apps users for any technical and functional issues.

保密, Houston

Application Developer/ Sr. 程序员/分析师

职责:

• Worked on critical enhancements and SOX compliance projects. Modified 形式 and 报告 to implement SOX controls like Discount of Records, tracking of Price variance activities, tracking of all types of issues, holds and approvals during the order life cycle etc., writing downloads in PL / SQL and developing highly complex 报告 required by government auditors, SOX审计, and business executives.
• Received ‘On the Spot’ Award from business department for excellent work and service provided to internal customers.
• Worked on complex differed revenue project. 收到的是&T Excellence Award for this project for its quality, UI standards and completing within SLA.
• Worked on data extractions for data warehousing and dash boards to be used in BI for executive reporting. Developed back-end 包 in PL / SQL for EAI (Enterprise wide Application Integration) functionality to update information in real time across the applications.
• Developed 包 to generate email notifications (like order detail info to customer and sales rep, invoice notification, expiring service contract notification etc. from oracle during different processes.
• Troubleshooting tickets relating to AP, PO,i采购,iSupplier(P2P)issues.
• Providing 产品ion support for these modules to users, internal and SOX Auditors as well as for period-end closing process.
• Worked as a Lead Developer/Analyst with offshore 发展 team and delivered the projects on schedule.
• It also includes preparing test plans and coordinating IST (Integrated System Testing), UAT (User Acceptance Testing) and getting signoff for the deployment.
• Also worked as a release manager for deployment of the projects, which includes - preparing SOX Compliance CR (Change Request) and its relevant documentation, coordination with global 发展 team for version source control procedures, check-in the objects, preparing implementation plan, coordinating the deployment with Sys Admin/DBA team, and post deployment testing.
• Acquired Company Data Conversion as well as extraction for Data warehouse: Worked on acquired company data conversion for customer, 产品, 账户基本, 协议, 许可产品, support entitlements (service contracts), 发票等. as well as extraction projects for data warehouse.
• 数据映射, data conversion (uploading ASCII data files to oracle staging tables) using SQL Loader, 发展 and testing of conversion scripts, 报告 and queries to view conversion statistics, exceptions and warnings and proof 报告. Developed a generalized import utility in PL / SQL to load data into oracle custom tables from ASCII files using UTL FILE package.
• Worked with ETL processes utilizingInformaticaPower center tools to design data conversions from variety of data sources like relational, XML and flat file source systems to data warehouse/data marts, implementing business rules by creating 转换 (Expression, 总, 源限定符, connected and Unconnected Lookup, 路由器, Rank) and developing Maplet, 和映射.
• Merge/Sweep Utility for Customer Management: Developed tools to handle merge and 清洗 of duplicate records for customers, 网站和联系人. Any update on customer master (accounts, 办公地址, contacts) will propagate to oracle through customer interface events.
• Developed 存储过程 for Merge/Sweep functions. Developed RDP (Remote Data Processing), which updates the transactions in oracle custom applications for company/site/contact info in the tables listed in control table using Dynamic SQL.
• Upgrade of EBS 11i: Updated the custom objects (形式 and 报告) to 11i standard (i.e. from developer 2000 to Developer 6i), Updated the Database objects 11i standard and testing of all these objects.
• Enterprise wide Application Integration (EAI) project: Developed integration between different applications like Siebel, 甲骨文, and Customer First etc. to update information in real time through canonical design of publishers and subscribers. Changes made by application owner will be published and subscribers will get the events for change in real time.
• Written complex PL / SQL 包 for handling these events, consuming the subscription as well as well as publishing the changes for its subscribers. Developed integrations for Customer, Product, Sales Order, and Agreement entities.
• Production Support and Enhancement of custom OM, 许可产品, and PIM and interfaces with Siebel - handling helpdesk tickets, writing data-fix scripts, enhancement and 发展 of 形式, 报告, 包, 工作流, 存储过程, 数据库触发器, 和AOL对象.

保密

分类. 经理(系统)

职责:

• Consolidated different applications for finance and MRP being used at different manufacturing plants to bring them on platform and created a foundation for future ERP solution.
• Worked on requirement analysis for 物料清单, 英格, 发票, MRP, 采购, Production Floor Management and Maintenance (maintaining process sheets, machine utilization, operation center processing, 操作效率, 机器停机时间, operation center overhead, 耐磨部件等.).
• Prepared Requirement Specifications for the proposed system.

保密

Sr. Executive (Systems)

职责:

• Developed finance and distribution applications using early version of oracle and PL / SQL.
• Transformed the payroll application from COBOL to oracle.
• Developed branch application for OM, invoice, inventory using PL / SQL, Forms/Reports. Also developed interfaces between HO and branch application.
• Wrote application for WD functions like processing retailor requests, retailor分配, 库存管理, 处理订单, monitoring stock flow etc.
• Also worked on EAI project between all three tiers (HO, 分公司, and manufacturing plants) using 甲骨文 and Web technologies.
• Worked in different capacities from programmer to BA. Also managed Systems department for its Ahmedabad regional office being a Senior Executive (Systems) for few years.
• Designed FS and ER diagrams for custom applications of handling assets, 产品抱怨, 保险索赔, Business Intelligence reporting.