PROFESSIONAL SUMMARY:

• Over 12+ years of profound IT experience, involved in Mobile Testing, web testing, ETL testing and development.
• Around 5 Years of Experience in mobile app testing with Android, IOS, Windows, Linux platforms and Chrome OS.
• Good working Experience in Mobile Testing, Database testing, System Testing, Integration testing, and back end testing and End to End Testing.
• Strong experience in different life cycle of Project Management methodologies such as Waterfall and Agile Methodologies.
• Strong Agile Scrum Experience; Planning Meeting, Daily Stand up meetings, Demo meetings, Burn Down Charts, User Story Estimation, Capacity Planning.
• Extensive experience in preparing Test Plans, Test Scenarios, Test Cases, Test Reports and Test Documentation for both manual and automated tests.
• Involved in different testing like Smoke Testing, Static Testing, Functional Testing, Compatibility Testing, GUI Testing, UA Testing, Automated testing and Regression Testing.
• Expertise in Agile Project Lifecycle, software development life cycle process (SDLC) including Requirement Gathering, Business Analysis, and testing.
• Expertise in Test management and Defect Tracking Tools like JIRA, DEV OPS, TFS and Enterprise Tester .
• Knowledge in Analysis of Defect severity, Defect tracking System and Defect reporting.
• Worked on Web Services Testing
• Worked on Test Automation Tools such as Selenium and APPIUM
• Good exposure to SQL queries written in MS SQL server and Oracle.
• Expertise with DDL and DML statements. DDL scripts to Create database schema and database objects.
• Involved in backend testing by writing and executing SQL queries.
• Strong knowledge of all phases of Software Development Life Cycle & Software Testing Life Cycle from Test planning to defect Tracking and managing Defect Life cycle.
• Contributes to Team effort by Accomplishing related results as needed.
• Motivated team player with strong Interpersonal skills, excellent communication and writing skills capable of handling multiple tasks and responsibilities at the same time.

TECHNICAL SKILLS:

Browsers: Internet Explorer, Firefox, Chrome, Safari

Mobile Devices: Power user of all generations of iPhone, iPad, tablet, Google and Android mobile devices.

Mobile Applications: Experienced with native apps, web apps and Hybrid apps on multiple devices and platforms

Android specific: Installing APK’s, Simulators and Emulators

Bug Tracking: JIRA, TFS, DEV OPS

Test Management: TFS, JIRA, DEV OPS, Enterprise Tester

Applications: Excel, Word, PowerPoint, Outlook, e - commerce, google docs, mobile applications

Cloud Platforms: Perfecto Mobile, Browser Stack

PROFESSIONAL EXPERIENCE:

Confidential, PITTSBURGH

Mobile Testing Lead

Database: Oracle SQL

Tools: Used: Microsoft Foundation Server, VSTS

Responsibilities:

• Lead User Acceptance Test efforts; coordinate with business users to secure resources, outline testing plan, and manage test effort thru signoff.
• Develop and provide testing metrics and reports for the QA dashboard to effectively communicate test status to the test team and management.
• Derived Testable requirements by analyzing Business and Functional documents for various features of the site. Involved in Cross-browser (MSIE, Firefox, Chrome, Safari) and cross-platform (Windows 7/XP/Mac OS X)
• Responsible for UI and END-END ordering functionality testing on iPhone, iPad, Android, Google pixel and Tablets.
• Created test specification and test plans by reviewing business and technical documentation.
• Modification of existing Test Plans and Test Scripts for android testing.
• Involved in End to End testing of Emerging Business markets, Sanity/Shakeout testing using various applications according to the user stories
• Involved in regression testing, UAT defect testing
• Consistent monitoring & review of test deliverables.
• Coordinating with development & business teams during integration/system & UAT testing.
• Coordinating with Center of Excellence teams based on non-functional testing needs & support.
• Identify all testing risks & recommend feasible initiatives to mitigate/control the known-possible risks.
• Prepare UAT Test Plans and Test Scenarios.
• QA Status reporting, Issue log monitoring & defect workflow management.
• Identifying areas of challenges/risks & suggesting feasible process initiatives & tooling ideas to reduce the impact of testing risk/challenges.
• Ensuring that defect prevention and final inspection activities are carried out for the test deliverables on a consistent basis.

Confidential, PITTSBURGH

Mobile Testing Lead

Database: Oracle SQL

Tools: Used: Enterprise Tester, JavaScript, SSIS, Control+M, JIRA

Responsibilities:

• Understanding functional Requirements and writing Test scripts in Enterprise Tester.
• Regression Testing, UAT defect testing
• Consistent monitoring & review of test deliverables.
• Test strategy/plan preparation & Test case review.
• Derive testing estimates & deliverable planning.
• Coordinating with QA team, development & business teams during integration/system & UAT testing.
• Worked extensively on SQL in validating data.
• Implemented scripting & execution Sanity, Regression, Stress & Boundary test cases for mobile applications on Android, Google Pixel, iPhones & iPads
• Cross-browser (MSIE, Firefox, Chrome, Safari) and cross-platform (Windows 7/XP/Mac OS X)
• Responsible for UI and END-END ordering functionality testing on iPhone 3G, iPhone 3GS, iPhone 4G, iPad, Android and Tablets.
• Coordinating with Center of Excellence teams based on non-functional testing needs & support.
• Identify all testing risks & recommend feasible initiatives to mitigate/control the known-possible risks.
• QA Status reporting, Issue log monitoring & defect workflow management.
• Identifying areas of challenges/risks & suggesting feasible process initiatives & tooling ideas to reduce the impact of testing risk/challenges.
• Ensuring that defect prevention and final inspection activities are carried out for the test deliverable on a consistent basis

Confidential, PITTSBURGH

TESTING LEAD

Database: Microsoft SQL Server 2012

Tools: Used: SSIS, selenium, C#, BizTalk, UC4, TFS

Responsibilities:

• Resource Planning & Effective resource utilization across testing efforts.
• Consistent monitoring & review of test deliverables.
• Test strategy/plan preparation & Test case review
• Derive testing estimates & deliverable planning.
• Involved in mapping document preparation
• Involved in integration testing from source system to downstream system
• Coordinating with QA team, development & business teams during integration/system & UAT testing.
• Coordinating with Center of Excellence teams based on non-functional testing needs & support.
• Identify all testing risks & recommend feasible initiatives to mitigate/control the known-possible risks.
• QA Status reporting, Issue log monitoring & defect workflow management.
• Identifying areas of challenges/risks & suggesting feasible process initiatives & tooling ideas to reduce the impact of testing risk/challenges.

Confidential, BIRMINGHAM

TECH LEAD

Database: Microsoft SQL Server 2012

Tools: Used: SSIS, BIxPress, Control+M

Responsibilities:

• Involved in all the stages of Software Development Life Cycle (SDLC)
• Worked on table creation for each stages - Landing, Staging and Domain area tables
• Worked on index creation for the tables
• Created complex Confidential -SQL queries using Joins, Functions, Views, CTE and Sub- Queries.
• Improved Performance of the Confidential -SQL queries, Stored Procedures and Views
• Involved in Stored Procedure creation and modification of Stores Procedures and Views.
• Created Views to build logic for the SSIS packages
• Generated deployment scripts to move the code to QA and PROD.
• Prepared to move all SSIS packages to QA/PROD environment
• Responsible for monitoring the progress of a SSIS packages and logging progress to a text file, SQL Tables and windows event log.
• Designed and created distributed reports in multiple formats such as Excel, CVS. And DAT SSIS 2012.
• Involved in SSIS package design
• Involved in SSIS ETL package Creation
• Used SSIS functionalities like for each loop container, scripting, Event Handlers, logging and auditing.
• Worked with BIxPress tool to capture the SSIS package auditing and logging information
• Identify and resolve problems encountered during both development and release of the SSIS code.
• Created master table to capture package execution status like success, failed and progress.
• Involved in Control+M job creation and scheduling the SSIS Jobs
• Involved in Requirement gathering with customer
• Involved in coordination activities with team including mail communication, offshore calls
• Involved in Data Analysis work
• Involved in documentation related with project

Confidential

Sr. ETL and Reporting Developer

Database: Microsoft SQL Server 2012

Tools: Used: SSIS, SSRS 2012

Responsibilities:

• Involved in requirement gathering and analysis phase
• Involved in debug the SQL queries and fine tuning the SQL Performance
• Created complex Stored procedures to populate data to the dimension table and Fact table
• Created Complex SSRS Reports and calling Stored Procedure through SSRS and applied filter condition against Stored Procedure by passing parameters.
• Involved in SSIS package deployments and to migrate all the DB Objects to QA and PROD server
• Identify and resolve problems encountered during both development and release of the SSIS code.
• Involved in review and defect fixes.
• Involved in SSIS ETL package Creation

Confidential, Raleigh

Sr. ETL and Reporting Developer

Database: Microsoft SQL Server 2008, IBM DB2

Tools: Used: SSIS, SSRS

Responsibilities:

• Involved in Requirement gathering and analysis
• Involved in ETL Design document
• Involved in ETL package creation
• Created complex SQL queries to build SSIS package creation
• Worked on Confidential -SQLs to access data from IBM DB2
• Responsible for monitoring the progress of a SSIS packages and logging progress to a text file, SQL Tables and windows event log.
• Identify and resolve problems encountered during both development and release of the SSIS code.
• Developed drill down and drill through reports from IBM DB2 using SSRS.
• Deployed the SSRS reports to the reports server and configured with IBM DB 2 data base, so that business user can access through Report Server URL.
• Worked with support team for the SSIS package deployments and DB Objects to move QA/PROD.
• Involved in defect fix and code review
• Involved in ETL Testing
• Involved in Test Case Preparation

Confidential

Sr. ETL Developer

Database: Microsoft SQL Server 2008

Tools: Used: SSIS, Informatica

Methodology: SDLC

Responsibilities:

• Worked in all design documents for the SSIS package development
• Involved in SSIS design changes discussion with Client
• Designed and created SSIS Packages
• Used SSIS features like For Each Loop containers, Package Parameter, Event Handlers, and Script Component and add to the external dll into the script.
• Deployed all the project related SSIS packages to the SQL server
• Identify and resolve problems encountered during both development and release of the SSIS code.
• Created SSIS package to FTP the multiple files from one server to another server using FTP task.

Confidential

Cube Developer

Database: Netezza 6.0.11

Tools: Used: SQL SERVER 2008 Analysis services, BODI XI 3.1

Methodology: Agile

Responsibilities:

• Gathered and clarified the functional requirements from Team and Business by referring to low level design documents and designed High Level Requirement Document.
• Involved in Cube design Document.
• Involved in Cube Development
• Involved in BODI ETL development and created Confidential -SQL queries to extract the data from Netezza database
• Involved in Testing and Test Case Preparation

Confidential

Reports Developer

Database: SQL Server

Tools: Used: SQL SERVER 2008 Reporting Services

Methodology: SDLC

Responsibilities:

• Gathered and clarified the functional requirements from Team and Business by referring to low level design documents and designed High Level Requirement Document.
• Extensively involved in creating complex stored procedures, views to extract data for the SSRS reports (SQL Server 2005) (SQL Server 2008).
• Wrote multiple view to generate SSRS reports
• Responsible for scheduling the subscription reports with the Subscription report wizard.
• Created SSRS reports by calling Views and Stored Procedure
• Created Complex SSRS reports, drill reports by passing parameters from reports server
• Deployed reports to the report server and configured with SQL database