SUMMARY:

• 18+ years of IT Experience in Billing, Telecom and Health domain with 9+ years as Oracle System Analyst/Data Architect for System Analysis, Designing, Testing Development & Support of Oracle 8i, 9i, 10g & 11g in Production, Staging, Development environments and front - end applications (Developer 2000, Ver. 4.5,5.x, 6i, 9i, Oracle 10, 11g).
• Actively involved in all stages of Software design, development and implementation life cycle.
• Five Years experience as Data Architect/Analyst, Oracle/IBM DB2.
• Solid experience translating business requirements into conceptual, logical, and physical data models.
• Good knowledge in Data Modeling (Logical and Physical Design for distributed databases, Reverse-engineering and Forward-engineering using Erwin Ver.8.x).
• Implement best practices and methodologies in data analysis, design and modeling.
• Exposure in Oracle utilities like SQL*Loader, Export/Import and data pump utilities like EXPDP/IMPDP.
• Proficient in advance features of Oracle 11g for PL/SQL programming like Using Records and Collections, Bulk Bind, Ref. Cursors, Nested tables and Dynamic SQL.
• Exposure in SQL and PL/SQL tuning and query optimization tools like SQL Trace, Explain Plan, and DBMS PROFILER.
• Experience in Data Modeling (Relational, dimensional, Star and Snowflake Schema), Data analysis, implementations of Data warehousing using Windows and UNIX.
• Proficient in working and conceptual knowledge of Oracle Forms 6i/10g and Oracle Reports 6i.
• Knowledge in Data Ware housing, have used both Kimball and Inmon methodologies in implementing Star and Snowflake.
• Full ticket life-cycle experience with Remedy.
• Knowledge in Extraction, Transformation and Load (ETL) strategy, design and implementation.
• Experience in all aspects of analytics/data warehousing solutions such as Database issues, Data modeling, Data mapping, and ETL Development, metadata management, creation of Materialized Views, data migration and reporting solutions.
• Knowledge in Table Partitioning in order to increase the performance.
• Created database objects like tables, views, sequences, synonyms, indexes using Oracle tools like SQL*Plus, SQL Developer and Toad.
• Enforced data integrity using integrity constraint and database triggers.
• Hands on experience in data security, backup & recovery, data access, imports & export, application tuning, database auditing and documentation of procedures.
• Experience in Billing (BSS/OSS) Systems Team Leader Confidential (At present CSGI) CBP, Singl.eView CB & CM Technical Architect - Analyze the requirements, Creating the design document, Review and walk through the design document created with Peers and Clients.
• Migrating Data from legacy system to Singl.eView ( Confidential Telecom Billing Software at present CSGI) using Confidential Toolkit and Operation Console. Analyze the DVP errors generated during migration and rectify the legacy data.
• Coding EPM Functions, Perl Scripts, Product Development, Report Generation, Rating, Coding, Configuring various entities such as DA tables, Attributes etc and Testing.
• Experience in Quality Assurance Testing both manual and automated for Web based and Client/Server applications pertaining to Telecom Billing systems, Retail, Health and al institutions.
• Actively involved in UAT and System testing and resolved the issues by modifying the existing code and documented the changes.

TECHNICAL SKILLS:

Languages: Perl, EPM, SQL (PL/SQL - Advanced), C++, C & Pro*C, Expression Language, EMP Scripts, Basic shell scripts, Web Services - (SOAP).

Front End Tools: Designer 2000 (Ver. 6 & 1.3.2), Developer 2000 (Forms Ver. 4.5 & 5.1, Report Writer 2.5, & 3), Developer 2000 (Forms Ver6 & 6i, 9i Report Writer 6i), Discoverer 2000, Oracle Enterprise Manager (OEM), Oracle Financials, IBM DB2 Tools such as Control Center, Health Center, Load etc. SQL Loader, Crystal Reports, TOAD.

Data Modelling Tools: ERWIN, MS VISIO

Databases: Oracle 7.3, 8, 8i, 9i, 10g, 11g & IBM DB2 8.1,Watcom SQL & Xbases, MS Access 97.

Operating Systems: Ms DOS, Ms Windows & UNIX, and VMS.

PROFESSIONAL EXPERIENCE:

Confidential

Senior Data Architect

Responsibilities:

• Involved in Data Requirement Analysis, Data Modeling and Data Architecture for Report Generation based on the Statement of Work and Data Dictionary.
• Created a detailed design document for the Entities and the attributes required for the Portal Database, Report Database and for the Final Report Snapshot.
• Analyzed functional requirements to identify information, procedures and decision flows.
• Analyzed and created Data mapping documentation for each report based on the data elements mentioned in the data dictionary.
• Created CMS (Column Mapping Spreadsheet using EXCEL) in order to map the legacy data in accordance with the elements mentioned in the Data Dictionary for Report Database
• Generated Logical and Physical ER diagrams for each and every report based on the Entities and Attributes required.
• Evaluated existing procedures and methods, identified and documented database content, structure, and application sub - systems, and developed data dictionary.
• Generated Logical and Physical ER diagrams for NG Portal Database (From ALLSTREAM Mongo database), Report Database (Map Reducing) and for Final Report Snapshot.
• Created Tables with the required attributes for Portal Database, Report Database and for final Report Snapshot (Materialized Views).
• Actively involved in Table partitioning including the existing tables with huge data.
• Analyzed the DVP(Data Validate Process) errors encountered while migrating the data into tables and fixed the errors.

Environment: Mongo, Oracle 11g, PL/SQL, ERWIN, MS VISIO.

Confidential

Senior Data Architect

Responsibilities:

• Worked on Prime Biller module which is a customized model based on Singl.eView,
• Worked on PL/SQL, SQL, Expression Language, EMP Scripts, Perl, Basic shell scripts, Web Services - (SOAP), ERWIN.
• Involved in discussions with the business group in order to understand their requirements and create a Technical Design Document and once reviewed and accepted by the business created the necessary PL/SQL procedures, EMP functions, Perl scripts, creation of new Oracle tables and other entities based on the requirement.
• Actively involved in Prime Biller application development.
• Prepared application design with detail impact specifying impact on data flow, change in business logic, Oracle Pl/SQL, performance/testing consideration, change in data volume & dependency.
• Worked on sequences, functions, synonyms, indexes, triggers, packages, stored procedures, Materialized Views, roles and granting privileges on OLTP server.
• Analyzed/Created new design documents for new requirements, enhancements and CR’s based on the business requirements.
• Created Test Data for testing the created/modified procedures and functions.
• Analyzed and compared the results from procedures and packages and checked results’ rationality.
• Partitioned large Tables using range partition technique
• Involved in Data Migration project. Migrated data from the legacy system to Singl.eView. Created CMS (Column Mapping Spreadsheet using EXCEL) in order to map the legacy data in accordance with the Singl.eView billing system. Each Business Data Type that has to be migrated from the Legacy system to Singl.eView is mapped in accordance with the entity validation specifications configured in Singl.eView for the given Business Data Type.
• Created system test scripts and DVP (Data validation Process) complex queries to check the migrated legacy data is as per the column mapping requirements.
• Analyzed the new PL/SQL procedures/functions, EPM functions and other Singl.eView entities such as Entity Validations, Attributes, and server side Perl Scripts etc. developed by the developers pertaining to new requirements, enhancements and CR’s and suggested changes wherever necessary.
• Followed up with QA teams and offshore teams for all testing and development activities.
• Actively involved in code reviews, design walkthrough’s, and other forms of team quality procedures.
• Monitored monthly billing activities and followed up with the billing operation staff.
• Checked the invoices generated to make sure that they are as per the requirements.
• Analyzed the defects in Production and fixed the code bugs.
• Responsible for Analyzing, designing specifications of test plans.
• Followed up with QA teams and offshore development teams whenever necessary in order to resolve the Productions issues.
• Actively involved in UAT, Integration testing, System Testing and fixing the bugs that are detected during UAT, Integration testing and system testing.

Environment: Singl.eView (Version 7.00.09.00 ), Sun, HP, AIX, Windows XP, Oracle 9i,10g, 11g, TOAD, SQL *Loader, EXCEL, SQL Navigator, Oracle SQL Developer.

Confidential - MCLEAN, VA

Senior Data Architect

Responsibilities:

• Over all in charge of Singl.eView operations.
• Worked on PL/SQL, SQL, Expression Language, EMP Scripts, Perl, Basic shell scripts.
• Involved in Gathering and Understanding the business requirements, analysis, design, development and implementation into the system.
• Analyzed the created Procedures/Functions based on the business requirements for performance and recommended the changes wherever necessary.
• Monitoring Bill runs and resolving issues if any during the bill runs.
• Resolving issues pertaining to Customers and Products.
• Resolving issues in regards to VAT calculations Adjustments Unbilled usage, Usage and rating errors.
• Analyzed the CR’s requirement and created the required design document and tested the created new PL/SQL Packages, Functions, EMP Functions, Entities based on the CR’s requirement for performance.
• Analyzed and made changes to the Customers Invoice formats whenever necessary.
• Generating various reports on total VAT collected, Unbilled Usage, Adjustments and Financial reports.

Environment: Singl.eView (Version 6.1), Sun, HP, AIX, Windows XP, Oracle 9i,10g, 11g, TOAD, EXCEL.

Confidential

Senior Pl/SQL Developer

Responsibilities:

• Involved in development of New EPM functions and server side Perl Scripts pertaining to CR’s.
• Worked on PL/SQL, SQL, Expression Language, EMP Scripts, Perl, Web Services, SOAP, Basic shell scripts.
• Participated in code reviews, design reviews, or other forms of team quality procedures.
• Worked on CR’s pertaining to Internal Credit Rating, Deposits, IMEI Code Unlock, and Promotion Codes etc.
• Involved in discussions with the business group in order to understand their requirements and create a Technical Design Document and once reviewed and accepted by the business created the necessary PL/SQL procedures, EMP functions, Perl scripts and other entities based on the requirement.
• Involved in fixing the existing bugs in the code,
• Generated reports pertaining to Promotions, Monthly revenue generated etc.
• Worked on production tickets pertaining to rating, late payment fee, bill runs etc.
• Actively involved in UAT, Integration testing, System Testing and fixing the bugs that are detected during UAT, Integration testing and system testing.

Environment: Singl.eView (Version 6.1), Sun, HP, AIX, Windows XP, Oracle 9i,10g, 11g, TOAD, EXCEL, SQL Navigator.

Confidential, Providence, RI

Senior Pl/SQL Developer

Responsibilities:

• Extracted data from the base data base and transferred the same to various schemas in order to transfer the data into flat file and moved to Vendors database in order to create the document on the web.
• Involved in creating the Technical Design Document and once reviewed and accepted by the client created the necessary Packages in order to extract the data.
• Created both logical and Physical data model diagrams where ever required.
• Responsible for development and testing of conversion programs for importing data into Oracle database utilizing PL/SQL, SQL*Loader and UNIX shell scripts, to load data from flat files to Oracle database.
• Converted stored procedures among different database environment.
• Provided sample data for stored procedures and packages for testing purpose
• Involved in performance analysis using explain plan, query options and provided solutions for better performance.
• Reviewed existing stored procedures/packages and made changes based on new business requirements, tables changes, logical errors, new programming rules added and bad performance and provided solutions for fixing them.
• Involved in running weekly reports and provided results for business analysis
• Created materialized views for quick SQL queries.
• Involved in Unit Testing, UAT, and Production support.
• Worked on assigned production service request and resolved the issues.
• Involved in creating the base tables, dimension tables and fact tables in order to load the data from the legacy schemas into base tables and dimensional tables.
• Created the required PL/SQL packages to extract, transfer and load data into base, dimensional and fact tables.

Environment: Oracle 10g, 9i, Sun, HP, AIX, Windows XP, TOAD, SQL *Loader, EXCEL, SQL Navigator.

Confidential

Lead Data Architect

Responsibilities:

• Meteor - Ireland, Confidential - UK, MIC1 Beirut, MTN Nigeria and DIGICEL Jamaica, Master Card - (Project Lead).
• Developed new PL/SQL Packages, modified the existing ones to enhance the functionality of the Toolkit ( Confidential Data Migration Tool) in order to migrate the clients data from the legacy system to Singl.eView.
• Worked on PL/SQL, SQL, Expression Language, Basic shell scripts, EPM Scripts
• Involved in discussions with the client in order to understand the legacy system data structure and the existing business rules.
• Created CMS (Column Mapping Spreadsheet using EXCEL) in order to map the legacy data in accordance with the Singl.eView billing system. Each Business Data Type that has to be migrated from the Legacy system to Singl.eView is mapped in accordance with the entity validation specifications configured in Singl.eView for that particular Business Data Type.
• Once the client has approved the functional specifications and column mapping spreadsheet, created a detailed design document in order to guide the developers to create the necessary packages to migrate the legacy data to Singl.eView billing system.
• Involved in creating the tables, partitioning where ever necessary, creating the required indexes, backup and restore.
• Developed new packages or modified the existing packages in order to validate the legacy data as per the rules specified in column mapping rules sheet and load the same to Singl.eView billing system.
• Created system test scripts and DVP (Data validation Process) complex queries to check the migrated legacy data is as per the column mapping requirements.
• Created Unit Test, System test, UAT, and Pre Production Test scripts.
• Actively involved in Unit Testing, System Testing, Full Volume Test Runs, and Dry Runs.
• Analyzed the erred out data during the system test, created a Cleanse log with suggestions for corrections with examples and forwarded the same to the client to correct the erred out legacy data in order to achieve 100% error free migration.
• Involved in supporting the production after migration and resolved the tickets rose during post migration.

Environment: Toolkit, Operation Console, Singl.eView (Version 7.1), TOAD, EXCEL, SQL Navigator, Sun, HP, AIX, Windows XP, Oracle 9i,10g, 11g.

Confidential

Senior Technical Architect/Developer

Responsibilities:

• Involved in gathering system requirements and assisted project teams by developing detailed technical documentation to deliver client (Meteor) requirements for ‘Credit Vetting’ which is a part of Customer Care and ‘GL Codes Functionality’ (Financial Module - new functionality introduced in version 6.01) for Meteor project.
• Worked on CB Singl.eView BSS/OSS application suite.
• Involved in discussions with the client in order to understand their requirements and modify both the Credit Vetting and GL Functionality Technical Documents.
• Coded, configured and Unit Tested the required Functions, Types, DA tables, GL codes, GL guidance entities, Receivable Types and Functions in order to support the Credit Vetting Functionality and GL functionality as per the Clients requirements.
• Actively involved in Coding, Configuring and Unit testing the Changes done as per the client’s Change Requests.
• Actively involved in integration testing, System Testing and fixing the bugs that are detected during integration testing and system testing.
• Involved in gathering system requirements and created detailed technical documentation and configured the required entities and expressions to deliver to the clients
• Configured remote functions in order to initiate the system calls to the above mentioned local functions.
• Actively participated in product development, API coding, configuring Derived Attributes tables in which the data is stored and mapped, functions, Unit testing, System testing using the Confidential Singl.eView Expression Language.
• Participated in System Testing supervision. Assisted testers to modify the EPM scripts created for automation testing.
• Actively involved in resolving and fixing the integration test tickets, system test tickets and production tickets.

Environment: Singl.eView Version 6.1, Expression Language, PL/SQL, SQL, Oracle 9.3. TOAD, Sun Solaris, Windows XP, Oracle 9i and 10g.

Confidential

Senior Technical Architect/Developer

Responsibilities:

• Release Phase - 1.1.7 & 8’, Virgin Mobile South Africa - Singl.eView CM &CB.
• Involved in writing the system requirements based on the business requirements and assisted project teams by developing a detail technical design documentation along the Unit Test and System Test scripts to deliver client (Virgin Mobile) requirements for release 1.1.7. I am directly responsible for ‘Abandoned Sales without Payments’ design which checks for payment at the time of sale before the service is activated thus preventing the hassle of cancellation of the service at a later date for nonpayment by the customer.
• Worked on CM & CB Singl.eView BSS/OSS application suite.
• Modified the existing triggers and created new triggers in SV CM and modified the service activation expression in CB in order to ensure that the service of MSISDN number is not activated without submitting to the database where the payment details are checked before the actual service is activated. Created a new expression in SVCB in order to check if the payment has been processed successfully and the database table has been updated with the payment details.
• Created new search criteria by using the search tool in CM in order to make sure that the assigned MSISDN number has not been assigned to any other account or in active status before the account is saved and submitted.
• Actively participated in fixing production bugs, product development, coding, configuring, unit testing, and creation of Pre and Post Commit Expressions using Confidential Singl.eView expression language. Attended design walkthrough, code-walkthrough and sign-off meetings with Virgin Mobile.
• Actively involved in gathering the SRS for Release 1.1.8.

Environment: Singl.eView CM Ver. 5.01.07, CB Ver. 5.1.18.3, Expression Language, Oracle 9.3. TOAD, Sun Solaris 2.8 and Windows NT/2000.

Confidential

Senior Technical Architect/Developer

Responsibilities:

• Worked on Singl.eView BSS/OSS application suite.
• Involved in gathering enterprise system requirements and assisted project teams by developing detailed technical documentation to deliver client (BellSouth) requirements for ‘Additional Mailboxes’ (Companion Products) and ‘Mass Adjustments’ a batch process which is executed periodically in order to make the adjustments for customers’ bills .
• Actively participated in product development, coding, configuring, Unit testing, creation of Pre and Post Commit Expressions, using the Confidential Singl.eView
• Expression Language. Attended design walkthrough, code-walkthrough and sign-off meetings with BellSouth.

Environment: Singl.eView v6, Expression Language, Oracle 9.3. TOAD, Sun Solaris 2.8 and Windows NT/2000.

Confidential

Technical Architect/Developer

Responsibilities:

• Worked on Singl.eView BSS/OSS application suite.
• Involved in gathering enterprise system requirements and assisted project teams by developing detailed technical documentation to deliver client requirements for ‘Non Recurring Charges’ (NRC), ‘Companion Products’, ‘Promotions’ and ‘Customer Care’.
• Actively participated in product development, coding, configuring, Unit testing, System Testing, creation of Pre and Post Commit Expressions, using the Confidential Singl.eView Expression Language.
• Periodically attended design walkthrough, development, code-walkthrough and sign-off meetings in Atlanta.

Environment: Singl.eView v6, Expression Language, Oracle 9.3., 10g, 11g, TOAD, Sun Solaris 2.8 and Windows NT/2000.

Confidential

Programmer/Junior DBA

Responsibilities:

• Actively involved in the junior staff.
• In House: Attended provided by the company - IBM DB2 UDB 8.1, Oracle 9i, Forms Ver.9i

Environment: IBM DB2, Oracle 9i

Confidential

Programmer Analyst

Responsibilities:

• PRISM, CCI & ACN (U.S.A) - CBP Telecommunications Billing Software - Billing, Singl.eView Billing, Customer Care Modules.
• Designed, developed a module namely: (1) Find Dealers. This module is dependent on Accounts module that is, it is called from the main module Accounts in order to display the particulars of the Dealers.
• The module is generated by Designer 2000.
• Involved in development of Front-end screens and back end Procedures, using Oracle 7.3 and Developer 2000 (Forms 5.1), PL/SQL.
• The job involves Design, Development, and Testing of various customized front-end screens and Report generation.

Environment: Developer2000 (Forms Ver 4.5, 5.1, Reports 3), Oracle 7.3, (PL/SQL), Windows NT (Ver 4), UNIX.

Confidential

Programmer/Analyst

Responsibilities:

• Involved in development of business application using C++, VISUAL C++ The application is divided into various Modules such as customers’ information, investment details, and Transaction details.
• As a team member involved in preparation of functional specifications, creation of customers’ information screen.

Environment: C++, VISUAL C++, WINDOWS.

Confidential

Data Warehouse Developer

Responsibilities:

• Designed, developed and implemented a database application that takes care of generating various reports, campaign tables from huge data supplied by the client.
• The reports are used by the clients (mainly BELL MOBILITY, SCOTIA BANK) for promotional activities of their products (namely air time. and insurance) with the various customers.
• The reports are generated from the information extracted either through Crystal Reports or through Procedures ( PL/SQL).
• The job involved creation of Database, Roll Back Segments, Table spaces, tables, preparing Control files, loading data through SQL LOADER, creating snapshots, extracting data as per the requirements of the promotional activities for generating the reports.
• Involved in installation of Oracle 7.3.Tuning the system (DSS) for maximum performance creating Bitmap indexes, Hash joins etc. where ever necessary.

Environment: Oracle 7.3, Developer2000 (4.5), SQL Loader, Crystal Reports, Windows NT (Ver 4), SUN Solaris, Access