SUMMARY

• An astute professional with over 10 years of experience in Business System Analysis, Quality Assurance Analysis, Robotic Process Automation (RPA) and Report Development with exceptional team leading experience.
• Extensive experience in various domains such as Manufacturing, Automotive, Healthcare, Insurance, Real Estate, Banking & Financial Services, Manual & Automation Testing, Robotic Process Automation - Confidential, Customer Relationship Management (Siebel & Salesforce).
• Strong understanding of programming languages with ability to write code in Java and ASP.Net.
• Experience in leading and facilitating project meetings, sprint planning meeting, sprint review meeting and daily scrum meeting.
• Expertise in Project Documentations such as Product Definition Documents, Business Requirement Document (BRD), Functional Requirement Document (FRD), Software Requirement Specification (SRS), Use Case Documents, and GAP Analysis Document across the deliverables of a project.
• Sound understanding of Test Driven Development, writing test cases, and preparing User Acceptance Testing (UAT).
• Expertise in Manual Testing and A utomation Testing tools such as Confidential, HP ALM /Quality Center, Rational Team Concert, Rational Quality Manager, QTP/UFT, Selenium, Fiddler, Eclipse, Jenkins, Cucumber, Soap UI.
• Expertise in project documentation, solution design & development, Process design & development, developing requirement traceability matrix etc.
• Strong process modeling using UML diagrams - Use Cases Diagrams, Activity Diagrams, Class Diagrams, Data Flow Diagram and etc. in MS Visio.
• Extensive experience in testing Customer Relationship Management (CRM) Applications such as Siebel and Salesforce.
• Experience with AWS, DevOps, and CI/CD tools such as Jenkins.
• Hands on experience with various RDBMS (Relational Database Management Systems) including MS SQL Server, MySQL, Oracle, etc and wrote SQL queries to generate data reports for different levels of management, Data Analysis and resolving database issues.
• Hands on experience using JIRA, TestTrack, HP ALM /Quality Center in maintaining and tracking defects.
• Experience in performing Unit Testing, Sanity, Functionality, Integration, GUI, System, Regression, Smoke, Browser compatibility and UAT Testing.
• Experience in cleansing data, data validation checks during landing and staging area on migration to DataWarehouse.

TECHNICAL SKILLS

Methodologies: Waterfall, Agile, Scrum, DevOps

Database: AWS, Oracle, MS Access, MS SQL Server, DB2, Network, Hierarchical & RDBMS

Operating Systems: Unix, Mac, Windows, Linux

Diagramming Techniques: MS Visio, UML - Use case, Activity Diagram, Dataflow Diagram, Process Flows

Programming Language: , JAVA, ASP.Net, C#, PLSQL, SQL

Data Analysis Tool: MS Excel, MS Access, TOAD, Oracle Developer

Office Automation: MS Word, MS Excel, MS PowerPoint, Outlook

CRM: Siebel 6.x/ 7.0/7.5.2/7/5.3/7.7/7.8.3/8.0/8.1 ,SiebelAnalytics7.7.1,Tools, Configuration, EIM, Call Center, eCommunication, eFinance, Oracle Hisna, Salesforce

Testing Tools: Confidential RPA, HP ALM, Win Runner, QTP 9.0/8.2, Load Runner 8.0, Test Director 8.2, Rational Test Manager 7.0, Rational Manual Tester 7.0, Clear Quest, JIRA, QTP10, SELENIUM, JMeter

PROFESSIONAL EXPERIENCE

Confidential, Los Angeles, CA

Lead Business Analyst / RPA Consultant

Responsibilities:

• Work with key decision makers and business owners to understand our customer’s business requirements and clearly documenting them in order for our RPA consultant teams to deploy in an optimal manner the automation projects.
• Provide support to Implementation team throughout deployment of new deals during POCs and project implementation phase.
• Lead Daily Scrum, Sprint Planning, Sprint Grooming and Sprint Review.
• Lead the effort of Requirement gathering and project documentation and facilitation of meetings.
• Analyze business processes, identify automation opportunities, define RPA value proposition, reengineer process to improve automation potential and recommend RPA approach/strategy
• Develop Detail As Is Process Description - PDD (Process Description Document), Detail To Be Automated Process Description - SDD (Solution Design Document).
• Conduct RPA High Level Assessments and develop RPA client architecture and solution proposal focusing on scalability and extensibility.
• Develop high level project plans for implementation projects and provides continuous updates to RPA stakeholders and Project Manager during project delivery
• Work with teams in the identification of business requirements, functional design, process design (including scenario design, flow mapping), prototyping, testing, training, defining support procedures.
• Validating Sales Order Management and experience role based testing in Salesforce.
• Experience in custom settings using Salesforce Silverlight and API calls to external applications.
• Formulate planning, budgeting, forecasting and reporting strategies.
• Manage full life cycle implementations, designed, developed & tested Robots and Implemented End to End RPA robot using Confidential
• Used Confidential Orchestrator for deployment, monitoring & management of Confidential Robot automation activity.
• Identify business opportunities to increase usability and profitability of information architecture.
• Exposed to leadership, governance and change enablement.
• Lead QA Scrum Calls, prepare and run Test Cases, and Bug Triaging
• Manage product backlogs, Bugs, Requirements using JIRA.
• Use MS Visio for workflow and process diagramming.

Environment: Agile, Scrum, Requirement Gathering, Solution Development, Confidential RPA, SFDC (SALESFORCE), QA Analyst, WebService, RESTful, REST API, AS-IS, TO-BE, UML, MS Visio, MS EXCEL

Confidential

Business Analyst / RPA Consultant

Responsibilities:

• Worked as RPA Business Analyst and Confidential lead for the project and implemented Proof Of Concept for Confidential .
• Gathered Requirements, developed Confidential PDD’s (process definition documents) and Served as a liaison between Confidential and vendor for the RPA delivery and automation process.
• Estimating, Analyzing Confidential Bots required for the process and cost involved in securing Bots.
• Co-ordinating Confidential near shore, offshore Development teams, QA Teams in ensuring the delivery of the identified and eligible candidates for Robotic Automation procedures as directed by Confidential .
• Worked in Scrum team and facilitate Sprint Planning, Sprint Review, and participate in Daily Scrum.
• Providing continuous update to Confidential on bug-fixes in previous deliveries.
• Ensuring the Robotic Automation process of identified Siebel CRM daily procedures by Confidential with Confidential Bots in QA environment, and monitoring the same in Production environment.
• Hands on experience include automating identified Standard Confidential Salesforce Application processes with Confidential Bots in QA Application and monitoring the same in Production environment.
• Along with the standard CRM applications, hands on experience include developing process flows for Robotic automation of internal ASP.NET and JAVA Based Confidential home ground applications.
• Used Visio and UML Diagrams to visualize the system process and to present, elaborate and explain the details of the requirements to all stakeholders for identified robotic automation procedures.
• Developed AS-IS Business Process and To - BE Business Process for Confidential RPA Implementation 2019
• Conducting several side by side meetings with Business stake holders at Confidential for future RPA projects and documenting them into AS IS process flows
• Developing workarounds for final TO BE Business process to make the process eligible for RPA with Confidential and verified the same with Confidential, Development Team.
• Created Process Defined Documents (PDD) upon Confidential ’s approval of AS IS and To Be Processes for anticipating projects.

Environment: Agile, Scrum, Automotive, Financial Services, Confidential RPA, SIEBEL CRM, ORACLE EBS 5, SFDC (SALESFORCE), MS Visio, SQL, Production Support, ASP.Net, Java, MS EXCEL

Confidential, Riverside, CA

Business Analyst | QA Lead

Responsibilities:

• Participated in Interviews, Joint Application Development Sessions (JAD), focus sessions for requirements gathering, analysis and design with stakeholders, Subject Matter Experts, Developers and system architects.
• Served as a liaison between the internal/external business community and the IT organization in order to help facilitate the development of project business, user and functional/non-functional requirements, Worked on Inventory Systems
• Responsible to document securitization process system upgrading and analyzing the needs of the business & customers, incorporating them in to the FRD.
• Involved in the management of multiple small projects, using MS Excel to enhance the existing functionality and web page development for the customer.
• Acting as a feeding source to the Change Management process from initial request through estimation, approval, requirement documentation, and implementation.
• Worked with the Project Manager (PM) for the initial development of project plan, milestones and management of deliverables, Detailed Schedule, Resource Allocation and Budget Plan throughout the entire life cycle of the project
• Communicated and interacted with both IT team and QA team to clarify and provide information on validating and testing the requirements specifications
• Developed Process flow diagrams and use cases and test cases using Visio and Power point and worked with Solution Architects to understand the workflow of the system
• Used SQL and MS Excel to Map and extract data based on the customer needs and requirements and prepared Data Mapping Documents for specific requirements of the customer.
• Prepared Data Specification Document for different data set migration between databases and DataWarehouses.
• Wrote Business Requirement Specifications documents to further elaborate the requirements and successfully delivered necessary change in a manageable way, during the process of Change Management.

Environment: Agile/Waterfall, Requirement Gathering, JAD, BRD, FRD, MS EXCEL, ASP.NET, JIRA, MS SQL SERVER 2009, FIDDLER, AJAX, KODAK, DOCUMENTUM, Test Cases, UAT

Confidential

Senior QA Analyst

Responsibilities:

• Participated in the Requirement sessions for Pricing and Products implementation.
• Participated in product review, functional review and design review meetings and provide feedback.
• Developed QA Test Plan which included objectives, testing strategies, test environment for covering functional, integration and end-end testing.
• Used Quality Center for Defect Management and used Visual Source for Configuration Management.
• Created and executed test plans, test cases including regression test suits to support quarterly, monthly and semi-monthly releases.
• Utilized various RDBMS such as Oracle, SQL Server and backend testing using SQL queries and Toad.
• Validated pricing using the PSP (Product Selection and Pricing) engine for the Agents/Office Products for eMedia.
• Validated integrations for Credit Card Authorizations, Tax Calculations, and Inventory Search and Lock Extension Business Rules
• Validated for PeopleSoft and Siebel Integration for Agreements, Invoice Generation and Charge Calculations.
• Validated Data Validation Rules at Auto Order, Approval generations and order Submit to compile with large amounts of data.
• Tested Email Templates for Order confirmations, Renewal Notification email and Proposal Templates for Invoice Generation.
• Tested OBIEE Reports for Revenue Recognition, Cash Flow, Product analysis and Inventory Search.
• Monitor and debug the Realtor.COM to Siebel Workflows at the time of Integration testing.
• Conducted three cycles of Regression Testing and achieved no new errors in the application with the defect.
• Review process of the design and test case documents with UAT users
• Organize test plan/test case review meetings and get test plan sign-off from QA, Development and Business Analyst groups
• Analyze multiple input systems to create and modify test input data Created and executed SQL scripts to create and modify test data.
• Closely interacted with the developers for assistance of Production Bug Fixes and Data migrations issues.

Environment: eCommerce, Real Estate, SIEBEL CRM, Oracle, SQL, Database Testing, QTP 10.0, HP ALM, Test Track, MS Visio