Shatrughan Singh

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