We provide IT Staff Augmentation Services!

Senior Oracle Programmer Resume

Alpharetta, GeorgiA

PROFILE SUMMARY:

  • Over 11 years of Experience in Oracle SQL, PL/SQL, UNIX, Linux, Shell Scripting, Java, C, C++, Pro* C, IBM MQ, data warehouse tools, web services, Business Objects, Oracle 11g, Oracle 12c, Oracle Exadata, XML
  • Over 7 years of Experience in Vertex O Series Tax calculating and experience in configuring tax rules, exemption s and Confidential
  • Expertise in supporting Contract, Pricing, Billing and Revenue Oriented applications like Confidential and CARS/IS
  • Daily Participation in Scrum meetings to provide status on development effort. Experienced in GIT and Jira to code and build Oracle PL/SQL and SQL enhancements and user requirement stories.
  • Experienced in cross technologies like Java, Perl and Python during migration of existing application from on - premise to AWS.
  • Extensive experience with Oracle SQL and relational databases, including writing complex SQL and PL/SQL packages and procedures
  • Experienced in Jenkins build deployment tool and created new jobs for new projects
  • Knowledge of AWS Cloud services and working experience in EC2, S3 bucket, Lambda functions, AWS SCT, Aurora Postgres
  • Experienced in developing Aurora PostgreSQL applications for Telecommunications System and foreign data wrappers, bulk loading EDW files using copy, search path, performance tuning complex alarm queries, postgres functions, triggers, partition tables creation using trigger functions
  • Experience in migrating Oracle 12c database to PostgreSQL database using AWS SCT
  • Developed Java tool to copy data from on premise Oracle DB to AWS cloud DB for migration.
  • Experience in Liquibase Build Deployment tool for Oracle and PostgreSQL databases for tracking and deploying changes into all environments
  • Experienced in Migrating Oracle OLTP database tables into PostgreSQL database using Java and Hibernate for PostgreSQL conversion
  • Experience in analyzing EDW data load Perl modules for Oracle Database and performed changes for Oracle to PostgreSQL conversion
  • Experienced in Onestash source code version management tool for checking-in the changes and peer reviewing other developer change
  • Experienced in Writing new EDW data offload scripts from Teradata database using Teradata Fast Export and Perl
  • Expertise in all phases of Software Development Life Cycle (SDLC) and software engineering methodologies such as Requirement Gathering, Development, Normalization, Data analysis,
  • Performance tuning, Integration, Bug-fixing, Coding, Unit Testing, Production support and Maintenance of application
  • Completed Confidential System Upgrade project ensuring smooth migration from present system to new system
  • Experienced in Vertex Tax software and completed upgrade from Vertex 4.1 to 6.0
  • Experienced in developing UNIX and Linux shell scripts to automate the manual processes.
  • Experienced in Planning, co-ordination and execution of Data Center migration project.
  • Experienced on Incident, Change, Outage, and Problem Managements areas
  • Experienced in translating business requirements into creation of database objects: Tables, Indexes, Constraints, Packages, Stored procedures, Functions, Collections, Records, CLOB, Bulk Collect Dynamic SQL and Triggers, Oracle Types, Oracle Cursor Management, Exception Handling, Oracle Packages, External Table, XML Processing using XSLT configuration, Oracle DB Links, Scheduling and Creating New jobs Database jobs using DBMS SCHEDULER, Change Data Capture and Materialized views using SQL and Oracle PL/SQL.
  • Strong Programming and Debugging, Tracing skills in SQL & PL/SQL
  • Experienced in migrating data between OLTP and OLAP systems. Extensively worked on OLTP systems for extracting and loading data.
  • Expertise in advanced PL/SQL functionalities such as Collections, System variables, Ref Cursors, bulk processing, analytical functions, performance tuning, interfacing with external applications, use of advanced build in packages, external tables, temporary tables and table partitions.

TECHNICAL SKILLS:

Operating Systems: Windows XP, Windows 7, UNIX, Linux, Windows Server 2012, Solaris, Linux, UNIX

Databases & Tools: SQL, PL/SQL, Oracle 9i, SQL Developer, TOAD, SQL Navigator, Power Builder, PVCS, Serena Version Control, Tomcat, Oracle 11g, Oracle 12c, DataStage, Teradata, Oracle Exadata, Jira, GIT, Tortoise GIT, AWS Aurora Postgres 9.6.3, 10.4, Jenkins, Liquibase 3.5.5, Psql, AWS SQS, SNS

Languages: SQL, PL/SQL, Shell Scripting, C, C++, Java, IBM Message Queues, XML, Perl, Python

Other Tools: Control-M, Vertex O series 4.1 & 6.0, Service now, UC4 Scheduling Client

Domain: Finance and Billing, Pharma, Telecommunications

RESPONSIBILITIES and PROJECT DESCRIPTION:

Confidential, Alpharetta, Georgia

Senior Oracle Programmer

Responsibilities:

  • Developed Advance PL/SQL packages, procedures, triggers, functions, Indexes and Collections to implement business logic using SQL Navigator.
  • Experienced in Tortoise GIT and Jira to check in code and make the code ready for Build.
  • Worked on Scheduling and Creating New jobs Database jobs using DBMS SCHEDULER, XML Processing using XSLT configuration
  • Experienced in Jenkins build deployment tool and created new jobs for new projects
  • Good knowledge of AWS Cloud services like EC2, S3 bucket, Lambda functions, AWS SCT
  • Experienced in developing PostgreSQL applications for Telecommunications Project and experienced in developing foreign data wrappers, bulk loading EDW files using copy, search path, performance tuning complex alarm queries, postgres functions
  • Experience in migrating Oracle 12c database to PostgreSQL database using AWS SCT
  • Experience in Liquibase Build Deployment tool for Oracle and PostgreSQL databases for tracking and deploying changes into all environments
  • Experienced in Migrating Oracle OLTP database tables into PostgreSQL database using Java and Hibernate for PostgreSQL conversion
  • Experience in analyzing EDW data load Perl modules for Oracle Database and performed changes for PostgreSQL conversion
  • Experienced in Onestash source code version management tool for checking-in the changes and peer reviewing other developer change
  • Experienced in Writing new EDW data offload scripts from Teradata database using Teradata Fast Export and Perl
  • Developed Custom Java tool to ease the DB records copy of millions of records during migration from Oracle to Postgres which helped in production go live
  • Developed utility in Java to read messages from MQ and send to AWS SNS for OEP cloud migration project.
  • Developed Java tool to automate Oracle DB Tables objects creation into xml files for Liquibase deployment of Oracle to Postgres migration

Technology Stack Used: Oracle 12c, Solaris Linux, Oracle SQL and PL/SQL, AWS Aurora PostgreSQL 9.6.3,10.4, PL/pgSQL, Perl, Jenkins, Liquibase, Onestash, GIT, Psql, Teradata Fast Export, AWS EC2, SQS, SNS

Confidential, Dublin, Ohio

Lead Developer

Responsibilities:

  • Support CARS/IS application and assist users in daily issues related to CARS/IS entry for Contracts, Invoices and pricing.
  • Monitor Mid-month, Month end accrual pricing jobs to ensure all contracts are priced without any issues and keep users updated on same.
  • Coordinated with the front-end design team to provide them with the necessary stored procedures and packages and the necessary insight into the data.
  • Worked on SQL*Loader to load data from flat files obtained from various facilities every day. Used standard packages like UTL FILE, DMBS SQL, and PL/SQL Collections and used BULK Binding involved in writing database procedures, functions and packages for Front End Module.
  • Wrote Unix Shell Scripts to process the files on daily basis like renaming the file, extracting date from the file, unzipping the file and remove the junk characters from the file before loading them into the base tables.
  • Involved in the continuous enhancements and fixing of production problems.
  • Generated server-side PL/SQL scripts for data manipulation and validation and materialized views for remote instances.
  • Developed PL/SQL triggers and master tables for automatic creation of primary keys.
  • Developed Advance PL/SQL packages, procedures, triggers, functions, Indexes and Collections to implement business logic using SQL Navigator. Generated server-side PL/SQL scripts for data manipulation and validation and materialized views for remote instances.
  • Used joins, indexes effectively in where clauses for Query optimization.
  • Resolved Query Level Performance tuning using Explain Plan, SQL Trace
  • Developed ETL framework for processing and monitoring import of flat files into oracle database
  • Debugged existing ETL processes and did performance tuning to fix bugs.
  • Developed ETL code for Incremental/delta loads.

Technology Stack Used: Oracle Exadata, Linux, Window 2012 Server, Power Builder, Teradata, Oracle 11g, Oracle 12c, ASP.Net, Oracle SQL and PL/SQL, Service now, ETL

Confidential, Parsippany, New Jersey

Lead Developer

Responsibilities:

  • Responsible for performing disaster recovery testing yearly once to make sure DR environment functionality is working as expected
  • Assist business users in any issues in application and provide solutions to the issues related to invoices, contracts and revenue recognition
  • Provide support during User Acceptance Testing to Business users and work with offshore to resolve any issues rose
  • Worked on SQL*Loader to load data from flat files obtained from various facilities every day. Used standard packages like UTL FILE, DMBS SQL, and PL/SQL Collections and used BULK Binding involved in writing database procedures, functions and packages for Front End Module.
  • Wrote Unix Shell Scripts to process the files on daily basis like renaming the file, extracting date from the file, unzipping the file and remove the junk characters from the file before loading them into the base tables.
  • Developed PL/SQL triggers and master tables for automatic creation of primary keys.
  • Developed Advance PL/SQL packages, procedures, triggers, functions, Indexes and Collections to implement business logic using SQL Navigator. Generated server side PL/SQL scripts for data manipulation and validation and materialized views for remote instances.
  • Used joins, indexes effectively in where clauses for Query optimization.
  • Resolved Query Level Performance tuning using Explain Plan, SQL Trace
  • Planning, co-ordination and execution of Data Center migration project
  • Provide 24X7 support for level 3 production support job failures and customer outage calls
  • Vertex O series 4.1 and 6.0 Monthly maintenance to update tax rules provided by Vertex system
  • Configure tax rules and exemption s in Vertex system as part user requirements for billing calculations
  • Resolve billing issue related to vertex to solve incorrect tax rate issues from users
  • Implemented ETL framework to facilitate the ETL development process
  • Made updates to current ETL processes based on new requirements or bug fixes
  • Data Quality Analysis to determine cleansing requirements.
  • Extracted data from multiple sources to flat files and load the data to the target database.

Technology Stack Used: Oracle 9i, Unix, Window 2003 Server, Power Builder, PVCS, Serena Version Control, Linux, Oracle 12c, Control-M, SQL, PL/SQL, Shell Scripting, C, C++, Java, IBM Message Queues, Linux, UNIX, Vertex O series 4.1 & 6.0, ETL techniques

Confidential, Parsippany, New Jersey

Project Lead and Developer

Responsibilities:

  • Execute the POC for upgrade in given environment to confirm new working OS, software’s and database
  • Analyzing the present server spec, software’s, scripts and programs to determine the latest compatible OS and software versions
  • Preparing Application and Database server specification documents for new servers and software’s
  • Working with UNIX and Database teams to design new system architecture
  • Discussing with Security team to get required approvals for firewall rules and user id creation
  • Modifying existing programs, scripts to make sure that they work in new environment without any issues
  • Acquiring required approval from architecture review board on design of new servers
  • Analyzing backup procedure for existing server and database and setting best backup procedure for new servers and databases
  • Providing Weekly and Monthly updates on project to Manager
  • Following up with Vendor manager to make sure servers on board as planned to avoid any delays
  • Preparing plan for development, Testing and Go-LIVE (production) date
  • Discussing with business users and clients to align on dates for testing and GO-LIVE (production)
  • Debugging and analyzing any issues in testing scripts in new environment and working with concerned parties to resolve them
  • Testing the application in new environment and acquiring the sign-off from business users on test results.
  • Monitoring new systems during stabilization period to ensure that new system is stable

Technology Stack Used: Oracle 9i, Unix, Window 2003 Server, Power Builder, PVCS, Serena Version Control, Linux, Oracle 12c, Control-M, SQL, PL/SQL, Shell Scripting, C, C++, Java, IBM Message Queues, Linux, UNIX

Confidential, Parsippany, New Jersey

Project Lead and Developer

Responsibilities:

  • Execute the POC for upgrade in given environment to confirm new working OS, software’s and database
  • Analyzing the present server spec, software’s, scripts and programs to determine the latest compatible OS and software versions
  • Preparing Application and Database server specification documents for new servers and software’s
  • Working with Linux and Database teams to design new system architecture
  • Discussing with Security team to get required approvals for firewall rules and user id creation
  • Modifying existing programs, scripts to make sure that they work in new environment without any issues
  • Acquiring required approval from architecture review board on design of new servers
  • Analyzing backup procedure for existing server and database and setting best backup procedure for new servers and databases
  • Providing Weekly and Monthly updates on project to Manager
  • Following up with Vendor manager to make sure servers on board as planned to avoid any delays
  • Preparing plan for development, Testing and Go-LIVE (production) date
  • Discussing with business users and clients to align on dates for testing and GO-LIVE (production)
  • Debugging and analyzing any issues in testing scripts in new environment and working with concerned parties to resolve them
  • Testing the application in new environment and acquiring the sign-off from business users on test results.

Technology Stack Used: Oracle 9i, Unix, Linux, Oracle 11g, Java, Web services (Apache Tomcat), Vertex O Series 4.1 and 6.0

Confidential

Team Member, Offshore Lead

Responsibilities:

  • Supported Confidential front end tool developed in power builder which is used for contract, pricing and billing management
  • Support Credit card (CPS), subfile, AOS, Tax interfaces for daily maintenance of jobs
  • Pick up incident/issues created by users and analyze data in oracle tables to find root cause of the issue reported
  • Extensively involved in writing SQL queries, PL/SQL Programming.
  • Created and modified several UNIX shell Scripts according to the changing needs of the project and client requirements.
  • Involved in the continuous enhancements and fixing of production problems.
  • Generated server side PL/SQL scripts for data manipulation and validation and materialized views for remote instances.
  • Developed PL/SQL triggers and master tables for automatic creation of primary keys.
  • Developed Advance PL/SQL packages, procedures, triggers, functions, Indexes and Collections to implement business logic using SQL Navigator. Generated server side PL/SQL scripts for data manipulation and validation and materialized views for remote instances.
  • Used joins, indexes effectively in where clauses for Query optimization.
  • Worked with Bulk Collect, Bulk Bind and partitioning to improve the performance of multi- row queries.
  • Investigate for possible reasons of errors and scripting as needed to resolve issues
  • Vertex O series 4.1 and 6.0 Monthly maintenance to update tax rules provided by Vertex system
  • Configure tax rules and exemption s in Vertex system as part user requirements for billing calculations
  • Resolve billing issue related to vertex to solve incorrect tax rate issues from users

Technology Stack Used: Oracle 9i, Unix, Window 2003 Server, Power Builder, PVCS, Serena Version Control, UNIX Shell Scripting, C, C++, Java, Windows Server, Vertex O Series version 4.1

Hire Now