SUMMARY:

• 7 years of IT Experience as Oracle Developer for System Analysis, Designing, Testing Development Support of Oracle 8i, 9i, 10g 11g in Production, Staging, Development environments.
• Experience in financial, retail and telecom domain.
• Expert in creating SQL Queries, PL/SQL package, function, stored procedure, triggers, and cursors.
• Created database objects like tables, views, sequences, synonyms, indexes using Oracle tools like SQL Plus , SQL Developer and Toad.
• Enforced data integrity using integrity constraint and database triggers.
• Proficient in advance features of Oracle 11g for PL/SQL programming like Using Records and Collections, Bulk Bind, Ref. Cursors, Nested tables and Dynamic SQL.
• Experience in SQL and PL/SQL tuning and query optimization tools like SQL Trace, Explain Plan, and DBMS PROFILER.
• Strong knowledge in Oracle utilities like SQL Loader, Export/Import and data pump utilities like EXPDP/IMPDP.
• Extensively used package like DBMS STATS, UTL FILE, DBMS SCHEDULER and UTL SMTP.
• Strong knowledge with PL/SQL Wrapper to protect the PL/SQL procedures or packages. Extensively used Cubes Rollups for making cross tabular reports. Strong knowledge of Star Schema, Snow Flake Schema, Dimension and Fact table.
• Expertise in handling errors using Exceptions.
• Making structural changes to the database objects.
• Transferred data using data transfer tools like FTP File Transfer Protocol and SFTP Smart FTP .
• Exposure knowledge of designing logical physical Data Model in Relational Database Management System RDBMS .
• Experience in working high-transacted OLTP systems.
• Extensive experience with all phases of the Software Development Life Cycle including analysis, Resource Planning, code development, testing, implementing and maintenance.
• Documentation of projects for Functional Requirement Spec FRS , Use case Spec, ER-Diagram, Test Plan, and Test Script Test Cases.
• Have worked in fast paced AGILE environment attended daily scrum meeting.
• Assisted QA Teams for bug testing, User Acceptance Testing UAT System Integration Testing.
• Highly motivated, excellent team player, enthusiastic, strong initiative and quick learner of new technologies.
• Strong interpersonal and communication skills in dealing with customers.

TECHNICAL SKILLS:

PROFESSIONAL SUMMARY:

Confidential

Role: Oracle Dev

Responsibilities:

• Participated in Designing databases schemas to ensure that the relationship between data is guided by tightly bound Key constraints.
• Involved in Business Requirements, System analysis and Design of the Data warehouse application.
• Data Analysis primarily Identifying Data Sets, Source Data, Source Meta Data, Data Definitions and Data Formats.
• Designed Physical and Logical Data model and Data flow diagrams.
• Involved in the creation of database objects like Tables, Views, Stored Procedures, Functions, Packages, DB triggers, Indexes.
• Worked on various tables to create Indexes to improve query performance. Also worked on partitioning large Tables using Range Partitioning, creating Index Organized Table, Rollback Tablespace.
• Involved in writing several Queries and Procedures.
• Built database objects like Tables and Views.
• Involved in the Database Design Relational and Dimensional models using ERwin.
• Defined both logical views and physical data structure using ERwin.
• Converted all Oracle ETL Packages to Informatica Mappings and created workflows/Sessions.
• Developed Informatica Mappings using various Transformations and PL/SQL Packages to extract, transformation and loading of data.
• Filtered and Loaded data from different formats of data sources into Database Tables.
• Extracted required data from the database tables and exported the data to different sources in different formats.
• Worked with several tools to access and perform several operations on database. Experience in Generating Reports.
• Developed Data entry, query and reports request screens and tuned the SQL queries. Used joins, indexes effectively in where clauses for Query optimization.
• Assisted in gathering requirements by performing system analysis of the requirements with the technology teams. Environment: Toad, SQL Plus, SQL Loader, Oracle 10g, MS SQL Server, Informatica 8.5, ERwin, Windows XP, UNIX. Edward Jones Financial Corporation TEMPE, AZ Jan 2010 Aug 2012

Confidential

Role: Oracle PL/SQL Dev

Responsibilities:

• Involved in SDLC gathering requirements from end users. Developed views to facilitate easy interface implementation and enforce security on critical customer information.
• Developed stored procedures and triggers to facilitate consistent data entry into the database.
• Written Stored Procedures using PL/SQL and functions and procedure for common utilities.
• Participated in system analysis and data modeling, which included creating tables, views, indexes, synonyms, triggers, functions, procedures, cursors and packages.
• Created programming code using advanced concepts of Records, Collections, and Dynamic SQL.
• Developed Database Triggers for audit and validation purpose. Used pipelined functions for faster data accessibility.
• Writing validation packages using PL/SQL package.
• Used PL/SQL to validate data and to populate billing tables.
• Used advanced Bulk techniques FOR ALL, BULK COLLECT to improve performance.
• Developed Installation scripts for all the deliverables.
• Performed functional testing for the procedures and packages.
• Created and manipulated stored procedures, functions, packages and triggers using TOAD.
• Wrote heavy stored procedures using dynamic SQL to populate data into temp tables from fact and dimensional tables for reporting purpose.
• Involved in migrating database from oracle 9i to 10g database. Environment: Oracle 9i/10g, SQL, PL/SQL, Toad, SQL Loader, SQL Navigator, Caliber, CVS, Eclipse, Quality Center, Dimensions, Windows 2000 server.

Confidential

Role: PL/ SQL Dev

Responsibilities:

• Analyzed data to check for Data Integrity and Referential Integrity when loaded to source-staging tables.
• Created tables to capture errors and data that failed Validation Checks.
• Re-validated corrected data from source and re-processed to get them loaded to the oracle target.
• Re-worked on the BAD Files that were generated by SQL Loader. Used SED and AWK in UNIX Shell scripting to correct the data issues in the SQL-Loader data file.
• Responsible to write scripts which identify the legacy data and the valid data.
• Created Database Objects such as Tables, Views and Synonyms to provide data access to subscribing parties.
• Created/modified various Packages, Stored Procedure Functions as part of the data validation and cleansing process.
• Pro-actively participated in SQL tuning, Used ANALYZE, DBMS STATS, EXPLAIN PLAN, SQL TRACE and TKPROF.
• Used SQL hints and Indexes as needed to improve SQL performance.
• Designed and Created Database objects and Written PL/SQL PROGRAMMING for data extraction and transformation.
• Wrote UNIX Shell scripts for performing development and DBA activities.
• Tested the ETL process in testing environment and created test cases. Environment: Oracle 9i/10g, SQL, PL/SQL, Redhat Linux 2.1/3.0, Windows 2000 server, TOAD, SQL LOADER, ETL, EXPORT, IMPORT.

Confidential

Role: Oracle Pl/SQL Dev

Responsibilities:

• Gathered the Requirement from the business user and prepared the program specification and design document for the development of the CEMR Application.
• Completely involved in migrating data to Epic applications in a text file format and transferring the data onto the FTP Server which is accessible to the interface team.
• Involved in analyzing the root cause for the missing data and providing the missing data from the Extracts for Testing.
• Extensively worked in providing updated records of the patients on weekly basis by comparing the with the previously-Exported patients records.
• Involved in keeping track of previously-Exported patients and archived them for future reference purpose.
• Created the PL/SQL packages, procedures, functions applying the business logic to update the patients' database.
• Created custom triggers to automatically populate different tables and also to restrict the data being inserted to the timesheet tables.
• Design and developed the scripts to create table, views, indexes and sequence.
• Created the custom tables to import the Patient's data and insert into the database tables.
• Developed the SQL Loader scripts to load data into the staging tables from the flat files
• Extensively used DTS package in Migration of the data from the previous timesheet database in SQL Server database to Oracle 10g.
• Extensively involved in tuning the queries and applying hints for faster and better performance of the SQL queries.
• Used Perl Scripting in moving the files faster to the Archive folders.
• Used FTP to transfer the files into different servers as per needed by the business users.
• Involved in preparing BRD, functional document, user document, process flow diagram and flow charts.
• Created the test scripts and complex queries to test the application and to quality assurance of the data.
• Involved in preparing test plans, unit testing, System integration testing, implementation and maintenance.

Environment: Oracle 9i/10g, SQL Server, PL/SQL, SQL Plus, SQL Loader, TOAD 10, FTP, DTS package, MS- Office, UNIX Putty , Perl Scripts, MS Office, MS Visio. NRB Nepal

Confidential

Role: Oracle PL/SQL Dev

Responsibilities:

• Developing packages, procedures, functions, and triggers for the application.
• Using UNIX environment for performing the testing.
• Performing the tests on the newly coded procedures and documenting the same.
• Writing technical documents using the functional specifications.
• Writing PL/SQL code using the technical and functional specifications.
• Creating Oracle objects like tables, types, packages, procedures and functions.
• Automated sqlldr using shell scripting.
• 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.