SUMMARY

• 8+ years of working experience as Sr. PL/SQL developer, Oracle GoldenGate expert, Oracle Application DBA in Finance, Health, Manufacturing, Mobile and Educational sectors.
• Experienced in requirement analysis, coding and testing various modules in a software development life cycle.
• Experience in Design, Development, and Enhancement and Maintaining applications in Oracle 8i/9i/10g/11g using SQL, PL/SQL in Windows 9x/NT/2000/XP and UNIX environments. Detailed depth Knowledge in Oracle Architecture, Data Dictionary and DBMS Packages.
• Experience with creating and managing database objects such as tables, partitions, views, materialized views, snapshot replication, indexes, constraints, context, synonyms, sequences, database roles, Oracle directories etc.
• In depth hands on with complex SQLs, PL/SQL coding, stored procedures, triggers, cursors, packages, performance Tuning, Indexes, Logical and Physical database design to implement the business logic.
• Proficient in developing Oracle Reports 6i and developing concurrent programs using SQL, PL/SQL and UNIX Shell Scripting.
• Extensive experience in SQL, PL/SQL, SQL*Plus and third party tools like TOAD and SQL Developer.
• Using Explain plan, Analyze, TKProf; SQL performance improvements using indexes, hints, query tuning, gathering stats etc.
• Hands on Export/import, datapump (expdp/impdp). Experience with Oracle logminer utility for troubleshooting production issues.
• Comfortable with Shell scripting, perl scripting, crontab scheduling.
• Proficient in Oracle Tools and Utilities such as SQL*Loader, Import/Export and SQL*Navigator.
• Worked on Production Support, receiving production calls on troubleshooting the application and resolve bugs.
• Strong experience in client interaction and understanding business application, business data flow and data elements.
• Having 1yr of ETL and data integration experience in developing ETL mappings and scripts using Oracle for Informatica PowerCenter.
• Ability to work in teams and independently with minimal supervision to meet deadlines.

TECHNICAL SKILLS

Databases: ORACLE 8/8i/9i/10g/11g

Languages: SQL, Oracle PL/SQL, Oracle developer 2000.

Data Modeling: Erwin and Visio 2007

Front end Tools: Developer 6i (Reports)

Web: HTML, XML, Macromedia Flash.

Scripting tool: Unix Shell Script

Scheduling Tools: Tivoli (Maestro)

Tools: /utilities SQL*Plus, TOAD, PL/SQL Developer, SQL Navigator, SQL Loader, Oracle Portal 9i AS.

Operating System: DOS, Windows 9x/NT/2000/XP, UNIX, HP - UX

Version Control: VSS 6.0, Clearcase 3.2.

ER Design: ERWIN, MS Visio.

PROFESSIONAL EXPERIENCE

Confidential, Atlanta, GA

Sr. Oracle PL-SQL Developer

Responsibilities:

• Handling 70+ Dev/QC/Test databases; 15+ performance/stage/UAT/training databases, 40+ production databases varying from few GBs to 4 TB.
• Creating new databases as and when required, creating and maintaining database objects.
• Creating, managing, and monitoring tablespaces.
• Helping development team and PL/SQL developers with writing complex packages and solutions.
• Involved in database design with application analyst/design team; and work on database environment and database solution design.
• Working with System Administrator and Networking team on database host server design, file system, disk space, memory, swap memory, networking etc.
• Also working closely with SA and System DBA to setup backup and recovery procedures; and monitoring the backups are performed as per SLA. Coordinating host servers and database upgrades/patching with SA/System DBA.
• Worked with oracle support via service requests, providing necessary inputs and detail to oracle and follow-up on issues/bugs till closure.
• User management, roles, profiles, compliance and security management.
• Involved with FGA, Auditing setup, SPI/PCI data management.
• Cloning databases using Import, export, datapump; loading data using Sqlloader, external tables and DB links from interfacing systems.
• Using Statspack, Explain plan, Analyze, ADDM, AWR Report for performance tuning and troubleshooting. Gathering and analyzing AWR report for troubleshooting purposes. SQL performance improvements using indexes, hints, query tuning, gathering stats etc.
• Working on session management, database locking/blocking issues, hang sessions; monitoring resource intensive queries and optimizing those in production environment.
• Configured oracle GoldenGate replication in various modes like: unidirectional (for query offloading), Bidirectional (for Standby DB or Active-Active for HA), broadcast distribution and data integration.
• Configure and build Golden Gate Extracts, pump, and replicat for multiple databases including test, pre-production and production databases.
• Experience with checkpoint table, optimized network settings in pump, USEREVENTS, SQLEXEC, calling procedures from golden gate, exception handling, discards/error reporting, CDR (collision detection and resolution), DDL and DML replication.
• Resolved issues with Golden Gate components like Extract, Replicate, Trail Files, GGSCI commands, Tranlog options etc.
• Used logdump to resolve transaction level troubleshooting and data consistency.
• Created monitoring scripts to get alerts of any/all lag, abends, and errors in export/pump/replicates. Configured heartbeat and checkpoint monitoring.
• Troubleshooting and tuning of Goldengate for the performance issues and data conflict issues.

Confidential, Armonk, NY

Sr. Oracle PL-SQL Developer

Responsibilities:

• Extensively involved in ETL code using PL/SQL in order to meet requirements for Extract, transformation and loading of data from source to target data structures.
• Create and maintain tables, views, procedures, functions, packages, DB triggers, Indexes and Collections.
• Created Stored Procedures, Functions, Triggers and Packages using TOAD and SQL Navigator.
• Advance PL/SQL development using dbms packages, xml functions, regexp, directories, For all, bulk collect, table collections, user defined data type etc.
• Tuned SQL queries using explain plan generated in TOAD and SQL Navigator.
• Involved in database tuning by creating function-based index, table partitions and analyzing the tables.
• Used UTL FILE built-in package to generate files as per the requirement.
• Involved in creating DYNAMIC SQL that will update or insert data into the tables on the run.
• Wrote complex in-line views which summarized the business needs to the fullest.
• Use of different Exception Handlers and also Create Some User defined Exception Handlers.
• Involved in migrating the entire database setup from test environment to production.
• Participated in status meeting and walkthroughs.
• Designed, implemented and tuned interfaces and batch jobs using PL/SQL and UNIX utilities.
• Wrote Unix Shell Scripts for automation process.
• Designed reports that had complex SQL, PL/SQL code and stored the procedures using Reports 10g.
• Extensively worked with BA and QA team to fix the defects that are logged in Quality Center.
• Involved in the continuous enhancements and fixing of problems.
• Involved in creating Detail Design Documents for the requirements.
• Involved in formulating general methodologies, naming conventions and coding standards for various procedures and packages.
• Refreshed development/QA environment with production environment.
• Provided DBA support for multiple production, staging, development, QA and test environments.
• Database security - this activity included creating/revoking users, creating roles, grant/revoke roles from users/roles.
• Creating and managing multiple database environments.
• Have some hands-on on Teradata development, ETL
• Also worked on Miscrosoft SQL server database as a part of database developer and application DBA.

Confidential, Atlanta, GA

Sr. Oracle Consultant

Responsibilities:

• Developed PL/SQL Procedures, Functions and Packages and used SQL loader to load data into the database.
• Designed and developed Informatica Mappings in oracle views to load data from Source systems.
• Worked on Informatica Power Center tool - schedule a Job to load the data from source system.
• Created metadata insert and update scripts using excel macros to load the mapping data in metadata table for every release changes.
• Involved Test case/data preparation, execution and verification of the test results.
• Tuning of SQL Queries, Procedures, Functions and Packages using EXPLAIN PLAN and TKPROF.
• Used Bulk Collect feature to improve performance.
• Created DDL scripts, Created database objects like Tables, Views Indexes, Synonyms and Sequences.
• Responsible for requirements gathering from Clients and implement the back end changes in existing product and in designing the database.
• Created automated script to create synonyms for all tables in the schema.
• Created new tables, views, queries for new enhancement in the application using TOAD.
• Extracted data from Flat files and transformed it in accordance with the Business logic mentioned by the client using SQL*Loader.
• Written Procedures and database triggers for the validation of input data and to implement business rules.
• Created database objects like packages, procedures, functions, and triggers and handled errors using Exceptions for implementing role based security access for VIAONE reporting system.
• Tuned the queries using Explain Plan and packages, procedures and functions using sql trace.
• Created technical documentation for all the scripts written for future reference.
• Created indexes on the tables for increasing the performance by reducing the data retrieval timing.
• Performed ETL Process by using Informatica Power Center.

Environment: Oracle9i, Oracle Web Server(OAS),SQL, PL/SQL, Forms6i, Reports 6i, Toad, Java script, SQL*Loader, UNIX,, Perl and Win 2000.

Confidential

PL/SQL Developer

Responsibilities:

• Involved in analysis, database design, coding, and implementing.
• Loaded data into multiple tables using SQL Loader.
• Used extensively PL/SQL, to develop packages, stored procedure, functions and database triggers.
• Tuned SQL queries using TKprof utility to improve performance.
• Used Designer 6i for Dataflow and Entity relationship diagram.
• Designed & developed major input screen using Forms 6i.
• Created calling forms, forms calling reports screen, using stacked, tab canvas on a content canvas.
• Developed procedures, functions for different forms.
• Developed master-detail, drill down, matrix, nested summary detail reports using Reports 6i, which pulled the thousands of records in different formats.
• Used different joins, sub-query, and nested query in SQL query, for reports.
• Extensively used PL/SQL in reports to perform calculation and to get desired output.
• Interacted with end user for problems faced and providing necessary technical support by fixing the bugs.
• Testing, Integration System test, Implementation (test with users) and documented the entire project.

Environment: Oracle 8i (SQL*Plus, PL/SQL),Reports 6i and Linux, Windows 2000.