Email id: aczrdl@r.postjobfree.com

Cell: +1-719-***-****

Ramana Reddy Rangaiahgari

Profile

Having around 9 years of professional experience in Requirement Gathering, Analysis, Design and Development, Testing, Implementation and Production Support, Documentation and Delivery. Strong programming skills with diverse computer science experience. Sound analytical and problem solving skills with a good exposure to the key facets of leading teams to meet set objectives and ability to learn new technologies quickly.

Highly experienced in Software Design, Analysis, Coding, Development and Testing with specialization in ORACLE 12c/11g/10g based Client-Server and Three-Tier Computing Architecture, Database Design and Development, Implementation, Production Support & Maintenance and Quality Assurance.

Experience with various technologies such as Oracle, Structured Query Language(SQL), Procedural Language and Structured Query Language (PL/SQL), Oracle Application Express (APEX), Oracle Forms (11g/10g/9i) and Oracle Reports (11g/10g/9i), SQL Loader, shell scripting.

Extensive experience in writing/debugging Oracle Back-end PL/SQL development by writing Packages, Stored Procedures, Functions and Triggers. Strong knowledge in using Oracle built-in packages, Cursor management and Exception handling.

Experienced in creating and maintaining Database Objects like Tables, Views and Materialized views, Indexes, Constraints, Sequences, Synonyms and Database Links and Wrote complex PL/SQL subprograms, packages, procedures, functions and DB triggers to implement the business logic.

Experienced in Tuning application using Advanced PL/SQL (Analytical Functions, PL/SQL tables, Record type, Bulk Collects and Bulk Binds)

Experienced in Tuning using various types of Hints, Partitioning, Indexes, Explain Plan and TKProf.

Having good knowledge on ERP Modules CRM(IB/SA/TCA), OM, AR and GL.

Experienced in application fine-tuning and database fine-tuning using Explain Plan and analysis tools, Monitor performance and identify bottlenecks and System Tuning and Monitoring indexes and analyzing their status for performance tuning and query optimization.

Expertise in design and develop Archive and Purge Framework for Large-scale Enterprise applications.

Proficiency in Technical Project Delivery, Installation and Configuration of Software Components.

Applications modules to import data from various sources using PL/SQL, Shell Scripts and SQL Loader.

Experienced in scheduling batch jobs using DBMS Scheduler utilities.

Expert in writing UNIX korn/bash shell scripts for batch processing.

Expertise in usage of putty, File Transfer Protocol (FTP) and secure Transfer Protocol (sftp) tools to connect to remote server and for file transfer etc.

Experienced in using version control tools such as PVCS, Apache Subversion (SVN).

Experience in Agile and waterfall Methodologies.

Involved in various activities like preparation of functional and technical documents, discussions with the client regarding the proposed solution, PL/SQL programs scripts, related reports and forms, unit level and user acceptance testing.

Excellent interpersonal skills and professional communication skills and have worked extensively in a team oriented environment with a strong desire to achieve specified goals.

Worked extensively with the Onsite–Offshore model, Co-ordination with clients/users and understanding client requirements

Skill Set

ERP Tools : Oracle Applications 11i

Database and GUI : Oracle Form Builder, Oracle Report builder, Oracle 9i/10g/12c

Development Tools :Toad, PL/SQL Developer, PVCS (Version Control Tool), Defect Management Tools(HP Quality Center, BMC Remedy), Kintana (Migration Tool).

Functional Modules :Install Base and Service Contracts, TCA, AR and

Order Management.

Languages : Oracle SQL, PL/SQL,Java, Shell script

Operating System : Windows XP/00/98/95, Linux

Tools Experience : Toad, PVCS, SVN,Kintana, Rally, Tidal Job Scheduler and $Universe

Processes : IBM’s QMS (Quality Management System)

Education:

Bachelor of Technology in Electronics and Communications – 2006, Sri Krishna Devaraya University, Andhra Pradesh, India – Passed with 80%.

Professional Experience

Jul 14 – Till Date, Technical Consultant Cisco Systems Inc., San Jose, USA

Project Name : Next Generation CCRM

Client : Cisco Systems, Inc., San Jose, USA

Role : Application Developer

Organization : IBM India Pvt Ltd.

Period : Jul 14 – Till Date

Project Description:

Commitment Compliance & Revenue Manager (CCRM) is a tool for managing revenue deferrals related to Non Standard Deals. Its primary user group is Sales Finance. CCRM works on the account receivables side of the ERP and is used to provide customizations to the Order revenue recognition process. Using CCRM tool, users can apply different types of holds on ERP standard Orders. These holds are used to defer one or more of the following parameters: Bookings, COGS, Revenue and Invoice.

These deferred parameters get recognized once holds are released from the Order during acceptance phase. Next Generation CCRM (NGCCRM) is an enhancement/replacement of the existing CCRM application. Its goal is to eliminate capability gaps; reduce costs, and thereby improving efficiency. One of the goals of NGCCRM is to build in flexibility in the application so that RAO can manage future changes without having to go through the lengthy process of QTC IT approval or code change

Responsibilities :

As an Analyst involved in preparation of Functional specification document, Test Scenarios and test Cases by understanding the requirements analysis of the BRD specifications provided by the clients.

Developed a custom revenue adjustment application, for creating revenue adjustments, integrating with SLA Application and posting until GL.

Played an important role in analysis, requirements gathering, functional/technical design, development, deploying and unit testing.

Writing Extensive PL/SQL code for customizations as needed.

Creation of multiple database objects. Testing and Bug Fixing in application’s Functionality.

Interacting with client to understand the requirements and generating reports on different systems accordingly.

Attending the scrum calls and creation of tasks based on user story and update them in Rally tool.

Played an active role in preparing Quality documents like Inspection Review Report, code Review Report, Defect Tracking Form

Supporting various QC calls, PWC/Sox Audits and giving UAT (User Acceptance Testing) support.

Designed the reports using Reports as per user requirements. Created Reference and Master/Detail tables to store information. Tested forms and reports using test data.

Involved in analysis and tuning of SQL queries by using EXPLAIN PLAN and TKProf for faster and better performance of the SQL queries.

Involving in debugging and analyzing production issue and fix them as part of normalizations.

Provided extended support to help and fix the performance issues in production instance.

Automation of Audit processes and jobs monitoring.

Performing Month End Reconciliations at Account Level in End-to-End process.

Worked closely with DBA Team on Upgrading database from 10g to 12c and support issues post DB Upgrade.

In order to overcome performance bottlenecks, implemented alternate approaches like range partitioning of tables and use of various methods like global temporary tables etc.

Build a framework for Archive, Purge process for entire application, and automate it as daily job.

Interact with cross-functional team to understand business process and design end-to-end solutions.

Environment & Tools:

Windows XP, Oracle 12c, Oracle Developer 6i, Toad 9.0, PL/SQL and Oracle Apps 11.5.10.2.

PVCS : Project Version Control System for uploading the production data fix (PDF) scripts.

Kintana : To deploy the PDF’s

Tidal : It is a job Scheduler, to create and launch the concurrent programs

May 12 – Jul 14, Technical Consultant Applied Materials Inc., Santa Clara, USA

5. Project Name : Oracle Leap Applications

Client : Applied Materials, Santa Clara, USA

Role : Technical Consultant

Organization : IBM India Pvt Ltd.

Period : May – 12 to Jul - 14

Project Description:

Applied Materials Inc. is a leading manufacturer in Semiconductor, Flat panel displays for computers and Televisions. Oracle Leap Applications is an ERP Application (involved PO, INV & OM) used for managing the day to day activities related to their Manufacturing process, Inventory Management and MRP Planning.

Responsibilities:

Provided support on purchasing issues like PO’s stuck in workflows & maintenance of purchasing hierarchies across different plants.

Worked on fixing existing reports for performance issues.

Developed a number of custom reports in order to meet the business requirements.

Provided support for Inventory & Purchasing modules. Supported various functions like creation of new order types, Sales Person Credit setup, Buyer setup, Auto Create functions etc.

Monitoring the application and making sure it is stable without any issues.

Ensure jobs and audits are in line with project requirements, service level agreements and security policies.

Set up meetings with business for status reports and also ad hoc meetings for production issues.

Interacting with end users and addressing their recurring issues as enhancement requests.

Actively involved in Month end and Year end war room and closely work with end users.

Environment & Tools:

Windows XP, Oracle 9i, Oracle Developer 6i, Toad 9.0, PL/SQL and Oracle Apps 11.0.2.

PVCS : Project Version Control System for uploading the production data fix (PDF) scripts.

Kintana : To deploy the PDF’s

Nov 10 – May 12, Technical Team Lead Cisco Systems Inc., San Jose, USA

Project Name : Next Generation CCRM

Client : Cisco Systems, Inc., San Jose, USA

Role : Application Developer

Organization : IBM India Pvt Ltd.

Period : Nov -10 to May -12

Project Description:

Commitment Compliance & Revenue Manager (CCRM) is a tool for managing revenue deferrals related to Non Standard Deals. Its primary user group is Sales Finance. CCRM works on the account receivables side of the ERP and is used to provide customizations to the Order revenue recognition process. Using CCRM tool, users can apply different types of holds on ERP standard Orders. These holds are used to defer one or more of the following parameters: Bookings, COGS, Revenue and Invoice.

These deferred parameters get recognized once holds are released from the Order during acceptance phase. Next Generation CCRM (NGCCRM) is an enhancement/replacement of the existing CCRM application. It's goal is to eliminate capability gaps; reduce costs, and thereby improving efficiency. One of the goals of NGCCRM is to build in flexibility in the application so that RAO can manage future changes without having to go through the lengthy process of QTC IT approval or code change

Responsibilities :

As a Team member involved in preparation of Functional specification document, Test Scenarios and test Cases by understanding the requirements analysis of the BRD specifications provided by the clients.

Writing Extensive PL/SQL code for customizations as needed.

Strong Exposure in writing Simple and Complex SQLs, PL/SQL Functions and Procedures, Packages.

Creation of multiple database objects. Testing and Bug Fixing in application’s Functionality.

Scheduled different jobs using job. Submit and also using DBMS_Scheduler.

Worked on indexes, analyze and rebuilding indexes online and parallel hint.

Made use of collections in procedures to generate high performance queries and PL/SQL code.

Supporting various QC calls, PWC Audits and giving UAT(User Acceptance Testing) support.

Resolving the defects raised by QA Team within SLA.

Creating Kintana packages to migrate the objects to stage and production instances.

Environment & Tools:

Windows XP, Oracle 10g, Oracle Developer 6i, Toad 9.0, PL/SQL and Oracle Apps 11.5.10.2.

PVCS : Project Version control System for uploading the production data fix (PDF) scripts.

Kintana : To deploy the PDF’s

$ Universe : It is a job Scheduler, to create and launch the concurrent programs

Aug 09 – Nov 10, Application Developer Punjab & Sind Bank

Project Name : Punjab & Sind Bank CBS Customization

Client : Punjab & Sind Bank

Role : Technical Consultant for the Forms & Reports to be customized

and to be created newly

Period : Aug -09 to Nov 10

Description:

This project is mainly the customization of the Core Banking Product named SYMBOLS owned by a Singapore based company Sungard System Access. A joint venture between Satyam Computer Services Limited and Sungard System Access to implement Core Banking for one of the oldest banks in India, Punjab & Sind Bank which is almost 100 years old.

This product SYMBOLS is implemented in number of banks throughout the world very successfully. This is the first time SYMBOLS being implemented to an Indian Bank in India.

As the product being developed with Oracle Forms and Reports D2K, the customization part includes changing the existing forms and reports and creating brand new forms and reports along with some database changes needed like creating new tables and adding or removing some specific columns from the tables.

Responsibilities:

Modification of the existing Forms & Reports based on the customer requirements.

Creation of new Forms & Reports which ever needed as a part of customization of the product.

Modifying Database Objects according to the requirements.

Following standards mentioned by the customer in the product development.

Maintaining quality standards to provide better efficiency.

Conducting Defect Preventing Meetings, to minimize the defects that arise during product development and to reduce the cost to the company.

Testing the requirements which have been completed successfully.

Giving Knowledge Transfer to the new team members to make them aware of the procedures and processes being followed in the project.

Jul 07 – Aug 09, Technical Consultant Cisco Systems Inc., San Jose, USA.

Cisco replaced their old contract management system CSM In June of 2002 with the new Oracle based CRM system for continuing scalability to growing business needs and named it CIBER (Contract Installed Base and Entitlement Repository).

CIBER Applications are part of Oracle ERP Software Platform and the primary modules are IB, SA, IQT and SALT.

The heart of the CIBER system is the Installed Base. It acts as the central repository of Customer Product information.

The main sources for IB are Shipment (Order Entry), C3, CARAT, Inventory (Item Process) and Customer Process.

Shipment, C3 and CARAT follow IBAE (Installed Base Assimilation Engine) process for populating data into IB. Customer and Inventory processes use a similar Extract and Load process, for populating the information into CIBER TCA and Inv Schema (in CIBER Database) respectively, but not a strict IBAE process.

IB product information is used by the Service Agreements (Contracts) and Quoting tools (IQT, SMS, SCC)

Quote is created through tools such as IQT and SCC. A link for auto-invoicing is created at this juncture. The products can be added in the quote either through Sales Orders or through Import Engine. After the quote gets converted into a Contract (Service Agreement), auto-invoicing is done in AR module and the data flow between IQT and the EC Engine enables AR.

As a team member, I am responsible for

To see that the production cases are well addressed and properly managed.

To see the Application is stable.

Creating and monitoring the $U concurrent jobs (programs)

Determine and analyze the data involved in the conversions and interfaces. Worked closely with the client technical team to ensure that the data was brought over accurately from multiple disparate systems.

Maintaining proactive interaction with the client to understand business practices to aid in system configuration

Environment: Oracle Applications 11i, Oracle 9i Database

Team Size : 12

Nov 06 – Jul 07 Developer/Designer Satyam Computer Services Ltd., Hyderabad.

Single Trading Company (STC), as part of the larger Commerce Transformation program, is an opportunity for Cisco to stimulate growth and to meet customer demands by conducting business with local presence in emerging countries.

This (STC) initiative has been brought forward to the business demand for direct selling capabilities (product, service, software) in more Countries. It is focused on building the right back-end (legal entity/ buy-sell structure) to support the next decade of global growth. Direct selling capabilities are a competitive necessity, particularly in emerging countries.

As a team member, I am responsible for

• Analysis of the specifications provided by the clients

• Design and Development of code as per standards

• Perform enhancements required to implement necessary Optimization.

• Registration and execution of Concurrent Programs using AOL

• Designed the technical documentation.

• Worked on tools like PVCS and KINTANA for data migration from one instance to another

Environment & Tools:

Windows XP, Oracle 9i, Toad 8.5, SQL, PL/SQL and Oracle Applications 11.5.10.2

PVCS : Project Version control System for uploading code

Kintana : Used to migrate the code from one instance to another

Training:

Oracle Performance Tuning 10g.

Oracle Advanced PL/SQL 10g concepts.

Oracle Service Contracts and Install Base Modules in CRM.

Oracle Inventory, PO and Order Management Functionality

Trained on Java and Oracle ADF.

References: Available upon request

Contact this candidate