SUMMARY

• Seven plus years of IT experience in Oracle Applications 11.5.9, 11.0.3 specializing in Order Management, Account Receivables, Inventory, Shipping GL modules with sound functional and technical knowledge.
• Solid understanding of Sales and Marketing , Manufacturing and finance.
• More than two years of experience working in various capacities as a Project Manager at Wipro Technologies at Sony Electronics.
• Currently managing an engagement of 9M (4.1M onsite + 5M offshore) per annum with team size of 49 consultants.
• Good exposure in Project Management activities including Metrics collection/reporting, Project Scheduling and Phasing, Coordinating Presentations, Managing Tasks, Deliverables and Budgets. Liaising between Users and Consultants to resolve specific or unique business needs. Coordinating Technical Enhancements of Forms, Reports and third party interfacing between Clients, Consultants and Users from different geographical locations like US/Japan/Mexico/India.
• Excellent exposure in Oracle Applications implementation and upgrades spanning across the entire project life cycles, including active participation in Software Evaluation, Business Process reviews and Requirements definition, Unit and Integration Testing, Transition Planning and Documentation, End-user Training and Post-implementation Support.
• Solid Skills in understanding the Business Process flows.
• Excellent working knowledge of the underlying Oracle Applications structures and architecture.
• Excellent knowledge mapping the Business requirements to Technical Specs
• Solid skills in estimating effort to complete tasks and projects.
• A leader in planning, organizing, scheduling, and managing project activities.
• Experience in Performing detailed reviews of current practices and procedures, examining alternatives and implementing solutions within the current system environment
• Experience in PL/SQL Reports , Interfaces , AOL s and APIs
• Excellent Communication, conflict resolving and people management skills.
• Strengths:
• Well rounded management , functional technical expertise in software implementation, consulting, software evaluation and application support
• Ability to deal creatively with complex or ambiguous problems in unfamiliar businesses, to structure current process and to reach sensible conclusions with the available facts in a short time
• Ability for logical reasoning, creativity, quantitative skills, business judgment, pragmatism, and an ability to structure problem solving. Also have an intellectual curiosity and enthusiasm for other issues to be solved.

Ability to learn and implement new software and technologies in a short time.
Discerning eye for seeing the right solution for the client’s process.

SKILLS
Professional Skills:
Project Management, Metrics collection ,Requirements gathering, business process mapping, Technical/functional specifications. Process & Quality Consulting: Exposure to Different Quality Models including 6 Sigma, CMM, PCMM etc. Business Process Reengineering (BPR). Comfortable with AIM (Application implementation methodology).
Oracle Applications: Order Management (Order to Cash), Account Receivables, Inventory, Shipping, GL
Process & Quality Consulting: Exposure to Different Quality Models including 6 Sigma, CMM, PCMM etc. Business Process Reengineering (BPR), Comfortable with AIM (Application implementation methodology)
Operating Systems: UNIX, MS-DOS, Windows 3.1 and Windows95, Windows 2000, Windows XP
Application Packages: MS Word, MS Excel, MS PowerPoint, MS Projects, MS Access,
ERP: Oracle Applications Release 11i / 1103
Dev/ Prod Tools: PL/SQL, Developer 2000, Oracle Reports, FORMS, SQL * LOADER, SQL*Plus, Toad
Databases: Oracle 9i, Oracle 8i
Programming Language: SQL, PL/SQL

EXPERIENCE

Confidential,May 2009 – Present
Client : Confidential,San Diego
Project Manager
Support and maintenance of all Critical applications at Sony . All support engagements within Sony is handled by Wipro technologies in a onsite offshore model with the total team size of 49. Wipro provides support of all Oracle applications with an average of 2400 tickets per month complying to Service level agreement.

Responsibilities

• Project management activities like creating SOW, resource planning, budgeting, and project management
• Managing six different oracle teams within support engagement.
• Managing offshore and onsite team
• Design and drive process improvements and process efficiencies.
• Escalation management, Change management and responsible for support transition

Metrics collection and reporting

• Performed activities for Data consolidation and analysis
• Preparing contingency plans.
• Quality related activities for maintaining project plan and work plan updates
• Ensure SLA commitments, RCA quality
• Prepare stability matrix and monitor the control points along the project scope baselines.
• Single point of contact as Support Lead for the client – Ensure good relationship with the client and leverage the same to enhance further business opportunities for Wipro Technologies, manage complete onsite support team, interface with offshore management

Confidential,San Diego, CA April 2005 –May 2009
Team Lead / Business Analyst

Technology: Oracle Applications 11.5.9, Order Management ( Order to Cash ), Account Receivable, Inventory, Shipping, General Ledger

Project: Sony-Oracle OMS Production Support / Enhancements
Sony Electronics Inc. Sony Electronics Incorporation is world-renowned market leader in TV, games, semiconductors and electronics. The company designs, builds and sells a complete range of computers and peripherals, digital camera, home audio/video, games, handhelds/PDAs, CTVs etc through various retail accounts in the United States and through a mix of owned retail stores, distributors, licensees and subsidiaries worldwide.
Sony has implemented Oracle e-business spanning across Financials, Order management, Manufacturing and Supply Chain Management. Sony also has systems like SAP, DM+, FIB that interact with Oracle applications through customized interfaces. The 24 x 7 Production Support/ Maintenance project for Oracle application aims supporting the existing business including any new enhancement or modifications of programs/reports, identifying the root cause of the bugs, bug fixes, report any technical or functional gaps in existing programs/applications and suggest business process improvements.

Responsibilities:

• Prepare progress report and productivity improvement plans
• Closely coordinate with the business users to understand their requirements and map it to the existing system.
• Mapping the Business requirements to Technical Specs.
• Fixing with day to day issue either due to set up or other user issues.
• Worked with the Project teams closely during up gradation in mapping the current process into the upgraded environment.
• Interact with different users concerned with respective functional areas to proactively identify needs for enhancements/modifications. Documentation of business requirements, creation of project plans for the implementation of enhancements and solutions, and support of modifications in the Production environments.
• Extensive interactions with Warehouse Management System DM+ /EWM for shipping and inventory movements and cycle counting issues.
• Addressing day to day user support calls.
• Manage and provide ongoing analysis for Business Applications.
• Setting up the configurations whenever there is a new business process implementation.
• Ensuring all business issues or process hindrances have been addressed as per the service level agreement
• Provide an estimate and prepare business requirement documentation.
• Involvement in business process analysis, design, planning, implementation, user testing coordination and acceptance, education and training, and all supporting documentation related to project implementations
• Resolving all kinds of functional set up issues spanning from order management, shipping, inventory and Account Receivables.
• Worked on VESTERA address failures.
• Involvement in cycle count reconciliation with the inventory in the system
• Handling month end / Year end and revenue recognition.
• Closely interact with QA/Testing team to ensure System Enhancements do not impact the current production environment
• Handling all Order Management, Inventory, Shipping, Invoicing, Inventory and AR posting issues (B2B and B2C)
• Active involvement in Inventory and AR and GL reconciliations and month end / year end close
• Worked on business process improvements for Sony
• Worked on order import and EDI issues
• Build functional and Technical Design for Interfaces.
• Interface directly with business systems teams, and end-users
• Understanding and Analysis of the Existing Business process, as well as preparing the process Flow of the Business related to all the planning data.
• Performed activities for Data consolidation and analysis
• Also involved in reconciliation and data consolidation
• Worked with Tax ware whenever required to eliminate tax discrepancies in the system and the state tax.
• Individual Performance Progress reporting to Management
• Manage and track all requests from users to ensure timely and proper resolution.
• Monitor and report the progress of assigned tasks and provide guidance to other team members when necessary.
• Provide progress update to the vendor on the estimated deadline.

Confidential, September 2004 – March 2005
Oracle Systems Consultant
Technology: Oracle Applications 11i, Order Management ( Order to Cash ),, Account Receivables, Inventory, Shipping

Project: STN OMS Separation Project-CDW
Sony Electronics EMCSA-ISSA division is implementing a Solution that would separate VAIO and E-Solutions OMS from STN/FIB applications and feed CDW and other peripheral systems directly from Oracle OMS. This is basically a consolidation of all the VAIO and E-Solutions OMS and Financial reporting functions in single ERP system.

Responsibilities:

• Performed requirements gathering from external systems for inventory and sales data.
• Study of current Business Process and Gap Analysis.
• Inventory and Account receivable reconciliation with GL and data consolidation.
• Mapping the business requirements to functional specs
• Troubleshot all functional and technical set up issues ensuring smooth order to cash flow.
• Involvement in Month end close.
• Closely coordinated with the business users to understand the requirement and map it to the existing system.
• Involvement in Design, Development of Interfaces between Legacy System to Oracle Order Entry (Sales Orders/ Customer) and Accounts Receivables (Invoices, Credit and Debit Memos)
• Analyzed the existing business process, finding technical and functional Gaps
• Worked in PL/SQL, Forms, Report Builder, Shell Scripting.
• Tested Plan creation and integration testing
• Responsible for CRP, UAT and Cutover Activities

Confidential,Mumbai ,India

Oracle Technical Consultant
Technology: Oracle Applications 11.5.9 (11i), Order Management ( order to cash ), Account Receivables, Inventory, Shipping

Project: Agilent support and enhancement (worldwide support)
Agilent Technologies Inc. is a global, diversified Technology Company focusing on high-growth markets in the communications, electronics, life sciences and chemical analysis. Agilent has implemented Oracle applications 11.5.9 spanning across Distribution, Manufacturing and Supply Chain Management. Data flows from Siebel through Tibco middleware to oracle applications through customized interfaces.

Responsibilities:

• Worked on order to Cash day to day configuration / set up issues production issues.
• Troubleshoot day to day inventory/Shipping discrepancy and set up issues
• Addressing day to day user support calls.
• Actively coordinated with business users to understand individual concerns and issues about the current system and ensuring the concerns are addressed in timely fashion.
• Provided Adhoc reports based on business needs.
• Extensive interactions with Warehouse Management System DM+ /EWM for shipping and inventory movements
• Worked on cash applications and trouble shoot cash application settlement issues.
• Worked on hand value and aging report , Receivable, Cash Apps reconciliations with GL.
• Worked on having order to cash functional set ups in place before having the business moved from one location to another.
• Working with Auditors to explain the current business flow and providing Justification and ADHOC reports as and when required.
• Worked on Standard Order Import, shipping, inventory Account receivable issues.
• Worked in PL/SQL, Forms. Report Builder, Shell Scripting, Oracle API’s
• Active involvement in study of loopholes within the existing systems and developing a script to have corrective actions.
• Handled all kinds of production support issues including financial reconciliations.
• Involved in Performance tuning of long running jobs in production
• Responsible for acceptable performance of Business Applications.

Confidential,Pune, India June 2003 – February 2004
Oracle Systems Consultant
Technology:Oracle Applications 11.0.03 and 11.5.9 (11i), Order Management ( Order to Cash ), Account Receivables, Inventory, Shipping.

Project: Forbes Marshall Information Management Systems
Forbes marshal is a collaboration of eight companies which runs on Oracle e-business. Project had been implemented by oracle which was further supported by MIS Department within Forbes Marshall.

Responsibilities:

• Addressing day to day user support calls.
• Gathering user requirements for the enhancement projects taken up within the support.
• Handling Day to day Order to Cash set up issues
• Writing Technical Design documents based on the requirement gathered keeping in mind the existing features and the potential future features.
• Performance tuning of long running jobs.
• Tested Plan creation and Integration Testing
• Understanding the potential flaws within the existing system and suggesting the required change.
• Handled day to day Production support set up issues.
• Involvement with QA on enhancement projects to ensure smooth slow of order to cash in production Environment
• Worked as a part of upgrade team with oracle consultants to upgrade all the existing reports to run in 11.5.9 environment from 11.o.3 environment.
• Coordinating with the QA team for helping them out in planning and execution of the QA initiatives across the new release.
• Worked in PL/SQL, Forms. Report Builder, Shell Scripting, Oracle API’s
• Responsible for CRP, UAT and Cutover Activities
• Also involved in reconciliation and data consolidation

Confidential,Mumbai, India April 2002 – December 2002
Oracle Consultant
Project: Management information systems for Central Railways
This Project automated the entire maintenance activities of EMU’s and locomotives. There are two kinds of maintenance activities, namely, scheduled and unscheduled maintenance and the various key processes are symptom identification and resolution.

Role: Product designer / Developer

• Determining the user requirements and limitations of the Project
• Designing and developing prototyping systems
• Writing the design document, Coding, learning new technology like VBA
• Completed the product development well before the planned release date

EDUCATION
B.E (Bachelor of Engineering in Computer Science)