SUMMARY

• 10+ years of experience as a Programmer Analyst and Database Administrator.
• Expertise in Oracle: PL/SQL, SQL, Database Administration, Database Development and Design, BRM (Business revenue management) deployment, Data integrator, Data Warehouse, OLAP, fusion middle ware, BI publisher, Golden Gate, Data guard, Slack and RMAN.
• Well versed in System operations on AWS (Amazon web services).
• Experience with Talend ETL (Extract, transform, and loading), Gird control, RAC, GitHub, Git, SVN, Wiki, JIRA, Bit bucket, VMware, VMWare ESXI, Virtual Box, MS Sql Server Developer, and Data modeling.

TECHNICAL SKILLS

Languages: SAS, Joomla, Html, JavaScript, VB, VB.NET, DOT.NET

RDBMS: Oracle, SQL Server, MySQL, MS - Access, PostgreSQL, DB2, Sybase

App Servers: Oracle BI publisher 11g, AWS (Amazon web services), Oracle Golden Gate, Oracle Data Guard, Oracle warehouse builder, Grid control, RAC, Oracle IAS, Oracle Forms, Oracle Reports, Oracle People Soft, Oracle Business Intelligence system, MS-Internet Information Services (IIS), Win SCP

Tools: Oracle SQL, Oracle SQL Developer (Oracle, SQL Server), Oracle data integrator, Talend ETL (Extract, transform, and loading), Oracle SOAPUI, Postman, Oracle Slack, WikiJIRA, GitHub, Git, SVN, Bit bucket, UNIX Commands & Shell Scripts, VMware ESXIVMware, 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 databasesTOAD tool for Databases, EMS tool for databases (Oracle, SQL Server), Bugzilla

Environment: s: Linux/UNIX, Sun Solaris, Windows, MS-DOS

IDEs: Borland JBuilder, AdobeFlex Builder

PROFESSIONAL EXPERIENCE

Confidential - Washington, DC

Oracle Developer (PL/SQL)

Responsibilities:

• Create new stored procedures, functions, triggers, and views
• Update and modify existing stored procedures, functions, triggers, and views
• Create object types, packages, and package body
• Create Explicit Cursor, Ref Cursor, V-Arrays, Nest Tables, Collection Records, and Bulk Collections
• Debug and Resolve Oracle SQL/PLSQL code issues
• Using Oracle SQL commands to retrieve data from table, view
• Using Oracle SQL commands to insert, update to table
• Working expertise in PL/SQL stored procedures, data modeling, dictionary, entity relationships
• Working expertise in Oracle SQL
• Tuning and Performing complex stored procedures, functions, triggers, and views
• Making the build with stored procedures on Production environment
• Perform basic database tasks to support project activities and assist in supporting and maintaining enterprise applications linked to production databases
• Establish, instruct, and manage policies and procedures related to database maintenance and administration
• Work closely with design teams, technical infrastructure teams, and testing teams
• Provide solutions to a variety of information system technical requirements of moderate scope and complexity
• Follow standard policies, procedures, and best practices in maintaining and supporting the databases
• Support all database environments including development, test, and production. Interface with test teams to support test strategies and plans
• Create logical and physical database design
• Database development and creation of upgrade scripts
• Design and development of ETL procedures
• Develop and tune SQL and PL/SQL code
• Design database packages and procedures
• Responsible for design and development of database objects
• Responsible for writing database DML (SQL) scripts
• Responsible for liaising with operations team and reporting on daily status and issue updates
• Responsible for developing, conducting and reporting Unit Testing
• Participate in code reviews and ensure the code written complies with the company standards and policies
• Participate in meetings and discussions with Functional/Technical Leads to understand the requirements and work out a design
• Follow SDLC (Software Development Life Cycle) best practices and procedures
• Participate in meetings with customer to identify and scope new requirements
• Write ad-hoc queries based on schema knowledge for various application requirements
• Deal with complex data models and object relational database mapping
• Check-in the source code, updated code into SVN
• Check-out the source code, updated code from SVN

Confidential, Herndon, VA

Responsibilities:

• Employing Amazon Web Services
• Achieving Agility With EC2
• Adapting EC2 to the business needs
• Monitor and Scaling
• Hosting applications with the AWS Cloud
• AWS Security features
• Configuring Accounts and management tools
• Configuring Command-Line tools on EC2
• Configuring and Launching EC2 Instances
• Creating and Attaching EBS volumes
• Leveraging Amazon S3
• Decoupling Systems with SQS
• Configuring a Cloud Watch Alarm
• Auto Scaling and Load Balancing
• Managing AWS Access with IAM
• Creating a VPC
• Providing a relational database as a service
• Launching a RDS instance
• Customizing EC2 images
• Controlling Access to S3 Bucket
• Creating an AMI From an S3-backed Windows Instance
• Creating a Linux EBS AMI from an S3-Backed Instance
• Importing and Exporting Images
• Uploading an Existing Virtual Machines from VMware, Virtual Box into AWS
• Downloading Images From AWS and loading into VMware, Virtual Box
• Creating Database link and transfer dump file from EC2 Oracle database instance to Oracle database on RDS
• Creating Database link and transfer dump file from Oracle database on RDS to EC2 Oracle database instance
• Using shell script commands to write script file for exporting/importing dump file on RDS
• Configuring a Load Balancer
• Administering the Application Environment
• Creating Cloud Formation Template
• Installing VMware ESXI to manage Linux servers
• Installing Linux servers (BRM production, Oracle database server and client)
• Installing Oracle database server and client
• Installing BRM components
• Installing and configuring Pipeline
• Testing Pipeline Manager without a Database connection
• Testing Pipeline Manager with a Database connection
• Installing BRM clients (Pricing center, Customer center, and Developer center)
• Installing Pricing Design center
• Checking for starting and stopping BRM components
• Running test nap to test CM connection
• Deploying BRM among BRM servers
• Installing Oracle server and client on Linux server
• Creating database, schemas on Oracle server
• Granting permissions to users
• Revoking permissions from users
• Creating an Oracle instance and managing users, roles and Oracle table spaces
• Unloading and loading data using Oracle SQL statements and the SQL LOADER utility and external tables
• Extract, transform, and load (ETL) processing by using Talend tool
• Classical data Export utility and Import utility, new data pump export and import utilities
• Setting up of an audit trail and basic tuning are also covered
• Database Backup and recovery using RMAN, logical backups, and Oracle Enterprise Manager
• Database Backup and recovery using Oracle Data guard
• Using AWR and ADDM for performing and tuning databases
• Using OEM for performing and tuning databases
• Using TKProf for tuning COT SQL
• Database cold and hot backup recovery strategy
• Using the commands ExpDP and ImpDP to export and import Pump Files
• Improving queries with SQL Tuning tools (SQL Tuning Advisor, SQL Access Advisor)
• Creating data modeling with Power Designer, Erwin, and MS Visio tools
• Backing up and Restoring whole database
• Installing Linux servers (source server, target server)
• Installing and Configuring the Oracle software on source server and target server
• Configuring and Managing the Oracle Golden Gate Environment of two servers (host and target)
• Verifying that both database servers can talk to each other
• Configuring and starting Extract, Data Pump, and Replicate processes
• Generating sample data and test the validity of the replication
• Managing the reports produced by the processes
• Installing BRM report components on Linux Server
• Establishing Oracle BI Publisher connection to connect to Oracle database server
• Designing the new BRM reports on BI Publisher
• Planning to Schedule reports
• Export reports to excel file
• Installing Web logic services on Linux server
• Starting/Stopping Web logic service to start/stop BI Publisher
• Web logic services management (creating new users, grant permissions to users, ...)
• Creating store procedures, functions, and triggers
• Creating object types, packages, and package body
• Creating Explicit Cursor, Ref Cursor, V Arrays, Nest Tables, and Bulk Collections
• Responsible for Debugging and Resolving SQL/PLSQL code issues
• Working expertise in PL/SQL stored procedures, data modeling, dictionary, entity relationships
• Maintain overall responsibility for global data definitions used in the Data Warehouse
• Integrate data from multiple source systems into Data Warehouse
• Document, maintain and enforce data standards for the Data Warehouse, including security, archiving, backup and recovery
• Assist in the design, implementation, maintenance, and administration of databases with respect to performance, accessibility, availability, security, and configuration
• Perform basic database tasks to support project activities and assist in supporting and maintaining enterprise applications linked to production databases
• Establish, instruct, and manage policies and procedures related to database maintenance and administration
• Work closely with design teams, technical infrastructure teams, and testing teams
• Provide solutions to a variety of information system technical requirements of moderate scope and complexity
• Provide technical support for company’s database management systems and related applications
• Follow standard policies, procedures, and best practices in maintaining and supporting the databases
• Support all database environments including development, test, and production. Interface with test teams to support test strategies and plans
• Extract, transform, and load (ETL) processing
• Using ETL and BI to tune COTS SQL for performance improvements

Confidential, Fairfax, VA

Oracle Programmer Analyst / Oracle Developer (PL/SQL)

Responsibilities:

• Creating store procedures, functions, and triggers
• Creating object types, packages, and package body
• Creating Explicit Cursor, V Arrays, Nest Tables, Collection Records, and Bulk Collections
• Responsible for Debugging and Resolving SQL/PLSQL code issues
• Working expertise in PL/SQL stored procedures, data modeling, dictionary, entity relationships
• Maintain overall responsibility for global data definitions used in the Data Warehouse
• Integrate data from multiple source systems into Data Warehouse
• Document, maintain and enforce data standards for the Data Warehouse, including security, archiving, backup and recovery
• Assist in the design, implementation, maintenance, and administration of databases with respect to performance, accessibility, availability, security, and configuration
• Perform basic database tasks to support project activities and assist in supporting and maintaining enterprise applications linked to production databases
• Establish, instruct, and manage policies and procedures related to database maintenance and administration
• Work closely with design teams, technical infrastructure teams, and testing teams
• Provide solutions to a variety of information system technical requirements of moderate scope and complexity
• Provide technical support for company’s database management systems and related applications
• Follow standard policies, procedures, and best practices in maintaining and supporting the databases
• Support all database environments including development, test, and production. Interface with test teams to support test strategies and plans
• Extract, transform, and load (ETL) processing using Talend tool
• Experience with agile methodologies
• Installing Linux servers
• Install Oracle and MySQL on Linux servers
• Designing and modifying database schemas
• Querying, updating, and tuning databases
• Design, creation, and enhancement of stored procedures, triggers
• Backup, restore database
• Using shell script commands to write script file for importing, and exporting dump file
• Develop, maintain, enhance, and execute database extraction, database loading, and data purging activities

Confidential

Oracle Programmer Analyst

Responsibilities:

• Creating store procedures, functions, and triggers
• Creating object types, packages, and package body
• Creating Explicit Cursor, V Arrays, Nest Tables, Collection Records, and Bulk Collections
• Creating Oracle Forms and Oracle Reports
• Experience with agile methodologies
• Responsible for Debugging and Resolving SQL/PLSQL code issues
• Working expertise in PL/SQL stored procedures, data modeling, dictionary, entity relationships
• Maintain overall responsibility for global data definitions used in the Data Warehouse
• Integrate data from multiple source systems into Data Warehouse
• Document, maintain and enforce data standards for the Data Warehouse, including security, archiving, backup and recovery
• Work as part of the Engineering team to design and develop Oracle technical solutions
• Create and maintain complex PL/SQL programs, packages, functions, procedures, and triggers
• Create new ETL and PL/SQL scripts to support the data warehouse
• Work with Project Management and Business Analysis to analyze requirements for data and reports and enhancements to existing reports, and to plan the integration of technical solutions with other (or outside) business applications, systems, and data warehouses
• Write implementation and unit test plans for new application releases
• Working in Oracle PL/SQL, Oracle Forms, Oracle Reports
• Design and development of changes using Oracle Forms and PL/SQL, ranging from minor enhancements, bug fixes, through to Forms personalization and design and develop new reports to serve the business needs
• Writes and assembles system level design specifications
• Programs, tests and documents new and/or existing applications
• Makes changes to existing applications based on customer requirements
• Developing stored procedures, functions and packages to meet business requirements
• Developing system level program specifications and test plans

Confidential

Oracle Developer

Responsibilities:

• Creating store procedures, functions, and triggers
• Creating object types, packages, and package body
• Creating Explicit Cursor, V Arrays, Nest Tables, Collection Records, and Bulk Collections
• Responsible for Debugging and Resolving SQL/PLSQL code issues
• Working expertise in PL/SQL stored procedures, data modeling, dictionary, entity relationships
• Experience with agile methodologies
• Development and Design of an Oracle Data Warehouse written in Oracle PL/SQL
• Enhance our existing Oracle DW application to integrate with new financial data sets
• Programming PL/SQL, ETL, using packages, stored procedures and triggers
• Installing Linux server
• Installing SQL Server on Linux server
• Creating database on Linux server
• Creating store procedures, functions, and triggers
• Responsible for Debugging and Resolving SQL/PLSQL code issues
• Backup & Restore database