About Sushil Dwivedi
Sushil Dwivedi works as Team Lead at RBS and is based in Gwalior, India. Sushil studied Master in Computer Application at Bhartiya Vidya Mandir College of Technology and Management (2001-2004). On Youth4work, Sushil has taken skill tests in SQL Server (rank 4,183 of 52,571, top 8%). Sushil also lists talents in Software Development, Business Intelligence and Data Warehousing.
Talents
-
Software Development... among ... users in Gwalior…among … users worldwide -
SQL Server... among ... users in Gwalior4183among 52571 users worldwide83.94percentile among worldwide users -
Business Intelligence... among ... users in Gwalior…among … users worldwide -
Data Warehousing... among ... users in Gwalior…among … users worldwide
Professional Path
Team Lead
RBS
Full Time
Jan-2009 To
present
17 years 8 months
- 1. Managing test team for their work allocation, daily status, and appraisal.
2. Verified different reports and wep applications to ensure that the requirements, artifact from each phase, and the final product are complete and correct.
3. Identified the requirements and arranged peer reviews, walkthroughs and sign off requirement.
4. Defining and performing the Test strategies and associated scripts for the verification and validation of the application and ensuring that it meets all defined business requirements and associated functionality.
5. Performed the Unit and functional testing which validate the data is mapped correctly which provides a qualitative check of overall data flow up and deposited correctly in Target Tables.
6. Involved in Performance tuning, Optimization of database objects and Cube using SQL Profiler, PerfMon.
7. Performed SQL validation to verify the data extracts and record counts in the database tables.
8. Designed policies, standards and procedures for testing life cycle for the data warehouse and data marts.
9. Attended the Requirements reviews, Design reviews, Code reviews to understand the overall process flow and Source to Target Mappings.
10. Extensively worked on debugging ETL and Procedure.
11. Developed and tested transformation functions and record formats for various input data files.
12. Performed Data validation to verify the data extracts and record counts in the database tables.
13. Conducted weekly batch testing to incorporate changes in new builds.
14. Provided the management with weekly QA documents like test metrics, reports, and schedules.
15. Write MDX for Cube(SSAS) verification from SSMS and webapp.
16. Tested Cognos and Qlik reports with features of Drilling options [drill up, drill down and drill anywhere].
17. Data warehouse project automation using c# and T-Sql.
18. Preparation of documents for test activities (Test plan, Test estimation, Test Metrics) - a) Automation regression pack for database testing in .Net and Sql.
b) Environment Preparation tool in .Net and Sql
Qualifications
Bhartiya Vidya Mandir College of Technology and Management
Master in Computer Application Computer Application
2001-2004
-%
Contact details are visible to employers.
Log in or sign up as an employer
Other people named Sushil
- Sushil Kumar Bajpai, Jhansi
- Sushil Kumar, Dehradun
- Sushil Kunar, Bihar Sharif
- Sushil Kumar, Palampur
- Sushil Kumar Yadav, Lucknow
- Sushil Kumar, Gaya
- Sushil Shingne, Buldhana
- Sushil Kumar, Greater Noida
