Oracle PLSQL developer

Naveen Kumar

(Oracle PL/SQL Developer)

Email: ***********@*****.*** Cell no: 845-***-****

PROFESSIONAL EXPERIENCE

Around 6 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 modulesfor multi-tier business applications, both Data Warehouses and OLTP systems, in SQL and PL/SQL.

Solid experience in translating business requirements in to creation of DatabaseObjects.

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 and Table Partitioning.

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

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.

Interacted with the business users, collected the requirements, analyze the requirements, design and recommend solutions.

Prepared Business Requirement document that gives the detailed information about the requirements.

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

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.

Strong troubleshooting and Organizational skill, independent, self-managing and teamwork.

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

Interacted with business users, collected the requirements analyze the requirements, design and recommend solutions.

Have hands on experience in cloud deployments

Had experience working in Agile environment.

Technical Skills:

Languages

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

Databases

Oracle 11g, 10g, 9i, SQL SERVER 2005/2008,MS Access, Oracle Financials 10.4

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

Education:

Master’s in Information Systems

Bachelor of Technology, JNTU, Hyderabad, India

Professional Experience:

Client: NextEra Energy, FL Sep-2017 – Present

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.

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

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.

Worked on the dimensional model design for designing the data warehouse and data marts.

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,

State Street Bank, Boston

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

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.

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.

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.

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

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.

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

Maintaining daily batch cycle and providing 24 hour production support.

Developing automated Korn shell scripts to schedule the load of flat files on daily, weekly and monthly basis.

Developed database triggers required for the Integrity constraints.

Analyzed current procedures, recommended and implemented improvements as needed.

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.

Fidelity Investments, RI

Role: Sr. Oracle PL/SQL Developer Aug-2015 – Nov-2015

Description: STP is a user set up transaction process system to the new STP portal REST Service would call MSG Delivery service to send emails to notify client/consultant with user id and password once they are setup. The data comes from the different tables in form of daily feed files which are loaded into new environments. The data present in ODS gets loaded into DW on a daily basis, through ETL processes. The DWH Enrichment happens on a monthly basis and the Data Mart is built on a Month end, which is used and exposed for Daily Report generations.

Responsibilities:

Responsible for Study, Analysis, Design, Development/Customization and Testing/Debugging of the application.

Developed various Complex Queries, Views for Generating Reports.

Involved in Unit testing of PL/ SQL Stored Procedures, Functions and Packages

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

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

Designed snow-flake and star schema for ETL process

Created complex VIEWS using joins and aggregate functions in order to support the reporting team and the BI team.

worked on ETL code using PL/SQL in order to meet requirements for Extract, transformation and loading of data from source to target data structures.

Environment: Oracle 10g/11g, SQL * Loader, PL/SQL Developer, UNIX Shell Scripting, HTML, Informatica 8.6

Sentigy, TX Jan-2015 – July 2015

Role: Sr. Oracle PL/SQL Developer

Description: Risk Management System helps the bussiness 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.

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

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.

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

Experienced in DB Design, Oracle Forms reports, PL/SQ 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.

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,Windows 7, PL/SQL, SQL*PLUS,SQL, SQL*Loader,

PL/SQL Developer, JAVA J2EE.

State Bank of Hyderabad (SBH), Hyderabad, India Jan-2014 – Dec-2014

Role: Jr. Oracle PL/SQL Developer

Description: SBH is one of the INDIA’s largest financial services company and it offers a wide variety of banking services which include corporate and personal banking, industrial finance, agricultural finance, financing of trade and international banking. The large presence and vast resource base have helped the Bank to build strong links with trade and industry. Among the clients of the Bank are Indian conglomerates, medium and small industrial units, exporters, non-resident Indians and multinational companies.

Responsibilities:

Handling the request according to the User Specifications.

Created Grants of roles and privileges to the user.

Resolved application problems to maintain high level of customer satisfaction.

Created varioustables, indexes, constraints, views sequences, synonyms and stored program units.

DevelopedSQL* Loader scripts for data extraction and transformation.

Participated in Performance Tuning of SQL queries using Explain Plan to improve the performance of the application.

Developed Unix Shell Scripts to automate backend jobs, loading data into the Database using SQL* Loader.

Developed database triggers required for the Integrity constraints.

Analyzed current procedures, recommended and implemented improvements as needed.

Created Cursors and Ref cursors as a part of the procedure to retrieve the selected data.

Written PL/SQL cursors for transaction processing.

Written Queries for the management in the form of stored procedures and packages.

Involved in writing complex queries to generate reports as per client request as a part of production support.

Created partitions on the tables to improve the performance.

Extracted data from Flat files, Oracle and SQL server sources.

Designed and generated reports using Crystal Reports.

Environment: Oracle 9i, PL/SQL Developer, Solaris 5.9, SQL Developer 1.1,SVN, Windows 2000,

Crystal reports.

Bharat Heavy Electricals Ltd. (BHEL), India Jun-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 equipments, to reduce its dependence on the power sector. It developed the capability to produce a variety of electrical, electronic and mechanical equipments 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, index types and scoped variables.

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

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.

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

Developed necessary reports using Reports 6i.

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

Contact this candidate