SUMMARY

• Having around 9 years of IT experience in Design, Development, Implementation and support of RDBMS in Production and Development Environments using Oracle Tools.
• Strong Development and Testing experience on different domains such as Utility,Telecom and Media & Entertainment applications.
• Extensive experience in design and development and Configuration of Servers for various applications.
• Managing Users, Privileges and Roles, profiles, and other data accesses.
• Involved in complete Project Life Cycle including requirements gathering and Analysis, Database design, Database development, Application development, Testing, Implementation and Support of the application software and extensively on Production support.
• Proficient in developing and maintaining of packages, functions, application procedures, stored procedures, triggers, tables, indexes, views, partitioned tables using Oracle PL/SQL database programming language.
• Extensively used Cursors, REF Cursors, Composite data type and Collections in writing the backend PL/SQL code.
• Expertise in Design and development of interface and conversion programs to integrate Oracle Applications modules to import data from various sources using PL/SQL and SQL*Loader.
• Expertise in Database Performance Tuning using Oracle Hints, explain plan, TKPROF, Partitioning and Indexes, Gathering Statistics.
• Used DBMS utilities to extend the functionality of PL/SQL programs, such as UTL FILE to read and write from database to generate data file.
• Extensive experience in tuning the queries to improve performance of the code.
• Extensively used SQL joins, Oracle analytic and grouping functions for data analysis.
• Created many oracle objects like tables, views, queries, PL/SQL Functions, Materialized views, packages, stored procedures for new development and enhancements.
• Good experience in Unix Shell Scripting using bash and ksh.
• Created crontab scheduler using UNIX scripts, and used DBMS SCHEDULER API for plsql scheduled jobs.
• Extensive experience in Relational and Dimensional Data modeling for creating Logical and Physical Design of Database and ER Diagrams using multiple data modeling tools like Erwin.
• Have good experience in Hadoop Big data environment.
• Experience in Complete Software Development life cycle (SDLC) and Software Test life cycle (STLC).
• Experience in performing Backend/Database testing and writing SQL queries from SQL Server, Oracle for Data Integrity and used TOAD to execute the queries.
• Experience in using Test Management and Defect tracking tools Quality Center, Clear Quest, I - Track and JIRA for fixing and tracking the Defects.
• Proficient to develop Test Strategy, Test Plan, Test Scenarios, Test cases and Test Scripts.
• Experience in executing the Test cases and Test Scripts in different phases of testing like GUI Testing, Functional, Regression, Integration Testing, System and User Acceptance testing.
• Has good experience of SQL Server, Joins, Triggers, Stored Procedures and database connectivity for Back-end testing.
• Interacted with Business users, Project managers, and other team members to ensure problem solutions and user satisfaction.
• Extensive experience working in an Agile/scrum environment.

TECHNICAL SKILLS

Languages: C, C++, SQL, PL/SQL, HIVE

Data base: Oracle 9i, 10g, 11g, 12c and SQL Server

Browsers: Internet Explorer, Mozilla Fire Fox and VMware.

Scripting Languages: HTML, DHTML, UML and XML.

Defect Tracking Tools: iTrack, Quality Center, Clear Quest, SVN, JIRA.

Others: MS Office, MS Excel, Word, PPT, MS Visio, Adobe, Acrobat, Win merge, Visual Studio.

Operating Systems: Windows 2000, 2003, XP, XP Home, Vista and UNIX.

PROFESSIONAL EXPERIENCE

Confidential, Baltimore MD

PL/SQL/Golden gate/ODI Developer

Responsibilities:

• Closely worked with architects to make changes in current architecture based on client needs.
• Consolidate and standardize data sets across OpCos( Confidential, PECO, COMED) to serve multiple analytical workloads to avoid point to point integration between systems.
• Used golden gate and oracle data integrator for data ingestion into foundation layer/raw zone.
• Created stored procedures for incremental loads, which will load the data automatically.
• Involved in data validation in rawdev and rawtest environments for all Opcos.
• Used gzip or zip formats for file transfer to Opower to improve the performance.
• Used Hive to load the data from foundation layer to data lake/staging area.
• Extensively used SQL joins to load the data from data lake to Exadata, which is Oracle DB.
• Collaborate with data architects for data model management and version control.
• Working closely with the testers in order to help with overall-testing completion of the committed Iteration capacity (points).
• Analyses and discuss the business requirements with the clients.
• Worked with Business Analyst and Business Objects teams to get brief idea about requirements and translate the requirement into functional design documents and technical specifications.
• Worked in Agile Environment as an Oracle Developer to fine tune and optimize the queries in resolving the defects.
• For version control and sharing file used SVN.

Environment: Oracle 12c, Hive, Toad, SQL server, SVN, Rally, Agile, iTrack

Confidential, Herndon VA

PL/SQL Developer

Responsibilities:

• Verified the data in different Biller Source DB tables as per business requirements.
• Analyzing new and altering the existing Stored Procedures to meet the customer requirements for implementing business logic.
• Created new back end Triggers to audit the transactions on RECON tables.
• Identifies, maintains & controls database server’s configuration items and worked with other teams to replicate the dependency data from their DB to RECON DB through GG (Golden Gate).
• Created the new backend programs using PL/SQL Packages, Procedures and Functions for submitting the Jobs.
• Used Explain Plan, Oracle hints and creation of new indexes to improve the performance of SQL statements.
• Validates data integration by developing and executing test plans and scenarios including data design, data extract/transform.
• Experience in Oracle Database Administration, including performance tuning, application tuning using Explain Plan and TKPROF.
• Creating Oracle Database objects based on the new requirements (Tables, Indexes, views, partitions, Constraints and triggers).
• Extensively used SQL joins, Cursors for data analysis and defect fix.
• Involved in debug, troubleshoot, solve complex PL/SQL issues and the ability to reverse engineering the existing PL/SQL code.
• Interacted with business people to gather new requirements and implement with existing code.
• Involved in archiving the biller tables by using partition to improve performance.
• Created new tables in stage environment to pull the data from biller source by using DB links.
• Developed new procedures to load the data into stage and my local RECON tables based on daily delta loads.
• Created Materialized Views, indexes and partitions to improve performance.
• Worked with testers in End2End testing.
• Worked with product owners closely to understand the new business requirements.
• Worked extensively on forward and reverse engineering processes. Created DDL scripts for implementing Data Modeling changes. Created ERWIN reports in HTML, created naming convention files, co-coordinated with DBAs to apply the data model changes.
• Modifying table structure according to the new/changing requirement and also interacting with business users and DBA in order to be on the same page.
• Working closely with the testers in order to help with overall-testing completion of the committed Iteration capacity (points).
• Interaction with the Business Partners to understand the business of the application, gather requirements, analyzed and put into technical design documents (CSG & DDP).
• Analyses and discuss the business requirements with the clients.
• Worked with Business Analyst and Business Objects teams to get brief idea about requirements and translate the requirement into technical specifications.
• Optimized the queries to improve the performance of the application using Explain plan and TkProf.
• Used DBMS STATS package to gather statistics for a particular table and schema.
• Worked in Agile Environment as an Oracle Developer to fine tune and optimize the queries in resolving the defects.
• For version control and sharing file used SVN.
• Work experience in using Database links between two different databases such as CSG and DDP biller source.
• Involved in testing and data approval tasks and successfully moved project into production.
• Worked on enhancing the existing MV's to refresh the data periodically.

Environment: Oracle11g, Toad, SVN, Rally, Agile, iTrack, ClearQuest

Confidential, Alpharetta GA

PL/SQL Developer/Oracle ADBA

Responsibilities:

• Managed and maintained hosted production, development, test systems, non-hosted client systems, as well as internal systems running Oracle applications in a 24X7 environment.
• Responsible for planning, scheduling, and implementing database upgrades and patches.
• Responsible for supporting Development/Testing/Training/Staging/Production environments.
• Identifies, maintains & controls database server’s configuration items.
• Managed users, roles and privileges, profiles, and other data accesses.
• Performed backups, restores and refreshing databases and applications.
• Ensured availability of client production systems and internal instances.
• Performed Windows Server and UNIX system administrator tasks as part of maintenance.
• Writing the script to monitor the database with shell and PL/SQL code such as procedure, function and package.
• Involved in all phases of database development from needs assessment to QA/QC, design and support.
• Supported Oracle developers. Performed database tuning, created database reorganization procedures, scripted database alerts, and monitored scripts.
• Expertise in creating databases, table spaces, tables, indexes and other database objects.
• Expertise on SQL Loader to load the data and Data pump utility to create new users in other Database Environments.
• Working on Enhancements of OPUS application and Working on Testing Issues and the deployments.
• Involved in patching and upgrading the testing and production Environments.
• Extensive experience in design and development and Configuration of Servers for various applications.
• Creating tables and views for developer and client needs.
• Involved in Performance Training Issues, Explain Plan and Replication->Oracle streams and Golden gate.
• Working/Fixing on Database related tickets/issues in Dev/Training/QC/LT/Prod environments and deployments.
• Worked with development teams closely and provide assistance to developers and testers as needed.
• Provided on-call support during the peak load of project delivery.

Environment: Oracle11g, Toad, Java, SVN, Clear Quest, iTrack, SharePoint, SQL Developer

Confidential, Baltimore MD

PL/SQL Developer

Responsibilities:

• Worked on performance tuning Heavy SQL related issues and resolving the Issues with Oracle 9/10g (Advanced Functions) as to cope up with con-current processes to make sure no process fails due to the delay in the preceding process/s.
• Involved in Developing stored procedures and functions for the VPS, VPSO, CCA &Register aplications.
• Verified the data in different DBtables as per the requirements.
• Analyzing new and altering the existing Stored Procedures to meet the customer requirement for implementing their business logic.
• Managed users, roles and privileges, profiles, and other data accesses.
• Used advanced PL/SQL concepts including Global Temporary table, Collections (Bulk Collect, Varrays, Nested Tables and PL/SQL Tables).
• Created new back end Triggers to provide the Foot Note functionality for all the major Transaction Screens.
• Managed and maintained hosted production, development, test systems, non-hosted client systems, as well as internal systems running Oracle applications in a 24X7 environment.
• Involved in loading large amounts of data with SQL Loader.
• Identifies, maintains & controls database server’s configuration items.
• Involved in all phases of database development, from needs assessment to QA/QC, design and support.
• Developed new packages to Import from Excel and Export to Excel functionality.
• Modified existing Unix Shell Scripts and scheduled UNIX scripts through Crontab.
• Created the new backend programs using PL/SQL Packages, Procedures, and Functions for submitting the jobs.
• Requirements gathering from Specs, Users/PM’s and documentation, data cleansing and extraction, report design and implementation, and testing.
• Creating Oracle Database objects based on the new requirement (Tables, Indexes, views, partitions, Constraints, triggers etc.,).
• Extensively used SQL joins, Oracle analytic and grouping functions for data analysis.
• Create the jobs and schedules them to run on the specific times and will not affect the system performance, Email notification setup for failure notifications.

Environment: SQL, PL/SQL, UNIX, Quality Center, MS office, Toad, SVN, Clear Quest, itrack, SharePoint, SQL Developer

Confidential, Orlando FL

PL/SQL Developer

Responsibilities:

• Performed Backend testing, writing SQL queries and execute in TOAD.
• Involved in implementing stored procedures for Reservation management, Accounting, Folio and Room Inventory management modules.
• Used advanced PL/SQL concepts including Global Temporary table, Collections (Bulk Collect, Varrays, Nested Tables and PL/SQL Tables).
• Dealing with performance related issues and resolving the Issues with Oracle SQL and PL/SQL programs.
• Experience in using SQL queries to develop complex queries for data validation.
• Creating Oracle Database objects based on the new requirement (Indexes, view, constraints, partitions).
• Designed and developed new custom applications which support the daily business and synch with current level of application.
• Performed Unit test before going to Test team to make sure the software application works perfectly.
• Executed scripts in UNIX environment using putty.
• Developed complex Tasks for their trusted vendor requirements.
• Wrote the packages to provide vendor requirement data in their format as flat file.
• Involved in Pre-Production support for resolving the issues.
• Writing SQL, PL/SQL programs, Packages, Stored procedures, Functions and Triggers to automate the interface processes for daily transaction.
• Loading the data into the application, which will come in flat files and process them for correctness.

Environment: Windows XP, Quality center, UNIX, SQL, PL/SQL, Toad, MS office

Confidential

PL/SQL Developer

Responsibilities:

• Involved in writing complex queries to generate reports as per client request as part of production support.
• Developed back end interfaces using PL/SQL stored procedures, functions, packages, triggers.
• Wrote Procedures with bulk collection&bulk binding concepts for better performance.
• Scheduling UNIX jobs through Crontab.
• Involved in Unit Testing &Bug fixing.
• Worked closely with QA team in testing the developed Program units and successfully moving them to Production.
• Delivered a set of DDL scripts to create tables, views, primary/foreign keys, unique/check constraints, indexes, sequence and other Oracle database objects.
• Created complex SQL queries, Stored Procedures, functions for the purpose of data analysis.
• Analyzing new and altering the existing Stored Procedures to meet the customer requirement for implementing their business logic.
• Involved in query tuning to improve the performance using Oracle as backend.
• Created/Designed new tables, views, queries, PL/SQL Functions, packages, procedures for new enhancement in the application.
• Modified existing Unix Shell Scripts and scheduled UNIX scripts through Crontab.
• Involved in developing PL/SQL Procedures, Packages, and Triggers.
• Developed Test Plans and Test cases for coding.
• Prepared the design specification documents, test plan for all the above modules.

Environment: SQL, PL/SQL, UNIX, TOAD, MS office.