Home

SRI PUDI - ORACLE APEX DEV

[email protected]

Location: Woodinville, Washington, USA

Relocation: WA

Visa: GC

Summary: Over 16+ years of IT experience in Analysis, Design, Development and Implementation of Oracle, Oracle Apex, Business Objects and Optim. Experience with system analysis and architecture and capacity planning. Upgrading and migration of Oracle 9i/10g/11g and Oracle Apex 3.0/3.1/4.0. Proficient in Database administration tasks like Installation, Configuration, Creation and Patching of oracle products. Designing logical database from gathered requirements and transforming in to physical database. Expertise in using APEX 4.0/ 3 1/3.0 application builder tool to build database driven applications such as developed Interactive Reports and Hyper Text Linked Reports. Experience in developing validations of the page and page items using Ajax calls and also PL SQL packages. Experience in developing interfaces to interact with multiple schemas for data loads and refresh. Experience in preventing SQL injection and URL tampering over the APEX applications. Expertise in using HTML, CSS, Jquery, JavaScript and Ajax in APEX applications to have client side programming and validations. Experience in implementing Authentication, Authorization on Embedded PL SQL gateway, Oracle HTTP Server and Web logic server. Expertise in Database Performance Tuning using Oracle Hints, Explain plan, TKPROF, Partitioning and Indexes. Experience in developing SQL*Loader control programs and PL SQL validation scripts for validating data to load data from staging tables to production tables. Expertise in Oracle, PL/SQL, UNIX & exposure with large database applications of Data warehouse as well as Client/Server in various stages of SDLC like Development, Enhancement, Maintenance & Production Support Well-versed with conversion, customization and developing interfaces for Purchasing (PO, Supplier), Financial (AP, AR, FA, GL), Manufacturing (INV, BOM) and Order Management (OE) with expertise in setting up business rules, data mapping and data validation. Extensive experience as Oracle Developer in developing and utilizing PL/SQL procedures, functions, packages, triggers, shell scripting, unit testing and also involved in data extraction, transformation and loading operations on oracle using SQL Loader. Strong Shell scripting abilities and on-call support 24 X 7 Production server support. Strong communication, leadership, organizational, analytical, interpersonal skills and strong problem solving skills. Communicated and interfaced with Oracle support via Metalink to troubleshoot day-to-day database issues. Education: Master of Computer Applications from University of Madras, India Technical Proficiency: Database: Oracle Application Express (APEX)20/5/4/3,Oracle 8i/9i/10g/11i, SQL Server 2000/2005, MySQL, DB2/AS400, DB2 UDB, DB2 for z/OS, IMS, Optim, SQL*Plus, SQL*Loader, PL/SQL, ODBC, DG4ODBC, HSODBC, T-SQL, SSIS, SSRS, Sybase, MS Access, TOAD for Oracle, ERWIN, TOAD, data modeller. Applications/Tools: Optim 11.3/9.1/8.1/7.3.1/7.3.0, DB Visulizer, Data Direct ODBC Drivers, Vormetric encryption, VMWare Server Business Objects Enterprise. Programming Language: UNIX Shell Scripting, SQL, PL/SQL, SQL Plus, Transact SQL, ANSI SQL, VB, C, C++. Operating Systems : Windows NT/XP/00, MS-DOS, Solaris, Linux, AIX. Packages : MS Office. Professional Experience: AT&T, WA Mar 14- Till Date Sr. Oracle Apex Developer/DBA Responsibilities: Installed 11g,10g R2 in with Oracle s cluster ware, migrated 9i standalone database to 11G Real Application Clusters (RAC) environment with 2 nodes in Linux environment Gather requirements and review functional requirements, business flows including application security Responsible for developing custom application using APEX. This involves developing APEX Reports and Forms, conversion of Oracle Reports into Oracle APEX Reports. Involved in full development cycle of planning Analysis, Design, Development, Testing Implementation. Created page processes at several instances and computations in APEX. Responsible for System Analysis, Design, Development and test plan. Used PHP code to retire the CLOB and BLOB data types data from archived data. Involved in building Interface using APEX, conversion of Oracle Portal Reports to APEX Reports. Responsible for Oracle APEX Administrator. This involves creating APEX user including end users, providing access, creating database objects like tables, views, triggers, packages and procedure. Responsible for fixing existing application built in APEX, this involves fixing few front ends and reports. Involved in building application using APEX to replace the existing legacy system, this involves data conversion from legacy to oracle, development of APEX screen and Interactive reports. Responsible for providing security to APEX Application using Authorization Schema. Created different types of items like shuttles, drop down boxes, different types of date functions. Developed validations using Ajax calls with JavaScript and PL SQL packages. Developed well-built navigation system using APEX tabs, Lists, Trees and JQuery plugins. Experience in using Application processes and items for code reusability across the application. Experience in building classic reports, interactive reports and dynamic pl sql reports to enhance the performance. Followed standardized patterns to prevent SQL injections and url tampering from APEX applications. Experience working with several types of pages items, regions, page processes and branching. Experience in conditional processing of code and display regions based on several conditions. Configure SSL for APEX over web logic server, HTTP server and others in Test and production environments. Designed the look and feel of the APEX forms (User Interface) along with the users. Developed the user interface using the Oracle Apex form types depending on the requirements. Develop phase, APEX application and Develop PL SQL API's for business logic (business Logic is not to be developed in APEX) Environment: Oracle 9i/10g/11g, Oracle Apex 20/5.0/4.0/3.1/3/0, Optim 8.1/7.3.1/7.3.0, MS Access, TOAD, ODBC Drivers, DG4ODBC, HSODBC, SQL*Loader, Solaris, Windows 2003. Express Scripts, MN May 13- Feb'14 Sr Apex Developer System Retirement Team is the Express Scripts (ESI) standard repository for the databases of retired applications. The data is retained to support legal and auditing requirements across the ESI. ESI tracks legal approvals, data retention periods, and storage savings from application retirement. Here is to build and maintain the Optim production environment, interact with application managers, subject matter experts, technical team members to understand the application, archive, encryption requirements and retention policies, extract data from production environments. I ve archived from various relational and non-relational data sources. Using archive data to create the Canned reports in Apex. Involved in full development cycle of planning Analysis, Design, Development, Testing Implementation. Created page processes at several instances and computations in APEX. Responsible for System Analysis, Design, Development and test plan. Used PHP code to retire the CLOB and BLOB data types data from archived data. Responsible for providing security to APEX Application using Authorization Schema. Created different types of items like shuttles, drop down boxes, different types of date functions. Developed validations using Ajax calls with JavaScript and PL SQL packages. Involved in building Interface using APEX, conversion of Oracle Portal Reports to APEX Reports. Responsible for Oracle APEX Administrator. This involves creating APEX user including end users, providing access, creating database objects like tables, views, triggers, packages and procedure. Responsible for fixing existing application built in APEX, this involves fixing few front ends and reports. Involved in building application using APEX to replace the existing legacy system, this involves data conversion from legacy to oracle, development of APEX screen and Interactive reports. Developed well-built navigation system using APEX tabs, Lists, Trees and JQuery plugins. Experience in using Application processes and items for code reusability across the application. Experience in building classic reports, interactive reports and dynamic pl sql reports to enhance the performance. Followed standardized patterns to prevent SQL injections and url tampering from APEX applications. Experience working with several types of pages items, regions, page processes and branching. Experience in conditional processing of code and display regions based on several conditions. Configure SSL for APEX over web logic server, HTTP server and others in Test and production environments. Designed the look and feel of the APEX forms (User Interface) along with the users. Developed the user interface using the Oracle Apex form types depending on the requirements. Develop phase, APEX application and Develop PL SQL API's for business logic (business Logic is not to be developed in APEX) Environment: Oracle 9i/10g/11g, Oracle Apex 4.0/3.1/3/0, Optim 8.1/7.3.1/7.3.0, MS Access, TOAD, ODBC Drivers, DG4ODBC, HSODBC, SQL*Loader, Solaris, Windows 2003. AT&T, WA AUG 10- APR 13 Oracle Apex Developer/DBA Responsibilities: Gather requirements and review functional requirements, business flows including application security Responsible for developing custom application using APEX. This involves developing APEX Reports and Forms, conversion of Oracle Reports into Oracle APEX Reports. Involved in full development cycle of planning Analysis, Design, Development, Testing Implementation. Created page processes at several instances and computations in APEX. Responsible for System Analysis, Design, Development and test plan. Used PHP code to retire the CLOB and BLOB data types data from archived data. Involved in building Interface using APEX, conversion of Oracle Portal Reports to APEX Reports. Responsible for Oracle APEX Administrator. This involves creating APEX user including end users, providing access, creating database objects like tables, views, triggers, packages and procedure. Responsible for fixing existing application built in APEX, this involves fixing few front ends and reports. Involved in building application using APEX to replace the existing legacy system, this involves data conversion from legacy to oracle, development of APEX screen and Interactive reports. Responsible for providing security to APEX Application using Authorization Schema. Created different types of items like shuttles, drop down boxes, different types of date functions. Developed validations using Ajax calls with JavaScript and PL SQL packages. Developed well-built navigation system using APEX tabs, Lists, Trees and JQuery plugins. Experience in using Application processes and items for code reusability across the application. Experience in building classic reports, interactive reports and dynamic pl sql reports to enhance the performance. Followed standardized patterns to prevent SQL injections and url tampering from APEX applications. Experience working with several types of pages items, regions, page processes and branching. Experience in conditional processing of code and display regions based on several conditions. Configure SSL for APEX over web logic server, HTTP server and others in Test and production environments. Designed the look and feel of the APEX forms (User Interface) along with the users. Developed the user interface using the Oracle Apex form types depending on the requirements. Develop phase, APEX application and Develop PL SQL API's for business logic (business Logic is not to be developed in APEX) Environment: Oracle 9i/10g, Oracle Apex 3.1/3/0, Optim 7.3.0, MS Access, TOAD, ODBC Drivers, DG4ODBC, HSODBC, SQL*Loader, Solaris. Citi Group, NJ Nov 08 July 10 Oracle APEX Developer Responsibilities: Studied user requirements and functional specifications. Converted User Requirements into formal Functional specification and Interfacing with client. Responsible for building application using APEX 4.0 (Reports Forms) to replace the existing legacy system. Used Oracle APEX 4.0 utilities to Export and Import Large Volumes of Data in the format of CSV files, Excel Sheets into the tables. Developed and implemented authorization and authentication rules for Application Administrators in order to manage the Oracle APEX applications, users, and their log activity details. Developed Authorization Schemes functionality of APEX to set up security on the Screens in the application based on user roles. Created page level and item level validations in APEX form using JavaScript. Generated templates of page in Apex using HTML, CSS. Implemented some of the plugins available in open source. Implemented application level processes to interact with the databases for fetching the data without page submissions. Responsible for performing validations against the database column data in Oracle APEX Interactive reports and tabular forms using JavaScript. Responsible for converting Portal Reports into APEX Reports. Generated DDL statements for creation of new database objects like tables, views, sequences, functions, synonyms, indexes, triggers, packages and stored procedures. Developed Database Triggers to enforce security also used ref cursors Created and modified SQL*Loader scripts for migrating flat file data into target. Used advanced SQL features like Inline views, advanced Joins, Decodes, Indexing, Bulk Inserts, Bulk collects and other analytical functions in 10g. Designed and developed complex procedures to handle errors and exceptions level using PL SQL and SHELL scripts. Environment: Oracle Application Express 4.0 3.2, Oracle 11g, SQL Developer, Forms 10g, Reports10g, Designer 10g, SQL *Plus, XML, TOAD, PL SQL, HP-UX, Windows NT 2000 ACS, MD Jul 07 Oct 08 Oracle APEX Developer Responsibilities: Involved in the complete Life Cycle of database development that included creating Stored Procedures, designing database and populating data for web portal for views and reporting needs. Customized standard reports with the user requirements using Oracle Reports. Involved in developing user interface using Oracle APEX forms. Created parameter entry forms for the Oracle Reports to integrate them with APEX. Created Page level and Item level validations and also page processes and computations using APEX. Implemented validations using AJAX and JavaScript processing for server side data fetches. Implemented JQuery tabs, auto complete feature, popup alerts and date pickers in Apex Used Authorization Schemes functionality of APEX to set up security on the screens in the application based on user roles. Implemented notification systems for higher-level managers to send mails using APEX email. Created Tables, Indexes, Sequences, Triggers, Procedures, and Functions for faster data access and to incorporate business logic. Analyzing data that comes from different sources and wrote packages for maintaining a standard format. Used the Data load unload functionality in APEX to upload first time data into the database tables. Involved in writing complex queries, Functions, Procedures and Packages for the project as required using TOAD. Involved in Unit and Integration testing of PL SQL Procedures, Functions and Database Triggers Involved in offshore team coordination. Working with them to provide necessary requirement documentation, validating the development work and bug tracking. Involved in Production Support, problem resolutions and bug fixing. Actively involved in raising issues and coordinating between the Management Users. Environment: Oracle Application Express 3.0, Oracle 10g, JQuery, PL SQL, SQL TOAD, Windows XP AG Edwards, MO Apr 05 June 07 Oracle DBA Responsibilities: Created database objects for the system like tables, views, sequences, functions, synonyms, indexes, triggers, packages and stored procedures Developed Front-end forms depending upon the logic such as Master-detail form and complex forms for the application. Loaded data into various tables from Flat files, Access database as well as from Excel Spreadsheets using SQL*Loader. Developed stored procedures, packages and functions for the application that could be called by Forms Reports. Developed complex reports like matrix reports, tabular reports for the systems using running totals, sub totals, grand totals and daily balance. Developed new Data Input forms and Reports using Oracle Forms and Reports builder. Written scripts to create Temporary tables in various schemas and Audit Transactions. Wrote SQL, PLSQL, SQL*Plus programs required to retrieve data from the Data repository using cursors and exception handling. Environment: Oracle 8i, UNIX, Forms 4.5 and Reports 2.5, SQL, SQL*Plus, PL SQL, SQL*Loader, Toad. UBS, NJ May 04-Apr 05 Oracle Programmer Responsibilities: Developed project utilizing Oracle Developer 2000 (Forms 9i, Reports 9i, and PL/SQL) on a Windows NT and UNIX platforms using Oracle 9iAS as Application Server. Created tables, temporary tables, materialized views, constraints, managing triggers, stored procedures & cursors. Wrote the Scripts to create tables, functions, stored procedures, Triggers, Packages, Indexes, and Views. Created Universes, Classes, Dimension and Measure Objects by retrieving the data from various data sources and defining the necessary connections. Detected/Resolved data Cardinalities and loops, checked integrity of Universes, created list of values. Resolved Chasm, Fan traps and Loop problems using aliases and contexts in the universe and exported to repository. Created reports using Business Objects functionalities like queries, cross tab, master detail reports, formulas, Customized filters to display relevant data, etc. Created complex reports using cascading prompts. Created variables, formulas and used contexts (in, for all, for each). Created Web Intelligence reports using Multiple Data Providers, Prompts, break, filter, rank, alerters, Slice & Dice and Drill up/down functionality. Also involved in the business analysis, design, coding and testing of the Data analysis. Design new database table structure using MS-VISIO as data modeling tool and creating backend store procedures, packages and functions using SQL and PL/SQL. Prepared DS (Design specifications) from FS (Functional Specifications). Executed UAT (User Acceptance Test) and changed the system as per new requirement due to change in IIG Business. Used Report 9i for all reporting purpose, which was designed on the basis of a configurable table driven procedure. Users can analyze and print the same for the corporate paper work. End User training, bug fixing and Post Implementation Support. ENVIRONMENT: UNIX, Oracle 8i, Business objects 6i,PL/SQL, TOAD, DDL, DML, Developer2000 (Forms 8i, Reports 8i), Window NT, DS, FS, WINCVS, Performance Tuning. Airtel cellular India Pvt Ltd, Hyderabad Feb 03 Apr 04 Programmer/Analyst Responsibilities: Extensively involved in requirements gathering and data gathering to support developers. Involved in designing and of functional specifications for the development of user interfaces. Involved in designing of Entity Relationship Diagrams. Created tables, indexes, sequences, constraints and snapshots. Developed packages, procedures, functions and PL/SQL blocks for data validation. Developed PL/SQL scripts to validate and load data into interface tables. Fixed software bugs and interacted with developers to resolve technical issues. Helped in writing proposals, documentation and training. Designed and developed a Generic Billing system for a Telecommunication company. Environment: Oracle 7.3.2, SQL, PL/SQL, Shell Scripts, Oracle Forms 4.5/Reports 2.5, MS Access, MS Excel. State Co-Operative Central Bank, Hyderabad, India May 02-Jan 03 Database /Application Developer Responsibilities: Designed the Interface of the Loans System with other modules at Branch Office Level. Finalized the table scripts of Long term, Medium term and Financial Accounting System Developed the entire Recovery part of banking and loaning system of Long term module Integrated the Long Term Loans Module with Financial Accounting System. Developed various MIS Reports using Crystal Reports. Involved in the testing of long Term Loans, Medium Term Loans, and Financial System. Involved in the Integrated Testing of the Project. Environment : Wind Keywords: cprogramm cplusplus user experience database zos information technology hewlett packard purchase order microsoft procedural language Arkansas Colorado Maryland Minnesota Missouri New Jersey Washington