Sql Developer 1 0
Resume:
Nitin Mishra (Oracle PL/SQL Developer/ Programmer Analyst)
********.*****@*****.***
linkedin.com/in/mrnitinmishra
Experience Summary:
Around 12+ years of experience in various phases of Software Development life cycle, including Designing, Development, Testing and Production Support using Oracle SQL, PL/SQL, and UNIX.
Expertise Oracle 12c,1.0 Oracle 18.1.0, Oracle 19.1.0, SQL, PL/SQL, Metadata, Oracle Forms, Oracle Reports and 4 GL languages like SQL, ACCESS, C, C++, C#, Java
Experienced in working with utilities like SQL*Loader, External Tables, Import, Export to extract and load large volumes of data.
Experienced in performance tuning using SQL Trace - TKPROF and Explain Plan, ORDS for Migration.
Developed various Unix Shell Scripts to manipulate data files, set-up environment variables, custom FTP utility, file archiving.
Catalogued technical reports, papers, conference proceedings, and books in the technical library.
I have a very good knowledge of Database Normalization, ER Modeling diagrams and Data Dictionary.
Worked on semantic web development, metadata and data modeling, web services and APIs, and search engine optimization.
Extensive work experience on Oracle 12c,11g/10g/9i/8i, SQL server databases on UNIX, Linux, and Windows enterprise platforms.
Extensively consulted the existing Data Dictionary (DD) to learn about the existing system.
Updated and maintained the Data Dictionary (DD) file after each new change to the underlying tables.
Proficient in translating business requirements into logical data models, creating modularized enterprise applications.
Experience in interacting with users, analyzing client business processes, documenting business requirements, performing design analysis and developing technical design specifications.
Experienced in using PL/SQL, SQL developer tools like TOAD, PL/SQL developer.
Extensive experience in Application development using Oracle Forms and Reports.
Strong experience with Unix Shell Scripting (KORN, Bash).
Aiding in logical/physical data modeling using ERWIN.
Performance tuning using Explain Plan, SQL-Trace, TK-Prof oracle utilities and creating relevant system and users’ documentation.
Worked on Production Support, receiving production calls, troubleshooting the application, and resolving bugs.
Oracle PL/SQL Oracle Forms XML Appworx Word Excel SQL developer
Oracle SQL Oracle Reports SVN Java TOAD PVCS Access Visio
Excellent analytical, problem solving, communication and interpersonal skills, with ability to interact with individuals at all levels.
Well versed in Perl and Python.
Strong understanding of object-oriented JavaScript
Ability to work in teams and independently with minimal supervision to meet deadlines.
Experience in Data warehousing Management.
Databases
Oracle 19.1.0,12c,11g/10g/9i/8.x, MS SQL Server, MS-Access
Languages
SQL, PL/SQL, T-SQL, Shell Script, Batch script, XML
Database Utilities
TOAD 8.5/8.0/7.1, SQL-Developer, PL-SQL Developer, SQL*Plus, SQL*Loader, Import and Export, Explain Plan TKPROF,Autosys
Operating System
Windows XP/NT/2000/98/95, Unix
Scripting Languages
Unix Shell Script, Batch File, Perl,Python.
Front End
Oracle Forms, Reports 6i, VB 6.0
Others
ERWIN, Crystal Report, Oracle Migration Workbench (OMWB), SQL Server migration assistance
Professional Experience:
Health and Human Services (HHS) Dec-18-2022-Present
Project Title: PL/SQL Developer
• Interacted with Business Analysts and participated in user requirement sessions to analyze and gather business requirements.
• Involved in data modeling team for identifying tables and relations between them.
• Built complex queries using SQL and wrote stored procedures using PL/SQL
• Involved in development of interface programs to import parts information Oracle 19 to inventory base tables.
• Converted open purchase orders from legacy system to Oracle Purchasing using SQL* Loader, PL/SQL, Packages/Procedures
• Developed interface for item data conversion to load items from flat file to Oracle Inventory using SQL* Loader, PL/SQL and import items program.
• Involved in development of shell scripts to send invoices to customers through mailing.
• Involved in updating procedures, functions, triggers, and packages for validation and loading of data into target table based on the current requirement.
• Designed and developed various custom packages triggers and forms.
• Extensively used for all and bulk collect to fetch large volumes of data from table.
• Performed SQL and PL/SQL tuning and Application tuning using various tools like TKPROF, AUTOTRACE and DBMS_SQLTUNE.
• Performed performance tuning using the DBMS_PROFILER package, this checks the run time behavior.
• Atomized routine jobs using DBMS_JOB. On completion of these jobs an email will be sent out automatically with the help of UTL_MAIL.
• Involved in data migration from Production to test and created test data for analyzing problems, providing solution.
• Involved in integration testing.
• Debugging and Fixing Production Data.
PNC Bank Aug 18,2022-Sept 08,2023
Project Title: PL/SQL Developer
Interacted with Business Analysts and participated in user requirement sessions to analyze and gather business requirements.
Involved in data modeling team for identifying tables and relations between them.
Built complex queries using SQL and wrote stored procedures using PL/SQL
Involved in development of interface programs to import parts information Oracle 19 to inventory base tables.
Used ORDS develop REST APIs for the Oracle Database.
Converted open purchase orders from legacy system to Oracle Purchasing using SQL* Loader, PL/SQL, Packages/Procedures
Developed interface for item data conversion to load items from flat file to Oracle Inventory using SQL* Loader, PL/SQL and import items program.
Involved in development of shell scripts to send invoices to customers through mailing.
Involved in updating procedures, functions, triggers, and packages for validation and loading of data into target table based on the current requirement.
Designed and developed various custom packages triggers and forms.
Extensively used for all and bulk collect to fetch large volumes of data from table.
Performed SQL and PL/SQL tuning and Application tuning using various tools like TKPROF, AUTOTRACE and DBMS_SQLTUNE.
Performed performance tuning using the DBMS_PROFILER package, this checks the run time behavior.
Atomized routine jobs using DBMS_JOB. On completion of these jobs an email will be sent out automatically with the help of UTL_MAIL.
Involved in data migration from Production to test and created test data for analyzing problems, providing solution.
Involved in integration testing.
Debugging and Fixing Production Data.
Charles Schwab Bank April 18,2021-Aug 22,2022
Project Title: SQL Developer/Data Analyst
Mentoring junior developers on best practices and showing them how to work with predefined patterns.
Prepares time estimates and justifications for assigned tasks and provides recommendations to project managers.
Provide support and assistance to teams and other departments. Wrote Oracle 19 SQL, PL/SQL, SQL Plus programs required to retrieve data using cursors and exception handling.
Creating indexes on tables to improve the performance by eliminating the full table scans and views for hiding the actual tables and to eliminate the complexity of the large queries.
Used ORDS to create RESTful Services that execute PL/SQL stored procedures.
Coordinating with the front-end design team to provide them with the necessary stored procedures and packages and the necessary insight into the data.
Created and modified several Unix shell scripts according to the changing needs of the project and client requirements.
Wrote Unix shell scripts to process the files daily like renaming the file, extracting the date from the file, unzipping the file, and removing the junk characters from the file before loading them into the base tables.
Experience with UNIX shell scripting.
Developed and modified triggers, packages, functions and stored procedures for data conversions and PL/SQL procedures to create database objects dynamically based on user inputs.
Used Jenkins for Code Deployment. Used TFS to create and Manage labels.
Wrote SQL, PL/SQL, SQL Plus programs required to retrieve data using cursors and exception handling.
Creating indexes on tables to improve the performance by eliminating the full table scans and views for hiding the actual tables and to eliminate the complexity of the large queries.
Coordinating with the front-end design team to provide them with the necessary stored procedures and packages and the necessary insight into the data.
Client: Bank of America November 02,2020 to Dec 31,2020
Project Title: Oracle PLSQL Developer: Worked as a database developer for developing and maintenance of Permission Catalogue (CESIUM) application used inside the bank for the Managers and Editors.
Responsibilities:
Worked as an Oracle 18 SQL/PLSQL developer create table, add partitions to support large data set
Developed number of External tables to import the data from the data feeds.
Wrote/Deployed PLSQL Package to migrate data between Schemas both in UAT and PRD.
Created number of ARM (internal BOA portal) request to meet the application requirements.
Took part in the business meeting where the clients were informed about the changes to be made to the software.
Worked on BOA internal tool called ‘Rationalizer’ to download the DDL file for the dataset and populated the table for that DDL.
Actively took part in the design and development to meet the expectations of the clients.
Did the coding in PLSQL to adjust to new demands.
Partitioned the fact tables and materialized views to enhance the performance.
Extensively used bulk collection in PL/SQL objects for improving performance.
Created records, tables, collections (nested tables and arrays) for improving Query performance by reducing context switching.
Used Pragma Autonomous Transaction to avoid mutating problem in database trigger.
Extensively used the advanced features of PL/SQL like Records, Tables, Object types and Dynamic SQL.
Handled errors using Exception Handling extensively for the ease of debugging and displaying the error messages in the application. Actively took part in the meeting with Client to understand more about a project to deliver efficient backend support and code enhancement.
Involved in all phases of the SDLC (Software Development Life Cycle) from analysis, design, development, testing, implementation, and maintenance with timely delivery against aggressive deadlines.
Wrote Shell Scripts for Data loading and DDL Scripts.
Developed PL/SQL triggers and master tables for automatic creation of primary keys.
Created PL/SQL stored procedures, functions, and packages for moving the data to staging area.
Environment: Windows, TOAD for 12c version 2, MS Excel and MS Word.
Client: Wells Fargo Feb 18,2020 to July 24,2020
Project Title: Application Systems Engineer: Worked as a database developer for developing and maintenance of AFSO applications used inside the bank for the various Interface Partners.
Responsibilities:
Worked on SQL*Loader to load data from flat files obtained from various facilities every day.
Created and modified several UNIX shell Scripts according to the changing needs of the project and client requirements.
Wrote Unix Shell Scripts to process the files on daily basis like renaming the file, extracting date from the file, unzipping the file and remove the junk characters from the file before loading them into the base tables.
Involved in the continuous enhancements and fixing of production problems.
Generated/Updated server-side PL/SQL scripts for data manipulation and validation and materialized views for remote instances.
Extensively worked on Autosys to automate the jobs. Check issues encountered in Job load process and proactively fixed them for the next load.
Developed PL/SQL triggers and master tables for automatic creation of primary keys.
Created PL/SQL stored procedures, functions, and packages for moving the data from staging area to data mart.
Created/Modified scripts to create new tables, views, queries for new enhancement in the application using SQL Developer.
Created indexes on the tables for faster retrieval of the data to enhance database performance.
Involved in data loading using PL/SQL and SQL*Loader calling UNIX scripts to download and manipulate files.
Performed SQL and PL/SQL tuning and Application tuning using various tools like EXPLAIN PLAN, SQL*TRACE, TKPROF and AUTOTRACE.
Extensively involved in using hints to direct the optimizer to choose an optimum query execution plan.
Used Bulk Collections for better performance and easy retrieval of data, by reducing context switching between SQL and PL/SQL engines.
Created PL/SQL scripts to extract the data from the operational database into simple flat text files using UTL_FILE package.
Creation of database objects like tables, views, materialized views, procedures, and packages using oracle tools like Toad, PL/SQL Developer and SQL* plus.
Partitioned the fact tables and materialized views to enhance the performance.
Extensively used bulk collection in PL/SQL objects for improving performance.
Created records, tables, collections (nested tables and arrays) for improving Query performance by reducing context switching.
Modified Perl scripts and Shell Scripts as well.
Translated Perl scripts into Python as Perl was getting complex (Proc to Proc).
Enhanced/Modified existing Crystal Reports and create new reports as well.
Used Network Data Mover (NDM) to migrate data to the downstream interface partners.
Used Pragma Autonomous Transaction to avoid mutating problem in database trigger.
Client: Bank of America Sep 17,2019 to Feb 14,2020
Project Title: Oracle PLSQL Developer: Worked as a database developer for developing and maintenance of Permission Catalogue (PCAT) application used inside the bank for the Managers and Editors.
Permission Catalogue (PCAT) is a huge application software whose front end is Java and Backend is Oracle database which is used to grant and revoke permissions.
Responsibilities:
Worked as an Oracle 12 SQL/PLSQL developer to add the pagination, sorting, and filtering functionalities to the existing PCAT application.
Took part in the business meeting where the clients were informed about the changes to be made to the software.
Actively took part in the design and development to meet the expectations of the clients.
Did the coding in PLSQL to adjust to new demands.
Provide timely updates to management on coding, status, and scheduling issues.
Worked extensively with Oracle Objects like Stored Procedures, Function, Triggers and Sequences depending upon the Client’s needs.
Actively took part in the meeting with Client to understand more about a project to deliver efficient backend support and code enhancement.
Involved in all phases of the SDLC (Software Development Life Cycle) from analysis, design, development, testing, implementation, and maintenance with timely delivery against aggressive deadlines.
Experience with Data flow diagrams, Data dictionary, Database normalization theory techniques, Entity relation modeling and design techniques.
Expertise in Client-Server application development using Oracle 11g/10g/9i/8i, PL/SQL, SQL *PLUS, TOAD and SQL*LOADER.
Effectively made use of Table Functions, Indexes, Table Partitioning, Collections, Analytical functions, Materialized Views, Query Re-Write and Transportable table spaces.
Strong experience in Data warehouse concepts, ETL.
Good knowledge of logical and physical Data Modeling using normalizing Techniques.
Created Tables, Views, Constraints, Index (B Tree, Bitmap and Function Based).
Developed Complex database objects like Stored Procedures, Functions, Packages and Triggers using SQL and PL/SQL. Developed materialized views for data replication in distributed environments.
Updated Python scripts that were called from Shell scripts from the Autosys jobs.
Excellent technical and analytical skills with clear understanding of design goals of ER modeling for OLTP and dimension modeling for OLAP.
Experience in Oracle supplied packages, Dynamic SQL, Records and PL/SQL Tables.
Loaded Data into Oracle Tables using SQL Loader.
Partitioned large Tables using range partition technique.
Experience with Oracle Supplied Packages such as DBMS_SQL, DBMS_JOB and UTL_FILE.
Created Packages and Procedures to automatically drop table indexes and create indexes for the tables.
Worked extensively on Ref Cursor, External Tables and Collections.
Expertise in Dynamic SQL, Collections and Exception handling.
Experience in SQL performance tuning using Cost-Based Optimization (CBO).
Good knowledge of key Oracle performance related features such as Query Optimizer, Execution Plans and Indexes.
Experience with Performance Tuning for Oracle RDBMS using Explain Plan and HINTS.
Experience in ETL techniques and Analysis and Reporting including hands on experience with the Reporting tools such as Cognos.
Created Shell Scripts for invoking SQL scripts and scheduled them using crontab.
Excellent communication, interpersonal, analytical skills, and strong ability to perform as part of a team.
Environment: Windows, TOAD for 12c version 2, MS Excel, and MS Word.
Client: TDBank, Lewiston,ME Sep 05,2017 to June 28,2019
Project Title: Oracle PLSQL Developer: Worked as a database developer for USTS Information Management DB Solutions Team as a DBA/Database developer in the DEV region to support various clients across the bank with their software application systems.
Responsibilities:
Worked as a SQL/PLSQL developer to extract data from various sources to generate reports for further analysis.
Submitted NPID request in ServiceNow portal to create new Oracle service accounts in SIT/PAT and PRD regions.
Deployed the script to create new user in the DEV database region.
Granted the users permission to access different database Objects depending upon their need and position. Created Oracle ROLE and did GRANT on the ROLE to different Users.
Created and deployed the scripts to create Oracle service accounts in DEV region.
Create and deployed the script to install Oracle Service Name on DEV region.
Attended the CHANGE Meeting for PAT and PRD deployments.
Extensively used SQL Loader and MERGE statements for ETL purpose for data and Schema Migration. Initially Informatica was used, later it was decided to use SQL Loader to resolve some issues with Informatica.
Provide timely updates to management on coding, status, and scheduling issues.
Worked extensively with Oracle Objects like Stored Procedures, Function, Triggers and Sequences depending upon the Client’s needs.
Actively took part in the meeting with Client to understand more about a project to deliver efficient backend support and code enhancement.
Often altered the database schema Objects like Tables, Views to include new column.
Very often altered the package written by someone else to adapt to the new clients’ needs and software requirements.
Worked hand-on-hand with Front end developers to understand the flow from back end to the front end.
Updated the SDS Word document quite often as there were some changes made to the database objects. For Example, if a new table object was added to a Schema, then that information was included in the SDS.
Developed Materialized View based on the given set of tables to run on a timely basis using the Unix scripting.
Worked extensively on Oracle VIEWS. Wrote numerous VIEWS to support clients need.
A TRIGGER was fired and the business logic was implemented in different triggers as per the clients need with every DML (INSERT, UPDATE,DELETE) on a table. Wrote such triggers in coordination with the Client based on different meeting session and email threads.
Used PUTTY to login to the DEV UNIX server to perform DBA tasks.
Altered the SEQUENCE as the Sequence was out of Sync.
Perform regular analysis of existing reports/queries to make it more efficient.
Provide timely updates to management on coding, status, and scheduling issues.
Made use of GITBUCKET daily to get the latest code update on the Project done by others in the team and updated GIT repository when I did some new SQL/PLSQL Script.
Worked on the Migration Project where we did migration of all the database Objects from Oracle 9i to Oracle 12c.Various issues were faced as 12c does not support some features in Oracle 9i. Translated those old 9i features to Oracle 12c.
Wrote conversion scripts using SQL, PL/SQL, stored procedures, functions, and packages to migrate data from SQL server database to Oracle database.
Performed Functional/Non-Functional testing after the SQL/PLSQL scripting was complete before handing over the package to the client for testing.
Performed lots of UNIT testing to make sure that all the bugs are eliminated from the package and new enhancements were developed as requested.
Environment: Windows, SQL Developer for Oracle 11g,12c version 2, MS Excel, and MS Word.
Client: OIT (Office of Information Technology), State of Maine, Augusta, Maine October 03,2016 to March 16,2017
Project Title: Lead Programmer Analyst the Office of Information Technology (OIT): The Office of Information Technology is responsible for the delivery of safe, secure, and high-performing networks and systems to State Agencies for daily performance of their missions for the citizens of Maine. Responsibilities:
Working as a Lead Programmer. Do a deep analysis of the business to come up with a solution.
Frequently meet with the customer to understand their functional needs and create good documentation.
Do a knowledge transfer to the junior programmer on research I had recently or previously conducted.
Deployed Jira daily to log the software issue, customers feedback, software bugs and encouraged others to log all the activities in Jira.
Make changes to the existing Oracle database to need the meet of the Customers.
Participated in the analysis of current business processes and systems to recommend process and system enhancements to improve business performance and maximize the effectiveness of technology.
Identified, clarified, and resolved data discrepancies, to ensure it is complete, valid, and accurate.
Used Informatica for ETL activities.
Use Oracle 18 SQL, PL/SQL for day-to-day ad-hoc requests. Add/Modify features to the existing forms built in Oracle Reports.
Add/Modify features to the existing reports built in Crystal Reports. Fix errors in the SQL code to generate the correct report.
Submit the reports in Excel to Customers. Occasional Production Database Updates, Data-Fix.
Assist one consultant to give him the task and supervise.
Environment: Windows, SQL Developer for Oracle 11g, MS Excel and MS Word
Client: MTRS (Commonwealth of Massachusetts), State of Massachusetts, MA July 13,2015 to Sep 24,2016
Project Title: Oracle SQL/PL-SQL Developer
Massachusetts Teachers’ Retirement System (MTRS): The Massachusetts Teachers’ Retirement System is the largest of the Commonwealth’s 104 contributory retirement systems. MTRS provides retirement, disability, and survivor benefits to more than 90,000 active educators and 62,000 retirees and survivors.
Responsibilities:
Implemented Oracle 12 SQL/PL-SQL code to generate the data for the MTRS analysis.
After the data being tested by the QA team, uploaded to the PROD environment.
Made heavy use of Cursors, Triggers, Function/Procedures, Analytic Functions.
Use SQL, PL/SQL complex queries to derive data from the MTRS database.
Create documentation after the report is generated.
Export the report in MS excel and send it to QA team.
Wrote sequences for automatic generation of unique keys to support primary and foreign key constraints.
Used Data Specs as a metadata management tool.
Deployed Data Specs to collect and manage information distributed over the data-collections, repository, and reports.
Used Data Specs that helped the organization in decision support that increased in data quality and the improvement of data governance.
Used Data Specs to create the metadata dictionary and identified the core data sources.
Normalized the database and created the ER diagram.
Then created the Data Dictionary and added all the newly added Primary key/Foreign Key Constraint.
Environment: Windows, SQL Developer for Oracle 11g, MS Excel
Client: DHHS (OFI), State of Maine, ME Sep 2014 to March 2015
Project Title: Data Analyst
DHHS, Office of Family Independence (OFI) works for the welfare of the citizens of the State of Maine like helping them to provide the health insurance as per their income, train them for job opportunities and temporarily help the needy family with cash benefits.
Its office is located at 19 Union Street, Augusta ME.
Responsibilities:
Generate ad-hoc reports as per the Program Manager.
Use SQL, PL/SQL complex queries to analyze data from the DHHS development and production database.
Create documentation after the report is generated.
Created PL/SQL stored procedures, functions, and packages for moving the data from staging area to data mart.
Created scripts to create new tables, views, queries for new enhancement in the application using TOAD.
Created indexes on the tables for faster retrieval of the data to enhance database performance. Create Automation scripts in Toad Data Point
Environment: Windows, Toad for Oracle 11, Toad Data Point 3.2, MS Excel
Client: Standard & Poor's, NY, Dec 2013 to July 2014
Project Title: Senior Oracle Developer
Standard & Poor's Financial Services LLC (S&P) is an American financial services company. It is a division of McGraw Hill Financial that publishes financial research and analysis on stocks and bonds.
Responsibilities:
Interact with the Business Teams in the requirements gathering.
Associate with the system analyst in developing the use cases and class diagrams.
Working with Database Architects in designing and maintaining the database structure.
Designing database structure using ERWin.
Creating DDL scripts from ERWin.
Developed PL/SQL procedures, functions, triggers.
Created materialized views.
Used Java to create interactive pages.
Unix Shell Scripting.
Used clustered indexes to enhance performance of the application.
Handled DBA activities like Grant/Revoke privileges to database objects.
Imported data into database from other files like xls, xml using PL/SQL procedures and External Table.
Wrote UNIX script for batch process.
Production support which includes PL/SQL package and UNIX Scripts bug fixing, manual Updates/Inserts and monitoring of processes.
Used autonomous transactions in PL/SQL for various business rules.
Prepared schema statistics, data preparation by import/export from external databases in Dev and Quality control databases.
Oracle Forms 10g, Oracle Reports 10g, Oracle SQL and Oracle PL/SQL.
Environment: Informatica (PowerCenter 5.1/6.2/7.1/8.6.1/9.1.0, PowerMart 5.1, Power Connect/Power Exchange for SAP R/3, Mainframe and Oracle Change Data Capture (CDC), AB Initio 1.8 and SQL*Loader.HP-Unix, Oracle 9i/10g, Business Objects 6.5/XI R2, Toad, Informatica, Power Center 7.0, Autosys.
Client: Citibank, N.Y Nov 2012 to Oct 2013
Project Title: Senior PL/SQL Consultant
The Citibank Financial Data Warehouse (FDW) is a reporting system built to support financial analysis and strategic decision-making process. Various reports including custom built management reports and global performance reports are generated from this system.
Responsibilities:
Worked as Team lead, and led a team of four developers, Responsible for requirement gathering, status reporting, creating various metrics, project deliverables.
Conduct Technical Reviews and Audits of existing systems and Developed strategy document for new implementation.
Involved in analyzing and adding new features of Oracle 10g like DBMS_SHEDULER, Damp pump, Regular Expressions, Automatic Statistics collections in existing Oracle 9i applications.
Developed PL/SQL procedures, Functions and Packages and used PL/SQL ETL Table functions to load data into the database.
Tuned Report performance by exploiting the Oracle's ne built-in functions and rewriting SQL statements.
Used Crystal Report to generate reports.
Created custom Excel reports for dynamically grouping and analyzing financial account details. This was an Oracle financials R12 instance. Created MD70 for work.
Used EXPLAIN PLAN, TKPROF to tune SQL queries, Crystal Report.
Create conversion routines and add custom reports for converting legacy chemical analysis quality system into Oracle.
Client: United Healthcare, California Feb 2011 to Sep 2012
Project Title: Senior PL/SQL Consultant
UnitedHealth Group Inc. is an American managed health care company based in Minnetonka, Minnesota. It is 6th in the United States on the Fortune 500.UnitedHealth Group offers products and services through two operating businesses, UnitedHealthcare and Optum, both subsidiaries of UnitedHealth Group.
Responsibilities:
Used Oracle JDeveloper to support JA Built complex queries using SQL and wrote stored procedures using PL/SQL in Various APIs like Java, .Net and Hierarchical databases like Oracle and Access.
Developed and modified several Forms and for various modules. Also responsible for following up bugs reported by various users and suggesting possible patches to be applied.
Wrote Shell Scripts for Data loading and DDL Scripts.
Worked in Production Support Environment as well as QA/TEST environments for projects, work orders, maintenance requests, bug fixes, enhancements, data changes, etc.
Used Oracle JDeveloper to support JAVA, JSP
Contact this candidate