Relocation: Seattle, WA area only
To leverage my strong analytical and decision making skills towards a career that offers professional growth and incorporates my ability to be resourceful, innovative and flexible.
Unix, Oracle-SQL, PL/SQL, SSMS, COBOL, Pro-COBOL, Shell Scripting, Microsoft Office 2013 Suite- MS word, MS Excel, MS Power Point, HTML,XML, ITIL, CPP, C, Mozilla Thunderbird, MVC Architecture, Waterfall model,Agile SDLC, FTP Surfer, Filezilla, Bugzilla, Beyond Compare, Gvim, Lotus Notes, TCS- mastercraft, Linux,Smartest -ALM.
Programming Concepts: Data Structures and RDBMS
Platforms: Windows XP/NT/2000/9x, MS-DOS, UNIX, AIX/HP Server.
Version Control Tools: GIT, ALM, SVN
Extensive experience in enterprise software development life-cycle - Waterfall and Agile methods.
An incisive professional with 5 years of total experience in IT industry .(4 years as developer and support, 1 year as SDET )
Having expertise on UNIX (development), Bash Scripting, SQL, Oracle 11g and 12c, MVC architecture, SQL Server Management Studio, COBOL and Pro-COBOL, Testing methodologies, Microsoft Excel and Word.
Proficient knowledge on C++, C, C# and web tech - XML and HTML,UNIX Admin(TCP/IP,Kernel, Networking/Host), SSMS and Oracle- SQL developer..
Hands-on experience with different Linux flavors- HP-UX, AIX, Redhat and Ubuntu.
Experience in Relational Database Management Systems, Including Normalization, Data Import/Export, Joins, Stored Procedures, Constraints, Indexes, Triggers, Cursors. .
Provided daily support for the system having an average user count more than 10 Billion.
Extensive Performance, Stress, Scalability, Capacity, functional, white box, security testing experience.
Hands on experience in Quality Assurance in Manual Testing, Automated Testing, Database Testing, Client/Server based applications, Test Plan, Test Strategy, Test Cases and Test Scenarios.
Extensive knowledge of Bugzilla.
Awarded as the Best Team member and On The Spot.
TATA CONSULTANCY SERVICES
Project-TCS Bancs
TCS – System Engineer – March 2013 –Feb 2016
Project – TCS BaNCS Customer- National Bank of Kuwait(NBK).
System Engineer (Developer and Support).
Key Accountabilities:
Designing and analyzing the impact of requirement provided. Understanding functional requirement and converting it for bancs technical architecture. Manages complete cycle of change. Implementation of new change requests for bancs along with Unit Testing. It includes: Automate, debug and deployed multiple changes for TCS-Bancs using SQL,COBOL, Scripting-on UNIX, XML and HTML
Improved the team output by the implementation of Visual and White box testing for Developers.
Provided 24/7/365 on-call support of customer, all systems and associated software.
Performance tuned the stored procedures and queries for efficient throughput.
Coding of several Database Triggers, Stored Procedures, SQL scripting, Database usage – Oracle 11g and 12c, language used- SQL
Created job schedules to automate the routine tasks.
Applied usage of Hint, Null functions and Joins for better validations and desired output.
All the database related changes – includes new table creation and usage satisfying required normalization forms. Exporting and importing the database on different servers along with synchronization.
Met SLA's for all the incidents reported with accuracy.
Responsible for formation and deliverable to customer.
Working on role of back up Project Lead since August-2015.
Has done major implementations for NBK Customer which are unique for TCS.
Prepared documents - Functional specification, technical specification, Requirement Traceability matrix, Root cause analysis, Incident resolution document, Unit testing document.
Project – TCS BaNCS Customer - National Commercial Bank
Key Accountabilities:
Design and implementation of stored procedures and triggers for automating tasks.
Worked on purging of multiple tables along with applying validation on them.
Consistently recognized for excellent problem-solving and analytical skills by programmers, project managers and supervisors.
Active member for Automation Testing, Manual Testing, Database testing related to performance and Client server application testing.
Creation of Test Case and it's document. Tracking all the requirement meetups and tracking bugzilla for test progress, test execution and deliverables.
Has done Black Box Testing Techniques such as Boundary Value Analysis, Equivalence Partitioning, Comparison testing and Error Guessing.
Performed different kinds of testing like Smoke, Sanity, Functional, GUI, Backend, System Testing, Integration Testing, Regression Testing & UAT.
Initial Learning Program – TCS Training
Object Oriented Methodologies C++ on UNIX, PL/SQL, MVC Architecture, Business Skills
GLOBAL INFOWAYS
S.I.M
GLOBAL INFOWAYS – Application Support – March 2011 –Feb 2013
Project – Software of Institute Management Customer- ABES Engineering College
Key Accountabilities:
Elicitation of requirements.
Requirements organization.
Translating and simplifying requirements.
Modelling techniques and methods in SQL using Oracle SQL developer.
Maintain Application Environment
Collaborated with database development team for testing implementation.
Collaborated with QA Group to ensure adequate testing to maintain quality procedures, conducted UAT Testing, and ensured that documentation including test plan, test conditions and test cases to be used in testing based on business requirements, technical specifications and/or product specifications.
Worked on SQL Joins, Stored Procedures, Constraints, Indexes, Triggers, Cursors.
Bachelor of Technology in Computer Science, ABES Engineering College, Ghaziabad, Delhi.