SUMMARY:

A strategic & result oriented Testing/Quality Assurance Lead with 12 + years of experience. A diverse career containing roles throughout the Software Development Life Cycle (SDLC), which gave ample of exper ience in Quality Testing code, Business Requirement Analysis & Documentation, Data Analysis and Manage Releases, Environments and QA. Charismatic leader with excellent problem - solving skills. Have been part of several projects end to end - beginning from Inception and Planning to Production Go Live and Support.

SKILLS SUMMARY:

DOMAINS: Banking and Finance, Media, Analytics

TESTING AREAS: Frontend testing (web based apps), back end - Data testing, ETL, Automation

TESTING METHODS: System Testing, Integration Testing, Regression, White box, Black box, UAT, Exploratory, Performance

TESTING TOOLS: Quality Center 10.0, ALM, ITSM, Service NOW, Zephyr & JIRA (including X Ray and Agile), HP Performance Test

DATABASES: Oracle 11g, SQL Server

DWH /BI: Informatica Power Center 9, UNIX, TOAD, Business Objects, Cognos, XML

BIG DATA TECH.: Hadoop - HDFS, Squoop, HIVE, PIG, Map Reduce

BATCH SCHEDULING: Control M, Tivoli

VERSION CONTROL: Microsoft Visual SourceSafe (VSS), Sharepoint, SVN

CRM: Sales Force (Integrated with Apptus, FPX, Marketo, RALEX, E2C), IAM, Siebel 2K

EXPERTISE AND COMPETENCIES:

• QA projects in various project methodologies Agile (Test Driven), Waterfall and Hybrid.
• Environment/s Planning & Management, Release Management with all projects
• Liaised with multiple Dev, Prod teams simultaneously to carry out project operations and System Testing.
• Authored Test Plan, Test Strategy, Test Estimates and Schedule, Test Scenarios, Post Impl Reviews.
• Reviewed Team deliverables like Test Cases, Test Execution and Results.
• Designed successful Testing Frameworks for Projects in Continuous Integration models.
• Monitored overall Testing progress and published daily, periodic status reports and dashboards.
• Organized and drove Triage Meetings with multi teams on-board to track down defects.
• Worked as JIRA Admin alongside QA projects.
• Team identification, trained, mentored & tracked team in onshore-offshore models and multi-vendor env.
• Implemented Risk Based Testing methodology in working project as well as lead the initiative to implement it in other on-going parallel modules.
• Managed multiple projects/modules at a time (upto 4 projects at a given time)
• Experienced tester with HDFS architecture, worked on Squoop to connect to Oracle relational database and pull data to Hadoop file system.
• Used PIG with commands like LOAD, DUMP, STORE to process both structured and unstructured data sets. Used HIVE SQL for data analysis in HDFS.
• Extensively worked on projects involving DWH technologies like Control M, ETL (Informatica), UNIX, Oracle DB/SQL and XML.
• Tested several in-house web applications., front end testing
• Tested SFDC based applications with various SFDC components like - Accounts, Opportunity, Orders, Contracts, Leads to name a few.
• Tested CRM in Siebel with various modules.
• Authored numerous effective Test Cases and Executed them to testing closure with defects.
• Deep knowhow of QA automation processes and tools like QTP and Selenium.
• Been part of User team and planned, coordinated and executed Testing.
• Successfully carried out Requirements Analysis and Use Case analysis.
• Deep understanding of translation of Use Cases and Business Requirements into Functional Design and thereby Technical Specification.
• Authored elaborate BRD, FRD and Tech Design Documents.
• Hands-on with data analysis including but not limited to Data Profiling, matching patterns, mismatches, integrating with different systems, validation, migration, creating test/mock data.
• Developer Experience - Worked on Informatica Designer Components - Source Analyzer, XML Parser, various Transformations, Mapplet and Mapping Designer. Certified for Informatica Mapping Designer with 83%.

Project Experience Details

Confidential, NYC

Test Manager Consultant

Key Technologies: Sybase, Informatica PC, Oracle, SQL Server

Responsibilities:

• Requirements gathering and Analysis with BA Team.
• QA Team interview and ramp up.
• Knowledge Transition to QA Team. Review understanding.

Confidential, NYC

Test Manager Consultant

Key Technologies: Sales Force (SFDC), Informatica PC, Oracle, JIRA (and X-ray), SVN, Hadoop, Cognos, IDAM

Responsibilities:

• Solely responsible for managing and driving QA for the four projects - CAE, Lewtan, WES and IDAM.
• Drove Extensive rounds of tests first individually on each project and eventually their code merges and integrated them to existing project.
• Designed Test Plan and strategized sequential and parallel testing for the whole integration projects along with Testing estimates and schedules.
• Collaborated with business stakeholders by leading and discussing project scope and approach and presenting Business Analysis findings/documentation and proposed solutions
• Analyzed and planned for vast amount of Converted data coming into system due to integrations from previous business of newly acquired entities; data compatibility was tested in parallel in different env along side project System Testing..
• Hands-on worked on various SFDC objects like - Accounts, Opportunity, Orders, Entitlements, Contracts with Apptus, E2CP, Marketo, Cvent, Leads. ETL tested for loading data form SFDC to Reports and various downstream like PeopleSoft, SuccessFactor and WorkWise.
• Built team at offshore by interviewing, successfully transferred project knowledge via webex sessions, trained, mentored and tracked & reviewed all deliverables.
• Designed Test Scenarios, Test Cases and Executed them. Effectively logged defects and tested them to closure.
• Facilitated UAT with User and BA Teams.
• Environment Management for testing with various upstream and downstream
• Worked closely with stakeholders on tracking, updating and reporting on project status, risks and activities.
• Driven all 4 projects to comply with Risk Based Testing methodology.
• Liaised with Automation and Performance Testing teams as needed for various modules.
• Replaced the ill-equipped SharePoint issue tracker with industry standard JIRA and took up JIRA Administrator role additionally to drive test management and defect tracking across Dev, BA and user teams.

Confidential, NYC

QA Manager Consultant

Key Technologies: ETL, Oracle, Linux, HIVE, PIG, Squoop, MapR, HDFS, TestWhiz, Siebel

Responsibilities:

• Ramped up offshore team by identifying resources, interviewing and conducting knowledge transfer sessions to speed them up with deliverables.
• Designed testing framework, test plan and strategy. Identified Test Scenarios and Test Cases. Executed test cases and logged-tracked defects. Conducted System Testing.
• Interaction with Product Managers and Development Managers/teams to understand the requirements and converting them into business use cases.
• Root Cause analysis of the existing product bugs and delta between user requirements and existing deployed product.
• Devised techniques to test real time data by mocking up data using test loader tools like TestWhiz to check for accuracy, compatibility and system constraints.
• Accomplished ETL testing by writing SQL alongside transformations to analyze data change and business logic.
• Used PIG commands to access data at various QA stages.
• Hands on worked with dev team to help migration of existing DWH to Big Data Technologies.
• Reviewed test cases and providing guidelines for preparing test cases to simulate client scenarios
• Managing and Coordinating with the QA offshore team
• Tested in various Siebel Module e.g. marketing, eSales, and Call Center, E-commerce, Credit Card Payment Processing and Client-Server applications on different environments
• Periodic Client Reporting
• Drove UAT - liaising between Development, Users and offshore QA Team.
• Gathered information for all Environments needed for testing various modules individually and then integration test. Also, managed environment code bases as we had constant UAT happening on modules signed off by QA.

Confidential

BA QA Lead Consultant

Key Technologies- Oracle 11g, cross browsers, HTML, ETL, Control M.

Responsibilities:

• Created the Test Plan and resourced the team to get the project initiated.
• Converted existing use cases to fit the migration based new use cases.
• Created Work Breakdown structure for project estimation and schedule design.
• Requirement analysis, define test strategy on varied requirements for different applications in this group.
• Hands-on worked on creating Test Cases and Executed them to conduct System Testing.
• Handled a team of 6 members. Trained, reviewed deliverables and co-ordinated with onshore manager.
• Reported status to client in terms of DSR, WSR and client calls.
• Defect Analysis, Test Case Reviews and Traceability Matrix creation., Testing Sign offs and Readiness Reports.
• Actively involved with PM and worked on finalizing applications list and planning for next year’s work.
• Created use cases for automation..

Confidential

BA QA Lead Consultant

Key Technologies: Transition Management, Oracle, ETL, HTML, Control M

Responsibilities:

• Responsible for KAP of given set of applications under CRO and CFO portfolio or location.
• Tracked KAP Activities for Work on hand
• Collected Daily KAP Progress from Test Analyst and reporting to Transition Test Manager
• Tracked Checklist and Q&A Tracker for all Test Analyst/applications
• Drove Knowledge gathering sessions with Application SMEs and documented information which I later translated into workflow diagrams and specifications for COE team’s understanding of application.
• Resolution of Day to day issues for Test Analyst.
• Weekly Status reporting to Wipro and CS Transition Managers
• Issue/Action/Risk Tracking for KAP of applications in his portfolio in a Wave

Confidential

Informatica Developer

Key Technologies - Informatica PowerCenter 8.1, QualityCenter, Toad for Oracle, Tivoli, UNIX

Responsibilities:

• Monitored the ETL jobs on TIVOLI and handling all the ERRORS at batch runs.
• Resolved the defects by providing root cause and permanent fix for the problem.
• Designed and developed complex Informatica mappings using expressions, aggregators, filters, lookup and stored procedures to ensure movement of the data between various applications.
• Developed Unix Shell scripts to maintain and performing server level tasks.
• Extensively used almost all of the transformations of Informatica including complex lookups, Stored Procedures, Update Strategy and others