SUMMARY:

• Over 5years of experience in IT Industry in as a Business Analyst with Testing. Also performed various roles like Data Analysis, Data Modelling, Data Mapping, Functional consultant, Validation & Quality Analyst and project coordinator, in Healthcare, Financial, Salesforce CRM and Oracle apps (HRMS, AR, OM & OLFM).
• In - depth knowledge of Rational Unified Process ( Confidential ), risk engineering, data modelling and mapping, and design using UML (Unified Modelling Language), Rational Rose and Visio.
• Good exposure to conducting Joint Application Development (JAD) sessions/ workshops for project definition, requirement analysis and user interface.
• Effective communication with Stakeholders/Clients on Eliciting requirements and CR’s.
• Experienced in preparing Use Cases, diagrams (Activity, Class, Sequence), Business Requirements Document (BRD), Functional Requirement Document (FRD), Requirements Traceability Matrix (RTM). Experience in conducting SWOT Analysis, Cost Benefit and ROI Analysis.
• Hands-on experience in working with Agile-Scrum process. Worked closely with Product Owner, Scrum master, developing user stories and technical team to meet the objective of the projects.
• Excellent oral and written communication skills with a demonstrated capability for dealing with all levels of client management personnel and staff.
• Conducted walkthroughs with the end users and stakeholders to gather the modification requests from the user to upgrade or change the business specification for the product.
• Proficiency with SQL queries to perform Data Validation and Back end testing of databases to check the integrity of data.
• Strong writing skills in preparing Business Requirement Documents (BRD), System Requirement Specifications (SRS), Software Requirement Specifications (SRS), Use Case Specifications, Functional Specifications (FSD), Requirement Traceability Matrix (RTM) and Technical Design Document (TDD).
• Hands on experience in Functional Testing, System Testing, Integration Testing, UI Testing, Manual Testing, Regression Testing, Black box Testing, Smoke & Sanity Testing.
• Proficient in Test Management tools like JIRA, HP ALM & IBM Rational Tools.
• Expertise in designing, developing and executing Test Scenarios, cases & reports.
• Experience in End to End SDLC & STLC.
• Profound understanding of insurance policies like HMO and PPO and proven experience with HIPPA X12 EDI transaction codes such as health care benefits, status, 834(Benefit enrolment), 835(Payment/remittance advice), 837(Health care claim).
• Experience and strong understanding of HIPPA ICD- 9 & ICD-10, Claims Processing, Dual Processing of claims, Medical management information system(MMIS), Claim Adjudication, Memberships, SNAP, TANF and other standards.
• Well versed with all phases of Software Development Life Cycle (SDLC) methodology (such as requirement, analysis, design, data modelling, business process modelling, implementation and deployment), Waterfall and Agile Methodologies.
• Hands on experience in Salesforce Sales Cloud, Marketing Cloud & Wave Analytics.
• Performed most of the Salesforce Admin activities along with Business Analyst roles.
• Good experience with XML & JSON files and manually created XML files from Excel spreadsheets.
• Helped the business users to perform the SIT & UAT.

TECHNICAL SKILLS:

Methodologies: SDLC, Waterfall Model, Agile Kanban ( Confidential RAD, XP, and SCRUM)

Operating Systems: Windows 95/98/2000/XP/Vista/7, 8, UNIX

Operation Research Techniques: GAP Analysis, SWOT Analysis, Risk Analysis, ROI

Databases: Oracle 8i/9i/10i, MS Access, MS SQL.

Business Process Modeling Tools: MS VISIO, Rational Rose, UML

Quality Management: IBM Rational Tools (RQM, RTC & RTM), JIRA, HP QC, Mercury QC & HP-ALM.

Documentation & PM Tools: SharePoint, MS Office (Word/Excel/Power Point/ Visio), MS Project2010 and BluePrintSys.

Other Technologies: Salesforce CRM, Oracle SOA, Oracle EBS & Apps, JAVA, Web Services, JSON/XML, Informatica Power Center & MDM and SOAP UI.

WORK EXPERIENCE:

Confidential

Programmer Analyst

Responsibilities:

• Involved in the requirements and design plan of the system and prepared documentation after interacting with Clients on requirements design, updating test scripts and updating user manual in timely manner.
• Actively participated in change management meetings and change requests as per the State requirement.
• Tested the system in various ways (Manual & Automation) to make sure all the bugs were fixed and updating the team about new CR’s.
• Maintained and monitored all the defects in RTC defect tracking tool and make sure all the defects are fixed in timely manner.
• Maintained RTM and RQM by uploading test scripts, suites & defects traceability & linking to the related test cases.
• Was a part of gap analysis and code review meetings for the new requirements.
• Responsible for performing smoke test to the various environments after the build to see the application is up & running.
• Writing test scenarios as per the PSD’s provided by the State and reviewing them with the team on regular basis.
• Generating reports in Salesforce to track the Eligibility Criteria County wise.
• Managing Data in Salesforce through Data Cloud.
• Maintaining the huge data of cases and performing analysis for future.
• Executing test scenarios and creating test cases to test the application and reporting the defects in RTC.
• Familiar in running test scripts in Automation tool Selenium.
• Tested SOAP web services in SOAP UI to test the data in Interface application.
• Writing and executing SQL queries to test triggers in back end Database
• Facilitated training sessions to the new team members about the IEDSS applications its main focus and scope in the future for the State of Indiana and HIP.
• Facilitated training sessions on how to use tools like RTC, RQM, State formats, defect logging conventions and SharePoint.

Environment: Manual Testing, IBM Rational tools, RTC, RQM, JIRA, PL/SQL, Selenium, Soap UI and Informatica.

Confidential, Nashville, TN

Business Analyst

Responsibilities:

• Involved in the design of key gaps, interfaces and integrations that are part of the R12 Upgrade prototype from demo/business requirement sessions through configuration, solution design and testing.
• Involved in configuration of back office modules - General Ledger (GL), Accounts Receivables (AR), Accounts Payables (AP), Oracle Lease and Finance Management (OLFM), Cash Management, Sub Ledger Accounting (SLA), E-Business Tax (EB Tax), Fixed Assets (FA), Inventory, Payments, CRM Foundation.
• Was responsible for providing a global solution through functional designs (MD50) for Caterpillar specific customizations, custom reports, interfaces and integrations for business operations and accounting.
• Created Product Backlog, Sprint Backlog and managed User stories and use cases.
• Created Custom Objects, Page layouts, Validations rules, Formulas fields and Workflow rules, Lead assignment rules and auto-response rules in Salesforce.com Platform.
• Performed end to end application testing.
• Experience in creating approval process.
• Experience in creating time dependent workflows.
• Handled all Scrum team meetings, Sprint reviews, Product Grooming & Retrospective meetings.
• Proficient in developing business processes using process builder.
• Expertise in creating Reports, Custom report types and Dashboards in Salesforce.
• Created Field and Custom Fields as per the requirements.
• Performed Salesforce Admin roles like creating user profiles, security permissions, roles etc.
• Was responsible for developing and configuring Cat’s specific global accounting rules (using SLA) and tax rules (using EB Tax) as well as country-specific localizations.
• Providing the users with necessary training to use the application.
• Responsible for immediate resolving of issues in Production.
• Responsible for performing smoke test to the various environments after the build to see the application is up & running.
• Tested the complete application manually and reported various defects.
• Tested the Mobile Cat Quote App End to End developed in Salesforce.
• Was also responsible for global solution review, assisting business process documentation, documentation and review of test scripts (TE30), testing and facilitating UAT for user approvals.
• Prepared and reviewed all necessary documentation including - BR100 (Configuration), MD50 (Functional Design), TE30 (Link Test Script), TE40 (CRP Test Script), CCB (Change Request form).
• Addressed all Change requests as requested by the business. This included presenting high level solution alternatives, design reviews and delivering the technical components.

Environment: Salesforce CRM- Marketing Cloud, Sales Cloud & Service Cloud, Manual Testing, Oracle Applications R12 - Oracle Lease and Finance Management (OLFM), General Ledger (GL), Account Receivables (AR), Account Payables (AP), Cash Management, Sub Ledger Accounting (SLA), E-Business Tax (EB Tax), Inventory, Pricing templates, Contract templates, Agile-Scrum, HP ALM and Remedy.

Confidential, Durham, NC

Business Analyst

Responsibilities:

• Involved in requirement gathering session with Business analyst and Architect for building Data warehouse as part of ODS (Operational Data Store) project.
• Worked on Business requirement analysis and data analysis.
• Acted like a Scrum Master & Product Owner in leading the team to meet the deadlines in timely manner.
• Proficient in writing Use Cases and User stories.
• Worked with Scrum maters in prioritizing the User stories.
• Worked with PM’s to understand the product road map and create User stories.
• Hands on experience in building Storyboard.
• Worked with Facets Team for HIPAA Claims Validation and Verification Process (Pre-Adjudication) and assisted in version upgrade and impact analysis on data warehouse tables.
• Assisted in EDI transactions of medical claims (837) /underwriting for support and point of reference for the providers in business issues.
• Wrote business rules on database side. Also Worked on Data modeling as part of building databases using Database Diagrams in SQL Server management studio.
• Extensive use of FACETS backend tables and front end application system for data validation purposes.
• Experienced customizing standard objects. Designed and developed various Reports and Dashboards for various Enterprise applications.
• Worked in integration of Salesforce.com with external applications by using Web Services API, SOAP and REST.
• Used Data Loader for insert, update, and bulk import or export of data from Salesforce.com Objects. Used it to read, extract, and load data from comma separated values (CSV) files.
• Have developed the Test Classes and increased the code coverage.
• Worked on the Web Services and callouts using both SOAP and REST API for extracting the data from legacy systems to display in the pages of Salesforce.com.
• Produced transaction sets 835 and 837, complete gap analysis 4010 - 5010 against the document application 5010 enhancements ensuring the upgraded application included the required changes and additions for 5010 compliances.
• Involved in the upgrading process of 4010 transactions to 5010 by conducting impact analysis and risk assessment and worked on the mitigation plan to avoid the risks.
• Performed extensive Gap Analysis in order to understand and to identify AS-IS processes of claims transactions of standard and TO-BE processes of 5010 standards.
• Conducted Claims and HIPAA Compliance Training in order to run the test cases.
• Interaction with the SME's, Business User & Teams to get understanding of Business Processes.
• Requirement elicitation using JAD sessions with all level of Project Stakeholders,
• Creating & drafting conceptual models using UML for Use cases, Class Diagrams, and a number of interaction diagrams.
• Worked closely with the product owner, scrum master and technical project lead to meet the project goals.
• Setting up retrospectives, sprint reviews or sprint planning sessions.
• Walking the product owner through more technical user stories.
• Encouraging collaboration between the Scrum team and product owner.
• Working with the development team during the Design, Build and Test phase of system projects to clarify business requirements as required.
• Co-ordinates UAT activities with customer
• Coordinate UAT signoff activities

Environment: Agile-Scrum, Salesforce CRM, MS Office Suite, Windows 7, SQL, Teradata, ETL, Informatica, Jenkins, HP-ALM, Quality Manager, MS SharePoint, Java, PLSQL, SOAP/REST Web services and SOAP UI.

Confidential

Business Analyst

Responsibilities:

• Developed Software Requirement Specification (SRS) documents using Visio and MS Office (The requirements for this project are being subdivided into three separate Software Requirement Specification (SRS) documents, one for each release of the project).
• Customize Salesforce.com including fields, page layouts, record types, reports and dashboards.
• Customizing various Salesforce.com standard objects like Accounts, Opportunities, Products, Cases and Leads.
• Developed Workflow Rules, Validation Rules, Time-Dependent Workflow Actions and Email Alerts.
• Developed several Process builders for various automated process like chatter posts, record creation, record update, Email alerts, Approval submissions, calling apex class, Flows or another process builder.
• Created and customized various Reports & Dashboards according to the Business user’s requests.
• Designed various types of Email templates for auto response to customers.
• Involved in data mapping and migration of data from legacy systems to Salesforce.com Objects and fields.
• Coordinating all the testing activities between offshore and onsite as well as with development team.
• Review all Requirement specification docs, Functional design docs for completeness and testability.
• Assisting the team while Test Case execution.
• Conducted user interviews, attended JAD (Joint Application Development) sessions, created agendas and documented analysis in requirement gathering.
• Responsible for post development peer reviews and deployment of packages.

Environment: Salesforce CRM, Agile-Scrum, Sales & Service cloud, IBM RQM & RTC .

Confidential

Sr. Analyst

Responsibilities:

• Participated and facilitated meetings with business and technical Subject Matter Experts (SMEs) to capture the high level function points and business practices.
• Responsible for facilitating and arranging Conference Calls, and Business Interviews and worked with a team of onsite stakeholders to determine functional and technical requirements designed for the development of a new applications.
• Worked closely with the product owner, scrum master and technical project lead to meet the project goals.
• Performed analysis on the existing system logic difficulties and the proposed system and created as-is and to-be business process flow diagrams.
• Extensive data validation on the back end using SQL queries to verify the data has been loaded in the correct tables.
• Engaged in preparing the flow chart of the design and documented user requirements with MS Word as the editing tool.
• Involved as a Test Engineer in testing team for Manual and Automated Testing.
• Developing and executing test cases for the Maintenance, Sharing requirement and DBA modules.
• Documented problems found during test and communicated recorded problems to the responsible development personnel.
• Extensively used ETL to Extract, Transform and load data.
• Developed Scripts for Regression Testing and System Testing.
• Actively attend meetings with fellow testers and other groups to evaluate the progress and performance of the application.
• Performed Back-end testing using SQL Queries.
• Executed test cases manually and reported defects.
• Performed Sanity testing for each new build of the application.

Environment: Salesforce CRM, Java/J2EE, Web services, Oracle, SQL, PL/SQL, MS Office, MS Visio, Quality Center, Agile Methodology, XML, HP ALM & WINDOW 2003.

Confidential

HR Analyst

Responsibilities:

• Developed Software Requirement Specification (SRS) documents using Visio and MS Office (The requirements for this project are being subdivided into three separate Software Requirement Specification (SRS) documents, one for each release of the project).
• Customize Salesforce.com including fields, page layouts, record types, reports and dashboards.
• Customizing various Salesforce.com standard objects like Accounts, Opportunities, Products, Cases and Leads.
• Coordinating all the testing activities between offshore and onsite as well as with development team.
• Review all Requirement specification docs, Functional design docs for completeness and testability.
• Assisting the team while Test Case execution.
• Conducted user interviews, attended JAD (Joint Application Development) sessions, created agendas and documented analysis in requirement gathering.
• Responsible for post development peer reviews and deployment of packages.
• Identified the use cases from the gathered requirements and prepared a comprehensive Use Case Specifications document.
• Verified and validated data model with changes to business information and rules.
• Prepared the detailed work flow diagram based on the proposed enhancement for the system.
• Extensively interacted with both user group and development team in coming up with structured charts, class and sequence diagrams.
• Responsible for executing User Interface Testing, System Testing, Data Quality Testing.

Environment: Microsoft Project 2010, Salesforce, Rational Clear case, SQL Server, HPQC, Office, MS Access, MS Visio, MS Office, Lotus Notes, PL/SQL, Gap Analysis.