Plsql and Unix scripting

Yaseen Khandenahally Bedensab

Jersey City, NJ

Mobile: +1-201-***-**** ********@*******.***

EXPERIENCE SUMMARY

Six years of professional experience involving designing, development, testing and implementation of applications using Oracle Pl SQL, Unix shell scripting, Perl scripting, IBM MQ’s, C, C++, connect direct and U-deploy automation tools.

Strong experience in writing Unix shell scripts and Oracle PLSQL procedures covering data feed handling, implementing business logic.

Experience in AIX, Solaris and Linux server setup for application migration.

Experience in automating the regular reports requested by users using UNIX and PERL Scripts.

Experience in NDM connect direct Administration.

Preparation and participation in Disaster Recovery tests.

Highly motivated, energetic, quick and independent learner

Exceptional ability to quickly master new concepts

AUTHORIZED TO WORK IN US: H1B visa

PROFESSIONAL EXPERIENCE

Organization

Role

Period

HCL America, Jersey City, NJ

Programmer Analyst

Nov 2015 to Till Date

HCL Technologies, Bangalore, India

Unix/Plsql Developer

Oct 2013 to Oct 2015

Future Focus Infotech, Bangalore

Unix/Plsql Developer

Nov 2011 to Oct 2013

Rashmi Computers for Keonics Bangalore

Technical Assistant

Apr 2010 to Sep 2011

APPLICATION AREA

Line of Business – Tele Communication, Banking and Finance

Line of Technology – Oracle Pl Sql

TECHNICAL SKILL SET

Programming Language : PLSQL, Unix Shell scripting, PERL, C, C++

Platform : AIX 6.1, Linux and Sun OS 5.10

Database : Oracle 11g, Oracle 10g

Source Control Tools : CVS and SVN

Tool : Connect direct (NDM), TOAD, PLSQL developer,

Putty, winscp, IBM showcase, IBM MQ’s, eclipse and notepad ++

PROJECTS

Project #1 : U.S. Fixed Income Securities Settlement System

Role : Programmer Analyst

Client : Deutsche Bank

Team Size : 12

Operating System : AIX 6.1, Linux and Sun OS 5.10

Period : Oct 2013 to Till Date

Line of Business: Banking and Finance

Description:

DTE FISS is the middle office system in New Jersey which routes trades from fixed income front office trading systems like Bloomberg, Magellan and dbMTG to ICI-ADP, BoNY and DTCC those who are the back-office settlement clearance providers for Deutsche Bank. To route the trades the system uses tools which are built in bank using MQ Series, C and Pro*C. At the end of day, the system receives price, position and P&L information from all the front office trading systems and MQ transaction download files from all the above clearance providers and loads the data by running a nightly batch and produces hundreds of reports for business users to reconcile and make sure the trades, position and P&L information are correct between the back office and front office trading systems. DTE system is also used as a data warehouse for back office information and provides information necessary to load Magellan, Calico and other downstream systems.

Responsibilities:

●Understanding the BRD (Business requirement document), provided by the client.

●Preparing an estimate for required changes.

● Developing the codes.

o Making changes in existing perl/shell, writing new shell/perl scripts.

oAnalysis and debugging of shell scripts, perl script, C++ and C scripts

oBringing up and bringing down of MQ manager, listener, channel and monitoring of message depth. Removal and insertion of message from built in binaries.

o Writing new PLSQL codes, modifying existing ones

o Optimizing existing PLSQL codes

o Writing new control files

o Making changes to reports in report manager.

o Making crontab changes

o Unit testing of codes.

●Coordinating between different teams for System Integrated Testing.

●Releasing the codes into production (Using CVS and SVN).

●Develop FOBO (Front Office Back Office) reports for business user reconciliation purpose.

●Design and develop the new interfaces for business users to accomplish or reduce manual work of operation tasks.

●Participate in application server migration project and modify the code as per new application architecture system and perform end to end flow test along with upstream, downstream and business users.

●Design and effectively implement business continuity plans (BCP) for financial applications as per organization standards.

●Debugging of code and resolving bugs encountered in the system.

●Develop and maintain housekeeping jobs to maintain consistent size of data in production environment as per Bank standards.

●Develop batch jobs to process and generate the feeds for downstream teams and business users with in SLA

●Create the real-time exception reports for users to monitor trade flow from front office to settlement system.

●Migrate the existing application code to support other file transfer protocols like sftp and NDM

●Providing highest level of support for the application (L3 support).

Assignment 1: DTE server upgrade from Aix 5.3 to AIX 6.1

DTE is a middleware application hosted on 3 servers, the CORE, DMZ and Web server. Core application running on CORE server AIX 5.3 and migrated to AIX 6.1 with new server platform. Application have connectivity to 80+ downstream and upstream with trade flow, SFTP, SCP, database connectivity with 3000+ shell scripts and Perl scripts. All scripts are tested and verified by debugging many issues like mq connectivity, database connectivity, load library paths, connectivity issue, Sybase connectivity, Perl lib path changes and many more. MQ channels are recreated modifying MQ manager to point to new server. Connectivity to all interfaces are ensured by using DNS name. DR and IWP test are conducted and tested by simulating production scenarios.

Programming Language : shell scripting and Perl scripting

Platform : AIX 6.1

Database : Oracle 11g

Source Control Tools : CVS

Tool : TOAD, Putty, PLSQL developer winscp,IBM MQ’s and notepad ++

Assignment 2: C and C++ IOC compiler compatibility with AIX 6.1

As a part of application migration from Aix 5.5 OS to Aix 6.1 due to technology roadmap, it’s found out that the application code used Istrings in C and C++ source code are not supported by IBM compilers. A new class is introduced in the existing code and modified the source code by replacing Istring by inheriting the methods from the new class. Binaries are rebuilt with new code and tested the functionality by simulating the production like scenarios by inserting MQ messages manually into IBM MQ’s which are referred in the source code.

Programming Language : C, C++

Platform : AIX 6.1

Database : Oracle 11g

Source Control Tools : SVN

Tool : TOAD, Putty, winscp, IBM MQ’s and notepad ++

Assignment 3: Migrating from SFTP to Connect direct (NDM)

DTE application connects to external vendor via DMZ server, the server was using SFTP connection to transfer files which is not TRM compatible. The SFTP connectivity is migrated to NDM connect direct which is more secured way of file transmission, as part of this project have involved in installing of connect direct tool on server, creating configuration files with new set of IP’s. debug the issue to connect external vendor. Tested the file transmission with performance and did a comparison against the SFTP for speed and content of the file.

Platform : Sun OS 5.3

Tool : Connect direct(NDM) and SFTP

Assignment 4: Rates upload

A rate file in csv format is uploaded by a client from front end and the file is loaded to database with sql loader. A package with set of procedures and functions were written to handle the logic and a flat file with specific format is generated and SFTP to vendor for processing. A validation report will send back to DTE from which a report is generated by using perl script and uploaded to front end report manager for client to review. Various requirements were added to enable client to upload file with right format with mail alerts and step by step updates to client on the process.

Programming Language : PLSQL, shell scripting, perl scripting

Platform : AIX 6.1

Database : Oracle 11g

Source Control Tools : SVN

Tool : TOAD, Putty, winscp, sql loader, SFTP

Assignment 5: Migrating from Sun Solaris to Linux server

Migrating application from Sun Solaris to Linux new server as part of technology road map compliance, as part of this project have worked on implementing new mq client, Sybase client, jave jdk installation, apache tomcat installation, creating a prompt file setting up the environment files, debugging Sybase connectivity by using Sybase client, generating new SSH keys for connectivity, debugging all application related issues with shell scripts.

Programming Language : Unix shell scripting

Platform : Linux 2.7

Database : Sybase

Source Control Tools : SVN

Tool : TOAD for Sybase, Putty, winscp, SFTP, apache tomcat, mq client, Sybase client,

Project #2 : Tatasky Application support

ROLE : Developer

Client : TATASKY Limited.

Team Size : 5

Operating System : GNU/Linux 4.0

Period : Nov 2011 to Oct 2013

Description:

●Tata Sky is a joint venture between TATA group and STAR TV group which has DTH (Direct to Home) Service to telecast all the television channels in digital quality directly from the satellite to home, thus giving complete control over viewing experience. Here Tata Sky will uplink all the channels to its satellite (INSAT 4A) and the satellite will directly send the channels in digital quality to the Minidisk fixed on subscriber’s Residence. The minidisk relays the channels to Digicomp, where they are decrypted and sent to subscriber’s television to give an unparalleled viewing experience.

●This project deals with customer information such as address, relevant assets, billing, package details and Service Activation. This system also handles Account Management with billing, Asset Management, Sales Orders, Product with Promotions and Campaign Management. All these modules are developed in Siebel7.8 with various levels of Configuration changes, eScripts, EAI, EIM and Workflows. This application connects with external systems such as Kenan and SCMS for Billing and Asset Management for background process, This Project is the Integration of the Siebel, Kenan, SCMS, VMS, WebPortal, Cellnext and NDS

Responsibilities:

●Understanding and Analyzing Functional Requirements.

●Interactively worked with both project manager and customer to develop new features and functionality, on both sides of backend scripts and web based scripts.

●Part of a support and Development team, working on Enterprise level, Payment & Third-party Reconciliations, Migrations.

●Enterprise level reconciliations which includes Account, package mismatches, NRC postings.

●Payment reconciliations, comparing enterprise and third-party details.

●CA-SCMS reconciliation for package sync.

●Migration activity for packages provided by the client.

●Automation of reports requested by clients, generating adhoc dashboard as and when requested by clients

●Handling Escalations and responding to clients in time.

Programming Language : Unix shell scripting and JSP

Platform : Sun Solaris

Database : Oracle 10g

Source Control Tools : CVS

Tool : TOAD, Putty, winscp, SFTP and eclipse.

Project #3 : MGNREGA

ROLE : Technical Assistant

Client : PRED

Team Size : 6

Operating System : Windows XP

Period : Apr 2010 to Sep 2011

Description: This MGNREGA is an Indian labor law and social security measure that aims to guarantee the right to work. It aims to enhance livelihood security in rural areas by providing at least 100 days of wage employment in a financial year to every household whose adult members volunteer to do unskilled manual work. This project consists of Managing and maintaining of accounts and providing utilization certificate in the form of reports formats prescribed by state and central government.

Responsibilities:

●Creating a new work orders for the financial year and managing the information by using Visual basic and excel macros.

●Providing an estimation for the requirement.

●Monitoring the day to day activities and updating the data in MIS

●Generation of monthly financial reports as per the requirement given by client.

●Interactively work with team members to resolve the issues.

●Adding more functionalities to the existing tools.

Programming Language : Visual Basics and excel macros

Platform : Windows XP

Database : MS access

Tool : MS 2007, Visual basics and Macros

Contact this candidate