SUMMARY

• Oracle Certified Associate (OCA) with over NINE years of IT experience as an Oracle Developer on a variety of UNIX (Solaris, Linux and AIX), Windows platforms with Oracle 8i/9i/10g/11g.
• Involved in all phases of SDLC
• Experience in Agile software development methodology and collaboration between self - organizing cross-functional teams
• Good knowledge in Oracle Server Architecture and basic DBA activities
• Data loading from heterogeneous databases and flat files into Oracle Database using SQL*LOADER, SSIS and External tables
• Experience with exporting and importing data to and from a database using the exp/imp utility in Oracle 9i
• Using isql utility to connect and extract data from SQL Server 2005 Database
• Have good experience in writing PL/SQL scripts for the database objects like tables, views, procedures, functions, packages, database triggers, indexes, function based index and sequences
• Expertise in trapping, raising and handling errors using Exceptions
• Good knowledge of creating cursors and REF cursors
• Experience in creating Materialized Views in data warehousing environment
• Experience with creating and using Global Temporary tables
• Good knowledge of Creating Public Synonyms and DBLinks
• Working knowledge of Nested tables, PL/SQL tables and varrays
• Proficient in SQL, PL/SQL, Query/application tuning using optimizer hints, Explain plan, SQL trace, TKPROF and dbms profiler
• Experienced in designing, developing, scheduling and monitoring UNIX shell scripts for automation
• Extensive use of Crontab in UNIX environment for scheduling routine tasks
• Maintenance and modification of Shell scripts
• Used python scripting to process Images and load them into Oracle DB
• Knowledge of logical data modeling using ERD and UML
• Good knowledge of STAR schema and SNOWFLAKE schema in warehouse environment
• Experience in database application development using SQL Plus, TOAD, SQL Developer and PL/SQL Developer
• Good experience working with various FTP protocols like FTP, SCP using SSH protocol
• Creating interface, scenario and load plans in Oracle Data Integrator (ODI)
• Knowledge of Relational Database Management System (RDBMS)
• Knowledge of the Database Lifecycle (DBLC)
• Good understanding of the concept of Normalization
• Wrote Transact SQL scripts to query the SQL Server 2005 database
• Created Transact SQL Procedures to enforce business rules
• Clear communication and documentation of technical specifications
• Highly motivated, excellent team player, enthusiastic, strong initiative and quick learner of new technologies
• Strong interpersonal and communication skills in dealing with customers
• Expert Skills in knowledge management, time management, prioritizing tasks
• Significant project management experience for over four years

PROFESSIONAL EXPERIENCE

Confidential, OH

Sr. Database Developer

Responsibilities

• Gather business rules, transform them into a technical design
• Building Logical models, translate them into physical structures, identifying gaps and resolving gaps by working with Architecture team
• Create .XML files which would have init and delta loads for Store, Terr, Param and PrimeSub processes
• Parse, validate and load the XML received from the UI into database structures
• Design, code, test and document Polling process to communicate store specific changes done in the CCN to individual stores
• Performance tuning, testing, bug fixing and documentation of technical work done
• Created JAVA code to read from the Message Queue to send Polling changes to specific stores
• Created shell scripts to move .XML files to the Polling process and update the request with the request id retrieved from the Polling Process

Technologies: - Oracle 11g, PL/SQL, SQL Loader, JAVA, Web Services, GIT, Messaging Queue, Shell scripting, Jira

Confidential, OH

Sr. Database Developer

Responsibilities

• Analyze, design, develop and implement several components of the project using Oracle and ODI technologies
• System analysis, gathering and analyzing user requirements, transforming them into functional design specifications and reviews
• Reverse Engineer the GM EPC4 (General Motors - Electronics Parts Catalog) to understand the working of EPC4, the queries involved and database objects used
• Created Proof of Concept (POC) with 16 catalogs to implement the business rules in CDR (Central Data Repository) for ERAPA, RPO/ POC codes publishing and use them in filtering
• Loaded data from the flat files into staging schema (RAW) using SQL Loader
• Created procedures to validate the data in the RAW tables, process them and load them into Baseline (BL)
• Used set based approach to process the ERAPA data in the BL and load them into CDR
• Created views, functions, triggers and procedures to process the data and make the data available in Chapter, page and filter item CDR tables
• Used nested tables, bulk collect, cursors, ref cursors and Exception handlers as a part of my procedures to implement the business rules
• Extensive use of analytical functions like lead, lag, sum, min, max, row number and count
• Extensive use of Common Table Expressions (CTE) in views
• Used listagg functions to perform string aggregations
• Good knowledge of partitions and partition pruning
• Redesign/ restructure and recommended changes in PL/SQL code flow that resulted in reduction of publishing time
• Tuning the system for optimal performance, generating test scenarios, debugging, implementation, enhancement and bug fixes
• Clear understanding of Histograms and their types and uses
• Used Oracle Data Integrator (ODI) to create procedures, options and scenarios
• Loaded Images on file system into DB using Python Scripting and SQL Loader
• Created load plans in ODI to automate the running of scenarios
• Python scripting to Annotate the Images, capture callout, convert them and SQL Load the Images into the staging table
• Created indexes, plugged in hints and made use of partition pruning as necessary to reduce the execution time of the queries
• Used Explain Plan extensively to understand the execution plans made by the Oracle optimizer
• Data validation between GM EPC4 and CDR to affirm all business rules are met
• Created Unit Test Cases (UTC) to test the working of the publishing process
• Documentations of technical work done by creating developer user guides, data flow diagrams and technical instructions manual

Confidential, NC

Sr. Oracle Database Developer

Responsibilities

• Used Excel Macros to process the data in the Spreadsheet and load them into the staging tables
• Created procedures to validate the data in the staging table, process them and load them into the main tables
• Created procedures to give the users a reporting functionality to query the data by parameters
• Used SSIS feature of Microsoft SQL Server 2008 to move data from CDW (Client Data Warehouse) into the attribution environment
• Created procedures in SQL Server 2008 for the following requirements like move attribution commission across roles, clone the employees coverage across months, Bulk Employee change, Save Coverage
• Created Oracle procedures as a part of the End of the Day script to copy over the data in CDW to other products
• Created indexes on necessary attributes for faster data retrieval
• Made use of explain plan to find the access path taken when the query is executed
• Made use of analytical functions like rank and dense rank to assign is primary to the employee having maximum portion
• Used records, cursors, %TYPE and ref cursors in the procedures created
• Made use of bulk collect to process the data retrieved from cursor/ ref cursor
• Used FOR UPDATE clause to lock the records in the cursor and used WHERE CURRENT OF statement to update the records that have been referenced by a for update statement
• Used a wide variety of exception handlers in the procedures to handle the exceptions
• Documentation of the technical work done

Confidential, MI

Oracle Data warehouse Developer

Responsibilities

• Downloaded data from AS400 server with IBM iSeries into a .csv file
• Loaded the data from .csv into the staging tables through SQL Loader
• Created procedures, packages and functions to find the accuracy of the data in the Global Datawarehouse (GDW)
• Created procedures to add a new ibo and/ or update the changes with the existing ibo
• Created procedures to check the accuracy of data for imc status code, imc affiliate code, imc loa code and update the incorrect records
• Created scripts as a part of the package to find table statistics, disable an index before data insert and rebuild the index ones the inserts are done
• Used records, type, cursors, %TYPE and ref cursors in the procedures created
• Made use of bulk collect to process the data retrieved from cursor/ ref cursor
• Used FOR UPDATE clause to lock the records in the cursor and used WHERE CURRENT OF statement to update the records that have been referenced by a for update statement
• Used a wide variety of exception handlers in the procedures to handle the anticipated exceptions
• Worked with set operators like Union, Union all, Intersect and Minus
• Created and worked with sequences and synonyms
• Used partition swap to swap the fixed records into the corrupt table and removing the error ones
• Worked with LOB’s like CLOB and used DBMS LOB package and CAST functions
• Used DML error logging (dbms errlog.create error log) to create an error logging table and ‘log errors into’ clause to load the error records into an error log table during bulk insert
• Created indexes and function based indexes to expedite the processing of data
• Made use of performance tuning utilities like explain plan and dbms profiler to reduce the run time of complicated queries
• Created and worked with Global Temporary Tables
• Created dblinks to connect to a remote server and access the data
• Created SSIS packages to move data from Sql Server 2005 into Operational Data Store (ODS) in Oracle datawarehouse
• Created and worked with views and snapshots for fixing bad data in the IMC snapshot
• Tweaked hints like parallel, append, index, etc. to hint the oracle optimizer for better performance
• Used sub-query factoring to make the complex SQL statements simple and more efficient
• Created Interfaces with Oracle Data Integrator (ODI) to transfer data from AS400 into ODS and then to GDW
• Created Packages and used scheduler to run the ODI scheduled packages

Confidential, PA

Oracle Database Developer

Responsibilities

• Population of data in to the input tables using SQL*Loader
• Data transfer from Input tables to the Output tables using procedures, packages and functions
• Created Cursors and Ref cursors as a part of the procedure to retrieve the selected data
• Made use of Bulk Collect feature to process the data from cursor/ Ref Cursors
• Made use of Subquery-Factoring (WITH clause) to make complex SQL statements simple and make them more efficient
• Used composite data types like %ROWTYPE and %TYPE
• Using set operators in PL/SQL like Union, Union all, Intersect and Minus
• Have created PRx views for the SAS team to enable the access to the data from the Teradata environment
• Created records and nested tables in the procedures for easy handling and modification of data
• Performed exception handling for data that did not conform to the required format
• Worked on SFTP to transfer files from remote server
• Created indexes for faster data retrieval and improved query performance
• Worked with performance tuning tools like dbms profiler and explain plan to improve the database performance
• Created indexes and Hints to optimize performance of database
• Written shell scripts to automate loading files into database using Crontab
• Created UNIX shell scripts to automate the loading of data from vendors through SQL Loader
• Created UNIX shell scripts to connect to SQL Plus and execute the packages and procedures created
• Implemented PL/SQL scripts in accordance with the necessary Business rules and procedures
• Wrote complex SQL queries to retrieve information from the database depending on the user requirements
• Support for the development, pre-production and the production databases
• Used TOAD to develop database applications

Confidential, NJ

Oracle Database Developer

Responsibilities

• Gathering business requirements
• Creating database objects like tables, synonyms, sequences and views
• Created, edited procedures, triggers and functions to suite the improved business requirements
• Created records and nested tables in the procedures for handling of data
• Used SQL Loader to load data into the database coming from Knipper and FICO
• Used export/ import and expdp/impdp database utilities for data transfer
• Extracting data from the Customer Interaction Center and creating a ‘{‘ separated file (flat file) by writing SQL queries
• Coded complex SQL queries to retrieve data from the database depending on the need
• Created Cursors and Ref cursors as a part of the procedure to retrieve the selected data
• Made use of Bulk Collect feature to process the data from cursor/ Ref Cursors and put the processed data into a collection
• Creating and worked with GTT (Global Temporary Table)
• Made use of Subquery-Factoring (WITH clause) to make complex SQL statements simple and make them more efficient
• Using set operators in PL/SQL like Union, Union all, Intersect and Minus
• Worked with packages like DBMS UTILITY.FORMAT CALL STACK and DBMS UTILITY.FORMAT ERROR STACK
• Worked with regular expressions like regexp like, regexp count, regexp instr, regexp substr and regexp replace
• Performed exception handling for the procedures created
• Used composite data types like %ROWTYPE and %TYPE
• Written shell scripts to automate the execution of the procedures and report the results through e-mail
• Included iSQL commands in the shell scripts to connect to SQL Server 2005 and retrieve data from SQL Server 2005 database and generate a ‘.csv’ file
• Experience in resolving anomalies in the production database
• Created indexes for faster retrieval and improved query performance
• Worked with performance tuning tools like DBMS PROFILER, explain plan, hints SQL Trace and TKPROF to improve the database performance
• Used SQL plus and TOAD to develop database applications
• Worked on isql utility to connect and extract data from the SQL Server 2005 database
• Wrote complex Transact SQL queries to join tables and extract data from them
• Good knowledge in working with SQL Server Management Studio 2005
• Documentation of the technical work done

Confidential

Graduate Assistant

Responsibilities

• Created tables, synonyms, sequences, views, PL/SQL stored procedures and triggers
• Coded and implemented PL/SQL packages to house stored procedures and functions
• Used various forms of control structures including CASE, DECODE, IF-THEN-ELSE, FOR loops, WHILE loops while developing procedures and other database objects
• Generated SQL and PL/SQL scripts to create and drop database objects including: table, view, index, primary keys, constraints, packages, sequences grants and synonyms
• Created views in Oracle Database
• Enforced constraints for data validation
• Fixed performance issues and bugs with packages and stored procedures using explain plan
• Created indexes on some columns of tables to increase the applications performance
• Loaded datasets from Oracle database using several kinds of tools such as SQL *LOADER
• Optimized a lot of SQL statements and PL/SQL blocks by analyzing the execute plans of SQL statements
• Created UNIX shell scripts and scheduled Cron jobs
• Written PL SQL cursors and REF Cursors for transaction processing
• Implemented triggers based on the business rules and requirements
• Written shell scripts to automate loading files into database using crontab
• Implemented PL/SQL scripts in accordance with the necessary Business rules and procedures
• Generated SQL and PL/SQL scripts to create and drop database objects including: tables, views, primary keys, indexes, constraints, packages, sequences and synonyms
• Support for the development, pre-production and the production databases
• Designed and created Forms for the users to access the database through a front end