SUMMARY

• Working as a Sr. Business Analyst wif over 9 Years of Professional Experience in Retail, E - Commerce and Supply Chain Environments.
• Good experience at B2B, B2C and Ecommerce portals web application developments and CRM.
• Proficient in Oracle Applications: Inventory, Purchasing, Order Management (OM), Bill of Materials (BOM), Work in Process (WIP), Warehouse management systems (WMS).
• Experience in Merchandising (Retail), Demand Planning, Space Planning User requirement specifications and converting them into system requirements, preparing Requirement Analysis, Functional Specifications, design document and Software Requirements Specifications.
• Extensive experience working wif FMCG (Fast-moving Consumer Goods) / CPG (Consumer Packaged Goods) clients.
• Proficient in Quality assurance, Quality Control, Risk Management, Feasibility studies and cost-benefit analysis.
• 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.
• Experienced wif multiple WMS systems and IT technologies related to WMS systems in a high-volume retail warehouse.
• Good at ATG Dynamo B2B Commerce, ATG B2C Commerce, Shopping Cart, Product Catalog, Merchandizing, Catalog, and Droplets. Also experienced in testing product qualification testing in point of sales (POS) application.
• Expert in Shipping Point Determination, Route Determination, Transport and Delivery Scheduling, Backward Delivery Scheduling, Partial and Complete Delivery, Subsequent Outbound Delivery Split and Grouping of Deliveries.
• In-depth noledge of Use Case Modeling Language, modeling tools: IBM rational rose and Microsoft Visio.
• Deep noledge of the procure-to-pay cycle, order-to-cash and key implementation issues in Oracle Sourcing.
• Expert level working noledge 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.
• Expert in 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).
• Experience in Salesforce standard objects like Accounts, Contacts, Leads, Campaigns, Reports and Opportunities.
• Experienced in Activity Modeling Phase in Data Warehousing Design and Creation of Teradata Tables and Databases and choosing Indexes in Teradata.
• Strong noledge on Reworking the user experience through improving the systems informational architecture and overhauling the application user interface usingUX/UIbest practices.
• Comprehensive noledge of the procure-to-pay cycle and key implementation issues in Oracle Sourcing, Order Management Requisitions, iProcurement, and Purchase Orders systems.
• Experience working wif Retail Oracle POS application, Payment processing (EMV).
• Expertise wif Supply Chain Management (SCM), supply chain strategies/vendor manufacturing process methods to determine level of procurement and strategic sourcing strategies/plans and worked wif vendors/peers to determine lead times, schedules and cycle counts, established requirements needs.
• Extensive experience in Gathering Requirements, Scoping Requirement and creating Business Requirement Documents, User Requirement Specifications, Functional Requirement Specifications, System Requirement Specification, Test Plan, analyzing and Creating Use Cases, Use Case Diagrams, Activity diagrams, System Workflow Diagrams, Data Flow Diagrams, Business Flow Diagrams.
• Extensive experience in SAP Customer Order Management; OTC implementation projects (quotation, inquiry, orders, special orders, contracts, scheduling agreements, deliveries, shipments, transportation and billing document).
• Experienced in New Relic insights and Microsoft Dynamics 365 to provide relevant insights for customer analytics.
• Expertise in documenting project plan, Business Requirements Document (BRD), Test Plans, Use Case Specifications, Functional Specifications (FSD) and Systems Requirements Specification (SRS).
• Comprehensive noledge on Transportation Planning Point, Shipping Type, Route, Shipment Type, Procedure Group, Item Category Shipment Cost, Item Determination Procedure Group, Pricing Procedure for Shipment Cost.
• Experience in Lightning Components and Salesforce Lightning Design System (SLDS) wif Salesforce Marketing cloud.
• Excellent communication skills, Interpersonal skills, interacting wif team members, leadership qualities, mentoring, ability to work independently.
• Strong understanding of Data mining techniques wif noledge in end-to-end data reconciliation, SQL, PL\SQL, Oracle\ETL environments (tools like Toad\Informatica).
• Experience in all modules of Oracle CPQ Platform including its integration capabilities wif CRM and ERP applications.
• Technical Knowledge about Salesforce lightning schema builder, process builder, app builder, components and lightning connect.
• Strong noledge database and data manipulation skills using SQL.
• Involved wif multiple project teams of technical professionals through all phases of the SDLC using technologies including Oracle, Erwin, DataStage, Data Warehousing, WebSphere and Cognos.
• Experienced in facilitating Joint Application developments (JAD) and Joint Requirement planning sessions (JRP), End user interviews, workshops and requirement elicitation sessions, providing production support, interacting wif the business customer to resolve issues during UAT, conducting training sessions to educate the business customer on the application.

PROFESSIONAL EXPERIENCE

Confidential, Katy, TX

Senior Business Analyst

Responsibilities:

• Worked on restructuring store operations, creating new positions to oversee the growing custom products part of the business.
• Worked along wif the technology team on creating first commissioned sales program in the company. This program enabled store managers to attract a higher caliber of associate, increased productivity, greatly increased overall sales, improved customer satisfaction and increased profit margins due to reduction of errors on the part of sales associates.
• Worked on various Salesforce.com standard objects like Accounts, Contacts, Opportunities, Products, Quote, Activities, Reports and Dashboards.
• Prepared test data for the application; publish content and assets like images into the application through CMS and ATG BCC systems dat help in effective testing of the application.
• Worked extensively on supporting WMS users in their daily business solutions including system training and production issue troubleshooting.
• Designed the Data Warehousing ETL procedures for extracting the data from all source systems to the target system.
• Gathered requirements for the integration of Point of Sales (POS) system wif the supply chain system.
• Supported for a major effort to improve the Warehouse Management System (WMS) capabilities of Supply Chain.
• Wrote Test Strategy and Test Plans for POS implementation to map out the testing strategies and timeline.
• Participated in all the phases of Rational Unified Process wif specific focus as it pertains to the software testing and used the guidelines, templates and Rational tools in all the phases.
• Involved in Oracle CPQ implementation, customization and support for resolving various integration issues.
• Integrated wif Business owners & end users for Business functions.
• Worked on defining transportation zones, transportation planning points and document settings.
• Worked wif 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.
• Reviewed, analyzed, monitored and improved the current Office 365 SharePoint environment.
• Involved in the establishment ofUXdesign as the first stage of all Web and mobile application developments, instituting a user-centered design (UCD) approach.
• Scheduled internal demos to showcase SharePoint & O365 features and changes.
• Reviewed and validated the Output file sent by Manhattan WMS for Data Conversion elements.
• Identified processes involved in different phases of the procure-to-pay life cycle to include preparation of Use Cases, Test Scripts and Business Process improvement.
• 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 Micro strategy layer.
• Focused on partnering wif the global Manufacturing and Procurement functions while also responsible for supporting the delivery of business objectives for Logistics, Supply Chain Planning.
• Involved in developing procure to pay processes and analytics in support of sourcing, spend analysis and operational excellence initiatives.
• Identified areas of improvement in transportation, warehousing and 3rd party logistics processes and procedures.
• Documented and shared the requirements wif other Salesforce.com consultants for further implementation.
• Worked in SQL Server and Salesforce database structure. Developed Use Cases, process flows using Rational Rose.
• Involved actively in managing the product development of a proprietary EDI system enabling the integration of electronic invoicing wif billing systems and order fulfillment.
• Analyzed the current Supply Chain Management from receiving an order in OMS (Order Management System), WMOS (Warehouse Management Open System) and complete processing till final delivery to customer and suggest best remedial methods. Also Used Rational Requisite Pro for managing the requirements.
• Actively worked on Supply chain Management (SCM) methodologies to ensure coordination in the supply chain.
• Participated in UAT and worked wif HP Quality Center for bug and defect tracking.
• Involved extensively in the integration of Requisite Pro wif Clear Quest and Rose to provide all teams visibility and maintain tractability among requirements, use cases and change requests.
• Used MS Visio for Process modeling, Process mapping and Business Process flow diagrams.
• Collaborated wif the IT team on implementing Salesforce Sales cloud, Marketing cloud and Service cloud.
• Created specifications for data cleansing and conversion programs, EDI sales data loading processes and procedures, mapping of client/territory alignments and hierarchies.
• Involved in project scope meetings wif the Pricing manager to understand the type of requests and issues handled by the pricing team and documented the high-level business requirements to the product backlog using JIRA.
• Worked in Agile environment, created user stories in JIRA Application and supported Product Owners in gathering requirements while keeping CPQ Project capabilities in mind.
• Documented Test Plans and Test Cases using Rational Test Manager.
• Worked wif all aspects of ERP system, this includes sales, purchase orders, accounts payables, accounts receivable, quality control, shipping and receiving.
• 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.
• Involved in developing, maintaining and supporting process improvements for the Corporate ERP systems including MS Dynamics CRM and integrated systems.
• Used SQL Queries to validate and manipulate the data in Oracle database.
• Actively involved in the development of E-Business Suite programs for databases supporting supply chain management, order management, inventory, warehouse management system, purchasing, and iProcurement.
• Assisted wif introductory stage planning/development of managed CRM solutions for Field Marketing Organizations (FMO) on Microsoft Dynamics CRM.
• Worked along wif the IT Team on designing and implementing Oracle CPQ Cloud.
• Responsible for supervising the planning, coordination, and delivery of functional and technical components of solutions using Salesforce, Business Planning and Consolidation and other Cloud based data tools, including documenting complex data systems and business process flows.
• Used MicroStrategy dashboards for data analysis and custom reports.
• Actively involved in the design and development of new functionality and forms wifin ERP System.
• Interacted wif 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.
• Worked on development and refinement of Salesforce reporting functionality, prepared dashboards, pipelines, and other ad hoc reports.

Confidential, San Antonio, TX

Business Analyst

Responsibilities:

• Gathered requirements by conducting meetings and brainstorming sessions wif end users and SME and document them using Requisite Pro - the documentation tool offered by Rational.
• Data mapping, logical data modeling, created class diagrams and ER diagrams and used SQL queries to filter data wifin the Oracle database.
• Trade Promotions Management (TPM): Interacted wif different sources of information and provide a unified view of information to all the stakeholders.
• Worked on TD (Transportation & Distribution) and TSW (Traders Schedulers Workbench) functionality.
• Engaged wif business stakeholders to gather/analyze requirements and map them to solutions dat leverage salesforce functionality.
• Assist Category Development Managers (CDM's) wif the input of their annual trade plans in the Trade Promotions Management (TPM).
• Work wif CDM's to accurately document promotional events communicated to customers. Enter promotional events into the TPM system.
• Supported a procurement plan for new products, including start up items for new facilities and locations.
• Provide general/ ad hoc data and analytical support to CDM, Trade Marketing Manager, Sales and Finance.
• Developed E-Business Suite programs for databases supporting supply chain management (SCM), order management, inventory, warehouse management system, purchasing, and iProcurement.
• Supported customer needs using PKMS, WMOS Application by Manhattan Associates.
• Gathered requirements and modeled the data warehouse and the underlying transactional database. Worked wif ETL team during the upload process.
• Supported warehouse and business operation teams through WMS (Warehouse Management System).
• Prepared and maintained Business Rules Spreadsheets (BRS) identifying Rules, Triggers and corresponding data fields from Legacy to target CRM application.
• Developed and maintained strong relationships wif appropriate stakeholder organizations wifin the company and ensured dat procure to pay solutions met or exceeded stakeholder’s objectives.
• Coordinated operational research and improvement activities wif warehouse control vendors wifin a Manhattan WMS environment.
• Created different experience 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.
• Created Mock-up forms in MS word for better visualization and understanding of the software solution.
• Reviewed Stored Procedures for reports and wrote test queries against the source system (SQL Server) to match the results wif the actual report against the Data mart (Oracle).
• Developed E-Business Suite programs for databases supporting supply chain management, order management (OM), inventory, warehouse management system (WMS), purchasing, and iProcurement.
• Followed by reverse engineering to documentUIand 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.
• Used SharePoint for documentation and team related repository, while JIRA for ticketing issues and solutions.
• 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.
• Actively involved in 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.
• Validated the test data in DB2 tables on Mainframes and on Teradata using SQL queries.
• Applied UML notations and methodology in developing models dat accurately represent the business process and workflows and clearly communicate them to the stakeholders.
• Involved in building Platform features, user stories, and maintain backlog wif priorities, using Rally and JIRA.
• Performed Feasibility Analysis, Risk Analysis and Gap Analysis on vendor/third party tools.
• Involved in JAD sessions which includes the management, development and user teams for clarifying requirements and facilitating better communication.
• Worked on designing Functional Specification Documents for the reports.
• AS-IS study to identify the current process and try to fit into the ERP standard package.
• 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.
• Involved in managing at least two large-scale full-life cycle implementations of Quote to- Cash (Oracle CPQ/ CRM/CLM) solutions.
• Deep understanding of all the phases of Software Development Life Cycle (SDLC) methodologies throughout the project life cycle.
• Performed monthly GAP analysis of Supply Chain key performance indicators.
• Involved in performing version control and defect tracking activities using Rational ClearCase and Rational ClearQuest.
• Architecting reports, interfaces and extensions for Oracle EBS applications and Oracle Retail (Retek) for all OTC processes.
• Worked wif Salesforce Sales Analytics and Service Analytics standard applications, Dashboards, Datasets and monitor dataflows.
• Provided support to ongoing Salesforce.com maintenance and administration services including periodic data cleansing, custom objects, workflow and triggers.

Confidential, Pittsburgh, PA

Business Analyst

Responsibilities:

• Involved in Inception Phase and prepared vision statement and initial data models dat contain Business Requirement Documents and supporting documents dat contain the essential business elements and detailed definitions.
• Co-authored business requirements document wif project teams. Extracted, discussed, and refined business requirements from business users and team members.
• Ensured enterprise procurement processes were supported by working wif strategic sourcing, accounts payables, suppliers, internal end users, and by maximizing the use of offshore shared services operations.
• Performed the requirement analysis and documented the requirements using Rational Requisite Pro.
• Interacted wif the business users in noing the business views and gathered the reporting requirements to design the universes and business objects.
• Involved in scheduling and maintaining web analytics source data and provided UI reports using Omniture Site Catalyst.
• Involved in development and maintenance sales reporting using in MS Excel queries, SQL in Teradata, and MS Access.
• Produced 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 wif Marketing Team.
• Involved in the testing of the web application components of Content Merchandising System, Oracle RMS, WebSphere commerce functionality on various web browsers as part of UI testing.
• Worked wif 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.
• Created project templates, use case templates, requirement types and tractability matrix in Requisite Pro.
• Analyzed company specific data - Production amounts, forecasting and demand planning, inventory stocking at wholesaler & distributor, inventory turns per SKU, retail outlet coverage region-wise, merchandising & tax costs.
• Improved efficiency through better management of date integration and transfer between transmission control systems andAS/400mainframe.
• Used ARIS tool to capture as-is and future state processes in Order to Cash process.
• Incorporated an effective supply chain management to include inventory procurement and sales forecasting, especially on items involving short life cycle and high demand volatility by integrating Procure-to-Pay module.
• Interacted wif 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.
• Actively involved in developing 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 wif the Data warehouse/ETL and Reporting team.
• Worked wif information architects and creative groups in detailing the wireframes and depicting GUI design.
• Monitored KPIs and supported improvement measures for Transportation, Distribution and Warehouse Performance
• Performed Transportation and Distribution planning analysis and cost tracking to identify areas for improvement and cost optimization/reduction.
• Coordinated testing efforts across multiple JDA supply chain and retail applications includingallocations and replenishment.
• Worked on a procurement plan for new products, including start up items for new facilities and locations.
• Used MS SharePoint for the purpose of managing documents and for hosting websites which was used to access shared work spaces and documents.
• 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 wif ATGs ecommerce suite
• Conducted Joint Application Development (JAD) sessions wif IT groups. Identified the Key Changes, and participated in Stakeholder Management to communicate effectively wif 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.
• Created and managed project templates, use case templates, requirement types and tractability matrix in Requisite Pro.

Confidential, Burlington, NJ

Business Analyst

Responsibilities:

• Actively involved in the development and maintenance of sales reporting using in MS Excel queries, SQL in Teradata, and MS Access. Produce performance reports and implement changes for improved reporting.
• Actively involved in tracking and maintenance of accuracy of inventory through the use of WMOS.
• Performed the requirement analysis and documented the requirements using Rational Requisite Pro.
• Involved in Inception Phase and prepared vision statement and initial data models dat contain Business Requirement Documents and supporting documents dat contain the essential business elements and detailed definitions.
• Co-authored business requirements document wif project teams.
• Extracted, discussed, and refined business requirements from business users and team members.
• Interacted wif the business users in noing the business views and gathered the reporting requirements to design the universes and business objects.
• Interacted wif Subject Matter Experts (SME) and end users and established a business analysis around AGILE methodology.
• Analyzed Business Requirements and segregated them into high level and low-level Use Cases, Activity Diagrams/State Chart Diagrams using Rational Rose according to UML methodology thus defining the Business Process Models.
• Worked wif 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.
• Improved efficiency through better management of date integration and transfer between transmission control systems andAS/400mainframe.
• Helped in designed process which pulls ADHOC files from SharePoint using HTTP transformation and load it to UNIX server in the form of flat-file inInformatica Power Center.
• Used MS Visio for Process modeling, Process mapping and Business Process flow diagrams.
• Interacted wif business SMEs, enterprise architects, developers, business intelligence, and data warehouse teams regarding project requirements explanation and interpretation.
• Established traceability matrix using Rational Requisite Pro to trace completeness of requirements in different SDLC stages.
• Custom tools upgrade client had created marketing, merchandising product tools to support their custom web application which needed to be re-architected to work wif ATGs ecommerce suite.
• Conducted Joint Application Development (JAD) sessions wif IT groups. Identified the Key Changes, and participated in Stakeholder Management to communicate effectively wif them.
• Used MS Visio for Process modeling, Process mapping and Business Process flow diagrams.

Confidential, Houston, TX

Business Analyst

Responsibilities:

• Interacted wif 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.
• Used Balance Scorecard approach for developing program strategy in order to manage the grants program and development of metrics for monitoring success of program.
• Conducted JAD sessions for communicating wif Stakeholders and Project directors.
• Created business process workflow diagrams (Activity diagrams) in Rational Rose.
• Assured dat all Artifacts are in compliance wif corporate SDLC Policies and guidelines.
• Created Use-Cases and Business Use-Case Model after accessing the status and scope of the project and understanding the business processes.
• Worked on managing all the requirements in Requisite, making requirements available to all team members.
• 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.
• Followed the UML based methods using Rational Rose/MS Visio to create: Use Cases, Activity Diagrams / State Chart Diagrams, Sequence Diagrams, and Collaboration Diagrams.
• Coordinated and prioritized outstanding defects and enhancement/system requests based on business requirements, allowing sufficient time frame to ensure accuracy and consider deadlines.