SUMMARY:

• 12+ Years of overall Experience in Design, Development and testing of the enterprise level applications in IT with 11 years of SQL Database Development experience.
• Currently, working as a Consultant (QA Lead) at Intelligent Insites' in Health Care Domain since JUL 2016.
• 1.3 Years as Consultant (Senior Database Developer) in ‘University of Washington Medicine’.
• 4.2 Years as Full Time Employee in Confidential IT in Finance and HR domains in areas of Forecasting, budgeting, Procurement, Account payables & international Payroll systems.
• 6.2 Years as Full Time Employee in Confidential with Client as Confidential and associated with 6 Confidential Projects.
• Performed roles as SQL Developer, Software Development Engineer in Test (SDET).
• Extensively worked on Projects using Agile, Waterfall Software Development Methodologies and ‘TSP-PSP’ Software process.
• Extensive Experience as an SDET and in creating Test strategy, Test Plan, Use Cases, Test Scenarios, Persona, Test Plan, Test Cases and Test Automation.
• Experience in testing the performance of client/server applications developed using Confidential technologies.
• Comprehensive experience in coordinating projects requiring interaction with client/user to gather the user requirements and Onsite/Offshore model.
• Enthusiastic, hardworking, self-starter, eager to meet challenges and quickly assimilate latest technologies, concepts and ideas.
• Excellent analytical, written, communication skills, ability to work independently and highly motivated with strong work ethics and earned reputation for quality deliverables.

TECHNICAL SKILLS:

Operating System: Windows 8.1/8/7/Vista/XP, Windows Server 2012/2008 R2

Languages: C#, C, C++, Java, T-SQL,XML,HTML5

Front End: .NET, ASP.Net, Coded UI Framework, Excel VB Macro, Selenium Web Driver Framework, Panorama Necto, Pentaho BI

DBMS: MS SQL Server 2012/2008/2005/2000, SSIS, Familiarity with Big Data & Data ScienceTools: Visual Studio Team System 2013/2012/2010, Confidential Test Manager 2013/2012, MS Office 2013/2010, Sincera (Data Migration Testing Tool), Fiddler & Nexpert (Performance Testing Tools), NEWT (Latency Testing Tool - Performance), VSTS Web/Load Test, JIRA, AccuRev, Jenkins

PROFESSIONAL EXPERIENCE:

Confidential

QA Lead

Responsibilities:

• Lead the QA Team in providing high Quality deliverables in the application that helps Health-Care Industry to track usage of Patient, Staff, Equipment, Supplies, Location and generate messages, alerts, notification and reports that helps to save time, effort and cost.
• Guided Offshore Team in SQL Automation. Prepared Stored Procedures and SQL Scripts for Functional Test Validation.
• Creation/Review/Inspection/Execution of Test Cases, REST API Calls, Test Data in Sprint release.

Confidential

Senior Database Developer

Responsibilities:

• Design and Development of a new system in on-boarding multiple ACN Accountable Care Network with several Health Care Member Organization containing Provider (Doctors...) & Facility (Hospital, Clinics...) data into University Of Washington (UW) Portal & for sending data for Boeing Member Portal.
• Designed the Data Model with Normalized Database completely from the beginning for this system analyzing all the Business Requirements and scenarios
• Developed the code via SQL for the back-end and created SSIS Packages considering the scalability and Performance of the system.
• Developed Exception Reports with all possible validations from Facility & Provider Working Files for Member Organizations to ease their work.
• Handled Transformations of the Input Facility & Provider Working Files very efficiently to track changes of the data every month by applying all the complex Business Logic and Rules.
• Generated various Metrics out of the data for the management to make better decisions and for comparison of data in any given month.
• Generated Various Reports after transformations in less than 5 seconds (which was 4-5 hours in the old system)

Confidential

SDET

Responsibilities:

• Contributed towards Validating Business Rules by creating SQL Scripts for validating Business Rules, Design & Develop Normalized Test Database, create Stored Procedures, Functions for Automation (Coded UI Framework), Performance Testing, Environment Management, and Application Compatibility for one Platform supporting all Planning, Forecasting & Budgeting needs with real-time operational reporting.

Confidential

Test Lead & SDET

Responsibilities:

• Lead the team and contributed towards Functional Testing, creating SQL Scripts for validating Business Rules, Design & Develop Normalized Test Database, create Stored Procedures, Functions for .Net Coded UI Automation, Performance & Latency Testing, Environment Management, Application Compatibility for the application that does pay-roll processing of Non-US Employees (21 Countries)

Confidential

Test Lead/ SDET

Responsibilities:

• Contributed towards Validating Business Rules by preparing SQL Scripts, Design and Develop Normalized Test Database, Create Stored Procedures, Functions for Automation, Performance/Latency/Load Testing, Environment Management, Application Compatibility for application built using sharepoint site & AX Dynamics platform for submitting Expense Reports. Lead the VMF Project (a sub-project of Confidential ) very efficiently by incorporating all the Test Processes.
• Received 4 awards in this project - Kudos (FY12 Q1), Certificate of Appreciation (FY12 Q2), Commitment (FY12 Q3), Team Excellence (FY12 Q3)

Confidential

SDET

Responsibilities:

• Streamlined Defect Managed Process, Test Case Review/Inspection templates & contributed to Functional Testing & Automation for the tool that helps the user to find vendors and create, extend, and view purchase order requests. Received Confidential ‘Excellence’ award for contribution to Quality deliverables & Automation work.

Confidential

SDET

Responsibilities:

• Contributed towards analysis, conducting persona, Function Testing for system that provides a high capacity shared service built to securely store & Confidential content such as product images & large files to customers over the intranet/Internet with high integrity.

Confidential

SDET

Responsibilities:

• Apart from contributing to Function Testing, developed Performance Reports via Stored Procedures and generated reports out of it for the system that makes it easy for customers to understand their current licensed relationship with Confidential by accurately distilling and connecting all licenses purchased, across programs or agreements into a single, easy-to-read License Statement. Won Bug Bash Award

Confidential

Test Engineer

Responsibilities:

• Contributed to creation of Test plan, Functional Testing. Logged 118 bugs in a timeframe of 3 months leading to no bugs in UAT/Production (Phase Containment) for a system that designs a user interface for creating Purchase Order for GFS group.