 Oracle SR Raising and resolution
 Database Operations of OSS/HP OM/CSC/HDM/TR-069.
 Managing IT Operations for PTCL IT/DB Team.
 Product development experience building and operating dependable, large scale distributed software systems.
 Experience of Network Services(HTTP)
 Oracle EXADATA X3-2/X6 Machine Administration and Operations.
 Oracle 11g database administration (Oracle Database, Oracle RAC, Streams, Data Guard)
 PL-SQL programming to write/modify/tune Procedures
 Moving data using Data Pump, SQL* Loader & External Tables etc.
 Monitor systems and platforms for availability.
 Provide 24/7 support for critical situations.
 SQL / PL-SQL query tuning
 Maintain strong liaison with in-house developers and third party vendors for any issue that affect the applications and for the completion of new projects.
 Conduct regular Database health check such as EXACHK, SUNDIA, and AWR etc.
 Oracle Data Guard Configuration (Physical Standby Database)
 Database Migrations
 Written different optimal PL-SQL Procedures & Scripts for PTCL Servers i.e.
 Procedure for Authentication of PTCL DSL/IPTV Users
 Procedure for CDR Files Generation for Billing / Accounting of DSL Users
 Procedure to split table partitions to create new partition
 Procedures for automatic creation of data files of tablespaces when near to full
 Written different procedures for automation purpose
 Contribute in the analyses of process improvements by evaluating new/existing tools
 Analyze and solve complex customer issues related to data and processes.
 Perform analyses and recommend process improvements for Development.
 Proficient in all areas of SDLC– analysis, design, implementation, testing, performance tuning, debugging and Operations.
 Solar wind, IPDR system Operations/Administration
Day to day troubleshooting, of Solar Wind and IPDR(Billing) System.
Complete knowledge of Exa-data, AAA servers and MMBB systems.

Project: Implementation of Oracle Financial (Funds Management System) at OGDCL
 Currently working on customized application integrated with Oracle Financial.
 Extensively involved as a Technical consultant, creating Custom reports, creating new forms and PL/SQL Packages. Worked closely with Stakeholders, Business users and Technical lead to identify the requirements, preparing technical design specifications and preparing GAP analysis document in collaboration with functional lead.
 Working with the Technical Team lead to evaluate and identify Technical gaps between the application and business requirements and identify potential solutions.
 Involved in creating, modifying and repairing custom reports using Oracle Reports 10g.
 Extensively used Custom.pll for Forms customization
 Designed new Forms and Reports using Oracle Forms 10g that interface with Payroll and other Financials modules
 Registered Forms, reports, parameters and concurrent programs in Oracle Application
 Responsible for development, Support, Troubleshooting and deployment of Forms as well as reports using Forms /Reports 10g.
 Wrote various PL/SQL Packages, functions, procedures and stored procedures to implement the Business rules uncovered in the Database design
 Labeled information in a business area to help end users identify the information they will want to access
 Improved the association between folders by creating the necessary joins between folders in the business area
 Set up items in a hierarchy to enable end users to drill up and down the hierarchy to view related information
 Responsible for Integration of Customized Forms with Oracle Payroll module.
 Currently working on E-Business Suite R12 integration project.

Environment: Forms 10g, Reports10g, Oracle 9i, Windows Server2003/XP, SQL*Plus, PL/SQL, PL/SQL Developer, TOAD

Project: Automation of PLI (Product Loss Investigation) Reporting System
 Analyzed, developed and implemented the PLI. Performed systems analysis and design including: interacting with end users to understand and define requirements and preparing required document and E/R diagrams.
 Created AS-IS, TO-BE for the system using Visio.
 Created PL/SQL and Object libraries that can be used by most of the forms in the application.
 Maintain User level Security for all users.
 Designed and developed various Forms using Oracle Forms 10g.
 Designed Tables, Constraints, Views, synonyms and Indexes etc.
 Created various forms and reports based on stored procedures.
 Responsible for Forms/Reports up gradation to Forms/Reports 10g
 Responsible for end user Support, Troubleshooting and Bug fixing of existing applications
 Write extensive PL/SQL code including Packages, procedures and functions to validate the report.
 Created PL/SQL and Object libraries that can be used by most of the forms in the application.
 Created template that can be used to maintain uniformity throughout the application, which consists of property classes, visual attributes, alerts etc.
 Involved in end user training and user acceptance testing, preparation on test scripts and integration testing.
 Involved in requirement analysis, design, development, implementation, testing and end-user Training
 Build logical & physical data models, generated Schema using ERWIN
 Was solely responsible for the development of Data entry forms like Departments, Data entry screen etc. Also wrote PL/SQL code to implement business rules and validation triggers as well
 Responsible for taking regular backup / recovery of data
 Installed tested modules in user environment
 Developed some master detail and other reports for the data entry module
 Created template that can be used to maintain uniformity throughout the application, which consists of property classes, visual att

Project: Campus Management System (UAAR)

Role:
 Responsible for the analysis, design, development, unit testing and implementation of CMS
 Responsible for development, Support, Troubleshooting and deployment of Forms as well as reports using Oracle Forms/ Reports 10g and 10gAS
 Created various forms and reports based on stored procedures
 Responsible for end user Support, Troubleshooting and Bug fixing of existing applications
 Responsible for data conversion using SQL*Loader
 Created parameterized report using reports 10g, which are able to query data according to business area
 Developed Object Libraries and PL/SQL Libraries
 Wrote various PL/SQL Packages, functions, procedures and stored procedures to implement the Business rules uncovered in the Database design.
 Wrote PL/SQL packages, functions and procedures to enforce business rules and relationship uncovered in the Data model
 Supported CMS in tuning database and applications for optimal performance, monitor database growth and provide database capacity planning for applications expansion.
 Performed DBA activities like Daily Maintenance involved performance monitoring, backup monitoring, analyzing indexes, tables, schemas, and Database as needed, checking export/imports, space management, instance/SQL tuning, process scheduler maintenance, performing ad-hoc SQL for users and reviewing production process logs
 Tuning of the Database by monitoring performance of SGA, Rollback Segments.

Environment: Forms 10g, Reports 10g, Visio, Oracle 10g, Windows XP, SQL*Plus, PL/SQL, PL/SQL Developer, Import/ Export