Karthik Ogirala

PL/SQL Developer

Email id: adm53i@r.postjobfree.com

Contact no: 626-***-****

PROFESSIONAL SUMMARY:

7+ years of programming experience as an Oracle PL/SQL Developer in Analysis, Design, Data Modeling (Logical and Physical), and Implementation of Business Applications using the Oracle Relational Database Management System (RDBMS).

Excellent skills in Design and Development of applications using Oracle Database 11g/10g/9i/8i, SQL, PL/SQL, Oracle Forms & Reports 10g/9i/6i.

Involved in all phases of the SDLC (Software Development Life Cycle) from analysis, design, development, testing, implementation and maintenance with timely delivery against aggressive deadlines.

Experience in ETL Architect/Designer, Relational Database applications design, development and Support on UNIX.

Extensively developed PL/SQL code using PL/SQL Packages, stored procedures, functions, triggers, cursors, views, indexes for processing data and enforcing referential integrity.

Experience in using tools like TOAD, PLSQL Developer, and SQL Developer.

Proficient in Oracle database creation, table space management, creating database links, schemas, profiles and roles, managing control, redo log and data files.

Experience in designing data models using Erwin and Visio.

Expertise in data modeling, Normalization, database design, data loading, data retrieval, modification, and archival techniques.

Good experience in working alongside JAVA and Dot net projects.

Experience with data warehouse design using Star Schema and Snowflake schema.

Experience in loading data from flat files to database tables using SQL*Loader.

Experience in working with UNIX and expertise in UNIX Shell Scripting.

Strong experience in SQL Tuning using Explain Plan, SQL*Trace and TKPROF.

Working Knowledge on testing tools like Win Runner, QTP, Quality center, Test Case manager.

Experience in writing Java programs using Threads, File streams, Maps, Collections serialization, overriding, overloading, and other core Java concepts.

Manage and resolved the production issues by identifying the root cause.

Participated alone in production releases, design code review meetings, configuration/release meetings.

Ability to work closely with clients to analyze data, determines project requirements, review functional requirements and develop detailed designs to meet requirements.

Technical skills:

Operating Systems

Windows98/XP/2000/2003/NT, DOS, UNIX (Sun Solaris, HP-UX), Linux

Database

Oracle 11g/10G/9i/8i, MySQL, MS SQL Server, DB2, MS Access 2000

Programming languages

ANSI C, C++, Java, VC++, C#, VB, PL/SQL programming

Web Technologies

HTML, DHTML, Cold Fusion, AJAX, XML

Script Languages

JavaScript, Shell, Perl scripting

Tools

Toad, PLSQL Developer, OEM, SQL Navigator, SQL Tools

Others

Object Oriented Designing Methodology, UML, RDBMS Concepts

WORK EXPERIENCE:

ADP (Pasadena, CA) Jan 2018 - Present

PL/SQL Developer

Responsibilities:

Analyzed System Requirements to create high level and detail design documents with the assistance of requirements team and Architects.

Worked closely and supported members of teams such as Architecture, Change management, Database Management, Technical operations, System Test, UAT, Requirements and Business teams during entire life cycle of the project.

Significant use of database technology data warehousing STAR schema, SQL-Loader, Oracle Stored Procedures.

Developed highly complex applications using Oracle 11g database as back-end with expertise in design and development of Oracle PL/SQL Packages and Procedures.

Designed and developed Oracle objects such as Tables, Views, Indexes, Stored Procedures and Functions in PL/SQL, Packages in PL/SQL, Materialized Views, Joins and Dynamic SQL.

Used concepts like Partitioning, Partition pruning, Index by Tables, Bulk Collect, Pipelined Functions, Insert All, Global Temporary tables.

Developed Extraction, Transformation, and Load (ETL) scripts utilizing SQL, PL/SQL utilities and provide solutions to critical issues enhancing performance and productivity to the project.

As a key PL/SQL developer, defined the required analytics to design, develop financial routines, and assisted various work streams in identifying, and resolving data irregularities, and establish management reporting processes and requisite supporting technology.

Constructed complex SQL queries with sub-queries, inline views as per the functional needs in the Business Requirements Document (BRD). Created SQL scripts to perform unit and component testing financial calculations such as, Interest receivables.

DBMS developments include building data migration scripts using Oracle SQL*LOADER and UTL packages.

Data loads are been performed by using the SQL loader, Imports & UTL files based on file formats.

Written Java code by using collections, maps, file streams, threads for enhancements.

Developed multithread application using core java.

Used Java collections and maps extensively for creating the Java Classes.

Handled code defects, enhancements and release management using tools like Rational Clear case and Rational Clear quest.

Performed performance tuning for faster retrieval of data using various optimizer hints such as Parallel, Ordered, Append and Use Hash and used customized v$ scripts to monitor the database processes and performance.

Document production support procedures, standards. Create production support documents for data warehouse applications.

Participated in Design and Code Reviews enforcing Operational standards and provide inputs to development team.

Used existing processes and procedures for application deployment and provided 24x7 production support as Primary.

Environment: Oracle 11g/10g, Clear case, Clear quest, Toad 9.5, PLSQL Developer 7, Sun OS 5.8, Windows XP 5.1.2, AB Initio, Business Objects, Sql*Loader, Java, DOORS.

DELL (Austin, TX) May 2017 – Dec 2017

PL/SQL Developer

Responsibilities

Worked closely with platform support groups for seamless production executions-Unix Support, Autosys Support, DBA’s and Change Management Team

Played a key role in business requirement gathering & analysis, architecture designs, application development, integration and testing and production support

Created a custom extraction system that populated a data warehouse star schema.

Responsible for writing and modification of PL/SQL stored procedure, functions, packages and Database triggers.

Developed, modified, and optimized complex queries for data retrieval and modification. Optimized and Tuned SQL Queries by running Explain plans.

Used advanced PLSQL concepts like Bulk collect, plsql tables and Dynamic SQL for DML operations for better performance.

Created tables with complex constraints applicable to the business rules.

Developed Unix Kshell scripts to extract data from the Production database & refresh the data warehousing application on a daily basis.

Created tables, Tablespaces, schemas, views, packages, stored procedures, triggers, functions etc using TOAD.

Extracted Transformed and Loaded (ETL) data source database to data warehouse system.

Overridden several Java methods declared in Interfaces and Abstract classes.

Overloaded Java methods in the classes to achieve expected results.

Extensively worked in the performance tuning of the programs, ETL Procedures and processes

Used Ref Cursors, Synonyms, Indexes, Joins and Exceptions extensively in coding.

Data migration and conversion done utilizing Oracle utilities: Export/Import

Involved in writing Perl Scripts for populating data on to WebPages.

Involved in data load using PL/SQL and SQL*Loader; and cron jobs calling UNIX scripts to download and manipulate files.

Wrote UNIX shell scripts for automating regular data loading jobs.

Interacting with the users and troubleshooting the problems involved with the development of stored procedures, triggers and with the privileges.

Involved in developing scenarios for Unit, Integration testing to ensure that all the components work correctly when integrated.

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

Environment: Oracle 11g, Sun Solaris 10, SQL, Erwin, SQL*Plus, TOAD, SQL*Loader, Java, Quality Center, Relational Clear Case, Informatica Power Center 8.1.1, SQL Developer.

Fifth third bank (Cincinnati, OH) May 2016 – April 2017

PL SQL Developer

Responsibilities:

Created and modified complex functions, stored procedures, packages, and Triggers by using Oracle PL/SQL based on the business rules.

Extensively worked on Schema Migration, Database Program Migration, Data Migration from Sybase to Oracle by using Oracle SQL Developer.

Worked on SQL Tuning by using various tools like EXPLAINPLAN, DBMS_PROFILER, Hints etc.

Worked on Dynamic SQL by using Execute Immediate and DBMS_SQL along with Bulk Collect.

Extensively used PL/SQL advanced features like forward declaration, Procedure Overloading in the PL/SQL Packages.

Created Packages to be called by Java modules.

Used UTL_FILE_PACKAGES for writing DBMS_OUTPUT into the files.

Extensively used Oracle 11g features like RESULT_CACHE, Compound Triggers etc.

Used serialization, threads, file Input and Outputs in java for developing applications.

Worked on SQL*Loader to load data from flat files obtained from various facilities every day

Worked on Table partitioning and Index creation to improve the performance of the query.

Worked with DBA’s regarding the data checks during migration, loading, creation and management of tables, indexes, table spaces etc.

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

Involved in Requirement Gathering, High Level Design, Low Level Design, Development, Unit testing & Integration Testing of Data Migration process using ETL Methodology.

Facilitate timely approval of major milestones, approvals, and signoff.

Report the project status and generate milestone reports.

Creation of database objects like tables, views, materialized views, procedures, and packages using oracle tools like Toad, PL/SQL Developer, and SQL* plus.

Communicate with developers, database administrators, project managers, Systems analysts and senior management about the issues that impact the project’s success.

Create a risk plan and list all the mitigations.

Present the change requests for approvals.

Facilitate and document the post implementation results in the form of closure reports.

Conduct weekly status meetings.

Extensively used the advanced features of PL/SQL like Records, Tables, Object types and Dynamic SQL.

Participate in requirements review, application design review and test plan reviews

Coordinate activities with infrastructure, business, and QA teams.

Environment: Oracle 10g/11g, Oracle forms/reports 10g, SQL, PL/SQL, SQL*Plus, Toad, MSSQL Server, Windows NT, HTML, XML.

NuView Systems (Hyderabad, AP) May 2013 - June 2014

PL/SQL Developer

Responsibilities:

Involved in Requirement Gathering, Analysis, Implementation, Development and Maintenance of the application.

Involved in Designing data models using Erwin.

Responsible for writing and modification of PL/SQL stored procedures, functions, packages and Database triggers.

Created new Tables, Indexes, Synonyms and Sequences needed as per new requirements

Used advanced PLSQL concepts like Bulk collect, plsql tables and Dynamic SQL for better performance.

Extensively used SQL & PL/SQL in reports. Cardinalities and Joins were used

Developed, modified and optimized complex queries for data retrieval and modification.

Wrote UNIX shell scripts for automating regular data loading jobs.

Tuned SQL queries and complex procedures to improve performance

Handled PL/SQL Compile-Time, Runtime Errors, and Debugging stored procedure for business logic modification, responding to System Events through Triggers.

Interacting with the users and troubleshooting the problems involved with the development of stored procedures, triggers and with the privileges

Involved in Extraction, Transformation and Loading (ETL) of data by using Informatica power center 8.5.

Used SQL* Loader for Data Conversions and to load the flat files from other different sources, from flat files into Oracle database.

Tuned SQL* LOADER and SQL Scripts to load data faster.

Used Workflow manager to create Workflows, Worklets and tasks.

Extensively used Quality center to Run test cases and to report and track defects.

Used Relational Clear Case for source and version control.

Involved in Unit Testing for the application.

Involved in supporting the performance of the project in production phase

Involved in solving day-to-day problems, giving support to the users.

Provided 24/7 on call production support.

Environment: Oracle 11g/10g, WINDOWS 7, SQL, PL/SQL, SQL * Plus, Java, TOAD, SQL*Loader, Shell Scripts, SQL *Loader, SQL Plus, SQL Developer, UNIX, Windows XP

Contact this candidate