Sushant Narayan Bondre

adgy82@r.postjobfree.com

https://in.linkedin.com/public-profile/in/sushant-bondre-0426307

+1-551-***-****

JERSEY CITY, New Jersey, USA

SUMMARY:

13+ years of experience in application and database development. Involved in requirement analysis, design, development, testing and deployment of client-server Linux/Unix applications.

Over 9 Years of Experience as an SYBASE ASE/IQ as well as Oracle PL/SQL Developer with Proficiency in Oracle 12c/11g/9i, SQL, SYBASE ASE 12/15 and SYBASE IQ 15/16.

Strong experience on creating PL/SQL packages, Procedures, Functions, Triggers and Views and cursors to retrieve, manipulate and migrate complex data sets in Oracle Databases.

Experience in Performance Tuning & Optimization of SQL statements using various types of Hints, Partitioning, Indexes, Explain plan.

Expertise in migration of application databases (Sybase and Oracle) versions and implementation of changes needed from version to version.

An experienced team leader with the ability to initiate, implement and take ownership of new and enhanced business requirements.

Experience in understanding business and IT requirements in depth.

Expertise in migration of application source from Solaris to Linux system.

Experience in C++ for compiling, implementing and fixing migration as well as enhancement changes.

Designed test cases and implemented automatic testing processes, for both application and database migrations.

Expertise in Unix/Linux shell scripting.

Worked on advanced PL/SQL constructs like Oracle supplied packages, Nested tables, Varrays, Records and Types. Strong programming skills on Oracle SQL, PL/SQL indexes, bulk collects and Collections.

Extensive experience in data migration techniques using Oracle External Tables, SQL* Loader, Import/Export, bulk and batch processing.

Strong knowledge of UNIX and LINUX è AIX/HP/SOLARIS/RHEL

Extensive experience in working with large Databases.

Excellent analytical and interpersonal skills, oral and written communication skills.

Ability to work individually as well as in a team with excellent problem solving and troubleshooting capabilities.

Develop PL/SQL packages and provide support to all system interfaces and coordinate with all project managers to provide specifications for all core modules.

Design and implement various structures for all physical objects and recommend changes on applications through efficient statistical structures.

Analyze and ensure efficient transition of all technical design documents and develop various SQL packages to provide support to all application developers.

Excellent communication and provided prompt resolutions to users on their business and technical queries.

Worked on SQL developer, TOAD.

Expertise in migration, configuration and setup of different SCM tools like SVN, RTC, Enterprise build, Bitbucket, Jenkins, GitHub for application source.

Worked on configuration and setup of BMC-RLM (Release LifeCycle Mgmt) auto deployment tool.

Worked on Autosys, JIRA, HERMES, Control-M, Service Now, VMware, Confluence, ANT and Maven tools.

SKILL SET:

Computer Technologies:

PL/SQL

Unix/Linux shell and Perl scripting

Python

C++

Databases:

Oracle (9, 10, 11,12c)

SYBASE-[ASE/IQ] (12/15/16)

Operating Systems:

Unix/Linux (RHEL, HP, AIX and SOLARIS) and Windows.

WORK EXPERIENCE

CITIBANK N.A. Total - Oct 2013 – till date

Oracle Pl/SQL Developer Jersey City, NJ Jan – 2016 to Till Date

Oracle Pl/SQL Developer London, UK July 2015- DEC 2015

Database Developer Pune, India Oct 2013 –June 2015

Technologies involved:

Oracle 12c, PL/SQL, Sybase ASE/IQ, C++, UNIX Shell Scripting, Python, RHEL, AIX, Solaris

Description:

This sub-ledger back-end OTC-derivative system is responsible for TRADE processing where trades are generally entered into CITI Derivative System (front end) and flow into OASYS trade capture. OASYS trade capture will then sends OASYS FINANCIAL indicative and payment data for each new and revised transaction. Based on the information provided, OASYS Financial then generates daily the appropriate account entries, produce financial reports and feed downstream systems.

Responsibilities:

Application development from scratch using Oracle PL/SQL in place of Sybase ASE and IQ DB servers and C++ binaries.

Importing and Exporting the Data from large text files/excel files into the database using SQL Developer.

Created and maintained Tables, procedures, and Indexes.

Tuned PL/SQL Stored Procedures/Functions to improve the performance by creating function-based Index, Optimizer Hints, Explain plan and analyzing the tables.

Wrote high performance queries/programs using Collections, Bulk Binds, Objects, Nested tables, REF Cursors, pipeline functions etc.

Implementation and testing of migration issues using shell and python scripting.

Worked on finding and resolving Solaris to Linux migration issues for this application.

Coordinated with users, boundary systems (upstream/downstream) applications teams and address their Business and technical queries.

Worked on High Level design and detailed design and to prepare documents.

Worked on feasibility analysis with respect to technology / time and resources.

Analyzed and suggested improvements in the overall architecture of the application.

Took part in coding / performance tuning and other delivery related activities.

Coordinated with the offshore team and get the code delivered.

Monitored the progress and work upon the bottlenecks.

Prepared test plans and lead the unit testing /integration testing activities.

All release related activities [SCM, Build and deploy] for this application.

Configured and on-boarded all application and DB servers to RLM [Auto deployment tool] and source code management using RTC/EB tool.

Migration from SVN [source safe to RTC-Rational team Concert tool provided by IBM].

Migration of RTC/EB to Bitbucket/Jenkins – GitHub using Python

CREDIT-Suisse 01/10/2012 - 04/10/2013

Role: DATABASE Developer Pune, India

Technologies involved:

Oracle PL/SQL, C++, UNIX Shell Scripting, python, RHEL, Solaris

Description:

This application basically does the trade transactions until it is settled. It does Clearing of payments and settlements for different countries like Singapore, JAPAN, KOREA, Australia and many more. And POETS-EOL application is a migration project from Solaris to RHEL DB servers and perl4 to perl5 version.

Responsibilities:

Involved in the analysis and POC for above mentioned migrations.

Implemented changes needed for migration issues.

Worked on installation, configuration and deployment of application on different servers.

Worked on all release activities for this application.

SFR –France 08/11/2010 - 30/09/2012

Role: DATABASE developer Pune, India

Technologies involved:

Oracle (9, 11), C++, Linux Shell Scripting, RHEL

Description:

This Application is responsible for Provisioning and Service Activation of different telecom subscribers. This is done via KABIRA tool.

Responsibilities:

Worked on migration of Oracle database version from 9i to 11g.

Importing and Exporting the Data from large text files/excel files into the database using SQL Developer.

Created and maintained Tables, views, procedures, functions, packages, DB triggers, and Indexes.

Successfully manipulated Stored Procedures, Functions, Triggers and Packages using TOAD and SQL Navigator.

Involved in Migrating the entire database setup from test environment to production.

Designed, implemented and tuned interfaces and batch jobs using PL/SQL and UNIX utilities.

SYMANTEC: 01/03/2008 - 23/07/2010

Role: Sr. Software Developer Pune, India

Technologies involved:

C++, Solaris 8,9,10

Description:

Solaris deployment solution 1.0 product is responsible for building and exploring the operating system image from or to HDD. This imaging can be done on Solaris 8, 9 and 10 versions with support of both the architectures (SPARC and X-86). This system provides the remote installation of saved image like Jumpstart Server. It also supports auto boot environment for bare metal machine and configured machine through NBS (Network Boot Server). The NBS supports RARP IP Assignment.

Responsibilities:

Involved in all the phases of (SDLC) software development life cycle for the following features. - System Configuration: For Network, Boot-device, NS-Agent and DSS-plug-in with SVM and VxVM support. Boot Server Configuration - Active-Os registration

FIDELITY: 16/07/2007 - 28/02/2008

Role: Software Developer Pune, India

Technologies involved:

C, UNIX shell scripting, Java scripting, Oracle PL/SQL

Description:

The system is responsible for check cashing for its customers. This system validates and processes Pay and Tax Checks issued by various institutions and organizations, at various Points of Sales (POS), like WALMART, Seven-eleven or at self-operated kiosks. The PCA system accepts the check details and customer information, this information then passes through the various modules for validation. The result is either approval or decline of the check.

Responsibilities:

Involved in R&D and Documentation of various modules of the PCA system.

Involved in implementing, compiling and testing of the PCA simulator on AIX platform

EDUCATION DETAILS:

Education Specialization Year of Graduation Institution

BTech Information Technology 2007 COEP Pune

Contact this candidate