SUMMARY

• Oracle Certified Associate (OCA) with 9 plus years of experience in software development and database development using Oracle 8i, 9i, 10g, 11g, 12c and SQL Server 2000/2005/2008
• Experience in Retail, Pharma and Financial domains in both OLAP and OLTP environments.
• Good knowledge in Oracle Server Architecture and basic DBA activities.
• Experience in Agile software development methodology and collaboration between self - organizing cross-functional teams.
• Expert in understanding business requirements, translating them into efficient code, performance tuning, debugging and exception handling
• System and Integration testing using test cases, reports creation and documentation of the technical work
• Hands on experience in analysis, design, programming, testing and troubleshooting in various Operating Systems like XP, Unix, Solaris and Linux
• Involved in all phases of SDLC
• Experienced in designing, developing, scheduling and monitoring UNIX shell scripts to administer all the environments
• Created interfaces, Packages using Oracle Data Integrator (ODI) to move data across different database
• Created SQL Server Integration Service (SSIS) packages to transfer data from Oracle to SQL Server

PROFESSIONAL EXPERIENCE

USM Business Systems

Confidential, OH

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 Business Analysts
• Created tables, synonyms, views, index and triggers for Change Data Capture (CDC)
• Used a wide variety of exception handlers in the procedures to handle the anticipated exceptions
• Used packages, procedures and functions to create .XML files which would have init and delta loads for Store, Terr, Param and PrimeSub processes
• Used Cursors, REF Cursors and Bulk Collect functionality for faster execution
• Parse, validate and load the XML received from the UI into database structures
• Created indexes and computed stats as needed
• Used Explain plan for query tuning and optimization
• Used shell scripts to receive the .XML file and pass it on to the JAVA APIs to get the polling request IDs
• 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
• Code maintenance, code promotion, code deployment, testing in higher environments and documentation of the technical work done

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

Confidential, OH

Computer System Analyst

Responsibilities

• Gathering business requirements
• Creating database objects like tables, synonyms, sequences and views (200+)
• Created, edited procedures, triggers and functions to suite the improved business requirements
• Used SQL Loader to load data into the database coming from GM
• Used export/ import and expdp/impdp database utilities for data transfer
• 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
• 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
• 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
• Documentation of the technical work done

Technologies: - Oracle 11g, ETL, PL/SQL, SQL Loader, ETL, Oracle Data Integrator, Accurev, Oracle Apex, Python, Shell scripting, Jira

Confidential, NC

Exempt - Non officer

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 tables, views, synonyms, sequences and issues grants as needed
• 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

Technologies: - Oracle 11g, PL/SQL, SQL Loader, Microsoft SQL Server 2008, SSIS, SVN

Confidential

Oracle Database 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
• 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
• 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
• Created Cursors and Ref cursors as a part of the procedure to retrieve the selected data
• 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
• 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
• Worked on SFTP to transfer files from remote server
• 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

Technologies: - Oracle 9i, PL/SQL, SQL Loader, Microsoft SQL Server 2005, SSIS

Confidential, LA

Oracle Database Developer

Responsibilities

• Population of data into the tables using SQL*Loader
• Experience with merging data files coming from the customers
• Coding the survey questionnaire (telephonic version) using Ci3 software
• Coding the survey questionnaire (paper version) using wincati software
• Integrating the data from heterogeneous sources (Sql Server 2000, Access, Excel, csv etc.)and loading them in to the staging tables
• Created procedures and packages to transform the data into the required format and aiding in the research of the client
• Made use of records, cursors and ref cursors in most of the procedures
• Created indexes and function based indexes depending on the requirements
• Made use of performance tuning tools like explain plan, dbms profiler
• Performed exception handling for data that did not conform to the required format
• Responsible for making the merged data in turn available to other clients
• 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
• Documentation and Knowledge Management to pass the information to prospective employees
• Have worked in more than 40 surveys including Louisiana state government surveys
• Some of the important surveys worked are Louisiana Health Insurance Survey (LHIS), Louisiana Department Of Labor (LDOL), Tiger Atheletic Foundation (TAF), Business Climate Survey (BCS), Louisiana Health Insurance Coverage Survey (LHIS) and Louisiana Department of Health and Hospitals

Technologies: - Oracle 8, PL/SQL, SQL Loader, WinCati, MS Access, MS Excel