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.
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, KSHscripting, 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.
Erie Insurance. March 2013 – March 2014
Oracle PL/SQL Developer: Responsibilities:
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.
UPS Sep 2011– Feb 2013
Oracle PL/SQL Developer: Responsibilities
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.
Oracle PL/SQL Developer: The project involved maintaining information and ensuring efficient data retrieval as required for core decision making. Work involved writing Stored Procedures, Triggers and monitoring performance. The system will send the data in the form of files. The data from the files will be extracted and transformed using PL/SQL procedures. The Oracle database will act as target database.
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
caused due the data migration from various legacy systems.
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.
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
Environment: Oracle 10g/11g, SQL, PL/SQL, UNIX, Toad 10.0, ETL, Git.
HSBC Bank, INDIAApr 2007 to Mar 2008