SUMMARY

• Business Analyst with over Seven years industry experience in business data modelling, software requirement analysis, process modelling, process flow and quality assurance skills using different methodologies, mainly OOA, OOAD and UML
• Extensive knowledge of all phases of the software development life cycle (SDLC) and the iterative Rational Unified Process (RUP)
• Good understanding of Store Warehouse Inventory Movement (SWIM),Store returns (RTI ),check in, chech out, Adjust in, Adjust Out., Transfer IN, Transfer OUT
• Expertise in ecommerce environment.
• Extensive experience with Business - to-consumer (B2C) sales of tangible goods/online services and Business-to-business (B2B) scenarios.
• Extensive experience in modeling the AS IS and TO BE ecommerce solutions
• Thorough working knowledge of SharePoint and MOSS (2007), (TFS) Team Foundation Systems and Visual Studio Team System (VSTS) 2008.
• Extensive experience working with vendor e-commerce tools like Microsoft commerce as well as helping construct and integrate in-house ecommerce applications.
• Extensive experience performing analysis with Omniture, and POLK data feeds and web based interfaces (Site Catalyst)
• Expertise in the use of tools such as Caliber RM, Rational Rose, Requisite Pro, Starteam, Test Director
• Proficient in using UML in behavioural, structural and architectural modelling - in creating Use Case, State, Activity, and Class and Sequence diagrams using Rational Rose.
• Strong experience in conducting User Acceptance Testing (UAT) and documentation of Test Cases. Expertise in designing and developing Test Plans and Test Scripts.
• Used Microsoft Visio for Business Process Modelling and Data flow diagrams.
• Worked with Rational Suite of tools to create requirements documents (Requisite Pro), visual data models (Rose), manage and track defects (Clear Quest).
• Experience in development methodologies like RUP, SDLC, AGILE, SCRUM and Waterfall
• Proficient in the use of tools like Tele logic DOORS, Rational Rose, Requisite Pro, Rational Clear Case, Tele logic System Architect and MS Visio.
• Experience in conducting GAP analysis, User Acceptance Testing (UAT). SWOT analysis, Cost benefit analysis and ROI analysis..
• Effective in executing multiple tasks and assignments ahead of schedule. Created and maintained effective budgets.
• Advised management on improvement strategies, Competitive & Profitability Analysis.
• Excellent in Business proposal Risk Assessment. Highly effective management and organizational skills with ability to prioritize.
• Exposure to Client/Server, Web Application developmental tools and Software development and design.
• Successful as a team player to work in conjunction with other DBA’s, testers, developers and other team members in validation and testing complex scenarios and projects and in the maintenance of Quality Standards in Projects especially with Test Director.
• Expertise in Analysis of Problem Severity, Defect tracking and reporting system.
• 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, MS Office Suite, SharePoint, Visual Paradigm, Doors, Erwin Data Modeller 4x, Business Object (Crystal Reports)

Business Skills: Business Definition Requirements, Business Process Analysis, Gap Analysis, Use Case Modelling & Analysis, Business Environment and Market Research Analysis.

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

Testing Tools: Win Runner, Load Runner, CaliberRM, 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, DB2

Languages: UML, C, C++, HTML, Java, SQL, PL/SQL, ASP.NET

PROFESSIONAL EXPERIENCE

Confidential, Indianapolis, IN

Sr. Business Systems Analyst

Responsibilities:

• 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.
• Co-authored business requirements document with project teams. Extracted, discussed, and refined business requirements from business users and team members
• Act as a resource in understanding how IS systems carry out business functions and assists in ensuring the timely and effective implementation.
• Worked with CA Clarity and Workbench for project/Portfolio management
• Modeled AS IS and TO BE processes using MS Visio
• Analyzed Business Requirements and segregated them into high level and low level Use Cases, Activity Diagrams / State Chart Diagrams using Rational Rose according to UML methodology thus defining the Business Process Models.
• Analyzed and documented the system specifications, Business requirements; used the tool DOORS for documenting, tracking and analyzing the requirements.
• Supervise and manage projects throughout SDLC to ensure that project management methodology based on RUP is followed during the project lifecycle using MS Project and NIKU Workbench.
• Used Rational Tools for creating use cases, version control and defect tracking, monitoring. Use Rational Unified Process (RUP) methodology in all areas of the software development life cycle (SDLC).
• Planned and defined Use Cases created Use Case diagrams, Scenarios and Use Case Narratives using the UML methodologies.
• Was involved n the creation of new E-Commerce Products (Arrival Notices and Customized Reporting)
• Worked with Front-end and Back-end systems
• Created relationships in Requirement Traceability Matrix linking Business Requirements to Functional requirements and Functional Requirements to Systems Requirements.
• Involved in Crystal Reports, SQL,Omniture, HBX / Visual Sciences (and various reporting and analytical tools).
• Performed the requirement analysis and documented the requirements using Rational Requisite Pro
• Designed flexible project foundation enabling rapid implementation of e-commerce website capabilities
• Custom tools upgrade client had created marketing, merchandising product tools to support their custom web application which needed to be re-architected to work with ATGs eCommerce suite
• Conducted Joint Application Development (JAD) sessions with IT groups. Identified the Key Changes, and participated in Stakeholder Management to communicate effectively with them.
• Used ERP business user information to create prototype business models and related business objects for Human Resources, Sales, Supply Chain and Finance which strongly supported ERP configuration using Business Process Modeling tool with UML and OOD
• Used DOORS to link requirements to test cases, business rules, design items to maintain traceability.
• Used MS Visio for Process modeling, Process mapping and Business Process flow diagrams.
• Created and managed project templates, use case templates, requirement types and tractability matrix in Requisite Pro.
• Managed workload, schedules and coordinated status review meetings with project managers, business managers and team members.

Environment: Java, J2EE technology, .NET, ASP.NET, SQL Server, UNIX / Oracle Platform, MS Visio, MS Word, MS Excel, MS Power Point, Omniture, DOORS, MS Project, RUP, Rational Rose 2002, Rational Clear Quest, Rational ClearCase, Rational requisite pro.

Confidential, VT

Sr. Business Systems Analyst

Responsibilities:

• Interacted with the business users and gathered requirements for the business definition.
• Documented the Process Flows for B2C and B2B in the High Level Requirements Document.
• Documented all the Detailed Design and Business Rules in Detailed Design Document.
• Created Functional Requirements Document (FRDs), Functional Specifications Document (FSDs) and Traceability Matrices for application development.
• Involved in the stack sessions, and met with all stake holders to understand, articulate, and document the requirements.
• Worked on projects which used RUP and Waterfall methodologies.
• Acted as a Subject Matter Expert (SME) on many occasions to explain in brief to the business users about the internal systems.
• Analyzed the system for the effectiveness of the E- commerce operations
• Facilitated JAD sessions with the management, developers and analysts from all the dependant systems/applications and business users to refine functional requirements and to perform the Impact Analysis.
• Created mock up diagrams using MS VISIO and provided the screenshots replicating the changes to the User Interface (UI) as per the requirements.
• Created spreadsheets using MS EXCEL in data gathering stages for requirements mapping.
• Managed the database using SQL and Unicas Affinium Campaign to execute queries against large data sets in an Oracle environment to generate lead lists for new and recurring marketing campaigns based on the documented business requirements.
• Extensive experience in modeling the AS IS and TO BE ecommerce solutions
• Conducted walkthroughs with the end users and stakeholders to gather the modification requests from the user to upgrade or change the specifications for the product.
• Worked on following applications Business Objects, Enterprise Architect, Toad, PlanView (project management), Microsoft Suite (Word, Excel, PowerPoint, Visio, Access, Project).
• Performed GAP Analysis, designed new business process flows, and documented various business scenarios.
• Conducted informal Sessions to develop an architectural solution that the application meets the business requirements, resolve open issues and change requests.
• Worked on MS Visio to design and create Process Flow Charts, Activity diagrams with Swim Lanes, Data Flow Diagrams and Use Case Diagrams.
• Prepared PowerPoint slides to effectively communicate with the business users and stake holders in the meetings.
• Wrote custom DOORS DXL scripts to perform periodic quality checks on database content.
• Used Test Director and Mercury Quality Center for updating the status of all the Test Cases & Test Scripts that are executed during testing process.
• Provided recommendation for use of ATG Commerce for B2B and B2C business.
• Develop direct mail and email marketing initiatives using Unica Affinium Campaign and SQL.
• Involved in mentoring specific projects in application of the new SDLC based on the Agile Unified Process, especially from the project management, requirements and architecture perspectives.
• Developed estimates, project plans (Microsoft project), training material, BI reports using Microstrategy
• Define and control requirements baselines in the program's requirements management system (DOORS)
• Extensively used Informatica client tools. The objective is to extract data stored in Oracle database, flat files to load finally into a single data warehouse repository, which is in Oracle.
• Used MS Visio for Process modeling, Process mapping and Business Process flow diagrams.
• Served as a Business Liaison between the Business Users and the Developers helping them in understanding the Functional behavior of the Internal Systems.
• Created Testing Requirements Document (TRDs) and Test Case Scenarios to test functional changes to the system/application as per the project requirements.
• Used XML to look up for the specific attributes and parameters needed for testing the web application in the QAT environment.
• Interacted with the testing team while developing the functional test cases and regression test cases

Environment: Oracle 8x/9i, MS Project, MS Office Suite, RUP, DOORS, UML, Rational Rose, Requisite Pro, Clear Case 2002, Rational Clear Quest 2002, MS office suite, MS Access, MS Visio 2003

Confidential, Salt Lake City, UT

Operational Business Analyst

Responsibilities:

• Gathered high level requirements and developed scope of the project for the implementation of Microsoft Office Share Point 2007.
• Conducted weekly meetings for deciding the Policies and Procedures to be followed while constructing new sites.
• Gathered requirements for the integration of POS system with the supply chain system
• Performed the requirement analysis, impact analysis and documented the requirements using Rational Requisite Pro.
• Designed and developed Activity Diagrams, and Sequence Diagrams utilizing MS Visio.
• Documented the server farm requirements and requirements related to security within Share Point and using Windows Active Directory.
• Followed a systematic approach to eliciting, organizing, and documenting requirements of the system.
• Responsible for creating Business Requirement Specifications, to capture functionalities at all E-Commerce touch points.
• Reviewed the Joint Requirement Documents (JRD) with the cross functional team to analyze the High Level Requirements.
• Created Physical Inventory process for retail stores, consisted of data integration and inventory processes with third party vendor
• Assisted with the BRD for the POS implementation project
• Captured and documented system level (SSS) and software level (SRS) requirements in DOORS supporting the SOW and system design for the SCL3S Airborne Communcations program.
• Interacted with client and the Technical Team for requirement gathering and translation of Business Requirement to Technical specifications.
• Conducted interviews, meetings and JAD sessions during the process of Requirement Gathering.
• Planned and documented procedures for data processing and prepared data flow diagrams for the application.
• Create technical design documentation for the data models, data flow control process, metadata management.
• Worked on exporting data using Teradata.
• Wrote detailed specifications for various reports generated using Cognos
• Developing the application on J2EE platform with Oracle 8i database programming. Combined the latest e-commerce technologies -enterprise business XML (ebXML), SOAP
• Analyzed the data collected and process maps to determine the root causes and identify opportunities.
• Planned and defined system requirements to Wire Frame with Use Case, Use Case Scenario and Use Case Narrative using the UML (Unified Modeling Language) methodologies
• Created business requirement documents and integrated the requirements and underlying platform functionality.
• Analyzed and translated business requirements into system specifications utilizing UML and RUP methodology
• Analyzed trading partner specifications and created EDI mapping guidelines
• Documented the Traceability Matrix for tracing the Test Cases and requirements related to them.
• Developed Data Conversion Strategy for converting data from the existing site to the new site.

Environment: Windows XP/2000, Oracle, PL/SQL, SharePoint, Omniture, Unix, Doors, MS-Project, MS-Office Suite, MS Visio, Rational Requisite Pro, Clear Case, Clear Quest, MS Access

Confidential, Portland, OR

Business Analyst

Responsibilities:

• Conducted user interviews, gathered requirements, analysed the requirements using RUP methodology and documented the requirements using Rational Requisite Pro.
• The project focused on Exceed suite of products and involved tracking of warehouse inventory in multiple locations.
• The aim of the project was to enhance the functionalities of various existing applications linked to ecommerce.
• Support for an inventory management value assessment to improve financial performance and the customer experience by reducing working capitals and supply chain costs, and improving on shelf availability.
• Created context and workflow models, information and business rule models, Use Case and Object Models during the analysis using rational tools.
• Served as a liaison between mortgage specialists and the project team.
• Performed Data mapping, logical data modeling, created class diagrams and ER diagrams and used SQL queries to filter data
• Identified and retail procedures for emerging retail chain
• Conducted business analysis, acted as a liaison between project manager, business users’, & IT team, and used MS Office for the documentation.
• Facilitated Joint Application Development sessions and facilitated stakeholder meetings to identify business process and requirements; exhaustive management of project requirements using CaliberRM
• Responsible for creating the Business Process Model for the Global New Account Opening utilizing the BPM methodology and notations.
• Core responsibility involved complete manually testing of the User Acceptance Test (UAT)
• Use Cases and other Process Flow Models were designed using Visio and Rational Rose.
• Conducted joint requirements planning (JRP) sessions as a facilitator to gather requirements from the business area and to discuss different critical success factors of the project like Operational Feasibility Analysis, Technical Feasibility Analysis, Cost Benefit Analysis & etc.
• Authored test plans, test cases for various test scenarios and helped testing team to better understand the test scripts.
• Worked on following applications Business Objects, Enterprise Architect, Toad, PlanView (project management), Microsoft Suite (Word, Excel, PowerPoint, Visio, Access, Project).
• Determined project scope and engineering requirements, estimated schedules, tracked item completion, certified milestones and maintained project documentation and corporate e-commerce web site Testing.
• Designed and created prototypes of reporting tools for data validation and verification initiatives using macros in Ms Excel.
• Used Test Director which is a Mercury tool to help manage defects and issues log during the testing phase.
• Involved in the creating the User Interface Specification Document and User Training Manual as per project specification with the help of development team
• Followed the UML based methods using Microsoft Visio to create: Use Cases Diagrams, Activity Diagrams, State Chart Diagrams, Sequence Diagrams and Collaboration Diagrams.

Environment: Rational Suite (Rose, Requisite Pro), Windows XP/2000, SQL, XML, CaliberRM, HTTP, MS-Project, MS-Office Suite, MS Visio, WinRunner, Load Runner, SharePoint, Test Director (Mercury Interactive), Java, Oracle

Confidential, Hudson, OH

Quality Analyst

Responsibilities:

• Lead Business Intelligence reports development efforts by working closely with Microstrategy, Teradata, and ETL teams
• Reviewed and analyzed the business environment and identified process improvements.
• Interacted with Business Users to conduct thorough Requirements Analysis.
• Involved in interactions with the Subject Matter Expert, Project Manager, Developers, and the End-Users.
• Coordinated activities with project manager and various other teams using MS Project.
• Responsible for cost estimation and timelines for various Business Intelligence reports
• Interacted with other Business Analysts for designing and implementation of Use Cases and Test Plans.
• Custom tools upgrade client had created marketing, merchandising product tools to support their custom web application which needed to be re-architected to work with ATGs eCommerce suite
• Develop Logical and Physical data models that capture current state/future state data elements and data flows using Erwin.
• Upgraded e-commerce web site engine by managing resources and responsible for installing new software version to increase site uptime by 3%.
• Design, development, implementation and roll-out of Microstrategy Business Intelligence applications
• Designed flexible project foundation enabling rapid implementation of e-commerce website capabilities
• Form the requirements and using technologies such as JavaScript, XML, LDAP, AML language (similar to XML), and TIBCO configure and provide custom enhancements to the client
• Performed requirements modeling and develop analysis diagrams, activity diagrams, sequence diagrams, state diagrams, data models, and use-case realizations using RUP tools in Agile.
• Assisted in on-going process improvement efforts to ensure Test Planning, Execution, and Reporting is effective, efficient, standardized, coordinated, and integrated.
• Automated Shell scripts to pull and load data from operational resources into the Data Staging Area and Data Warehouse for business intelligence reporting.
• Assisted the Senior Business Analyst in writing Functional Requirement Specifications (FRS) and User Requirement Specification (URS).
• Developed Test Plans and Test Cases according to Business Requirements.
• Provided clear and concise documentation regarding requirements management plans, Functional Requirements, supplemental Requirements, Test Plans and Test Cases.
• Acted as User Acceptance Testing coordinator and monitored business testing and interfaced with the development team regarding defect status and fixes on a daily basis.
• Involved in generation and execution of SQL queries.

Environment: Rational Suite (Rose, Requisite Pro), Rational Unified Process (RUP), WinRunner, Windows XP/2000, Oracle, PL/SQL, MS-Project, MS-Office Suite, MS Visio, DOORS, MS Access, MS Word, MS Excel.