Susheel Verma_CV

Susheel Verma_CV

• 1.
  SUSHEEL VERMA H.No. RZ-21/EStreet No. 24,Sadh Nagar Palam Colony , New delhi 110045 Contact:+918800579269 DOB- 22/09/1984, Email- susheel.verma22@gmail.com About 5+ years of experience in Software Testing/development in various capacities on different platforms in Web Based, Client/Server, Java/J2EE, DotNet Applications in different environments and multiple Browsers. SUMMARY OF EXPERIENCE • Currently working with Espire infolabs Private Limited(CMM-I LEVEL-5) , Gurgaon • Over 5+ years of experience in Quality Assurance in Information Technology, involving analysis, both Manual and Automation testing of client server and web applications. • Extensive experience in ETL/ Data warehouse backend testing and BI Intelligence reports testing. • Extensive testing ETL experience using Informatica 9.5/8.1 (Power Center) (Designer, Workflow Manager, Workflow Monitor and Server Manager)and SSIS/SSRS as ETL tool • Extensive experience in developing SQL scripts to validate the databases tables and reports data for backend database testing. • .Good experience in Test automation with Selenium (Web Driver). • Having exposure of performance testing with JMeter tool • Having experienced in Defect tracking tools like Jira, bugzilla ,TFS • Worked on test management tool like quality center, Software planner. • Proficient with Financial , Power & utility , Printing Domain • Work with multiple of repository system as GIT and SVN etc. • Excellent Knowledge of Database Systems – Oracle 10g, SQL server, DB2 and Data ware house concepts • Actively involved in User Acceptance Testing (UAT) and Training of the end users. Participated in cross-functional teams to reengineer and improve business processes. • Good knowledge of Software and testing architecture with quality control, quality assurance. • Having experience to prepare the artifacts as Test strategy, Test plan, Test Matrix, Test cases, defect sheet etc. • Having interest to deal with new tools and technology and found myself a excellent team player, having ability to meet tight deadlines and work under pressure.
• 2.
  TECHNICAL PROFICIENCY Operating SystemsMicrosoft Windows 7/2000/XP/Vista Databases SQL Server 2005/2008/2012, DB2, Oracle 10G Testing Tools and IDE TFS, Bugzilla, Jira, Software Planner, Eclipse ,Quality Center ETL Tools Informatica 9.5/8.1 , SSIS/SSRS General Tools/Packages Rational Rose, Smart Draw, Git Repository ,SVN Test Automation Knowledge Selenium (Web Driver ,RC ) Languages Known C#, SQL, core java ,unix EDUCATIONAL SUMMARY: SCHOOL/COLLEGE BOARD/UNIVERCITY YEAR OF PASSING Medicaps institute of techno- management, Indore RGPV,University 2009 Unique College ,Bhopal Barkatullah University 2005 Maharishi vidya mandir, Bhopal M.P. Board 2002 Anand vidya mandir , Bhopal CBSE Board 2000 POFESSIONAL ACHIEVEMENTS • Received an appreciation letter from the management for the good quality work delivered to the clients. • Identified as one of the top performers in Arohatech IT Services (P) Ltd. EMPLOYMENT SUMMARY: COMPANY DESIGNATION DURATION Espire infolabs ( p) Ltd ,Gurgaon (CMMI Level-5) Sr. Analyst May 2013- Now Vertex customer management India ( p) Ltd , Gurgaon (CMMI Level-3) Analyst June 2011- May2013 Arohatech IT Services (P) Ltd,Noida (ISO-Certified) Software Engineer (Dev, Support) Dec-2009 – June 2011
• 3.
  PROFESSIONAL EXPERIENCE: 1) Espireinfolabs Private Limited, Gurgaon (www.espire.com/) Profile: Sr. Test Analyst Projects Worked / Contributed / Undertaken  Sembcorp-WMS Duration: DEC 2013 TO NOW Client: SembCorp Team Size: 10+ Location: Singapore Project Theme: SembCorp-WMS is basically a software and services which can manage all the waste material in Singapore.Here we are dealing with all the modules of project as compactors, dust drums, fleet, routes, deployment sheet, user management and all the reports that has been created with preprocessed data with ETL tool. Roles and Responsibilities: • Actively involved in Test Requirement and analysis. • Prepared the Test Plan and Testing Strategies for Data Warehousing Application • .Complete responsibility of audit trail/ETL testing with SSIS/SSRS. • Developed ETL test scripts based on technical specifications/Data design documents and Source to Target mappings. • Written and test with the complex sql queries for testing. • Extracted data from various sources like Oracle, flat files and DB2 server. • Scheduling and automating jobs to be run in a batch process • Prepared daily status reports with details of executed, passed, and failed test cases and defect status. • Test execution , defect identification and verification  Evolution/Medacs Application (Healthcare Recruitment) Technology Used: MVC, VB.net, ASP.net, Jira, Sql Server 2008 Duration: DEC 2013 TO NOW Client: Impellam Group Team Size: 10+ Location: UK Project Theme: The intent of this project (Medacs/Evolution) is to provide an Dot net Environment based product for recruitment services in healthcare domain where we have different user group like Client, Admin and worker group in all the medical professional. In this project multiple of services and different kind of application has involved there. Roles and Responsibilities: • Actively involved in Test Requirement and analysis. • Ensuring the designing the testing framework architecture. • Prepare all the initial Test Strategy, Test plan etc. • Prepare test data and worked in Kanban/Agile methodology • Responsibility to test the application with all the phases as functionally, db verification with sql queries and automation comes in the phase ( if required ).
• 4.
   JEA-PENFAX Application(Banking & Finance domain ) Duration: May 2013 TO Dec2013n Client: JEA Team Size: 30+ Location: USA & Canada Project Theme: The intent of this project (JEA Penfax) is to provide an Oracle ADF based product which would be rewriting the existing Oracle Forms & Reports based product. This would facilitate service oriented architecture and targeting the market of North America (USA & Canada). Roles and Responsibilities: • Actively involved in Test Requirement and analysis. • Involved in testing activity with informatica power center (ETL)Tool • Test script creation and execution and tested ETL packages and macros. • Creating test cases for ETL mappings and design documents for production support • Prepared daily status reports with details of executed, passed, and failed test cases and defect status. • Tested a number of complex ETL mappings, mapplets and reusable transformations for daily data loads. • Setting up, monitoring and using Job Control System in Development/QA/Prod • Verification of DB relations, memory management, integrity constraints etc. • Responsibility to test the application as manually and with the use of Automation tools. 2) Vertex Customer Management india Pvt. Ltd. (www.Vertexgroup.com) Profile: Application Analyst Projects Worked / Contributed / Undertaken  E-CIS+ Application (power & utility domain ) Duration: June 2011 to May 2013 Client: NWE Client Team Size: 60+ Location: North America Project Theme: Ecis+ application is basically a utility based product and it holds all the customer information regarding the utility which they are using. It contains services as Electricity, Water, Gas etc. and for this here we are providing the service for application support, application development and Testing. Roles and Responsibilities: • Actively involved in requirement gathering, analysis and designing of test automation.. • Ensuring the designing the framework architecture. • Deal with complex Sql queries in DB2 database. • Test script creation and execution • Responsibility to test the application as manually and with the use of Automation tools. • Analyzing and dealing with AS400 environment.
• 5.
  3) Arohatech ITServices Pvt. Ltd. (www.Arohatech.com) Projects Worked / Contributed / Undertaken  R-APDRP Project(power & utility domain ) Duration: May 2010 to June 2011 Client: upcl Team Size: 40+ Location: Dehradun (Uttarakhand) Project Theme: UPCL (Uttarakhand power corporation limited) is about to launch its new automated power and electricity utility services in Uttarakhand. The project has all the features with multiple type of connection, maitaines, and billing and with some enhancing features like customer care and customer services. Roles and Responsibilities: • Actively involved in requirement gathering, analysis and designing of the product. • Ensuring the designing confirm to the requirement. • Responsibility to test the application as manually and functionally • Worked on Selenium(RC) for automation script creation and testing • Analyzing and dealing with AS/400 ENVIRONMENT. • Done BI testing threw SSIS,SSRS and database testing as well. • Worked on manual script and involved actively in utility domain knowledge.  Job portal Duration: Dec 2009 to May 2010 Team Size: 7 Client: Lemon force Project Theme: This Project is basically a job portal and all the functionality like resume search, Registration, post job, import contact, face book sharing, all the Employer part and admin part ,it has mainly four section like Admin, jobseeker, Super Admin and Sub employer etc. Roles and Responsibilities: • Involved in requirement gathering, analysis and designing of the test automation. • Did complete Regression testing, functional and non functional testing. • Involved actively in function testing and all the database operation. • Involved actively in test planning , test scenarios and test cases development • Defect tracking and reporting the bug with bugzilla. • The project was delivered with great quality and within timelines. • Writing complex queries for the test cases.
• 6.
  Personal Profile: Name: SUSHEELVERMA Gender: Male Date of birth: 22-09-1984 Marital status: Married Nationality: Indian Father’s Name: Mr. S. S. VERMA Linguistic Ability: English, Hindi Passport Number: H8042348 Present Address: RZ-21/E Sadh nagar, Palam colony, Street No.24, New Delhi -110045 Personal Strength: Leadership skills, Self-confidence, Optimism and Hard working. Declaration: I hereby declare that all the details furnished above are true to the best of my knowledge and belief. SUSHEEL VERMA
• 7.
  Personal Profile: Name: SUSHEELVERMA Gender: Male Date of birth: 22-09-1984 Marital status: Married Nationality: Indian Father’s Name: Mr. S. S. VERMA Linguistic Ability: English, Hindi Passport Number: H8042348 Present Address: RZ-21/E Sadh nagar, Palam colony, Street No.24, New Delhi -110045 Personal Strength: Leadership skills, Self-confidence, Optimism and Hard working. Declaration: I hereby declare that all the details furnished above are true to the best of my knowledge and belief. SUSHEEL VERMA