SUMMARY:

• 9 yrs. of IT industry experience encompassing a wide range of skill set, roles and industry verticals.
• Working experience as Oracle application DBA for multiple legacy and COTS applications.
• Strong database programming knowledge in ORACLE PL/SQL (Stored Procedures, Functions, Packages, DB Triggers, Materialized Views, DB links, PL/SQL Types, External Tables, Merge Statements, Global Temporary Tables (GTT, Ref Cursors, Dynamic SQL, Bulk Collects, Collections, Pipeline Functions).
• Ability to create and manage Tablespaces, Indexes, Partitions on tables for tuning the database and enhance performance.
• Proficient in writing and tuning Complex SQL statements, complex joins co - related sub-queries and SQL statements with Analytical functions.
• Creating and loading data files (fixed format, csv format, comma separated etc.) from server to database using SQL LOADER.
• Working experience in RAC environment and Oracle Exadata.
• Expertise on Oracle 10g &11g having working experience on SQL*plus, SQL Developer and TOAD tools.
• Experience in the field of Software Design, Development and Implementation life cycle (SDLC) including analysis, design, architecture, development, testing, implementation, and maintenance and production support of application software.
• Developed UNIX shell Scripts to run the scheduled jobs in production environments.
• Experience in writing the UNIX shell scripts to automate manual processes.
• Experience in scheduler tool like ROBOT SCHEDULER and REDWOOD.
• Knowledge of core java and its concepts.
• Working knowledge of Perl and Windows batch scripting.
• Experience on Agile Methodology Projects and usage of Rational Team Concert tool during various iterations.
• Proficient in analyzing and translating business requirements to technical requirements and architecture.

TECHNICAL SKILLS:

Operating Systems: UNIX, HP-UX, Solaris, Windows NT

Primary Skills: Oracle SQL, PLSQL, Oracle application DBA, Unix Shell scripting

Secondary Skills: C, Core Java, Pentaho Kettle ETL, Perl scripting

Tools: Toad, SQL Developer, Eclipse 3.2.

Database: Oracle 10g, 11g

Billing System: Oracle BRM 7.3.1

PROFESSIONAL EXPERIENCE:

Confidential, PA

Senior Oracle PL/SQL developer

Responsibilities:

• Tune the SQL queries whenever there is a performance issues. Study the AWR reports to identify the bottlenecks in the system and take corrective actions.
• Working with Single view, CLIPS and century systems to generate subscriber files for Amdocs migration using Oracle SQL.
• Working on Pentaho Kettle tool to create jobs and transformation for different ETL requirements.
• Writing SQL, PL/SQL queries to extract data from different source systems.
• Working on the UNIX framework to automate ETL jobs using shell Scripting.
• Create new database objects such as triggers, packages, procedures for application developments, enhancements and releases.
• Work with Oracle system DBA teams to resolve any database performance issues.

Confidential

Senior Oracle PL/SQL developer

Responsibilities:

• Working on refreshing the schemas using dump files, import and export of tables.
• Tune the SQL queries whenever there is a performance issues. Study the AWR reports to identify the bottlenecks in the system and take corrective actions.
• Worked on character set change from US7ASCII to AL32UTF8 in CC database to support foreign characters in the database.
• Worked as onsite coordinator which involves assigning work to the offshore team, code review, get the work status from team and monitor the progress of print module during different phases of project.
• Maintain the multiple data models for the different applications and ensure that they are in sync with the latest enhancement of the functionality.
• Maintain the existing SQL and PL/SQL code and perform the changes in the code as per requirement for enhancements and releases.
• Create new database objects such as triggers, packages, procedures for application developments, enhancements and releases.
• Work with Oracle system DBA teams to resolve any database performance issues.
• Creating the UNIX shell scripts to schedule batch jobs in the redwood scheduler and writing scripts to execute data patches in the database.
• Involving in design, coding and unit testing phase of the projects as part of enhancements or new functionality implementation.

Confidential

Senior Oracle PL/SQL developer

Responsibilities:

• Worked as onsite coordinator which involves assigning work to the offshore team, code review, get the work status from team and monitor the progress of print module during different phases of project.
• PL/SQL development (functions, packages, procedures, triggers, Anonymous Block)
• Involved in the development of print module for Pennsylvania property from beginning until the complete rollout.
• Involved in print design, development and onsite co-ordination.
• Worked on the defect fixes and support activities during Integration and User acceptance testing phases of testing.
• Involved in support during the production code deployment.
• Worked on writing the new packages and procedures for print module, which extract data from different table and generate xml, which will be used to generate declaration pages, Invoices, Notices.
• Worked on existing code modification to in corporate business requirement for PA State.
• Involved in code review and performance tuning of the code when required.

Confidential

Oracle PL/SQL developer

Responsibilities:

• Worked on modifying PL/SQL packages to generate General Ledger report.
• Written new procedures to load CDR data from Moses into BRM system.
• Worked on partitioning the event tables for performance increase of database.
• Worked on various revenue report changes and tax report changes.
• Worked on the collection configuration and code changes to support the Speakeasy accounts.
• Worked on the UEL rating to upload the pre-rated CDR’s from Moses.
• Written unix shell scripts to automate the call detail record uploading process.
• Wrote a MTA application to send dunning notifications for invoice accounts pay type as postal.
• Creating new UEL templates for rating the VOIP CDRs, GRAS rating CDRs in during the Mega Path migration.
• Worked on partitioning the event tables for performance increase of database.
• Written price change utility to purchase/cancel/update product using a UI which can be used by the business users.
• Written migration scripts which are used for migration of the data on new matrix platform.
• Worked on adding new entry for FUSF tax in GL revenue table.
• Worked on creating a new journal entry JE5 for capturing the unearned revenue in future month.
• Wrote audit scripts to match the amount in GL interface tables and BRM database.
• Customized the C application written to purchase the regulatory surcharge amount for the accounts while billing.
• Customized the pre bill info to avoid creating accounts with small billing cycle.
• Involved in the deployment during first and second phase of migration.
• Involved in resolving support tickets raised post migration.
• Worked 4 months in client site at San Jose USA, for knowledge transfer and development activities.