SUMMARY:

• 16+ years of extensive IT experience in Application Design, Development, Enhancement, Maintenance, Testing and Support of OLTP real time distributed environment having 60+ million subscribers on Oracle 11g/10g databases.
• Highly skilled in Oracle RDBMS applications physical and logical design, SQL, PL/SQL packages, procedures, triggers, materialized views, advanced Oracle techniques including analytical functions, partitions, hints, queues, Oracle schedulers and DBMS pipes.
• Expert in system data migration, upgrade, fallback, data reconciliation between similar and disparate systems using Oracle Technologies and Unix Shell scripting (KSH).
• Expert understanding of Software Development Life Cycle (SDLC) using Agile methodologies, Waterfall methodologies and following quality process like ISO 9001 and CMMI L2.
• High ability to rapidly achieve organizational integration, effectively assimilate job requirements and aggressively employ new ideas, concepts, methods and technologies.
• Skilled in delivering quality solutions with strong analytical and problem solving skills by swiftly resolving critical production or development issues maintaining high availability and maximum performance of the system.

TECHNICAL SKILLS:

Database: Oracle 11g, 10g

Oracle Technologies: PL/SQL, Advanced PL/SQL, Packages, Procedures, Functions, Triggers, Views, Materialized Views, Partitions, RAC, SQL*Plus, SQL*Tuning, Pro*C, Oracle Developer Suite

Languages: SQL, PL/SQL, Java8 (Core Java familiar), XSD, XML, XSL

Scripting: Unix Shell scripting (KSH), Python (familiar), Perl (familiar)

Tools: PL/SQL Developer 8.0.4/7.x, Toad, SQL Developer, SharePoint, IBM Rational ClearCase, ClearQuest, Code Collaborator, Altova XML Spy, Altova StyleVision, Erwin, Rational Rose, Eclipse

Operating Systems: IBM AIX, Linux (RedHat, Oracle), HP Unix and Windows7/XP

WORK EXPERIENCE:

Confidential, NJ

Software Development Specialist

Key projects/responsibilities:

• Designed, developed, tested, implemented, and supported Oracle database applications for Kenan FX, Comverse ONE (C1) Converged Billing and Comverse Real - Time Billing System (RTBS).
• Extensively worked on database design, SQL, PL/SQL, stored procedures, triggers, constraints, functions, collections, dynamic SQL and exceptions handling to in corporate converged service features into existing applications.
• Developed and implemented XML file parsing utility using UNIX shell scripting (KSH) and AWK scripts for FX 4.0 release.
• Effectively implemented Data Model extensions using XSD, XML, XSL technologies by Altova XMLSpy and StyleVision which involved self-learning and development.
• Implemented features on the FX and C1 platform using Java 8 (Collections framework, HashMap, LinkedHashMap, Exceptions), stored procedures, packages, functions, triggers, sequences and ref cursors.
• Worked as a technical liaison for onsite as well as internal teams to perform root cause analysis (RCA), devise and deliver corrective solutions.
• Lead numerous FX, C1 and RTBS features for various releases. All features involved requirement analysis, solution design, designing use cases, high level design document (HLD), detailed design document (DDD), task inventory, unit test plans, milestone chart, code review, test data preparation, unit and integration testing as well as supporting QA team.
• Actively participated in meetings with Product team to discuss business and feature requirements and identify solutions acceptable to Product and end-customer.
• Rolled out/Implemented Materialized Views for data replication in distributed environments.
• Collaborated with Development and Architecture teams locally as well as offshore teams in India, UK and Canada on various projects.
• Created custom data mapping between RTBS and C1 systems. Designed, developed and implemented data migration scripts to convert Product Catalog, Subscriber, Service and Balances data, from Legacy to C1. Supported live customer-data migrations and extended support to achieve system stability.
• Developed reconciliation scripts for data validation and integrity checks, on-demand upgrade patches and fallback scripts as needed by R&D and/or production deployment team. Supported production deployment outside of normal work hours.
• Designed and developed automated extraction, transformation and loading (ETL) of data from operational database to a report server for end-client’s data warehouse (DWH) application using PL/SQL, AWK scripting, SQL Loader, Export/Import utility.
• Assisted with design of the metadata database in support for the plug-in architecture of Real Time Billing System.
• Worked extensively on database stored procedure performance improvement for the FX, C1 and RTBS product; and improved performance of nightly batch jobs by 30%.
• Implemented nightly batch jobs framework to manage and sync subscriber data using Oracle packages UTL TCP, UTL FILE, stored procedures, and advanced PL/SQL techniques in collections, records, and type objects. Design for batch jobs involved different SQL, PL/SQL tuning techniques like hints, indexes, conditional debugging and logging, explain plan and AWR reports to complete the nightly batch jobs execution within off-peak time.

Software Consultant

Key projects/responsibilities:

• Held discussions and meetings with end users and enhanced the system to meet user requirements for expense monitoring of new drug sales for the client.
• Developed new objects for the Expense Monitor module with Forms 5.0, Reports 3.0, sequences, tables, indexes, constraints, and views and integrated with existing ones.
• Worked on solution planning and design, implementation, code review, test plan design and execution, optimized and tuned SQL-code.
• Developed reporting tool to track weekly, monthly, quarterly and yearly - expense and profit reports.

System Analyst

Key projects/responsibilities:

• Lead the project of migrating module objects from Forms 3.0 to Forms 4.5 and Reports 1.1 to Reports 2.5.
• Interacted with the users to determine, understand the new requirements and construct technical specifications for enhancements of Data Bank, Redemptions, and Approved Securities modules.
• Worked on software design, implementation, code review, testing, implementation and production support.
• Enhanced existing system and developed new objects using Forms, Reports, sequences, tables, indexes and views; integration with existing modules.
• Carried out Year 2K compliance activities for the modules.