Manager Oracle
Resume:
Vijay Vuyyuru
Cell: 732-***-****
Email: ************@*******.***
. SUMMARY
* Excellent leadership, functional, technical, project planning, business
intelligence, analytical and communication skills, with over 14 years
of software design, development and implementation experience.
* Extensive experience in complete project life cycle including project
reviews, request for proposals, feasibility studies, rough order
magnitude assessment, budgeting, detailed time and cost estimates,
building the business/project intelligence for executives, project
planning, resource planning, team development, communications planning,
risk assessment and management, statement of work, software
requirements analysis, gap analysis, functional system architecture,
technical system design, interface agreements with legacy/external
systems, development, system integration, quality assurance,
deployment, change management and production support.
* Management experience in successfully leading, managing and driving
business organizations towards achieving the intended business results
on time, ensuring Sarbanes-Oxley (SOX) and 21 CFR Part 11 regulatory
requirements are met, covering all the domains as a consulting and
development project manager and architect. Significant experience in
working with steering committees, business teams, users, other project
managers and executive-level clients.
* Expertise in data architecture, data analysis and management, data
modeling, mapping data sources, designing data flows between
applications, integration of new companies/entities and consolidation
of organizational changes, data merging and data normalization.
* Expertise in defining functional and technical architecture,
implementing the functional setups and configuration,
designing/developing/architecting Oracle based products, including
being a part of Oracle Corporation Core Product Development Team (CA /
NY) for 4.5 years.
* Responsible for developing Oracle modules (at Oracle Corporation):
Oracle Common Applications / CRM Foundation (Assignment Manager,
Resource Manager, Territory Manager, Task Manager, Calendar, Notes),
Oracle Service (Service Requests), TeleService, iSupport, Core
Contracts, Service Contracts, Customer Care, Depot Repair, Field
Service, Install Base, Contact Center and Oracle Process Manufacturing.
* Over 11 years of experience in offshore development teams management.
. TECHNICAL SKILLS
* Oracle
Oracle eBusiness Suite of Applications - Oracle Release 12 (R12),
Oracle CRM R12 / 11i (11.5.10.2 / 11.5.10 / 11.5.9 / 11.5.x), Oracle
Applications R12 / 11i / 10.7, Oracle ERP, Oracle Process Manufacturing
(OPM), Oracle RDBMS 10g / 9i / 8i / 7.x, Oracle BPEL, Virtual Private
Database (VPD), Oracle Row-Level Security, Oracle Developer Suite,
Oracle Forms, Oracle Reports, Oracle Discoverer 4i, Oracle AIM
* Other Products
Salesforce.com(SFDC), Siebel 7.5x, Siebel EIM, Siebel EAI, Siebel
Tools, Siebel CRM, All Fusion ERwin Data Modeler, Model Mart, MS
Projects, GEMMS (Global Enterprise Manufacturing Management System)
Version 5.0 / 4.1, Crystal Reports, JAM, Forms Genie, Power Genie,
Power Builder 4.0, Dbase
* Operating Systems
LINUX, UNIX (Solaris, HP-UX), Windows 7 / Vista / XP / NT / 2000,
Windows Motif
* Languages
SQL, PL/SQL, XML, HTML, JPL, COBOL, FORTRAN, Pascal.
. EDUCATION
. Masters (Faculty of Engineering) in Computer Sciences and Applications
- 1996
. Bachelors (Faculty of Sciences) in Electronics - 1993
. HONORS / ACHIEVEMENTS
. Ranked among the University Top Five in Masters
. College Valedictorian in all the Semesters in Masters
. College Valedictorian in Bachelors Final Year
. Doctors Certification in Business Administration
. WORK EXPERIENCE
Employer: Canon Inc < 11/06 - Till Date >
Role: Sr. Manager / Functional Lead / Enterprise Architect
Client: Canon USA Inc., Jamesburg, NJ / Lake Success, NY
Products/Modules Implemented:
Oracle Sales, Marketing, Quoting, Proposals, Partners, Sales Offline,
Sales for Handhelds, Configurator, Service Contracts, Advanced Pricing,
Incentive Compensation, Oracle Install Base, Approval Management(AME),
TeleService, TeleSales, Field Service, Mobile Field Service, Depot
Repair, Scheduler, iSupport, Customer Care, Order Management, Spares
Management, Accounts Receivable(AR), General Ledger(GL), Interaction
Center, Oracle Alerts, Universal Work Queue, Human Resources Management
System(HR), Inventory, Workflows, Daily Business Intelligence(DBI),
Customers Online, Oracle Common Applications/CRM Foundation(Territory
Manager, Resource Manager, Task Manager) modules, TCA Architecture,
DQM, and Salesforce.com(SFDC).
Responsibilities:
Project scoping; risk assessment; risk analysis; project planning;
budgeting; status updates to the PMO; steering committee briefings; gap
analysis; requirements gathering; architecture for
design/interfaces/conversions; AIM documentation; leading the United
States and European roll-outs.
Accomplishments:
Functional architecture; integration of new companies and consolidation
after Canon merged all the United States based (East/West/Central)
companies into one entity; implementing/configuring the
Salesforce.com(SFDC) product for Opportunity, Lead, Task, Prospects and
Contact Management functionality for the Canon East region;
architecting the business executive reports; functional setups,
application configuration, profile options and flexfield setups;
architecting the Oracle CRM Custom interfaces to the legacy systems;
architecting the custom Service Contracts Billing and Accounts
Receivables (AR) Autoinvoice interface; configuring the Canon
machines/accessories using Configurator Developer; setting up the Bills
of Material(BOM), assigning the Machines to Pricelists, importing the
Bills of Materials(BOM) into Oracle Configurator, creating the Model,
creating Business Rules and User Interface in the Oracle Configurator
for Canon Machines, testing and publishing the configured models;
creating Incentive Compensation plans, plan elements, formulas for
calculating the Bonus for salesreps; implementing the Spares Management
functionality and custom screens for Pegasus Scanners providing the
users the ability to scan and receive the items, complete the sub-
inventory transfers and Move Order Fulfillment; DQM Party and Account
merge, setup duplicate identification and DQM Match Rules; ensuring
Sarbanes-Oxley(SOX) regulatory requirements are met; developing the CRM
Logical Business Model using All Fusion ERwin Data Modeler / Model
Mart; developing the Physical Business Data Model mapping the Logical
Attributes to Physical Columns in the Oracle Database; metadata
management and reference data analysis; identifying/assessing the
application gaps; customizations, extensions, SQL*Form
personalizations; designing Java based custom screens and enhancements;
testing the conversions, interfaces and reports; production support and
maintenance.
Environment:
Oracle CRM Release 12(R12)/11i (11.5.10.2), Oracle Configurator, Oracle
AS 10g, Forms 6i, Reports 6i, Discoverer 4i, PL/SQL, Java, ERwin Data
Modeler, Model Mart, Salesforce.com(SFDC)
Employer: Bearing Point / KBace < 08/06 - 11/06 >
Role: Sr. Manager / Functional Lead / Enterprise Architect
Client: Cendant Corporation/Wyndham Worldwide, Parsippany, NJ
Products/Modules Implemented:
Oracle TeleService, TeleSales, Field Service, iSupport, Depot Repair,
Scheduler, Contact Center, Customer Care, Core Contracts, Service
Contracts, Advanced Pricing, Install Base, Approval Management (AME),
Interaction Center, Alerts, Universal Work Queue, Human Resources
Management System, Inventory, Workflows, Daily Business Intelligence,
Customers Online, Oracle Common Applications/CRM Foundation (Territory
Manager, Resource Manager, Task Manager) modules, TCA Architecture and
DQM.
Responsibilities:
Project scoping; risk assessment; risk analysis; project planning;
budgeting; status updates to the PMO; steering committee briefings; gap
analysis; requirements gathering; architecture for
design/interfaces/conversions; AIM documentation.
Accomplishments:
Functional architecture; integration of new companies and consolidation
after Cendant Corporation split into four different companies;
functional setups, application configuration, profile options and
flexfield setups; architecting the business executive reports;
architecting the Oracle CRM interfaces to the legacy systems; DQM Party
and Account merge, setup duplicate identification and DQM Match Rules;
architecting the custom Service Contracts Billing and Accounts
Receivables (AR) Autoinvoice interface; addressing the issues and
concerns of customers and business representatives; ensuring Sarbanes-
Oxley(SOX) regulatory requirements are met; developing the CRM Logical
Business Model using All Fusion ERwin Data Modeler / Model Mart;
developing the Physical Business Data Model mapping the Logical
Attributes to Physical Columns in the Oracle Database; metadata
management and reference data analysis; identifying/assessing the
application gaps; customizations, extensions, SQL*Form
personalizations; conversion/migration of data from Legacy Systems to
Oracle CRM Database; testing the conversions, interfaces and reports;
production support and maintenance.
Environment:
Oracle CRM 11i (11.5.10.1 / 11.5.10.2), Oracle Applications 11i, Oracle
AS 10g, Forms 6i/6.0, Reports 6i, PL/SQL, Java, ERwin Data Modeler,
Model Mart
Employer: IBM < 09/05 - 08/06 >
Role: Manager / Functional Lead / Enterprise Architect
Client: Loral Skynet (Satellite Communications), Bedminster, NJ
Products/Modules Implemented:
Oracle CRM 11.5.10.1/11.5.10.2 implementation includes Oracle Sales
(ASN), Marketing, Proposals, Partners, Quoting, TeleSales, Oracle
Service Contracts, Sales Contracts, Advanced Pricing, Approval
Management (AME), Accounts Receivable (AR), General Ledger (GL),
Interaction Center, eMail Center, Alerts, Universal Work Queue, Human
Resources Management System, Inventory, Advanced Product Catalogs,
Order Management, Workflows, Install Base, Daily Business Intelligence
(DBI), Customers Online, DQM, Oracle CRM Foundation (Territory Manager,
Resource Manager, Assignment Manager, Task Manager, Calendar and Notes)
modules, TCA Architecture and DQM.
Responsibilities:
Project scoping; risk assessment; risk analysis; project planning;
budgeting; status updates to the PMO; steering committee briefings; gap
analysis; requirements gathering; architecture for
design/interfaces/conversions; IBM RICE/AIM documentation; functional
setups and configuration.
Accomplishments:
Integration of the existing Salesforce.com (SFDC) User Interface and
Data into Oracle Sales Application; building the business/project
intelligence for executives; functional architecture; functional
setups, application configuration, profile options and flexfield
setups; architecting the application and data storage retaining the
legacy system functionality; converting the data from
Salesforce.com(SFDC) to Oracle TCA and Sales tables; DQM Party and
Account merge, setup duplicate identification and DQM Match Rules;
architecting the Order Management to Service Contracts interface;
architecting the order-to-cash flow; architecting the Service Contracts
Billing and Accounts Receivables (AR) Autoinvoice interface; addressing
the issues and concerns of customers and business representatives;
ensuring Sarbanes-Oxley(SOX) requirements are met; developing the CRM
Logical Business Model using All Fusion ERwin Data Modeler / Model
Mart; developing the Physical Business Data Model mapping the Logical
Attributes to Physical Columns in the Oracle Database; metadata
management and reference data analysis; identifying/assessing the
application gaps; customizations, extensions, SQL*Form
personalizations; testing the conversions, interfaces and reports;
production support and maintenance.
Environment:
Oracle CRM 11i (11.5.10.1 / 11.5.10.2), Oracle Applications 11i, Oracle
AS 10g, Forms 6i/6.0, Reports 6i, PL/SQL, Java, ERwin Data Modeler,
Model Mart, salesforce.com(SFDC)
Employer: Keane Inc < 11/03 - 09/05 >
Role: Project Manager / Functional Lead / Enterprise Architect
Client: United States Federal Government, Washington, DC
Products/Modules Implemented:
Oracle Service, Tele Service, Service Contracts, Field Service,
Interaction Center, Contact Center, Customer Care, eMail Center,
Universal Work Queue, Human Resources Management System, Inventory,
Workflows, Install Base, Daily Business Intelligence (DBI), Sales
Online, Customers Online, iSupport, Territory Manager, Resource
Manager, Task Manager modules, TCA Architecture and DQM.
Responsibilities:
Project scoping; risk assessment; risk analysis; project planning;
providing status updates to the PMO; gap analysis; requirements
gathering; architecture for design/interfaces/conversions; AIM
documentation.
Accomplishments:
Functional architecture; functional setups, application configuration,
profile options and flexfield setups; building the business/project
intelligence for executives; architecting the Oracle CRM interfaces to
PBGC legacy systems as web services using Oracle BPEL;
architecting/developing a custom provisioning infrastructure,
leveraging the Virtual Private Database (VPD) and Oracle Row-Level
Security features; integrating Oracle CRM with the State Street
Corporation financial system; consolidating/architecting/developing the
PBGC Enterprise Logical Model using All Fusion ERwin Data Modeler /
Model Mart to represent the entire Interactions Business Process of
PBGC for the "Database Redesign" effort; DQM Party and Account merge,
setup duplicate identification and DQM Match Rules; addressing the
issues and concerns of customers and business representatives; ensuring
Sarbanes-Oxley(SOX) regulatory requirements are met; developing the
Physical Business Data Model mapping the Logical Attributes to Physical
Columns in the Oracle Database; metadata management and reference data
analysis; customizations, extensions, SQL*Form personalizations;
conversion/migration of data from PBGC Legacy Systems to Oracle CRM
Database; production support.
Environment:
Oracle CRM 11i (11.5.10/11.5.9/11.5.8), Oracle Applications 11i, Oracle
AS 10g / 9i / 8i, Oracle BPEL, XML, Forms 6i/6.0, Reports 6i, PL/SQL,
Java, ERwin Data Modeler, Model Mart
Employer: AT&T < 07/02 - 11/03 >
Role: Project Manager / Functional Lead / Enterprise Architect
Client: AT&T, Middletown, NJ
Products/Modules Implemented:
AT&T CRM implementation includes Oracle Sales Online, Marketing Online,
Configurator Developer, Workflows, eMail Center, Oracle HR, Inventory,
Advanced Pricing, Daily Business Intelligence(DBI), Territory Manager,
Resource Manager, Assignment Manager, Task Manager, Calendar, Notes
modules, TCA Architecture and DQM. Siebel eCommunications
(Opportunities, Accounts, Activities, Campaigns, Accounts, Contacts,
Quotes, Service Requests, Workflows), Partner Relationship Management.
Responsibilities:
Project scoping; risk assessment; risk analysis; project planning;
providing status updates to the PMO; gap analysis; requirements
gathering; architecture for design/interfaces/conversions; AIM
documentation; coordinating/leading the United States and European roll-
outs; coordinating the development effort with the India development
team.
Accomplishments:
Functional architecture; functional setups, application configuration,
profile options and flexfield setups; converting AT&T legacy data;
configuring the AT&T Services using the Oracle Configurator; designing
Java based custom screens; DQM Party and Account merge, setup duplicate
identification and DQM Match Rules; testing the conversions, interfaces
and reports; production support and maintenance; developing the CRM
Logical Business Model using All Fusion ERwin Data Modeler / Model
Mart; developing the Physical Business Data Model mapping the Logical
Attributes to Physical Columns in the Oracle Database; metadata
management and reference data analysis; following up with the issues
and concerns of customers and business team; customizations,
extensions, SQL*Form personalizations.
Architecting the interface agreements between Siebel, Oracle and legacy
systems; configuring business objects, business components, building
views, applets, screens; setup Siebel extension tables, links, joins,
pick lists, MVGs and drilldowns; importing data from legacy systems
into Siebel schema (Oracle database) using EIM; implementing EAI for
real-time interfaces of Siebel UI for "AT&T Credit Check Process".
Environment:
Siebel 7.5x, Oracle 9i, Forms 6.0, Oracle CRM 11.5.8, Oracle
Applications 11i, Oracle Configurator, PL/SQL, XML, Java, All Fusion
ERwin Data Modeler
Employer: Oracle Corporation < 12/98 - 06/02 >
Role: Development Lead / Functional Architect
Client: Oracle Development Team, Oracle World HQ, Redwood Shores, CA
Forms/APIs Developed for Oracle Applications:
Oracle CRM Foundation/Common Applications: Assignment Manager,
Calendar, Territory Manager, Resource Manager, Task Manager and Notes
Forms and APIs.
Oracle Service Contracts: Author/Terminate Contracts, Contract
Coverages Forms and APIs.
Oracle Field Service, Oracle Service, Install Base: Service Request,
Contact Center, Depot Repair and Counters Forms and APIs.
Responsibilities:
Project scoping; risk assessment; risk analysis; project planning;
providing status updates to the management; requirements gathering;
defining data/application/functional architecture; functional setups
and configuration; developing the Stored Procedures and Application
Programming Interfaces (APIs); developing the SQL*Forms, Java/HTML
screens and workflows; integration across modules; providing world wide
support for Oracle CRM.
Accomplishments:
Functional setups and application configuration; defining the required
profile options and flexfield setups; design documents; defining
functional flows; writing the code for the stored procedures, creation
of tables, profile options; creating workflows; developing, testing and
documenting the modules; developing Stored Procedures/APIs for the
Assignment Manager Rules Engine using PL/SQL and Java (Rosetta)
wrappers; developing the Assignment Manager UI with Oracle SQL*Forms
and Java Beans for visual representation of the Resources fetched from
the Assignment Manager Engine; integrating Assignment Manager with Task
Manager, Territory Manager, Calendar, Install Base, Service Contracts,
Service, Field Service, TeleService, Depot Repair, Workflows, Call
Center, Customer Care (including Contact Center), Tele Sales, Marketing
(including Sales Leads, Sales Opportunities and Accounts modules),
iSupport, Defect Management (Oracle Quality Online) modules; supporting
the world-wide Oracle implementations for CRM Foundation; executing the
Conversion of SQL*Forms Version 4.5 to SQL*Forms Version 6.0 in the
Oracle Service, Oracle TeleService, Oracle Customer Care, Oracle Depot
Repair, Oracle Install Base and Oracle Contracts Modules; developing a
framework/infrastructure utility for testing, using SQL*forms, which
made the integration and unit testing possible.
Data migration for Oracle Business Online (BOL and DEALS.com) by
writing the loader scripts for loading the data from flat files to
staging tables; writing the SQL scripts for capturing and reporting the
unprocessed/erred records at the staging tables and the interface
tables; defining/architecting/developing the entire process of sending
the legacy data in flat files by the customer; loading the flat file
data into the staging tables using the loader scripts; loading the
staging table(s) data into the interface tables using the API; running
the concurrent program for the Customer interface to load the Customer
and business data into the base tables of the Account Receivables (AR)
and Account Payables (AP) Modules; registering all the custom programs
(APIs) as concurrent programs; creating a Concurrent Request Set which
(by clicking on a menu item) enables the execution of all the
concurrent programs in the desired sequence.
Environment:
Oracle 9i / 8i / 8.0.4, Forms 6.0, Oracle CRM 11i / 3i, Oracle
Applications 11i, PL/SQL, Java
Employer: Rapidigm Inc / RPM Systems / Computer People Inc. < 12/97 - 11/98
>
Role: Team Lead / Functional Architect
Responsibilities:
Providing status updates to the management; conducting internal project
status review meetings; gap analysis; requirements gathering;
architecture for design/interfaces/conversions; AIM documentation;
reports development; forms customization.
Products/Modules Implemented:
Oracle Purchase to Pay (P2P), Oracle Consumer Packaged Goods (CPG) and
Oracle Process Manufacturing (GEMMS), Oracle Financials, Manugistics,
System ESS.
Client: Frito-Lay Inc., Dallas, Texas
Accomplishments:
Functional architecture; functional setups, application configuration,
profile options and flexfield setups; building the business/project
intelligence for executives; data analysis of Frito-Lay Legacy systems;
mapping data from legacy sources to the Oracle Database; development of
the custom quality control system using SQL*Forms(4.0/4.5); custom
SQL*Reports(2.5/3.0); creating the stored procedures/APIs for the
Conversions and Interfaces; testing and deployment.
Environment:
Oracle Applications 10.7, Oracle 7.3.2.3, Oracle P2P, Oracle CPG,
Developer 2000 R1.3, GEMMS 4.1
Client: Tri Valley Growers, San Ramon, California
Accomplishments:
Functional architecture; building the business/project intelligence for
executives; functional setups, application configuration, profile
options and flexfield setups; customization of key functional SQL*Forms
(4.0/4.5); custom SQL*Reports(2.5/3.0); creating the stored
procedures/APIs for the Conversions and Interfaces; testing and
deployment.
Environment:
Oracle Applications 10.7, Oracle 7.3.2.3, Oracle CPG V2.2.2, Developer
2000 R2.0, GEMMS 4.1
Employer: Sierra Optima < 03/97 - 12/97 >
Role: Sr. Software Engineer
Client: Oracle Corporation, Valhalla, NY
Forms/APIs Developed for Oracle Process Manufacturing (Oracle OPM):
System Administration (SY): UOM Types, Reason Codes, Unit of Measure
Codes, Purge Setup, Purge Tables, Purge and Archive, Purge and Archive
Process, Purge Inquiry.
Inventory Control (IC): Transaction Selection Dialog box; Transaction
Inquiry; Transaction Details; Inventory Close; Adjustment Transactions
and few Class Forms.
Quality Control (QC): Customer/Vendor Specifications; Item/Location
Specifications;
Production Specifications; Customer/Vendor Samples; Item/Location
Samples; Production Samples.
Forecasting (FC): Forecast Maintenance; Forecast Detail Maintenance.
Master Production Schedule (PS): MPS Schedule Parameters
Costing Management (CM): Burden Details
Responsibilities:
Gap analysis; requirements gathering; architecture for
design/interfaces/conversions; develop Oracle Process Manufacturing
(OPM) product; SQL*Forms and SQL*Reports development.
Accomplishments:
Functional and technical architecture; functional setups, application
configuration, profile options and flexfield setups; technical design;
developing and testing the stored procedures/APIs, new Oracle SQL*Forms
and SQL*Reports; converting the JAM front-end to Oracle Forms 4.5; re-
writing the JPL code in Oracle PL/SQL.
Environment:
Oracle Applications 10.7, Oracle 7.3.2.3, Developer 2000 Release 1.3,
SQL*Forms 3.0/4.0/4.5, SQL*Reports 2.5/3.0, GEMMS 4.0 / 4.1, 10 SC, AOL
Employer: Edit Services < 03/95 - 02/97 >
Role: Software Engineer / Architect
Client: Andhra Pradesh Agricultural University (APAU), Hyderabad, India
Responsibilities:
Gap analysis; requirements gathering; architecture for
design/interfaces/conversions; develop the Crop Statistics System;
reports development; custom screens development.
Accomplishments:
Requirements gathering; data analysis; functional architecture;
designing the user interface; creating/normalizing database tables;
developing thirty-four new screens, menus and reports; testing and
deployment.
Environment:
Power Builder 4.0, Oracle 6.0 / 7.0
Contact this candidate