Software Engineer Oracle

MALLIKARJUN RAO SAJJAPURI

Mobile: +1-669-***-****

E-Mail: *.***********@*******.***

In quest of career enrichment, looking for an opportunity in IT industry where my Technical & Leadership skills with my objectives in tandem with company goals.

Professional Synopsis

Projects Executed

Project Title : Supply Chain Management – MAKE Track Overhaul (CIS-CIS-MD-MAKE-OFF)

Client : CISCO Systems Inc.

Duration : Since Nov’16

Location : San Jose, USA

Role : Lead Engineer L1

Technology : ORACLE, Angular6, SAP HANA & HADOOP

Description :

Cisco, a major multinational corporation that designs, manufactures, and sells networking equipment. With more than 100 billion assets, it has widely captured the market and leads in the networking business. Cisco has implemented ORACLE APPS software to support its business. The business is so complex and various system with various technology integrations, ORACLE itself has analysed and trying to bring a new module to suit such kind of business.

Cisco customized SCM (Supply Chain Management) flow into 4 tracks PLAN, SOURCE, MAKE and DELIVER. I work for the MAKE track, which forms the crest of the tracks and Order Fulfilment.

Post implementation of R12 migration project (Large Scale Services – LSS Project), Cisco took various initiatives to introduce new Enhancements & Customizations. Those are being handled under different projects which are “Fulfilment and Return Processes”, “Enable BOM (Bill Of Materials) Option Class for BTS (Bill to Stock) Fulfilment”, “Component Buy Sell”, “Drop Shipment”, “RTV (Return to Vendor) Stabilization”, “Brazil Localization”, “Cisco UOV Tool Implementation”, “Make Process Stabilization”, “Process Automation”, “DevSC”, “Fulfilment Flexibility” and “New Initiatives”.

Above mentioned projects were aligned to Quarterly & Monthly Releases spanning across many fiscal years. Approved scopes were being deployed to Production Environment successfully.

Responsibilities :

Developing UI (User Interface) Screens using Angular6, SAP HANA Views for Reporting, HIVE Queries for Analysis using HADOOP, Complex Oracle backend Objects and Oracle Application Development using OAF (Oracle Applications Framework), Collections in MangoDB

New Requirement discussions with Business & Users as a part Requirement Gathering & Analysis

Technical Challenges were put-forward during Functional review if any, to re-consider given Solution

Collaborate with Cross-Functional teams on the integration points between Make Track and other Tracks.

Discuss and Design Technical Solutions for new requirements

Preparing Technical documentation and reviewing with Client, Leads, Analysts and Team Members and taking approvals from Stakeholders.

Each Scope is reviewed from Solution through Coding & Deployments. Estimations were calculated based upon optimum efforts needed and submitted for Client Approval

Developing Complex Components which include creating or modifying PLSQL Packages, Forms & Reports, XML Publisher Reports, Ad hoc Reports and OAF pages as a part of the new requirements or enhancements

Providing continuous support to QA (Quality Analyst) Team during the Software Test Cycle

Driving FPR (Final Production Run), GO-LIVE (Quarterly and Monthly Release Cycles) and Production support immediately after the release until Production Support Team takes over

Providing KT session to the Production Support Team on Components delivered to Production Environment

Managing Business User Acceptance Testing (BAT) for every Release

Work on Cases reported by End Users during after Go-Live before Production Support Team Take Over

Deep analysis of reported Production Issues and discussing with Cross-Functional teams if needed. Code fix is taken up immediately, release to QA team for testing and then to Production once QA Team provide signs off

Conducting Daily Stand-Up Agile Scrum meetings for Projects following Agile Methodology to discuss Statuses and Impediments

Creating User Stories at Rally, Effort Estimations & Tracking for Agile projects

Maintaining code versions in AppDB (Cisco’s In-House Tool) and managing migration of Code to different instances through AppDB Deployment Tool

Handling & Delivering ad-hoc requests from Clients, Cross-Functional Teams & Leads which include Analysis, Minor Enhancement, Functional understanding or a new Innovate Idea

Works on Design & Approach to correct the Customer Issues in Production Environment when P1 (Priority) or P2 rose

Work on Process Design & Development for Purging Data from Custom Tables

Documentation of the environment, as well as migration and administration processes

Project Title : Large Scale Services – B2B (CISCO-CVCM-LSS MAKE-B2B)

Client : CISCO Systems

Duration : Apr’16 to Nov’16

Location : Bangalore, IND

Role : Technical Lead

Technology : ORACLE & HADOOP

Description :

Cisco, a Major Multinational Corporation that Designs, Manufactures and sells Networking equipment. With more than 100 billion assets, it has widely captured the Market and Leads in the Networking Business. Cisco has implemented ORACLE APPS software to support its Business. The Business is so complex and has various Systems with multiple Technologies. It maintains Integrations between all the systems. ORACLE itself has analysed and trying to bring a new Module in Oracle E-Business suite to suit such kind of Business.

Cisco customized SCM (Supply Chain Management) flow into 4 tracks PLAN, SOURCE, MAKE and DELIVER. I work for the MAKE track, which forms the crest of the tracks and Order Fulfilment.

As a part of LSS (Large Scale Services) Project, Cisco considered to Implement RosettaNet. RosettaNet is a Business Protocol that enables Enterprises to conduct Business over the Internet. The RosettaNet Consortium is an Independent, Non-Profit Consortium of Major Information Technology, Electronic Component and Semi-Conductor Manufacturing working to Create and Implement Industry-Wide, open process standards. These Processes are designed to Standardize the Electronic Business Interfaces used between participating Supply Chain Partners. The RosettaNet Implementation Framework (RNIF) specification is a Guideline for Applications that Implement RosettaNet Partner Interface Process (PIP). These PIPs are standardized Electronic Business Process used between trading Partners.

Responsibilities :

As a part of Requirement Analysis, discussions were carried out with Business for deep understanding and Analysing

Implementation of RosettaNet Implementation Framework (RNIF) v2.0.

Providing RosettaNet Implementation Framework (RNIF) technical advisories and providing Additional Information for RNIF 2.0

Implementation of Technical Recommendations which describes features or Enhancements

Understanding PIP Blueprint, its Components and Evaluation. Preparation of PIP Guidelines and publishing

Discussing and providing Technical solutions for new challenges.

Preparing Technical documentation (MD70) and Developing complex components if required.

Being a part of FPR (Final Production Run), GO-LIVE (Quarterly and Monthly Release) and Production support till Production Support Team takes over.

Works on Issues raised by End Users those were reported during Transition Period hand over to Production Support Team

Deep analysis of the issue reported and discussing with cross functional teams. If a fix needs to be provided, code is developed, release to Testing team and then to Production once testing team signs off.

Maintaining Code Versions in PVCS and Migrating to different Instances through APPDB Tool (Cisco In-House Project) and Kintana Packages.

Handling the Ad hoc requests from Cisco India (Client) Team which may include Analysis, Minor Enhancement and so on.

Our project is audited, Lean compliant and own an award.

For every step Management Took, we Support and provide WIN-WIN situation for the Client and Company.

Continuous interaction with the onsite team for exchanging Updates and how to proceed further.

Documentation of the environment, as well as Migration process and Administration processes.

Mentoring the new Joiners

Project Title : Large Scale Services – R12 Migration Project (CISCO-COVC-LSS-MAKE-CONS)

Client : CISCO Systems

Duration : Apr’13 to Mar’16

Location : Bangalore, IND

Role : Technical Lead

Technology : ORACLE & HADOOP

Description :

Cisco, a major multinational corporation that designs, manufactures, and sells networking equipment. With more than 100 billion assets, it has widely captured the market and leads in the networking business. Cisco has implemented ORACLE APPS software to support its business. The business is so complex and various system with various technology integrations, ORACLE itself has analysed and trying to bring a new module to suit such kind of business.

Cisco customized SCM (Supply Chain Management) flow into 4 tracks PLAN, SOURCE, MAKE and DELIVER. I work for the MAKE track, which forms the crest of the tracks and Order Fulfilment.

LSS (Large Scale Services) – R12 Migration Project involves migrating all Supply Chain Manufacturing functionalities from Oracle ERP 11i to R12 instance. It includes to Implement Systems & Processes designed to Support CTO (Configure to Order) and BTS (Bill to Stock) models. Also enable all Manufacturing Partner Sites in R12 Instance and integration with the Partner System via Business-to-Business RosettaNet Standard Messages. Designed and led the team to implement Archive & Purge framework for MAKE track.

Responsibilities :

As a part of Requirement Analysis, discussions were carried out with Business for deep understanding and Analysing

Defining reality by putting forward any Technical Challenges if any during Functional Review. Concerns were raised if there any show stoppers.

Designing Technical solutions based upon Functional Reviews for the new requirements

Preparing Technical documentation and reviewing with Client, Leads, Analysts and Team Members and taking approvals from Stakeholders.

Each Scope is reviewed from Solution through Coding & Deployments. Estimations were calculated based upon optimum efforts needed and submitted for Client Approval

Developing complex components which include creating or modifying PLSQL Packages, Forms & Reports, XML Publisher Reports, OAF pages as a part of the new requirements or enhancements

Delegation of work to Team Members and Supporting them for Effective Deliverables

Providing continuous support to Quality Analyst (QA) Team during the Software Test Cycle

Driving FPR (Final Production Run), GO-LIVE (Quarterly and Monthly Release Cycles) and Production support immediately after the release until the production support takes over

Providing KT session to the Production Support Team on the components delivered to production

Building HIVE queries for TABLEAU team to build Reports

Managing Business User Acceptance Testing (BAT) for every release

Working on Production Cases reported by End Users during Production Support

Deep analysis of Issues reported and discussing with Cross-Functional teams if needed. Code fix is taken up immediately, release to Testing team and then to Production once testing team signs off

Maintaining the code versions in AppDB (Cisco’s In-House Tool) and migrating to different instances through AppDB Deployment Tool

I handle ad-hoc requests from Cross-Functional Teams, Leads & Clients which include Analysis, Minor Enhancement, Functional understanding or a new Innovate Idea

Works on Design & Approach to correct the Customer Issues in Production Environment when P1 (Priority) or P2 rose

Prepare QA Test Scenario & Strategy documents for every Release Cycle

Work on Process Design & Development for Purging Data from Custom Tables

Documentation of the environment, as well as migration and administration processes

Part of Process Simplification team to easy the Existing Process

To work from Client Side and present them Weekly Status Report during Weekly Meetings.

Work Forecast is reviewed with Client. Based on feedback, priority of Assigned Tasks were taken up and Delivered

Preparing MS Power Point Slides with Animation based upon the Client Requirement

Organizing Social Activities on Successful Releases

Reviewing each Team Members performance and sharing feedback to Manager during Appraisals

Possibility of Checking, Exploring to bring New Projects.

Project Title : CITIBANK

Duration : Aug’11 to Mar’13

Role : Senior Consultant

Technology : ORACLE Ecosystem Tools

Description :

Citibank, a major international bank, is the consumer banking arm of financial services giant Citigroup. Citibank has retail banking operations in more than 100 countries and territories around the world.

Responsibilities : SENIOR CONSULTANT & PIC AT OFFSHORE

Technical solutions for the new requirements.

Providing the production support, which involves handling critical and high priority tickets.

Discussing solutions for the enhancements with onsite team.

Handling the enhancements for Citibank for ASPAC region from offshore, which may include developing of packages, forms and reports.

Maintaining the code versions in PVCS.

Promotion of the codes to the testing environment with the help of the onsite team.

Unit testing and regression testing in the testing environment.

Investigate the cause of the issues of medium and high priority by replicating the same in the testing environment and providing the appropriate solution.

Documentation of the environment, migration process.

Provided the security access management by creating users/groups and folders.

Documentation of the environment, as well as migration and administration processes.

Ability to be on-call periodically as well as work outside of normal business hours to help with maintenance and administrative tasks.

Mentoring the new joiners to the team.

Project Title : SONY

Duration : Dec’09 to Jul’11

Role : Senior Software Engineer

Technology : ORACLE Ecosystem Tools

Description :

SONY has implemented ORACLE APPS Suite for its end-to-end business. ISEMICON project provides the production support for the same involving Inventory and Order Management modules.

Responsibilities : SENIOR SOFTWARE ENGINEER & POC AT OFFSHORE

Handling ARS’s of Critical and High priorities.

Monitoring, reporting (to the team) and fixing (as appropriate) failures related to scheduled jobs.

Make changes to scheduled jobs as and when necessary.

Investigating the cause of the issues by replicating the same in the testing instance and providing the appropriate solution.

Handling new enhancements from offshore.

Management of content and data migration through Dev, QA and Prod environments.

Preparing weekly and monthly reports including graphical reports, formula base and well-formatted reports according client requirements.

Provided the security access management by creating users/groups and folders.

Documentation of the environment, as well as migration and administration processes.

Ability to be on-call periodically as well as work outside of normal business hours to help with maintenance and administrative tasks.

Month end activities including clearing all the interfaces.

Raising ARR’s & creating scripts as a part of the fixing failure scheduled jobs.

Mentoring the new joiners to the team.

Involving in Testing of the new server and preparing the test cases.

Title : SONYFTV

Duration : Mar’09 to Nov’09

Role : Senior Software Engineer

Technology : ORACLE Ecosystem Tools

Description :

Sony implemented ORACLE APPS Suite for its end-to-end business. SONYFTV is the SONY FLATRON TV side project. We develop new packages and interfaces as and when the new requirement comes and also involved in tuning the SQL Queries.

Responsibilities : SENIOR SOFTWARE ENGINEER

Developing the interfaces.

Tuning SQL Queries.

Developing new PL/SQL Packages as and when requirement is given.

Investigating the issues when reported by the onsite person.-

Proactive monitoring of load and uptime for the BO environment.

Researching and implementing ways (via dev-test-prod cycle) towards continual stabilization of project.

Provided training for new joiners.

Title : EMERSON

Duration : Mar’08 to Feb’09

Role : Software Engineer

Technology : ORACLE Ecosystem Tools

Description :

MMI (Micro Motion Incorporation) Direct Order Entry Project. It is a development project mainly dealing with the merging (or automation) of Quoting module with the Order Management module, apart from the country wise rollouts.

Responsibilities : SOFTWARE ENGINEER

Functional Requirement gathering.

Developing XML Publisher Reports.

Developing new packages.

Modifications to the developed forms.

Fit Gap Analysis.

Deploy and testing the builds to TEST & PRODUCTION environments.

Preparing and providing the test cases.

Title : CISCO Systems

Duration : Jun’07 to Feb’08

Role : Software Engineer

Technology : PL/SQL

Description :

ICW is an end-to-end Customer Order Experience (COE) project. The customer can order, ship and close the order on a single page.

Responsibilities : SOFTWARE ENGINEER

Functional Requirement gathering.

Fit Gap Analysis.

Preparing Testing Cases for all the COE screens.

Developing new packages.

Testing the builds in TEST environment

Over 12 years of Experience as Oracle Techno-Functional Consultant, Data Analyst (Hadoop), UI (User Interface) Developer (Angular). It also includes Implementation, Upgrade and Customization of Oracle e-Business Suite Applications (R12, 11i), System & Case study, Fit Gap Analysis, Design, Development, API Integrations, SAP HANA Views and Post Implementation Maintenance.

Good hands on Experience on Angular6, HTML, Type Script, BootStrap, CSS, Java Script.

Good hands on experience on HADOOP ecosystem technologies Hive, PIG, HBASE & MAP REDUCE.

Good hands on Experience on PYTHON functional language.

Extensive experience in ‘Procure to Pay’ and ‘Order to Cash’ cycles Implementation, Migration and Customization of various modules in Oracle Applications with major focus in Order Management (OM), Inventory (INV), Purchase Orders (PO), Bill of Materials (BOM), Warehouse Management System (WMS), Configuration modules.

Hands-on experience in Data Conversion, Data Migration, Report Generation and Developing Interfaces between implemented modules in Oracle Applications.

Expert in Developing, Implementing and Customization of Oracle Applications R12 & 11i with RICE (Reports, Interfaces, Conversions, and Extensions) components in domain of Oracle Applications E-Business Suite.

Expertise in SQL and PL/SQL programming, proficient in writing Stored Procedures, Functions, Packages and Triggers.

Dextrous in developing and customizing Oracle Reports 10g/6i and XML Publisher Reports.

Proficient in developing Interfaces and Conversions to integrate Oracle Applications Modules to Import Data from various sources into Oracle Applications using PL/SQL, SQL*Loader.

Expert in Customizing Oracle Forms, Forms Personalization using Custom.pll and Zoom functionality.

Expert in Designing & Implementing Application object Library (AOL), Application Implementation Methodology (AIM), Multi Org Access Control process (MOAC), Trading Community Architecture (TCA) and Software Development Life Cycle (SDLC).

Well versed with client server environment and tools like SQL*Plus, PL/SQL, SQL*Loader, Toad, Oracle*Forms Builder, Oracle*Reports Builder, Workflow Builder, Discoverer Reports.

Experience in importing data from Legacy Systems to Oracle Applications using Oracle Interfacing, Oracle EDI, SQL LOADER, UTL_FILE, Oracle Packaged APIs etc.

Adroit in Performance Tuning for optimized results using tools like EXPLAIN PLAN, SQL TRACE, TKPROF, HINTS, UNIX shell scripting.

Expert in Preparing & Reviewing Functional Design Documents and Technical Design Documents.

Ability to handle user defined errors by developing Error-Handling Package using PL/SQL.

Knowledge in Data Warehousing concepts.

Good experience in migration tools – Rally, AppDB (Cisco Owned), Kintana, PVCS, HPQC, Remedy.

Well versed with Waterfall, Agile & DevOps Software Development Life Cycle methods.

Excel in Team Collaboration, Quick Adaptation and Problem Solving with Good Communication Skills.

Possess Excellent Troubleshooting, Interpersonal, Leadership and Time Management Skills.

Currently working as Lead Engineer at Cisco, USA Since Nov’16

Worked for Wipro Technologies as a Tech Lead during APR’13 – Nov’16.

Worked for ORACLE as a Senior Consultant during Aug’11 – APR’13.

Worked for Infosys Technologies Ltd., as Senior Software Engineer during Jan’07 – Jul’11.

Contact this candidate