Application Developer (pl/sql Developer) Resume
4.00/5 (Submit Your Rating)
Atlanta, GA
SUMMARY:
- 5+ years Oracle Database Experience
- 5+ years Oracle PL/SQL Programming Experience
- 5+ years Oracle BI Publisher Experience
- 2 - 3 years Web Interface Development (Using APEX and Oracle web toolkit)
- 3+ years HTML, JavaScript, CSS
- 2-3 years Full Project Life Cycle implementing Web Based Systems
- 5+ years Oracle SQL Developer
- 1+ years Informatica /ETL development
- 5+ years Oracle APEX Web Development
- Design, code, and implement systems software using Oracle software development tools such as APEX, SQL Developer, BI Publisher, Oracle Database 10g/11g, Oracle Form
- Intensive programming using PL/SQL
- Windows application development using VB.NET and Microsoft SQL 2000
- Website development using Joomla and Drupal
- Installing Oracle Database 11g with APEX, Configure RMAN, backup, restore, manage performance and troubleshooting during failure
- Oracle DB 10g/11g, Forms and Reports 10g, SQL, PL/SQL, Oracle BI publisher, Oracle Application Express (APEX), SQL developer, TOAD, MySQL, OOP, HTML, JDeveloper, PHP, C/C++, VB.NET, Microsoft SQL 2000, Dreamweaver, Joomla, Drupal, Apache Web Server, Windows OS
- Computer maintenance
- Networking and security Knowledge
- Good Analytical skill and flexible to understand new technologies and findings
- Eager to understand unfamiliar theories and concepts
- Capable of applying technical knowledge to user requirements.
- Additional Knowledge on MS-SQL, MySQL and MS-Access database systems
PROFESSIONAL EXPERIENCE:
Confidential, Atlanta, GA
Application Developer (PL/SQL Developer)
Responsibilities:- Write PL/SQL program using Oracle Web toolkit, HTP, HTF and OWA packages
- Creating PL/SQL package, function, stored procedure, triggers, and cursors
- Designing and Developing both Front-End and Back-End of Web Applications using PL/SQL procedures and packages, HTML, JavaScript, CSS and XML.
- Use Quest Software SQL Navigator tool
- Experience with full project life cycle in implementing web based systems
Confidential,Atlanta,GA
Oracle BI Report Developer
Responsibilities:- Write SQL to extract data from Oracle Database using Oracle SQL Developer
- Design reports Using Oracle BI-Publisher
- Create Dashboards using OBIEE and design backend using RPD
- Create report using the designed rtf format and Extracted data
- Use Informatica / ETL tool to extract data from transactional database and load into data warehouse database
- Extract data from Oracle transactional Database using Informatica.
- Extensively used ETL to load data into oracle data warehouse.
- Designed and developed complex aggregate, join, look up transformation rules (business rules) to generate OBIEE (fact/summary) data using Informatica ETL tool.
- Worked with SQL, PL/SQL procedures and functions within the mappings.
- Performed Unit testing and maintained test logs for all the mappings.
- Write PL/SQL Procedure for Batch team
Confidential
Application Developer
Responsibilities:- Installation of Oracle database 11g with APEX development environment
- Migrated Converge Database from Oracle 8i to Oracle 11g
- Configured RMAN, manage its performance and check the validity of backed up files
- Wrote backend program to take schema dump files from each database and RMAN backup files
- Wrote PL/SQL function and trigger for converge database to create communication with CNET ERP System using XML files
- Installed Oracle Database 11g and Configure converge application for 3 different companies, provide training for users, Configure backup systems, develop different kind of reports with Oracle BI Publisher according to their need and provide continues support
- Developed different kinds of report using Oracle BI Publisher
- Developed applications using Oracle database 11g and Oracle Application Express APEX (Oracle product used to develop web based applications)
- Worked on HTML, JavaScript and CSS in relation to APEX
- Load data using Informatica
- Develop the following application using Oracle APEX 4.2:
- Construction Quantity Management System for ABE consultancy company
- Timesheet Management for Confidential and Boston Medical
- Lead Management System for Boston Medical Marketing Team
- Issued management System for Boston Medical Service team
- Performance Management System & report using Oracle BI Publisher for Pioneer Diagnostic center
- Examined information and Registration System for Our Exam Center
Junior Application Developer
Responsibilities:- Installation of Oracle database 8i
- Configuration of Converge POS system with Oracle 8i
- Provide support on Converge Application for our sister companies and finance department
- Wrote PL/SQL on Oracle 8i using TOAD in order to interact with physical printer
- Installation and technical support for our exam center Pearson VUE with Pearson VUE technical team in UK ( Confidential is local partner for Pearson VUE)
- Advised, trained and assisted users on how to best utilize our systems
- Took regular backup of Converge Application
- Installed Server based Peachtree on windows server 2000, install client Peachtree for each finance team and wrote program to take Peachtree backup from server automatically
- Lab assistance for Oracle Database and Developer trainings ( Confidential is Oracle Approved Education Provider in Ethiopia)
Confidential
Ethiopia Content Manager
Responsibilities:- Updated content on betolo.com (commercial / Advertisement website)
- Updated content on realethiopia.com (tourist information website)
- Developed dynamic websites using Joomla and Drupal (PHP, MySQL and Apache based content management system)
- Provided IT support with simple network administration in Microsoft Windows environment