SUMMARY

• 8+ years of IT Experience as Lead Oracle Developer for System Analysis, Designing, Testing Development & Support of Oracle 8g,9i, 10g & 11g in Production, Staging, Development environments.
• Experience in financial, retail and telecom domain.
• Experience in writing/debugging Oracle SQL PL/SQL code i.e. Packages, Stored Procedures,
• Expert in creating SQL Queries, PL/SQL package, function, stored procedure, anonymous block, triggers, and cursors.
• Created database objects like tables, views, sequences, synonyms, indexes using Oracle tools like SQL*Plus, SQL Developer and Toad.
• Experience in developing various Unix/LINUX Shell Scripts to manipulate data files, set - up environment variables, custom FTP utility, file archiving.
• 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.
• 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.
• Good communication, interpersonal and managerial skills, team player with positive attitude and self-motivated to work independently and in team as well.

TECHNICAL SKILLS

Backend Oracle: 11g/10g/9i Database Enterprise Edition, Oracle 10g/9i Application Server

Frontend Oracle: Developer Suite 10g/9i/2000, SQL * Loader, SQL * Plus, 6i, XML, Oracle XE 10g/11g

Programming: ORACLE PL/SQL 10g/9i/8.0, UNIX K-Shell Scripting, C,C++, JAVA, J2EE, Servlets, Java Script, Visual Basic, COBOL

RDBMS: Oracle 9i/10g/11g, MS Access 2000/2002, MS-SQL Server 2005/2000/7.0/6.5

Third Party Tools: PL/SQL Developer, TOAD 8.6/7.5/7.0, Putty, Workflows, ERWin, Informatica 8.6/9.5.1

Operating System: Windows 98/2000/XP/NT, UNIX (SunOS 5.7, Solaris 8, HP-UX), Red hat Linux 3.0/4.0

Others: XML, HTML, SVN, Microsoft Visual Source Safe (VSS), IBM Rational Clear Case and Clear Quest, Caliber, CVS, Eclipse, Quality Center, Dimensions

PROFESSIONAL EXPERIENCE

Confidential, Dallas, TX

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, Anonymous blocks, Packages, DB triggers, Indexes.
• Experience in writing/debugging Oracle SQL PL/SQL code i.e. Packages, Stored Procedures, Functions, Anonymous blocks, Triggers, Cursors, Constraints, Indexes, Views, Materialized Views, Database Links, and Sequences.
• Knowledge in Shell scripting to automate system administration jobs as per the customer request and applying the changes after creating a change control and getting the approval according to customer requirements.
• Extensively used DTS package in Migration of the data from the previous timesheet database in SQL Server database to Oracle 11g.
• Developed LINUX/UNIX shell scripts with embedded SQL Loader and PL/SQL statements to extract data from the legacy application in the form of flat files.
• Involved in writing several Queries and Procedures.
• Participated in change and code reviews to understand the testing needs of the change components.
• Worked on troubleshooting defects in timely manner.
• Designed and developed the following custom reports as per the client requirement
• 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.
• Experience in developing various Unix Shell Scripts to manipulate data files, set-up environment variables, custom FTP utility, file archiving.
• 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.
• Used Perl Scripting in moving the files faster to the Archive folders.
• Worked with several tools to access and perform several operations on database.
• Experience in Generating Reports.
• Involved in creating LINUX/UNIX shell Scripting. Defragmentation of tables, partitioning, compressing and indexes for improved performance and efficiency. Involved in table redesigning with implementation of Partitions Table and Partition Indexes to make Database Faster and easier to maintain.
• Involved in the continuous enhancements and fixing of production problems. Designed, implemented and tuned interfaces and batch jobs using PL/SQL Involved in data replication and high availability design scenarios with Oracle Streams. Developed LINUX/UNIX Shell scripts to automate repetitive database processes.
• 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: Oracle 9i/10g/11g, SQL, PL/SQL, Toad, SQL*Loader, SQL Navigator, Caliber, CVS, Eclipse, Quality Center, Dimensions, LINUX, UNIX, Windows 2000 server

Confidential, Irving, TX

Responsibilities:

• Involved in SDLC gathering requirements from end users.
• Developed views to facilitate easy interface implementation and enforce security on critical customer information.
• Involved in full development cycle of Planning, Analysis, Design, Development, Testing and Implementation.
• 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.
• Participated in change and code reviews to understand the testing needs of the change components.
• Worked on troubleshooting defects in timely manner.
• Was actively involved in constant site enhancements along with developers - code and data push between different servers and testing and moving to production.
• 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.
• Involved in creating LINUX/UNIX shell Scripting. Defragmentation of tables, partitioning, compressing and indexes for improved performance and efficiency. Involved in table redesigning with implementation of Partitions Table and Partition Indexes to make Database Faster and easier to maintain.
• Extensively involved in SQL tuning, troubleshooting, debugging and fixing the codes/scripts.
• Writing validation packages using PL/SQL package.
• Used Perl Scripting in moving the files faster to the Archive folders.
• 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 10g to 11g database.

Environment: Oracle 9i/10g, SQL, PL/SQL, Red hat Linux 2.1/3.0, Windows 2000 server, TOAD, SQL LOADER, ETL, EXPORT, IMPORTc 2011

Confidential, Bentonville, AR

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 LINUX 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,11g SQL Server, PL/SQL, SQL*Plus, SQL*Loader, TOAD 10, FTP, DTS package, MS- Office, UNIX (Putty), Perl Scripts, MS Office, MS Visio.

Confidential, Irving, TX

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.

Confidential

Responsibilities:

• Developing packages, procedures, functions, anonymous blocks 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.