PROFESSIONAL SUMMARY

• 7 plus years of IT experience as an Oracle Developer on a variety of UNIX (Solaris, Linux), Windows 2000 /2003/ XP platforms with Oracle 9i/10g/11g.
• Experience in all phases of the project Life cycle - Requirement gathering and Analysis, Database design, Database development, Application development, Test, Implementation and Support.
• Proficient working experience with SQL, PL/SQL, Database objects like Stored Procedures, Functions, Packages, and Triggers.
• Strong in Designing, Development (coding), Testing, Implementation and Documentation as per Industry standards.
• Experience working, delegating, and hand over and task management with the offshore teams.
• Experience in developing OLTP applications for Bill pay and billing systems and tuning the applications for optimal performance under heavy loads.
• Experience in data migration activities like Export and Import, data scrubbing using Oracle data pump.
• Hands on experience in developing financial applications relating to fund transfer, fund flows, merchant and payment processors.
• Experience in coding PL/SQL packages using credit and debit logic.
• Experience in implementing telecom billing business and data bashing across various platforms like Purchase, SSP, and Ordering.
• Worked on Oracle development tools like SQL Developer, Oracle Enterprise Manager, PL/SQL Developer, and used TOAD in many development projects.
• Good at Shell scripting and Pearl scripting and used Crontab for scheduling jobs regularly.
• Extreme experience in using SQL*Loader for loading data into single table and multiple tables.
• Experience in developing External Tables, Joins, indexes and Database Triggers.
• Extremely used of the latest features to optimize performance like Bulk Binds, Bulk Collect, Ref. Cursor and Sys ref cursor.
• Proficient in using advance features for PL/SQL programming like Using cursor variables, Ref. cursors, System Ref. cursor and Dynamic SQL.
• Experience in creation of table partitioning by range, list, hash, composite methods and indexes for managing large tables, normalization and de-normalization.
• Good noledge in using PL/SQL Wrappers to protect the PL/SQL procedures and packages.
• Worked on Informatica sessions/mappings /transformations.
• Self-motivated, able to set TEMPeffective priorities to achieve immediate and long-term goals and meet operational deadlines. Able to work independently and as team member.
• Worked as a Team member in performing tasks such as Strategic Planning, Logical and Physical Data Modeling & Application Performance Tuning.
• Experience in working Agile Methodology.

TECHNICAL SKILLS:

Databases: Oracle 11g, Oracle 10g, Oracle 9i, MS-Access, SQL*Plus.

Environment: UNIX (Sun Solaris, HP-UX, AIX), Windows NT/2003/2000/XP/98

Programming and GUI: SQL*Loader, Export / Import, Expdp / Impdp, Oracle Wrap, FTP,SFTP, Cute FTP, PL/SQL, SQL*Plus, TOAD, PL/SQL developer, SQL Navigator, UNIX Shell Scripting, BODI

Languages: SQL, PL/SQL, Shell Programming, C

Reporting Tools: Developer 2000, Oracle Forms 6i/9i, Reports 6i/9i, Discoverer.

Job Scheduler: Tidal, Autosys, Oracle job scheduler.

Management Tools: PM Tools: MS Project 2010, Methodologies: SDLC & AGILE

PROFESSIONAL EXPERIENCE

Confidential, Santa Monica, CA

Oracle PL/SQL Developer

Responsibilities

• Extensively involved in System Study & Business Requirements Analysis.
• Involved in the preparation of Functional Specs as part of the solution team.
• Co-ordination with the Business for the requirement and translate the business needs into Technical design.
• Strong analytical skills in resolving and providing solutions.
• Handling Major /Minor Enhancements for the application.
• Involved in MIGRATION of source systems from Oracle to Teradata.
• Responsible in Designing and development of Logical& Physical Data models, Forward and Reverse engineering using Microsoft Visio.
• Responsible to process towards finance reporting for rebate payout's to the partners quarterly.
• Provided support to the Finance team in accessing the reports.
• Developed PL/SQL Packages, Functions and Procedures to implement the Business Logic using Bulk collect, bind variables, Ref cursors, dynamic SQL’s.
• Create Oracle Partition tables like Range/List/Hash/Composite.
• Developed shell scripts for batch processing and database transactions.
• Tuning complex queries using Query Optimizer hints, joins and indexes.
• Create CTL files and UNIX shell scripts to read, move and processed data files. Use multiple different ftp servers for file delivery and receipt.
• Created conversion payment dues data for 2013 to run for the Future Year as well as performed complex conversions using PL/SQL packages, stored procedures, cursors for the Current Year data.
• Perform data migration/replication between database instances.
• Developed a Status Report using PL/SQL Collections to pass multiple input values; which ran the report based on the hierarchy of State/Local/Individual members.
• Developed a backend application to capture credit card transactions, EFT/ACH transactions and various other fund flows from NEA to Bank of America on a per state basis.
• Worked on the solution designing and giving inputs to handle complex solutions.
• Worked on the design of Business Objects Universe and developed the web intelligence reports as per the business requirement.
• Worked on UNIX-shell Scripting.
• Handled errors usingException Handlingextensively for the ease of debugging and displaying the error messages in the application.
• Prepared the technical document as per the Functional specifications.
• Worked on Informatica sessions/mappings /transformations.
• Worked on queries using Teradata SQL assistant.
• Provided support during the UAT/BAT/QA phases.

Environment: Oracle 11g, PL/SQL, Toad 10.6.13, Informatica 9.1.0/9.5.1, SSH Tectia, Windows 2003/XP, UNIX, Microsoft Visio

Confidential, Seattle, WA

Oracle PL/SQL Developer

Responsibilities

• Work on multiple projects and multiple database instances at the same time.
• Directly work with business stakeholders to receive and process data per existing processes.
• Create and edit stored procedures and functions to address new business requirements.
• Design, modify and update database tables, setting up indexes, data constraints, database views, and referential integrity.
• Write SQL codes to modify business rules to validate and load on database.
• Create and maintain scripts with SQL loader to perform data loads for multiple DB instances.
• Create CTL files and UNIX shell scripts to read, move and processed data files. Use multiple different ftp servers for file delivery and receipt.
• Perform data migration/replication between database instances.
• Write PL/SQL procedures, packages, materialized views and develop other database scripts like tables, synonyms, sequences, triggers,
• Handle tables, index and partitioning and Involved in data cleaning, merging and conversion
• Worked on agile and test driven environment, participated on daily scrum meeting, discuss and finalize road blocks.
• Use JIRA as the defect tracking system.
• Interacted with production support team regarding production issues.
• Familiar with both OLTP and Data Warehouse environments.
• Debug and optimize performance ofPL/SQLcode.
• Aggregate/window functions and commonly used OLAP functions and exception handling
• Maintain and Monitor Autosys job scheduler, Pearl watchers to monitor file loaded in FTP by line of business

Environment: Oracle 8i/9i/10g, Toad 9.0, PL/SQL, SQL, ERWIN, UNIX, BODI, Informatica Power Center 8.1

Confidential, Miami, FL

Oracle PL/SQL Developer

Responsibilities:

• Heavily involved with the Logical and Physical Design of the Database.
• Creation of database objects like tables, views, procedures and functions.
• Developed PL/SQL-Packages, SQL Scripts and Database Triggers for making history of insertion, updating, deletion and all kind of Audit routines.
• Used various Joins for data retrieval from multiple tables according to the requirement.
• Developed a billing application using Oracle Collections and ref cursors to pull up customer data based on Business account numbers and speed up data retrieval process.
• Handled a lot of OLTP data and applied various performance tuning methods to speed up the data retrieval process like using bulk collect mechanisms, hints, distinguishing between driving tables in joins, function based indexes.
• Migrated data amounting to 3 billion rows per table across 10 different Oracle databases.
• Worked on data migration activities like invoking Export, Import and Data pump from the UNIX shell script.
• Involved in Performance Tuning for the SQL, PL/SQL scripts using EXPLAIN PLAN, HINTS, and DBMS PROFILER.
• Used crontab, dbms job and dbms scheduler for scheduling of jobs.
• Used Dynamic SQL for Query Optimization and by using dis dynamic sql it increases the performance and also to perform error detection and cleanup.
• Involved in Doing Partitioning and Sub partitioning on table to improve performance.
• Worked on User-defined and System defined exceptions to handle different types of Errors.
• Used SQLCODE and SQLERRM for the exceptions error code.
• Extensively worked on SQL Loader for loading data into tables from flat files and CSV files.
• Experience in using packages like DBMS JOBS, DBMS SCHEDULER to schedule tasks.
• Extensively used FORALL and BULK COLLECT to fetch large volumes of data from table.
• Using the Crontab in UNIX and Scheduler in windows for Automatic Tasks (Analyzing tables, loading into Tables, Imp/Exp).
• Developed UNIX shell scripts (Korn/Bourne/bash) for routine tasks.
• Used rollup, cube operators, merge with insert and update statements.
• Developed flat files using UTL FILE Oracle supplied packages.
• Creating and worked with GTT (Global Temporary Table).
• Used various forms of control structures including CASE, DECODE, IF-THEN-ELSE, FOR loops while developing procedures.
• As a team member, involved in interacting with business users, gathering business requirement.
• Provided 24x7 on-call supports. Worked beyond regular hours based on business demands.

Environment: Oracle 10g, Solaris 5.10, UNIX, Windows XP, SQL Developer

Confidential, Mt Prospect, IL

Oracle PL/SQL Developer and Data Migrations

Responsibilities:

• Gathered the Requirement from the business user and prepared the program specification and design document.
• Completely involved in migrating data to Epic applications in a text file format and transferring the data onto the FTP Server which is accessible to the interface team.
• Involved in analyzing the root cause for the missing data and providing the missing data from the Extracts for Testing.
• Extensively worked in providing updated records of the NTN Bearings on weekly basis by comparing with the previously-Exported NTN bearing records.
• Involved in keeping track of previously-Exported Bearings and archived them for future reference purpose.
• Created the PL/SQL packages, procedures, functions applying the business logic to update the Bearings database.
• Created custom triggers to automatically populate different tables and also to restrict the data being inserted to the timesheet tables.
• Design and developed the scripts to create table, views, indexes and sequence.
• Created the custom tables to import the Bearings data and insert into the database tables.
• Developed the SQL*Loader scripts to load data into the staging tables from the flat files.
• Extensively used DTS package in Migration of the data from the previous timesheet database in SQL Server database to Oracle 10g.
• Extensively involved in tuning the queries and applying hints for faster and better performance of the SQL queries.
• Used Perl Scripting in moving the files faster to the Archive folders.
• Used FTP to transfer the files into different servers as per needed by the business users.
• Involved in preparing BRD, functional document, user document, process flow diagram and flow charts.
• Created the test scripts and complex queries to test the application and to quality assurance of the data.
• Involved in preparing test plans, unit testing, System integration testing, implementation and maintenance.

Environment: Oracle 9i/10g, SQL Server, PL/SQL, SQL*Plus, SQL*Loader, TOAD 10, FTP, DTS package, MS- Office, UNIX (Putty), Perl Scripts, MS Office, MS Visio.

Confidential

Oracle PL/SQL Developer

Responsibilities

• Involved in planning, control and implementation of the DBMS using SDLC
• Involved in Requirement gathering & Analysis, Database designing and normalization of database tables.
• Used a CALL statement enables you to call a stored procedure, rather TEMPthan code the PL/SQL body in the trigger itself.
• USED SQLCODE returns the current error code from the error stack SQLERRM returns the error message from the current error code.
• Involved in the development of database objects.
• Involved in Oracle User creation & assigning Roles & Privileges.
• Involved in Doing Partitioning and Sub partitioning on table to improve performance.
• Used the pragma Exception Init to name the system exceptions that are raised by the program.
• Wrote UNIX shell scripts to automate the daily process as per the business requirement.
• Writing SQL queries for data retrieval involving complex join conditions.
• Wrote stored procedures, functions, Packages, Triggers.
• Involved in writing cursors and ref cursor.
• Used Import/Export utilities of Oracle.
• Wrote complex SQL queries including inline queries and sub queries for faster data retrieval from multiple tables.
• Created and managed primary data base objects such as Tables, Views, Indexes Sequences and Synonyms.
• Good exposure in creating and maintaining UNIX Shell scripts.

Environment: Oracle 9i, Windows XP, PL/SQL, SQL*PLUS, SQL Developer, UNIX

Confidential

Oracle PL/SQL Developer

Responsibilities:

• Developed PL/SQL queries to obtain historical data.
• Developed BTEQ scripts to migrate huge volumes of data (in order of hundreds of millions) from Oracle to Teradata.
• Extensively used bulk Collects to code Procedures.
• Created PL/SQL packages, procedures and functions necessary for validations before loading records into interface tables.
• Used Exception Handling for validation of input and the ease of debugging.
• Created database objects like views, sequences, synonyms, database links required by the application.
• Managed queries, enhanced and supported service issues.
• Developed ETL objects (mappings, sessions and workflows) as per the business requirements
• Prepared Code Migration Document in order to deploy the code in testing and production environments.
• Coordinated with QA and Production support teams during code deployment in their respective environments.
• Involved in modeling, development of Metadata.
• Post Production Support for 2 months after code deployment in production environment.
• Coordinated daily activities with global team in a distributed environment.
• Maintained project document repository for ETL Objects, database objects, UNIX objects, mapping information, unit test cases, dollar audits, deployment plan, replic jobs etc.
• Coordinated component, system testing with the appropriate technical groups and Release Management and documented test procedures and findings.
• Reconciled test results from different tests and different groups. Assessed readiness and deviation of product/project performance based upon test results and product specifications.
• Worked with Excel Pivot tables.
• Written complex SQL queries for validating the data against different kinds of reports generated by Business Objects XIR2
• Worked on profiling the data for understanding the data and mapping document.
• Developed Access databases and associated graphical user interfaces.
• Involved in extensive DATA validation using SQL queries and back-end testing
• Used TOAD Software for Querying ORACLE and Used WinSQL for Querying DB2.
• Written several UNIX scripts for invoking data reconciliation.
• Tested the reports using Business Objects functionalities like Queries, Slice and Dice, Drill Down, Cross Tab, Master Detail and Formulae etc
• Responsible for testing Business Reports developed by Business Objects XIR2
• Prepared and ran regression scripts, shell scripts and performed sanity tests and end-end testing.

Environment: Oracle 9i, Toad 8.0, PL/SQL, SQL* Loader, UNIX, share point, SVN, Forms 6i, ETL, Informatica, Power Center 8.1, JIRA, Autosys.