SUMMARY

• 10 years of industry experience as a Business Analyst with solid understanding of Quality Process Improvement, Software Testing Life Cycle, Business Process Flow, Business Process Modeling and Quality Assurance & Analysis.
• Worked on industry standard methodologies like Software Development Life Cycle (SDLC), RationalUnifiedProcess (RUP), CMM (Capability Maturity Models), and Capability Maturity Model Integration (CMMI) and Six Sigma and Rational Tools used during various phases of RUP.
• Experienced in analyzing massive and highly complex data sets, performing ad - hoc analysis and data manipulation.
• Experienced with writing reports using Cognos reporting system to extract data for analysis using filters based on the analysis.
• Worked on complex information model, logical relationships, and the data structures that support different jean brands.
• Strong experience in Business and Data Analysis, Data Profiling, Data Migration, Data Integration and Metadata Management Services.
• Good experience in Data Modeling with expertise in creating Star & Snow-Flake Schemas, FACT and Dimensions Tables, Physical and Logical Data Modeling using Erwin.
• Experienced working on DB2and Oracle databases.
• Also skilled in implementation and development of applications in JAVA/J2EEwith additional knowledge of Spring, Spring Batch hibernate, Jsp, sql, solr JavaScript, Omniture,Demandware.
• Expertise in the field ofDemandware(now Salesforce Commerce Cloud).
• Provided guidance in the writing and review of SAP course materials. This will included working with the functional team to obtain SME input and to facilitate the overall complete development of materials
• Experienced in SAP classroom learning events, delivering training, demonstrating concepts, achieving student participation and effective learning results
• Developed web-based SAP course materials.
• Experience in navigating the set-up process, ongoing support for any operating issues,paymentgateways, manage transactions, merchant funding, automated recurring billing, tokenization, fraud prevention, etc.
• Delivered process workshops presenting new SAP process information between each individual site's legacy PeopleSoft/JD Edwards systems
• Achieved 50% error reduction for EDI utility and telecommunication invoices by developing VB replacement for mainframe application.
• Identified and implemented process improvement efforts within the EDI structure including system interface, policy and procedure changes.
• Performed detailed design and mapping specification creation for translation between Legacy and EDI formats.
• Payment transaction expert with experience in handling and inspecting forfraudor counterfeit activity across; cash, domestic or foreign wire transfers
• Acted effectively as point-of-contact on status of EDI transactions from internal and external customers.
• Identified and recognized opportunities to resolve problems related to EDI transactions.
• Experienced in providing end user technical support, troubleshooting, and assistance in configuration, product feature customization, performance improvement, testing, reporting, maintenance, installation and on call support for SharePoint applications.
• Extensive experience in complex query writing in SQL using MYSQL and Oracle databases.
• Excellent team player work in conjunction with testing, development and other teams in validation and testing complex scenarios and projects and in the maintenance of Quality Standards in Projects.
• Experience on bridging the gap between Business/Product department and IT.
• Worked on large scale Retail Sector Projects facilitating testing across cross functional teams
• Familiar with current industry standards such as ISO, Six Sigma, and Capability Maturity Model.
• Result oriented, committed and hard working with a quest to learn new technologies and undertake challenging tasks.
• Proficient in Developing and executing Test Plans, performing functional, usability testing and ensuring that the software meets the system Requirement.
• Excellent team player work in conjunction with testing, development and other teams in validation and testing complex scenarios and projects and in the maintenance of Quality Standards in Projects.
• Extensive experience with MS Visio for drawing flow charts and screen mock ups and MS Project for status reporting and planning.
• Proficient inTestPlanning,TestManagement,TestExecution, Reporting Aspects, Resources Management, Schedule and Cost Management, Client Interaction, Status Reporting to Senior Management.
• Worked on Amazon Web Services (AWS) and Amazon E-Commerce Supply Chain as requested by the end clients.
• Migrated Raytheon's Remedy ticketing database over to Hewlett Packard's CA ticketing system.
• Extensive experience in Unit testing, Platform Testing, Acceptance Testing, Functional, Module, Black-box, Integration, Regression, System, Smoke, Database, Backend, User Acceptance, Performance, Load and Stress Testing.

TECHNICAL SKILLS

Methodologies: Agile, Waterfall, RUP, UML, SDLC, Scrum, RUP, V-shape modeling, BPEL, BPMN

Change Management Tools: Rational Clear Quest, Rational Clear Case.

Business Modeling&VersioningTools: MS VISIO, Visual Paradigm, Rational Rose; Rational Requisite Pro, Rational Clear Case, Microsoft Dynamics CRM

MS Office: MS Project, MS Word, MS Excel, MS PowerPoint, MS Access

Programming Languages: Structured Query Language (SQL).

Operating System: Windows NT/98/2000/XP.

Databases: Access, Oracle 8i/9i/10g, Teradata, DB2, MS SQL Server 7.0/2000

Other known tools: SAP, Informatica, Load Runner, Win Runner, Crystal Ball, Expert Choice, Core, Caliber

OLAP Tools: Business Objects XI, Cognos .

Testing tools: Rational Robot,RationalClearQuest Test Manager, HP Quality Center, Quick Test Test Professional, LoadRunner, WinRunner, Team Foundation ServerTFS 2010, Bugzilla, JIRA, IBM Jazz

Apps & Webservers: Apache web server, Tomcat, Web logic 8.1, IIS

PROFESSIONAL EXPERIENCE

Confidential, Framingham, MA

Sr. Business Analyst

Responsibilities:

• Worked in AGILE & create storyboards, user-stories, wire frames while working in Sprints.
• Created and Updated the Data Dictionary Mapping from Database to User Interface(UI) for the Internal Portal Team.
• Created SQL test scripts for a diverse group from the Application team, Testing team(IV&V), Performance team, Business Partners and others which were used for application verification.
• Mined data for the application team and design team to assist with creation of the application.
• Conducted data reverse mapping utilizing the TOAD, Siebel (SQL, PL/SQL server) for Oracle systems.
• Created a technical Specification document to show how the project gathered data to create a new system environment in Oracle.
• Worked with direct reports to manage order processing flow,fraudprevention, cancellations, charge backs, returns, and exchanges, up selling, back-order and pre-order management.
• Worked on designing DB2 database for the application.
• Proficient in Sales Force Commerce Cloud(Demandware) from Testing Perspective as well as from Content Management Perspective.
• Worked on Microsoft Dynamics CRM to - Centralize customer information, Automate marketing interactions, Provide business intelligence, Facilitate communications, Track sales opportunities, and Analyze data and to enable responsive customer service.
• Responsible forfraudmanagement initiatives, chargeback, disputes and routine review of payment gateway rules with the objective to maintain compliance.
• Responsible for new project implementations onOrderManagement System (OMS).
• Streamlined backend processes including demand to net flow and reconciliation, returns and refund processing,fraudprevention.
• Utilized various tools to gather, analyze and interpretfrauddata •
• Web service Calls to Payment Gateway andFraudCheck.
• Used MS Dynamics for sales to sell smarter with embedded intelligence, Foster relationships with authentic and personal engagement, Boost productivity and increase revenue.
• Responsible for maintenance, upgrade, uploads,paymentgatewayintegration
• Monitor processing and completion ofpaymentprocesses for the day-to-day activities
• Used MS Dynamics in finance and operations to elevate financial performance, Automate and streamline supply chain, optimize production planning, scheduling, operations, and cost management in sales.
• Processpayments gateway and Set uppaymentplans for client requirement.
• Worked on MS Dynamics for MS Dynamics for Retail application for reporting, Business Intelligence, production planning, scheduling operations and cost management etc.
• Reviewed potential fraudulent accounts for detection and prevention of electronicfraud
• Improved overall SWAT process by implementing mentoring sessions to give a solid knowledge transfer from my knowledge and experience with SAP HR, ESS/MSS, Training and Events Management, and Beacon
• Responsible for primary collections &paymentplan strategy contact
• Troubleshooting of SAP GUI Issues
• Used Salesforce Commerce Cloud (Demandware)
• Ensured successful integration of EDI data to Visteon's SAP system and to trading partners' (VAN) Value Added Network mailboxes and through the Internet.
• Created and maintained over 200 trading partner profiles in the Netscape ECXpert EDI software.
• Coordinated timely resolutions of EDI-related phone and online requests from Visteon personnel.
• Conducted bi-weekly EDI status meetings with Visteon customer to discuss resolved/unresolved EDI requests.
• Executed EDI system test plans to ensure successful integration into Visteon's SAP production environment.
• Identified candidate business processes which leverage SharePoint tools to enhance day-to-day office functions using workflows, Info Path forms and Corasworks.
• Built out content using SharePoint Designer, provided training for additional best practices and lessons learned for education of end users.
• Developed a quick and thorough understanding of MS SharePoint 2010. Performed quality assurance testing on developed SharePoint sites and web parts.
• Authored functional requirements based on the needs of users. Authored a governance plan detailing the rules and policies for the SharePoint Project.
• Worked in digitalmarketingon social media (Facebook, Twitter, YouTube& Google+) and actively involved in Search Engine Optimization (SEO), synonym mapping and product categorization for creating, implementing new digitalmarketingcampaign.
• Worked on writing complex SQL queries and PL/SQL stored procedures.
• Work withETLdevelopment team to make sure data is modeled & available in the DW tables that can be used by down streams as required
• Worked on Amazon E Commerce Supply Chain modules as required by the client.
• Worked with Multi-Channel Fulfillment & Inventory Management, Order Management and Omni channel retailing
• Conducted JAD sessions with supply chain management and development team to brain storm Point of Sale (POS) and Inventory and Order Management System (IOMS).
• Wrote VB Script to do daily work & also performed testing by writing SQL queries using TOAD.
• Did Campaign growth by working closely with the DigitalMarketing, Ecommerce, and Strategic Partnership teams & handled all functions for a brick and mortar store including product selection, staffing, advertising & back office functions.
• Implemented catalog shopping cart through mobile payment gateway.
• Analyzed trends in customer perception, preferences, and behaviors across the ecommerce/website channel through full shopping cart life cycle and customer order history using Omniture system.
• Work withETLteam to understand data load/data mapping issues to make sure data warehouse tables are developed as per thebusinessrequirements.
• Involved in implementing (POS) Point Of Sale system and Point Of Commerce for US retail/Online stores.
• Support major effort to improve the Warehouse Management System (WMS) capabilities of Supply Chain.
• Contacted T.J. Maxx, Brick and Mortar stores to set up delivery options.
• Created macros in excel and performed complex tasks for data analysis as required on all projects.
• Extensive use of Adobe WebAnalyst/Omniture Site Catalyst for web-site analysis.
• Involved in implementing Omni channel Point of Commerce (POC) and Point of Sale (POS) upgrading Order Management System (OMS) with third party vendor support.
• Partnering with hybris, an industry leader with expertise in both B2B and B2C ecommerce.
• Decompose high level concepts and requests into epics and user stories that are consumed by agile teams across multiple parts of the organization that directly lead to on-time deployments through agile release planning efforts.
• Proficient with Ecommerce Content Management System and (POS) Point of Sale systems.
• Interaction with the third party systems - Exact Target, JDA, Sterling team and ensuring the requirements are well understood.
• Worked with the internal ecommerce and web development teams to design the most cost-effective ecommerce solution to meet thebusinessobjectives.
• Enhanced Web Design/UI Experience for ecommerce according to customer requirements.
• PerformedBusinessProcess Analysis and documented Process Design Document (PDD) to capture the end-to-end flow of processes in Sales and Distribution.
• Acted as SPOC (Single-point-of-contact) at offshore for any functional aspect of the IBM Sterling OMS application and its features for the assigned module.
• Conducted User Acceptance Testing (UAT) sessions with business users and prepared document for enhancements and bug fixes.
• Participated in Business Modeling by understanding the needs of the business, and also documenting Business Use Cases as well as System Use Cases
• Develop the supporting plans such as scope, cost, risk, schedule, quality, resource, security deliverables, procurement and change management plans.
• Facilitated Joint Application Development (JAD) sessions with the Management, Mainframe and multiple teams to make sure everyone are in synchronous with the business requirement processes.
• Developed SQL queries to query the data present in databases stored in EDW.
• Conducted defect tracking & management as well as requirements gathering, test cases etc. using HP Quality Center.
• Lead testing team & ensured delivery of artifacts on time & measure test effectiveness throughout the testing phase.
• Created Test Matrix, measured defects density, defect closure standards as per the compliance and standards.
• Initiated Test Plans, developed and executed test cases and scenarios, worked with users to develop specific acceptance criteria and prepare test exhibits.
• Provided production support, release management, incident control management as required by the team
• Did detailed data mapping, data validation & data analysis for multiple systems
• Conducted GAP Analysis& Data mapping for project implementation as well as also developed RFP for vendor analysis
• Worked on DemandwareCartridges with controllers
• Worked on Sales Force Commerce Cloud (Demandware) from Testing Perspective as well as from Content Management Perspective
• Creating webpages using templated which includes plane HTML and added(X)HTML tags also included other templates usingDemandwareScripts, Building Forms, Input
• Captured detailed BRD/FRD for Rational Suite Upgrade & conducted testing: SIT/UAT: Test-Plan development/Test-Cases development/Test-Data creation using Quality Center.
• Used translator vendor tools to convert files into XML formats for successful processing.
• Analyzed & validated acceptance criteria are documented for user stories on multiple projects in AGILE.
• Develop Project charter and obtained approvals & conducted defect tracking/management.
• Successfully lead & coordinated a team of testers using QC & used MS Visio to create Use Cases and Sequence Diagrams.
• Site preferences, custom objects/attributes creation and scheduling jobs inDemandware.
• Involved in Sales, Marketing Strategy development and implementation, track customer flows usingDemandwareand CRM tools
• Assisted development team to translate requirements into technical specifications.
• Created and Maintained the Requirement Traceability Matrix (RTM) throughout the project.
• Supported escalated issues that were initially unsolvable by colleagues.
• Migrated Raytheon's Remedy ticketing database over to Hewlett Packard's CA ticketing system.
• Resolved Network mapping issues for external and internal users.
• Created presentations via PowerPoint for clients/Contracting Officers.
• Supported users with DoD certificate issues, network access problems, and both hardware/software related issues.
• Provide inbound technical support for a major credit cardpayment gatewaysolution.
• Stay up-to-date withDemandwareplatform releases and webinars.
• Changing the defaultDemandwarelogic related to PDP, Cart and Checkout process.
• Aided the IT Department in troubleshooting various desktop and networking issues.
• Used MS Outlook and Excel on a daily basis to communicate and manage moves.
• Established, analyzed, and delivered weekly key performance indicators (KPIs) to senior leadership.
• Lead effort to change and universalize theGatewayreceipt compliance requirements by designing and proposing product functionality change to Product and Development teams, without impacting existing customer base.
• Marketing strategy lead responsible for developing launch marketing strategies and pilot programs to increase awareness, acquisition, and adoption of Amazon WebServices' features and services.
• Owned development and execution of annual marketing strategy (including financial model) for localsearch.com; recommendations made led to securing budget and resources for execution.

Environment: SharePoint, SQL, IBM Watson, Adobe Suite, Demandware Visual Basic,OMS, Toad, Windows XP, Agile, UNIX, HIPAA, Outlook, Test Director, Oracle, Ultra Edit, XML. Quality Center Rational Rose, Rational Requisite Pro, UML,XML, XSLT, MS Project, MS Visio, MS Office Suite, PL/SQL Developer, HTML, DB2.

Confidential, Minneapolis, MN

Sr. Business Analyst

Responsibilities:

• Responsible for all EDI map development and testing, version control, profile setups and documentation for new trading partners for both production and test environments
• Provided functional input and SAP guidance to 10 configuration Managers on the Army\'s mySAP Business Suite.
• Liaison between IT technical departments and external and internal customers to ensure error free EDI transactions
• Performed data profiling in the source systems that are required for the System
• Documented the complete process flow to describe program development, logic, testing, and implementation, application integration, coding.
• Worked with internal architects and, assisting in the development of current and target state enterprise data architectures wrote integration document, and performed the LINK cartridge demonstration withDemandwareto get the LINK cartridge certified both in pipelines and controllers.
• Worked with project team representatives to ensure that logical and physical data models were developed in line with corporate standards and guidelines.
• Assisted with functional, regression and user acceptance testing forDemandwarereplatform and subsequent deployments.
• Performed updates, maintenance, and enhancement integration onDemandware
• Involved in defining the source to target data mappings, business rules and data definitions.
• Geek Squad Service Integration
• The project was to introduce new digital TS/S2 (Tech Support & Software Subscriptions) SKUs in dotcom
• I lead the manual testing done for the web services using SOAPUI needed for GSSI from dotcom.
• I lead the support teams for the IPT team from overall dotcom perspective.
• I conducted test data Set up for SIT & UAT.
• Exposure to severaldemandwarelink cartridges like PayPal, Order guard, Bazaar voice, Link share, Rich Relevance etc.
• Imanaged and conducted UAT sessions with various impacted business users groups.
• Digital SKUs in dotcom
• The project was to work on the pending High/Critical existing production defects from March '08 for digital products.
• Managed manual testing activities and coordinated with the external/downstream teams for defect resolutions.
• Emerging Channels
• Enhancements and changes to new and existing functionalities in mobile and tablet applications.
• Reviewed test requirements & Use Cases, review test design documents prepared by the offshore team.
• Tracked test design & project test - tracking sheets using QC and wrote SQL queries to do testing.
• Manual testing the mobile & tablet applications for the changes going in through frequent releases.
• Reverse Logistics
• Reverse Logistics was a project to provide a track able solution for returned mobile to BestBuy Mobile.
• I lead the Manual testing effort for the internal services to Bestbuy and worked for testing all the services, internal/external systems.

Environment: SAP,SQL, HP Quality Center, Demandware,XML,ClearCase MS Office, OMS,MS-Visio, XML, Java, TOAD, MS Project, SOA, SOAP UI, cURL, Cucumber, Win Xp/7, Unix, Mainframes, Oracle, Agile, TOAD, DB2.

Confidential, Bentonville, Arkansas

Business Analyst

Responsibilities:

• Worked with Scrum Masters (Agile), Product Owners, and Scrum team members to ensure success of Programs, Releases and Sprints.
• Wrote complex SQL queries using WINSQL to do data analysis, data validation etc. & followed amazon ecommerce supply chain models.
• Developed Concepts, Exercises and Quick Reference Cards for SAP Navigation
• Extensive use of ERP systems including SAP, UNIX and JD Edwards.
• Monitored, investigated and resolved EDI production problems; reviewed daily EDI error/exception reports; analyzed process and recommended improvements
• Coordinated with business owners to insure business needs and EDI transaction format requirements were met and troubleshoot issues that arose.
• Worked on designing and managing DB2 database.
• Coordinated data communication procedures involving the transmission and reception of electronic data within the Sterling EDI system
• Drafted migration/relaunch plan for the SharePoint 2010 environment including governance, infrastructure, and taxonomy, requirements, timeline and test plan.
• Leveraged Agile development process to design SharePoint resources
• Trained multiple internal classes in Redwood City, CA and Vacaville, CA on SharePoint processes
• Created 22 videos on SharePoint best practices and tutorials
• Reviewed Business requirements documents and preparedTestStrategy,TestPlan and Involved in Static and Dynamic testing.
• Involved in 6 successful releases of application and played a critical role in each success.
• Updated existingtestcases and wrote newtestcases as per the requirement.
• Used Quality Center fortestcase management, defect tracking, and defect reporting.
• Prepared Requirement Traceability Matrix document to map the requirements totestcases.
• Involved in executing thetestcases manually and did System, Functional, End-to-End, Regression, Integration, UAT, Black Box, White/Grey Box testing, Ad-hoc testing, Risk based testing, Usability testing and retesting.
• Involved in defect review, checkpoint and root cause analysis meetings and tracked defects in Quality Center.
• Verified build, release package by logging in to controllers using commands.
• I did daily lab set up verification on all controllers (like USWM controller, USSM controller, etc.).
• Used UNIX commands to verify log files while troubleshooting issues and tested POS Registers/Terminals and Controllers.
• Prepared Logical Process and Data Models that contained set of diagrams and supporting documents containing the essential business elements, detailed definitions, and descriptions of the relationships between the data elements to analyze and document Business Data Requirements.
• Followed the UML based methods using MS Visio to create Use Case Diagrams, State Chart Diagrams and Sequence Diagrams.
• Detailed understanding of business functionality and preparing the Functionality Test Plan
• Responsible to conduct walkthrough sessions to get Business Sign off for the FRD.
• Meetings with Developers, Team Leads to help them understand the requirements.
• Interacted with the Testing and Development team to resolve and follow up on development issues.

Environment: SAP,MS Office Tools, Windows XP, Demandware, MS Project, ClearCase, Business Objects, Waterfall, Quality Center, JAVA, Web Services, 50 Key Registers, Controller/Store, 4690 IBM Point Of Sale OS, Oracle, Teradata, UNIX, Linux, PuTTY, SQL, DB2