Sql Server Test Cases

Venkat

Location: Raleigh NC

Professional Summary:

Over 8 years of experience in gathering business requirements, defining business process flow, system analysis, business process modeling and analysis.

Managed Features, Epics and User stories in Rally tool.

Assisted RTE and Program Manager to run Quarterly Release Planning sessions.

Managed multiple Scrum Ceremonies, Sprint Planning, Sprint Refinements, Sprint Reviews, Sprint Retrospection, Daily stand ups, QA Warranty calls and 3 Amigos.

Active participation in Systems Team meetings for development on cadence with different functions: Dev-ops, QA, IT, Dev, PM’s, SM’s, App Dev Managers, PTLs etc.

Worked with Business Analysts, System Analysts, Architects and Tech lead to have elaborated discussion on Architectural Runways and finalizing Spikes

Generated Reports from Rally - Program, Iteration, Dependencies and Velocity etc.

Worked in an agile scrum environment and trained the team during transition from Waterfall to Agile by conducting workshops.

Experienced with various scrum Estimation techniques like Bucket System, T-shirt Sizing and Prioritization techniques. Walking Skeleton and Validated Learning.

Experienced with writing user stories and splitting user stories using various strategies.

Managed the resolution of issues that may not have an established precedence.

Strong in the complete Software Development Life Cycle (SDLC) including requirements definition, design, programming / testing and implementation of major systems.

Expertise in writing Business Requirements Document (BRD), Functional Specification Document (FSD), Non-Functional Specification Document, System Design Specification, Use Cases, and training manuals.

Experience in Database Analysis/Design/Normalization/Manipulation processes using SQL Server 2000/2005/2008/2010/2012.

Worked experience on the source control software packages like Microsoft Visual Source Safe (VSS) and Team foundation Server (TFS).

Experience performing Unit and Integration Testing in the Development, System Integration Testing (SIT), User Acceptance Testing (UAT) including Bug Reporting and Fixing.

Proficient in HP-ALM to create the test sessions, Write test cases, test scripts and execute system testing and prepare the defect reports

Successful work experience working for large systems at Cigna Health Care and Barclay Credit Cards US.

Excellent communication skills, strong organization and interpersonal skills and a very good team player, capable of working independently with minimal supervision, and perform as part of a team.

Educational Qualification:

Bachelor of Technology (B.Tech), JNTU, INDIA

Certifications:

SAFe 4.0 Scrum Master Certification

Technical skills:

Languages : C#, Visual Basic, SQL, PL/SQL.

Web Technologies : XML, IIS 6.0/7.0,HTML, XHTML, CSS.

Databases : SQL Server, MySQL, PL/SQL, Oracle 11g, MS Access 2000/97.

Operating Systems : Windows NT/95/98/2000/2003/2008 and UNIX, MS-DOS, Win 2k3 servers, XP, Windows 7.

Reports : Crystal Reports 10.0, SQL Server Reporting Services.

Platforms : Windows 9x, 2000/2003/2008, Windows XP, Windows NT, Vista

Source Control : Team Foundation Server (TFS), Visual Source Safe (VSS)

Network Protocols : TCP/IP, HTTP, FTP, SMTP, SOAP, UDDI.

SDLC/Design Methodologies: Unified Modeling Language (UML), RUP, Agile, RAD and Waterfall

Professional Experience

Client: Cigna HealthCare, Bloomfield, CT Nov 14 - Till Date

Role: Scrum Master/Tech Lead

Project: Informatics Management.

Responsibilities:

Scrum Master for 2 teams in Agile Release Trains to Release on Demand and Develop on Cadence

Managed multiple Scrum Ceremonies, Sprint Planning, Sprint Refinements, Sprint Reviews, Sprint Retrospection, Daily stand ups.

Championed agile concepts & methodologies outside of the software development teams, leading to the adoption of Agile.

Led and coached Product Owners to improve story writing & requirements gathering process, leading to an increase in customer.

Managed full SDLC, from ideation, to discovery, to execution, then to deployment.

Facilitated Scrum ceremonies such backlog grooming, cross team meetings, retrospectives, etc.

Attended Scrum of Scrum meetings to facilitate the cross teams whenever needed.

Leading and managing onshore and offshore resource pool of 30 plus resources.

Implementing Agile and Scrum practices for onshore and offshore teams.

Making business plans for the application development practice for revenue growth.

Mentoring and supervising the teams for technical growth.

Involved in gathering functional requirements, writing design specifications, prototype and architecting the new application using SOA and Agile.

Coordinated the build/migration of releases to test and production environments.

Troubleshot the application in Staging and Production environment.

Analyzed C# code to support BAT testing to co-ordinate releases.

Preparing Test and mock-up data for complex business requirements to make developers understand.

Participated in System Documentation, Technical Design Documentation and Code Documentation.

Involved in customized tool called Turbo Debugger to interact with pricing engines.

Developed test plans with QA team and helped to develop test scenarios for system testing and performance testing.

Conducted UAT, documented and reported user feedbacks to management team, and developed training materials for different end users and assisted in User Training for the new system.

Environment: SQL Server 2010/2012, Rally, N-Unit Testing, TFS 2013, Aspose Reporting, HP-ALM, Turbo Debugger, Red Gate SQL Tools, Microsoft Visio, Microsoft Excel, Pricing Engines, Tableau.

Client: Barclaycard US, Wilmington, DE Feb 13- Oct-14 Role: Scrum Master/Senior .Net Developer

Project: Contact Center Desktop Solution.

Responsibilities:

Involved in gathering functional requirements, writing design specifications, prototype and architecting 7the new application using SOA and Agile.

Coordinated the build/migration of releases to test and production environments

Derived unit testing and contribute to the Software QA process

Troubleshot the application in production environment.

Participated in System Documentation and Code Documentation.

Identify research, analyze, define and document business processes.

Conducted interviews with project managers, SMEs business users to collect requirement and business process information.

Worked with the developers closely to magnify success scenarios of Primary and Alternate flows.

Developed PowerPoint presentations for monthly meetings with upper management.

Teamed up with the credit allocation department to perform market survey and learn client requirements to assist the technical team in Software development.

Assisted Engineers in coming up with technical documents Functional design documents.

Assist in selecting the technology for the application based on Cost-Effectiveness and Quality with an eye towards the future.

Used SharePoint for content management and document management.

Used UML to prepare Use Cases from the gathered requirements and created diagrams using Rational Rose.

Assisted in preparation of UAT test plan, Test Cases, Testing Cycle schedules, Test Scenarios and implemented them with QA team.

Worked on Jira tool to maintain the user stories

Environment: Waterfall, Agile,UML, SQL Server, MS Office, MS Project, DB2, Oracle DB,SharePoint, Jira, TFS, Ranorex Test Automation Framework.

Client: Florida Department of Economic Opportunity (DEO), Tallahassee, Florida Feb 12- Jan 13

Role: Senior .Net Developer/Agile Team Member

Project: Unemployment Framework Automated Claim & Tax Services (uFACTS)

Responsibilities:

Actively involved in SCRUM meetings discussing the implementation, integration of backlog modules considering the released version of software and best practices for solutions.

Followed AGILE software development life cycle (SDLC) methodology to achieve a highly efficient end product.

Worked with n-tier architecture involving Services Layer, Data Access Layer, and Business Layer.

Involved in development of Classes using C#.NET that incorporates both N-tier architecture and database connectivity.

Involved in Software Development Life Cycle starting from requirements gathering and performed object oriented analysis and design using UML.

Documented various attributes of the RESTful web service such as methods of exposing, URIs and description of each method. Cataloged sample requests, depicting the format of the calls from and to the web service.

Also developed modules like Claim Maintenance that are dependent on Work Flow.

Worked with Windows Presentation Foundation (WWF) tool PageFlowGUI all over the project life cycle.

Maintained artifacts such as Sprint burn down chart, Product burn down chart, list of impediments and defect logs, which in turn assist in velocity and capacity calculation for superior planning of upcoming sprints.

Responsible for decomposing EPICS into manageable user stories by applying the INVEST criteria.

Worked with the UI team verifying the completeness of Client Side Validations by developing exhaustive test cases and test scenarios and assisted in the automation of the UI testing process using tools like HP QTP.

Environment: .NET Framework 4.0, Visual studio 2010, ASP.NET, C#, Oracle 11g Express Edition, N-Unit Testing, Entity Framework, LLBLGen, Windows Application.

Client: Comcast, Westchester, PA Jun 10-Jan 12

Role: Senior .Net Developer

Project: Grand Slam Application

Responsibilities:

Coordinated release dates and fixes which go into each release.

Coordinated with QA team to get the developed features tested.

Extensively used Application and page level tracing feature of .Net to trace and debug the code.

Documented all the specifications and code for future reference.

Developed back end Database using SQL Server.

Involved in Normalization of the database and created queries to interact with the database.

Analyzing and reviewing the business requirements, design document, use cases and functional requirements document.

Actively Participated in Team Meetings, frequently communicate with Business Analysts to clarify the business requirements and working with QA Team to make clear the issues.

Worked with test team and fixed the issues as part of the bug life cycle.

Managed the requirements of the business users.

Facilitated meetings with clients, stakeholders and a group of business partners to identify the needs and requirements of the new system, prioritized and organized these requirements in a systematic fashion, evaluated and compared potential solutions.

Performed Gap analysis and was involved in analysis of the technical specifications of the current system and the infrastructure needs.

Assisted in finalizing and documenting the new business processes to be followed by various verticals.

Gained proficiency in formulating effective service delivery processes for the line of business.

Synthesized User Interface and Business Process Requirements and translated it into the Business Requirement Document (BRD), to be used as input to the functional design specifications.

Worked with project teams in preparing Software requirement specifications (SRS), software design documents (SDD), user interface design.

Defined and organized the system requirements to Narrative Use Cases and Use Case Scenarios using the UML methodologies. Created Use Case Diagrams, Activity Diagrams, Flow Diagrams in MS Visio and created Wire frame Diagrams.

Developed supporting documentation including business and technical requirements.

Collaborated with development teams to come up with working business solutions.

Involved in drafting functional specifications, user and operations manuals.

Participated in Functional Audit and User Acceptance testing.

Carried out UAT by developing test plans, test scenarios, test cases, test data to be used in testing based on business and user requirements.

Wrote SQL Queries and Functions to validate all possible business rules.

Imparted training to the end business users on the new enhancements/application.

Supported the change management process by way of formal and informal presentations.

Environment: Windows 2003/2007 Server, SQL Server 2008, TFS, Windows 2000/XP, Unix, MS Office, MS Project, MS Visio, MS Project, SQL, HTML, Load Runner.

Client: Visual Soft Technologies, India May 09 – May 10

Role: Analyst/Programmer.

Responsibilities:

Designed the entire application flow for eTool through WEB FORM.

Analyzed, Designed and coded the modules using C#.

Design & develop web from using ASP.NET

CMS (Content Management System ) ensure update site instantly and securely

Develop stored procedure for SQL Server 2000 database.

Created web custom controls and web user controls where necessary.

Extensively used ADO.NET objects for data retrieval and database updates.

Environment: C#, Microsoft Visual Studio, ASP.NET, ADO.NET, HTML, CSS, Microsoft SQL Server 2000, Content Management System

Contact this candidate