OBJECTIVE:

Over 22 years of IT experience in Software Life cycle.

Contributing to organizational growth to its optimum efficiency, deliver effective business results, and quality by obtaining a position that allows me to use my strong IT analytical skills and SDLC experience extensively, to design, develop and testing projects in a dynamic team - oriented environment that promotes leadership, learning, and growth.

Actively involved in the SCRUM agile Methodology, working as Hadoop Support.

SUMMARY:

• Working with the Confidential, in Hadoop Data Ingestion team, successfully ingesting the customer files on a daily basis.
• Worked as a Senior QA Analyst, supporting the QA team with different projects like Trickle down, vin solutions, Dealer Zone etc
• Supported the BI Support team, vigorously working with all the customer tickets with different applications using Informatica work flows.
• Extensively working personality with Mobile Technology, CRM, and Billing with Quikview of Confidential Internal application along with the Amdocs Billing.
• Pretty good knowledge of Agile Methodologies supported by Team Foundation Server.
• Managing the version control, automated team builds, story building, Feedback by Team Foundation server.
• Close intimate work nature with Amdocs Billing system on daily basis.
• Pretty good knowledge and work experience with all the mobile Devices with IPhone, Blackberry, Tablet, IOS, femato cell signal testing.
• Hands on experience with Performance using both Jmeter and Load Runner and Monitoring tools like ksar.
• Capturing the Non Functional Requirements like Response time, TPS and getting the SLA from the sign off doc
• Worked extensively with both client side and server side setting to run baseline, load and stress and also endurance testing.
• Recorded the base scripts to make sure the setup is ready and then enhance the scripts in order to make the performance suit ready
• Working with the Network Engineers for IPSpoofing, Working with the Workload modules.
• Capturing the server logs from the developers or from the 123LogAnalyser
• Identifying the Critical scenarios, talking to the architects and also with Business.
• Monitoring the most critical scenarios and providing the reports to the Development team.
• Working with the scenario setting up, and also with correlation (session id dealings)
• Good knowledge of Cloud based platform for testing and monitoring mobile websites and applications using Device Anywhere.
• Very good understanding and involvement in Agile Testing based Environment with very good communication.
• I am innovative, result-driven, highly self-motivated and energetic professional having more than 15 years of experience in Information Technology with over 8 years of experience in design, development, and multi-level QA(quality assurance) testing using SDLC((software development life cycle), waterfall and Agile methodologies.
• In Agile as a team work together better, and will hold one another accountable for delivering.
• Attending the daily standups in scrum.
• Working based on the Business priority.
• Managing backlogs and Pre-Planning for the next sprints
• Periodic Communication in SCRUM AGILE Methodology to the stake holders about the status.
• Creating working agreement with the cross platform team in Agile.
• I am very strong in object oriented analysis and design skills including 5+ years of experience Oracle, PL/SQL, and C programming, UNIX and shell scripting.
• Worked thoroughly with the SAP based Confidential internal application Quikview having couple of modules like DMW, EEIR,
• And SAP OER.
• I have proven track record experience of leading, developing, unit, regression and system integration testing (SIT) and delivering client-server, warehouse, and web based complex multi-dimensional projects on time with quality.
• I have strong functional knowledge in data warehousing, billing, collections, vouchers, and Internet transaction solutions, GUI (Graphical User Interface), and mobile technology systems. Multiple times, I was recognized as a Strong QA Resource with strength in leading and managing QA teams, proven Ability to Work effectively in very competitive and aggressive Agile development methodologies, recognizing peer strength, building a productive and intelligent QA Team.
• I professionally performed the responsibility as Mentor and Leader to motivate the team to follow strong QA Process.
• I have been extensively using QTP, QC (Quality Control), Performance Testing (Load Runner) tools.
• I always advocate for improvised QA Process which will provide a Quality Product within Schedule and Budget. My leadership experience coupled with strong technical background, along with excellent Analytical, Presentation and Communication skills makes me a valuable asset to any project or to any organization.
• Worked extensively with the IPhone, IOS, Blackberry mobile device testing, in almost all the Mobile Technology companies worked with.

EXPERTISE AREA:

• Expertise in Manual, Automated, Performance and Stress testing.
• Proven ability to work on multiple projects within given timeline by delivering projects successfully and efficiently,
• Expertise in creating Risk Analysis reports, Test Coverage, Test Requirements, test plan, Test Cases., Test data specifications, Test matrices, Test results, Test status and incident reports and Final test reports.
• Manage Software Test Deliverables for QA Team, Development Team, Business and Upper management.
• Ability to setup and maintain Test Environment. Influence designs and Plans to Improve Performance and Reliability, Reduce Resource consumption and Facilitate Testing.
• Excellent understanding of SDLC, Agile, Waterfall and Test methodologies from project scope to post deployment.
• Expertise in Testing with Windows Environment, UNIX Environment and Oracle, SQL Server, Netezza databases.
• Expertise in testing the Migration of the data from Legacy system to new systems
• Expertise in writing and executing SQL queries
• Expertise in testing Data Stage to load data to different stages
• Expertise in Preparing XML files for test scenarios
• Expertise in VB Scripting, Java scripting.
• Mobile handsets testing.
• Testing the apps in iPad and Touch pads.
• Testing the apps in Smart phones.
• Understanding and acting accordingly to all the server side coding in order to deal with some of the critical Intermediate server issues.
• Expert Level Knowledge in Creating an Automation Test Scripts for Web based Application Using HP QTP 10/11 using Descriptive Programming. Proven Problem - Solving and technical Debugging Skills.
• Participates in requirement definition for specific projects.
• Expertise in Quality Centre (Test Director) to Manage and Handle Project Planning and to create Test Requirement, Test Coverage, and Test scripts, Test cases, Defects tracking and reporting.
• Advance knowledge of system analysis, database design, form design, report outlay, development and testing
• Expertise in various levels of Quality Assurance for Client/Server, Web based and Mainframe applications.
• Expertise in Handling Small to Medium, Medium to Large QA member Team in Agile Development Methodology.
• Strong leadership quality. Ability to lead based on situation. Handling small to large QA groups in onsite and also off shore team based on time zones. Effectively provided 24X7 supports.
• Ability to work through any kind of Defect to give result and work with Developers to resolve the issue.
• Ability to provide both detail information and also summarize to management level.
• Expertise in Performing Usability Testing, Black Box Testing, GUI Testing, Unit (CIT), Integration, and System Integration Testing(SIT), Security Testing, User Acceptance Testing(UAT), Regression Testing, Data Driven Testing, Beta Testing, Boundary Value Analysis and Performance Testing, Input Testing, Equivalence Partitioning, Syntax Checking, Special-Value Testing, Output Result Coverage.
• Attending the Requirement Analysis meetings, playing a major role in the defect tracking Meeting.
• Working with the test metrics. Working with the developers and BAs for the Use case and test case deliverables.
• Preparing the traceability and test coverage matrix. Working with the Test Plan and Test cases.

TECHNICAL SKILLS:

Operating System: UNIX, Red hat Linux, SCO UNIX, Windows OS, OS/400, MVS, SunOS4.1.4

Software: Hadoop, TOAD, PL/ SQL, SQL, MS-Office, Rumba, Tomcat, WinSQL, SQL Developer

Database: DB2/400, ORACLE 11g/10g/9i/8.x/7.x., MS Access, ES9000, MS SQL

Application Server: Oracle Web Server, JSP Server, SQL Server, IIS, Solaris 2.8/2.7/2.6/2.5.1 , XMPP

Automated Test Tools:  QTP 11/10/9x/8x, Win Runner 7.00/7.2/8, Load Runner, Clear Quest, Silk Test6.0, AMDOCS

Bug Tracking Tool:  Quality Center 11/10//9.5/8.x, Rational Clear Quest, PVC Tracker, JIRA, Rally, BUGZilla

Testing methodologies: Black Box, White Box, System Integration, Regression, End-to-End, Performance, CIT, SIT, UAT, Data Validation & Verification, Data Driven, Functional, Smoke, Positive and Negative testing, boundary testing, bottom up, RBT, SBT,ATDD.

Reporting Tools: Test Director (Test Manager), Quality Center, Team Track, Crystal Reports, Rally,ALM,PVC Tracker, Crystal Reports, Oracle Business Intelligence, Tableau

Web tools:  Flash, Dream weaver, Adobe Photoshop, Web sphere, Web logic, eCom, COLD FUSION

Language: C, C#, SQL, PL/SQL, SQL*PLUS, JAVA, AJAX, JCL, CICS, VSAM, BASIC, COBOL,.NET

Scripting Languages:  VB SCRIPT, JAVA Script, HTML,DHTML,TSL,XML, .NET, UNIX Shell Scripting

Business Tools: MS Word, Excel, Power Point, Golden Tool for SQL

Web navigator:  Netscape Navigator 7.0, Internet explorer, Firefox, Chrome

OLTP: CICS

Network protocols:  TCP/IP,HTTP,SMTP,MM7

SDLC Methodology:  Agile, RUP, Water Fall, V-Model and Spiral Model

Training:  QTP, QC, Load runner, Configuration Management, HIPPA, Agile.

Administration:  Test Management, Quality Control, Quality Analysis ,Review, Audit, Assessments, Reporting

ETL/BI: Informatica 9.5.1/9.1.0/9.0.1/8.6 , OBIEE, Micro strategy

PROFESSIONAL EXPERIENCE:

Confidential

Hadoop Support

Responsibilities:

• Was responsible for ingesting data from Databases (oracle, sql server, db2, Netezza, Vertica) to Hadoop and AWS platform.
• Was responsible for ingesting data from API, sterling ftp system to Hadoop and AWS platform.
• Wrote custom ingestion script using python and unix shell.
• Was responsible for setting of ingestion processes using Azkaban work flow and control-M.
• Was responsible for Quality and validation of source, Hadoop/AWS data.
• Was part of data monitoring team who were responsible for any data issues on big data platform. Technology used: Hadoop , hive, sqoop, AWS EMR, S4, Azkaban, control-M, Unix shell scripting, Python
• Working with Hadoop data Ingestion, using ControlM and Stream sets.
• Was responsible for CADS data Ingestion
• Production support in Hadoop
• Checking reports in Tableau.
• Working with the UNIX bash scripting, developing and maintaining as per the project requirement.
• Internal ATC and also external client data (hourly, daily, weekly and also monthly) downloading through FTP sites and any discrepancies in incoming data, need to be monitored and act accordingly.
• As per the tasks in the scrum need to work with the development, and also the maintenance and production task using the Hadoop tools like hive, hue (for Hdfs database) , transferring and loading data whenever necessary into edgenode and the hdfs.
• Using azkaban for scheduling and executing the daily jobs.
• Working with the sqoop jobs, both autosqoop and the regular sqoop to pull the data from the external sources.
• Managing the data and the metadata issues.
• Using ipyspark to get the sizes of the hdfs partition to get the graphical representation of the database usage.

Environment: Hadoop, Hive, impala , ipyspark , hue, azkaban(for scheduling jobs of Hadoop), XMPP, Agile, RUP, Netezza, Vertica, Toad, Aginity, SQL Developer, Tableau, Putty, SQL NAVIGATOR, Sun Solaris, HP-UX, Oracle 11G, SQL Server, Micro Strategy, Informatica 9.0.1.

Confidential

BI SUPPORT

• Supporting the ETL/BI QA for all the ETL projects,
• New Car - Front end modifications on the web pages and the customer browsing information and the new car specials etc.
• Information is captured as the SSM feed and daily files are loaded, the data warehousing testing should be validated based on the ETL process and the mapping documents.
• The movement of the data into the backend databases like Netezza, INTM, Oracle and MSTR (Micro strategy) Report.
• Worked as the Lead for the Trickle Down project for the Regression testing of the New Features added to the Old Packages.
• The updated packages are being moved properly to the backend databases will be tested and the same need to be shared with the whole group with the status meeting and emails and also the graphical reports.
• Dealer zone is the project when 52 tags and 7 dar tags are been added to the front end web site the same need to the tested from the backend side when the front end ESO group is done the testing and when deployed.
• Conducting Regular Meetings with the QA team and also with the developers and Managers for any issues and status.
• Conduction war rooms to expedite the work as well as the issue fixing and also talking with the SSM data feed group.
• Technology ETL/BI, Informatica, Oracle and Netezza databases using the Tool Toad and Aginity. 
• MSTR reports through Micro strategy.
• Working for Confidential on datawarehouse, BI and ETL Projects.
• Supporting and working with the ETL projects like NEW CAR, HAYSTACK, SPECTRUM, DEALER ZONE, SLA DAR
• Now recently getting into Technical Lead role.
• Managing the environments, making sure all the environments are available and no issues for both employees and users.
• Supporting daily ETL loads to load the data into QA environments.
• Any changes to any configurations or code changes or performance table changes, need to be indicated in the QA Run book and also need to add to the Daily loads.
• Monthly loads and Quarterly refresh need to take care, conducting meetings with the architects, Delivery managers etc making sure the quarterly refresh during which the non-availability of one of the QA environment (QA2 with closely equal to production) should not be any impact to any projects.
• Making sure the quarterly refresh dates none of the projects get deployed.
• Providing solutions if any project is getting impacted because of other common table data changes by other projects.
• Weekly environment meetings are being conducted to capture the deployment, DEV Completion dates, QA1 to QA2 code move, QA2 move before which the Hand off meeting making sure the QA is pass, before the code move to QA2.
• SLA DAR most visibility and important data project for the company
• Building or developing the remaining DAR DLEADS Metrics for the 2nd release in Daily CUSTOMER METRICS TABLE.
• Complete the DAR and car/dealer process two hours earlier by developing Month to Date DAR Process using the DAILY CUSTOMER METRICS Table.
• Making sure the ETL CODE reflects the design 
• Validating the wrk table and the design code (DAR Daily SQL) 
• Testing the Count Validation check between DAILY table against EXTMRT table (DEALER LEADS EXTMRT) on the 1st day of the Month 
• Working for each New Metric to make sure the value should match between Daily Metrics Table and the EXTMRT table at customer level.    

Environment: ALM/Quality Center 11 (Test Director), Quick Test Pro 11.00, XMPP, Agile, RUP, UAT, Netezza, Toad, Aginity, SQL Developer, Putty, SQL NAVIGATOR, Sun Solaris, HP-UX, Oracle 11G, SQL Server, Micro Strategy, Informatica 9.0.1.

Confidential

Scrum QA Lead

• Working with the Quick View Confidential application made with Flex and Java , which is a Customer Service Management (CSM) application.
• Dealing with all the Socs, Services, Bans and IMEI and SIMS with different environments, depending on the Monthly Builds.
• Leading and Working extensively with the Production supporting QA group.
• Working with the Customer Service defects from the Production.
• Working with the Quick View Confidential application made with Flex and Java, which is a Customer Service Management (CSM) application.
• Dealing with all the Socs, Services, Bans and IMEI and SIMS with different environments, depending on the Monthly Builds.
• Working to retrieve different types of data for different environment using SQL Server database.
• Very close intimate work culture with the Developers, discussing day to day defects.
• Before released to QAT group, testing extensively in the PST group.
• Working with the Automation projects of the QuickView Application using Flex Monkey.
• Simultaneous work culture with both PST (Production support) and also with the Automation Team.
• Leading and Working extensively with the Production supporting QA group.
• Working with the Customer Service defects from the Production.
• Working to retrieve different types of data for different environment using SQL Server database.
• Very close intimate work culture with the Developers, discussing day to day defects. Before released to QAT group, testing extensively in the PST group.
• Working with the Scrum Master and other offshore team.
• Working with the Automation projects of the QuickView Application using Flex Monkey.
• Providing them with the data or any software help in the early hours of eastern timings to match with the offshore team. Working with the sanity and communicating with the CSM team also with Jira, internal supporting and in-build Confidential application of all the defects.
• QC 11 is the day to day defect tracking along with the Jira(overall application for the Confidential ).Dealing with the weekly build , sanity testing.
• Communicating with the CSM team.
• Leading daily scrum Meetings and also defect meetings for the production based issue. .

Environment: Web 2.0, Quality Center 11 (Test Director), Quick Test Pro 11.00, XMPP, Agile, RUP, UAT, SQL Developer, Putty, SQL NAVIGATOR, Sun Solaris, HP-UX, Oracle 10G/11G, QTP, Flex Monkey , SQL Server, Confidential Tools for IMEI.

Confidential, Lindberg, GA

Encore QA Analyst/LEAD

• Working with the Unified Inbox and the Address Book in the 4G technology
• Hands on experience in testing IVR technology with extensive knowledge of IVR applications, testing procedures, and tools
• Handle the tasks of testing the behavior of IVR systems to stimulate the callers
• Encore application is the web based application with the Java application servers.
• This application is made to test the most widely used SMS, MMS and also Voice recognition, voice to text and vice versa using the IVR application prompting callers to gather and also transfer the calls.
• Also testing IVR on different devices like web, IPAD and also on the Android phones.
• Tested the Voice recognition through IVR application.
• Also tested the data retrieved from the server during the call.
• Assigned responsibilities of testing voice quality and voice recognition functionality of IVR Systems
• Extensively involved in completing the Requirements Doc, gathering and analyzing before test case writing.
• Created the test cases from scratch and provided team co-coordination to complete all test cases ahead of weekly test cycles start.
• Successfully completed and executed Warehouse Management System Test Cases.
• Proactively analyzed test cases with cross functional team leads and managers and shared weekly cycle’s defect tracking status.
• Successfully executing test cases for telephone line transmission, SMS/MMS, Audio, Video, and webcam pictures by executing series of tests such as Unit, Regression and System Integration Testing (SIT), Stress and User acceptance testing (UAT), pre-prod and prod certification testing.
• Tested with different levels of the stage environment with the femoto cell to get the signals onto mobile.
• HUI Testing is done with Femoto cell.
• Recording Voice Message and testing it before and after sending. Recording Video calls and testing it before and after sending Successfully executing test cases for telephone line transmission, SMS/MMS, Audio, Video, and webcam pictures by executing series of tests such as Unit, Regression and System Integration Testing (SIT), Stress and User acceptance testing (UAT), pre-prod and prod certification testing.
• Capturing/debugging data using Firebug and sending across to development team.
• Testing of the chat conversations, Send Receive Picture messages, MMS, sending SMS from the chat, calling from the conversation, Notifications.
• Involved in end-to-end testing for the Mobile Applications.
• Multiple sets of data along with SMS, MMS, Video, Voice and Emoticons are tested in all the environments like QA, SIT and Production.
• These are the points u can add in the recent project
• Developed and executing the Test Planning Test Development, Test Bed and Test Matrix and Test Execution.
• Performed extensive tests by uploading pictures after instantly taking the pictures and also with the old pictures.
• Recording Voice Message and testing it before and after sending. Recording Video calls and testing it before and after sending.
• Performing multi-tasking by Working with the Master Number Management and working with the voice plus, photo attachment and forwarding it.
• Testing after forwarding and again attaching some Emoticons. Thoroughly testing the emoticons, with direct selection and also with the short code typing. Working with the Jmeter with the server side script running.
• Loading the Jmeter scripts for SMS/MMS, MMS with vcard.jmx files, MMS with vCal, EP1 Inbound services, BSCA Services.JMX, Metaswitch, Jmx, Login.jmx.
• Created Regression test scripts and developed reusable scripts to test the functionality of the application developed in XML for ORACLE and Windows. Attending meetings with Business/BA’s/Developer in BR/SR/FRD/ADD stages and create test cases and train teammates. Testing all the services through backend server services.
• Create User Define Function, Maintain User define function library for Automation Scripts.
• Testing with the QTP automation framework mostly with the descriptive programming of vb script.
• Writing and enhancing the scripts as per the Requirement changes. Working with the object repositories both local and shared.
• Automated the MMS and SMS concepts with the Data driven framework using data in the excel sheet.
• Multiple sets of data along with SMS, MMS, Video, Voice and Emoticons are tested in all the environments like QA, SIT and Production.
• Different options for time recording with min of 1 sec to max of 4 min voice and video were tested with QTP.
• Design, Document and Gain approval for test Deliverables for Test Automation.
• Review Test Results to Validate Completion of Testing. Review test deliverables to ensure compliance to the Test Strategy.
• Analyzing results of performance and stress test execution and deliverables reviews to evaluate product performance.
• Analyzing test Metrics to determine quality and forecast release readiness.
• Participated in Peer Reviews and Walkthroughs for SRS, Design, Test Planning, Test case Specification artifacts, and Source code
• Performed back-end testing using SQL queries to make sure that data entered correctly into the Source Database.
• Create Regression and Functional Automation Scripts using Descriptive Programming.
• Created and Implemented an Automation strategy that converted manual test cases to QTP scripts.
• Created and maintained Virtual test lab Resource via VMware Virtualization.
• Create User Define Function, Maintain User define function library for Automation Scripts.

Environment: Web 2.0, Quality Center 11 (Test Director), Quick Test Pro 11.00, XMPP, Agile, RUP, UAT, PL/SQL, SIT, TOAD, SQL Developer, Putty, SQL NAVIGATOR, Sun Solaris, HP-UX, Oracle 10G/11G, QTP, Load Runner, UNIX / Red hat Linux Shell Scripts

Confidential, Alpharetta, GA

QA Analyst

• Involved in successfully executing multiple Modules, which includes QPASS, Bad Debt, Manual JE, Roamer, Rollover, VPDP, Warehouse Management System, commissions and compensations.
• Performed testing on UI (User Interface), PC Client, Middleware, and web user interface solution.
• Successfully created and executed test cases by utilizing Agile, RUP, and interactive test procedures.
• Performed system integration testing (SIT) of Web 2.0 applications. Responsible for messaging protocols including XMPP.
• Prepared the Setup scripts and uploaded the test cases into Quality Center. Worked on Manual JE testing both SIT and with UAT.
• Uploaded the test scripts for testing in MPQA1 (SIT environment), MPQA2 (UAT environment), MSQA6 (Pre-Prod and Prod).
• Prepared the SIT test summary.
• Worked extensively with the performance test plan for Roamer and manual testing projects, VUGEN scripts, and its enhancements.
• Extensively worked on performance test cases for manual JE process and Roamer project.
• Wrote the test cases and worked with testing and defect tracking with the java based application.
• Extensively used Web based application (ASPEN) for MANUAL JE testing and created new featured Manual JE in Phase 3.
• Tested the breadcrumbs, navigation, and content on the web page and also compatibility check and orphan pages.
• Extensively worked with the commission agents projects including VPDP.
• Worked with Crystal Reports for the report generation and testing. Attending meetings with Business/BA’s/Developer in BR/SR/FRD/ADD stages and create test cases and train teammates.
• Worked with commission and compensation projects in VPDP.
• Participated in BRD and FRD meeting with users. Working with the NFRD test cases. Defect tracking and discussion about the defects with developers. Leading up all Test Efforts across the Board for business.
• Analyzing test Metrics to determine quality and forecast release readiness.
• Responsible for creating risk analysis reports, test plan, test data specifications, test matrices, test results, test status reports and final test reports. Retesting the fixed defects. Worked on Flat files.
• Worked very effectively and efficiently with ATDD development methodology (Agile Methodology).
• Checking the mappings in Informatica 8.6 and analyze the sources and target mappings how the data is transmitting and write test cases on these mappings. Check the source vs. Target based on the mappings done in Informatica and make sure all the required data populated in target tables based on the Filter transformations used in Informatica.
• Wrote test cases on Informatica data flow (how the data is populating in Target tables from Source using different transformations).
• Wrote the whole project test cases single handed. Worked with the developers and Business Analysts.
• Opened and maintained the defect tracking and retested the defects.
• Aggressively used the SQL Developer for the Backend testing. Used ASPEN front end JAVA APPLICATION for testing.
• Set up the entire environment for testing. Wrote the full QPASS project test cases single handed.
• Prepared the setup environment document and set up the entire UAT environment for testing.
• Extensively worked with developers and fixed all the opened defects.

Environment: Web 2.0, Quality Center (TestDirector), XMPP, Agile, RUP, UAT, PL/SQL, SIT,TOAD, SQL Developer, Putty, SQL NAVIGATOR, Informatica 8.6, Sun Solaris, HP-UX, Oracle 10G, Informatica, QTP, LoadRunner, UNIX / Red hat Linux Shell Scripts