Sign in

Business Analyst

United States
June 05, 2017

Contact this candidate

Mahalakshmi Veerabadra 609-***-****

Professional Summary

9+ years of experience as a Business Analyst with strong knowledge in requirement analysis, agile project and Business Intelligence tools with widespread industry domain knowledge in Finance, Healthcare and Supply Chain Management.

Worked in all phases of Software Development Life Cycle (SDLC) including Production and Deployment.

Extensive experience in Waterfall and Agile (Scrum) methodologies, enterprise environments, architectural and solution design, implementation and complex customizations.

Expertise in conducting in-depth Root-Cause Analysis, GAP Analysis, SWOT Analysis.

Liaison to several cross-functional teams and in-depth understanding of the AS-IS and TO-BE business processes.

Assisted in conducting Cost Benefit Analysis and ROI Analysis.

Detailing user stories from Product Backlog, Sprint Backlog and clear understanding of Burndown charts.

Highly efficient in Requirement Gathering, Modeling, System Designing, Testing, Validation, Workflows and Data Management.

Lead planning meeting, Joint Application Development (JAD) sessions for eliciting requirements from stakeholders through focus groups and interviews for documenting the BRD, FRD and FSD.

Prepared graphical depictions of project processes using Use Case Diagrams, Mock-ups, including the business workflow using MS Visio.

Experience in converting the business into technical specifications for preparing Test Plans.

Efficient in reformulating strategies through Process Re-engineering, Change Management, Release Management, Process Improvements and UAT Testing.

Implemented Data Modeling techniques including Data Visualization, Data Warehousing, and Data Mapping.

Traced Requirements throughout the development process and verifying adherence using the Requirement Traceability Matrix (RTM).

Knowledge in generating Reports, Analytic Snapshots, and Dashboards, enabling Email Services and also constructing Page Layouts.

Good understanding about Electronic Data Interchange (EDI) standards: 270, 271, 835 and 837 which are used in various business processes.

Experience with HIPAA compliance and involved in upgrading of HIPAA 4010 transaction to HIPAA 5010 in healthcare with a strong understanding of Medicaid and Medicare rules and claim adjudication.

Strong knowledge and understanding of ICD-9 and ICD-10 coding and claims processing.

Excellent interpersonal skills, effective writing, and oral communication skills.

Ability to work both independently and as part of a team to meet objectives and possess the ability to motivate the team towards successful completion of project milestones.


HIPPA Certification

CBAP Certification

Skill Set

Domain Expertise

Healthcare, Banking, Investment Banking, and Supply Chain Management


Agile – Scrum, Waterfall

Business Modeling

MS – Visio, Enterprise Architecture

Management Tools




Document creation/Management

MS Office Suite – Word, Excel, Outlook, PowerPoint, MS Project, OneNote, Adobe Acrobat, Lotus Notes

Content Management

MS – SharePoint

Database Management

Oracle, MS SQL, MySQL, MS – Access, Informatica

Business Intelligence

Microstrategy, Power BI, SAS, Tableau

Operating Systems

Windows, MAC OS, Unix, Linux

Work Experience

Client: Cambia Health Solutions (Portland, OR) Jun 2016 – Till Date

Role: Business Data Analyst

Project Description: Predictive Analytics using Claims Database, This study focused the power of modern analytics on hereditary angioedema (HAE), a single rare disease, because it exhibits features of diseases associated with high costs: rare, hard to diagnose, progressive, and takes a long time from diagnosis to appropriate treatment. Despite the availability of effective therapies, misdiagnosed and under diagnosis of HAE result in a significant burden to the healthcare system. A 3-stage process was applied to a claims database to: a) define the characteristics (diagnoses, procedures, therapies, and providers) of patients in the database already being treated for HAE, b) use those characteristics to create a model of patients with HAE, and c) use the model to identify patients with HAE in the database who were not yet diagnosed. Conclusions: This study successfully demonstrated the ability of this state-of-the-art predictive analysis to find rare-disease patients in a large and complex database. This information could be valuable to claims managers and employers who may realize savings by helping physicians bring these patients to appropriate treatment sooner.


Data collected from various sources and categorized as required.

Demonstrated the ability of this state-of-the-art predictive analysis to find rare-disease patients in a large and complex database.

Documenting the types and structure of the business data (logical modeling), Requirement Management plan and BRD.

Analyzing and mining business data to identify patterns and correlations among the various data points.

Mapping and tracking data from system to system in order to solve a given business or system problem.

Designed and created data reports and reporting tools using Tableau to help business executives in their decision-making,

Performed statistical analysis of business data.

Enhanced the schedule after the brainstorming JAD sessions and documented the limitations.

Prepared Scheduling and Estimation reports using MS Project, MS Word, MS Access.

Prepared a detailed summary of the work done on that particular day and checked whether all the resources are available for next day’s work.

Environment: SQL, MS Office Suite – Word, Excel, Project, Visio, Share Point, Tableau, Agile Methodology

Client: Walgreens (Deerfield, IL) Aug 2015 – June 2016

Role: Business Systems Analyst

Project Description: The Specialty pharmaceuticals provide hope for patients with chronic, complex or rare disease states that do not respond to traditional drug therapies. But like most health plans, our client faced several key challenges for their clinically administered specialty medications; Limited distribution, Administrative burden, High program costs, Appropriate clinical management. The health plan initiated a Medical Injectable Drug (MID) program in 2002, working as their specialty pharmacy provider (SPP). The MID program was developed as a method to manage specialty pharmaceuticals that are commonly administered in physician offices and reimbursed under the medical benefit. Under the program, the specialty pharmacy billed the health plan directly for the cost of the specialty medication and the physician continued to bill for the office visit and the administration. This relieves the physician from needing to bill all three components as is typically required with a more traditional buy and bill process. The program was associated with health plan cost savings as targeted. This was achieved by changing reimbursement channels: about more physician-administered injectable pharmaceuticals changed from reimbursement to physicians, to reimbursement to Walgreens as a single specialty pharmacy provider.


Formulated and defined system scope and objective based on user needs and thorough understanding of business processes, best practices, and available supporting technology.

Defined the functional requirements, designed UML diagrams and worked with the team to provide technical guidance, design specifications and approach using MS-Visio.

Collected and defined requirements translated into functional design documents and participated in the technical design, test planning and user documentation and BRD processes.

Worked with other business analysts, project manager, business owners, QA teams, and developers to support development and delivery of a high-quality product compatible with release timeline targets.

Analyzed business practices throughout business departments and utilize this information to influence process improvements.

Study and analyze information about alternative courses of action to determine which plan will offer the best outcomes.

Conducted system demonstrations and coordinated the creation of user guides.

Environment: SQL, MS Office Suite – Word, Excel, Project, Visio, Share Point, Agile Methodology

Company: Bank of America (India) Apr 2013 – Jul 2015 Role: Business Analyst

Project Description: Provide access management support for critical Global Risk Technology and Risk, Capital Investments & Treasury Technology applications to ensure correct levels of access while maintaining audit compliance. Design and document numerous processes for application and development teams. Analyze process requirements from senior leaders and train a wide scope of associates to ensure consistency.


Gathered requirements from product owner and SMEs, through interviews, surveys, prototyping and worked with teams to identify the gaps and defects.

Assisted planning, decision- making and reporting by analyzing the resources and operational risks involved.

Collected data every month from metrics and determine trends and patterns in organization’s performances. Traceability with clients and getting sign-offs for all recommended solutions. Worked on the Business Requirement Document to record new release & change involved adhering to the Software Development Life Cycle process.

Created and Automated SQL Server Reporting Services(SSRS) Reports.

Provided access management support for critical Global Risk Technology, Capital Investments & Treasury Technology applications to ensure correct levels of access while maintaining audit compliance using JIRA.

Developed and automated tools and scripts to increase efficiency and automate repeatable tasks.

Environment: SQL, SSRS, JIRA, MS Office Suite – Word, Excel, Project, Visio, Share Point, Agile Methodology

Client: Ace Hardware Corporation (India) Dec 2009 – Oct 2012

Role: Senior Systems Executive

Project Description: The project involved enhancing the application maintenance and process optimization for the ACE Hardware Inventory tracking system. It includes assisting the QA and the development team to support the ordering and warehouse management on various applications such as Web, AS400, Mainframe, SAP and CICS. The additional functionalities are performing the change management process and deploy production changes using Endeavour.


Involved in Development and Monitoring Application. Work closely with the development team to deploy change management process and BRD documentation.

Expertise with Developing SQL scripts and Performance Tuning.

Analyzing business requirements, propose flexible solutions, and provide specifications and designs in support of application development, use cases and UML diagrams using MS-Visio.

Configured and supported batch schedules, reporting distribution systems and data exchange activities.

Identified data issues and provided recommendations for resolution to ensure optimal performance.

Worked on tight timelines and interact with different stakeholders handling day to day issues and incident management, releases.

Environment: SQL, MS-Visio, AS400, CICS, TSO, CA7, Mainframe, Endeavour

Client: Morgan Stanley (India) Sep 2007 – Nov 2009

Role: Jr. Business Analyst

Project Description: Morgan Stanley is a leading global financial services firm providing investment banking, securities, wealth management, and investment management services.

This project was driven by the need to adjust Morgan Stanley Laser (Sybase) system against supporting repurchase claims from previous servicers. This includes decommissioning several access databases and removing the dependencies on any Morgan Stanley SQL server databases.


Gathered business requirements by working directly with the key senior acquisition and portfolio management teams to translate them to functional and technical specification for the development team to meet the business needs for servicing originated loans.

Worked closely with the development team to work on the UML diagram, requirement management plan, use cases and to document the BRD using MS-Visio and MS-Word.

Analyzed and proposed cost effective solution by carefully evaluating the options by working closely with the PM and technical leads.

Performed GAP analysis, RTM to meet the expectation of the end users, IT staff and business sponsors throughout the process from inception to warranty period.

Conducted high-level analysis for Portfolio Management, converted over 70K loans from Morgan Stanley's Laser (Sybase) system to utilize an existing .NET application.

Created presentations for the business meetings using PowerPoint and Excel.

Created reports using Microstrategy by working closely with the development team.

Developed test plans and scenarios, regression testing to compare the results.

Applied Agile Methodology to ensure sprint timeline was met and have created backup options when the milestones pass critical deadlines.

Provided training for the end users, support, and guidance on the product/functional feature.

Environment: Microstrategy, MS-Visio, MS-Office, .NET, Agile Methodology

Contact this candidate