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.