SUMMARY

• Having over 9+ years Professional Experience as Business Analyst in Retail, E - Commerce and Supply Chain Environments. And understanding of Business Requirement elicitation techniques, Business Requirements Gathering, Power BI, Tableau Reporting, Business Process Flow and Business Process Modelling and Data & Quality Assurance Analysis skills.
• Good experience at B2B, B2C and Ecommerce portals web application developments and CRM.
• Experienced as a Supply Chain Business Analyst in the Ecommerce industry focusing on process improvements, analyzing and integrating Supply Chain, Marketing, Finance and Sales teams in the project.
• Expert in business process engineering and software development life cycle methodologies i.e., Waterfall, RUP, Agile, Scrum, and Prototype., including analysis, design, development, gap analysis testing and implementation of software applications.
• Experience in e-Commerce platform as BigCommerce, Magento, Shopify, Interspire.
• Very Good at ATG Dynamo B2B Commerce, ATG B2C Commerce, Shopping Cart, Product Catalog, Merchandizing, Catalog, Droplets.
• Experienced in Scope Finalization, architecture design, develop and maintain test strategies (Black /White-Box Testing, User Acceptance Testing (UAT)), plans and scripts, delivery of IT solutions to the business on time, within budget and to agreed quality standards for different Business Systems and ERP Systems.
• Good working knowledge in different verticals and areas like Localization, Mobile-Commerce, SCM and CRM.
• Knowledge on Oracle Applications: Inventory, Purchasing, Order Management (OM), Bill of Materials (BOM), Work in Process (WIP), Warehouse management systems (WMS).
• Experience in Oracle Retail Modules like RMS, REIM and RPM and also has very good experience in Order Management Application Sterling WMS.
• Extensive experience on CRM platform and other Java based CPQ (Configure, Price, Quote) application and Contract applications.
• Experienced in Oracle E-Business Suite with an emphasis on O2C including iStore, Order Management, Service Contracts, and Advanced Pricing.
• Outstanding Subject matter expert (SME) with excellent business analysis experience related to ERP (Quote to Cash Q2C, Order to Cash O2C, Global Pricing, Configure Price Quote CPQ), CRM Implementations / Upgrades & Billings (Recurring, Usages, BRM)
• Comprehensive experience in Implementation, Upgrade, Production Support Projects specifically on Procure to Pay and Order to Cash process flows.
• Knowledge on Project systems modules and End to end OTC and P2P business processes. E - commerce integration and Shopify integration with SAP.
• Extensive hands-on experience on working with BI and experience in creating interactive dashboards using Tableau, Splunk and IBM Cognos tools.
• Strong Data Mapping experience using ER diagram, Dimensional/Hierarchical data modeling, Star Schema modeling, Snowflake modeling using tools like Erwin, E/R Studio and Sybase Power Designer.
• Experience with Data modeling (Dimensional & Relational) concepts like Star-Schema Modeling, Snowflake Schema Modeling, Fact and Dimension tables.
• Experience with Teradata and Snowflake database for data analysis and data validations.
• Experience in developing/supporting enterprise web content management systems/e-commerce applications.
• Strong wireframe, content management, mobile and E-commerce experience.
• Good knowledge about Order Management System, Retail POS Applications, Customer Relationship Management (CRM), Ecommerce platforms.
• Experienced in risk analysis, systems analysis and requirements for enterprise integration and POS system enhancements for Oracle XStore, Oracle Locate Order Broker and Retail Interact.
• Knowledge and experience of WMS systems integration with MHE Warehouse Control Systems (WCS) in a large-scale distribution center environment a plus
• Working knowledge of Warehouse Control and unit sortation/fulfillment systems a plus.
• Experience with Master data elements which are associated with Warehouse Management (material master, control cycle, etc.)
• Experience in creating visualizations, interactive dashboards, reports and data stories using Tableau, Power BI and MicroStrategy.
• Experience in Business Intelligence development and testing in various reports using Cognos, Tableau, Power BI.
• Experience in working with different reporting tools like Cognos, OBIEE, Tableau, Business Objects, MicroStrategy.
• Extensive knowledge and experience in Optimizing SCM, Reducing Inventory & Holding cost, Manufacturing Process Improvement, Supporting and enhancing POS (Point of Sale systems).
• Experienced in E - commerce integration and Shopify integration. knowledge on Project systems modules and End to end OTC and P2P business processes.
• Experience working with FMCG (Fast-moving Consumer Goods) / CPG (Consumer Packaged Goods) clients.
• 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).
• Good experience in Order management systems: Manhattan Associates WMS, IBM Sterling WMS and JDA including OMS integration with other systems.
• Reworking the user experience through improving the systems informational architecture and overhauling the application user interface using UX/UI best practices.
• Excellent communication skills, Interpersonal skills, interacting with team members, leadership qualities, mentoring, ability to work independently.

PROFESSIONAL EXPERIENCE

Confidential, Jacksonville, FL

Sr. Business Analyst

Responsibilities:

• As a business analyst in charge of all SDLC activities within the domains of Web Services, Web content management, Document Management, Datawarehouse /Datamart Integration, MDM, and Enterprise Content Management.
• Prepare test data for the application; publish content and assets like images into the application through CMS and ATG BCC systems that help in effective testing of the application.
• Involved in designing the Data Warehousing ETL procedures for extracting the data from all source systems to the target system.
• Created and Customizing data models for Data warehouse supporting data from multiple sources.
• Gathered requirements for the integration of Point of Sales (POS) system with the supply chain system.
• Extensive success in translating business requirements and user expectations into detailed specifications employing Unified Modeling Language (UML) in an SOA environment.
• Worked with the Business Intelligence team to manage and structure data and relational databases (Microsoft SQL Server & Snowflake).
• Interface with relevant stakeholders to resolve/improve WMS issues impacting task completion, response time, process control, and efficiency.
• Worked on the financial area of ERP system, concentration with Supply Chain Management, GL, AP, Manufacturing SSB Project, Purchase and Invoicing.
• AS-IS study to identify the current process and try to fit into the ERP standard package and customize the application if needed based on the business demand.
• Implemented IBMWCS e-commerce platform which supports faster and flexible site performance, more effective merchandising and easier management of multiple web sites.
• Defined requirements for eCommerce platforms powered by WebSphere Commerce Server (WCS).
• Support for a major effort to improve the Warehouse Management System (WMS) capabilities of Supply Chain.
• Created Monthly Project KPIs of Usage Statistics, Identity Compliance and Audit Reports in Interactive Dashboards/Storyboards using Tableau and Power BI.
• Curate dashboards and reports using SQL, Power BI, Tableau, and Excel summarizing key performance indicators.
• Led & implemented complete Order to cash (O2C) process end to end process within Supply chain
• Responsible for gathering requirements, configure, develop, Implement, Test & Support R12 as per expected standards for Order to Cash (O2C)
• Capture as-is and future state processes in Order to Cash, and participating in functional design workshops.
• Defined requirements for WebSphere Commerce Server. Assessed the servers, storage and infrastructure sizing.
• Interacted with stakeholders to finalize the Business Requirements Document (BRD) in terms of Content, Pricing and Store / WAP Page Structuring.
• Troubleshooting Order XML data issues with Enabler Pricing and Product Catalogue.
• Involved in CPQ (Configure, Price& Quote) design and mapped to the custom objects and involved in Apttus Advanced Workflow Approvals
• Worked on enterprise-based WMS systems such as Manhattan Associates and custom WMS.
• Gather Data requirements from Manhattan associates and prepare the Mapping Schema with XML tags and the required values.
• Involved in creating different reports based on the business request and ad hoc requirements using Tableau, Power BI desktop. Prepare financial deliverables (quarterly, accrual and budgetary reports) for funding agencies; as well as proof of concept, and solution mockups.
• Used Power BI power query to extract data from external sources and modify data to certain format as required for consumption in the dashboards.
• Deployed SSRS reports and published Power BI dashboards to share them with the appropriate users. Created multiple roles, with appropriate privileges for different users.
• Creation of multiple highly interactive Power BI and SSRS reports for supervisors and managers, which enables them to see the current status of the work, shift allocation for the next day at location, district and borough level.
• Worked on Implementation of Warehouse Management System (Manhattan WMOS) for ASCENA's e-commerce warehouses as Product Owner.
• Involved in the process of automating POS system using involving monthly import of POS excel files into a database using SSIS packages. And Created templates for power users to create their own SSRS reports.
• Involved in the creation in an intranet to load data into Shopify.
• Worked with the team in the migration from HTML E-commerce platform with Visual Retail Plus POS to Shopify.
• Assisted Project Management, Consulting and Development Services in Digital Commerce, SWIFT Alliance Access (SAA), Mobile Payments, Payment Gateways, Point of Sale Commerce.
• Distributed Point of Sales (POS), Sales, and Commission reports to Sales Management Teams.
• In the process of learning Java script and creating a third-party app to access Shopify website through API.
• Extensive knowledge and experience in Optimizing SCM, Reducing Inventory & Holding cost, Manufacturing Process Improvement, Supporting and enhancing POS (Point of Sale systems).
• Involved in the Re-architecture of an in-house developed retail point of sale application to support pin and chip (EMV) payments for the omni channel retail operations.
• Performed numerous Ad-hoc involving SQL scripts, UNIX, and Teradata.
• Supported User-Acceptance phases by performing data validations and metrics calculation across every layer including source systems, Staging, Mart and MicroStrategy layer.
• Modified existing tableau reports that are in place and collaborate with business to integrate new data points to streamline workflow and company processes
• Gave permissions to specified Business users to access the Report using Tableau server
• Created Use Cases, process flows using Rational Rose.
• Responsible for all website Content Development, Digital Content Editing, Page Design, Content Updates, and System Administration.
• Apply Supply chain Management (SCM) methodologies to ensure coordination in the supply chain.
• Participated in UAT and worked with HP Quality Center for bug and defect tracking.
• Created specifications for data cleansing and conversion programs, EDI sales data loading processes and procedures, mapping of client/territory alignments and hierarchies.
• Documented Test Plans and Test Cases using Rational Test Manager
• Used SQL Queries to validate and manipulate the data in Oracle database.
• Interacted with developers and various members of my team to discuss and resolve defects and their priorities
• Assisted in JAD sessions to gather information about user experience for developing the User Interface and Reporting.
• Extensively followed Rational Unified Process (RUP) for application development.
• Created and authored Use Case Diagrams and Activity Diagrams using MS Visio.
• Coordinated the User Acceptance testing with the end use.

Environment: Windows 10/8, Business Objects, MS Project, MS PowerPoint, MS Visio, Office 365 Suite, SharePoint 2016/2013, UAT, Oracle POS, SQL Server, Teradata, Unix, ETL, MicroStrategy, UML, XML, SharePoint.

Confidential, Framingham, MA

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.
• Involved in designing Data Mart and Data Warehouse using Star and Snowflake Schemas.
• 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
• Created and maintain sales reporting using in MS Excel queries, SQL in Teradata, and MS Access. Produce performance reports and implement changes for improved reporting.
• Experienced in testing product qualification testing in Point of Sale (POS) application.
• Translated and redefined the company Order to Cash O2C process flow in NetSuite.
• Worked on Order to cash (O2C) process end to end process within Supply chain from non-standard Quotes & Orders - Order creation, booking, picking, fulfillment, shipment & revenue recognition
• Participate in tech As - is and To-be, Gap Fit Analysis, Requirements gathering and defining Functional Specifications for FRICE in Order to Cash area.
• Participated in Creating Master data and map them into various modules of the ERP application
• Help in Preparing Project Scope of the business to fit into the ERP product.
• Created BRD (Business Required Document) for the POS implementation project and Managed changes to the POS system.
• Collaborated with the team for E-Commerce POS testing Product Search, Payment System, Online transaction processing
• Performed GAP Analysis of business rules, business and system process flows, user administration, and requirements. Ensured POS PCI compliance requirements were met.
• Worked with the business team to implement existing business process from Legacy to WCS Ecommerce platform.
• Gather requirements for catalog browsing and inventory; availability for WebSphere Commerce WCS store and transition of requirements to Functional specification.
• Utilized expertise in Content Management Systems and coding to customize Confluence Collaboration server via plugin architecture using available language APIs.
• Performed Business data gathering and report generation using Tableau.
• Created Reports and Charts using Data visualization tools like Tableau and Power BI
• Worked extensively with MS Excel and SQL server, MySQL, tableau Desktop, Tableau Server
• Created several Data models and Reports, List of values and parameters, integrated it with OBIEE dashboards.
• Do the Analysis to manage the Common Business Object (CBO) changes by the Manhattan team and process them through 'Change Control Management'
• Consulted other IT-teams with applications that work on top of the base Manhattan WMS system.
• Worked on Manhattan WMS implementation to support Ecommerce Growth with automation, process optimization and integration with new WCS system.
• Worked on Optimizing SCM, Reducing Inventory & Holding cost, Manufacturing Process Improvement, Supporting and enhancing POS (Point of Sale systems).
• Strong understanding of Data mining techniques with knowledge in end-to-end data reconciliation, SQL, PL\SQL, Oracle\ETL environments (tools like Toad\Informatica).
• 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.
• 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.
• Worked on E-Business Suite programs for databases supporting supply chain management, order management, inventory, warehouse management system, purchasing, and iProcurement.
• 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 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.
• Created and managed project templates, use case templates, requirement types and tractability matrix in Requisite Pro.

Environment: SQL Server, Business Object, Informatica, Crystal Reports, Cognos, AS400, SharePoint 2010/2013, UNIX, HTML, PL/SQL, Interwoven, Omniture, MS Visio, MS Power Point, MS Project, Rational Rose, Rational Clear Quest, Rational ClearCase, Rational requisite pro.

Confidential, Doosan, ND

Business Analyst

Responsibilities:

• 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.
• Worked implementing API in extracting large volume of legacy data in Order to Cash cycle (O2C).
• Created Architecting reports, interfaces, customizations, and extensions for Oracle EBS applications and Oracle Retail (Retek) for all Order to Cash processes.
• Implemented enhancements like Back-to-Back Ordering, Internal orders, ATP, drop shipment, work order less completions, Order to cash flows.
• Worked on a Functional aspects for Supply chain Management module to implement ERP application
• Interacted with the business users in knowing the business views and gathered the reporting requirements to design the universes and business objects.
• Involved in data validation on large datasets to improve the data quality using SQL in Snowflake warehouse.
• Configured, implemented and used functionality of Manhattan WMS, Develop reports of employee activities and view workload across functional areas.
• Involved in developing test scripts specific to Manhattan EOM.
• Prepared Unit and Integration Test Plans for the Data Delivery to Customers Module, Release content management systems sub module and helped reduce cycle time.
• Provided assistance on giving access permissions for the viewer and editor using Tableau server and Scheduling auto data updates for dashboards using Tableau server.
• Generated Tableau reports and effectively used data blending feature in the tableau desktop and Generated Interactive Dashboards with Quick filters, Parameters, and Actions to handle views more efficiently.
• Technology savvy with strong skills in SQL and Data Warehousing Concepts and Data Modelling Techniques like Dimensional Data Modelling, Star Schema Modelling and Snow-Flake Modelling.
• Involved in creating different reports based on the business request and ad hoc requirements using Tableau, Power BI desktop. Prepare financial deliverables (quarterly, accrual and budgetary reports) for funding agencies; as well as proof of concept, and solution mockups.
• Responsible for entire roll out and user training for content management contribution for each program.
• Focus on partnering with the global Manufacturing and Procurement functions while also responsible for supporting the delivery of business objectives for Logistics, Supply Chain Planning.
• Created and maintain sales reporting using in MS Excel queries, SQL in Teradata, and MS Access. Produce performance reports and implement changes for improved reporting.
• 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).
• Strong understanding of Data mining techniques with knowledge in end-to-end data reconciliation, SQL, PL\SQL, Oracle\ETL environments (tools like Toad\Informatica).
• 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.
• Help designed process which pulls ADHOC files from SharePoint using HTTP transformation and load it to UNIX server in the form of flat-file in Informatica Power Center.
• Interacted with business SMEs, enterprise architects, developers, business intelligence, and data warehouse teams regarding project requirements explanation and interpretation.
• Helped design data warehouse solutions and business intelligence dashboards and scorecards.
• 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 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.
• Created and managed project templates, use case templates, requirement types and tractability matrix in Requisite Pro.

Environment: SQL Server, Business Object, Informatica, Crystal Reports, AS400, UNIX, Oracle, PL/SQL, Clarity, Omniture, MS Visio, MS Power Point, MS Project, Rational Clear Quest, Rational ClearCase.

Confidential, Reading, MA

Business Analyst

Responsibilities:

• Function as the main conduit between the IT development group and the operation’s business managers and users to help prioritize requirements and optimize resources
• Compose Business Requirements Documents and Business Functional Specification Documents routinely as new requirements are presented.
• 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).
• Trained and implemented an automatically distributed supplier forecast.
• Enables buyers, managers and suppliers to quickly access the continually changing requirements
• Using Tableau Server, granted access permissions for the workbooks and Scheduled data updates for the Tableau Dashboards
• Attained experience in dashboard design in Tableau 9 based on SQL Server and Excel data.
• 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 is the best course of action
• Routinely participate in GAP analysis efforts and new software assessments
• Work with Operation's management team to prioritize issues and identify future improvement opportunities.
• Periodically engage business users to identify pain points and other opportunities for enhancements
• 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
• Conduct training classes for a broader audience such as non-inventory requisition training as well as very specific training classes directed at buyers, planners or manufacturing engineers
• Help business on Organizational structure design by providing mapping between business and Oracle EBS.

Environment: Rational Rose, Rational Req Pro, RUP, Oracle EBS, Business Objects, AS400, MS Word, MS Excel, MS Access, MS Project, MS PowerPoint, MS Visio, SQL Server.

Confidential, Framingham, MA

Business Analyst

Responsibilities:

• 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 Gap analysis and implemented updates for the Data Warehousing Application.
• Modeling the As-Is system and doing the complete Gap Analysis for the existing system in order to map it to the To-Be system.
• Conducted JAD sessions for communicating with Stakeholders and Project directors.
• Created business process workflow diagrams (Activity diagrams) in Rational Rose.
• Created and maintained various Business unit reports by using Teradata, 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 Gap 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.
• Assured that all Artifacts are in compliance with corporate SDLC Policies and guidelines.
• Coordinated and prioritized outstanding defects and enhancement/system requests based on business requirements, allowing sufficient time frame to ensure accuracy and consider deadlines
• Monitored client expectations and conducted user interviews.

Environment: RUP, UAT, GAD (Gap Analysis Document), MS Visio, MicroStrategy, SQL Server.