Career Objective

I want to work in an environment which provides a challenging and rewarding career ensuring a high-level job satisfaction. In the process apart from benefiting my employer, I also expect to learn for my overall development.

Career Summary

• 5.5 Years Oracle PL SQL,Oracle10g,11g RAC DB Implementation an Administration, Data guard, Sound knowledge on Unix/Linux Shell Scripting, Terabyte Databases and SAP Business Objects developer Experience.
• Technical experience in Oracle 10g,11g, PL SQL, Data guard, Performance Tuning, RAC, Unix/Linux Shell Scripting, SAP Business Objects and MIS.
• Functional Domain experience in Taxation, Telecommunication Billing/CRM, OSS AAA/PCRF, Insurance and Manufacturer ERP/CRM.
• Responsibility experience in Development, Production Support, Implementation, Client Relationship, Requirement Gathering, Business Development and Previous-Post Sales Activity, Delivery Assurance.

Technical Skills

Professional Training and Course Attended

Oracle Certified SQL Database Expert , OCA Developer- ORACLE PL/SQL and Advance PL/SQL , OCP Forms-Reports, Database Admin-I II.

Working Experience

Senior Developer

Confidential

• Involved activities like creating packages, procedures, functions, database objects to migrate oracle apps fulfillment framework to java- oracle application stack.
• Technical Architect -Database on B2B e-fulfillment domain.
• Effectively manage resources from the different continental working in different time zone.
• Conducting meeting with business analysts of different clients and get the extractions of the functional requirements and develop the documents to take the tasks ahead.

Senior Software Engineer

Confidential

OSS : Replacement From Huawai PCRF To Elitecore PCRF

• Understand the project requirement and providing developing deliverable as per RFC standards using in-memory database technologies.
• 99.99 Highly Available solution design for Data-Center as well as application.
• As we need to migrate 25 Million Subscriber Base, We got 2 Data-Center Hub.
• Project have many challenges because it's a brown field project. Replacement of Huawai PCRF to Elitecore PCRF, Taking Leadership of data-mapping and data modeling phase and provide accurate migration script which successfully passed in it's first mock-migration run and got RA approval for 22 Circle Migration Across India.
• Implementation of RAC, Active-Active Physical Standby For disaster recovery and geographical redundancy.

Confidential

BSS: Migration of TECHM BSS Modules to Elitecore BSS Modules and Developing/Enhancing Collection Dunning , Loyalty Business Modules As per TM Forum.

• Project scope is still in design phase.
• Development of collection dunning, Loyalty Modules.
• Creating database flow diagrams and developing business requirement with managing team.

Roles Responsibility

• Technical Leadership for Project specific development and implementation.
• Assuring development/Implementation deliverable on timely and smoothly on production.
• Creating database model for new module requirement for BSS and OSS stacks.
• Contributing SQL-PL/SQL technical leadership for development of database objects like packages, procedures, functions, triggers, collections, schedule jobs for reports and agents for the modules/components/utilities.
• Unix/Linux Scripting for various operational ease, Auto-Startup scripts, Log-Ratating and Removing scripts, Database Backup and Tuning Scripts, SMS integration scripts, Migration Scripts, Quick Product Installation Scripts, Database Monitoring Scripts.
• Implementation of RAC Database, Physical Standby, Data-warehouse Schema, Data Migration, Data Quality Analysis for Reporting Servers.
• Implementing/Performing Database Support Strategies and Database Space Management.
• Handling L3-L4 Escalation for Performance Issues, RAC Instance recovery, Media/DATA Recovery.
• MIS/Reports for BSS/OSS stacks in different reporting frameworks using SQL/PLSQL development and Crystal Report/JSP-Product-Framework/OracleBI tools.

Senior Engineer

Confidential

Environment:SQL, PL/ SQL, Oracle 11g, SAP BO Crystal Report 11 , MQSubscribe, MQNsure, CISCO Adaptors, DB Platform Linux and Application Platform Windows and Android Application for Hand Hold Devices.

Project and Module Description:

• Handling two projects.
• ISP Telecommunication Billing and CRM.
• Pay Tv Billing and CRM.
• Working on Modules as bellow,
• Provisioning,
• Adapter Configuration,
• Order and Package Management,
• Accounts,
• Customer Care,
• Inventory and Logistics

Roles and Responsibilities:

• I work on database objects, on application for creating new process or module or unit related database objects.
• Handling a team for android application customization and provide idea on technically and functionally.
• I work on performance improvement activities like tuning queries, procedures and packages by defining better explain plan or creating indexes or partition.
• I also take care of backup and restoration of development and production DB.
• I develop database objects like tables, views, sequences, synonyms, stored procedures, function, packages, cursor and triggers.
• Working on Unix Shell Scripts.
• Database Development and Administration. SAP Business Objects Developments. Involved in Development of Product custom feature enhancement, Implementation and support. Leading Team and Resource Management. Delivery Assurance based on SLA. Requirement Gathering on Product Features.

Achievements : Successfully completed Implementation and Migration of 10g EE Database to RAC 11g R2 with ASM RAID.

Software Developer

Confidential

Environment: SQL, PL/ SQL, Oracle 11g, Java- Struts/Spring, Jdeveloper, iReport 2.0.

Project and Module Description:

There are several modules in Application - Dealer Registration, Returns, Recovery, Enforcement, MIS, Audit, Work Force Management and Access Control Management. There are few functionality provided to dealers for their conveyance through portal.

Roles and Responsibilities:

• I work on portal for return filling related database objects, on application for creating new process or module or unit related database objects. I work on MIS and scheduling procedures.
• I work on process request and fix it quickly.
• I had work on Java Portals Application for e-Payment API integration. I also worked on TCS Java Framework to integration of DB objects with JSP pages.
• I work on change request in robust manner and think upon possibilities along with project leader, function consultants and client side project leader. I need to create assign task in given time.
• I work on performance improvement activities like tuning queries, procedures and packages by defining better execution sequence, indexes and partitioning of tables.
• I also take care of backup and restoration of development DB.
• I develop database objects like tables, views, sequences, synonyms, stored procedures, function, packages, cursor and triggers.
• I create procedures for new MIS Reports and Modify procedures for Existing MIS Reports.
• I provide offshore support to client side team in DB related activities along with DBA.
• I take care of offshore database development environment and provide support to deploy DB Patches to client side maintenance and production environment.
• I create and schedule batch process and jobs for critical procedures and database backup scripts.

Achievements:

• I appreciated by my project leader twice for providing successful committed work before deadlines and work as proactive team member in critical situation of project.
• I appreciated by team member for providing knowledge sharing session and helping to understand work-process to improve productivity.
• I have completed E2 level competency in ICalms for Oracle 10g PL/SQL within technology owner category.
• I have done successful migration from oracle 10g enterprise edition to oracle 10g express edition.
• I have done successful upgrade from oracle 10g express edition to oracle 11g express edition.

System Analyst

Confidential

Ahmedabad

Hospital Enterprise Resource Planning

Environment: SQL, PL/ SQL, ORACLE 6i/10g Forms and Reports.

Project and Module Description:

I am involved with two major modules of this project which is Inventory and HR.

Roles and Responsibilities:

• I involve in taking requirements from client end users and senior staff of relative domain whenever needed and based on that I create E-R diagrams, Function Hierarchy diagrams, Process diagrams, Data Flow diagrams using Oracle Designer for further usage for me and my team mates.
• I have major role to develop database objects like tables, views, sequences, synonyms, stored procedures, function, packages, cursor and triggers for oracle forms and reports.
• I design form layout in oracle 6i forms and reports and developing application triggers and Programming Language Units and Libraries.
• I design form layout in oracle 10g forms and developing application triggers and Programming Language Units and Libraries.
• Working on Sales, Purchase and Inventory Module of Oracle ERP.
• I have wrote complex SQL queries using joins, sub queries and correlated sub queries to retrieve data from the database.

ACUBE - Human Resource Management System

Environment: SQL, PL/ SQL, VB.NET, SAP BO Crystal Reports 11

Project and Module Description:

ACUBE HRMS is the company product implemented at many local and global small scalar companies. This Product includes various modules like Human Resource Information Module, Recruitment Module, Time and Attendance Module, Leave and Holiday Management Module.

Roles and Responsibilities:

• I have major role to develop database objects like tables, views, sequences, synonyms, stored procedures, function, packages, cursor and triggers for .Net Forms and Crystal Reports.
• I involve in performance tuning, improve execution plans and polish previous back-end coding of the software, add new functionality by doing modification based on client need and applying business logics.
• I involve in writing Technical Specification Documentation.

Software Developer

Confidential

Customer Relationship Management System

Environment: SQL, PL/ SQL, VB.NET, SAP BO Crystal Report 11

Project and Module Description:

I involve in Design, Development and Implementation of Customer Relationship Management System at I.T. Department of True Life Services Private Limited. The division was responsible for developing and maintaining the products like leads management, potential leads management, account management, task management, insurance policy issue management, renewal management, different kinds of reports generation and dynamically administration of system. So This Project kept all kind of records related customers and generates various reports.

Roles and Responsibilities:

• I have major role to develop database objects like tables, views, sequences, synonyms, stored procedures, function, packages, cursor and triggers for .Net Forms and Crystal Reports.
• I involve in performance tuning, improve execution plans and polish previous back-end coding of the software, add new functionality by doing modification based on client need and applying business logics.