Professional Summary:

• 13 years of experience in IT/software industry proficient in Data Analysis and Quality Assurance.
• Expertise in testing FP A-HR Product, Biotechnology, Banking, HealthCare, Telecom Billing.
• Testing and Analysis of diverse applications such as Oracle Retail Supply Chain, AMDOCS CRM, HealthCare with Kaiser Permanente ,Genomic Health and HR Product with TRINET
• Explored big data tools in Hadoop 2.0 with traditional RDBMS EDW implementation for data.
• Created/Developed PL/SQL, QTP, selenium Eclipse-Java, Perl, Javascript AUTOMATED scripts which runs in the background to expedite the results using Database.
• Strong at SQL Queries in validate the new Business logic in the ETL packages , fine-tuning SQL queries, procedural PL/SQL with Database/Backend testing using Oracle 11g/SQL Server 2008/2005, Hyperion Essbase. and provide test Data for Mobile testing
• Documenting Test Plan, Strategies, Estimation, Metrics, User Documents and Daily Status Reports for Both in Agile and waterfall
• Validating Enterprise Data Warehouse Products, Finance, Sales, Commercial and HR data using ETL Tools like SSIS, SSAS, Informatica, and ELT Tools like ODI, BIDS and Data Analytical/ Dashboard Reports using SSRS, Business Objects, Cognos and Tableau.
• Coordinate with various Stakeholders in planning, execution and documenting the testing requirements.
• Good in Unix Shell Scripting validation Perl, K-shell .
• Over 9 years of experience Leading the offshore team in an onsite-offshore model.
• A proactive team player with strong communication skills and belief in synergetic relationships.
• Ability to work on Multiple projects and new product or business domain with minimum supervision.

Technical Skills:

ETL: Informatica Power Center 8.x/7.x/6.2, SSIS, SSAS, ODI 11

Database: Oracle 11g, SQL Server 2008/2005, Hyperion ESSBASE, IBM DB2

Languages: C, C , JAVA, SQL/PLSQL, Visual Basic.

Testing Tools: QTP, Selenium IDE/RC, Test Director, Rational Robot, Rational, Clear Quest, PVCS Tracker, Clarify Inc., FOCUS

Operating Systems: Windows XP/7, UNIX AIX , IBM AIX RS6000, BEA Tuxedo 7.1, AS/400.

Others: FTP, Telnet, CVS, Clear Case, Source Offsite, Shell scripting k shell

Reporting Tools SSRS, Cognos 10.5, Tableau 6.0, Hyperion ESSBASE BSO , Business Objects.

Internet Technologies: JavaScript, VB Script, Perl Scrip

Confidential

ETL Data Quality Analyst

Confidential HR Corporation is HR Product Company which provides services such as payroll, benefits, worker's compensation, and strategic human capital services. Confidential helps these companies contain HR costs, minimize employer-related risk, and relieve the administrative burden of HR.

• Validating the PeopleSoft Finance Planning and Accounting FP A , HR and Payroll data with various businesses rules and populates the data to Oracle through ODI and generates Cognos Reports and Dashboards for BI analytics.
• Validate DB scripts ,ETL ODI , PeopleSoft Source and Oracle Target Tables and ensure the data is Loaded/transformed to target with defined business rules.
• Validate Cognos Reports single/multi-layer tier down structure and summary and details reports and Dashboard.
• Validate data from the Hyperion ESSBASE BSO Block Storage option . Analyze the previous months finance planned/Forecast data.
• Create Master Test Plan, Test Matrix ,Results, progress incidents, defects and other quality metrics
• Validate and Tested multiple levels of security with the reports and Analytics.
• Developed Automated scripts using QTP.
• Lead 4 member QA offshore team.

Technical Environment: Oracle Database 11g, Oracle Data Integrator 11, Cognos 10.5, QTP 11.0, Hyperion Essbase ASO/BSO Analytics

Confidential

Business Intelligence/ETL QAanlyst

Confidential is an oncology-based health care services company providing individualized genomic analysis of tumor biopsies. Non-clinical IT activities include the test data development, data validation for the Finance and revenue modules and also for commercial, Sales SSRS Reports, Data validation in SSIS, and Analytic Tool.

• Validating the Enterprise Data Warehouse, Data Mart Data various line sales, commercial, customer service, executive, financial reports and validating data for ETL, OLAP Cubes, SQL script and Reports.
• Validate single/multi-layer with tier down structure and summary/details with SQL 2005 /2008/2012 Integration SSIS , Analysis SSAS and Reporting SSRS Services and Tableau Dashboard, DQS.
• Validating SSIS ETL packages, mapping validation, ETL job, batch process automation for the new changes in Data warehouse, Operational Data and Documenting Data Mapping Document.
• Creating various functional test scripts and test scenarios to check Count, Dimensional data, Factual data is populated as per requirement.
• Explored big data tools in Hadoop 2.0 ecosystem for solving scalability issues with traditional RDBMS data warehouse implementation for data.
• ETL validation using SQL scripts for testing the both in various environment for both Functional and Regression in SSRS reports and SSIS ETL packages and various stored procedures.
• Validate T-SQL and create Test Data to get the test results for various test scenarios.
• Delegate and coordinate work to 4 member offshore team and validate the deliverables quality against the business requirements with Results and deadline drive. Conduct on call meetings with offshore with Daily standoff meetings.
• Tested Field Sales Force Mobile app for Sales territory and ensure the data reflected as per requirement.
• Expertise in documenting Test Design, Test Strategies and Status Report Word, Excel, PowerPoint and Visio and Leading the 4 member offshore-team.

Technical Environment: MS SQL Reporting Services SSRS , MS SQL Integration Services SSIS and/or MS SQL Analysis Services SSAS , SQL SERVER 2005/2008, Perforce, MS TFS, TABLEAU 6.0,MS DQS,QTP11.0

QA/Data Analyst

Confidential Wholesale/Non-wholesale customer/account data is migration. The Migration is by US State by State from East to West States., over-lapping markets.

• Created automated test script using PL/SQL and UNIX K-shell for the ETL Mappings from source to target for all the requirements in BRD.
• Validating the Oracle PL/SQL, T-SQL script and data to ensure the data is populated as per the requirements.
• Validate the Informatica mappings, job and transformations and ensure the SQL queries populate the same data as mapping.
• Validate the data in QA staging Area and ensure the required data is populated in Target tables
• Validate Summary/Detail and Exceptions Report for various requirements like wholesale accounts, zero balance, Manuel Feed, RDC to CEO Remote Deposit Capture to CEO Desktop Deposit bank accounts.
• Developed automated Oracle scripts SQL, shell scripts and Perl to validate data in the extract files are same as the data in the database.
• Validate the data is in-par with different environments like development, SIT, UAT and PROD Servers and analyzing the data and Involve Monthly or bi monthly in production releases
• Validate various JIL jobs, sequence of the execution of loading data into staging and deploying.
• Rejected rows and error rows are captured and created as Exception report to identify/ opportunities/cleanup and create new potential mapping adjustments.
• Delegate and coordinate with offshore team on the assigned work.
• Publishing reports and documentation for intranet knowledge server.

Technical Environment: UNIX, Informatica Power Center 7.1/6.2, Oracle 10g, Shell scripting k shell , Cognos, Business Objects, Perl.

Data/QA Analyst

Confidential various domains like Investment banking, Assets Management, Brokerage systems is being integrated with Wells Fargo Bank. To convert the Wachovia source data from various sources flat files/databases like Oracle, SQL Server and DB2 to DB2 Databases within the Client.

This initiative involves the following:

• Reviewing and analyzing requirement and product specifications, developing and executing test plans, test procedures and test scenarios.
• Validating the DB2 extract script and data to ensure the data is populated as per the scripts.
• Validate the ETL mappings, SQL queries and different ETL transformation.
• Developed automated PERL scripts to validate data in the extract files are same as the data in the database.
• Coordinated with Business Analysts both teams to synchronize the data across various systems across the Project.
• Performing different verification, validation and end to end testing different delimiter extract files and SQL scripts.
• Run complete test cycles for each product release monitoring and analyzing test results, collecting test metrics and conducting test reporting.
• Publishing reports and documentation for intranet knowledge server called as wiki pages.
• Writing complex SQL queries to analyze source data and communicating data quality issues to the business

Technical Environment: UNIX, Informatica Power Center 7.1/6.2, DB2 7.6, Oracle 10g, PlanView and SharePoint, PERL

QA Analyst

Confidentialintends to Convert/Migrate legacy business applications and databases from AS400 environment to a new UNIX based environment with Oracle Retail Application replacing the legacy business applications.

This initiative involves the following:

• Preparing requirement analysis QA Analysis documents to pull the existing legacy data DB2 to the Oracle Retail 9i UNIX based application.
• Provided Test Plan and executed test cases compared the expected results with the actual and validate the discrepancy and document the defects in MQC.
• Implement test automation for web applications from front to backend using Selenium and Junit
• Coordinated with Test Data Management Group to synchronize the data across various systems across the Project.
• Mentoring Partnered with other QA engineers to ensure standards of quality were maintained on all projects, attended test set reviews providing guidance, stayed abreast of QA industry practices and taught out to other testers and developers.
• Release management - Lead requirements for software configuration and build processes for test environments. Test environment connectivity with multiple POS systems.
• Assigned worked to IBM Offshore team and validate the deliverables quality against the business requirements.
• Prepare Automated Test Cases and Test Plan as per the Detail Design document both functional and technical designs. Loading and testing the Autosys Job Scheduling, UNIX Batch Process.
• Ensures that SOAP web services and testing XML Messages on IBM MQ actually meet business expectations. Report RationalClear Quest for defect Tracking and generated defect summary reports.
• Followed up with development team to defects during the conversion process while ExtractTransfer and Load ETL process.

Technical Environment: Java, Unix IBM - AIX , Informatica Power Center 7.1/6.2, Oracle 9i, JavaTM 2 SDK, J2RE 1.4.5, JInitiator, Gray Box, Web sphere, Selenium, QTP, Junit, Toad, In-house DB2 systems Operation Data Store, Enterprise Data Warehouse and JDA Replenishment system, Oracle 360 POS, Yantra, Rational ClearQuest, Rational Test Manager, Rational Functional Tester, PlanView and SharePoint centralized doc management , DbVisualizer, AutoSys.

KPIC Kaiser Permanente Insurance Company Analyst

• Fine tuning and troubleshoot defects in the application using SQL queries and stored procedures.
• Creating new KPIC and HMO documents based on the requirements. Maintaining and enhancing the existing templates using AuroraDS Idworkstation.
• The Solution offers benefits of maintaining and viewing of the contracts and dynamically generating the reports.
• Extensive knowledge Kaiser's Healthcare core Foundation system Module.
• Coordinate with various business analysts from Benefit, Contract and PDM group.
• Maintaining the KPIC application from year 2004 to 2006.
• Created and testing new PLAN Id that is added and creating new Template for KPIC new/PPO/OOA plan as publishing the document.
• Create and validate new custom plan for KPIC and KFHP.
• Develop test scripts verifying different aspects of the complex web application using QTP.
• Supplement company bug-tracking system with new discovered defects and update status of existing bugs.
• Involved in Requirement Analysis, Design, Development, Testing during defect fixes and maintenance Phases for CPMS project which was developed using ASP.Net.
• Involved in GUI web based Testing and also GUI-less Web services.

Technical Environment:Aurora DS ID Workstation , Visual Basic 6.0, SQL Server 2000, QTP, Test Director, ASP.Net

DST Innovis AMDOCS

Confidentiala Customer Management based application for Cable TV Telephony Subscribers. To fix the bug identified by DST QA, SATYAM-QA the ITC Users. It comprises of many modules like Order Entry Processing, System Management, Money Processing, Addressability Management, Charging, Telephony, MCOS Mass Change of Service etc. Company provides integrated customer management software to utilities such as Telephony, Broad band and Cable customers.

• Worked with the Same Client for 4 years in Offshore-Onsite model. Part of the both Offshore and Onsite teams.
• Study and organize the defects based on the severity and Assign it to concern offshore team members.
• Study Cable and Telco packages like DDP Financials, and QuickData software packages.
• Involved in fixing the client reported defects without affecting the original code and also was involved in the enhancement of the product and testing the product
• Study the required changes in the DDP/SQL module.
• Responsible for the analysis products or releases for UNIX/AIX based Intelecable, Tandem/Oracle based DDP/SQL, and High Speed Data Service API for ATHOME.
• Committed to excellence and the highest standards in product quality and customer satisfaction.
• Versatile and flexible professional with a 'can-do' attitude.
• Solid understanding of test plan development and execution using black box, white box, and exploratory testing techniques.
• Created and implemented training classes with knowledge needed for new team members to train for the CDAC certification.
• Achieved Sustained Performance and Loyalty' Awards for consistent performance and long service.
• Interactive with Clients for further understanding of the defects and log the details in the defect tracking system.
• Conducted functional, integration, performance and regression testing of the entire application using Rational Robot.
• Ensure the Defected Tested and Log the Results.
• Tested and Implemented Provisioning software for HSDS and VoIP projects.

Change Request Fixing

Technical Environment: UNIX AIX , C, JavaScript, VBScript, Oracle 8i,Nonstop Server Tandem utilities, Tuxedo, Oracle 8i, MS Office, SQL, SQL Plus, Mercury/Quality Center, XML, Clarify, TOAD, UNIX, J2EE GUI applications, DDP SQL, :C, Pro C, XML, COM, VC JavaScript, Oracle 8i, UNIX AIX , Windows NT/2000