We provide IT Staff Augmentation Services!

Database Developer /oracle Developer- Data Integration Developer Resume

Fairfax, VA

SUMMARY:

  • IT Professional with 14+ years of experience on diverse Federal projects in the roles of Oracle database & application development, Data Integration (ETL), Oracle Database Administration (DBA), Oracle E - Business Administration (Apps-DBA), Oracle Data Warehousing & Reporting, is available immediately seeking new projects and challenges.
  • SQL, PL/SQL development work in Stored Procedures, Functions, Packages & Triggers.
  • User Interface Development in Oracle Forms (4.5 to 10g) & JDeveloper - J2EE/Java.
  • Vast Reports Development > Oracle Reports (6i to 10g), Oracle Discoverer, Jasper/ iReports Reports, SQL Queries, SQL*PLUS Reports, Views, Mat.Views, Excel reporting; Working knowledge of Crystal Reports. Mentored & trained developers in Oracle Reports & Jasper/iReports.
  • Other Oracle tools used: SQL TOAD, SQL NAVIGATOR, SQL*PLUS, SQL Developer.
  • UNIX shell commands and scripting. MS Excel advanced experience.
  • Full SDLC using Agile (Requirements Gathering/Design/Dev/Testing/Release)
  • Performed data profiling, analysis, cleansing, standardization & transformations.
  • Informatica PowerCenter 8.6-9.5-9.5.1 Data Integration - Developed mappings & workflows.
  • Performed ETL using SQL, PL/SQL and Analytical Functions for Data-warehouse & year-end reporting.
  • Performed Data Loads using SQL*Loader; Export/Import using Data Pump
  • Utilized OEM Grid Control to monitor and manage Oracle and Unix targets
  • Managed Physical & Logical DB Objects; Monitored Alert Logs/trace files.
  • Performed RMAN Database Backup & Recovery
  • Maintained/Upgraded/Installed Oracle RDBMS
  • Applied Oracle Interim/ CPU patches
  • Data Management: Data imports/exports using SQL*Loader/ Data Pump.
  • Unix/Linux server monitoring, scripting and space management.
  • Deployed Oracle 11i E-Business Applications Builds/ Releases & Repair Operations.
  • Oracle Applications 11i backup & cloning.
  • Monitored/Configured/Bounced Oracle 11i mid-tier servers/services.
  • Monitored/Configured/Bounced OBIEE Servers; Modified/Deployed OBIEE (RPD) Reports
  • Load Balanced (F5) Oracle Application Servers

PROFESSIONAL EXPERIENCE:

Database Developer /Oracle Developer - Data Integration Developer

Confidential, Fairfax, VA

Responsibilities:

  • FEMA PRISM Data Migration Project
  • Performed ETL (Extract-Transform-Load) from AAMS to PRISM databases.
  • Performed Data Migration/ Extraction/ Exports/ Imports between SQL Server and Oracle 11g
  • Performed Data analysis and clean-up/standardization for data migration.
  • Created Oracle objects (Tables Views Indexes Procedure Functions Packages) using SQL & PL/SQL.
  • Created SQL Server objects using SQL & T-SQL.
  • Created PowerShell scripts to migrate operating system files between servers.
  • Performed error checks and validation during and after migration.
  • Created documentation and test scripts.
  • Engaged and interacted with client for requirements, reviews and acceptance.

Database Developer /Oracle / ETL / Data Integration Consultant

Confidential

Responsibilities:

  • Created, modified and maintained Oracle database objects as Tables, Views, Indexes & Triggers.
  • Utilized SQL and Analytical Functions for data analysis.
  • Performed data migration using Oracle utilities such as SQL Loader & Data Pump.
  • Created PL/SQL Functions, Procedures & Packages. Utilized PL/SQL collections.
  • Utilized Informatica PowerCenter prod stack for data migration & ETL development effort.
  • Developed PowerCenter 9.5-9.5.1 (ETL) Mappings and Workflows. Implemented best practices.
  • Performed Data Profiling & Analysis, then Data Cleansing & Standardization.
  • Trouble shoot performance bottlenecks - analyzed mappings, transformations, workflows & sessions.
  • Managed version control, exports/imports and migration of workflows with Repository Manager.
  • Proficient usage of all PowerCenter tools: Designer, Workflow Manager/Monitor, Repository Manager.
  • Formally trained and upgraded skills in PowerCenter Development & Administration.
  • Able to use PowerCenter Admin console to configure and monitor multimode PowerCenter domain.
  • Able to manage domain security - Created and managed domain users.
  • Able to maintain and back up Oracle repository.
  • Able to create and manage PC domain services (Repository service, Integration service, Reporting service).
  • Able to install Server/Client upgrades/ hotfix patches/ new installation.

Oracle Database Developer

Confidential

Responsibilities:

  • Worked on mission critical Defense Logistics Agency contract with 23 environments.
  • Helped maintain 11i/R12 Oracle with RAC (non E-Business func role) on Unix platform.
  • Utilized SQL and PL/SQL to create and maintain both logical and physical Oracle objects.
  • Performed database Patch Analysis and applied Oracle quarterly CPU/PSU security patches.
  • Code promotion between environments - Applied monthly code releases.
  • Performed platform health checks.
  • Help create and manage database RMAN backup scripts & cron job schedule.
  • User Accounts - Managed and rectified Oracle Applications and Database accounts, profiles, resources & locks.
  • Monitoring - Used Oracle Grid (EM) to monitor all targets for errors, warnings and alerts.

Database Developer /Oracle DBA

Confidential, Reston, VA

Responsibilities:

  • Maintained/implemented/deployed RAIL Oracle Applications in Test and Production instances.
  • Managed Oracle 11i E-Business Applications.
  • Applied Oracle Applications and Database CPU patches.
  • Monitored/Configured/Bounced Oracle 11i mid tier servers/services.
  • Implemented 11i (EBS) Applications Test & Production builds
  • Managed, scheduled & monitored 11i Concurrent Manager jobs
  • Participated in cloning of 11i Applications & Oracle Database systems
  • Utilized AD (11i) and OPMN (j2ee) mid-tier utilities
  • Monitored/managed Oracle Standby databases for 11i Applications.
  • Created and maintained Oracle logical and physical objects.
  • Monitored alert logs & trace files daily for failures and errors.
  • Performed and monitored RMAN backups.
  • Used Oracle Grid Control (Ent Mgr) to monitor databases and Unix/windows hosts; Created Grid email Alerts.
  • Installed Oracle Grid Control (EM) agents.
  • Administered OBIEE repository; Monitored/Configured/Bounced OBIEE Servers.
  • Utilized Load Balancer (F5) to enable/disable mid-tier servers (10gAS, OBIEE) for rolling bounces.
  • Managed and served as On-Call DBA & Pager DBA on Production, ITE &Pre-ITE (Test & Pre-Test)
  • Managed database user accounts (profiles, resources, locks, etc)
  • Scheduled, automated and coded database & OS jobs on Unix & Windows Servers.
  • Unix Shell scripting and Windows batch programming.
  • Managed/monitored file system space/tablespaces on database hosts

Oracle DBA

Confidential, Arlington, VA

Responsibilities:

  • Installed & Maintained Oracle 10g database for R9DAP application in test and production.
  • Performed and monitored RMAN backups.
  • Monitored alert log/trace files for issues and errors.
  • Performed database & mid-tier bounces as required.
  • Scheduled database jobs.
  • Performance tuned database object including Queries, Stored Procedures & Functions.
  • Created AWR and ADDM reports to review performance issues.
  • Managed/monitored file system space on database hosts.
  • Applied Oracle security CPU patches.
  • Modified and maintained Entity relationships (E-R diagrams).
  • Designed and Developed Data Warehouse data models for staging and star schemas.
  • Participated fully in the product development process from requirements definition to application deployment.
  • Managed routine database management tasks in dev, test & production environments.
  • Worked closely with System Administrators to ensure OS resources & database security.

Oracle Developer/ ETL Developer

Confidential, Rosslyn, VA

Responsibilities:

  • Created and maintained Oracle database objects like Tables, Indexes, Database Jobs, & Materialized Views.
  • Performance Tuning - Revised/tuned slow SQL queries and PL/SQL code for improved performance.
  • Generated & analyzed AWR reports for tuning purposes.
  • Managed database user accounts (profiles, resources, locks, etc). Processed day-to-day database change requests.
  • Developed PowerCenter 8.6 mappings & workflows for data loading/migration.
  • Performed data loading from Oracle/DB2/Excel/Access to Oracle using Informatica SQL*Loader & PowerCenter,
  • Performed data exports from production databases and imports to data-warehouse, test and dev databases.
  • Scheduled and maintained database jobs
  • Participated in database design and development from data modeling through Oracle tuning.
  • Created and maintained multiple database schemas.
  • Created and maintained documentation on database standards and performance improvements.
  • Created and managed SQL scripts/queries, triggers, stored procedures, functions and packages.
  • Assist with routine database management tasks in test & environment.

Senior Oracle Systems Analyst

Confidential, Washington DC

Responsibilities:

  • Data Migration - National data extraction & modifications (PL/SQL ETL) of large data sets from a distributed system of 130 Oracle databases to a centralized repository; Data migrating/loading from large & small sources using SQL*Loader and PL/SQL.
  • Oracle Discoverer - Developed, Troubleshoot & modify Discoverer reports for the nationwide Data Warehouse application; Develop yearly summary Oracle reports for departmental upward reporting in Constructed Features, Range, FHWA, Wilderness, etc, used in budget approval by US Congress.
  • Performance tuned up views; analyzed and tuned slow queries.
  • Implemented OLE2 in Oracle Reports for Excel porting and macro application.
  • Modified/maintained user interfaces using JDeveloper/J2EE.
  • Developed complex reports and enabled reports output in varied formats like text, Excel, html & pdf.
  • Performed Data Analysis across different source databases.

Oracle Technical Consultant

Confidential, Washington DC

Responsibilities:

  • Developed & Maintained Oracle Client/Server Application; Upgraded/migrated Oracle modules (Forms, Reports, Libraries) to Oracle 6i, Revised SQL queries/views, for Infra application to maintain the departments inventory on a distributed system spread throughout the US and used by up to 12,000 Federal, private & contracted personnel.
  • Migrated/Converted about 260 Oracle 2.5 Reports to 6i Oracle Reports.
  • Upgraded Oracle 7.3 PL/SQL code for Oracle 8i, 9i compatibility.
  • Complete Reporting Task of all reports needs (canned/ad-hoc); Maintained/troubleshoot over 350 reports; Implemented Reports template and Driver reports.
  • Enable running huge SQL*Plus formatted/scripted reports on middle tier UNIX server.

Oracle Developer

Confidential

Responsibilities:

  • Created many reports in Oracle Reports & SQL*PLUS.
  • Involved in the design, development, implementation and maintenance (SDLC) of Odyssey Reservation System (FORMS 4.5 & Report 2.5) for National Car Rental Agency.
  • Used software tools such as Oracle DEVELOPER 2000 (Forms & Reports), PL/SQL, SQL*Plus, Oracle RDBMS 7.3/8 and UNIX.
  • Interacted with user community in obtaining user requirements; facilitated testing team and user group interaction; maintained database objects and implemented change requests.

Software Developer

Confidential

Responsibilities:

  • Developed and Troubleshoot Student Registration System Modules in Oracle Forms and Reports (4.5/2.5) on Oracle 7.3 and WIN NT platform.
  • Created Oracle Tables/Views, Procedures, Functions and Triggers.
  • Good knowledge of Data Modeling and E-R design.
  • Created reports in Oracle Reports and SQL*PLUS.

Information Systems & Technology Support Tech

Confidential

Responsibilities:

  • Created MS ACCESS Forms and Reports
  • Created and modified database objects like SQL, Views, and Tables.
  • Worked on structure/ loading/ migration of Documents on INFOWORKS (Bechtel’s Document Management System-a version of DOCUMENTUM).
  • Utilized HTML, Hotdog Pro, L View Pro, Paint Shop Pro, Digital Camera, Internet Explorer and Netscape Navigator to create/modify/maintain WEB pages.

Hire Now