SUMMARY

• Versatile, effective professional with 8+ years of IT Experience in conceiving, developing and implementing cutting edge solutions in Software Development Life Cycle (SDLC), Product Development Cycle (PDLC) and Agile environments. Seasoned technical solution provider, with an intuitive sense of end - user requirements.
• Keen relationship builder, tech savvy team leader, and engaging communicator. Detail oriented professional with proven leadership and experience in Project management, Functional and Business Analysis with specialization in Supply Chain, Retail and Digital E-Commerce.
• Competent experience from working on different phases of Software Development Lifecycle (SDLC) and Product Development Life Cycle (PDLC) utilizing the Waterfall methodology, and Agile methodologies like SCRUM, Kanban and Waterfall-Agile hybrid. Have a sound understanding of Scaled Agile Framework (SAFe)
• Experience in strategic sourcing, strategic planning, resource management, procurement and sourcing in the supply chain of projects using tools on cloud such as Maximo and SAP Ariba
• In depth understanding of the Gap Analysis i.e., As-Is and To-Be business processes and strong experience in gathering requirements and converting these requirements into Technical Specifications documents
• Possess expertise in tracing requirements throughout the development process and verifying adherence to Requirement Traceability Matrix (RTM) using tools such as Excel and Rational Requisite Pro. Performed Cost benefit analysis, and SWOT analysis to obtain clarity on requirements
• Experience in creating Business Requirement Documents (BRD), Functional requirement Document (FRD), Functional Specification Document (FSD), Use Case Narratives & Use Case Diagrams among others
• Strong analysis, communication and training skills with proven leadership and ability to work as the primary interface between Business partners and Developers/SME’s/Architect/UX team
• Extensive experience facilitating requirement gathering workshops such as brainstorming, focus groups, and interviews, helping team transition smoothly from divergent to convergent thinking preventing analysis paralysis
• Working knowledge in data warehousing concepts, Data Marts, Operational Data Stores and ETL Tool - IBM® WebSphere® Application Server & Informatica Power Center. Worked extensively with Data warehouses by migrating data from various OLTP’s to OLAP cube using the Informatica Power Center suite
• Strong understanding of Multi-Dimensional Database schemas like Star, Snowflake, Fact Constellation Schema; Fact and Dimensional tables
• Vast experience in creating Mockups and Wireframes using tools such as MS Visio, Mockup Screens and Balsamiq to communicate my understanding of requirements to development and UI teams, for e-commerce apps
• Experience in creating SQL Queries in SQL Server including DDL and DML, with a strong understanding of data & analytics; creating and requesting the updates of data dictionaries
• Experience in documenting and executing quality Test Plans, Test Cases, and verifying and validating complex scenarios for quality purposes including User Acceptance Testing (UAT), Blackbox testing, Whitebox Testing, Regression testing, Load & Spike testing
• Involved in reviewing and analyzing various test metrics including process and product metrics such as Test Design Coverage, Test Execution Productivity, Test Execution Coverage, Test Cases passed, Test Cases failed, Error Discovery rate, Defect Fix Rate, Defect Removal Efficiency
• Collaborated with QA team in performing automated testing using tools such as Selenium, Cucumber, HP UFT
• Extensive experience in creating SQL reports, graphical interactive UI and dashboards using QlikSense, Power BI and Tableau from multiple data sources like SQL, Oracle and flat files like JSON, CSV, Excel
• Well acquainted with Unified Modeling Language (UML) diagrams including Use Cases, Activity, and Sequence diagrams therefore assisting in Business Process Modeling, using tools such as MS Visio, Balsamiq etc.
• Expertise in graphical representations for Reporting, Visualizations and Project Management, creating meaningful insights on Key Performance Indicators (KPI’s), using tools such as Tableau, Power BI etc.
• Excellent technical skills with, Oracle - Advanced Benefits, SAP - Ariba, Informatica Power Center, Exact Target, SQL Navigator, Jira, Confluence, SharePoint, HP ALM, LEAN manufacturing & Six Sigma
• Experience in documenting tags of REST and SOAP UI and involved in API testing using Postman

TECHNICAL SKILLS

Methodologies/Environments: Waterfall Methodology, Agile Methodology, RUP-Rational Unified Process, Scrum

Version Control: Rational Clear Case, Visual Source Safe

Requirements Management: Microsoft Office, Jira, Confluence, HP QC ALM, TFS

Change Management: Rational Requisite Pro, Clear Quest, Test Director.

Modelling Tools: Rational Rose, ERwin, MS Visio, Mockup Screens, Wireframes, Balsamiq

Testing Tools: HP QC ALM, HP LoadRunner, Selenium, HP UFT, Postman

RDBMS and Databases: MS Access, MS SQL server, Oracle Database, IBM Db2, Sybase SQL Server

Languages: C, C++, Java, JavaScript, XML, UML, SQL, HTML, JSON

Operating Systems: Windows Family, Familiar with UNIX, LINUX, and MAC

Office Tools: MS - Word, Excel, PowerPoint, Visio, Outlook, Office 365

Project Management: Microsoft Project, Microsoft Office, Smartsheet, MS Visio

Reporting Tools: IBM Watson Analytics, Tableau, Power BI, Crystal, IBM Cognos, MicroStrategy

Other Tools: Informatica PowerCenter, SharePoint, SAP - Ariba, Confluence

PROFESSIONAL EXPERIENCE

Sr. Business Systems Analyst

Confidential - Austin, TX

Responsibilities:

• Conduct meetings with Subject Matter Experts to identify business needs and set up walkthrough meetings with Business Users and Directors
• Working with MS Word, MS Excel, MS Project, MS Visio for documentation and analysis reports among other project management and reporting tools
• Driver behind the elimination of the supplier Code of Conduct Compliance (CoC) issues as well as the Universal Device Identification (UDI) regulation adherence issues
• Document analysis and represent them in Requirements Traceability Matrix (RTM) using Requisite Pro
• Maintain project documents and share important links and tutorials, etc. with the team using SharePoint
• Create User Requirement Specifications (URS) and Functional Requirement Specifications (FRS) documents after consultation with the stakeholders involved using elicitation techniques like interviews, and focus groups
• Design Use Case Diagrams and wrote their specifications in the Use Case Specification documents using UML/Visio based on the requirements gathered
• Direct several mission critical updates like Db2 on cloud upgrade, file system upgrades, DLL installations, disaster recovery testing etc.
• Provided detailed information about business data, such as standard definitions of data elements, their meanings and allowable values using Data Dictionary
• Performed data mapping using Infomatica PowerCenter 8.6, validated connection objects and target writing path of the concerned warehouse with the help of proper naming conventions
• Proficient in design and development of various dashboards, reports utilizing Tableau Visualizations like bar graphs, line diagrams, pareto charts, funnel charts, scatter plots, pie-charts, donut charts, bubble charts, funnel charts, heat maps, tree maps according to the end user requirements
• Discuss table design, data flow, data migration, ETL processes, reporting via Tableau, & consequently discuss with development team requirement details
• Involved in UAT and post-production support by creating a checklist to ensure close to 100% coverage
• Experience working with remote monitoring of assets using the IBM Maximo Asset Management tool on cloud
• Supported QA Team in executing the Test Plans, Test Cases, Test Scenarios and collected the Test and Process Metrics. Also, assisted with writing manual testing scripts throughout the SDLC and PDLC
• Utilized Manual testing methodologies using HP QC ALM to check validity of existing data within the databases and also to protect the system from SQL Injection Attacks. Assisted in writing Test Scripts to check load capacity and spikes using Load Runner
• Developed numerous Reports / Dashboards with different Analytics Views (Drill-Down / Dynamic, Cascading Style Sheets, Pivot Table, Column Selector, Tabular with global and local Filters) using Presentation Services
• Supported the cloud implementation of Ariba Contract Management, Contract Compliance, Sourcing, SLP and Guided Buying modules
• Involved in create, read, update and delete operations within SAP - ERP 6.0 ecosystem related to purchase orders, sales orders, work orders, transfer orders
• Created value stream maps to reduce wastage and get business processes as close to ideal as possible

Environment: Waterfall-Agile, MS Office, MS Project, MS Visio, MySQL, IBM Db2 10.5 on cloud, Postman 4.8, Informatica PowerCenter 9.6.x, Tableau 8.3.11, IBM Websphere, Apache Tomcat, IBM Maximo 7.6, Rational Requisite Pro, HP ALM, Load Runner, SAP - ERP 6.0, SAP - Ariba, HTML, XML, Jira 7.2.4, Twilio 2.0.0

Sr. Business Analyst/Scrum Master

Confidential - Milwaukee, WI

Responsibilities:

• Assisted Product Owner in release level, sprint level and product backlog economics with respect to supply chain
• Improved the product backlog incrementally and reviewed it with Product Owner during sprints
• Multi project experience on Ariba Spend Management Suite - Ariba Buyer, Ariba Sourcing, Analysis and Contracts Workbench
• Helped visualize business goals in the form of success indicators & KPI’s which included order fulfillment rates, on-time delivery, PO item fill rate, PO quantity fill rate, GM return on investment etc.
• Helped create wireframes for UI / UX requirements with direction from Product Owner and Presentation Layer from JAD sessions
• Assisted teams achieve cross-functionality and self-organization by promoting collaboration
• Enhanced the flow of communication between stakeholders and acted as the point of contact for all incident tickets and test environment issues. Coordinate issue escalation and/or resolution, manage code installs, and manage security for respective environments
• Involved in the feature creation of Confidential ’s wallet, which is a Point of Sales (POS) payment gateway and Card management system within the digital mobile application
• Responsible for writing effective user stories using INVEST criteria, creating personas and splitting into tasks using the SMART criteria and defined the Acceptance criteria. Helped the team in estimating stories using techniques Planning Poker and proficient in prioritization techniques like MoSCoW and KANO based on the business needs prevalent during that season. Expert at performing various retrospective techniques as well
• Developed & maintained Requirements Traceability Matrix (RTM) tracking end-to-end mapping of system specifications and test cases ensuring 100% coverage
• Created, assigned, and maintained tickets in Jira for issues, bugs and defects so that these could be monitored systematically to its closeout. Also performed Issue Tracking in Jira to track impediments surrounding user stories and other dependencies. Also used the integrated Confluence for content manage and facilitating quicker releases
• Used Jira to create Sprint Burnup and Burndown Chart reports to present to relevant high-level stakeholders to identify the next courses of action regarding the release, supporting our supply chain
• Set up the reporting tools and monitored the reporting functions for the clients using MS Excel and Power BI
• Utilized SQL to probe data dependency issues and inconsistencies to safeguard against SQL Injection
• Assisted and communicated requirements with the team in Test Driven Development (TDD), Behavior Driven Development (BDD) which were used in test-centric development and daily standup meetings, ensuring quality standards were met as per the build-release schedule
• Involved in writing Feature Files in the Gherkins language for Cucumber testing and have experience and collaborated in the Cucumber - Selenium integrated automated testing environment for BDD
• Assisted the team in writing user stories by clearly articulating each Acceptance Criteria written in the Gherkins language. Constantly re-iterated how each user story relates to the final Definition of Done (DoD)
• Created Master Test Plan, Test Scenarios, Test Cases, and Test Scripts and performed facilitated User Acceptance Testing (UAT) collaborating intensively with the quality assurance team
• Involved in API documentation and testing using Swagger, provided guidance and review for SOA implementation its deployment and management. Integration based on XML / JSON data representation using SOAP / REST Services or orchestrated services

Environment: Agile, Apache Hadoop, HDFS, Apache Hive, Apache Kafka, Jira 6.2, SQL, MS Office, MS Project, Selenium, Cucumber, Power BI, Jira 7, SAP - Ariba Spend Management Suite

Sr. Business Analyst

Confidential - Boston, MA

Responsibilities:

• Accomplished experience through whole SDLC from requirement analysis till deployment
• Wrote SLA and negotiated terms of contract that ensure quality of service and cost savings
• Created and tracked schedules to ensure deliverables are met throughout the SDLC and PDLC
• Developed non-functional and functional requirements documents like BRD, FRD, and SRS
• Created need analysis documents of the requirements gathered through JAD, Brainstorming and interviews sessions using Rational Requisite Pro
• Driver behind various project management related activities such as scheduling, budgeting, resource allocation, value stream mapping and business process reengineering in order to reduce wastage and to get business processes as close to ideal as possible
• Coordinated and managed business analyst resources work queue to ensure project timelines are met to produce builds as per the requirements using MS Project
• Actively involved in Advanced Planning and Scheduling (APS) including production scheduling, distribution planning and transportation planning
• Worked on Accounts Receivables, Accounts Payables, cash management, asset management, supplier management using the SAP ERP - Ariba integrated modules
• Provided Systems Consultant functions such as managing change requests across the systems development life-cycle (SDLC), building and managing client business user relationships in a highly dynamic work environment
• Participated in the Change Control Board to identify the impact of the change, collaborate and come to a consensus as to its feasibility and risks involved chartered documents on the appropriate next steps
• Did root cause analysis to identify data quality problems and obtain historical trends
• Created Physical architecture diagrams from Conceptual architecture diagrams using the Erwin tool
• Involved in the maintenance and timely updates of Data Dictionary
• Extensive experience in UAT testing and post - production support by creating a checklist to ensure close to 100% requirements coverage
• Worked proactively with the DevOps team in performing Impact analysis, Cost Benefit analysis, and capturing Risks in Risk Registers and mitigating using Risk Mitigation Strategies
• Build rich and dynamic dashboards using out-of-the-box features, customizations, visualizations and advance functionalities like Groups in calculations, Cluster analysis, Cross Database joins etc. in MicroStrategy

Environment: Waterfall, Erwin 9.5, Rational Requisite Pro, Oracle 11g, MS Office, MicroStrategy 9.5x, Oracle NetSuite, SAP - ERP, SAP - Ariba

Business Systems Analyst

Confidential - Greensboro, NC

Responsibilities:

• Organized, set up and facilitated JAD sessions, and functional design review meetings
• Provided assistance with creating process flow and data flow diagrams. Assisted architects in the creation of Physical and Logical architecture diagrams by clearly communicating requirements
• Updated business specification documentation based on updates to functionality of the systems
• Collaborated with Program manager, Product Management to revise User Acceptance Criteria and change management plan by integrating the insights from focus groups and impact analysis. Facilitated UAT sessions to demo features and functionalities with the end users and obtained feedback
• Reviewed the Data Models and updated Data Mapping Documents as needed
• Acted as an agile champion imparting agile values, initiating new ideas, analyzing market trends and preferences, and creating holistic user stories for implementing better product features
• Performed SQL data validation for the data integrity in the back-end systems
• Worked closely with Product management and Program manager in designing the change management plan using Rational Clear Quest and analyzed impact, incorporated feedback from business focus groups
• Designed and created business dashboards by using Tableau to extract key insights such as resource utilization and changes in inventory levels
• Performed GAP analysis to derive requirements for existing system enhancements
• Involved in writing Feature Files in the Gherkins language for Cucumber testing and have experience and collaborated in the Cucumber - Selenium integrated automated testing environment for BDD
• Requested updates and was actively involved with Data Dictionary maintenance
• Designed the Use Case Diagrams and coordinated with multiple resources in creation of Activity Diagrams and Sequence Diagrams using MS Visio
• Worked with QA team to prepare master test plan, test strategy, test cases, and test scripts to perform functional testing, black-box testing, GUI testing, system testing, performance testing, stress testing, sanity testing, regression testing, and supported user acceptance testing (UAT)

Environment: Agile (SAFe), MySQL, Hadoop, Apache Flume and Scoop, Apache Spark, Apache Tomcat, Cucumber, Selenium, XML, HTML, JSON, HTTP, REST API, MS Visio, Load Runner, Tableau 7.0.12, MS Project

Business Analyst

Confidential

Responsibilities:

• Identifying customer inputs, activities and release calendar
• Estimating cost/effort, forecasting defects, and managing uncertainty. Streamlined project management practices, eliminated role confusion and ensured tasks are not overlooked by creating RACI matrices
• Documented the Traceability Matrix for tracing the Test Cases and requirements related to them
• Led and innovated in the expansion of the group's use of issue tracking system Jira 5.0
• Used SharePoint for uploading project deliverables and maintaining the documents
• Was responsible for handing requirement churn, by successfully transitioning from longer release cycles to shorter ones, reducing risk and increasing flexibility to remain competitive
• Involved in technical writing, API documentation and end user manuals and documentation using MS Office Suite (Word, MS Access, Excel, Power point)
• Involved in Regression Testing every new build in UAT, QA and Pre-Production Environments
• Assisted QA team in Unit, Integration, and Regression testing to validate report and mapping functionality
• Extensively worked in Data Requirement Analysis and Data Mapping for ETL process using the Informatica PowerCenter Suite including modules like Analyzer, Workflow Monitoring, and Workflow Designer

Environment: Agile, Jira 5.0, Informatica PowerCenter 9.0.x, HP ALM, HP QTP 11.0, Oracle 10g, Crystal

Business/Data Analyst

Confidential

Responsibilities:

• Conducted requirement gathering with end users and converted them into business specs and developed the specs into application design and development throughout the PDLC
• Conducted Gap Analysis to check the compatibility of the existing infrastructure with the new Business Requirements that helped provide key insights
• Performed data analysis, data cleansing and presented results using SQL, SSIS, Excel
• Created Project Plan, Critical Path, and Gantt Chart using MS Project
• Assisted in the construction of Logical models and Entity Relationship Design using ERwin
• Worked as a unit BA lead with Data Warehouse team for transferring information between the business, developer, data modeler and testing team
• Interacted with third party vendors to help the company with mission critical applications
• Performed basic DML and DDL Queries to probe and perform CRUD operations on the existing database under supervision of Lead Developer
• Created SSIS packages to load data from Oracle to SQL Server using various transformations in SSIS
• Created different report views like Table, Pivot, Graph, Narrative, Static, Filter for testing purpose

Environment: Waterfall-SDLC, Oracle 10g, Microsoft SQL Server, SSIS, MS Office Suite, Erwin 8, MS Project

SQL Developer

Confidential

Responsibilities:

• Developed Use Case diagrams, business flow diagrams, Activity/State diagrams and Sequence diagrams using Rational Requisite Pro so that developers and other stakeholders can understand the business process
• Established Traceability Matrix using Excel to trace completeness of requirements in different SDLC stages
• Involved in requirements gathering of the work streams by meeting with the business user and baselining details
• Evaluated POS in regard to establishing stores across the country by 2015
• Wrote basic SQL queries for retrieving data from Database using Microsoft SQL Server
• Used SQL queries to modify the application with different data sets
• Experienced in Data ETL using various tools such as SQL Server Integration Services (SSIS)
• Assisted SQL Lead in using SQL Server Profiler that aided in profiling server resource usage and optimization

Environment: Waterfall, Windows, Microsoft SQL Server, SQL Server Profiler, Visual Studio, SSIS, Crystal