Project Manager Management
Resume:
R icha Gupta
***********@*******.***
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