SUMMARY:

• Oracle Certified Professional and Over 7+ years of experience in various Information Technology segments, Offering Professional experience in Oracle Database, PL/SQL, SQL and SQL Server, Proficient in Oracle 9i/10g/11g in various operating systems like Red hat Linux and windows.

TECHNICAL SKILLS:

Databases: Oracle 9i/10g/11gr2,SQL Server 2005/2008/2012 R2 and Mysql

Languages: SQL,PL/SQL,PHP, Weka, R, C, Shell Scripting and JAVA

Operating Systems: Windowds NT, UNIX and Linux

Oracle Tools: RMAN, ASM, AWR, Oracle Database Tuning, Data Pump, SQL Loader, DBverify, Export/Import, External Table, Opatch, SQL Trace, Flashback Technology, OEM,RAC, Data Guard

SQL Server Tools: SQL Server Profiler, Database Engine Tuning Advisor (DETA), Surface Area Configuration, SSCM, PrefMon, DMVS, Data Replication, Database Mirroring, Windows Server Performanc Monitor, SQL Server Export and Import, Execution Plans

Other Expertise Areas: Data Mining, Data Warehousing, Data Preprocessing, Data Cleansing, Stock Exchange Trading System,IIS and Wamp Web Service,ETL,FTP,PuTTY, Informatica Power Center 9.6.1,Networking (VPN,VLAN, Firewall and FTP), Oracle Virtualbox,Vmware,JIRA

PROFESSIONAL EXPERIENCE:

Confidential, Detroit, MI

Oracle PL/SQL Developer

Responsibilities:

• Developed application and database triggers, functions, procedures, and packages in PL/SQL, Oracle11g as back - end.
• Coordinated with the front end design team to provide them with the necessary stored procedures and packages and the necessary insight into the data.
• Created various SQL and PL/SQL scripts for verification of the required functionalities.
• Created Records, Tables, Collections (nested tables and arrays) for improving Query performance by reducing context switching.
• Worked on modifying various existing packages, procedures, functions and triggers according to the new business needs.
• Used merge statement, Global Temporary table extensively.
• Developed triggers and packages to delete stored session data from various tables.
• Analyzing performance of database objects and suggesting DBA for Indexes, schema gathering, partitioning, Explain Plan and TKPROF.
• Performed SQL and PL/SQL tuning and Application tuning using various tools like EXPLAIN PLAN, SQL*TRACE, TKPROF and AUTOTRACE.
• Extensively involved in using hints to direct the optimizer to choose an optimum query execution plan.
• Used Pragma Autonomous Transaction to avoid mutating problem in database trigger
• Used complex views and SQL analytical functions to generate business verification reports.
• Partitioned the fact tables and materialized views to enhance the performance.
• Wrote stored procedure to migrate data from one database to other using BULK COLLECTION utilities for better performance and easy retrieval of data, by reducing context switching between SQL and PL/SQL engines.
• Creation of database objects like tables, views, materialized views, procedures and packages using oracle tools like Toad, PL/SQL Developer and SQL* plus
• Used advance features of oracle such as function result cache,virtual columns,pivot and unpivot queries,listagg functions,plsql subprogram inlining,query result cache,plsql collection using order and distinct,multiset,pipelined functions etc..
• Analyzed legacy application and Created Data access layers for modernized applications using complex views.
• Created data dump scripts using SQL queries and importing data into excel sheets.
• Developed data incremental load stored procedure from staging tables to target tables.
• Created exception log PL/SQL stored procedures to load data exceptions into exception tables before the data conversion from legacy system to modernize system.
• Worked on one time initial load PL/SQL block to convert data from legacy system to modernize system by applying various business rules.
• Supported business analyst team to understand data flow and to create mapping documents from source and target system.
• Handled errors using Exception Handling extensively for the ease of debugging and displaying the error messages in the application.
• Performed unit testing of developed PL/SQL code in DEV environment and promoting codes to QA, UAT and Production environments.
• Created data flow diagrams, data mapping from Source to stage and Stage to Target mapping documents indicating the source tables, columns, data types, transformations required and business rules to be applied.
• Created Test cases and Test scripts for System Integration Testing (SIT), User Acceptance Testing (UAT) and Unit Integration Testing.
• Worked closely with QA team, UAT team to validate and verify developed Pl/SQL code in respective environments.
• Released and deployed final version of codes in QA, UAT and Production environments.
• Checked in all tested PL/SQL code in SVN and maintaining versions of PL/SQL codes.
• Involved in the continuous enhancements and fixing of production problems
• Documented code in accordance with company policies, company standards and industry best practices.

Confidential, OH

Sr. Oracle PL/SQL Developer

Responsibilities:

• Performed server installation, configuration and managed MS-SQL Server 2005/2008/2012 R2 in WINDOWS NT OS.
• Created, Maintained and optimized database objects
• Upgrading MS-SQL server from 2005 to 2008 to 2012 R2
• Experience in using SQL Server Profiler, SQL Server Agent, and Database Engine Tuning Advisor(DTA).
• Performed daily tasks including backup and restore by using SQL Server 2005 tools like SQL Server Management Studio, SQL Server Profiler, SQL Server Agent, and Database Engine Tuning Advisor.
• Expert in Using DMVs, Performance dash board, Mirroring, database snapshots and tracking Performance Counters.
• Configuring Database mirroring and replication between primary production servers and standby servers
• Checking space monitoring, Index Defrag, Update statistics, Log shipping between primary production servers and standby
• Rebuilding / Monitoring the indexes at regular intervals for better performance.
• Maintaining and managing Data center and Disaster Recovery sites
• Monitoring SQL server performance using SQL Profiler to find performance and dead locks.
• Worked closely with the database users, application developers and network administrator to provide direction in identifying and resolving production database issues
• Involved in trouble shooting and fine-tuning of databases for its performance and concurrency
• Prepared technical design/specification for data extraction, Transformation and loading.
• Mapping data items from source system to target system.
• Analyze the sources, transformed the data, mapped the data and loading the data into targets using power center designer.
• Worked on informatica utilities-source analyzer, warehouse designer, mapping designer, maplet designer and transformation developer. worked on various transformations like source qualifier,expresion,filter,aggregator,lookup,update strategy, stored procedure,squence generator, router and joiner transformations
• Extensively worked in PHP and Wamp Server to generate financial reports from the database for the clients and organization
• Worked closely with ASP.NET Developer to redesign existing Trading System
• Updated and monitored Streaming Traded data into website
• Using FTP client to upload and download files from SERVERS

Confidential, Rosemont, IL

Oracle PL/SQL Developer

Responsibilities:

• Installed, configured and managed of Oracle Server Software and related products
• Patching and Upgrading Oracle Databases 9i
• Backup (HOT and Cold) and Recovery using User managed Backup and RMAN
• Created Logical Backup using Data Pump.
• Transported tablespace from Production Database to Warehouse
• Performed Recovery point in time using flashback and Log Miner.
• Identified corrupted blocks using Dbverify function and recovered using RMAN
• Installed, managed and maintained ASM and Oracle RAC to Maximize database Availability, Load Balancing and Scalability.
• Configured and Managed Physical and Logical Standby Database using Data Guard and RMAN.
• Configured and managed Active Data Guard using Oracle Data Guard Broker for Disaster Recovery.
• Maintained Database Security and managed different level of database user’s access.
• Data Load Into and out from Oracle Database using SQL* Loader, External Table and Data Pump
• Monitored database health and Optimize database performance using AWR, ADDM and Other Oracle built in Advisors.
• Created and maintained DBLinks, Views and Materialized Views
• Scheduled various DBMS jobs and Wrote Unix/Linux Shell scripting to automate the various manual process.
• Created, maintained and managed Tablespace, Indexes and Audit Tables.
• Monitored system resource availability, Database capacity planning, Data Migration, Documenting changes and maintained organization standards and Policies
• Created and maintained PL/SQL scripts and stored procedures.
• Extensive experience in developing Stored Procedures, Functions, Triggers, Views, Cursors, Packages, Exceptions, Joins, Sub Queries and Set Operators.
• Involved in modifying various existing packages, Procedures, functions, triggers according to the new business needs.
• Performed SQL and PL/SQL tuning and Application tuning using various tools like EXPLAIN PLAN, SQL*TRACE, TKPROF and AUTOTRACE.
• Involved in the development backend code, altered tables to add new columns, Constraints, Sequences and Indexes as per business requirements.
• Data validation/Reconciliation report generation
• Testing of code functionality using testing environment

Confidential, Richmond, VA

Oracle PL/SQL Developer

Responsibilities:

• Involved in SDLC gathering requirements from end users.
• Developed views to facilitate easy interface implementation and enforce security on critical customer information.
• 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.
• 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.
• Writing validation packages using PL/SQL package.
• Developed Installation scripts for all the deliverables.
• Wrote heavy stored procedures using dynamic SQL to populate data into temp tables from fact and dimensional tables for reporting purpose.
• Involved in analysis, Design, Development phases of the project.
• Developed user interface Forms, Reports, PL/SQL Packages, Procedures, Functions and Database Triggers to meet the business requirements.
• Identifying and troubleshooting production issues and delivering on key enhancements.
• Involved in extensive interaction with demanding business users and help resolve queries and issues on time.
• Co-ordinate with the DBA during production releases.
• Provided assistance to QA Team, in defining and validating the test scenarios.
• Involved in Production Support, problem resolutions and bug fixing. Actively involved in raising issues and coordinating between the Management & Users.