Neha Gulati
43732 Calistoga Sq.
Ashburn, VA 20147
Cell: [Send email to request phone number] 26-6586
Home: [Send email to request phone number] 26-9075
E-mail: [Send email using form at bottom]
Objective: To obtain a position in the software field where my business data
analysis, reporting and quality assurance skills will be utilized.
Citizenship Status: US Citizen
Education: B.S., Decision Sciences and Management Information Systems
George Mason University: 2001-2005
Minor – Information Technology
Major GPA:
3.5
Skills:
• Maintaining and manipulating data using SQL queries, SQL/Access, Web Page
Design, HTML
• Microsoft Word, Access, Excel (Reporting, Creating Charts, Graphs, Pivot
Tables, VLookups, Extensive Formulas, etc.), Power Point
• Momentum Financials, Sharepoint, Clear Quest, Lotus Notes, MS Project, Great
with Numbers – good mathematical skills
Experience: AOL Dulles,VA
October 2008-March 2009
AOL is a subsidiary of media of Time Warner. The project involves development of
web-based directory information regarding the inventory of all the online
advertisement items. AOL also sells and distributes online advertising through
such subsidiaries as Advertising.com and search marketing firm Quigo
Technologies. Took part in the preparation of Project plan, user acceptance
testing. Got a detailed understanding of business functionality and took the
responsibility of preparing the test cases which was used during the testing
process.
Data Analyst/QA (Short-term Contract Project: Data Migration)
Job Responsibilities:
Developed Excel Sheets for the product migration and eliminated the
products that were not getting enough or expected impressions
Manipulated products related data in Excel sheets using wide-ranging
formulas, VLookups and conditional formatting
Used Pivot Tables extensively for data summarization
Loaded the migration related Excel Sheets on the system
After the load, performed Business functionality testing, which
involved manual testing of all core functions of the application
Involved in preparation of Test Plans for different modules and
documented test cases for various screens of the application
Executed the test scripts on different releases as well as in different
modes and validated the actual results against the expected results
Involved in the user acceptance testing during the launch
Recommended changes for improvement after analyzing operational
procedures and methods
Responsible for Regression testing after bug fixes and verified those
fixes
Responsible for data update on the database using the front door
application in Access
Used basic SQL Queries to extract reports
Participated in the QA activities for various sites and releases within
the Project
Participated in weekly product migration meetings
Worked on product inventory data sheets to ensure proper migration
mapping
Performance Inc. Chantilly, Virginia October 2007 – October
2008
Performance Inc. is a division of ADP that provides financial analysis and
reporting software tools to automotive manufacturers and dealers.
Data Analyst/QA (Short-term Contract Project: Data Migration/Conversion)
Assist in conversion of database from mainframe to SQL server, data
mapping, scrubbing and analyzing
Reporting on Data Anomalies via Excel sheets and charts and identifying
and resolving discrepancies in data
Providing QA Support for MS Backoffice Application for 15+
Manufacturers by creating test scripts and recording/tracking issue details
Creating Excel Sheets related to the statements for data quality and
maintenance using VLookups, Formulas and Pivots
Field definition and assignment, statement creation and mapping rollup
of statements to multi-dealer franchise statements
Documentation of QA activities, issues, enhancements, etc. and creating
user guides for training purposes
CGI Federal Fairfax, VA October 2006 – October
2007
Business Analyst/Data Analyst/Issue Verification
Department of Interior April 2007 – October
2007
Support the creation and/or create test scripts relevant to the
enhancements.
Testing functionality, ensuring proper quality assurance of the sites
specific to the client and comparing against baseline testing.
Developing, writing, executing test plan/cases and creating
documentation to update test cases.
Documenting defects in Clear Quest and provided detailed status reports
of defects within functionality.
Running queries using SQL to perform data verification, extracting
reports in Excel and creating charts.
Performing business analysis, project-related research, and
documentation.
Developed and maintained information and documentation related to
developing and modifying business process and system.
Managed the project plan to complete quality work on time and meeting
business requirements.
Momentum Delivery Support Team October 2006 – April
2007
Resolving all Momentum client account issues and questions in the
Remedy support requests.
Working on defects verification and logging issues discovered in Clear
Quest.
Working with developers’ to resolve the issues found in a timely
manner.
Communicating the defect resolution and verification details to the
client account teams via Clear Quest and emails.
Attend client meetings and prepare meeting minutes monthly.
Meridian Knowledge Solutions, Inc. Chantilly, VA
September 2005 – October 2006
Quality Assurance Specialist/Data Analyst
Learning Management System (LMS) Business Analysis
Conduct requirements gathering, analysis, and develop documentation for
administrator and user’s guides.
Working with clients and partner organizations to determine
requirements for ongoing site development, understanding clients’ objectives in
requesting changes and Coordinate development of new functionality for clients.
Participate in design meetings with the Product Management group to
analyze functional specifications of the product.
Manage development and implementation of the client’s site in
coordination with the other team members on deadline and within budget.
System Testing/Quality Assurance
Work with clients on reported issues (trouble tickets) throughout the
Software Development Lifecycle utilizing the Requirements Management System (RMS)
to track, manage, and report customizations and fixes.
Develop test plans and project plans, based on overall project
requirements and create, maintain and update test cases based on business
requirements.
Test product enhancements and fixes during the product release cycle
and on an as-needed basis.
Attend project meetings to report on status of testing, communicate
issues, enforce QA standards and policies, and set QA schedule.
Product Support
Provide administrative support for training sessions.
Complete basic programming tasks such as text changes and posting of
reports.
Respond to user inquiries in a timely and accurate manner through phone
and email support.
Navy Federal Credit Union, Vienna, VA August 2004
– July 2005
Workstation Analyst Intern
Providing support to the Information Center Branch, responding to first
tier Help Desk tickets
Applying basic skills necessary for the support and analysis of client
server systems and assisting in deployment of hardware and software
Completing inventory and asset management assignments, completing
various computer tasks using problem-solving techniques
Working with Access files to record important inventory information
Mortgage Releases Clerk August
2001-August 2004 & October 2000-June 2001
Preparing release documents on mortgages and generating the documents
for the clients
Utilizing proprietary software to verify and convey confidential
mortgage information to clients
Providing administrative support including data entry, cutting checks,
filing, faxing and copying
Personal Qualifications:
• Self-starter, dependable and highly-motivated worker
• Detail oriented individual with a positive attitude, excellent verbal, written
and organizational skills
• Good communication, problem-solving skills and easily adaptive to new system
and environment |