SUMMARY:

• Business Analyst with 8 + yrs of experience in technical and functional roles for Manhattan WMS Ecommerce, Microsoft Suite of data tools, Web - frontend applications, Content Management, Statistical analysis, Business Intelligence, Big Data and Data Warehousing.
• Worked on environments involving web services, XML, WMS, Quality Center, OMS, HTML and CSS, Java script, CQ5, Web product catalog, Sterling, UPM, and HANA, SAP, PLSQL Open Text ECM, SOA Architecture, Java, J2EE, SSMS, Informatica

PROFESSIONAL EXPERIENCE:

Confidential, Minneapolis, MN

Sr. Business System Analyst

Responsibilities:

• Responsible for defining the scope and implementing business rules of the project, gathering business requirements and documentation.
• Work with sites to capture configuration requirements for WMOS build.
• Hands-on experience with Waterfall, RUP, & Agile Scrum methodologies
• Experienced with Manhattan Warehouse Management Systems (WMS) and Order Management System (OMS).
• Responsible for writing Functional Requirement Specifications (FRS) and User Requirement Specification (URS).
• Implementation of Red Prairie WMS, warehouse management system, for both forward and reverse logistics/distribution solutions in a 3PL (Third Party Logistics) environment.
• Acted as a Subject Matter Expert (SME) on many occasions to explain in brief to the business users about the internal systems.
• Well versed with client server environment and tools like SQL/ PLSQL, SQL*Loader, and TOAD.
• Facilitated JAD sessions with the management, developers and analysts from all the dependent systems/applications and business users to refine functional requirements and to perform the Impact Analysis.
• Analyzed the complete Supply Chain, from receiving an order in OMS (Order Management System) and complete processing till final delivery to customer.
• Conducted walkthroughs with the end users and stakeholders to gather the modification requests from the user to upgrade or change the specifications for the product.
• Performed GAP Analysis, designed new business process flows, and documented various business scenarios.
• Responsible for Manhattan WMS E-commerce website developed in Hybris Platform for new enhancement of existing B2B and B2C applications.
• Followed RUP and AGILE development methodology and adhered to strict quality standards in requirement gathering
• Designed and implemented service-oriented architectures (SOA) suitable for secure, reliable, and high-performance system.
• Participate in daily SCRUM meeting and engage with development team(s) to communicate requirements, coordinate plans and progress, and assist in developing prototypes to validate user requirements, using SCRUM and Agile methodology, to define product backlog and sprint backlog.
• Proficient in creation of source to target data mapping documents in a data warehouse environment and execute SQL queries in a data warehouse environment.
• Experience managing requirements using JIRA, Remedy and HP Quality Center.
• Implemented Web Services (SOAP, UDDI and WSDL) to integrate different applications.
• Gathered requirements for the integration of POS system with the supply chain system
• Worked with UI and UX designers to create prototypes and Website workflow.
• Gathered requirements for the integration of Point-Of-Sale (POS) system with the supply chain system Manhatta WMS
• Supported the current implementation for Manhattan WMS-including the design, development, testing, training and go live support.
• Hands on experience in working on SOA, detailing out web services, data mapping of elements and defining various operations for web services.
• Facilitated JAD sessions with Data management, development team, users and other stakeholders to refine functional requirements.
• Assisted with the BRD for the Point-Of-Sale (POS) implementation project.
• Collected business requirements to set rules for proper data transfer from Data Source to Data Target in Data Mapping.
• Coordinated with UX designer to create storyboards related to user stories
• Facilitated daily stand ups and managed task board with user stories and board
• Designed Data Flow Diagrams (DFD’s), Entity Relationship Diagrams (ERD’s), and web page mock ups using modeling tools.
• Converted various SQL statements into stored procedures thereby reducing the Number of database accesses.
• Created surrogate key tables to map the required dimensions.
• Created Business Use cases, activity report, logical components and deployment views to extract business process flows and workflows involved in the project.

Confidential, Dallas, TX

Business Analyst

Responsibilities:

• Involved in development of Business and Technical Requirements in preparation of System Architecture, Information Strategy, Detailed Design documents, to satisfy the Business Needs and Processes for the core system
• Experience implementing Manhattan WMS in distribution centers.
• Experienced working on tools like Informatica and DataStage for ETL operation.
• Devised system to generate automated Business Intelligence reports for the internal users.
• Preparing technical manuals, policy terms and conditions, and meeting minutes.
• Developed and maintained legal documents as required by state and federal laws.
• Prepared project Documentation based on requirements such as Business Required Document (BRD).
• Collaborating with business partners and cross-functional teams and supporting system documentation.
• Worked extensively to socialize and execute the re-engineering of Manhattan WMS E-commerce wide requirements management structure using documentation tools such as Quality Center and Rational Requisite Pro.
• Communicating necessary changes and development to stakeholders in meetings.
• Utilized Unified Process to contribute to design standards, and provided technical leadership and expertise in reorganization of a complex End-to-End Testing effort.
• Performed Data mapping, logical data modeling, created class diagrams and ER diagrams and used SQL queries to filter data.
• Performed System analysis and organizational review of existing QA processes
• Prepared Business Process Models including business process flows from conceptual to procedural level, often applying BPR to optimize resource optimization
• Trained users on the Micro-strategy interface with particular focus on data drilling, report creation using public objects, data filtering, and grid/graph capabilities of the Dashboard
• Focused on continuous process improvement strategies with a clear and measurable Development Process that is deployable throughout the enterprise
• Controlled project resources, planning and implementation using MS Project, SharePoint and AGILE methodologies
• ExaminedOrder Management System (OMS)to ensure compliances with upgrade requirements, and generated documents for the workflow of exiting system and desired system that involveCash Analysis, Portfolio Analysis, Order Initiation, Order Execution, Trade Clearing, and Booking, and performed gap analysis.
• Modeled business architecture by gathering Business Requirements and creating Functional Documents, scheduled and monitored development process
• Gathered and analyzed Business and User Requirements from walkthroughs with the users and business developers. Used Rational RequisitePro to create the requirement analysis and specification documents
• Analyzed the complete Supply Chain, from receiving an order in OMS (Order Management System) and complete processing till final delivery to customer.
• Assisted the technical team in translating application functionality into application architecture and the production of a System Functionality document
• Conducted JAD sessions, initiated process improvements and worked as an interface between the users and different teams involved in the application development for the better understanding of the functional and IT processes, and thus converting business needs into proficient, quality solutions
• Followed a structured approach to organize requirements into logical groupings of essential Business Processes, Business Rules and Functional specifications, thus ensuring that Critical Requirements are met thoroughly
• Coordinated the Functional and Performance Testing of the ERP with the QA team

Confidential, Houston, TX

Business Analyst

Responsibilities:

• Conducted interviews for business requirement gathering (BRD) from three primary focus groups, including sales, finance, and other internal teams.
• Organized scrum meetings for the team and reported the burn-down chart to key stakeholders.
• Developed the data flow diagrams to observe the flow of information across the ETL processing.
• Created an ER diagram to explain the work flow of information for the technical team as a part of the functional specifications.
• Worked with the business to develop mockups for requirements regarding the business intelligence reports.
• Developed Use Case Diagrams, Activity Diagrams, and Sequence Diagram using MS Visio.
• Utilized UML and source-to-target mapping to cause a clarified understanding of the project and the ETL process, and worked alongside the ETL development team to sort out issues and maintain a consistent completion of stories in JIRA.
• Updated all the data sources-specific documents and the business documents on SharePoint.
• Worked as the liaison between the development and the business team, and provided separate updates for both.

Confidential, Houston, TX

Business Analyst

Responsibilities:

• Worked with the Subject Matter Experts (SMEs) to generate business requirement documents (BRDs) that included basic goals of the new enhancements and series of expected call to actions.
• Developed Gap analysis based on focus groups and interviews to ensure accuracy in expectations of SMEs.
• Worked with the sales group to gather business requirements around the sales attributes that needed to be added on their position records.
• Analyzed Google analytics data and developed reports for the business team to gauge on potential growth of new features and risks.
• Developed FSDs based on BRDs, and communicated these to the development team.
• Researched previous documents and evaluated the Business Objects Interface to see the projected requirements of the project.
• Utilized the extraction process to the fullest to identify data sources for dimensions and measures that complimented the requirements based on the functional specifications.
• Gained experience in segmenting data for traffic coming from other websites.
• Managed scope changes in the same area based on customizations required by Sales.
• Created workflow processes and set up different events and members who need notifications using SharePoint and MS Project, as needed.
• Coordinated with data warehouse team and business intelligence team to streamline data.