Abhinav.k

SR.Oracle PLSQL

412-***-**** acxeu4@r.postjobfree.com

PROFESSIONAL SUMMARY:

Over 7 years of extensive experience as a software developer in Oracle PLSQL.

Excellent command over SQL, PL/SQL proficient in SQL and Oracle databases.

Oracle9i/10g/11g/12c, SQL, PL/SQL; Query Optimization, Performance Tuning, Trouble shooting, transaction management mechanism, and referential integrity, Packages, Stored Procedures, Triggers and Export/Import Utilities.

Logical & Physical Data Modeling, Normalization, Application Analyzing and Designing -Designer 2000. Translating business requirements into creation of database objects: Tables, Indexes, Constraints, Triggers, Stored Procedures, and Materialized Views.

Extensive coding in PL/SQL and very strong in performance tuning expert level Oracle 9i/10g

Good experience in client/server technology, GUI design, Relational Database Management Systems (RDBMS)

Experience in Data warehousing design & Concepts and ETL

Modified database structures including table spaces, tables, views, triggers, stored procedures.

Experience in Creating Unix Shell script to automate the FTP processes for receiving and sending the files

Good knowledge on logical and physical Data Modeling using normalizing Techniques.

Experience in UNIX Shell Scripting.

Created Shell Scripts for invoking SQL scripts and scheduled them using crontab.

Experience in writing and tuning of complex SQL statements, complex joins and sub- queries.

Used SQL Trace, Explain Plan and TK Prof for Better performance.

Experience in working with UTL Files and Dynamic SQL.

Developed SQL Loader control programs, interfaces and PL/SQL validation scripts to transfer flat file data into oracle database and Oracle Applications base tables.

Proficient in Designing and Developing of Forms and Reports using Oracle Forms 9i/6i and Reports 9i/6i.

Experience in Design, Development, Implementation and support as Oracle Developer in Production, Development and Test Environments using Oracle Tools like JDeveloper and reporting services using Oracle BI tools.

Proficient in designing, modeling, creating and maintaining Oracle database.

Proficient in navigating through the databases using PLSQL Developer.

Good understanding of the Oracle database, related utilities and tools.

Experience in monitoring Performance and Tuning of the database for optimization using Explain Plan.

Knowledge of other Programming languages like Java, VB .Net,C# .Net

Experience of building and maintaining Microsoft Excel Spreadsheets, Pivot tables and Macros.

Excellent Analytical, Programming and Reporting skills.

Coordinated with DBAs, QA, Release Management and external team for technical needs and to ensure the timely release of project.

Strong perseverance and diligence towards attaining challenging goals and effective time management.

Good communication skills, inter personal skills and proven ability to perform both as an individual and as a team player.

EDUCATION

Bachelor’s Degree in Computer Science from J.N.T.U University, Hyderabad, India.

TECHENICAL SKILLS

Operating Systems

DOS, Windows XP/NT/Vista/7, Sun, AIX, Linux, UNIX

Languages

SQL, T-SQL, PLSQL, C, C++, COBOL, Java, C# .Net, VB .Net

Scripting Languages

JavaScript, Perl, HTML and XML

GUI’s

Technologies

Developer2000 (Forms 11g/10g/9i/6i, Reports 11g/10g/9i/6i), Oracle Designer 2000, Discoverer10g, Erwin, ODI, Oracle APEX

Databases

Oracle8i/9i/10g/11g/12c, SQL server 2000, Oracle XML DB, Oracle AIX, Oracle AQ, MS Access

SCM Tools

Subversion, CVS, ClearQuest, JIRA

Utilities

SQL* Plus, SQL* Loader, SQL Navigator, Toad, UTL_File, ETL tools Informatica Power Center, OEM

PROFESSIONAL EXPERIENCE:

Harte Hanks, Trevose, PA June’2015 – Till Date

Oracle PL-SQL Developer/Quality Analyst

Responsibilities:

Worked on Large Data Base processing millions of records Change requests and Source Controls.

Developed PL/SQL code to implement business rules using procedures, functions

Worked on export and import of data, SQL *Loader, UTL File package.

Extracted data from Flat files and transformed it in accordance with the Business logic mentioned by the client usingAllLink Transact Load (Front end Application used for ETL)

Involved in validating the data while data migration by creatingPL/SQL Packages, Procedures, Functions, Triggers.

Involved in Unit Testing the code before Deployment.

Created indexes on the tables for faster retrieval of the data to enhance database performance

Used hints in select statement for improving the performance.

Created PL/SQL program units to include DDL statements using Dynamic SQL.

Used cursor variables to pass query result sets between PL/SQL programs and client application

Handling CR’s and implementing according to the business rules as per required to the client.

Developed complex queries to retrieve the data

Provided updates and status and issues to the project team.

Worked as a QA resource in the team during Project Post Live.

Involved in UAT testing, Bugs fixing and the code was sent to Production.

Involved in developing test plans and test cases based on high-level and detailed designs.

Involved in Production Support and troubleshooting data quality and integrity issues.

Interacted with clients in remote locations to verify customer requirements.

Responsible for writing the technical documents and maintaining the documentation.

Environment: Oracle 12c, PLSQL Developer, Windows 7, AllLink Transact Load,Virtual Source Safe(VSS)

Brick Street Insurance, Charleston, WV Oct’2014 – may’2015

Senior Oracle PL-SQL Developer

Responsibilities:

Maintaining the Oracle Coding Standards and reviewing the Code and testing the Components.

Developed PL/SQL procedures to validate the data and insert the validate data into Oracle Standard interface tables.

Developed Packages to validate raw data from Flat Files and insert into tables.

Involved in the data transfer creating tables from various tables, coding using PL/SQL, Stored Procedures and Packages.

Customized the Reports in Cross Tab Layout and Tabular Layout Formats.

Designed and Developed scripts for uploading data from flat files and XML files into database, performing business validations on the data using PL/SQL Procedures.

Developed back end interfaces using PL/SQL Stored Packages, Procedures, Functions, Collections and Triggers.

Involved in Design, analysis, Implementation, Testing and support of ETL processes for Staging.

Used PL/SQL Tables and Records in payroll generation process.

Developed Forms (like invoicing, Delivery order) and Reports using Oracle Reports and PL/SQL.

Involved in database development by creating PL/SQL Functions, Procedures, Packages, Cursors, Error Handling and Views.

Defined UNIX shell scripts for file comparisons & file manipulations.

Created various custom reports like Transaction Aging Report, Credit Card Transaction Report, Active Invoice Register Report, Account Balance Consolidation reports and others using Reports Builder 6i.

Coordinated with DBA in improving database performance.

Written Test Plans and Involved in Unit testing.

Used the FTP commands efficiently to migrate the files and logs have been created successfully in proper directories on completion of the transfer process.

NCI Building Systems, Houston, TX Aug’2013 –Oct’2014

Oracle PL/SQL developer

Responsibilities:

Analyzed the business requirements of the project by studying the Business Requirement Specification document and prepared data dictionary document.

Created different schemas and maintained schema objects.

Creation of new packages and modification of existing codes to resolve application bugs.

Developed PL/SQL Procedures and database triggers for the validation of input data and to implement business rules.

Created database objects like packages,procedures, and functions according to the client requirement.

Created scripts to create new tables, views, queries for new enhancement in the application using TOAD.

Created indexes on the tables for faster retrieval of the data to enhance database performance.

Developed PL/SQL triggers and master tables for automatic creation of primary keys.

Created PL/SQL stored procedures, functions and packages for moving the data from staging area to data mart.

Created and modified several UNIXshell Scripts according to the changing needs of the project and client requirements.

Generated server side PL/SQL scripts for data manipulation and validation and materializedviews for remote instances.

Tuned procedures/SQL queries for maximum efficiency in various databases using Oracle Hints, for Rule based optimization.

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

Extensively used Cursors, REF cursors, User-defined object types, Records, in PL/SQL programming.

Used Advanced queuing concept to deque the exceptions raised during the cron job execution which will be notified by mail using UTL_MAIL package and enque it into main table for error reprocessing.

Created and modified several UNIX shellScripts according to the changing needs of the project and client requirements.

Performed SQL and PL/SQL tuning and Application tuning using various tools like Explain Plan, TKPROF, Autotraceand DBMS_APPLICATION_INFO..

Involved in fine tuning the existing packages for better performance and providing on-going support to existing applications and troubleshooting errors when occurred.

Environment: Oracle 11g/10g, SQL*Loader, SQL, PL/SQL, SQL developer, UNIX, Windows 7, Golden Gate, SQL Plus.

Sony Entertainment, Mumbai, India Jan’2012–June’2013

PL/SQL developer

Responsibilities:

Responsible for gathering Business Requirements, creation of Technical design documents and user Documents.

Used SQL*Loader, PL/SQL procedures to facilitate data import to staging tables, interface tables and then to base tables.

Used Materialized views in places where the data does not change very frequently.

Developed UNIX shell scripts for batch jobs.

Designed and developed Oracle Monthly Reports.

Extensively used Oracle ETL process for address data cleansing.

Scheduled the execution of PL/SQL Procedures using UNIX Shell scripts for updating of Base tables from Transaction Tables.

Used Materialized Views to simplify data-warehouse summary management and speed query processing at the same time.

Implemented corporate database backup management policy by automating various kinds of backups using UNIX shell scripts.

Gathered data into PL/SQL tables for validating and loaded into Oracle tables using BULK loader utility.

Developed Email Routing logic for validating, classifying and processing the incoming emails to Email Center.

Environment: Oracle Database 9i, PL/SQL Developer, TOAD, Forms Builder 6i, Reports Builder 6i Workflow Builder 2.6.3.5, Kintana, PVCS

ABB Introl India Nasik, India Nov’2009–Dec’2011

Oracle PL/SQL Developer

Responsibilities:

Created PL/SQL Stored Procedures, Functions, Triggers and Packages for implementing business logic.

Extensively used Cursors, User-defined Object types, Records, and Tables in PL/SQL Programming.

Handling the tickets which comes into the queue based on the priority level. Ping the users in the chat window and confirm from them if they are able to login.

Developed PL/SQL packages using indexes, joins, bulk collects and bulk variables.

Developed control files for SQL*Loader and PL/SQL programs for loading and validating the data into the Database.

Solving the issues which users get while working on this production Application server. Also call them and find out the issue they are going on and solve it.

Used Exception Handling extensively for the ease of debugging and displaying the error messages in the application.

Implemented features including materialized views for better performance of summary tables, Autonomous Transactions, Coding Dynamic SQL Statements.

Involved in SQL Tuning by creation of indexes, rebuilding Indexes using Explain Plan, SQL Trace and TKPROF Tools.

Created UNIX Shell scripts for automating the execution process.

Created Packages, Stored Procedures and Functions to be called by Java modules.

Designed and Created several Customized Reports using Oracle Reports10g.

Designed and developed front-end applications using Oracle Forms 10g.

Developed Proceduresand Triggers for Oracle Forms and Reports.

Involved in writing complex queries to generate reports as per client requests as part of productionsupport.

Coordinated with DBA in improving Database Performance.

Environment:Oracle 9i/8i, SQL PLUS, PL/ SQL, SQL*Loader, Java, J2EE, JDBC, XML, Korn Shell Scripts, FORMS & REPORTS 6i, SQL Navigator, Windows XP, MS-Excel.

Genex Technologies,Hyderabad,India May’2009–Oct’2009

Oracle Developer

Responsibilities:

Involved in gathering requirements for the new enhancements and participated in Database Design changes and prepared documentation of the application.

Co-ordinate with Business and Data Analysts in reviewing the requirements, posing questions and translating business requirements to technical specifications.

Created (or edited existing) Informatica mappings and sessions to accomplish data migrations. Sources were Oracle, SQL Server 2000, DB2 and flat files and load into Datawarehouse.

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

Creation of the database objects like tables, views, Materialized views, sequences, Synonyms, database links and indexes.

Extensively involved in using hints to direct the optimizer to choose an optimum query execution plan.

Developed custom libraries for the existing applications, used canvases, blocks, and visual attributes in developing front end using forms 10g.

Wrote SQL, PL/SQL, SQL*Plus programs required to retrieve data using cursors and exception handling.

Effectively used Oracle Reports for generating PDF reports according to the client’s requirements.

Transferred the data between databases using Export, Import and Datapump utilities.

Wrote UNIX Shell Scripts for automating the daily/weekly/monthly data process.

Wrote shell scripts to transfer files using FTP to all the UNIX servers at one time for daily data processing.

Prepared Technical Documentation. Trained the business users for the better understanding of the Business Application.

Environment: Oracle 10g, SQL * Plus, TOAD, SQL*Loader, SQL Developer, Shell Scripts, UNIX, Windows XP.

Karvy Global Services, Hyderabad, IndiaMar’2008 – April’2009

PL/SQL Developer

Responsibilities:

Performed review of the business process, involved in Requirements Analysis, System Design Documents, Flows, Test Plan preparations and Development of Business Process / Work Flow charts.

Developed PL/SQL procedures, customizing existingprograms according to the needs of the client testing.

Wrote PL/SQL packages consisting of procedures and functions.

Created Materialized Views, Triggers, Sequences, collections.

Involved in development and testing of oracle back-end objects like database triggers,stored procedures, Sequences and Synonyms.

Worked with tuning the complex Stored Procedures for faster execution using bulk collections and Dbms_profiler.

Involved in design, development and Modification of PL/SQL stored procedures,

Functions, packages and triggers to implement business rules into the application.

Extensively used cursors for fetching the rows.

Loading data through SQL Loader and UTL_FILE.

Involved in tuning the SQL queries create database objects and optimally set storage parameters for tables and indexes.

Designed reports using Reports as per user requirements. Created Reference and Master/Detail tables to store information. Tested forms and reports using test data.

Developed complex triggers in reports before/after for validation of user input.

Designed and developed user interfaces using Oracle Forms.

Wrote Shell scripts to insert data to database tables. Wrote PL/SQL code to retrieve data for master and detail blocks.

Customized forms and reports as per user requirements using Oracle Developer Forms & Reports.

Environment:Oracle 9i, SQL, PL/SQL, SQL*Plus, Forms 6i, Reports 6i, Windows.

Contact this candidate