Pl Sql Software Development

Sujatha s

Mobile: 508-***-****

Email: ad4s2c@r.postjobfree.com

Summary:

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.

Expertise in Database application development using Oracle 11g/10g/9i/8i, PL/SQL, SQL *PLUS and SQL*LOADER.

Developed Complex database objects like Stored Procedures, Functions, Packages and Triggers using SQL and PL/SQL.

Developed materialized views for data replication in distributed environments.

Created Packages and Procedures to automatically drop table indexes and create indexes for the tables.

Worked extensively on Ref Cursor, External Tables and Collections.

Developed Dynamic SQL, Collections and Exception handling.

Excellent communication, interpersonal, analytical skills and very good team player.

Actively participated in implementation of two new clients by working with various teams.

SKILLS

Programming skills: SQL, PL/SQL, HTML5, CSS3, Angular 2, Bootstrap, JQuery, PHP, JavaScript.

Operating System: Windows XP, Vista, Windows 7,8,10.

Database: Oracle, MySQL, SQL Server.

Web/App Servers: Apache, Tomcat 5.0.25, HTTP Web Server, Python, MongoDB Compass, Studio 3T

Other: MATLAB, MS word, excel, power-point, Eclipse, OBIEE reporting, Oracle analytics cloud, Data warehouse, ODI, Data modelling concepts, Sql and PlSql, RPD admin tool, ETL tool, RPD Admin tool.

Eduction Details :

Bachelor of arts from SK university 2002, India.

Professional Experience:

Client: Nirvana Health, Massachusetts, USA. December 2018 – January 2023

Role: Solutions Architect

Responsibilities:

Designed and implemented PL/SQL procedures, triggers, views and other database objects for Contract Admin application.

Developed and maintained SQL queries to obtain and store complex data into tables from remote databases (ETL)

Performed quality testing and assurance for various dev and testing environments.

Worked with DBAs on performance tuning for local reports and remote data queries.

Worked with product owners and developers across the units to identify business requirements and translated business needs to Agile stories.

As a side project, Worked on Mongo dB with python application.

Coordinated with the front-end design team to provide them with the necessary stored procedures and packages and the necessary insight into the data.

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

Involved in the continuous enhancements and fixing of production problems.

Generated server-side PL/SQL scripts for data manipulation and validation and materialized views for remote instances

Worked with the deployment team to deploy the scripts to the production servers and validate the deployed scripts.

Developed Python and shell scripts for automation of the build and release process, developed Custom Scripts to monitor repositories, Server storage.

Environment: Oracle 12c, SQL * Plus, SQL*Loader, SQL Developer, Shell Scripts, UNIX, XML, MongoDB, Python

Client: Arvest bank, Arkansas, USA. June 2017 –December 2018

Role: Senior Database Developer

Responsibilities:

Created database objects like tables, views, materialized views, procedures, and packages using oracle tools like PL/SQL Developer and SQL Developer.

Handled errors using Exception Handling extensively for the ease of debugging and displaying the error messages in the application.

Worked with cross functional teams to determine the project scope/limitations to develop the database.

Participated in system analysis and data modeling, which included creating tables, views, indexes, synonyms, triggers, functions, cursors, and packages.

Developed and maintained data extraction and transformation processes and ensured that data is properly loaded and extracted in and out of our systems.

Investigated data quality issues to implement appropriate solutions.

Identified and implemented programming enhancements.

Developed technical system documentation.

Designed and implemented PL/SQL procedures, triggers, views and other database objects for Business Data Repository (BDR) system.

Maintained SQL scripts, indexes and complex queries for analysis, extraction, and reporting.

Worked with shareholders to identify business needs and provided technical solutions.

Client: Lumen, Oklahoma, USA. February 2015 –May 2017

Role: Senior Database Engineer

Responsibilities:

Focused on the analyzed system/business requirements for feasibility.

Participated in business meetings and communicated with the other team members to gather the requirements, analyze business challenges, and provide the technical specifications regarding the code changes and enhancements.

Worked on the different software and hardware applications and made necessary changes to increase the productivity of the organization.

Installed and configured SQL Server Management Studio 2016 and Visual Studio 2019.

Gathered, organized, and sorted the operational data of restaurant clients using qualitative analysis techniques.

Identified slow performing queries and objects that hinder the operational efficiency and proposed possible solutions using problem-solving skills.

Made code enhancements to get the data requested by front-end developers.

Developed new database exports and reports by writing SQL queries to provide the data requested by the clients.

Participated in performance tuning and optimizing database objects with high CPU, reads and duration for smooth and efficient functionality.

Provided database user access to the admins based on their roles using SQL Server Analysis Services.

Performed the UAT testing and prepared the test cases when new database objects are developed or when there were code changes.

Participated in code review meetings to go through the code changes made by other developers and provided necessary feedback.

Client: Strogers Hospital, Chicago, Illinois, USA December 2014 – December 2015.

Role: Oracle Database Developer

Responsibilities:

Involved in Agile lifecycle. Designing, coding, testing.

Build, test, and deploy scalable machine learning system with an accuracy of 99% to classify more than 20,000 non-profit groups based on political activity

Design and deploy a data quality assurance system to ensure data accuracy across staging and production environments, lowering the error rate by 18%

Set up and maintain automated ETL processes, reducing the data processing time by 12%

Create Indexes and optimize queries using Query Execution Plan

Identify requirements, design Entity-Relationship (E-R) models for various applications, convert E-R models into relational schemas, and create a SQL scripts to implement models

Develop ad-hoc SQL queries to analyze and troubleshoot data errors

Assisted with schema design, code review, SQL query tuning.

Install, tune, implement and upgrade DBMS installations.

Environment: Html5, CSS, PHP, MySQL database.

Client: Canara Bank, Hyderabad. January 2010 – October 2014

Role: Database Developer

Responsibilities:

Experience data modeling, ETL (Extract-Transform-Load) concepts, query performance tuning and testing.

Utilized Teradata SQL assistant ODBC-based client utility used to access and manipulate data.

UNIX shell scripting – ability to write shell scripts that call TD utilities for processing as well as manipulating files.

Wrote many simple and complex ad-hoc reports using SQL Plus and TOAD for business users.

Transformed complex business rules to Oracle PL/SQL.

Created database objects like tables, views, procedures, packages using Oracle tools like SQL Plus, SQL Developer, PL/SQL Developer and TOAD.

Hands-On Experience writing, debugging SQL for TD load utilities.

Supported monthly process needed for project and performed data validation using various techniques.

Coordinated with project management staff on database development timelines and project scope.

Tested programs and databases to identify issues and make necessary modifications.

Contact this candidate