Software Tester/ .net Consultant Resume
Charlotte, NC
SUMMARY
- 10 years of IT experience in all phases of Software Development Life Cycle (SDLC) such as planning, analysis, design, implementation, testing and maintenance of Web Based in domains like Bank, Healthcare, Education, Retail and Cable.
- Experience in programming skills coupled with experience of designing and developing software applications with the C#(3.0/2.0), .NET Framework (3.5/3.0/2.0/1. x), ASP.NET(3.5/3.0/2.0), ADO.NET, AJAX, LINQ, CSS, Web Services.
- Software Quality Assurance Testing experience with excellent understanding of Software Development Life Cycle (SDLC) with emphasis on Black Box, Functional, System, Ad - hoc, Smoke, Regression and User Acceptance Testing, Web and Client Server applications and Analysis, Design, Coding in ASP.Net technology.
- Experience in Agile software development methodology and Test driven development including SCRUM Framework
- Hands on experience in design using Object Oriented Programming Principles like Encapsulation, Inheritance, Polymorphism, Abstraction and Design patterns like Abstract factory, MVC.
- Designed Presentation Tier (web pages) using the concepts such as Master Pages, Themes, HTML, XML, CSS, Java Script, jQuery and also Worked With ASP.NET Custom Controls.
- Worked extensively with ADO.NET objects such as Data Adapter, Dataset, and Data Reader to interact with databases like SQL Server 2008/2005/2000 .
- Worked in database related work primarily creating complex stored procedure, Views, Triggers, Functions, Schemas using PL/SQL, and SQL.
- Experienced in Configuration Management, build schedule using Team Foundation Server 2010/2008.
- Experience in deploying, configuring and maintaining the web sites and services on IIS 7.0.
- Extensive working experience in unit testing framework - Integration Testing, MS Unit Tests.
- Expertise in designing and maintaining detailed Test Scope, Test Plans/Strategy and Test Cases.
- Expertise in thoroughly validating the back end database systems by writing complex SQL queries.
- Very good experience in testing Reports using Business Objects by validating it against the back end data.
- Experience in coordinating test teams, test deliverables, status report to management and also in coordinating onsite and offshore teams to perform the testing activities.
- Experience in analysing business requirements, ensuring that the requirements are correct and complete and using the same in preparing use cases
- Experience on Agile methodology
- Experience on version control tools like TFS and VSS
- Recognised for taking initiatives, good analytical skills, quick learner, excellent communication skills, co-ordination capabilities, hard work and dedication in various projects.
TECHNICAL SKILLS
Operating Systems: Windows, Unix
Programming Languages: Asp.net C#, VB.Net with C#, HTML, T-SQL, Ruby with water.
UI Technologies: Winforms
Databases: MSSQL SERVER 2008/2005/2000 , MSAcces 2010/2007/2003 & Netezza
Database Tools: SQL Server Management Studio, Winsql, SQL Developer for Oracle
Defect Tracking Tools: HP Quality Center
Internet Technologies: JavaScript, AJAX, CSS, HTML
Automation Tool: Testwise(IDE)
Testing Application: CSG, AMDOCS, ENTITLE MANAGER
STB - Video Testing: CHIMPS
PROFESSIONAL EXPERIENCE
Confidential - Charlotte, NC
Software Tester/ .Net Consultant
Responsibilities:
- Attended Quality review meetings of the Requirements.
- Production support team lead and onsite coordinator.
- Production migration for new deployment and monitoring the tidal jobs.
- Involved in the requirements collection and functional specification preparation for Migration automation.
- Designed and developed an integrated n-tier web application using C#, ASP.NET and ADO.NET.
- Conducting pre-release, release meeting. Meeting with client to discussion production details for new changes.
- Closely working with Business Analysts, Data Modeler, Developers and Delivery Leads.
- Occasionally work with the Business (SME) directly in order to Analyze and understand the Business process.
- If any production issue occurred working on agile methodology to help the developers fix the defect faster in order to meet the deadlines.
- Validating the Target data against the Source data as per the Business logics and rules.
- Extensively using HPQC for Defect Tracking purposes
- Writing Complex SQL queries to validate the data against the technical documents.
- Working mainly on SQL Server databases and working in netezza.
- Highly involving in creating job long run analysis and handling failures.
- Migrate for new requirement/changes in to production.
- Working with Tidal for production job monitoring.
- Involved in working with the Development team and Business users to clarify requirementsas needed and to ascertain level of effort and feasibility.
- Actively involved in Daily stand-upmeetings with Project Manager and team to discuss theupdates/issues.
- Reviewed and Analyzed BusinessRequirement Documents, Project Plans and FunctionalSpecification.
- Attended Use Case Review and DesignReview Meetings.
- Logged the Defects in QC with appropriate Severity and Priority and Conducted DefectMeetings and Team Status Meetings providing testingupdates.
- Attended Change Control Meeting forapproval of change requests and raised testing concerns.
- Provided daily inputs to the ProjectManager on the testing schedule and its time frame.
- Inserted Check Points to check thebroken Links, Text, and standard properties of an objectusing Prod fix.
- Validated the Columns, Data completeness for Data Migration by using SQL Queries.
- Created and Maintained TraceabilityMatrix to ensure test coverage of all requirements.
- Ensured testing schedules are metduring different iterations to ensure a timely release toproduction.
- Develop the Test Scripts forRegression build based on theenhancements to theapplication
- Identified, Reported and TrackedDefects in Quality Center. Created and Updated Test ExecutionMatrix and Defect Matrix.
- Provided regular status updates toProject Manager on high priority issues.
- Coordinated with the Reporting team tomake sure that required data is displayed in reports.
Environment: & Tools:ETL, SQL, Oracle, QualityCentre, Confidential Visio, Confidential Project, Toad for Oracle, Visual Studio 2008,Putty & IBM netezza server. For automation -Ms - Visual studio .Net (MVC), Sql server 2005
Confidential
Software Tester/ .Net Consultant
Responsibilities:
- Involved in working with the Development team and Business users to clarify requirementsas needed and to ascertain level of effort and feasibility.
- Actively involved in Daily stand-upmeetings with Project Manager and team to discuss theupdates/issues.
- Reviewed and Analyzed BusinessRequirement Documents, Project Plans and FunctionalSpecification.
- Attended Use Case Review and DesignReview Meetings.
- Logged the Defects in QC with appropriate Severity and Priority and Conducted DefectMeetings and Team Status Meetings providing testingupdates.
- Attended Change Control Meeting forapproval of change requests and raised testing concerns.
- Provided daily inputs to the ProjectManager on the testing schedule and its time frame.
- Created Test Scripts from use casesand Requirements Documents
- Perform Smoke Test before moving thecode to a Stable QA environment.
- Inserted Check Points to check thebroken Links, Text, and standard properties of an objectusing Quick Test Pro.
- Performed GUI, Functionality and Regression Testing in QTP.
- Performed data driven testing usingQuick Test Pro.
- Executed Test Scripts for Functionality Testing and reported defects in QualityCenter.
- Validated the Columns, Data completeness for Data Migration by using SQL Queries.
- Created and Maintained TraceabilityMatrix to ensure test coverage of all requirements.
- Ensured testing schedules are metduring different iterations to ensure a timely release toproduction
- Develop the Test Scripts forRegression build based on theenhancements to theapplication
- Identified, Reported and TrackedDefects in Quality Center. Created and Updated Test ExecutionMatrix and Defect Matrix.
- Provided regular status updates toProject Manager on high priority issues and TestingProgress.
- Coordinated with the Reporting team tomake sure that required data is displayed in reports.
- Leading the ASG team (4 Members)& Regression test execution as part of manual testing for this project that is being executed in Agile.
- Tested the STB - Video testing using CHIMPS.
- Tested the AMDOCS, CSG - Billing system.
- Worked with Tittle ingestion using Tittle ingestion tool
- Developing the automation tool using Ruby script& Client interaction for defect discussion and new release discussion.
- Attended Quality review meetings of the Requirements.
- Extensively using HPQC for Defect Tracking purposes
- Validating the Target data against the Source data as per the Business logics and rules.
Environment: Windows 7, Client environment (VPN), CHIMPS, Putty
Confidential
QA Technology Analyst/ .Net
Responsibilities:
- Involved in the requirements collection and functional specification preparation.
- Designed and developed an integrated n-tier web application using C#, ASP.NET and ADO.NET.
- Designed and developed Data Access layer, Business layer and Presentation Layer (user interface).
- Responsible for designing the ASP.NET application using .NET Framework.
- Designed and developed effective web forms based on technical design and requirement specifications.
- Managed and customized functionality, design, content, security, and membership options.
- Involving in handling ASP.NET client side state management (view state, cookies and query strings) and server side state management (application state, session state and profile properties)
- Effectively handledASP.NET caching techniquessuch aspage output caching and data cachingin order to improve the performance of the web application.
- Developed Base Pages, Master Pages, Key web pages, Business Entities,Business Components, stored procedures.
- Incorporated many rich, user friendly, responsive features in the application using .Net framework, ASP.NET AJAX Control toolkit, CSS and JavaScript to give better performance and richness to the user interface.
- Extensively involved in using UML in the design process - Use cases, Process diagrams, Sequence diagrams, Class diagrams. Prepared detailed design document for the application.
- Responsible for writing secure code and in implementation of Code Access Security, CAS implemented for the assemblies which access system resources like Event Logs, SQL services and Registries.
- Created reusable user controls and implemented object caching in different pages in ASP.NET.
- Created stored procedures, functions, triggers and packages in T-SQL for backend communication.
- Used Sql Server Integration Services (SSIS) for extraction transformation and loading data.
- Extensively used crystal reports for generating reports populated by data in databases.
- Involved in unit-testing web applications and in Test Driven Developement (TDD).
- Used Team Foundation Server (TFS) for version controlling and assisted in documentation and creating
Environment: Ms - Visual studio .Net, Sql server 2005, Windows 7
Confidential
QA Technology Analyst/ .Net
Responsibilities:
- Managing the entire life Cycle of the product following processes like Schedule, Tracking, Monitoring, QA, etc
- Responsible for the design and development of ASP.NET web pages
- Part of the development & integration testing for this project that is being executed in Agile.
- Extensively used ADO.NET objects to communicate with SQL Server 2000 database
- Experience in Test Driven Development - TDD Methodologies using Visual Studio 2008/2005 Test System and Nunit/MS-Test.
- Code Review, Performance Analysis.
- Designing/Creating the Product Database.
- Working on SQL Server databases and provided Support end to end testing activities.
Environment: Ms - Visual studio .Net (MVC), Sql server 2005, Windows 7
Confidential
QA Technology Analyst
Responsibilities:
- Followed Agile methodology, reported status to scrum master on daily basis, attended daily basis scrum meeting, planning of QA in sprint planning meeting.
- Worked closely with developers and data warehouse team.
- Prepared Test data of every story before started testing.
- Worked on snowflake schema and followed Kimball approach.
- Developed Test Cases ETL Data Validation, Cube Testing and Report testing.
- Tested whole data warehouse when migrating from sql server2005 to sql server 2008
- Test planning of QA before whole rebuilt.
- Tested all the areas of company involved for data warehouse like lotto, games, search and win, member identity, coreg, direct track, entries, survey.
- Worked as ETL Tester responsible for the requirements / ETL Analysis, ETL Testing and designing of the flow and the logic for the Data warehouse project.
- Prepared test strategy for testing each user story.
- Tested source files, source testing, staging testing, dimension testing, fact testing, incremental testing.
- Experienced in writing complex SQL queries for extracting data from multiple tables.
- Reported bugs to the developer and maintained in Quality center and version one.
- Wrote SQL queries to validate source data versus data in the data warehouse including identification of duplicate records.
- Experienced in writing test cases, test scripts, test plans and execution of test cases reporting and documenting the test results using Mercury Quality Center
- Developed ETL Test Plan and Test Strategies for the entire Line of businesses.
- Extensively used SQL queries for Database testing and Validation.
- Involved in extensive backend testing.
- Gathered requirements from system architect, developers, and business people.
- Debugging the SQL-Statements and stored procedures
- Tested the database to check field size validation, check constraints, stored procedures and cross verifying the field size defined within the application with metadata.
- Developed regression test scripts for the application
- Tested the data and data integrity among various sources and targets
- Extensively using HPQC for Defect Tracking purposes
- Provided Support end to end testing activities
Environment: SSIS, SSRS 2008, Ms - Visual studio .Net, Windows7, HP QC, MS Access, MS Excel, MS PowerPoint
Confidential
Senior software engineer
Responsibilities:
- Part of the development & integration testing.
- Requirement gathering from client.
- Task splitting and managing the team.
- Production Migration and Handling the deliverables as well.
Environment: Ms - Visual studio .Net, Sql server 2005, Windows XP
Confidential
Senior software engineer
Responsibilities:
- Designed the application with UI in the presentation layer, Business logic in the middle layer and Database activity in the Data Access layer.
- Developed and designed Web forms in ASP.NET
- Implemented business logic into C#.NET
- Developed and used ADO.NET objects for handling database activities.
- Developed SQL stored procedures for data manipulation and querying data using SQL Server
- Developed and used JavaScript for Client side validation
- Developed and used Ajax for calling serverside objects from client side
- Weekly status report to client and status call
Environment: Ms - Visual studio .Net, Sql server 2005, Windows XP
Confidential
Responsibilities:
- Designed the application with UI in the presentation layer, Business logic in the middle layer and Database activity in the Data Access layer.
- Developed and designed Web forms in ASP.NET
- Implemented business logic into C#.NET
- Developed and used ADO.NET objects for handling database activities.
- Developed SQL stored procedures for data manipulation and querying data using SQL Server
- Developed and used JavaScript for Client side validation
- Developed and used Ajax for calling serverside objects from client side
- Weekly status report to client and status call
Environment: Ms - Visual studio .Net, Sql server 2005, Windows XP
Confidential
Responsibilities:
- Designed the application with UI in the presentation layer, Business logic in the middle layer and Database activity in the Data Access layer.
- Developed and designed Web forms in ASP.NET
- Implemented business logic into C#.NET
- Developed and used ADO.NET objects for handling database activities.
- Developed SQL stored procedures for data manipulation and querying data using SQL Server
- Developed and used JavaScript for Client side validation
- Developed and used Ajax for calling serverside objects from client side
- Weekly status report to client and status call
Environment: Ms - Visual studio .Net, Sql server 2005, Windows XP
Confidential
Responsibilities:
- Designed the application with UI in the presentation layer, Business logic in the middle layer and Database activity in the Data Access layer.
- Developed and designed Web forms in ASP.NET
- Implemented business logic into C#.NET
- Developed and used ADO.NET objects for handling database activities.
- Developed SQL stored procedures for data manipulation and querying data using SQL Server
- Developed and used JavaScript for Client side validation
- Developed and used Ajax for calling serverside objects from client side
- Weekly status report to client and status call
Environment: Ms - Visual studio .Net, Sql server 2005, Windows 7
Confidential
Responsibilities:
- Designed the application with UI in the presentation layer, Business logic in the middle layer and Database activity in the Data Access layer.
- Developed and designed Web forms in ASP.NET
- Implemented business logic into C#.NET
- Developed and used ADO.NET objects for handling database activities.
- Developed SQL stored procedures for data manipulation and querying data using SQL Server
- Developed and used JavaScript for Client side validation
- Developed and used Ajax for calling serverside objects from client side
- Weekly status report to client and status call
Environment: Ms - Visual studio .Net, Sql server 2005, Windows XP
Confidential
Project Lead
Responsibilities:
- Designed the application with UI in the presentation layer, Business logic in the middle layer and Database activity in the Data Access layer.
- Developed and designed Web forms in ASP.NET
- Implemented business logic into C#.NET
- Developed and used ADO.NET objects for handling database activities.
- Developed SQL stored procedures for data manipulation and querying data using SQL Server
- Developed and used JavaScript for Client side validation
- Developed and used Ajax for calling serverside objects from client side
- Weekly status report to client and status call
Environment: Ms - Visual studio .Net, Sql server 2005, Windows XP
Confidential
Software Engineer
Responsibilities:
- Designed the application with UI in the presentation layer, Business logic in the middle layer and Database activity in the Data Access layer.
- Developed and designed Web forms in ASP.NET
- Implemented business logic into C#.NET
- Developed and used ADO.NET objects for handling database activities.
- Developed SQL stored procedures for data manipulation and querying data using SQL Server
- Developed and used JavaScript for Client side validation
- Developed and used Ajax for calling serverside objects from client side
- Weekly status report to client and status call
Environment: Ms - Visual studio .Net, Sql server 2005, Windows XP