Ramprasad Kadiyala 408-***-**** ad0qzf@r.postjobfree.com

Summary

RamPrasad Kadiyala, Oracle Technical Consultant at Technomax LLC, has 15+ years of IT experience with 12 years in Oracle Developer SQL, PL/SQL and 5 years in UNIX, Oracle Developer 2000 Forms 6i,10g and Reports 6i,10g, BI Publisher and 2+ years of experience in Java, PostgreSQL and MySQL with Strong technical experience in Optimization, building oracle interfaces, conversions and experience in all phases of SDLC and Agile methodologies . Self-motivated with a positive attitude to meet/exceed goals unsupervised and in a team-oriented environment.

Academic Qualification

Master of Computer Applications (M.C.A) from Periyar University.

Bachelor of Electronics (B.Sc) from Osmania University

Skill Set

OS : Windows 95/98/NT, LINUX

Languages/Scripting : SQL, PL/SQL, Unix Shell Scripting, Java, Java Webservices, Python,

HTML, CSS and JavaScript.

Databases : Oracle 12c, MySQL, PostgreSQL, Couchbase DB

GUI : Developer 2000, Oracle Applications 11i, R12

Tools : Oracle Developer 2000 Forms 6i,10g and Reports 6i,10g Oracle Workflows,

SQL Developer, TOAD, SQL *Loader, Kintana, LiveLink, QVCS, SQL*Loader,

BI Publisher.

Code Repository : GITHUB and GITLAB

Professional Summary

Oracle Technical Consultant at

PRIMO North America, Atlanta, USA. Aug 2012 to Till Date

Skills : Oracle SQL, PL/SQL, Developer 2000 Forms 6i,10g and Reports 6i,10g, Couchbase DB, Unix Schell Scripting, ETL, Informatica Power Center, HTML,CSS, JavaScript, XML, Java, Java(REST and SOAP) and JSON.

Roles and Responsibilities:

Optimizing and Improving Performance on Long Running Oracle PL/SQL Based Concurrent Programs using Oracle Partition Feature to dynamically handling read time data that gets interfaced from different sources of web based and App based Applications.

Create Change log Triggers and Compound Triggers to read/write inbound and outbound data to Salesforce from Oracle and from Oracle to Salesforce.

Create Normal Oracle Views to read data from Active and History Partitions on real time and Materialized views.

Extracting Transactional Data from ERP and pulling to DW, with Informatica by writing certain Formula Expressions during ETL Process.

Data Modeling and Analyze Requirements and layout Architectural Flow Diagrams and Integration with External Systems.

Develop Hierarchy vs Revenue Reports using PL/SQL and HTML with UTIL_FILE.

Developed Oracle PLSQL Packages with Store Procedures to parse the data that comes thru upstream applications in sort of XML format, procedure will parse the large data set XML’s and process the transactions using XML DB Methods and Pl/SQL Tables.

Integrate with Internal System Database objects with ERP Suite R12 Modules Order Management and Account Receivables and with Salesforce CRM System.

Developed Oracle PLSQL Packages with Store Procedures and Functions and integrated with Java Restful web services API’s and SOAP for WMS Implementation.

Optimizing Long running process and Tuning SQL Queries using EXPLAIN Plan using TKPROF Tool.

Developed Python Scripts to Modify the PL/SQL Object Files in Bulk to Override the default attributes as an automation process.

Develop RICE components and Customizations to Oracle Forms10g Builder, Oracle Forms9i, Reports 9i, Bi Publisher and Workflow builder.

Developed existing Java classes to pass additional attributes to Oracle that comes from iOs applications integrated with Couchbase DB.

Development of New Forms and Reports and Customize existing Forms and Reports based on the requirements using Forms 6i Developer 2000 Forms 6i & Reports 6i.

Created Oracle PLSQL based Triggers to sync Outbound, Inbound Applications and Relational Databases and Non-Relational Unstructured Document Data Base Couchbase DB.

Tuning Long running SQL’s and tracing out bottle necks of the highest sql’s thru Trace files.

Developed Shell Script’s to read files from inbound directories processing the files and writing back to the outbound directories to avail it for upstream and down stream applications.

Developed Shell Script’s to read files from EDI Inbound directories to the process data and move them staging tables using Control Files and SQL Files.

Shell Scripts to SFTP and FTP files to External Client Systems for file processing for Cash Apps related and SFTP and FTP Files to Third Party Clients Working directories.

Collaborate with Scrum and functional teams to review requirements, provide estimates and perform map and gap analysis.

Collaborate with Scrum and functional teams to review requirements, documenting requirements in Confluence Page, Identifying Java Webservices Integrated with Oracle API’s, creating Jira Ticket for the changes needed based on new Requirements.

Manage Code in GITHUB.

Work with Cross Functional Teams to Demonstrate the flow before moving the code to QA Testing and support PROD issues Post Production.

Creating Jira Stories based on the requirements and Create WBS to align with Project Plan.

Working with required stake holders and follow SDLC starting from Solutioning Data Model and Architecture, design, development, test, and deploy the solutions to test Instance and Co-ordinate with Functional and IT Managers and Post Production Support.

Module and Project Lead at Tech Mahindra

Cisco Systems Inc, California, USA. Nov 2005 to Aug 2012.

Skills : Oracle SQL,PL/SQL, Unix Schell Scripting, Java, Developer 2000 Forms6I and Reports.

Roles and Responsibilities:

Understanding the Business/Client requirements for designing functional

-Technical Design Documents.

Requirements Gathering, Analysis and Problem Identification & Provide Solution.

Identifying the Gaps in process and providing the solutions to fix the existing issues.

Designing Functional Specification & Technical Specification Document for the release wise by interacting cross functional teams like Business, Project Team & QA.

Developed stored procedures triggers and complex packages using PL/SQL.

Optimized the existing long running PL/SQL packages by modularized programming & with Advanced SQL & PL/SQL features and reduced context switching.

Analyze & pulling up the Long running SQL Queries, optimizing them using EXPLAIN PLAN/TKPROF and improved the Performance of Queries.

Writing Unit Test cases and testing after completion of the Object.

Reviewing the QA Test Cases to ensure the E2E Functional Testing.

Developed new Reports using XML Publisher to show re-pricing values of Service Items.

Played an active role in Analysis of the specifications provided by the clients and Coordinated with other teams for clarifications and support during development.

Responsible for overseeing the Quality procedures related to the project.

Executive Systems at Mascon Global Limited for

Florida Rock Industries, USA. July 2003 to June 2005

Oracle Forms Developer 2000 6i & Reports 6i, Java, JSP & MySQL.

Roles & Responsibilities:

Understanding the User/Client requirements and design the functional Requirements

Design Detail Design Specification and Architectural Design Specification.

Designing Oracle Forms with Oracle Forms Designer to create form level, block level and item level triggers using forms generator and then customize it.

Development of New Modules (CEMENT Systems) in Forms 4.5, Developer 2000 Forms 6i & Reports 6i.

Enhancements of the Existing Modules depending upon the client request.

Logical & Physical Table designs in Oracle 9i.

Writing, Debugging of PL/SQL, Stored Procedures and Functions.

Detailed the User Interface Guidelines for the system.

Used Java servlets as a controller to forward an appropriate request and provide a suitable response.

Developed Java class files for taking care business logic.

Designed GUI front-end using HTML, DHTML and involved in client side validation using JavaScript.

Developed sales Module to add up new products online without any additional effort.

Personal Profile

Full Name : Ramprasad Kadiyala

Phone No : 408-***-****

Nationality : Indian

Visa : Green Card

Current Location : Alpharetta, GA, 30004.

Email Id : ad0qzf@r.postjobfree.com

Contact this candidate