SUMMARY

• 8+ years of IT experience in analysis, design, development, implementation and testing as Oracle SQL/PLSQL Developer.
• Hands - on experience in all phases of system development & software development with well-defined Quality Standards; Requirement Analysis, Design, Development, Testing & Implementation.
• Provided support for RDBMS in Development, Test and Production environments using Oracle Tools.
• Involved in database design and data modelling using Erwin Data Modeler tool.
• Experience in Oracle Development tools TOAD, Oracle SQL Developer.
• Experience in SQL, PL/SQL, Tables, Table Partitions, Database links, Views, Synonyms, Sequences, Stored Procedures, Functions, Packages, Triggers, Cursors, and Indexes.
• Knowledge of Autonomous Transactions Materialized Views, Bulk Collects and Collections.
• Experience in writing PL/SQL routines in data warehousing applications.
• Analyzing & gathering table statistics for Query Optimization.
• Experience with Oracle Developer Suite 6i /9i /10g/11g/12c.
• Experience in Performance Tuning using SQLTRACE, EXPLAIN PLAN&TKPROF with the help of Hints, Partitioning, Bulking techniques and Indexes.
• Experience in UNIX Shell Scripting.
• Oracle Import/Export Utilities & SQL*Loader.
• Experience in Migrating Data to Oracle database.
• Good understanding of Oracle Architecture.
• Experience in preparing technical documentation & user manuals.
• Ability to cope up with team with good analytical, communication, organizational and interpersonal skills.

TECHNICAL SKILLS

OPERATING SYSTEMS: WINDOWS NT/2000/XP/Vista/windows7/windows10, Solaris 10/9/8, AIX 5.x, Red Hat LINUX AS3.0 & 4.0

DATABASEs: ORACLE 8i/9i/10g/11g/12c, MS Access, MS Excel (VBA), SQL Server 2005/2008, DB2

GUI's: Oracle Developer suite 9i/10g/11g/12c

TOOLS: ERWIN 7.x, TOAD 10.6, SQL Developer 2.1, SQL*PLUS, SQL*LOADER, PVCS, Informatica 7.1/8.6, Actimize Designer 5.13, Actimize Visual Modeler 4.23.0.14

SCRIPTING: UNIX Shell Scripting

Languages: C, C++, Java, VB, C#

Communication Tools: Microsoft Teams, Skype, MS-Outlook, IBM Lotus Notes

Web Technologies: JSP, Servlets, Applets, XML, HTML, CSS, PHP

PROFESSIONAL EXPERIENCE

Confidential, Richfield, Minneapolis

Oracle Developer

Responsibilities:

• Responsible for requirements gathering from Clients and implement the backend changes for existing product and in designing the database.
• Creating SQL*Loader Control Files for moving data from Flat Files (Fixed Record Length) to Staging Area Tables.
• Developed procedures to move data from staging tables to production tables.
• Analyzed the performance of SQL queries using Explain plan and SQL TRACE, and increased the query performance by creating proper indexes on tables.
• Involved in Performance tuning of SQL queries as data warehouse consists of many of rows of data.
• Created data for Crystal Reports using procedures and complex Queries.
• Design and developed the scripts to create tables, views, indexes and sequences.
• Created custom triggers to automatically populate different tables and to restrict the data being inserted to the different tables.
• Developed Database Triggers, Stored Procedures, Functions and Packages.
• Exclusively worked on Unix/Linux Shell scripting (Korn Shell (KSH), BASH, etc.) and rewrote complex UNIX shell scripts as per the requirement.
• Gained experience with job scheduling systems (ESP, Autosys, Cron, etc.).
• Gained experience with Actimize with Dart reports and backend support related to RCM Plugins.

Environment: Oracle 12c, PL/SQL, SQL*Plus, SQL*Loader, PL/SQL Developer 9.0.3, UNIX, Toad, AIX 7.1, Actimize Designer 5.13, Actimize Visual Modeler 4.23.0.14

Confidential

Oracle Developer

Responsibilities:

• Responsible for leading the development and support of several Advisor Services centralized databases written in Oracle and MS SQL Server.
• Actively collaborated with agile teams to support software development lifecycle and involved in writing and contributing to detailed design, functional specifications or technical requirements.
• Extensively involved with relational database development using stored procedures primarily in Oracle and MS SQL Server.
• Worked with other database leads to establish standards, procedures and design patterns.
• Analyzed the performance of SQL queries using Explain plan and baselines.
• Developed PL/SQL packages, procedures, functions applying the business logic facilitate the functionality for various modules.
• Worked with Partition tables and indexes to improve the performance of data loading and query processing.
• Extensively involved in tuning the queries for faster and better performance of the SQL queries Optimized critical queries to eliminate Full Table scans, reduce Disk I/O and Sorts.
• Designed and developed data cleansing, data validation, load processes ETL using Oracle SQL and PL/SQL and UNIX
• Provided with assistance in logical/physical data modeling and data integrating using Erwin.
• Worked with Microsoft TFS and C#/.NET.

Environment: Oracle 11g/12c, PL/SQL, SQL*Plus, UNIX, MS SQL Server 2008, Toad, Microsoft TFS.

Confidential, Madison, WI

Oracle Developer

Responsibilities:

• Develop logical and physical data models that capture current state/future state data elements and data flows using Erwin.
• Analyzed the functional specs provided by the data architect and created technical specs documents for all the enhancements.
• Involved in preparing functional document, user document, process flow diagram and flow charts.
• Migrated data from the previous database in SQL Server database to Oracle 11g.
• Worked with SQL*Loader and External Tables to load flat files into staging tables.
• Involved in performance tuning and troubleshooting issues.
• Fine Tuned procedures in various schemas across databases using Oracle Hints, Explain plans and Trace sessions.
• Ran Cron jobs for loading database tables from Flat Files using SQL*Loader and also used DBMS SCHEDULER to schedule PL/SQL stored procedures.
• Created the Shell Scripts to automate the execution of the PL/SQL subprograms and to move the data to store in historical folders.
• Used FTP to transfer the files into different servers as per needed by the business users.
• Involved in preparing test plans, unit testing, System integration testing, implementation and maintenance

Environment: Oracle 11g, Microsoft SQL Server 2008, PL/SQL, SQL*Plus, SQL*Loader, TOAD 10.6, AIX 7.1.