We provide IT Staff Augmentation Services!

Programmer Analyst (production Support) Resume

Monroville, PA

SUMMARY:

  • Around 12 + years of experience as Oracle Developer in complete software development life cycle with active participation in database design, development, reporting and administrative tasks.
  • Expertise in developing applications using IDs: Forms11g/10g/9i/6i & Reports10g/9i/6i, Oracle Designer10g for Data modeling.
  • Extensive experience working with Oracle databases (8i/9i/10g/11g)Back - end Programming using SQL, PL/SQL, Packages, Stored Procedures, Functions, Packages, Database triggers for Oracle 10g/9i/8i and also SQL queries/reports.
  • Experience in ODBC and JDBC programming, Unix shell scripting, including development of Unix Shell scripts
  • Expertise in SQL and PL/SQL programming, developing complex code units and using the latest features to optimize performance (Bulk Binds, Materialized views, Inline views, Global Temporary Tables).
  • Good programming and debugging skills in PL/SQL, SQL, Dynamic SQL and UNIX shell scripting
  • Strong skills in writing technical and functional documents defined by the business requirements
  • Gathering the requirement from the BA and according that prepare the DFD and ER Diagrams
  • Retail, Banking, Investments and Healthcare industry experience.
  • Knowledge in web logic server application
  • Performed Application and SQL statement tuning using Explain Plan, Optimizer Hints and Partitioning etc.
  • Usage of utilities such as SQL Loader, export, imports.
  • Designed static HTML web sites
  • Knowledge in Agile.
  • Follow SDLC Rules in all the project
  • Excellent Communication, interpersonal skills. Worked in team environment with Managers, team leads, internal customers, other departments
  • Experience with Data Modeling using Oracle Designer/Erwin Tools and performed activities such as configuration of Applications and sharing/unsharring them across multiple applications. Created complex E-R diagrams, Data flow diagrams, Server model configurations and implementations. New repository creations and migrations.

SKILL:

Software: Oracle Enterprise Edition 11g/10g/9i/8i on Unix as well as Windows XP/2000/NT, Oracle Forms (11g/10g/9i/6i), Oracle Reports (10g/9i/6i), SQL*Plus, PL/SQL, Stored Procedures/Functions, SQL*Loader, HTML, JAVA, JDBC, Portal, Database Triggers, Instead of Triggers, Packages, LOB s, Data Modeling using Oracle Designer (10g/6i/6.0/2.x/1.x), PVCS Version Manager, Star Team, PVCS Tracker

Hardware /OS: SUN Fire UNIX Systems, Windows 2000/98/95, Sun Solaris, HP 9000 UNIX

Tools: SQL * Navigator 4.x, TOAD, DBA Studio, SQL *Trace, SQL * Plus

PROFESSIONAL EXPERIENCE:

Confidential, Monroville, PA

Programmer Analyst (Production Support)

Responsibilities:

  • Design the Tech Documents as per the Business Requirement
  • Design the Database Structure
  • Experienced in design and development of web applications using Forms, Oracle
  • Involve in the analysis, design, development and maintenance of the features that are being added to the application.
  • Experienced in production support activities involving bug fixes, monitoring the applications,
  • Resolving the issues raised by the end user.
  • Creating Oracle tables, views, packages & Production Support in SPARCS and creating
  • Procedures, Developing new forms and new reports using Oracle
  • Customizing and optimizing existing PL/SQL packages, procedures and functions to accommodate change in functionality and better performance Writing the database triggers and using Dynamic SQL in Oracle Forms and Oracle Reports
  • Experienced in implementing design patterns across web applications.
  • Specialized in the development of applications on both Windows and UNIX environments.
  • Experienced in Requirement management, Design, Implementation, Integration, Deployment and
  • Testing. Experienced in Bug/Defect tracking tools (Jira, Bugzilla and HP Quality Center).
  • Experienced in Change Management and Configuration Management processes (GIT, SVN,
  • Confidential, Jenkins, PVCS).
  • Experienced in Functional, Regression, Integration, Manual, System, End to end, Security, Load and
  • Performance testing. Supporting data Migration Activities Excellent interpersonal and communication skills.
  • Worked individually as well as a team player.
  • Used Form properties and triggers to control insert, update and deletes of table data.
  • Developed Oracle Forms using mater-detail triggers, navigation triggers, message-handling triggers and interface event triggers.
  • Developed Oracle Forms using Mouse event triggers and System variables.
  • Developed Custom Menus using Menus and menu items in Oracle Forms.
  • Developed Multiple Blocks Forms and deployed.
  • Developed Menus and implemented security through menu roles.
  • Created PL/SQL packages using collections like Nested tables and Arrays.
  • Created PL/SQL packages using ref cursors and dynamic SQL.
  • Created PL/SQL packages using new features like table functions.
  • Created Standalone Procedures and Functions to call from User interfaces.
  • Created database Triggers for inserting primary keys and auditing of user records.
  • Improved SQL queries by tuning SQL queries.
  • Improved PLSQL program unit’s performance by batch processing process.
  • Improved PLSQL program unit’s performance by tuning PL/SQL.
  • Developed Unix Shell Scripts and called from PL/SQL packages.
  • Administered Oracle Database by creating Schema objects, partition tables and indexes.
  • Exported and Imported Oracle Data using Data Pump export and import utility.
  • Replicated Database using Oracle Advance Queue.

Environment: Oracle Database 11g, Forms11g, Reports 10g, Forms 12c, TOAD(Version 12.6.0.53), Windows XP,Linux

Confidential, Chantilly, VA

PLSQL Developer

Responsibilities:

  • Design the technical specification and documentation
  • E-ACCESS support for development and enhancement in PLSQL and JAVASCRIPT
  • Development of PL/SQL code by using Packages, Stored Procedures/Function and database level triggers
  • Generation of DDL’s and Tables, data reorganization to enhance performance
  • Database and Application Tuning
  • Developed PL/SQL Stored Procedures/Functions to meet the business needs.
  • Developed PL/SQL Packages to facilitate financial applications.
  • Tuned PL/SQL Packages and PL/SQL Stored Procedures/Functions to improve the performance using EXPLAIN PLAN, TKPROF and SQL TRACE.
  • Tables and Indexes Creation, Clusters, data reorganization to enhance performance
  • Maintenance of Production & Test Databases

Environment: Oracle Database 11g, TOAD, Windows XP

Confidential, CA

Oracle Forms Developer

Responsibilities:

  • Installed Oracle 11g Database and Installed Web Logic Server also configured both front end and back end.
  • Developed Forms10g coding standards as per the Application needs.
  • Configured webutil for Upload and Download files.
  • Developed PL/SQL Stored Procedures/Functions to meet the business needs.
  • Developed PL/SQL Packages to facilitate financial applications.
  • Development of Forms10g/Reports10g in order to provide user interface.
  • Developed Forms based on PL/SQL Stored Procedures to implement complex business functionality.
  • Developed Object Libraries to maintain standards in Forms.
  • Used PL/SQL bulk insert to insert the data into multiple table.
  • Developed utilities to Upload/Download Client Local files to the IAS server and perform Database changes according to the contents of the files using Webutil package.
  • Developed various Reports to meet the customer needs.
  • Modified the existing reports using Oracle discoverer to meet the business needs.
  • Web based Development using iAS10g, Forms10g/9i/6i, Reports10g/9i/6i.
  • Development of Database level triggers to update data into multiple tables.
  • Developed Menus in such way that users can access the forms through menus.
  • Development of single form to run all the Reports as central point.
  • Developed List of values to populate data in certain conditions based on Record Groups.
  • Databases and Application Tuning Maintenance of Production & Test Databases

Environment: Oracle Database 11g, Forms11g, Reports 10g,TOAD, Windows8

Confidential, PA

Oracle Forms Developer

Responsibilities:

  • Created Oracle Multiple Oracle Forms 10g and Reports 10g and deployed.
  • Developed Oracle Forms using templates and Object libraries.
  • Manipulated Stacked and tab canvas programmatically.
  • Manipulated Windows programmatically by moving and resizing windows in Oracle Forms.
  • Implemented Timer, record group and Lov in Oracle Forms.
  • Implemented Multiple Oracle Forms and pass parameter values while invoking Forms.
  • Developed Oracle Forms using text items, check boxes, display items, list items, and radio groups in Oracle Forms.
  • Used Form properties and triggers to control insert, update and deletes of table data.
  • Developed Oracle Forms using mater-detail triggers, navigation triggers, message-handling triggers and interface event triggers.
  • Developed Oracle Forms using Mouse event triggers and System variables.
  • Developed Custom Menus using Menus and menu items in Oracle Forms.
  • Developed Multiple Blocks Forms and deployed.
  • Developed Menus and implemented security through menu roles.
  • Created PL/SQL packages using collections like Nested tables and Varrays.
  • Created PL/SQL packages using ref cursors and dynamic SQL.
  • Created PL/SQL packages using new features like table functions.
  • Created Standalone Procedures and Functions to call from User interfaces.
  • Created database Triggers for inserting primary keys and auditing of user records.
  • Improved SQL queries by tuning SQL queries.
  • Improved PLSQL program unit’s performance by batch processing process.
  • Improved PLSQL program unit’s performance by tuning PL/SQL.
  • Developed Unix Shell Scripts and called from PL/SQL packages.
  • Administered Oracle Database by creating Schema objects, partition tables and indexes.
  • Exported and Imported Oracle Data using Data Pump export and import utility.
  • Replicated Database using Oracle Advance Queue.

Environment: Oracle Database 11g, Forms11g, Reports 10g, TOAD, Windows XP,Linux

Confidential, Whitehall, MI

Oracle Developer

Responsibilities:

  • Designed the technical specification and documentation
  • Debugged PL/SQL Code, Performance Tuned bad SQL’s, Developed Procedures, Functions and Packages for the business need
  • Owned all the Application Deliveries that TCS performed on behalf of APP as an Onshore Coordinator Confidential APP and TCS
  • Migrated COBOL Reports to Oracle Reports
  • As an Onshore Coordinator Alcoa APP & TCS, owning all the Application Deliveries that TCS is performing on behalf of APP
  • Initiated & formulated project status tracking tools and ideas where taken by client TCS team performed greatly in conversion and testing phase and based on the recommendation from Client, tried to get some more projects for TCS in other areas in APP IT
  • Arranging Weekly Status Call, Monthly meeting between customer & TCS, preparing the status reports and presentations, periodic feedback of the team from client are some of the activities, ensuring Customer Satisfaction
  • Development of Unix Shell scripts, Unix shell scripts run the stored procedures/functions from Unix
  • Worked on the technical areas like help understanding customer requirements on forms, reports changes & testing and acted as an onshore technical co-coordinator between customer and TCS offshore team
  • Troubleshoot Oracle Forms, Reports and PL/SQL code in the production environment

Environment: Oracle Database 11g, TOAD, Windows XP/ Linux 5

Confidential, Tampa, FL

PLSQL Developer

Responsibilities:

  • Design the technical specification and documentation
  • Development of PL/SQL code by using Packages, Stored Procedures/Function and database level triggers
  • Generation of DDL’s and Tables, data reorganization to enhance performance
  • Database and Application Tuning
  • Development of Unix Shell scripts, Unix shell scripts run the stored procedures/functions from Unix
  • Using Data mapping tools to transfer data between source databases to destination database

Environment: Oracle Database 11g, TOAD, Windows XP

Confidential, Louisville, KY

Oracle Developer

Responsibilities:

  • Monitor and with investigated issues with production applications.
  • Monitor ticket queues and resolve technical operation issues related to Forms/Reports and PL/SQL.
  • Development of New Orders, Orders monitor, and Search orders complex Forms.
  • Created Object Libraries to provide enterprise level Application standards such as Canvases, Date, Number formats, smart Triggers, Visual attributes, Classes etc.
  • Troubleshooting of existing Forms/Reports to fix issues and enhance of new functionality to meet business needs.
  • Worked with Tech Writers to provide forms/Reports functionality for documentation purposes.
  • Development of Master/Detail forms to display accounting details. Developed many Entry level forms.
  • Generation of Forms Templates, and developed standards for forms and reports, olb and attached libraries development
  • Fixed tickets in Forms & Reports.
  • Developed List of values to populate data in certain conditions based on Record Groups
  • Development of dynamic Reports using Lexical Parameters.

Environment: Oracle Database 10g, Forms11g/10g/9i, Reports 10g/9i, Windows XP, Sun Solaris

Confidential, Chicago, IL

Oracle Forms & Reports Developer

Responsibilities:

  • Developed Forms 10g /11g to meet the business needs
  • Created existing Forms and prepared new Forms
  • Development of Master/Detail forms to display accounting details. Developed many Entry level forms.
  • Development of PL/SQL code by using Packages, Stored Procedures/Functions, and database level triggers.
  • Finding out possible Forms development screens and combinations.
  • Generation of Forms Templates, and developed standards for forms and reports, olb and attached libraries development.
  • Developed various Reports to meet the customer needs.
  • Development of dynamic Reports by using Lexical parameter to run the Generic Reports.
  • Display SSN based on parameter mode either 4 digits or full 9 digits SSN
  • Generated Forms Templates, and developed standards for forms and reports, olb and attached libraries development.
  • Changed Chapter Id condition based on location
  • Developed of Master/Detail forms to display accounting details. Developed many Entry level forms.
  • Created PL/SQL code by using Packages, Stored Procedures/Functions, and database level triggers.

Environment: Oracle10g, Forms11g/10g/9i, Reports 10g/9i, Windows XP, Sun Solaris Unix server v10

Confidential

Oracle Developer

Responsibilities:

  • Migrated code using PVCS into Development, QA and Production environments.
  • Developed of Custom screens using Forms10g based on Stored Procedures to implement complex business functionality, Tab canvases.
  • Created Views based on Multiple Tables and performed data changes using Instead of Triggers for the underlying tables.
  • Developed of Unix Shell scripts to monitor Cron tab jobs; UNIX shell scripts run the stored procedures/functions from UNIX
  • Development of code using Packages, Stored Procedures/Functions to facilitate business needs.
  • Performed database tuning using EXPLAIN PLAN, TKPROF and SQL TRACE, enabling session specific trace using DBMS MONITOR.
  • Developed Object Libraries to maintain standards in the Application.
  • Usage of bulk inserts to insert the data into multiple tables.
  • Created Materialized Views to transfer data from OLTP Database to Warehouse databases in order to perform reports by the Reports Team.
  • Created Snapshot logs to keep the incremental changes and scheduled materialized views to refresh daily.
  • Created more than 25 MViews in Data warehouse environment which are critical to the Reporting system and applied the fast/on demand refresh methods.
  • Developed Reports10g/9i to meet the business needs.
  • Development of dynamic Reports by using Lexical parameter to run the Generic Reports.
  • Using Data mapping tools to transfer data between source databases to destination database.
  • Web based Development using iAS10g, Forms 10g/9i/6i, Reports10g/9i/6i.
  • Developed List of values to populate data in certain conditions based on Record Groups.
  • Developed Menus in such way that users can access the forms through menus.
  • Development of Database level triggers to update data into multiple tables.
  • Data modeling using Designer10g- Creating table definitions, developing E-R Diagrams, DFS’s and Reverse Engineering etc.
  • Support external systems by using DBMS SQL and Scheduled jobs by using DBMS SCHEDULER Packages.
  • Databases and Application Tuning
  • Generation of DDL’s out of Erwin/Designer Tools and deploying in the production databases.
  • Tables and Indexes Creation, Clusters, data reorganization to enhance performance
  • Knowledge in AWR Oracle Report generation from Oracle Instance various procurement and receivables applications like (Smart Plant Materials and great plains)
  • Maintenance of Production & Test Databases

Environment: Oracle Database 10g, Forms11g/10g/9i, Reports 10g/9i, Windows XP and Sun Solaris v10

Confidential

Oracle Developer

Responsibilities:

  • Analysis on current system to convert from Legacy system to Oracle.
  • Finding out possible Forms development screens and combinations.
  • Generation of Forms Templates, and developed standards for forms and reports, olb and attached libraries development.
  • Development of PL/SQL code by using Packages, Stored Procedures/Functions, and database level triggers.
  • Development of Master/Detail forms to display accounting details. Developed many Entry level forms.
  • Development of UNIX shell scripts as needed to perform the Oracle jobs and system monitoring.
  • Migrating forms from Forms 5.3 to Forms 6i and Forms 9i.
  • Assisted in finding objects interdependencies on packages and tables and development of PL/SQL, Packages, SQL, and Forms10g/Reports10g etc.
  • Usage of PL/SQL EXTERNAL TABLES for reading data from the Excel File, which has been generated from the Legacy Systems to transform into Oracle Database Tables.
  • Application Tuning to improve the performance by using SQL*Trace, Explain Plan and TKPROF, Indexes, and Hints.
  • Understanding of Data Flow processes of Legacy and Oracle systems. Development of Data flow diagrams to facilitate the business needs.
  • Use JDBC connection to connect the database from Java applications using servlets.
  • Wrote many java interfaces and applets for user interaction.
  • Development of Test cases and performed Unit testing on the application.
  • Meet with the Users and understand the business needs and presented mock ups before the development of Forms.
  • Create and design reports using Oracle discoverer.
  • Modified the existing reports using Oracle discoverer to meet the business needs.
  • Creation/Modification of DDL’s from Oracle Designer9i.
  • Development of E-R Diagrams using Oracle Designer9i.
  • Created Views based on Multiple Tables and performed data changes using Instead of Triggers for the underlying tables.
  • Databases and Application Tuning
  • Generation of DDL’s out of Erwin/Designer Tools and deploying in the production databases.
  • Tables and Indexes Creation, Clusters, data reorganization to enhance performance
  • Maintenance of Production & Test Databases

Environment: Oracle Enterprise Edition - 10g/9i Database, Designer 10g/9i/6i. Windows 2000

Hire Now