SUDHEER KODAVATI

Victoria, B.C, Canada

Phone: 250-***-****

abouz3@r.postjobfree.com

SUMMARY

Analytical, enthusiastic and innovative Business Systems Analyst with over Seven years of Information Technology experience in Business Analysis, Development, Quality Assurance and support of software related to Client-Server, Web applications and ERP applications.Extensive experience in gathering, managing and documenting business and functional requirements, communicating effectively with project management, developers and QA engineers.Adept at creating and transforming business requirements into functional requirements and designing business models using UML diagrams - Use Case, Sequence, Activity diagrams in Enterprise Architect, MS Visio and Rational Rose.Comprehensive knowledge of Software Development Life Cycle (SDLC), having thorough understanding of various phases like Requirements, Analysis/Design, Development and Testing. Excellent knowledge of RUP, Waterfall, Agile and SCRUM methodology.Experience in creating BPMN diagrams using Microsoft Visio2010 Premium for modeling the Business processFacilitated JAD sessions to ensure that the solution aligns with the client’s requirements.Expert in data analysis using various tools and writing SQL queries against various databases including MySQL, SQL Server and Oracle.Experience in providing system support to users during the development, maintenance phases by troubleshooting software problems, testing alternative solutions, and reviewing impact of resolutions.Extensively worked on reporting tools such as Crystal reports and Bex Analyzer.Experience with QA Methodologies and QA Validations to ensure the Quality Assurance Control.Experience in creating Test plans, Test Cases, Test Scripts for Functional, System, Integration, Regression, User Acceptance Testing of web-based and client/server applications.Having excellent communication skills and fast learning capabilities.Good team player and ability to multitask among various responsibilities.

TECHNICAL SKILLS

ERP : SAP ECC 6.0, SAP R/3

Data Warehousing : SAP BI 7.0, BW 3.X.

Content Management tools : Microsoft SharePoint 2010

Operating Systems : Windows 95/98/2000/NT/XP, Linux

Programming Languages : C, Java, XML, HTML, PHP, JavaScript

Databases : MySQL, Oracle, MS Access, SQL Server 2000

Automated testing tools : Win Runner, QTP,

Business Intelligence tools : Business Objects XI R2, Crystal Reports

Bug tracking tools : HP Quality Centre, Test Director, DevTrack,

Rational Clear Quest

Design tools : Microsoft Visio 2010 Rational Rose, Erwin,

Enterprise Architect 6.0

Brainstorming tools : XMind, Mind Jet Manager

PROFESSIONAL EXPERIENCE:

ShipConstructor Software Inc. Victoria, BC Jun’08 – Present

Business Systems Analyst

Description: ShipConstructor Software provides 3D Product-Modeling software for the design and fabrication of ships and enterprise solutions for shipyards.The majority of the US Navy and Coast Guard’s future fleet is being 3D modeled by shipyards using ShipConstructor software.It's software is integrated with crystal reports for reporting solutions (BOM) used by shipyards. It also has various features such as ERP Integration, Project Split and Merge etc. As a Business Systems Analyst, my role was to gather business requirements for new features and enhancements perform gap analysis, write business and functional specification documents, and facilitate UAT.

Involved in gathering business requirements, analyzing the requirements and created use case diagrams and functional specification documents.Clarified user requirements, business needs and project objectives, via JAD Sessions and meetings with project managements.Performed Gap Analysis for new features, identified issue risks to achieve business objectives.Extensively used mind mapping and brain storming software (XMind) to understand new functionalities, to break down high level areas, to generate ideas and to trace requirements.Used Rational Rose and UML to produce models like use case, sequence and activity diagrams.Created work flow diagrams using Mindjet Manager and BPMN diagrams using Visio 2010 professional. Assisted in designing test plans, test scenarios and test cases for integration, regression and user acceptance testing (UAT) to improve overall quality of the Application.Perform complex Data Quality Analysis procedures and manual matching techniques to successfully correct data inaccuracies directly in the user interface or via SQL scripts in the Database.Report defects in defects tab of "HP Quality Centre" for subsequent triage & then tracking them to closure.Developed a good dialog and communication with the team members, clients, and developers for the success of the project.Prepared Demos of new modules and presented them to cross-domain team members during knowledge by sharing sessions.Updated the documentation in accordance with corporate standards.

Environment: C++, Microsoft SharePoint Designer 2010, Microsoft SharePoint 2010, Crystal reports, HP Quality Centre, Microsoft OneNote, Microsoft Visio 210 Premium, XMind, Mindjet Manager, Windows 7/XP, Microsoft SQL Server 2005/2008.

Business Objects (now SAP Canada), Vancouver, BC Sep’07-Dec’07

Software Test Engineer. (Internship for UBC)

Description: BusinessObjects is one of the largest business intelligence firms in the world. Business Objects software helps organizations gain better insight into their business, improving decision-making and enterprise performance. Worked for Customer Intelligence and Escalations (CI&E) team which is responsible for all incoming customers’ escalations from customer support regarding various Business object products such as Businessobject XI, Crystal reports, WebI reports etc.

Involved closely with the Customer Support and development team to replicate, test, troubleshoot and narrow down the customer issues aroused in various Business object products. Interacted extensively with software developers to ensure defects are correctly identified, fixed, tested, and incorporated into the product builds.Created reports using universe and freehand SQL as data providers.Provided workarounds for the customer support for the escalations rejected as by Design .Worked on different severity issues and updated customer support hourly, daily and weekly based on the severity of the issue.Developed SQL statements to query against different databases for consistency of data in the report.Extensively work on extracting data from SAP Netweaver as data source and testing the reports.Involved in configuring and administering access rights for different servers used for different reports based on the problem statements.Performed Functional, Integration, System and Regression testing and tracked bugs in bug tracking system

Environment: SAP Net weaver, SD,FI-CO, Business Objects XI R2, Crystal Reports, Crystal Reports Viewer XI, Desktop Intelligence Reports, Apache Tomcat Server, Rational Clear Quest, PeopleSoft CRM, Windows 2000, Linux.

Reliance Global Services, India Feb’04– Dec’05

SAP Tester

Client: Bharati Airtel Ltd

Description: Bharati Airtel Ltd is one of the fastest growing national wide wireless service providers in India. .The role is responsible for the testing the billing modules, ETL process of their SAP BW system and verifying data in the reports.

Involved in testing different functionalities of their billing module.Configured and tested customer master, account groups, and tested additional Pricing procedures, rebates, tax and freight.Created Infocubes, ODS, Infosources and tested the sales data at various staging levels of business warehouse systemGenerated queries based on fiscal period, month & year in order to test combination of reports from the multi-cubes.Involved with Business Analysts, Developers and support team to define the testing requirement documents.Closely interacted with designers and software developers to understand application functionality and navigational flow.Developed Test cases for covering functional, integration, regression and end-to- end testing.Prepared test data for positive and negative test scenarios for Functional Testing as documented in the test plan.Performed functional, Integration, System, Regression, Security, Positive &Negative, End to End and User Acceptance testing.Used Test Director for bug tracking and reporting, also followed up with development team to verify bug fixes, and update bug status.Provided weekly, written status reports to QA coordinators showing the progress of the testing effort and open issues to be resolved.

Environment: SAP R/3 4.6C, B.W 3.0B, SD, FI-CO, Bex Analyzer, Windows 2000, Test Director.

Capstone InfoTech, India

QA Analyst

Client: IndiaProperties.com Ltd, India Feb’03 – Jan’04

Description: IndiaProperties assists individual customers and real estate industry professionals in sales, purchase and leasing of all types of property located across the length and breadth of India. I was on the team responsible for testing its primary website.

Developed test cases for Functionality, System, negative and positive testing.Worked extensively on manually testing the web based applications.Performed Database Testing manually by writing SQL queries to make sure that the data inserted from the user end was accepted at the back end.Involved extensively in Smoke test, Regression Testing, of the application.Performed Integration Testing as and when new modules were developed and system testing before the application went into staging & production.Interacted extensively with development groups and end users.Verified and validated the entire functionality of the application on different browsers and Defects were tracked, reviewed using Test Director.Provided daily status report to QA Lead and QA Manager.

Environment: Windows2000, ASP.Net, MySQL, Microsoft Explorer, Opera, Win Runner 7.5, Test Director.

ACADEMIC PROJECTS (Programming)

Medical Office Management Systems (MOMS) Jan’07-Aug’07

Institution: University of British Columbia

Description: MOMS project provides features to assist in effectively managing the daily activities and improving productivity in a medical office. Features include patient registration, appointment scheduling, medical record, inventory control, billing, and report generation.

Responsible for requirements documentation and use cases design and development of UML diagrams using Rational Rose and MS Visio.Created 3 layered architecture to support interoperability of the application.Designed GUI and coded the application using java, databases are developed in MY SQL.Performed Black Box, White Box and System Testing for entire application..Lead the team of five for successful completion of the project. Planned milestones and assigned project tasks to individual team member.

Environment: Windows 2000, Java, Net beans, Swing, JSP, MVC, Hibernate, MySQL.

Discussion group Management Systems (DGMS) Dec’08-Apr’08

Institution: University of British Columbia

Description: It is a web-based application, which provides to keep track, share, and post information on blog and bulletin board. It was developed by team of four for MSS department in University of British Columbia.

Involved in system architecture, design of database and GUI by providing efficient development model to ensure completion of project in scheduled time.Created and documented use cases, class diagrams and sequence diagrams.Created database tables and data objects to store the details, and posting made by user and administrator. Involved in coding of css script and some modules of the applications using PHPPerformed Black Box, and White Box testing for entire application Improved knowledge on database design, programming in PHP and XML.

EDUCATION

The University of British Columbia, Canada Jan’07-Apr’08

Master of Software Systems

University of Mysore, India Jun’97-Sept’01

Bachelor of Engineering, Computer Science

REFERENCES

References will be provided upon request.

Contact this candidate