Sql, pl/sql applications. Extensive experience in writing sql, Stored procedures, sql query Tuning

• 
  Over 7 Years of Software Development Life Cycle experience in Software Design, Development and Implementation of Oracle, SQL, PL/SQL applications. 
  
• 
  Extensive experience in writing SQL, Stored procedures, SQL Query Tuning, Functions, Packages, Database Triggers, Shell-Scripts and SQL Loader scripts. 
  
• 
  Extensive experience working on Web Services architecture in SOAP and WSDL using JAX-RPC.
  
• 
  Profound knowledge of EDI X12 standards in healthcare insurance .
  
• 
  Sound knowledge of HIPAA privacy requirements 
  
• 
  Expertise in performing Data export, Import and various operations using TOAD. 
  
• 
  Extensively worked in Client-Server application development using Oracle 11g/10g/9i/8i Forms 9i/6i, Reports 10g/6i/6.0, SQL, PL/SQL, Oracle 9iDS, Oracle Import and Export Utilities. 
  
• 
  Extensive experience in data migration techniques using Oracle External Tables, SQL* Loader, Import/Export, bulk and batch processing. 
  
• 
  Experienced in data analysis, data modeling, development, testing and documentation of Projects. 
  
• 
  Extensively Worked on Extraction, Transformation and Load (ETL) process using PL/SQL to populate the tables in OLTP and OLAP Data warehouse Environment
  
• 
  Strong Data Warehousing ETL experience of using Informatica 9.1/8.6.1/8.5/8.1/7.1 Power Center Client tools - Mapping Designer, Repository manager, Workflow Manager/Monitor and Server tools – Informatica Server, Repository Server manager.
  
• 
  Experience with DBA activities like creating users, granting and revoking privileges on database objects and taking backups. 
  
• 
  Experience in Installing Software's , Pro 'C,C shell, Perl Scripting, Korn Shell, SDLC and Configuring Databases. 
  
• 
  Experience in UNIX Shell Scripting ,KSH scripting, Linux with Business Objects. 
  
• 
  Strong Trouble-shooting, Problem solving, Analytical & Design Skills.
  

• 
  Bachelor in Electronics and Communications Engineering - India.
  

• 
  Actively participated in gathering Business Requirements and System Specification from system users.
  

• 
  Responsible for Analyzing requirements, designing, maintaining and updating data models
  
• 
  Facilitate scrum ceremonies (grooming, sprint planning, retrospectives, daily stand-ups, etc.)
  
• 
  Installation and configuration of Operating System such as Sun Solaris, Linux
  
• 
  Developed batch programs in Pro*C and wrote Scripts to run them on Unix Cron Scheduler.
  

• 
  An ad hoc query is created to obtain information as the need arises.
  
• 
  Role Development Lead (C on Unix, Pro*C,SDLC,Perl scripting, C shell Oracle, Sybase, XML parsing,.Net)
  
• 
  Maintained and developed custom utilities in a multi-platform environment proprietary software.
  

• 
  Developed stored procedures to pull the data from the distributed systems.
  
• 
  Gather requirements and design of data warehouse and data mart entities.
  
• 
  Created tables, synonyms, sequences, views.
  
• 
  Generated Statspack/AWR reports from Oracle 10g/9i database and analysed the reports for Oracle wait events, time consuming SQL queries, tablespace growth, database growth
  
• 
  Identified and recognized opportunities and resolved problems related to EDI. 
  
• 
  Data migration techniques using Oracle External Tables, SQL* Loader, Import/Export, bulk and batch processing. 
  
  • 
    Manage RAC environment for Day to Day Database administrator, Performance Tuning.
    
  • 
    Migrate over 3 TB data from Across the Platform ( From Solaris to AIX)
    
  • 
    Strong trouble shooting, problem solving, analytical and design skills.
    

• 
  Optimized and modified the triggers, complex store functions, user base data type etc.
  
• 
  Involved in tuning of SQL queries by using quest central tools and manual by EXPLAIN PLAN.
  
• 
  Developed payment register FORM and Invoice register FORM using 6i.
  
• 
  Developed data entry REPORTS in REPORTS 6i.
  
• 
  Effectively made use of Table Functions, Indexes, Table Partitioning, Collections, Analytical functions, Materialized Views, Query Re-Write and Transportable
  
• 
  Created Tables, Views, Constraints, Index (B Tree, Bitmap and function based)
  
• 
  Involved in unit testing and integrated testing, KSH scripting, Linux with Business Objects.
  
• 
  Extensively used SQL*Loader to load the data from the flat files to the database and validated the data with the PL/SQL procedures.
  
• 
  Tuned complex stored procedures for faster execution and developed database structures according to the requirements.
  
• 
  Worked on Informatica Power Center tools- Designer, Repository Manager, Workflow Manager, and Workflow Monitor.
  

• 
  Coordinated with the front end design team to provide them with the necessary stored procedures and packages and the necessary insight into the data.
  
• 
  Developed numerous forms, reports and utilities using Oracle forms 4.5, Pro*C,.Net C, Awk, Sed.
  
• 
  Developed C/C++, Pro*C, Perl Scripting ,Korn shell, SDLC Batch programs using Multithreading Programming for handling large volumes of data for parallel processing/load to purge RMS data.
  
• 
  Worked on SQL*Loader to load data from flat files obtained from various facilities every day.
  
• 
  Created and modified several UNIX shell Scripts according to the changing needs of the project and client requirements.
  
• 
  Acted effectively as point-of-contact on status of EDI transactions from internal and external customers.
  
• 
  Familiar with HIPAA technical aspects related to claims and eligibility transactions 
  
• 
  Worked on developing and debugging informatica mappings, mapplets, Sessions and workflows.
  
• 
  Created scripts to create new tables, views, queries for new enhancement in the application using TOAD.
  
• 
  Performed SQL and PL/SQL tuning and Application tuning using various tools like EXPLAIN PLAN, SQL*TRACE, TKPROF and AUTOTRACE.
  
• 
  Used Bulk Collections for better performance and easy retrieval of data, by reducing context switching between SQL and PL/SQL engines.
  
• 
  Data migration techniques used in Oracle External Tables, SQL* Loader.
  
• 
  Created PL/SQL scripts to extract the data from the operational database into simple flat text files using UTL_FILE package.
  
• 
  Creation of database objects like tables, views, materialized views, procedures and packages using oracle tools like Toad, PL/SQL Developer and SQL* plus.
  
• 
  Extensively used bulk collection in PL/SQL objects for improving the performing.
  
• 
  Created records, tables, collections (nested tables and arrays) for improving Query performance by reducing context switching.
  
• 
  Used Pragma Autonomous Transaction to avoid mutating problem in database trigger.
  
• 
  Extensively used the advanced features of PL/SQL like Records, Tables, Object types and Dynamic SQL.
  

• 
  Developed and implemented dozens of automated batch processing jobs, running in numerous development, test and production environments.
  
• 
  Created and Configured Workflows and Sessions to transport the data to target warehouse Oracle tables using Informatica Workflow Manager.
  
• 
  Administrating software Package like adding, deleting of software packages in Solaris and Adding software patches in Solaris.
  
• 
  Wrote Pro*C programs to handshake data with other projects.
  
• 
  Involved in importing the production data to work environment through TOAD.
  
• 
  Involved in handling the changes in compiling scripts according to the database changes.
  
• 
  Effectively used Triggers to track the user profile updates and to send the messages to downstream systems
  
• 
  Wrote custom support modules for upgrade implementation using Pl/Sql, Unix Shell Scripts, Pro*C, and C++.
  
• 
  Developed and prepared EDI documentation for internal and external use. 
  
• 
  Export/import using Data Pump, creating indexes, synonyms, sizing tables, refreshing Materialized view.
  
• 
  Developing back-end PL/SQL packages, building UNIX shell scripts for data migration and batch processing.
  
• 
  Process Tuning of various Nightly jobs that we rarely analyzed for the use BULK collect and optimizing
  
• 
  parameters and adjusting hint and index by reviewing the Trace files,
  
• 
  Extensively used Materialized views and DB links for remote instances to retrieve data from other databases Worked with DBA in making enhancements to physical DB schema and coordinated with DBA in creating and managing Tables, indexes, table spaces, synonyms, db links and privileges.
  
• 
  Maintained stored definitions, transformation rules and targets definitions using Informatica.
  
• 
  Used various transformations like Filter, Expression, Sequence Generator, Update Strategy,
  
• 
  Handled PL/SQL compile-time, run-time errors, debugging of Stored Procedures for business logic modification, and responding to system events through triggers.
  

• 
  Analyzed the Functional Specs provided by the Architect and created Technical Specs documents for all the mappings.
  
• 
  Manned for the efficient processing of incoming and outgoing EDI messages including customer and supplier connections. 
  
• 
  Analyzed and fixed the data discrepancies between various systems and identified bad data
  

• 
  Created PL/SQL Stored Procedures, Functions, Packages, and Triggers; extensively used Cursors, REF cursors, User-defined object types, Records, forms and reports in PL/SQL programming
  
• 
  Developed several stored procedures and functions using advanced Oracle concepts such as Bulk Binds, Bulk Collects Ref Cursors to improve performance.
  
• 
  Involved in fine tuning the existing packages for better performance and providing on-going support to existing applications and troubleshooting serious errors when occurred.
  
• 
  Modified and debugged several PL/SQL programs for performance tuning using techniques like EXPLAIN PLAN, TKPROF and DBMS_PROFILER
  
• 
  Created B Tree indexes, Function based indexes, Bit Mapped Indexes on Tables, columns to minimize query time and achieve better performance
  
• 
  Improved performance by creating Unique and Range Indexes based on the cost returned by EXPLAIN PLAN.
  

Scripting, Toad, ER-Win Windows XP, .Net.

• 
  Analyzed the business requirements and created technical specifications for enhancements in GPC. 
  
• 
  Made enhancements to the file loading process in the GPC having worked on Packages, Procedures, Functions, Views, Materialized views, Synonyms, Indexes, Cursors, Triggers, DB links, Dynamic SQL, Collections and using utilities such as MERGE, External tables and UTL_FILE.
  
• 
  Monitoring and administered the EDI system/application. 
  
• 
  Made changes to the scheduler packages which run through DBMS_JOBS in GPC. 
  
• 
  Interacted with Business analyst and Project head on daily basis being an AGILE methodology project. 
  
• 
  Co-ordinated with the Java team for frontend changes in line for the LMS application. 
  
• 
  Was involved in handling the PL/SQL changes of backend jobs and ETL process of LMS application. 
  
• 
  Created objects like Tables, Materialized views, Procedures, Packages, Synonyms. 
  
• 
  Performance tuning using hints, indexes and explain plan.
  
• 
  Extensively used TOAD for all the development work.
  
• 
  Was part of analysis of the migration of GPC system from Oracle 10g to 11g.
  
• 
  Wrote SQL and UNIX scripts to move code base to Git version control.
  
• 
  Co-ordinated with the OBIEE team to cater the reporting requirements
  

• 
  Designed the tables according the requirements 
  
• 
  Upload flat files to database using ETL tools like Informatica and SQL Loader.
  
• 
  Developed procedures to check validity of data according the business rules and fix them.
  
• 
  Write Script for data updating 
  
• 
  Daily Report Generation of Telephone Migration Project Status 
  
• 
  Production Support and Quality Control
  
• 
  Oracle objects creation scripts (DDL) for database development to Test and Production environments 
  
• 
  Oracle PL/SQL design and tuning of stored procedures 
  
• 
  ETL (Extraction Transformation Load) of data from Oracle tables to flat files and from flat files to Oracle tables 
  
• 
  Prepared test environment for QA team to test the developed application from end-end 
  
• 
  PERL script conversion to Oracle PL/SQL package
  
• 
  Developed tools to populate test data for Quality Assurance team 
  
• 
  Developed a framework for extensible automated production support in PL/SQL 
  
• 
  Developed a framework to build restart ability in the system. 
  
• 
  Single point of contact for development and technical enhancements 
  
• 
  Documented the user guide for the system.