Nikhil Gupta

About Nikhil Gupta

Over 12 years of industry experience in transforming business challenges into competent software solutions and to achieve customer delight in many projects. Working experience with many big clients such as T-Mobile, Allianz Insurance, Deutsche Bank, Dollar General, SANMAR, City of Seattle across multiple locations in US. Worked full time for over 8 years with HCL Technologies as a Technical Lead, with an expertise in business analysis, business process and data modelling creation, User Stories and Use Cases creation, conducting GAP and Impact Analysis, Risk management. Over 10 years of experience with framing database queries in SQL, TeraData and Oracle Expertise in preparing Business Requirement documents (BRD), Functional Specification document (FSD), Requirement Traceability Matrix (RTM). Proficient using the tools like JIRA, Confluence, Quality Center, Visio Actively participate during Joint Requirement Planning (JRP) sessions with Business User Groups, Joint Application Development (JAD) sessions with IT teams and other team members. Comprehensive experience in every aspect of SDLC process involving: Understanding Client requirements, Requirements gathering using Waterfall & Agile Methodology, Acceptance criteria, facilitate UAT, preparing test scenarios/ test cases, test documentation, test reports. Experienced in preparing the data workflow diagrams, screen layouts, internal and External interface layouts. Recognized as an expert at managing execution, improving client relationships through building trust, effective communication, and actively maximizing relationships to foster a collaborative culture at multiple levels.

Experience

1. Business System Analyst

   T-Mobile

   Jan 2017 — Present · Bellevue, WA, US

   Performed the Business Analysis of ECS (Employee Commissions System) application, documenting business requirements, wrote Use Cases, wrote complex SQL/ORACLE queries, facilitated UAT. Streamlined and defined Scrum process for new teams formed for the execution of the project. Conducted milestone planning and doing stakeholder management (both technical and business) for global initiatives. Planned, tracked, measured and reported on the status of a variety of ECS projects throughout the entire development life cycle. Managed Product Backlog: Created Personas, Journey Maps, Use Cases, Workflows, User stories, Functional Specification Documents. Performed Sprint Planning and sprint backlog grooming activities: User Story Walkthrough; Effort Estimation. Developed Domain models, Use Case documentation, Screen layouts, data flow diagrams, use case diagrams, activity diagrams, Class diagrams, Sequence diagrams and state charts using MS Visio. Communicated progress and impediments to all stakeholders and the leadership team on a regular basis. Conducted war room discussions for quick resolution of critical showstoppers. Mentored business users in their roles during User Acceptance testing. Prepared UAT test scenarios, Test plans, Test reports.

Education

• Punjab Technical University

  Computer Science and Engineering, Computer Software Engineering

  2003 — 2007

Skills

• Pl/Sql
• Oracle
• Requirements Analysis
• Regression Testing
• Functional Testing
• Team Management
• Sdlc
• Core Java
• Sql
• Quality Center
• Microsoft Sql Server
• Test Planning
• Manual Testing
• System Testing
• Test Automation
• Software Quality Assurance