Project Manager Oracle

Summary

Experienced Techno-Functional Consultant, Project Manager and Oracle

Certified Professional Database Administrator with 16 years experience with

Oracle ERP and custom Oracle applications. Prior experience includes work

at Deloitte Consulting and CGI. Extensive experience with Oracle

application implementations in various industry segments including media,

pharmaceuticals, manufacturing, consumer products, telecom and the public

sector. Experience in global deployment of Oracle Applications, involving

multiple organizations and currencies. Experienced in varied roles

including application administration, database administration, performance

tuning, application cloning, and application extension and software

configuration management. Functional knowledge of Financials Suite, Order

Management, CRM applications. Experienced with forecasting and data

analysis using Oracle Sales Analyzer and Oracle Financial Analyzer. Author

of 3 papers on customizations to Oracle Financials Suite. Exposure to

Business Intelligence using Discoverer, OBIEE and Hyperion.

Skills

Oracle EBS: Releases 10.7 to 12.1.1 - Financials Suite, CRM, Order

Management

Oracle BI: Discoverer, OBIEE, Hyperion

Databases: Oracle RDBMS 6 - 11g

Software: Oracle Developer 2.5 - 9i, ADI, TOAD, SQL Navigator, Precise

Methodologies: Deloitte Consulting Fasttrack, Information Engineering

Methodology, and Project Management Framework, Applications

Implementation Methodology,Evolve

Certification

- Oracle Architecture and Administration

- Oracle SQL, PLSQL

- Oracle Backup and Recovery

- Oracle Networking

- Oracle Performance Tuning

- Oracle Certified Professional Database Administrator

Awards

. 2009, 2008 and 2005 - Achieved Company Outstanding Performance Awards

in recognition of superior client support and technical expertise in

Financials, CRM, OM implementations.

. 2004 - Awarded a project bonus in recognition of delivering a fixed

priced project on time and on budget for a Financials Suite

implementation.

. 2002 - Achieved Company Outstanding Performance Award in recognition

of delivering fixed priced project on time and on budget for a

Financials Suite implementation.

. 1999 - Won Big Biller Award in recognition of revenue generated on

project engagements.

Professional Experience

THE ATHENE GROUP Nov 2010 - Present

Technology consulting Firm specializing in Oracle CRM implementations.

. Lead EBS implementer coordinating with a team of Siebel CRM

implementers and developers.

. Responsible for designing procedures to extract transactions from

Order Management, Accounts Receivables and General Ledger.

. Design and develop transformation and staging processes to format

transactions per requirements of Siebel CRM.

ZENSAR TECHNOLOGIES 2005- 2010

Global technology consulting firm with offices in 22 countries and

employing 5400.

Principal Consultant - Project Manager, Techno-Functional Lead, Oracle

Applications DBA Administrator

. Managed the installation, upgrade, configuration and maintenance of

Oracle Applications versions 11.5.10 to R12.1 on Oracle Database

versions 8i to 11g on various platforms for high profile clients,

including Primavera, Columbia Broadcasting Service (CBS), Thomas

Publishing, Public Broadcasting Service (PBS), Town Sports

International, Approva, Integro Insurance, Deerfield Hedge Fund,

Synchronoss, Barnes and Noble, City of Atlanta, AT&T, Specialty

Minerals.

. Author of 3 papers on customizations to Oracle Financials Suite.

. Project Manager on 2 full cycle implementations of Release 12 of EBS.

. Project Manager and database administrator on upgrades to Release

11.5.10.2 of EBS.

. Release Manager on full cycle implementation of Release 12.1 of EBS.

. Database administrator and technical lead on 2 full cycle

implementations of Release 12 EBS.

. Database administrator and technical lead on 5 full cycle

implementations of Release 11.5.10 of EBS

. Technical Lead on building and extending a custom module to integrate

with EBS Financials.

. Business Intelligence experience with Discoverer, OBIEE, Hyperion on

Windows and Linux.

. Designed and documented business process flows for the Financials

Suite using Serena.

. Coordinated with Vertex for the installation and integration with the

e-Business Suite.

. Used forms personalization to format and perform data validation for

fields on Standard Financials screens. Built custom forms to meet

business requirements.

. Coordinated custom interface development for Cash Management,

Receivables, I-expense, AP.

. Implemented Oracle Single Sign-on Solution to allow the user base in

Microsoft Active Directory to access the E-Business Suite without

entering login credentials for 400 I-expense users.

. Developed wrapper processes to invoke encryption and decryption

procedures for data file transmission to financial institutions for

Oracle Payables.

. Developed custom interfaces between Service Contracts, Order

Management, and Receivables.

. Customized application flow and business processes in the Financials

Suite using Logical Apps.

. Developed external system interfaces to Oracle Order Management,

Oracle Configurator, Advanced Pricing, to transmit orders from OM and

I-Store.

. Led a team of 9 Functional and Technical resources operating onsite,

remote and offshore to deliver web services that interface CRM with

financials applications real time.

. Facilitated process design to review Call Center processes to flow

through CTI, Advanced Inbound, and Oracle TeleService and Oracle Email

Center applications.

. Executed client training to support Oracle applications

administration.

. Defined application security using password policy options in the e-

Business Suite.

. Setting up of custom responsibilities to support specific business

roles. Built custom menus and customized standard menu to meet

business requirements.

. Defined printers created custom printer drivers, custom styles for

reporting and check printing.

. Mentored and trained developers and administrators.

. Completed Upgrade of Discoverer4i to 10g allowing access to EUL for

Financials data.

Key Highlights

. Delivered EBS 11.5.10.2 on RedHat OS on VMware guests for Primavera.

. Coordinated with business groups and 30 member development teams in

Los Angeles, New York and Kolkatta, India to deliver 70 Custom

Interfaces to the Financials Suite for CBS, in 12 weeks.

. Delivered 3 Oracle Financials Accelerator implementations in a span of

6 months.

. Managed a 9 member onsite, remote and offshore team and 10 vendors to

deliver CRM implementation integrated with CTI, for City of Atlanta in

11 months.

. Managed a 22 member onsite and offshore team to deliver 7 releases of

billing customizations for PlumChoice in 7 months.

ORACLE CENTER OF EXCELLENCE, CGI INC. 1998 - 2004

Sixth largest technology consulting firm in North America with 31000

professionals in 125 offices worldwide providing end-to-end IT and business

process services.

Senior Consultant - Techno-Functional Lead and Oracle Applications

Database Administrator

. Experience with multi-tasking in various roles within a project and also

simultaneously on multiple projects. Roles performed include

o Technical Project Manager

o Business Analyst

o Subject Matter Expert - customizations to Oracle Financials

Suite.

o Conduct JAD Sessions

o Software Configuration Management

o Disaster Recovery Management

o Application Administration and Database Administration

o Performance Tuning

o Conversion and Interfaces Lead, Custom Design and Development

Consultant

. Managed the installation, upgrade, configuration and maintenance of

Oracle Applications Financials Suite versions 10.7 to 11.5.10 on

Oracle Database versions 7 to 9i on various platforms for high profile

clients, including Eaton CCD, Acclaim Entertainment, NYS Department of

Motor Vehicles, NYS Division of Criminal Justice Services, NYS

Department of Environmental Conservation, New York State Insurance

Fund, Imagistics, NYS Department of Education, Quintiles

Transnational.

1. Global roll-out of a multi-org, multi-currency deployment of Oracle

Financials Suite, Human Resources Suite, Order Management, Inventory

and Purchasing.

. Extracted data from standard Oracle data structures to populate custom

data warehouse data stores for forecasting and analysis using Oracle

Sales Analyzer and Oracle Financial Analyzer.

. Executed client training to support Oracle applications

administration.

. Conducted JAD sessions with client business teams to gather interface

requirements from external systems to the Financials Suite.

. Developed external system interfaces to Oracle General Ledger.

Designed an effective conversion strategy to load transactions and

statistics for historical data into General Ledger.

. Set up custom workflows for I-expense approval management and to

identify accounting for Oracle Projects. Research setup of Oracle

Approval Management for I-expense.

2. Developed a set of "How To" procedures to handle frequent application

management tasks.

3. Designed custom interfaces for Oracle Receivables, to revenue transfer

cash receipts and miscellaneous cash receipts between revenue

accounts. Extended custom interfaces to transmit and receive financial

transactions with the office of State Comptroller's Central Accounting

System.

4. Encrypted interface transaction data files using PGP software.

5. Designed and developed discrete job screen using Developer2000 Forms

for one-step JIT assembly completions that back flush inventory for

automotive parts manufacturer. Designed custom screen to provide data

access to Oracle MRP and Work-In-Progress.

Key Highlights

. Increased business opportunities by authoring 3 position papers on

customizations to the Financials Suite. Each position paper led to

new E-Business Suite Financials implementation contracts.

. Standardized installation routines to deploy application

customizations. Reduced deployment time for customizations to the

Financials Suite, helping the company deliver fixed priced projects

under budget and ahead of schedule.

. Defined an efficient solution to implement multi-org capability for

application customizations to Financials Suite implementations for

New York State. Reduced deployment time for customizations to E-

Business Suite, helping the company deliver fixed priced projects

under budget and ahead of schedule.

. Built a custom insurance application POC using the Global Insurance

Open Solution (GIOS) for the fleet insurance market. This turned

into a 5 million dollar engagement to create an insurance

application for the US market.

SIRCO ASSOCIATES 1996 to 1998

Lead Designer and Developer

. Modeled business process using dataflow diagrams and documented

requirements using function hierarchy diagrams for payment

processing, Receivables and Audit processes.

. Designed client side modules to enable customer access through the

web using Java applets.

. Accessed customer and vendor data from remote databases using JDBC.

. Designed new functionality to existing customer billing systems to

accommodate new vendors of utility services and interface to

external billing systems, using EDI.

. Managed interface and data integrity between billing system and

corporate GL and reporting applications.

. Set up Discoverer, to enable end users to define ad-hoc queries and

reports

. Achieved significant performance enhancements using PreciseSQL and

ExplainSQL.

Key Highlights

. Worked with Oracle Software Solutions to build the data model for

payment processing for Utilities. The data model became part of the

Oracle Software Solutions Suite for the Utility Industry.

. Led reengineering project for System Controls Area for residential

utility accounts.

Graduate Research Assistant

Ocean Drilling Program, TAMU, College Station

1994- 1995

An international partnership of scientists and research institutions

organized to explore Earth's structure and history through scientific

ocean drilling.

. Implemented a physical properties database for geological samples.

. Created menu driven user interface with Power Builder 4.0 based on

assigned privileges.

. Produced reports with dynamic and composite Data Windows.

. Maintained quality control program to maintain uniformity in

variable naming and coding standards.

Education

MS, Engineering, Texas A&M University, College Station, TX 1995

BS, Engineering, S.K. University, Anantapur, India 1992

Training

. Oracle Designer2000 6i; Oracle Developer2000 6i

. Oracle Designer Headstart Application Development: Java, HTML

. Web Application Development: DHTML, JavaScript, Document Object

Model, Cascading Style Sheets

. Customizing Oracle Applications: Developer 2000

. Performance Tuning: Analyze SQL, Inspect SQL

. Extending Oracle Applications (ERP): Developer 2000

. Enterprise Integration Framework

. Oracle Architecture and Administration

. Oracle SQL and PLSQL

. Oracle Backup and Recovery

. Oracle Hyperion

Contact this candidate