SUMMARY

• 5+ years of experience in customization and implementation of IBM Sterling OMS and Manhattan OMS for several global clients and Proficient in Design and development of IBM Sterling Order Management System (OMS) & Message Oriented Middleware (MOM) solutions using IBM Websphere Message Queue.
• Over 7+ plus years of experience as a Business System Analyst in requirement gathering, analysis and business processes management with adept knowledge of System Development Life Cycle (SDLC) using Waterfall, RUP, and Agile methodologies.
• Working Experience in Data Analysis, Data Profiling, Data Migration, Data Mining, Data Auditing, Data Integration and Metadata Management Services. Working knowledge in writing SQL query for identifying databases involved in the application development.
• Experience in design of order fulfillment, payment processing, tax, invoicing and establish integration with multiple external systems like Legacy, Inventory Management System, Warehouses, vendor merchandizing systems etc.
• Extensive domain knowledge in retail industry including Point of sale, Store management, Inventory management and E - commerce IBM Sterling order management and Specialized in Inventory Management functions including global inventory visibility, inventory adjustment, inventory synchronization
• Domain knowledge in areas of Order Management including Order verification (Fraud), vendor integration (PO management), Tax & Invoicing, Payment processing.
• Extensive experience in using SQL Server Management Studio and Microsoft office tools such as Advanced Excel (lookups, functions, Pivot Tables & charts), MS Word, MS PowerPoint and MS Visio.
• Hands-on experience in complete OMS implementation tasks such as UI customization, Functional customizations, Altering the order flow using pipelines, Security/ Access control, Hotfixes, Enhancements based on business requirements, Configuration deployment and Production support.
• Skilled in Performing GAP analysis of business process, system opportunities and data migration constraints in order to improve accounting, billing and credit business processes across different functional areas.
• Experience in developing functional, non-functional and technical requirements for the technical developers that are free from ambiguity to minimize re-work and errors while being aligned with the SDLC standards and also experience in Plan, design, and implement application database code objects, such as stored procedures and views using SQL.
• Expertise in Project Planning, Project Design, gathering requirements, creating Functional Specifications, and Data Flow Diagrams.
• Knowledge of Relational Database Management System (RDBMS), knowledge of Microsoft BI technologies like MS SQL Server Integration Services (SSIS), MS SQL Server Analysis Services (SSAS), MS SQL Server Reporting Services (SSRS) and MS SQL Server.
• Conversant in a broad range of technologies and tools, including business process tools such as Erwin, Rational Rose, MS Visio and Data Analysis.
• Extensive experience in Requirement management tools such as JIRA, Rally and QC. And Created defect tracking using HP QC and JIRA and reviewed them in subsequent iterations of the application development process.
• Extensive experience in configuration of Order-To-Cash (OTC) business process with focus on areas of Order Management, Pricing, Availability-To-Promise (ATP), Delivery & Billing.
• Understanding of Business Intelligence and Data Warehousing concepts with emphasis on ETL and life cycle development including requirements analysis, design, development, testing and implementation.
• Extensive experience in gathering requirements and authoring Business Requirement Documents (BRD), Software Requirement Specification (SRS), Functional Requirement Document (FRD) and maintaining Requirement Traceability Matrix(RTM).
• Experience in conducting Joint Application Development (JAD) sessions for requirements gathering, analysis and design, and Rapid Application Development (RAD) sessions to congregate early toward a design acceptable to the customer and feasible for the developers.
• Skilled in Performing GAP analysis of business process, system opportunities and data migration constraints in order to improve accounting, billing and credit business processes across different functional areas.
• Strong knowledge of data modelling, mapping and design using Unified Modelling Language (UML) and Use Cases, Sequence Diagrams, Activity Diagrams, Collaboration Diagrams and Class Diagrams using rational tools and Microsoft Visio.
• Experienced in writing Test Cases, Test Scripts and generating Test Data. Also, experienced in UAT, Functional, Regression, Back End, Stress White Box, Black Box and Unit Testing.
• Extensive experience in conducting Joint Application Development (JAD) sessions for project definition involving analyzing requirements, creating prototypes, user interfaces, database schema and system design.

TECHNICAL SKILLS

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

Business Modelling Tools: MS Visio, MS Project, Erwin, Power Designer, Doors, TFS, Balsamiq, Mockingbird

Languages: C, UML, Oracle, HTML, XML, SQL, PL/SQL

Operating Systems: Windows, MS DOS, Linux

Databases: SQL, MS Access, Oracle, SQL, MySQL server, MS Access, Server, Oracle 10g/11g, DB2,

Quality Assurance: Quality Centre, Load runner, TOAD

Requirement Management Tools: Rational Requisite Pro, MS Test Manager, SAP Business Objects, Crystal Reports

Business Applications: Microsoft Office Suite- Word, Excel, PowerPoint & MS Share Point

PROFESSIONAL EXPERIENCE

Confidential - Bentonville-AR

Sr. IBM Sterling Consultant

Responsibilities:

• Responsible for implementation of IBM Sterling Order Management system and actively involved in in processing Invoices, Credit memo, Re-bills & order management Transactions.
• Worked on fulfillment models (3rd party model, Inventory, customer pays order, ship order to the customer, In-house fulfillment).
• Defined the entire Omni-channel strategy based on project goals with concerned stakeholders and amplify the details consisting of IBM Sterling order management and fulfillment.
• Standardized reports in SQL Server Reporting Services (SSRS). Centralized reports on reporting server for departmental access through IE Browser and setup subscriptions to run on scheduled basis and email reports in Excel file format directly to department personnel.
• Extensive experience in configuration of Order-To-Cash (OTC) business process with focus on areas of Order Management, Pricing, Availability-To-Promise (ATP), Delivery & Billing.
• Performed data analysis by using SQL queries and used Query Analyzer optimize SQL Queries. Applied SQL and other data analysis tools to fulfill plan requested enhancements to existing data products.
• Involved in Sterling commerce upgrade project (version 9.2 to 9.4)), which includes DB2 upgrade, WAS upgrade and OS migration from UNIX to Linux.
• Worked on several production support issues in IBM Sterling Order Management like stuck SO lines, RMAs, pick release & shipping documents, adjustments & maintaining setups in OM and advanced pricing
• Performed all of the setups for Order Management including defining of the OM Workflows, Transaction Types, Line Transaction flows, RMA Process, Setting up Pricing in Advance Pricing (Modifiers, Qualifiers, Pricing Formulas), Shipping Networks, Shipping Parameters, etc.
• Design and create finance data and reporting reconciliation using OBIEE, Excel, Oracle ERP, SQL and Tableau. Developed business confidence in reporting system.
• Create SSIS packages to perform ETL functions and automate data needs.
• Lead design and development of various order fulfillment flows like Click and Pull (both post-paid and pre-paid), drop ship vendor, special tire order, gift card and OWN wire house deliveries.
• Also Involved in enhancement and implementation of Home Depot's various order fulfillment process flows like buy online pickup from store, buy online ship to Store, store to store fulfillments (fly-by) and buy online deliver from store.
• Responsible to generate reports for various critical business activities (including inventory tracking, order release, fraudulent orders and financial reports)
• Identify data & reporting issues and manage the corrections. This included involving the developer and quality testing and then following the release process to ensure the data was corrected in a timely manner.
• Responsible to Track, Document, Capture, Manage and Communicate the Requirements using Requirement Traceability Matrix (RTM) which helped in controlling numerous artifacts produced by the teams across the deliverables for a project.
• Ensuring all the test results are updated in QC and remedy tool at the time of UAT (User acceptance testing) and SIT (System integration testing).
• Interacted extensively with Subject Matter Experts (SMEs) in understanding and documenting the requirements pertaining to introducing new insurance products, on line claim reporting process, on line policy change and many other such business areas.
• Performed requirements modeling and develop analysis diagrams, activity diagrams, sequence diagrams, state diagrams, data models, and use-case realizations using RUP tools in Agile/Scrum.
• Conducted one-to-one meetings and Web-Conferences as well as JAD sessions with different stakeholder, analyzed and came up with suggestions providing consistent process for the communication, escalation, and resolution of issues.
• Involved in Requirement Gathering and analyzing high priority requirement for implementation and communicated with users and business analysts to gather requirements and Developed Business Requirement Documents (BRD) and Functional Requirement Document (FRD) for this integration.

Confidential

Sr. IBM Sterling Consultant

Responsibilities:

• Involved in design of order fulfillment and integration with multiple external systems like Inventory Management System, Warehouses, vendor merchandizing systems etc.
• Worked as Senior Data/Business System Analyst for Agile Team working on ETL/SAS based Consultative Analytics Reporting Platform and also actively Participate in quality management reviews, reviews of the testing output, POCs, Pilots, and other identified work products to ensure they fulfill the requirements.
• Worked on various order fulfillment flows like Click and Pull (both post-paid and pre-paid), drop ship vendor, special tire order, gift card and OWN wire house deliveries.
• Mapped data elements to capture transactions coming from IBM sterling Order Management Systems. Worked on integration of new changes in implementation Omni channel POS (Point of Sales).
• Defined the entire Omni-channel strategy based on project goals with concerned stakeholders and amplify the details consisting of IBM sterling order management and fulfillment.
• Completed cost benefit analysis, ROI, and other financial analyses for related business lines related to system upgrades, replacements, and changes.
• Developed SAS Macro programs to create Ad-hoc reports. Created macro program to create Macro variables to pull data from DB2 for monthly data extraction and Extracted data from different sources like Oracle and Teradata and text files using SAS/Access, SASSQL procedures and created SAS datasets.
• Worked on a Unix and Windows platform in a server application environment. Done performance tuning for the programs created.
• Used SAS Proc SQL pass through facility to connect to DB2 tables and created SAS datasets using various SQL joins such as left join, right join, inner join and full join.
• Prepare daily, monthly, and ad hoc reports (by PowerPoint, Excel, pivot tables, and pivot charts, etc.), and present findings and recommendations to all levels of senior management.
• Assisted in the design and testing of program logic, coding programs, program documentation and preparation of programs.
• Developed Data Mapping, Data Governance, Transformation and Cleansing rules for the Master Transformation on the files received from clients and consumed by Sql Server and developing repetitive loops for retrieving array variables for joining of datasets for ad-hoc reporting.
• Communicated clearly with sales, the customer, warehouse sales team members, finance team, logistics partners and across Order Management.
• Extensively used Base SAS- ETL to load data from Teradata, SQL server, oracle, Flat files and sources to Teradata Data warehouse as target.
• Worked on huge data transfers from & to SQL Server Databases using SSIS and used configuration files for production deployment.
• Worked with the Technical team- Architect, Tech lead, Developer and System Admin to Identify the Risk involved and create the system to be built.
• Based on the Business Requirements, and design of new system, I met with CIS team to have System Requirements and Worked with system integration team to implement the requirements in Hyperion and established financial DataMart in SQL Server.
• Develop Analytics reports in SAS by creating framework of ETL logic. Mentor development/testing team in building high quality SAS programs for client reporting.
• Prioritize User Stories based on Business Value & Return-On-Investment (ROI) for quick delivery to market and maximize productivity of resources.

Confidential - Dallas, TX

Ecommerce Business Analyst

Responsibilities:

• Worked closely with Store Planning teams to re-design Point of Sale (POS) systems to integrate the changes for implementing Omni-channels shopping and Publish weekly POS (Point of Sales) reports internally and call out category trends, opportunities and risks.
• Developed BPMN work flow diagrams to show the process starting with customer login to product delivery; included with information exchange in various stages and Mapped data elements to capture transactions coming from IBM Sterling Order Management Systems and had resolved issues related to requirements during system testing and UAT plan preparation.
• Automation of key reports required on daily basis, performance enhancement and fine tuning of IBM Sterling OMS to ensure a high service is provided to our business users and members.
• Analyzed and compared data present in HIX reports (BizTalk/Windows Service Bus) to Facets by writing SQL Queries. Involved in writing SQL queries to test the mappings and to track the requirements as per the user requirements and Develop SQL reports to demonstrate future state & maintain data quality of source systems.
• Interacted with various stakeholders to collect their user stories; document, manage and ensure real-time tracking of them as project proceeds and Interfaced with Business users to document receiving, binning, customer picking, inventory processing and reporting processes for click & collect orders.
• Worked on e-commerce content gathered in past, performed in depth BI functions to derive useful insights from raw data and Analyze business data, to understand customer behavior and organizational activities of past in customer ordering and fulfillment processes.
• Developed work flow diagrams in Visio from customer order to Point of Sale (POS); identified steps to modify for re-designing the supply chain.
• Assisted with User Acceptance Testing, developed and maintained quality procedures ensuring that appropriate documentation is in place.
• Worked with gathering information from the initial Change Requests, initial user stories, and meeting notes and converting them into a User Story document; updated and created Process flows.
• Worked with the business teams to map existing Order & Contract Management & Order Evaluation systems; re-designed data flow operational flow process to reflect the newly aligned strategic goals.
• Created Business Requirements Document (BRD), Use Case Specifications, Systems Requirements Specification (SRS), Functional Specification and User Stories; also, created ad hoc reports as per the situation needs.
• Coordinated the planning of in store merchandizing and product marketing with the store managers.
• Created a Requirements Traceability Matrix (RTM); Kept a track of product backlog, sprint backlog, and time estimates using Agile tools like Jira.
• Coordinated the activities of Customer Relationship team in altering the contract management as per the business initiatives.

Confidential

Business Analyst

Responsibilities:

• Worked on various standard objects like Accounts, Contacts, Cases, Opportunities, Products, Opportunity Line Items, Leads, Campaigns, Reports and Dashboards.
• Analyzed and documented business processes through workflows and business process modeling (BPM) techniques.
• Gather business requirements from key stakeholder for new Manhattan Associates warehouse management system.
• Worked on the SDLC process, which included requirements, design, analysis and testing via utilizing agile methodology.
• Create business process models, as needed using Business Process Modeling Notation (BPMN), Use case diagrams or other UML-based diagrams.
• Gathered User and Business requirements through interviews, brainstorming sessions and documented.
• Reviewed and gathered requirements from the Subject Matter Experts (SMEs) and Stakeholders using various elicitation techniques and produced Scope Management Documents, Business Requirements Document (BRD), Functional Requirement Document (FRD).
• Performed GAP Analysis on the requirements, identified the gaps using outcome analysis, and documented the GAP Analysis report.
• Prepared business process models; used Visio to create use case diagrams
• Created various documents such as Use Cases, Business Flows and Work Flow diagrams for effective plans.
• Responsible for analyzing project goals, breaking down what needs to be created and attempting to engage users so that definite requirements can be defined.
• Reviewed system requirements and assisted testing team in Test Plan and Test Cases for testing the functionality.
• Wrote SQL statements to extract data from the tables to validate data flow
• Involved in UAT (User Acceptance Testing) in the last phase of the project with Developer, Project Manager and Stakeholders.