SUMMARY:

• Over 15 years of experience in Project Management, Systems Analyst, Business Process reengineering, application implementation and upgrade. Oracle Application Financial Functional with good knowledge of Oracle HRMS, iRecruitment, depth knowledge of oracle database and toad (sql/plsql). More than ten years of experience in Fortune 500 companies in Oracle E - Business suite (ERP) as System Administrator, Systems Analyst. Application Implementation, support, upgrade, documentation, testing, customization, integration, personalization’s, automation and enhancements in US.
• Expertise in Oracle System Administrator, General Ledger, Accounts Payable, Accounts Receivables, Fixed Assets, System Integration, iExpense, iReceivables, Project Costing, Project Billing, Collections, E-Business Tax .Worked on EBS cycles P2P, O2C & R2R, Oracle Framework, Personalization’s and Human Resource Management System. Worked on MOAC (Multi Organization Access Control), Multiple Legal Entities, secondary ledger and sub ledger accounting.
• Worked on Interface Design, Conversion Projects related to GL (General Ledger), AR (Accounts Receivables, AP (Accounts Payables), FA (Fixed Assets), Project Billing, Project Costing and ebTax.
• Extensive experience of full life cycle implementation including gathering requirements, fit & gap analysis, design, configuration, CRP, UAT (User acceptance testing), user training, documentation, development and production support. AIM methodology used for documentation (BR100, MD50, MD70, TE40). Extensive knowledge of SQL, PL/SQL, toad.
• Performed data conversions from legacy systems to Oracle applications AR, GL, AP, FA like invoice conversions, receipt conversions, asset conversions, supplier conversion, customer conversion, item conversion, month-end closing and financial year closing support.
• Managed Discoverer Administrator and reports on various platforms discoverer, FSG, Web ADI, Report Manager and SQL reporting. Generated MIS reports for end users and top management.
• Participated in internal and external audits, SOX reporting, provided the required data to the auditors. Track the data changes.

TECHNICAL SKILLS:

Operating Systems: Windows 365, AIX 7.1, Windows 7 / 2000 / XP/ 98 / 95, Window NT with SP-6, NT workstation 4, Novell 4.0, UNIX, Linux, Sun-Solaris.

Applications: Oracle E-Business Suit R12.1.3, 11i (11.5.10.C.U.2, 11.5.9, 11.5.8),(AR, AP, GL, CM, FA, Sys Admin, OM, PO, Purchasing, iExpenses, iReceivables),Discoverer 11G, Discoverer9i, C-Series (Bottomline Technologies), Manhattan, PVCS(Serena), FACT. Dataloader, Sharepoint, MS Visio, MS Powerpoint, Clarizen.

Development: TOAD 9.7, SQL / PLSQL, Forms 6i, Reports 6i, Developer 2000, Visual Basic 6.0, Snagit.

RBMS & DBMS: Oracle Database 11.2.0.4 on AIX 7.1. Oracle database 11i / 9i / 8i, MS Access, Foxpro.

PROFESSIONAL EXPERIENCE:

Sr. Systems Analyst

Confidential,Madison, NJ

Responsibilities:

• Started as Systems Analyst and then promoted to Sr. Systems Analyst in 2013.
• Manage multiple applications as an administrator including Oracle Financials, C-Series(Bottomline Technologies), Manhattan, Hyperion Servers, PVCS. (Serena), Clarizen, Sharepoint.
• Participated in Oracle ERP upgrade from 11.5.8 to R12.1. Created test plan and test cases to utilized in end to end system, conference room pilot (CRP) and user acceptance testing (UAT) to insure application functionality, accuracy and reliability.
• Implemented lots of small projects with full life cycle implementation in oracle financials for System Administrator, GL, AR, AP, FA, CM and PA modules for business stakeholders. Manages AIMS documentation BR100, MD50, MD70, user training documents and post implementation user support.
• Worked with the development team to research on Metalink, log SRs and resolve outstanding software issues related to latest patch set or any other application issues. Manage user training and functional documentation. Managed disaster recovery testing for the IT team.
• Manage Discoverer Administrator, FSG Reports, Web ADI reports and Report Manager reporting for users and management. Primary resource for production support and month End / year end closing.
• Experience in Gap Analysis, analyzed, resolved deficiencies in the business process, reconciliation process for receipts, deliveries, and invoice matches with the general ledger.
• Project Management includes System Analysis, Oracle System Administration, Oracle Financial Accounting Implementation (GL, FA, AP, AR, PA and CM), Setups, Subledger accounting, Secondary Ledger, custom development. Managed quarterly regression testing, production support, user training, user acceptance, support month-end closing and financial year closing support. Integrated financial accounting software for all departments including (GL, AR, AP, iRecevables, iExpenses, FA, PA and CM) e.g. WAX, C-Series, Manhattan, also generated MIS reports for top management and for end users. Off peak management support for critical issues.
• Lead the consulting projects for multi-ledger, multi-currency implementations, upgrades and customizations. Successfully utilized standard AIM methodologies with SDLC (Software development life cycle.
• System Administrator: Create or update responsibilities, Users, profile options, Security rules, key and descriptive flex fields, values and value sets, Build or update menus, functions, concurrent programs and requests, application setups, HRMS, organizations.
• GL (General Ledger): Chart of Account Structure, KFF, DFF Accounting Flex Field, Parent Child relationships, Cross Validation Rules, Value Sets, Security Rules, SOB, Profile Options, Journal Sources, Consolidation Setups, Calendar, FSG report setups, Daily / Monthly rates, Journals, recurring journals, approvals, mass allocations, Import, posting, reversing, budget, create accounting, multi-currency processing, Designed the Year and Month end process to be followed before closing in General Ledger. Accounting Setup Manager.
• Subledger Accounting (SLA): Accounting configurations, accounting program, journal entry setup, subledger journal entries, subledger accounting, subledger balances.
• FA (Fixed Assets): Setups Multiple Organizations, Book Controls with multiple ledgers, Asset Tax Book, Asset Categories, Location Flex fields and Values, Asset Keys, Additional Fiscal Years, Profile Options, Creating Mass Additions, Posting Mass Additions, CIP Assets, Full Asset Retirement Setup, Partial Asset Retirement Setup, Depreciation Method Setups and successfully Created the Journal Entries, and posted Journal Entries in GL. Using Web ADI for asset additions, transfers. Reclassifying assets. Reconciliation reports, CIP Reports, Adjustment Reports etc. Using API’s for additions, adjustments, CIP, deletion, retirement and reinstatements.
• AR (Account Receivables ): Setups for TCA Architecture, Customer Profiles, System Options, TAX Codes, Sales Tax rates, Transaction Types, Sources, Accounting Rules, Auto Accounting Rules, Auto Invoice Line Ordering Rules, Grouping Rules, Receipt Sources, Receipt Classes, Banks, Bank Charges, Lock Boxes, Transmission Formats, Collectors, Aging Buckets.
• AP (Accounts Payable): Setup like Payment Terms, Hold and Release Names, Period Types, Periods, AP Accounting periods, TAX Codes, Tax Reporting Entities, Financial and Payable Options, Banks, Lookup Codes for Payables, purchasing. Distribution sets, Supplier, Supplier Bank, Internal Bank, Payment Format & Interest Rates. Created Invoices and Batch Invoice templates, Recurring Invoices Expense Report. Created Payments and Batch Payment templates. Transfer to General Ledger. Providing Training to the end user.
• Developed detailed design specifications for software development for technical teams. Configured applications to meet system requirements identified by stakeholders to obtain required system functionality. E xperience with client interaction, adherence to client specifications, system enhancements, understand business data flow, data relations and production system support.
• Expert in Creating Training Plans, Developing Training Documentation and provide user Training.
• Managed C-Series (Bottomline Technologies) application linked with oracle accounts payable module as a system administrator, created new user accounts, security of the accounts, transaction monitoring and resolve user problems.
• Responsible for System Administration for Manhattan application (Lease Management). Participated in system setups, user administration, user support and resolved issues between interface from oracle to Manhattan application.
• Administrator for Hyperion Server, support users.

Oracle APPS Functional Consultant

Confidential, Phoenix, AZ

• Worked as Functional Consultant (Team Lead) for Oracle 11i Accounts Receivable, General Ledger, Cash Management and iReceivables for Multi Org and Multi Currency Implementation.
• Managing client management and users and guiding technical team.
• Preparing various AIMS documents like BR100 and MD50.
• Gathering Business process information from client, designing analytical business flow, specializing in Oracle Financials Full Life Cycle Implementation, Rollout, Post Go-Live / Post Implementation Support, month-end closing, CRP, UAT, end user training and as Lead on business process analyst related to Oracle General Ledger, Accounts Receivables, iReceivables and Cash Management.
• GL (General Ledger): Implemented GL Setups like Chart of Account Structure, Accounting Flex Field, Cross Validation Rules, Value Sets, Security Rules, SOB, Profile Options, Journal Sources, Consolidation Setups, Calendar, FSG's, Designed the Year and Month end process to be followed before closing them in General Ledger etc.
• AR (Accounts Receivables): Defining Setups, Designing Invoices, Document Sequences, Transaction Source, Transaction Types, Receipt Class, Receipt Sources, Payment Methods, Customer Profile, Payment Terms, Define DFF for invoices, Customer Conversion. customer Interface. Auto Invoice, Auto Lock Box. Customized standard reports such as the Invoice printing (BPA) Report, aging bucket report, consolidated billing report and Credit snapshot report, Invoice Printing thru BPA.
• AP (Accounts Payable): Setup like Payment Terms, Hold and Release Names, Period Types, Periods, AP Accounting periods, TAX Codes, Tax Reporting Entities, Financial and Payable Options, Banks, Lookup Codes for Payables, purchasing. Distribution sets, Supplier, Supplier Bank, Internal Bank, Payment Format & Interest Rates. Created Invoices and Batch Invoice templates, Recurring Invoices Expense Report. Created Payments and Batch Payment templates. Transfer to General Ledger. Providing Training to the end user.
• Prepared CRP, UAT documentation, conducted user acceptance testing, completed proof of concept demonstrations.
• Wrote MD50 (Functional Specification), MD70 (Technical Specification) Documents for loading AR Invoices, Customers from Legacy System.
• Designed and Directed the Technical Team for developing Conversion routines, Staging Tables, Custom PL/SQL API to load external AR Invoices, Customers using TCA Architecture from legacy system using SQL*Loader into Auto Invoice Interface Tables.
• Worked with the development team to research Metalink, log SRs and resolve outstanding software issues related to latest patch set
• Provided production support and worked closely with end-users and with DBA team during development, testing, migration, upgradation and production deployments.

Functional Consultant / EDP Officer

Confidential

• Preparation of Gap Analysis documents and preparation of Setup Documents (BR100).
• Implemented order to cash modules (GL, OM (Order Management), AR, CM.
• Managed GL Setups, Chart of Account, Key and Descriptive Flex Fields, Cross Validation Rules, Value Sets, Security Rules, SOB, Profile Options, Journal Sources, Consolidation, Calendar etc.
• Managed AR (Account Receivables) Setups for TCA Architecture, DQM (Data Quality Management).
• Implemented FA (Fixed Assets) Setups for asset category, Location Flexfields and values, asset keys, profile options, mass Additions, asset retirement setup, depreciation. Successfully transferred and posted journal entries in GL.
• OM (Oracle Order Management/Pricing, Shipping): Setups for Document Categories, Document Sequences, Parameters, Transaction Types, Quick Codes, Credit Check Rules, Credit Profiles, Payment Terms, Price Lists, Pricing Agreements, Modifiers, Shipping Parameters, Freight Carriers, Shipment Transit Times, Pick Slip Grouping Rules, Release sequence rules and Successfully created Orders, Attached pricelists, Pick released, Ship confirmed and transferred Order Information into Account Receivables (AR).
• Involved in Troubleshooting with the Issues in Financial Modules while supporting Finance users, troubleshooting various issues relating to performing the month end and quarter close.
• Training super users and users and Preparing User Manuals for the Different levels of Management hierarchy.

System Administrator / Consultant

Confidential

• Responsible for Oracle Application worked as Functional consultant, Administrator of Application Server, Stand-by Server on Windows 2000.
• Created responsibilities, request groups, menus, values sets, request sets, forms, functions thru System Administrator. Gathered business requirements, mapping key elements from native system, re-engineering business processes to match native system functionality, Created functional specifications, customizations business process, managed CRP (conference room pilot) sessions, system testing and validate data with the legacy system.
• Created PL/SQL and SQL, data loader scripts as a part of conversion process to extract the legacy data from existing applications and loaded them into Oracle Database tables. Converted the entire customer Addresses, contacts, phones, relationships. Interacted with end users and functional architects for mapping the legacy data. Upgrade Forms and Reports 4.5 to 6i. Involved in registration of concurrent programs, executables.
• Generate Interfaces forms and reports for both existing and new functionality. Implementation of the Accounts Receivables, Accounts Payables and General Ledger . Dealing with Vendors, resolving their problems and providing required reports by using Forms & Reports 6i.
• Monthly period close procedures for Oracle GL, AR and AP modules. GL Audit Schedules, Alerts (Event / Periodic) through Exceptions reporting.

Executive Systems

Confidential

• Managed ERP software for all departments including Purchase, Store, Marketing, Sales and Accounts. A Separate module also builds for HR department. Database Administration (Oracle 8.0/8i), Installation and Connectivity of database with clients, Database maintenance & Backups etc. Implementation of Integrated Software developed in Visual Basic 6.0 as front end and Oracle 8 / 8i as back end. Developed a new Application for Fixed Assets Computation in VB 6 and MS-Access, troubleshooting issues and manage backups.
• Administrator of Mail Services (Giftmail), Internet (Communication on net, Web site Development, maintenance. System Setup, Integration & Troubleshooting.
• Implemented Financial Accounting software (GL, AR, AP, CM, PO, OM, FA) Creation of General Ledger, Accounts Payables, Accounts Receivables, Order Management, Inventory, PO, User training, maintenance and troubleshooting user problem solutions, Integration of External reports. Backup and recovery and restoration of the application software, Administration of the in-house build software’s, manage user rights, user maintenance, approval limits, desktop designing, Security Grouping, Security rights and Audit trail. Designed and coded the front-end of database application GUIs for production and R&D using Oracle Developer2000, Oracle Report, Oracle Form, Oracle SQL*PLUS, PL/SQL, Visual Basic6.0, Access, and Excel that greatly increased the efficiencies of production and R&D.

Financial System Consultant

Confidential

• Financial Consultant and System Analyst for new and existing Customers.
• Managed more than 40 big and small companies, providing accounting solutions with system support for entire northern India for international business accounting software FACT (ERP software of Vedika Software Pvt Ltd, Kolkata)
• Independently handled FACT application implementations with full life cycle, system analysis, system setups and configurations.
• Managed Trading, Profit & Loss account and Balance sheets. Month end and year end support for closing accounts for various clients.
• Managed ERP Software, FACT (Business Accounting Software) Implemented GL, AR, AP, PO, OM, FA, INV, MIS. Troubleshooting the application and provide training to end-users. Maintain Backups. Integrate with all the departments, Sales, Store, Purchase, Accounts and MIS. Handle System Administration independently.
• Setup the companies, branch offices, Chart of Accounts, General Ledger, Accounts Receivables, Accounts Payables, Inventory, Cash and Bank Management, Purchase Orders, Order Management, and Inventory also complete the Year Ending process with carry forward the previous year’s balances of GL, AR and AP to next year and Adjustment of Accounts.
• Responsible for installation, upgrades, patches, support, database tuning, cloning and administrator functions. Duties included database tuning/reorganization, SQL statement tuning, backup/recovery, general troubleshooting. Specific Applications modules installed include AP, GL, AR, FA, PO, OM, CM and Procurement.