SUMMARY

• Over 7+ years of experience in Software development using Oracle Technologies that includes Complete System Development Life Cycle from Analysis and Design to Implementation inHealthcare, Banking & Finance domain.
• Expert level skills as an Oracle backend developer including PL/SQL and SQL coding, stored procedures, packages, functions, cursors, triggers, constraints, DDL, complex queries, Records and Collections.
• Strong conceptual knowledge and experience in developing Oracle Forms and Reports.
• Experience in Data Loading, Data Migration, Data Modeling, Data Mapping, Analysis, Design and Implementation.
• Expertise in Unit Testing and Integration Testing of the application.
• Experience in creating Forms and Reports using Oracle APEX 5.0.
• Sound working knowledge and experience in UNIX shell scripting.
• Sound working knowledge on Web servers including Oracle Web application Server and IBM WebSphere application server.
• Experience in using TOAD, SQL Developer, SQL*Plus, SQL Loader, Import/Export, Oracle APEX and XML Publishing utility.
• Experience in using Cursors, Ref cursors, Nested Tables, Associative arrays, Aggregate functions, Analytical Functions, Regular Expression, Dynamic SQL, Exception Handling, built in Oracle Packages, Materialized views and Views.
• Extensive experience in enterprise data warehousing, design of extraction, transformation and load (ETL) environment.
• Hands on knowledge on SQL Server 2005, 2008 R2, 2012 management studio.
• Knowledge on Business Intelligence in SSIS, SSAS and SSRS reporting tools.
• Good understanding and working experience in Java Scripting language, HTML, CSS.
• Experience in query optimization, performance and tuning (PL/SQL) using SQL Trace, TKPROF, Explain Plan, Indexing, Hints, Bulk Binds and Bulk Collect.
• Worked on production support for more than 2 years, receiving production calls on trouble reports from Client.
• Experience with Software Development Life Cycle (SDLC) like Agile, RAD and Waterfall with good working knowledge, disciplines, tasks, resources and scheduling.
• Excellent Communication Skills and a recognized team player with strong project leadership and time management capabilities.

TECHNICAL SKILLS

Operating Systems: Windows, UNIX, Linux.

Database: Oracle 12c, 11g /10g/9i, MS Access, SQL Server 2005/2000

Programming languages: SQL, PL/SQL Programming, Java Script, XML.

Database Tools: Toad, SQL Developer, SQL*PLUS, SQL*Loader, Oracle Forms and Reports 6i/9i/10g, Import, Export utility, Oracle APEX, XML/BI Publisher, Erwin, Data Pump, SSMS, SSIS, SSAS, SSRS.

Web Technologies: HTML, CSS.

Script Languages: UNIX Shell Scripting.

PROFESSIONAL EXPERIENCE

Confidential, Washington, DC

Oracle PL/SQL Developer

Responsibilities:

• Involved in all phases of application analysis, design with client, users, and financial experts in gathering the requirements.
• Worked on Data Migration from legacy system to Oracle 11g.
• Supported in the design and development of Web Portals for enrollment and billing services to the customers using Java Script.
• Implemented PL/SQL procedures to read data from external tables, flat files and transfer to Oracle database tables using SQL* Loader.
• As part of user’s request, created and modified database objects like packages, procedures, and functions according to the client requirement.
• Introducing new Stored Procedures and Indexes for better performance.
• Analyzed and developed various Forms using Oracle Forms 10g.
• Involved in development of custom reports using Reports 10g.
• Performed Unit testing and System Integration testing by developing and documenting test cases in quality center.
• Used TOAD, PL/SQL developer tools for faster application design and developments.
• Created records, tables, collections for improving performance by reducing context switching.
• Created number of database triggers according to business rules using PL/SQL.
• Wrote complex SQL queries including inline queries and sub queries for faster data retrieval from multiple tables.
• Modified several UNIX Shell Scripts according to the changing needs of the project and client requirements.
• Used Exception Handling extensively for the ease of debugging and displaying the error messages in the application.
• Provided ongoing support and improvement, batch monitoring and performance tuning.

Environment: Oracle 11g, Oracle Forms and Reports 10g, ERP, TOAD 11.5/12.6, Windows 7, SQL*PLUS, SQL*LOADER, UNIX, MySQL.

Confidential, Portland, Oregon

Oracle PL/SQL Developer

Responsibilities:

• Actively involved in interacting with front end users and gathered user requirement.
• Involved in creating procedures, functions, packages and triggers to facilitate functionality in different modules.
• Created audit tables and implemented complex business logic using triggers.
• Used cursors, for cursors and Ref Cursor (dynamic SQL) for fetching data and processing it.
• Involved in development of interactive Forms using Oracle Forms Builder.
• Wrote SQL code for publishing data from source to target using DB links, Regular Expressions, Ref Cursors, Joins and Sub queries.
• Worked onXMLalong with PL/SQL to develop and modify web forms.
• Used bulk processing for better performance and easy retrieval of data, being a part of performance tuning of the procedures and packages.
• Involved in preparing test plans, unit testing, System integration testing, implementation and maintenance.
• Involved in ETL Development using native Oracle tools (SQL*LOADER, Oracle PL/SQL) to load data from external tables and flat files.
• Extensively used the advanced features of PL/SQL like Records, Tables, Object types and Dynamic SQL.
• Handled errors using Exception Handling extensively for the ease of debugging and displaying the error messages in the application.
• Worked on requirement analysis, coding and testing various modules in a software development life cycle.

Environment: Oracle11g, Oracle Forms 10g, SQL, ERP, PL/SQL, SQL*Loader, SQL*plus, TOAD, UNIX, XML Publisher.

Confidential, KY

Oracle PL/SQL Developer

Responsibilities:

• Participating in requirement meetings and design walk through to understand the business requirements.
• Interacted with the Systems Analyst / Business Analyst of the project for any clarifications required in the requirements.
• Coded and debugged the stored Procedures, Packages and Views in Oracle Databases using SQL and PL/SQL.
• Conducting peer review for the scope items developed by team members.
• Developing of PL/SQL packages, stored procedures and functions for the project as per the requirements for packages based EDI transactions.
• Extracting Non - relational data from web services, applications into Relational Database form.
• Created data models and mappings, wrote underlying Oracle SQL code (containing views, analytical functions, Regular Expressions, sub queries, joins, dB links) to publish data from source to target.
• Supported for developing and analyzing Forms and Reports using Oracle Forms and Reports 6i.
• Performed import and export of schemas, objects using data pump utility in 11g.
• Involved in query and performance tuning.
• Modifying the UNIX shell scripts for the batch jobs for the projects.
• Written shell scripts to load data into various subsystems using SQL Loader.
• Unit testing of the modules of the project.
• Summarized/detailed report of data from the database.
• Providing production support to the project, by performing SQL and PL/SQL tuning and application tuning using various tools like EXPLAIN PLAN and SQL*TRACE.

Environment: Windows XP, Oracle 11g, Oracle Forms and Reports 6i, SQL Developer, SQL*TRACE, EDI, ETL, UNIX, XML.

Confidential, KY

Oracle PL/SQL Developer

Responsibilities:

• Involved in database development by creating different schema objects like Tables, Views, Cursors and different types of Indexes and Clusters.
• Created different types of Sub-queries and used Loop structures.
• Analyzed and developed Forms using Form builder
• Used Oracle inbuilt function like Aggregate functions, Single row- Multiple row functions.
• Maintained the Data Integrity and Security using Integrity Constraints and Database triggers.
• Created control files and used SQL* Loader to upload bulk of data and also data from external tables, text files into oracle database tables.
• Involved in Tuning and Performance
• Interacted with end users to in corporate any changes in requirement.
• Developed PL/SQLtriggers and master tables for automatic creation of primary keys.
• Involved in Requirement Gathering, High Level Design, Low Level Design, Development, Unit testing & Integration Testing.
• Report the project status and generate milestone reports.
• Communicate withdevelopers, database administrators, project managers, Systems analysts and senior management about the issues that impact the project success.
• Extensively used the advanced features of PL/SQLlike Records, Tables, Object types and DynamicSQL.

Environment: SQL, PL/SQL, Oracle 10g, Oracle Forms 6i, ETL, SQL* Loader, SQL script, ODI

Confidential -St. Louis, MO

Oracle PL/SQL Developer

Responsibilities:

• Created custom functions, stored procedures, database triggers and packages using Oracle ref cursors to retrieve, validate and process the data.
• Utilized Oracle Tuning, cursors and cursor for loops to fetch the data faster and effectively from different tables extensively.
• Experienced in participating in walkthroughs, Iteration design, problem resolution and error handling.
• Supported Oracle EBS units and resolved technical programming problems.
• Wrote technical design and functionality documents.
• Effectively involved in understanding and creating data flow, technical flow diagrams and data marts.
• Wrote Unix Shell Scripts and SQL*Loader Scripts to load flat data into the Oracle Tables.
• Client interaction through meetings & presentations.
• Involved in developing various Procedure, Functions and the PL/SQL Libraries to support the GUI application and EDI transactions.
• Worked on XML along with PL/SQL to develop and modify web forms.
• Involved in the production support by implementing various tuning techniques.

Environment: Oracle 10g, DB2, SQL Server, SQL*Loader, ETL, PL/SQL, UNIX, GUI, EDI, Erwin, OMWB, Java applets, OBIEE

Confidential, Chicago

PL/SQL Consultant

Responsibilities:

• Worked on low-level system design Using Case diagrams, Sequence Diagrams and Rational Rose.
• Responsible for developing stored procedures on back end using Oracle PL/SQL.
• Responsible for unit testing and system integration testing of the application.
• Involved in production bug fixing and maintenances using clarify tool.
• Responsible for production support and maintenance (24/7).
• Responsible for analysis and documentation.
• Responsible for assigning tasks to offshore team and coordinating with the project managers.
• Interacting with business users to analyze the business process and requirements and transforming requirements into Conceptual, logical and Physical Data Models, designing database, documenting and rolling out the deliverables.
• Used Exception Handling extensively for the ease of debugging and displaying the error messages in the application.
• Created and modified several UNIX Shell Scripts according to the changing needs of the project and client requirements.

Environment: Oracle PL/SQL Developer, SQL*Plus, ETL, Oracle 10g.