SUMMARY

• 9 Years of experience in PL/SQL Development with expertise in developing and modifying packages, triggers, procedures, functions and database objects like tables, grants and synonym, Cursor, PL/SQL Collections, PL/SQL Objects, PL/SQL Performance Tuning.
• Deep Knowledge on Advanced PL/SQL concepts like Collections, Bulk Binding, Embedded SQL.
• 9 years of experience in Software Development and Production support for PL/SQL application code.
• Expertise in Unit Testing, Code Analysis and Bud Fixing.
• Fixing Production Bugs with detailed analysis
• Hardcore expertise in Oracle forms.
• Writing Technical Design document(Md.70) from Functional Design Document (Md.50)
• Design the Application Back end code, develop and review the code by Junior team members and Peers.
• Managed Team highly skilled PL/SQL Developers and Front end Developers.
• Have been part of Architect discussion
• Have Knowledge on Extraction, Transformation and Load(ETL) concept.
• Expertise on Oracle Application Modules Purchasing (PO),Inventory (INV),General Ledger (GL), Account Receivables(AR),Account Payables(AP)
• Development and production support experience in Oracle 10g .
• Expertise in Software Release Automation and Release Ops.
• Part of Architect Team for the development of new custom tool for code migration
• Build at full ownership in EBS system.
• Technical ownership and management of the resources for the development and maintenance of new tool for release management.
• Expertise in Custom Tool (APPDB) Development and Release Management.
• In depth understanding of Software Development Life Cycle (SDLC) and Testing Life Cycle.
• Extensive use of SQL queries for various production support activities.
• Developed own SQL Queries which can show all the issues in Order Flow
• Excellent verbal and written communication skills with an eye for detail.
• Highly conceptual and innovative problem solver with excellent organizational skills

TECHNICAL SKILLS

Modules: Oracle EBS Suite Applications R12.1.X, 11i Ver11.5.10.2 Order To Cash (O2C), Procure To Pay (P2P) Cycles, Order Management (OM), Oracle Inventory (INV), Account Receivables (AR), Account Payables (AP), General Ledger (GL), Oracle Advanced Supply Chain Planning (ASCP),Advance Pricing, Costing and Work in Progress(WIP),Oracle Manufacturing including, Plan, Source, Make, Deliver and Finance.

Domain: Oracle Supply Chain Management (SCM), Oracle Manufacturing, Dev Ops, Release Management.

Operating System: Solaris, Linux, Windows, Windows Vista/95/98/2000/XP/XP Pro/7, DOS, UNIX

Languages: SQL, PL/SQL, UNIX Shell Scripting, Basic Java

Tools: /DB/Packages: Application Object Library(AOL), Oracle Reports 10g/9i/6i, Oracle Forms 10g/9i/6i, Oracle BI Publisher(XML Publisher), SQL*Plus, SQL* Loader, Toad, Polytron Version Control System (PVCS), Kintana, Subversion(SVN), Oracle Application Express, Oracle Application Framework(OAF),Data Modeling. Hierarchical profiler, dbms profiler SQL tracing, tkprof, dbms xplan

Databases: Oracle 10g, 11g,12.2

PROFESSIONAL EXPERIENCE

Confidential

Technology Lead

Responsibilities:

• Technical implementation on Buy - Sell and Buy-Hold-Sell process in Cisco R12 environment to have more visibility on components purchased by the partner from Suppliers.
• Create and maintain new inventory locations (SHUB).
• Implement locator concept current process.
• Mange cut over orders which does not have locators assigned.
• Implement custom reservation API.
• Technical implementation of Compliance frame work (Smart compliance) in Cisco Order Flow in order to meet import compliance criteria of different countries across the world.
• Develop data model and design and develop front end OAF screen to capture compliance data.
• Develop APIs to be used by Order Management and Planning team to access the compliance Rules.
• Do unit testing by simulating entire order flow by entering order, booking order, scheduling the order, simulating partner integration messages, pick release, ship confirm and invoicing.
• Senior Technical Consultant of the project.
• Managing EDI data like EDI 856, 4B2 Messages from partner and process the same for transactions in Oracle APPS Supply Chain Make Track.
• Code Development for Retro Invoice Creation (Differential amount to be settled with partner).
• Unit Testing on Procure to Pay Cycle by requisition creation from partner 4B2 messages, requisition import, Purchase Order (PO) creation, PO Approval and PO Receipt and Invoice generation as part of SCM R12 Implementation.
• Have worked on Order to Cash (O2C) cycle for Configure to Order (CTO) and Build to Stock (BTS) items SCM R12 Implementation.
• Have created Order, Booked, Scheduled, Pick release, Pick Confirmed Ship Confirmed, created invoice and posted to General Ledger (GL).
• Develop, Modify and Review Data base objects as PL/SQL Packages, Procedures, triggers, functions, table, synonyms, Grants.
• Code review of Peers and Offshore team
• Coordinating with offshore team.
• Lead the team on Development activities.
• Onsite Offshore handover.

Confidential, San Jose, California

Technology Lead

Responsibilities:

• Design and Architect in-house tool (APPDB) for version control and object migration.
• Data modeling for the entire application.
• Create maintain and review data model for the new tool.
• Create user interfaces using Oracle Application Express (APEX) tool for version commit and code review.
• Create and maintain PL/SQL APIs for version commit and deployment.
• Create and maintain dbms jobs for object migration and meta data synchronization.
• Work with sysadmin and DBA team for server space allocation and system maintenance.
• Develop dynamic PL/SQL APIs which utilize Oracle standard FNDLOAD and XMLLoader utilities to migrate Oracle AOL Objects and XML Publisher files.
• Create design documents, system maintenance documents implementation manuals and user manuals for the new tool
• Train users and developers on usage of the new tool and evangelize the tool across the cisco development community.
• Design and monitoring regression and progression test scripts for enhancements on the tool.
• Debug and fix the issues on tool at minimum SLA.
• Support Object commit, promotion to test and production environments.
• Co Ordinate with Release Management Team for any issues during Production Go Live.
• Identify and implement innovative solution to customers Problems.
• Technical Leadership and direction to Agile Software Development teams.
• Design and monitor regression and progression testing on any enhancements on the tool.
• Coordinating with developer community, Release management and SRA team during Go Live and new enhancements on the tool.

Environment: SQL, PL/SQL, Oracle Apex, Java

Confidential, San Jose, California

Technology Lead

Responsibilities:

• Senior Technical Consultant of the project.
• Have Worked on Order To Cash Flow including Order creation, Booking, Custom work flow management and partner message management, Pick release, Ship confirm and Invoicing.
• Have worked on 4B2 message processing for purchase requisition creation, Purchase Order creation, PO receipt, invoicing and invoice communication.
• Have fixed data issues in Advance shipment notice and enablement data send to customer and suggested long term fix to enforce pallet info in partner message.
• Have worked extensively on BTS and CTO flow issues and handled daily order processing during Normalization period.
• Coordinating with offshore team.
• Lead the team on handling issues, cases and proactive monitoring.
• Onsite Offshore handover.
• Proactively find the system issues and resolving them.
• Daily monitoring of newly implemented R12 instance and normalization support
• Bridge between ITDS and Business.

Environment: SQL, PL/SQL, Oracle Forms.

Confidential

Oracle Apps Functional Consultant

Responsibilities:

• Senior Functional Analyst Consultant of the project.
• Define set ups required for Oracle Order management(OM), Inventory(INV) and help finance team to identify set ups in Account Receivables(AR) and General Ledger(GL) for the implementation of Order To Cash Cycle(O2C).
• Identify Set up Order Transactions types, Document Sequence, Item attribute setups, Customer setups, and pricing set ups like Advance Pricing and Costing required Order Management from Biz users and implement the same and document in BR100 document.
• Identify set ups required in Purchasing(PO),Inventory(INV) and help finance team to identify set ups required for Account Payables(AP) and General Ledger(GL) to implement Procure to Pay Cycle(P2P), document the same in BR100 document and implement the same.
• Implement Configure To Order (CTO) and Build To Stock (BTS) Order Flow in Cisco Manufacturing.
• Implement JIT (Just in Time) Manufacturing concept in Oracle R12 system.
• Integrate newly acquired organization (Currently working in SAP) to Cisco R12 environment.
• Learn current data send in Advance Shipment Notice (ASN) and Enablement data from SAP system and implement the same from R12.
• Functional and technical design for the above mentioned ASN and enablement data.
• Implement ASN propagation as EDI 856 messages.
• Technical design for capturing enablement data (like MAC address, IMEI) for each serial number from Auto test data base using multiple concurrent programs and web service call.
• Co Ordinate Onsite Offshore activities and release cycles.
• Author Functional (MD.50) and Technical Design document (MD.70).
• Transition Lead for all activities during project cycle.
• Data Extraction from current 11i system, required conversion and loading into R12 system.

Environment: SQL, PL/SQL, Oracle AOL, UNIX, Java Webservices.

Confidential

Software Engineer

Responsibilities:

• Was responsible for validating the release environment by doing the functional testing.
• Gathering the functional testing requirement from onsite team, study it and provide the KT to automation team.
• Also responsible for testing on manufacturing & finance track and SCD.
• Learned the oracle order management functional flow. Have worked on PO and GL. Created the PO, received it and created invoice for the same.
• Have created the Journal voucher and posted it to GL.
• Have done Daily Cost Rollup for PID item.(Have updated the cost for PID item and reflected the updated cost in Local org and global Org.)
• Have validated the Oracle data against the Cisco tools MRAP and Siebel. SCV: Have validated the Contract Manufacturer files against the Cisco files and reported the discrepancies to the client. It was a very business Critical activity and got appreciation from client.