Loading data into the databases through flat file. - Profile by yaoyufang

VIEWS: 1 PAGES: 4

									SHALAJ VERMA
                                                                                                OCA Certified
C-1/16 pkt-6                                                                email:sverma.3639@gmail.com
Kendriya Vihar ,                                                             Contact No: +91 9958024673
sector 82,Noida,
U.P




OBJECTIVE:

       Willing to work in an organization where I can apply and enhance my knowledge and technical skills for
       the personal and professional development.


SUMMARY OF QUALIFICATIONS:

       Total 2.6 years of experience in Oracle 9i or 10g.
       Hands on Experience to write Stored Programs, Anonymous blocks.
       Hands-On experience in SQL Query Optimization,
       Hands on Experience to Reports development and spooling.
       Highly Proficient in Oracle9i & Oracle 10g with PL/SQL.
       Hands-On experience in Installation, Administration and Maintenance of Oracle 9i/10g.
       Hands on Experience on Backup Scheduling.
       Conceptual knowledge of physical database design and Performance Tuning.




TECHNICAL EXPERTISE:

    OCA :                    Oracle Certified Associate


TECHNICAL SKILLS:

       Systems:               Windows
       Languages:             Sql , Pl/Sql.

       Software/Tools:        TOAD, Sql Developer.
       RDBMS:                 Oracle 9i,10g,MsAccess.




ORGANIZATIONAL EXPERIENCE:

       Since May’ 2011’ with Thomson Digital Noida (U.P.)

    Thomson Digital , Noida.: Thomson Digital (A Division of Thomson Press India ltd) is among the
    leading service providers for content processing for multi-modal delivery The process involves converting
    raw, unformatted information of multiple types using customer-defined rules, into a consistent, defined and
    directly publishable document format. We also provide value additions like artwork and tables resizing and
    touchup, scanning and fresh design, and localization of content.




                                                                                                              1
SHALAJ VERMA
                                                                                               OCA Certified

Key Projects Handled:


    1. Project Title : FMS (File Management System)


            DBA Team Size: 4
            Technologies: Oracle9i and 10g Database, User manage backup, Sql &
            PL/SQL.
      Description
          FMS is a web based content management system that provides systematic file movement
       across various activities during the course of processing a job in T.D . This application includes all
       processes starting from the initial receipt of materials to moving and passing of file through various
       departments. The file is moved according to the workflow. Before uploading the file that is to be
       processed by other departments, various validation checks are done. This implies proper enforcement of
       Quality Control procedures.


     Role and Responsibilities

            Generating Daily and week status report of each database
            Maintaining security of the database through privilege and roles
            Creating schema with all object required
            Using Export and import for moving data between different databases.
            Loading data into the databases through flat file.
            Using data dictionary view and dynamic performance view to monitor the status and performance of
             database.
            Technical documentation of database and processes
            Designing of Physical and Logical Database Layout
            Take the backup of database

    2. Project Title : TIS (Thomson Information System)


            DBA Team Size: 4
            Technologies: Oracle9i database server, export & import , Sql & PL/SQL.
.
      Description:
         Thomson Information System (TIS) is a comprehensive enterprise-wide information system
      covering all the information needs of each and every department in the organization.TIS is flexible
      and easy to use. The main features of TIS are complete order tracking system: That tracks the
      orders of clients.


     Role and Responsibilities

            Moving database schema from Oracle 9i to Oracle10g through Export and import
            Database Synchronization between production environment to Live and test Environment
            Designing and creating Schema with all object for different applications
            Designing Technical and functional documentations of different databases and change processes
            Writing and optimizing SQL queries for software applications and generating reports for MIS.
            Creating procedures, functions, triggers as per requirement.Loading data into the databases
             through flat file.




                                                                                                            2
SHALAJ VERMA
                                                                                                    OCA Certified

    3. Project Title : HRMS (Human Resource Management System)


             DBA Team Size: 4
             Technologies: Oracle9i database server, export & import , Sql & PL/SQL.
.
      Description:
          HRMS is a web based application that enhance the core productivity of the human resource
department.We realize that HR is a vital department in driving the most important asset of any organization , that is,
the workforce .This system automates much of the HR activities lessening the chance of error.


      Role and Responsibilities

             Creating database and with all object required
             Provide all possible support
             Database Synchronization between production environment to Live and test Environment
             Designing and creating Schema with all object for different applications
             Designing Technical and functional documentations of different databases and change processes
             Writing and optimizing SQL queries for software applications and generating reports for MIS.
             Creating procedures, functions, triggers as per requirement.Loading data into the databases
              through flat file.



    COMPANY PROFILE:

     One Touch Solution, Noida.
     Position: PL/SQL Developer
     Total Time: 1.6 years


    Work Summary

      CRM database maintains (updating required objects)
      Dialer database maintains
      DNC wash on portal
      Database User creation
      Provide privilege to user
      Database Backup

      Description: To maintain the database of CRM and Dialer in Oracle 10g and Ms sql server 2005
      respectively .We can update the triggers ,procedures and some required manipulation according to the
      valid requirements and provide some extra utility. We have a large database of Australia We fetch the
      data according to their dialer requirement through our database and export the data in EXCEL and get
      ready to performing DNC wash after some manipulation and we get the DNC registered number to scrub
      these numbers with the actual data and finally we will get the unregistered DNC number .These data are
      ready for dialer. We also update the database and manipulate the tables data according to campaign and
      sales requirement and also maintain weekly basis database recovery. We maintain a graph (chart) how
      much data are washed within a week. It is on weekly basis and forward to the regarding senior.
      We also maintain the sales data and Business data.




                                                                                                                    3
SHALAJ VERMA
                                                                                 OCA Certified
EDUCATIONAL QUALIFICATION:

               Course                                     Institute/University
   Bachelor Of engineering (I.T)   Rajasthan University, Jaipur
   Senior Secondary                U.P Board
   Secondary                       C.B.S.E Board

PERSONAL PROFILE:

   Name                            Shalaj Verma
   Father’s Name                   Shri Dinesh Verma
   Date of Birth                   8 April, 1988
   Marital Status                  Single
   Nationality                     Indian
   Language Known                  English, Hindi (Native)
   Permanent Address               C/o Mr. Ram Das Verma,
                                   22/ 65 Bagh Antha,
                                   Loha Mandi, Agra (UP)
                                   INDIA.




                                                                                             4

								
To top