SUMMARY:

• Over 5 years of experience as a Business Analyst experience, having Complete Life Cycle experience across multiple organizations i.e. Gathering Business Users Requirements, System Analysis, Development and Testing.
• Experience in business analysis, systems analysis and design in large-scale projects across multiple organizations
• Involved in conducting JAD sessions to Gather Requirements
• Functional as well as Technical expertise on Data warehousing and Business Intelligence domain.
• Proficiency in writing technical documents such as BRD, SRS and SDD Documents.
• Experience with Agile methodologies for software development
• Excellent knowledge of Oracle database, SQL and data warehousing concepts.
• Extensive use of SQL queries.
• Hands-on experience testing web-based and desktop applications: writing and executing test cases: running Functionality, Regression, GUI, Usability tests; reporting software defects and following up with fixed bugs.
• Strong knowledge of QA methodologies and concepts.
• Extensively used Omni.
• Experience with using and maintaining documents on SharePoint 2010.
• Experience using Rational Clear Quest and JIRA.
• Extensively used Advanced excel and Omni for Data Analysis.
• Extensively used pivot table, charts in excel.
• Used DOORS to enter the requirement.
• Excellent communication skills and experience working with business user’s community and leads/managers.
• Exposure to various Business Intelligence tools including Oracle Business Intelligence Enterprise Edition (OBIEE), BI Publisher, Cognos, Business Objects

EDUCATIONAL QUALIFICATIONS:
MBA in Information Technology
Diploma in Web Design
Diploma in Computer Application
Bachelor of Commerce

TECHNICAL SKILLS:
Operating Systems: Windows Vista/XP/NT, UNIX/LINUX, DOS
Programming: C, C++, SQL, PL/SQL, Visual Basic, Java, Javascript, HTML, XML
Database: Oracle 9i/10g, MS Access, Teradata
Applications: Oracle Business Intelligence (OBIEE 11g (Admin, Presentation Services), BI Publisher, Omni, SQL*Plus 8.x/9.x, PL/SQL 8.x/9.x, Toad, SQL developer

WORK EXPERIENCE:

Confidential, 12/2011– Till Date
Arlington, Virginia Business Analyst
Confidential,an independent federal agency, issues limited-term grants and cooperative agreements to individual researchers, groups of investigators, and research centers to conduct scientific and engineering research. The intention of this project is to provide an alternative option to report panel information to Program Officers in the event of PARS outage. The Panel Reporting Utility OBIEE dashboard provides NSF Staff select PARS data mat. This audience will access the Panel Reporting OBIEE Dashboard to view panel-related reports.

Responsibilities:

• Involved in Gathering Requirements with stakeholders.
• Conducted meetings and JAD sessions
• Involved in pre sprint planning sessions.
• Acted as Project Manager.
• Did Gap Analysis
• Conducted demos to business users for Panel Reporting and Award Manager.
• Interacted with the end users and stakeholders to validate requirement.
• Involved in created use cases and Activity Diagram.
• Involved in pre sprint planning sessions.
• Worked on Panel reporting Report center and Award Manager projects
• Created the flow diagram using Visio 2007
• Was involved in creating help files for end users
• Worked with testing team to incorporate the test cases for Panel Reporting.
• Executed SQL Queries to provide the testers with sample test data.
• Maintained documents on SharePoint 2010.
• Actively involved with the testing team to sort out the test scenarios
• Involved in Regression and Functional Testing of Award Manager web application.
• Was involved in writing Technical Design Document.
• Created the SDD (System design document) and SRS Template
• Conducted the Sprint planning sessions
• Created help file for the end users.
• Entered ARs and MRs and maintained a excel sheet to track the status
• Created ETL mapping document for Award Manger and Panel Reporting.
• Maintained documents in SharePoint site
• Was involved in Configuration Management Activities.
• Tracked the status of all the team members on daily basis in Sprint excel sheet
• Created ROM for new project
• Validated the Requirements for HRM Reporting.
• Created document for 508 Compliance.
• Used Rational Clear Quest to enter MR and AR and verify the closed bugs.

Environment: Oracle Business Intelligence, Oracle 10g, Toad, SQL developer, Visio 2007,MS PowerPoint , MS Excel, Rational Clear Quest, SharePoint, SAS.

Confidential, 04/2010 - 11/2011
Charlotte, NC Business Analyst
Confidential,Plan must be established and administered pursuant to a written document a written document which contains all material term. Project was generating the ERISA reports for various institutes using OBIEE tool. Aim of the project was to create, maintain and also enhance them as per the requirement BIP was used to develop the reports.

Responsibilities:

• Involved in gathering business requirement for different views of report i.e. charts, Pivot table, Titles, Graph, Filters etc. and added column selector, view selector and narrative view to the reports.
• Interacted with the Business users and did gap analysis
• Translated the Business Requirement into Functional Requirement.
• Was involved in creating RTM( Requirement Traceability Matrix)
• Used Rational DOORS to enter the requirement
• Wrote SQL queries and executed them to modify the BI Publisher reports.
• Executed queries to provide the testers with sample data.
• Extensively did Unit, Regression, Integration testing and UAT
• Was involved in entering the requirement in QC (Quality Center).
• Tested the various reports and validated it against Omni.
• Created BRD and FSD for the login screen of the financial institutes.
• Was involved in entering the bugs in JIRA
• Strong experience with Agile/Scrum development processes.
• Involved in Configuration Management Activities.
• Was involved in creating training material for End users.
• Was involved in maintain the project documents on Sharepoint.
• Used Rational Clear Quest.
• Entered MR and AR in Rational Clear Quest.

Environment: Rational Clear Quest, OBIEE 11g, BI Publisher, Teradata, Micosoft office 2010, Rational DOORS, Sharepoint, Quality Center, Omni

Confidential, 01/2010-03/2010
Palo Alto, CA Business Analyst
Confidential,is a video management and monetization technology provider that helps content owners and aggregators expand their video revenues.

Responsibilities:

• Involved in gathering business requirement.
• Actively involved in wring BRD and FSD.
• Tested the Ad Platform developed by Auditude.
• Conducted JAD Session.
• Manages requirements traceability information and tracks requirements status throughout the project
• Tested features like creative, billing, custom group, Content library, Reporting, Geo.
• Analyzes and documents business requirements / processes and communicates these requirements to stakeholders.
• Did Functional, Ad-hoc, GUI, smoke, acceptance testing of the application. Provided regression testing whenever there was a new build or a new functionality was added.
• Entered the bugs in JIRA
• Involved in browser compatibility testing of the application on MSIE and Firefox
• Made enhancement suggestion for the product.
• Strong experience with Agile/Scrum development processes
• Wrote Use Cases and created Flow Diagram for the process
• Automated Campaign Manager test cases using Selenium.
• Tested the Ad sever by using Charles Proxy and reading XML files.

Environment: Web applications, JAVA, Oracle 10g, Toad, SQL developer, XML editor, Selenium, JIRA

Confidential, 06/2009-12/2009
Los Altos, CA Business Analyst The audience management platform allows clients to interact-with, profile, analyze and grow their audience across media, driving revenue from lead generation, advertising and E-commerce activities. It is a web based application.

Responsibilities:

• Reviewed Requirements provided, as well as existing test documentation.
• Set up meeting with the business users.
• Was involved in UAT.
• Understood the functionality of the application, created and maintained test cases and test documentation for designated areas.
• Performed manual, functional, regression, usability, acceptance and ad-hoc testing of Web-based application.
• Was involved in the black box testing by validating and verifying various inputs given to the application.
• Wrote easy-to-follow bug reports. Reported cosmetic bugs by taking screen shots so as to make them easy to understand.
• Created and maintained data driven tests cases using Selenium IDE.

Environment: Web applications, JAVA, Selenium, Oracle 10g, Toad, SQL developer, XML editor

Confidential, 02/2009 – 06/2009
Los Altos, CA Business Analyst
Confidential, is a web-based video-on-demand application, which allows users to subscribe and watch movies online

Responsibilities:

• Tested web-based video-on-demand application, which allows users to subscribe and watch movies online.
• Tested various areas of the application including Uploading, Playing Movies, New Customer Registration, Adding Play Lists, Adding friends, sending messages, Editing the profile, requesting movies and adding comments to name a few.
• Performed testing on different browsers like Firefox, IE, Chrome, Safari.
• Provided localization testing of many pages and profiles in Hindi and English.
• Reported software defects utilizing Bugzilla, a web-based bug tracking application.
• Extensively used JIRA.
• Verified fix for resolved bugs.

Environment: Web Applications, Java, Oracle 10g, Toad, SQL developer, Bugzilla, JIRA

Confidential,CA 01/2008 - 09/2008
San Francisco, CA Business Analyst
Confidential,software records the usage of all Logitech devices (namely mouse & keyboards). The Arlberg project dealt in creating business intelligence solutions to analyze the product usage data collected by the LUE software to calculate the Logitech product’s performance and lifetime.

Responsibilities:

• Participated in requirements gathering by meeting with the business user and base lining the details, preparing the documents and conducting application demonstration
• Documenting the Business Requirement Document, Technical Design Document. and Creating FSD
• Extensively used Advanced Excel.
• Was involved in conducting JAD session.
• Created UML Diagram.
• Provided training for the end user for UI analysis.
• Entered the requirement in Quality Center.
• Documented every phase of the project- Business Requirement, UI functional Specification Doc, User Guide, Test cases.

Environment: Quality Center, Toad, SQL developer, notepad++, Microsoft Office.

Confidential, Jun 2004 - May2005
Bangalore, India QA Analyst
The project consolidated multiple regional applications into one single application. At the database level all the oracle databases were merged into a single oracle database. This required to analyze the different source databases from all different regions and mapped fields into the new database.

Responsibilities:

• Writing SQL Queries on different Oracle databases and pulling sample data into excel
• Gather requirement using word.
• Was involved in extracting data from different databases into Excel sheet.
• Did data comparison in excel sheets using sorting and filtering.
• Used conditional and simple functions in excel to do calculations and grouped the worksheets.
• Used advanced excel features like Vlook, Sorting and Auto sum.
• Data cleansing rules e.g. address table cleanup, SSN cleanup, skillset clean up
• Mapping data between old databases and new database
• Verifying sample data in target database after data migration
• Involved in making ER diagram.

Environment: Oracle, SQL, Microsoft Office suite, ERWin, MS Powerpoint.