SUMMARY:

• Over 11+ years of IT experience on the implementation of various projects from analysis, involving manual and automated testing.
• On an onsite - offshore model, ensuring to keep up with SLA’s, deliverables on a day to day basis that includes Production Support management & Development projects.
• Expertise in Analysis, design, development, testing and Implementation of Business Intelligence solutions using Data Warehouse/Data Mart Design, ETL, OLAP, Client/Server applications.
• Experience using query tools for Oracle, DB2 and MS SQL Server to validate reports and troubleshoot data quality issues.
• Experience in testing methodologies which includes, test plan development, test case development, test case execution, test results analysis, and defect reporting, that application processing complies with business and technical specifications
• Expertise in defining Test Strategies, writing detailed Test Plan and Test Cases, Defect Tracking and Defect Reporting using Mercury Test Director and Quality Center.
• Extensive experience in Database Testing in DB2 and Oracle using SQL.
• Extensive experience in Data validation and verification in all ETL Stages (Source, Staging and Target environments).
• Experience on different types of Testing like Integration, System, Functional and Regression Testing.
• Experience in assisting the customer in User Acceptance Testing (UAT).
• Extensive testing ETL experience using Informatica (Power Center/ Power Mart) (Designer, Workflow Manager, Workflow Monitor and Server Manager)
• Extensive Working experience in applying Relational Database concepts, Entity Relation diagrams and Normalization concepts.
• Experience in Performance Tuning of SQL and Stored Procedures.
• Automated and scheduled the Informatica jobs using UNIX Shell Scripting.
• Application Data warehousing experience in Financial, Insurance and Healthcare.

TECHNICAL SKILLS:

Manual Testing & Environment: Client Server, Web Based, ERP, BPM and Mainframe environments with SQL, DB2 and Oracle as Databases.

Automated Testing & Tools: WinRunner, QTP, Test Director and Mercury Quality Center

DW Tools: Informatica Power Center 8.1/7.1, Ascential DataStage, Cognos and Business Objects

Management Tools & Languages: MS Project, Rational Clear Case / Quest, Visual Source Safe, C++, VC ++, Java Script, ASP, HTML, COBOL

Operating Systems: Unix, WIN XP/NT and MVS/ESA

Database Query Tools: TOAD, WinSQL, RapidSQL, SPUFI and QMF

Mainframe Environment: TSO / ISPF, IMS/DC, CICS, JCL, VSAM, Endevor, Changeman, File-Aid, Xpediter, Intertest, CA-7

PROFESSIONAL EXPERIENCE:

Confidential

QA Testing Lead

Responsibilities:

• Worked on onsite offshore model, managed multiple projects parallel and coordinating with multiple teams involved and getting the work done.
• Extensively worked on multiple WGS Systems - Capitation & Claims areas.
• Preparing project test strategies which include test scope, schedules, test data, environment readiness & resource.
• Participate in all meetings planned for particular release with Business Analysts and Development teams to understand the business requirements and giving the estimates from testing prospective.
• Review the design, functional & technical requirements with business analysts and dev teams to understand the test needs from both design and data perspective.
• Test Design & Test plan preparation, preparing daily status reports and running defect triage meeting.
• Involved in prioritizing the requirements according to business needs and putting all the requirements in QC.
• Performed various automated tests and ensured continuous regression tests on systems.
• Maintain and monitor the defect & error logs for all issues identified.
• Involved in writing and executing the test cases for testing the new functionalities and system changes.
• Involved in identifying the cause of Defect and reporting the same to developers.
• Participate in business meetings with end users and work with the architects in analyzing and designing the client's requirements.
• Preparation of technical specifications as per the functional specifications and the business needs.
• Involved in Defect reporting and verification.
• Involved in identifying the cause of Defect and reporting the same to developers.
• Test plan preparation, preparing daily status reports and defect reports.
• Involved in production support activities and bug fixes.
• Documenting test procedures, test plans, test cases and test results.

Environment: RQM, Mainframes, DB2, RTC, Clear Quest, Clear Case.

Confidential

Lead QA Analyst

Responsibilities:

• Interacting with Business Analysts and Development teams to understand the business requirements and giving the estimates from testing prospective.
• Test plan preparation, preparing daily status reports and defect reports.
• Involved in prioritizing the requirements according to business needs and putting all the requirements in QC.
• Involved in identifying the cause of Defect and reporting the same to developers.
• Worked with ETL group for understating mappings for dimensions and facts
• Validating the data between Tera Data Staging and EIS Data Store by using SQL Statements.
• Extensively used Informatica power center for extraction, transformation and loading process.
• Testing the data present in fact tables and dimensions tables.
• Involved in Data Validation, Data Conversion and Data Reconciliation Testing.
• Involved in HUT (Hard unit testing), SIT (System Integration Testing)
• Attending defect triage meetings.
• Involved in Currency Validation Testing.
• Involved in Defect prevention, productivity improvement and knowledge management activities
• Preparing metrics and reports.
• Documenting test procedures, test plans, test cases and test results.
• Wrote complex SQL syntax using case, having, Group by etc
• Excellent knowledge on Agile Methodology.

Environment: SAP BW, SQL Navigator 5.0, Informatica Power Center 8.6, (Power Center Designer, workflow manager, workflow monitor), Quality Center 9.0, Oracle 10g, UNIX

Confidential , MN

Sr Programmer Analyst

Responsibilities:

• Analyzed the Specifications and involved in identifying the source data needs to be moved to data warehouse.
• Created technical specifications from source to target in absence of technical lead.
• Extracted data from various sources and to targets like Flat files, Oracle, Teradata
• Written several hundred’s of complex SQL statements to validate the data against different target systems including Oracle and Teradata
• Transformed and loaded the data into target database (Teradata) using Informatica Power Center.
• Worked on SQL tools like TOAD, Rapid SQL to run SQL queries to validate the data.
• Extensively used Informatica Debugger for testing the mapping logic during Unit Testing. Performed unit testing, integrated testing and validated results with Business Analyst and/or customer.
• Involved in FTP process to transfer the files from one server to other.
• Performed quality control analysis and validates results of conversion programs. Used extensive SQL query. Evaluated actual data load results. Involved with high volume testing
• Implemented SDLC, QA methodologies and concepts in the Project
• Completely involved in Developing Test Plans and Developed Test Cases/Test Strategy with input from the assigned Business Analysts
• Extensively used Mercury Quality Center (TEST DIRECTOR) and Created Test Cases in the TEST PLAN according to the specifications.
• Used TEST LAB to run the Test cases.
• Reported Defects and prioritized outstanding defects using TestDirector/Quality Center.
• Created the test data & Coordinating with Developers/Leads in resolving bugs.
• Clearly communicated and documented test results and defect resolutions during all phases of testing.
• Stimulated several production cycles. Worked with data validation, constraints, record counts, and source to target, row counts, random sampling and error processing.
• Created Daily, Monthly, and Quarterly Schedules using Maestro Scheduling Tool.
• Created Maestro Jobs to execute UNIX Shell scripts, SQL Scripts, Informatica Workflows etc.
• Created dependencies on Jobs, Job Streams and monitored the Maestro Flow for Daily, Weekly and Monthly jobs.
• Executed Maestro Jobs using Composer and Conman Commands

Environment: Pega PRPC, Oracle 9i/10G, Flat files, PL/SQL, TOAD 8.0, SOAP UI, UNIX, Maestro 8.0 (Tivoli Work Scheduler), Websphere, Test Director/Quality Center, SUN SOLARIS.

Confidential, MD

Programmer Analyst/Tester

Responsibilities:

• Responsible for Business analysis and requirements gathering.
• Designed and developed UNIX shell scripts as part of the ETL process to automate the process of loading, pulling the data for testing ETL loads.
• Tested different detail, summary reports and on demand reports developed by Report Studio.
• Reported bugs and tracked defects using Quality Center 8.2 (Test Director)
• Performed the tests in both the SIT, QA and contingency/backup environments
• Performed all aspects of verification, validation including functional, structural, regression, load and system testing
• Strong ability in developing advanced SQL queries to extract, manipulate, and/or calculate information to fulfill data and reporting requirements including identifying the tables and columns from which data is extracted
• Tested several data migration application for security, data protection and data corruption during transfer.
• Worked as liaison between support team, business and development team for resolving multiple issues during test execution and data loading.
• Worked with Data Conversion projects for testing data quality after migration.
• Experienced using database query tools for Oracle, SQL and UNIX such as TOAD, Teradata SQL Assistant and SQL Plus.
• Experienced in data analysis using SQL, PL/SQL and many other queries based applications.
• Written several UNIX scripts for invoking data reconciliation.
• Validated documented user requirements.
• Involved in extensive DATA validation using SQL queries and back-end testing
• Validated business reporting requirements with internal and external customers.
• Used SQL for Querying the DB2 database in UNIX environment
• Tested the Oracle Applications and Portals like Executive Dashboard, Bank One Portal built on Oracle. Used TOAD Software for Querying ORACLE.
• Performed periodic checks to run crosscheck against QA/SIT/PROD environments to ensure it is up and running.
• Validated the reports to make sure all the data is populated as per requirements.
• Performed front-end testing on JPMC Portal and Executive Dashboard portal
• Tested Analytical Data Mart (ADM) of Oracle system and Stored Procedures
• Tested Operation Data Store process of ODS/DWL product
• Used workflow manager for session management, database connection management and scheduling of jobs.

Environment: Informatica Power Center 8.1/7.1, (Power Center Designer, workflow manager, workflow monitor), SQL, PL/SQL, Quality Center 8.2, Oracle 10g, SOAP UI, Report Net, UNIX, Windows 2000, TOAD

Confidential, New York, NY

Data Analyst/Tester

Responsibilities:

• Involved in Business analysis and requirements gathering.
• Assisted in creating fact and dimension table implementation in Star Schema model based on requirements.
• Performed segmentation to extract data and create lists to support direct marketing mailings and marketing mailing campaigns.
• Develop ETL test plans based on test strategy. Created and executed test cases and test scripts based on test strategy and test plans based on ETL Mapping document.
• Preparation of technical specifications and Source to Target mappings.
• Extensively used SQL programming in backend and front-end functions, procedures, packages to implement business rules and security
• Wrote UNIX Shell scripts for back up and running batch files and perform quality assurance and validation on the transported data and reports.
• Experienced using query tools for Oracle to validate reports and troubleshoot data quality issues.
• Solid testing experience in working with SQL Stored Procedures, triggers, views and worked with performance tuning of complex SQL queries.
• Developed scripts, utilities, simulators, data sets and other programmatic test tools as required executing test plans.
• Effectively communicate testing activities and findings in oral and written formats.
• Extensively used Informatica power center for extraction, transformation and loading process.
• Worked with ETL group for understating mappings for dimensions and facts.
• Extracted data from various sources like Oracle, flat files and SQL Server.
• Designing and creation of complex mappings using SCD type II involving transformations such as expression, joiner, aggregator, lookup, update strategy, and filter.
• Optimizing/Tuning several complex SQL queries for better performance and efficiency.
• Created various PL/SQL stored procedures for dropping and recreating indexes on target tables.
• Worked on issues with migration from development to testing.
• Designed and developed UNIX shell scripts as part of the ETL process, automate the process of loading, pulling the data.
• Validated cube and query data from the reporting system back to the source system.
• Tested analytical reports using Analysis Studio

Environment: Informatica Power Center 7.1 (Power Center Designer, workflow manager, workflow monitor), SQL *Loader, Cognos 7.0,Oracle8i, SQL Server 2000, Erwin 3.5, Windows 2000, TOAD 7.