Punam Pradhan

Punam Pradhan

System Executive

Followers of Punam Pradhan149 followers
location of Punam PradhanMaharashtra, India

Connect with Punam Pradhan to Send Message

Connect

Connect with Punam Pradhan to Send Message

Connect
  • Timeline

  • About me

    Module Lead

  • Education

    • Wilson college mumbai

      -
      Master's Degree Chemistry

      Activities and Societies: Dancing at annual day, putting stalls in funfares ... An imp field inorganic chem that i studied as chemicals are evrywhere...

  • Experience

    • Hathway Cable & Datacom Ltd

      Feb 2008 - Jun 2011
      System Executive
    • Fauna Technologies Pvt. Ltd.

      Jun 2011 - May 2013
      Software Developer

      Developing Procedures, functions, Packages, sql queries, temporary tables, schedule jobs...What i know:-Cursors-parametrized, dynamic, ref cursors, Overloading of procedures, functions with diff datatypes of arguments, Creating force views to reduce compilation errors, Materialized views, making tables with proper constraints- primary key, unique key,foreign key, Triggers for certain action after a DML event and history tables, Collection to handle large data- varrays, assciative arrays, plsql tables, nested tables using bulk collect and forall and Bulk SAve exceptions........ Creating synonyms, indexes (bitmap, function based, and btree), sequences...Using UTL_file for reading and writing files and utl_smtp- to send mails..Studing explain plan and using DBMS_trace , Compiler hints(No_index, leading, use_concat, use_merge, no_expand, hash, use_NL , ordered , Index)Character functions(replace, substring, instring), number functions(ceil, floor, round), composite datatype, composite primary keys, Rollback savepoint in procedures..Set operator in sql queries union, minus, intersect, union all)Analytical functions- Rank, Dense_rank, first, last, row_number...Group functions- Cube, rollup, avg, max, min, sum , count..Joins- Outer, full, right, left outer joins , self joinsInline views, corelated subqueriesForms10g - Open_form, New_form, master detail forms , post_query, pre_insert, when validate_item ,when_new_record_instance, To make alerts (Caution, Note) , Dynamic record groups, DynamicLOVS, Client_text_IO to write excels, Default_where, WEbutil_open dialogue to upload files from client machine, Visual_attributes, error messages in ON error trigger,right click popupmenus,property class etc....Reports10g- Lexical parameter using, Master detail reports, Formula cloumns, Data_links matrix reports, attaching images from source in property... And much more... Show less

    • The Boston Group Software Consultants(TBG)

      Sept 2014 - Dec 2014
      Consultant
    • ASM Technologies

      Mar 2015 - Feb 2016
      PLSQL developer

      Performance tuning, complex queries , advanced PLSQL.........

    • Xalted Information Systems Pvt. Ltd.

      Feb 2016 - May 2017
      Senior PLSQL developer
    • Worldline epayment - Atos company

      Jun 2017 - Apr 2018
      Senior Software Engineer
    • Hexaware Technologies

      May 2018 - Nov 2023
      System Analyst

      PLsql,Unix,controlm,dotnet

    • Mphasis

      Feb 2024 - now
      Module Lead
  • Licenses & Certifications