SUMMARY

• 8+ Years of Professional Experience as Business Analyst in Retail, E - Commerce, and Supply Chain Environments.
• Good experience at B2B, B2C and Ecommerce portals web application developments and CRM.
• Oracle Applications: Inventory, Purchasing, Order Management System (OMS), Bill of Materials (BOM), Work in Process (WIP), Warehouse management systems (WMS).
• Extensive experience working with FMCG (Fast-moving Consumer Goods) / CPG (Consumer Packaged Goods) clients.
• Expert in business process engineering and software development life cycle methodologies i.e., Waterfall, RUP, Agile, Scrum, and Prototype, including analysis, design, development, Confidential analysis testing and implementation of software applications.
• Very Good at ATG Dynamo B2B Commerce, ATG B2C Commerce, Shopping Cart, Product Catalog, Merchandizing, Droplets.
• Expert level working knowledge in different verticals and areas like Localization, Mobile-Commerce, SCM and CRM.
• Experience in Oracle Retail Modules like RMS, REIM and RPM and has very good experience in Order Management Application Sterling WMS.
• Expert understanding of Electronic Data Interchange EDI Process, standards, and transactions.
• Good working experience at Master Data Management (MDM), Identity data, Trade Promotions Management (TPM) and Point of Sales (POS).
• Performed analysis and implemented updates for the Data Warehousing Application.
• Experienced in Activity Modeling Phase in Data Warehousing Design and Creation of Confidential Tables and Databases and choosing Indexes in Confidential .
• Involved in writing test plans, defining test cases, test scenarios and data sets developed and maintained test scripts, analyzed bugs, and interacted with development team in fixing the errors.
• Reworking the user experience through improving the systems informational architecture and overhauling the application user interface using UX/UIbest practices.
• Interacting with business SMEs, enterprise architects, developers, business intelligence, and data warehouse teams regarding project requirements explanation and interpretation.
• Experience working with Retail Oracle POS application, Payment processing (EMV).
• Expertise with Supply Chain Management (SCM), supply chain strategies/vendor manufacturing process methods to determine level of procurement and strategic sourcing strategies/plans and worked with vendors/peers to determine lead times, schedules, and cycle counts, established requirements needs.
• Extensive experience in Gathering Requirements, Scoping Requirement and creating Business Requirement Documents, User Requirement Specifications, Functional Requirement Specifications, System Requirement Specification, Test Plan, analyzing and Creating Use Cases, Use Case Diagrams, Activity diagrams, System Workflow Diagrams, Data Flow Diagrams, Business Flow Diagrams.
• Expert in documenting project plan, Business Requirements Document (BRD), Test Plans, Use Case Specifications, Functional Specifications (FSD) and Systems Requirements Specification (SRS).
• Experienced in facilitating Joint Application developments (JAD) and Joint Requirement planning sessions (JRP), End user interviews, workshops, and requirement elicitation sessions, providing production support, interacting with the business customer to resolve issues during UAT. conducting training sessions to educate the business customer on the application.
• Excellent communication skills, Interpersonal skills, interacting with team members, leadership qualities, mentoring, ability to work independently.
• Well versed in using project management tools for managing and facilitating the development process using Jira, MS Project, Visual Studio Online.

PROFESSIONAL EXPERIENCE

Confidential, Arlington, VA

Sr. Business Analyst

Responsibilities:

• Served as primary contact between retail locations and Headquarters to resolve IT POS application issues.
• Developing business requirement updates while working with different user groups to define priorities concerning project development.
• Conducted brainstorming and JAD sessions with stakeholders and end-users for requirement analysis and documented the same.
• Provide support in developing and maintaining ETL processes that extract data from multiple SOR's residing on various technology platforms tan transport the data to various delivery points such as data marts or data warehouses.
• Gatheird requirements for a Merchandise Assortment planning tool created for Retail Business that created worksheets of merchandise assortments that were based on location that provided retail stores laid out the detail diagrams.
• Determined the process and wrote unique T-SQL scripts for non-standard data imports for the Merchandising.
• Developed estimates, project plans (Microsoft project), training material, BI reports using Micro Strategy.
• Performed testing on a data warehouse platform, including data integrity and data validation.
• Developed business solutions through implementation of Business Requirement Gathering, Business Process Flow Analysis and Business Process Modeling by utilizing Caliberas well as Scenario Based Requirements processes (SBR).
• Used UML during requirements gathering and created Use Case Models and Use Case Diagrams for the purpose of stakeholders in the project to halp them understand the workflow of the system associated with the requirements.
• Wrote Confidential scripts for data manipulation, data inserting millions of records into tables.
• Updated and remediate existing Business Intelligence scripts and Confidential applications to reflect changing business data requirements.
• Determined merchandise needs for store locations and created and completed corresponding purchase orders.
• Analyzed, coordinated, documented, and managed project requirements, project processes and procedures and its changes throughout the software development lifecycle.
• Performed Requirements Analysis and traceability using Test Director and MS Word.
• Developed prototypes to demonstrate the newUIfor stakeholders.
• Involved in writing test plans, defining test cases, test scenarios and data sets.
• Developed and maintained test scripts, analyzed bugs, and interacted with development team in fixing the errors.
• Worked with Subject Matter Experts (SME), project team members (business and technical), to define technology application for the business and system requirements.
• Also worked with the QA Team Lead to develop QA standards and ensured compliance with all regulatory requirements.
• Developed several MS Excel spreadsheets and applications to automate manual calculations and optimize reporting structure.
• Created and segregated SQL views and stored procedures for obtaining meaningful set of data.
• Extensively used MS Project for status reporting and planning throughout the project lifecycle.
• Conducted Joint Application Development (JAD) sessions with IT groups.
• Identified the Key Changes and participated in Stakeholder Management to communicate effectively with them.
• Created Mock-up forms in MS word for better visualization and understanding of the software solution.
• Tracked change requests and monitored workload and schedule.
• Used MS Visio for Process modeling, Process mapping and Business Process flow diagrams.

Confidential, Stratham, NH

Business Analyst

Responsibilities:

• Involved in Inception Phase and prepared vision statement and initial data models that contain Business Requirement Documents and supporting documents that contain the essential business elements and detailed definitions.
• Performed the requirement analysis and documented the requirements using Rational Requisite Pro.
• Co-authored business requirements document with project teams.
• Extracted, discussed, and refined business requirements from business users and team members.
• Interacted with the business users in knowing the business views and gatheird the reporting requirements to design the universes and business objects.
• Scheduled and maintained web analytics source data and provided UI reports using Confidential Site Catalyst.
• Develop and maintain sales reporting using in MS Excel queries, SQL in Confidential, and MS Access.
• Produce performance reports and implement changes for improved reporting.
• As part of CRM Activities, gatheird client data, managed, tracked, and analyzed dis data to improve customer relationships and targeted marketing campaigns and pricing along with Marketing Team.
• Experienced in testing product qualification testing in point of sale (POS) application.
• Worked with Data Warehouse in the development and execution of data conversion, data cleaning and standardization strategies and plans as several small tables are combined into one single data repository system MDM (Master Data Management).
• Tested the web application components of Content Merchandising System, Oracle RMS (v9, v10), WebSphere commerce functionality on various web browsers as part of UI testing.
• Strong understanding of Data mining techniques with knowledge in end-to-end data reconciliation, SQL, PL\SQL, Oracle\ETL environments (tools like Confidential).
• Used Rational Tools for creating use cases, version control and defect tracking, monitoring.
• Used Rational Unified Process (RUP) methodology in all areas of the software development life cycle.
• Planned and defined Use Cases created Use Case diagrams, Scenarios and Use Case Narratives using the UML methodologies.
• Participate in Development Solution in regard to Interwoven TeamSite related design and implementation concepts.
• Analyzed company specific data - Production amounts, forecasting and demand planning, inventory stocking at wholesaler & distributor, inventory turns per SKU, retail outlet coverage region-wise, merchandising & tax costs.
• Involved with multiple project teams of technical professionals through all phases of the SDLC using technologies including Oracle, Erwin, DataStage, Data Warehousing, WebSphere, and Cognos.
• Helped design data warehouse solutions and business intelligence dashboards and scorecards.
• Developed E-Business Suite programs for databases supporting supply chain management, order management, inventory, warehouse management system, purchasing, and iProcurement.
• Reviewed the data model and reporting requirements for Cognos Reports with the Data warehouse/ETL and Reporting team.
• Coordinate testing efforts across multiple JDA supply chain and retail applications includingallocations and replenishment.
• Used MS SharePoint for the purpose of managing documents and for hosting websites which was used to access shared workspaces and documents.
• Worked with information architects and creative groups in detailing the wireframes and depicting GUI design.
• Uploaded documents produced onto SharePoint, an intranet website for all Technology Information Group members to download, revise and upload shared documents.
• Custom tools upgrade client had created marketing, merchandising product tools to support their custom web application which needed to be re-architected to work with ATGs ecommerce suite.
• Created and managed project templates, use case templates, requirement types and tractability matrix in Requisite Pro.

Confidential, Andover, MA

Business Analyst

Responsibilities:

• Function as the main conduit between the IT development group and the Operation'sbusiness managers and users to halp prioritize requirements and optimize resources.
• Included numerous trips and conference calls to gather requirements, identify issues and gaps, prepare training documents, train superusers, provide go-live and follow up support as needed.
• ComposeBusinessRequirements Documents and Business Functional Specification Documents routinely as new requirements are presented.
• Engaged in Requirement gathering (BRD), Solution Design (Process Documents) for Inventory, Costing, Quality,WIP & BO Mmodules.
• Developed dozens of test plans for implementing new system functionality.
• Extensive working knowledge of Oracle 11.5.9 in Purchasing, Planning, Inventory, Bills of Material & Manufacturingas a user, as a trainer and as a change advocate.
• As a user, focus on data conversion validation and training co-workers on daily activities.
• As a change advocate, deal with training, managing sections of the data conversion and various project checkpoints (Conference Room Pilots, User Acceptance Testing, Go-Live and Post Go-Live support).
• Worked with Data Warehouse in the development and execution of data conversion, data cleaning and standardization strategies and plans as several small tables are combined into one single data repository system MDM (Master Data Management).
• Designed, trained, and implemented an automatically distributed supplier forecast.
• Enables buyers, managers, and suppliers to quickly access the continually changing requirements.
• Consolidated reports from 8 company sites to now have a single face to the supply base.
• Spearheaded the implementation of Oracle I Supplier which allows the purchasing group to seamlessly communicate purchase order requirements with the supply base.
• When a reoccurring issue is revealed, I proactively investigate the size, scope, and audience to understand what the best course of action is.
• As additional sites were migrated to Oracle, I halped identify that transitioning from MRP to DRP, along with setting up inter-company sourcing rules which has enabled supply and demand signals to be distributed across organizations instantaneously.
• Routinely participate in Confidential analysis efforts and new software assessments.
• Work with Operation's management team to prioritize issues and identify future improvement opportunities.
• Developed functional spec for outbound interface to the transfer intercompany billing documents to AS400 system.
• Periodically engagebusinessusers to identify pain points and other opportunities for enhancements.
• Conduct training classes for a broader audience such as non-inventory requisition training as well as very specific training classes directed at buyers, planners, ormanufacturingengineers.
• Project lead for implementing online requisition and purchase order approvals which included defining the requirements with the management team, developing the solution, performing the setups in a test environment, running user acceptance testing sessions, writing the training documentation, and successfully implementing the system.
• Improved inter-company ordering and fulfillment processes across organizations on Oracle by setting up various sub inventories for Min-Max planning and using inter-location transit times and shipping networks to accommodate for in transit time between internal and/or external locations.

Confidential, Oakland, CA

Business Analyst

Responsibilities:

• Developed and instituted new procedures and protocolsfor proper chain of command communications between all users of the Confidential. dis resulted in fostering a more efficient processto ensurequeriesweretimely addressed and resulting inKellwood benefiting and utilizing all contracted benefits from Confidential .
• Interacted with the SMEs and stakeholders to get a better understanding of client business processes and gather business requirements.
• Identified/documented data sources and transformation rules required populating and maintaining data warehouse content.
• Performed Confidential analysis and implemented updates for the Data Warehousing Application.
• Modeling the As-Is system and doing the complete Confidential Analysis for the existing system in order to map it to the To-Be system.
• Used Balance Scorecard approach for developing program strategy in order to manage the grants program and development of metrics for monitoring success of program.
• Used MicroStrategy dashboards for data analysis and custom reports.
• Managed SOA/Process Integration Prepared High Level Logical Data Models and BRD’s (Business Requirement Documents) supporting documents containing the essential business elements, detailed definitions, and descriptions of the relationships between the actors to analyze and document business data requirements.
• Conducted JAD sessions for communicating with Stakeholders and Project directors.
• Created business process workflow diagrams (Activity diagrams) in Rational Rose.
• Designed, developed, and maintained various Business unit reports by using Confidential, SQL, and MS Excel.
• Created Use-Cases and Business Use-Case Model after accessing the status and scope of the project and understanding the business processes.
• Integrated Requisite Pro with Clear Quest and Rose to provide all teams visibility and maintain tractability among requirements, use cases and change requests.
• Managed all the requirements in Requisite, making requirements available to all team members.
• Created requirements analysis and design phase artifacts using Requisite, Rational Rose, and Smart Draw to create DFDs, ER diagrams, Use cases, Activity/ State chart, Sequence, Collaboration and Deployment Diagrams.
• Used the Unified Change Management from Rational to track changes to multiple artifacts by versioning artifacts, associating requirements to specific change request/defects to streamline the defect/change tracking process.
• Performed Feasibility Analysis, Risk Analysis and Confidential Analysis on vendor/third party tools.
• Followed the UML based methods using Rational Rose/MS Visio to create Use Cases, Activity Diagrams / State Chart Diagrams, Sequence Diagrams, and Collaboration Diagrams.
• Coordinated and prioritized outstanding defects and enhancement/system requests based on business requirements, allowing sufficient time frame to ensure accuracy and consider deadlines.