PROFESSIONAL SUMMARY:

• Around 8 Years of IT Experience in Data Warehousing Technologies, Data Analysis & Quality Assurance
• Knowledge of Healthcare, Banking, Retail, Travel & Sales
• Strong in Data warehousing concepts, Star Schema, and Snowflakes Schema, methodologies, understanding business process/requirements
• Involved in all the stages of the software development cycle design, specification, coding, debugging, testing (test plan and test execution), documentation and maintenance of the programs
• Extensively worked in Production Support on Designing, Development and Deployment of enhancements using Informatica 8.1, SQL & PL/SQL
• Assisted in designing, planning and managing the data migration process
• Experienced in Functionality Testing, GUI Testing, Compatibility Testing, Integration Testing, Regression Testing, Smoke Testing, System testing, Black Box and White Box testing, Database Migration Testing, Reports Testing, Database Testing & Mobile testing
• Expertise in Developing Test Strategy, Test Plans, Test cases, Test Scripts, and Test Reports
• Proficient in all cycles of test life cycle from test planning to defect tracking and managing defect lifecycle.
• Worked on CRM application - SFDC(Salesforce.com) as Quality Analyst
• Performed Data migration, Data Integration & Implementation
• Worked on both Front End & Back End Testing for Business Objects Reporting Tool
• Experience using query tools for Oracle and MS SQL Server to validate reports and troubleshoot data quality issues
• Experience in writing and executing SQL queries to perform back-end testing for data integration and validation using Oracle & SQL Server
• Extensive experience in conducting User Acceptance Testing (UAT) with the end users
• Experience in Data Analysis, Data Validation, Data Cleansing, Data Verification and identifying data mismatch
• Experience with all phases of Software Development Life Cycle (SDLC) using various module like Waterfall, Agile/Scrum and V-model
• Strong Communication, Presentation and Interpersonal skills with excellent problem solving capabilities

TECHNICAL SKILLS:

Testing Tools: Quick Test Pro 9.x, Quality Center 8.x, HP ALM

Languages: C, C++, SQL, PL/SQL, Shell scripting

Data Warehousing: Informatica 8.x, ER/Studio Data Architect 8.5, Callidus TrueComp 5.2

CRM Applications: SalesForce.Com (SFDC), Ariba Contract Management

Reporting Tools: Oracle Forms and Reports 6i, Business Objects XI r3, Qlik View

Operating Systems: Windows NT/2000/XP/7, MAC iOS, Unix

Databases: Oracle 11i/10g/9.x/8.x/7.x, MS SQL Server, Sybase, MS Access

Defect Trackers: Quality Center 8.x, Bugzilla, JIRA, HP ALM

Other Tools: Sql *Plus, TOAD, SQL Developer, DataMaker, DB data Generator

PROFESSIONAL EXPERIENCE:

Confidential, San Francisco, CA

QA / Data Analyst

Responsibilities:

• Analyze and understand the method of transforming existing data and load into target Ariba system
• Extract data from various legacy system
• Coordinate and execute the data migration activities to migrate master data from legacy systems to Ariba system
• Support different client systems to extract, cleanse and map legacy data into the new format to be loaded to the new system
• Perform data migration validation to verify that data are migrated correctly from legacy system to new system
• Create spreadsheets and macros to enable validation and comparison
• Work and facilitate with business, operations, and technology teams on all stages of the project
• Involved in scrubbing, cleansing and converting data.

Environment: TOAD 9.7, HP ALM, Ariba

Confidential, San Francisco, CA

Data Analyst/ QA Lead

Responsibilities:

• Translate business requirements into test scenarios and test cases
• Responsible for test planning, design and execution of test scripts and cases
• Identify and set up test data requirements based on test scenarios
• Analyze test results and document, report and track defects found in the system
• Mentor junior QA engineers
• Coordinate and review work from offshore
• Provide estimates of work efforts to project stakeholders

Environment: TOAD 9.7, Quality Center 8.2, Informatica 8.6, Business Objects: 12.1.0, Oracle DB, Callidus Truecomp

Confidential, San Francisco, CA

Data Analyst

Responsibilities:

• Assisted product owner in creating user story details and effective acceptance criteria to ensure that user stories are well defined and understood
• Test Scenario creation from use-cases, and Test Case design from design document
• Mobile & Tablet Testing on iOS 4.1/5 and android with Google maps.
• Various browser compatibility testing and Mac/ Windows 7/XP testing
• Preparation of Test Summary report for each sprint release
• Accountable for enforcing a defect resolution process and leading defect triage meetings
• Source data from reports into SFDC backend to UI Testing
• Security testing, ESB Data load Testing and BI report validations.
• Create and maintain test data

Environment: TOAD 9.7, Quality Center 8.2, SFDC, Business Objects: 12.1.0

Confidential, San Francisco, CA

Data Analyst

Responsibilities:

• Work closely with client business teams, vendors & technical team to identify key functionalities & enhancements
• Associated with requirements gathering and Data modeling analysis
• In collaboration with others, Identify, analyze, interpret data from various data marts using SQL queries and develop recommendations based on findings
• Performed End-To-End Testing from loading the data from source files to Target Data in Eligibility Reports
• Develop reports, and presentations of testing results to the various business teams
• Performed comparison to tie data between the data warehouse, TrueComp and reporting
• Analyze and list out the inaccuracies between legacy and current system to the business for synchronization
• UAT and Business user support
• Mock up data in source systems to ensure maximum Test Coverage

Environment: TOAD 9.7, Quality Center 8.2, Informatica 8.6, Business Objects: 12.1.0, TrueComp 5.2, Excel 2010

Confidential, San Francisco, CA

QA Analyst/ETL tester

Responsibilities:

• Analyze User Specification Documents, Business and technical requirements
• Developed Test Plan and Test Scripts based on Use Case & functional requirements
• Performed End-To-End Testing from loading the data from source files to Target Data in BO Reports
• Responsible for defect tracking and reporting the defects in Quality Center and also worked closely with the development team to ensure high quality and timely releases
• Have worked and handling four modules of Project concurrently
• Have been Single Point of Contact for two modules
• Managed new associates and reviewing their work
• Led defect tracking and reporting the defects in Quality Center and also worked closely with the development team to ensure high quality and timely releases
• Verified & Validated the data consistency from Legacy systems to Oracle
• Worked on issues with migration from development to testing for different data loading jobs
• Conducted User Acceptance testing (UAT) to check that the application properly reflects business functions and requirements
• Handled Production support issues

Environment: Windows XP, Oracle 9i, TOAD 9.7.2, Informatica 8.1, Business Objects XI r3, Quality Center 8.2

Confidential, San Francisco, CA

ETL Tester

Responsibilities:

• Performed System testing, Functional Testing, Integration Testing, Database Testing & Reports testing
• Involved in front end GUI testing and also Backend Oracle database validation testing
• Performed Role based testing of reports on Business Objects - Crystal Reports
• Created test cases based on the requirements and test conditions in QC and identified & created test data in order to match with requirements.
• Tested various reports which were developed using Business Objects and validated the data expected versus actual.
• Tested for the compatibility of Reports in Browser (IE, Firefox &Safari).
• Participated in weekly status meetings to discuss the status of the project, review meetings to discuss the bottlenecks and its resolutions

Environment: Windows XP, Oracle 9i, SQL Plus, TOAD 9.7, QC 8.2, Informatica 8.6, Business Objects: 12.1.0, SFDC, Commportal

Confidential, San Francisco, CA

Quality Analyst

Responsibilities:

• Developing Functional and ETL, BO Reports Test Cases, AGGS MGMT Tool in Mercury Quality Center
• Creating Events for various Test Data scenarios in SFDC CRM
• Execution of Functional and ETL, BO Reports Test Cases
• Validation of ETL Mappings in Various DB Schemas, BO Reports, both Front-end and Back-end Testing
• Validation of Case Creation, Case Close & Case Management in Salesforce.com
• Performed various kinds of testing like functional, system, regression, Black Box, Gray box, smoke, ad-hoc, end-to-end, browser compatibility testing
• Role based testing / Security Testing on Business Objects & SFDC
• User Document preparation and Management, UAT Test case Preparation document provided to UAT users

Environment: Oracle 9i, SQL Plus, TOAD 9.7, Quality Center 8.2, Informatica 8.6, Business Objects: 12.1.0, SFDC (CRM), MGMT Tool, Commportal, SAP T & E

Confidential, San Francisco, CA

Quality Analyst

Responsibilities:

• Understanding the Requirements and Functional Specifications of the Application and identifying the required Test Scenarios
• Designed Test Cases based on functional Specification documents, and Use cases, STMs, Creating and executing Test Cases and Compares the actual results.
• Possess extensive hands on experience in creating Test Plan, Test Strategy and Test Cases using Mercury (HP) Quality Center based on the system/functional requirements.
• Understand the database development for this project, Analyzed the database design.
• Preparation of database Test cases according to assigned module, reviewing the database Test cases.
• Performed End-To-End Testing starting from running the Informatics jobs to making sure the data is going into the data base and the application UI.
• Tested the data integrity from Legacy systems to Oracle.
• Perform the Database Testing by writing Complex Queries from SQL, Data validation & Data Verification testing.
• Experience in testing reports generated by the Business Objects.
• Coordinating with the DEV team and acted as a point of contact between the Dev and the QA teams for immediate resolution of the issues.

Environment: Oracle 9i, TOAD, Informatica 8.1, TOAD 9.7,Quality Center 8.2, Business Objects: 12.1.0

Confidential, San Francisco, CA

Developer

Responsibilities:

• Understanding the Business rules completely and implemented data transformation methodologies.
• Involved in testing the E.T.L mapping documents.
• Understanding the Business rules completely and data transformation methodologies
• Involved in testing the E.T.L mappings
• Creating and executing the database test cases for the mappings.
• Creating and executing the functional and data validation test cases for the reports.
• Developing the SQLs from the mappings to validate the data within the Data Warehouse.

Environment: Windows XP, Oracle 9i, TOAD, Informatica

Confidential

Testing & Test Data Management

Responsibilities:

• Write test Scenarios and Detailed Test Steps
• Write Data Requirements and Specific Test Condition requirements
• Create traceability Matrix in QC between requirement & test cases
• Responsible for coordinating with Business for any Clarifications or issues related to the various projects within CBOL and Internet Applications
• Analysis Design Documents, Identify Data needs and create test data
• Prepare testing Metric reports and presents statistical analysis and findings

Environment: Windows XP, Excel Macros, IE

Confidential

Developer & Production Support

Responsibilities:

• Design & Develop Informatica Mappings, Workflows
• Responsible for on-call duties on a rotational basis, including monitoring and resolution of errors and error records
• Write and troubleshoot SQL queries and stored procedures
• Creating technical data mapping specifications to be used by developers
• Resolving the Data issues while the execution of the Production ETLs and ensuring the clean data to subscribers and reporting systems
• Supporting the reporting related issues pertaining to finance raised by End User
• Provide support to Application Tuning Team
• Working closely with clients and Biz to ensure a detailed understanding of the needs
• Design, Development, Testing and Deployment of enhancements
• Reconciliation process across two databases (Oracle and Teradata)
• Participation in critical EDW Finance Month End and Quarter End closing activities
• Unit test business logic and data landing according to source-to-target mappings rules.
• Verify code deployments, ensuring the correct build versions have been deployed to new environments.
• Analyze, evaluate, and document data requirements of business stakeholders and communicate effectively

Environment: Windows XP, Oracle 9i, SQL Plus