SUMMARY

• Business Analyst with 8 years of diverse experience in e - commerce with focus on business modeling, requirement gathering, technical documentation, software validation andweb applicationservices.
• Successful and progressive experience in all phases of the iterative Software Development Life Cycle (SDLC) - Agile Scrum, XP, Rational Unified Process (RUP).
• Experience with different payment gateways (PayPal, Authorize.net) for e-commerce solutions.
• Expert in sales management systems, online advertisement, web analytics and SEO. Work experience in using web analytical tools (Google Analytics) to improve the online experience of customers and prospects.
• Experience to design placeholders for ads and integrate with ad-exchanges. Shopping carts, site themes and payment gateways in CMS like Drupal, Joomla and self hosted websites.
• Expertise in utilizing e-commerce tools such as WebSphere Commerce (WCS), ATG Web Commerce and Adobe Online Marketing Suite by Omniture to create site improvement recommendations to augment sales strategies and price optimization.
• Experienced in conducting Joint Application Development (JAD) sessions with business users, business system analysts, SMEs, software developers, and QA team.
• Excellent technical writing skills to create Business Requirements Document (BRD), Functional Specifications Document (FSD), Nonfunctional Requirements Document and Use Cases Specifications. Adept at designing business models using UML diagrams (Use Case Diagrams, Sequence Diagrams, Activity Diagrams, etc.) and BPMN.
• Good conceptual understanding of Data Warehousing, OLTP and OLAP. Experience in SQL queries for creating database, Data Mapping Document, data modeling, and ETL.
• Experience in both manual and automated testing tools in conducting QA testing and User Acceptance Testing (UAT). Hands on experience in reviewing Test Cases, Test Scripts using QC. Proficient in understanding and absorbing technology concepts.
• Highly motivated team player with excellent Interpersonal Skills, Proven Communication, Organizational, Analytical, Presentation Skills, and Leadership Qualities.
• Bilingual in English and Chinese

TECHNICAL SKILLS

• MS Windows
• OS X
• MS Office Suite
• MS Visio
• MS Project
• Adobe Photoshop
• Adobe Online Marketing Suite by Omniture
• WebSphere Commerce (WCS)
• ATG Web Commerce
• Google Analytics
• Dreamweaver
• HTML
• PHP
• Drupal
• Wordpress
• Joomla
• Rally Agile Project Management Tool
• Erwin
• Quick Test Pro
• Win Runner
• Load Runner
• Test Director
• IBM Rational Quality Manager
• HP Quality Center
• HP Quick Test Professional
• Rational Robot
• Access
• Oracle
• MS SQL Server
• Doubleclick
• Cheetahmail.

PROFESSIONAL EXPERIENCE

Confidential, Fort Myers, FL

Sr. Ecommerce Business Analyst/Scrum Master

Responsibilities:

• Used Google Analytics to analyze website usage, page views, traffic and exit to find out popular products and the reason why potential customers abandon shopping carts.
• Simplified check out process by simplifying customer registry process.
• Conducted email marketing based on customer preference.
• As a Scrum Master involved in creating and prioritizing the Sprint Backlogs in Rally Scrum Sprint Planning Sessions, conducting Sprint Retrospectives and Reviews, sharing metrics to identify, implement improvements, resolve conflicts among project stakeholders.
• Conducted JAD sessions with business users, SMEs, developers, QA team, and other stakeholders for open, pending and critical issues. Sessions focusing on IT strategies.
• Gathered requirements from the business and technical end to develop the mainframe and the web portal backend.
• Conducted gap analysis and played a major role in documenting functional and technical specifications.
• Studied user stories to deliver product as required. Worked with managers to create high-level approach/design for solutions.
• Created and managed project templates, user stories templates, requirement types and traceability relationships.
• Developed Use Stories, Sequence Diagrams, Collaboration Diagrams, Activity Diagrams, and Class Diagrams.
• Assigned problems to appropriate software development team for fixes.
• Designed SQL queries for Backend Testing and Report Generation accordingly based on the specifications.
• Assisted project leader for project management and delivering projects.
• Involved in creating a detailed System Test Plans, Test Cases and Test Scripts for different modules in the Application according to the Business Requirement Documentation.
• Used Quality Center to log all the test cases/scripts and generate a daily status report.
• Helped regression testing, UAT and tested the applications compatibility on different browser versions of IE, Firefox and Safari.

Confidential, Minneapolis, MN

Sr. Ecommerce Business Analyst/Scrum Master

Responsibilities:

• Added new items and promotions by using ATG Web Commerce.
• Managed multiple payment methods including PayPal, Confidential debit card, Confidential credit card in both website and mobile app.
• Proposed and completed Confidential cards online marketing, including banner advertisement and pop-up advertisement.
• As a Scrum Master involved in creating and prioritizing the Sprint Backlogs in Rally Scrum Sprint Planning Sessions, conducting Sprint Retrospectives and Reviews, sharing metrics to identify and implement improvements.
• Worked closely with data architects, developers, test managers, business stakeholders and project managers to achieve project objectives in defined time frames.
• Worked in Cross-functional team and resolved conflicts among project stakeholders and team members.
• Gathered and collected requirements resulting in detailed business rules, functional requirements and process design.
• Managed all the requirements with Rational Requisite Pro, making requirements available to all team members.
• Explained the existing (as-is) business processes using BPMN to support ecommerce changes required in project.
• Worked with a team to design the workflows and the wire frames and Mockups for the whole process from searching for a product to checkout, payment and delivery.
• Used Rally software to plan and execute the project staging on different level and assisted management on analyzing reports and data.
• Created UAT for end users and played a key role in Beta Testing to transit project smoothly to other levels.
• Prepared Test Reports and submitted the Bug Findings to the Bug Tracking system using Quality Center and its modules (Requirements, Test Plan, Test Lab and Defects).

Confidential, Huston, TX

Business Analyst

Responsibilities:

• Facilitated team meetings to coordinate activities for project schedules, presented deliverables to the management, conducted JAD sessions with Subject Matter Experts (SMEs) to elicit requirements.
• Documented an initial project glossary and an initial business case. Prepared initial vision and supporting documents that contained essential business elements, BRD, and detailed definitions.
• Proposed the use of pop-up advertisement and YouTube video advertisements for online marketing.
• Analyzed Business requirement document, developed functional requirement document (FRD) and got it approved by the client.
• Wrote clear, concise detailed system requirements specification (SRS) documents and user documentation in accordance to guidelines and standards of a level where developers can interpret, design and develop the application with minimum guidance.
• Used Rational Rose to create Use Case Diagrams and facilitated the design sessions to identify user scenarios
• Used Google Analytics to analyze the website and improve SEO.
• Uploaded videos on the website by using customer HTML module in Joomla.
• Efficiently interacted with designers and software developers to understand application functionality and navigational flow and keep them updated about business user’s specifications.
• Assisted project manager by using MS Project and used SQL queries to analyze various reports.
• Planned and executed all online sales initiatives and promotions by using WCS.
• Used Quality Center to develop Test Plan and Test Cases based on the Use Cases and Functional Requirements Specification
• Participated and assisted with the test teams in deliverable testing and quality assurance review to ensure that all the business requirements have been satisfied.
• Supported User Acceptance testing (UAT) and collaborated with the QA team to develop test plans, test scenarios, test cases and test data to be used in testing, based on business requirements and application knowledge.

Confidential, Englewood, CO

Business Analyst

Responsibilities:

• Implemented Google analytics to analyze the growth of current project to imply improvements. Developed reports of ecommerce conversions, engaged visitors, readers, bounce rate, and email tracking based on Google Analytics.
• Involved as a team leader in defining detailed business requirements and created a BRD and user stories using Excel sheets.
• Involved with onlinemediaplanning and working with ad-exchanges and networks.
• Communicated challenges and issues as appropriate to the Stakeholders and Scrum Master.
• Worked with clients to continually test, analyze, and optimize programs to increase registrations, conversion rates, engagement and more.
• Worked closely with the marketing team as well as the site usability team to improve overall conversion rate, providing data and analysis to justify required changes to the site marketing, user experience, pricing, CRM.
• Involved in email promotion, Search Engine Marketing, Display Advertising, Webcasting, social media and other campaigns with extensive knowledge on CPC, CPA and CPM.
• Helped monitor daily performance metrics to understand channel performance and diagnose issues.
• Built strong relationships with clients as well as internal and external resources and manage all phases of campaign development from concept through to reporting.
• Managed online marketing campaigns using tools such as Doubleclick, Cheetahmail.
• Conducted structure tests including home pages, category, landing pages.
• Involved in management of campaigns to continually improve campaign performance and grow productivity.
• Implemented search engine optimization (SEO) strategies with proven results.
• Served as liaison with third party web developers, photographers, SEO and SEM teams conducting daily, weekly and monthly check-ins on progress of projects

Confidential, New York City, NY

E-commerce Business Analyst

Responsibilities:

• Involved in the meeting withbusinessowner, SME (Subject Matter Experts) and marketing team to understand the scope of project.
• Established JAD (Joint Application Development) sessions to elicit and elaborate system requirements, developed architectural solutions and applications to meets business requirements; resolved open issues and change requests.
• Developed the FRD document for project by analyzing the feasibility ofbusinessrequirement.
• Prioritized user stories from product backlogs and helped generate sprint backlogs with Excel.
• Created use cases, test cases, ER diagrams, activity diagrams, business process models, project schedule diagrams, process flow diagrams using CRM and rational unified processing object oriented process implementation.
• Communicated with Java and GUI developers about the functional requirements.Also, handled change requests within thebusinessand IT.
• Developed creative ideas and improvements for site content, enhancements and site functionality.
• Involved in Content management system. Added items, shopping cart, payment gateways by using ATG Web Commerce.
• Evaluated the rational comprehensive approach to software development, featuring seamless integration between tools, service, best practices and current customer service tracking system to deliver a system concept to address the gaps.
• Produced executive reports on assigned projects to keep management apprised of project status, major issues, scope changes, resource changes and milestone achievements or misses.
• Ensured all products published on site for seasonal collection launches, promotions and all online events

Confidential, Huston, TX

Business Analyst

Responsibilities:

• Identified/elicited business requirements, generated Business Requirements Documents (BRD) by using MS Visio
• Oversaw digitization of all assets - conversion to online formats, intercampus access of archived audio/video material.
• Designed and implemented digital audio and video file databases within the library’s current framework, ensured compatibility with the existing OLTP.
• Managed solution implementation from inception to completion to create digital audio/video database for the library’s media services.
• Oversaw QA of database insertion, updating, deletion, tagging, and assigned attributes for data warehousing of content.
• Designed all transaction-related back end interfaces, including asset search and request, borrow request alerts, request approval/denial/activation, asset tracking, admin end asset search, user permissions management.
• Wrote all user end specifications detailing UI and system functionality for engineers to develop the administrative pages in PHP and Java Script.
• Acted as content ‘owner’ and system super user, managed and trained administrative users, managed user permissions.
• Communicated with other campuses to ensure seamless integration of application with their transaction processes.
• Managed and updated digitized audio and video files, and maintained system integrity and durability.