SUMMARY

• Qualified professional with 6+ years of experience as a Sr. Business Analyst in Retail, Supply Chain and Ecommercewith solid experience working with the technical staff to implement management and staff's business requirements into the software application in retail and e - commerce environments.
• Proactive and result oriented Business Analyst of experience in business requirements gathering, analysis & communication with Stakeholders, documenting project artifacts, data modeling, Testing/ maintenance operations.
• Experience in Software Development Life Cycle (SDLC) methodologies and techniques with expertise in Requirements Analysis, Design, Development, and post-production support and maintenance of various applications.
• Experienced in performing Business Process Reengineering to check the compatibility of the existing system infrastructure with the new business requirements. Well versed in Requirements/ChangeManagement, Impact Analysis and Gap Analysis
• Skilled in documenting Unified Modeling Language (UML) diagrams like Use Case Diagrams, Activity Diagrams, Sequence Diagrams, and Business Flow Diagrams using MS Visio
• Skilfully Documented Business Requirements (BRD), Use Case Specification, Functional and Non-Functional specification, UML diagrams including Use Case diagram, Activity diagram, screen mockups, Requirement Traceability Matrix (RTM)
• Experience in conducting Joint Application developments (JAD), Interviews and workshops with end-user/clients/stake holders and the development group
• Proficient in writing Packages, Stored Procedures, Functions, Views and Database Triggers using SQLandPL/SQLinOracle.
• Experience in document sharing applications including MS SharePoint and documenting user stories using Rally.
• Experience in customer and/or client interaction and deep understanding of business systems functionality
• Excellent analytical and problem solving skills; listening, oral, and written communication/presentation skills with strong ability to influence people at all levels and in various functions
• Energetic, positive, and self-motivated. Ability to adapt quickly to challenges and changing environments. Adept at multitasking various projects at one time, while maintaining high attention to detail

TECHNICAL SKILLS

SDLC Methodologies: Agile/SCRUM, Waterfall, Spiral, RUP Process and Prototyping

Internet Languages/ Web Applications: UML, HTML, CSS, XML

Databases and Tools: SQL Server … My SQL, Oracle … MS Access, PL/SQL.

Project Management: Microsoft Project Professional, Change Management Rational Clear Quest, Requisite Pro.

Languages: C/C++, Java/ J2EE, Shell Scripting, JavaScript, ASP.NET, C#.NET

Version Control: Rational Clear Case, Rational Rose, Rational Requisite Pro

Others: MS Office Suite (Word, Excel, PowerPoint, Visio)

PROFESSIONAL EXPERIENCE

Sr. Business Analyst

Confidential - Chicago, IL

Responsibilities:

• Gathered user and business requirements through open-ended discussions, brainstorming and prototyping and create BRD document using MS Word.
• Utilized Waterfall methodology to configure and develop process, standards and procedures.
• Knowledge and understanding of key E-commerce functions like site browsing and navigation, checkout flow, order fulfillment, payment processing, order shipment, inventory management and order management.
• Performed Gap analysis by identifying existing technologies, documenting the enhancements to meet the end state requirements.
• Performed Data mapping, logical data modeling, created class diagrams and ER diagrams and used SQL queries to filter data.
• Participated in design, development, testing, and deployment of front end applications as well as reports.
• Facilitated JAD sessions with management, users and other stakeholders to define the project and to reduce the time frame required to complete deliverables.
• Understand and provide solutions for Metrics and reporting needs ofchangemanagement
• Created Use case diagrams, activity diagrams using Ms Visio according to UML methodology thus defining the Data Process Models..
• Involved in integrating data from disparate sources into a data warehouse using ETL and applied analytical/BI skills to develop existing business reports, thus reducing the time to generate these reports manually by doing complete automation.
• Involved in SQL and PL/SQL support, coordinated with the developer's team throughout the development process.
• Assisted the QA team in designing the test plan and test cases. Performed User Acceptance Testing (UAT).

Business Analyst

Confidential - Milwaukee, WI

Responsibilities:

• Conducted weekly meetings for deciding the Policies and Procedures to be followed while constructing new sites.
• Performed the requirement analysis, impact analysis and documented the requirements using Rational Requisite Pro.
• 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.
• Reviewed the Joint Requirement Documents (JRD) with the cross functional team to analyze the High Level Requirements.
• Identified all necessary Business andSystemUse Cases from requirements and created UML diagrams using MS Visio.
• Interacted with client and the Technical Team for requirement gathering and translation of Business Requirement to Technical specifications.
• Created the SQL scripts for demonstrating the prototypes and for verifying the result sets
• DevelopedChangeManagementframework and implemented standards, processes, and controls for configuration andChangeactivities.
• Optimized theOraclePL/SQLqueries by Performance Tuning.
• Planned and documented procedures for data processing and prepared data flow diagrams for the application.
• Analyzed and translated business requirements into system specifications utilizing UML and RUP methodology
• 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.
• Developed tables, Stored Procedures and Triggers using SQL Scripting.Designed workflows and allocated permissions within SharePoint.
• Performed Unit Testing and User Acceptance testing and documented detailed results.
• Provided input (scope, goals, risks, constraints, timelines and interfaces) to PM for project planning and control.

Business Analyst

Confidential - San Leandro, CA

Responsibilities:

• Conducted Interviews and Brainstorming Sessions with stakeholders (application users, subject matter experts etc.) to gather requirements and end user perspectives in order to identify deficiencies and areas for improvement & enhancement.
• Documented and analyzed the business process for receiving and processing customer sales based on "Opportunity to Order" and covers business-to-business (B2B) and business-to-consumer (B2C) sales.
• Migrated Data from MS Excel to SQL Server Reporting Service Using DTS and SQL loader utilities.
• Identified As-is and To-be process maps as part of Gap Analysis for new functionality requirements, and thereafter prioritized them in order to align them with the project roadmap.
• Implemented data access, storage and validation routines on the database server using Procedural Language/Structured Query Language (PL/SQL).
• Analyzed and managed Supply Chain reports, dashboards and performance metrics.
• Developed strategies and created plans forChangemanagementprograms. Engaged in on-going Production Support to stakeholders forChangerequest and programs.
• Conducted Risk Assessment for theChangeManagement, analyzed and documented the overall risk and risk factors.
• Designed and implemented basic SQL queries for testing and report/data validation.
• Facilitated the developers in creating a user friendly website by adding more filters and also optimized navigation to help customers in locating the products easily. Good knowledge on content delivery network
• Create and review test plans and test case for UAT sessions. As well as conducting UAT sessions.
• Responsible for development and testing of conversion programs for importing data from text files intoOracledatabase utilizingSQL*Loader.
• Strong experience in preparing User Manual to ensure successful training and knowledge transfer to Client Service Representative Management.