SUMMARY:

• Almost 7+ years of extensive experience in IT and a Business Analyst in retail industry. In implementing Business Process Flows, Case Tools and System Analysis in a web - based and client - server environment. I have demonstrated that I am experienced in requirement analysis, test plan and test case generation, and project management.
• I am skilled in modeling UML diagrams and have a well developed understanding of the Software Development Life Cycle. Additionally, I possess experience working with ER Diagrams and MS Access and skilled in SQL languages. I have shown excellent skills in communication, organization and leadership abilities.
• Strong experience in requirement gathering analysis via interviews, walkthroughs and existing system documentations, resources and procedures.
• Analyzed, elicited and validated the changes in the business requirements for the business processes and policies.
• Experienced in analyzing business requirements at all stages of Software Development Life Cycle (SDLC) models such as Agile, Waterfall and RUP.
• Expertise in merchandising, store operations, supply chain, warehouse management, POS and content management.
• Strong experience in writing deliverables like Project Charters, Business Requirement Documents, Functional Specification Documents, Requirement Traceability Matrix table, and also assisted in generating Test Plan documents.
• Skilled in interacting with the business users to identify several business and information needs to initiate process changes and creating Use Case Analysis including Use Case Diagrams, Use Case Scenarios, Activity Diagrams, Sequence Diagrams, Data Flow Diagrams, Class Diagrams on UML methodologies using tools like MS Visio and Rational Rose.
• Project management experience includes client management, customer interaction, scope identification, project planning, change control, and integration release management.
• Strong experience in Project Management tool, MS Project, for status reporting.
• Performed GAP Analysis and Requirement Traceability Matrix.
• Conducted Joint Application Design (JAD) sessions with business owners, IT teams, users and Subject Matter Expert (SME) to drive out detailed business requirements.
• Participated in Joint Requirement Planning (JRP) meetings, Scrum meetings and Kick-Off meetings with the project team.
• Experience in Change Management Process (Identify, Analyze, Evaluate, Plan, Implement, Review and Close).
• Good working knowledge with XML. Created QTP scripts for validating XML schema and inserted check points for various tags in XML.
• Strong experience in conducting User Acceptance Testing (UAT) and documentation of Test Cases. Expertise in designing and developing Test Plans and Test Scripts.
• Experience in manual testing and error reporting to the developers.
• Proficient in creating and documenting use case scenarios and story boards.
• Strong customer focus with emphasis on delivering quality solutions. Successfully able to address team issues and implement resolutions as needed.
• Excellent organizational, communication and documentation skills along with a remarkable ability to gather requirements to bring out quality product.
• Practical experience with Data Modeling, Data Mapping, Web development and design.
• Experienced in using Mercury Automated tools Win Runner, Load Runner, QTP, Test director/ MQC, and IBM Rationale Requisite Pro/Rose/Clear Quest/Clear Case.
• Knowledgeable in Data Warehousing such MS SQL Server, Oracle, DB2, SQL * Plus.
• Knowledgeable in Online Analytical Processing (OLAP) tools like Business Objects.
• Skilled at learning new concepts quickly, working well under pressure, and communicating ideas clearly and effectively.
• Experience in conducting GAP analysis, User Acceptance Testing (UAT). SWOT analysis, Cost benefit analysis and ROI analysis.
• Excellent communication skills with exceptional group facilitation skills, knack of negotiating and building consensus and ability to view “think outside the box”.
• Creative and aggressive self-starter with integrative thinking skills, capable of forming and maintaining positive and productive working relationships in internal, external, independent, and team environments
• Highly motivated, organized and results and detail oriented with excellent interpersonal, communication and presentation skills.
• Excellent knowledge of Microsoft Office Suite: Word, Excel, Access, PowerPoint, MS Visio and Project.
• Proven capability of adapting to new and fast changing technologies.

TECHNICAL SKILLS:

BUSINESS MODELING: Rational Rose, MS Visio.

DATABASE: MS SQL Server, MS Access, Oracle, IBM DB2, SQL * Plus, SQL *

DEFECT TRACKING TOOLS: Test Director, Rationale Clear Quest/Clear Case.

FRONT- END TOOLS: Microsoft Excel, Access, Front Page, Flash, SharePoint, MS Power Point.

METHODOLOGIES: RUP, Agile, Waterfall.

OPERATION SYSTEM/PLATFORM: MS Windows 2003/XP/2000/NT, AS/400, UNIX, Sun Solaris, Apache HTTP Server.

PROJECT MANAGEMENT TOOLS: MS Project.

REQUIREMENT MANAGEMENT TOOLS: Rational Requisite Pro, iRise, Enterprise Architect.

TESTING TOOLS: Quick Test Professional(QTP), Test Director, WinRunner

WEB TECHNOLOGIES/LANGUAGES: SQL, VB-scripts, XML, XSLT, Web-Services, HTML, CSS, .NET, TSL, OLAP, FTP.

PROFESSIONAL EXPERIENCE:

Confidential, San Francisco, CA

Sr. Business 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.
• Performed Data mapping, logical data modeling, created class diagrams and ER diagrams and used SQL queries to filter data
• Worked closely with the Enterprise Data Warehouse team and Business Intelligence Architecture team to understand repository objects that support the business requirement and process.
• Worked on development of High level design, Conceptual design, Logical and Physical design for Database, Data warehousing and many Distributed IT systems
• Provided Business Requirement Documentation (BRD) for the customers after thorough market and technology research and by analyzing current market trends.
• Responsible for implementing supply chain and operations solutions in the exploration & production lines
• Created Data Stage jobs to extract, transform and load data into data warehouses from various sources like relational databases, application systems, temp tables, flat files etc.
• Maintained and ensured traceability across leveled requirements by controlled change management and impact analysis
• Developing the GUI using ASP, Java/VB Script and Html.
• Documented XML file processing use case as well as identified XML file level processing errors.
• Aligned requirement documentation with use of UML for object oriented software development (OOD).
• 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.
• The Supply Chain scope includes the entire supply chain from production order to shipping & delivery and order management.
• Provide ad-hoc reporting and analysis from data sources including PeopleSoft (SET) and Teradata
• Created job schedules to automate the ETL process.
• Developing Business Objects reports based on report Design documents (RRD) Effort estimation and providing it to the client.
• Conducted UAT to confirm that all derivative products can be successfully processed through stages of the trade life cycle.
• 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.
• Coordinated various kinds of User Acceptance Testing (UAT) including regression testing, system testing, integration testing, functional testing, alpha & beta testing.
• Designed and Developed the Business Objects Universes which suit the standard, analytical and ad-hoc reporting requirements of the Business Objects users.
• Responsibilities included source system analysis, data transformation, loading, validation for data marts, operational data store and enterprise data warehouse.
• Used Informatica to extract and transform data from various DB2 database to the data warehouse.
• Created Mock-up forms in MS word for better visualization and understanding of the software solution.
• Used Informatica to extract, transform and load data from multiple input sources like XML, SQL Server, Flat files and loading into Oracle.
• Used Test Director and Mercury Quality Center for updating the status of all the Test Cases & Test Scripts that are executed during testing process.
• Developed estimates, project plans (Microsoft project), training material, BI reports using Microstrategy
• 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.
• Tracked the defects in legacy reports as per account managers and end users. Compared the results and tracked the differences in excel
• 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, NIKU, MS Visio, MS Outlook, MS project, MS Dynamics, RUP, Rational Rose 2002, XML, Rational Clear Quest, Rational ClearCase, Rational requisite pro

Sr. Business Analyst

Responsibilities:

• Coordinated and hosted meetings with multiple cross-functional groups involving Users and Product Managers from distinct Business Groups to understand business requirements, formulate a solution and discuss timelines
• Involved in Master Data Management’s project to provide Cash Management Services for scoping and analyzing future requirements
• Worked closely with the Project leads in the managing and prioritizing of projects, enhancements and defects in the pipeline within the CRM Master Data Management (MDM) Group
• Lead and monitored the development team in terms of prioritizing of tasks, creating milestones and providing business context to development efforts.
• Managing the project using the Agile Method of project development.
• 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.
• Conducted user interviews, gathered requirements, analyzed, and documented business requirements based on the different requirement analysis and managed them in Requirement Management tool.
• Functioned as the primary liaison between the business line, operations, and the technical areas throughout the project cycle.
• Involved in coding using Java created web pages using HTML, Java script.
• Facilitated meetings among the Change Management, Problem Management and other relevant teams to discuss the impact of the changes and prepare project milestone plans.
• Researched industry trends; assessed various software vendors and service providers for potential alliances or partnerships; developed the business, marketing, and infrastructure plan.
• Used standard Business Analysis methodology centered on RUP and involved in the system analysis and member GDS searches.
• Developed XML schema to validate business rules in the generated XML files
• Worked with customer’s internal business processes and developing detailed analysis of how to effectively deploy Point of sale throughout the enterprise environment.
• Identified/documented data sources and transformation rules required populating and maintaining data warehouse content.
• 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
• Designed and developed Use Cases, Activity Diagrams, Sequence Diagrams using Visio and Worked with a cross functional and diverse team of business users and developers to enable accurate communication of requirements and ensure consensus.
• Assisted PM in developing project plans, tracking and managing project process and resources for successful delivery following RUP based SLDC methodologies.
• XML order header and order detail data transfer; inventory/supply chain management modules.
• Formulating and defining system scope and objectives based on both user needs and a good understanding of applicable business systems and Retail Industry requirements.
• Interviewing several business area experts (SME), asking detailed questions and carefully recording the requirements in a format that can be reviewed and understood by both business people and technical team.
• Project tracking and documentation using MS Project, Excel, Access, and Word.
• Worked with technical analysts to develop technical specifications for the features and functions defined in the requirements document.
• Support for a major effort to improve the Warehouse Management System (WMS) capabilities of Supply Chain.
• Created test plan, test case and test script for the different functionality of application and actively involved with User Acceptance Testing (UAT) with technical staff and business users and report bugs on MQC after Regression Testing of the system.
• Involved and responsible for creating weekly status reports regarding the progress of testing process.
• Clarified QA team issues and reviewed test plans and test scripts developed by QA team to make sure that all requirements will be covered in scripts and tested properly.
• Performed UAT testing of the requirements. Testing for checking the data flow of the application using SQL.
• Participated in the bug review meetings, Updated requirement document as per business user feedback and change in functionality of the application
• Coordinated with Project Manager to setup the pre-validation and Validation environment to execute the scripts.

Environment: Rational Clear Case, Rational Clear Quest, Requisite Pro, Agile, SQL, XML,RUP, Java, MS Project, SharePoint, MS Office 2003, Windows 2000.

Business System Analyst

Responsibilities:

• Conducted JAD sessions with business users, independent agent groups and third party users to converge the business needs.
• Documented JAD minutes and incorporated business needs to business requirements.
• Worked as a liaison between business, development and quality assurance team to streamline the processes.
• Elicited, analyzed, documented and validated business requirements.
• Created functional requirements and functional specification documents which were developed for different front-end and back end systems such as Mainframe, Oracle and DB2.
• Used Waterfall methodology for the development and deployment of roadside assistance and scheduled property projects.
• Designed mock ups from new application screens and introduce new database tables for DB2 and Oracle.
• Conducted walkthroughs with Business, Development and Testing teams for the projects
• Reviewed test plan, test cases and provided sign-offs.
• Employed Rational Clear Quest for effective Change Management (Requirements Creep) and bug tracking during the testing lifecycle.
• Obtained sign-offs from Business users and Technology groups on Business/Functional requirement documents and Functional specification documents.
• Created and updated rate file for rolled out states for home and auto projects.
• Worked on DB2 reference data which controls Point of Sale front end application.
• Delivered the time-critical project on-time and received appreciation from higher management and business users.
• Conversion of delivery system of data elements from flat, text files into XML data feeds.
• Assisted programmer/analyst in resolution of work problems related to flow charts, project specifications, or programming.
• Developed detailed BRDs and DFDs using various modeling tools and developed databases based on the system model following the techniques in Agile.
• Manually tested and analyzed electronic claims file and first party medical applications which handles customers’ auto claims and medical information for periodic functionality and design changes.
• Actively involved in User Acceptance Testing, explained to the end-users the testing methodology to get the various data points from the different interfaces.
• Participated in User Acceptance Testing by getting the data points from the production environment.
• Monitored changes to the testing process and communicated errors found during and after User Acceptance Testing.
• Interacted with client regarding project status and feedback on UAT and discussed the information with the development team.

Environment: Policy Management System (Back-end Application Built on COBOL), Point of Sale (Front-end Application Built on Java, DB2, Oracle, Mainframe, Rational Requisite Pro, XML, Quality Center, Agile, MS Visio, MS office suite.

Business/Quality Analyst

Responsibilities:

• Identified the various business processes and analyzed as to how Retek can be incorporated into Eckerd day-to-day business
• Facilitated collection of requirements from system users and prepared Business Requirement documents for the different RMS functionalities using Rational RequisitePro that provided appropriate scope of work for technical team of Retek to develop a prototype and overall system
• Used the guidelines and artifacts of the RUP to strategize the implementation of RUP effort in different iterations and phases of the SDLC
• Worked as an liaison between the users and the different teams involved in the application development for the better understanding of the retail business processes
• Followed a structured approach to organize requirements into logical groupings of essential business processes, business rules, and information needs, and ensured that critical requirements are not missed
• Followed the UML based methods using MS Visio to create Use Case, Activity / State Chart, Sequence, and Collaboration Diagrams
• Prepared Logical Data Models that contained set of diagrams and supporting documents containing the essential business elements, detailed definitions, and descriptions of the relationships between the data elements to analyze and document business data requirements
• Prepared Business Process Models that included modeling of all the activities of the business from the conceptual to procedural level
• Aided management in standardizing GUI and recommending alternatives for in corporation in a phased, iterative manner
• Organized JAD Sessions to resolve issues and conflicts, and to arrive at quick agreements regarding the system architecture design
• Worked extensively with the QA and the UAT teams for designing Test Plan and Test Cases for the UAT
• Verified the Business Scenarios on new builds to allow extended testing by the QA team

Environment: UML, RUP, Erwin, Rational RequisitePro, Rational Rose, RMS, Windows, UNIX, Oracle, MS Office.

Business Analyst

Responsibilities:

• Interviewed Business Users to gather Requirements and analyzed the feasibility of their needs by coordinating with the project manager and technical lead.
• Conducted extensive requirement analysis using Rational requisite pro
• Thoroughly studied the requirements for the process re-engineering
• Worked on broad range of technologies, including business process tools such as Microsoft Project, Primavera, Promodel, MS Excel, MS Access, MS Visio, technical assessment tools, MicroStrategy Data Warehouse Data Modeling and Design
• Analyzed Business Requirement Documentation and Functional Specification Documentation using UML methodologies.
• Prepared Business Requirement Documents (BRD’s) after the collection of Functional Requirements from System Users that provided appropriate scope of work for technical team to develop prototype and overall system.
• Created Source to target data mapping documents identifying key data elements and prepared Data Flow Diagrams
• Responsible for creating Report Design Documents (RRD) and Test Plans for unit testing.
• Performed extensive data modelling to differentiate between the OLTP and Data Warehouse data models
• Designed the business requirement collection approach based on the project scope and SDLC Methodology.
• Designed flexible project foundation enabling rapid implementation of e-commerce website capabilities
• Created Activity Diagrams, Sequence Diagrams and ER Diagrams.
• Developed the ETL Informatica Mappings for importing data from ODS into subsequent data marts.
• Core responsibility involved complete manually testing of the User Acceptance Test (UAT)
• Develop and maintain sales reporting using in MS Excel queries, SQL in Teradata, and MS Access.
• Tracked the defects in legacy reports as per account managers and end users. Compared the results and tracked the differences in excel
• Worked with Cognos and micro strategy reporting systems to extract the data for analysis using filters based on the analysis.
• Developed and Documented timelines for Project Delivery, and managed Projects and Resources to successful completion.
• Prepared graphical depictions of Use Cases, Use Case Diagrams, State Diagrams, Activity Diagrams, Sequence Diagrams, Component Based Diagrams, and Collateral Diagrams and creation of technical design (UI screen) using Microsoft Visio.
• Designed the universes by creating the Business Objects data model.
• 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.
• Conducted User Acceptance Testing, gathered and documented User Manuals and Business Rules.

Environment: Microsoft Word, Excel, Outlook, MS Visio, Casewise modeller, Borland CaliberRM, Unix, Documentum, Windows NT/XP, Oracle, SQL, SQL Server, Cognos, Sybase, VBScript, C#. DOORS, Java, C++, NET, ASP.NET, Business Objects