Management Oracle

Parag Agrawal

**** *** ******** ***, ****** CA **568 Phone: 510-***-****, 925-829-

5822(h) e-mail: abikfn@r.postjobfree.com

Summary

Creative, results-oriented team member with 15+ years of experience

leading strong teams and solving complex business problems. Strong

skills in: project management; professional services; partner

management, vendor and customer ; contract negotiation, release

management; qa; application administration; producing results under

ISO and six sigma standards; product life-cycle methodologies;

technical writing.

Extensive experience in both product development and deployment.

Demonstrated ability to organize, motivate, and communicate with

groups and individuals at all levels in an organization. Managed

professional services and application admin teams.

Establish and implement strategy, policies, procedures and

technologies to software and infrastructure in order to improve

efficiency, reliability and performance. Ability to effectively

prioritize and execute tasks in a high-pressure environment. Well

conversant with Oracle Distribution, Mfg and Financials modules and

their interfaces. Functional and Technical understanding of Oracle

Applications. Understanding/Analyzing complex business processes and

configuring them to Oracle ERP applications

TECHNICAL SKILLS

Business Oracle ERP Release 10.7,11.03 11i

Applications (11.5.10), R12

Oracle SOA Suite, Oracle Accelarator

Application Oracle Distribution ( OE,

Modules OM,SHIPPING,PO,Advance Pricing)

Oracle CRM ( Service Contracts,Install

Base)

Oracle

Manufacturing(INV,COSTING,BOM,WIP,SCM)

and their interfaces, Oracle Financials

(AP,AR,GL) SAP (PP),

Siebel e-business applications (6x / 7x),

Service Procurement Management (SPM)Elance

3x/4.x/5x, Clarity 4x, Ariba Buyer, SAP

R/3

RDBMS Oracle 7.x, 8.1.3, 9i,10g, DB2 UDB, MSSQL

2000, My SQL

Operating systems SUN Solaris and HP UNIX, Windows

98/2000/XP/NT, Linux

Tools SQL,PL/SQL,Reports2.5/6i,10g Forms

4.5/6i,10g SQL*Loader, QTP, Test director,

Perforce, Clear case, Bugzilla, Alcea,

Mantis bug tracking systems, Twiki,

sharepoint.

Professional Experience

Senior Business Systems Analyst (Team Lead & PM - Techno functional),

Art.com USA, July 08- Present

As member of PMO team reporting to CTO responsible for IPO

preparedness initiative. One of the key stakeholder for ERP

implementation and responsible for its successful launch. Working very

closely with CFO on market research, investment banking, and industry

analysts on Pre-IPO tasks. Art.com Inc. is a leading authority in wall

d cor and the world's largest online retailer of posters, prints, and

framed art. It offers selection of wall d cor products with over 5

million items. It also provides professional custom framing and

mounting services. It has helped more than 8 million customers in over

200 countries decorate their walls.

. Responsible for estimates, management and tracking of IT labor,

expense and capital budgets Support business and IT initiatives as

planned and achieve cost savings wherever possible. .

. Point of contact between business and technology team to identify

current process, future roadmap and performing Gap Analysis. Owner

of CRPs, resource schedule, test scripts following AIM methodology.

Delivering Corporate Project Portfolio on budget, on time, on scope

with matured communication vehicle and artifacts. With motto of

faster and better, putting RACI, RAP and other Project management

methodology in place.

. Performed on-going due-diligence on vendor/partner services,

monitor the adherence to the contractual SLAs and SLOs, and on-

going service delivery. Created vendor selection framework to

use/manage all the vendors.

. Successful implementation of Suite of Oracle R12 Application with

more than 100 CEMLIs and SOA technology as Backend. Involved in

complex integration with existing application and tools ranging

from : Item manager - Product categorization, SERP(SEO/SEM)

application, Image Cache - AKAMAI(CDN/DSA), Endeca - Search engine,

Internationalization/Localization, ERP Oracle R12(SOA, BPEL, Oracle

Finance, Manufacturing, Distribution), iPhone Apps, Facebook

connect. Involved collaboration with various business unit: Sales,

Marketing, Operations, Merchandising, Customer Services and

Finance.

. Identify gaps by Analyzing existing processes, future

process/product roadmap and provide business solutions using AIM

documents BP 40, BP80, RD 30, BR 30. Very good experience in

business requirements gathering, business process design,

requirements documentation (BRDs,FRDs etc)

. Design and developed business solutions, CEMLI approval with

business stakeholders, integration of the interfaces with various

front office and back office applications. Analyzed various

business systems and integrating new business critical Order to

Cash applications using SOA technologies in Oracle Fusion

Middleware. Converting Oracle E-Business suite as source of truth.

Concentrated on creating AIM documents MD30, MD70.

. Responsible for Data conversion planning, implementation and

testing, creating CV40 and CV110

. Responsible for testing Oracle suite coming up with TE40, TE100.

Coordinating CRPs UAT, Tracking testing results, business sign off

and system readiness with highly matrix and cross organization

participation, environment deployment, concurrent program

scheduling, users login, environment refreshes and Snapshots.

. Identification of Performance scenarios, data gathering, data

loading, tracking issues, rerunning test and signing off on

Performance criteria.

. User training: Power user and end user training, post go live

support and patches coordination.

. Sales Order booking and Shipping Dashboard developed multiple

Booking and Shipment reports.

. Techno functional lead role in Order to Cash implementation.

. Testing Order to Cash business flows, interfaces, using QTP and

Oracle accelerator

. Implemented Oracle product information management(PIM) suite for

5M+ items for centralizing product management including costing,

purchasing, inventory, BOM, Order management

. Implemented Oracle Manufacturing enterprise system(MES) for shop

floor operations integration with global shipping.

. Implemented Oracle Business Intelligence suite(BI) for Financial,

Procurement and spending and Order Management Analytics

. Implemented Financial Module(AR, AP, GL, CM) for Making Oracle

suite as source of truth.

Senior Business Systems Analyst (Team Lead & PM - Techno functional),

Synarc Inc. USA, July 06- July 08

Working with team on supporting 150+ Clinical trial studies. Synarc

is world's leading Pharmaceutical service organization dedicated to

global Clinical Trials. Software is developed in regulatory

environment with FDA compliance to 21 CFR Part 11.

. Understanding business problems and resolving them as well as

testing and implementation of application programs in support of

them

. Playing a key role in defining data conversion requirements and

procedures and maintaining them while upgrading Oracle ERP from

11.0.3 to 11i.

. Act as onsite primary point of contact for all client requirements

and lead offshore development team .

. Designed, developed several Data migration process which includes

data extraction from 11.03 and loads the data into 11i after

converting and validating 11.03 data into 11i accepted formats.

Import validated data using Standard Oracle API and standard

import process to import Items, Item categories, Item Revisions, On

hand quantities, Sub inventories, locaters, Bill of Materials,

Routings, Sales Orders, Price lists, Invoices, Purchase Orders etc

. Performed analysis and preliminary design for future iProcurement

and iReceivables implementation

Systems Analyst - Techno functional, Elance Inc. USA, Apr 03- July

06

Managing team of 25+ onsite & offshore engineers for entire life cycle

of professional services, account management, testing and release

engineering for the various Elance product line Ariba Workforce,

Elance 4.0 and Elance Online and Oracle 11i. Planned all resources and

schedules for functional and performance QA work for new and ongoing

web-based Service procurement management application various modules

include MSA (Master Service Agreement), Supplier, Contractor, Service

Engagement, and Service Procurement Management (SPM). Quality

Assurance: Metrics, Process Improvement, and CMM-i Readiness. Project

Management and Process Improvement initiatives. Certifying Patches to

resolve critical customer issues during implementation / production

phase. Major Tasks are

. Requirement gathering - Coordinate and schedule PRD reviews.

Allocate PRDs / feature to team members. PRDs to features break

down. PRD to test plan mapping

. Professional services: Managed professional services team acting as

liaison between clients and technology organization. Clients are

fortune 100 companies like Amex, GM, Motorola, Novartis and FedEx.

. Designing - Test plan creation. Metrics generation for test plan

vs. requirement coverage. Coordinating test plan review and sign

off.

. Testing - Owns builds, deployment, testing, verification and final

sign off of releases. Managed bug tracking system -bugzilla. Test

management using Test Director. Provide technical and

organizational leadership for software testing monitoring and

reporting of test metrics.

. Production support - Deployment to production, supporting customer

issues, testing patches & releasing to production environment.

Coordination with UNIX admin, DBAs, customer support professional

services to release patches / MR to hosted customers and CD install

customers. Some of the customers are GE, Motorola, Amex, BP,

Novartis.

. Automation Effort - Coordinating automation effort. Prioritizing

test plans to be automates depending upon ROI, easiness / frequency

of test runs. Facilitating test harness. Tools used are Winrunner

and QTP.

. Performance Testing - Responsible for initiatives to enhance

existing load test scripts to cover more scenarios, monitoring of

more parameters. Developed multiple performance environments

Solaris & Linux. Performance testing tool used is Loadrunner.

. Release Engineering - Handling release schedules, branching/

tagging strategies, builds and deployments. Deployment of

configuration management tools as needed.

. Other tasks - Integration testing with other procurement systems

like Peoplesoft, SAP, Oracle, Ariba. Training guides, demo

environment set up for new customers, UAT scripts testing. Hiring

right mix and aptitude of team members. Managed Localization

testing efforts. Supervised outsourced testing team in India.

Hired, trained and supervised software quality assurance and

release engineers. Assured technical accuracy of end-user software

documentation.

. Analyzed, Designed, Developed, Tested and Implemented New Automated

Inter-company Process by designing New Business Process in Oracle

Workflow which includes Standard and Expense ASN. This New Inter-

company Process covers both Procure to Pay and Order to Cash

business processes.

. Analyzed, Designed, Developed, New Customer Credit Check Process.

. This Global Credit Check process checks Credit limit of each

customer exists 2 different production instances (Oracle 11.03,

Oracle 11i ) based on orders booked and 90 days forecasted goods

value.

. Designed and Developed several Oracle Alerts to advice credit

department to approve or decline newly booked orders based on

Global Credit Check process credit limit check.

. Very good experience in business requirements gathering, business

process design, requirements documentation (BRDs,FRDs etc) and

system analysis in a highly matrix and cross-functional

organization.

. Configured OM, Advanced Pricing, Inventory modules for almost 100+

customer with 50000+ users located globally. Designed, developed

and deployed data migration processes and lead the post

implementation production support team for all legacy to 11i and

11.03 to 11i upgrades

. Managed teams offshore, onsite oracle development team and oracle

functional team.

. Lead production support team and worked as primary point of contact

for all Oracle Distribution modules related production issues for

global organization.

Lead Engineering/Technical Services, Siebel Systems Inc. USA, Apr 00-

Mar 03

Part of integration team for Siebel 6x/7.x releases. Some of the tasks

include

. Databases and Server Requirement planning, Manpower Resource

planning for optimum utilization

. Scope out the release schedule with PM's & Engineering and

prioritized issues which are in red to get resolved to avoid

bottlenecks

. Provided excellent quality product by understanding business

processes, understanding anomalies in Build process, valuable input

for Technical document to Release Egg

. Resolved customer issues for clients like Nestle, Nike, Bell

Canada, Procter & Gamble, Philip Morris, GM, for various 7x

releases

. Performed all aspects of software quality assurance: MRD and design

doc review, development of test plans and test cases, integration,

acceptance testing.

. Managed linguistic testing efforts in more than ten languages (ENU,

FRA, ESN, DEU etc)

. Siebel intelligence dashboards which includes Verticals-

eAutomotive, eCG Sales Handheld, Consumer Sector, Comm Media

Energy, Horizontals- eService and PRM.

. Testing on upgrade, replication manager, Workflow manager, EAI, EIM

with siebel and other application: Oracle Apps, SAP, people soft,

report server email response and eChannel. Certified iPAQ, Symbol &

HP Jornada, Handheld devices for Siebel, eScripting, S2S Connector,

OLAP/ OLTP

. Expertise in various modules like trade promotion management, sales

volume planning, deduction management, retail execution, assets,

move in/move out, eDealer operations, order management.

. Established bugs trend charts and monitored the release progress.

. Coordinated with DBAs, PMs, QA, Unix Admin, IT for utilizing

resources to speed up Maintenance Releases/Customer

Sr. Support Engineer, CEISMC, USA, May 99- Mar 00

Developed online Database Management System for Department of

Education using MS Access and Coldfusion software for streamlining,

updating and accessing information system that includes every RDBMS

functionality

Sr. Support Engineer, Student Health Center, USA, Sept 98-May 99

Provided statistical assistance and computer support for internal

management of activities and developed strategies involving inventory

management

Support Engineer, Larsen & Toubro Limited, INDIA, Sept 95-Aug 98

Business requirement gathering, professional services support for in

house application for Production Planning, Scheduling, Manpower

Management, Facilities, Vendor Development and Productivity

improvement. Successfully completed projects constituted analysis of

discrepancies in inventory system & implementation of remedial methods

that saved company $0.1 M.

. Optimizing various procurement cycles reports and management tools,

viz. Supplier scheduling, Component level forecast determination,

price variance alerts and reporting.

. Helped shop floor with recommendations and custom reporting tools

to eliminate communication gaps between planners and shop floor

personnel.

. Supported production environment with impromptu reports, data

migrations, patches & sysadmin.

Education

MS Industrial and Systems Engg, Georgia Institute of Technology,

Atlanta,

Major in transportation and logistics, minor in finance, GPA 3.61

BE Mechanical Engineering, S.G.S.Institute of Technology, Indore,

India

Graduated with First Division Ranked Top 1%

Honors

Recipient of Certificate of Merit for meritorious student in Year 89

and 91

Recipient of Appreciation Award for excellent performance at L&T for

Year 1997-98

Highest performer of the group at Siebel for the Year 2002

Employee of the quarter award at Elance for Oct - Dec 2004

Employee of the release award at Elance in June 2005

Contact this candidate