SUMMARY

• Around 8 years of experience in Oracle, SQL, PL/SQL, T - SQL, Data Warehousing Development, and Production Support in domains such as Insurance, Healthcare, and Transportation.
• Experienced in requirement analysis, coding, and testing various modules in a software development life cycle.
• Experienced in Oracle SQL and PL/SQL including all database objects: Stored procedures, Stored functions, Packages, TYPE Objects, Triggers, Cursors, REF cursors, Parameterized cursors, Views, Materialized Views, PL/SQL collections.
• Experienced in Design, Development, Enhancement, and Maintaining applications in Oracle 8i/9i/10g/11g using SQL, PL/SQL in Windows 2000/XP/7/8 and UNIX environments.
• Detailed depth Knowledge in Oracle Architecture, Data Dictionary, and DBMS Packages.
• Substantial development experience in creating Stored Procedures, PL/SQL Packages, Triggers, and Functions. Strong knowledge in Oracle cursor management and exception handling.
• Extensive experience in Database query tuning, Performance tuning (PLAN and TKPROF utility) of reports and troubleshooting Oracle Application issues on OLTP and DSS systems.
• Experienced in designed and deployment of UNIX Shell Scripts using K-Shell.
• Expertise in handling errors using Exceptions.
• Experience on multi-tiered web application development, using Java/J2EE
• Experience of using web services, application services, and RDBMS
• Extensive experience using scheduling tools like CRON tab, Control-M, and AUTOSYS.
• Expertise in Creating SQL Loader Scripts to load data from flat files into database and exporting data to flat files using UTL FILE package.
• Hands on experience on ETL (Extract-Transform-Load) applications development and testing.
• Experienced in working with SDLC, Agile, Waterfall, and Scrum methodology.
• Experience in working with offshore team of INFORMATICA.
• Execute Quality Control checks of source code created by other developers
• Uses coding methods in specific programming languages to initiate or enhance program execution and functionality.
• Respond to errors and emergencies within applications and programs.
• Create and execute development and maintenance of the client team’s inventory collection and reporting.
• Own the development lifecycle and be responsible for managing technical risks throughout the project.
• Highly motivated, excellent team player, enthusiastic, strong initiative and quick learner of new technology.

TECHNICAL SKILLS

Operating Systems: HP UNIX, Linux, Sun Solaris and Windows NT/2000/XP/Windows 7

Programming Languages: SQL, PL/SQL, Unix Shell Scripting

Database Technologies: Oracle 11g/10g/9i/8i, DB2 and SQL server 2000

GUI: Toad and SQL Developer

Version Control Tools: VSS and Tortoise SVN,GIT

Tools: & Utilities: Informatica, Data stage, SQL*Loader, Import/Export and Data Pump

Others: Putty, corn tab, AUTOSYS, RDBMS concepts and Control-M scheduler tool

Web Technologies: HTML, CSS, JSP

PROFESSIONAL EXPERIENCE

Confidential, Tulsa, OK

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.
• Involved in migrating database from Oracle 9i to 10g database, developing screens and generating reports.
• Integrated with client to gather the requirements and implement the same in the project, along with many migrations of project’s application interfaces.
• Developed stored procedures and triggers to facilitate consistent data entry into the database. Written Stored Procedures using PL/SQL, functions, and procedures for common utilities.
• Participated in system analysis and data modeling, which included creating tables, views, indexes, synonyms, functions, procedures, cursors, and packages using TOAD.
• Created programming code using advanced concepts of Records, Collections, and Dynamic SQL.
• Used pipelined functions for faster data accessibility.
• Involved in working with IMPLICIT CURSORS, EXPLICIT CURSORS, and REF CURSORS.
• Created materialized views using different clauses like FAST, COMPLETE FORCE, and ON COMMIT.
• Used various Oracle PL/SQL collections such as VARRAYS, NESTED TABLE, and ASSOCIATIVE ARRAYS with INDEX BY VARCHAR2.
• Involved in creating various utility scripts to generate log files in UNIX using shell scripts.
• As a software engineer, worked on multi-tier Java and J2EE based applications, responsible for writing business logic using core Java and JavaBeans, SQL queries for the backend RDBMS, and user frontend using JSP, along with JavaScript libraries and HTML

Environment: Oracle 11g/10g, SQL, PL/SQL, SQL*Loader, SQL Developer, TOAD, UNIX/LINUX, Java/J2EE, Windows.

Confidential, Denver, CO

PL/SQL Developer

Responsibilities:

• Preparing project-phase plans and implementation schedule, plan and conduct meeting and workshops relative to the project plans, and communicate day to day project status to all levels of management.
• Analyze, develop and implement custom application solutions using BMC Control-M scheduling tools.
• Analyze, processes, and test batch processes from requirements specifications, and ensures that the finished product meets requirements.
• Working with Application Developers to perform analysis and recommendations on new workflows identified for scheduling.
• Deployment of Workflows in development, QA and Production Control-M Environments and assist developers in performing functional and user acceptance tests.
• Created stored procedures, functions, packages, collections, triggers, object types to implement complex business functionality. Implemented data optimization, scrubbing and manipulation of staged data using PL/SQL packages.
• Encapsulated error handling and used autonomous transaction for logging. Used UTL FILE for exporting data and UTL MAIL to generate E-mails.
• Developed the application underJ2EEarchitecture, developed Designed dynamic and browser compatible user interfaces usingJSP, Custom Tags, HTML, CSS,and JavaScript.
• Extensively used PL/SQL features like nested table, V array and Bulk collect for high performance of stored procedures.
• Involved in writing complex SQL queries (cursors, ref cursors, sub queries, correlated sub queries). Provided support for multiple business groups and managed SDLC for multiple projects to satisfy business needs.
• Created various User defined EXCEPTIONS to control the process based on the business requirement.

Environment: Oracle 11g/10g, SQL, PL/SQL, SQL*PLUS, SQL*Loader, TOAD, Control-M

Confidential, Portland, OR

PL/SQL Developer

Responsibilities:

• Extensively worked in providing updated records of the patients on weekly basis by comparing with the previously-exported patients records.
• Involved in keeping track of previously-exported patients records and archived them for future reference purpose.
• Created the custom tables to import the Patient's data and insert into the database tables.
• Developed the SQL*Loader and external table concepts to load data into the staging tables from the flat files.
• Involved in resolving the project specific code issues by discussing with offshore team.
• Created the PL/SQL packages, procedures, functions for applying the business logic to update the patients' database.
• Involved with offshore team, providing requirements for reporting, testing through informatica and Cognos.
• Created custom triggers to automatically populate different tables and also to restrict the data being inserted to the tables.
• Involved in end to end testing of the applications.
• Documented applications based on the developed operations, for better future understanding.
• Quickly learned a wide range of technology skills and business knowledge required for my projects.

Environment: Oracle 9i/10g, SQL Server, PL/SQL, SQL*Plus, SQL*Loader, External tables, Informatica, Data Pump, TOAD 10, Package, UNIX, MS Office.

Confidential, Bethesda, MD

Oracle PL/SQL Developer

Responsibilities:

• Created and modified severalUNIX shell scriptsaccording to the changing needs of the project and client requirements.
• Wrote Unix Shell scripts to process the files on daily basis like renaming the file, extracting date from the file, unzipping the file and remove the junk characters from the file before loading them into the base tables.
• Involved in production support.
• Generated server side PL/SQL scripts for data manipulation and validation and materialized views for remote instances.
• Created PL/SQLstored procedures, functions and packagesfor moving the data from staging area to data mart.
• Involved in Architect level to design schemas and developed ER diagrams for the team for better understanding.
• Createdindexes on the tables for faster retrieval of the data to enhance databaseperformance.
• Involved in data loading usingPL/SQLandSQL*Loadercalling UNIX scripts to download and manipulate files.
• Extensively usedbulk collectionin PL/SQL objects.
• UsedPragma Autonomous Transaction.
• Involved in RDBMS design and developed ER-diagrams. Participated in code walkthroughs and review sessions with the development team.
• Handled errors usingException Handlingextensively for the ease of debugging and displaying the error messages in the application.

Environment: Oracle 11g, SQL*Plus, TOAD, SQL*Loader, SQL Developer, Shell Scripts, UNIX, Windows XP

Confidential

Jr. PL/SQL Developer and Testing/Java

Responsibilities:

• Involved in the whole life cycle of the project.
• Interacted with clients to understand their requirements.
• Involved in Table design.
• Programmed Packages, stored procedures, queries, and triggers on Oracle 10g.
• Used Unit and System Testing.
• Planed and supervised the daily activities of the application support.
• Implemented Database Query tuning and implementation.
• Involved in resolving production problems for the applications and Ensure all support service level agreements are met.
• Prepared root cause analysis for problems occurred.

Environment: Oracle 10g, SQL PLUS, PL/SQL 2.3.4, TOAD, Windows XP.

Confidential

Jr. PL/SQL Server Developer/ Java

Responsibilities:

• Involved in maintaining database, handling performance issues, query optimization, locking issue, creating DTS Package and documentation.
• Developed packages, procedures, functions, and triggers for the application.
• Used UNIX environment for performing the testing.
• Performed the tests on the newly coded procedures and documented the same.
• Written technical documents using the functional specifications.
• Written PL/SQL code using the technical and functional specifications.
• Created Oracle objects like tables, types, packages, procedures and functions.
• Automated SQL loader using shell scripting.
• Made a JAVA Chat Server using JAVA and JUnit as the testing tool the product
• Developed various Customer and Network capacity flows. Developed various server side components using J2EE and TIBCO APIs.
• Automated data fetch using UNIX shell script.
• Optimized the queries to improve the performance of the application.

Environment: Oracle 8.3, SQL*Plus, TOAD, SQL*Loader, Forms 4.5 & Reports3.0 and Windows 2000 professional, UNIX shell scripting.