SUMMARY:

• Around 11+ years of experience in IT industry specializing in Data Warehousing, ETL, QA Engineer in large - scale Data warehouse Applications including: Data Modeling, Information Systems Design and Development, Data Extraction/Conversion, Client/Server Applications, Database Programming, User Interface, Integration Testing, and Software Testing, Project Management, Technical Delivery, Cloud Technology, CRM SaaS.
• Experience in Project Management/Technical Delivery and PM tools.
• Experience in implementing SDLC Methodologies like Agile, Waterfall and V Model.
• Experience in Cloud Solution Implementation.
• Experienced in structuring and leading project teams towards building quality software products in complex fast paced multi-project environments.
• Experience in Software Quality Assurance and Testing with hands on Software Testing Life Cycle (STLC), System Analysis, QA Processes and Test Methodologies.
• Creation and implementation of a QA Methodology, Test Management Plan, Defect Management Plan, Code Migration Plan, test scripts, automation, overall test policies and procedures and Workflow Processes
• Created and documented the "Build and Release" procedures.
• Implemented and maintained a product-level testing environment including hardware and software
• Forecasted, trained, mentored and built up QA personnel to work and grow as a team
• Determined appropriate tools and environments for automated functional and performance testing
• Experience with the full Software Development Life Cycle (SDLC), which includes Requirements, Planning, Analysis, Design, Agile Development, Testing, Implementation and Support.
• Expertise in working on requirement in Requirement Traceability Matrix(RTM).
• Experience in US-Healthcare, Insurance, Banking, Retail, Mortgage-Accounting and Telecommunication Domains.
• Good exposure to HOGAN CIS (banking software).
• Good exposure to Enterprise Application Integration(TIBCO-BW)
• Good exposure and experience in testing involving XML, HTML, testing message types; HL7 or EDI or XML messages.
• Good exposure to eBusiness application, Order management application, Stock maintenance application.
• Good understanding about the concept of capacity planning, data rollups/aggregation, data standardization, slowly changing dimensions, and data security.
• Experience in working as QA Lead implementing Test automation and mentoring testing team.
• Expertise in Functional, Integration, Regression, Performance Testing and Compatibility Testing
• Experienced in performing System Testing, User Acceptance Testing, Web Services testing, Database Testing.
• Extensive experience in developing Test Plans/Strategies, Test Cases, Test Scenarios and Test Scripts (Manual and Automated) for various applications to ensure proper business compliance.
• Experienced in Confidential quality assurance and testing in Data Warehouse.
• Expert in backend testing using Oracle, SQL on SQL Server databases, DB2 on Mainframe.
• Extensive experience in performing back-end test by developing and executing SQL Queries to verify the data.
• Expert in Manual & Automated testing using Mercury Test tools (QTP) Quick Test Pro, Test Director, Quality Center, Win Runner.
• Experience in using the Rational Too(Rational test Manager, Rational ROBOT, DOORS)
• Experience in understanding Business Process from the requirements and converting them to test scenarios.
• Experience in claim processing system FACETS4.3 & FACETS4.5.
• Excellent knowledge and working experience in Test Execution and Test Result Analysis, Test Reviews and Defect Management (Quality Center)
• Extensive experience in Unit, Black Box, Functional, Performance, Negative, Regression, System integration (SIT), Acceptance (UAT) Testing.
• Good exposure in Product based testing, Mainframes hosted application testing, ERP testing, end to end testing.
• Expertise in Data Warehouse, ETL Verification, BO reports and Universe testing.
• Experienced in web and client/server applications QA in manual and automated testing.
• Expertise in developing and executing of Test cases/scenarios for Performance testing/Recoverability testing/Scalability testing.
• Worked on many Change Orders from client and change control.
• Experience on Quality Improvement Processes. Implemented Client Quality Sigma for clients in UHG.
• Believer of documentation process and have hands on experience on professional documentation during all the phases of development life cycle.
• Good domain Knowledge of Healthcare & Welfare Benefits, Insurance, Qualified Status Changes (IRS Section 125), COBRA Changes & Specifications, HIPAA, Medicare, Payroll, Finance.
• Knowledge of Datawarehouse (OLAP Applications, Dimensional Modeling), ETL & Informatica Power Center 8.x (Designer, Repository Manager, Workflow Manger, Workflow Monitor).
• Good exposure on Informatica Power exchange 8.x for the Change data capture(Archive logs/log miner/listener/condense jobs).
• Interviewed the resources on behalf of the Client.
• A self-starter, team player working on fast-faced development environments committed to the deliverables.
• Flexible and versatile to adapt to any new environment and work on any project.
• Ability to work in a team and as an individual. Possess strong communication, presentation, problem solving and excellent interpersonal skills.

TECHNICAL SKILLS:

Web Technologies: XML, HTML

GUI Tools: Visual Basic 6.0, Developer 2000

Databases & RDBMS: ORACLE 7.X, 8, 9i, 10g, MY SQL, MS Access, DB2, SQL Server 2005,SQL Server 2008

Technologies/ Tools: IBM Mainframes 3270 - JCL, DB2, COBOL, CICS, TSO/ISPF, TOAD,SQL Developer, SOA/SOAP-UI MS Outlook, Lotus Notes, Ultra Edit TIBCO, FACETS- Claims processing application PORTICO- Provider data maintenance application, NASCO- Large group processing application, TerrAlign- Region/location/PCP/Medical panels alignment tool (RCC/LCC/PCP/MedPanel)

Operating Systems: MS-DOS 6.22, WINDOWS ’95,'98 & NT/2000/XP, Unix, ZOS

Languages: C, C++, SQL, PL/SQL, VB Scripting, Unix shell script

Networking: TCP/IP, FTP, UDP, ATM, Ethernet, LAN & WAN

Web Browsers: Internet Explorer 6.0, 5.0, Netscape 7.0, 6.0, Mozilla Firefox 1.5

Testing Tools: Test Director 8.0, Quality Center 8.2/9.1, HPALM, IRize, Bugzilla, LoadrunnerWin-runner, QTP

Data Warehousing Tools: Informatica (Power Center 8x/7x, Power Exchange 8.1.1).

Project Management: Microsoft Project, Clarity, Serena, Primavera Project Planner, Safran Planner

Domain Knowledge: US Healthcare & Welfare Benefits, Insurance, Mortgage-Accounting, COBRA Changes, Qualified Status Changes (IRS Section 125), HIPAA, Medicare, Defined Benefits (DB), Defined Contribution (DC), FACETS, PORTICO, NASCO-NPS.

PROFESSIONAL EXPERIENCE:

Confidential, MD

Sr. Technical Delivery/Project Manager

Responsibilities:

• Plan, schedule and manage long term technical projects.
• Seek multiple department input throughout the major phases of project management: initiation, planning, analysis, build, execution, closeout and monitoring.
• Leading and managing resources.
• Resource Planning/Estimation.
• Identify and schedule project deliverables, milestones, and required tasks.
• Assign tasks, responsibilities and drive accountability to project team members in a matrix environment.
• Provide coordination between multiple technical and business teams including DBAs, Server Administrators, Architects, Infrastructure Analysts, Developers, Operations Analysts and business contacts.
• Utilize accepted project management techniques to develop and maintain project plans and manage project quality.
• Manage project budgets and authorizations for expenditures.
• Complete projects on time and within budget guidelines to ensure company and project objectives are achieved.
• Oversee the development of Confidential FEP Local applications using SQL /JAVA / CRM-SaaS(Cloud Solution)/ Datawarehouse-Informatica.
• Translate technical details for people with varied levels of knowledge.
• Identify and coordinate opportunities for the implementation of best practices, process improvements.
• Coordinate project related change management activities - oversight, scheduling, communication and conflict resolution.
• Provide leadership and direction to client and project teams
• Reviewing the Business Requirements & Technical specifications
• Involved in the design, analysis and testing of the solution/system/application.
• Involved in the estimation of resources.
• Created and reviewed the Test Strategy
• Responsible for test data set up across the test environments across the test phases.
• Process improvisation, setting up/suggesting standards per industry level.
• Implementing new technology oriented processes viz; automated claim creation, test result reporting Automation, regression automation, testing harness.
• Responsible for organizing meetings with the team members to discuss about projects.
• Conducting walkthroughs across the project deliverables.
• Propose and Design the automation approach for the testing and guide the team as and when needed.
• Created Test execution metrics, Defect Metrics for weekly status meeting.
• Conducted weekly status meeting with the Business/Executive team.
• Coordinating with Business for UAT, Status meetings, conduct walkthroughs.
• Created and reviewed the SQL scripts, PL/SQL, SOAP requests (xml/html).
• Mentor the team on a regular basis as and when needed.

Environment: Data ware housing concepts, data modeling, Healthcare, Mainframes, JAVA, CRM-SaaS, JReport, Tibco, Portal-Web-services, Informatica Power center 8.6.1, FACETS4.5/4.7, PORTICO front end application, HP-ALM, Quick Test Pro, SQL Server-2008, MS SQL, XML files, PL/SQL, Oracle 9i, TOAD, UNIX, Perl Scripting, Load Runner, Windows 2000/XP, MS-Project Plan, MS-Office tools, Share point, Lotus Notes, EDI, 837I/P, 270/271, 276/277, 278, 835, UB92, HCFA.

Confidential, MD

Sr. QA/Test Manager

Responsibilities:

• Reviewing the Business Requirements & Technical specifications
• Involved in the design, analysis and testing of the solution/system/application.
• Involved in the estimation of resources.
• Created and reviewed the Test Strategy, test scenarios, test procedures as well as documentation.
• Leading and managing testing resources.
• Resource Planning/Estimation.
• Responsible for test environment setup (SIT/Performance/UAT).
• Responsible for test data set up across the test environments across the test phases.
• Process improvisation, setting up/suggesting standards per industry level.
• Implementing new technology oriented processes viz; automated claim creation, test result reporting automation, regression automation, testing harness.
• Design the Test Schedules for all the test phases(System/Integration/UAT/Regression)
• Responsible for completing duties assigned by the direct manager.
• Responsible for organizing meetings with the team members to discuss about projects.
• Conducting walkthroughs across the testing deliverables.
• Propose and Design the automation approach for the testing and guide the team as and when needed.
• Created Test execution metrics, Defect Metrics for weekly status meeting.
• Conducted weekly status meeting with the Business/Executive team.
• Coordinating with Business for UAT, Status meetings, conduct walkthroughs.
• Created and reviewed the SQL scripts, PL/SQL, SOAP requests (xml/html).
• Mentor the team on a regular basis as and when needed.
• Responsible for Project - Test Reporting on a daily /weekly basis to the senior management.
• Designed/reviewed the test scripts and guided the team.

Environment: Data ware housing concepts, data modeling, Healthcare, Mainframes, Tibco, Portal-Web-services, Informatica Power center 8.6.1, FACETS4.5/4.7, PORTICO front end application, HP-ALM, Quick Test Pro, SQL Server-2008, MS SQL, XML files, PL/SQL, Oracle 9i, TOAD, UNIX, Perl Scripting, Load Runner, Windows 2000/XP, MS-Project Plan, MS-Office tools, Share point, Lotus Notes, EDI, 837I/P, 270/271, 276/277, 278, 835, UB92, HCFA.

Confidential, MD

Sr. QA/Test Manager

Responsibilities:

• Reviewing the Business Requirements & Technical specifications
• Involved in the design, analysis and testing of the solution/system/application.
• Involved in the estimation of resources.
• Created and reviewed the Test Strategy, test scenarios, test procedures as well as documentation.
• Responsible for test environment setup (SIT/Performance/UAT).
• Responsible for test data set up across the test environments across the test phases.
• Process improvisation, setting up/suggesting standards per industry level.
• Implementing new technology oriented processes viz; automated test result capturing tool, test result reporting automation, regression automation.
• Design the Test Schedules for all the test phases(System/Integration/UAT/Regression)
• Creation of Work orders for the SSP-Vendors (Cognizant/Infosys)
• Responsible for handling a team of testing team and supervising their work(onshore & offshore resources)
• Responsible for completing duties assigned by the direct manager.
• Responsible for organizing meetings with the team members to discuss about projects.
• Conducting walkthroughs across the testing deliverables.
• Design the automation approach for the testing and guide the team as and when needed.
• Created Test execution metrics, Defect Metrics for daily status meeting.
• Conducted weekly status meeting with the Business/Executive team.
• Coordinating with Business for UAT, Status meetings, conduct walkthroughs.
• Created and reviewed the SQL scripts, PL/SQL, Perl/Unix Scripts, SOAP requests (xml/html).
• Mentor the team on a regular basis as and when needed.
• Responsible for Project - Test Reporting on a daily /weekly basis to the senior management and OPS-council.
• Designed/reviewed the test scripts and guided the team.
• Interviewing and hiring new resources to the team.
• Working with the project scheduling lead on the Project schedules on a weekly basis.
• Created automated report generation process using VB scripting for the TerrAlign.
• Weekly meeting and walkthrough with Senior Directors/VP/SVP on the overall status as well as the TerrAlign reporting.

Environment: Data ware housing concepts, data modeling, Healthcare, Mainframes, Tibco, Portal-Web-services, Informatica Power center 8.6.1, FACETS4.5/4.7, TerrAlign, NASCO, PORTICO front end application, Power exchange 8.6,, HP-Quality Center 9.0, Quick Test Pro, SQL Server-2008, MS SQL, XML files, PL/SQL, Oracle 9i, TOAD, UNIX, Perl Scripting, Load Runner, Windows 2000/XP, MS-Project Plan, MS-Office tools, Share point, Lotus Notes, EDI, 837I/P, 270/271, 276/277, 278, 835, UB92, HCFA.

Confidential, CA

Technical Delivery Manager

Responsibilities:

• Involved in the design, analysis and testing of the Migration solution/system/application.
• Created the Test Strategy, test scenarios, test procedures as well as documentation.
• Responsible for test environment setup (SIT/Performance/UAT).
• Designed the Test Schedules.
• Used Quality Center to execute the test cases, track execution against the plan during testing and manage defects from inception to resolution.
• Created extensive SQL queries to test the data against the SQL Server, Oracle databases.
• Created extensive SQL queries to test the data against the DB2.
• Created basic PL/SQL stored procedure for execution of few SQL transactions.
• Created Test cases scripts from the functional specifications and maintained traceability with the requirements.
• Leading and managing a team of 20 members (offshore & onshore).
• Created test mainframe files for validating the Source to Target Entitlement reports
• Created test data in the Source Wachovia system.
• Created Test JCLs and executed the JCLs for the Test workflow jobs and monitored.
• Creating the test batch data file by FTP thru Unix.
• Validating the Tilde delimited file converted from VSAM file.
• Created Unix shell scripts and Perl scripts.
• Performed Verification and Validation of migrated data in different targets viz; SQL Server, Oracle, DB2, LDAP, Unix.
• Documented and communicated test results.
• Conducted walkthroughs across the testing deliverables.
• Created Test execution metrics, Defect Metrics for daily status meeting.
• Conducted weekly status meeting with the Business/Executive team.
• Coordinating with Business for UAT, Status meetings, conduct walkthroughs.
• & Mentoring new comers as and when required.

Environment: Informatica Power center 8.6, Mainframes, Hogan CIS, Windows 2000/XP, Quality Center 9.0, SQL Server-2008, MS SQL, XML files, PL/SQL, Oracle 10g, TOAD, UNIX, Perl, LDAP, Load Runner.

Confidential

Delivery Manager

Responsibilities:

• Involved in the design, analysis and testing of the application.
• Created the Test Strategy, test scenarios, test procedures as well as documentation.
• Responsible for test environment setup(systest/integration/performance/UAT).
• Designed the Test Schedules.
• Used Quality Center to execute the test cases, track execution against the plan during testing and manage defects from inception to resolution.
• Created extensive SQL queries to test the data against the database.
• Created basic PL/SQL stored procedure for execution of few SQL transactions.
• Created Test cases scripts from the functional specifications and maintained traceability with the requirements.
• Created test data files for the FACETS batch application.
• Leading a team of 10 members(Dev & Testers).
• Created test mainframe files for validating the NASCO- Revenue and Billing data.
• Created test provider/practitioner data in the PORTICO system.
• Created test UB92 & HCFA, EDI-837I/P claims(claims with different plan PPO/POS/HMO) for FACETS, NASCO.
• Created Test JCLs and executed the JCLs for the workflow jobs and monitored.
• Performed functional, performance, regression and black-box testing on the payment and billing application.
• Created and executed exclusive Performance test scenarios and scripts for doing multiple iterations.
• Performed Recoverability/scalability/Load testing as part of the Tech testing along with the Performance testing.
• Creating the test batch data file by FTP thru Unix.
• Validating the Pipe delimited file converted from VSAM file.
• Created Unix shell scripts.
• Monitored metrics like CPU utilization, response time, memory activities and network delay.
• Performed Verification and Validation.
• Documented and communicated test results.
• Conducted walkthroughs across the testing deliverables.
• Created Test execution metrics, Defect Metrics for daily status meeting.
• Conducted weekly status meeting with the Business/Executive team.
• Coordinating with Business for UAT, Status meetings, conduct walkthroughs.
• Interviewing the Testing resources on behalf of the client.
• Reviewing the testing deliverables of other projects.
• & Mentoring new comers as and when required.

Environment: Informatica Power center 8.1.1, FACETS, NASCO, PORTICO front end application, Power exchange 8.1, Windows 2000/XP, Quality Center 9.0, SQL Server-2008, MS SQL, XML files, PL/SQL, Oracle 9i, TOAD, UNIX, Load Runner.

Confidential

QA-Test Lead Engineer

Responsibilities:

• Involved in Client meetings to gather Requirements to be mapped to the system.
• Performed the Onsite test lead role in mentoring and leading testing team of 5 resources.
• Created Requirements specifications to be presented and signed off by the client.
• Managing all phases of software testing for assigned components ensuring Test plans, Test Strategies and Test cases are completed to meet business requirements.
• Created/tested test scenarios to validate the integration/routing/transformation and deliver of data such as COBOL copybooks across different protocols including HTTP, JMS, FTP, and e-mail thru TIBCO-BW.
• Created/tested test scenarios to validate the proper expedition of third-party applications(IBM MQ series) through TIBCO Adapters.
• Worked on five implementation projects & three ongoing projects simultaneously.
• Leading efforts to improve QA practices by identifying, proposing and implementing move of test case development into the Quality Center tool from MS Excel, Word.
• Coordinated with the business analysts and developers and discussed issues in interpreting the requirements and effectively managed the finalized requirements using Quality Center.
• Maintained Test Plan which includes description of the item being tested and its scope, user requirements, environmental needs, risk assessment, approach and methodology.
• Analyzing business and functional requirement to design System Integration, Performance testing and User Acceptance Test Cases.
• Wrote and executed detailed test cases including prerequisites, detailed instructions and anticipated results.
• Modified and used automated test scripts which are called from Quality Center during execution.
• Created multiple test scenarios based on business rules to create data driven testing.
• Participated in Test Case walkthroughs, inspection meetings.
• Executed Test cases from Test lab in Quality Center and documented test results.
• Performed various types of testing, such as unit, black box, functional, performance, negative, system integration, regression and user acceptance.
• Participated in project meetings, review specifications, release notes and give recommendations and suggestions.
• Tested deployment of applications in various environments during all phases of product lifecycle.
• Managed defect tracking, defect reporting for assigned projects using Quality Center/Test Director.
• Maintained Daily Project Status Report
• Interacted with the development team to solve the problems encountered in the test scenario run.
• Worked with development teams to investigate, prioritize and resolve software bugs / defects based on the testing results.
• Participated in review meetings and took the initiative to meet the QA testing targets.
• Participated in daily status meetings to report any bugs, issues and risks.
• Run the SQL queries to fetch test data and backend (database) testing to validate the database.
• Trained & mentored new joiners in the team as and when required.

Environment: Mainframe-3270 system, TIBCO(BW), Manual Testing, Quality Center 9.2, Test Director, CICS, DB2.

Confidential

Junior Engineer

Responsibilities:

• Reporting on daily basis to the supervisor ensuring Test plans, Test Strategies and Test cases are completed to meet business requirements.
• Worked on 5 implementation projects.
• Coordinated with the business analysts and developers and discussed issues in interpreting the requirements and effectively managed the finalized requirements using Test Director.
• Analyzing business and functional requirement to design System Integration and User Acceptance Test Cases.
• Wrote and executed detailed test cases including prerequisites, detailed instructions and anticipated results.
• Modified and used automated test scripts which are called from Test Director during execution.
• Created multiple test scenarios based on business rules to create data driven testing.
• Participated in Test Case walkthroughs, inspection meetings.
• Executed Test cases from Test lab in Test Director and documented test results.
• Performed various types of testing, such as unit, black box, functional, performance, negative, system integration, regression and user acceptance.
• Participated in project meetings, review specifications, release notes.
• Tested performance web applications using Client /Server architecture.
• Managed defect tracking, defect reporting for assigned projects using Mercury Test Director.
• Worked with development teams to investigate, prioritize and resolve software bugs / defects based on the testing results.
• Participated in review meetings and took the initiative to meet the QA testing targets.
• Participated in daily status meetings to report any bugs, issues and risks.
• Run the SQL queries to fetch test data and backend (database) testing to validate the database.

Environment: Mainframe-3270 system, Manual Testing, Quality Center 9.2, Test Director, CICS, DB2