Oracle PL/SQL Developer

Naveen Kumar

(Oracle PL/SQL Developer)

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

PROFESSIONAL EXPERIENCE

Around 8 years of experience in IT industry. Extensive work experience in Oracle 9i,10g,11g, 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.

SolidexperienceintranslatingbusinessrequirementsintocreationofDatabaseObjects.

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, 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.

PreparedBusinessRequirementdocumentthatgivesthedetailedinformationabouttherequirements.

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.

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:

Bachelor of Technology, JNTU, Hyderabad, India

Professional Experience:

Fidelity Investments, RI

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

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-2014– 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.

Ecolab, IL Sep-2012–Jan-2014

Role:Sr.OraclePl/SQLDeveloper

Description:Ecolab will receive claim request file from Clients. This file will have all the member information that can be used to extract the claims from the warehouse for the members listed in the file. We need to load data into the systems data warehouse.

Responsibilities:

Involved in Developing and handling the PL/SQL Packages, Procedures, Functions and Database Triggers.

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 and Triggers.

Involved in uploading of the data from flat files into Databases and validated the data with PL/SQL procedures.

Maintaining daily batch cycle and providing 24 hour production support.

Supporting legacy systems with backups of all cases to/from parallel systems.

Preparation of the Test Cases and involvement in Unit Testing and System Integration Testing.

Utilized SQL*Loader to load flat files into database tables.

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

Worked with a team which Upgraded Oracle DB 8i to Oracle 10g.

Used Various Database administrative tools such as Oracle Enterprise Manager, Erwin, Toad DBA Tools, and Data Migration Tools.

Created Shell scripts to generate oracle reports and send to e-mail.

ER diagrams are developed using TOAD Data Modeler.

Involved in creating Cron jobs and Korn Shell scripts for running the daily loads.

Involved in creating and maintaining Partitioned Tables and Indexes for better performance of application

Performed SQL tuning using Explain Plan, Tkprof, Hints and indexes.

Involved in tuning of SQL queries by using Quest SQL optimizer and manually by Explain plan.

Involved in handling the changes in compiling scripts according to the database changes.

Conducted PL/SQL training session for co-workers to educate about the latest PL/SQL features, PL/SQL performance tuning.

Environment: Oracle 10g/11g, SQL * Loader, PL/SQL Developer, SQL*PLUS, UNIX Shell

Scripting, HTML, Informatica 8.6

JP Morgan Chase, Lewisville, Texas Jan-2011 – Aug-2012

Role: Oracle PL/SQL Developer

Description:The Corporate Internet Group (CIG) Money Movement processing team will be responsible for building solutions used for Chase Bank online users and other Chase Bank consumer, small business and commercial customers to support execution of critical processes for billing, remittance and settlement of large volumes of financial transactions initiated through online and offline processes. The weekly, monthly, quarterly and ad-hoc reports were generated.

Responsibilities:

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

Analyzing the data and Mapping the data requirements developing Stored Procedures, Functions and Triggers.

Involved in uploading of the data from flat files into Databases and validated the data with PL/SQL procedures.

Maintaining daily batch cycle and providing 24 hour production support.

Developed Korn shell scripts to kick off back end PL/SQL, SQL programs.

Preparation of the Test Cases and involvement in Unit Testing and System Integration Testing.

Utilized SQL*Loader to load flat files into database tables.

Created SQL*Loader scripts to load data into temporary staging tables.

Performed SQL tuning using Explain Plan, Tkprof, Hints and indexes.

Partitioned tables and indexes for better performance of application

Contacting Application Team and clients to gather the information for migration. Reviewed architecture.

Analyze SQL statements, reorganize database objects and design indexes to improve response of queries.

Involved in handling the changes in compiling scripts according to the database changes.

Developed reports using complex queries as per client request as a part of production support.

Provided on call support, solved the user issues and made necessary changes.

Resolving Production severity Issues in time and meeting the SLA.

Writing high quality and well documented code according to standards.

Environment: C, C++, UNIX shell scripting, Oracle 10g, 11g, PL/SQL, PL/SQL Developer,

SQL*PLUS, UNIX Shell Scripting, HTML

State Bank of Hyderabad (SBH), Hyderabad, India May-2009 – Dec-2010

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-2007- May-2009

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