Sushil Dwivedi Email and Phone Number

• Evaluate client business challenges and work with the team to arrive at the best-fit technology solution.• Design, document, and develop MongoDB Enterprise architectures, patterns which will be well suited for bank’s use cases.• Study the database needs of a client s application and optimize them using MongoDB. • Build MongoDB performance and capacity planning. • Have experience in configuring and monitor multiple MongoDB instances and replica sets, create MongoDB backup and recovery plans. • Assist with estimating work efforts required to build MongoDB solutions and performance improvement techniques on existing and new processes.• Technically leading more than 7 members on suggesting and reviewing their day to day activities.• Working as a Mongodb TPO(Technical Product Owner) in the bank and possessing all its roles and responsibilities like product upgrade, decision trees, product catalogue, standard document, roadmap etc.

Project: Communication SurveillanceJob responsibilities:• Provide support in database architecture of the project through database design, modelling and implementation• Understand the end-to-end scope of work and design architectural solutions accordingly• Use database design and database modelling concepts to ensure data accessibility and integrity. • Continuous integration and deployment on different environment using team city, ARM, Octopus.• Support the project data warehouse through appropriate utilization of ETL tools.• Extracted data from various sources like SQL Server 2008/2012, .CSV, Excel and Text file and load into database via SSIS.• Design and develop solutions regarding ETL through extensive usage of SSIS.• Designed and implemented stored procedures views and other application database code objects.• Maintained SQL scripts indexes and complex queries for analysis and extraction.• Involved on optimising SQL objects and coding best practices.• Report design and development using SSRS/Tableau.• Leading more than 15 members of team for their work allocation, tracking, recruitment and appraisal.• Having good knowledge of Compliance domain (Trade and Communication Surveillance).Achievements:-1. Database design for communication surveillance project.2. Designed and developed utility for automated database code deployment.3. Migrated Sybase database components into SQL Server 2012 and saved infrastructure and support cost for maintaining both databases for single project.4. Setup Continuous Integration (CI) and deployment (CD) on all environments using Team city, ARM/Octopus.5. Expert academy trainer on Data analytics and Data modelling.6. Predictive analysis on Trade surveillance which helps for reducing false positive and increasing efficiency.

Project: Trade SurveillanceJob responsibilities:• Managed QA team of 7-8 members, delivering on average 15-20 requirements on quarterly cycle.• Involve requirement analysis; test strategizing, test cycle planning, estimation, test plan review and execution review.• Involved in test execution and delegating test execution to testing team and track their progress.• Represent testing team in different forums and provide update.• Involved in different formal and informal project review meetings.• Involved in environment management activities.(Applications, Database, Autosys, Argon, Services).• Involved in conducting UAT activities and provide test signoff.• Involved in fulfilling audit requirement of attestation.• Involved in employees appraisal and recruitment process.Achievements:-o Automated end to end reconciliation process. o Take over SSAS/SSRS development work parallel to test lead responsibilities.o Automated manual batch running process and saved 1 full man day and appreciated by management team.o Academy training on MSBI (SSIS/SSAS/SSRS) in Gurgaon and Chennai.

Project: S-mart (Sales Mart)Job Responsibilities:• Managed QA team of 15 members, delivering on average 10-15 requirements on quarterly cycle.• Main tasks include requirement analysis; test strategizing, test cycle planning, estimation, test plan review and execution review.• Delegate test execution to testing team and track their progress.• Providing project implementation support.• Mentoring new team member and knowledge management activities.• Daily, weekly and monthly status reporting.• Technical Guidance to team in Database, ETL, SSAS and Report development.• Involved in creation/review of functional and technical specifications.• Environment management.Achievements:-1. Migrated 10 different applications into S-mart without any major concern. Performed detail risk analysis of migration tasks and handled properly. This migration process decommissions duplicate systems from Organisation and saved infrastructure and support cost.2. Optmised cube process timing which helped to generate critical report to business user beforehand and broadly appreciated in organization. 3. Trained Organisation’s employees in academy on advance database concepts and MSBI.4. Established defect RCA process using 5 whys technique to prevent production defects and delivered projects with high quality.5. Received multiple appreciations from Global management team.

Project: CSATJob Responsibilities:• Read design and requirement documents as a part of Review• Writing and Executing Test Cases and Maintain the bug cycle.• Conducted different formal and informal review meetings.• Reporting and controlling any test failures within testing schedule Limit.• Read design and requirements documents as a part of Review.• Using SQL for checking the output of various reports.• Reviewed & Tested packages, fixing bugs (if any) using SQL 2005 Business Intelligence Development Studio.• Daily support of system wide replication tasks including monitoring, alerting, and problem resolution.• Code review and dog fooding.Achievements:-1. Automated environment preparation activity.2. Automated testing regression process which helped to complete testing cycle with minimal supervision and less time compare to manual activity.3. Implemented test case management process across organization.

Project: EPFO (Employee Provident Fund Organisation)Job Responsibilities:• Requirement understanding, test case writing and execution and ensure that the requirements, artefact from each phase, and the final product are complete and correct.• Identified the requirements and arranged peer reviews, walkthroughs and sign off meetings.• 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.• Reporting and controlling any test failures within testing schedule Limit.• Importing Source/Target tables from the respective databases by using Execute Package Task& using Control Tasks in SQL Server 2005 Integration services.• Development of packages according to the ETL specifications for the staging area & Warehouse data loading using SQL Server Integration Services & SQL Server 2005.• Daily support of system wide replication tasks including monitoring, alerting, and problem resolution.• Developed DTSX packages to extract, transform and load into the Campaign database from OLTP database using of SQL Server Integration Services (SSIS).Achievements:-• Automated different process like code deployment and environment preparation activities.• Conducted UAT activities with different high government official and appreciated by them.