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.

Skillset:

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 .

Projects Summary:

Confidential

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

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

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

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

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.