Lohith K

ac9ftx@r.postjobfree.com

678-***-**** Ext: 10

Summary:

Around 6 years of PL/SQL Developer experience specializing in Analysis, Design, Development, Implementation and Maintenance of various applications and databases, with complete understanding of Software Development Life Cycle.

Designed, developed and supported ETL process for Data Staging, Extraction, Transformation, and loading of Fact Tables, Data Cleansing, and Automating ETL Process.

Expertise in leveraging SQL, PL/SQL, SQL*Plus, TOAD and SQL*Loader utilities to perform and automate data ingestion, manipulation and supporting in-house ETL jobs.

Strong understanding of concepts in Data Warehouse like logical and physical database designs and dimensional modeling schemas like Star and Snowflake schema for OLAP, OLTP, ETL and Reporting.

Good experience in UNIX shell scripting: Bash, Bourne, KSH. Good experience in leveraging UNIX utilities: sed, awk, grep for data manipulations.

Expert in creating DDL, DML, DCL, TCL statements, Indexed Views, Constraints, Stored Procedures, Functions, Packages, Triggers, Exceptions to facilitate efficient Data Manipulations while maintaining data consistency.

Worked with features like BULK COLLECT, MERGE, CASE and PL/SQL Supplied Packages such as DBMS_SQL, DBMS_JOB and UTL_FILE.

Proficient in developing SQL queries to retrieve the data from source at session level and in transferring and retrieval of data between FTP Servers and Oracle Database.

Expertise in handling errors using Exceptions.

Documented Data flow diagrams, Data dictionary, and applied suitable Database normalization theory techniques to create Entity Relationship models.

Working knowledge of Data-Modeling Techniques using Data-Modeling Tools like ERwin.

Experience in developing forms based on Views, Tables and Procedures in Tabular and Form layouts.

Expert in integrating the SSRS reports into web applications using Report Viewer Control, URL methods and creating data driven subscriptions to different users using Report Manager.

Excellent technical and analytical skills with clear understanding of design goals of ER modeling for OLTP and dimension modeling for OLAP.

Hands on experience in Performance Tuning of SQL Queries & Views using EXPLAIN PLAN, SQL Trace and TKPROF utilities.

Hands on experience working with Git, GitHub, TFS for Source Control.

Performed Unit Testing, System Testing and UAT Testing.

Proficiency in understanding and creating Technical Requirement Documents (TRD), Rough Order of Magnitude (ROM), Requirement Traceability Metric (RTM).

Experience in writing Technical Design Documents and developing Unit Test Documents.

Experienced in Agile/Scrum development environment.

Efficient to work independently as well as in teams to achieve solutions for complex issues and have strong verbal and written communication skills.

Involved with Environment and Configuration team for measuring various SLA (Service Level Agreement) metrics and taking corrective action plan during LAM (Look Ahead Meetings).

Worked on development focused projects with an understanding of the Software Development Life Cycle.

Technical Skills:

RDBMS: Oracle 12c/11g, MySQL

Operating Systems: Windows, Mac OS, Linux (RHEL), UNIX

Tools: TOAD, SQL Developer, SQL*Loader, SQL*Plus, Erwin, Oracle Enterprise Manager, EXPLAIN PLAN, SQL Trace, Cognos Reports, TKPROF, DBMS_PROFILER, GIT, GitHub, Oracle WebLogic, James B.Watcher.

Languages: SQL, PL/SQL, T-SQL, Shell Scripting, HTML, XML, JSON

Professional Experience:

Client: UPS - SCS, Alpharetta, GA Oct 2018 to Present

Role: Sr. Oracle PL/SQL Developer

Project: FGV

FGV is a dashboard display application that supports UPS/SCS customers with real-time tracking information. Responsible for development and production support of FGV application.

Responsibilities:

Used TOAD for creating and modifying Views, Materialized Views, Functions, Stored Procedures and Packages along with Bulk Collect of Oracle R12 as needed by business requirements.

Developed DB Triggers on data inserts, updates for automated notifications.

Developed UNIX Shell Scripts for automated execution of PL/SQL Procedures and ran using crontab at various intervals.

Created mail scripts in UNIX to send notification on successful completion or failure of various Interfaces and Jobs, with custom email format.

Worked with SQL*Loader to load data from flat files obtained from various facilities into staging tables.

Worked with DBA's regarding the data checks during Migration, Loading, Creation and Management of Tables, Indexes, Table Spaces.

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

Involved in query optimization and performance tuning using EXPLAIN PLAN, DBMS_PROFILER and SQL hints.

Performance tuned DB Queries and updated tables without breaking the existing functionality.

Facilitate timely approval of major milestones, approvals, signoff, report the project status and generate milestone reports.

Involved in Data Modeling, System/Data Analysis, Design and Development for both OLTP and Data Warehousing Environments.

Worked with source control tool (TFS) to maintain PL/SQL code and Project Tracking.

Coordinate activities with infrastructure, business and QA teams.

Provided deliverables in Agile model. Monitored and escalated tasks when dependent tasks were not completed.

Environment: Oracle 12c, TOAD, PL/SQL, SQL*PLUS, SQL*LOADER, UNIX Shell Scripts, EXPLAIN PLAN, Windows, XML, JSON, Oracle WebLogic, James B.Watcher

Client: Hansen Technologies, Bethlehem, PA June 2017 to Oct 2018

Role: Sr. Oracle PL/SQL Developer

Responsibilities:

Created and modified Complex Functions, Stored Procedures, Packages and Triggers by using Oracle PL/SQL based on the business rules.

Creation of database objects like Tables, Views, Materialized Views and advanced features like Records, Forward Declaration, Procedure Overloading and Bulk Collect.

Worked on Table Partitioning and Index Creation for improving the performance of the query.

Developed PL/SQL Triggers on Master Tables for automatic creation of primary keys and updated tables without breaking the existing functionality.

Created mail scripts in UNIX to send notification on successful completion or failure of various Interfaces and Jobs, with Customized subject and Text. UNIX Shell Scripts for automation of UNIX jobs and running files in batch mode.

Integrated the mailing system to alert various group on the status of data pulls and data processing.

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

Experience in upgrade and migration of OBIEE between dev/test/prod environments.

Involved in installation of Oracle RDBMS server software and version upgrades.

Worked with DBA's regarding the data checks during Migration, Loading, Creation and Management of Tables, Indexes, Table Spaces.

Involved in query optimization and performance tuning using EXPLAIN PLAN, DBMS_PROFILER.

Advised optimization of queries by looking at execution plan for better tuning of the database.

Worked with source control tool (GitHub, Git) to maintain the referential integrity of database.

Facilitate timely approval of major milestones, approvals, signoff and generate milestone, Project status reports.

Create a risk plan and list all the mitigations.

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

Participate in Data Modeling, System/Data Analysis, Design and Development for both OLTP and Data Warehousing Environments and involve in reviews.

Coordinate activities with infrastructure, business and QA teams.

Utilized Agile/ Scrum methodologies to monitor steer and develop project objectives.

Customized Reports according to client requirements.

Environment: Oracle 12c/11g, SQL, PL/SQL, TOAD, ERwin, SQL*PLUS, SQL*LOADER, UNIX Shell Scripts, EXPLAIN PLAN, DBMS_PROFILER, GIT, Windows

Client: UHG, Basking Ridge, NJ Oct 2013 to Dec 2015

Role: PL/SQL Developer

Responsibilities:

Worked with designers and developers to translate data requirements into the physical schema definitions for oracle.

Created and maintained Tables, Indexes, Views, Procedures, Functions, and Packages and performing DML operations using insert, update and delete statements.

Extensively worked using autonomous transaction and triggers to keep the track of DML operations (insertion, updating and deletion) and Dynamic SQL to implement DDL statements in PL/SQL programs.

Developed many complex PL/SQL programs and modified the existing PL/SQL program units using both implicit cursors and explicit cursors and their attributes.

Used Ref cursors and Collections for accessing complex data resulted from joining of large number of tables.

Used composite data types (PL/SQL Tables and Nested Tables) to improve functionality with in PL/SQL.

Extensively used the oracle exception handling techniques for implementing all types of exceptions to process errors.

Used Bulk Collect and FOR ALL to reduce context switching between SQL and PL/SQL engine and vice versa.

Developed shell scripts using UNIX commands to perform complex file processing automatically.

Developed SQL and PL/SQL scripts to transfer tables across the schemas and databases.

Worked with external tables, loaded data from flat files into Oracle tables using SQL*LOADER.

Tuned SQL queries and performed refinement of the database design leading to significant improvement in system response time and efficiency by using EXPLAIN PLAN.

Performed unit test on the developed code to ensure that its bug free.

Involved in Data Migration, logical and physical modeling of application.

Leveraged Agile Scrum methodology and responsible to provide updates in scrum calls.

Environment: Oracle 11g, TOAD, SQL Developer, Oracle Forms, Oracle Reports, SQL*LOADER, EXPLAIN PLAN, UNIX shell scripts, Windows

Client: I Space Global Services, India June 2012 to Sep 2013

Role: Oracle PL/SQL Developer

Responsibilities:

Created new database objects like Procedures, Functions, Triggers, Indexes and Views in Development and Production environment in PL/SQL and SQL*PLUS.

Developed stored procedures to pull the data from the distributed systems.

Extensively used SQL*LOADER to load the data from the flat files to the database and validated the data with the PL/SQL procedures.

Responsible for analyzing requirements, designing, maintaining and updating data models.

Developed and implemented complex data models and logical database designs.

Involved in tuning of SQL queries by using Quest Central Tools and manual by EXPLAIN PLAN.

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

Tuning queries in SQL. Hands on experience in tuning queries and on Oracle performance related features such as Query Optimizer, Execution Plans and Indexes to improve performance.

Developed payment register form and Invoice register form using Oracle Forms.

Developed data entry reports in Oracle Reports.

Involved in Unit test, Integration test and writing test plan.

Actively participated in gathering business requirements and system specification from system users and preparing detailed Business Requirement Documents (BRD’s).

Analyze the current data management procedures in practice and suggest ways for automating the process or improving the existing system.

Environment: Oracle 11g, PL/SQL, UNIX Shell Scripts, EXPLAIN PLAN, SQL*LOADER, SQL*PLUS, Oracle Forms, Oracle Reports

Education:

Master’s in Information System Technologies – Wilmington University, Delaware, May 2017

Bachelor of Technology – India, April 2012

Contact this candidate