R icha Gupta

acpc3d@r.postjobfree.com

Cell: +1-713-***-****/ Home: +1-713-***-****

PROFESSIONAL SUM MARY:

o Having around 3+ years of experience into Softwa re development and Q uality Assurance

a nd Automation Testing(QTP)

o Development experience in V B Scripting and E xcel VBA Macro P rogramming

o Experience developing Dashboard and Visualization with Tibco Spotfi re 6.5

o Experience of Microsoft S QL Server Management Studio, l it tle experience in Teradata 12.

o Extensive knowledge and understanding of S DLC

o Reviews/walkthroughs/audits for SRS, system designs, database designs, GUI screens.

o Good Exposure on Bug Life Cycle. Reporting and prioritizing software bugs in conjunction with the

Development & QA Managers using test management tools.

o Involved in client meetings, calls and Weekly status meetings.

PROFESSIONAL EXPER I ENCE:

Working in C hevron Corp., Houston as Softwa re Developer f rom May 2014 till Date

Worked in L evonsys, H yderabad (http: / / www.levonsys.com) as Q A Test Engineer f rom J ul 2010 to

Dec 2012

E D UCAT IO NAL QUAL I F ICAT IO NS:

Post-Graduation, Master of Computer Application (M.C.A.) 2010, Indira Gandhi National Open University

( IGNOU), Delhi, India.

Certificate in Computing (C.I.C.) 2004, Indira Gandhi National Open University (IGNOU), Delhi, India

Graduation, Bachelor of Science (B.Sc.), 2003, Agra University India

SOFTWARE SKI L LS:

Languages : C, C++, V isual Basic, E xcel VBA /Mac ros, HTML, ASP.Net and FORTRAN

Tools : Tibco Spotfire, AspenTech Petroleum Scheduler (APS)

Operating Systems : Windows XP, Windows 2003 Server, UN IX, Apple Mac

RDBMS : Microsoft SQL Server, Teradata 12.0

P ROJECT # 1:

Title : RSAP – Refinery Scheduling Assessment Project

C lient : Chevron

Environment : Excel VBA, AspenTech Petroleum Scheduler (APS), Tibco Spotfire

Team Size : 17

Duration : May 2014 to Till Date

Description:

AspenTech Petroleum Scheduler (formerly Orion), is a refinery scheduling solution to replace current M3

S IMTO at all large U.S. Chevron refineries (Richmond, El Segundo and Pascagoula). I t allows planners and

schedulers to easily and quickly identify and react faster to gaps between the plan and schedule for better

a lignment. This solution manages integration with various systems, such as shipments and receipts, crude and

stream qualities, blend schedules etc. As part of this project, it also required generating various templates to

generate excel reports and also Spotfire visualization dashboards. These reports are mainly to analyze data

f rom Actuals (history), Plans and Schedules and publish them further to refinery portals and management.

Responsibilities:

• Understanding the requirements, f low and functionality of the application

• Design and develop report prototypes with Business Analysts

• Developed dynamic report using functions and Excel VBA Scripting

• Prepared Test Data for the specific reports

• Prepared Technical Design document for report templates

• Participated in code review and peer testing

• Working closely with the Business Analyst, Project Manager and offshore development team

PROJECT # 2:

Title : Kites Junior College (http://www.kitesjuniorcollege.com)

Client : Kites Educational Society

Environment : ASP.Net, C#, XML, Microsoft Excel and SQL Server

Team Size : 6

Duration : Apr 2012 to Sep 2012

Description:

This project is about school management system for Kites Junior College. This we based application was

created to manage school staff, faculty, students, finances, course curriculum, manage and t racking. This also

help in managing day to day operational activities such as attendance t racking, leave management, employee

work hours entries, library & canteen management. I t has various modules like Master, Campus Master,

Students, Faculty, library, canteen etc. This project was developed on Microsoft platform, ASP.Net and SQL

Server.

Responsibilities:

• Understanding the requirements, f low and functionality of application

• Reviews/walkthroughs for SRS, system designs, database designs

• Developed reports and expense calculator using Excel VBA Scripting

• Involved in preparation of Test Data and automation testing using QTP tool

• Responsible for identifying User Interface anomalies and defects

• Working closely with the Development team and project manager

P ROJECT # 3:

Title : Ayurvedam (http://www.ayurvedicpsoriasis.com/)

Client : R.K. Ayurvedic & Psoriasis Research Center

Environment : PHP, Microsoft Excel/VBA, and SQL Server

Team Size : 5

Duration : Nov 2011 to Mar 2012

Description:

Ayurvedam is a web based portal and application which gives information relating to the clients and dealers

of company which respect to its medicine and product launches. This also helps in keeping t rack for medicine

i nventory for the company. The portal also shows details about all the medicines, their usage. I t also hosts

i nstructional and promotional videos for site visitors. The application has an option for visitors to create login

and buy medicine through website. Project also required to create Microsoft excel based inventory

management tool.

Responsibilities:

• Understanding the requirements, f low and functionality of application

• Reviews/walkthroughs for SRS, system designs, database designs

• Prepare UI Screens and reports using VBA Scripting and automation testing

• Developed inventory management tool in MS Excel using advance VBA

• Involved in preparation of Test Data

• Working closely with the Development team and project manager

PROJECT # 4:

Title : Navya LED Lights (http://www.navyaledlights.com/)

C lient : Navya LED Lights

Environment : PHP, SQL Server and Microsoft Excel

Team Size : 4

Duration : Jul 2011 to Oct 2011

Description:

The Navya LED Lights is a web based product catalogue which gives information about various products

related to specialized lighting needs to customers and businesses. The main requirement of website was to

make it visually appealing and more user-friendly. For the project team the main focus was to eliminate the

v isual discrepancies and to test browser compatibility in internet explorer, Mozilla Firefox, apple safari and

various operating systems.

Responsibilities:

• Understanding the requirements, f low and functionality of application

• Involved in Designing, Reviewing and Executing Test Cases

• Involved in preparation of Test Data

• Responsible for identifying User Interface anomalies and defects and automation testing

• Executed Scripts through Mercury Quality Center

• Used application life cycle management for Software Bug identification, t racking and reporting

• Reviews/walkthroughs for SRS, system designs, database designs, GUI screens, automation testing

• Working closely with the Development team and project manager

PROJECT # 5:

Title : Front Office Management

C lient : Sai Priya Resorts, Bangalore

Environment : VB 6.0, COM, Crystal Reports and Microsoft Excel

Team Size : 4

Duration : Feb 2011 to Jun 2011

Description:

This project mainly deals with the security management with user groups, users and accessibility of the

modules, enquiry & Booking of the rooms, expiry of bookings, advancement and postponement of bookings,

rooms changes, GRC (Group Rooms Control), GRC extensions, GRC cancellations, Check-in, Check-out,

complementary bills, authorizations, memberships.

Responsibilities:

• Understanding the requirements, f low and functionality of the application

• Responsible for executing Test Cases based on testdata and for automation testing

• Responsible for identifying User Interface anomalies and defects

• Used application lifecycle management tool for Software Bug identification, tracking and reporting

• Working closely with the Development team and project manager

Contact this candidate