SUMMARY

• 8 years of professional experience in Retail, E - commerce and Manufacturing domain and strong understanding of Business Requirement Gathering, Business Process Flow, Business Analysis and Supply Chain. Possess strong communication, analytical and problem-solving skills with superior leadership, team collaboration, training and management skills to build consensus across relevant parties and derive business success.
• Worked in industry standard Software Development Life Cycle (SDLC) methodologies like Waterfall, Agile-Scrum, Kanban and Waterfall-Scrum Hybrid with understanding of Extreme Programming and Spiral model.
• Extensive experience working with vendor e-commerce tools as well as helping construct and integrate in-house e-commerce applications with Business-to-consumer (B2C) sales of tangible goods or online services and Business-to-business (B2B) scenarios for enterprises.
• Excellent Business writing skills in writing Business Requirements Document (BRD), Use Case Specifications, Functional Specifications, Systems Requirements Specification (SRS), Functional Requirement Document (FRD), Data Requirements and Workflows for applications such as shopping carts, catalogs, search tools, checkout and payment gateways.
• Assisted Project Managers in preparing Project Plans, Project Schedules, establishing Milestones, Work Breakdown Structure (WBS), maintained RACI chart to manage overall project risks and mitigation plans.
• Excellent knowledge in dataflow analysis of the system using use case diagrams, dataflow diagrams, state diagrams, activity diagrams, flowchart diagrams and collaboration diagrams.
• Analyzed and implemented various Lean and Six-Sigma business techniques to reduce waste, streamline the process and the flow to make system more sustainable and reliable to get better yield in production.
• Great understanding and knowledge of Scaled Agile framework (SAFE) .Certified Scrum Master with immense skills in facilitating the Scrum Ceremonies, User Story Workshops, Training the teams to better understand Scrum and increase the team’s overall productivity.
• Performed Financial Analysis and Business Process Re-engineering providing solutions for issues relating to risk management. Maintained a structured approach in organizing requirements to ensure that critical business rules and requirements are met.
• Maintained a structured approach in organizing requirements to ensure that critical business rules and requirements are met with the help of Requirement Traceability Matrix (RTM).
• Involved in scripting business logic in the web methods of the web services and documenting the Web Service Level Agreement (WSLA) document using Extensive Markup Language (XML).
• Experienced in working with Subject Matter Experts from various business areas and domains to identify (key performance indicators) KPI’s and (service level agreements) SLA’s for the Website Performance, Customer Acquisition, Lead Conversion, Customer Retention, Search Engine Optimization, CLA (call to action), CLV (customer lifetime value) and fulfillment.
• Expertise in creating Data Models like Conceptual data model, Physical data model, and logical data model in the form of entities and relationships to capture the user requirements properly in the underlying database. Practical knowledge of Data Warehousing architecture, implementation approaches, schemas, dimensional modeling and translating the business requirements into various types of dimensions
• Excellent Business Analysis skills and extensive experience writing Use Case Requirements, Request for Information (RFI), Request for Proposal (RFP), Request for Quote (RFQ), and Request for Bid (RFB).
• Worked with project teams and architects to develop UML diagrams which helped visualize the process.
• Managed requirements and tracked defects working with HP Application Lifecycle Management (HPALM) and HP Quality Center (HPQC) and documented performance reports.
• Experience in conducting Risk analysis and preparing Training manuals and Standard Operating Procedures.
• Strong knowledge on SAP Transactions and Business processes including Procure to Pay and Order to Cash.
• Extensive experience in Data Warehouse and ETL process using Informatica and Data Stage.
• Worked with the software developers to ensure that the applications confirm to customer requirements.
• Well versed in conducting various types of testing including Alpha and Beta testing along with User Acceptance Testing (UAT) and helped in designing and developing test plans and test scripts.
• Experienced in conducting Data Analysis using design of experiments in Minitab and Tableau for dashboards.
• Experience in Database Applications with Oracle, SQL Server, MS Access and very efficient in tuning the SQL queries and using several tools and utilities.
• Cultivated experience in working with different web services such as HTML, WSDL, SOAP, UDDI, REST, JSON under various architectures like Three-Tier Architecture and Service Oriented Architecture (SOA).
• StrategicMarketing, IntegratedMarketing& Promotional Plans, Brand Management, Wholesale/Trade & RetailMarketing, Digital & Social MediaMarketing, Brand Positioning, Business Development, Brand Portfolio.
• Excellent communication, analytical and time management skills, with capability to handle new technologies and situations and an ability to lead, manage and work in challenging environments.
• Knowledge of implementing Automation Program using Programmable Logic Controller (PLC).
• Team player and self-starter with excellent coordination, documentation, project planning and interpersonal skills with proven ability to work under pressure, prioritize and meet deadlines.

TECHNICAL SKILLS

SDLC Methodologies: Waterfall, Agile-Scrum, Kanban Waterfall-Scrum Hybrid, XP, Spiral

Requirement Management: Atlassian-JIRA, CA Agile, and HP-ALM

Project Management Tools: MS Project, MS SharePoint, Confluence, Coupa v15.0, VISIO, JIRA

Modeling Tools: Rational Rose, Microsoft Visio, Lucid Chart, Balsamiq

Testing Tools: HP Quality center, Selenium, Load Runner, Soap UI, Swagger, Postman

ETL Tools: Informatica Power Center, SQL Server Data Tools

Reporting Tools: Tableau Desktop, QI Macros, Minitab, SSRS

Languages: HTML, SQL, C, Java, .NET

IDE: MS Visual Studio, Eclipse, PHP storm

Databases: MySQL Server 2012, Oracle, HBase, SSIS, Informatica power center

Operating Systems: Windows, Mac OS, Linux

E commerce tools: Google analytics, Salesforce, Moz, Buffer

Business Skills: Change Management, Conflict management, Impact Analysis, Project Planning, Project Scheduling and Project Budgeting, DMAIC, 5S, Root-Cause Analysis, GAP Analysis, SWOT Analysis and ANOVA.

PROFESSIONAL EXPERIENCE

Confidential, Framingham,MA

Sr. Business System Analyst

Responsibilities:

• Assisted in developing Project Proposal, Business Case and Business rules for the high-level requirements.
• Performed Gap analysis to show as-is state and To-be state of the need for the system to be implemented.
• Helped in creating a Work Breakdown Structure (WBS) in Microsoft Project to visualize the workflow.
• Gathered business requirements from stakeholders and translate them into detailed requirement specification document to keep track of all the requirements for implementing the new system.
• Performed various Elicitation Techniques such as Brainstorming sessions, JAD sessions and Surveys.
• Helped Business Owner in establishing Business Rules for Promotional discounts based on First-in first-out (FIFO) inventory in the warehouse or the stores and customer Brand loyalty programs.
• Prepared Business Requirement Document (BRD) from the elucidated requirements and helped the Product Owner and Development Team in making User Stories by using Three C’s.
• Managed and documented the change requests and implemented changes and updates for the new design. Created and maintained Requirement Traceability Matrix (RTM) to ensure all the requirements are fulfilled and all the test cases have been executed according to the proposed plan.
• Facilitated Scrum ceremonies: Iteration planning, Daily scrum, Iteration reviews Iteration retrospective.
• Designed data models and conducted Normalization and De-Normalization of the data as per the Online Transaction Processing (OLTP) and Online Analytical processing (OLAP) frameworks for data analysis.
• Performed slicing and dicing of data marts in order to facilitate the analytical decision-making process.
• Integrated various OLTP to OLAP by using Informatica Power Center as an ETL tool.
• Implemented Asynchronous Java script and XML or Ajax which is client-side validation techniques without reloading the entire web-page to reduce the traffic between the client and the server.
• Analyzed Business Requirements and segregated them into high level and low-level Use Cases, Activity Diagrams or Sequence diagrams to have better understanding of the system.
• Developed several Use Cases using Draw.io and the company’s templates for better understanding and implementation for developers and uploaded them into Confluence and linked it with JIRA.
• Good Understanding of SAP and Coupa Integration to optimize the supply chain and to make integrating easier, both flat file and REST API were used to manage the complex integrations. Worked with Product Owner to groom the Product backlog and help him prepare the plan releases.
• Hands on Coupa (SaaS) Product including Procurement, Invoicing, Expenses to provide a solution that increases Business-to-business (B2B) efficiency and drives profitability to the organization. Designed and implemented SQL queries to perform data validation, CRUD operations joints, triggers and stored procedures.
• Created dashboards, reports, forms and templates to manage expenses, invoices and catalogs in Coupa.
• Created Invoices in Coupa via the Coupa Supplier Network, cXML and Manual Entry after approval, they are sent to the customer's ERP system, matched, and then paid.
• Extracted data from Oracle database with MS Access, and performed SQL query, data analysis and verification.
• Helped in development of the prototypes and test scenarios for User Acceptance Testing.
• Helped Quality Assurance Analyst to formulate test cases and test scenarios from the use cases.
• Helped the team and the users in performing Alpha and Beta testing of the developed design.
• Developed Test Cases, User Acceptance Testing (UAT), and Regression Testing to assist with Quality Assurance (QA) and verify that requirements were fulfilled.
• Involved in systems integration testing, web services API testing using SOAP UI.
• Implemented Lean and Six-Sigma techniques including 5S, Fish Bone Diagram, Analysis of Variance, Design of experiment and Spaghetti diagram to reduce waste in the warehouse management system (WMS).
• Used Ideaboardz (SaaS) for Retrospective meeting to come up with the Action Items.
• Developed reports using Tableau v9.0 to communicate information using graphs, charts and other info graphical solutions to the project team.

Environment: Atlassian-JIRA v7.2, Confluence v5.9, Eclipse IDE Neon v4.6, Coupa v15.0-v17.0 HTML5/CSS3, JavaScript, Ajax, REST, XML, SoapUI, Selenium v2.5, LoadRunner, Infomatica Power Center, Draw.io, Ideaboardz 2016, Tableau v9.0, MS office suite 2013 (Excel, Word, PowerPoint, Outlook, Visio), Agile-Scrum.

Confidential, Greensboro, NC

Business System Analyst

Responsibilities:

• Responsible for establishing and performing business process, analysis, and modeling of business processes.
• Gathered requirements for Business-to-business (B2B) and Business-to-consumer (B2C) parts of the website for online and onsite user’s ability of search online, shopping cart management, membership subscription, payment processing, order processing and Customer support.
• Providing Sales andMarketingperformance analysis; Industry, trends and best practices research;
• Business Development, Website Optimization and Content recommendation.
• Created mockups to compliment use cases to communicate between business and technical teams.
• Conducted and created User Interface for web pages and documented user interface forms with relevant data dictionary, and models to communicate to database and development teams.
• Performed Impact Analysis, Feasibility Study/PEST Analysis, Cost-Benefit Analysis and Return on Investment (ROI) to mitigate certain risks associated with the project and project output.
• Participated in assignments developing UI pages using JSP, HTML, CSS and JavaScript technologies
• Created use cases for various scenarios using activity diagrams using VISIO. .
• Identified user specific requirements, analyzed them and documented all of them along with the Vision.
• Developed and analyzed the Sprint/Product burn down chart to calculate the team’s velocity and track sprint progress. This was then utilized for planning of the upcoming sprints. Used JIRA to plan and track the sprints.
• Established and modeled product features for each planned iteration to manage the scope of project.
• Converted business requirements to system requirement specifications, with the help of various elicitation techniques like JAD, Interviews, contextual enquiry.
• Documented business rules and supplemental specifications for better understating of the system.
• Created high level use case models depicting features of overall system and specific models for each release
• Provided recommendation for use of ATG Commerce for (B2B) and (B2C) business.
• Analyzed, developed, and documented detailed business process overview diagram.
• Active part of the testing of the system during Smoke testing, Black Box testing, Regression Testing, System Testing. Conducted ETL workshops to understand requirements for Data Warehouse Design (Extraction, Transform and Load) operations on the database.
• Designed and implemented basic SQL queries for QA Testing and Report / Data Validation.
• Assisted Data modeling process by creating conceptual and logical ER diagrams and designing database schemas to help development of an accurate Data Warehouse Structure.
• Integrated various OLTP to the OLAP by using Informatica as an ETL tool and used Tableau as reporting tool. in Database management systems.
• Developed mock-ups and wireframes along with the screen designs to make better UI designs.
• Implemented HADOOP ecosystem and built a highly efficient network of nodes, racks and clusters.
• Created Feature files in Cucumber using Gherkin language for various scenarios and scenario outlines.
• Established a CRM and B2B database which helped company to manage and reduce its loss by fifteen per cent
• Managed company e-commerce websites and third party sales websites, prepared relevant reports based on key performance indicators (KPI’s). Provided weekly sales reports and funnel analysis to the General Manager by using Google Analytics tools.

Environment: CA Agile (Rally v2014.1), SharePoint 2013, Oracle9i, MS SharePoint Enterprise 2013, MS Visio 2013, Apache Sqoop v1.4, Apache Flume v1.5, Apache Mahout v0.11, Apache Hive 2.0,MS Project 2013 Web sphere, Oracle ATG, Java/J2EE HTML, XML, JSP, EJB, Scrum-Waterfall Hybrid.

Confidential, Confidential, Ohio

Business Systems Analyst

Responsibilities:

• Conduct customer and market research to understand, analyze, and articulate customer needs, industry and technology trends, and competitive landscape.
• Utilize both quantitative and qualitative methods to inform and drive platform/product roadmap and requirements. Collaborate with executive team to get agreement on product/platform strategy and roadmap.
• Write necessary requirements/specifications/epics/user stories for all new product features and enhancements.
• Work closely with UI design staff to develop intuitive and compelling user experiences. Create models, mockups, wireframes, and other illustrations to convey feature ideas and requirements and gather feedback.
• Set the product strategy, prioritize features, build consensus and coordinate product schedules with a team of engineers and designers to ship top quality experiences to users.
• Created AWS Route53 to route traffic between different regions .Created configuration for establishing a VPN tunnel between on premise network and AWS VPC.
• Integrate usability studies, user research, and market analysis and community feedback into product requirements to ensure the product satisfies user needs as well as wants.
• Inform product decisions with quantitative data on user behavior and experimentation a/b testing.
• Define methods and metrics for measuring success and failure while ensuring the team is clear on their objectives, and constantly track performance.
• Designing and implementing AWS Solutions using EC2, S3, EBS, Elastic Load balancer (ELB), VPC, Amazon RDS, Cloud Formation, Amazon SQS, and other services of the AWS infrastructure.
• Utilized EBS to store repeated data and overcome failure by using Snapshots
• Creating users and groups using Identity Access Management (IAM) and assigned individual policies to each group. Setup specific IAM profiles per group utilizing newly released APIs for controlling resources within AWS based on group or user.
• Responsible to create various Cloud Watch alarms that sends an Amazon Simple Notification Service (SNS) message when the alarm triggers. Created SNS notifications using S3 events for object loss notifications.
• Creating S3 bucket for backups using versioning enable and moved objects to Amazon Glacier for archiving purpose and using Amazon S3 for database backup regularly and save snapshots of data
• Coordinate with other product managers, designers, and engineers to ensure a cohesive overall user experience.
• Involve in formal product development processes by working with product development team to provide guidance, clarification and direction. Primary point of customer communication and interface. Monitored program budget, program timing, product design and manufacturability, and other program deliverables.
• Create and manages open issues lists and conducts open issues meetings with team members and customers.
• Played a key role in migrating the existing on premise applications to the AWS VPC.
• Responsible for creating Well Architected applications on AWS using Auto scaling, Lambda, SQS, SNS, ELB, Caching and Database layer as necessary.

Environment:JIRA, TFS 2012, MS Test Manager, SQL Queries, JavaScript, MS Office, AWS.

Confidential, Richfield, MN

Business Systems Analyst/QA

Responsibilities:

• Design and Development of QA documentation like Test Cases and Test scenarios from business and functional requirements. Extensively worked on power center tools like Designer, workflow monitor and workflow manager to monitor and schedule sessions and workflows.
• Identified the requirements and arranged peer reviews, walkthroughs and sign off meetings.
• Actively participated in creating requirements Traceability matrices and Test plans.
• Experience in manual testing which involves web-based application testing for provider and claims system.
• Promoted Informatica application releases from development to QA and to UAT environments
• Written test cases for checking the populated data correctly into fact and dimension tables.
• Created Test Case documents in MS Excel template from the Test Plan and the Business Requirements documents. Tested the ETL mappings from Source to Target.
• Designed policies, standards and procedures for testing life cycle for the data warehouse and data marts.
• Prepared test cases by understanding the business requirements Data Mapping documents and technical specifications. Extensively used SQL Queries to verify and validate the Database Updates.
• Used TOAD Software for Querying ORACLE. And Used Teradata SQL Assistant for Querying Teradata
• Responsible for different Data mapping activities from Source systems to Teradata
• Extensively used Informatica power center for extraction, transformation and loading process. Implemented manual automated test scripts for Risk Warehouse decision support system using HP Quality Center.
• Extracted Data from Teradata using Informatica Power Center ETL and DTS Packages to the target
• Coordinated with development team in system integration test and services level unit testing.
• Used HP Quality Center 9.0 for Test Estimation, Test Planning, Test Designing, Test Analysis, Test Execution, Defect Tracking and Test Result. Performed SQL validation to verify the data extracts and record counts in the database tables by writing complex SQL minus queries.
• Exported Manual Test Cases from MS Excel template directly to HP Quality Center and executed all the Test Cases in Quality Center with Pass/Fail/Blocked status. Extensively worked with backend activities for testing several reports developed by BI tools. Wrote several complex SQL queries.
• Prepared test requirements, test plan approach document and test cases.
• Performed Unit and functional testing for all the Mappings and Sessions. Tested Complex Reports in OBIEE functionalities like Slice and Dice Drill down Functions Cross Tabs Master/Detail and Formulae.

Environment: Informatica 9.1, HP Quality center 10.0, QTP 10.0,OBIEE10.1.3,Oracle 10g,Teradata V2R6, SQL server SSIS, SQL server SSRS, PL/SQL, Toad,XML, XSD, PERL 5.12.1, XML Spy, Flat Files, Excel, Ms PowerPoint, Autosys, UNIX, IBM AIX 6.1, Shell Scripting,Windows server

Confidential

Business Analyst/Scrum Master

Responsibilities:

• Worked with the business owners in collecting their specifications and analysis, partnered with the stakeholders to define, design, develop, test and implement solutions and creating requirements.
• Assisted the product owner to break EPICS into User Stories using INVEST Technique.
• Gathered, Analyzed, Classified and documented the requirements into BRD and Use Case documents.
• Elicited requirements by identifying participants, setting up meetings and responsible for documenting artifacts.
• Leading member in JAD’s and meetings to engage business associates and subject matter experts in business planning, business analysis and business requirements definitions. Facilitated Backlog grooming, daily scrum, sprint planning and sprint review meetings.
• Monitored the timelines, budget and target at each demo of potentially shippable product increment.
• Assisted the product owner to break EPICS into User Stories using INVEST Technique.
• Used Prioritization and Estimation techniques for better time management and deliver quality results.
• Helped the team to split user stories into tasks meeting the SMART criteria. Values of collaboration and agile principles and explained the team how important was to operate as a self-organizing entity.
• Applied Unified Modeling Language (UML) methodologies to design Use Case Diagrams, Activity Diagrams and Sequence Diagrams. Analyzed and translated information for management and IT teams.
• Removed impediments by keeping a track and worked with collocated and distributed teams to set goals and impact measurements that align with department and companywide strategy throughout the cycle..
• Used Prioritization and Estimation techniques for better time management and deliver quality results.
• Worked cross-functionally across Engineering, Design, Content-Acquisition and legal teams to ensure synchronization among all the relevant parties to ensure integrity.
• Generated Electronic Funds Transfer reports and escalates to support team in case of discrepancies in EFT’s.
• Generated insights from the reports the team received from the Business Intelligence team and presented recommendations to the Product Owner and the management for better decision making.
• Assessed the scrum maturity of the team and coached them to higher levels of maturity, at a pace that is sustainable and comfortable to the team and organization using a servant leadership style.
• Using various techniques such as ORID (Objective, Reflective, Interpretive, and Decisional), Silent Writing, and Satisfaction Histograms facilitated the Sprint Retrospective Meetings.
• Lead Research and gathered information regarding a business problem/ opportunity.
• Extracted data from Oracle database with MS Access, and performed SQL query, data analysis and verification. Assisted with user testing of features. Performed interface and integration and component testing, Sanity testing.
• Assisted in preparation of User Acceptance Testing (UAT), test plan, Test Cases, Testing Life Cycle schedules and implemented all the test scenarios with the help of QA Team. Calculated the team’s velocity and capacity, developed and analyzed the sprint burndown charts, sprint burnup charts to track the team’s progress and to forecast the team’s upcoming sprint and promote transparency.
• Developed reports using Tableau v7.0 to communicate information using graphs, charts and other info graphical solutions to the project team.

Environment: Agile-Scrum, HP-ALM v10.0, MS word 2010, MS Excel 2010, MS Power Point2010, Outlook 2010, Tableau v7.0, Minitab, MS Project 2010, SQL.

Confidential

Business Analyst

Responsibilities:

• Defined business requirements and analyzed the possible technical solutions.
• Prepared Business Requirement Document (BRD) from the elucidated requirements and helped the Product Owner and Development Team in making User Stories by using Three C’s.
• Managed and documented the change requests and implemented changes and updates for the new design. Created and maintained Requirement Traceability Matrix (RTM) to ensure all the requirements are fulfilled and all the test cases have been executed according to the proposed plan.
• Developed and implemented processes and tools for requirements gathering, analysis, planning, tracking and delivery. Designed and developed project document templates based on agile methodology.
• Provided mortgage origination support to end users for the web based application.
• Assisted project managers with the development of project schedules and develop requirements and preliminary design for client applications.
• Designed Use Case Diagrams, Activity Diagrams, and Sequence Diagrams, Use Cases, and web prototypes.
• Interacted with the developers to ensure that the requirements are clearly understood.
• Collaborated with the QA team to ensure adequate testing of software both before and after completion, maintained quality procedures, and ensured that appropriate documentation is completed.
• Validated the test cases and conducted UAT (User Acceptance Test)
• Created and maintained database objects. Created complex Stored Procedures, Triggers, Cursors, Tables, Views and SQL Joins and other statements for various applications, maintained referential integrity and implemented complex business logic using SQL.
• Created various reports using MS Reporting Services. Assisted in writing and optimizing complex SQL Queries.
• Analyzed the existing application programs and tuned SQL queries using SQL Profiler.
• Involved in writing scripts for the programs. Provided on-call support for various projects.
• Loading data from various data sources using MS Data Transformation Services.
• Interacted with developers on various aspects ranging from usage of utilities to SQL performance, test data and general trouble shooting. SQL performance tuning by modifying SQL or adding/changing indexes.
• Prepared the reports for the day-to-day as well as weekly/monthly purposes in various formats like MS Excel, PDF, and HTML. Wrote and integrated stored procedures to generate the reports.

Environment:SQL Server 2000, Sybase, DTS, Excel, MS Access 2000, ASP, MS SQL Reporting Services.