PROFESSIONAL SUMMARY:

• Over 8 years of experience in the development of Application Software Design and Development in Oracle Database Management Systems, production Database Support & Maintenance of Jobs in Healthcare, Retail Environments
• Designing, Coding, Testing and implementation of High Availability Distributed System.
• Proficient in 8i/9i/10g/11g Databases, SQL, PL/SQL, SQL* Loader, Shell Scripts.
• Expertise in Oracle Stored subprograms, Packaged subprograms, Cursors, Cursor Variables, Collections, Triggers, Native Dynamic SQL.
• Populating the data into Database tables from various flat files using SQL Loader.
• Very proficient in writing Stored Procedures, Standalone Functions, Nested Functions, building Packages and developing Public and Private Sub - Programs using PLSQL and very strong SQL Skills.
• Improving the Performance of the SQL Queries, Functions, Procedures, Packages and Database Objects by creating Normal, Unique and Bitmap Indexes.
• Excellent in Master Data Management with Strong RDBMS concepts with ETL Processing and well experience in creating database Tables, Views, Sequences, triggers, etc. taking the Performance and Reusability into consideration.
• Developedmaterialized viewsfor data replication in distributed environments.
• Used SQL Trace, Explain Plan and TK Prof for Better performance.
• Experience in working with UTL Files and Dynamic SQL.
• Optimal in performing Database Tuning in reducing the Cost and Cardinality of the SQL Queries by using various Hints and Optimizers on looking at the Explain Plan.
• Experience in Creating Unix Shell script to automate the FTP processes for receiving and sending the files
• Experience in UNIX Shell Scripting.
• Developed SQL Loader control programs, interfaces and PL/SQL validation scripts to transfer flat file data into oracle database and Oracle Applications base tables.
• Proficient in design, development, deployment and administration of Business Objects Universes, Web Intelligence, Desktop Intelligence.
• Extensively used Crystal Publishing Wizard, Import Wizard, Info view and Central Management Console.
• Expert in designing the Data model in Conceptual, Logical and transforming them to Physical Data model, and developing the ERD schema diagrams in Erwin.
• Expert in designing and Reverse Engineering the Relational and Dimensional Data Models for Large size OLTP and OLAP Databases using Erwin.
• Well experienced in developing the Data mart in Star Schema, Snowflake Schema and building the Data warehouse.
• Experience in handling all XML specific storage models (Unstructured, Structured - Schema Based and Binary XML-11g)
• Expertise in using PVCS (VM and Tracker) tools and also CollabNet Subversion Edge to handle the version control system.
• Expertise in using Atlassian JIRA, CRUCIBLE, FISHEYE for project tracking, teams planning and also reviewing and commenting the code base.
• Proficient in Normalizing and De-normalizing the data with respect to the Business Rules.
• Well Managed Business Process Modeling, Process Flow Modeling, Data Governance, Meta Data, Data Dictionary Maintenance and Data flow modeling.
• Hands on Experience in Oracle Discoverer, developing reports, working various components like Discoverer Administrator, Discoverer Desktop, Discoverer Plus and Discoverer Viewer.
• Experience in TSQL DDL/DML, perform most of the SQL Server Enterprise Manager and Management Studio functionality using T-SQL Scripts.
• Knowledge of other Programming languages like Java, VB .Net, C# .Net
• Experience of building and maintaining Microsoft Excel Spreadsheets, Pivot tables and Macros.
• Excellent communication and interpersonal skills.
• Versatile team player with proven problem solving skills.
• Experience in Design, Development, Implementation and support as Oracle Developer in Production, Development and Test Environments using Oracle Tools like JDeveloper and reporting services using Oracle BI tools.
• Great learning skills to adapt the rapid changing technologies and implementing the same at work.
• Strong Analytical, Inter-personnel, Problem-solving and Proven ability to work under pressure.
• Worked independently as well as in team environments and Experience in Interacting with users for business requirements.

TECHNICAL SKILLS:

Operating Systems: DOS, Windows XP/NT/Vista/7, Sun, AIX, Linux, UNIX

Languages: SQL, T-SQL, PLSQL, C, C++, COBOL, Java, C# .Net, VB .Net

Scripting Languages: JavaScript, Perl, HTML and XML

GUI s Technologies: Developer2000 (Forms 11g/10g/9i/6i, Reports 11g/10g/9i/6i), Oracle Designer 2000, Discoverer10g, Erwin, ODI, Oracle APEX

Databases: Oracle8i/9i/10g/11g/12c, SQL server 2000, Oracle XML DB, Oracle AIX, Oracle AQ, MS Access

SCM Tools: Subversion, CVS, Clear Quest, JIRA

Utilities: SQL* Plus, SQL* Loader, SQL Navigator, Toad, UTL File, ETL tools Informatica Power Center, OEM

PROFESSIONAL EXPERIENCE:

Confidential, St. Louis, MO

Sr. PL/SQL Developer

Responsibilities:

• Involved inLogical & Physical Database Layout Design.
• Involved in data loading usingPL/SQLandSQL*Loadercalling UNIX scripts to download and manipulate files.
• PerformedSQL and PL/SQL tuningand Application tuning using various tools likeEXPLAIN PLAN, SQL*TRACE, TKPROFandAUTOTRACE.
• Wrote conversion scripts usingSQL, PL/SQL, stored procedures, functionsandpackagesto migrate data from DB2 database to Oracle database.
• Extensively used the advanced features of PL/SQL likeRecords, Tables, Object typesand Dynamic SQL.
• Was a part of conversion team and have taken part actively in propose an idea to convert data from DB2 database to Oracle.
• Introduced a view related approach to convert the data.
• Created PL/SQL program units to include DDL statements using Dynamic SQL.
• Created database triggers for audit and data validation.
• UsedBulk Collectionsforbetter performanceand easy retrieval of data, by reducing context switching between SQL and PL/SQL engines.
• Createdindexes on the tables for faster retrieval of the data to enhance databaseperformance.
• Used bulk processing for better performance and easy retrieval of data, being a part of performance tuning of the procedures and packages.
• Improve the performance of the slow SQL queries by implementing indexes, using BULK LOAD, BULK COLLECT and developed various procedures, functions and packages to implement thenew business.
• UsedPragma Autonomous Transactionto avoid mutating problem in database trigger
• Was in charge of performance tuning several programs and was successful in getting the run time down for more than 90 percent.
• Used Collection objects, ref cursor, aggregate functions and Analytic functions while writing SQL Queries.
• Assisted my team lead in proposing a new way of writing the procedures and have written a set of coding standards and provided it to the team which was followed by everyone.
• Wrote Queries to retrieve data in XML format from the tables.
• Involved in creatingUNIX 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 makeDatabaseFaster and easier to maintain.
• Worked on populating the data in the DataMart Tables in Star schema, Snowflake schema, Multi star schemas, Aggregate tables and Normalized.
• Handled errors usingException Handlingextensively for the ease of debugging and displaying the error messages in the application.
• Involved in Technical Documentation, Unit test, Integration Test and writing Test plan.
• Efficiently De-normalized the data in building the DataMart’s in Star schema.
• Exporting reports into various formats like Editable RTF, XML, PDF, HTML, EXCEL, and WORD using Crystal Reports XI for user.
• Worked with Informatica to create source/target definitions, mappings and sessions to extract, transform and load data into staging tables from various sources
• Provided 24x7 supports for the production reports in troubleshooting and resolved issues.

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

Confidential, New York.

Sr. PL/SQL Developer

Responsibilities:

• Created new Schemas, Tables, Synonyms, Views, Indexes, Partitions and Sequences needed as per new requirements.
• Extensively worked on data mapping, validation, SQL loader and Control file creation, Bulk processing for loading data into Oracle database.
• Tuned the SQL queries and complex procedures to improve performance. Used EXPLAIN PLAN and Toad/SQL Navigator for tuning the queries.
• Developed various database objects like views, packages, stored procedures, triggers, functions etc. using TOAD.
• Developed SQL*Loader scripts to load the data from external flat files that are exported from SQL Server.
• Modified and optimized complex queries for data retrieval and modification.
• Involved in XML parsing and loading XML files into the database.
• Involved in using of features of Oracle 11g like Analytical functions, Flash back Query, regular expressions etc.,
• Involved in the restructuring and fine tuning of the existing SQL Queries according to the new requirement.
• Used UTL FILE package for writing DBMS OUTPUT messages to file.
• Interacting with the users and troubleshooting the problems involved with the development of stored procedures, triggers and with the privileges.
• Worked on UNIX environment and shell scripting for creating Batch Jobs using UNIX KORN, AWK UNIX Shell Scripts and API’s Using PEARL Scripts.
• Involved in providing 24/7 database production support and troubleshooting data quality and integrity issues.
• Actively involved in transforming the business requirements in to system requirement specifications and creating functional design documents.
• Writing and tuning SQL Queries, PL/SQL Stored Procedures, Functions and Triggers
• Identify deficiencies of the business application and constant data integration using Java components, SQL and PL/SQL
• Identify stakeholders need to modify the component and the database layouts (design) and to create custom database tables
• Oracle PL/SQL Functions, Procedures, Korn Shell Scripts were used for staging transformation and loading of the data from flat files to target.
• Prepared Test Plans for various functionalities developed and assisted the testers in creation of test scripts that are used in testing the Oracle stored procedures.
• Involved in Defect Prevention activities like identifying the root cause of major defects and raise change requests in HP Quality Center.
• Worked on requirement analysis for Change requests and fixed the defects raised by the user community and other stakeholders.
• Carried out extensive Unit testing and Integration testing of the system and created Unit Test Plan (UTP) and Unit Test Results (UTR) documents.
• Detected and corrected bugs during system integration and User Acceptance Testing (UAT).

Environment: Oracle Database 9i/11g, Oracle Forms 6i/11g, Oracle Reports 10g, SQL, PL/SQL, SQL*Plus, SQL*Loader, .Net, DTS, TOAD, Clear Case, VSS, UNIX.

Confidential

Sr. Oracle Developer

Responsibilities:

• Reviewed the Business/ Functional/ System Requirement Specs, High Level Design Documents, and Detailed Design Documents.
• Worked with Business Analysts and Business Objects team to understand the requirements and translate the requirement into technical specifications.
• Developed officer profile module using Stored Procedures, Functions, Packages, Triggers, Tables, synonyms, Materialized Views, sequences, indexes which is compatible with the .NET Application.
• Experience in application development using various features of Oracle like Bulk Collections, Table Functions, Autonomous Transactions, Dynamic SQL, Object types, Records and External tables.
• Created Cursors and Ref Cursors in the PL/SQL Blocks.
• Validated and loaded data into Oracle Database using DB links and external tables from CSV files.
• Autosys job scheduling- created the jil scripts and UNIX shell scripts to automate the jobs scheduling
• Created batch jobs in regular maintenance, production support to load the data using UNIX shell scripting
• Designed and Developed scripts for uploading data from flat files and XML files into database, performing business validations on the data using PL/SQL Procedures.
• Improve the performance of the slow SQL queries by implementing indexes, using BULK LOAD, BULK COLLECT and developed various procedures, functions and packages to implement thenew business.
• Created database triggers for audit and data validation.
• Worked as a release coordinator, raised Work Requests and Change Requests and also deployment of code in various environments.
• Involved in Unit testing and System Integration testing for PL/ SQLStored Procedures andFunctions.
• 24/7 production support and involved in implementation of coding standards and Data Base change requests.
• Used SVN for version controlling and ALM (Application Lifecycle Management) for ticketing system.
• Involved in creating ETL model (snowflake schema), normalizing and documenting.
• Worked with Informatica to create source/target definitions, mappings and sessions to extract, transform and load data into staging tables from various sources.

Environment: Oracle Database 11g, Windows 7, UNIX, Toad, XML, SQL, PLSQL, UNIX Scripting, SVN, ALM, PAC2000, WinSCP, Putty.

Confidential, Houston, TX.

Sr. PL/SQL Developer

Responsibilities:

• Analyzed the business requirements of the project by studying the Business Requirement Specification document and prepared data dictionary document.
• Created different schemas and maintained schema objects.
• Creation of new packages and modification of existing codes to resolve application bugs.
• Developed PL/SQL Procedures and database triggers for the validation of input data and to implement business rules.
• Created database objects like packages, procedures, and functions according to the client requirement.
• Created scripts to create new tables, views, queries for new enhancement in the application using TOAD.
• Createdindexes on the tables for faster retrieval of the data to enhance databaseperformance.
• DevelopedPL/SQL triggersandmaster tablesfor automatic creation of primary keys.
• Created PL/SQLstored procedures, functions and packagesfor moving the data from staging area to data mart.
• Created and modified several UNIX shell Scripts according to the changing needs of the project and client requirements.
• Generated server side PL/SQL scripts for data manipulation and validation and materialized views for remote instances.
• Tuned procedures/SQL queries for maximum efficiency in various databases usingOracle Hints, for Rule based optimization.
• Partitionedthe fact tables andmaterialized viewsto enhance the performance.
• UsedBulk Collectionsforbetter performanceand easy retrieval of data, by reducing context switching between SQL and PL/SQL engines.
• Used bulk processing for better performance and easy retrieval of data, being a part of performance tuning of the procedures and packages.
• Extensively used Cursors, REF cursors, User-defined object types, Records, in PL/SQL programming.
• Used advanced queuing concept to dequeue the exceptions raised during the cron job execution which will be notified by mail using UTL MAIL package and enqueue it into main table for error reprocessing.
• Created and modified several UNIX shell Scripts according to the changing needs of the project and client requirements.
• Created indexes on the tables for faster retrieval of the data to enhance database performance
• Used hints in select statement for improving the performance.
• Performed SQL and PL/SQL tuning and Application tuning using various tools like Explain Plan, TKPROF, Autotrace and DBMS APPLICATION INFO.
• Involved in fine tuning the existing packages for better performance and providing on-going support to existing applications and troubleshooting errors when occurred.

Environment: Oracle 11g/10g, SQL*Loader, SQL, PL/SQL, SQL developer, UNIX, Windows 7, Golden Gate, SQL Plus.

Confidential

PL/SQL Developer

Responsibilities:

• Developed interface to load Invoice data into Account Payables. Developed validations programs to load the data into AP INVOICE INTERFACE, AP INVOICE LINES INTERFACE.
• Data was loaded into temporary table from flat file and then into AP INVOICE INTERFACE andAP INVOICE LINES INTERFACE tables. Worked with the Business users in Vendor reconciliation process between Great Plains system and Oracle System.
• Wrote SQL scripts to insert the vendor data into PO VENDOS ALL, PO VENDOR SITES ALL, PO VENDOR CONTACTS.
• Wrote SQL scripts to create temporary tables and developed SQL*Loader Control files to load the data into the temporary tables.
• Data was loaded into temporary table from a flat file and then into RA INTERFACE SALESCREDITS ALL and RA INTERFACE LINES ALL tables.
• Customized and developed reports as per client's requirements using Reports 6i and PL/SQL and registered them with APPS.
• Involved in analyzing business requirements and designing the functional specifications and also translated functional requirements into technical specs.
• Extensive experience in developing efficient PL/SQL code for OLTP environment and ETL code for the Data Warehouse environment.
• Used SQL*Loader to upload data into the staging files from flat files.
• Wrote high performance queries/programs using Collections, Bulk Binds, Objects, Nested tables, REF Cursors, pipeline functions etc.
• Used UTL FILE built-in package to generate files as per the requirement.
• Wrote complex in-line views which summarized the business needs to the fullest.
• Wrote complex SQL queries, Control files, Procedures, Triggers and PL/SQL Packages used for data validations, error handling and data cleansing activities.
• Used Shell Scripts for day-to-day use of queries on Data Dictionary and other common tasks on UNIX.

Environment: Oracle 9i/10g, SQL, PL/SQL, SQL*Loader, TOAD, Forms and Reports 9i, MS Visio, UNIX and WinNT.

Confidential

Oracle PL/SQL Developer

Responsibilities:

• Creation of Technical and Detailed Level Design Documents.
• Requirement/Data Gathering and Analysis.
• Creation of Oracle Packages, Views, Triggers, PLSQL Collections.
• Extensively worked in Oracle SQL, PL/SQL, SQLPLUS, Query performance tuning, Created DDL scripts, Created database objects like Tables, Indexes, Synonyms, Sequences, stored procedures etc., and involved Data Import/Export, Closely worked with DBAs to improve performance.
• Worked on Oracle SQL Developer.
• Performance tuning of SQL queries and PLSQL Code.
• Defined the executable, concurrent program and schedule the process to run automatically using AOL.
• Extensively used SQL*LOADER to upload data into interface tables to run order import program to load data into oracle order management base tables
• Involved in writing complex queries to generate ad-hoc reports as well as ad-hoc DBA activities like data migration, ETL, replication per client request as a part of production
• Tuning the performance of SQL statements using HINTS and using TKPROF utility & Explain Plan Table
• Used Materialized view to create a Monthly Snapshot from the Filed Reporting.
• Involved in writing complex procedures using Oracle 9i features like Bulk collect, FORALL loop, Collection Type, Object Type & Autonomous transactions
• Involved in the creation of Database Objects to Oracle database, by using Erwin, Wrote UNIX SHELL scripts to automate Oracle ETL jobs.
• Used reports triggers before parameter form and after parameter form
• Debugging and testing of procedures and packages developed for the customized forms and reports
• Experience in using Oracle Workflow and supporting applications using Workflow and e-business applications as well.
• Involved in the creation of Database Objects to Oracle database, by using Erwin, TOAD & Procedure Builder applications.
• Developed Reports to extract the monthly sales information
• Used import/ export utility to backup daily development jobs.
• Used SQL Loader in Oracle for bulk Data Loading using direct path & Conventional Path.
• Creating Unix Shell script to automate the FTP process for receiving and sending the files from many data vendors like IMS, WKH (NDC), VA, Milliman, Pharmarica etc.
• Creating Auto-sys UNIX/TDP job to schedule the jobs to be run the given time and completion of the dependent jobs Creating Operation support documentation.
• Provided quality assurance for all the modules developed.
• Provided technical support to the user with regard to operational aspects

Environment: Oracle 9i, Reports 6i, Oracle 10g, UNIX, XML, ETL, PL/SQL, TOAD 8.6.1, SQL*Loader, SQL Server, PL/SQL, AWR, SQL, SQL*PLUS, SQL*Loader.

Confidential

PL/SQL Developer

Responsibilities:

• Performed review of the business process, involved in Requirements Analysis, System Design Documents, Flows, Test Plan preparations and Development of Business Process / Work Flow charts.
• Developed PL/SQL procedures, customizing existing programs according to the needs of the client testing.
• Wrote PL/SQL packages consisting of procedures and functions.
• Created Materialized Views, Triggers, Sequences, collections.
• Involved in development and testing of oracle back-end objects like database triggers, stored procedures, Sequences and Synonyms.
• Worked with tuning the complex Stored Procedures for faster execution using bulk collections and Dbms profiler.
• Involved in design, development and Modification of PL/SQL stored procedures,
• Functions, packages and triggers to implement business rules into the application.
• Extensively used cursors for fetching the rows.
• Loading data through SQL Loader and UTL FILE.
• Involved in tuning the SQL queries create database objects and optimally set storage parameters for tables and indexes.
• Designed reports using Reports as per user requirements. Created and Master/Detail tables to store information. Tested forms and reports using test data.
• Developed complex triggers in reports before/after for validation of user input.
• Designed and developed user interfaces using Oracle Forms.
• Wrote Shell scripts to insert data to database tables. Wrote PL/SQL code to retrieve data for master and detail blocks.
• Customized forms and reports as per user requirements using Oracle Developer Forms & Reports.
• Interacted with clients in remote locations to verify customer requirements.

Environment: Oracle 9i, SQL, PL/SQL, SQL*Plus, Forms 6i, Reports 6i, Windows, UNIX.