PROFESSIONAL SUMMARY:

• 7+ years of experience as Business Analyst in different domains like HealthCare, Retail, and Banking.
• Experience in gathering requirements.
• Having experience in creating use cases, business requirement document and functional requirement document.
• Expertise in reviewing the requirements with the project teams.
• Having experience in doing show case demo to the client for the builds.
• Experience in working with Agile and Waterfall methodologies.
• Experience in writing and managing user stories.
• Expertise in decomposing the requirements for the development and quality assurance teams.
• Experience in conducting JAD sessions.
• Very good understanding on project methodologies.
• Comfortable in working with large volumes of data.
• Experience in working with SFDC Cloud environment.
• Worked on Dot Net and Java based applications.
• Worked closely with the stakeholders to prioritize the requirements.
• Knowledge of worker compensation and healthcare insurance systems.
• Experience in using Putty and fileZilla service interface.
• Extensive experience in using different tools to analyze the csv/tab files/ flat files.
• Experience in “as - is” and “to-be” documentation of Business Process.
• Experience using the SQL Developer and Toad.
• Expert in using MS-Office including Word, Excel.
• Expertise in defect tracking tools like JIRA, ALM and Mingle.
• Expertise in using SharePoint.
• Excellent experience in successfully managing multiple assignments simultaneously.
• Maintain Close interaction with the core teams to review the design, and to do the risk analysis.
• Experience in coordinating the UAT effort.
• Excellent Communication, Interpersonal and Leadership skills, Self-motivated, quick learner, Good team player and ability to work individually with strong desire to achieve quality results.

TECHNICAL SKILLS:

Operating System: Unix, Windows XP, VISTA, Mac OS x

Databases: Oracle, MS Access, SQL SERVER 2008/2012

Browser: IE, Mozilla Firefox, Google Chrome, Safari

Programming languages: SQL, JAVA,J2EE, HTML, XML, C, C++

Technologies: DOTNET and Web Services

Testing Tools: QTP, LoadRunner

Bug tracking Tools: HP-ALM, IBM Rational ClearQuest

Other Tools: VMware workstation, XML notepad, MS-Office, AutoSysOFSAA

PROFESSIONAL EXPERIENCE:

Confidential

Business Analyst

• Gathering the business requirements based on user’s recommendations for internal tools.
• Working closely with the users for training sessions on the new functionalities.
• Preparing Business/Functional requirement documents.
• Initiating the walk thru of the Requirement documents.
• Reviewing the requirement with the project teams, shared by the Business team.
• Working closely with the business group to get the clarification on requirements.
• Reviewed test plan for the testing team.
• Assisting the Testing team in understanding the requirements to create test cases.
• Created change requests based on the functional requirements.
• Coordinated with the project team to complete those change requests on time.
• Used IBM Rational Clear Quest to manage the defects and prepare the defects reports based on different criteria’s.
• Organizing meetings on daily basis to keep track of the project status.
• Using Microsoft tools to prepare reports for different projects.
• Working closely with the UAT team to develop test cases based on the same.
• Working closely with tech team to resolve the issues.
• Worked closely with team to ensure the AutoSys runs the scheduled jobs on time.
• Tracking if all the requirements are covered by the project team.
• Preparing the issues report on daily basis with the current status and sharing the same with project managers.

Environment: MS-OFFICE, Share point, Quality center, Windows 7.

Confidential

Business Analyst

• Gathering requirements from the business for cloud based SFDC environment.
• Creating the use cases based on the requirements.
• Reviewing the business/functional requirement with the project team for SFDC cloud based environment.
• Working closely with project team to ensure that user needs are fulfilled.
• Writing the requirements in ALM with a requirement breakdown.
• Working with the developers on the design documents for the upcoming changes.
• Involved in integration systems as the project includes multiple systems.
• Ensuring all the requirements are uploaded in ALM before the team is starting testing.
• Working closely with Dev. team to get the defects resolved on time.
• Coordinating for UAT effort.
• Doing the show case demo to business for each build.
• Providing user training after each release.

Environment: MS-OFFICE, Share point, Informatica, SQL Server 2012, ALM, Windows 7, TIBCO, Salesforce, SoapUI.

Confidential

Business Analyst

• Gathered the requirements based on user requirement/ Confidential standards.
• Prepared Business/Functional requirement documents.
• Initiated the walk thru of the Requirement documents.
• Reviewed the requirement with the project teams, shared by the Business team.
• Worked closely with the business group to get the clarification on requirements for Confidential III.
• Clarified all the details regarding the attributes being sourced from source system to ODS for ETL Testing.
• Shared understanding on the details related to DB changes required based on the requirements and attributes being sourced.
• Developed the Test Strategy and RRA document based on the requirements.
• Reviewed the test plan for End-to-End ETL Testing (ODS-OFSAA) along with the project team.
• Worked closely with the UAT team to develop test cases based on the same.
• Assisted the Testing team in understanding the requirements to create the test cases.
• Assisted the testing team to prepare the SQL scripts for the verification of the data in the db.
• Worked closely with tech team to resolve the issues.
• Tracked if all the requirements are covered by the project team.

Environment: MS-OFFICE, Share point, Informatica, SQL Developer, Putty, Filezilla, Oracle, Quality center, Windows 7.

Confidential

Business Analyst/ Lead QA Engineer

• Worked with the business team to gather the requirements.
• Created the user stories based on the requirements and decomposed the same for development and test teams.
• Involved in prioritizing the requirements for multiple projects.
• Analyzed the requirement documents, Functional Requirement documents, common components which belong to all the running projects.
• Created the Test plans, test strategies, test scenarios and developed test cases by analyzing the requirements.
• Interacted with the Project Manger to provide estimates for different phases in the projects.
• Involved in Functional testing, System testing, Regression testing, Integration testing, database testing and volume testing which involves ETL Validations in the Data ware house with huge-volumes of data.
• Worked on different projects following the Agile methodology.
• Worked with Putty as an interface server.
• Written Test Cases for ETL to compare Source and Target database systems.
• Ran SQL queries to verify the number of records from Source to Target and validated the referential integrity, Time variance, Missing records, Nulls/Defaults/Trim spaces rules as per the design specifications.
• Performed the CSV File comparison, to compare the data against current production code v/s branch code.
• Validated and compared the data in source table and target tables after the ETL process.
• Verified and validated transformations in ETL mapping.
• Validated Source Target mappings applying various transformation rules and Business Rules.
• Tested the ETL jobs and other ETL Processes and verified mapping of the fields, duplication of values from various sources.
• Wrote the SQL queries to verify and validate the data on source and target databases.
• Maintained JIRA defect-tracking tool, including submitting and assigning defects to the application developers along with the release of defect aging reports.
• Involved in the retrospective process after each iteration.
• Involved in the bug triage process to prioritize the bugs so that the highest priority bugs can be fixed first.
• Interacted with the developers related to the bugs logged during the testing process.
• Provided status on various projects and testing processes to the Project Managers and QA Manager.

Environment: JIRA, Mingle, JAVA, XML, Windows XP, Oracle 10g, MySQL, MS Visio.

Confidential, LA, CA

Business Analyst

• Created software requirement documents, functional requirement documents, and common components which belong to all the running projects.
• Created Use Cases and use case flow diagrams.
• Assisted the testing team in creating the test plan, test scenarios and reviewed test cases based on the requirements.
• Reviewed the Functional test cases, System test cases, Regression test cases, Integration test cases, which involves ETL Validations in the Data ware house with huge-volumes of data.
• Used Charles and FileZilla interface server.
• Ran SQL queries to verify the number of records from Source to Target and validated the referential integrity, Time variance, Missing records, and Nulls/Defaults/Trim spaces rules as per the design specifications.
• Worked closely with the testing team to test the ETL jobs and other ETL Processes and verified mapping of the fields, duplication of values from various sources.
• Involved in extensive DATA validation using SQL queries.
• Used Analysis Report from the server responses and detected large times to first buffer for certain transaction responses. This was reported to the development team which provided the fix before the project sign off.
• Used Clear Quest defect-tracking tool, including submitting and assigning defects to the application developers.

Environment: Rational Clear Quest, JAVA, J2EE, XML, Windows XP, Oracle 10g, MySQL, MS Office.

Confidential

Software Engineer

• Analyzed the requirement documents to create the data warehouse.
• Interacted with the Lead and requirement people to get fully understand the requirement documents.
• Created the strategy and scenarios for the design documents for the ETL process.
• Verified the mappings performed on the data to create the data warehouse.
• Wrote and executed SQL queries to verify the data at the target related to various sources.
• Verified and validated the data against different design documents to create the data warehouse.
• Logged the defects in test director.
• Interacted the development team to resolve the issues.
• Reported the QA Lead to provide the status updates.

Environment: TOAD, Test Director 8.0, Windows XP, IE 6, .NET.