SUMMARY:

• More than 13 years of progressive hands - on experience in system analysis, design and development, testing, production support and maintenance with a good mix of functional and technical expertise in Banking, Finance and Energy and Utilities Sectors.
• More than 12 years of experience in Design, Development, and Enhancement and Maintaining applications in Oracle 7.3/9i/10g/11g using SQL, PL/SQL, Oracle Forms & Report and Pro*C.
• Substantial development experience in creating PL/SQL program units (Package, Procedure, Function and Trigger) by using PL/SQL advance features such as Native Dynamic SQL, Bulk Collect, Bulk Bind, Collection, Ref Cursor, Pragma Directive, Pragma Autonomous Transaction, Object Type and Exception Handling.
• Substantial development experience in writing SQL Queries using With Clause, Hierarchy Query, Regular Expression, XML function Joins, in-line query and Analytical Functions, Database objects like Views, Synonyms, Constraints, Materialized View, Sequence and Oracle Utilities such as SQL Loader, export/import, data pump and Database Link.
• Extensive experience in SQL Performance tuning using Oracle provided utilities and Objects such as Explain Plan, SQL Trace, TKPROF, SQL Advisor and AWR Report, Hints, Analyze, Gather object level Statistics, Histogram, Indexes and Materialized View in OLTP and DSS systems.
• Good understanding of data dictionary and Oracle supplied Packages such DBMS JOB, DBMS SCHEDULER, UTIL FILE, DBMS XPLAN, DBMS APPLIACTION INFO, UTL MAIL,
• Substantial experience in ETL through Oracle Lodestar mapping, Business Rule implementation and data Transformation by using Rule Language
• Substantial experience in Data Extraction, Transformation and Loading through Informatica Power Center 9.01/9.5/9.6 .
• Excellent understanding on ETL, Dimensional Modeling technique, Slowly Changing Dimension (SCD), and Data warehouse concepts - Star and Snowflake schema, Fact and Dimension tables, surrogate key and Normalization/demoralization.
• Well acquainted with Informatica Power Center applications Designer (Source Analyzer, Target Analyzer, Transformation, Mapplets, Mapping designer), Work flow Manager and Work Flow Monitor and Repository Manager.
• Extensive experience in developing complex mapping from various transformations like Source Qualifier, Connected and unconnected Lookups, Router, Filter, Sorter, Normalizer, Expression, Aggregator, Joiner, Union, Update strategy, stored procedure and sequence generator.
• Substantial experience in interface design, development and scheduling/ monitoring batch processes through Unix CRONTAB, AutoSys and monitoring the batch processing.
• Proficient in providing production support which includes identifying and resolving customer issues and enhancements.
• Excellent analytical, problem solving, debugging, communication and inter-personal skills to manage and interact with individuals at all levels.

TECHNICAL SKILLS:

Languages: SQL, PL/SQL, Pro*C, UNIX Shell Script, and Rule Language (Oracle Lodestar).

Databases: Oracle 11g/10g/9i/8i/7.3, and MS Access.

ETL Tool: Informatica Power Center 9.01/9.5/9.6, Oracle Lodestar (Energy & Utility Sector)

Operating Systems: UNIX (Sun Solaris 10/11, HP-UX 11), Linux (Red hat Linux 4.5/5.2)

Software: Oracle Forms 4.5, Oracle Developer Suite 6i/9i/10g, Oracle Discoverer, Crystal Report, CR Server 2008

Tools: /Others: Oracle Utilities (SQL*Loader, Supplied Packages, Data pump, Import and Export), TOAD, PLSQL Developer, SQL Developer, ER-win, Visio, Toad data modeler, PAC2000, SVN, VSS, HP Quality Center and Incident Management Remedy.

PROFESSIONAL EXPERIENCE:

Confidential,San Francisco, CA

Sr. Database Engineer

Responsibilities:

• Designed and implemented various data base objects such as Procedure, Function, Package, Triggers, Views and Materialized Views.
• Involved in SQL turning and provided optimized queries for various applications.
• Solely responsible to complete database development activities for CSR, BPM and CSAPIs applications.
• Created multiple jobs to load data by using SQL Loader, External table and Shell script.
• Worked with stakeholders, application developer and QA team across unit to identify the business needs and solution option.
• Contributed in Shopping Cart, Visa Check-out, Catalog Migration, Siebel Catalog Migration, and Siebel Upgrade projects.
• Worked closely with Data Architect team to implement the data model changes to meet the business requirements.
• Worked closely with release team, DBA during production release, and provided post release support by providing work around fix on issue.
• Responsible for providing day to day data fixes by using Advance SQL and PL/SQL features such as Bulk Collection, Bulk Binding, Ref Cursor, Hierarchy Query, Analytical Function, Collection and Exception Handling.
• Created multiple dashboard report to monitor the Sales, LMS, Promotion in near real time using the Shell script and Cron job to monitor the change activities and sending out alert email.
• Worked on database rebuild scripts for BPM and Siebel applications. These scripts are using dynamic SQL to set up the environment parameters for rebased development, QA and release environments.
• Worked on BPM purge script to purge the BPM instances on predefined frequency, reclaim the unused space, rebuild the indexes and maintain the table statistics.
• Worked on highly complex E-commerce archival process to move the bulk data from main E-commerce database to archive database and removing achieved data from main E-commerce database using advance features of PL/SQL.
• Created multiple Shell script Cron job to fix the data issue arose due to development bugs or delay in development by different teams

Technologies:Oracle 11g R2, SQL and PL/SQL on Linux, TOAD, SQL Developer, Putty, Shell Script, JIRA, Perforce, GitHub

Confidential, San Leandro, CA

Application Engineer

• Analyzed multiple business requirements and created Functional Design and Detailed Technical Design Documents.

• Developed complex business rules through PL/SQL and SQL for multiple SOR like LCSC AFS, Industry Data.
• Responsible to deliver the officer MDM Phase 2 and ORBT phase 5 database with the help of offshore team.
• Designed generic data bulk upload & Common Business Rule Solution and created multiple PL/SQL Program package, Procedure and Triggers using the oracle advance features like C URSOR, Native Dynamic SQL, Bulk Collection, Bulk Binding, Hierarchy Query, Analytical function, XML and With Clause.
• Worked closely with production support team and resolved multiple SQL performance tuning issue by using EXPLAIN Plan, Query re-writing, Hints and introduced/ Modified Metalized View and indexes.
• Developed multiple Informatica Power Center Mapplets, Mapping and Workflows to uploaded data from multiple source and generate exception.
• Created multiple UNIX Shell Scripts to validate incoming file before it gets consumed by other process for next level of processing.
• Worked closely with WQA team and provided fix to identified defects raised through HP Quality Center.
• Responsible to conduct post deployment knowledge transfer session with production support team on enhancements and new applications.
• Responsible to work closely with production DBA during production release, validate the deployment and provide the support on post release issues.
• Responsible to create the deployment game plan, arrange walk through session with multiple team and seek their approval on deployment approach.

Technologies:Oracle 11g R2, SQL and PL/SQL on Linux, TOAD, SQL Developer, Putty, Shell Script, SVN and HP Quality Center, AutoSys, Informatica Power Center 9.01 & 9.6, IDQ, PAC 2000

Confidential

Senior Database Developer

Responsibilities:

• Responsible to analyze the business requirements and created high level and low level design documents.

• Developed multiple PL/SQL program units by using Oracle advance features such as REF CURSOR, Native Dynamic SQL, Object Oriented Programing, Collection, Bulk Collection, Bulk Bind, Hierarchy Query, Analytical function and With Clause.
• Developed multiple ETL Program units for data extraction, and transformation and uploaded to data warehouse system.
• Extensively used Oracle supplied Packages such as UTL FILE, DBMS LOB, DBMS APPLICATION INFO and DBMS STAT, DBMS XPLAN, DBMS UTILITY, DBMS SESSION, and DBMS SCHEDULER.
• Worked closely with QA team and resolved the identified bugs.
• Worked closely with deployment team to resolve deployment and back out related issue.
• Created multiple UNIX shell scripts to execute the PL/SQL Program unit at scheduled time through AutoSys.
• Used TKPROF and EXPLAIN PLAN to tune SQL queries using hints, re-writing the query and introducing new indexes.
• Test case /data preparation, execution and verification of the test results.
• Used SQL*Loader to upload the received flat files to staging tables.
• Used Toad to develop the code and Toad Code Expert to generate the code matrix which includes Computational Complexity (Halstead Volume), Cyclomatic Complexity (McCabe's) and Maintainability Index (MI)

Technologies:Oracle 11g R2, SQL and PL/SQL on HP UNIX, TOAD, AutoSys, Shell Script, Perl Script, SVN and HP Quality Center

Confidential

Senior Database Developer

Responsibilities:

• Analyzed the new business requirement, involved in impact assessment and estimation.

• Modified High Level, Low level Design, Conceptual Model, and Logical Modeling according to new business requirement and in corporation of post review comments.
• Created low level design document, unit test case and created test data and data validation scripts.
• Created / modified multiple Oracle PL/SQL Program Units (Packages, Procedures, Functions, and Triggers) and introduced Oracle 10g and 11g new features.
• Extensively worked on SQL Performance tuning by introducing new indexes, and using oracle utilities like EXPLAIN PLAN, TKPROF and HINTS.
• Worked closely with DBA team during database migration from Window Based Oracle 9i to Unix Based 10g and later on Oracle 11g.
• Developed multiple PL/SQL Program units with Oracle Advance features such as Bulk collect, Native Dynamic SQL, Collections and Collection API.
• Analyzed and gather database schema statistics to achieve the benchmarked performance.
• Improve the error handling process by introducing DBMS UTILITY to Format Error Back trace.
• Change the job scheduled process by replacing the existing DBMS JOB by DBMS SCHEDULER.
• Used data pump to importing and exporting data at table level and schema level.
• Test case/data created for all the changes and tested these changes.
• Replaced existing widow script with Unix Shell script for automated processing of incoming data files from multiple sources.
• Developed multiple Inbound and Out bound interfaces on ETL concept through custom PL/SQL Programing, SQL* Loader, Pro*C Program and Oracle Lodestar.
• Configured Crystal Server 2008, Migrated and deployed Crystal report to XI.
• Created deployment and release instruction for UAT and production environment.
• Worked closely with QA team and deployment team.

Technologies: Oracle 9i/10g/11g, Solaris UNIX, Visual Source Safe, Visual Basic 6.0, Crystal Report XI, CR server 2008, PLSQL Developer, MS Outlook and OR tool.

Confidential

Tech Lead /Sr. Database Developer

Responsibilities:

• Involved in analyzing the business requirement / CR, impact assessment and resource planning and estimation.

• Modified high level design documents, Conceptual model and Logical Model in line with the business requirement changes. Co-ordinated with DBA team to implement data base physical design changes.
• Created Low level design documents, developed multiple Oracle Forms and Unit tested them.
• Created Low level design document and developed multiple re-useable Oracle Form Program Units and Libraries.
• Created Module Specification, developed multiple PL/SQL program units (Package, Procedure, Function and Trigger) and used PL/SQL Advance features such as Native Dynamic SQL Statement, Bulk Collect, Collection, Autonomous Transaction, Ref Cursor, Parameterized Cursor and Object Type.
• Designed and Developed multiple Batch programs, outbound interfaces using Pro*C program and used Oracle supplied UTL FILE package.
• Replaced obsoleted oracle provided job scheduling package DBMS JOB to DBMS SCHEDULAR across CVA application and validate this changes unit testing.
• Extensively worked on SQL Performance tuning to resolve the post migration performance related issues and gathered table level statistics.
• Substantial involved in SQL Performance tuning by using SQL Hints, used oracle Utility TKPROF, Oracle supplied package DBMS XPLAN for explain Plan and introduce new indexes, rebuild and changed index key columns.
• Designed Report output formats, complex filtering and formula calculations, as well as the rendering of multi-band and multi-grouped reports.
• Designed and developed multiple inbound interfaces using SQL* Loader, UNIX Shell Script, PL/SQL Program and Pro*C programs.
• Modified three major outbound settlement data files generation by making the necessary changes in legacy Pro*C Programs. These data files send across Electricity market in United Kingdom.
• Involved in designing imbalance settlement calculation change. It is a moderated complex process, National Grid, UK uses balance mechanism to balance the Electricity system.
• Introduced DBMS APPLIACTION INFO in long running batches to monitor the progress of the batch processing.
• Developed data upgrade script for Energy Contract Volume Aggregation Agent (EACAA). This script identifies all Exempt Export BMU from CRA system and goes through all current BMU in ECVAA system, update CCQ Status and Dip Flag to correct value.

Technologies: Oracle 9i/10g/11g, Solaris UNIX, PL/SQL, Oracle Forms & Report, Oracle Application Server, Pro*C, PL/SQL Developer, Perl Script, Shell Script, Erwin, Visio SVN, Kfig, OR Tool and HP Quality Center.

Confidential

Sr. Database Developer

Responsibilities:

• Migrated more than 50 Oracle Forms from 6i to 9i, Unit tested, performance bench marked, fixed and deployed in N-tier architectures.

• Migrated PL/SQL programs and Pro*C programs from ORACLE 9i to 10g later on 11g, Unit tested and Bench mark performance tested. Worked with DBA in schema stats gathering.
• Substantial involved in SQL Performance tuning by using SQL Hints, used oracle Utility TKPROF, Oracle supplied package DBMS XPLAN for explain Plan, DBMS SESSION to enable the session level tracing.
• Replaced obsoleted Oracle supplied DBMS JOB with DBMS SCHEDULAR across the SVA and FAA applications scheduled interfaces.
• Created high Level Design and Low level design documents, Conceptual Model, Logical Modeling, Physical Modeling, Developed and Unit tested Electronics notification and delivery system for FAA application to replace the legacy FAX and Physical Post mechanism to deliver the across the Electricity industry as part of go green initiative.
• Developed/Modified new oracle reports such as backing sheet, Ledger report. VAT summary, Combined Advice Notes, Combined Confirmation Notes and Backing sheets.
• Worked Closely with QA team and assisted them to create/modify IVT (installation Verification Test), System test script and created performance Bench Mark Test scripts.

Technologies: Oracle 9i/10g/11g, Solaris UNIX, PL/SQL, Oracle Forms & Report, Oracle Application Server, Pro*C, Perl Script and Shell Script

Confidentia

Sr. Database Developer

Responsibilities:

• Analyzed the business requirement and Created low level Design document for data migration for Combined Appliances of Banner Application.

• Developed multiple Pro*C Programs to migrate the existing data to new database design.
• Performed unit testing to validate correctness of transformed data and Co-ordinate with QA team during multiple phases of testing

Technologies:Oracle 9i on Solaris, SQL, PL/SQL, Oracle Forms 4.5, Pro*C and Kfig