Profileimage by Anonymous profile, Oracle SQL and Pl/SQL with unix shell scripting

Last update: 19.02.2019

Oracle SQL and Pl/SQL with unix shell scripting

Graduation: B E(Computer Science and Engineering)
Hourly-/Daily rates: show
Languages: English (Full Professional) | Hindi (Native or Bilingual)


I have around 14 years of IT experience in Oracle SQL and Pl/SQL with Unix shell scripting.
Other than that the other technologies that I have worked parallel on are VB 6.0, ErWin, Autosys, Crystal Reports and other products likes Hyperion MDM, ADAPTIV etc.
My major domain expertise have been in Investment banking and second is Pharma and Medical Devices.
I have also worked in the capacity of Project Manager for approximately two years and have fair idea about Project management.

Apart from the above, I have also written few articles technical as well as non technical.
My strengths are Problem Solving, Logical Reasoning and Analysis.

Project history

Projects Handled:
  • ADAPTIV Migration
  • FRD (Financial reporting database)
  • Client MI (Management Systems) 
  • SMAC (Securities Management & Asset Control)
  • Intellect - Custody (Securities)
  • Finacle & Monitoring Tool, ABN AMRO Bank
  • Construction management system, CEDTI
  • Registration process, CEDTI
  • Examination project, CEDTI
Project Details
Project Name      : ADAPTIV                                         Client: Johnson and Johnson. India        
Software             : SQL SERVER, ASP.Net, MS-DOS, Minitab    
Team Size           : 08
            ADAPTIV is a Document Management system that facilitates the change management. Also used for retaining and retrieving different versions of the documents. It is robust software to be implemented at the India plant sites and to add on various other functionalities and associate and integrate other systems like training management, change control etc. with the ADAPTIV.
Role and Responsibilities:
  • Migration activities:-
  • Slashed numerous Man days by preparing batch scripts to expedite, enhance and fulfill the migration activities. 
  • Effort estimation and project planning.
  • Coordinate with the stake holders (global/local) for Inputs/suggestions and contribution to techno functional discussions.
  • Preparation and execution of detailed unit test cases and documentation of results
  • Identify gaps, Diagnosis and resolution of defects found during QA and UAT test phases
  • Continuously track tasks and training completion and generate training effectiveness reports during Audits and on Ad-hoc basis.
  • Trend Analysis for Quality Department using Minitab software and spreadsheets
  • Administrator, trainer and SPC for the users of all three sites and the technical support team for the software systems viz ADAPTIV, Compliance wire, CDR(Common document repository) and Pharmadoc (Document Management System).
Project Name      :  FRD (Financial reporting database)                Client: JPMC Bank, Mumbai
Software             :    Oracle 10g (PL/SQL), UNIX, Autosys
Team Size           :    15
Description          :
                         FRD is an application which caters the reporting needs of the business analyst team. The system contains various database entities where data gets loaded on daily basis and after loading of data, calculations take place and finally reports get downloaded in the .csv and .pdf format. The data loading process is done using the sqlloader utility of the Oracle pl/sql, where Autosys technology is used to set the ordering of data loader, and finally the reports get generated using the oracle forms builder. There are certain loaders for which the data is migrated from Oracle pl/sql to another database, which in turn is used for reporting purpose of another application.
Role and Responsibilities:
  • Client Interaction, Analyze Requirement & Development and Testing.

Local Availability

Only available for the countries India
Women friendly locations.
Profileimage by Anonymous profile, Oracle SQL and Pl/SQL with unix shell scripting Oracle SQL and Pl/SQL with unix shell scripting