SUMMARY

• Around 8 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.
• Experience in e-Commerce platform as BigCommerce, SAP Hybris, Magento, Shopify, Interspire.
• Good experience at B2B, B2C and Ecommerce portals web application developments and CRM.
• Knowledge on Oracle Applications: Inventory, Purchasing, Order Management (OM), Bill of Materials (BOM), Work in Process (WIP), Warehouse management systems (WMS).
• Experienced on WMS systems integration with MHE Warehouse Control Systems (WCS) in a large-scale distribution center environment a plus
• Expert in Supply Chain focusing on process improvements, analyzing and integrating Supply Chain, Marketing, Finance and Sales teams in the project.
• Experienced 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.
• Experienced in ATG Dynamo B2B Commerce, ATG B2C Commerce, Shopping Cart, Product Catalog, Merchandizing, Catalog, Droplets.
• Experience in IT or eBusiness, including experience with e-commerce, eCommerce Payment Transactions, web application development and other eBusiness solutions.
• Experienced using (CRM) for approaching and managing interactions with current and future customers.
• Experienced in customer / client interaction, in-depth knowledge of RAD, SWOT and CRM.
• 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.
• Knowledge in different verticals and areas like Localization, Mobile-Commerce, SCM and CRM.
• Experience in Oracle Retail Modules like RMS, REIM and RPM and also has very good experience in Order Management Application Sterling WMS.
• Experience with Teradata and Snowflake database for data analysis and data validations.
• Experience in developing/supporting enterprise web content management systems/e-commerce applications.
• Experienced with Enterprise Content Management and Data models and Meta data definitions for content management.
• Working knowledge of Warehouse Control and unit sortation/fulfillment systems.
• 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.
• Experience working with Retail Oracle POS application, Payment processing (EMV).
• 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.
• Working experience with FMCG (Fast-moving Consumer Goods) / CPG (Consumer Packaged Goods) clients.
• Expert understanding of Electronic Data Interchange EDI Process, standards, and transactions.
• Experience in Order management systems: Manhattan Associates WMS, IBM Sterling WMS and JDA including OMS integration with other systems.
• Possessed knowledge in B2C and B2B eCommerce and broad knowledge of various commerce platforms - IBM WebSphere Commerce, hybris.
• Expertise in System Analysis Development and Quality Assurance including Functional, Regression, Integration, System and Performance Testing of Client/Server and Web based Application.
• Technology savvy with good skills in SQL and Data Warehousing Concepts and Data Modeling Techniques like Dimensional Data Modeling, Star Schema Modeling and Snow-Flake Modeling.
• Hands-on experience on working with BI and experience in creating interactive dashboards using Tableau, Splunk and IBM Cognos tools.
• 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.

PROFESSIONAL EXPERIENCE

Confidential - Edison, NJ

Senior Business Analyst

Responsibilities:

• Restructured store operations, creating new positions to oversee the growing custom products part of the business.
• 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.
• Customized 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
• 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.
• 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 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.
• Developed and 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
• Generated reports from multiple data sources by blending data on a single worksheet in Tableau Desktop.
• Developed Use Cases, process flows using Rational Rose.
• Manage the product development of a proprietary EDI system enabling the integration of electronic invoicing with billing systems and order fulfillment.
• 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.
• 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 - Springfield, MO

Business Analyst

Responsibilities:

• 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
• Develop 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).
• 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.
• Involved with SMEs in implementing Oracle's self-service OBIEE reporting system. This system allows for real-time data to be accessible at all HR locations throughout the company.
• 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.
• 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 in designing 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.
• 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 - Mahwah, NJ

Business Data 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 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.
• Developed 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.
• Develop 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).
• 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.
• Helped in designing 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.
• Participated in E-Business Suite programs for databases supporting supply chain management, order management, inventory, warehouse management system, purchasing, and iProcurement.
• 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 - Lakeland, FL

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).
• Designed, 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 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
• 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 - Benton Harbor, MI

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.
• Involved in Designing, developing, and maintaining 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.