Namrata Bansal

Over 10 years of experience as a Software Quality Analyst, developer with experience in all phases of software development life cycle, software testing life cycle using various development and testing tools in Windows, UNIX, Mainframe, Web Services and Web based applications.

Experience in Automotive Sales and Manufacturing, Health care, Gas Energy distribution sectors.

QA Specialist - Urban Science - Detroit

(2012-04 - 2016-08)

Urban Science provides solutions to OEM Clients to increase their Market share and improve profitability. I worked on various web based applications from inception like Audi DBI, Ford BMI, SSO, and MMO. OEMs share their sales data, financial data with Urban Science, which then gets standardized in our systems, and then we create KPIs and distribute them to dealers.

These KPIs help dealers compare their performance with other dealers in the same or different geographic segments. I also worked on their industry-leading lead management system ELS that acquires high-quality leads from any source, cleanses, processes and scores leads and then distribute to dealers.

• Participated in Requirement gathering meetings, reviewed BRDs and provided feedback on gaps identified.
• Reviewed BRD’s, provided test estimates and created test Plans.
• Worked closely with developers to get good understanding of application design.
• Maintained excellent understanding of databases.
• Used Test Manager as the test repository and Visual Studio for defect tracking and RTM reporting.
• Performed Security testing with different levels of access.
• Performed extensive data validation testing using SQL queries to extract data from multiple tables using joins and calculations.
• Conducted Bug Triage meetings and provided testing status to management.
• Created, executed and maintained Automation Scripts for smoke tests, feature testing, back end data validation and back-end to UI using Selenium, XML and C#.
• Tested the Spanish and French translations of the application.
• Tested several releases of the product on a very tight schedule to ensure delivery on time.
• Mentored junior testers, acted as a team lead, handled several projects at the same time.
• Created Change requests, updated requirement documents
• Environment: TFS 2012, Visual Studio 2012, Selenium, Test Manager, C#, .Net, XML, MS SQL Server

Sr QA Analyst - iPatientcare - New Jersey

(2010-09 - 2012-03)

iPatientcare is an EHR system that can be configured from solo to more than 200 physicians in practice. It keeps track of patient’s demographics, medical history, billing, appointments, lab reports, test results and allows e-prescriptions. This client server application is build using .net and Oracle.

It integrates seamlessly with third party tools like state immunizations, lab reports, pharmacy database and other hardware devices. It can be completely customized based on physicians’ requirements.

• Interacted with Business Analyst and Development team to design and plan the test plans.
• Reviewed Use cases and created test cases based on test scenarios drawn from functional requirements.
• Created test estimates.
• Used Quality Centre as the test repository and for executing the test cases, for defect tracking and requirement traceability.
• Performed UAT testing and ensured that application met the highest quality standards.
• Developed automated test scripts using QTP with features like parameterization, check points etc. for regression testing.
• Kept track of the customer bugs, decided their priority and then assigned them to the different developers.
• Supervised junior level testers while writing test cases and test execution.
• Consistently provided high quality feedback on product readiness.
• Environment: QTP, Quality Center, .NET, Oracle10g, XML, MS SQL Server, MS-Project

Sr QA/BA Specialist - TEAMS - Novi

(2009-08 - 2010-09)

Teams is a Math and Science Academy, they develop analytical thinking skills in elementary to middle school students through creative problem solving practices.

• Participated in sprint planning with development and created corresponding sprint test plans.
• Created user stories, Technical Specs, System requirements specs, User Interface specs and developed test scenarios.
• Created Test Estimation, Test Plan, Test strategy and test cases based on test scenarios drawn from the requirements.
• Performed the Positive and Negative Testing, User Interface Testing on the application.
• Performed Data Validation for the data flow from Front end to back end using SQL.
• Documented final results and summarized, identified success and problems.
• Environment: .NET, C++, MS SQL Server, Toad, MS Office, XML, Bugzilla, Workspace

Consultant (Business Intelligence) - EDS - Troy

(2000-09 - 2001-10)

Production Control &Logistics Supply chain performance metrics DW was built to support GM’s WWP/PC&L for trend analysis and decision support. PC&L DW provided single repository for information where all business data was integrated, consistent, accurate, and timely for their decision making process.

• Incorporated complex business rules during the ETL part of the process and used ETL Tool PRISM to do extraction, cleansing, manipulation and load of the data. PRISM created COBOL code was executed using JCL in mainframe MVS environment.
• History of the data was loaded in nightly batch jobs created using JCL.
• Provided the production support for the application after the release.
• Created reports using Cognos.
• Environment: MVS, TSO, ISPF, SDSF, CA-7, File-Aid, Prism, DB2, Cognos, Micro strategy, Data stage.

Systems Analyst - ANR Pipeline - Detroit

(1998-04 - 2000-09)

Gas Transaction Invoicing System: This system was created to keep track of invoices, revenue, estimates and budgets. Customer Information System: CIS supports marketing, sales, customer service, revenue forecasting and controller’s group. System contained information on customer’s daily transactions to nominate gas on the pipeline along with customer information along with contracts and tariff rates.

• Created views for easy reporting by executing stored procedures and complex join queries.
• Created Reports for business partners using Crystal Reports.
• Supported the users by responding to their requests quickly, resolved the issues related to data load, report generation.
• Collected the data from various legacy systems and consolidated at one central place, so it can be easily accessed by different departments in the company.
• Involved in the design and developed this application using Informatica, Sybase, UNIX, C and Power Designer.
• Migrated the data from existing legacy system.
• Applied business rules in the application using Informatica’s transformations and stored procedures. Stored procedures were called from the mappings.
• Created mappings to receive data from multiple sources such as flat files and relational tables and loaded into data mart after applying filtering, lookups, aggregations, sorting rules.
• Created the workflow in Workflow manager, cr
• Environment: Sybase, Rapid SQL, UNIX, C, Crystal Reports

MS - Maharishi Dayanand Saraswati University, Ajmer (India)

BS - Punjab University, Chandigarh (India)