Quality Assurance Project

Charu Kharbanda

Contact No.: 704-***-****

E-Mail: ********@*****.***

Summary:

• Over 8 years of IT experience in System Development Life Cycle (SDLC) including design, configuration, development, integration, testing, and deployment.

• Experience in business analysis, fit-gap analysis, requirement gathering, specification, documenting designs, workflows, data mapping, preparing and performing test, testing methodologies, defect and issue management, process implementation, production troubleshooting, and end to end project management.

• Working as a liaison with business/end users, technology, cross functional domain, onshore/offshore team.

• Experience in User Acceptance Testing (UAT), System Integrated Testing (SIT), Quality Assurance Testing and Regression Testing.

• Experience in PeopleSoft modules like Human Resource Management System (HRMS), WFA (ESS, MSS), Payroll and Compensation.

• Worked on Java/J2EE based application.

• Expert level in MS Excel, MS Word, MS Visio and Intermediate level in MS Access and MS Project.

• Extensive Experience with SQL queries & SQRs.

• Extensive experience in Oracle (7.x, 8i, 9i, 10g), SQL Server 2000, PL/SQL, UNIX scripting and database concepts.

• Good understanding of Agile and Waterfall Methodologies.

• Knowledge of Data warehousing and Business Intelligence tools like ETL, Informatica, Microstrategy etc.

• Experience in SAS 70 Audits & Transaction Accuracy Audits (TAA).

• Establishing and maintaining productive working relationship with management, clients and team members.

• Comprehensive problem solving ability with presentation and analytical skills.

• Solid Management skills, demonstrated proficiency in leading and mentoring individuals to maximize productivity and forming cohesive team environment.

• Excellent Technical, Communication and Interpersonal Skills with strong Customer Orientation and Client Interfacing Skills.

• A self-motivated professional and natural communicator possessing good technical, initiating leadership and problem-solving skills and has proven to be a good team player.

Experience:

Hewitt Associates April 2004 – till date

Business/QA Analyst

Projects:

Setup HR and Payroll in PS and myHR

Client - PNC Financials (Aug 2007 – till date)

Responsibilities

• Participate in client meetings and document requirements.

• Act as a liaison between business users and IT team to seek information, document and prioritize business requirements based on meetings, Contract, Statement of Work.

• Define and Document Functional and Business Requirement Documents (BRD, FDD).

• Worked on PeopleSoft modules: HRMS, WFA (ESS, MSS), Payroll and Compensation.

• Resource coordination, requirement review to ensure proper documentation and stakeholder analysis, defect management utilizing Quality Center and Caliber RM to generate traceability matrices.

• Create Workflows and activity diagrams (High level/Low level).

• Built Data Entity Relationship Diagrams (ERD) for data modeling.

• Evaluate client requirements with other existing clients with Hewitt.

• Participated in Siebel Call Center (Issue Resolution) customization meeting with client.

• Develop, Document and execute test case, test script, test plan in Quality Center.

• Identify Defects, document and assign to the Tech team using Quality Center.

• Perform Quality Assurance Testing, System Integrated Testing & User Acceptance Testing.

• Create UML diagrams on Rational Rose/MS Visio.

• Coordinate with business, cross functional domain and technology to ensure successful delivery.

• Managed application builds, deployment activities.

• Performed planning and data conversion activities.

• Prepare SQL queries using INNER, JOIN, UNION etc. for functional validations, Quality Assurance reports & Defensive Queries.

• Involved in data mapping in PeopleSoft using Common Data Storage (CDS).

• Set-up different dataset and parameters in the Configuration database in the existing PeopleSoft tables.

• Review user requirements and facilitate meetings for fit-gap analysis.

• Document project management and planning efforts for design and deployment of applications and upgrades.

• Assisted myHR team to ensure the correct data is getting redirected to PeopleSoft.

• Troubleshooting on Siebel Request created for the transaction that goes for Manual Processing.

• Analyzed current processes and provided solutions for future projected processes resulting in saving time and cost.

• Analyzed the new processes in relation to Average Processing Time (APT), technology and skill set to calculate FTE requirement.

• Developed Presentations and reports using PowerPoint and Excel.

• Document System Operated Procedure (SOPs) for all the processes by foreseeing the methods, tools & applications and versions used.

• Back Office User Interface – to upload information on application used by end users and clients

Environment: PeopleSoft 9.0, myHR, Java, Siebel, AQT, SQL, SQR, Application

Designer, Quality Center, Rational Rose, MS Office Suite, Sharepoint, MS Visio, Application Engine, File Layout, Back Office User Interface, Spring, Hibernate,

Phase: Requirement, Analysis, Design, Implementation, Test & Deploy

STEE Project

Client - Ministry of Defense, Singapore (March 2007 – July 2007)

To review the existing benefits processes of Ministry of Defense based on mainframe (TSO) application. Identify Non Value Add (NVAs) steps which can be eliminated and transform their process into more simplified and cost effective way.

Responsibilities

• Participate in client meetings to gather requirements.

• Review the Process Maps for the current Benefit processes.

• Compare/Evaluate with the current Hewitt processes and identify the NVAs such as manual processing, different sources to collect information, different location to store information.

• Identify the manual processing and provide a common platform with usage of new tools & applications.

• Define and develop new Process maps and workflows in MS Visio.

Environment: Content Manager, Imaging, Siebel, Mainframe, MS Visio, MS Office

Phase: Requirement, Analysis, Design

Workforce & Compensation Administration Application and ongoing support on HR Solutions

Client - Medco Health Solutions (March 2005 – March 2007)

Responsibilities

• Gathering the clients' existing HRIS policies, and procedures.

• Use the requirements documents to develop system-testing specifications.

• Involved in Configuration, Acceptance and Regression testing.

• Manage Recruiting Interfaces received via Taleo.

• Review and execute batch jobs in Mainframe.

• Upload Mass Updates in the application.

• Create SQL queries to run various reports.

• Handle and provide resolution to end user in various issues like data mismatch in from ESS or MSS or Benefits in comparison to Peoplesoft.

• Lead Data Cleanup Project wherein Employees data needs to be updated with specified information

• Lead Volume Information Project to analyze incorrect Pay group activity.

• Lead Audit of unresolved Channel Errors Project to provide correct resolution.

• Executing and monitoring the ongoing delivery and quality of processing,

• Troubleshooting problems that arise, and identifies ways to improve the efficiency of processing and the system.

• Ongoing interaction with client contacts or other third parties involved in the maintenance of a particular HR program.

• Documentation of System Operated Procedure (SOPs).

Environment: PeopleSoft 8.9, HRWorkways, AQT, SQL, SQR, Java, TSO/ISPF,

Taleo, Citrix, MS Visio, MS Office, Lotus notes, Operations Issues Database, Mass Change, Application Engine

Workforce & Compensation Administration Application and ongoing support on HR Solutions

Client - SONY Electronics (March 2005 – March 2007)

Responsibilities

• Gathering the clients' existing HRIS policies, and procedures.

• Use the requirements documents to develop system-testing specifications.

• Involved in Configuration, Acceptance and Regression testing.

• Create SQL queries to run various reports.

• Handle and provide resolution to end user in various PeopleSoft issues like Employee Issues, PeopleSoft Correction, HR Consultant, Job Code or Department Creation, Cancellation of Termination etc.

• Lead Prism project to create new Job Code design in PeopleSoft.

• Support offshore team on ongoing Operations Issues.

• Involved in SAS 70 Audits with Ernst & Young.

• Lead IIRS project across cluster to generate Utilization report.

• Manage Workforce and Compensation Administration.

• Providing Solutions for Process Escalations as and when required.

• Executing and monitoring the ongoing delivery and quality of processing,

• Troubleshooting problems that arise, and identifies ways to improve the efficiency of processing and the system.

• Ongoing interaction with client contacts or other third parties involved in the maintenance of a particular HR program.

Environment: PeopleSoft 8.9, HRWorkways, AQT, SQL, SQR, Java, TSO/ISPF, Citrix, Taleo, Lotus Notes, Operations Issues Database, MS Visio, MS Office, Mass Change, Application Engine

Connections-Eligibility/Premium

Client – 100+ like Aetna, Cigna, BCBS, Unisys etc. (April 2004 – March 2005)

Responsibilities

• Perform QA analysis on different jobs in Mainframe as per client schedule.

• Document the analysis report in client QA report.

• Analyze the weekly EB count and send to SME if required.

• Involved in process mapping and workflows of different processes.

• Assisted in EB Count Analysis Project.

• Perform Audit on all the processes to verify compliance.

• Develop TAT report on all the processes.

Asiatic Electronic Industries Sep 2002 – March 2004

Computer Associate

Responsibilities

• Catalogue Designing and Presentation of Products

• ISO related Charts & Documentation

• Maintenance of Websites (www.asiatic-india.com, www.quizandpuzzles.com) including research on data for children quiz, designing banners, animation, quiz etc.

• Design & Development using Frontpage, Dreamweaver, HTML, DHTML, Servlets, Java Applets, JDK1.4.2, ASP, JSP & Oracle 8i for web portals & applications.

Technical Skills:

Operating Systems : Windows NT/2000/XP, Sun Solaris, Mainframe,

UNIX, DOS

Languages : Java, JDBC, PL/SQL, C, C++, HTML, Java Script, ASP, UNIX Shell Scripting, SQL, PeopleCode, UML

Applications : PeopleSoft 8.9/9.0, SQR, Tree Manager, Crystal Reports, Vision Reports, PS Query & Reports, MS Project 2000, Taleo, Successfactors

Design Tools : PeopleSoft Internet Architecture, MS Visio, Frontpage, Dreamweaver, Rational Rose, Data Entity Relationship Diagram

Requirement Tool : iRise, CaliberRM, DOOR

Packages : MS Office, Peoplesoft (8.9/9.0), Lotus Notes

Databases : Oracle (7.x, 8i, 9i, 10g), MS Access, SQL Server 2000

Application Tools : Siebel, AQT, Toad, Back Office User Interface, Putty, Secure CRT 4.1, Damware, Core FTP, VNC, RAD, PC Anywhere, Terminal Service Client, Caliber, Toad, Data Imager, NetMeeting, File Layout, Eclipse, TSO/ISPF

Data/Integration Tools : Hyperion, Informatica, ETL, CruiseControl, Citrix, Sharepoint

Application Builder : Application Designer, Application Engine

Testing : HP Quality Center, Win runner, Load runner

Qualifications:

• MBA(Finance) from IGNOU

• Bachelor Degree from Delhi University

• Certificate Course in Information Technology from CMC Ltd.

• Diploma in Multimedia from YMCA

• Certificate Course in E-Commerce from R.C.S.M.

Trainings and Certifications:

• Certified Six Sigma Yellow Belt

• Brainbench Certified RDBMS Concepts

• Fundamentals of US Payroll Training Program

• Project Management Modules on SumTotal

• Hewitt Associates Certified Trainer

• Personal Effective Training Program

Award(s):

• Spot Awards

• Green Belt Participant Award 2008

• SONY BRAVIA Award: July 2007 (from end client)

• Process Wizard: November 2006

• Process Champion: October 2006

• Best Idea Award: July 2006

• Team Synergy: November 2005

• Star of the Month: April 2005

Contact this candidate