Venkatesh Jagadeeshwara

Sunnyvale, California ***87

408-***-**** • adkj1t@r.postjobfree.com • LinkedIn

Senior-Level IT Consultant

Multifaceted Business Analyst career with proven track record of innovation and success

Talented information technology (IT) consultant with an extensive background in providing excellent services across a versatile selection of clients. Highly experienced with Oracle E-Business Suite, with primary focuses on supply chain modules, system upgrade/transformation, and business analysis. Experience in wide variety of systems including Zuora, the leading SaaS/PaaS based Subscription platform, migration of Dash board sources from various Databases to Snowflake. Showcase capable team leadership/management of in-house and off-shore technical service teams. Ready to target applicable employment in business applications development and support-related positions. Core Competencies include:

IT Consultation

Data Migration

Systems Support & Engineering

Data Auditing

Team Leadership & Development

Systems/Business Analysis

Problem Resolution / Troubleshooting

Oracle E-Business Applications R12

Oracle instance merging

Data Modeling

Install Base/Service Contract

Understanding of Oracle Inventory Cloud and OM Cloud

Order to Cash/Pricing/Inventory

Snowflake

Migration from On-premise to Snowflake

Zuora Subscription Platform

Professional Experience

Cisco, San Jose, California

Principal IT Consultant, 06/2019 – Current

Part of the Business team involved in migration/identification of Dash Board Data Sources from Variety of Databases to Snowflake, Master Data Management in Oracle R12 Inventory and BOM and designing custom tools to view Oracle EBS R12 Supply Chain data.

Key Contributions:

As part of MDM, Designed and developed various Compliance report which would alert the Business users about the Master data quality/integrity with focus on Inventory and BOM modules. Oracle Alerts were used to deliver the report based on a schedule and user list

As part of MDM, Designed and Developed tools for quick view of critical Master Data related to Item Master, BOM, B2B communication about changes to Master data to Partners, Manufacturer and their Part numbers using CGI-Perl

Worked on Comprehensive User story creation for the migration of Data Elements associated with existing and new Tableau Dashboards from various sources to Snowflake covering around 150 use cases covering the functionalities of Prod-Ops and Global Planning.

Worked with Various stakeholders, followed up to get the Objects created in Snowflake and obtained sign offs for the User story.

Converted Source queries for 100+ dashboards to Snowflake compatible

Involved in analysis and documentation of BO Reports whose Data Sources were targeted for migration from Teradata to Snowflake

Worked extensively on Data Modeling that would enable seamless migration from existing data source to Snowflake

Maintained information to track the user stories, data elements and the migration status

Involved in Validation and certification of Data migrated to Snowflake

Symantec, Mountain View, California

Principal IT Consultant, 10/2018 – 05/2019

Part of the Application team involved in design, development and implementation of Cloud Based Provisioning system integration in Oracle EBS R12 with focus on Inventory, Order To Cash (primary focus on Order Management), Service Contracts, Install Base and Supply Chain Modules.

Key Contributions:

Designed, Developed and implemented capturing of the New Service, Renewal, Upgrade & Downgrade, License split events and sending the request to common-cloud system

Designed, Developed and implemented comprehensive Provisioning status report

Worked on scheduling the Provisioning status report in APPWORX job scheduler

Configured and enabled User defined attribute to capture SFDC account id at Order header

Configured and enabled capture of Grace period days for a specific product model

Designed, Developed and implemented SFDC account ID correction process

Supported Business during New Product Introduction

Supported and answered Business user questions during UAT and Post Go-Live Phase

Worked on multiple support production support cases

Worked on Deliverables which were implemented using Agile Methodologies

Worked on Design of Business Process to extend the functionality available on Zuora Subscription platform onto Oracle EBS R12 Suite

Riverbed Technology, Sunnyvale California

Principal O2C Functional Support Analyst, 8/2018 – 9/2018

Part of the Application Support team involved in resolving production issues of the company's Oracle EBS R12 with focus on Oracle Order Management, Install Base,Service Contracts, Custom Quoting/configurator tool,Supply Chain Modules and SFDC.

Key Contributions:

Maintained and monitored production system.

Followed Best Practices, tools and procedures to enhance operations and increase efficiency

Analyzed and resolved issue related to Disti Order Transfer from Distributor to Oracle ERP

Analyzed and resolved Duplicate Salesrep_id issue during Order transfer from Custom Order configurator tool to Oracle EBS

Analyzed and resolved several issues related to keyserver(a custom token generation system) to Oracle interface

Worked on issues related to transfer of Asset information from Oracle to SFDC

As Part of Functional testing did end to end testing starting with creation of Opportunities in SFDC to Order Fulfillment in Oracle EBS

Worked with offshore team to correct defects found in Production

Symantec, Mountain View, California

Principal IT Analyst, 9/2017 – 5/2018

Part of the sustain team involved in resolving production issues of the company's Global subscription platform system(GSP) built around Zuora, a leading SaaS based Subscription platform system.

Key Contributions:

Maintained and monitored production system and provided triage support for GSP

Followed Best Practices, tools and procedures to enhance operations and increase efficiency

Resolved wide variety of Provisioning issues leading to increased productivity while meeting the SLA

Collected and sent out daily status reports

Worked with offshore team to correct defects found in Production

Designed, developed and deployed interface from Oracle Install Base to Zuora

Cisco, San Jose, California

Oracle EBS Consultant, 1/2012 – 9/2017

Oversee the analysis, design, development, and implementation of the company’s order management system, and related data migration, for eight different legal entities associated with Oracle E-Business (as transitioning from 11i to R12 release versions over the course of 28 months). Create, maintain, and evaluate CV040, Requirements Traceability Matrix (RTM), and Work Breakdown Structure (WBS) documents. Coordinate system development and testing, as well as post-live support, in conjunction with key stakeholders.

Key Contributions:

Key contributor in creation and evolution of Oracle E-Biz R12 global instance

Part of the team which was responsible for migrating Multi-Billion Dollar worth of Sales Order data with high accuracy from Oracle 11i and R12

Part of the team which migrated open, closed and Cancelled Sales orders, RMA, Holds, Custom Data and supporting Setups from 11i to R12 instance

Part of the team which migrated Archived Sales Orders, RMA, Custom Data and supporting Setups from 11i to R12 Instance

Worked closely with the boundary teams to help them extract the changes that were applied on the migrated data

Key contributor in Sun-setting the defunct 11i instance

Highly involved in planning, communicating and execution of different phases of Data Migration effort

Assisted project team in transforming Oracle E-Business Data from Release 11i to R12 including Stake holder engagement, Requirement capture, Application setups, key developments, obtaining approvals, bug and issue resolution.

Assisted project team in upgrading China 4a capabilities to 5a “Full Buy Sell” status in accordance with current value-added tax (VAT), tax reforms, and Chinese laws and regulations.

Validated and audited data migration from CG1PRD (global instance) to CL1PRD (China-specific instance).

Presented requirements and obtained sign-offs from key stakeholders.

Communicated data migration requirements to cross-functional and development team, while maintaining data mapping information.

Participated in change management and “bug” resolution process.

Served as one of the key members of order workflow data transformation.

Assisted project team in migrating Inventory items, categories, Revisions from 11i instance to R12 instance as part of foundational release. Worked on design documents, developed code, and participated in testing and deployment to production. Part of the team in designing and developing ongoing replication of items, categories and revisions from 11i instance to R12 instance. Participated in daily data issue review meetings and engaged in resolving issues by guiding the development team and suggesting the solutions to the issues reported.

Assisted project team in developing POC in NOSQL platform of MongoDB and Big Data ecosystem of Apache Hadoop, Map Reduce, Pig, Hive and Sqoop.

Senior Consultant, 4/2003 – 8/2009

Catalogued data required for sending legal notifications by analyzing and employing Oracle Flexfield application, while also providing documentation for field mappings on the customer creation screen and corresponding database table for Oracle release version 12. Participated in additional “map and gap” application analysis for database migration from Oracle to Teradata, as well as source identification for existing entity attributes (and for determining planned system availability). Merged two instances of customer management system (CIBER to C3) during an effort to upgrade and analyze patch scripts, migrate custom application tool data, and facilitate the design and development of items being transitioned to C3 systems (such as Service Agreement and IB) supporting the Service Product data Attribute Maintenance (SPAM) tool.

Key Contributions:

Conducted performance tuning and error resolution for the Oracle Application Database 9i upgrade that resulted in the SQL script degradation and the creation of invalid database objects.

Helped with movement of Asia Pacific customer ordering and transactions from U.S. buy-sell legal entity to a Netherland entity, including the testing, execution, and auditing of data migration scripts.

Involved in team-based data migration projects concerning the transition from Oracle Application 10.7 to 11i, including porting and implementation of customized data, the migration of 10.7 sales order cycle data to 11i workflow, and supplemental monitoring and troubleshooting during the upgrade process.

Symantec Corporation, Mount View, California

Consulting Business Analyst, 10/2009 – 6/2011

Instituted recommendations to troubleshoot critical data integrity issues, and address enhancements, for pricing/product data hub modules during the Stock Keeping Unit (SKU) Data Issue Resolution Project. Prepared functional business technical documentation and user acceptance test scripts, and managed application design specifications and production code migration approval documents to sustain production cut-over plan. Ensured accurate consulting revenue categorization by restructuring product line code, while utilizing Logical Apps extension tool to compile product line code for draft revenue and invoice processes. Procured requirements for users’ functional business documents, and drafted application design document for project design customizations. Supported all software development phases (including user training and post implementation).

Key Achievements:

Established Oracle Entity setup for Verisign integration into Symantec ERP(Verisign Day 1), and assisted with the functional design and configuration documents for the General Ledger and Operating units (as well as additional testing and migration planning).

Applied enhancements to existing invoice print program towards distribution of Delivery Acceptance form for Russian clients, and provided user acceptance testing and production cut-over for offshore developers.

Rectified custom pricing process for data integrity and performance point-of-view, including issue documentation and resolution across multiple project phases, and impact analysis of a recommended Oracle patch.

Analyzed, Designed, Developed and Implemented Product Line code restructuring to facilitate the capturing of correct product line code at Project task so that the consulting revenue is categorized correctly. Work involved customization using Logical Apps extension tool to capture Product line code at the Project task Level, Changes to Auto Accounting Rules in Oracle Projects module to make sure the Product line code is picked up by Draft revenue and Draft Invoice process while deriving the Revenue account. Closely worked with the Business users in gathering requirement and turning it into Functional Business requirement document. Worked on designing the customization by writing Application design document and worked on building the required customization to implement the project. Involved in all aspects of software development life cycle including user training, production cut over and post implementation support.

Additional Experience

VERITAS Software – Senior Consultant, Mount View, California

Silicon Graphics International – Senior Consultant, Mount View, California

Rapidigm, Inc. – Senior Consultant, Pittsburg, Pennsylvania

Datacons Ltd. – Senior Consultant, Bangalore, India

Sysnet Associates – Senior Consultant, Bangalore, India

Technical Proficiencies

Oracle E-Biz Modules:

Oracle EBS R12, Oracle EBS 11i, Oracle EBS 10.7

Oracle Order Management, Oracle Inventory, Oracle Bills of Material, Oracle Receivables, Oracle Project Accounting, Oracle Advance Pricing, Oracle Trading Community Architecture(TCA), Oracle Install Base, Oracle Service Contracts

Platforms:

UNIX, MS-DOS, VMS, MS Windows 10/7/2003/XP/2000/NT/95/58/3.1, SunOS

Languages:

C, Oracle PL/SQL. Pro C,Python, PyMongo

Cloud Based DW:

Snowflake

Nosql:

MongoDB

SaaS/PaaS Platform:

Zuora Subscription system

Tools:

Citrix, Cognos, Tableau, Kintana Object Migrator, PVCS Version Manager, ClearCase Version Manager, RDBMS (Oracle 12C, 10G/9.X/8.X/7.X/6.0, Ingres 6.2),Service Now Service Exchange, Jira Issue Tracking tool, Perforce Version control

Software:

Oracle Forms 2.3/3.0/4.0/4.5, Oracle Reports 1.1/2.0/2.5/6i, SQL Plus, PL/SQL, Developer/2000, Forms 4.5/2.3, SQL Forms 2.3/3.0, Ingres Report Writer, Ingres SQL

Hardware:

DEC 3400/5100, UNISYS U6000, SG Indy, IBM Compatibles, Pentium,Sun, Ultra Enterprise 10000, HP-9000, PC X86

Education and Credentials

Certificate Program in Business Analysis

UC Berkley Extension, Berkley, California

Bachelor of Computer Science and Engineering

Mysore University, Karnataka, India

Certifications

MongoDB for Developers – Course Completion Confirmation (MongoDB University)

Business Analysis Essentials and Planning / Elicitation, Requirements Management, and Communication / Enterprise and Requirements Analysis / Solution Assessment and Validation, Underlying Competencies – Student Achievement Report (UC Berkley Extension)

Currently hold American citizenship, and authorization to work in the U.S.

Contact this candidate