Shankar Murthy

Professional Resume

Position Qualifications

Shankar Murthy has over 21 years of experience in various roles as Project

Manager, Finance Controller/ with Architecture/Development expertise in

Oracle 7.3,8.0,8i,9i,10G, Oracle Applications 10.7, SC/11.03/11i/ - 11.5.8,

11.5.9,11.5.10/12 using General Ledger, Accounts Receivable, Accounts

Payable, Fixed Assets, Advanced Pricing, Inventory, Purchasing, BOM, Order

Management, Project Management modules,Order to Cash, procure to pay and

Data Warehousing.

He is a highly motivated oracle applications solution architect with over

10 years of experience transforming user requirements, designing detailed

specifications, designing, developing, architecting and implementing

creative solutions having Excellent analytical and problem-solving skills

with Proven communication, leadership, customer service, and presentation

skills.

Professional Experience

Senior Consultant

Cross Country Home Services

Jul 2013---

Current

. Mentoring Upgrade of Oracle Applications from 11.5.10 to 12.1.3.

. Developed the Architecture for Business Intelligence Reporting

. Designed the Functional/Technical specifications documents for Oracle

R12 customizations and conversions,

. Developed of Business Intelligence Reports in OBIEE, BI/XML Publisher.

. Designed and developed PL/SQL Packages as part of R12 Implementation.

. Designed and implemented support of Business Intelligence reporting to

be implemented as multi-platform architecture and related integration

methodology.

. Managing Client expectations on the migration and cut over strategies,

post production issues and overall implementation efforts.

. General Ledger, Fixed Assets and Receivables setups.

. Designing and developing FSG Reports, functional designs for

customizing accounts analysis reports.

Senior Consultant

Aerojet Rocketdyne

Nov

2012--- June 2013

. Worked on Oracle R12 -- Projects, Payables, Inventory, Fixed Assets,

BOM, Inventory, Purchasing, General Ledger and Order Management

Modules.

. Worked closely with the PMO, Business and Functional teams to design

and build, unit test XML Publisher Reports.

. Worked on Business Analysis, CR's, and the complete project

implementation life cycle.

. Developed documentation as per AIM methodology.

. Implemented customization in Fixed Assets, Re-designing, development,

testing and migrating across instances up to the Production.

. Used Bill of Materials API to import Bills of Material information

from product data management (PDM) system into Oracle Bills of

Material including revision information, bill comments, components,

substitute component and reference designator information in a very

user friendly manner without using cryptic ID's and system specific

information.

. Developed Pl/Sql packages, procedures and functions as part of R12

implementation in Oracle Projects, Receivables and Payables modules.

. Procure to Pay processes for both expense and inventory requirements;

including Purchasing Accounting,

. Receiving, Transaction Flows and Accruals.

. Procure to Pay process improvements for Purchasing, Payables and A/P

Accruals

. Monthly Close Reconciliation and Analysis for A/P Accruals.

. Resolved post GoLive inventory to A/P Accrual G/L reconciliation and

analysis challenges. Designed new reports to support reconciling

multiple Oracle EBS subledgers to the General Ledger.

. Had follow-up visit December 2012 to help resolve Oracle bugs with the

A/P Accrual processes. Subsequent patches broke the reconciliation

procedures; the A/P Accrual Reconciliation Report failed to correctly

identify purchase order lines with zero net amounts, causing detail

A/P Accrual reports to not equal summary A/P Accrual reports.

. Create Projects and Tasks Using AMG-Interface Error Report.

. Developed Interface Programs for data transfer between modules OM to

PA, PA to AR and legacy to PA.

. Designed and Developed of Business Intelligence Reports in OBIEE,

BI/XML Publisher.

Accelrys Inc --- San Diego, CA

May 2012--- Nov 2012

Senior Consultant

. Worked with PMO on a daily basis to provide regular project updates,

to manage project plan, cutover planning and instance

strategy.

. Working on an Upgrade project-from oracle R11i to Oracle R12

version 12.1.3.

. Implemented Oracle Best Practices in the approach to the upgrade,

implementing the custom solutions on various ETL, conversions,

interfaces, module configuration, instance planning, cutover, etc.

. Worked on designing cutover, providing Support during UAT, planning

post production support.

. Supported the maintenance and enhancements to existing customizations.

. Worked on Service Contracts, INV, Fixed Assets, PO, Order Management,

HRMS and Receivables modules.

. Set up the following in Fixed Assets: Key Flexfield Structures: Key,

Category, and Location

. Fiscal years and calendar

. Asset categories, and calendar periods

. System controls

. Asset Security by Books

. Prorate convention

. Book controls (corporate books)

. Salvage limits and locations

. ADI (excel) template to create mass additions

.

. Designed and Developed Conversion and Interface programs relating to

the modules mentioned above.

. Customized forms, reports and oracle packages.

. Customized depreciation, specified period, asset capitalization, etc

. Used API's for HR, Item and Service Contracts conversions.

. Designed and Developed XML Publisher and OBIEE reports.

. Supported end-to-end processes for:

o Order to Cash reporting improvements

o Procure to Pay reporting improvements for A/P Accruals

. Interacted with project manager and financial leads in the business to

gather requirements for the implementation of FAH

. Working with technical team for developing technical solution as

per business needs

Matson Navigation Company - Oakland, CA

December 2011 - May 2012

Oracle Project Manager

. Managing the onsite development team and the DBA's to coordinate the

customization of Payables, Purchasing and Receivables modules at

various stages of the conversions, interfaces, maintenance and

support, effectively managed changing client expectations and

transformation and migration of data from legacy into production

instance in oracle.

. Lead the Scoping, Triaging, Development, Testing, Reporting-worked

closely with the all levels of management in planning and implementing

the ETL, development, testing and migration efforts, instance

management and performance enhancement initiatives aimed at

facilitating seamless and effective implementation of interface and

conversion related applications.

. Managing issues at various stages of conversion and interfaces of the

all modules referred to above.

. Designed and Developed Oracle Packages (involved advanced Pl/Sql

Development), Oracle Forms and OAF Page Personalization in Purchasing,AP, Projects, INV, BOM, AR, and GL modules for converting and

interfacing data into Oracle.

. Worked regularly with the PMO in effectively managing the project

plan, designing cut over and post production support.

. Worked on Oracle Applications Release 12.1.3, Oracle 10G, Forms and

Reports 10g, GL, FA, AR, AP, INV, Purchasing, AOL and System

Administration modules.

. Prepared the (BR.100) setting up the Setups of Oracle General Ledger,

Oracle Payable, Oracle Fixed Asset, Accounts Receivable.

. Oracle Fixed Assets (FA: Asset Creation process, Manual and Automatic,

awareness on key functions of Assets Flex fields creations, Awareness

of Asset category definitions, Depreciation rule and methods ...etc.

. Working with the Business to design custom solutions for interfacing

and converting data from the legacy systems into oracle 12.1.3 aimed

towards improvising client's business processes.

. Responsible for Analyzing source system transactions and drive

requirement gathering towards FAH accounting.

. Preparation of design blueprint for accounting all source system

transactions - High level and detailed. (Process wise and granular).

. Development of rules and configure the SLA for centralized accounting

in Oracle GL.

. Supported end-to-end processes for:

o Plan to Procure

o Procure to Pay

.

.

UHG - Carlsbad CA

April 2011 - November 2011

Oracle Techno Functional Consultant

. Managed the various phases of SDLC-worked closely with the middle

level management in driving the development, testing and migration

efforts, instance management and performance enhancement initiatives

aimed at facilitating seamless and timely transition of customized

applications to production.

. Managed the development team consisting of functional consultants,

DBA's in the customization of Order Management, Inventory, Payables,

Purchasing and Receivables modules at various stages of the

conversions, interfaces, maintenance and support, effectively managed

changing client expectations, worked with the team in finding

practical, long serving solutions to achieve improved business

processes.

. Worked actively with the PMO in effectively coordinating functional

and technical development, documentation and migration aspects with

the offshore team, developing post production support strategy, etc.

. Worked on Oracle Applications Release 12, Oracle 10G, Forms and

Reports 10g, OM, INV, Purchasing, AOL and AR modules.

. Working with the Business to design custom solutions for Order

Processing and Fulfillment aimed towards improvising client's business

processes.

. Provided direction as well as hands on effort in resolving issues at

various stages of customization of the OM and AR modules.

. Designed and Developed Oracle Packages (involved advanced Pl/Sql

Development), Oracle Forms and OAF Page Personalization in OM and

Purchasing modules.

. Designed and Developed BI Publisher and XML Publisher Reports.

IBM - USA

August

2008 - April-2011

MANAGING CONSULTANT

. Leading the Implementation Team as Implementation Architect.

. Provided analysis, design, installation, and rollout of Oracle 11i

General Ledger, FA, Accounts Payable, and Purchasing, supply chain

including BOM for offshore and onshore projects worldwide.

. Completed module wise Setups included Multi Reporting Currency, Multi

Organization

. Coordinated and lead the entire phase of the project which included

initial operations analysis, business process re-evaluation, testing,

training, conversions, customizations and documentation and

implementation of modules

. Developed Project Plan, Gap Analysis Design and Roadmap for

implementing the project in distinct phases, Instance & Integration

Strategy, Development Standards, Cutover Strategy and Post Production

Support.

. Actively engaged in managing client expectation and client

relationships.

. Providing crucial coordination leadership and support to onsite cross

functional teams and offshore development team.

. Responsible of business requirements gathering and definition for the

FA implementation and production support.

. Lead the Data warehousing team in building Enterprise data warehouse

and a Financial Data warehouse. Responsible for defining the complete

data warehouse architecture (e.g. ODS, ETL process, Data Marts, EDW).

. Define data and technical architectures and technical requirements for

the data warehouse.

Direct and design the ETL process involving data quality and testing.

. Developed Financial Analysis Reports using FSG - for reporting

financial performance by product, cost center, company, etc.

. Developed Oracle Packages (involved advanced PL/SQL Development) on

various oracle customizations.

. Architected report design and documents for developing a

multifunctional MIS reporting - this involved use of Oracle 6i report

developer and Oracle Discoverer reporting tools.

. Designed customized reports, fit gap analysis, and all documentation

and deliverables.

. Designed and developed BI Publisher reports on multiple projects.

AMWAY CORP- Grand Rapids, MI

August 2010 - April 2011

Oracle Applications Senior Consultant

. Worked on upgrade of oracle 12.0.4 to 12.1.2.

. Designed and developed OAF page personalization in AR, AP, FA, OM, INV

and WMS modules.

. Designed AR, AP netting, customized OTC and P2P process flows.

. Designed developed Auditing SOLUTIONS as part of internal auditing

requirements of AMWAY.

. Evaluated various alternate solutions with the view point of

performance and maintainability.

. Developed custom packages, database triggers, etc as part of this

solution using advanced PL/SQL programming features.

. Defined and Tested: The required value sets and the Key Flexfield

structures, asset locations, asset calendar, Book Controls (only

corporate books), Prorate Conventions, Asset Categories, mass

additions, leases and asset security etc.

. Supported the defect resolution process by working closely with oracle

support and the functional teams.

. Worked with DBA and SYSTEM ADMINISTRATION teams to strategize

creation, maintenance and synchronization of various oracle instances.

INFOPRINT - Boulder CO, RICOH

May 2009 - July 2010

Oracle Applications Senior Consultant

.

Senior consultant responsible for converting and migrating all project and

project activities (Billing and Costing) for PB (Parsons Brinckerhoff)

project. Oracle Application 11i released 2.

Primarily responsible for

. Migrating all Project Templates, open and closed Projects, Tasks,

Financial Structures, Agreements, Detailed Funding and all types of

Budgets including project setups, project customers and contacts,

project players (Employees) and their assignments, Employee and Non

Labor Bill Rate overrides using AMG API.

. Migrating all Expenditure items for migrated projects at the detail

level including project, task, expenditure type, quantity, raw cost,

burdened cost, bill amount, billed(Yes/No), billable(Yes/No), billing

hold and comment.

. Convert billing events for each project, including all manual events

for billing and revenue purposes

. Created a comprehensive process to transform and import all Standard,

Retention and Net Zero Adjustments Invoices via creating invoice

events, PA Draft Invoices and import PA Draft invoices into AR

Invoices:

. Provided a drill-back to inquiry expenditure and any billing event

created at invoice line level

. Provided the ability to query and modify conversion expenditures and

invoices such as moving from non-billable to billable to create credit

memo.

. Transform and imported all existing revenue formulas into PA.

. Transform and imported all Invoice Retention set ups and rules as well

as amounts read from Project Retention Inquiry.

. Transferring Billing method values & billing amounts to PA.

. Imported AR Customers and Contacts and Cash Receipts into Oracle AR

to create Project Customers and Contacts

. Import all Employees and employee's assignments into HRMS to create

Project Key Members

. Dovetailing conversion solution towards augmenting client's business

practices and helping formulating long term oracle related client

initiatives.

. Worked with the functional team, the offshore and onsite development

team, MDMC team(Master Data Management) and the DBA's to coordinate

and support the implementation at various stages of the conversion,

effectively managed changing client expectations, worked with the team

in finding practical, long serving solutions to achieve custom

functionalities.

. Provided vital inputs and also actively participated in resolving

. Functional/technical issues through various stages of design and

development.

. Implemented the Inventory and Warehouse management System (WMS)API.

. Lead the Development, Testing, Reporting and Cutover team-developed a

sound cutover strategy, planning the deltas, sequential job runs,

allocation responsibilities to various teams as part of the cut over

plan, developed a restart strategy for failed jobs during cutover,

developed strategy for post production support.

. Developed interfaces and data conversion programs for applications

. Developed Oracle Packages, Procedures, Functions, database Triggers

(involved advanced Pl/SQL Development),

AMWAY CORP

August 2008 -

April 2009

Oracle Applications Techno Functional Consultant

. Techno functional Lead - Designed Conversion and Interfaces

. Estimating work, architecting system interfaces and conversions,

designing custom solutions, leading cross sectional team of

developers/DBA and System Administration, programming, scheduling,

designing and developing documentation and providing production

support.

. Designed conversions in Projects,AR, AP, GL, Installed Base, WMS,OM

and Inventory modules.

. Interfaced data from legacy sources into Projects modules.

. Designed and developed the project Budget interface (Grant API)

. Design and develop the project billing events interface (Both Revenue

and Billing)

. Developed oracle packages, Materialized views, customized procedures

and functions using advanced SQL and PL/SQL.

OFFICE DEPOT - Delray Beach, FL

August 2006 - July 2008

Oracle Applications Senior Consultant

Worked on Oracle Applications 11.5.10 implementation as Techno Functional

Manager

. Managed implementation projects, driving technical architecture

design, designing quality control processes, managed development,

application and achievement of client needs assessments to effectively

meet client specifications.

. Maintained proactive interaction with the client to understand

business practices to aid in system configuration

. Delivered data cleansing, master data management and preserving

historical dimensions using pl/sql for ETL functions.

. Setups of financial modules, Instance and Integration planning,

Business Case validations and Requirements Analysis, Developing and

validating Gap documentation, functional and technical design

documentation as per AIM Methodology - MD50, MD 70, code review and

testing, etc.

. Managed the Module wise Setup Validation, Instance Planning, Design

and Development of custom forms, reports, packages, and code

integration and migration tools like ITG, Subversion, middleware tools

like BPEL etc.

. Developed Custom Oracle Forms and Reports for the user interface;

using Oracle Developer Forms.

. Validated setups in GL, AR, FA, AP and Order Management.

. Developed customized solution for Oracle Fixed Assets 11i to resolve

depreciation issues

. Designed and customized end to end process for Procure to Pay and

Order to Cash.

. Upgraded Forms and Reports from 3.0/1.1 to 6i.

. Lead the interface effort to source customer and invoice data from

legacy system into oracle -worked with offshore and onsite development

teams and successfully completed the interface effort in the laid out

deadline.

. Implemented Taxware as part of AR implementation.

. Designed and developed performance testing strategies, cutover

planning design, job scheduling for smooth transition into production

and post-production support.

. Modules include GL, AP, AR, FA, OM, INV and PO.

US INTERNETWORKING - Annapolis, MD

September 2004 - July 2006

Oracle Applications Techno Functional Consultant

. Managed implementation of onsite/offshore projects. Employed MS

Projects, ITG and the like as tools to effectively manage projects,

provided leadership to a team of four, managed production time table,

status reporting, client/project team coordination, quality assurance,

etc.

. Worked on Oracle Applications Financials and Manufacturing modules --

GL, PROJECTS, AP, AR, CRM, INVENTORY, OM.

. Actively participated in resolving complex project issues concerning

multi-modular interfaces and integration in a non-networked

environment

. Performed process analysis, solution design, build, test, delivery,

and post production support for enterprise-wide General Ledger and

related documentation/deliverables

. Designed various data loading programs and documentation pertaining to

different project phases.

. Designed and developed various financial analysis reports using oracle

FSG.

. Developed Oracle Packages (involved application of advanced SQL and

PL/SQL Features.),

. Proactively interacted with client to understand their business

practices and configure the system accordingly

. Analyzed various business functions to derive benefits that would be

obtained in terms of cost rationalization and management control as a

result of the implementation

. Performed fit/gap analysis, pre-production business testing,

conference room pilot support, interface/conversion mapping, and

related documentation/deliverables

. Designing and developing customizations in the CRM module - including

opportunities, staging, win probabilities, staging, contact, and

product information to meet the client's business needs.

. Used API's to interface sales data to a custom web based interface

tool -NCM.

. Developing, maintaining and supporting applications including

interfaces and conversions for various clients in a distributed

environment.

. Worked as part of the team on selecting the appropriate tool for data

warehouse, building the architecture based on Star schema, planned ETL

strategy and designed BIS reports using Oracle Reports Developer.

. Developing and managing Accounts

PERRY ELLIS INTERNATIONAL - Miami, FL

August 2003 - September 2004

Senior Programmer Analyst

. Managing Projects for various departments like Accounts Payable,

Credit & Collections, etc.

. Developing and maintaining applications, conversions and interfaces

for Marketing, Accounting and Finance departments.

. Designed and Developed MIS Reports using Oracle Reports Developer and

FSG - to provide financial and Accounting Analysis reports to users in

Finance, Billing and Accounts departments. Worked on enhancement of

reports by creating summary columns, formula columns, displaying

percentages, drill down reporting, using lexical parameters, etc

. Providing support to users in various departments on a daily basis.

. Authoring standards for developing and maintaining applications.

. Working with Oracle Support on TAR's, applying patches bug fixes.

. Responsible for Module tuning by running optimizer programs, etc.

. Responsible for Oracle tuning - SQL and PL/SQL tuning -tuning for

determining optimal performance and maintenance of front end and

backend applications.

. Worked on Oracle Applications 11i 11.5.8, 11.5.9, Oracle 8i, Forms 6i,

Reports 6i, GL, AP, AR, FA, Sys admin, AOL modules

IGATE CORP - Oakdale, PA

July 1999 - July

2003

Software Engineer

. Specialty skills include: Waterfall and Agile Project Management

Methodology, Oracle Financials (GL, AP, AR, PO, FA, SA), business

requirement gathering, business analysis, training, implementations,

de-conversions, and post production support.

. Designing and developing Interfaces and Conversions for Payables,

General Ledger and Receivables modules.

. Worked as data warehousing developer -- was also responsible for

business analysis for data emanating from oracle applications.

. Designed and developed Functional and Technical specifications and

documentation for these interfaces and conversions using SQL and

PL/SQL.

. Developed packages, forms and reports relating to these interfaces and

conversions.

. Worked closely with the database and system administration team to

move the applications into the testing and production environments.

. Worked on Oracle Applications 11i - 11.5.8, Oracle 8i, Forms 6i,

Reports 6i, GL, AP, AR, Sys admin, AOL modules.

. Major Clients included GE, Motorola, Etrade, University of Chicago

Hospitals, Wheeling Pittsburgh Steel, Corning Inc, etc.

VARIOUS COMPANIES

November 1987 - July 1999

(IN THE MANUFACTURING, FINANCIAL AND GOVERNMENT SECTOR, India)

Finance Director

. Worked in various companies in the manufacturing/financial sectors in

various positions starting as an accounting executive and ending with

becoming the director on the board of a private company with

collaboration with Australian/American companies.

. Work experience ranged from executing finance, accounting and IT

assignments and culminated in discharging directorial

responsibilities.

. Key Skills Managed medium to short sized projects in the fields of

Information Technology, cloth manufacturing, Precision Sheet Metals,

Pharmaceutical Industry, etc.

. Functional skills include requirements gathering, functional gap

analysis, application design, managing development, configuration,

module setup, test script generation, instance and cutover planning,

training end users, and production support.

. Techno functional (technical lead, functional lead, lead developer,

etc.) activities including interfacing with users, identifying

functional and technical gaps

. Estimating work, architecting system interfaces and conversions,

designing custom solutions, leading cross sectional team of

developers/DBA and System Administration, programming, scheduling,

designing and developing documentation and providing production

support.

. Industry Experience lies in the areas of Manufacturing, High-tech,

Finance

Education

Bachelor of Science (Commerce)-(1983)

Key Courses and Training:

FUSION MIDDLEWARE -- BPEL, AIA, WEBLOGIC - 2006 -- 2009

Oracle Warehouse Builder (2007)

Essbase(2004)

Oracle RDBMS,PL/SQL, Accounts Payables, Accounting, Project Management from

Brain Bench Skills Authority(20002)

Validator--Brain Bench Skills Authority(2000)

Oracle Applications -- Kernex Micro Systems -- (1997)

CA --- The Institute of Chartered Accountants of India(1988)

Other relevant information:

THE INSTITUTE OF CHARTERED ACCOUNTANTS OF INDIA

FELLOW MEMBER

Contact this candidate