SUMMARY

• Strong Knowledge of SDLC concepts and Oracle AIM methodology
• Team Leader with TEMP effective team - building and business analyst capabilities like gathering requirements, estimating, planning deliverables, preparing test plans, demonstrating oracle applications for CRP
• Thorough understanding Oracle Applications Architecture and its migration, enhancement by release/revision. Able to analyze business requirement and approach proper solutions with giving in details Pros and Cons analysis from both processes and technical point of view.
• Production support experience following ITIL Standards in Incident Management, Change Management, Demand Management
• Proficient in developing (RICEW) BI reports, interfaces, conversions, extensions, workflows, form customizations, form personalization, Fusion Reports (Oracle BI Reports), Fusion Page Customization
• Customer Onsite Experience in halping them with their issues during day-to-day operations and providing specific trainings for ease of using Oracle Applications
• Experienced in project life cycles in industries like Banking, Energy, Manufacturing, Retail, Travel
• Have Canadian PR Status and authorized to work with any employer. Willing to relocate.

TECHNICAL SKILLS

Programming Languages: SQL, PLSQL, Unix Shell Scripting, OAF, ADF

Development Tools: Oracle Forms, Reports, Discoverer, BI Publisher (XML), Oracle JDeveloper, Oracle Workflow, Oracle Business Intelligence Reports (Fusion Reports)

Functional Knowledge: Receivables (AR), Payables (AP), General Ledger (GL), Subledger Accounting (SLA), Cash Management (CM), Project Accounting (PA), Purchasing (PO), Inventory (INV), iSupplier, iProcurement, iExpenses, Order Management (OM), Shipping (WSH)

PROFESSIONAL EXPERIENCE

Confidential

Onsite Support Lead Analyst

Responsibilities:

• Lead Analyst for Oracle Finance, Purchasing, Order Management and Shipping functions
• Interact with the business users and IT Team in order to understand business requirements and negotiate delivery schedules
• Plan, design Enhancements, Data Conversion, Customization and Localization (CEMLIs)
• Support the users to complete the Period Close procedures within the short timeline and in a very TEMPeffective manner
• Develop ad-hoc reports and data extracts to meet one-time or continuing business needs using available tools (Oracle Discoverer, BI Publisher)
• Install latest RPC patch collection to keep code up to date without breaking custom functions
• Provide QA services and regression testing for all applicable Oracle EBS patches and upgrades
• Implement Oracle Applications for MKS sites in Colorado, China and Japan
• Participate with Internal and External (PwC) audit teams and implement changes to be SOX complaint
• Implemented Journals Approval Workflow, Period Close Dashboard, Bofa Daily FX rates interface, Dunning Process, Japan tax implementation

Confidential

Technical Consultant

Responsibilities:

• Designed and Developed Ultipro to Oracle Core HR interfaces like Employees, Assignment Changes
• Provide go live support and fix all issues reported

Confidential

Technical Lead

Responsibilities:

• Analyze existing outbound interfaces to DW and create AS-IS and TO-BE documents
• Estimate and provide delivery plan with clear timelines on different phases of development, testing and installation
• Design Sales, Product, Customer, Region, Receipt, Vendor, Stock On Hand, Address ETL interfaces
• Track teams deliverables and provide status report on delivery milestones to client on bi-weekly basis
• Provide Knowledge Transfer to production support team

Confidential

Technical Analyst

Responsibilities:

• Upgrade Oracle EBS from R12.1.1 to R12.1.3
• Impact Analysis for custom objects and process and document changes
• Prepare cut over plan and provide go-live support

Confidential

Support Analyst

Responsibilities:

• Support and maintain Production instances for multiple clients like Confidential, RoyalJet
• Identify improvement areas and demo proof of concept to client on monthly basis
• Designed and Developed Salesrep and Customer relationship process which halped business in calculating correct commissions for sales representatives (Nufarm)
• Fixed bugs in vacation bonus calculation fast formula and halped business pay bonus on time (RoyalJet)

Confidential

Technical Lead

Responsibilities:

• Create Technical Specification documents (MD070) for Customization of GPA to impose service tax and various Sale Agreement reports for their multiple real-estate sites.
• Lead the development and testing of custom packages and reports with in tight schedule due to Finance Year close (Mar-13 in India)
• GPA customization TEMPhas halped IREO in calculating correct service tax while customer makes changes/cancellations to their property units

Confidential

Technical Lead

Responsibilities:

• Track team’s deliverables and report status to client weekly
• Create unit test and user test documents and conduct unit testing of all component with team members
• Track any bugs reported during the testing process fix them
• Get the QA approval and create installation documents for all deliverables

Confidential

Team Lead

Responsibilities:

• Present service delivery report to client on a monthly basis as Accounting Support Team Lead
• Help users in reconciling data from sub ledgers with GL during Month End Close
• Implemented KEDB and created a knowledge repository with resolution documents for reducing resolution time for repetitive incidents/requests
• Maintain Purchasing module setups involving approval hierarchies, Buyers, Employees as per changes in Business Reporting structure
• Track team’s vacation plans and make necessary arrangements for delivery of change requests and enhancements

Confidential

Developer

Responsibilities:

• Modified Suppliers, Supplier Sites, Contacts and Banks Import and Validations Program for Confidential Rollout
• Oracle Custom Form -Proof of Concept for checking duplicates while entering data in a detail block firing triggers to notify user.