PROFESSIONAL SUMMARY

• 12 years of overall experience in Information Technology as a QA Lead, Business Analyst, Application Development, Testing and implementation using Oracle (9i/10g/11g), SQL Server, SAP and Seibel CRM environments.
• Configured development and QA environments to meet data privacy and data sub setting requirements using Optim Test Data Management (TDM) services.
• Experienced in data migration/loading across DB Platforms using native tools - SQL Loader and Shell Scripts.
• Assisted in designing conceptual, Logical and physical data models using Erwin, PL/SQL Programming, and Shell Scripts.
• Worked as a team member to provide 24x7 on call support production database support.
• Strong backend skills in creating SQL objects like Tables, Stored Procedures, Views, Indexes, Triggers, Rules, Defaults, user defined data types and functions.
• TEMPHas very good experience in data analysis, database design, data mapping, conversion and data load.
• Lead onshore / offshore teams for project Implementation wif daily offshore task assignment, review daily offshore status & customize the same to the client expectations.
• Experience in Multi-Dimensional Data Modeling (Star Schema) - Identified Business & Data requirements and converted them into conceptual & logical data models
• Possess a very strong technical foundation wif excellent interactive communication and interpersonal skills.
• Ability to learn new technologies and functionalities quickly and adapt to changing requirements.
• Team player wif demonstrated collaborative working relationships.

PROFESSIONAL EXPERIENCE

Confidential, NJ

Environment: IBM Optim, Oracle 11g/10g, LINUX, HP-UX, TOAD, SQL, PL/SQL, HP Quality Center.

QA Lead

Responsibilities:

• Implement and test Enterprise Data Management using IBM Info Sphere Optim tool for Data Archive (Performance Archive, Retirement Archive) and Data Purge.
• Create OPTIM Environments, Directories and DB Aliases for Oracle.
• Configure Optim Archive / TDM environment in windows and UNIX environments.
• Convert flat files and csv files into relational model to use wif Optim.
• Create and test Optim extract, archive, convert, insert jobs.
• Responsible for scheduling and automation using Shell Scripts.
• Worked wif Optim support team to resolve the archive data access issues wif data types.
• Implemented Test Data Management and Data sub setting services for Oracle Database.
• Create OPTIM access definitions, table mappings and columns mappings and apply masking functions.
• Write Column Procedures and Exit Routines for custom masking algorithms using OPTIM tool.
• Create OPTIM Extract, Convert, Insert, Compare and Restore requests based on the masking requirements.
• Manage offshore team responsible for implementing the Optim.
• Coordinate meetings wif business Analyst, project manager, and Development and client management teams for scheduling of Archiving initiatives.

Confidential, MN

Environment: SAP BW, SAP BO, Oracle 11g/10g, LINUX, HP-UX, SQL Server, TOAD, SQL, PL/SQL.

QA Lead / Business Analyst

Responsibilities:

• Responsible for gathering requirements from super users, Requirement Analysis, Data Modeling, Development and Testing for the implementation of SAP BW for SAP MM and SAP FI - AR.
• Analyzed and mapped business reporting requirements to BW and developed detailed reporting specifications, logical Data Model and business blueprint.
• Interacted wif functional & ABAP team to gather the information required for Data Extraction from Planning Area and R/3 to BW and provided the design options to meet the business requirements.
• Generated the BEx Reporting requirements and analyzed and updated the BRD as per the user requirements.
• Facilitated the users to analyze the Business scenarios.
• Create and run Shell Scripts to load the data.
• Manage QA Testing and User Acceptance Testing through testing phase by reviewing and approving test cases, managing defect analysis.
• Conduct end user training and document the process to access and the required data.

Confidential

Software QA Lead for Salesforce.com implementation

Responsibilities:

• Gain functional noledge (Application & DB) to an extent of driving the offshore team.
• Daily offshore task assignment.
• Lead the QA efforts for functional and Performance testing of Salesforce.com Implementation.
• Review daily offshore status & customize the same as expected by the IST lead / Client.
• Defect follow-up, re-test.
• Work on any issue resolution wif the PM / Dev leads of the respective work stream.
• Onshore-Offshore co-ordination.
• Lead the QA teams responsible for functional and Performance testing using QTP and Load Runner.
• Collect and summarize performance test results from support teams.
• Provide appropriate recommendations to ensure data Quality and test robustness.
• Gain noledge of the Stock Loan applications and perform test planning and test execution.
• Share the noledge and support the team members in testing the applications.
• Coordinate testing efforts wif Business analyst, development and management teams.
• Ensure timely completion of the test execution and submission of the deliverables.
• Escalating and coordinating resolution of the issues wif team members.

Environment: Salesforce.com, Sybase, JSP, XML HTML, EJB, Oracle, HP Quality Center, QTP, Load Runner.

Confidential

Seibel CRM implementation Lead

Responsibilities:

• As part of the team providing data to Novartis LDS team, gained understanding of the existing process, analyzed the data entities, documented the Functional requirements, Created detail design document, Developed PL/SQL procedures for generating the requested reports from Novartis Roster.
• Provided data to Novartis LDS team,
• Gained understanding of the existing process
• Analyzed the data entities
• Documented the Functional requirements
• Created detail design document
• Developed PL/SQL procedures for generating the requested reports from Novartis Roster.

Environment: Seibel CRM, Oracle

Confidential

Senior Conversion Analyst

Responsibilities:

• As a senior conversion analyst/developer, reviewed and updated requirements and detail design documents, data layouts and rules to convert the data from legacy systems to NYCAPS.
• Developed and modified SQR’s for data conversion from Legacy systems to PeopleSoft records by performing required validations and acquired good working noledge on FIT/GAP Analysis.
• Converted data from staging to PeopleSoft records for Personal Data, Tax Data, Recruitment Processing, Pre Employment processing, Probation and Employee Performance Management.
• Created Cron Jobs to Schedule and run the conversion programs using Shell Scripts.
• Executed and modified the conversion run book during mock conversions.
• Coordinated wif development, test and functional teams in processing and analyzing the converted data, troubleshoot the issues while processing the converted data.
• Ensured all the prep scripts are executed and data validation is complete in testing environment
• Provided support to functional teams during Mock conversions in analyzing and fixing incorrect data using SQL.
• Executed, analyzed and presented converted data reconciliation to client manager.

Environment: PeopleSoft HRMS, Oracle SQL, PeopleSoft SQR, UNIX, XML, Load Runner.

Confidential

Configuration Lead

Responsibilities:

• Was a team member in Confidential for the employees having salary progress in steps in accordance wif the contractual agreement.
• Derived the contractual Salary increments for New York City employees in uniformed titles and configured data in HRMS setup for implementing PeopleSoft HR Step Progression as Salary Plan, Grade and Steps.
• Analyzed employee salaries and converted the salary plan information for the employees to fit in to the configured values by leveraging existing Application Engine program for conversion and mass updates.
• Ensure correctness of converted data.
• Used SQL queries for data analysis and presented the analysis results to the project team.
• Provided support to the Testing Team in analyzing converted data and providing input on the functionality of the application.
• Responsible for documenting key discussion points during team meetings, and distributing meeting minutes to team members.

Environment: PeopleSoft HRMS, Oracle SQL, PeopleSoft SQR, UNIX, XML

Confidential

Onshore/ Offshore Testing Lead

Responsibilities:

• Manage offshore QA team responsible for testing of web/IVR applications to manage the customer base and progression of Get Quit support program for the Chantix users.
• Coordinate wif business Analyst, project manager, development and client management teams to provide scheduling for testing, reporting and tracking of defects.
• Prepared detailed test plan specifying the system inputs, outputs, limitations, entry and exit criteria.
• Reviewed test scenarios and test cases on a regular basis to ensure that the test cases are most current and in accordance wif changes in requirements.
• Coordinated meetings for the test team wif business analyst to understand new business rules as compared to the existing ones.
• Managed all phases of testing (unit, regression, system and user acceptance testing) to ensure the test deliverables are met on time
• Analyzed and communicated the impact of requirements changes on testing deliverables.
• Coordinated wif business analyst, development team and management team to prioritize and resolve issues.

Environment: XML HTML, JAVA, Oracle, HP- Mercury Quality Center

Confidential

QA Lead / senior QA Analyst

Responsibilities:

• Lead QA team responsible for testing CRM and analytical systems for pharmaceutical clients.
• Prepared validation scripts wif system inputs, outputs, limitations, entry and exit criteria specified.
• Coordinated wif project manager, development and client management teams to provide estimates required for testing, reporting and tracking defects.
• Was responsible to ensure the test deliverables are met on time.
• Review of test plans and test cases on a regular basis to ensure that the test cases are updated in accordance wif changes in requirements.
• Coordinated impact of requirement changes on testing schedule.
• Managed all phases of testing (unit, system, user acceptance and regression)
• Conducted meetings wif the business analysts and team members to understand business rules, and understand the existing legacy systems.
• Created test plan, test strategy and test cases that would be used for all phases of testing.
• Manual and automated Testing of client-server as well as web based applications using Quick Test Professional
• Used Mercury - HP Quality Center for defect-tracking.
• Coordinated wif business analyst and development team to resolve issues.

Environment: SQL Server, XML HTML, VC++, VB Script, Oracle, HP- Mercury Quality Center, Win Runner.

Confidential

QA Lead / Manager

Responsibilities:

• Lead QA team responsible for testing online Applications.
• Prepared detailed test plan specifying the system inputs, outputs, limitations, entry and exit criteria.
• Performed server administration and upgrades to Load Runner.
• Analyze and migrate project data for Performance and Load testing scenarios.
• Coordinate wif project manager, development and content management teams to provide estimates required for testing, reporting and tracking of defects.
• Record script the load test scenarios using Load Runner and Quality CenterEnsured the test team deliverables are on schedule.
• Reviewed test plans and test cases on a regular basis to ensure that the test cases are most current and in accordance wif changes in requirements.
• Analyzed and coordinated the impact of requirement on testing delivery dates.
• Provided 24x7 support during the launch time for the web site.
• Managed all phases of testing (unit, system, user acceptance and regression)
• Conducted meetings wif the business analyst to understand business rules, and understand the existing legacy systems.
• Created test plan, test strategy and test cases that would be used for all phases of testing.
• Manual and automated Testing of client-server as well as web based applications using Quick Test Professional
• Managed defect tracking and issues resolution using Mercury Test Director for.
• Trained business and functional users to use Test Director and setting up processes for defect cycle.
• Worked wif business analyst and development team to resolve open defects.
• Drafted release notes wif new features and fixed defects.
• Performed system analysis for upgrading existing Salvage screens.