SUMMARY:

• Highly Motivated and Skilled Professional with having 7+ Years related work experience as a Business Analyst involving planning and analysis of requirements, designing, building, testing and maintenance of the product in various industries.
• Expertise in all phases of Software Development Life Cycle and in employing methodologies such as Agile (Scrum) methodology, Rational Unified Process (RUP) and Traditional Waterfall Model.
• Extensive experience in gathering, analysing, documenting the Business Requirements into artefacts such as Business Requirement Document (BRD), Functional Specification Document (FSD), System Requirement specification (SRS) and Requirements Traceability Matrix.
• Extensive experience in project designs, functional documentation, BPMN, Risk assessment, Testing and implementation.
• Good Data analysis skills including Data mapping from source to target database schemas, Data Cleansing and processing and understanding data extract scripts/programming of data conversion.
• Used SQL to query new system during testing phase and to track the activities, used basic SQL scripts and queries to extract data from various data sources into the Business Objects,Excel, Tableau and to manipulate - validate output data of the reports.
• Experience on Salesforce, Microsoft Dynamic CRM 365, 2015, 2016 Entity, Views, Web resources, Ribbon, Chart, configuration and customization, integration with MS Outlook.
• Worked closely with project managers, SMEs and staff to understand and brief the requirements, architecture, ETL as well as reporting data.
• Efficient in conducting workshops and Joint Application Development (JAD) sessions, Project meetings, Reviews and walk through sessions.
• Gathered as well as managed the requirements by prioritizing user stories with proficient use of project management tools like TFS, HP ALM and used JIRA for defect management.
• Created Process Flow/Use Case/Class Diagrams/Interaction Diagrams using Microsoft Visio, Rational Rose and Rational Requisite Pro for modelling and capturing business requirements per UML methodology thus defining the Data Process Models.
• Practical knowledge in writing complex SQL queries, Stored Procedures, database tuning, query optimization and resolving key performance issues.
• Working knowledge on integrating data in the SaaS platform with on-premises back-end systems and databases.
• Well versed with Medicaid Management Information Systems (MMIS), Facets, HIPAA standards and Health benefits Exchange.
• Wrote Test Cases, test plans during various release cycles, documented the in-detail defects using the Defect Tracking reports from ClearQuest and Quality Centre.
• Performed Unit testing, Integration System and User Acceptance Testing(UAT) on claims processing systems, Softwares and Web applications.
• Experience in writing SQL queries as well as using SQL for organizing and abstracting data from MS access, Sybase, SQL server databases, created reports, forms on Ms Access.
• Expert in Product Development starting from Business process analysis, Requirements analysis and review, gap analysis, functional designs, functional test scripts for unit, integration & system test cycles.
• Proficient in Word, MS-Excel, Power-point, Visual Basic for applications, VBA macros along with Hlookup and Vlookup functions.
• Solid understanding on JAVA, methods, functions, and basic knowledge on OOPS concepts.
• Ability to coordinate among multiple teams to implement and establish solid project interfacing and deployment.
• Enthusiastic and adaptive, learning new languages as needed by the project.
• Strong communication and presentation skills.

TECHNICAL SKILLS:

Databases: MS SQL Server, Tableau server, Oracle SQL server, MS Access.

Reporting Tools: Business Objects, Tableau 9.3,10, Microsoft Excel Reports, Crystal Reports, MicroStrategy

Operating Systems: Windows XP Professional, Windows 2003, Windows 7,MS Windows 9X, Windows 8, Linux

Methodologies: Software Development Lifecycle, Waterfall, Agile,Scrum methodologies, Rapid Application Development (RAD), UML

Requirement management Tools: MS Visio, MS Office, Rational Requisite Pro, Rational Rose, Clear quest, Quality Centre, Smart Draw, MS Paint, VBA, Access-create database, report writing, power point presentations

Project Management tools: Test Director, Requisite Pro, MS Project 2010, MS Office 2010, Lotus Notes, MS Outlook, JIRA 6.1, 6.2, One Note.

IDE Tools: SQL Developer, Eclipse, Microsoft Visual Studio 2010/2008/2005

WORK EXPERIENCE:

Confidential, Nashville, TN

Sr. Business Analyst

Responsibilities:

• Working as a liaison between stakeholders and IT team to understand and translate business needs
• Provided testing and package deployments on medical claims process changes. Created change requests prior to production deployments.
• Led weekly/bi weekly meetings for the elicitation of business needs through communication and teamwork in order to achieve clear requirements from project team managers/members.
• Wrote functional business requirements for review and obtained shareholder approval.
• Assisted in review of technical requirements and oversaw creation of traceability matrices.
• Responsible for creating project artefacts like business case, vision and scope document.
• Analysed the Business Requirement Documents (BRD)&Source to Target Mapping Document (STM) for better ETL Process before the development.
• Responsible to document repository of end to end data flows for all applications and Data Interchange interfaces.
• Liaison between IT, Finance and Customer service departments and responsible to translate the requirements back and forth.
• Furnished required documentation for each project based on the complexity of the project. Documentation includes Project Charter, Project Execution Plan, Requirements document, Requirement Traceability Matrix, Requirement Report, Design report, Implementation Plan etc.
• Organized the Business Analyse calls, Off-shore transition meetings, Design/Build meetings and Test status/monitoring calls.
• Analyze, standardize, document, train, and maintain global processes and procedures for working with CRM.
• Conducted weekly meetings for deciding the Policies and Procedures to be followed while constructing new sites
• Involved in mapping customer requirements to Microsoft Dynamics CRM 365.
• Work across functional teams to facilitate CRM analysis such as dashboards and reports
• Performed the business process modelling,Business Process Reengineering by identifying and analysing gaps and filling them.
• Prepared Functional specification documents, business architectures and worked with development teams in developing technical specifications.
• Tracked business systems metrics, budgets and provides reporting.
• Worked with business users to translate ETL requirements into system flows, data mappings, Jobs create transformations, manage metadata, execute business processes and monitor them.
• Good understanding on development of ETL mappings using Informatica Designer and manage source/targets connections, folders, objects, users etc.
• Analysed different business reports and guided the team on deployment and customization of those reports in CRM dynamics.
• Worked on documenting different data warehouse architectures as well as network architectures.
• Understood business goals and business context and translated them into technical specifications.
• Delivered to others on the use of Tableau and on Business Intelligence software including business objects to navigate and use the visualizations.
• Responsible to analyse data from large datasets, using geospatial and/or statistical analysis tools.
• Used several high end technical functionalities in tableau such as pivoting the pulled data, calculated fields, parameters, action filters, highlighters and KPIs towards building data visualizations using survey data for clients.
• Responsible to connect data into Tableau reporting tool to create graphic rich dashboards and visualizations for clients.
• Excellent communication skills and proven ability to work with business customers, and technical teams.
• Provided feedback on the quality of data including identification of billing patterns and outliers

Environment: JIRA, Oracle SQL Server, SaaS, SQL developer, MS outlook, MS office, Excel, CSV, SQL Server, Onenote, Informatica, CRM dynamics 365.

Confidential, Washington, D.C

Business Systems Analyst

Responsibilities:

• Served as the lead internal point of contact between the subject matter expert, project manager and development resource/vendor for the National Council's core business applications and other related systems.
• Interface with and act as a liaison between business stakeholders who have made the request and the IT team that is designing, developing, testing, and implementing the solution.
• Only point of contact between IT Department and Communications Department by playing a crucial role in addressing direct requests/inquiries from customers and clients etc.
• Assist the team in testing approach, test data identification, and scenario review activities and acted as a single point of contact for clarifications on business and functional aspects of the system.
• Performed Data analysis to provide data reports as per customer’s data requests.
• Responsible to pull large chunks of data/reports from Dynamics CRM, converting the data to excel or csv files and pulling the data reports as per requirement.
• Responsible to connect data into Tableau reporting tool to create graphic rich dashboards and visualizations for clients.
• Performed analysis and involved to construct the documents with scope statements, business requirements, use cases, business process flows, and implementation needs to support to construct a fully functional working ERD and BPMN.
• Made Process models such as flow chart, BPMN, or event-process-chain (EPC) diagrams, if needed, to provide a better understanding of the application. he desired end-state.
• Constructed High level ER data model of each cluster (i.e., of a use case) in Visio.
• Made an Integrated ER model based on the individual ER models.
• Formulated a Relational representation using SQL Server.
• Facilitated design reviews with the IT team and revises the design/requirements as needed based on scope, timelines, and technical feasibility feedback.
• Keeping track of Cases and Creating Dashboard in MS Dynamic CRM.
• Developed user acceptance test scripts and coordinate testing of new systems and/or functionality using HP ALM and JIRA tools.
• Provided on system functionality on core systems, as needed to internal stakeholders
• Responsible to create, oversee, and catalog queries, reports, dashboard, pivot tables, and other reporting output to support business initiatives
• Coordinated and elicit requirements for and assist with documentation on all association core applications.
• Building custom components in Microsoft Dynamics CRM based on gathered functional requirements.
• clients on using and troubleshooting technical components of a complex software solution, and perform Data Migration, Data Validation, and upgrades.
• Perform system functionality testing and quality assurance during specific upgrades or other initiatives.
• Tracked business systems metrics, budgets and provides reporting
• Involved in QA testing in preparing QA test approach, test plans, ensured proper test coverage for all requirements and business rules by designing extensive test conditions (positive as well negative test scenarios) and writing test cases for each test condition.
• Conducted UAT testing successfully and actively involved in interaction with the business users and getting business sign-off.
• Developed the release checklists and prepared implementation/deployment plan.
• Collaborated and coordinated projects with, project sponsor, project manager, database administrator and external resources
• Other duties as assigned

Environment: Business Objects, CRM Dynamics, Share Point, MS office, SQL server, Red Booth, Zendesk, Survey monkey, Drupal, Talend.

Confidential, St louis, MO

Business Analyst

Responsibilities:

• Involved in development & documentation of Software Requirements Specification (SRS) using Rational Rose.
• Elicited requirements for development of the users' GUI, interfacing with various systems.
• Utilized RUP (Rational Unified Process) to create use cases, activity diagrams, class diagrams and workflow process diagrams.
• Main point of contact between multiple teams.
• Dynamic CRM mainly helped in tracking and basic commands using voice for simple tasks.
• Involved in gap analysis of the existing system and the to-be system.
• Documented project artefacts such as Stakeholders Analysis, Business Requirement Document (BRD), Functional Requirement Document (FRD), Test cases and Test Plans.
• Scheduled and conducted meetings with user members to identify requirements documented them in specification documents and identified priorities.
• Planned and defined system requirements to Use Case, Use Case Scenario and Use Case Narrative using the UML (Unified Modelling Language) methodologies.
• Worked in the ETL Procedures and processes. Reconciled disparate master data from distributed systems and synchronized this reliable data with analytical and operational systems using master data management (MDM).
• Keeping track of Cases and Creating Dashboard in MS Dynamic CRM.
• Developed the test plan, test conditions and test cases to be used in testing based on business requirements, technical specifications and/or product knowledge.
• Created DTS Packages for migration of data between MS SQL Server database and other databases like MS Access and MS Excel.
• Extensive use of MS Office tools for data migration into System Knowledge Data Base in Microsoft SharePoint Designed and developed Call Flows, Use Cases using UML and Visio.

Environment: Share point, MS Visio, Java, UML, MS-Project, MS Office, SQL, Testing, and Windows XP/10. Rational Unified Process.

Confidential

Business Analyst

Responsibilities:

• Designed and development of test cases based on functional requirements for Institutional and claims for EDI and HIPAA Transactions 837/835, 834, 276/277, 270/271 testing.
• Performed System testing of the Claims processing systems (Pricing Rules, Duplicate/Limits validation, Member Eligibility, Provider Enrolment, et al).
• Performed testing for Medicare, Medicaid and X-Over claims for Medicaid Management Information System (MMIS).
• Prepared documents for business requirements document (BRD), systems requirements specification (SRS), high level design documents (HLDD), and traceability mapping / matrix with the assistance from the business group, and the IT team members.
• Prepared graphical depictions of Use Cases, Use Case Diagrams, State Diagrams, Activity Diagrams, Sequence Diagrams, Component Based Diagrams, and Collateral Diagrams and creation of technical design (UI screen) using Microsoft Visio.
• Conduct complex documentation and user needs analysis. Interface with team and staff to develop HL7 integration.
• Utilized corporation developed Agile SDLC methodology.
• Involved in full life cycle of Business Objects reporting Application.
• Lead Business Intelligence reports development efforts by working closely with Teradata, and ETL teams.
• Assisted JAD sessions to identify the business flows and determine whether any current or proposed systems are impacted by the EDI X12 Transaction, Code set and Identifier aspects of HIPAA.
• Trained and guided the new staff on the company’s standards, delivered presentations on Role of Business analyst in project life cycle.
• Used Scrum Work Pro and Microsoft Office software to perform required job functions.
• Assisted to develop the Test Plan, Test Cases and Test Scenarios to be used in testing based on Business Requirements, technical specifications and/or product knowledge.

Environment: Windows 2000/XP, Business Objects (BO), Agile, Rational Requisite Pro, MS Office, SQL Server 2005, DB2, MS Project, MS Access, HP Quality Center.

Confidential

Jr. Analyst

Responsibilities:

• Created the functional requirements specification from the business requirements.
• Conducted and Participated in JAD Session with the business users.
• Analysed and prioritized user and business requirements as system requirements that must be included while developing the software.
• Gained better understanding of SDLC methodology working on different domains and types of projects.
• Prepared logical Data Models that contains set of diagrams and BRDs (Business Requirement Documents) supporting documents containing the essential business elements, detailed definitions, and descriptions of the relationships between the actors to analyse and document business data requirements.
• Planned and defined system requirements to Use Case, Use Case Scenario and Use Case Narrative using the UML (Unified Modelling Language) methodologies.
• Created Use Case Diagrams, Activity Diagrams, Sequence Diagrams, Class diagrams and ER Diagrams in MS Visio.
• Worked on projects that involved usage of HTML, CSS, XML and Web 2.0 concepts.
• Wrote test cases and test plans for the web applications and Involved with testers to perform manual testing and automation testing.
• Attended the for understanding the concepts of extracting the data from multiple databases, transforming in a format compatible and loading the same.
• Worked on MS SQL Server Data Warehousing for one of the in-house product called Archive-Plus, a tool to archiving and purging data.
• Aware of concepts of creating reports on daily, weekly and monthly basis for strategic and tactical decision-making process.

Environment: MS Visio 2007, MS PowerPoint, MS Word, XML MS Project 2007, MS Outlook, SDLC, White paper, CMS, OO analysis, UML, MS SQL Server, Product marketing.

Confidential

Data Analyst (Intern)

Responsibilities:

• Involved in the migration from SQL server .
• Analysed and visualized raw data using Excel to sort the reported problems/ bugs by priority/urgency.
• Completed daily reports to summarize all the issues and propose associated action plans to improve workflow efficiency and service effectiveness
• Gathered and researched customer experience data and feedbacked to service department to help mapping product features to shape development.
• Actively involved in Normalization of database.
• Create rules, defaults, tables, views, clustered & non-clustered index, user defined data types, and user defined functions.
• Optimize query performance by creating indexes.
• Involved in merging existing databases and designed new data models to meet the requirements.
• Use DDL and DML for writing triggers, stored procedures, and data manipulation.
• Installed and Configured SQL Server 2005 on development server for designing and testing.
• Worked on client requirement and wrote Complex SQL Queries to generate Crystal Reports.Prepared test case scenarios and internal documentation for validation and reporting.