SUMMARY:

• An accomplished hands on Software Quality Professional with an emphasis on leading System Functional Testing for numerous complex projects from planning to deployment
• 14+ years of experience in various industries including Telecommunication, Media, Manufacturing, and the Financial industry
• 11+ years of expertise in SQA in the areas of of Smoke/Sanity, Functional, System, Regression, UAT testing
• Solid track records on: - Leading Onsite and Offshore team with complex project - AGILE and Waterfall testing methodologies - Web Portal, Web and Mobile IPTV Video testing on Android and iOS platforms - Web Services API (SOA, WSDL, XML) testing using SoapUI Pro and JSon Lint
• Expert understanding on QA standard and methodologies on manual and automation testing
• Expert level understanding on AMDOCS EMSEMBLE/ENABLER billing COTS/CRM applications and its different modules such as PIC, MAF, MPS, BILLING, and A/R COLLECTIONS
• Proven communicator while managing multi years complex projects/resources
• Have strong interpersonal skill and proven track record on meeting strict deadlines
• Expert knowledge in SQL queries and have strong understanding in RDBMS concepts
• Expert knowledge on testing tools such as ALM QC, RQM, Clear Quest, Jira, Rally, SoapUI
• Adapt readily to the demands of travelling, irregular work schedules, and changing priorities

TECHNICAL SKILLS:

Languages: C, C++, XML, SQL, PL/SQL, SQL *PLUS, HTML, VB Script

Databases: Oracle 8.x/9.x/10.x/11.x, MS Access 2000, DB2

GUI: Visual J++, Visual Basic 6.0, Developer 2000, CSM, ERS, VMS

Operating Systems: UNIX (HP, Sun), and Win NT/XP/Vista/7/8, iOS, Android, AS400

Testing Tools: Win Runner, Quick Test Pro, HP Quality Centre, Rally, Clear Quest, QA Complete, Test Base, RQM, Jira, WinSCP

Web Services: SoapUI Pro, ReadyUI, XML, REST call, JSon Lint

Data Warehouse: Informatica (PC), Cognos (BI), IBM Optim

Middleware: TRIAD, Web Logic, Rabbit MQ

Modeling Skills: ER- Diagrams

WORK EXPERIENCE:

Confidential, Rowlett, TX

Entrepreneur/Program Manager

Responsibilities:

• Created a PoC approach for 12 weeks iteration
• Created workshop contents for the clients
• Conducted on site face to face meeting in Bangladesh and Kuwait
• Defined stakeholders participation for the PoC

Tools: Utilized: MS Office Suits, Rally, Jira.

Sr. Conversion Test Engineer z

Responsibilities:

• Created test suits, test cases, and test lab at ALM QC
• Created test data through CRM GUI, Web portal Sales Force as well as backend AS400 green screen
• Tested E2E functionality for converted Residential and Business customers from New Installations to Provisioning to Assigning Technician to Billing and Invoice validation
• Tested mobile devices (iOS, Android, and Windows) for Frontier Tech portal application with converted customers
• Tested Sling Box with Fiber (FiOS) videos in the Lab
• Validated backend test data through SQL queries
• Created training manuals for different applications for E2E manual testing team and BUAT team

Tools: Utilized: AS400, Teradata, DB2, Sales Force, Dynamics, Calibrus, Inet Portal, Tech Portal, ViryaNet, Triad, SQL, ALM QC 12.0.

Sr. Test Engineer

Responsibilities:

• Created requirements, test suits, and test cases in QA Complete (Testing tool like QC)
• Tested new CRs on QA, Staging, and Production environments
• Managed mobile build releases, load and tested the builds on different mobile devices
• Prioritized regression test scope and perform regression test after each deployment
• Tested IPTV VoD, TV Shows, Live TV from geo perspective
• Provided daily testing status to QA manager
• Maintained device list and ensured that all the devices were tested based on the agreed requirement

Tools: Utilized: UNIX, Test Flight, Junos Pulse, iOS (iPhone, iPad), Android (Tab and Mobile devices), Magento, MS Office.

Sr. Test Engineer

Responsibilities:

• Attended daily scrum calls and discussed roadblock or testing related issue
• Prepared test data for testing using DBF Viewer, SoapUI and JSONLint and validated Database through SQL queries
• Tested ongoing new change requests (CRs)
• Ensured cross browsers testing of DSub UI and the Reports

Tools: Utilized: SoapUI Pro, JSON Lint, EPG, Oracle JDeveloper, DBF Viewer 2000, SQL, WinSCP.

Sr. Test Engineer

Responsibilities:

• Tested different IPTV playback functionalities on TVOD, SVOD, TV Shows on various iOS and Android devices and virtual machines
• Performed vigorous regression testing after every deployment
• Tested different playback functionalities like Parental Control, Purchase/Rental PIN
• Ensured new CR functionality is tested/implemented as per release notes
• Assisted other team members with their testing when they are behind schedule

Tools: Utilized: Silverlight Player, Magento, FireBug, Oracle VM, Test Flight, iOS (iPhone, iPad), Android (Tab and Mobile devices), Rally, Jira.

Sr. Test Engineer and Off Shore Team Lead

Responsibilities:

• Led and managed India offshore QA team of 4 resources
• Designed API test flow through SoapUI script to mimic the Web app user experience from end to end account creation to purchase or rental DVD to playback
• Validated newly created customer data and playback data in the backend tables through SQL queries
• Opened defect precisely by providing root cause analysis and failures info from log files
• Worked as video streaming gatekeeper and tested Silver Light Player functionality such as Entitlements and DRM rules on both backend API calls and Player
• Ensured that video purchased/rented through API calls are streamed successfully by the Player
• Improved testing efficiency by automated SoapUI scripts to improve accuracy and reduce regression testing time
• Performed Load test using SoapUI script

Tools: Utilized: SOA, Video Media Suits, SoapUI Pro, JSONLint, SilverLight Player, FireBug, WinSCP, Unix, SQL, Rally, Jira, QA Complete, Notepad ++, Putty, Rabbit MQ, Mongo DB.

Sr. Test Engineer - Web Portal

Responsibilities:

• Joined the project as 2nd QA and started testing the portal from scratch
• Represented QA on planning and task breakdown sessions with Scrum Master, Business, and Development team prior to each iteration
• Estimate expected QA man hours per story
• Worked closely with UX designer, on site and off shore development team from Israel and Serbia and onsite environment support team to ensure that all the different 3rd party applications are functional and code deployment is on schedule in the testing environments
• Performed smoke testing, functional testing and end to end regression testing using various OS like Windows and Mac on IE, Firefox, Chrome and Safari browsers as well as mobile iOS and Android platforms
• Identified any unexpected critical issues which are putting road block to meet expected deadline and communicated to QA Manager and Project Manager
• Provided QA Sign off QA after every release

Tools: Utilized: SOA, SoapUI, QTP10, SQL, XML, iOS (iPhone, iPad), Android (Samsung Galaxy), CSM, TOAD, ERS, Ensemble, Rally.

Sr. Data Analyst and Team Lead

Responsibilities:

• Managed Field to Field (F2F) and Bill to Bill (B2B) testing for Data Migration/Conversion project
• Assigned test modules to the testers and ensure that assigned tasks are timely executed
• Moderated daily defect review calls and ensured that all the open defects are effectively communicated and assigned to appropriate owner such as Amdocs on-site, Amdocs off-site, Collator, Data Cleansing, and Translation Table group
• Created and maintained two separate defect registers. One for all defects related to migration and one for all defects related to Amdocs System Test (AST)
• Analyzed failed data through SQL queries and helped other team members with their queries
• Found root cause of the migration fails and let the developer understood what was the failed reason and where to fix it
• Opened defects, prioritized them, and assigned them to appropriate group based on the root cause analysis findings
• Created regular QA Dashboard, provided input to tasks, estimates, issues, and risk logs and daily defect count reports to the senior management for continuous project update
• Created Root Cause Analysis (RCA) process document for the data migration team

Tools: Utilized: Oracle, SQL, CSM, SGI, TOAD, Ensemble, Test Base, Clear Quest, MS Access, MS Excel.

Sr. Test Analyst e-Commerce Web Portal

Responsibilities:

• Managed multiple waterfall and agile projects for client servers and web portals
• Simultaneously worked with different web applications such as Rogers.com, Fido.ca, Sales Central portals in support of Functionality testing
• Represented eComm QA to the weekly Agile meeting and estimated the expected actual man hours with Scrum Master, Business, and Development resources for each individual project
• Tested oracle financial application OTL to ensure the required functionality
• Worked closely with database and environment support team to ensure that all the patches and updates were correctly implemented in the testing environments
• Testing English and French web portals

Tools: Utilized: Oracle, SAP, SQL, CSM, TOAD, Ensemble, Test Base, Rally, Clear Quest.

Sr. Test Analyst - System Test

Responsibilities:

• Performed end to end testing for billing functionality includes create Ban, Usage, validate usage tables through SQL queries, run Billing, generate Invoice, and validate Invoice
• Simultaneously worked with different teams in support of Functionality testing as well as Management Releases and production Trouble Ticket fixes
• Tested different AMDOCS module such as CSM, PP, MAF, MPS, and Billing
• Trained and transferred knowledge to the visiting off shore resources and ensured that they understood the testing methodology and can work independently
• Executed full testing cycle includes analyze detail design document (DDD), system specification document (SSD), prepared test plan, developed test cases, prepared test data, executed test cases, opened, retested, and closed/re-opened defects
• Validated proposed SOC/Price Plan build prior to testing and communicate with Data Management team for any issue before and during testing
• Kept tracking any valid changes which is not mentioned in the SSD and make sure the changes are correctly reflected in the PCR(s)
• Tested Fido and Rogers integration for new and existing customers.
• Communicate with AMDOCS, Rogers and Third party resources for any testing issues and ensure the issue is resolved immediately
• Performed regression testing on Rogers customers to ensure that new functionality didn’t break the existing one
• Tested different reports includes Bill Cycle Revenue, Run Verification, Process Balance, Paper Statistical, and Non-Paper Statistical Reports for business, finance, and marketing team

Tools: Utilized: UNIX, Oracle, SQL*PLUS, SQL, CSM, TOAD, ERS, Ensemble, Test Base, Rally, Clear Quest, MS Access.

Sr. Systems Test Analyst

Responsibilities:

• Used Mercury Test Director 8.0 for end to end testing for Ensemble (Knowbility) advance releases
• Created new Customers, created Usages, processed them through MAF/MPS, validated usages in the backend database through SQL to verify estimated charges, ran Billing, generated Invoices, and made sure the test results are 100% as expected
• Coordinated with AMDOCS and TELUS Mobility resources for any critical issues and ensured the concern is resolved within the strict timeline
• Implemented new Change Requests for TELUS Mobility for improve their systems and stay on top of the competitors
• Tested implementation of dealer friendly Smart Activation which will allow user/dealer to activate the customer with minimal system error that will save TELUS Mobility millions of dollars in credit adjustment due to billing error caused by CSM activation
• Maintained liaison with business, finance, and marketing team to explain testing resolutions and its impact in the production

Tools: Utilized: UNIX Shell, Oracle, SQL*PLUS, SQL, CSM, SQL Navigator, Rational Clear Quest, Ensemble, HP Quality Centre/Test Director.

Sr. QA Test Analyst

Responsibilities:

• Generating Nexxia-Mobility ensemble and non-ensemble related customer reports
• Used mercury interactive Test Director 7.6 for writing and executing test cases
• Communicated with Business Analysts and Developers to resolve any report issues and make sure the BRAC, the Mapping Document, and the CODE are in the same phase
• Tracked of WebRT Tickets for non-code related issues and Test Director Defects for code related issues for the report testing team
• Worked diligently through CSM includes make online payments, creating new BAN, modifying existing BAN, and creating e-portal user
• Ensured the reports were working 100% before released into the Production

Tools: Utilized: UNIX Shell, Oracle, SQL*PLUS, SQL, CSM, Toad, Golden, Ensemble, HP Quality Centre/Test Director, Web Focus, WebLogic.

QA Test Analyst -Team Lead

Responsibilities:

• Managed the entire test life cycle using Mercury’s Test Director 7.6 for writing requirements, test sets, test cases, and reporting defects
• Executed the test plan and trouble shoot defects while managed a strict time line
• Tested messages passed between AMDOCS and TRIAD through CDES middleware
• Worked with the environment support team to establish testing environment and resolved issues prior to and during test execution

Tools: Utilized: UNIX Shell, Oracle, SQL*PLUS, SQL, CSM, Toad, Ensemble, HP Quality Centre/Test Director, Quick Test Pro (QTP), TRIAD, Web Logic.

QA Analyst

Responsibilities:

• Coordinated Test Calendar migration executed test cases through new testing tools
• Documented test case migration errors and worked diligently with Amdocs/Cingular development team to re-write test cases as required
• Tested time-critical fixes (Emergency Change Requests, ECRs) for issues affecting the functionality of applications currently in production

Tools: Utilized: Unix Shell, Oracle, Access, SQL*PLUS, SQL, CSM, Toad, Lotus Notes, Ensemble, Test Director.

Production Support Analyst

Responsibilities:

• Successfully corrected over one million rejected customers and put them back into the billing system that helped SBC LD to generate millions of dollars of revenue
• Worked with the SBC and AMDOCS team to resolved issues related to SBC Long Distance customer database
• Responsible for developed and documented SQL, PL/SQL scripts to identified and fixed data errors in production environments
• Developed UNIX scripts to standardize business processes that saved our team approximately 40%-50% of real work time
• Provided 24/7 on call assistance to Long Distance Production support team
• Generated and distributed several daily reports to Long Distance Business team in California

Tools: Utilized: COBOL, Oracle, SQL*PLUS, SQL, PL/SQL, Unix Shell Scripting, Lotus Notes, Customer Care and Billing, DBM Tools, Win Runner, Ensemble.

Programmer Analyst

Responsibilities:

• Developed complex queries for collecting data from more than 100 tables
• Developed PL/SQL cursors, functions and procedures for system’s enhancements. Created reports in Oracle Reports by using Oracle Report Writer
• Successfully translated technical requirements to a business perspective and documented the requirements

Tools: Utilized: Oracle, SQL, PL/SQL, Forms and Reports, and Unix (HP).