SUMMARY:

• 8 years of Industry experience as a Business Analyst with solid understanding of Business Requirements Gathering, Business Process Mapping Evaluating Data Sources, Data Mapping, and Translating Requirements into Specifications, Application Design.
• Worked extensively with Confidential Excel (Macros, VLOOKUPS, and Pivot Tables). Proficient Confidential Word, Power Point, Access and Lotus Notes.
• Knowledge in the ETL (Extract, Transform and Load) of data into a data ware house/date mart and Business Intelligence (BI) tools like Business Objects Modules (Reporter, Supervisor, Designer, and Web Intelligence).
• Deep understanding and experience of Investment Management, Asset Management, Prime Brokerage Services, Money and Capital Market Instruments
• Expertise in Project Management i.e. Project Scoping, Planning, Estimating, Scheduling, Organizing, Directing, Controlling, Budgeting and Drafting Remedy Procedures.
• Extensive experience in conducting Market Research, Feasibility Studies, Data Analyses, Data Mapping, Data Profiling, Gap Analyses, Risk Identification, Risk Assessment, Risks Analyses, and Risk management.
• Experience on AS/400 and Retail / Supply chain domain with strong knowledge of standard business processes like Inventory Control, Procurement & Allocation, Merchandise Planning, Pricing & Invoicing, Demand Planning & Forecasting, Returns, Warehouse & transportation management process, Accounting & financials. Little knowledge on POS and Assortment Planning.
• In depth knowledge Rational Unified Process (RUP) methodology, Use Cases, Software Development Life Cycle (SDLC) processes, Object Oriented Analysis and Design (OOA/D).
• Competent in Creating Unified Modeling Language (UML) diagrams such as Use Case Diagrams, Activity Diagrams, Class Diagrams and Sequence Diagrams.
• Expertise in broad range of technologies, including business process tools such as Confidential Project, MS Excel, MS Access, MS Visio, technical assessment tools, Micro Strategy Data Warehouse Data Modeling and Design.
• Experience with data migration (ETL development), document data manipulation processes and scripts
• Provided mapping of XML from Auto Web to policy management system.
• Exposure to Client/Server, Web Application developmental tools and Software development and design.
• Developed extensive SQL queries using Query Manager against oracle database for data verification and backend testing
• Responsible to Track, Document, Capture, Manage and Communicate the Requirements using Requirement Traceability Matrix (RTM) which helped in controlling numerous artifacts produced by the teams across the deliverables for a project
• Strong experience in conducting User Acceptance Testing (UAT) and documentation of Test Cases. Expertise in designing and developing Test Plans and Test Scripts.
• Interface with clients from Operations, Marketing, Sales, Technologies, and Outside Vendors and act as their customer interface point as the lead of the Projects.
• Highly motivated team player with excellent Interpersonal and Customer Relational Skills, Proven Communication, Organizational, Analytical, Presentation Skills, and Leadership Qualities.

TECHNICAL SKILLS:

• ERWIN
• ETL
• Ascential Data Stage (7.x, 6.x, 5.x)
• Star - Schema Modeling
• Snowflake Modeling
• FACT and dimension tables
• Erwin 4.0
• Business Objects
• CRM
• Micro strategy
• SAS
• Macros
• Erwin 4.x
• C/C++
• Java SE 1.4
• TURBO PASCAL 7.0
• VB.Net
• Teradata
• HTML
• COBOL
• SQL Server
• SOA
• SAP SD
• MySQL
• Agile/Scrum
• Oracle 8i
• Visio
• Sybase ASA (6 - 9). ASP/ASP.net
• PHP
• JAD
• MS Suite
• MS Visio
• Unix
• Wintel
• MVS
• MS Windows/95/98/NT/2000/XP
• MS DOS
• MS Office
• Quality Center
• QTP
• Rational Requisite Pro
• Hyperion
• Brio.

PROFESSIONAL EXPERIENCE:

Confidential, Parsippany, NJ

Sr. Business System Analyst

Responsibilities:

• Conducted interviews and JAD sessions with business users to gathered business requirements and to understand the scope of the project.
• Help business clients define business requirements by leading and facilitating meetings.
• Developed and translate business requirements into various documentation deliverables such as Business Requirement Document, Functional Specification Document and other artifacts such as Non-Functional Requirement, Meeting Minute, Meeting Schedule Spread sheet, work flow process, use cases etc.
• Create wireframes for Account Administration application.
• Provided work in progress report and status reporting of project-to-project manager, Director and business users.
• Create test scenarios and develop test plans to be used in testing the business applications in order to verify the client requirements are incorporated into the system design
• Exposed to SOX compliances.
• Conducted Use case walk through in xan effort to identify and realize the process and flows
• Responsible for liaison with cross-functional team, developers and test team to plan and coordinate application release.
• Worked with business users to create UML use cases and Traceability Matrix for developers.

Environment: Confidential outlook 2010, Confidential Word 2010, Cisco MeetingPlace, MyPortal and Confidential Visio

Business Analyst

Responsibilities:

• Gathered business requirements by conducting JAD sessions and detailed face-to-face interviews with business users and Technical Folks.
• Responsible for scheduling meetings and conferences.
• Developed and translate business requirements into various documentation deliverables such as Business Requirement Document, Functional Specification Document and other artifacts such as Non-Functional Document, Meeting Minute, Meeting Schedule Spread sheet, work flow process etc.
• Acting as an interface between the clients, development team and other cross-functional teams.
• Conducted and led onsite off shore meetings with QA testers and developers to clarify their queries
• Provided work in progress report and status reporting of project-to-project manager, Director and business users.
• Exposed to PCI and SOX Compliances.
• Good knowledge of ADS/GDS (Alternate Distribution system/ Global Distribution System), PMS (Property Management System), CMoR (Call Center application).

Environment: WynSPE, Confidential Office 2010, Confidential Outlook 2010, Cisco Meeting Place, Confidential Visio, TIBCO Middleware.

Business Analyst

Responsibilities:

• Worked through the AGILE framework methodology.
• Was the involved in daily Scrum meetings and part of sprint planning meetings.
• Helped PM and lead in defining the sprint back logs and product back logs and defined user stories.
• Closely interacted with development and project teams to understand system requirements.
• Reviewed Business and Functional Requirement documents and detail design documents.
• The technology was designed to meet the needs of the Business (EnCana) by providing a system capable of serving data, maps, and control points through visualization tools to end users in real time. The enterprise platform consisted of the required architecture, software and databases to deliver these tools via web services. These services ultimately provided access to online mapping and integration with existing databases and other software systems such as IMS (Incident Management System), SCADA (etc.
• Structured workflow for entire content lifecycle from early research and development (R&D) through eSubmission.
• Defined charter, scope, schedule, and resources for projects productizing R&D programs, managing (and often defining and delivering) customer needs via marketing requirement documents (MRD).
• Identified opportunities for business process improvement through various meetings with business users and developers and initiated efforts to make improvements.
• Developed the project plan with assistance from the management, and included provisions for project scope changes and issues and initiated efforts to make improvements.
• Conducted project kick off meetings with team members to explain roles / responsibilities, relationships with other groups, deliverables, timelines, assignments and status reporting.
• Wrote PL/SQL statement and stored procedures in Oracle for extracting as well as writing data.
• Created GUI specifications with Page flows, page business actions and screen mockups
• Created RUP activity diagrams and sequence diagrams to analyse the requirements and recommend solutions.
• Created specifications for data cleansing and conversion programs, EDI sales data loading processes and procedures, mapping of client/territory alignments and hierarchies.
• Assisted PM in Developing Project plan and tracking project Process, Scheduling and organizing group meeting, as well as developed Risk Management Plan
• Designed the business requirement collection approach based on the project scope and SDLC methodology.
• Used SDLC (System Development Life Cycle) methodologies like the RUP and the waterfall.
• Prepared scenarios, Use Cases & UML State Diagram for scenarios using Rational Rose.
• Prepare presentation slides in MS Project, which was extensively used in different JAD sessions and to track progress.
• Assisted the technical team in translating application functionality into application architecture.
• Participated in the bug review meetings, updated requirement document as per business user feedback and changes in the functionality of the application.
• 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.
• Organized meetings to discuss outstanding issues with QA and developers.
• Wrote test scripts for User Acceptance Testing (UAT).

Environment: Rational Suite (Rose, Requisite Pro), Dreamweaver, Rational Unified Process (RUP), Windows NT/XP/2000, UML, UNIX, MS-Project, MS-Office Suite, Casewise Corporate Modeller, WinRunner, Quality Center

Business Analyst

Responsibilities:

• Involved in all phases of software development life cycle (SDLC) in AGILE framework.
• Analyzed and collected business requirements, identified system interfaces and created the requirements specification document.
• Applied Unified Modeling Language (UML) methodologies to design Communication Diagram, Use Case Diagrams, Activity Diagrams, Sequence Diagram and ER diagrams.
• Extensively interacted with both user group and development team.
• Facilitated the JAD sessions, set clear objectives and set the clear objectives for JAD.
• Managed and tracked change control process of requirements and design changes. Documented the changes, issues and their impact on the system design and delivery.
• Provided documentation such as requirements management plans, functional requirements, test plans and test cases.
• Incorporated the best practice methodologies as advocated by the Rational Unified Process.
• Designed and analyzed Business Process Model, Use Case model and test procedures based on AGILE methodology.
• Performed requirement analysis by gathering both functional and non-functional requirements based on interactions with the process owners & stakeholders and document analysis. Performed user interviews.
• Involved in Call handling, Monitoring processes and CRS work force management processes
• Worked extensively with MS Project for resource management and allocation
• Worked with MS Power Point for presentations
• Used Rational Clear Quest and Clear Case for Change Management and Configuration Management.
• Wrote user requirements specification (URS) and Functional requirements specification (FRS) Documents as per the Business requirements and process flow.
• Performed Data mapping, logical data modeling, created class diagrams and ER diagrams and used SQL queries to filter data within the Oracle database
• Involved in Quality Assurance maintaining Software quality standards and Software quality Matrices
• Designed and developed project templates based on AGILE Methodology
• Developed UML Use Cases for the application and prepared the detailed Work flow diagram based on the proposed enhancement for the system.
• Developed modules in the HR department for educating and training the user about the new system.
• Acted as User Acceptance Testing coordinator and monitored business testing and interfaced with the development team regarding defect status and fixes on daily basis.

Environment: Oracle 8x/9i, Asp. Net, MS Project, MS Office Suite, AGILE, UML, Clear Case 2002, Rational Clear Quest, MS office suite 2003, MS Visio 2003, JAD.

Business Analyst/QA Analyst

Responsibilities:

• Performed extensive data modeling to differentiate between the OLTP and Data Warehouse data models
• Wrote Test Plans in MS Word for Manual Testing, System Testing, Integration Testing, Performance Testing, Regression Testing & reviewed their consistency with the business requirements.
• Involved in designing and developing Data Models and Data Marts that support the Business Intelligence Data Warehouse
• Implementing Oracles Retail Management System (ORMS) in order to provide a streamlined solution for performing an end-to-end process of creating a Purchase Order by buyers to Offshore Vendors.
• Developed function specifications for modifications of POS system for multiple chains.
• Include integrating new chain into existing systems which encompassed, gap analysis, specific brand requirements and full POS integration
• Interacted with Cash Management Division and Compliance Office to review the AML (Anti Money Laundering) requirements and provide Positive Pay service to reduce check fraud
• Created Functional Unit/String test cases for Order Management, Warehouse & Inventory Mgmt, and Planning & Procurement.
• Conducted JAD sessions with different Vendors, Sponsors, Business Users and SME’s.
• Worked closely with the Enterprise Data Warehouse team and Business Intelligence Architecture team to understand repository objects that support the business requirement and process.
• Gathered requirements, organized team meetings requirements from business users such as insurance policy managers, generated business process models, & use-case models, and created business requirements document (BRD) & functional requirements document (FRD).
• Participated in UAT and worked with Quality Center for bug and defect tracking.
• Developed function specifications for modifications of POS system for multiple chains.
• Include integrating new chain into existing systems which encompassed, gap analysis, specific brand requirements and full POS integration
• Worked with SME’s in Europe, to finalize the layout of the new Work-flow diagram. Also, the design (wire frames) was re-formulated.
• Planned and documented procedures for data processing and prepared data flow diagrams for the application.
• Involved in development & documentation of Software Requirements Specification (SRS) using Borland Caliber RM.
• Developed entity diagrams, data interface mapping to map all the possible inputs and outputs.
• Wrote Test Cases in MS Excel for user registration, access to training material, and activity log-in, reviewed the test cases and finalized
• Gathered requirements and modeled the data warehouse and the underlying transactional database
• Performed Requirement Analysis and developed Use Cases, Activity Diagrams using Rational Rose
• 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
• Responsible for Data Extraction, Data Compilation, Data Analysis, Data Manipulation and Data Validation using SQL queries in a MS SQL Server 2005 environment
• Involved in creation and execution of manual test cases in Quality Center and automated Test Cases in QTP and analyzed the Test Results.
• Involved with the QA team to conceptualize, determine and develop test approaches and methods for unit testing, integration and functional testing, load and usability testing according to the application complexity and test requirements.

Environment: Windows XP/2000, Oracle, PL/SQL, SharePoint, JAD, Unix, MS-Project, MS-Office Suite, MS Visio, Rational Requisite Pro, Clear Case, Clear Quest, MS Access, Quality Center, Quick Test Pro (QTP)

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.
• 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.
• Conducted business analysis, acted as a liaison between project manager, business users’, & IT team, and used MS Office for the documentation.
• Worked with the SME’s (Financial Analysts, Risk Managers, and Project Managers) to define business critical needs and analyse the possible technical solutions.
• Responsible writing Test Plans, Test Cases and Test Scripts using manual and automated testing tools from Rational and Interactive such as test Director, Winrunner.
• Involved in Data Modeling of both Logical Design and Physical design of data warehouse and data marts in Star Schema and Snow Flake Schema methodology.
• Interacted with database developers for formulating the ER diagrams and data flow diagrams.
• Prepared Use cases and Activity flow diagrams and Work flow diagrams, considering the scope of the project with MS VISIO 2003.
• Writing PL/SQL procedures for processing business logic in the database. Tuning of SQL queries for better performance.
• Responsible taking down meeting minutes during JAD sessions and sending daily status update reports.
• Extensively involved in the modelling and development of Oracle Data Warehousing System.
• 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.
• Prepared the functional test cases and performed the functional testing of the application using mock and live data at the back end.
• Served as a resource for analytical services utilizing SQL Server, TOAD/Oracle, and SQL Developer.
• Managed and organized requirement coverage, Test Case Management and Defect Management using Quality Center.
• Developed and managed project plans, schedules, issues log created and business-technical conflicts.
• Coordinated various kinds of User Acceptance Testing (UAT) including regression testing, system testing, integration testing, functional testing, alpha & beta testing.
• Authored test plans, test cases for various test scenarios and helped testing team to better understand the test scripts.
• Designed and created prototypes of reporting tools for data validation and verification initiatives using macros in Ms Excel.
• Used Test Director to 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 Confidential Visio to create: Use Cases Diagrams, Activity Diagrams, State Chart Diagrams, Sequence Diagrams and Collaboration Diagrams.

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