PROFESSIONAL SUMMARY:

• Experience in analyzing, designing, managing, implementing, and testing software products/projects. Involved in Business Process Re - engineering, Business Process improvement, elicitation, requirement analysis, planning, monitoring, change management and validation using various tools and techniques
• Fluent in ecommerce platforms (Oracle ATG commerce), ERP systems (SAP), CRM (Salesforce), ETL tools (Informatica), Content Management Systems, Product Catalogue, Web Analytics (Google analytics).
• Solid Experience in Search Engine Optimization(SEO), e-commerce, m-commerce, Omni-Channel, and implementing integrated online marketing initiatives by using Social Media like Facebook Ads, Google Ads etc.
• Adept at performing GAP Analysis, Impact Analysis, SWOT analysis, Cost Benefit Analysis, and Feasibility study.
• Proficient in Software Development Methodologies like Waterfall, Scrum, Kanban, and Waterfall-Scrum Hybrid. Solid noledge of Extreme Programming principles, Rational Unified Process, and Spiral Methodologies
• Excellent understanding of Scaled Agile framework (SAFe) and Scrum framework including Scrum Roles and Scrum Artifacts. Facilitated Scrum ceremonies like Daily Scrum, Sprint planning, Sprint review, and Retrospective. Used several Prioritization (MoSCoW, Kano) and Estimation techniques (Planning Poker) in backlog grooming sessions
• Proficient in networking with individuals at various levels while organizing, conducting, and facilitating elicitation sessions like Interviews, Brainstorming, Focus groups, Requirement workshops, and JAD sessions
• Elicited requirements using techniques like Surveys/ Questionnaires, Document Analysis, and Interface Analysis
• Skilled in converting requirements gathered to standard documents like Business Requirement (BRD) and Functional specification (FSD) Documents. Prepared Use Case Models, User Stories, and Data Flow Models.
• Skilled in creating prototypes like Screen Mockups and Wireframes. Proficient in developing UML models like Use case diagram, Activity diagram, and Sequence diagram with a solid understanding of Class diagrams.
• Skilled in analyzing and maintaining triple constraints in a project. Expert in handling change requests and analyzing impact of the change, creating impact analysis report, and processing it through change control board(CCB)
• Solid background in Supply Chain Management, Inventory Control and Management, Quality Management, and Risk Management. Hands on experience of project management techniques like PERT and CPM.
• Experience in cloud computing with a solid understanding of Amazon Web Services (AWS). Experience in creating AWS EC2 instances, Auto scale, EBS, Amazon RDS, Amazon Redshift, Auto scale, EBS, Cloud watch.
• Performed CRUD operations on databases using DDL, DML, and DCL along with joins, and stored procedures.
• Well versed in Data Warehousing concepts like OLAP, OLAP Cube, Conceptual modelling, logical modeling, Star Schema, Snowflake schema, Facts, Dimensions, Measures, Top-down and Bottom up approaches.
• Proficient in creating Data Mapping Specification document, Entity Relationship (ER) models, and dimensional models. Assisted in data profiling, data cleansing and data validation in Data Warehouse projects
• Used NO SQL to maintain constantly changing product catalogue information in NO SQL databases
• Skilled in Quality Control (QC) activities like developing and reviewing Test plans, Test Scripts, and Test Cases. Created Requirement Traceability Matrix (RTM) to make sure that all the requirements are tested. Involved in Test Execution, Issue tracking, Issue Resolution, and Report Generation
• Experienced in supervising and assisting in Black Box Testing, Functional Testing, Integration Testing, System Testing, Regression Testing, Performance Testing (Load/Stress), and User Acceptance Testing (UAT).
• Experience in preparing and documenting the User Acceptance test (UAT) plan, UAT test cases and obtaining the necessary signoffs from the concerned business units.
• Expertise in developing documents for different web services like SOAP (WSDL, XML) and REST (XML & JSON) under various architectures like Three-Tier Architecture and Service Oriented Architecture(SOA)
• Good understanding of software development best practices in Extreme programming(XP) such as Test-Driven Development (TDD), Behavior Driven Development (BDD), and Acceptance Test Driven Development (ATDD).
• Involved in training of end users and documenting training manuals for end users.
• Experience handling multiple projects in a fast-paced cross functional environment, Efficient team player with strong leadership skills, excellent interpersonal skills and strong verbal and written communication skills.

TECHNICAL EXPERTISE

Business Modeling Tools: MS Visio, Lucid Chart, Balsamiq

Requirement Management Tools: CA Agile, JIRA, TFS, HP ALM, Version One

Documentation Tools: Microsoft Word, Microsoft Power Point, MS SharePoint

Project Management: MS Project, MS SharePoint server, Confluence

Databases: My SQL, SQL server 12.0, Oracle DB, Dynamo DB, Mongo DB

ETL tools: Informatica Power center, Data Quality, and Informatica MDM

Reporting Tools: Tableau, IBM Cognos, Google analytics

Testing Tools: HP QC, Cucumber, Selenium, Load Runner, SOAP UI

Programming languages: PYTHON, C, JAVA, R, JULIA, UNIX, SQL, NO SQL

ERP/CRM: SAP R/3 ECC 6.0, S/4 HANA, Salesforce

Cloud: Informatica Cloud, AWS

Domain (e-commerce): Order management, Supply chain management, Warehouse management, O2C (B2B & B2C), P2P, Inventory management, CRM, SEO

PROFESSIONAL EXPERIENCE

Confidential, Richfield, MN

Sr. Business Systems Analyst

Responsibilities:

• Elicited business requirements from business owners, users, and Subject Matter Experts (SME’s) using various elicitation techniques like Interviews, Brainstorming, Focus groups, Requirement workshops, and JAD session.
• Performed Document Analysis, Interface Analysis, and Interviews to understand AS-IS business process and documented the TO-BE business processes by conducting GAP Analysis to identify the gaps.
• Created RACI Matrix to identify, categorize, and manage all relevant stakeholders in the project.
• Gathered functional and non-functional requirements and documented them in a Business Requirement Document.
• Participated in User Story Writing Sessions to decompose BRD into User Stories and write Acceptance Criteria
• Conducted Feasibility Study to study the feasibility of cloud computing for migrating into cloud and explored various cloud computing options. Assisted in configuring AWS instances, Auto Scale, EBS and Cloud Watch alarms. Worked closely with the system architects to develop logical architecture diagram for the system.
• Worked on Content Management System and assisted in consolidating Product Catalogue for various channels.
• Worked on Order Management Systems(OMS), ERP systems and Customer Relationship Management (CRM)
• Created Mockups and Wireframes to create throw away prototypes of Graphical User Interface (GUI)
• Created Use cases and UML models like Use-Case diagram, Activity diagram and Sequence diagrams in MS Visio.
• Involved in API technical writing for both SOAP and REST. Documented XML and JSON request and responses.
• Generated web analytics reports using Google Analytics to understand the funnel conversion rates.
• Assisted in creation of data models, as a part of development of dynamic content determination and targeting system.
• Responsible for writing Feature Files in cucumber for which the QA writes step definition file.
• Worked with the Quality Assurance team in validating Test Plan, Test Scenarios, and Test cases.
• Aided in development of UAT test plans and worked with UAT team to clarify BRD.
• Conducted User Acceptance Testing (UAT) with stakeholders and system users to uncover latent defects in the system. The defects were corrected and verified through a new cycle of regression testing
• Executed View SQL queries with different Where Clauses to create specific views for reports.
• Used NO SQL to maintain constantly changing product catalogue information in Dynamo DB
• Developed and maintained quality procedures and ensured that appropriate documentation was in place.
• Used JIRA for issue tracking, user story management and requirement traceability and Confluence for repository management and collaboration.

Environment: SCRUM, JIRA, Confluence v5.9, MS Visio, MS Project, Tableau v9.0, XML Copy Editor, REST API, Cucumber, Jenkins v2.4, HTML5, CSS3, JavaScript, Java EE 7, Microsoft Excel, Microsoft PowerPoint, Microsoft Word, Selenium IDE, Selenium Web driver, AWS EC2, AWS RDS, My SQL 6.0, Red Hat Linux, Dynamo DB

Confidential, Estero, FL

Sr. Business Systems Analyst / Scrum Master

Responsibilities:

• Elicited requirements by conducting Brainstorming and JAD sessions with stakeholders. Interviewed vendors and SME’s and asked both open ended and close ended questions to refine the requirements. Coordinated all the requirements with the requirements management tool- TFS.
• Assisted PM in creating work breakdown structure and made sure it is properly broken down into relevant, specific, measurable, achievable sections. Created and updated the Gantt Chart to trace the project planning at the detailed level.
• Facilitated Scrum ceremonies, and converted Epics and Themes into user stories by using Vertical Slicing techniques
• Generated Sprint and Release Burn Down charts to track the progress of the project and calculate Technical Debt.
• Gathered and documented MDM application, conversion, and integration requirements.
• Worked with integration services for transferring and reviewing data from heterogeneous sources like various databases, flat files (Excel, CSV). Developed Master file from multiple sources for better data governance.
• Gathering the information about manual sources that are not captured in point of delivery (POD) Mappings.
• Configured Landing Tables, Base Objects, Relationships, Staging Tables, Mappings, custom cleanse functions, Match and Merge settings, Trust, and Validation Rule.
• Worked with ETL team to schedule Batch runs to call ETL workflows that calls corresponding MDM SIF API's.
• Participated in making the Data Stewards familiarize with the Informatica IDD functionality.
• Configured Entity Objects, Entity Types, and Relationship Types for Product Hierarchical view in Informatica MDM
• Used SQL select queries to get data from databases for backend testing.
• Analyzed requirements in terms of the dimensional data elements and measurable facts. Identified source systems, their connectivity, related tables, and fields and ensured data suitably for mapping.

Environment: Waterfall-Scrum Hybrid, Informatica Multidomain MDM 9.7.1, SQL Server 2012, IDD, Erwin, Informatica Data Quality, SOAP UI, TFS, Microsoft Excel, Microsoft PowerPoint, Microsoft Word, Red Hat Linux

Confidential, Trenton, NJ

Sr. Business Systems Analyst

Responsibilities:

• Conducted JAD sessions, one-on-one interviews, and Group interviews. Performed Document analysis, Interface Analysis of existing systems documentation. Employed Observation technique on the existing process
• Created data model for the Star Schema using Erwin, created DDL scripts for static dimensions and ETL Mappings using Informatica Power Center and Used DML, DCL and DDL SQL queries for constructing the DWH
• Integrated various OLTP to the OLAP by using Informatica Power Center as an ETL tool and used Tableau as reporting tool. Also maintained the Bill Inmon and Ralph Kimball Paradigms.
• Created Data mapping specifications, Source to Target mapping documents including the transformation rules
• Created logical data model from the conceptual model and its conversion into the physical database design
• Performed Data Profiling, Data Cleansing, and Data Analysis along with Data Analyst before loading the data into the central data warehouse using tools like Informatica Data Quality.
• Helped in deciding the methods for ETL process to load data into target warehouse using Informatica Power Center.
• Created complex reports using union queries, conditional formatting and prompting, drill-through.
• Worked closely with Data Architects and development team to make sure requirements are understood
• Used Tableau for Data Reporting, studying the trends, data patterns and for data forecasting.
• Performed data analysis using SQL, data profiling and validation on the various source data systems and feeds and cleansed and standardized the data to be provided to ETL
• Created /scheduled SQL server jobs and maintenance activities of database.
• Analyzed and fixed the defects raised by end users and Assisted users in trouble shooting their reports
• Involved in generating Test Plans and Test cases, prepared test data for positive and negative Test Scenarios as per system specifications and requirements

Environment: Waterfall-Scrum Hybrid, Erwin 3.5.2, PL/SQL, Angular JS, Oracle 9i, Informatica 7.1, BO 6.5/, Informatica Power Center, MS Visual studio 2013, MS Word, MS Excel, MS PowerPoint, MS Access, Tableau

Confidential, Orlando, FL

Business Systems Analyst

Responsibilities:

• Helped PM in developing project scope document, concept statement, risk analysis document, mitigation plan and proposal statement. Performed feasibility study, SWOT analysis and cost benefit analysis.
• Elicited requirements by conducting Focus groups, Group Interviews, and Requirement Workshops. Interviewed business owner and SME’s and asked both open ended and close ended questions to refine the requirements.
• Created requirements documents- BRD & FRD. Decomposed these requirements into user stories by conducting user stories session with product owner and defined the Acceptance Criteria. Assisted in the prioritization of requirements.
• Involved in Salesforce application setup and customized the apps to match the functional needs of the organization.
• Created Use Case diagram, Data Flow diagram, Activity diagram showing the application flow. Also created mock up screens, Wireframes for better understanding of GUI requirements.
• Conducted GAP Analysis for the AS-IS and TO-BE Processes to identify and validate the requirements.
• Creation of Requirements and implementation for an Omni-Channel experience in agreement with vendors.
• Used NO SQL to maintain constantly changing product catalogue information in NO SQL databses
• Responsible for analysis of overall SEO efforts including keywords, page ranking, and content optimization
• Generated web analytics reports using Google Analytics to understand the funnel conversion rates.
• Created Test Plans and Test Cases for functional testing by analyzing the Business requirements specification document. Reviewed test scripts to ensure that all the functional requirements were tested.
• Implemented several complex SQL joins to retrieve data from multiple tables with Referential Integrity.
• Involved in API technical writing for both SOAP and REST. Documented XML and JSON request and responses.
• Involved in Performance testing using HP Load Runner. Generated reports to verify against SLA.
• Prepared Test Reports and submitted the Bug Findings to the Bug Tracking system using Quality Center and its modules (Requirements, Test plan, Test lab and Defects)
• Developed user manuals and training manuals as per project specifications and timelines

Environment: Waterfall-Scrum Hybrid, Erwin 3.5.2, PL/SQL, Java, HTML5, CSS3, JavaScript, Angular JS, Oracle 9i, Informatica, HP QC, TFS, MS Visual studio 2013, MS Word, MS Excel, MS PowerPoint, MS Access, Mongo DB

Confidential

Business Systems Analyst

Responsibilities:

• Involved in defining the scope and business rules of the project, gathered business requirements by employing several elicitation techniques like Interviews, Brainstorming, Focus-Groups, Requirement Workshops which involved interaction with various stakeholders and Subject Matter Experts(SMEs). Created BRD and FRD.
• Extensively used INVEST criteria to write user stories by conducting a story writing session along with product owner, development team, scrum master and other stakeholders and wrote user Acceptance Criteria for each story.
• Facilitated various Vertical Slicing of the epics into user stories during Backlog Grooming Meeting.
• Worked on Content Management System and assisted in consolidating Product Catalogue for various channels.
• Created mock-ups and Wireframes for the UI using Balsamic and assisted UX team in developing the UI.
• Analyzed requirements in terms of the dimensional data elements and measurable facts. Identified source systems, their connectivity, related tables, and fields and ensured data suitably for mapping.
• Created a mapping document that maps all the fields in the HTML pages to XML tags which are in turn mapped with the tables and column names in the database and involved in performing client-side validation on the new system.
• Collected information about different entities and attributes identified primary keys and foreign keys for the entities. Mapped surrogate key tables to the required dimensions.
• Worked on service-oriented architecture (SOA), REST, SOAP, XML, API.
• Used SQL select queries to get data from databases for backend testing.
• Assisted User Acceptance Testing (UAT) in communicating testing principles and guidelines with the team.
• Created product documentation including online halp, user manual, and training materials.
• Provided user test cases and collated and tracked defects. Communicated defects to development team.
• Prepared Test Reports and submitted the Bug Findings to the Bug Tracking system using HP QC (Quality Center) and its modules (Requirements, Test plan, Test lab and Defects)
• Facilitated Joint Application Development (JAD) sessions to identify business rules and requirements and then documented them in a format that can be reviewed and understood by both business and technical teams.
• Defined the Scope, and performed Cost/Benefit Analysis, Risk Management, and GAP Analysis.
• Created Business Requirements Document (BRD) and converted them into System Requirement specifications (SRS) and obtained approvals for all documents.
• Assisted in gathering requirements for the GUI (Graphical User Interface) Screens and designing.
• Created use cases and designed use-case diagrams, class, sequence diagrams and activity diagrams.
• Analyzed business requirements and created Use Cases, Process and Activity Flow Diagrams using MS Visio to derive a clear and mutual understanding among stakeholders.
• Developed strategic partnerships with the business unit to develop a solid noledge base of the business line, including the business plan, products, and processes.
• Used Google APIS to connect the maps to the existing system with SOAP and RESTful APIs.
• Prepared Requirement Traceability Matrix(RTM) and interacted with QA team to ensure quality of software.
• Worked with QA team to develop and execute Test Plan Document defining Test Cases and Test Scripts.
• Conducted walkthrough sessions with end users, technical team and aided in developing user manuals.
• Part of User Acceptance Testing (UAT) by managing identified issues and ensured all issues were resolved.

Environment: Waterfall, MS Office, UML, MS SharePoint 2010, MS Visio, Selenium, SOAP UI

Confidential

Jr. SQL developer

Responsibilities:

• Interacted with business users and analysts and gathered and documented the technical and business metadata.
• Involved in ER diagrams (Physical and Logical using Erwin) and mapping the data into database objects.
• Designed database, tables, and views structure for the new data mart.
• Created complex stored procedures and functions for integrity checks of transferred data.
• Created and managed Schema Objects such as Tables, Views, Indexes, and Constraints.
• Ensured performance, security, and availability of databases.
• Used NO SQL to maintain constantly changing product catalogue information in NO SQL databases
• Implemented different joins to retrieve data from multiple tables with Referential Integrity.
• Unit testing of the Database using PL/SQL queries and Creation of new indexes to avoid the potential locking issue.
• Proficiency in understanding clients’ needs and generate, modify reports existing in Oracle Applications according to the requirements and specifications and Optimization the queries to improve the performance of the application.
• Created PL/ SQL stored Procedures, views, functions, packages, MS SQL SERVER 2008 stored Procedures
• Performance Tuning of the data using indexes, views, Graphs in SQL Server.

Environment: Waterfall, SQL Server 2008, Windows 2005/2003/2000, MS Access, T-SQL, PL/SQL, SQL, MS Excel