SUMMARY:

• A competent and result oriented professional with 6+ years of rich experience in Information technology, with emphasis on DWH/ETL, Quality Assurance, Agile Methodology and Data Analysis.
• Extensive experience with Specialized - Requirement analysis, Quality Analysis,Data Warehouse Testing, data analysis and Business Intelligence report testing
• Possess sound knowledge on Telecom Cable domain industry. Gained good working knowledge on SQL development in Oracle and Netezza.
• Tested ETL applications in Netezza data Warehouse and UNIX shell scripts written for ETL processes and used Tidal Job scheduler to schedule the jobs, while working closely with development team.
• Strong understanding and hands on experience of Software Development Life Cycle (SDLC) & Software Testing Life Cycle (STLC), while working in different SDLC methodologies like Waterfall and Agile (Scrum).
• Expert in story writing based on the requirements based on inputs from stakeholders.
• Good hands-on on, Test activities that include: design, develop and execute test strategies/plans; debug and troubleshoot; perform impact, defect and gap/root cause analysis; coordinate test resources, status reporting, issue resolution, defect tracking and defect triage activities.
• Involved extensively in various testing Phases - Component Integration, System Integration, Regression, System testing, Performance testing and UAT.
• Performed different roles in a Data warehouse BI project i.e. QA Analyst, QA lead, Data Analyst & Scrum Master.
• Proficient in creating Test Strategy, Test Plan, Test Cases, Identifying Test scenarios by decomposing business requirements, providing LOE estimates and developing test scenarios to support quality deliverables.
• Extensively used tools like JIRA & Rally for creating &Tasking stories and Quality center for Defect tracking and Release Management.
• Good working knowledge of Operating Systems like LINUX and UNIX.
• Experience with version control using tools such as Subversion.
• Experience in performing data validation testing by writing and executing SQL queries. Gained good working knowledge on SQL development in Oracle and Netezza.
• Possess sound knowledge on Telecom Cable domain industry.
• Excellent communication, collaboration, reporting, analytic and problem-solving skills, acted as scrum master for a team as well.

TECHNICAL SKILLS:

SQL and Scripts: PL/SQL, Netezza SQL.

Tools: and Technologies Used: Oracle, Netezza, Quality Center & micro strategy

Operating System: Windows XP, Windows Server and UNIX

PROFESSIONAL EXPERIENCE:

Confidential,Charlotte

Technical Lead, Quality Analyst

Billing Systems: ICOMS, CSG

Tools: and Technologies Used: Oracle, Quality Center

Order Management System: OMSE

Role & Responsibilities:

• Business Requirements and stories analysis, Estimation and story sizing.
• Work closely with the development team & Business analysts to understand and analyze the product better.
• Create Test Plans, scenarios, Test cases and test scripts and review them with the team as part of Test Plan reviews and Product Demos.
• Work with application users, UAT testers during the UAT period.
• Perform Sanity, Functional & Regression testing with the help of offshore team.
• Co-ordinate 2 member offshore team for daily tasks and deliverables to be able to deliver on time.
• Report defects and manage the Defect tracking cycle in HPQC.
• Provide Test status reports (Daily/release wise) and post-release production statistics.

Confidential, Charlotte

Data analyst, Quality Analyst & Scrum Master

SQL and Scripts: PL/SQL, Netezza SQL.

Tools: and Technologies Used: Oracle, Netezza, Quality Center & micro strategy

Operating System: Windows XP, Windows Server and UNIX

Role & Responsibilities:

• Analyzed the Business Requirements and Business Reports to get a better understanding of the system on both technical and business perspectives.
• Project had direct impact on business, lead to interactions with the Business users, stakeholders to understand the expectation of client and better understand the ETL work flow of data.
• Worked very closely with the development team & Business analysts to understand and analyze the product better.
• Created & reviewed Test scenarios, Test cases and test scripts as part of Test Plan reviews and Product Demos.
• Validated the ETL flow of data and BI reports.
• Validate the data fallouts and flow into Mart layer.
• Performed data analysis on Live Production data.
• Creating reports which depict the quality of data.
• Provided business solutions based on the analysis done on live data.

Confidential

ETL Tester, Team Lead and Onsite Coordinator

SQL and Scripts: PL/SQL, Netezza SQL.

Tools: and Technologies Used: Oracle, Netezza, Quality Center

Operating System: Windows XP, Windows Server and UNIX

Role & Responsibilities:

• Analyzed the Business Requirement Documents and Functional Specifications to create technical and business level understanding of the Story.
• Being part of the scrum team, take part in daily interactions with Product Owner, Business Analysts and development team to understand and translate better, the business requirements to Functional specific ETL requirements.
• Tasking the stories and providing estimates based on the understanding during Planning.
• Building the Test strategy document and making the test approach during planning phase.
• Preparation and Review of Test scenarios, Test cases and test scripts.
• Test environment and Test data setup by Mocking up the data to test all possible scenarios.
• Executed test cases through iterative testing for incremental functionality.
• Preparation of traceability matrix for the test duration mapping requirements to defect.
• Defects and Release Manuals tracked in HPQC.
• Work allocation to offshore team, and communicated status of work products on a regular basis to the Client manager.
• Co-ordinate 4 member offshore team for daily tasks and deliverables.
• Collating, analyzing and circulation of test Metrics to Management team
• Experience in working on agile methodologies with the Onsite - Offshore model.
• Have filled up the shoes of Business Analyst as well whenever required by providing the business solutions based on the thorough data analysis done.
• Providing estimates and assigning tasks based on the understanding during Planning.
• Validate the data fallouts and flow into Mart layer.
• Performed data analysis and trend analysis on Live Production data, to report any deviations from the trend.
• Creating reports which depict the quality of data.
• Provided business solutions based on the analysis done on live data.