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 certificates and vertex upgrade
• Expertise in supporting Contract, Pricing, Billing and Revenue Oriented applications like BOLT 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 training 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 engineeringmethodologies such as Requirement Gathering, Development, Normalization, Data analysis,Performance tuning, Integration, Bug-fixing, Coding, Unit Testing, Production support andMaintenance of application
• Completed BOLT 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, OraclePackages, 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

PROFESSIONAL EXPERIENCE

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

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

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 certificates 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