PROFESSIONAL SUMMARY:

• Expertise in Oracle: PL/SQL, SQL, Database Administration, Database Development and Design, BRM (Business revenue management) deployment, Data integrator, Oracle Data Warehouse Builder (OWB), OLAP, fusion middleware, BI publisher, Golden Gate, Data guard, Slack and RMAN.
• Created and supported ETL and BI functions to complete performance tuning for COTS SQL for improvements.
• Managed Extract, Transform, and Load (ETL) processing by using the Talend and Oracle (OWB) ETL tools to seamlessly integrate all data functionality.
• Created new ETL (OWB) and PL/SQL scripts to support the Oracle Data Warehouse.
• Coded using PL/SQL and Talend ETL to create and maintain stored procedures and triggers.
• Well versed in System operations on AWS (Amazon Web Services).
• Experienced with Talend and OWB ETL Tools, Gird control, RAC, GitHub, Git, SVN, Wiki, JIRA, Bit bucket, VMware, VMWare ESXI, Virtual Box, SQL/ Server Developer, and Data modeling.

TECHNICAL SKILLS:

• PL/SQL
• Oracle
• SQL Server
• MySQL
• MS - Access
• PostgreSQL
• DB2
• Sybase
• Oracle BI publisher 11g
• AWS (Amazon web services)
• SAS
• Joomla
• Html
• JavaScript
• VB
• VB.NET
• DOT.NET
• Oracle Golden Gate
• Oracle Data Guard
• Oracle Warehouse Builder
• Grid Control
• RAC
• Oracle IAS
• Oracle Forms
• Oracle Reports
• Oracle People Soft
• Oracle Business Intelligence
• MS-Internet Information Services (IIS)
• Win SCP
• Oracle SQL
• Oracle SQL Developer (Oracle
• SQL Server)
• Oracle data integrator
• Talend ETL (Extract transform and loading)
• Oracle SOAPUI
• Postman
• Oracle Slack
• Wiki
• JIRA
• GitHub
• Git
• SVN
• Bit bucket
• UNIX Commands & Shell Scripts
• VMware ESXI
• VMware
• Virtual Box
• MS office
• CVS
• MS Visual source safe
• Crystal report
• Power Designer
• ETL Tool
• Swis tool to convert databases
• Aqua data studio tool for databases
• TOAD tool for Databases
• EMS tool for databases (Oracle
• SQL Server)
• Bugzilla
• Linux/UNIX
• Sun Solaris
• Windows
• Borland JBuilder
• AdobeFlex Builder

PROFESSIONAL EXPERIENCE:

Confidential, Washington, DC

Oracle Developer (PL/SQL)/Sub version Management

Responsibilities:

• Created stored procedures, functions, triggers, and views
• Updated and modified existing stored procedures, functions, triggers, and views
• Created object types, packages, and package body
• Developed and tuned SQL and PL/SQL code
• Responsible for writing database DML (SQL) scripts
• Designed, built and developed ETL procedures
• Created Explicit Cursor, Ref Cursor, V-Arrays, Nest Tables, Collection Records, and Bulk Collections
• Debugged and Resolved Oracle SQL/PLSQL code issues
• Utilized Oracle SQL commands to retrieve data from table, view
• Built PL/SQL stored procedures, data modeling, dictionary and entity relationships
• Completed performance tuning of complex stored procedures, functions, triggers, and views
• Created logical and physical database design
• Created multiple scripts
• Participated in code reviews and ensured that code complied with company standards and policies

Confidential, Herndon, VA

Oracle Developer (PL/SQL)

Responsibilities:

• Responsible for debugging and resolving SQL/PLSQL code issues
• Managed PL/SQL stored procedures, data modeling, dictionary, entity relationships
• Supported Extract, Transform, and Load (ETL) processing
• Utilized ETL and BI to tune COTS SQL for performance improvements
• Created stored procedures, functions, and triggers
• Created Explicit Cursor, Ref Cursor, VArrays, Nest Tables, and Bulk Collections
• Documented, maintained and supported data standards for the Data Warehouse, including security, archiving, backup and recovery
• Performed database tasks to support project activities and assist in supporting and maintaining enterprise applications linked to production databases
• Supported all database environments including development, test, and production. Interface with test teams to support test strategies and plans
• Used Git to checkout, push, and pull projects source code

Oracle DBA / AWS

Responsibilities:

• Created database, schemas on Oracle server
• Created Oracle instances and manage users, roles and Oracle table spaces
• Managed Extract, Transform, and Load (ETL) processing by using the Talend tool
• Performed Database Backup and recovery using RMAN, Data Guard, logical backups, and Oracle Enterprise Manager
• Utilized AWR and ADDM for performance tuning databases
• Configured and managed the Oracle Golden Gate Environment including two servers (host and target)
• Established the Oracle BI Publisher to connect to Oracle database server
• Hosted applications with the AWS Cloud
• Configured AWS account and management tools
• Configured Command-Line tools on EC2
• Configured and Launched EC2 Instances
• Managed AWS Access with IAM
• Created Database link and transfer dump file from EC2 Oracle database instance to Oracle database on RDS

Confidential, Fairfax, VA

Oracle Developer (PL/SQL)

Responsibilities:

• Designed web sites (Installing and using Joomla tool and database My SQL on Linux)
• Created and supported PL/SQL stored procedures, data modeling, dictionary, entity relationships
• Maintained overall responsibility for global data definitions used in the Data Warehouse
• Documented, maintained and supported data standards for the Data Warehouse, including security, archiving, backup and recovery
• Assisted in the design, implementation, maintenance, and administration of databases with respect to performance, accessibility, availability, security, and configuration
• Provided technical support for company’s database management systems and related applications
• Experienced with Agile methodologies

Confidential

Oracle Developer (PL/SQL)

Responsibilities:

• Created Oracle Forms and Oracle Reports
• Responsible for Debugging and Resolving SQL/PLSQL code issues
• Created new ETL and PL/SQL scripts to support the data warehouse

Oracle Application Server (Oracle Forms, and Oracle Reports)

Responsibilities:

• Coded and wrote applications using Oracle PL/SQL, Oracle Forms, Oracle Reports
• Designed and enhanced applications ranging from minor enhancements, bug fixes, through to forms personalization and design and develop new reports to serve the business needs

Confidential

Oracle Developer (PL/SQL)

Responsibilities:

• Responsible for debugging and resolving SQL/PLSQL code issues
• Development and design of an Oracle Data Warehouse written in Oracle PL/SQL
• Enhanced existing Oracle DW application to integrate with new financial data sets
• Coded PL/SQL, ETL, using packages, stored procedures and triggers