SUMMARY

• A result - oriented professional wif strong industry experience in Business Analysis/Quality Assurance, major strengths include excellent communication, organization, and people motivating skills, outstanding organizational development and strategic planning capabilities; and proven track record in delivering results for multiple concurrent projects on time, interpersonal skills and an ability to effectively interact wif technology as well as business counterparts.
• Above 8 yearsof experience as Data Warehouse BA/QA Analyst.
• Experienced in all phases of teh Project/Software Development Life Cycle (SDLC) including analysis, design, development, testing and implementation of software applications.
• Well versed wif Functional Design Documents (FDD) based upon overall Project requirements.
• Facilitating Joint Application Discussions (JAD), walkthroughs and brainstorming sessions wif development team, QA team, technical Advisory teams and business users.
• Analyzing bugs, interacting wif QA/development teams in fixing errors and User Acceptance Testing (UAT) methodologies to validate teh product before implementation
• In depth knowledge of Testing methodologies, Concepts, Phases, and Types of testing, developing Test Plans, Test Scenarios, Test Cases, and documenting test results accordingly after analyzingBusinessRequirements Documents (BRD),Functional Requirement Specifications (FRS).
• In-depth knowledge of Database, experienced in back-end testing by writingcomplex SQL Queries.
• Expertise in Transact-SQL (DDL, DML), Views, Efficient Normalization, Stored Procedures.
• Knowledge in developingStored Procedures, Views, Triggers and Complex Queries on SQL Server, Oracle, Teradata
• Knowledge of Business Intelligence (BI) Tools, Data Warehouse Applications, OLAP Analysis, and reporting Tools like Business Objects, SSRS and Micro strategy.
• Understanding of Data Models,Data Schema,ETLand created extensive store procedures, SQL queriesto perform back-end data warehousingtesting.
• Experienced in Bug Reporting and Defect tracking using tools like Quality Center and Test Director to log and regress bugs; analyzing actual against expected results.
• Strong analytical, dynamic trouble-shooting and requirement traceability skills.
• Experienced in interacting wif Clients, Business Analysts, IT leads, UAT Users and developers.
• Extensive experience using project management tools like MS-Project for status reporting, planning and ability to develop and maintain detailed project plans (work breakdown structures)
• Dynamic and Assertive team player wif strong commitment
• Ability to learn new technologies and methodologies quickly.

TECHNICAL SKILLS

Databases: Oracle 8i/9i/10g, MS SQL, SQL Server, Teradata

Development Methodologies: Waterfall, Agile/Scrum

ETL tools: Informatica Power center 8.X/7.X, Ab Initio

Reporting Tools: Business Objects, Xcelsius, Microstrategy 9.0, SSRS, Cognos

Testing Tools: Quality Centre, VSTS, QTP, Test Director

Data Access Tools: TOAD, Teradata, Unix

Programming Languages: C, C++, HTML, JavaScript, SQL, PL/SQL

Business Process Modeling Tools: MS Visio, Rational Rose 6.0

Project Management Tools: MS Office 2000/2007, MS Visual Studio, MS Visio, MS Project

Operating Systems: MS DOS, Win 98/2000/XP

BUSINESS SKILLS

• Solid background in Business Analysis, Strategic Planning, Gap analysis and Cost/benefit analysis.
• Proven leadership, management, and functional skills.
• Strong skills in Analytical Problem Solving, Time Management skills, Decision-making, Quantitative Skills/Working wif Numbers and Team work.
• Excellent Communication, Analytical, Interpersonal, and Presentation skills.
• Excellent team player wif ability to think analytically and troubleshoot issues.
• Have an extensive work experience in a multiracial and multiethnic work environment.

PROFESSIONAL EXPERIENCE

Confidential, OH

Business Analyst

Responsibilities:

• Involved in initial requirement sessions and analyzed Requirements from Compliance standpoint
• Work closely wif teh Users to identify teh gaps/issues wif respect to Bridger feeds, if any
• Identify/Resolve teh root cause for teh defects/issues raised by teh users
• Plan and define teh Development/QA timelines based on teh overall Project efforts.
• Interacted wif Tech team to ensure teh Codes are defined as per teh business expectations.
• Coordinated wif Tech/QA Team on a regular basis to ensure teh requirements are clear and understood by all
• Reviewed teh Technical Specs/Test Strategy and teh Test Scripts and ensured these meet teh Business expectations.
• Validated teh Bridger files/tables from BA standpoint per teh defined requirements
• Executed SQL scripts to ensure existing functionalities does not break due to teh Changes/new project requirements
• Act as teh single point of contact between Project Team, Development and Testers.
• Ensure teh timely delivery of different Project milestones.

Confidential

BO Test Lead

Responsibilities:

• Understand teh testing effort by analyzing teh Number/Complexity of reports to be tested.
• Plan teh Strategy and Test Plan/Approach, and define teh Test Scripts to be executed
• Ensure content and structure of all Testing documents / artifacts is documented and maintained.
• Organize teh testing kick-off meeting, Daily Status & Defects triage meetings on a daily basis.
• Assign task to Onsite Testing Team and ensure dat they deliver quality work as expected on time.
• Act as teh single point of contact between Project Team, Development and Testers.
• Responsible for Smoke Testing, Report Metadata Validation (Structure, Layout, Formatting etc.)
• Ensure dat Report functionalities (Prompts, Filters, Schedule, and Export etc.) are not adversely impacted along wif teh Data Validation due to teh migration efforts.
• Track and prepare teh report of testing activities like test testing results, test case coverage, required resources, defects discovered and their status, performance baselines etc.
• Ensure teh timely delivery of different testing milestones.
• Prepares / updates teh metrics dashboard at teh end of a phase or at teh completion of project.

Confidential, OH

DW Test Lead

Responsibilities:

• Understand teh testing effort by analyzing teh requirements of project.
• Estimate and obtain management support for time, resources and budget required to perform testing.
• Organize teh testing kick-off meeting
• Define teh Strategy and Test Approach document for releases, gets it reviewed by required stake holders and keeps updating these documents as and when teh changes are required.
• Develop teh test plan for teh tasks, dependencies and participants required to mitigate teh risks to system quality and obtain stakeholder support for dis plan.
• Assign task to Offshore Testing Team and ensure dat they deliver quality work as expected
• Ensure content and structure of all Testing documents / artifacts is documented and maintained.
• Document, implement, monitor, and enforce all processes for testing as per standards defined by teh organization.
• Keep track of teh new requirements / change in requirements of teh Project.
• Organize teh status meetings and send teh Status Report (Daily, Weekly, Monthly etc.) to teh Client
• Attend teh regular client call and discuss teh weekly status wif teh client.
• Act as teh single point of contact between Project Team, Development and Testers.
• Track and prepare teh report of testing activities like test testing results, test case coverage, required resources, defects discovered and their status, performance baselines etc.
• Ensure teh timely delivery of different testing milestones.
• Prepares / updates teh metrics dashboard at teh end of a phase or at teh completion of project.

Confidential, Bellevue, WA

BI Test Analyst

Responsibilities:

• Designed & Drafted teh Test Scenario's, Test Cases and Scripts based upon teh Business Requirements documents, Data Mapping documents and Technical Specifications Documents.
• Collaborated wif QA staff on using documentation standards in teh development and review of Test Plan and test cases.
• Involved in providing teh Testing effort estimates and provided teh timely feedback on progress of teh testing activity.
• Followed up teh timelines wif teh test Plan document and development design documents.
• Wrote & Executed Test Cases and results of Functional Integration Testing for teh Projects Scope.
• Created Test Plans for various phases of teh Projects from different Business Requirements created by teh Project Management, and Business Line Teams.
• Created Test Case documents in MS Excel template from teh Test Plan, and teh Technical Specification documents. And Executed and uploaded teh Test Cases and Scripts in Quality Center.
• Utilized TOAD, SQL Server Management Studio tools for querying and analyzing Oracle and Sql Server databases.
• Tested to make sure dat data is moved from source to target database by writing SQL queries.
• Extensively performed backend testing on databases by writing complex SQL queries.
• Performed extensive manual testing for teh data validation and to ensure dat teh system meets teh requirements
• Focused onData Quality issues/problemsdat include completeness, conformity, consistency, accuracy, duplicates, and integrity.
• Identified & analyzed teh defects, provided documentation to teh development team for debugging.
• Tracked defects through Mercury Quality Center.
• Performed Regressiontestingof teh fixed issues in teh new build until no new issues are identified.
• Updated QA Manager and Lead wif thetestingstatus, which included Test Task Plan, Defect Management, and Test Metrics.
• Maintained teh Requirement Traceability Matrices (RTM) to track teh coverage of Requirements v/s designed test cases.
• Participated in frequently held Defect and testing status report Meetings wif internal QA team on a regular basis.
• Coordinated test activities wif all testing resources
• Documented to support all of teh responsibilities above to Internal Audit requirements.
• Validated teh most granular data items against OLAP systems and identified teh source tables from which teh data warehouse extracts data.
• Extensively worked wif backend activities fortestingseveral reports developed by BI tools. Written several complex SQL queries.
• Tested teh SSRS reports which includes:
• Test teh reports against DB.
• Test teh reports for source to target data
• Tested contexts to ensure teh correct results from teh query.
• Tested teh reports structure to ensure teh tables are properly updated along wif teh database
• Manual verification of data in teh backend using SQL.

Environment/Tools: SQL, SQL Server 2008, Oracle 10.1, Quality Center, Sql Server Reporting Server (SSRS), Manual backend testing, Share Point, Microsoft Office Suite.

Confidential, OH

Business Intelligence QA Tester

Responsibilities:

• Wrote and Executed Test Cases and results of Functional Integration Testing of teh International Currency Conversion Project Scope.
• Data Validation to source at each development layer (base tables to SAP tables, Aggregates to Base tables, views to tables and MSI to views) as applicable.
• Analyzed teh Business requirements wif teh Business Analyst to find Gaps if any.
• Designed & Drafted teh Test Scenario's and Test Cases.
• Executed and uploaded teh Test Cases in Quality Center.
• Prepared Test data for each test case and wrote complex SQL queries for Testing teh ETL Logic.
• Conducted and Participated in Integration Testing, User Acceptance Testing and Regression Testing.
• Prepared teh Regression Test Suite.
• Conducted teh Defect Review and Status meeting.
• Prepared teh Report to indicate teh status of teh project to teh Project Manager.
• Documented to support all of teh responsibilities above to Internal Audit requirements.

Environment/Tools: SQL, Teradata, Quality Center, Micro strategy 9.0, Data stage 7.5.1.A, Manual backend testing, Share Point, Microsoft Office Suite.

Confidential, Bellevue, WA

Sr. Quality Analyst

Responsibilities:

• Conducted walkthroughs wif customers, project management, and development team.
• Created Test Plans for various versions of ERP Reports applications from different Business Requirements created by teh Project Management, and Business Line Teams.
• Prepared test cases, scripts based upon teh business requirements documentation (BRD), use case documentations, and functional requirements specification (FRS).
• Created Test Case documents in MS Excel template from teh Test Plan, and teh Business Requirements documents.
• PerformedData Analysisfor all incoming feeds toETL. Worked wif Business Unit Managers for developing Mapping Document after Data Analysis.
• Tested teh data load process using teh Informatica Power CenterETLtool
• Developed Informatica Mappings/Sessions to populate teh Data Warehouse and Data Mart.
• Error checking and testing of teh ETL procedures and programs using Informatica session log.
• Focused onData Quality issues/problemsdat include completeness, conformity, consistency, accuracy, duplicates, and integrity.
• Used Workflow Manager for Workflow and Session Management, Database Connection Management and Scheduling of jobs
• Worked on Power Center client tools like Source Analyzer, Warehouse Designer, Mapping Designer, Mapplet designer and Transformations.
• Utilized TOAD, SQL tools for querying and analysis of Oracle databases.
• Extensively performed backend testing on databases by writing complex SQL queries.
• Coordinated in developing stored procedures, functions, views and triggers.
• DW was tested for teh row counts and errors after each transaction loads.
• Teh data validations and manual verifications were done in SQL server 2005 and Oracle 9i.
• Point of contact for teh client datatesting, data accuracy and accuracy of functionality.
• Coordinating wif source system owners, day-to-day ETL progress monitoring and maintenance of daily Informatica batch schedule run on a nightly basis.
• Defects were identified, provided documentation to teh development team for debugging.
• Performed Regressiontestingof teh fixed issues in teh new build until no new issues are identified.
• Participated in frequently held Defect Meetings which included Project Management, QA, Development, and Business Line teams and submitted weekly defect and test status updates during teh Defect Management meetings
• Submitted Final Test Report & required documentation for teh project wifin assigned time frame.
• Involved in getting final signoffs from Test Manager and Business.
• Involved in User Acceptance Testing (UAT) wif users and helped users in UAT testing.

Environment/Tools: Oracle 9i/10g, SQL, SQL Server 2005, Business Intelligence tool, Informatica Power Center 8.1/7.1, Manual Testing, TOAD, MS Project, MS Visio, MS Outlook, MS Office Suite

Confidential, Golden, CO

DWH Backend Quality Tester

Responsibilities:

• Participated in business requirement walk through, design walk through and analyzed Business requirements and Coordinated wif teh business analysts and developers to discuss issues in interpreting teh requirements.
• Analyzed teh user requirements, functional specifications and Use Case documents and created teh Test Plans, Test cases for Functional testing.
• Worked closely wif ETL team in each phase of project (data requirement analysis, data field analysis, data mapping and ETL testing)
• Built external mapping to transfer data from SQL Server database to Oracle Data Warehouse. dis includes writingSQLStatements.
• Coordinated in implementing ETL using complex stored procedures on SQL 2005 Server
• Acted as first point of contact for all critical issues related to data mapping and data sourcing
• Reviewed and tested Informatica ETL code
• Involved in Integration Testing, and Data Testing including boundary testing.
• Developed procedures to ensure conformity, compliance wif standards and lack of redundancy, translating business rules and functionality requirements.
• Involved in Performance Tuning of Targets, Sources, Mappings and Sessions.
• Actively participated in Functional testing, System testing, and Ad-hoc testing.
• Analyzed bugs, worked wif development team and ETL team members in fixing defects and validating teh solutions.
• Maintained teh Requirement Traceability Matrices (RTM) to track teh coverage of Requirements v/s designed test cases.
• Interacting & working wif teh development and product management team to find out teh end user actions and scenarios.
• Attended project meetings, release meetings, and QA status meetings.
• Involved in providing teh Testing effort estimates and provided teh timely feedback on progress of teh testing activity.
• Updated QA Manager and Lead weekly wif thetestingstatus, which included Test Task Plan, Defect Management, and Test Metrics.
• Successfully Coordinated User Acceptance Testing (UAT) on each release of teh project wif teh help of end user requirements.
• Involved in doing Business analysis and Requirements gathering for new Informatica maps.
• Coordinate all aspects of teh solution delivery including design, development,testing, and deployment.

Environment/Tools: Oracle 9i, MS SQL Server 2005, Informatica Power Center 8.1/7.1, Data Warehousing, Manual Testing, Rational Rose, MS Office Suite.

Confidential

Quality Tester

Responsibilities:

• Manually tested teh application for a few modules for teh functionality of teh application
• Provided facilitation among cross-functional departments translating new business and market needs to functional requirements
• Created test cases to validate teh functionality.
• Extensive manual testing to ensure dat teh system meets teh requirements
• Involved in User Interface, Functionality, Load, Performance and Security testing, Beta Testing.
• Involved in regression testing of teh application.
• Developed and executed teh test scripts and test cases.
• Involved in tracking defects and creating test summary report.
• Identified and reviewed teh design outputs against teh Design input requirements.
• Assisted QA team in planning and performing User acceptance testing (UAT) for teh all teh modules involved in teh project and ensured they are in line wif both business and functional requirements
• Participated in meetings to update teh status of testing to teh management

Environment/Tools: MS Office, MS Visio, VSTS, HTML, Java, Rational Rose, MS Project, MS SQL Server 2000/2005, UML, MS Access

Confidential

Coordinator Database Application Support

Responsibilities:

• Involved in teh project initiation, working closely wif teh project manager in identifying teh business opportunity, Cost Benefit Analysis and Critical Success Factors
• Worked wif teh technical team in conducting teh technical feasibility of teh system
• Interacted wif clients, project team, stakeholders and business users to gather requirements
• To understand requirements of Application owners, prepare IT Infra setup requirements related to Hardware, Software, and Network etc.
• Prepare total cost of ownership for teh requirement, coordinate for procurement, delivery and installation and post installation maintenance.
• Managing Application wif an Objective to provide maximum Production Uptime.
• Ensure uptime of production system as per business requirement, maintenance of existing IT infrastructure and providing inputs for future requirement (Capacity management), using teh process & policies such as SOX, ISO / CMMI or ITIL and Project Management.
• Created UML diagram such as use case, sequence and activity diagram using Rational rose to represent business workflow
• Provide technical support and solutions on Oracle for trouble free and better performance.
• Provide support and ensure quality wif respect to testing.
• Vendor Management (Application/RDBMS)

Confidential

Quality Tester

Responsibilities:

• Gatheird and documented business requirements, detailed functional design specifications and system documentation
• Worked wif focus groups to seek teh functionalities of teh system
• Created teh Business Requirements Documents and Technical specification Documents
• Used MS Visio to make use case models, activity diagrams, class diagrams, depicting whole business workflows in these diagrams.
• Did root cause analysis (RCA) and suggested solution for data base issues and batch performance related issues using MS Visio
• Made “As Is” and “To Be” systems for teh functionalities
• Extensively performed manual testing to ensure teh quality of teh application.
• Documented business processes in terms of customer service and feedback.
• Assisted in designing test plans, test cases and user acceptance testing.
• Coordinated wif team members on technical and environment related issues.
• Actively participated in resolving user issues, bugs and other production problems after implementation.

Environment/Tools: UML, MS Visio, MS Office, Visual Basic, Oracle, SQL, HTML