SUMMARY

• A highly adaptable IT professional with a total of 9 + Years of experience in Analysis, Development, Testing, implementation in Client/Server Environments and maintenance.
• Expertise in Oracle PL/SQL Programming and SQL
• Highly proficient in developing Oracle PL/SQL packages, stored procedures including Cursors (implicit and explicit), Functions and Dynamic SQL queries.
• Have strong hold on BULK Processing using BULK COLLECT and FORALL
• Experienced in loading data into Oracle tables using SQL * Loader.
• Highly skilled in Error Handling by using User Defined and System Defined Exceptions in PL/SQL.
• Have knowledge on Materialized Views and Query Rewrite.
• Have excellent knowledge on RDBMS concepts.
• Expertise in complex SQL Query writing and PL/SQL programming.
• Experience with Performance Tuning using EXPLAIN PLAN Statement and TKPROF.
• Experience in using Oracle related tools like SQL * Loader, Toad and SQL Developer
• Worked on UNIX and WebSphere servers as part of Cramer 6.2 upgrade to OSS 8.2 in Confidential project.
• Good Understanding of Business rules and ability to work as part of a project team.
• A keen communicator with honed problem solving and analytical abilities.
• Excellent communication skills, self - starter, quick learner and team player.

TECHNICAL SKILLS

Databases & Other Tools: Oracle 9i/10/11g, Oracle SQL Developer, Toad

OSS Tool: Cramer 6.2(RM, Configurator, Task Engine)OSS 8.2 (RM, Metadata Manager)

Business Intelligence Tools: Crystal Reports 9/10/XI/2008

Operating Systems: Windows 2000/2003/XP/7, UNIX

Languages: PLSQL, SQL, JSP, HTML

PROFESSIONAL EXPERIENCE

Senior Oracle Developer

Confidential, Chicago, IL

Environment: Oracle 10g, SQL, PLSQL

Responsibilities:

• Extracting and Loading inventory data from various systems by using PL/SQL packages and procedures.
• Bulk upload /extract of data from databases using adhoc procedures.
• Developed PL/SQL routines for daily checks and automated them on windows scheduler.
• Created temporary tables and materialized views on Oracle Database.
• Performance tuning of SQL queries using Explain Plan to generate efficient monthly and quarterly inventory reports.
• Developed PL/SQL Functions in order to get hierarchy of locations.
• Developed various complex SQL queries and views in order to generate crystal reports.
• Extensively used tools like Oracle SQL Developer and Toad to generate PL/SQL programs.
• Created and maintainedDatabase Objects(Tables, Views, Sequences and stored procedures).
• Involved in debugging andTuning the PL/SQL code, tuning queries, optimizationfor theOracledatabase.
• Used SQL* Loader to load csv files on to database’s temporary tables.
• Developed Summary, Maintenance and Exception reports on database using Crystal Reports XI.
• Maintaining and scheduling crystal reports on Business Objects 3.1 Infoview.
• Adhoc bulk loading Inventory items into DB using PL/SQL scripts.
• DB customizations. For example, PL/SQL callouts.
• Supporting Confidential Services whenever there are any production issues.

Senior Oracle Developer

Confidential, Edison, NJ

Environment: OSS 8.2, Oracle 11g, SQL, PLSQL, UNIX, Web Sphere

Responsibilities:

• Developed PLSQL packages and procedures to migrate Confidential network inventory objects like Locations, Services, Devices, Cards, Links, Circuits, and Generic Entities etc.
• Extensively used Dynamic SQL queries for the purpose of migrating data from Old DB to New DB
• Developed functions and PL/SQL scripts on a daily basis to retrieve/upload/update data.
• Daily coordination with the vendor to get the upgrade status. Was SPOC from Confidential for the upgrade project.
• Created and maintained Users and Roles in Amdocs Security Manager (ASM).
• Installed OSS 8.2 software in various environments like Development, UAT, Contingency and Production.
• Using Amdocs Universal Installer installed various products like Resource Manager, Task Engine, Delivery Engine, Route Finder and Resource Planner.
• Deployed latest Hotfixes in various environment systems to fix product issues
• Cramer 6.2 metadata is upgraded to 8.2 and then generated final XML file to import it to Metadata Manager
• Metadata Manager in Eclipse environment has been setup and base repository has been created using Command Line Operations (CLI) and then distributed to Resource Manager Database after importing Cramer 6.2 upgraded metadata.
• Customization Kit environment has been setup and deployed customized jar files using Installer
• Planned and conducted Training sessions to all Network inventory users and Cramer engineers to get them on par with the new tool.
• Involved in Unit testing of PL/ SQL Stored Procedures, Functions and Packages

Senior Oracle Developer

Confidential, Edison, NJ

Environment: Cramer 6.2, Oracle 10g, SQL, PLSQL, Crystal Reports XI

Responsibilities:

• Extracting and Loading inventory data from other Network Management Systems by using PL/SQL packages.
• Developed integration between NCM and Cramer using PL/SQL Packages and automated to run weekly using windows scheduler.
• Bulk update of attributes of Nodes, Cards, Ports and other inventory items by writing adhoc PL/SQL scripts with cursors and exceptions.
• Developed various complex queries and views in order to generate reports.
• Developed Summary, Maintenance and Exception reports on Cramer database using Crystal Reports XI.
• Maintaining and scheduling crystal reports on Business Objects 3.1 Infoview.
• Adhoc bulk loading Network Inventory items into Cramer using PL/SQL scripts.
• Creating network inventory metadata using Cramer Configurator.
• Cramer front end customizations. For example, JSP customizations.
• Cramer back end customizations. For example, PL/SQL Cramer callouts.
• Supporting Cramer Services.

PL/SQL Developer

Confidential, New York City, NY

Environment: Oracle, Windows Server 2003, Oracle SQL Developer

Responsibilities:

• Involved in understanding the Business flow.
• Wrote SQL and PL/SQL programs to update the data and retrieve any data using cursors and exception handling.
• Extensively wrote SQL Queries using Joins and Subqueries on the Database to retrieve data.
• Created DB links from Test environment DB to Development environment DB.
• Developed views, sequences and synonyms.
• Developed complex SQL queries to perform the back end testing of the Oracle database using SQL.
• Run batch jobs for loading database tables from flat files usingSQL* Loader.
• Used version control tool MKS Integrity

PL/SQL Developer

Confidential, New York City, NY

Environment: Oracle, Windows Server 2003, Oracle SQL Developer

Responsibilities:

• Created Standalone procedures to insert and update tables.
• Created PL/SQL stored procedures with cursors and Functions in order to update/delete/load data.
• Extensively worked towards optimizing the Queries to enhance the performance.
• Wrote complex SQL queries and subqueries using Joins.
• Responsible for developing / maintaining Housekeeping scripts of the DB
• Performed debugging of the PL/SQL codes using the DBMS OUTPUT.
• Dealt Exceptions efficiently using system defined and programmer defined exceptions.
• Experience in application development using various features of Oracle like Bulk Collections, Dynamic SQL, Object types, Records.
• Created Cursors and Ref Cursors in the PL/SQL Blocks.