PROFESSIONAL EXPERIENCE:

• Experienced Business Analyst with around 10 years of proven skills in requirement gathering, interacting with developers, documenting various business process evaluating Data Sources, Translating Requirements into Specifications, Application Design in Retail, E - commerce and Logistics.
• Excellent knowledge in Software Development Life Cycle (SDLC) / Rational Unified Process (RUP) methodologies, Agile Methodology.
• Proficient in using UML for Business Process Modelling, Use Cases, Activity Diagrams, Sequence Diagrams, Data Flow Diagrams, Collaboration Diagrams, Class Diagrams, Wireframe, Prototypes and documenting them using Microsoft Visio.
• Expert at ATG Dynamo B2B Commerce, ATG B2C Commerce, Shopping Cart, Product Catalog, Merchandizing, Catalog, Droplets.
• Extensive experience in the Retail and e-commerce environments with knowledge of Microsoft commerce ATG suite and Websphere.
• Expert level working knowledge in different verticals and areas like Localization, Mobile-Commerce, SCM and CRM.
• Experienced in Oracle E-Business Suite with an emphasis on O2C including iStore, Order Management, Service Contracts, and Advanced Pricing.
• Working knowledge in the ETL (Extract, Transform and Load) of data into a data ware house/date mart and Business Intelligence (BI) tools like Business Objects Modules (Reporter, Supervisor, Designer, and Web Intelligence).
• Good experience at Master Data Management (MDM), Identity data and Point of Sales (POS).
• Experienced in Activity Modeling Phase in Data Warehousing Design.
• 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.
• Experienced to use analytical tools (Google analytics, Adobe analytics & Core metrics) for reporting of ecommerce conversions, engaged visitors, readers, calls of actions, bounce rate, social engagement tracking and email tracking.
• Knowledge of Enterprise Dimensional Model and Relational Models; EDM & EDW.
• Expert in Test driven development & Unit testing methodologies for performing UAT, System Integration testing (SIT), and Business Acceptance Testing (BAT).
• Experience capturing requirements for web development specifically in eCommerce Payment Transactions.
• Experience in database modeling and development of Entity Relationship Diagrams (ERD)
• Experience in Requirement Traceability Matrix (RTM), Data Migration, Periodic Review, GAP Analysis, Risk analysis, CAPAs and Remediation Process.
• Experience in Data mapping, logical data modeling, class diagrams and ER diagrams and used SQL queries to filter data.
• Hands-on experience in using test management, Regression Testing and defect tracking tools such as Jira, Bugzilla, Mingle, HP Quality Center and Confluence.
• Experience in Participating with QA team in different phases of testing such as System testing, Functional testing, Regression testing and Integration testing for Quality Analysis.
• Excellent skills in Business Analysis, Data Analysis, Requirement Analysis, and Business Modeling.
• Experience in database queries of the application database to provide data for business decisions, resolution of issues and validation of solutions.
• Experience in various programming languages (SQL, XML) and operating hardware and software applications including TOAD, Crystal Reports, Oracle Discoverer, Query Analyzer and SQL Navigator.
• Expert in creating clear and concise reporting on requested business metrics using Microsoft Power BI, SQL Server Management Studio (SSMS), SQL Server Reporting Services (SSRS), Microsoft Access, Microsoft Excel, Crystal Reports, Tableau and other reporting tools.
• Experience in creating and maintaining artifacts associated to Agile user features/ stories, use cases, functionality issues, data dictionaries, data mapping and test cases using Visio, JIRA, Confluence.
• Experienced with Rational tools like ReqPro, Clearquest, ClearCase, Rational soda, Rational Rose.

PROFESSIONAL EXPERIENCE:

Confidential, Westborough, MA

Sr. Business Analyst

Responsibilities:

• Worked on conducting requirement gathering meetings with the business to collect functional/non-functional requirements relating to client's technology enhancement and initiatives.
• The Supply Chain scope includes the entire supply chain from production order to shipping & delivery and order management.
• Worked on development of High-level design, Conceptual design, Logical and Physical design for Database, Data warehousing and many Distributed IT systems
• Restructured store operations, creating new positions to oversee the growing custom products part of the business.
• Assisted in JAD sessions to gather information about user experience for developing the User Interface and Reporting.
• Assisted with introductory stage planning/development of managed CRM solutions for Field Marketing Organizations (FMO) on Microsoft Dynamics CRM.
• Gathered requirements for the integration of Point of Sales (POS) system with the supply chain system.
• Translated business requirements and user expectations into detailed specifications employing Unified Modeling Language (UML) in an SOA environment.
• Assisted in testing the newly redesigned Oracle POS system.
• Participated in all the phases of Rational Unified Process with specific focus as it pertains to the software testing and used the guidelines, templates and Rational tools in all the phases.
• Interacted with business with Business owners & end users for Business functions. Analyzed business requirements and detail design of the software.
• Create Salesforce reports and dashboards for KPIs, trending, forecasting, account plans, SPIFFs, business reviews, customer growth initiatives and ad-hoc analysis.
• Worked with key members from various cross-functional teams to analyze various third-party CRM solutions to make a ‘buy vs. build’ decision. Conducted cost/benefit and impact analysis.
• Established UX design as the first stage of all Web and mobile application developments, instituting a user-centered design (UCD) approach.
• 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.
• Designed and Administered Teradata Scripts, Tables, Indices and Database Objects.
• Extensive knowledge of RUP methodology and its implementation through the entire software development lifecycle in all four phases of a project: Inception, Elaboration, Construction and Transition
• Working knowledge of Software Development Life Cycle (SDLC), having thorough understanding of various phases like Requirements, Analysis/Design, Development and Testing.
• Developed a consolidated and prioritized high level requirements matrix for both B2C and B2B that detailed current and future state needs, along with a gap analysis against Salesforce Commerce Cloud (Demand ware) and SAP Hybris capabilities.
• Manage the product development of a proprietary EDI system enabling the integration of electronic invoicing with billing systems and order fulfillment.
• 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.
• Tracked bugs and reported issues and defects using JIRA.
• Created specifications for data cleansing and conversion programs, EDI sales data loading processes and procedures, mapping of client/territory alignments and hierarchies.
• Used Rational RequisitePro for managing the requirements
• Tested the web application components of Content Merchandising System, Oracle RMS (v9, v10), Web Sphere commerce functionality on various web browsers as part of UI testing.
• Used SQL Queries to validate and manipulate the data in Oracle database.
• Tested Reports functionality and result applying Business rules with estimated Results, which were developed on the GUI.
• Involved with the team on Business Intelligence reports development efforts by working closely with Microstrategy, Teradata, and ETL teams.
• Designed the Data Warehousing ETL procedures for extracting the data from all source systems to the target system
• Designing and customizing data models for Data warehouse supporting data from multiple sources.
• Worked on data warehouse solutions and business intelligence dashboards and scorecards.
• Prepared 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
• Wrote Test Strategy and Test Plans for POS implementation to map out the testing strategies and timeline.
• Used Rally and TFS for updating the status of all the Test Cases & Test Scripts that are executed during testing process.
• Assisting with introductory stage planning/development of managed CRM solutions for Field Marketing Organizations (FMO) on Microsoft Dynamics CRM.
• Interacted with developers and various members of my team to discuss and resolve defects and their priorities
• Created and authored Use Case Diagrams and Activity Diagrams using MS Visio.
• Coordinated the User Acceptance testing with the end use.

Confidential - City of Industry, CA

Business Analyst

Responsibilities:

• Responsible for gathering business requirements, contribute functional design prototypes and write functional specifications, document workflow and process diagrams and use cases.
• Worked with cross-functional team to identify and track multi-channel/cross-media (banner ads, email, paid search, micro-site, etc.) metrics during consumer and commercial marketing campaigns and benchmark campaign performance.
• Analyzed click stream data using tools like Omniture Site Catalyst to create reports on site navigation (i.e. path analysis, entry & exit analysis, keyword analysis etc.) and gauge visitor/customer behavior.
• Interfaced and integrated middleware APIs with Front end clients like Quik View, Retail .Net platform, Magenta UI and back end systems like Identity Access Management, Customer Hub, Documentum, etc.,
• Played a key role in the automated order flow for B2B Customers involving different B2B Customer Ordering portals, middleware and several backend systems.
• Developed a consolidated and prioritized high level requirements matrix for both B2C and B2B that detailed current and future state needs, along with a gap analysis against Demand ware and SAP Hybris capabilities.
• Used IBM Websphere for Mobile application in giving seamless shopping experience to guest in selecting products, shopping cart, check out, bill payments modes.
• Analysed the PCI DSS to create an additional level of protection for card issuers by ensuring that merchants meet minimum levels of security when they store, process and transmit cardholder data.
• Analysed and prioritized Business Process and User Interface (UI) requirements as system requirements that must be included while developing the Application. Created automation profile of the process using TSYS.
• Collaborated with on-shore and off-shore development team and business users to create and implement EPIC/User stories for desktop/mobile application features like Buy Online, Product Comparison and Product Bundle, Guest Check out and Persistence Shopping cart.
• Worked on Websphere Application server (WAS) to test and validate the functionality of new version against the applications.
• Wrote use cases, user stories, technical specifications, process flows and wire frames for new processing functionality.
• Migrated data between different heterogeneous sources such as flat file, Excel and SQL Server 2005 using SSIS and Bulk Insert.
• Assisted in information architecture and content migration from legacy CMS to AEM
• Worked closely with business users to understand content reporting needs and translated in terms of current AEM configuration
• Facilitated requirement gathering sessions, helped business to understand what can be accomplished quickly out of the box on AEM when compared to customizations.
• Extensive experience with migrating from AEM Classic to touch interface
• Write technical and user documentation, create test environment to conduct system, regression and end-to-end tests for new or modified programs.
• Translated business concepts into XML vocabularies by designing XML Schemas with UML
• Involved in Data Mapping.
• Wrote PL/SQL statement and stored procedures in Oracle for extracting as well as writing data.
• Support reports built with Microsoft Reporting Services (SSRS) on SQL 2005.
• This tool has helped to increase engagement level of customers and thereby performance of newsletters. Subsequently I also wrote a whitepaper on the same.
• Involved in mentoring specific projects in application of the new SDLC based on the Agile Unified Process, especially from the project management, requirements and architecture perspectives.
• Used Informatica Designer to import, create and edit the metadata.
• Developed business performance metrics and KPI’s and created monthly performance dashboards for websites.
• Reported and assessed all application defects, user issues and resolution status to the higher manager using JIRA Bug Tracking software.
• Maintain and monitor data warehouse to ensure its proper operation, performance and availability.

Confidential - Dallas, TX

Business Analyst

Responsibilities:

• Interacted with the business users in knowing the business views and gathered the reporting requirements to design the universes and business objects.
• Scheduled and maintained web analytics source data and provided UI reports using Omniture Site Catalyst.
• 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.
• As part of CRM Activities, gathered client data, managed, tracked and analyzed this 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.
• Comprehensive platform assessments and gap analysis done for potential clients using Hybris, IBM Commerce, Oracle ATG and Demandware.
• 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 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.
• Planned and defined Use Cases created Use Case diagrams, Scenarios and Use Case Narratives using the UML methodologies.
• Participate in Development Solution in regards to Interwoven Teamsite related design and implementation concepts.
• Analysed 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.
• Improved efficiency through better management of date integration and transfer between transmission control systems and AS/400 mainframe.
• Requirements and designed the solution by customizing various standard objects of Salesforce.com (SFDC).
• Interacted with business SMEs, enterprise architects, developers, business intelligence, and data warehouse teams regarding project requirements explanation and interpretation.
• 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.
• Worked with information architects and creative groups in detailing the wireframes and depicting GUI design.
• Coordinate testing efforts across multiple JDA supply chain and retail applications including allocations and replenishment.
• Used MS Sharepoint for the purpose of managing documents and for hosting websites which was used to access shared work spaces and 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
• 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 - Grand Rapids, MI

Business Analyst

Responsibilities:

• Gather requirements by conducting meetings and brainstorming sessions with end users and SME and document them using Requisite Pro - the documentation tool offered by Rational.
• Provided recommendation for use of ATG Commerce for B2B and B2C business.
• Data mapping, logical data modeling, created class diagrams and ER diagrams and used SQL queries to filter data within the Oracle database.
• Developed E-Business Suite programs for databases supporting supply chain management (SCM), order management, inventory, warehouse management system, purchasing, and iProcurement.
• Implementation, enhancement and support solutions to meet client's needs using Demandware ecommerce platform.
• Gathered requirements and modeled the data warehouse and the underlying transactional database. Worked with ETL team during the upload process.
• Prepared and maintain Business Rules Spreadsheets (BRS) identifying Rules, Triggers and corresponding data fields from Legacy to target CRM application.
• Created different Experienced in User experience (UX) definition and User Interface (UI) design for project as well as mockups, prototypes and wire frames.
• Duties included maintenance of existing and development of new Unix Korn and C shell scripts for sales/marketing EDI data extraction and uploading to Excel spreadsheets and MS Project files.
• Reviewed Stored Procedures for reports and wrote test queries against the source system (SQL Server) to match the results with the actual report against the Data mart (Oracle).
• Followed by reverse engineering to document UI and Functionality.
• Created Test Scripts & Test Scenarios to check report content, layout, and parameters.
• Perform Gap Analysis of the processes to identify and validate requirements.
• Identified/documented data sources and transformation rules required populating and maintaining data warehouse content.
• Organize requirements into high level Use Cases and low level Use Case Specifications and modeled them into UC, Activity and Sequence Diagrams using Rational Rose and MS Visio.
• Created and maintained user stories in JIRA for better understanding of the requirements for the development team. Also use JIRA for bug tracking.
• Validated the test data in DB2 tables on Mainframes and on Teradata using SQL queries.
• Apply UML notations and methodology in developing models that accurately represent the business process and workflows and clearly communicate them to the stakeholders.
• Involved in JAD sessions which includes the management, development and user teams for clarifying requirements and facilitating better communication.
• Used Agile/SCRUM requirements management tool Rally for managing story cards, efforts, and preparing burn-down charts and velocity charts.
• Coordinated, prioritized outstanding defects and enhancement/system requests based on business requirements, allowing sufficient timeframe to ensure accuracy & consider deadlines.
• Review the Test Plan developed by the testing team for testing the application.
• Deep understanding of all the phases of Software Development Life Cycle (SDLC) methodologies throughout the project life cycle.
• Involved in performing version control and defect tracking activities using Rational ClearCase and Rational ClearQuest.

Confidential - Philadelphia, PA

Business Analyst

Responsibilities:

• Interacted with business heads to finalize the Business Requirements for the application.
• Performed the requirement analysis and documented the requirements using Rational Requisite Pro.
• Managed changes to the POS system
• Used the requirement attributes (priority, effort, and risk) as the basis for negotiating the inclusion of the requirement, to manage the scope of the system efficiently.
• Developed UML Use Cases using Rational Rose and developed a detailed project plan with emphasis on deliverables.
• Successfully conducted JAD sessions, which helped synchronize the different stakeholders on their objectives and helped the developers to have a clear-cut picture of the project.
• Understand the As Is system and develop the To Be system concept and also prepare the System Process Maps.
• Managed changing requirements which included establishing a baseline, keeping track of the history, determining dependencies that are important to trace, tracing relationship between related requirements and maintaining version control.
• Prepared and documented System Requirements and workflows for the Content Management Application tool.
• Involved in implementation/improvement of SAP, JD Edwards, Epicor Retail System &Demand Ware eCom System
• Checked Business Readiness and determined activities of flow.
• Performed Unit Testing and User Acceptance Testing and documented detailed defects.
• Wrote Procedure Manuals and was responsible for continuity preparedness.
• Managed various tests, stored test information, reviewed and analyzed test results.
• Conducted presentations of the Q/A test results with analysis to the stakeholders and users and documented modifications and requirements.
• Involved in testing the POS system
• Helped in writing Training manuals and helped business with the Training on a one to one sessions.
• Employed Rational Clear Quest for effective Change Management (Requirements Creep) and bug tracking during the testing lifecycle.