SUMMARY

• IT Professional wif 12 years experience in Business Analyst and Quality assurance roles.
• Hands - on experience in evaluating business processes, anticipating requirements, uncovering areas for improvement, and developing and implementing solutions.
• Experienced in testing Web based Applications for eCommerce, Data Warehouse, Financial, Customer care, Order processing and Data Migration applications.

TECHNICAL SKILLS

SDLC Methodologies: Agile, Waterfall

Requirements Management: Jira, Confluence

Languages: SQL, PL/SQL, C++, PERL, Pro*C, Java, Python

Databases: Oracle, Sybase, MS SQL Server, Cassandra, Teradata, AS400

Web Technologies: HTML, XML

Web Servers: Tomcat, Apache

GUI Tools: Visual Basic, PowerBuilder, Java Script

Operating Systems: Solaris, UNIX (HP), Linux, Windows

Tools: Tableau, Business Objects, Excel, PowerPoint, Visio

Automation Tools: Silk, Selenium

Issue Tracking: Remedy, Jira, Quality Center, Salesforce, Bugzilla

PROFESSIONAL EXPERIENCE

Confidential, Alameda, CA

Sr. Business Analyst

Environment: Oracle, PL/SQL, MS SQL Server, AS400, Java, REST APIs, XML, JSON

Responsibilities:

• Performing requirements analysis and ensuring solutions meet business needs and requirements.
• Prioritizing initiatives based on business needs and requirements
• Support the testing of Rest APIs using JSON in Postman.
• Created business process flow diagrams, integrate process flow diagrams to show end-to-end business model and business process mapping.
• Translate the requirements intospecifications and maintained the backlog of epics, user stories and sprints in JIRA.
• Leadrequirements gathering and partnering wifbusiness partners to deliverand test billing APIecommerce solutions.
• Worked on Web service methodologies - REST APIs, XML, JSON payloads
• Worked wif Product teams for roadmap prioritization of product enhancements
• Performed Story Mapping creating epics, themes, and top-level user stories wif acceptance criteria meeting stakeholder's needs & focused toward developers
• Translating requirements into User Stories and Acceptance Criteria and updating the JIRA board wif tasks and sub tasks created for the team.
• Managing projects, developing project plans, and monitoring performance.
• Performing user acceptance testing of new features in QA and Sandbox environments
• Conducting meetings and presentations to share ideas and findings.
• Working closely wif vendors for production support and issues.
• Serving as a liaison between stakeholders and development team.
• Wrote complex SQL queries to debug production issues.
• Worked extensively on Data Validation and identifying Data Mismatches.
• Data Analysis for developing trending reports using SQL and PL/SQL scripts
• Supporting the onboarding of new stores onto the ecommerce platform
• Analyzed inefficiencies in processes and brought about process changes to improve team performance

Confidential, Sunnyvale, CA

Sr. Business Analyst

Environment: Oracle, PL/SQL, Java, UNIX, REST APIs, XML, JSON, Cassandra, Teradata

Responsibilities:

• Conducted Daily Scrum to identify and track the critical issues and requirement gaps
• Gatheredbusinessrequirements by conducting detailed interviews wifbusinessusers, stakeholders, and Subject Matter (SME's).
• Identified business trends utilizing real data, compiled analysis reports for further evaluation by developers
• Implemented a comprehensive management plan for each project and held regular stakeholder meetings to keep all interested parties updated in project progress
• Participated in evaluating business processes, documenting requirements, uncovering areas for improvement, and developing and implementing solutions.
• PerformedAPITesting: Performed Restful web services andAPITesting to validate response wif assertions.
• Analyzed feeds in various formats like EDI, XML, json, cvs to identify system/data issues
• Data Analysis to identify issues
• Responsible for leading ongoing reviews of business processes and developing optimization strategies.
• Led felicitations and functional requirements for API integrations to several products wif tight timeline.
• Critical order support by performing Order Data Validation and identifying discrepancies
• Wrote complex SQL queries to debug issues wif Orders
• Played a key role in defining essential reports for seller order tracking and analysis
• Performed root cause analysis and created informative documents and FAQs
• Managed stakeholder communication wif crisp, informative status reports
• Identified, prioritized, assigned and tracked the progress of issues
• Created User stories in JIRA for implementation of Seller enhancement requests
• Worked wif Product teams for roadmap prioritization of product enhancements
• Provided requirements to develop tools for issue monitoring, trends and resolutions
• Improved team performance through efficient process changes
• Discovered several production bugs and requirement gaps through prolific testing
• Worked closely wif QA team to include business critical issues as test cases
• Coordinated wif cross functional teams for quick resolution of high priority Seller issues
• Worked wif Vendors and internal teams for the project management of issues
• Conducted training sessions for Operations and Customer care groups
• Utilized REST APIs to test and troubleshoot seller request and response issues
• Mentored and supported on-site and Offshore teams

Confidential, Sunnyvale, CA

Business System Analyst / QA Analyst

Environment: Oracle, PL/SQL, Java, UNIX, Power Builder, REST APIs, XML, JSON

Responsibilities:

• Documented business functionality requirements in Business Requirement Document (BRD).
• Gathered and articulated Business Requirements from users and transformed those requirements into technical specifications.
• Organized and conducted Joint Requirements Planning sessions (JRP) as a facilitator to gather requirements from the Business User.
• Created Error mapping documents, Developer Reference Guide, Application Integration Mapping documents according to the requirements gathered from the stakeholders.
• Developed process flow/screen-flow diagrams for development/businessteams using MS Visio
• Wrote detailed test plans and test cases based on product and functional requirements
• Performed black box, smoke, GUI, functional, integration, regression tests for web-based applications.
• Good experience wif Agile and Waterfall software development life cycles
• Experienced in testing of SOAP Style and REST Full Web services.
• Performed cross browser/cross platform testing
• Good noledge of SDLC and testing practices
• Effectively reported bugs, appropriately escalated issues and followed up for resolution
• Test Data Validation using SQL and PL/SQL scripts
• Reporting and ETL testing wif heavy use of SQL and PL/SQL
• Created extensive test data for testing various functional areas
• Discovered several latent, hidden production bugs and requirement gaps
• Influenced product behavior by suggesting enhancements to product management
• Mentored other QA engineers and offshore teams
• Designed and developed automation scripts using PL/SQL scripts and Python
• Validated all DB objects during Release validations
• Worked in close association wif the development team to rectify software defects
• Supported continuous integration, process improvement and innovation
• Worked closely wif the Developers and Engineers to achieve a high level of code coverage