Experience

EnvisionRxOptions

• United States
• Pharmaceutical Manufacturing
• 100 - 200 Employee

• Software Engineer II Database Developer

  • May 2019 - Present

  • Analysis, requirement gathering, documentation, business requirements, functional requirements, development, deploying and testing. • Design and develop software modules that meet customer requirements while upholding high standards, reliability, security, maintainability and performance. • Define product technical architecture and design complex software components • Developed and tuned PL/SQL procedures, triggers and Packages. • Developed database objects like Tables, Synonyms, Views, Indexes, and Sequences • Developed UNIX jobs and shell scripts to convert and load the files from customers to the database. • Create export and response files for client in their format using Linux, Shell scripts, SQL Loader and database packages. • Participate in peer reviews for design, code and other work products. • Perform software quality assurance, including all types of testing of database designs to confirm functionality and performance. • Write technical documentation and advise management on product and process improvements • Enhance and maintain applications • Participate with and lead a team to carry out the full lifecycle of software development activities. Show less



Nationwide

• Insurance
• 700 & Above Employee

• Oracle Devloper

  • Feb 2014 - Sep 2014

  Responsible for production support and minor enhancements for the integration process between multiple sub systems. User would request extract, transform and load from one subsystem to another subsystem and would like to make it available for application developers to access and show in the application for the end users. • Understanding the customer requirements, analysis, design, development and implementation into the system, Gather and define business requirements, improve business processes. • Participate in the daily, weekly team meets and monthly business meets to discuss the status of the application development and discuss detailed work plan. Participate in the daily, weekly team meets and monthly business meets to discuss the status of the application development and discuss detailed work plan. • Coded PL/SQL Packages, procedures &Triggers to perform data loading, Error Handling and logging. Tied these procedures into an existing ETL process. • Developed packages, procedures, functions, cursors, triggers, synonyms, views and several other database level objects. • Extensively worked on Nationwide Bank server migration project which involved changing the code, migrating the databases and implementing the changes. • Extensively used UNIX Shell Scripts for generating the parameter file and to load the data on daily process. • 24*7 production on call support for the complex High available databases, checking logs, debugging, provided work around to sustain a bends and supported the entire system for daily loads. • Created batch scripts to handle various FTP and file handling process according to business requirement, triggered and validated the batch jobs. • Created Tables, Views, Constraints, Index according to the business requirements. • Extensively worked in loading multiple Client and vendor data into our Bank Staging and Mart databases, worked on various P1 issues related to the bad data and loading the clean data into the MART. Show less



JPMorgan Chase & Co.

• United States
• Financial Services
• 700 & Above Employee

• Oracle Developer

  • Jan 2013 - Jan 2014

  Multiple Application Reporting Systems is responsible for all the reports for multiple applications used which are developed to support the mortgage loan system in JPMC. There are around 485 oracle reports for around 40 applications which can be run with various parameters in MARS application. The report outputs can be viewed by users from past 10 days in MARS application. The report outputs can be send to the distribution list once it is created using MARS. There is capability for the users to upload files and run the reports for those loan or MIN numbers. • Developed 17 new complex Oracle Reports and enhancements for 60 existing Oracle Reports. • Created 20 new batch processes which loads the data from different sources and loads the data into reporting database. • Developed procedures to pull data from application database (INFOPROD) and load it into the Reporting Database (BUSPROD). • Developed DDL Scripts for Database Objects like Tables, Views, synonyms, sequences, Indexes etc. • Developed stored procedures and complex packages using PL/SQL. • Developed SQL Loader scripts and PL/SQL statements to extract/migrate data from the different application in the form of flat files and load the extracted and transformed data into the new database application. • Developed and modified several UNIX shell scripts • Attended business conference call with business team to understand the changes to the system • Involved in testing the system and fixed the defects raised during the testing phase • Involved in the optimization of query performances using Oracle Hints, SQL Trace/Tk Prof, and Explain Plan, partitioning of tables and creating indexes. • Created Control M jobs and xml scripts to schedule the batch processes • Documented all PL/SQL procedures and user guide for different processes followed • Resolved most of backlogs which were pending from long time. Show less



Navashakthi Agency

• Hyderabad Area, India

• Oracle Developer

  • May 2007 - Feb 2010

  Order Management System is customized oracle application developed to handle the orders, inventory and manufacturing of the products. Navashakthi Agency is a paints and chemicals company which has many customers all over the India. Application consists of many forms like customer, order, and inventory. The manufacturing team checks for inventory and generates a report about what to produce every day. • • Responsible for creating the Database tables, indexes, constraints and other database objects. • Created Stored Procedures, Functions, Packages, Triggers using SQL, PL/SQL. • Developed Various Forms with Triggers, Alerts, Multiple Canvases, Multiple Windows, LOVs and List Items using Forms 6i • Developed complex Oracle Forms and Reports as per the user requirements. • Meeting with management for enhancement of the system and trained end users. • Involved in creation of Technical Docs & User docs as well. • Developed a PL/SQL Interface Program to validate the data and load the data into the INTERFACE tables • Involved in requirement gathering meetings and developed design and demo documents • Created Business Area’s and Custom Folders in Discoverer Admin version Environment: UNIX, Oracle 8i, PL/SQL, SQL* Loader Show less