Pl Sql Management

Charles River OMS

Unix, C, C++, Oracle PL SQL Developer

Results-Oriented professional with over 15 years of experience. Extensive experience in setting up, support and upgrade of Charles River OMS. Development experience spreads over Wealth Management and Healthcare sectors using UNIX, PERL scripting, Oracle PL SQL utilities and C++. Familiarity with complete SDLC project life cycle from feasibility study through design, development using Object Oriented Technology, testing, deployment, maintenance and production support.

TECHNICAL SKILLS

Industries: Wealth Management, HealthCare, Telecomm

Applications: Charles River Order Management, Client Relationship Management, Risk Monitoring, Object Oriented applications.

Programming Languages: UNIX and PERL scripting, C++

Databases: OLTP processing with Oracle 11G/12C and lower versions, data-architecture/modeling using ERWIN and applications development using PL/SQL Stored Procedures and Packages, ProC/ProC++, SQL Loader, SQL Plus and other SQL utilities

Operating Systems: UNIX/Linux OS, Windows 2000 Server

PROFESSIONAL EXPERIENCE

UBS –Wealth Management March 2005 – May 2019

Technical Subject Mapper Expert for Charles River OMS

UNIX scripting and Oracle PL SQL Programmer

Performed initial implementation and production support for Charles River Order Management System and subsequent upgrades.

Designed and developed User Entitlements, Trading Workflows, Compliance Rules. Set up FIX, SWIFT, Real Time Processing (RTAPI) interfaces.

Designed and developed various utilities, reports and interfaces with other applications such as Accounting, Corporate Actions, Risk Monitoring etc.

Designed and developed unix and perl scripts to perform data loading, BOD setting of systems, intra-day processing and reporting. Designed and developed PL SQL packages and triggers to handle database tasks.

Successfully migrated legacy Loan Order system to a newly designed efficient system using 3-tier client-server architecture. Further enhanced this application to include processing of Fixed Deposits, LCs and Payments on the single platform.

Worked with the vendor team to upgrade Risk Monitoring system. Designed and developed interfaces with internal applications. Provided user training. Set up RTB team for production support.

Designed database schemas using ER modelling. Developed PL SQL stored packages and triggers to handle business logic and processing. Performed tuning and optimization of SQLs to improve performance.

As the technical subject matter expert, provided support to Run-The-Bank team during production issues.

Bloomberg Inc. May 2004 - January 2005

Oracle PL/SQL Programmer

Performed back end UNIX, Oracle PL SQL development for BDAP System. This content management system has replaced existing Bloomberg system of gathering, processing and storing/retrieval of financial data in the form of News, Company related information as well as company’s financial and other documents. The data is processed on real time basis as and when news comes or at a pre-defined time, such as monthly/ quarterly/yearly financial documents of a company. The data once received is scanned thru Documentum system and then processed by various departments. The data is massaged and stored in the backend Oracle database for quick retrieval.

Performed database modeling, design and development of Profiles, Fundamentals sub-systems. Developed Unix shell scripts for loading and massaging of data and PL SQL stored procedures/packages/ triggers to support database interfaces and front-end processes.

Carried out performance tuning and optimization of complex SQL queries.

Campbell Soup Co. January 2004 - April 2004

UNIX scripting, C, Porch++ and Oracle PL SQL Programmer

Instrumental in backend UNIX, Oracle PL/SQL, ProC++ development for Export Clearance system, for providing up-to-date EDI documents to customs for goods transported across Canada and US border. This application extracts order information from Supply Chain Order System and feeds to the Inventory system. The inventory system allocates and adjusts the inventory level for an order. This information is then processed in DelFour Logistic system, which arranges for collection of order items from various plants in Canada and provides transportation of it as per Bill of Landing. The export system generates various EDI documents for goods to be delivered and its transportation details, to facilitate smooth checkout at the customs checkpoint.

Performed analysis, Design, development of database interfaces for this System

Developed hourly reports for price and quantity variations between the order placed by the customer and the order filled by the inventory system.

Developed various EDI interfaces using C/ProC++ and embedded PL/SQL stored packages and procedures. Also developed Unix and AutoSys job-scheduling scripts for the same.

Performance tuning of SQL queries.

Also worked in

Healthcare Industry - Independence Blue Cross PA, CIGNA

Telecom Industry – AT&T

Education

Master of Management Studies, University of Bombay, India.

Bachelor of Engineering, University of Bombay, India.

Contact this candidate