Lakshmi Narayana

669-***-****

ad1n2z@r.postjobfree.com

Summary:

** ***** ** ********** ** development as database developer/ Technical Associate.

Well experienced in working on Oracle 10g, 11g, 12c, 19c (SQL, PL/SQL, Stored Procedures, packages, functions, triggers and SQL Loader).

ETL: Implemented Extraction, Transformation and Loading (ETL) packages to support the client workflows.

Data Migration: Experience in migrating data from different file store sources to Oracle Database.

Design: Expertise in database design for small to big database using Data modeler (ER Diagrams).

Performance Tuning: Tuned slow performing queries from AWR reports to get optimal performance using Indexes, Oracle Hints, and query re-write.

Reporting: Extensive experience in creating the dynamic and static reports using SQL, Pl/SQL, Business Objects and Crystal Reports.

CDC: Expertise in using Oracle Change Data Capture (CDC) for data transfer from one schema to another schema.

Partitioning: Experience in partitioning the tables in database for better data storage, maintenance and faster data access.

Liquibase: Experience in writing Liquibase scripts for database change management

Experience in writing Unix/Linux Shell scripting

DB Jobs: Scheduled DB jobs using OEM.

Mergers & Acquisition: Experience in merging client’s data.

RTE: Production Support

Mongo DB: Expertise in creating the collections for storing the data based on the application design.

Skill Set:

Operating Systems : Windows XP/NT/2003/7/10, Linux, UNIX

RDBMS : Oracle 9i/10g/11g/12c/19c

Non-Relational DB : Mongo DB, Robo Mongo

Tools : TOAD, SQL Developer, Liquibase, Data Modeler, BO, Crystal Reports, SVN,

Anthill, WinSCP, Putty, Splunk, Version One, Cherwell, QC, ALM, Wiki,

Service Now

Engineering Practices : Waterfall, Agile Scrum

Education:

Bachelor of Technology (Computer Science) – JNTU - 2007.

Project Experience:

Client: Cummins, Inc., Rocky Mount, NC July 2022 – Till date

Role: Sr PL/SQL Developer

Description:

Cummins Inc. is an American multinational corporation that designs, manufactures, and distributes engines,

filtration, and power generation products. Cummins also services engines and related equipment, including fuel systems, controls, air handling, filtration, emission control, electrical power generation systems, and trucks.

CMES: Cummins Manufacturing Execution system, it's belonged to Engineering and Industrial Services.

the Customer background is manufacturing the engines and the maintaining the power systems and components.

and lastly distribution the engines. CMES has the capability to support common and site-specific requirements.

and functionalities for assembly and machining solutions. It is supporting multiple versions of the product and solutions.

Responsibilities:

Identify the business needs and provided solutions for the new enhancements to the existing application.

Designed and created database tables, views and stored procedures.

Write ETL packages to move the data into different applications which are integrated with the LMS.

Migrated all the free hand SQL BO reports to universe-based reports.

Developed SQL Scripts, Packages and Procedures for Business rules check to implement business rules.

Used Ref cursors and Collections for accessing complex data resulted from joining of large number of tables in PL/SQL blocks and worked with exceptions handling.

Developed UNIX Shell scripts to automate table creation, execute procedures.

Used Toad for creating PL/SQL (trigger, sequence, stored procedure).

Developed Procedures for efficient Error Handling process by capturing errors into user managed tables

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

Writing of packages to support the client workflow.

Developed new automated processes to facilitate data imports.

Write the packages to support the business requirement.

Involved in Team meetings for any Outages and Production issues.

Employer: Evoke Technologies May 2012 to June 2022

Client: Corporation Service Company, USA

Project 1: MM (Matter Management) - (Oct 2016 – June 2022)

Oracle 11g/12c/19c, SQL, PL/SQL

Role: DB Developer

Description:

CSC scans and uploads all service of process and attached pleadings into its electronic, web-based tool, Matter Management, for immediate on-line access. This not only reduces paper flow but it also reduces the time and money spent dealing with paper. Also, since Matter Management is completely web-based, pleadings and case information can be shared across your organization with outside counsel or other interested parties without the need for costly software installations or licensing fees. Matter Management with its built-in customizable reporting engine and customizable matter fields, allow you to perform matter management tasks at a fraction of the cost of traditional software-based systems. It’s quick, it’s simple and it’s secure.

Responsibilities:

Works with business users and application developers to identify business needs and provide solutions.

Designed and created database tables, views, stored procedures, functions and triggers.

Loading client data into database by using SQL Loader and wrote scripts to support the data load from staging area to base tables.

Client data validation and transformation.

Migration of clients from other application database to Matter Management database.

Writing of functions, procedures, packages and triggers to support the client workflow.

Writing of ETL packages for populating data into data warehouse tables.

Developed and maintained ETL (Extract, Transformation and Loading) mappings to extract the data from multiple source systems like Oracle, SQL server and Flat files and loaded into Oracle.

Developed Informatica Workflows and sessions associated with the mappings using Workflow Manager.

Involved in creating new table structures and modifying existing tables and fit into the existing Data Model.

Extracted data from different databases like Oracle and external source systems like flat files using ETL tool.

Use EXPLAIN_PLAN for looking into query plan and make changes to queries to make use of indexes and faster plans.

Developed new automated processes to facilitate data imports.

Developed BO and crystal reports for reporting based on the client requirement.

Service request processing for client issues.

Supported L1, L2 teams for any Production issues in a Database.

Worked on the Production tickets which is raised by the business user in the Service Now.

Involved in Team meetings for any Outages and Production issues.

Project 2: EM (Entity Management) - (Apr 2014 – Sep 2016)

Role: DB Developer

Oracle 9i/10g, SQL, PL/SQL

Description:

CSC Entity Management is a portfolio management system that makes it easy for corporate legal departments, compliance professionals, and businesses to manage their entities, compliance events, corporate filings, officers, directors, management, and much more. It’s a flexible and robust solution that goes beyond basic compliance needs. The Entity Management application provides a simple, yet effective, tool for managing your entire entity portfolio, including individual entity details. Delivers corporate filings directly to your entity, while providing comprehensive document management capabilities. Provides the ability to view, download, and report on all information within your portfolio and Allows field customization to meet the needs of each unique business.

Responsibilities:

Analyzing the requirements and collaborating with DBA’s.

New Table design to support the new system PBNG.

Created database objects like Tables, Views, Sequences, Synonyms, Stored Procedures, Functions, Packages, Cursor, Ref Cursor and Triggers.

Wrote complex SQL Statements, Complex Joins, Co-related Sub-queries and SQL Statements with Analytical Functions

Create Adhoc PL/SQL blocks for User requirements

Resolve the database issues of the users whenever in need of

Create Programmable blocks using SQL Server to migrate data from Legacy applications to Oracle

Liquibase scripts for database change management.

Created stored procedures and packages to migrate the data from PB to PBNG.

Project 3: LMS (Litigation Management System) - (May 2012 – Mar 2014)

Role: DB Developer

Oracle 10g, SQL, PL/SQL

Description:

The project involves the development and enhancements to the Litigation Management system for Corporation Service Company.

LMS is CSC’s revolutionary system for receiving, processing, and distributing SOP, enabling the same day electronic delivery of SOP to our registered agent clients. LMS begins with Logging and Scanning Court Document and ends with the Electronic Notification to the customer and allows viewing document on web. LMS is integrated with multiple sub systems to process and deliver sop like scanning infrastructure, Captiva, documentum, mail service, fax service and FedEx...etc.

Responsibilities:

Understand low level functional requirements from business users and document technical specifications.

Create DDL’s for claim adjudication project.

Create and develop oracle forms for claim adjudication process and test them.

Created procedures, functions and packages for claim adjudication process which will be used by web application and backend data processing.

Developed data integrity checks and also developed data reconciliation scripts.

Improved Oracle reports SQL performance by modifying queries, creating required indexes.

Identify the business needs and provided solutions for the new enhancements to the existing application.

Designed and created database tables, views and stored procedures.

Wrote ETL packages to move the data into different applications which are integrated with the LMS.

Migrated all the free hand SQL BO reports to universe-based reports.

Developed SQL scripts, packages and procedures for Business rules check to implement business rules.

Data loaded from legacy systems (ETL Operations) using PL/SQL and SQL*Loader.

Involved in developing data conversion programs using SQL *Loader, PL/SQL and UNIX shell scripts.

Developed custom Forms and Reports as per client requirements and making them web enabled using Oracle Reports builder 10g and Oracle Forms builder 10g respectively.

Writing of packages to support the client workflow.

Contact this candidate