Shatrughan Singh

Shatrughan Singh

Software Design Engineer

Followers of Shatrughan Singh1000 followers
location of Shatrughan SinghDelhi, India

Connect with Shatrughan Singh to Send Message

Connect

Connect with Shatrughan Singh to Send Message

Connect
  • Timeline

  • About me

    Principal Member Of Technical Staff at Oracle

  • Education

    • St. John's Sr Sec School

      1991 - 2000
      Physics, Chemistry, Maths
    • Makhanlal Chaturvedi Rashtriya Patrakarita Vishwavidhyalaya

      2001 - 2004
      Bachelor of Computer Application Information Technology
    • Amity Education Group

      2005 - 2008
      Master of Computer Applications - MCA Information Technology
  • Experience

    • The Perfect Future

      Sept 2008 - Jan 2010
      Software Design Engineer

      Responsibilities: • Development of platform components using Language C, Python, SQL, Perl & Shell scripts.• Development and maintenance of the entire Communication between several servers(Linux & windows) installed with Asterisk on daily basis using Perl, Shell scripting to: a. Apply filtration and transfer data/bulk of audio files from different sources b. Generate and aligned unique files with its related data at numerous locations c. Form & maintain a boundary between all collected data d. Mark entries in individual excel sheets as per required format e. Log all the activities and exceptions step by step individually as well as globally• Development and maintenance of batch files to transfer all processed files and folders to another various servers to seed the data as per TTS input on weekly basis.• Develop various modules of almost each project by using Python & SQL scripts for oracle database.• Work extensively with business users to define scope and prepared ‘Documents of Understanding’ for various change requests by analyzing the feedback from user groups.• Debug & fix bugs reported by operations or customers Show less

    • IBM

      Feb 2010 - Aug 2010
      System Engineer

      Responsibilities: • Analyse project requirements & designed high level documentation.• Development and maintenance of Tuxedo Services in C to enable all CRM activities like activations, billing and provisioning.• Provide solutions by writing UNIX shell scripts as per the small requirements and to resolve existing issues.• Deploy & involve in small/large fixes and enhancements on production servers.• Conducted brainstorm sessions & effort estimation.• Interacted with multiple development teams at IBM in India to resolve technical and functional queries, including defect tracking. Show less

    • Oracle

      Aug 2010 - now
      Principal Member Of Technical Staff

      Responsibilities:• Gather & Analyze business requirements and process documents pertaining to new customizations or enhancements• Responsible for writing and maintaining Automation scripts using WebDriver for regression.• Design & develop Super Mass Consolidation tool for upgrading from REL12 to REL13 by using shell scripts, SQL, PL/SQL & Python to perform & automate all major operations, like:a. Setup & configure multiple REL12 domains on multiple Linux platform.b. As per user’s requirement, it provides SMC configured environment with all REL12 domains for data population before upgrading to REL13.c. Consolidate all composites & runtime data and migrate all to REL13 single domain.d. Process of backup/restore data, if any failure happens.• Develop various PL/SQLs to verify below stages before & after migration:i. Source to Target row counts based on the retention period and schema selectionii. Database object counts on Target Schemaiii. Sequence Numbers correctly setiv. No errors in the SMC_ERROR_LOG table• Develop various Python scripts to update data source for each REL12 domain with all different properties.• Perform Data Validation for various areas before & after Migration on both local and FA environment:a. BPM related functionality, like: vacation period, user Rules, HWF Tasks & Share Views, Approval Groups, etc.b. BPM Composer related functionality with drafts, applications, import/export & templates etc.c. SOA related functionality, like: deploy/un-deploy/retire composites, Paused/Un-paused the EDN Queue, Email Notification etc.d. Verified Source to Target row counts based on the retention period and schema selectione. Verified many ERs as part of SMC, like: Approval Group collision, BPM Project Collision detection, BPM Post Migration, Composite Name conflict, User task Views etc.• Develop Python scripts to test REST API functionality for regression setup. Show less

  • Licenses & Certifications

    • Microsoft Certified Systems Engineer (MCSE)

      Microsoft
      Jun 2004