SUMMARY

• Over 7 years of IT experience in Design, Development, and Maintenance of Telecommunication, Banking, Pharmaceutical, and Retail Industry Software application needs.
• Excellent conceptual and working knowledge of Oracle (SQL, PL/SQL), C, C++, Java, and HTML.
• Proficient in writing Packages, Stored Procedures, Functions, Views and Database Triggers using SQL and PL/SQL in Oracle.
• Data Conversion from Flat files to Oracle using Oracle SQL* Loader.
• Extensive experience in analysis and design of database including ER Diagrams and Normalization techniques.
• Experienced in all phases of Software Development Life Cycle (SDLC) including analysis, specification, software and database administration, development, maintenance, testing and documentation.
• Involved in design, review, implementation, testing and release of databases, sign specifications and application software.
• Experienced in star schema structure design and involved in estimation and optimization of data storage.
• Experienced in Performance Tuning and Optimization of SQL statements.
• Comfortable working with Unit Testing, Debugging, and Deployment of Applications.
• Working Knowledge on Extraction, Transformation and Loading process (ETL).
• Knowledge in design and setup of Backup and Recovery Strategy for various databases.
• Knowledge in Test Scripts, Test Cases, and SQL QA scripts to perform Unit testing, System Testing and Load testing.
• Working knowledge of Migration of Code from Development to Testing, UAT and Production.
• Excellent analytical and communication skills those are required effectively to work in the field of applications development and maintenance.

TECHNICAL SKILLS

• Oracle 11g/10g/9i/8i
• MS Office (Visio
• Excel
• Word
• Access)
• MS SQL Server 2005/2000
• SQL* PLUS
• PL/SQL Developer 9.0
• C
• C++
• Java
• HTML
• Visual Basic 6.0
• TOAD
• PVCS
• Tortoise SVN 1.7.5/CVS 1.12.5
• Putty
• Aginity Netezza
• Python 2.7
• Eclipse
• Notepad ++ 5.7
• Mercury Quality Center
• HP OpenView
• WinZip
• Snag it
• JIRA
• Windows Vista/2003/2000/XP/NT/98
• Unix
• SQL*Loader
• Tkprof
• Informatica Power Center
• Team Track (Serena Business Manager)

PROFESSIONAL EXPERIENCE

Confidential, Cherry Hill, New Jersey

Oracle PL/SQL Developer

Responsibilities:

• Work as part of the IM - Information management DB solution team to design, develop, test, debug, implementation and production of oracle DB applications.
• Developed a PL/SQL Package for GCRM-governance control risk management - the interface for aggregating the lending exposure by lender and customer across retail and commercial credit system for managing loan policy.
• Information Management development, test and production related issues to modify DB objects -stored procedures and packages referenced by tables and views.
• Stored procedures for UCID/ULID unique customer, lender IDs to retrieve detailed lending aggregate exposure.
• Developed DALs for FATCA - foreign account tax compliance act to create one central repository to combat tax evasion by mandating USFIs report certain information on non US accounts to IRS.
• Created database objects such as tables, views, synonyms, indexes, sequences, functions, stored procedures, packages and database link as per business requirements.
• Experience with modifying and deploying database objects - tables, views, stored procedures, triggers, packages, and functions in development environment.
• Data migration of UCLID database objects from BAT to PAT environment.
• Regression test analysis using SQL loader to refresh initial UCLID data load from csv files in DEV, BAT and PAT environment and deploy fraudguard database using data pump.
• Consolidated stored procedure for Data mapping of collateral types using macro for referential database.
• Deployment for fraudguard database changes to archive and purge work flow tables data - stored procedure TD DB maintenance daily to schedule all jobs.
• Data validation and verification for DEV, BAT and SIT environment.

Environment: Oracle 11g, SQL Developer Client for Oracle 3.1.07.42, SQL*Loader, MS Office (Visio, Excel, Word), Tortoise SVN 1.7.5/CVS 1.12.5, Notepad ++ 5.7, Primavera, SQL Developer Unit Test Tool, Windows XP, WinRAR.

Confidential, Englewood, Colorado

Oracle PL/SQL Developer

Responsibilities:

• Developed a DAL (Data Access Layer- PL/SQL Package) for BLOCKBUSTER movie pass for DISH’s commercial and multi- family customers.
• Create Baseline - all database schemas for BT, comparison of database objects between schemas used as the foundation for DDL script moved from DB to TEST and PROD using Eclipse, Notepad ++ and Python script to kickoff the objects - conversion script.
• Billing Transformation development and BT/BAU PROD related issues to modify stored procedures and packages referenced by tables and views.
• A cleanup script, PL/SQL store procedure to clean up millions of record inadvertently added into the table and fixes the bad data - Battery and waives Cleanup.
• Eliminate duplicates DISH customer IDs - store procedure to stop the duplicates occurring, and a data clean up script to fix the bad data.
• Developed DALs PL/SQL Package for LIBERTY BELL - Internet and Phone reseller. Package to load data for Liberty Bell. Store procedures to save and delete service provider’s products and product components.
• Load data for production as a part of Initial reference data setup as ETL process in order to execute during the release.
• Involved in logical and physical Design of database, Data Modeling, and Design Specifications to analyze dependencies.
• PL/SQL Anonymous block for BT to clean and fix duplicate data for race condition occurring on DISH customers contact details.
• Work Order Migration - PL/SQL anonymous Block to migrate CSG work order numbers to ACP work order numbers.
• PL/SQL stored procedure to support the rollouts of the Hopper 2000 (New XIP home DVR receiver) for both BAU and BT units.
• Created database objects such as tables, views, synonyms, indexes, sequences, functions, stored procedures, packages and database link as per business requirements.
• Involved Database Administration of database objects, including tables, clusters, indexes, views, sequences packages and procedures Troubleshoots with regards to database problems and TQA defects.
• Tested new enhancements and bug fixes before deployment into the production environment.

Environment: Oracle 11g, PL/SQL Developer 9.0, MS Office (Visio, Excel, Word), PVCS, Aginity Netezza, Python 2.7, Eclipse, Notepad ++ 5.7, Team Track (Serena Business Manager), Mercury Quality Center, HP OpenView, Windows XP, WinZip, Snag it, JIRA

Confidential, Bloomington, Illinois

Oracle PL/SQL Developer

Responsibilities:

• Built complex queries using SQL and wrote stored procedures using PL/SQL.
• Troubleshoots with regards to database problems and TQA defects, bugs reported by various users and suggesting possible patches to be applied.
• Involved in Logical & Physical Database Layout Design.
• Wrote conversion scripts using SQL, PL/SQL, stored procedures, functions, and packages to migrate data from SQL server database to oracle database.
• Performed Database Administration of all database objects, including tables, clusters, indexes, views, sequences packages and procedures Troubleshoots with regards to database problems.
• Implemented 10G and Upgraded the existing database from Oracle 9I to Oracle 10G.
• Set-up and Design of Backup and Recovery Strategy for various databases.
• Performance tuning of Oracle Databases and User applications.
• Provided user training and production support.
• Developing Control files using SQL*Loader to perform bulk data loads into database tables from external data files.
• Involved in Designing of Data Modeling the, Design Specifications and to analyze Dependencies.
• Responsible for creating and maintaining the packages, stored procedures, functions and cursors.
• Created database objects such as tables, views, synonyms, indexes, sequences and database links as well as custom packages tailored to business requirements.
• Involved in Unit level testing, Module level testing and System testing.
• Involved in preparing functional specifications, release notes, & documentation using Ms-Office.

Environment: Oracle 10g (SQL*PLUS, PL/SQL), SIP, MS-Office, SQL*Loader, Visual Basic 6.0, UNIX, FTP, TOAD, MS Office (Visio, Excel, Word), Erwin, Windows XP.

Confidential, Woodland Hills, CA

Oracle Developer

Responsibilities:

• Involved in the design, review, implementation, testing and release of databases, sign specifications and application software.
• Responsible for installation, upgradation of oracle (8i, 9i) software in different environments, creating and maintaining oracle development and test databases.
• Responsible for synchronizing and merging the payout and deferred databases.
• Wrote and modified Oracle PL/SQL, SQL statements procedures and functions.
• Developed data model for the payout stream using ERwin as a datamodelling tool.
• Responsible for users, roles and privilege management.
• Migrated data from production (AIG) to test the deferred products with development engine.
• Responsible for definition and management of schemas and objects.
• Responsible for schema comparisons.
• Created and maintained quality assurance database along with test case products and features.
• Responsible for enhancements depends on the client’s functionality.
• Supporting and advising developers during databases related issue.
• Rewrite SQL queries to improve the performance of the application.
• Implementing version control on an application system and freezing previous versions.
• Tested the SPIA application on ORACLE 9i database.

Environment: Oracle 10g, Toad, PL/SQL developer, MS Office (Visio, Excel, Word), win2k, Erwin, PRTracker, PVCS, C++, SQL loader.

Confidential, Seymour, IN

Oracle Developer

Responsibilities:

• Involved in gathering Business requirements and implementing the Conversion and Implementation of Software Development Life Cycle (SDLC).
• Responsible for creating and maintaining the stored procedures, Function, Packages and triggers.
• Interacted with the business users on a regular basis to collect business requirements and specifications.
• Providing Security for the Oracle database objects.
• Created database objects such as tables, views, synonyms, indexes, sequences, functions, stored procedures, packages and database link as per business requirements.
• Involved Database Administration of database objects, including tables, clusters, indexes, views, sequences packages and procedures Troubleshoots with regards to database problems and TQA defects.
• Maintaining the Data Base changes according to the client’s requirements.
• Tested new enhancements and bug fixes before deployment into the production environment.
• Worked as part of a team to launch new application releases under strict time deadlines.
• Developing Control files using SQL*Loader to perform bulk data loads into database tables from external data files.
• Tested new enhancements and bug fixes before deployment into the production environment.

Environment: Oracle 10g (SQL*PLUS, PL/SQL), Mainframes, MS Office (Visio, Excel, Word), TOAD, SQL*Loader, FTP, Windows XP.