PROFESSIONAL SUMMARY:

• Exposed to business and operational processes in various diverse industries; especially, Retail, Supply chain manangement and Finance.
• Proficient in writing detailed level functional specification, system design, design documents, Interface design documents.
• Proficient in creating Solution Architecture, System / functional specifications (high level and detailed level), UML diagrams, Use cases, dataflow diagram, screen mockups, non - functional requirements, etc.
• Proficient at preparing conceptual and logical data models, data modeling, data mapping, database design, object-oriented analysis etc.
• Proficient in preparing interface requirements, interface design, system to system and GUI User interfaces.
• Good Exposure on POINT OF SALES (POS), Change Management and Order Management System (OMS).
• Translate functional requirements into Use cases for B2B and B2C ecommerce solution.
• Have good knowledge of different ecommerce platforms like ATG, IBM WCS (Web sphere), Hybris and Blue Martini.
• Expertise in batch processes, backend processing, data warehousing, Data Mapping, Data modeling, data analysis, Web based applications, Client /server applications
• Expert in using modeling tools such as MS Visio, Rational Rose. Expertise in using other tools such as Rational Requisite Pro, MS word, MS excel, MS access, MS project.
• Excellent skills in training, facilitation, Power point presentation, leading team meetings, technical writing.
• Experienced in conducting JAD (Joint Application Development) sessions, SWAT team meeting, walkthroughs, review meetings, defect resolutions.
• Strongknowledge & understanding of industry standard methodologies includingSoftware Development Life Cycle (SDLC), and Project Life Cycle.
• An effective team player recognized for having excellent communication and presentation skills.
• Experience in interacting/interfacing with various stakeholders. Coordinate with stakeholders to develop business requirements, analyze an acceptable functionality solution, translate the requirements into specification documents, and communicate the requirements clearly to the development and quality assurance team.
• Extensively utilizing requirements collaboration techniques like workshops, questionnaires, meetings (kickoff, structured, unstructured, brainstorming) interviews, business case use cases, scenarios descriptions, walkthroughs document analysis. Organize and invigilated Joint Application Development (JAD)/Joint Requirements Planning (JRP).

TECHNICAL SKILLS:

Project Methodologies: Rational Unified Process (RUP), UML, Agile, Waterfall

Business Modeling Tools: Rational Rose, MS Visio

Requirement Management Tools: Rational RequisitePro, Doors, Jira

Operating Systems: Windows Vista/7, UNIX

RDBMS: Oracle, SQL Server

Business Applications: MS Office Suite including MS Access &MS Project

Design Tools& Languages: Microsoft Visio, VB, C, C ++, SQL, HTML and JAVA

PROFESSIONAL EXPERIENCE:

Confidential, Menomonee Falls, WI

IT Business Analyst

Responsibilities:

• Created an integrated project plan tracking the key milestones and dependencies.
• Coordinated activities between business unit and technical staff, developing new methods, policies, and procedures to meet the business needs, and acting as primary trainer in education of the business unit as it relates to business applications.
• Documented business workflows textually as well as in UML diagrams and provided them to stakeholders for review.
• Extracted the business requirements for different LOB’s from various sessions with business leads and maintained them using HP Quality Center, tracing them all the way to the system artifacts.
• Worked extensively with retail data of stores to gather requirements for RDM (Reference Data Management) tool to push Forecasts to Warehouse.
• Well-developed business and supply chain understanding attained through diverse assignments in logistics, sales, and business analysis at both staff and manufacturing locations.
• Prepared detailed reports analyzing the supply chain practices and offered suggestions for improvement
• Worked with clients and vendors to prepare Functional Requirements documents that include automated interfaces to third party vendors’ Order Management Systems.
• Conducted analysis of client business processes and functional or reporting requirements
• Regularly updated projections of sales and inventory levels up to 12 months into the future in order to better prepare for and capture the sales potential of the retail market and ensure profitability by optimizing inventory levels, relying upon anticipation of sales trends and consequent receipt need well in advance of actual spending
• Created spreadsheet in MS Excel to predict demand patterns, the results of which drives purchasing and shipping schedules to ensure adequate availability of product at the distribution center and at the store level. Automate the calculations by creating macro in VBA.
• Create ad hoc reports with SQL; perform daily and weekly report generation and maintenance procedures.
• Moved domestic sourcing in line with Import Production, given reality of business and market, and due to the fact that most domestically sourced items were produced overseas; initiated long-term projection based production planning for domestic vendors.
• Assisted requirements planning for warehouse and sales order management systems.
• Involved in the UAT process to check the reliability and acceptability for end users against the original requirements and reviewed test procedures, test cases and maintain test scripts
• Work with the business owners of data and IT to develop solutions that will ensure proper usage, accessibility and quality of the information within the business subject area(s) assigned.
• Conducted Back-End Testing Using SQL Commands.
• Extensively used SQL statements to query the Oracle Database for Data Validation and Data Integrity.
• Created and maintained SQL scripts and Unix Shell scripts as a part of back-end testing on the oracle database.
• Executed SQL statements to check if the data integrity has been maintained.

Environment: MS Windows, Windows Server,HP Quality Center, MS Office, Snag IT, MS Lync,TOAD, UNIX

Confidential, Warminster, PA

Business Systems Analyst

Responsibilities:

• Interviewed Business Users to gather Requirements and analyzed the feasibility of their needs by coordinating with the project manager and technical lead.
• Worked on the Inventory Management using the RF Unit.
• Established a business analysis methodology around the RUP (Rational Unified Process). Helped develop use cases, project plans and manage scope.
• Supported project metrics analysis, team communication, resource planning, risk analysis, report generation, and documentation control using Workbench application.
• Perform Gap Analysis of the processes to identify and validate requirements.
• Responsible for order management system design, implementation, and maintenance
• Identified/documented data sources and transformation rules required populating and maintaining data warehouse content.
• Performed extensive data modeling to differentiate between the OLTP and Data Warehouse data models
• Designed the business requirement collection approach based on the project scope and SDLC Methodology.
• Created Activity Diagrams, Sequence Diagrams and ER Diagrams.
• Worked with Cognos and micro strategy reporting systems to extract the data for analysis using filters based on the analysis.
• Conducted Joint Application Development (JAD) sessions with IT groups. Identified the Key Changes, and participated in Stakeholder Management to communicate effectively with them
• Developed and Documented timelines for Project Delivery, and managed Projects and Resources to successful completion.
• Participated in customizing Order workflow in Order Management in accordance to user’s specifications.
• Prepared graphical depictions of 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.
• Worked on Documentum for Version Controlling, to maintain up to date changes in the Documents.
• Conducted User Acceptance Testing, gathered and documented User Manuals and Business Rules.
• Conducted JAD sessions with management, SME, vendors, users and other stakeholders for open and pending issues. Incorporated Rational Unified Process (RUP) to create Business Requirement Document Specifications using MS Visio and MS Word.
• Facilitated and managed meeting sessions with committee of SMEs from various business areas including Mortgage Servicing, Loan Monitoring and Asset Management.
• Performed requirements gathering from the business users of the system while adhering to SDLC (Software Development Life Cycle) industry best practices.
• Various versions of the documents generated during the project were maintained and managed using Rational ClearCase and performed defect tracking using Rational ClearQuest.
• Planned and defined system requirements to Wire Frames with Use Case, Use Case Scenario and Use Case Narrative using the UML (Unified Modeling Language) methodologies. Designed the business requirement collection approach based on the project scope and SDLC methodology.
• Identified and documented all issues and defects to ensure desired quality of the application functionality.
• Worked with development team members to better understand system functionality in order to improve testing quality.
• Delivered informative and well-organized documentation & presentations.
• Created and managed project templates, use case project templates, requirement types and traceability relationships in RequisitePro and managed the concurrence of the parties involved with respect to the evaluation criterion

Environment: JSP, HTML, XML, Clear Case, Clear Quest, XSL, Cobol, Rational Rose, MS Office Suite, MS Visio, RUP, UML, MS Project, SQL Server, MS Access, MS Excel and MS Word

Confidential, Goodlettsville, TN

Business Systems Analyst

Responsibilities:

• Conducted one on one and JAD sessions to gather complex requirements for data acquisition, conversion scheduling and data mapping routines.
• Involved in gathering, documenting and verifying business requirements.
• Translated user requirements into business requirements that are testable and traceable through business and functional requirements and/or workflow changes.
• Worked on supply chain sustainability that includes projects to reduce energy cost, any form of waste and application of green technologies within transportation and logistics.
• Created the workflow for Retail Management System (RMS) and Warehouse Management System (WMS).
• Identified end to end requirements for all systems and business units that may be impacted by the project
• Defined the timeline for gathering business requirements.
• Involved with Developer and QA team as pairing party during Sprints in Agile environment.
• Used the guidelines and artifacts of the Rational Unified Process (RUP) to strategize the implementation of Rational Unified Process effort in different iterations and phases (Inception, Elaboration, Construction and Transition) of the Software Development Life Cycle.
• Used user stories to define and explain requirements to development team in the agile environment practically worked on Point of Sale(POS) to observe customer’s problems and concerns.
• Facilitated JAD sessions to collect requirements from system users and prepared business requirement that provided appropriate scope of work for technical team to develop prototype and overall system
• Developed requirements integrating E-R diagrams and designed the testing process flows.
• Participated in daily Scrum meetings for various data analysis tasks.
• Created and managed change control guidelines and managed all the change requests/additional requirements through this processes.
• Coordinated with various business and technical teams working on different tracks for scheduling, requirements, dependency and risk.
• Created and managed MS Share Point for issues management, data review, project management and document repository.

Environment: MS SQL, PL SQL, SQL Server 2005, Oracle 9i, Informatica 8.5, Excel, MS Project, MS Visio, MS Share Point, Agile-Scrum

Confidential, Westfield, OH

Business Analyst

Responsibilities:

• Worked extensively with various stake holders, project teams and management to analyze and identify the business processes.
• Analyzed business needs, created and developed new functionality to meet real time data integration that facilitated decision-making.
• Created extensive questionnaires for performing GAP analysis and documented the gaps between the current capabilities and the desired requirements.
• Design, document and present functional story board designs to show the benefits of a web based system.
• Participated in planning and review meetings with engineering, QC, documentation, product management, customer service leads and Subject Matter Experts.
• Extensively involved with creating functional artifacts including detailed use cases, activity and work flow diagrams, traceability matrices and test plans
• Documented detailed use cases that translate high-level requirements into system/functional specifications
• Produced detailed description of user stories, business rules, flows, and data elements required developing new and modifying existing products.
• Established traceability between business use cases, low level/detailed use cases and software requirements specifications.
• Translated surveyors requirements into functional specifications for the development of the insurance online system and managed changes to those specifications.
• Worked closely with the stakeholders to define, build, deliver and maintain web based applications.
• Tracked key project milestones and adjust project plans and/or resources to meet customer needs.
• Identified and documented definition needs for project glossary.
• Conducted JAD sessions with business stakeholders to elicit business systems and business processes.

Environment: MS Visio, MS Word, MS Project, SQL, MS Excel