Seeking a challenging and rewarding position of PL SQL Developer that fully

utilizes my development experience, training knowledge and skills, also provides me a platform to master and transform as a SQL Specialist.

Overall 6+ years of Professional experience in Software Development & Training

Around 2 years predominantly in Oracle, Working as a PL SQL Developer with 7Hills Global Consulting Pvt. Ltd

Around 5 years as Faculty in VNR VJIET CSE Lab, Worked on multiple IT projects through VNRVJIET’s R&D division

Proficient in PL/SQL objects such as Packages, Stored procedures, Functions, Triggers, Cursors, Views,exception handling, shell scripting

Sound knowledge advanced concepts such as Dynamic SQL, Sequences, Bulk binding, Collections, Associative arrays, Nested Tables and Varray

Posses strong analytical and problem solving skills; good at debugging skills

Exposure in Performance Tuning; Query Optimizer, Execution Plans and Indexes

Good in system design, Data flow diagrams, Database normalization techniques

Knowledge inManufacturing domain, Logistics & WMS

Microsoft Certified SQL Developer MCSA 70-761; Strong T-SQL skills

ISTQB Certified Tester. Well versed with SDLC & STLC. Solid exposure in both Development Projects and Support Environments

Expertise in Coaching and Mentoring Junior resources, conducted practical training sessions on various programming languages

A quick learner and hardworking individual with positive attitude Qualification University / Board Score

M.Tech Software Engineering (2018) VNRVJIET, JNTU, Hyderabad 8.84 CGPA Master of ComputerApplications(2014) Sikkim Manipal University 75.9% B.Sc. Computer Science Alagappa University, Tamilnadu 64.5% Post Diploma in Computer Applications Technical Education Board, Kerala 82.8% Polytechnic Diploma in Electronics Engineering Technical Education Board, Kerala 81.7% Matriculation (SSLC) Board of Public Examinations, Kerala 85.6% Job Objective

Curriculum Vitae

Jincy P R

Ph: +91-939*******

e-mail: adl4u9@r.postjobfree.com

Profile Summary

Academics

Jul 2019 – Till date : Software Developer, 7Hills Global Consulting, Cyber Towers, Hyderabad

Jul 2012– Jun 2019 : Faculty, Computer Science Lab, VNR VJIET, Bachupally, Hyderabad

(**Acquired M.Tech from JNTU by taking long leave and attending regular course during 2015-16 in same college)

Primary Skill :Oracle ( SQL & PL/SQL )

Languages &Scripting :PL/SQL, T-SQL, Unix Shell, C, Python, Java, OpenCV, Perl, .Net

WebDevelopment : HTML, CSS,Java Script, XML, PHP, JSP

IDE, Utilities &Tools :Toad, Oracle SQL Developer, Rational Rose, MS Office, HPQC, QTP

Databases : Oracle12c, MS-SQL Server, MySQL

Microsoft Certification 70-761 “Querying Data with Transact-SQL”

ISTQB - Foundation Level Certification

InDaS Conference on Data Sciences

Oracle SQL Performance Tuning

Software Developer

01/07/2019 – Till Date

7Hills is focused supply chain solutions and Services Company, driven by a team of supply chain experts, who spent years building and nurturing high performing SCM consulting and technology business.eBizNET Solutions was an affiliate of 7Hills Business Solutions, provider of several supply chain technology solutions including the SaaS eBizNET Warehouse Management System. The company has also developed specialized applications for transportation management, port and cargo management, reverse logistics, warranty and aftermarket solutions. The company started selling its WMS solution as an integrated application within the NetSuite platform. NetSuite had acquired eBizNet Solutions in 2014 and Oracle acquired NetSuite in July 2016. Professional Experience

Skills Set

Trainings & Certifications

Experience Summary

Expert Moderate Novice

Project Name : eBizNET – Enhancements& Support

Duration : 19+ Months (Oct 2019 – Ongoing)

Description: eBizNET WMS is a highly configurable warehouse management system that provides real-time visibility of inventory, orders, shipping and more. I have been consistently getting development work for new enhancements from multiple customers. Maruti Suzuki, India's car manufacturing leader, operates alarge centralized warehousefor spare parts distribution use this End-to-End Warehouse Management System to reduce manual interventions especially on put-away, order picking, shipping and label printing processes to eliminate errors, improve efficiency & order fulfillment velocity. BANZ Group, formerly known as Bahrain national cold storage and warehousing company’s facility includes Bahrain customs bonded warehouse, temperature controlled storage facilities and logistic services that facilitate and expedite the efficient and speedy movement of cargo in and out of the country.

Roles & Responsibilities

Design, build and configure applications to meet business process and application requirements, few sample enhancements provided below

Regular Meetings with Maruti & Banz IT Team to provide satisfactory support for their queries and development needs

Trouble shoot Production issues, analyze application and suggest optimum solution

Implement fixes in PL SQL to resolve business reported problems

Coordinate with the front end UI developers and provide them with the necessary stored procedures and other backend support

Creating, Maintaining and Performance Tuning of Packages, Views, Stored Procedures

& Functions

Worked on Inbound and outboundinterfaces, File handling using UTL_FILE, XML and JSON file handling

Work Closely with QA Team and get Testing signoff

Sample Developments Maruti Suzuki:

1. WMS Access Management - User approval process: Whenever a new user created, he/she will be kept in pending state. The new user creation can be approved or rejected by the authorized person using this new enhancement. 2. WMS Access Management - Site approval process: When a site access is assigned to a user, the assignment will be kept in pending state. The authorized person can approve or reject the site assignment. User can get access to the assigned site only after the approval.

3. Waybill Upload process: The list of waybill numbers and its courier type uploaded into the table after validating the courier type & waybill number format. The waybill numbers exist for a site can be assigned to picked orders. 4. Waybill upload status Report: This report gives the statistics of waybill numbers uploaded from the given list based on the process status. Status can be successful or failed to upload due to format error, length error or invalid courier type or waybill number already exists etc.

5. Waybill number assigned to orders: This report list all the waybill numbers uploaded between a date range and the respective sales order attached, order number column shows blank if there is no order tagged to that particular waybill. 6. Nil-Count Report: When the pick generation happens some pick tasks can be failed due to location error or insufficient quantity. This failed task information along with item name and its count of failure records are included in this report. 7. Container Planning Reports: Two reports were developed based on MSIL requirement; a, Consignee Status Report & b, Consignee Summary report. 8. Location duplication mail alert: Sending alert mails when there are duplicate locations in sites.

Sample Developments Banz Group:

9. SKU Type Enhancement: Added SKU Type to 3 screens under Customs Module; Import Invoice, Direct BOE & Customs Document. Developed a new report in column format with facility to export data to Excel and summarized by SKU Type and Foreign cost currency

10. Customs Report Documents by Currency: Currently system generates multiple BOE based on the warehouse bill but customs department requested to segregate the order lines based on the currency.

Project Name : GATI Upgrade Project

Duration : 3 Months (Jul 2019– Sep 2019)

Description: Gati Ltd is currently running on older version that doesn’t have latest features added in Inbound & Outbound process, RF Applications &WebServices, The project objective is to upgrade UI as well as Backend with latest version without disturbing the existing customized features available for GATI.

Migration Activities Performed

Developed PL-SQL utility script to compare and migrate objects from old to new DB

Database clean up, dropping unwanted DB Tables and objects

Impact Analysis and standardize enhancements using PL/SCOPE

Identifying Table discrepancies, new columns, data type mismatch etc

Altering old DB tables to equivalent the structure with upgraded DB

Altering sequences, Recompile packages in upgraded DB

Load data from old DB UAT environment to new Dev environment

Testing the application and identifying gaps and fixing VNR Vignana Jyothi

Institute of Engineering & Technology

(**Joined as a regular student for M.Tech

Faculty, Computer Science Lab

01/07/2012 – 30/06/2019 **

in same college by taking long leave during 2015-16) I have worked as a Faculty in CSE Department and conducted both theoretical and practical classes for various Programming Languages. Responsibilities include Conduct Practical Labs forB.Tech & M.Tech students, Programming Language classes for Diploma students, Guidance to students on Academic projects. Also worked on multiple IT projects through VNRVJIET’s R&D division:

Project Name : Automatic Identification of Criminals in Surveillance Videos Dev Environment : Python, OpenCV

Description: This is an online system for automatic identification of criminal in surveillance videos. This system recognizes the criminals automatically by comparing the images from the videos with the images of criminals from database. Project Name : FoddieSpot

Dev Environment : My SQL 5.6 & PHP 5.3 (Hostinger), Android SDK & ADT Description: An android application that helps to increase operational efficiency of a restaurant by reducing customer wait-time. This application will greatly simplify the ordering process at customer end and also lightens the load on the restaurant end, as the process of taking and processing the order is fully automated. Project Name : Reporting tool for AquaSense

Dev Environment : Apache HTTP Server, My SQL5.6, Java, PHP 5.3, Javascript, HTML, CSS Description: Built a reporting module as part of the ongoing research project “AquaSense” initiated by ITRA. Objective of “AquaSense” project is to develop an indigenous, intelligent and adaptive decision support system for on-line remote monitoring of the water flow and water quality across a wireless sensor zone to generate data pertaining to utilization of water and raising alerts following any violation in the safety norms for the drinking water quality and usage of amount of water by remote detection of leaks and pipe burst events. ProjectName : Online Visa Application

Dev Environment : Apache Tomcat 7.0, My SQL 5.0, Java, JSP 2.0, Java script, HTML & CSS Description: Online Visa Application is a centralized system designed forIT Organizations to manage all requirements relevant to visa processing. It is a web-based system, using which an employee can see onsite opportunities available and can apply for the respective positions and visa processing. This system is useful for the HR department as well as for delivery department to keep track of employee visa details and foreign visits. Name : Jincy PR

Gender : Female

Nationality : Indian

Languages Known : English, Hindi, Malayalam and Telugu E-mail : adl4u9@r.postjobfree.com

Telephone No : +91-939*******

PresentAddress : 789, Old MIG, BHEL, Lingampally, Hyderabad – 502032 Expected CTC : 6 Lacs PA

Notice period : One Month

Personal Details

Contact this candidate