SUMMARY:

• 9+ years of professional experience as a functional business analyst specifically in Financial, Retail e - commerce, Supply Chain, and Education/Publishing industry domains.
• Exceptional analysis skills with an ability to transform the needs of business users and stakeholders into functional and technical requirements.
• Extensive knowledge of all phases of the software development life cycle (SDLC) and the iterative rational unified process (RUP).
• Experience in conducting and facilitating JAD sessions to resolve issues related between business requirements and technical design.
• Extremely proficient in using agile and waterfall methodologies, Performed roles of scrum master following sprint sessions and used JIRA extensively to write concise user stories and precise acceptance criteria which is used by developers and testers as a key input for development.
• Design and review various documents including use case diagrams, business requirements document (BRD), functional requirements document (FRD), requirement traceability matrix (RTM) and test plan documents.
• Performed requirements modeling and develop analysis diagrams, activity diagrams, data models, and use-case realizations using RUP tools in agile.
• Worked with rational suite of tools to create requirements documents using Requisite Pro, and track defects using Clearquest.
• Experienced with solid techniques in gathering business requirements for data initiatives that address data sources, data integration, data flow and analytics capabilities.
• Conducted risk assessment and trade surveillance for regulatory purposes. Interacted with the compliance department and SME experts within the laws/act of compliances.
• Proficient in configuring Google Analytics and Omniture SiteCatalyst, and worked with internal staff and clients to define strategies for web analytics, search engine optimization and sponsored search marketing.
• Analyzed data from web analytics tools to create customized dashboards calculating KPIs, metrics and trends to improve website performance and achieve overall marketing goals.
• Experience testing implemented systems and system changes including liaising with QA teams to develop test cases, test plans, test scenarios, generating test data, and conducting manual testing phases (regression, smoke, end-to-end, and functional).
• Effectively resolve conflicts, facilitate requirements prioritization, and gain formal approval.

TECHNICAL SKILLS:

Requirement and Project Management Tools: Requisite Pro, JIRA, VersionOne, Basecamp.

Business Skills: Business Definition Requirements, Business Process Analysis, Gap Analysis, Use Case Modeling & Analysis, Competitive Intelligence and Market Research Analysis.

SDLC Process: Waterfall, Agile, Scrum, V-Model.

Tools: Informatica, SharePoint, WinRunner, HP Quality Center, Clearcase, Clearquest

Utilities: MS Office Suite, MS Visio, MS Project, Rational Rose, SPSS, OmniGraffle.

Operating Systems: Windows, Unix, Linux.

Database: Oracle 11g, 10g/9i/11i, MS Access, MS SQL Server, Sybase.

Web Analytics Tools: Omniture SiteCatalyst, Google Analytics, WebTrends, Experian Hitwise.

Scripting: HTML, SQL, JavaScript, XML.

PROFESSIONAL EXPERIENCE:

Confidential,Richfield,MN

Business Analyst

• Ensure functional requirements and use cases documented are clear and concise to map to business requirements and processes in language understandable to both technical and business stakeholders.
• Prepare detailed business and functional requirement documents, data flows, high level design document and obtain sign-offs from the appropriate business stakeholder’s prior to development.
• Work with MDM and EDW solution architects and dev leads in a closed loop to develop and align the technology roadmap, which will support business goals and project objectives.
• Perform source system analysis (SSA) to identify the source data that needs to be moved into the target tables and also prepare accurate data mapping document for future references.
• Review test plans, testing scenarios, and test cases wherever applicable and ensure that project plans, roles and responsibilities are well documented and communicated.

Technologies: MS Office Suite, Java Web Services, JMS, SharePoint, QTP, MDM, EDW, ETL, Informatica Power Center 9.6, Sybase, Oracle.

Confidential,New York,NY

Business Analyst

• Authored detailed requirement documents, user stories, acceptance criteria, estimation, and prioritize product releases. Worked with various cross functional teams (UX, creative, legal, marketing, etc) to execute product roadmap and bring new functionalities to the product.
• Worked closely with the UX and UI design team to create wireframes, activity diagrams, business rules document and UX prototypes.
• Facilitated sessions, resolve blockers and present solution using various methods like presentations, demos, business processes etc.
• Interacted with the onshore tech lead and offshore technology team on a regular basis to communicate complex functionalities, dependencies, business needs and change requests.
• Coordinated with testing/ quality assurance team to ensure all user interactions and use case scenarios are tested.
• Performed post deployment product support, identify bugs and prioritize for future release using agile methodology and share success metrics with the entire team.
• Collaborated with external teams and stakeholders to make sure the team is in the right direction and provide necessary inputs whenever needed.

Technologies: MS Office Suite, OmniGraffle 6, HP Quality Center, ClearQuest, VersionOne, JIRA, Basecamp, HTML, jQuery, JavaScript, Confidential -Hill Connect platform.

Confidential,Framingham,MA

Business Analyst

• Responsible for requirement collection and analysis, design deliverables, approving technical designs, assisting development integration teams to deploy Oracle RPAS (retail predictive application server) planning suite, Oracle RDF (retail demand forecasting) and Oracle RMS (retail merchandise system) applications.
• Gathered requirements from key stakeholders, customers, and subject matter experts to define the scope and requirements of merchandise planning system needs.
• Conducted review sessions for communicating with the all project directors and stakeholders and created process workflows, functional specifications and project initiation artifacts for both solution and interface specific requirements.
• Prepared detailed functional and non-functional design document for new business requirements. Create data conversion and interface specifications and build test cases/scenarios to ensure qualiy of the end solution.
• Defined data and process requirements for each planned integration, successful implementation and continued operations (disaster plan and procedures) in the event of system interruption.
• Managed an interface tracker representing all the data transfers taking place across Enterprise Data Warehouse (EDW), Master Data Management (MDM), Legacy Systems, RPAS and RMS systems and produce technical documentation for the support and execution of all the operational interfaces.
• Co-ordinated and help QA teams to develop and execute the overall test strategy and testing approach documents for each go-live releases.
• Monitored version control and defect tracking activities using HP Quality Center.
• Traiged change requests (CR’s) and provide estimates based on complexity.

Technologies: MS Office Suite, MS Visio, Sharepoint, HP Quality Center, MDM, EDW, ETL, FTP, DataStage, MQ FTE, Websphere Message Broker, RPAS, RMS and RDF, Oracle WorkFlow, XML, SQL.

Confidential,New York,NY

Business Analyst

• Responsible in gathering functional requirements in the form of user stories and documenting them in functional requirements document by eliciting and brainstorming the same in interview sessions with the product team.
• Facilitated meetings with stakeholders, managers and end users to understand various process plans, business process, and functionality in detail.
• Responsible for creating use case diagrams, activity diagrams using UML modeling tools.
• Performed functional and user acceptance test (UAT) testing according to test scenarios and reporting the results using defect tracker through manual testing.
• Liased between business groups (inbound and outbound transportation) project functional team and software developers. Ensured all stakeholders were clear on final application expectations.
• Understood Red Prairie’s middleware technologies APPTALK, retek management system, external communication broker with communication of data interchange between the systems.
• Updated and analyzed data setup - updating TMS tables for setting up new distribution centers for inbound and outbound logistic networks.
• Analyzed industry trends, competitor activity, and pricing effectiveness to support the development of effective business plans.
• Designed KPI reports for company managed operations based on transport modes to identify strengths and weaknesses against industry standards. Prepared ad-hoc reports for internal customers.

Technologies: UAT, Gap Analysis, MS Visio, MS Powerpoint, SQL Server, IBM Rational Clear Quest, SharePoint, Red Prairie - Transport Management System.

Confidential,San Francisco,CA

Business Analyst

• 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.
• Created wireframes and screenshots for the application to easily communicate it to the users by using MS visio.
• 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 business analysis.
• Developed content matrix and prepared metadata values for content.
• Created physical inventory process for retail stores, consisted of data integration and inventory processes with third party vendor.
• Participated in UAT and worked with mercury quality center for defect tracking.
• Came up with test cases from the functional requirements, validated/exercised those test cases in form of integration and regression tests. used test director to map the requirements with test cases and used QTP for automated testing.
• Implemented and operated analytics tools Omniture SiteCatalyst and Google Analytics to inform marketing activity, advertising spending and customer retention. Introduction of A/B testing systems using Google Website Optimizer to optimize landing pages.
• Analyzed and interpreted trends in customer perception, preferences, and behaviors across the e-Commerce/website channel through full shopping cart life cycle and conversion funnels using Omniture system.
• Identified and monitored customer behavior patterns and the performance of website functionality and distill the information into conclusions with relevant, actionable recommendations.
• Directed web and marketing analysts through the measurement strategy process to construct appropriate KPIs and develop business requirements.

Technologies: RUP, UAT, Gap Analysis, MS Visio, MS Powerpoint, MS Excel, HTML, JavaScript, SQL,Windows 2000 Advanced Server, UNIX / Oracle Platform, Documentum, Omniture SiteCatalyst, Google Analytics, Experian Hitwise.

Confidential, Minneapolis,MN

Business Analyst

• Worked with the business users to define business requirements and analyze the possible technical solutions.
• Conducted user interviews, gathered requirements, analyzed, and documented business requirements based on the analysis of process workflow model.
• Conducted workflow, process diagram and gap analysis to derive requirements for existing systems enhancements.
• Worked with an information architect to create and develop wireframes and mock-up screens for the user interface.
• Created data mapping, logical data modeling, E-R diagrams, and used SQL queries to filter data within the oracle database.
• Co-authored business requirements document with project teams. Extracted, discussed, and refined business requirements from business users and team members.
• Assisted the testing team in developing the test plans for quality assurance based on functional requirements.
• Performed user acceptance testing (UAT) for various web based and database related applications.
• Analyzed user problems, including automated and manual business processes and identified, researched, investigated, defined and documented business processes.
• Implemented and analyzed WebTrends and Google Analytics to deliver sales-oriented actionable business insights.
• Generated dashboard, scorecards and other ad-hoc reports on website analysis (KPIs) by using WebTrends and Google Analytics.
• Provided insights to the stakeholders on website performance and build customized dashboards for various reporting needs. Measured and evaluated performance of all online marketing campaigns leveraged on the website.

Technologies: MS Office Suite, MS Visio, WebSphere, Rational ClearCase and Rational ClearQuest, Rational Test Manager, Oracle 8i, JavaScript, HTML, Competitive Intelligence, Google Analytics, WebTrends.

Confidential, NY

Business Analyst

• Implemented the entire Rational Unified Process (RUP) methodology of application development with its various workflows, artefacts and activities.
• Conducted user interviews at both in-house and client locations, gathered requirements, analyzed the requirements, and managed it using Rational Requisite pro.
• Conducted Cost benefits analysis and return on investments
• Documented the scope of the project
• Conducted Gap Analysis by identifying existing technologies, created and documented the end-user's AS-IS workflow and TO-BE business processes to better understand the mechanics of the existing system.
• Gathered Business Requirements. Interacted with the Users, Designers and Developers, Project Manager and SMEs to get a better understanding of the Business Processes, and analyzed and optimized the process.
• Analyze business requirements and segregated them into Use Case Diagrams, Activity Diagrams, Sequence Diagrams, and OOD using Rational Rose according to UML methodology thus defining the Data Process Models.
• Responsible for preparing Business Requirement Document (BRD) and then translating into functional specifications and test plans. Closely coordinated with both business users and developers for arriving at a mutually acceptable solution.
• Documented and delivered Functional Specification Document to the project team.
• Used MS Project to manage schedules, deadlines and resources and collaborate on the project.
• Performed Data Analysis of existing data through SQL and experience with EDI & ETL.
• Integrated Rational RequisitePro with Rational Rose, Rational Clear Quest and Clear Case to provide the visibility to the teams and maintain tractability among Requirements, Use Cases, Change Requests and Configuration Changes.
• Interacting with the developers on resolving the reported bugs and various technical issues.
• Assisted the QA team in designing the Test Plan and Test Cases for User Acceptance testing.

Environment: Rational Software Tools, MS Office Suite, MS Visio, Web Logic, Windows, Win-SQL, WebSphere, Rational ClearCase and Rational ClearQuest.