VIJAYANAND

Oracle APEX / PLSQL Developer

[email protected]
https://www.linkedin.com/in/vijay-kandati-9b25b3109/
rok.co/@vkandati
+91-868-808-3491
________________________________________________________________________________

OBJECTIVE

Having around 2 years of experience in ORACLE APEX and 8+ years experience as Oracle PLSQL Developer
( Using PLSQL, UNIX, JAVASCRIPT Scripting ) web application development where I wish to be the part of better
workplace and could render my skillset enhancing the development process of Web Applications fulfilling the
needs of current trending market and taking Businesses to ONLINE ( CLOUD Computing ) and to lead
technologies in complete Business Automation.

PROFESSIONAL SUMMARY

Having around 8 Plus years of experience in developing large scale Enterprise level Business Applications ( both
Web and Desktop). Had taken part in mission critical real-time projects where clients include TUI Travels Plc(UK),
Presbyterian Healthcare System (United States), EMNOS GmbH (Germany), BRITISH TELECOM (BT), AZURE
SOLUTIONS (UK) and TATA STEEL (TISCO) at Jamshedpur. Had worked at client place onshore in UK with
excellent interpersonal skills and leadership abilities along with strong coding, debugging and testing skills in
CI/CD ( Continuous Integration & Deployment ) application Platforms.

TECHNICAL BACKGROUND

Oracle 10g Certified Associate (OCA)

Sun Certified Professional, SCP (Sun Certified System Administrator for Solaris 10 OS)
Certificate In Computing (CIC) from Indira Gandhi University (IGNOU)
PG Diploma in Computers Applications - PGCCA - CMC, Govt
Enterprise PG Diploma in Computers Applications - PGDCA ,NIIT

SKILLS ( Core and related awareness ) :

OS Platform WINDOWS, Solaris 10, Red Hat Linux, Ubuntu

Programming Languages Python, Core & Advanced Java, C/C++, Salesforce Apex, SQL, PL/SQL, HTML5
Scripting Languages Unix Shell (Bash, Ksh) , JavaScript, VBA, Batch , PowerShell, CSS3, Python, PHP
Web Frameworks / Libraries Django, Bootstrap, JQuery, Angular 2+ , Express, Node
Web related activities Domain Name Registration, Web Hosting services, Website Maintenance
ERP / CRM E-Business Suite, Salesforce
Salesforce Tools ( CLOUD Apex, VisualForce Pages, Triggers, Force.com API, Classic, Lightning, SOQL,
COMPUTING ) SOSL, Data Loader
Databases Oracle, MS Access, PostgreSQL, MongoDB, MySQL, SQL Server
Developer RAD Tools Developer /2000 (Forms & Reports), MS-Office 2017, ORACLE APEX
ERP / CRM Tools ORACLE APPS R12, AOL , RICEW, Concurrent Programs Registration,
Customization & Workflow ,XML Publisher
E-Commerce / POS Tools EMNOS
EBS12/Modules Oracle Financials(AP,AR,GL), P2P & O2C Cycles, OM, MFG(Discrete, Process),
Inventory
DW / ETL Tools ODI 12c/11g , INFORMATICA 9.6, DAC, OBIA, BI APPS, OWB
BI / Reporting Tools OBIEE 11g, BI Publisher, Jasper, APEX AOP, BIRT, Oracle Reports
SQL Utilities / Tools SQL *Loader, SQL *Plus, PLSQL Developer, SQL Developer, TOAD, FTP, Putty,
SFTP, WINSCP
Agile / Source Code Version SCRUM , GIT/GITHUB, JIRA, Rally Dev Software, Subversion SVN, CVS, Tortoise
Control SVN
Job Schedulers Cron, Control-M, Autosys, DAC, ODI Agents, DBMS_JOBS, UTL_FILE, UTL_SMTP

Confidential DEVBOT Technologies Pvt Limited Page No. 1

WORK HISTORY
 Working as Senior Technical Consultant for DEVBOT Technologies Pvt Limited, Chennai from May
2015 to Till Date
 Worked as Senior Technical Consultant for Sonata Software, Bangalore from Oct 2013 to Apr 2015
 Worked as Senior Technical Associate for Hitachi Consulting, Hyderabad from Nov 2010 to Oct 2013
 Worked as Senior Technical Associate for TechMahindra Ltd, Pune Feb 2004 to Jan 2009
 Worked as Oracle/Java Developer for TATA STEEL, Jamshedpur from Aug 2001 to Nov 2003

EXPERIENCE

DEVBOT Technologies Pvt Limited, Chennai

Role: SENIOR TECHNICAL CONSULTANT (JAVASCRIPT/ ORACLE )

1. DEVBOT Technologies Pvt Limited

Domain : Telecommunication and Aqua Mineral Solutions Duration : May '15 – Till Date

DEVBOT is involved completely into Wholesale & Retail Re-distribution, Sales in Telecom & Aqua Mineral
areas. Some of its client includes Lava, Lemon mobiles, I-smart, Mafe, M-tech , CELKON, OxyGem etc.
Responsibilities: As a Senior Technical Consultant and responsible for -
 Application Development using Oracle Application Express (APEX) and Oracle SQL, PL/SQL.
analysis, design, development, testing, implementation and maintenance of applications in
Oracle Application Express.
 Hands-on experience with Oracle APEX 3.2/4.0/4.1/4.2/5.0/5.1/18.1/19.1/20.1
 Create Apex pages, Master Detail Forms, Tabular forms, Apex Collections, Interactive reports,
Charts etc.
 Worked on APEX extensions using Web services (SOAP and Rest).
 APEX reports queries & report Layout,
 APEX Front end development, interactive grid, collections, APEX_MAIL and etc
 developing both web layout and paper lay out reports in various styles
 Integration of Oracle APEX with Oracle EBS
 Writing SQL queries, Views, Materialized views, Database links, PL/SQL procedures, functions,
packages, triggers, cursors, collections, Dynamic SQL.
 Concepts of PL/SQL Jobs, PL/SQL Schedulers
 Writing Technical design documents and developing unit test documents.
• Involved in developing Mapping, Scenarios, Interfaces , Target Load Plans, Scheduled Tasks and Applications.
• Preparing cost & work effort estimates.
• Monitored Application performance & Trained Users.
 Running the Control-M jobs to load data from source to target
 Implementation and deployment of FCUBS(Oracle core banking solution)
 Loading the flat / complex files into databases using python scripts & libraries
• Involved in the process of End-to-End Solution provisioning.
• Automating repeated tasks with python, ksh, bash scripts.
Environment: Windows 7 & 10, Oracle 11g, Oracle APEX (5 and 18), eBusiness Suite R12, Informatica 9.5,
ODI 11g/12c, FCUBS, MS Office 2007, Salesforce CRM, Toad, UNIX Shell, Python Django & JAVA, JavaScript
Frameworks, HTML5, CSS3

Sonata Software, Bangalore

Role: SENIOR JAVA/ ORACLE DEVELOPER

Cyrus - Revenue Management System Domain : Tours and Travel

Client : TUI Travels Plc, UK Duration : 14 Months Duration : March'14 – May'15
Cyrus is a Yield Management application. That is, it is intended to adjust the prices of inventories (flights and
accommodation) up and down, depending on demand, to maximize the profit on any one item. It does this
by taking the entire inventory, determining the load factor (how much has been booked).
Responsibilities: In a team of 28, I am working as a Senior Developer and responsible for -
• Involved in Developing Procedures, functions and Packages and other PL/SQL code units.
• Preparing estimates for new work.
• Preparing Unit test Plans, Unit Test Reports, Release checklists and User Support Documents.
• Working on Change Requests, Handling Service Requests and Incidents.
• Preparing the database on a multinode by running jobs extensively, and troubleshooting with the errors.
• Creating various Windows Batch Jobs to automate report generation, download in Excel & FTP/ SFTP /SCP
etc.
• Monitored application related jobs, data replication activities. Troubleshooting production issues.
Confidential DEVBOT Technologies Pvt Limited Page No. 2
Environment: Windows 8, Sun OS 5.10, Oracle 11g, Oracle APEX (5 and 18), Rally Dev
Software, Eclipse SVN, Salesforce CRM, Informatica 9.5, ODI 11g/12c,
OBIEE 11g, OBIA/BIAPPS, JavaScript Frameworks, Angular 2+ , HTML5, CSS3,
Python Django , JAVA

3. PHP ( Presbyterian Healthcare Plan ) Duration : 9 Months Duration : October'13 – March'14

Client : Presbyterian Healthcare System/Services, Albuquerque, New Mexico - United States
PHP - SRT (Service Request Team) automates the processing of Trading Partner specific members enrollment and
claims data into facets database. Each TP associate with PHP will send member’s enrollment data in the form of
EDI 834 format in monthly or biweekly basis. Modules included are Enrollment, Eligibility and Claims.
Responsibilities: As a Team Member was responsible for
 Involved in development of process EDI 834 Enrollment data into Facet Applications.
 Involved in Data Extract process of Eligibility and Claims Data and FTP to Trading Partners
 Involved in developing test cases for Unit testing.
 Needed to automate ETLs through Unix script and schedule it in Crontab in Unix (Solaris).
 Developed Automated Process Flow to group and execute above Maps in proper sequence.
 Responsible for code review and peer testing of code developed by team.
 Monitored scheduled jobs, data replication activities. Assisted in system integration, bug fixes.
 Automating functionalities in reports through Macro Codes.
Environment: Windows Server 2008 R2, Oracle 11g, FACETS 5.01, SQL Tools, Toad, MYSQL, OBIEE 11g, Informatica
9.5, OBIA/BIAPPS, JAVA, JavaScript, Angular 2+ , Angular CLI, HTML5, CSS3, PHP

Hitachi Consulting, Hyderabad

Role: SENIOR JAVA /ORACLE DEVELOPER

4. EMNOS GmbH Duration : 13 Months

EMNOS (Munich, Germany) is a preferred partner for delivering customer-centric growth bringing the retailers closer
to their customers than ever. Emnos serves big retailer clients like Carrefour (France), Albert Heijn (Netherlands) and
Loyalty Partner.
Responsibilities: As a Team Member was responsible for
 Written SQL and PL/SQL scripts for procedure, packages and triggers etc

 Development and customization of forms & reports based on client requirement.

 Client Interactions for technical & functional requirements and project related issues.
 Bug fixings in various environments. Requirement Analysis and participating in design.
 Code reviews and testing. Preparing documents on database and unix shells.
 Creating UNIX scripts to automatically schedule the job in Crontab (Solaris).
Environment: UNIX, Oracle 11g, Life ray, Alfresco, Adobe flex, Apache Tomcat web server, Python and J2EE

TechMahindra, Pune
Role: SENIOR JAVA /ORACLE DEVELOPER

5. BAL (Billing Access Layer) & GenIUS ASG, Milton Keynes, UK Duration : 14 Months
This is a Geneva Application Support, which primarily focuses on Customer Interaction like troubleshooting
queries to derive its resolution. Coordinating with offshore team for the other resolutions .
Responsibilities:
 Involved in checking and correcting data in order to facilitate billing.
 Was involved in testing and execution of various scripts in production live and on call Production support.
 Tuning SQL queries and performance monitoring and Production support for the Billing System.
 Coded Unix shell scripts for database administration, backup and performance monitoring.
 Documented all the Development/Test/Production Activities for the client Record.
 Performed the unit testing for the code and migrated the files through legacy system.
Environment: Windows 2003, Oracle 10g, XML, GENEVA, Java, MQ Series, Advanced Queuing, Web
Logic Server, JavaScript, HTML, CSS

6. BT Retail Customer ID Duration : 7 Months

BT’s IVR or CTI systems on 150 for customer service, pass the customer’s telephone number to the CustID system
and receive the customer tag, which is then translated into a Reason Code according to a set of rules also defined
using the CustID system. These codes have a meaning specific to the channel and direct it to handle the call in a
particular way.
Responsibilities:
 Writing Plsql packages comprises of stored procedures and functions used in the Application.
 Testing the overall functionality with the sample live data on development environment.
 Involved in remodeling of the system to accommodate new enhanced features.
 Achieving satisfactory time response for most of the widely used online transactions.
 Detecting and correcting instance performance problems. Locating and tuning SQL statements.

Confidential DEVBOT Technologies Pvt Limited Page No. 3

 Performed tasks associated with tuning of database systems for performance and efficiency
enhancements. Environment: Windows 2003 Adv Server, Oracle 10g, XML, Java, Shell Script, D2K

7. BT Directory Programme Duration : 18 Months

Maintenance of BT‘s employee data and to provide identity data feeds to all BT systems. All updates to
distribution directories are logged into history database. The Purpose of BT DEP project was to exploit history
logs and to design feeds to avail for OLAP to BT Managers in cost effective manner.
Responsibilities:
 Requirement gathering, System Analysis and design.
 Writing stored procedures and functions used in the Application
 Monitoring daily logs and taking appropriate actions in case of failures.
 Applied, tested & administered Patches in Development/Test/Production.
 Setting up daily monitoring jobs, automatic alert notification when database is down or on thresholds.
 Audit systems for backup and Disaster recovery. Designed databases for new requirements and
enhancements.

Environment: Windows 2003 Adv Server, Oracle 9i, Warehouse Builder (OWB), XML, Shell script, D2K

8. Bristol Operations (BOPS), British-Telecom Ltd, Newcastle upon Tyne (UK) Duration : 14 Months
The BOPS is an application which process orders for various products of BT. This Project is intended to process the
customer’s orders within agreed service level agreement.
Responsibilities:
 Exporting and processing the orders. Writing adhoc Shell scripts & provided 24/7 application support.
 Creation of Stored procedures, SQL Queries, Triggers, packages, views
 Developed scripts to automate database monitoring involved in find and re-validate invalid objects.
 Involved in Oracle Migration from 9i to 10g applying patches, managing RMAN backups.
 Performed bottleneck identification and system tuning for 1000 concurrent users for improved performance
 Provided 24x7 production supports on rotated basis.
Environment: Java, JavaScript, HTML, CSS , Solaris 9, SQL and Oracle 10g, Citrix, SQL Toad, Oracle Forms 6i &
Reports 6i

9. Atlas Sub-Ledger for Client Azure Solutions, UK Duration : 8 Months

This project supports the operation of the British Telecom Global Services (BT GS) Billing and Settlements unit.
The Atlas Sub-Ledger defines the functionality of supporting Settlements, Recording of Payments and Receipts.
Responsibilities:
 As a Senior Team Member (with a team size of 10) responsible for designing and coding of Settlement
module.
 Responsible for administering all the databases in the development and staging area.
 Plan data flows for a new or revised database. Train users on database methodologies.

 Re-Structured the design of tables & programs. Developed data validation procedures using PL/SQL.
 Provided month end support for the programs. Conducted performance tuning activities.
 Develop, Implement and enforce data security procedures. Coded Shell script for database
administration.
Environment: Java, JavaScript, HTML, CSS , Windows 2003 Server, Oracle 10g, and Developer 9i, OEM,
Shell Script, SQL*LOADER

TATA STEEL, Jamshedpur

Role: JAVA /ORACLE DEVELOPER

10. CRM-IS (COLD ROLLING MILL - INFORMATION SYSTEM) Duration : 9 Months

The scope of CRM Information System (CRM- IS) extends from the customer order acceptance to cold coil
dispatch to customers. The system has linkage to the Levels 2 (Automation Computers)/L1 (PLC'S
equipment computers.
Responsibilities:
 These include rearrangement of coils by dragging, Dropping of records and define coil work sequences.
 Translate Client's needs into Technical Design Document and Unit Test cases.
 Development and Enhancement of Forms and Reports. Designing the Database Logical structures.
 Writing Back-end Procedures, Packages, Functions and Triggers
 Took active part in creation of Interface Table & their Scripts, Telegram Tables & their DB
Triggers.
Environment: Java, JavaScript, HTML, CSS ,Windows 2000, HP/UX, Oracle 9i, Developer 9i, Oracle
9iAS, Java, Shell Script, SQL*LOADER

11. Engineering Shops Process Automation System (ESPAS) for TATA IRON AND STEEL Co. (TISCO), Jamshedpur
Duration : 6 Months

Confidential DEVBOT Technologies Pvt Limited Page No. 4

ES-PAS deals with the automation of the manual method for processing of Work Orders sent by various departments of
the West Bokaro Collieries Division. The key objective is to alleviate the difficulties in analysis of the jobs being done by
the ES.
Responsibilities:
 Analyzed and documented Impact analysis.
 High and low level redesign of the existing Database/system to incorporate the new
requirements.  Involved in the production support, maintenance and enhancement
processes within the system.  Wrote Unix shell scripts for database administration, backup
and performance monitoring.
 Developed Procedures, Functions, Packages. Prepared Technical Documentation for developed
Objects.  Created new and customized existing standard Oracle reports using Oracle Reports and
SQL*Plus.
Environment: Windows 2000, HP-UX, Oracle 9i, Developer 6i, PL/SQL, and SQL, Java, Shell Script, Toad

TRAINED IN : Salesforce CRM & MEAN Full Stack ( Angular 7 ), ORACLE 11g DBA, ORACLE APPS R12,
INFORMATICA 9.6, ODI 12C/11g, OBIEE 11g, DAC, OBIA
ACADEMIC : Bachelors Degree (B. SC) from Osmania University (1994-1997)

Confidential DEVBOT Technologies Pvt Limited Page No. 5

DEMO OR PET PROJECTS : ( HANDS-ON PRACTICE )

rok.co/@vkandati
VK Homepage
VZone Homepage
SVB Homepage

Confidential DEVBOT Technologies Pvt Limited Page No. 6