SUMMARY:

• Around 6+ Years of professional experience in ORACLE 12c/11g/10g, SQL and PLSQL.
• Experience in advanced PL/SQL concepts like Bulk collect, PL/SQL tables, Cursors and Dynamic SQL for DML operations for better performance.
• Experienced in PL/SQL programming, Triggers, Stored Packages, Procedures and Functions, PL/SQL collections.
• Strong knowledge in RDBMS concepts and extensive experience in creation and maintenance of Tables, Views, Materialized Views, Stored Procedures, Packages, Synonyms, Indexes, Triggers, Bulk Load and PL/SQL programming.
• Expertise in developing complex code units, Database triggers and using the latest features to optimize performance (Bulk Binds, Materialized views, Inline views, Global Temporary Tables).
• Worked on various phases of Software Development Life Cycle (SDLC) such as Project Requirement Analysis, System Analysis & Design, Coding, Unit Testing, Quality Assurance, Project Planning and Documentation
• Thorough understanding of Python 3.x/2.x basic concepts like Lists, Strings, Indexing, Slicing, Tuples and Dictionaries.
• Familiar with NumPy, Pandas.
• Experience in database design, data analysis, data modeling, development, Query Optimization, SQL Tuning, and Trouble Shooting
• Good experience in working with Autonomous Transactions in PL/SQL.
• Experience in using SQL TRACE tools for Explain Plan, collection of statistics and creation of indexes for database access and indexing the required columns.
• Involved in the issue resolution and Root Cause Analysis.
• Expertise in doing Unit Testing, Integration Testing, System Testing and Data Validation for Developed Informatica Mappings.
• Well Experienced in doing Error Handling using various log files.
• Strong programming, debugging and problem - solving skills and ability to translate user requirements into specific technical solutions by utilizing business insights.
• Involved in Full Life Cycle Development (Agile) of building a Data Warehouse on Windows and Unix Platforms.
• Experience in UNIX working environment, writing UNIX shell scripts for Informatica pre-& post session operations.
• UNIX shell scripts for automating batch programs, DBMS SCHEDULER and DBMS JOB.
• Experience in customizing standard reports as well as developing custom reports in Oracle Applications using Oracle Reports Builder.
• Experienced in using various Oracle PL/SQL collections VARRAYS, NESTED TABLE.
• Expertise in implementing business logic using various DB objects like Joins, complex SQL Queries, views, dynamic SQL.
• Experienced in writing SQL scripts for creating Tables, Indexes, Grants, Views, Schemas and Synonyms.
• Expert in writing Job Schedulers, Cursors, Ref Cursors and Handling Exceptions while developing the applications.
• Experienced in using parallel query execution in selects, and subqueries in update, insert and delete statements.
• Experienced in using SQL hints for troubleshooting purposes.
• Broad experience working with Eclipse.
• Experience with writing scripts for creating Tables, Indexes, Grants, Views, Dynamic Sql, Schemas and Synonyms and made modifications for the existing tables as per business logic.
• Experienced with writing SQL Loader scripts to migrate the data from text files, csv files, spreadsheets to DB staging tables.
• Excellent communication, interpersonal, analytical skills and strong ability to perform as part of a team.
• Experience in E-R modeling, understanding in developing Database Schemas.

TECHNICAL SKILLS:

Web Technologies: HTML/HTML5, CSS2/CSS3, DHTML, XML, XHTML, XSLT, Java, JavaScript, AJAX, jQuery, JSON, Apache, PHP, Responsive Design

Languages: SQL, PL/SQL, XML, UNIX Shell Scripting, Perl Scripting, C, C++, Perl programming, Java

Tools: PL/SQL Developer, TOAD, SQL Developer, SQL*Loader, Oracle SQL*Plus, SQL Navigator, PUTTY (Unix/Linux Utilities), Solaris, FileZilla, WinSCP, Jira, ERWIN, APEX

Development Tools: Adobe Photoshop CS5, Google Ad Words, Yahoo Search Marketing (spring tool suite)

Oracle Tools/GUI: Forms 9i/10g, Reports 9i/10g, Discoverer 11g

Databases: Oracle 12c/11g/10g, PL/SQL (oracle), MySQL, MSSQL2008/2012

Operating Systems: Windows XP/Vista/7/8, MAC OS X, Linux

PROFESSIONAL EXPERIENCE:

Confidential, Pittsburgh, PA

Oracle Developer (PL/SQL)

Responsibilities:

• Implemented efficient ways to join multiple data sources with the objective of gaining insights into customer data, performing error root-cause analysis and sending reconciliation reports
• Developed the new Oracle Database objects like Complex queries, Joins, Views, and Materialized Views.
• Used Triggers to track the user profile updates and to send the messages to downstream systems.
• Designed, implemented and tuned interfaces and batch jobs using PL/SQL. Used Pragma Autonomous Transaction to avoid mutating problem in database trigger.
• Created PL/SQL scripts to extract the data from the operational database into simple flat text files using UTL FILE package.
• Receive EPS/PPR extracts from CMS and upload in DataMart. Compare data at DataMart (EPS extract) to provide dispute analysis on CMS reported files and present to HSRI along with fix for customers out of sync with UHIP system
• Created B Tree indexes, Function based indexes, Bit Mapped Indexes on Tables, columns to minimize query time and achieve better performance
• Modified and debugged several PL/SQL programs for performance tuning using techniques like EXPLAIN PLAN and DBMS PROFILER.
• Created indexes on tables to improve the performance by eliminating the full table scans and views for hiding the actual tables and to eliminate the complexity of the large queries.
• Developed several stored procedures and functions using advanced Oracle concepts such as Bulk Binds, Bulk Collects Ref Cursors to improve performance.
• Generated server-side PL/SQL scripts for data manipulation and validation and materialized views for remote instance.
• Involving in bugs raised in JIRA
• Work on three types of population list on billing system (NFP) to limit load of errors during billing dates using Python Pandas packages for data frame, reads Cvs to load files.
• Created PL/SQL tables and global variables and also using IN and OUT parameters with TYPE, ROWTYPE, PL/SQL tables and PL/SQL records.
• Collaborated with developers and performance engineers to enhance supportability and identify performance bottlenecks.

Environment: Windows, Oracle 12c, Erwin, Oracle SQL, PL/SQL, SQL Developer, Python, JIRA, SQL Server Management Studio ‘08,’14., Oracle Reports.

Confidential, Cincinnati, OH

Oracle Developer

Responsibilities:

• Created sessions, configured workflows to extract data from various sources, transformed data, and loading into data warehouse.
• Involved in full life cycle development including Design, ETL strategy, troubleshooting Reporting, and Identifying facts and dimensions.
• Database Objects Development-Tables, Views, Triggers, Stored procedures, Cursors, Functions, Packages in PLSQL and Transact SQL
• Retrieving, loading, interpreting and analyzing data. Cleaning up data for upload process and creating reports
• Responsible for Data analysis and production support for the daily data processing issues
• Created sessions, configured workflows to extract data from various sources, transformed data, and loading into data warehouse.
• Used SQL programs to analyze and create the visual representation of data responsible for creating the required objects to process claims and generating flat files for 834 ad 837 files
• Tuned the PL/SQL programs using Bulk Processing using Types responsible to debug and resolve the production issues
• Using SQL Loader, EXTERNAL Tables and BCP utility to move data between Oracle and SQL Server
• Used the External Tables to simplify the loading process of flat files to OLTP databases
• Change control management and Ticket management using the Team Foundation Server
• Testing the new developing changes in pre-prod environments and working with DBA team to deploy the changes into production

Environment: Windows, Oracle 12c, Erwin, Oracle SQL, PL/SQL, SQL Developer, Tableau, Workflow Monitor, SQL Server Management Studio ‘08,’14., SQL * Loader, Oracle Reports.

Confidential

Oracle PL/SQL Developer

Responsibilities:

• Developed Oracle SQL queries to update procedure code as per various requirements requested by the Senior Analyst.
• Responsible for supporting code deployment which is done using Jenkins
• Developed and modified triggers, packages, functions and stored procedures for data conversions and PL/SQL procedures to create database objects dynamically based on user inputs.
• Worked on PL/SQL Implicit, Explicit, and Ref Cursors and created Triggers. Enforced integrity constraints using triggers.
• Handled errors using Exception Handling extensively for the ease of debugging and displaying the error messages in the application.
• Extensively used the advanced features of PL/SQL like Records, Tables, Object types and Dynamic SQL.
• Created records, tables, collections (nested tables and arrays) for improving Query performance by reducing context switching.
• Usage of bulk inserts to insert the data into multiple tables.
• Wrote sequences for automatic generation of unique keys to support primary and foreign key constraints in data conversions.
• Used Database trigger for making history of insertion, updating, deletion and all kind of Audit routines.
• Developed Oracle database Tables, Views, Indexes, and Synonyms with proper privileges.
• Used PL/SQL to extract data from different tables with a Million records in some of the tables
• Used Bulk Collections for better performance and easy retrieval of data, by reducing context switching between SQL and PL/SQL engines.
• Wrote PLSQL and T-SQL blocks, Procedures, Functions, and Packages for Migration of flat files and to transfer in exact format in Database Tables.
• Used PLSQL tables and Bulk loader programs for processing data and loading into oracle tables.
• Wrote Unix Shell Scripts to process the files like renaming the file, extracting data from the file, unzipping the file and remove the junk characters from the file before loading them into the base tables.
• Collaborated with product management to design, build and test systems.

Environment: Windows, Oracle 10g, Erwin, Oracle SQL, PL/SQL, SQL Developer, UNIX, MS Visio, MS Access, Jenkins, SQL Server Management Studio ‘08,’14., SQL * Loader.

Confidential

Jr. Oracle Developer

Responsibilities:

• Analyzing the data needs for the customized reports. Mapping the data requirements developing Stored Procedures, Functions and Triggers.
• Performed SQL tuning using Explain Plan, Tkprof, Hints and indexes.
• Worked on developing/supporting Oracle APEX applications.
• Prepared application logic; Developed PL/SQL Packages and procedure and provided Target Load Order Dependencies.
• Developed PL/SQL Procedures, Functions, Cursors, Packages, views and Materialized views.
• Wrote Shell Scripts for Data loading and DDL Scripts.
• Used Analytical functions like RANK and DENSE RANK to assign to components having maximum portion.
• Developed PL/SQL Procedures, Functions, Cursors, Packages, views and Materialized views.
• Worked on Positions and Trades data, also on data quality changes.

Environment: Windows, Oracle 10g, Erwin, Oracle SQL, PL/SQL, SQL Developer, SQL Server Management Studio ‘08,’14., Oracle Reports.