Sunil Kallepu

Technical Business Analyst/Product Owner

Phone# 936-***-**** Email: adkig8@r.postjobfree.com Professional Summary:

• Around 4 years of professional experience as Business Analyst/Product Owner/Scrum Master in variety of projects in the E-commerce, Health, Finance, Retail and Digital Marketing using traditional and Agile methodologies.

• Adept at coordinating and following up in simultaneous high profile projects from Confidential with cross functional teams in a global environment

• Worked in different types of projects - Development, Enhancement, Data Migration, Production Support and gained experience in all stages of Software Development Life Cycle

• Managed projects where enterprise products were deployed, maintained and migrated both on-premise and on cloud-- AWS EC2, AWS CloudWatch, AWS Lambda, AWS relational database, Amazon Redshift and AWS S3 Bucket.

• Proficient in Business Requirement gathering, Business Process flow, Business Process Modeling (BPM), Process Redesign, Business Process Reengineering, Business Change Management, Documenting Enhancement Requests, Automatic and Manual Testing, etc. with a keen awareness of developers and end - users needs and able to dealt with user groups at all levels efficiently

• Extensive experience in leading and designing online Marketing Campaigns, Consumer Research, Search Engine marketing, Search Engine Optimization, Web Analytics and Site Tagging.

• Experience in Dynamics CRM including Design, Development, Implementation and Management. Hands on experience on various modules including Sales, Services, Marketing and creating various custom objects.

• Worked in front end applications for gathering requirement and coordinating with developers to deliver the application.

• Proficient in documenting System Requirement Specifications (SRS), Functional Requirement Specifications

(FRS), Requirements Traceability Matrix (RTM) using Rational Requisite PRO and Software development plan.

• Conducted Daily Scrum meeting, Planning Sessions, Backlog updates, User Stories updates, Continuous Integration, Continuous Testing

• Expertise in using leading industry tools like MS Visio, MS Word, MS Excel, MS PowerPoint and Requisite Pro to develop various project deliverables. Extensive knowledge of Continuous Integration and Continuous Deployment (CICD) using GIT, Jenkins

• Experienced in requirements gathering and analysis using various elicitation techniques like interviews, surveys, JAD sessions, observation, prototyping and brainstorming.

• Excellent Experience in SDLC Methodologies like RUP, Agile/Scrum and Waterfall. Experience in functional and use case design ensuring no redundancy and acted as product Owner in Agile based development

• Adapt at creating and transforming business requirements into functional requirements and designing business models using UML diagrams like Use Case, Sequence, Activity diagrams using MS Visio and Rational Rose

• Successful completion of projects using the software development principles of Rational Unified Process (RUP) using Rational Rose, Rational, Requisite Pro, Unified Modelling Language (UML)

• Experience with Data analysis and SQL queries with database integrations for large organizations.

• Proficient in assessing Project feasibility through Cost-benefit analysis, SWOT analysis, Break-even analysis, What-if Analysis, Monte-Carlo method, Impact Analysis, Regression Analysis, Gap analysis, and PESTLE Analysis.

• Experienced in various diagramming techniques like wireframes, Process maps, Flowcharts, Functional Demonstration, context diagrams and BPM modelling techniques.

• Create Test Plans, Test Cases, Test Scenarios and Test Strategies to ensure Quality Assurance and acceptance criteria are met. Hands on experience in Agile ATDD Acceptance Test Driven Development process, and also in Test Driven Development TDD cycle.

• Extensive experience in conducting Joint Application Development, JAD sessions with end users to provide for accurate statement of system requirements and a better understanding of common goals.

• Experience in project management activities like Resource Allocation, Invoicing, Scheduling and Estimation, monthly metric reporting etc.

• Skilled in implementing Data Warehousing, Business Intelligence solutions and ETL Processes. Experience in data modeling concepts like STAR schema and Snow Flake Schema. Technical Skills:

• Business Skills: Business Requirement Documents, Business Process Analysis & Research, Use Case Modeling, JAD/RAD sessions, Requirement Gathering, GAP analysis, Impact Analysis

• Modeling Tools: Erwin 2018/19/20 R1 9.8/9.6/9.5, Microsoft Visio, Rational Enterprise Suite

• ETL/Data warehouse Tools: Informatica Power Center, Data Marts, Talend, OLTP/OLAP

• BI Tools: Tableau, Crystal Reports

• Packages and CRM: Microsoft Office, Microsoft Project, Share point Portal Server, Salesforce CRM, Microsoft Dynamics CRM.

• Operating System: Windows, Unix, Linux

• Automation Tools: MS Visio, Rational Rose, Rational Clear Case

• RDBMS: Microsoft SQL Server14.0, Teradata 15.0, Oracle 12c/11g/10g/9i and MS Access

• Programming Languages: SQL, Python, .Net framework, PL/SQL, NoSql

• Cloud: AWS Web Services, EC2, S3, Lambda, CloudWatch, Red Shift, Snowflake DW, Azure

• DevOps Tools: Terraform, Jenkins, Vagrant, Docker, Kubernetes, CI/CD, JIRA, Bit Bucket, Ansible, Puppet

• Testing Tools: Quick Test Pro, Test Director, HP Win Runner, Selenium, Load Runner, Caliber RM

• Version Control Tools: GIT, GitHub

• Scripting Languages: VB Script, Shell Scripting(Linux)

• Project Execution Methodologies: Agile/Scrum, Rational Unified Process (RUP), Rapid Application Development

(RAD), Joint Application Development (JAD)

Work Experience:

Softura, Farmington, MI Feb 2020 to Present

Technical Business Analyst/Product Owner

Responsibilities:

• Facilitated interviews, cross-functional working sessions with Product Owner, Line of Business managers, stakeholders& SMEs to refine the project scope and document the requirements in Requirements Traceability Matrix (RTM).

• Created and gathered all the requirements in the high-level Business Requirement Document

(BRD)/Functional Specification Document (FRD) and low-level System Requirements Specification Document (SRS).

• Collaborated with the project manager on sprint planning, daily stand up meetings, and sprint retrospective meetings. Participated in Sprint review demos with stakeholders to track project progress, captured views from the stakeholders.

• Created AS-IS and TO-BE business process Flow Diagrams, Integrate Process flow diagrams to show end-to- end business model and business process mapping exercise including swim lanes

• Designed and prepared the Use Case Diagrams, Class Diagrams, Sequence Diagrams for process flow using MS Visio

• Derived Functional Requirement Specifications (FRS) based on User Requirement Specification (URS). Understand and articulate business requirements from user interviews and then convert requirements into technical specifications

• Assisted in designing the configuration of MS Dynamics CRM as per the business users requirements.

• Assisted the development team with demos to the Product Owner and ensured that any changes requested in the demos were implemented

• Developed wireframes along with SME’s based on business needs and Worked with UI interface designers for visual designs and mockups

• Created Acceptance Criteria in every use case based on requirements, wireframes and design document. Prepared User Stories for various business scenarios to meet the acceptance criteria

• Designed Use Case Diagrams and wrote their specifications in the Use Case Specification documents using Visio based on the Requirements gathered

• Participated in server deployment on Cloud, Optimization and cost reduction of Amazon AWS services .

• Perform deployments and quality assurance of our systems and products. Acted as a resource in assisting team members in the development and executing test/use cases/negative tests.

• Configuration and customize our products and Microsoft Dynamics CRM, Actively participated in the process of data mapping of products and benefit systems and ensuring all data fields are functioning correctly

• Interacted with the developers to report and track bugs using JIRA.

• Involved in performing GAP Analysis by identifying existing technologies and documenting enhancements to meet end state requirements

• Prioritizing API function call for testers and documenting the API according to system, Performance & experience.

• Responsible for writing test cases for GUI, Functional, Regression, Integration, System, User Acceptance Testing for system and Unit Level Requirements.

• Prepared Final Practice Run & Go-Live environments for Smoke tests after deployment, assisted QA Analysts in creating Test cases &Test Scenarios, performed Regression, UAT testing, performance testing and System Integration Testing.

Environment: MS Office Suite Applications, MS Visio, Agile/Scrum, JAD, Unix/Linux, QTP, Selenium, Erwin 2018/19 R1, Oracle 11g/12c, SQL, REP, SQL Server 2016/17, Microsoft Dynamics CRM, CI/CD, SSRS, Git Hub, Python, Tableau, MySQL, SharePoint, AWS EC2, S3, AWS RDS, Vagrant, Docker, PL/SQL, ETL. Verizon, Irving, TX Aug 2017 to Jan 2020

Technical Business Analyst/Product Owner

Responsibilities:

• Reviewed the business case and analyzed the high level scope to create a process map.

• Identified the subject matter experts and project stakeholders before conducting a stakeholder analysis.

• Conducted scope review meeting followed by scope decomposition to be reviewed by the technical project stakeholders.

• Conducted requirements gathering sessions with the stakeholders Business Technical to create the high level requirements document BRD.

• Translated high-level requirements into high-level user stories and epics over sprints. Documented the user stories to create the product backlog with the product owners input.

• Used the MoSCoW technique for prioritization of the product backlog items to move onto the appropriate sprints during the sprint planning meetings.

• Used the industry standard change request management tools Rational suite during requirement churns.

• Conducted Backlog Refinement meetings as needed for reprioritization and implementation in the current planned sequence of sprints.

• Performed different transformations in Informatica like the Source Qualifier Transformation, Aggregator Transformations, Filter Transformations, Joiner Transformations, Rank Transformation and Sorter Transformation.

• Enhancing MS dynamics CRM usability by designing and optimizing navigation, forms and layouts. Involved in mapping customer requirements to MS Dynamics CRM.

• Worked on various Microsoft dynamics CRM configuration including Custom Objects, Page Layouts, Form Layouts, Field values, Reports and Dashboards.

• Converted the high-level process map To-Be into a detailed process map with integration points and gateways including alternate processes.

• Overviewed the manipulated data on a daily basis - SSIS for ETL Stored Procedures, Reporting and Extracts from complex data structures

• Prepared and analyzed the existing architecture and performed Gap Analysis. Created workflow scenarios, designed new process flows and documented the Business Process and various Business Scenarios and activities of the Business from the conceptual to procedural level on MS Visio.

• Worked closely with Product Manager, System Analyst and Development team to sign off feature file test cases as part of Agile ATDD Acceptance Test Driven Development process.

• Prepared Use Case Diagrams, State Diagrams, Activity Diagrams, Sequence Diagrams and creation of technical design UI screen, UI Wireframes and Mock-ups using Microsoft Visio.

• Worked with BI Team on SQL queries to pull systems data for data analysis and performed Data Validation.

• Prepared Logical Data Models that contained set of Entity Relationship Diagrams and Data Flow Diagrams and supporting documents and descriptions of the Relationships between the data elements to analyze and document the Business Data Requirements.

• Took part in QA activities by writing the Test Plan followed by Test Scenarios and Test Cases for the User Acceptance Testing UAT on JIRA.

• Worked on different Spotfire Objects/Visualizations like straight tables, line charts, bar charts and pivot tables etc. for dashboard design

• Communicate with Architects, Lead Designers & Engineers and identify the risks, perform the Risk Analysis, planned Risk responses and prepared Risk Register.

• Extensively involved in Regression and Black Box testing, executing tests and tracking defects using HP ALM.

• Closely assisted the project manager during project closure by creating Gantt milestones, lessons learned, process presentation and a final end-user feedback overview post UAT and sign off. Environment: MS Office Suite, SDLC, Agile/Scrum Methodology, TOAD, Tableau, SQL Server, MS Visio, UML, SQL Server, Oracle, AWS Web Services, Python, Jenkins, Microsoft Dynamics CRM, SharePoint, JIRA, HP Win Runner, Selenium, Confluence, Informatica Power Center, ETL, RUP, Snowflake DW. Education:

Bachelor's in Technology, Computer Science Engineering, JNTUH, India

Master’s in Computing and Information Sciences, SHSU, Texas References:

Furnished upon request

Contact this candidate