Sunil Bheemireddy

acg3bu@r.postjobfree.com

847-***-****

Summary:

. OCA certified Professional with 8+ years of IT experience as an Oracle

Apps Techno-Functional Consultant.

. Extensive work experience with the modules like Inventory, Advance

Pricing, Bills of Materials (BOM), Order Management and Application

Developer.

. Proficient in functional flow of Order to Cash (O2C) and Procure to Pay

(P2P) cycles

. Techno-Functional Consultant with Implementation, Up-gradation,

Customization and Production Support of P2P and O2C cycles of Oracle

Applications 11i and R12 environments.

. Extensively worked on Pricing (Pricelists, Modifiers and Qualifiers),

BOM, Item Categories conversions.

. Solid experience in developing conversion programs and open interfaces

(Inbound and Outbound).

. Has a good logical skill suitable for Process Design, Development and

Implementation.

. Hands on in Oracle Tools such as Oracle Forms Builder, BI Publisher

Reports and GRC controls.

. Data migration strategy, approach, conversion and reconciliation

activities. Leading and guiding the project team towards deliverables.

. Expertise in writing Packages, Procedures, Functions, Triggers and

Cursors.

. Expertise in doing AOL Configurations such as Concurrent Programs,

Executables, Flex Fields and Value sets.

. Designed Technical Documentation using AIM Methodologies (MD50, MD70 and

CV40).

. Experience in complete software product development life cycle (SDLC):

System Analysis, Design, Development, Testing and Deployment.

. Experience in successfully delivering large scale business transformation

programs and Global Roll-outs.

Computers Worked on:

Computer System: Windows/UNIX

Programming Languages: C, SQL, PL/SQL, UNIX Shell Scripting, Oracle

Application Framework.

Special Software: Data Migration Tool, D2K (Forms & Reports), Oracle

Workflow Builder 2.6, PLSQL Developer, SQL Loader, DOORS, Toad, IPMS,

Rational Rose, OraExcel.

Education:

Bachelor of Technology (B. TECH) in Information Technology passed out in

the year May-2006 from Jawaharlal Nehru Technological University.

Professional Experience:

Title: MSI - Zebra Separation Project

Mar 2014 - till date

Client Name: Motorola Solutions Inc. Schaumburg, Illinois, USA.

Role: Onshore BSA

Project Description:

Motorola Solutions Inc (MSI) sold its Enterprise business (Enterprise

mobile computing, Bar-code scanning technology and Wireless LAN) to Zebra

Technologies. As part of the data separation activity between MSI & Zebra,

we have involved in converting the Master data from MSI global R12 instance

to Zebra R12 instance.

This project involves in

developing master data conversions, Open Interfaces and transactional data

conversions from MSI to Zebra Oracle R12 instance.

Responsibilities:

. Involved in discussions with MSI stake holders for gathering the

requirements.

. Involved in preparing CR document in DOORS and in responsible for

getting the Approvals from MSI.

. Responsible in migration of Master Data (BOMs, Item Categories and

Pricing) from the MSI Global R12 instance to Zebra R12 instance.

. Presenting the Technical Development Requirement Documents to the

stakeholders and getting Approvals.

. Preparing and Executing End to End System Testing and Regression

. Testing and involve in defect resolution.

. Involving in the design and coding of Customer Enhancements.

. Preparing and Executing End to End System Testing and Regression

Testing and involve in defect resolution.

. Coordinating and supporting the Business users during CAT (Customer

Acceptance Testing).

Hardware: Intel Pentium Processor

Operating System: Windows and UNIX

Languages: PL/SQL, UNIX Shell Programming and XML.

Version: Oracle Applications R12.1.1

Tools: TOAD, Oracle 10g, PLSQL Developer and Oracle Forms.

Modules: Oracle BOM, Inventory and Advanced Pricing.

Title: Supply chain Transformation from 11i to R12

Jan 2013 - Feb 2014

Client Name: Motorola Solutions Inc. Schaumburg, Illinois, USA.

Role: Onshore BSA

Project Description:

Motorola Solutions has most of its ERP applications running on Oracle Apps

11i versions for different regions.This has enabled the development of

process complexity, variation, and high cost. It also creates challenges

managing across sites. These issues can be eliminated by the transition to

a simplified, global supply chain process enabled by a single IT solution.

As part of Business Transformation program, they want to analyze the

transformation process of Oracle Applications R12 ERP Version. All legacy

application interfacing with Motorola ERP should be pointed to Oracle

Applications R12. This transformation will reduce cost, improve process

performance, and provide the agility required to meet the strategic

objectives of the EMS Supply Chain.

The scope of this project

is to transform the existing Motorola Solutions Supply Chain process and

systems to align to a common standard. Determine best practice processes

and roll out globally. Enable key Supply Chain strategy of "Anything,

Anywhere". Implement a best in class demand planning and S&OP process.

Target improvement to key supply chain operations KPI's. Simplify IT

architecture and retire legacy applications.

The project involves developing interfaces and converting master and

transactional data from multiple regional instances of Oracle Applications

to a single Global Oracle R12 instance, developing WRICE components using

Oracle Developer Suite 10g and PL/SQL scripting.

Responsibilities:

. Involved in discussions with Customers for gathering the requirements.

. Developing conversion programs to convert various master level data

. Like Item Categories, BOMs and Pricing data from Regional Oracle 11i

instances to Global R12 instance.

. Developing interfaces from external systems to Global R12 instance.

. Developing Forms and XML publisher reports.

. Setting up the POC instance to determine the "To-Be" process.

. Developed the Interfaces by using Fusion Middleware.

. Presenting the Customer Requirements and Development Requirement

. Documents to the stakeholders and getting approvals.

. Involving in GAP and Impact Analysis for Customer Requirements.

. Preparing and Executing End to End System Testing and Regression

. Testing and involve in defect resolution.

. Coordinating and supporting the Business users during CAT (Customer

. Acceptance Testing).

Hardware: Intel Pentium Processor

Operating System: Windows and UNIX

Languages: PL/SQL, UNIX Shell Programming and XML.

Version: Oracle Applications R12.1.1

Tools: Jdeveloper, TOAD, PLSQL Developer, Fusion Middle Ware, Oracle 10g

and Oracle Forms.

Modules: Oracle Advanced Pricing, Inventory, OM and Oracle GRCC.

Title: Supply Chain Transformation from SAP to R12

Sep 2010 - Dec 2012

Client Name: Motorola Solutions ODC, Schaumburg, Illinois, USA

Role: Onshore Module Lead.

Project Description:

Motorola Solutions has most of its ERP applications running on SAP, Oracle

Apps 11i versions for different regions.This has enabled the development of

process complexity, variation, and high cost. It also creates challenges

managing across sites. These issues can be eliminated by the transition to

a simplified, global supply chain process enabled by a single IT solution.

As part of Business Transformation program, they want to analyze the

transformation process of Oracle Applications R12 ERP Version. All legacy

application interfacing with Motorola ERP should be pointed to Oracle

Applications R12. This transformation will reduce cost, improve process

performance, and provide the agility required to meet the strategic

objectives of the EMS Supply Chain.

The scope of this project

is to transform the existing Motorola Solutions Supply Chain process and

systems to align to a common standard. Determine best practice processes

and roll out globally. Enable key Supply Chain strategy of "Anything,

Anywhere". Implement a best in class demand planning and S&OP process.

Target improvement to key supply chain operations KPI's. Simplify IT

architecture and retire legacy applications.

The project involves developing interfaces and converting master and

transactional data from multiple regional instances of Oracle Applications

and SAP to a single Global Oracle R12 instance, developing WRICE components

using Oracle Developer Suite 10g and PL/SQL scripting.

Responsibilities:

. Involved in discussions with Customers for gathering the requirements.

. Developing conversion programs to convert various master level data

. From Regional Oracle 11i instances and SAP to Global R12 instance.

. Developing interfaces from external systems to Global R12 instance via

. Fusion Middleware.

. Developed XML Publisher reports to generate the Barcode label.

. Setting up the POC instance to determine the "To-Be" process.

. Presenting the Customer Requirements and Development Requirement

. Documents to the stakeholders and getting approvals.

. Involving in GAP and Impact Analysis for Customer Requirements.

. Preparing and Executing End to End System Testing and Regression

. Testing and involve in defect resolution.

. Coordinating and supporting the Business users during CAT (Customer

. Acceptance Testing).

Hardware: Intel Pentium Processor

Operating System: Windows and UNIX

Languages: PL/SQL, UNIX Shell Programming and XML.

Version: Oracle Applications R12.1.1

Tools: Jdeveloper, TOAD, PLSQL Developer, Fusion Middle Ware, Oracle 10g

and Oracle Forms.

Modules: Oracle Purchasing, Inventory, BOM and Oracle GRCC.

Title: TTL OSS/BSS CRM Post Paid

Sep 2008 - Aug 2010

Client Name: Tata Teleservices Limited, India. Hyderabad, India.

Position: Offshore Module Lead.

Project Description:

Tata Teleservices Limited, along with Tata Teleservices (Maharashtra)

Limited, serves over 85 million customers across the country, with a

bouquet of telephony services encompassing the GSM, CDMA and 3G platforms,

offering Mobile Services, Wireless Desktop Phones, Public Booth Telephony

and Wire line Data Services across one unified and integrated brand-Tata

DOCOMO.

This project mainly deals with the Customer Relationship management (CRM)

with TTSL postpaid customers.

Key Responsibilities:

. Developed custom solution for Customer Relationship Management Systems

for TTSL Prepaid system.

. Involved both during Design and Development stages of application

development by PL/SQL Programs, Designing Forms and by writing UNIX Shell

scripts.

. Involved in development of new enhancements deployed for TATA

Teleservices Ltd which include automation of Caller tunes etc.

. Testing of New Releases, Roll Ups and Certifications.

. Training the new trainees for Functional and Technical knowledge.

. Involved in creation of Project Execution Plans for New Enhancements,

Releases and continuous coordination with Product Management Team.

. Developed archival purge scripts for custom tables to improve the

performance.

. Customer Support issues in Oracle CRM.

Version: Oracle Applications 11.5.10.

Tools: Clear Case LT (Version Control and System Admin), TOAD, Oracle 10g,

Forms and Reports 10 g.

Operating System: Windows and UNIX

Title: JPMC Customer Consolidation, Phase-III.

Aug 2007 - Aug 2008

Client Name: JPMorgan & Co, USA. TCS, Chennai.

Position: Asst System Engineer.

Project Description:

Played an active role in the re-engineering Project for the world's 2nd

largest Bank - JPMorgan & Co. The scope of this project is to migrate and

consolidate the Customer and customer relationship data at SBS SOR (IMS-

DB) level to the INDEX level.

The JPMC CIS' (Customer Information System) comprises 2 separate

systems namely Strategic Banking System (SBS) and STARBASE (INDEX). Both

SBS and INDEX hold data pertaining to Customer and Customer relationships.

As part of this initiative, all the customer and customer relationship

database segments on SBS will be migrated to INDEX.

Key Responsibilities

. I have developed PL/SQL programs to access the customer information.

. Designed Forms, Reports and workflows in the various stages of the

development.

. Construction, testing, reviews and implementation support.

. Updating the skills and application specific knowledge for enhancing

productivity

. Provide training for new members of the team.

Version: Oracle Applications 11.5.9

Tools: Jdeveloper, TOAD, Oracle 10g, Forms and Reports 10g.

Title: CFB Acqstn-Data Migr (Offsh)

Apr 2007 - Jul 2007

Client Name: BB&T (Bank Branch and Trust), USA, TCS, Chennai.

Position: Asst System Engineer

Key Responsibilities

. I have developed Shell Script programs to load the customer data into

Oracle tables.

. Designed Reports and workflows in the various stages of the development.

. Construction, testing, reviews and implementation support.

. Updating the skills and application specific knowledge for enhancing

productivity.

Version: Oracle Applications 11.5.9

Tools: TOAD, Oracle 10g, Forms and Reports 6i

Contact this candidate