Naveen Kumar

(Oracle PL/SQL Developer)

Email:adi9u9@r.postjobfree.com

Cell no: 845-***-****

PROFESSIONAL EXPERIENCE

•Around 8 years of experience in IT industry. Extensive work experience in Oracle 9i,10g,11g,12c,PL/SQL, TOAD, SQL* PLUS and SQL*Loader, developed back-end modules business applications, both Data Warehouses and OLTP systems, in SQL and PL/SQL.

•Solid experience in translating business requirements in to creation of Database Objects.

•Experience in Dynamic SQL, PL/SQL Collections and Exception Handling.

•Created multiple customized PL/SQL Procedures & Packages for various business’s needs, to transform data before the loading process, and to manipulate and sort data for the Reports specifications.

•Proficient in Databases including Oracle 11g/10g/9i/8i, DB2 & SQL Server.

•Expertise in Database Performance Tuning, Performance Monitoring and Optimization using Oracle Hints, Explain Plans, TK-Prof.

•Extensive work experience in Oracle 9i,10g,11g,12c, PL/SQL, TOAD, SQL Navigator, SQL* PLUS and SQL*Loader.

•Effectively made use of Table Functions, Indexes, Table Partitioning, Collections, Analytical functions, Query Re-Write and Transportable table spaces.

•Well experienced in Query Optimization and Tuning using Bulk Collections, Hints, Explain Plan, SQLTRACE.

•Experienced in creating External Tables, Uploading/Downloading data using SQL*Loader control files.

•Expertise in handling errors using Exception Handling.

•Proficiency in solving the issues after the application release in production.

•Hands on experience in working different FTP clients like Smart FTP, Cute FTP, SFTP using F-Secure and WINSCP.

•Worked closely with the technical teams and made structural changes in Database.

•Well-versed with different stages of Software Development Life Cycle (SDLC).

•Created Shell Scripts for invoking SQL scripts and scheduled them using perl scripting.

•Also performed database administrative functions like installation and configuration of database, creating database, partitioning of database, creating indexes.

•Demonstrated high learning ability with regard to new skills such as programming languages and application tools/software.

•Well versed in UNIX Commands & Scripting (Shell and Perl).

•Worked with the large teams and guided them to achieve the goals.

•Experience developing PHP applications and Oracle forms.

•Experience in Information Systems Development Methodology (ISDM).

•Experience using SAS ETL tool, Talend ETL tool and SAS Enterprise Data Integration Server highly preferred.

•Developed Materialized Views for data replication in distributed environments.

•Used Bulk collections for better performance and easy retrieval of data, by reducing context switching between SQL and PLSQL engine.

Technical Skills:

Languages

PL/SQL, SQL, Shell Programming, C, C++, Java

Databases

Oracle 12c, 11g, 10g, 9i, SQL SERVER 2005/2008,MS Access, Oracle Financials 10.4, Teradata, SAP Tables

GUI / Tools/Utilities

SQL*Loader, TOAD 11.0/8.0/7.5, PL/SQL Developer, SQL* PLUS, ERWIN 3.5/4.0, Microsoft Excel, Microsoft PowerPoint

Operating Systems

Unix, DOS, Linux, Windows XP/7

Scripting

Unix Shell Scripting

Professional Experience:

Client: Florida Blue (BCBS), Jacksonville, FL Oct 2019 to Till Date

Role: Sr.Oracle PL/SQL Developer

Description: Claims rules management is single UI Application for multiple Rulesets in diamond. Earlier each rule set has its own screen in power builder application. Claims rules application has more flexibility to add/delete/void/term/copy rules. All the converted Rules sets will use the same data model with converted rules. Extra capabilities like debug logging for rules engine and new process logging for claims with improved claims processing time.

Responsibilities:

•Involved in project planning and scheduling, System Design, Functional specification, Design specification, Preparation of impact analysis, Coding, System Test Plan, User Acceptance Testing (UAT), Quality Assurance, Code Review and Production Support.

•Analyzed each keyword before converting to new rules engine. And also prepared dev analysis document which will be source document for analysts to converts determinant rules to new rules engine supported rules. Converted rule will show up in claims rules management application.

•Partitioned the fact tables and materialized views to enhance the performance.

•Extensively used bulk collection in PL/SQL objects for improving the performing.

•Created records, tables, collections (nested tables and arrays) for improving Query performance by reducing context switching.

•Used Pragma Autonomous Transaction to avoid mutating problem in database trigger.

•Researching production issues and provide documented analysis and sizing required to fix the issue.

•Supported for code deployments for monthly release. (Diamond deployment and BART Deployments).

•Created multiple objects/method/procedure/packages to for both key word and claim rules management.

•Extensively worked with JSON format data and CLOB objects.

•Experience using code repositories, preferably Gitlab.

•Experience with developing Oracle forms and PHP application.

•Experience with Unified Modeling Language (UML)

•Extensively worked on code to improve the claim processing time after converting each keyword.

•Worked with analysts to load the new rules to rules management application with BART deployment.

•Used advanced Bulk techniques (FOR ALL, BULK COLLECT) to improve performance. Involved in working with implicit cursors, explicit cursors, and REF CURSORS.

Environment: Oracle 19c/12c/11g/10g, PL/SQL, UNIX Shell Scripting, Shell Programming, UNIX (Solaris, Linux), Microsoft SQL Server 2008, Visual Studio 2008, T-SQL, SQL Server Reporting Services, SQR-Reporting.

Client: NextEra Energy, FL Sep-2017 – Sep-2019

Role: Sr.Oracle PL/SQL Developer

Description: The Partner Reporting will support the WSS applications, extracts/reports, and downstream applications in support of contractual obligations. The NextEra energy has there all transactions entered into their data-base as they occur, and they write a log record to a backup disk and writes the unique transaction ID generated by the region for each transaction to a Transaction List File. The Close of business day (COB) generates transactions such as Spot deals are written in database. As per the FERC requirement we are getting the 5min data from vendors and validating them to hourly.

Responsibilities:

•Developed PL/SQL Packages, Procedures and Functions accordance with requirements for loading data into database tables.

•Loading of data from using SQL* Loader and import/export utilities.

•Developed technical specifications for various back end modules from Business Principles.

•Developed stored procedures to extract the data from various sources and load it into data warehouse.

•Analyzing the data needs for the customized reports. Mapping the data requirements developing Stored Procedures, Functions, Views, Materialized View and Triggers.

•Created and modified several views on tables which will be populating the Warehouse system. Also involved in creation of aggregate materialized views on Data Warehouse.

•Hands on experience on migration on on-perm OBIEE to OAC

•Experienced in DB Design, Oracle Forms reports, PL/SQL Development and DBA.

•Complex SQL, User-Defined Types, Collections, Dynamic SQL, Bulk binding techniques

•Developed reports using complex queries as risk manager request as a part of production support.

•Conduct ETL performance tuning, troubleshooting, support, and capacity estimation within multi-terabyte environment.

•Created and customized Oracle BI metadata in the analytics repository with OBIEE Administration Tool.

•Designed the Dimensional Model of the Data Warehouse Confirmation of source data layouts and needs.

•Identified the dimension, fact tables and designed the data warehouse using star schema.

•Improved the performance of the slow SQL queries by implementing indexes, using FORALL, BULK COLLECT and developed various procedures, functions and packages to implement the new business

•Developed complex SQL queries to perform the back-end testing of the Oracle database using SQL and UNIX shell commands

•Performed the uploading and downloading of flat files from UNIX server using FTP

Environment: UNIX, Oracle 10g/11g/12c, Windows 7, PL/SQL, SQL*PLUS, SQL, SQL*Loader,

Role: Oracle PL/SQL Developer Dec-2015 –Aug-2017

Client: State Street Bank, Boston

Description: The Partner Reporting will support the WSS applications, extracts/reports, and downstream applications in support of contractual obligations. The State street have all transactions entered into the ORD database as they occur and they writes a log record to a backup disk and also writes the unique transaction ID (WSS_TID) generated by the WSS for each transaction to a Transaction List File. The Close of Area (COA) generates transactions such as FX Spot deals are written in ORD database. We are migrating these into the new Linux server (IORD). In this migration we are changing our applications and scripts and creating new tables and extracts which are compatible to our server. So, that we can generate the reports and extracts as soon as possible by our new server.

Responsibilities:

•PL/SQL programming - Packages, Stored procedures.

•Created Partitioned tables and indexes for improving the performance of application.

•Extensive experience working with DB Links and also creating bitmap indexes, Index Organized table, external tables etc. Experience in using several built in database packages as DBMS_JOB, DBMS_OUTPUT, UTL_FILE and DBMS_SQL are few to be named.

•Created shell scripts to execute script in SQL*plus using AutoSys jobs.

•Experience with Unified Modeling Language (UML)

•Developed back-end PL/SQL packages, UNIX shell scripts for data migration and batch processing.

•Created SHELL script in (BASH and KORN) to called Oracle application, get files from FTP site and copied to local server and created FTPLOGS, LOGFILES, and INFILE/OUTFILE directories for processed or troubleshooting.

•Experience with developing Oracle forms and PHP application

•Developing complex PL/SQL database objects, including both DML and DDL

•Install and manage Autosys scheduling package on Windows and multiple UNIX environments.

•Monitor daily processing flows and Autosys jobs, insuring systems stability so we meet processing service level.

•Experience working in trending reports using Crystal Report XI Enterprise.

•Responsible for deployment of changes to QA, UAT and PROD making use of Cloud DB Deployment, IBM Build Forge

•Created AUTOSYS command script to retrieved information from daily AUTOSYS EVENT logs.

•Created Autosys JILs to run in job streams as requested by the Production department.

•Worked on data analysis and data correction and cleanup for warehouse tables.

•Experience with additional JavaScript frameworks, such as AngularJS, NodeJS, and React.

•Performed tool evaluation and feasibility to help in selecting suitable Automation tool for RPA implementation.

•Created reusable automation framework with Meta Bots and reusable libraries with data externalization for RPA implementation.

•Performed stress test for bot Scripts to prove the scalability and stability of RPA code.

•Experience with responsive design frameworks, preferably Bootstrap

•Analyzed current procedures, recommended and implemented improvements as needed.

•Experience in web development leveraging XML and CSS

•Developed complex SQL queries to perform the back end testing of the Oracle database using SQL and UNIX shell commands

Environment: Oracle 11g/10g, PL/SQL, UNIX Shell Scripting, Shell Programming, UNIX (Solaris, Linux), Autosys JIL, Microsoft SQL Server 2008, Visual Studio 2008, T-SQL, SQL Server Reporting Services, SQR-Reporting, IBM Utilities.

Client: Sentigy, TX Jan-2014 – Nov 2015

Role: Oracle PL/SQL Developer

Description: Risk Management System helps the business to analyze the risk associated with insight into global market. It offers historical or projected data to calculate market risk as potential changes in fair values of financial instruments in response to market movements. It also used for scenario analyses to estimate the potential economic loss that could arise from extreme, but plausible, stress events.

Responsibilities:

•Developed PL/SQL Packages, Procedures and Functions accordance with requirements for loading data into database tables.

•Loading of data from using SQL* Loader and import/export utilities.

•Design and development web pages using ASP.Net

•Developing the application using MVC, Entity Data Model and RESTful and WCF services.

•Experience in Information Systems Development Methodology (ISDM)

•Developed stored procedures to extract the data from different sources and load it into data warehouse.

•Analyzing the data needs for the customized reports. Mapping the data requirements developing Stored Procedures, Functions, Views, Materialized View and Triggers.

•Created and modified several views on tables which will be populating the Warehouse system. Also involved in creation of aggregate materialized views on Data Warehouse.

•Developing complex PL/SQL database objects, including both DML and DDL Experienced in DB Design, Oracle Forms reports, PL/SQ Development and DBA.

•Experience with developing Oracle forms and PHP application

•Complex SQL, User-Defined Types, Collections, Dynamic SQL, Bulk binding techniques

•Developed reports using complex queries as risk manager request as a part of production support.

•Improved the performance of the slow SQL queries by implementing indexes, using FORALL, BULK COLLECT and developed various procedures, functions and packages to implement the new business

•Developed complex SQL queries to perform the back end testing of the Oracle database using SQL and UNIX shell commands

•Experience with JQuery (JavaScript library) and JavaScript frameworks, such as AngularJS, NodeJs, and React.

•Experience in web development leveraging XML and CSS

•Experience developing classic Microsoft ASP (ASP 3.0) applications.

Environment: UNIX, Oracle 10g/11g, Windows 7, PL/SQL, SQL*PLUS, SQL, SQL*Loader, PL/SQL Developer, JAVA J2EE.

Client: Bharat Heavy Electricals Ltd. (BHEL), India Jan-2012 – Dec-2013

Role: Jr.Oracle PL/SQL Developer

Description: BHEL is a Heavy Electricals (India) Limited was merged with BHEL in it entered into power equipment’s, to reduce its dependence on the power sector. It developed the capability to produce a variety of electrical, electronic and mechanical equipment’s for all sectors, including transmission, transportation, oil and gas and other allied industries, it was converted into a public limited company.

Responsibilities:

•Analyzed the Business requirements of the project by studying the Business Requirement Specification document.

•Prepared program specifications for PL/SQL Procedures and Functions to do the data migration and conversion.

•Worked with wide range of data types, tables, and index types and scoped variables.

•Creation of database objects like Tables, Views, Packages using Oracle tools like PL/SQL, SQL* Plus, SQL*Loader.

•Experience with responsive design frameworks, preferably Bootstrap

•Designed the front end interface for the users, using Forms 6i

•Involved in database development by creating Oracle PL/SQL Functions, Procedures, Triggers, Packages and Records.

•Experience with developing Oracle forms and PHP application.

•Experience developing web services, preferably rESTful web services.

•Run batch jobs for loading database tables from Flat Files using SQL*Loader.

•Developed necessary reports using Reports 6i.

•Developing complex PL/SQL database objects, including both DML and DDL Created number of database Triggers using PL/SQL.

•Implemented project at client place.

Environment: Oracle 9i, Oracle Forms 6i, Reports 6i, SQL Loader, UNIX, Toad, SQL*LOADER

Education:

•Master’s in Information Systems, Texas A&M University.

•Bachelor of Technology, JNTU-Hyderabad, India.

Contact this candidate