Developer Management
Resume:
Professional Summary:
**+Years of experience as Application Developer (APEX) and Oracle Pl/sql Developer. With Some Oracle DBA Basics.
Architecture, Design and Development of web based application using Oracle APEX.
Implemented Google maps to display the addresses based on the requests entered. Used web services to validate the various address types like Point, Intersection and Range.
Developed and maintained operational and system level documentation.
Developed applications using Oracle Application Express (APEX 5.0).
Integrated IREPORTS to ORACLE APEX.
Modal Pages window and parent page refresh in oracle apex 4.0.
Implementation of dynamic actions, before/after header processes, other processes, validations, branching.
Using ORACLE EBS CRM to generate reports based on clients requirements
Implementation of select list refresh based on another using JavaScript/ Jquery and application processes in APEX 3.2.
Performance Tuning.
Conditional formatting using column header using JavaScript.
Integration oracle apex with BI publisher using parameterized parameter, extracting xml from SQL queries using report queries
Developed and tested the application software systems using the existing Oracle database frame work and extended the functionality of the existing applications.
Developed database objects like tables, views, indexes and sequences.
Developed several back-end Packages, Procedures, Functions and Triggers to use in multiple Forms and series of other backend programs using PL/SQL
Have Designed and monitoring Dash board which is projected on the wall for operation team to monitor, It’s a 24*7 rotational reports using Apex4.0.2
Using APEX COLLECTIONS to implement manual tabular forms.
Use of APEX ITEMS to signify item on the pages and reports.
Implantation of HTML/CSS/JAVASCRIPT/JQUERY with ORACLE APEX.
Have Designed The production database using data modeler by oracle (sql developer data modeler3.0)
Have implemented Download all interactive reports in conditional highlight format to excel and HTML.
Have implemented upload CSV file to table in Apex4.0.2.
Modifying oracle apex repository themes and templates.
Implementation of LDAP /Custom authentication.
Giving oracle apex training to associates.
Implemented ASM (Automatic Storage Management) Oracle 10g in PTPK.
Use of SERVICE NOW to create change request(creation of wrapper scripts, promotion/backup scripts )
Implemented validations on the buttons based on the conditions. Created LOVs, item, page level validations, Templates etc. based on the user requirements.
Involved for performance tuning which include Portioning of table, indexing, materialized view and configuration of initialization on parameters.
Involved in user managed and Recovery
Involved in migration of discoverer reports from development, testingand production release using Oracle Discoverer Administrator tool
ModifiedtheGoogleMapplug-intodisplaythemarkersinordertoidentifythe location of the requests made.
Office of Underground Coordination OUC: Developed application using Oracle APEX to validate the addresses based on the address type. Used web service calls to implement the validations. Created PL/SQL procedures to call from Oracle APEX using On-Demand application process.
Created Application Processes and application items to navigate between pages. ImplementedUploadandDownloadfunctionalitieswherealdermancanuploadany type of documents into the Aldermanic Portal application.
Created technical design document and S2T mapping documents.
Creation of reports, dashboards, and score cards etc.
Designed application software systems to meet the Departmental business requirements.
Performance Monitoring and tuning through OEM.
Provided training to staff in the maintenance and supported the developed application software systems.
Served as a technical resource for other members of the development team.
Used Dynamic Actions to display messages based on a condition.
Manage Alderman / Ward information, Work Types and funding in formation
Experience in using several built-in database packages such as DBMS_JOB, DBMS_OUTPUT, UTL_FILE, and DBMS_SQL to name a few.
Experience in using DBMS_SCHEDULER to run jobs in parallel to improve time- constrained performance.
Expertise in loading data from legacy systems using SQL*Loader.
Extensively worked with third-party database tools like TOAD&PL/SQL Developer.
Strong knowledge of Extraction Transformation and Loading (ETL) processes using UNIX shells scripting, SQL, PL/SQL and SQL Loader.
Good in creating users and maintaining their roles and responsibilities.
Experience in writing Technical design documents and developing unit test documents.
Education:
Bachelors in Information Technology, India
Technical Skills:
Operating Systems
WINDOWS 98/NT/2000/XP, WINDOWS 7, WINDOWS 8, LINUX, UNIX, Windows Server 2000/2003/2008.
Programming skills
SQL, PL/SQL
Oracle Tools
Oracle BI Publisher (Reporting Tool),Oracle Apex (3.2,4.0,4.0.2,4.1,4.2,5.0),Web Service through Oracle apex API,Data Modeling(SQL Developer datamodeler3.0),ORACLE EBS (CRM)
Web Technologies
HTML, CSS, JQUERY, JavaScript.
Reporting Tools
JasperReports (I reports)
Databases
ORACLE 8i/9i/10g/11g/12c,
Web Services
Oracle apex Restful, SOAP
ETL Tools
TALEND
Testing Tools
Quick Test Professional, Rational Robot, Load Runner,Rational Test Manager
Certifications: Oracle Apex Developer Certified.(4.0)
Oracle Certified Associate
IBMDB2
IBM Rational Robot
IBM Rational Test Manager
Professional Experience:
Ally Financials NOV 2012 - Present
Oracle APEX Developer
PFMA( Project Financial Management Application)
PFMA Is an application which manages all the projects in Ally. It uses prior year data to forecast the financials for future years. Starting with resource allocation, resource billing cycle, project management, and line item managements for each project. All the Tollgate Reports generated by the application is reported to the CEO of Ally Financials. Stated in 2012 PFMA has come a long way. Below are some bullet points
a.Generating TOLLGATE REPORTS for each of the projects every month.
b.Apply existing project management experience to comply with Ally conventions for IT project accounting
c.Use PFMA (Program Financial Management Application) to create a project financial forecast
d.Complete the monthly cycle of updating your project financial forecast
OAE IMPLEMENTAION
Oracle application express 4.2 is used to build PFMA. Some of the OAE features used in this project are outlined below:
Creation of manual Tabular forms.
Creation of modal screens which open up on parent screen and after processing the same, it refreshes the parent screen to reflect the changed records.
Implementation of APEX COLLECTIONS.
Implementation of session state protection for URL tampering.
Implementing APEX_SERT to the application to know the THREATS (LOW, MEDIUM, HIGH) SEVERITY.
Creating multiple interactive reports using IFRAMES.
Creating INTERATIVE REPORTS using Function returning query process.
Implementation of Validation functionality to validate some business criteria.
Implementing Computations to process certain business logic to APEX ITEMS.
Implementing GLOBAL PAGE in ORACLE APEX.
Creation of application items and application process.
Using List of values (static, dynamic) to populate select list and pop up select list.
Creation of before/after header process to process certain business logic.
Implementation of LDAP custom authentication.
Implementation of Apex authorization.
Sending out Emails using APEX_MAIL API.
Use of APEX_ITEM API.
Integrating JASPEREPORTS (IREPORTS) to OAE PFMA to generate Tollgate reports.
Creation Of dynamic heading in the page using custom heading pl/sql functionality.
Integrating JavaScript/JQuery/AJAX to Oracle APEX.
Implementing Conditional branching using PL/SQL branching.
Modifying Themes and using user attributes to change the themes according to requirements.
Implementing Partial Refresh to each parameterized SQL CLASSIC report.
PL/SQL IMPLEMENTATION
Creation of packages,procedures,triggers,functions,tables,sequences,views,materialized views,SQL tuning,Bulk Collections.
SERVICE NOW
Creation of Wrapper scripts, Promotion steps to higher environment, creating cart using sql developer.
DOCUMENTATION
Creation of RUNBOOK,PLAYBOOK,USERGUIDE for PFMA
DQET(Data Quality Exception Tracker)
This application will provide Ally with a streamlined mechanism to be notified of exceptions to approved Data Quality rules, a system of record to submit, document, track and disposition exceptions, and a process to determine whether exceptions require formal issue identification via Ally’s Enterprise Issue Management process.
Data Quality rules are established through EDG ACE engagement and are executed through scheduling processes at a predetermined frequency (usually monthly). However there is no process/system to track and report on how the exceptions identified by these rules (Data Quality Exceptions) are being managed and remediated. Also, not all generated exceptions may be material / critical enough to be sent through the Ally’s Enterprise Issue Management process.
Hence an interim solution (Data Quality Exception Tracker or DQET) is required that will fill the gap of systematically managing DQ exceptions though an intermediate system outside of Ally’s Enterprise Issue Management process, and establish a process to manage and link exceptions requiring formal issue identification through Ally’s Enterprise Issue Management system.
The goals of DQET is to manage below points
Define a process to manage EDG Data Quality Exceptions
Provide tool/application to track and document disposition of Data Quality Exceptions
Provide Management reporting of Data Quality Exception Tracking
OAE IMPLEMENTAION
Creation of pl/sql procedure and OAE process to download oracle apex interactive reports in highlighted format.
Creation/managing oracle apex workspace, schema assignments.
Creating and managing Developer user in oracle apex.
Implementing HIDE/SHOW region using OAE.
Implementing URL page branching from report to form page.
Creating breadcrumb navigation.
Creating multilevel TABS
Creation Of dynamic heading in the page using custom heading pl/sql functionality.
Integrating JavaScript/JQuery/AJAX to Oracle APEX.
Implementing Conditional branching using PL/SQL branching.
Modifying Themes and using user attributes to change the themes according to requirements.
Implementing Partial Refresh to each parameterized SQL CLASSIC report.
Creation of modal screens which open up on parent screen and after processing the same, it refreshes the parent screen to reflect the changed records.
Implementation of APEX COLLECTIONS.
Implementation of session state protection for URL tampering.
Implementing APEX_SERT to the application to know the THREATS (LOW, MEDIUM, HIGH) SEVERITY.
Creating multiple tabular forms using IFRAMES.
Creation of application items and application process.
Using List of values (static, dynamic) to populate select list and pop up select list.
Creation of before/after header process to process certain business logic.
Implementation of LDAP custom authentication.
Implementation of Apex authorization.
Sending out Emails using APEX_MAIL API.
Use of APEX_ITEM API.
PL/SQL IMPLEMENTATION
Creation of packages,procedures,triggers,functions,tables,sequences,views,materialized views,SQL tuning,Bulk Collections.
SERVICE NOW
Creation of Wrapper scripts, Promotion steps to higher environment, creating cart using sql developer.
Creating change request and following up till the deployment is complete.
DOCUMENTATION
Creation of RUNBOOK,PLAYBOOK,USERGUIDE for DQET
BCMS(Business Counterparty Management System)
Business Counterparty Management System (BCMS) is the system of record for storing Ally’s counterparties, risk ratings, and limits (both global and allocated). It is owned and used by Credit Risk Management.
BCMS basically used to store the records for the Counterparties. For each counterparty what is the GLOBAL Limit and what is the Allocated Limit is decided based on rating for the counterparty. At any stage Allocated limit should not exceed the global limit. Global limit factor depends upon the rating of the counterparty.
It is also used for MODEL ratings which is to decide whether to initiate /continue the business with respective financial institutions.
OAE IMPLEMENTAION
Oracle application express 4.2 is used to build PFMA. Some of the OAE features used in this project are outlined below:
Creation of Conditional color formatting using html tags in OAE sql classic reports.
Implementation of customized jQuery for dynamic TABs as a plugin.
Creation of PL/SQL dynamic Region of customized reporting.
Creation of manual tabular forms and processes
Using report query to generate xml data in oracle apex.
Creation of modal screens which open up on parent screen and after processing the same, it refreshes the parent screen to reflect the changed records.
Implementation of APEX COLLECTIONS.
Implementation of session state protection for URL tampering.
Implementing APEX_SERT to the application to know the THREATS (LOW, MEDIUM, HIGH) SEVERITY.
Creating INTERATIVE REPORTS using Function returning query process.
Implementation of Validation functionality to validate some business criteria.
Implementing Computations to process certain business logic to APEX ITEMS.
Implementing GLOBAL PAGE in ORACLE APEX.
Creation of application items and application process.
Using List of values (static, dynamic) to populate select list and pop up select list.
Creation of before/after header process to process certain business logic.
Implementation of LDAP custom authentication.
Implementation of Apex authorization.
Sending out Emails using APEX_MAIL API.
Use of APEX_ITEM API.
Creation Of dynamic heading in the page using custom heading pl/sql functionality.
Integrating JavaScript/JQuery/AJAX to Oracle APEX.
Implementing Conditional branching using PL/SQL branching.
Modifying Themes and using user attributes to change the themes according to requirements.
Implementing Partial Refresh to each parameterized SQL CLASSIC report.
PL/SQL IMPLEMENTATION
Creation of packages,procedures,triggers,functions,tables,sequences,views,materialized views,SQL tuning,Bulk Collections.
SERVICE NOW
Creation of Wrapper scripts, Promotion steps to higher environment, creating cart using sql developer.
DOCUMENTATION
Creation of RUNBOOK,PLAYBOOK,USERGUIDE for BCMS
RDH(REFERENCE DATA HUB)
This development introduces a new tool based on the current Reference Data architecture that allows maintaining the Ally Critical Elements (ACE) using current Oracle Application Express (APEX). APEX utilizes a web browser for development, deployment and runtime, communicating with the Oracle Database using the web listener for page requests, rendering and processing.
The Maintenance pages will be developed using the Application Builder to develop the frontend and additionally an Oracle database to create objects as sequences, triggers, views, functions, packages, etc. The application will reside in the database tables as Meta data and leverage database utilities.
The RDH has 3 main purposes:
1.Provide an integrated solution for maintaining/approving/viewing valid reference data values and descriptions
2.Enable comparisons of like values between different source systems
3.Provide ability for downstream data owners/consumers to map source system values to their target data values
OAE IMPLEMENTAION
Creation Of Forms and Reports page
Creation/managing oracle apex workspace, schema assignments.
Creating and managing Developer user in oracle apex.
Implementing Modal pages.
Creation of application items and application process.
Using List of values (static, dynamic) to populate select list and pop up select list.
Creation of before/after header process to process certain business logic.
Implementation of LDAP custom authentication.
Implementation of Apex authorization.
Sending out Emails using APEX_MAIL API.
Use of APEX_ITEM API.
PL/SQL IMPLEMENTATION
Creation of packages,procedures,triggers,functions,tables,sequences,views,materialized views,SQL tuning,Bulk Collections.
SERVICE NOW
Creation of Wrapper scripts, Promotion steps to higher environment, creating cart using sql developer.
Creating change request and following up till the deployment is complete.
DOCUMENTATION
Creation of RUNBOOK,PLAYBOOK,USERGUIDE for RDH
41’st PARAMETER
The 41’st Parameter Interface consists of 2 webservices. One is an endpoint exposed to the BITS platform that collects transaction data sent to 41’st Parameter. The same data that is sent to 41’st Parameter is sent to the OAE endpoint and inserted into the BITS_MSG table in the parm41 schema.
A second webservice makes a call from the database through the BITS server to the 41’st parameter endpoint. Scored data from the transactions sent from BITS is returned and inserted into a table in the RET_41ST_PARM table in the parm_41 table. DataStage reads both of the tables above and inserts data into the MARS system.
A purge process (via Tidal/Ksh scripts) is scheduled to remove records older than 15 days in both OAE tables. Purge process is scheduled to run nightly.
OAE IMPLEMENTAION
Implementation ORACLE APEX WEB-SERVICE (SOAP)-XML Envelope to SAS reporting tool
Creation Of Forms and Reports page
Creation/managing oracle apex workspace, schema assignments.
Creating and managing Developer user in oracle apex.
Implementation of LDAP custom authentication.
Implementation of Apex authorization.
PL/SQL IMPLEMENTATION
Creation of packages,procedures,triggers,functions,tables,sequences,views,materialized views,SQL tuning,Bulk Collections.
SERVICE NOW
Creation of Wrapper scripts, Promotion steps to higher environment, creating cart using sql developer.
Creating change request and following up till the deployment is complete.
DOCUMENTATION
Creation of RUNBOOK,PLAYBOOK,USERGUIDE for RDH
*Apart from above applications 5 more OAE application also there which are developed and sustained by me.
1.Alert Triage
2.Return Payment
3.DQMT(Data Quality Management Tracker)
4.EALERT(Fraud Application)
5.TAX Assumption
Responsible for upgradation from OAE 4.2 to 5.0
T-SYSTEMS malaysia August 2011 – NOV 2012
Oracle APEX Developer
Project: Shell Petroleum
Description:
Shell Backup and Storage with Reporting
Shell’s backup and storage is done by many tools such as commvaily net vault, Networker and trivoli etc. Some of the tools have daily backup reports, monthly backup reports, weekly reports Using Perl Scripts.
We extract Data from backup tool and Put those data in oracle database, and Through APEX. We create the Reports according to the client’s requirement.
We basically Project the KPI %.
Responsibilities:
Developed The interface and designed the Database To Reporting
Developed A rotational Dashboard Which Is projected on the wall which is24*7.
Monitoring the backup Logs, as dashboard creates a lots of logs.
Tuning Of data By creating Materialized View Creating Indexes Table Portioning
Created ETL for loading of data from Input tables to report tables.
DatabaseDesignForproductiondatabaseusingsqldeveloperdatamodeler3.0
Developed Chain In oracle Enterprise Manager to run the jobs.
Implemented Upload CSV to table in apex interface by user defined procedure.(APEX 4.0.2)
Implemented Download the reports in color formats from Interactive reports to Excel and HTML.
Responsibilities include installation and administration of the oracle database utilities, providing 24*7 supports to the issues regarding production and development of data base.
Creating Database, Backup and Recovery procedures.
Performance Tuning, with portioning and indexing techniques.
Storage Management with oracle 10g(ASM)
Project
Perbadanan Tabung Pembangunan Kemahiran (GOVT Malaysia). June 2008 – May 2011
Apex Developer
Description:
The PTPK project is a GOVT Malaysia initiative with an overarching goal of improving the affiliates operational processes while upgrading the technologies currently used to support back office transactional systems. PTPK has selected and purchased Oracle software to replace current affiliate core systems. This project is based on the Oracle Apex and BI publisher.
Responsibilities:
Developing Loan Application system.
The Loan Application system as implemented by 546 college’s over Malaysia.
Integrating BI publisher with apex for reporting.
Installing and Configuring Linux and Oracle10g on 2 servers.
Implementing on Primary and Auxiliary Servers.
Implementing Data Guard (Standby Servers).
Managing database security. Design, develop, and implement automated data backup and restoration procedures. Provide technical support for database maintenance and disaster recovery.
Created new databases and users: setup backups, export and other monitoring scripts.
Taking Export dump daily for Backup purpose.
Responsibilities include installation and administration of the oracle database utilities, providing 24*7 supports to the issues regarding production and development of data base.
Creating Database, Backup and Recovery procedures.
Performance Tuning, with portioning and indexing techniques.
Pacific Insurance
Apex Developer
Description:
Insurance company which needs an apex system to Pay out commissions to agents, and manage resources.
Responsibilities:
The Application system as implemented by 546 college’s over Malaysia.
Integrating BI publisher with apex for reporting.
Installing and Configuring Linux and Oracle10g on 2 servers.
Implementing on Primary and Auxiliary Servers.
Implementing Data Guard (Standby Servers).
Managing database security. Design, develop, and implement automated data backup and restoration procedures. Provide technical support for database maintenance and disaster recovery.
Created new databases and users: setup backups, export and other monitoring scripts.
Taking Export dump daily for Backup purpose.
Responsibilities include installation and administration of the oracle database utilities, providing 24*7 supports to the issues regarding production and development of data base.
Creating Database, Backup and Recovery procedures.
Performance Tuning, with portioning and indexing techniques.
E-LIOSPHARMACEUTICALS Jul 2007 – mar 2008
Oracle Developer
Description:
Sistemi Informative provides IT solutions for pharmaceutical industry. Their flagship product pharmacy CRM Suite is an integrated solution for sales. ETMS part is being considered as a heart of which deals Administrative Section along with Basic set up creation like User Management Organization Chain Management, Customer and Working area management.
Responsibilities:
Created HR management System using Oracle Apex3.2.
Developed and designed the Application and Database from scratch
Gathered Requirements from business, convert it to technical document workflow.
Integrated BI Publisher to Report Automatically Each day.
Provided 24*7 Supports to Users.
Configuration installation and administration of the oracle database systems and tools,
Developed implemented and maintained the methodology and procedure standards for the effectiveness in the access, backups and recoveries.
Responsibilities include installation and administration of the oracle database utilities, providing 24*7 supports to the issues regarding production, development of database etc.
Modifying oracle apex repository themes and templates.
Implementation of LDAP /Custom authentication.
Contact this candidate