SUMMARY

• Over 8+ years of IT experience in Design, Development, and Maintenance of Telecommunication, Banking, Insurance, Airline, Pharmaceutical, and Retail Industry Software application needs.
• Excellent conceptual and working knowledge of Oracle (SQL, PL/SQL), MYSQL, 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,Mysql
• 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
• Mysql Experience:
• Experienced in Database optimization and developing stored procedures, Triggers, Cursors, Joins, Views, Cursors and SQL on databases:MySQL, Oracle10g .
• Developed stored procedures, triggers in MySQL for lowering traffic between servers & clients.
• Ability to carry out security tasks at network level such as block/unblock TCP/IP ports through firewall on both Linux and windows and block/unblock remote access to MySQL server.Proficiency in Unix/Linux shell commands.
• Ability to carry out security tasks at network level such as block/unblock TCP/IP ports through firewall on both Linux and windows and block/unblock remote access to MySQL server.
• Proficiency in Unix/Linux shell commands.
• Created and deleted users, groups and set up restrictive permissions, configuration of the sudo files etc.
• Configuring/Installing/Troubleshooting Apache and PHP.
• Created data extracts as part of data analysis and exchanged with internal staff.
• Performed MySQL Replication setup and administration on Master - Slave and Master-Master.
• Documented all servers and databases.

TECHNICAL SKILLS

Programming Language: Java (JDK 1.1, J2SE 1.3/1/4/5.0, Java SE 6), SQL, PL/SQL, C, C++

Web Technologies: HTML,Javascript

Operating Systems: Windows 7/Vista/ XP/NT/2000,ScoUnix, Ubuntu, Solaris, Redhat Server

Version Control: IBM Rational ClearCase 7.0/7.1, Tortoise SVN, CVS

UML Tools: Rational Rose, MS Visio

Methodologies: Agile, RUP, Scrum, XP, Test Driven development

Protocols: TCP/IP, FTP, HTTP/HTTPS, RMI/IIOP, DNS, SOAP

Databases: Oracle 8i,9i,10g, Sybase 11.9/12.0/12.5 , DB2, SQL Server 2000/2005/2008 , MySQL 5.5

Database Tools: Toad for (SQL Server, Oracle, MySQL), Altova DB Spy, MS Access, Teradata

Transaction Control: JTA, Hibernate Transactions.

Application Servers: Web Logic 6.1/7.0/8.1/9.0/10.1 , Jboss 4.2.2/4.3, Apache Tomcat 5.5/6.0,Oracle Application Server

PROFESSIONAL EXPERIENCE

Confidential, Augusta, ME

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.
• StrongMySqlandSQL Serverskills but also significant general system administration skills on UNIX/HP Open VMS, Linux and Windows environment. Proficient writing shell scripts as well as knowledge in general systems administration tasks.
• Experienced in Database optimization and developing stored procedures, Triggers, Cursors, Joins, Views, Cursors and SQL on databases:MySQL, Oracle10g,OMWB tool.
• 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 fraud guard database using data pump.
• Consolidated stored procedure for Data mapping of collateral types using macro for referential database.
• Deployment for fraud guard 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, MysQL,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, Dallas, TX

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 fraud guard database using data pump.
• Consolidated stored procedure for Data mapping of collateral types using macro for referential database.
• Deployment for fraud guard database changes to archive and purge work flow tables data - stored procedure
• TD DB maintenance daily to schedule all jobs.

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

Confidential, Houston, TX

Oracle 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 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, store 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.

Confidential, Chicago, IL

Sr. Oracle 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), MYSQL, 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, Rockford IL

Oracle 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, New York, NY

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, MYSQL,Visual Basic 6.0, UNIX, FTP, TOAD, MS Office (Visio, Excel, Word), Erwin, Windows XP.