SUMMARY:

• 16+ years of experience in business analysis and ERP systems implementation
• Strong Project Management and Implementation experience with Oracle Applications (Inventory, Cost Accounting, General Ledger, Fixed Assets, Accounts Receivables, Accounts Payables, Order Management and Purchasing modules) and PeopleSoft Payroll
• Has Managed a team of Business Analysts and Developers as part of Project Management and Implementation
• Performed the role of Functional Lead for various Oracle Application modules and PeopleSoft Payroll
• Has design, implementation and support experience in functional and technical areas of Oracle Financials and Financial Analysis
• Proficient in all phases of Project Implementation including initiation, analysis, design, testing, quality assurance, scheduling, documentation and support
• Hands on experience in project planning, coordination and issue resolution
• Adept at acquiring new technical skills and implementing them in optimum time to achieve business goals

TECHNICAL SKILLS:

ERP: Oracle Financials 11i & R12, OBIEE, People

Soft Payroll: GL, FA, AR, AP, OM INV, PO, Alerts and ADI

RDBMS: Oracle

Languages: SQL, P/L SQL

Others: HPQC, SharePoint, Documentum, Discoverer, DBI, UA Solution Delivery Methodology

PROFESSIONAL EXPERIENCE:

Project Manager

Confidential, Chicago, IL

Responsibilities:

• Managed the project from Initiation to close out
• Managed the budget for the project
• Provided timely status to project board on issues and risks
• Led System Integrator through every phase of the project
• Managed and provided direction to the team of United developers on the detailed design
• Prepared and reviewed several Functional and Technical Specification documents
• Worked closely with Business user through the entire project to ensure the timelines, requirements and cost was met

Lead Business Analyst

Confidential, Chicago, IL

Environment: Oracle Cost Accounting, Oracle Inventory, Cost Management - SLA, Oracle AP, Oracle Business Intelligence (OBIEE), PeopleSoft Payroll, HPQC, SharePoint, Documentum

Responsibilities:

• Prepared an in-depth analysis of how current state legacy systems worked.
• Identified Pain points and prepared detailed Requirements in Legacy cost accounting systems
• Led System Integrator through every phase of the project
• Managed and provided direction to the team of United developers on the detailed design
• Prepared and reviewed several Functional and Technical Specification documents
• Worked closely with Business user through the entire project by conducting requirements and design, sessions
• Managed the SIT and UAT phase
• Prepared business requirements for the full process.
• Designed the Oracle AP garnishment process and the integration with PeopleSoft Payroll.
• Designed Oracle AP invoice number to help keep track of the all invoices and payments between 2 applications
• Designed the integration of Oracle AP Vendor and PeopleSoft Vendor combination
• Worked closely with to developer to build the interface
• Led the team on SIT and UAT testing for this process
• Performed in-depth testing of the Oracle AP invoices import and Garnishment interface from PeopleSoft
• Performed post production support to the Oracle AP Invoice and Vendor Setup process
• Identified and implemented process improvements for this process
• Developed over 500 requirements based on the current state
• Co-ordinated various Configuration and Business Process Design sessions for PeopleSoft Payroll
• Designed multiple custom components for PeopleSoft Payroll
• Reviewed and Prepared multiple Functional Specification Design documents including for Oracle AP and PeopleSoft Payroll
• Conducted multiple Proposed Design Session Reviews with Business and Technical users
• Worked closely with Developers in order to clarify Business Requirements and Finalized Design
• Led the project team in configuration of PeopleSoft Payroll
• Defined processes to ensure all configuration requests are met
• Prepared Detailed and High Level test cases
• Conducted multiple phases of System Integrated testing
• Performed rigorous System Integrated Testing of custom and default PeopleSoft Components
• Reduced customization by streamlining exceptions to Business Processes
• Provided Increased ownership to Business by not hard coding values in custom modules
• Extensively used tools like HPQC and SharePoint in order to maintain and track project related documents
• Provided guidance and direction to various project members on multiple occasions throughout the project

Senior Business Analyst

Confidential, Chicago, IL

Responsibilities:

• Conducted detailed current state user interviews with business users
• Conducted detailed process flow review sessions with business users
• Prepared detailed Business Process documents using MS Visio and MS Word to document current state processes
• Identified and provided direction on immediate Business Process Improvements
• Provided direction and guidance to the team on preparing process flows using MS Visio
• Prepared Business case to assess introducing P-cards
• Prepared Project plan to track progress
• Reviewed and provided input into System Integrator Work Order
• Prepared Receivables Concept Phase Project Plan
• Conducted high level current state user interviews
• Identified and documented application interfaces into B2C module
• Identified Cost Saving opportunities with the implementation of B2C module

Senior Business Analyst

Confidential, Chicago, IL

Environment: Oracle Financials11i GL, Discoverer, DBI, UA Solution Delivery Methodology

Responsibilities:

• Performed the role of a Senior Business Analyst between System Integrators and Business Users
• Conducted Current state user interviews and requirements gathering sessions with business users
• Worked with Sox consultants and internal auditors to ensure the implemented application is Sarbanes Oxley and internal audit compliant
• Prepared multiple Business Process documents to document current and future state Oracle processes
• Conducted and Performed Fit Gap Analysis between Business Requirements and the Oracle GL with Business Users
• Minimized Oracle GL customization by changing business processes
• Conducted Business Impact Analysis between current state and future state
• Configured Oracle GL (Journal Sources, Categories, Calendar, FSG reports, Journal Approval Limits etc.)
• Performed System Integration testing and Conducted User Acceptance Testing for Oracle Report Manager and Discoverer
• Led the team to conduct Data Conversions
• Designed usage of Report Manager for Business Users
• Conducted Sessions on Discoverer Reporting, FSGs, Oracle Report Manager and Oracle GL Standard Reports
• Provided Post Production Support to Business Users

Oracle Applications Lead

Confidential, Chicago, IL

Environment: Oracle Financials11i (GL, AP, AR, FA, OM, INV, PO), Oracle 8i

Responsibilities:

• Taking Profit and Loss report and Balance Sheet as the base identified the source for each account code combination as it stands on this date and the link between each other. For a particular sales channel, identified the receivables, revenue, tax, freight, cost of goods sold, liability, cash, returns, cost of returns, accounts, account code combinations and link between each of these at each stage
• As part of this process, also re-directed sales and COGS accounts to different accounts in order to have only one channel’s income / expense in one account code combination
• Have setup number of alerts, both event and periodic alerts to notify the management on the issues and errors that occur on a daily basis. This has enabled the users to take timely resolution on various day to day issues. Some of alerts setup were; AR Interface Errors, AP Interface Errors, Cost Manager Failure errors, Aging Credit Memo Refunds and Automatic Receipts and Remittance failures. Also, provide periodic on the alert setup to the ERP team
• Have spearheaded the entire period closing process for all the modules which includes closing periods till date and the users on future closings, documenting and supporting users on month end procedures. The current books had periods open from 2002 for AR, INV, PO and GL modules
• With given complexity of 3 set of books periods that need to be closed, conducted an extensive research and with the clear understanding of the current books and users requirements, closed all the old periods and provided step by step process that needs to be followed for each sub-ledger
• Filed number of service requests with Oracle Metalink and resolved numerous issues. As part of this, also involves in issue diagnosis to provide Oracle Support with required documentation
• Have provided to the users on a number of critical issues and did setup to eliminate cumbersome processing
• Have provided the ERP team with on number of Oracle Applications Functional/ Accounting setup issues
• Have designed accounting setup for various projects
• Have setup number of system administrator functions like created responsibilities to support the new books, Creating sequences, and updated concurrent programs to resolve number of production issues
• As part of the credit card processing, supported the CyberSource product ‘Paylinx’ on the windows server

Software Consultant

Confidential, Stamford, CT

Environment: Oracle Financials11i (GL, AP, AR, FA and CM), Oracle Discoverer 9.1

Responsibilities:

• Reviewed verified and modified client’s requirement definition documents.
• Designed preliminary Business Processes documents for General Ledger.
• Designed Chart of Accounts, Cross Validation Rules, Summary Accounts and Suspense Accounts.
• Designed Standard Journal Entries, Mass Allocation Journals.
• Defined Budget and Budget Organization, Master & Detail Budget, Consolidation and Mapping Rules and Financial Statement Generator (FSG).
• Performed in-house End User on General Ledger.
• Assisted G/L manager with month end closing and prepared financial reports for management.
• Imported purchase order information into payables, defined quickcodes both for payables and employee, also, defined invoice tolerance limits and conducted testing of Expense reports as well.
• Conducted testing of transfer of data from AP to GL.
• Set up of Oracle Receivables, Imported Invoices from Legacy systems using Auto Invoicing, Imported AR data to GL module and created reports.
• Defined business processes for Oracle Receivable Configured AR according to client business requirement. Assisted in setting up Auto Accounting.
• Created and trained the usage of dunning letters in the AR module to follow up with the customer.
• Designed Flexfield for Asset Categories, Location and Descriptive Flexfield.
• Setup bank reconciliation process for payments and receipts
• Defined cash forecast report, using cash management forecasting functionality

  Has created a business area, so that the Discoverer desktop users could have access to information pertaining to their department.

• Has conducted sessions for the users on Discoverer Desktop.
• Assisted the company in creating dimensions and designing the hierarchies associated with the dimension values.
• Conducted sessions for the Budget workstation users.

Systems Analyst

Confidential

Environment: Oracle Forms 4.5 and Reports 4.5

Responsibilities:

• Involved in problem analysis and generated requirements specification.
• Used data modeling and designed key database tables.
• Eliminated various redundant processes and forms to ensure faster responses to customers, in-turn improve employee productivity.
• Designed and implemented forms and reports required for the system.
• Conducted unit testing and system testing for the developed system.
• Generated design, implementation and testing documents.
• Problem incidence report - Tracking report used by operations, marketing and collection units to prevent recurrence of customer problem incidence.
• Problem resolution report - Report used by service and marketing units to identify the satisfaction levels of customers.
• Timely resolution report - Report used by service unit to know the efficiency and effectiveness in resolving a query.
• Was part of the Team constituted by Citibank to increase the Satisfaction scores of its credit card customers.
• Consistently delivered the resolutions of all issues with specific attention to turnarounds, accuracy and controls with consistent focus on reducing the unit costs.
• Was responsible for managing and maintaining cross functional interface with Departments such as Operations, Quality, Sales, Marketing, Phone Banking, Technology, and Financial control to ensure consistent and seamless delivery of Service to the customers.
• Have led various process changes to improve response to customer and maximize customer responsiveness.

Financial Analyst

Confidential

Responsibilities:

• Calculated the operating cycle of the steel company taking into consideration the time it takes to convert raw materials into finished goods.
• Calculated the operating cost required before getting money from the customers depending on the operating cycle.
• Analyzed the company’s five years financial statements and calculated the financial and liquidity ratios.
• Evaluated the loan amount that a bank will lend for a short-term liability and estimated the amount that the company should have to fulfill the gap.