PROFESSIONAL SUMMARY:

• Around 8+ years of extensive experience as a Business Analyst & Assistant Project Manager dealing with versatile business solutions, which includes ETL Testing.
• Wrote User Stories based on the requirements gathered from all the stake holders.
• Organized and facilitated Agile and Scrum meetings, which included Sprint Planning, Daily Scrums or Stand - ups, Sprint Check-In, Sprint Review & Retrospective
• Facilitated Agile adoption Retrospective for the organization with the leadership and guided teams with outcome resulting in enhanced performance.
• Developed Business Requirement Documents (BRD), functional requirement documents (FRD) and traceability matrix.
• Extensive Experience in Waterfall and Agile SDLC methodologies.
• Experience working with various requirements management tools such as Enterprise Architect, Version One, Rational Tools and others.
• Used JQUERY for developing and integrating slider for different applications used in the websites.
• Used JQUERY for developing Video and photo slideshow, and customization of the application according to the requirements and needs.
• Used Ajax and java script calls for driving data from the backend (Magento and Drupal) for cross site data transfer and display.
• Conducted interviews with users and Joint Application Development (JAD) Sessions for gathering requirements and developed Use Cases in UML using Visio.
• Developed Test Scenarios, Test Cases and Test Data for UAT.
• Strong in writing and documentation skills for the management, development and control of documentation.
• Highly proficient in creating Use Cases, Sequence Diagrams, Collaboration diagrams, Activity Diagrams, Class Diagrams etc.
• Proficient in analyzing Business/System requirements, Use cases, workflow analysis & automation.
• Experience with Business Process Modeling (BPM), Data-warehousing techniques & Document Management Automation Systems
• Highly proficient in Microsoft office tools including MS SharePoint, Access, Word, Excel, Project.
• Generated custom Reports, Dashboards and analytical snapshot for management and various business unit personnel to provide detail information on key performance indicators (KPI).
• Experienced in data migration and integration using Data Loader and IBM DataStage.
• Excellent communication, analytical, interpersonal, and presentation skills.
• Worked actively in various phases of System Development Life Cycle (SDLC) by implementing methodologies such as Waterfall, Rational Unified Process (RUP), Agile (Scrum).
• Skilled in Stakeholder analysis, management and communication by working with Executive, senior businesssponsors and technical specialists for proposing any new change in applications or building new applications.
• Experienced in working with SMEs and development team to design solutions for clients.
• Involved in eliciting requirements using documents analysis, requirement workshops, brainstorming, use cases and workflow analysis.
• Prepared Business Requirements Documents (BRD), Functional Requirements Specification (FRS), System Requirements Specification (SRS).
• Developed Use Case Diagrams, Sequence Diagrams, State Diagrams and Activity Diagrams using UML to make developers understand thebusinessand system needs.
• Experienced in facilitating and conducting Joint Application Design (JAD), Rapid Application Development (RAD), interviews, workshops and requirement elicitation sessions with stakeholders and end-users.
• Tracked, validated and communicated requirements using Requirement Traceability Matrix (RTM), Performed SWOT Analysis, Risk Analysis, Root Cause Analysis and GAP Analysis between As Is and To Be workflow models for conducting Enterprise Analysis.
• Highly experienced in Business Process Analysis & Engineering, Business Requirements gathering and documentation, Data Modeling, Database & Data Warehouse design, Data Migration from Spreadsheets to Application DB and development of Web Based applications and BRDs (Business Requirement Documents) supporting documents containing the essential business elements, detailed definitions, and descriptions of the relationships between the actors to analyze and document business data requirements.
• Collaborated with the technical team / Development/ QA teams to resolve issues/defects towards the satisfaction of the users. Participate in design reviews and provide input to the design recommendations.
• Proficient in analyzing Business/System requirements, Use cases, workflow analysis & automation.
• Proficient in writing Test Plans for Unit Testing, System Integration Testing and User Acceptance Testing (UAT).
• Highly initiative, self-motivated with excellent communication skills, Conflict resolution and presentation skills.
• Excellent communication and inter-personal skills, accustomed to working in both large and small team environments.

TECHNICAL SKILLS:

Operating Systems: Windows 98/2000/XP/vista/7.

Programming: Visual Studio 6: Visual Basic 6.0,Visual C, C++, HTML,SQL,TSQL, and JAVA

BI/Analysis Tools: Cognos, Datastage, Crystal Reports 6.0, MicroStrategy Office, Business Objects

Languages: T: SQL, SQL, PL/SQL, Java Script, Java, C, C++, Visual Basic

Management Tools: Star Team, Enterprise Architect, Version One, Rational Tools

Tools: /Utilities: Quality Center (HPQC), JIRA, SQL Server Management Studio (SSMS), Business Intelligence Development studio, DTS, SQL Advantage, SQL * Plus, Toad, Erwin, Eclipse, ExactTarget, Eloqua, Magento and Drupal

Databases: MS SQL Server, Oracle, MS Access

Software: MS Office, Adobe Photoshop, Adobe Acrobat, MS Excel, MS-Project 2000

Reporting Services: Excel, SQL Server Reporting Services, Crystal Reports

ERP/CRM Salesforce Technologies: Salesforce CRM, Salesforce SFA, Apex Language, Apex Classes/Controllers, Apex Triggers, SOQL, SOSL, Visualforce Pages / Components, S Controls, Apex Web Services, AJAX, Workflow & Approvals, Dashboards, Analytic Snapshots, Case Management Automation, Custom Objects, Apex Data Loader

PROFESSIONAL EXPERIENCE:

Confidential, Texas

Assistant Project Manager/Sr. Business Analyst

Responsibilities:

• Extensively involved in Requirement Analysis and Wrote User Stories based on the requirements gathered from all the stake holders.
• Met with Business stakeholders for detailed requirements elicitation and gathered business requirements through various interviews, and meetings to collect functional and non-functional requirements relating to client’s Salesforce CRM platform enhancement and initiatives.
• Developed, gathered and documented the business needs of clients and stakeholders.
• Organized and validated the requirements and ensures that all are traceable and measurable.
• Worked with Development, QA, and Release Management teams to come up with preliminary sizing of their respective efforts.
• Organized and facilitated Agile and Scrum meetings, which included Sprint Planning, Daily Scrums or Stand-ups, Sprint Check-In, Sprint Review & Retrospective.
• Implemented Sales cloud and incorporated the enhanced features as required to streamline the business process.
• Used JQUERY for developing Video and photo slideshow, and customization of the application according to the requirements & needs
• In parallel, worked on a side project to clean up the JIRA system, of redundancies and inaccuracies.
• Used JQUERY for developing and integrating slider for different applications used in the websites.
• Designed and maintained user roles, security, profiles, workflows, approval processes, and validation rules.
• Assisted in user acceptance testing (UAT) process including creating and validating UAT scripts and coordinating UAT process with users.
• Maintained data cleanliness and accuracy by adding custom validation rules, custom formulas, reports and dashboards.
• Extensively involved in Unit Testing using Test Methods using Force.Com utilities.
• Participated in the training sessions provided by the Salesforce team and support end users.
• Under the new executive leadership, part of creating the Project Management Office for Barnes and Noble, researched and created various templates to be used for implementing projects using Waterfall and Agile Scrum Methodologies

Environment: MS Office including Visio, PowerPoint, Word, Excel; MS Project, SQL Server Management Studio, Toad for Oracle, JIRA, SnagIt, Adobe Acrobat; SQL Server Database, Oracle Database; Java; Manhattan EOM, SAP, Oracle Financials.

Confidential

Sr.Business Analyst/ Delivery

Responsibilities:

• Defined and documented the scope of the project & developed Project Plans, Project Analysis and Project Deliverables.
• Worked with Salesforce team on continuous basis to discuss and document various business needs, requirements, development of the application, and to discuss and resolve any issues, changes, or problems during various phases of the SDLC.
• Developed, gathered and documented the business needs of clients and stakeholders.
• Organized and validated the requirements and ensures that all are traceable and measurable.
• Implemented Sales cloud and incorporated the enhanced features as required to streamline the business process.
• Designed and maintained user roles, security, profiles, workflows, approval processes, and validation rules.
• Assisted in user acceptance testing (UAT) process including creating and validating UAT scripts and coordinating UAT process with users.
• Designed customizations and configurations of SFDC objects, page layouts, workflows, document templates, data fields, reports and dashboards according to the business need.
• Imported excel based customer information records in to Accounts, Contacts and Cases using Data Loader and Import Wizard.
• Developed, documented, and executed test plans to assess the integrity and accuracy of business processes, module functionality setups and modifications, enhancements, customizations, and patches.
• Assisted the PM in capturing and reporting project measures to the appropriate stakeholders.
• Managed resources and project timeline using MS project based on Statement of Work.
• Created custom Dashboards for Sales manager’s home page to reflect their sales quota and sales team’s performance against the forecast and provided accessibility to dashboards for authorized people.
• Coordinated with Salesforce team and various internal teams for requirements elicitation, design, implementation, and testing phases of the application.
• Worked with various teams and helped them with data integration from various applications.
• Worked with outside vendors developing various applications for the client, and acted as a liaison between business, technical and QA teams of the vendor, and the client.
• Worked with offshore vendors as a project lead, assign, and kept track of the resources and timeline on an ongoing basis.
• Coordinated any changes necessary, documented them and followed them up through Change Request Process.

Confidential

Business Systems Analyst

Responsibilities:

• Interacted with stakeholders, managed stakeholder responsibilities through continual communication.
• Facilitated meetings with stakeholders through various elicitation techniques like JAD sessions, brainstorming, and interface analysis to identifybusinessneeds and rules.
• Established constant communication with the Project Manager and development team during different stages of the agile life cycle.
• Analyzed requirements and created use cases diagrams and activity diagrams using MS Visio.
• Created Use case descriptions and prototype to communicate those businessesneeds to the development team.
• Tracked and managed the requirements using the Requirement Traceability Matrix (RTM) which facilitates to trace the artifacts produced by the team throughout the project.
• Conducted structured walkthrough to conform the elicitation results to end users, developers and managers.
• Prepared training manuals and guidance documents by working withbusinessand technical teams.
• Performedbusinessrequirements traceability testing using the Requirement Traceability Matrix (RTM).
• Analyzed impacts of proposed solutions with the communication of key stakeholders.
• Collaborated with QA team in preparing test data for positive and negative test scenarios as per application specifications and writing test plans.
• Analyzed and evaluated the performance of the application from various dimensions and conducted User Acceptance Testing (UAT) for successful implementation.
• Conducted bug triage meetings to prioritize bugs in order to help streamline the QA efforts.
• Used Quality Center for tracking defects that were reported to development team during System testing and UAT.
• Assisted the PM in capturing and reporting project measures to the appropriate stakeholders.
• Managed resources and project timeline using MS project based on Statement of Work.

Environment: Windows XP, Windows 7, Oracle 11g, MS Visio, MS Project, MS Word, MS Excel, MS Project, Toad for Oracle, SVN, Salesforce, Business Objects, SnagIt.

Confidential

Business Analyst/ETL QA Test Engineer

Responsibilities:

• Analyzing requirement, FDS documents and understanding business scenarios to ensure the data will meet the business need.
• Involved with warehousing developers for understanding the application functionality and database structural design and workflows.
• Working on preparing BRD, FRD, Test Strategies, Test Plan and developing test scenarios for the coverage.
• Testing of Mappings and Transformations for validating the Business scenarios.
• Creating test scripts using SQL queries for validating backend data in source and target database.
• Validate the ETL job to extract data from source table to staging area, validate files using UNIX commands.
• Creating ETL Transformation test scripts, ETL test data, test conditions to validate mapping rules, transformation logic & data extraction/load using tool Data Stage.
• Using Quality Center for Test script creation/export, test execution, Bug Tracking, preparation of daily test logs and Defect reporting.
• Working with development team in resolving Defects, presenting the Defect Status reports and to understand the root cause of the defects.
• Participated in calls and regular project status meetings related to testing and providing WSR to onshore team.
• Participate in knowledge sharing sessions regarding product functionalities and testing with other team members.

Confidential

ETL QA Test Engineer

Responsibilities:

• Analysis of the specifications provided by the client
• Involved in testing, which includes preparation/execution of test cases
• Handled Enhancement requests
• Executing the ETL Jobs and Validating the ETL Datastage Jobs.
• Ensuring the Data Quality and Preparing the Test Data.
• Authoring the Check List of Reports.
• Validating the BI Reports.
• Ensuring all the Requirements are covered and Data loaded in DW is Satisfies to Mapping Document and Business Validations.
• Designing test cases and Responsible for review of test cases to ensure high quality deliverables.
• Raising and Tracking the Defects through Quality Center.
• Involved in Identifying Risks