Summary:

• 7 years of experience in IT industry which involved various phases of project that includes requirement study, analysis, design, development, testing and implementation.
• Experience in testing software applications developed using C, Informatica, Microstrategy, Teradata and Oracle.
• Good experience in doing Datawarehouse and Business Intelligence reports testing.
• Proficient in performing Functional Testing, Regression Testing, System Testing, Database Testing/Back-end testing and User Acceptance Testing.
• Very good knowledge of doing Functional testing and Regression testing using QA Wizard Pro.
• Knowledge in ETL process consisting of data transformation, data sourcing, mapping, conversion and loading.
• Experience in backend testing on Oracle and written SQL/PL SQL queries.
• Good working knowledgeof UNIX and Shell Scripts.
• Very good experience in working on projects that follows Waterfall, Agile and Scrum methodologies.
• A self-motivated professional and natural communicator possessing good technical, initiating, leadership and problem-solving skills and has proven to be a good team player.
• Excellent Technical, Communication and Interpersonal Skills with strong Customer Orientation and Client Interfacing Skills.
• Dedicated, hard working individual with the intercommunication skills to work at all levels of the organization.

Education:

• Bachelors in Computer Science and Engineering

Appreciation / Awards / Certification / Training:

• Teradata Certified Professional V2R5
• Teradata Certified SQL Specialist V2R5
• Achieved "Above and Beyond" award from Wipro Technologies towards outstanding performance in the project.
• Undergone training in MicroStrategy 9.x
• Undergone training in Ab Initio GDE 1.14.7/Co-Op 2.14.2.

Technical Skills:

ETL Tools: Informatica 8.x, Ab Initio GDE 1.14.7/Co-Op 2.14.2
Reporting Tools: Cognos 8.x, MicroStrategy 8.x/9.x
Testing Tools: QA Wizard Pro 2009
RDBMS: Teradata V2R5, V2R6, Oracle 10g/11g
Operating Systems: Windows XP, NT & 2000, UNIX, LINUX
Scripting: Shell Scripting
Languages: C, SQL, PL/SQL, HTML
SCM Tools: Clearcase, CVS, SVN, JIRA
Job Schedule: Autosys
Agile Tool: Rally

Professional Experience:

Confidential, DC (Feb-2009 - Till Date)
Sr.Quality Analyst
The Advisory Board Company (NASDAQ: ABCO), a professional and technology services firm serving 2,500 of the country's preeminent hospitals and healthcare systems, is rapidly expanding its portfolio of technology solutions to provide hospitals with clearer insight into their financial, operational and clinical businesses. Advisory Board Compass Solutions aim to empower hospitals to achieve business performance goals through faster, data-driven decision-making.

Worked as a Senior Quality Analyst for multiple assignments with the primary responsibility of maintaining high quality on developing Business Intelligence products for HealthCare called NURSING, ED, THEATRE and SPEND COMPASS. With additional responsibilities of automating the ETL loads and MicroStrategy reports for regression testing.

Responsibilities:

• Reviewed and Analyzed business requirements, technical requirements and specification for various functionalities.
• Conducted and involved in meetings and walkthroughs with users, developers and Business Analysts to gather information about business process.
• Prepared Test Strategy Document, detailed Test plans and Test Cases based on the Business and Technical requirements.
• Created and executed the Test Plan, Test Cases, Automation Test Scripts, and Test Steps for all modules and stored in SVN and JIRA.
• Expertise in Defect Tracking and requirement tracking throughout the test life cycle using JIRA.
• Prepared and provided test status reports to the management on system status, system changes, problems and potential impacts.
• Worked on Agile Methodology Framework.
• Took part in creation of QA Metrics and graphs to help the top management to keep update with the QA Team progress.
• Performed Functional testing on various Business Intelligence reports developed using MicroStrategy and JAVA.
• Proven expertise in testing ETL Informatica transformations. In addition to Starting, monitoring the loads and checking the error logs for the root cause.
• Extensively used SQL, PL/SQL to do Database testing and in validating the front-end functionality.
• Identified the regression test cases for the front end application and created scripts to automate these regression scripts to run in QA Wizard Pro tool.
• Also, wrote and maintained UNIX shell script to execute set of ETL Regression SQL queries which helped the team to identify any errors in ETL Transformations of existing mappings when a new change is being migrated to QA.
• Worked on up gradation project of MICROSTRAGEGY 8 to MICROSTRATEGY 9.

Technologies: Informatica 8.x, MicroStrategy 8.x, Oracle 10g/11g, QA Wizard Pro 2009, Windows NT and UNIX.

Confidential, Silver spring, MD (March-2008 - Dec 2008)
Applications Tester
VZBDW-FINTRAN / VZBDW
VZBDW is a Teradata Database Warehouse which provides Enterprise Business Solutions, Customers & Products Data. Data for this Warehouse is entirely sourced from VZ450 VAM Gateway and from Non-VZ450 Federal Sources Systems. This ware house provides the Data for Billing Systems, AR Systems for
f-MCI, f-ESG, Finance. Data is loaded on regular basis based on the System and Cycle of the process. Capacity of the ware house is 40 TB. This warehouse provides the data for Different Data marts for meeting the business requirements in Verizon.

Responsibilities:

• Involved in Design analysis, Debugging and Maintenance of Verizon Business Data Warehouse.
• Created Test Plans and Test cases and Test data sets based on the business requirements and pariticipated in the Test Plan review with the team.
• Identified tasks and provided the work estimation to the team.
• Used the SQL test cases to validate the test data set for its data quality and reviewed final test results to check whether it meets the business requirements.
• Involved in researching the Billing issues and providing the inputs to development team for long term fixes for Revenuevz450, Revenue, and for Adjustments and Payments systems.
• Managed the defect tracking process using ClearQuest.
• Responsible for maintaining and writing documentation related to the project.
• Provided the update on the testing status on a regular basis.
• Prepared the release readiness document for the functionality tested and the bug fixes tested.
• Used FastLoad, MLoad for loading data into testing environment.
• Used Autosys for job scheduling.
• Written stored procedure for the Ware house functions which includes Cleaning up of the warehouse tables.

Technologies: Teradata SQL Assistant 7.1, Fast Export, Teradata SQL, Stored Procedures, ClearCase/Clearquest, Autosys

Confidential, India (June 2004 - Dec 2007)
Client: Confidential, San Diego, CA
Teradata Developer/Tester
Confidential, is a leading global technology company helping businesses build stronger relationships with their customers. NCR\'s Teradata data warehouses, ATMs, retail systems, self-service solutions and IT services provide Relationship Technology that maximizes the value of customer interactions and helps organizations create a stronger competitive position.

Responsibilities:

• As a developer and tester, I was involved in feature test case development, testing and bug fixing.
• Worked in creating extensive test cases for Table Functions and Table Functions Kanji
• Wrote extensive SQL queries
• Involved in executing the test cases in different platforms like MPRAS, WINDOWS,UNIX and LINUX and had good knowledge about the PTE tool (Parallel Testing Environment)
• Handled the customer defect report.
• Used Unix Scripts to schedule the Test cases.
• Effectively involved in developing the RFC for show table query.
• Documented Teradata Installation Procedure for MPRAS, WINDOWS and LINUX for development team.

Technologies: Teradata, SQL, C, UNIX, LINUX