Techno Functional Lead In Finance Resume
Mountain View, CA
PROFESSIONAL SUMMARY:
- 12+ Years of IT industry experience on Oracle Applications eBS in Design, Development and Delivery of Enterprise Application Solutions and post implementation support using Oracle Applications 11i/R12, Oracle10g/9i/8i Developer/2000 (Forms 6i/10g, Reports 6i/10g) and implementation of various database applications under different environments.
- Solution Architect, Global Team Leadership and Management, ability to multi - task monitoring open tickets & tracking results, testing & on time delivery.
- Lead Business Strategy, End-to-End Planning, Change Control, Execution.
- Managed successful ERP end-to-end Implementation, up gradation, Development and production support.
- Expertise in client server, Internet architecture applications development using Oracle10g/9i/8i/, PL/SQL, SQL* Plus, SQL *Loader, and PL/SQL's UTL file, Stored Procedures, Triggers, Functions, Packages and Developer 2000 (Forms 6i/10g, Reports 6i/10g).
- Experience includes developing Interface/Conversion Programs for migrating data from non-oracle and oracle systems to Oracle 11i/R12 Oracle eBS Applications, development and customize of Reports, Procedures, Functions and Packages using PL/SQL.
- Expert on Oracle Applications 11i/R12 experience includes AP, GL, AR, FA, CM, PA, PO, OM and INV modules.
- Good Knowledge on Oracle Applications 11i/R12 Functional in Finance modules with AME Approval Process.
- Expert on third party tools which are integrated to eBS like REVPRO, SABRIX, IPM, Concur and EDI XML GATEWAY.
- Expert in Data Conversion, Data Mapping & Data Extraction.
- Experience in System analysis, design, development, documentation, testing, user, technical support and maintenance of information systems
- Expert on extracting data from Legacy Systems to Oracle Applications modules
- Expert on XML Publisher and Oracle Discoverer Reports.
- Expert on Forms Personalization, Oracle Workflow.
- Good Knowledge on OAF.
TECHNICAL SKILLS:
Operating System: Windows NT, Windows 2000/XP and Windows7 and UNIX
Environment: Oracle Applications R12/11i
Database: Oracle 11g/10g/9i/ and 8i
Tools: SQL* Loader, SQL* Plus, TOAD, Kintana (ECMS), PVCS, Putty, Winscp3. XML Publisher, Discoverer, Forms6i/10g, Reports6i/10g, Workflow Builder, RevPro, Sabrix, IPM, Concur and EDI XML Gateway
Languages: SQL, PL/SQL, C, C++, Java and UNIX Shell Script.
Other: Mercury Quality Center, Clearcase Remote Client and Perforce
PROFESSIONAL EXPERIENCE:
Confidential, Mountain View/CA
Techno Functional Lead in Finance
Responsibilities:
- Developed REVPRO adaptor code to integration between REVPRO and Oracle eBS.
- Involved in development of SABRIX adaptor code to integration between SABRIX and Oracle eBS.
- Involved configuration of XML Gateway to integrate to Oracle eBS.
- Handling - Oracle E-Business Suite, AMS Projects and preparing documentation for R12 Upgrade.
- Responsible for production support delivery of P1, P2, P3 and P4 Incidents and Requests as per the SLA.
- Working with cross functional teams, internal and external resources and the business to ensure project success.
- Responsible for managing resources, meeting deadlines, achieving key deliverables on time delivery.
- Monitoring Tickets and Development activities of the Team, Estimations, Design document for the Implementation and enhancements, interacting with onsite users for resolving the Incidents and Requests.
- Working with the DBA team for the instance availability/implementations and escalations.
Environment: Oracle eBS Applications R12, Oracle 10g, D2K (Forms 10g & Reports 10g), REVPRO, SABRIX, EDI XML Gateway, TOAD, SQL *Loader, Putty, Winscp3, XML Publisher, Perforce Version Control and Workflow Builder.
Confidential
Enterprise Solutions Architect
Responsibilities:
- Handling - Oracle E-Business Suite, HV, Corp and ASG Projects and preparing documentation for R12 Upgrade.
- Part of R12 new implementation team and responsible for the preparing required docs and reviewing the code.
- Responsible for production support delivery of P1, P2, P3 and P4 Incidents and Requests as per the SLA.
- Working with cross functional teams, internal and external resources and the business to ensure project success.
- Responsible for managing resources, meeting deadlines, achieving key deliverables on time delivery.
- Monitoring Tickets and Development activities of the Team, Estimations, Design document for the Implementation and enhancements, interacting with onsite users for resolving the Incidents and Requests.
- Working with the DBA team for the instance availability/implementations and escalations.
Environment: Oracle eBS Applications 11i/R12, Oracle 9i/10g, D2K (Forms 6i/10g & Reports 6i/10g), TOAD, SQL *Loader, Putty, Winscp3, XML Publisher and Workflow Builder.
Confidential
Sr: Consultant
Responsibilities:
- Worked as a lead and responsible for the application development maintenance and support
- Worked as an On-Site Coordinator as an additional responsibility, on the support tickets raised by the IT / Business
- Developed XML, Discoverer Reports and Custom Reports as per the client requirement.
- Review source code, design and prepare test cases.
- Prepared RCA (Root Cause Analysis) documents
- Preparing Weekly Status Reports and Monthly Project dash board
- Consolidating Weekly Status Report & Time Entry for entire team and sending across to Business.
- Updating Delivery Tracking Sheet
- Technical Design documents (MD070 or DTD) Preparation and Reviewing.
- Co-Ordinating UAT and Release activities.
Environment: Oracle eBS Applications R12, Oracle 10g, D2K(Forms 10g & Reports 10g), TOAD, SQL *Loader, Putty, Winscp3, XML Publisher, Discoverer and Workflow Builder.
Confidential
System Analyst
Responsibilities:
- Involved in Conference calls for faster resolution on some problems and for daily updates on status.
- Responsible for monitoring the issue tracker 24/5 basis and providing the resolution against service request (SR).
- Resolved issues in-time and prepared JDS Uniphase Quality Documents for a deliverable object.
- Development and customization of Forms, Reports, Interfaces and XML Reports.
- Coordinating all the technical walkthroughs between offshore and onsite teams.
- Reviewing incoming technical documents and maintaining all the clarification logs.
Environment: Oracle eBS Applications R12, Oracle 10g, D2K(Forms 10g & Reports 10g), TOAD, SQL *Loader, Putty, WS FTP32, XML Publisher.
Confidential
System Analyst
Responsibilities:
- Worked as a offshore technical team lead and responsible for the coding, testing of custom PL/SQL Packages.
- Developed Interface to Import AR Invoices Information
- Involved in the Interface to Import AR Customers Information
- Developed Post process programs for Client requirement.
- Preparing MD70, TE30 and Client Quality Documents.
- Responsible for creation of the AOL Objects, SQL Files from development instance to prior production instance.
- Prepared Agilent Quality Documents for a deliverable object
- Created Kintana(ECMS) packages for custom objects.
Environment: Oracle eBS Applications 11i, Distribution Module and Financials Modules, Oracle 9i, Reports 6i, Toad and WS FTP32
Confidentia
Sr: Software Engineer
Responsibilities:
- Converted MS Access Queries into PL/SQL Stored procedures and sent the data files to specified server as per business requirement.
- Developed & Customization of Interfaces(Inbound, Outbound)
- Developed Customer Shipped Report in Sql*Plus
- Developed Customer Outbound Interface
- Preparing MD70, TE30 and Client Quality Documents.
- Involved in Conference calls for faster resolution on some problems.
Environment: Oracle eBS Applications 11i (GL, AP and AR): Financial Modules, Oracle 9i, Reports 6i,Toad and WS FTP32
Confidential
Sr: Software Engineer
Responsibilities:
- Developed Interface to Import Deferred Revenue Information.
- Involving the Development of Interface to Import Sales Person Information.
- Developed Interface to Import Unbilled Receivables Information.
- Preparing CV060, TE30 and Client Quality Documents.
- Developed Interface to Import Standard PO Information.
- Developed Interface to Import BPA PO Information
- Developed Post process programs for Client requirement
- Involved in the preparation of Technical design document, Development of PL/SQL scripts for the TD.
- Used Kintana Tool for Code Migration and Clear Case Tool for Version Control
Environment: Software Oracle eBS Applications 11i: Financial Modules (GL, AP and AR), Oracle 9i, Reports 6i,Toad and WS FTP32 OASIS (Oracle Architecture Simplification Integration and Support) Project.
Confidential
Sr: Software Engineer
Responsibilities:
- Developed GL interface to Import the Journals into General Ledger application.
- Converted SQL Queries into PL/SQL Stored procedure for Outbound.
- Preparing MD70, TE30 and Client Quality Documents.
- Involved in Conference calls for faster resolution on some problems..
- Preparing migration document and test script for the given object.
Environment: Oracle eBS Applications 11i: Finance and Distribution Modules (GL, AP and AR), Oracle 9i, Reports 6i, Toad and WS FTP32
Confidential
Software Developer
Responsibilities:
- Developed & Customization of Reports (Oracle Reports, SQL*Plus)
- Writing Procedures, Functions, Packages, Triggers, Cursors and Involving Modules GL, AP and AR
- Revisiting of existing objects code to support for multi organizations
Environment: Oracle eBS Applications 11i Finance Modules (GL, AP and AR), Oracle 9i, Reports 6i, Toad and WS FTP32