SPOORTHY RAJANA

****, ********* ***, #** *** Diego CA 92126

858-***-**** acvql2@r.postjobfree.com

OBJECTIVE:

To seek a challenging position as a Business/ Systems analyst position in Financial/ Retail/ Health care that needs innovation, creativity, and dedication and enable me to continue to work in a challenging and fast paced environment, leveraging my current knowledge and fostering creativity with many learning opportunities where I can apply the best of my analytical, management and programming skills.

SUMMARY:

Experience in writing SQL queries and optimizing the queries in Oracle and SQL Server 2008

Understanding the specifications for Data Warehouse ETL Processes and interacting with the data analysts and the end users for informational requirements.

Competent in Creating Unified Modeling Language 2.0 (UML) diagrams such as Use Case Diagrams, Activity Diagrams, Class Diagrams, Package Diagrams, Deployment Diagrams and Sequence Diagrams

Proficient in Unit Test Plans (UTP), Integrated Test Plans (ITP) and experience in User Acceptance Testing (UAT).

Involved in Test Planning, Test Preparation, Test Execution, Issue Resolution and Report generation to assure that all aspects of a Project are in Compliance with the Business Requirements

Good communication and interpersonal skills while dealing with business end users and developers to discuss the user requirements and functional specifications.

Ability to gather business and technical requirements from both formal and informal sessions utilizing a variety of software tools including, Use Cases and the Rational Unified Process.

Maintains professional and technical knowledge by attending educational workshops; reviewing professional publications.

EDUCATION: NATIONAL UNIVERSITY, San Diego, CA

Master of Business Administration, Graduation: June 2016

MAJOR: International Business

GPA: 3.78, Major GPA: 3.67

JAWAHARLAL NEHRU TECHNOLOGICAL UNIVERSITY, INDIA

Shri Vishnu Engineering College for Women, Andhra Pradesh, India

Bachelor of Technology, Graduation: June 2012

MAJOR: Computer Science & Engineering

GPA: 3.8

SELECTED COURSES:

Marketing Management, Statistics for Business, Economics for Managerial Decisions, Global Business, Managerial Accounting, Seminar in Financial Management, Topics in International Business, Business Strategy and planning, Managerial Support System, Organization and Leadership

EXPERIENCE:

Business Analyst

Tata Consultancy Services, Hyderabad, INDIA May 2012 – Jan 2015

Responsibilities:

Part of testing team supporting products beginning with early development cycles through end of life.

Monitoring performance analysis, failure analysis on products to trace down issues and resolve them with recommended solutions.

Regular viewing of trends and then generating charts to identify top field issues.

Created project plans for multiple projects and allocated resources accordingly.

Involved in Change Request meetings to document changes and implemented procedures to test changes

Designing and improving the test methods and procedures for measurement, documentation, work flow techniques based on the project plan.

Reporting up-to-date status on all the products to the Project Manager.

Communicating successfully with cross-functional development teams to troubleshoot related issues

Execute all the test case and report defects, define severity and priority for each defect.

Carry out regression testing every time when changes are made to the code to fix defects.

Improved several processes within the team to increase the efficiency of the deliverables by introducing time tracking and team review sessions focused on every individual.

Environment:

Web Technologies : HTML

Languages : C++, C, JAVA, SQL, PL/SQL, HTML, XHTML, CSS

Software : SharePoint, MS Visual Studio, Eclipse, Microsoft Project

Database : MS-SQL Server 2008/2012

Operating Systems : Windows 98, 2000, XP

Expertise : Social Network Analytics, Experimental Design, Data Driven Experimentation

Office Assistant May’ 15 – Dec’ 15

International Programs Office, National University San Diego

Duties and responsibilities include fielding telephone calls, directing visitors and students.

Updating students contact information, schedule/cancel tutoring appointments, and as well as monitor student and tutors visit records in to the university database.

Provided timely and courteous notifications to students and tutors when changes need to be made to scheduled appointments.

Maintained confidential student information.

INTERNSHIP: Vedams Software Solution December 2011-March 2012

Role: S/W Developer

Developed a database-driven e-commerce website using Java with functionalities such as login page, email page, protected page, product catalog, administration page and shopping cart.

Designed warehouse using SQL Server Integration Services (SSIS) and Visual Studio following the ETL logic and wrote queries to perform analyses

ACADEMIC PROJECTS:

Market Analysis (November 2015)

Introduction of Hotel in New Zealand

Market Analysis for new Hotel Introduction

Trends and Financial analysis

Requirement Bi-Directional Traceability Matrix (Jan 2012-Mar 2012):

Designed and implemented a complete working database to manage client requirements during an application development

Documented working database to facilitate its maintenance

Designed database using Oracle 10g and SQL plus

LEADERSHIP ACTIVITIES

President, Hostel Management, JNTU (2010 -2012):

Organizing hostel accommodation and looking after the issues and complaints.

Organizing the hostel staff and lunch/dinner menus.

Constructing and maintaining web sites, helping new students.

Board Member, College Event Organization Club (August 2009 - Dec 2011):

Organized cultural events and case-study competitions.

Officer, Women Entrepreneurship Club, JNTU (Nov 2010 - Jan 2012)

Discover and support students, faculty, and local businesses to achieve their business plans.

Promote entrepreneurship on and off campus, and manage entrepreneurial projects.

Contact this candidate