Administrative Assistant Project

PRIYANKA TRIPATHI

*** ******** ** ****: 415-***-****

San Ramon, CA 94582

Email: ************@*****.***

SUMMARY QUALIFICATIONS:

• Over 3 + years of extensive experience as an Administrative Assistant.

• Extensive experience in scheduling meetings and managing calendars, drafting correspondence, conducting JAR sessions, formal/informal reviews,

walkthroughs with Subject Matter Experts (SMEs) and end users and ability to work as the primary interface between Business Users and External Sources.

• Strong management skills including detail oriented, multi tasking and excellent organizational skills. Utilize proactive and creative approach to work

responsibilities, strong telephone skills, and an ability to work with minimal supervision, excellent communication and interpersonal skills.

• Expertise in usage of Microsoft office software, Word, Excel (Pivot Table), PowerPoint, Access and MS Visio tools.

• Ability in creating professional correspondence and complete documentation including Data Filing, Document Formatting, and Document Validating.

• Well versed with Excel spreadsheets in scheduling, monitoring and forecasting the data, advantageous for Cost benefit and Gap Analysis.

• Proven track record in Data collection, Mail sorting and distribution, Photocopying, Scheduling, Material Organizing, Office Coordination, communication

and inter personal skills with ability to interact with individuals at all levels.

• Proven ability in creating Business reports through Pivot Table, Crystal Reports and managing Ad hoc reports.

• Advanced skills in MS Office Suite 2007, including intermediate knowledge in Microsoft Sharepoint and Adobe Acrobat/Reader software.

• I am a quick learner, decisive, flexible, and enthusiastic to learn new tools and technologies.

TECHNICAL SKILLS:

MS Visio, SQL, My SQL,. XML, UNIX, Windows Vista/XP/Windows 7, Mercury Quality Center 9.0, Desktop Applications MS Office suit like MS Excel, Access,

Word, PowerPoint, Outlook, Quality Test Professional 8.2., Lotus Notes.

Client: Kaiser Permanente

Location: Pleasanton, CA

Duration: Aug 2010 to Jan 2011

Role: Administrative Assistant

Project description: AWS Utilization application that tracks number of clients in the estate at a particular day and time.

The system worked with Excel and Access databases and generating reports on daily and weekly basis.

Roles and Responsibilities:

• Acted as liaison between cross functional team, conducting JAR sessions.

• Reviewed BRD, Responsible for maintaining the Excel spreadsheet for setting up the milestones.

• Maintained Access and Excel Databases.

• Developed Ad hoc Reports using Pivot Tables and Excel Charts.

• Managed Management Plans, which includes prioritized and individual risk mitigation plans.

• Maintained Word documents for change request and Requirements Traceability Matrix (RTM) across the deliverables of the project.

• Designed and enhanced reports for processing and financial information.

• Handled multiple tasks/projects concurrently, including Mail sorting and distribution, Photocopying, Scheduling, Material Organizing, Office Coordination.

Environment: Microsoft Office Suit including MS Excel, Access, Word, PowerPoint, Outlook., Lotus Notes.

Client: Target.com

Location: Minneapolis, MN

Duration: March 2009 May2010

Role: Administrative Assistant 1

Project Description: Target.com is developed to avoid maintaining huge amount of merchandise and more number of warehouses. According to the order placed Target

maintains vendors to supply the products from their warehouses and also helps to coordinate all the orders and to analyze the performance of the vendors.

Roles and Responsibilities:

• Conducted meetings and JAR sessions, managed calendars and correspondence, formal/informal reviews.

• Performed cost benefit analysis and Impact analysis for new vendors

• Created and reviewed Excel spreadsheets for analyzing and forecasting the data, advantageous for Cost benefit and Gap Analysis.

• Created Excel VBA Macro and Pivot Tables.

• Used Net Meeting to share my application to product managers and vendors.

• Developed SQL queries to perform Database pulling to analyze the performance of the vendors and third parties.

• Extensive documentation including Data Filing, Formatting and maintenance of database. Performed defect tracking and documented change request.

• Performed feasibility, adaptability study and risk analysis to identify the business critical areas from user perspective

• Performed gap analysis to compare the existing data with the proposed and documented new requirements and features.

• Prepared RTM (requirements traceability matrix) to analyze the actual work done and required analysis.

Environment: Windows7, PowerPoint, Excel (Pivot Table), Access, SQL, Text pad 4.6.2, Sharepoint

Client: NIIT Ltd

Location: Atlanta, GA,

Duration: May2007 Jan 2009

Role: Requirements Analyst

Project Description: The existing NIIT system launched business expansion through opening local franchisees business as NIIT LEDA. Were local students were

enrolled to learn new technologies and advance courses. The aim of project Element “K” was to centralize the whole system and have control over all LEDA centers and

train them to grow in the community.

Roles and Responsibilities:

• Conducted JAR sessions for Business Views with stakeholders to define the deliverables and to reduce the period required to complete deliverables.

• Developed prototype of purchase order management system.

• Documented and maintained Business Requirements document

• Carried out an in depth analysis of requirement, impact, processes flow.

• Performed planning and guiding the project calculating and providing timelines to the management.

• Followed UML based methods using MS Visio to develop use cases and activity diagrams.

• Acted as liaison between business unit, technology teams and support teams.

• Created and maintained project plan using Microsoft Project (MSP).

• Worked with SQL queries for data analysis.

• Performed cost benefit analysis and Issue tracking.

• Maintained Requirements Traceability Matrix (RTM) and Change Request Documents.

Environment: Windows XP, PowerPoint, SQL, Access, Excel, Text Pad, XML, MS Visio.

Client: Shan Marketing Services

Location: Chennai, India

Duration: Jan 2001 Jan 2003

Role: Management Trainee

Project Description: Vacation Resorts

Role and Responsibilities:

• Interacted with Internal Development Team for new business requirements, conducted JAR sessions

• Maintained Access and Excel Database and performing SQL Queries for data pull.

• Generated Reports through Pivot Tables, Crystal Reports.

• Performed planning and guiding the project from start to finish, calculating and providing timelines to the management / user function, listing and assigning

tasks, and clarifying any doubts on the requirements

• Followed programming of Agile Process.

• Maintained Business Requirement documents and Change Request Documents.

• Developed use case with UML for new product functionality using Visio.

• Responsible for maintaining project plan and setting up milestones

Environment: SQL, XML, MS Visio, MS Excel, Access, Word, PowerPoint, Outlook.

EDUCATION:

• Credit Courses in Visual Basic, SQL and Introductory Database Design from College of Marin, San Rafael CA.

• Diploma in Systems Management, NIIT India.

• Bachelor in Commerce (Equivalent to BS), Kanpur University, Kanpur, India.

Work Permit: EAD

Contact this candidate