Experience Summary

• A dynamic professional with eight years and one month of experience in Software Development as a Database Developer.
• Expertise in Database Design and Development using Oracle 12c/11g/10g, PL/SQL back end applications SQL Developer, PLSQL Developer, SQL Navigator and Toad.
• Proficient in PL/SQL programming Stored Procedures, Functions, Packages, SQL tuning, and creation of Oracle Objects Tables, Views, Indexes, Constraints, Materialized Views, Triggers, Sequences, Synonyms, Database Links, and User Defined Data Types.
• Experienced in Dynamic SQL, PL/SQL Collections and Exception handling.
• Experience in advanced PL/SQL concepts like Multi Table insert, PL/SQL table, Cursors, Nested tables, Varrays, Records and Types for DML operations for better performance.
• Experience in Performance Tuning by analyzing tables, hints, DBMS Profiler, SQL Trace, Explain Plan, Bulk Collect feature, FORALL statements, and Troubleshooting Oracle database issues.
• Experienced in Tuning Queries for better performance with large volume of data.
• Experience in handling very large data files using Export-Import utilities.
• Developed complex triggers using PL/SQL for data integrity and enforcing business rules.
• Intermediate working knowledge in Core java and UNIX Shell Scripts.
• Intermediate working knowledge in implementing ETL Extract, Transform and Load by using Oracle Warehouse Builder.
• Expertise in Product and Tariff Configuration of the Rating and Charging Engine CSG SingleView.
• Expertise in all aspects of SDLC requirement analysis, technical specifications, Logical and physical design, development, testing, documentation, implementation and maintenance in multi-tier and client/server architectures.
• Excellent analytical, problem solving, communication and inter-personal skills to manage and interact with individuals at all levels. Able to interact effectively with other members of the Business Engineering, Quality Assurance and other teams involved with the System Development Life cycle.
• Excellent verbal and written communication skills and the ability to interact professionally with a diverse group, including executives, managers, and subject matter experts.

Technical Qualifications

• Operating Systems : Windows 7, HP-UX, UNIX and LINUX.
• Languages : PL/SQL, Core Java, HTML5, java script, Shell Scripting.
• Databases : Oracle 11g/10g/9i.
• Tools : Oracle Warehouse Builder, Toad, SQL Navigator, SQL Developer, PL/SQL Developer, Magic Draw, Eclipse, Visual SourceSafe, Subversion, Perforce.

Professional Experience

Confidential

Oracle Developer

• CBF handles the complete billing process from bill calculation to the generation of invoices and statements.
• Module: Bill Time Discount BTD and Bill Time Bonus BTB - Bill Time Discounts and Bill Time Bonuses are one of many possibilities for an Operator to reward customers for behavior the operator wants to encourage e.g. to make more calls and to increase customer loyalty.
• Module: Journal Calculation Process JCP - Journal Calculation Process converts Billing Data into Journal Data for the purpose of booking customer billing related financial transactions to a General Ledger G/L System.
• Roles Responsibilities:
• Knowledge gathering of data models and identifying database tables and fields required for implementation of BTD/ BTB/ JCP.
• Extensively used PL/SQL programming for functions, procedures, packages to implement the functionalities.
• Interacted with team and with clients during implementation and analyzed new business requirements and enhancements.
• Created complex Oracle views, stored procedures, functions, packages, tables triggers, data modeling analyzing data.
• Involved in writing Procedures, Functions, Triggers, Cursors, Dynamic SQL and Views.
• Experience in creating different DB objects like views, sequences, synonyms etc.
• Worked with PL/SQL result cache, Collections, Bulk Collection techniques for speed optimization.
• Worked with temporary database tables for intermediate data processing and manipulation for faster performance.
• Involved in writing Test Cases and Test Codes using Test Driven Language and FitNesse.

Environment: Oracle 11g, SQL Developer, PL/SQL Developer, SQL LOADER, SQL PLUS, UNIX, Perforce, NX Client, FitNesse.

Confidential

Oracle Developer

• CBF handles the complete billing process from bill calculation to the generation of invoices and statements.
• Module: Re-rating Processor RRP - financial correction for un-billed customers and reprocessing and rating of bad events.
• Roles Responsibilities:
• Knowledge gathering of the pre-existing code base of Re-rating Application.
• Configuration of rating engine and event formatter and dispatcher module for processing event details records to be re-rated.
• Writing Stored Procedures for retrieving faulty events that are processed incorrectly.
• Developed unit test cases for the Re-rating processor application using Junit.
• Multiple Product and Tariff Configuration in the Rating and Charging Engine CSG SingleView required for Unit Testing.
• Prepared mock applications using core Java for test execution.
• Documentation of the Service Design for Re-rating Application based on the existing code base.
• Performance tuning of SQL Queries for the Re-rating Application.
• Created Shell Scripts to launch the Re-rating process.

Environment: Oracle 11g, SQL Developer, Eclipse, Junit, UNIX, Perforce, NX Client, FitNesse.

Confidential

Developer

CSG International is a leading software vendor for real-time charging and billing solutions. The project Mobile Money System MMS enables telecom operators and mobile money providers to offer advanced mobile financial and payment services.

Roles Responsibilities:

• Worked on Service Design of the use cases for the Product Mobile Money System.
• Worked on the existing data models and the class diagrams.
• Created sequence diagrams for the multitier architecture of MMS.
• Developed Java packages for implementing the use cases using Software Patterns like Singleton, Factory Pattern.
• Worked on PL/SQL codes for adhoc requirements.
• Product and Tariff configuration of the Rating and Charging Engine CSG SingleView for MMS.
• Worked with Solution Architect for creating new use cases.

Environment: Oracle 11g/10g, SQL Developer, Magic Draw, Eclipse, Perforce.

Confidential

Database Support

Project goal is to provide support to customer for the database tables housekeeping utility.

Roles Responsibilities:

• Involved in running the housekeeping utility for different database tables.
• Maintaining the tables that has been cleaned and tracking the duration of data has been removed.
• Maintaining a schedule for all the database tables that has to be cleaned.
• Keeping track of the database space that has been freed up on housekeeping the tables.
• Verifying the data loaded in staging area, with customer, before removing them completely.
• Interacting with client regularly for providing updates and getting inputs on the duration of the data to be removed from individual tables.

Environment: Oracle Database 10g, UNIX, SQL Developer, PL/SQL Developer.

Confidential

PL/SQL Developer

Project : Enterprise Information Platform

The BT EIP platform is the telecom BI support of the retail business, catering all necessary MIS requirement for retail management. The project goal is to implement a housekeeping solution for large database tables containing customer billing data.

Roles Responsibilities:

• Designing and developing an automated housekeeping solution for large database tables.
• Designing and developing an automated index conversion solution for partitioned tables.
• Identify data from the large database tables that are old and can be removed from the tables.
• Developed packages, functions, and stored procedures using PL/SQL.
• Developed PL/SQL codes using collections, bulking techniques to increase performance.
• Created various PL/SQL scripts for verification of the required functionalities.
• Analyzed the business requirements and wrote Test Plans.
• Developed and maintained the design documentation to support the team and business.
• Involved in developing maps using OWB for adhoc project requirements.

Environment: Oracle 10g, Shell Script, SQL, TOAD, PL/SQL, Oracle Warehouse Builder, Subversion.

Confidential

PL/SQL Developer

Project : Solution SMARTS

This project involved data migration of customer service and network inventory data distributed across legacy applications into a master data management database for handling fault management of the network.

Roles Responsibilities:

• Analysed data received from various systems and ensuring data integrity across the systems.
• De- duplication and pattern matching of data from different system available in different formats.
• Designed and developed an automated solution for data analysis across various systems.
• Created stored procedures for various attributes of the network as required by customer.
• Developed PL/SQL codes using indexes, bulking techniques and partition to increase performance.
• Maintained packages to run the stored procedures using DBMS JOB.
• Created PL/SQL procedures for generating reports using UTL FILE utility.
• Created various ad hoc reports as required by customer.
• Worked on Database Links to connect to various customer end databases.
• Developed and maintained the design documentation to support the team and business.
• Modified, maintained and developed the SQL codes to develop new enhancements.

Environment: Oracle 9i, PL/SQL, SQL PLUS, SQL Developer, SQL Navigator, SQL Loader, Toad, UNIX.

Confidential

PL/SQL Developer

Project : Network Management System

The Project strives to implement an OSS solution for a 2G/3G combo network. Data is received in flat files and XML files from various network systems like BTS, BSC, MSC, and were loaded in the database. The challenge was to extract relevant information from these files and load them into database depending on business logic using Oracle procedures, functions and packages.

Roles Responsibilities:

• Formulated SQL queries and stored procedures on assigned modules.
• Developed database triggers, packages, functions, and stored procedures using PL/SQL and maintained the scripts for various data feeds.
• Developed PL/SQL codes using collections, bulking techniques and partition to increase performance and efficiency of already existing reports and various programs.
• Worked on Data Loading using SQL Loader.
• Developed and maintained the design documentation to support the team and business.
• Modified, maintained and developed the SQL codes to develop new enhancements.
• Developed the PL/SQL codes on the basis of the RFC's Requests for Change .

Environment: Oracle 9i, PL/SQL, SQL PLUS, SQL Developer, SQL Navigator, SQL Loader, Toad, Visual SourceSafe.