SUMMARY:

• 14+ years of IT knowledge with Software development, Implementation, (Manual/Automation) Testing, Defect Management, Process Improvements, Project Lead (KPI) and Release Management (Life Cycle).
• 9+ years of experience in Billing System Testing and Quality Assurance (Lead SQA Analyst) (STLC), implementing, Leading and Testing Oracle Confidential solutions (CC&B (customer care and billing), Lodestar, Siebel) at large scale.
• Extensive Experience in ambiguity review on business/functional requirements, Design to create test plans, test cases, test scripts and test data requests. Work with the Revenue Assurance group to certify the complex projects have major revenue impacts
• Over 7 years of Experience with End to End Project Lead. Includes Experience Lead the onshore and offshore model.
• In - depth knowledge of all the phases of Software Development Life Cycle, Scrum and Agile Methodology, Waterfall and iterative methodologies including preparing Risk Analysis, Test Strategy, Test Plan, Test Cases, Test Summary Reports, Defect Tracking and Test Scripts for Manual testing, Risk Based Testing and Automation Testing.
• Proficient in planning and executing tests from large system wide tests (ST, UAT, etc.) to individual functional tests and regression tests, Unit, Functional, Integration, System, Regression, User Acceptance, GUI, Smoke Testing, Sanity Testing
• Extensively used Defect Bug tracking system with the use of tools like Quality Center, JIRA.
• Expertise in various domains including Telecom, Confidential, Confidential and E-commerce.
• Experience in Backend testing in API Testing, MS-SQL Server, Oracle, MySQL and MS-Access using SQL Queries/reports, ETL for data verification and validation.
• Good understanding of programming languages such as PL/SQL, Lodestar, VB Scripting, Java, HTML, CSS.
• Experience with SQL Server (database modeling, batch jobs)
• Extensive experience in Oracle Development in table design, writing stored procedure, Database Triggers, Functions and PL/SQL packages. Strong knowledge in Oracle Cursor management and Exception Handling.
• Highly skilled in business/function analysis, data modeling and relational database design Extensive experience in developing and supporting company-wide systems. Proven ability to work with a wide range of departments and levels of management.
• Knowledge with the project management activities by creating project summary reports, KPI reports, Staffing Report and Forecasting Reports. Managed and lead different teams over a period.
• Good written, communication, interpersonal skills, proven team player with an analytical mind bent to problem solving and delivering solutions

TECHNICAL SKILLS:

Testing Skills: SDLC and Agile Methodology, Reviews, Estimations, Test Planning, Designing of Use Cases, Designing of Test Cases, Test Case creation, Test data & Test Scenario creation, Execution of Test cases, Defect Logging & Reporting, Matrix preparation, Test Report preparation

Testing Techniques: Module Testing, Integration Testing, System Testing, Smoke Testing, Regression Testing, End to End Testing

QA Tools: (JIRA, HP-Quality Center, ALM), Selenium, ETL

Technologies: ETL (Data Warehouse), BI Reports (Power BI Tool), Crystal Reports, Visual Studio, PL/SQL, HTML, DHTML, Java Script, CSS, XML

Databases: Oracle, Lodestar, CC&B, IBM Lotus Domino, MS Access, SQL-Server.

Languages: Lodestar Script, VB Script, PLSQL, IBM Lotus Script, IBM Lotus Formulas

Configuration Management Tools: VSS (Visual Source Safe), TortoiseSVN

Project Management: KPI Reports, Staffing Reports, Project Status

Products: Lodestar, CC&B, MWM (Oracle Confidential ), Lodestar Reports, Siebel

WORK HISTORY:

QA Project Lead

Confidential, Dallas, Texas

Responsibilities:

• As a QA Project Lead, work with business and DEV Team on the requirement gathering, create test strategies, align projects and resources for the future releases. Work with RA Team to certify the Revenue impact for the Agile based projects.
• Involvement in Test Estimations and Test strategy implementation.
• Plan and Manage Critical Project deliverables (specialist in business customers) (Customer Migration from legacy billing system to the new billing system, the Billing System Enhancements, Order Process System and Bill Verification), Scrum meetings, process improvements for system. Also Manage and Execute custom support activities
• As part of scrum master role, introduced scrum principal and benefits to management and demonstrated the benefits of scrum framework such as almost real-time project status and issues.
• The Review Defect reports, Testing Status reporting, Defect Management using Jira, KPI Reports
• Design the Automation requirements, work with the team to validate the automation scripts to provide high quality ST results.
• Prepare, Review and execute manual, Billing automation and performance test strategies, test plans and test cases
• Proficient in Test Automation using UFT (Formerly QTP) and Selenium Tools. Lead the QFT to Selenium migration activities.
• Strong Experience in Automating Web Application Testing using Selenium WebDriver with TestNG framework. (Gits / TestNg / MySQL/Toad/PLSQL Developer (to access the selenium database)/eclipse (Write Test Cases)/ selenium web driver.
• Hands on test cases execution and test data generation for Confidential /Telecom Billing System.
• Functional and Non-functional testing of Zone Mediation, RBM, EOC, APIs, CRM and usage processing tools
• Test data generation and population in DBMS using SQL queries to improve the quality of testing
• Design of QA Checklists, Regression, Smoke & Sanity Test Suites and Quality Control Checklists for QA and Processing teams
• Design and Audit QA Processes and Templates for Testing, System and Processing teams of the organization
• Design and review project plans and QC checklists prepared by Processing Team to process Customers data using Processing Tools designed
• Arrange and conduct review, bug triage, Sprint retrospective and Defect Meetings
• Training to QA team on new technologies
• Analyzed the existing testing process and submitted the report to improve the process and estimated the efforts

Team Lead

Confidential, Dallas, Texas

Responsibilities:

• Working as Team lead/Architect on the Project Financial Dashboard project for the organization.
• Coordinated with business partners on requirements
• Created/Design the database schema (MS SQL SERVER 2014), ETL Process (MS SQL SERVER - SSIS) and project Dashboard with Microsoft Power BI Tool.
• Data modeling with MS SQL Server
• Created Test Execution Plan (STLC)/ Test Scripts / Execute Test Scripts.
• Created the SMOKE TEST plans help business to verify the core functionality after each deployment ad before starting any testing.
• As Team lead, assigning the tasks to respective developers and all necessary tracking, tasking and migrating to all environments, also involved in debugging the scripts to identify the bugs and fixing the bugs.
• Worked with XML Imports
• Created project status and KPI reports, defect tracking system (JIRA).
• Developed Staffing Tool that helps to analysis resource and project availability respectively. It also helps management to allocate resources for upcoming opportunity and help to create Project RFP accordingly.
• Worked on the CC&B billing modules during testing phase. Verify the billing rates/calculation/bill print details/meter management/customer information/service point configuration.
• Created/Modified data setup (V structure) required for the billing process in CC&B system
• Created the CC&B Global Details that helps BV (Organization) to keep a track on prospects/suspect sales opportunities.
• Created the MWM Strategic Workforce Planning
• Managed the code review and design changes
• Working on Enhancing the skill set to Oracle MWM (Mobile Workforce Management), Microsoft SharePoint
• Created presentation on Sybase (T-SQL) Overview to help with one of the proposal working on.

Senior Consultant

Confidential, Philadelphia

Responsibilities:

• Co-ordination with various stakeholders involved with project, tracking of defects and status reporting.
• Requirement gathering and analysis, allocation of the task to the team members & Tracking of the tasks
• Development of test plan, Estimation, test cases, test data and their reviews / walkthrough
• Review Defect reports, Status reporting, Defect Management using Jira
• Preparation of Matrix, Maintain Requirement Traceability
• Delegated to handle testing of web based applications (Siebel) and outline test strategy, cases and scripts.
• Handled approval process and test estimation (ETL Testing).
• Coordinated about software defect tracking and regression updates to stakeholders and managed documentation.
• Maintained manual test and continuous improvement in meeting client needs and handled design reviews.
• Evaluated automation test status reports and formulated tools and scripts.
• Conducted load testing.
• Handled formulation of reusable scripts and evaluated testing needs and automated scripts.
• Managed repository of automated quality assets and extended consultation of complex projects.

Senior Analyst

Confidential, Maine

Responsibilities:

• Co-ordination with various stakeholders involved with project, tracking of defects and status reporting.
• Integration Testing/ System Testing for the data analysis system, follow the Agile test life cycle
• Development of test plan, Estimation, test cases, test data and their reviews / walkthrough
• Review Defect reports, Status reporting
• Defect Tracking using - Quality Center, Jira

Senior Analyst

Confidential, Denver

Responsibilities:

• Created Test Plans & strategies (JIRA)
• Worked on legacy system enhancement test cases includes verifying PL/SQL script / analysis legacy system script and impact analysis on new enhancement.
• Review Defect reports, Status reporting
• KPI Reports /SMOKE Test

Senior Oracle Consultant

Confidential, Baltimore

Responsibilities:

• Worked with business analysts and IT staff to develop a performance test plan document
• Worked with the Client on User Acceptance Test (JIRA). Created/presented the system flow to allow customer to understand new system workflow.
• Created the QAT Regression Test strategies includes functional ad technical details required to test the system.
• Created the SMOKE TEST plans that help business to verify the core functionality after each deployment ad before starting any testing.
• Created the testing process guidelines to help Client Test Team with testing future enhancement after going live.
• Managed the production release activities that include creating a production package, cross impact analysis for the production release along with the code version control.
• Worked on the Post-go live impact analysis & testing the Core functionality.
• Created lodestar script to covert legacy system data into new system format during merger project

Senior Software Engineer/ Onshore-Offshore coordinator

Confidential, Austin, Texas

Responsibilities:

• Requirement gathering and analysis, allocation of the task to the team members & Tracking of the tasks
• Implement the new Lodestar solution for the energy market.
• Worked with the business key resources on requirement gathering, work estimation and impact analysis.
• Worked on system integration for billing system. Help team members with integration process and share knowledge.
• Created/Managed solutions to high priority 1 & 2 defect technical solutions (Oracle PL/SQL Scripts) within given period to meet SLA.
• Created Database Model (MS SQL Server)
• Created Lotus Notes script to in corporate enhancements/production go-live defects.
• Created project status, defect tracking system (JIRA), budget report and KPI reports, MS-Project work plans.
• Created SMOKE Test process document to verify end-to-end functionality for each module Worked with clients on User Acceptance Tests.
• Managed the production release activities that include creating a production package, cross impact analysis for the production release along with the code version control (Visual Source safe).
• Worked with onshore/offshore model, managed the team at offshore, work with team on deliverables.
• Managed the unit testing on the key elements during production releases.
• Support QA activities during project includes mapping to requirements, defect tracking.

Senior Software Engineer/ Onshore-Offshore coordinator

Confidential

Responsibilities:

• Coordinated with systems partners to finalize designs and confirm requirements.
• Provided continued maintenance and development of bug fixes and patch sets for existing web applications.
• Created Lotus Notes script to in corporate enhancements/production go-live defects.
• Coordinate with onsite client team/architect to discuss go live defects and solutions.
• Provided solutions to high priority 1 & 2 defect technical solutions within given timeframe to meet SLA.
• Created KPI reports, Managed Project work Plans (MS Project)