SUMMARY:

• Business Analyst / System Analyst with 7+ years of hands - on experience in the field of ecommerce with focus on business modeling, requirement gathering, technical documentation, software validation and web application services.
• Valuable knowledge and proficient in utilizing e-commerce tools such as Web Sphere Commerce, Adobe Online Marketing Suite by Omniture to create site improvement recommendations to augment sales strategies and price Optimization.
• Proficiency in utilizing e-commerce tools to create site improvement recommendations to augment sales strategies and price optimization.
• Highly proficient in writing User stories, creating Use Cases, Use case diagrams, Activity Diagrams, Sequence Diagrams, and Class Diagrams etc. Extensively experienced in using MS Visio.
• Excellent business writing skills for Functional Requirement Documents (FRD), Business Requirements Documents (BRD), and Systems Requirement Specification (SRS).
• Involved in conducting Joint Application Development (JAD) sessions with business users, business system analysts, SMEs, software developers, and QA team.
• Strong knowledge of software Development Life Cycle (SDLC) and Software Testing Life Cycle (STLC), methodologies like Agile, Waterfall and Rational Unified Process (RUP).
• Experience in designing Process Flow and Data Flow diagrams to document Business processes.
• Able to effectively converse, relate and liaise with multi functional teams, including business owner, stake holders, managers, architects, developers and testers at all levels.
• Expertise in understanding of Data Warehousing, OLTP and OLAP. Experience in SQL queries for creating database, Data Mapping Document, data modeling, and ETL.
• Extensive knowledge and experience in Optimizing SCM, Reducing Inventory & Holding cost, Manufacturing Process Improvement, Supporting and enhancing POS (Point of Sale systems) in Retail Domain
• Extensive experience in providing effective e-commerce solutions to complex administration and content management issues, including server-based and third-party shopping cart, systems, cross-product marketing, shipping gateways, placement strategies, category/product oversight, and other daily functional e-commerce operational tasks.
• Extensive experience in the Retail and e-commerce environments with knowledge of Microsoft commerce ATG suite and web sphere.
• Extensive experience with Business-to-consumer (B2C) sales of tangible goods/online services and Business-to-business (B2B) scenarios, such as e-procurement
• Extensive use of MS Office tools like MS Access, MS Word, MS Excel, and MS PowerPoint MS Project for data migration in to the CI System Knowledge Data Base in Microsoft SharePoint. Used the ODBC/SQL to migrate all data to one database before uploading it into the Knowledge Base.
• Solid experience with SQL Server and T-SQL in constructing triggers, tables, user functions, views, indexes, user profiles, relational database models, data dictionaries, and data integrity
• Highly motivated team player with excellent Interpersonal and Customer Relational Skills, Proven Communication, Organizational, Analytical, Presentation Skills, and Leadership Qualities.

TECHNICAL SKILLS:

Programming Languages:  C,C++,C#,VC++,VB,VB.NET,C#.NET, ASP.NET, Java, SQL, PLSQ

Development Methodologies:  RUP, AGILE, Waterfall, ESDM, STV

Databases: MS-Access, MySQL, SQL Server, Oracle, Teradata, DB2, Sybase

Application Servers:  IBM Websphere, ATG Dynamo, BEA WebLogic.

Internet:  HTML, XML, VBScript, ASP, JavaScript, JSP, J2EE.

Automation Tools:  MS Visio, Rational Rose, Rational ClearCase, Rational RequisitePro, Documentum

Bug Tracking Tools:  Mercury TestDirector, Rational ClearQuest

Utility Tools:  MS Office Suite, MS Project, TOAD, Adobe Photoshop

Reporting Tools: Crystal Reports, SQL Server Reports (SSRS )

Data warehousing Tools:  Informatica, Business Objects, Cognos, Erwin

Testing Tools:  Quick TestPro (QTP), TestDirector, WinRunner, LoadRunner, Niku Project WorkBench

PROFESSIONAL EXPERIENCE:

Sr. Ecommerce Business Analyst

Confidential,Seattle,Washington

• Monitored, analyzed and reported performance of website using site analytics tools such as Google Analytics and Omniture, mainly focused on key business metrics that drive the business including traffic drivers, site sales, conversion, site experience, site functionality, etc.
• Collaborated with members of the Ecommerce team as well as Merchandising, Creative, and Brand Marketing teams to provide analytic support to measure performance of efforts. Assisted end-users in identifying key performance indicators for their areas and proactively share knowledge and learnings.
• Performed gap analysis for the reports which needed to be upgraded for Excel 2007. Some of the reports had already been upgraded by JIRA request. Also, had meetings with Business team to identify the list of reports used by particular client.
• Used JIRA to track tasks and Quality Centre to track open bugs, worked with BA and developers to ensure identified issue are resolved in a timely manner.
• Maintained daily and weekly dashboards. Support the creation and on-going maintenance of daily, and weekly KPIs.
• Assisted in gathering and analyzing consumer feedback to inform product, website, or functional enhancements.
• Work with business sponsors and stakeholders to understand business requirements and develop technical specifications for projects.
• Identifies data sources, constructs data decomposition diagrams, provides data flow diagrams and documents the process.
• Worked to define the overall Ecommerce strategy and executed overall plan and tactics
• Tracking all assigned work using the JIRA project management application, while assuring that all relevant projects are followed through to completion.
• Manage iterations using JIRA/ Grasshopper plugins for Agile sprint management
• Responsible for review of reporting from third party vendors relating to campaigns - work closely with Senior Director of Ecommerce and Director of Strategy to ensure ROA.
• Create and Maintain KPI dashboards for application backlog, test coverage, and processing map coverage.
• Analyzed E-Commerce business gaps and opportunities, elicited and captured complete and unambiguous user requirements, and break down complex processes into workable units.
• Identifies data sources, constructs data decomposition diagrams, provides data flow diagrams and documents the process.
• Oversee, coordinate, and participate in organizational, operational, and procedural analyses to determine information input, and desired output for potential and/or up dated computerization for a large number of users in support of a multi departmental or country wide applications.
• Collaborated with business users and cross functional teams to develop the BRD (Business Requirement Document) and define KPI's (Key Performance Indicators)
• Reviewed and analyzed variety of forms, documents (RT or Approach Framework) reports, data output, and record-keeping requirement to identify any questions or requirements POS team has. Contribute in weekly staff and Analyst/Dev Meetings.
• 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.
• 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 with developer leads and managers, System Testers & UAT; to review requirements of the project, status of testing and any issue needing discussion.
• Synchronized POS and cross team delivery schedules to ensure needed resources are available. Tools & Technologies.
• Involved with all the phases of Software Development Life Cycle (SDLC) methodologies throughout the project life cycle.
• C reated DTS and SSIS Packages to vendors in which records were loaded Daily, also to other data resources such as Excel, Access, flat file, and XML in order to Create and maintain a centralized data warehouse .
• Analyze requirements utilizing various methods. (E.g. sample data from SQL queries, Screen Shots, reports, prototype screens, sourcing information, and other data models.)

Confidential,Cincinnati OH

Ecommerce Business Analyst

Responsibilities:

• Maintained records and statistical information for E-Commerce managers, E-Commerce personnel, other departments and outside vendors.
• Performed requirements modeling and develop analysis diagrams, activity diagrams, sequence diagrams, state diagrams, data models, and use-case realizations using RUP tools in Agile/Scrum.
• Utilized Agile/ SCRUM and PMI methodologies to monitor steer and develop project objectives.
• Develop marketing strategy for Business Partner online Billing Portals for ecommerce using Web Analytics from CRM platform.
• Using JIRA Agile, groom and prioritize the issues backlog. Participate in sprint planning and daily scrum practices.
• Determined project scope and engineering requirements, estimated schedules, tracked item completion, certified milestones and maintained project documentation and corporate e-commerce web site Testing.
• Responsible for requirements gathering, analysis, detailed process flow design, user acceptance testing and rollout of new & modified feature functionality deployed on the E-commerce website applications.
• Worked on Agile Methodology. Created and managed a backlog of clearly defined and prioritized user stories.
• Gathered requirements from the end-users and acted as a liaison between the end users and the development team and QA team.
• Develop individual department reports detailing key performance indicators (KPI).
• Desktop application upgrade client created custom offline desktop application for their users to browse recommended products at their leisure which needed to be upgraded to work with new infrastructure, security and ATG Ecommerce suite
• Created catalog test data (for ecommerce projects) using tools such as ATG BCC systems and the Catalog management tool maintained.
• Used JIRA to track tasks and Quality Center to track open bugs, worked with BA and developers to ensure identified issue are resolved in a timely manner.
• Used JIRA to log defects, assign severity of defects, assign priority as per project and generate reports.
• Managed High worth vendor accounts and performed key point indicators (KPI) to ensure profitable integrations through MS Access
• Involved with all the phases of Software Development Life Cycle (SDLC) methodologies throughout the project life cycle.
• Conversion of existing website to ATG software client moved from custom built application to ATGs Ecommerce suite
• Provided guidance to development team required to complete transition from Broadvision to Hybris Ecommerce platform
• Determined project scope and engineering requirements, estimated schedules, tracked item completion, certified milestones and maintained project documentation and corporate e-commerce web site Testing.
• Coordinated various kinds of User Acceptance Testing (UAT) including regression testing, system testing, integration testing, functional testing, alpha & beta testing.
• Prepared High Level Logical Data Models and BRD’s (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.
• Prepared test Data sets and performed data testing using the PL/SQL scripts. Also used MS excel for data mining, data cleansing, data mapping, data dictionary and data analysis.
• Develop and maintain sales reporting using in MS Excel queries, SQL in Teradata, and MS Access.
• Prepared test Data sets and performed data testing using the PL/SQL scripts. Also used MS excel for data mining, data cleansing, data mapping, data dictionary and data analysis.

Confidential,Reading, MA

Business Analyst

• Conducted user interviews, gathered requirements, analyzed the requirements using RUP methodology and documented the requirements using Rational Requisite Pro.
• Analyze B2C and B2B web properties and create new business plan, business requirements, and staffing requirements
• Gathered requirements for both B2B and B2C parts of the project.
• Performed Data mapping, logical data modeling, created class diagrams and ER diagrams and used SQL queries to filter data
• Performing end to end system testing of the customized ATG BCC tool. Preparation and execution of business scenarios to validate the implementation of the ATG ecommerce suite.
• Participated in the testing of B2B and B2C websites, including creating test plan and test cases, executing test cases(including regression and ad-hoc testing), and defect management
• XML is used extensively to communicate with web service component and to populate data at the client side
• Designed and developed project document templates based on SDLC methodology.
• Responsible for gathering requirements from users in operations group and performing data mapping for the application, confirm and vacillating the requirement at time of BA testing.
• Analyzed the system for the effectiveness of the E- commerce operations
• Responsible for all web development, E-commerce and optimization and web strategy and corporate website and self-service intranet site.
• Obtained Data requirements, identified data sources, determined the content of data fields and created Data Mapping Documents and performed Data Extraction and Data Compilation using SQL queries.
• Extracted the Business Requirements from the end users keeping in mind their need for the application and prepared Business Requirement Documents (BRD) using Rational Requisite Pro.
• Provided recommendation for use of ATG Commerce for B2B and B2C business.
• Created Process Flow diagrams, Use Case Diagrams, Class Diagrams and Interaction Diagrams using Microsoft Visio and Rational Rose.
• Authored various Use Cases and Activity diagrams, Sequence diagrams using Rational Requisite Pro and used UML methodology to define the Data Flow Diagrams (DFD).
• Apply UML notations and methodology in developing models that accurately represent the business process reengineering and workflows and clearly communicate them to the stakeholders.
• Maintained project plans, task, defect and issues lists, lead meetings to discuss all aspects of the project’s execution, developed test scripts, executed UAT, participated in the QA process, and developed training materials and system documentation.
• Facilitating workshops, JAR/JAD sessions, during the inception of the new web based application for the Portfolio Information.
• Created use-case scenarios and storyboards in MS Word and MS PowerPoint for better visualization of the application and managed them using Rational Requisite Pro.
• Worked as a User/Customer advocate and negotiated with user as well as the technical team and management staff to resolve any outstanding requirement conflict during the whole SDLC process.