Jr. Oracle PL/SQL Developer

Summary:

• *-* years of IT experience in Design, Development, and Maintenance of Telecommunication, and Retail Industry Software application needs. Experienced in all phases of Software Development Life Cycle (SDLC) including analysis, specification, software and database administration, development, maintenance, testing and documentation. Excellent conceptual and working knowledge of Oracle (SQL, PL/SQL), C, C++, Java, and HTML. Involved in design, review, implementation, testing and release of databases, sign specifications and application software. Working experience with Unit Testing, Debugging, and Deployment of Applications. Excellent analytical and communication skills those are required effectively to work in the field of applications development and maintenance. Extensive experience in analysis and design of database including ER Diagrams and Normalization techniques.

Education: Bachelor’s of Engineering (Information Technology)

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, 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, SQL*Loader, Team Track (Serena Business Manager).

Projects Summary:

DISH Network, Englewood, Colorado AUG/2011 – Present

Oracle PL/SQL Developer

DISH Network is the leader in TV technologies, family entertainment and high definition TV programming. DISH is the value leader among all television providers offering the most choices for programming and technologies including TV everywhere, BLOCKBUSTER @ home and XIP Hopper HD DVR. The BT project is to transform from BAU - Business As Usual to BT - Billing Transformation and used by BT teams to log development integration related issues and DISH’s IT standard projects.

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 Packages 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.

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

Contact this candidate