Description
Summary * More than 9 years of programming experience as an Oracle PL/SQL Developer in all phases of Software Development Life Cycle (SDLC) including Analysis, Design, Data Modeling (Logical and Physical) and Implementation of Business Applications using the Oracle Relational Database Management System (RDBMS). * Generating (constructing) XML data from relational data in the database. * Worked on SQL/XML standard functions and Oracle Database-provided functions and packages for generating XML data from relational content * Reading and writing XML to/from files. * Worked on externally organized tables. * Worked on NO SQL database (MONGODB) * Highly competent in gathering user requirements and converting those into software requirement specifications. * Expertise in designing of HLD, LLD, Data Model and Database Development Lifecycle, Risk & Gap analysis. * Expertise in creating relational database development, for creating complex database queries, writing Constraints, Indexes, Views, Packages, Stored Procedures, Cursors and Functions using PL/SQL in Oracle databases (8i, 9i, 10g, 11g and 12c). * Experience in using Oracle supplied packages such as DBMS_SQL, DBMS_JOB, and UTL_FILE to read and write into files. * Implemented PL/SQL advanced concept like Bulk Collects, Bulk Inserts Ref Cursors, Collections, Dynamic SQL, Autonomous transactions, Table Partitioning and External tables. * Expertise in Database Performance Tuning, Performance Monitoring and Optimization using Oracle Hints, Explain plans, Tk-Prof and Table Partitioning. * Proficient in Oracle Tools and Utilities such as SQL*Loader, Import/Export, EXPDP/IMPDP. * Migrated large data between different data sources to Oracle databases. * Experience in development of custom Oracle forms and reports application. * Expertise in data modeling, Normalization, database design, data loading, data retrieval, modification, and archival techniques. * Proficient in Oracle database creation, table space management, creating database links, schemas, profiles and roles, managing control, redo log and data files. * Used several Oracle provided packages such as DBMS_JOB, DBMS_PROFILER, DBMS_STATS and DBMS_SCHEDULER packages. SLIM is the tool-set used by Cisco Service Product Managers (SPMs) to create new services and manage the release of those service offers through the Cisco Services Development Methodology (CSDM) governance process. SLIM is used to track the entire life-cycle of a service Planned ( Available ( Retired The services information managed in SLIM is maintained in the Cisco Services Portfolio (CSP) database which has been established to become the single-source-of-truth (SSoT) for all core services information. Receiving XML data from downstream system manipulating them and passing to some other downstream. This project involves development and maintenance of a various report dashboards based on existing legacy application as well performance tuning of them for better result. We are also managing the xcharge for engagement for multiple quarters. There are many splunk engagement requests coming for various JVM for log management. Through splunk engagement project now we made an arrangement /process through this tool to make the user life easy. Various type report development tuning and other DBA related activities for other Cisco legacy system. In today's world of telecommunications a simple phone call may involve several kinds of communication carriers. These multi-level handoffs mean that carriers have to mediate and dispute more complicated combinations of revenue billing and tariff data. More often than not Telco companies stand helplessly as millions of dollars of their revenue go unaccounted. Given the technical and business challenges in such complicated environment revenue leakage is guaranteed. Hence MoneyMap enabling RA team to find the leakage wherever in the system by comparing CDRs from various sources and performing their account reconciliations. The Web-Based application made is a fully-integrated completely internet-based software suite Designed to keep records of all primary sale as well as secondary sale. Also capture CAF (Customer Agreement Form) and CIF (Customer Information Form) The application was designed to track all the sell either it is to Vodafone store or distributor as well as to end user. Here sell to Vodafone store is called transfer whereas sell to a distributor is called primary sell and to end customer it is called secondary sell. Document as per the TRAI guide lines are stored in the system as well in case of secondary sell. Also maintaining the stocks and account details of sales for each stores and external channels
Accomplishments
Highlights:
Keywords
