SUMMARY:

• Goal oriented professional with 8+ years of experience in eCommerce, Retail and Operations as a Sr. Business Systems Analyst working in collaboration with cross functional and self - organizing teams across various business areas to deliver cost-effective, high performance technology solutions to meet challenging business demands.
• In-depth knowledge and hands-on expertise in implementation of project life cycle in various phases and stages of Software Development Life Cycle (SDLC) in Waterfall, Agile (Scrum) and Hybrid (Waterfall-Scrum) methodologies.
• Knowledge of functional organizations, matrix organizations and projectized organizations along with understanding of projects like new initiatives, OPEX, CAPEX, In-house projects, vendor built projects and COTSS.
• Extensive knowledge and hands-on experience on Distribution Management Systems (DOM), Warehouse Management Systems (WMS), Order Management Systems (OMS) for Omni-Channel Retailers.
• Experienced in working with SME's from various business areas 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 (SEO), Call to Action (CTA), Customer Lifetime Value (CLV) and fulfillment.
• Possess knowledge on various marketing and PR concepts like marketing mix, 4P’s and 4C’s of marketing, Porter’s market forces, market segmentation and targeted marketing strategies.
• Proficient in the usage of the Salesforce Marketing, Salesforce Sales and Salesforce Servicing Clouds.
• Extensive knowledge and hands-on experience on Supply Chain Optimization, Distribution Management Systems (DOM), Warehouse Management Systems (WMS), Order Management Systems (OMS) for Omni-Channel Retailers.
• Proficient in working with procurement modules like SAP Ariba and Coupa Supplier Portals in a procure to pay model.
• Certified Google Analytics Professional with hands on experience on marketing tags, Google Analytics and AWS Quicksight.
• Knowledge and Experience on Lean Six Sigma Concepts like Define, Measure, Analyse, Improve and Control.
• Well-versed in identifying and creating plans to eliminate the Six Sigma identified kinds of waste which are Defects, Waiting, Over- Production, Transportation, Inventory, Motion, Extra-Processing and non-utilized talent.
• Proficient in preparing documents used throughout SDLC, such as Business Requirement Document (BRD), Functional Requirement Document (FRD), Software Requirement Specification (SRS) and Requirement Traceability Matrix (RTM).
• Experienced in converting requirements into wireframes, prototypes, mock-ups for developing UI/UX components.
• Proven skills in creating Unified Modeling Language(UML) Diagrams including Sequence Diagrams, Activity Diagrams.
• Experience in using different elicitation techniques for requirement gathering such as conducting JAD sessions, Requirement Workshops, Focus Groups, Document Analysis, Brainstorming, Prototyping, Survey/Questionnaire.
• Knowledge and experience in performing GAP Analysis, Cost-Benefit Analysis, Feasibility Study, Root Cause Analysis, SWOT Analysis and Impact Analysis for planning and execution of several business decisions.
• Facilitated various Scrum ceremonies such as Sprint Planning, Sprint Review, Sprint Retrospection, Daily Scrum and Backlog Grooming to improve the team’s performance and maximize value while focusing towards a Sprint Goal.
• Proficient in using Prioritization techniques (MoSCoW method, Kano method), Estimation Techniques (Planning Poker, T-Shirt sizing) in helping the Product Owner and the team to commit the Product Backlog Items (PBI) for Sprint.
• Assisted in gathering requirements and documenting them for mobile applications on the iOS and Android platforms.
• Assisted data architects in designing plans to perform ETL procedures for loading data into Enterprise Data Warehouse (EDW) from heterogeneous sources and design of Data Models. Experienced in preparing Data Mapping documents.
• Knowledge of Database concepts including Data Warehousing, Dimensional modeling, Relational Database Management System (RDBMS), Data Marts, OLAP operations such as Drill-Down, Roll-Up, Slicing, Dicing and Pivoting.
• Experienced in using SQL queries Joins, Unions, Group-by, Aggregate functions for data analysis and data validation.
• Worked with Business Intelligence (BI) team in creating custom reports and dashboards for data visualization.
• Demonstrated experience in using Microsoft Suite tools such as MS Visio, MS Excel, MS Word, MS PowerPoint.
• Participated extensively in User Acceptance Test (UAT), Black-Box testing, Smoke testing, Sanity testing, Load testing, Stress testing, Volume testing, Unit testing, Regression testing, End-to-End testing and Integration testing.
• Collaborated with QA Team in reviewing Test Procedures while creating and executing test cases, test plans and test scripts and efficiently prioritizing and managing defects using Defect Tracking Systems like JIRA, HP QC and HP ALM.
• Creative and aggressive self-starter attitude with integrative thinking skills, capable of forming and maintaining positive and productive working relationships with internal and external stakeholders.
• Successful as a team player with excellent problem solving, team building, decision making skills coupled with good communication skills to work in conjunction with DBA's, testers, developers and other team members.

TECHNICAL SKILLS:

Waterfall, AgileScrum, Waterfall: Scrum Hybrid

Management Tools: JIRA, MS Office, HP ALM, Rally, MS project, MS SharePoint, Manhattan DOM, WMS, OMS

SQL/PL: SQL, HTML, CSS, XML

Business Modelling Tools: M.S Visio, Mockup Screens, Balsamiq

Data Warehousing: Data Marts, OLTP, OLAP, Multidimensional Analysis, Data Mining, ETL, Slicing/Dicing, Drilldown/ Roll Up

RDBMS Databases: MYSQL, Oracle 9i and 10g(PL/SQL), Microsoft SQL server

Data Warehouse Tools: Tableau, QlikView, IBM Cognos, SSRS, Informatica, Data Stage, SSIS, SSAS

Testing Tools: HPQC, HP ALM, Load Runner

Business Skills: Change Management, Impact Analysis, JAD sessions, SWOT analysis, Project Planning, Scheduling and Budgeting, HLD, LLD, Business Process Modelling

Operating Systems: Windows XP, Vista, 7,8,10, Mac OS, Linux

Mobile Platforms: iOS, Android

PROFESSIONAL EXPERIENCE:

Confidential

Sr. Business System Analyst (Analytics)

Responsibilities:

• Contributed as a Business Intelligence and Analytics Specialist working on Analytics focused services in AWS like S3, EMR, Glue, Data pipeline, Athena and Redshift etc. to implement systems thinking and deliver business value in iterations.
• Worked closely with application SMEs and vendors to create and implement data extraction procedures from systems like SAP, MDM, SAS etc., to be integrated on to the Analytics Platform.
• Performed requirement elicitation and scoping with business and technical stakeholders, Facilitated JAD sessions, Interviews, Survey/Questionnaire and Focus Groups to elicit requirements with various stakeholders, for requirement elicitation
• Create Business and Technical documentation like BRDs, FRDs, UML, Flow diagrams, ER Diagrams etc.
• Facilitated and Participated in Scrum Ceremonies like Daily Standups, Sprint Planning, Backlog Grooming and Demos.
• Used tools like Tableau, Smartsheet etc., to build and maintain custom business, financial, operational and project reports and dashboards to provide daily, and weekly status updates to stakeholders and leadership.
• Used AWS Athena to perform data profiling and analysis to identify keys and relationships to design logical data models and table schemas by implementing ANSI SQL scripts.
• Developed use cases and performed Gap, Risk, and Cost-Benefit analyses to evaluate feasibility.
• Continuously applied systems thinking and process re-engineering concepts to help design cost effective Big Data Analytics and Workflow solutions to solve complex business analytics use cases in AWS Cloud.
• Developed end-to-end data mapping using AWS Glue to enable developers understand ETL rules for various stages in the integration process.
• Involved and Supported organizational change initiatives like Agile Transformation, Data Democratization, Data Governance etc.
• Planned and Co-ordinated platform roll out to Europe Middle East AND Africa (EMEA) AND Asia Pacific (APAC) regions
• Worked alongside scrum masters and product owners to prioritize the product features for delivery, translate requirements to user stories and plan releases in Jira. for slicing epics by vertical slicing and creation of user stories with INVEST criteria.
• Designed, developed and executed test cases and test plans using SQL Workbench, Tableau etc., for Load, System Integration and User Acceptance Testing and document test results in HP ALM.
• Reviewed and documented ad hoc change requests during project deliverables, communicate with the business and development leads to understand the impact of the change required,
• Assisted in deployments. Created and maintained support documents like Business Data Dictionaries, ER Diagrams, Release Notes, and end User Training manuals on Product Resource site.
• Analyzed competitive market strategies and technology trends to make recommendations on future product development or product enhancement. Communicated with the internal clients like Vans, The North Face etc. to understand their reporting needs including Consumer Buying patterns, Consumer Demographics, Store Traffic, Demand Chain Analytics, Omni Channel sales, Inventory, Customer Relationship Management, Loyalty and Customer retention to enable them to have a targeted marketing strategy and inventory planning.
• Identified data sources, open communication channels and negotiate timelines on successfully getting the data from the sources to the Unified Analytics Platform in an Agile environment.
• Made sure that the delivery timelines are on schedule for the identified use cases.
• Identified stakeholders for future brands to be on-boarded and open a communication channel with them to scope for their requirements.

Environment: : Agile, Jira, AWS, API Gateway, Dynamo DB, Redshift, Cloudformation, Datapipelines, EMR, ELB, Hadoop, GitHub, MS Visio, MS Project, Confluence, Microsoft Office 365

Confidential, Framingham, MA

Sr. Business Systems Analyst

Responsibilities:

• Applied the "As Is" and "To Be" process designs in order to identify any potential process gaps and as well as improvement opportunities.
• Conducted Requirement elicitation with various stakeholders, mostly business users and SME’s for understanding the business requirements.
• Collaborated with various business departments and IT through effective communication to develop business use cases associated with new project requests and associated workflows.
• Conducted requirement walk-throughs with key stakeholders using various methods like team demos, workshops during sprint planning and backlog refinement sessions.
• Drafted Business Requirement Document (BRD) for the specific business requirements and Functional Specification Document (FSD) capture the functional requirements.
• Assisted in implementing and maintaining large and complex project schedules using MS-Project.
• Involved in tracking and managing the complete working dependencies of Onsite and Offshore teams.
• Developed Strategy document to recommend approaches for organizational data strategic alignment.
• Involved in Forecasting; Release Planning; developing business cases for prioritizing the product road map features; defining the User stories and User Acceptance Criteria.
• Helped the team overcome technical barriers by creating and updating use case diagrams, Activity diagrams, Sequence diagrams, Data Flow Diagrams using MS Visio.
• Collaborated with the business stakeholders to elicit requirements for the Confidential Business Advantage mobile application on both iOS and Android platforms.
• Created Mock-Up screens for the UI for the iOS and Android applications.
• Worked on Calabash to test the applications built for the iOS and android platforms
• Performed Data profiling, data cleansing and Data Enrichment activities to ensure Data Quality.
• Applied business rules and complex transformations for the data transfer from the data sources.
• Actively assisted the product owner in prioritizing the product backlog as per the maximum business value, grooming User Stories in planning activities using INVEST criteria.
• Extensively used JIRA to record and maintain the artifacts such as Product backlogs, Sprint backlogs, user stories / Data stories, Impediments list, tasks, defects and issue tracking.
• Used MS- Sharepoint for documentation and collaboration.
• Created test plan to best understand test scenarios and structured documents with test case scenarios for developers.
• Maintained and created end-to-end testing strategy and enterprise wide test cases for Subject Matter Expert Testing (UAT), assisted in Systems Integration Testing (SIT).
• Assisted system architect in identifying required gateways through Amazon API Gateway.
• Used Quicksight to create dashboards and reports.
• Responsible to provide valuable insights to clarify opportunities and identify associated risks that require consideration to optimize the solution

Environment: Waterfall Scrum Hybrid, Jira, Amazon AWS, Amazon API Gateway, Dynamo DB, Amazon Kinesis Firehose, Amazon Redshift, Amazon Quicksight, Manhattan EOM, Microsoft Office 365,, Jenkins, Windows 7, HTML5, CSS3, JavaScript, Objective C, Bootstrap.

Confidential, Ada, MI

Sr. Business Systems Analyst

Responsibilities:

• Performed Document analysis, conducted interviews with Compliance team, monitoring team, and Executives to understand about As-Is state of PIM System and identifying sources.
• Conducted interviews with business owners and facilitated JAD, brainstorming sessions between business stakeholders through effective communication.
• Worked with the Transformation Management Office(TMO) to bring in a mindset of continuous improvement within the organization.
• Worked towards increasing, the transparency in the processes.
• Responsible for identifying, analyzing requirements and documented them by creating various artifacts such as

Business Requirement Document (BRD) and Functional Specification Document (FSD).

• Supported and assisted Product owner in capacity planning to determine the production capacity with respect to availability of onshore and offshore team members to meet the changing needs of the project.
• Responsible for creation of data flow diagrams, use case diagrams and documented them.
• Coordinated with system architect team in creation of logical, physical designs and Bus Matrix.
• Analyzed source database, identified cardinalities and created conceptual, logical data diagrams.
• Responsible for identifying different data sources and conducted data profiling using Informatica.
• Involved in identifying facts and dimensions and created data mapping document. Coordinated with database developer to create star dimension modelling and develop the target Database.
• Created Test Plans, Test Cases, and Test Scripts for all testing events such as System Integration Testing (SIT), User Acceptance Testing (UAT) and Unit Integration Testing.
• Responsible for slicing epics by vertical slicing and creation of user stories with INVEST criteria.
• Responsible for tracking requirements, tasks, defects and impediments resolution using CA Agile Central.
• Participated in scrum process including Daily Scrum Meetings, Sprint Planning Meetings and Reviews meetings and sprint retrospective and followed up on action items for continuous improvement.
• Coached team members on Agile processes. Maintained task board and produced daily burndown charts.
• Assisted the Scrum Masters and Product Owners in removing impediments and protecting team members from interruptions and distractions to maximize productivity.

Environment: Waterfall-scrum hybrid, UML diagrams, CA Agile Central, Visio, MySQL DB, Informatica, Sql, MS Excel, MS Visio. and Power BI.

Confidential, Richfield, MN

Sr. Business Analyst

Responsibilities:

• Lead the definition and documentation of business and functional requirements.
• Conducted user/stakeholder interviews and planning sessions.
• Provided best practice recommendations in the areas of Order Management System and CRM.
• Created Activity Diagrams, Sequence Diagrams using UML methodologies for easy understanding.
• Created requirement documentation; reviews with user representatives, recommended priorities and obtained user signoff.
• Analyzed present needs/recommendations and aided in preparing and presenting Return on Investments, business case proposals and Cost Benefit Analysis.
• Worked in conjunction with the team in assigning tasks with understanding of the complexity and priority of the task.
• Assisted the Product Owner in converting requirements from BRD into User Stories by conducting User Story sessions and prioritizing Product Backlog Items (PBI) using various techniques.
• Responsible for implementing, coordinating and documenting all business processes for (web based) Internet billing customers (EBPP).
• Implemented and supported Order Management System by defining and validating requirements relating to OMS and developing process flows to define functionality across the systems.
• As a Scrum Master, implemented Scrum Practices while handling team and facilitated Scrum Ceremonies like Daily Scrum, Sprint Planning Meeting, Sprint Review Meeting and Sprint Retrospective meeting.
• Tracked team’s velocity and progress during a Sprint using Sprint burn down chart and Release burn down chart.
• Helped the team in estimating the complexity of the user story by using Planning Poker and T-Shirt sizing techniques.
• Assisted Business Intelligence (BI) team in creating dashboards using Tableau as required by the end users.
• The effort involved developing extensive SQL Queries and Procedures, utilized to perform database integrity testing, ensuring various data table entries, data validity, and data integrity.
• Performed logical data modeling and created ER diagrams and used SQL queries for managing database.
• Prepared Requirement Traceability Matrix (RTM) report to ensure that every Business requirement is adhered to achieve the expected performance.
• Involved with the Software Quality Assurance (SQA) Team to develop Test plans, execution of Test Cases and logged the defects for failed test cases using HP Quality Center.
• Assisted in deletion of defects and bugs, to meet requirements and deadlines for successful execution of project.
• Played a key role in the planning and performing User Accepted Testing (UAT) along with business users

Environment: Scrum, HP ALM, Tableau, Microsoft SQL Server 2012, Mock-Up Screens, GAP analysis, UML, UAT Testing, MS Office Visio, PowerPoint, Word, Excel, Project .

Confidential, Columbus, Ohio

Sr. Business Analyst

Responsibilities:

• Worked on a multi-system integration project that involved a major data migration from existing sources.
• Functioned as the primary liaison between the business line and technical areas throughout the project life cycle.
• Worked with the Business owners & Stakeholders and business users in identifying the business requirements.
• Involved in all phases of SDLC-Waterfall methodology in conjunction with architects, developers and testers to collaborate resource allocation and project completion using MS Project.
• Conducted JAD sessions as a facilitator to gather requirements from the business area and with IT group.
• Performed Requirement Analysis by gathering both functional and non-functional requirements based on interactions and document analysis, and represented them in Requirements Traceability Matrix (RTM).
• Used MS Visio to design Activity Diagrams, Sequence Diagrams that effectively communicates business requirements using Unified Modeling Language (UML) diagrams.
• Created data mapping document by performing data analysis and traceability mapping.
• Addressed all aspects of the loan life cycle, starting from identifying a prospective client to the loan closure
• Worked closely with developers in creating Data Models with fact and dimension tables using snow-flake schema.
• Handled several SQL queries by involving in data integrity testing and manipulating the data in Data Migration.
• Identified system interfaces and created the requirements specification document and assisted in developing test plans and test cases using HP-ALM.
• Assisted in ETL process to map source data and ingest data into target staging and target database.
• Performed task decomposition, delegated tasks and monitored project milestones using MS Project.
• Created test cases and test scripts Conducted User Acceptance Testing (UAT), Unit testing and System testing.

Environment: Waterfall, JAVA, Oracle, UML, Test Director, VB, .NET, Windows 2000, UNIX, Microsoft Office suite, MS Visio, MS Project, HP ALM, SQL server 2005.

Confidential

Business Analyst

Responsibilities:

• Interacted with stakeholders and elicited requirements by conducting user interviews and JAD Sessions.
• Analyzed and documented requirements gathered and authored Business Requirement Document (BRD), Functional Requirement Specification (FRS) for application development.
• Planned and organized requirements review and inspection sessions with SME’s, Project Managers and end users.
• Authored progress and completion reports, which were then submitted to project management on a weekly basis.
• Involved in reviewing and evaluating teams Service Level Agreement (SLA) on weekly and monthly basis.
• Assisted the team in performing testing on the data integrity, verifying table entries in data validity.
• Analyzed the requirements to understand business operational risks and create process flows.
• Had constant interaction with developers on Service Oriented Architecture (SOA), Web Services (SOAP, WSDL).
• Involved in performing Client-Side validation and Server Side validations in ensuring login functionality.
• Participated in identifying sources of data for creating Geodatabases and Attribute Tables.
• Involved in developing SQL Queries and Procedures.
• Provided updates to the Project Manager regularly on the status and progress of the tasks.
• Interacted with the upper level management on status reporting, schedule control, client/project team coordination.
• Worked with the Dev team and gathered requirements to develop the Confidential mobile application for Android and IoS platforms.
• Ensured requirements compliance and testing using Requirement Traceability Matrix (RTM).
• Used HP Quality Center for creating and executing test cases, for defect tracking and for generating reports.
• Documented Test Plans that contains test scripts, test cases, test data and expected results for the Integration, Functional, Performance, and User Acceptance Testing.

Environment: MS Visio, MS Office 2007, HTML/CSS, JavaScript, My SQL Server, HP QC, Waterfall, SOA, SOAP, WSDL

Confidential

Business Analyst

Responsibilities:

• Involved in all phases of SDLC, including requirement gathering, analysis, design, development, and implementation.
• Assisted the project manager/ lead in defining the vision, project plan, charter, scope and timelines.
• Facilitated JAD sessions to embrace a problem’s dimensions, possible causes, to propose alternative solutions.
• Performed requirement analysis by gathering both functional and non-functional requirements based on interaction with the process owners & SME's.
• Created and use case documents and uploaded the documents in Knowledge Link.
• Analyzed business requirements and segregated them into high level and low level Use Cases using UML.
• Worked with designers and developers for interpreting requirements, tracking the requirement & timeline.
• Monitored client expectations through client involvement and communication throughout the lifecycle of the project.
• Organized Daily/Weekly Review Meetings with PM, Development team/SQL DBAs team for smooth migration of the Historical databases.
• Involved in UAT, test plans, documentation of test reports, etc.
• Performed Functionality, Integration, GUI, Regression, Usability and System testing.
• Created document for data flow to support the project once it implemented in production and mapped new functional and business requirements.

Environment: MS Visio, MS Office, MS Project, SQL Server 2008R2, Knowledge Link, HTML, SQL, Windows OS 2008/XP.

Confidential

Jr. Business Analyst (Intern)

Responsibilities:

• Interacted with end users to gather Requirements. Created technical, user documentation.
• Created new Database Objects like Procedures, Functions, Triggers, Indexes and Views using T-SQL in SQL Server.
• Designed and developed SQL SSIS Packages to extract data since 2005 from various data sources such as Access Database, Excel Spreadsheet, and Flat Files into SQL server for further Data Analysis and Reporting by using multiple transformations provided by SSIS such as Data Conversion, Conditional Split, Bulk Insert, merge and union all.
• Good experience in Installing, Updating, Configuring and Maintaining various databases for Production, Development and Testing using SQL Server with latest Service Packs.
• Using Checkpoints in packages to enable the package to run from the point of failure.
• Identified and worked with parameters for parameterized reports.
• Developed reports using SSRS and published as PDF, Excel, and CSV formats.

Environment: MS SQL Server 2005,2000, T-SQL, DTS, Microsoft Visual SourceSafe 2005, MS Access 2002, Flat files, SQL Server Integration Service, Windows 2003 Server++