PROFESSIONAL SUMMARY:

• Sr. E - commerce/Retail Business Analyst with 7 + industry experience in business data modeling, software requirement analysis, process modeling, process flow and quality assurance skills using different methodologies, mainly OOA, OOAD and UML.
• Experienced working with Service Oriented Architecture (SOA), Software development life cycle (SDLC) and agile methodology.
• Experience testing web services / SOA (Service Oriented Architecture) applications using SOAP UI and QTP.
• Utilized Agile/ SCRUM and PMI methodologies to monitor, steer and develop project objectives.
• Extensive experience working with vendor e-commerce tools like Microsoft commerce as well as helping construct and integrate in-house ecommerce applications.
• Used Agile Software Development process viz. Scrum, as this was a time bound project.
• Excellent understanding of Data Models and Information Architecture and sound skills in SQL
• Design and review of various documents including the Software Requirement Specifications (SRS), including USE Cases, Business requirements document (BRD), Use Case Specifications, Functional Specifications (FSD), Systems Design Specification (SDS), Requirement Traceability Matrix (RTM) and testing documents.
• Documented systems based on Java and XML scripts that used Service Oriented Architectures(SOA)
• Managed the porting of old legacy platform applications into ATG Product suite (Campaign Management, targeted email distribution system, CMS content update management).
• Created business requirement documents and integrated the requirements and underlying platform functionality.
• Worked with systems area to translate business needs into system requirements.
• Senior level SQL query skills (Oracle and TSQL) in analyzing and validating Extract, Transform and Load (ETL) database data ware house processes
• Extensive success in translating business requirements and user expectations into detailed specifications employing Unified Modeling Language (UML) in an Service Orientated Architecture (SOA) environment
• Involved in Configuration Management, Requirement management and analysis
• Extensive experience in modeling the AS IS and TO BE ecommerce solutions
• Extremely proficient in using Agile and XP methodologies performed roles of Scrum Master following sprint sessions and used Rally software extensively to write User Stories, assign tasks to individual team members.
• Proficient in using UML in behavioral, structural and architectural modeling - in creating Use Case, State, Activity, Class and Sequence diagrams using Rational Rose
• Experienced working with Service Oriented Architecture (SOA), Software development life cycle (SDLC) and agile methodology.
• Experience in development methodologies like RUP, SDLC, AGILE, SCRUM and Waterfall
• Strong knowledge and experience in writing and executing SQL queries for database testing.
• Extensive experience in configuring data mapping between different Databases.
• Have good Agile methodology experience (Scrum, RUP, XP, i.e. Iterative Development and Project Management). Used User Stories in agile testing. Familiarity with UML and Use Cases.
• Strong communication, problem solving, organizational, interpersonal, and presentation skills.

TECHNICAL SKILLS:

Business Tools: Rational Suite (Requisite Pro, Rose, Clear Quest, Clear Case), MS Visio, MS Project, MS Access, Hybris, MS Office Suite, Visual Paradigm,DoorsErwin Data Modeler 4x, Business Object (Crystal Reports)

Business Skills: Business Definition Requirements, Business Process Analysis, Gap Analysis,Use Case Modeling & Analysis, Business Environment

Methodologies: RUP, OOAD, AGILE, UML & Business/Data Modeling

Testing Tools: Win Runner, Load Runner, Test Director, Quick Test Pro, PR Tracker

Operating Systems: Windows XP/95/98/NT/2000, Mac OS X, DOS, UNIX, Linux

Databases: Oracle 8i/9i; SQL Server 7.0 & 2000; Access 2000, MS SQL Server, MySQL,

Management Tools: Documentum, Sharepoint, Interwoven, Filenet

Languages: UML (Use case, activity

PROFESSIONAL EXPERIENCE:

Confidential, Hudson, OH

Sr. Business Systems Analyst

Responsibilities:

• Experienced in working with Time Deposit setups, renewal and management, and termination, Reg D rules and violations, conversion rules and regulatory requirements.
• Adept at Cash Pooling setup and management, the related governance and business rules.
• Prepared user training manual for merchandising team on managing commerce assets through ATG BCC (Business Control Centre).
• Worked on service oriented architecture (SOA), data warehouse, Informatica, ETL, SeeBeyond environments for integration of applications.
• Worked in an Agile Scrum environment. Attended internal trainings for Akamai, and XSS.
• Interfaced with business partners to capture business requirements, documented individual project requirements and reported the status of deliverables periodically.
• Defined the duplication of data and columns between tables using TOAD and SQL.
• Worked eCommerce Business Analyst on website rebuid/redesign on the e-commerce platform.
• Worked closely with business and cross-functional technology team members to document and communicate the business goals and objectives.
• Studied the working of the existing system to analyze the different kinds of reports that are to be generated for the senior management's review.
• Elicited requirements using interviews, document analysis, requirements workshops, business process descriptions and workflow analysis.
• Involed in bringing vendors into a development phase that matches or promises to reach the interoperability of a service orientated architecture (SOA) framework
• Custom tools upgrade client had created marketing, merchandising, promotion and product tools to support their custom web application which needed to be re-architected to work with ATGs eCommerce suite
• Collaborated with developers and subject matter experts to establish the technical vision and analyze the tradeoffs between usability and performance needs. Posed universal questions to define the project, estimated man hours required to accomplish specific tasks for budget purposes, obtained authorization; designed and constructed project plan and tested all areas of the project with focus on quality assurance.
• Performed Data mapping, logical data modeling, created class diagrams and ER diagrams and used SQL queries to filter data 
• Determined project scope and engineering requirements, estimated schedules, tracked item completion, certified milestones and maintained project documentation and corporate e-commerce web site Testing.
• Critically evaluated the information gathered from multiple sources, reconciled conflicts, decomposed high-level information into details and distinguished user requests from the underlying true needs.
• Assisted in documentation of Business Rules and Business Processes and worked on Multichannel Cockpit.
• Worked with internal product management teams to include this functionality in the product release cycle. Ensured that the product, client and 3rd party teams were in agreement with the requirements
• Assisted in developing test scripts and test plans for the UAT phase.
• Created Requirement Traceability Matrix between Business, System and Functional specifications.
• Assisted in identifying defects and also in status reporting with Quality Center. Also provided post conversion/implementation support. 

Environment: Windows XP/2000, Oracle, PL/SQL, MySQL, MS-Project, MS-Office Suite, MS Visio, Rational Requisite Pro, Clear Case, Clear Quest, JavaScript, MS Visual Source Safe, AGILE, WebSphere, SOA, Quick Test Pro (QTP)

Confidential, Newton, MA

E-Commerce Business Analyst

Responsibilities:

• Working closely with the development team you will determine when new functionality is ready for UAT and will lead the testing activities
• Participated in the analysis design and implementation and enhancement of  ecommerce platfor
• Proposed solutions to reporting needs and develop prototypes using SQL and Business Objects that address these needs. 
• Preparing Detailed Requirement specifications, functional specifications, use case and work flow.
• With QA Manger design the execution of test scripts and Scenarios
• Business Process Redesign, roadmap planning and development proof of concepts
• Good work experience working with Web services developed using Service Orientated Architecture (SOA)
• Responsible for creating Business requirement Specifications to capture functionalities at all E-Commerce touch points.
• Provide support to the business in the form of hands-on help, if required, and deliver motivation to complete the testing within the required timescales.
• Develop and maintain sales reporting using in MS Excel queries, SQL in Teradata, and MS Access. Produce performance reports and implement changes for improved reporting. 
• Understand project plan and resourcing issues, allocating suitable staff to testing activities as needed
• Review test strategy and plans at regular intervals to assure appropriate coverage, making changes where appropriate
• Supporting documents that contain the essential business elements & detailed definitions and analyzed the system for the effectiveness of the E- commerce operations.
• Utilizes Web Services-Service Orientated Architecture (SOA) implementation into applications 
• Working with the Implementation Lead to find ways to improve processes and deliver efficiencies within the company
• Monitor and report on testing progress, raising risks or concerns as soon as they are identified
• Developed several detail and summary reports including line and pie charts, trend analysis reports and sub-reports according to business requirements using SQL Server Reporting Services (SSRS). 
• Provide effective management of testing activities and ensuring delivery to deadlines
• Planning, coordinating and managing test resources, people and facilities
• Manage and motivate staff at all levels
• Defining and embedding processes and procedures within the business
• strong client relationship by building trust, rapport and strong working relationship with ley sponsors, stakeholders and team member

Environment: Mainframes, COBOL, JCL, Db2, Quality Center, Oracle, Rose, MS Word, MS PowerPoint, MS Excel, MS Visio, LoadRunner, WinRunner

Confidential, Framingham, MA

Business Analyst

Responsibilities:

• Coordinated participation and sign-off of various business partners and customers.
• Utilizes Web Services-Service Orientated Architecture (SOA) implementation into applications 
• Evaluated existing e-Commerce applications to identify areas of improvement and carried out program enhancements and modifications. The prime focus was to develop key links and easy navigation to products & to enhance the customer's web interface and provide them with a more user-friendly online system. Staples/Paypal Integration
• Grouped the Use Cases and other diagrams into sequence and collaboration Diagrams using Rational Rose based on UML methods thereby defining the business process model.
• Created Use Cases for the applications and facilitated QA group to develop Test Plan and Test scripts based on Used Cases.
• Develop direct mail and email marketing initiatives using SQL. 
• Documented and Performed User Acceptance Testing (UAT).
• Involved in Staples online store Production Support that included incident troubleshooting and resolving tickets
• Managed project requirements for e-commerce platform upgrades of Christopher and Banks, (christopherandbanks.com, cjbanks.com), PetSmart (petsmart.com), Spanx (spanx.com) and new client store launch of Sony 
• Managed project requirements for new client store launches of Flavia ( myflavia.com), Forzani ( sportchek.ca), Mattel (shop.mattel.com), and Tumi (tumi.com, uk.tumi.com, tumi.de, intl.tumi.com). 
• Engaged clients to understand their business objectives, challenges and recommend solutions.
• Provided level of effort estimations and resource requirements 
• Identified and mitigated project risks and issues. Created and maintained risk and action item lists 
• Maintained and presented regular project status reports to clients and company leadership
• Analyze requirements utilizing various methods. (E.g. sample data from SQL queries, Screen Shots, reports, prototype screens, sourcing information, and other data models.)
• Supervised and reviewed deliverables of direct reports to ensure high quality. 
• Participated in a cross-functional team to drive process SDLC improvements to store launch projects.  
• Developed and implemented a new client pre-engagement process as part of a select cross-functional team to improve client education, change enablement, and preparation in advance of store launch projects.  
• Provided technical sales support in pursuit of new client prospects. 
• Having a common order management system to eliminate shadowing of trades from different system.
• 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.
• Developed Stored Procedures and User defined functions using T-SQL and PL/SQL and used them as metadata objects in  Framework
• Performed data analysis by using SQL queries using the DB Artisan tool
• Performs system administration duties related to the content management system. This would include developing process flows required for the development of workflows within Stellent that tracks all CMS-mandated content contributions.
• Extensively tested the web services from client side in Service Orientated Architecture (SOA)
• Involved in Business process design, streamlining, application systems analysis, object oriented analysis, system analysis and design, Quality Assurance and software verification and validation process.

Environment: Windows XP/2000, Oracle, PL/SQL, MySQL, MS-Project, MS-Office Suite, MS Visio, Rational Requisite Pro, Clear Case, Clear Quest, CMS, JavaScript, SOA, MS Visual Source Safe, AGILE, WebSphere, Quick Test Pro (QTP)

Confidential, IL

Business Systems Analyst

Responsibilities:

• Responsible for establishing the agile product development teams to transform the Marketing and Digital Sales technology support from traditional waterfall development. 
• Reviewed requirements together with QA Manager, Vice President of Human Resources & Business Analyst
• Provided recommendation for use of ATG eCommerce for B2B and B2C business.
• Facilitated four-hour long round table discussion with most HR directors, managers and analysts along with QA manager to get their input ad-hoc UAT in the project
• Created project plan, managed and implemented Enterprise-Wide & Attendance System and Enterprise-Wide SAP HRIS System.
• Performed requirements modeling and develop analysis diagrams, activity diagrams, sequence diagrams, state diagrams, data models, and use-case realizations using RUP tools in Agile
• Gathered requirements for the integration of POS system with the supply chain system
• Assisted with the BRD for the POS implementation project
• Served as Business Analyst for the To-Be Business Process Model for the Order-to-Cash workflow; documented current and future-state business processes using IndustryPrint Process Modeler.
• Extracted data from Oracle database with SQL Developer, and performed SQL query, data analysis, data ware and verification.
• Desktop application upgrade client created custom offline desktop application for their users to browse recommended fixes on products at their leisure which needed to be upgraded to work with new infrastructure, security and ATG eCommerce suite
• Reviewed Technical Specs together with the team of two developers
• Wrote Test Plans in MS Word for Manual Testing, System Testing, Integration Testing, Performance Testing, Regression Testing & reviewed their consistency with the business requirements.
• Performed White Box, Black Box, and Usability Testing
• Wrote Test Cases in MS Excel for user registration, access to training material, and activity log-in, reviewed the test cases and finalized
• Mastered all inbound functions in Warehouse Management Operating Systems (WMOS) 
• Performed Functional, GUI, Regression, System Integration, User Acceptance, Configuration and content testing for web-based e-Commerce application and Content Management System..
• Designed and developed Project document templates based on SDLC methodology
• Worked on several resolutions pertaining to, order to cash business process flow.
• Documented the outcomes of all the testing in MS Word and MS PowerPoint
• Developed automated Test Scripts in Win Runner using Test Script Language (TSL) for Functional Testing, Regression Testing, Data Driven Testing, Usability Testing, and Verifying Specific content through using Checkpoints
• Prepared PowerPoint slides of all the outcomes with the focus on defects and presented to the team of Business Analyst, VP of Human Resources, and the Developers

Environment: Mercury Tools (Win Runner 7.0, JDA, Test Director 7.0/7.5, Agile, Load Runner 6.5/7.0, Quick Test Pro 6.5, Quality Center 9.0), NT/00, SDLC,SQL, Ecommerce, SOA, SQL Server, XML

Confidential, Houston, TX 

Business Analyst

Responsibilities:

• Gathered business requirements by developing Specification Documents, Use Case scenarios for translating requirements into an application design.
• Developed documentation for POS Systems including Corporate Policies.
• Worked with the BRD for the POS implementation project
• Followed a structured approach to organize requirements into logical groupings of essential business processes, business rules, and information needs that insures any critical requirements are not misse
• Conducted Joint Application Development (JAD) sessions with IT groups & stakeholders to identify key changes in existing system.
• The Supply Chain scope includes the entire supply chain from production order to shipping & delivery and order management.
• Prepared graphical depictions of Use Cases, UML diagrams, created mockup design (UI screen)/ prototype using Microsoft Visio for new system
• Used Rational Unified Process (RUP) guidelines to strategize the efforts in overall software development process while assisting developers in system development
• Responsible for Data Extraction, Data Compilation, Data Analysis, Data Manipulation and Data Validation using SQL queries in a MS SQL Server 2005 environmen
• Generated XML documents using the XML Output Stage.
• 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.
• Provided day-to-day project management supervision to clearly communicate the project path, timelines for project delivery, and managed resources to successful completion.
• Assisted to develop the Test Plan, Test Cases and Test Scenarios to be used in testing based on business requirements, technical specifications and/or product knowledge
• Involved in Inception Phase and prepared vision statement and initial data models that contain Business Requirement Documents and supporting documents that contain the essential business elements and detailed definitions.

Environment: MS Visio, MS Word, JAVA/J2EE, MS Excel, MS Power Point, MS Project, RUP, Rational Rose 2002, Rational Clear Quest, Rational ClearCase, SOA, Rational requisite pro