CHANDANA YALAVARTHI

630-***-**** acf94o@r.postjobfree.com

SUMMARY

> Confident, Outgoing and Highly-Organized Business Analyst/Project

Coordinator has over 8+ years of extensive experience in the field of

Information Systems with emphasis on Business Analysis, Healthcare

Processes, Insurance, Strategic Planning, Healthcare Medicare,

Medicaid based industries.

> Actively seeking a challenging role as a Business Analyst/Project

Coordinator/Planner ideally with a dynamic and progressive industry

forerunner.

> Experience working with Medicare and Medicaid insurance data, Medicare

parts A, B, C & D, and Insurance Claims.

> Worked on various Line of business in Insurance domain and PPO, HMO,

POS, Medicare and Medicaid claims.

> Extensive hands on experience in SDLC using Agile/Scrum methodologies

in multiple projects.

> Expertise in areas of project management, business analysis, process

planning, scheduling and documentation management systems.

> Ability to write SQL queries to check the database integrity and

migration of data.

> Expertise in translating the business requirements into Business

Requirement Documents (BRD's), Functional Requirement Documents

(FRD's), GAP analysis, Use Case & Test case creation and System Test

Scenarios.

> Experience defining business process, governance model, dependencies,

identify risks, doing gap analysis.

> Experience working with business users, developers and senior

management.

Essential Skills:

. Effective interpersonal and communication skills

. Experienced in Document Management

. Excellent organizational skills to reach the required deadlines

. Able to work as team player

. Able to work under pressure and independently

Technical Skills:

. Microsoft Office Suite (Word, Excel, Power Point, Outlook, Access, MS

Project, Visio, Lync)

. CRM System

. UML, Rational Rose

. Lotus Notes

. GoTo Meeting, Live Meeting, Skype, Webx, Lync

. Sharepoint

. Primavera 6.0

. SAP FICO

. DB2, SQL Server, Oracle, SQL, TOAD, SQL Developer

. Windows, UNIX

. Testing Tools: Test Link, Quality Center

. Tax Software: OneSource, Storm

. Accounting Software: JD Edwards Oracle, One-Write plus, Microsoft

Office

. Accounting Professional 2007, Hedberg: Office Systems, Delphi, Wins,

McCloud

Education:

Benedictine University, Lisle IL

Masters of Business Administration

Bachelor of Business Administration

Major: Accounting

Experience:

2014 - Present Catamaran, Chicago,

IL Business / Systems

Analyst

Catamaran - Catamaran provides PBM (Pharmacy Benefit Management)

solutions. They work with several large insurance companies' government

and private to provide members the best possible solution.

Roles and Responsibilities:

Catamaran is in the middle of shifting to new application (call tracking)

from an existing legacy system, so we are working on taking all

the functionality from legacy system and inputting them in to new

application with enhancements and changes applicable to the new system.

. Working with Member Services and Call Center Business people to gather

user and business requirements to create scope documents, Business

requirements documents (BRD), change requests.

. Developed necessary documentation for the release and maintained in the

Team Place (IBM Lotus Quickr - Library).

. Weekly team meetings to go over the Release status, track updates and

discuss any roadblocks we are facing.

. Involved in QA/UAT testing, where I created test cases and executed

them.

. Daily Stand ups to get updates from the testing team and development team

to make sure we are on track for the Go Live Date.

. Working with the Project manager to identify GAP analysis between the

legacy system and the new application to implement them in the next

release.

. Worked with the Call center agents to identify issues they are having

with the new application and bought them to management's attention.

. Identified cosmetic changes that can be made for the new application to

make it more user friendly for the agents and made suggestions to the

team - which is now being implemented in a new release.

. Created several report specs of which some were used for auditing

purposes, some by the clients and other were used internally.

. Created MedD reports, this reports are specifically used for auditing

purposes so I worked with the grievance team to make sure the report met

all the CMS requirements

. Created reports that measured the productivity of call center agents,

research and resolution etc... which were used internally to help improve

the call center

. Created report specs based on the requirements provided by the Business

team. Once the development is completed, QA'ed the reports to make sure

all the requirements are met and send it to UAT testing.

. Maintained any new request from the Member Service related to

reports, enhancements, change requests in the Portfolio Database - were

the items are prioritized and worked in order.

. Knowledge on Healthcare terminology, Medicare and

Medicaid Insurance Data, Medicare Parts A, B, C & D and other Private

insurances.

2013 - 2013 State Farm Insurance, Bloomington, IL

Business Analyst/Program Coordinator

. State Farm has a Change Adoption group in which I worked. This group

helps end user (Agents, Call Center, Cutomer Care, etc..) to adapt any

changes that are going to be released from the state farm side.

. Daily and Weekly stand ups with the team where we go over our work

allocation and bandwith we might have

. Tracked Risk and Issues from the Change Adoption Workstreams.

. Scheduled meetings to update the existing Risk and Issues and document

any new Risk and Issues that wold affect change adoption.

. Prepared weekly status reports as defined by the Change Adoption group

standards and escalates issues to the management in a timely manner.

. Attended Release Execution Lead metings, notes were documented and shared

with the management to make next steps or decisions.

. Schedule meetings and participate in such meetings to complete updates to

project plans utilizing Microsoft Project and distribute updated plans to

management for review.

. Worked on new projects such as Feedbackloop - which tells us the story

once something is implememted if there are any issues from the end users

side and how many are using it and if it is very helpful

. MS Excel was used extensively to create reports, schedules, and T-plans.

. Created TRD's, BRD's and FRD's and identified GAP analysis, also

Collaborated with client project manager and different teams in JAD

sessions to document organization`s direction, structure, business

processes and requirements.

. Created Use Case and Visio flow diagrams to represent all LOB's

functionality and reviewed with the management.

. Determined Web client requirements, researched Legacy applications to

identify data elements requested by clients.

. Also invloved in the Dev-Int testing phase where I created Test Cases and

executed them when new code changes are deployed.

. Worked on legacy application database like DB2 along with Oracle on the

present application for Unit testing and data

analysis/mapping/verification.

. Experience writing SQL queries on Oracle and DB2 databases while testing

the application and verifying the data.

Environment: Agile, JAVA, UAT, JAD, GAD (Gap Analysis Document), Oracle,

DB2, MS Office, Sharepoint, Primavera, Cross platform testing, Test Link

2010 - 2013 Passport Health Communications, Oakbrook, IL

BusinessAnalyst/ Project Coordinator

. Involded in setting up project plans for Business Process Simplification

( BPS ) Project.

. Worked with project managers to develop and maintain project schedules,

schedule status and schedule analysis using MS Project.

. Point of contact for new team members and walk them through On-Boarding

process and introductions.

. Organized Agile process, participated in the sprint sessions, daily

status meetings and tracked the updates.

. Maintain team documentation on Lotus Notes, ensure that team members have

proper access to team site, log Actions Items on SharePoint and track

updates from team members through completion.

. Conducted Joint Application Development (JAD) sessions, requirement

elicitation sessions, workshops, interviews sessions with Subject Matter

Experts (SMEs)/ end users/development group/Client, asking detailed

functionality aspects of business process and carefully updating the

information to the requirements in an easily understandable format.

. Gathering User and Business Requirements and creating Scope document,

Business Requirement documents (BRD), Functional Requirements, (FRD), Use

Cases, Work flow, Wireframes.

. Coordinated with project managers on status of work being performed,

incorporating schedule revisions and regularly analyzing any impacts on

critical path, future schedule work or resource allocation.

. Tracked and measured progress against the approved project schedule on a

daily basis and involved in rescheduling if necessary.

. Developed and analyzed summary and detail level schedule reports and

metrics in meeting project requirements.

. Worked on rescheduling, change management and resource allocation in the

project plan with focus on Critical Path, Slipped Tasks and Upcoming

Tasks.

. Knowledge on Medicare and Medicaid insurance data, Medicare parts A, B, C

& D, and other Private Insurances.

. Maintained activity codes and program and portfolio planning items such

as dependencies, milestones and environment assignments.

. Consolidated information to understand project impacts, develop

appropriate schedules and risk mitigation plans.

. Provided timely and appropriate generation of project information to

management and other stakeholders to ensure expectations are consistent

with the realities of the project.

. Provided scheduling training to project managers as needed.

. Analyzed the historical data and metrics for use in maintaining a

realistic basis for future planning and forecasting and advised project

managers on scheduling on resource risks in the project plan.

2008 - 2010 Acxiom, Downers Grove, IL

Business Analyst

. Scheduled and facilitated business requirements sessions for development

and review of the project scope and high level requirements.

. Followed the RUP methodology for the entire SDLC. Created full life-cycle

documentation from product requirements in the developmental stage to

functional specifications. Experience in developing BRD's.

. Participated in daily Scrum(Agile) meetings of the project and maintained

the schedules and time lines of the sprints.

. Facilitated the project planning process including the identification and

development of work breakdown structure, development of the work package

dictionary, assignment of resources, development of the network diagram,

and development of the project schedule.

. Worked in partnership with client representatives, business unit

partners, and other senior members of the technology team.

. Tracked and measured progress against the approved project schedule on a

daily basis and involved in rescheduling as necessary.

. Identified opportunities for process improvements and made suggestions to

the team.

. Developed necessary documentaion for all the phases of the project and

maintained in Share point.

. Prepared regular status reports as defined by the project reporting

standards and escalates issues to the management in a timely manner.

. Developed a coarse-gained plan for the project, focusing on major

milestones and key deliverables.

. Participated in established project management processes such as Change

Management, Risk Management and Issues Management.

. Created work break down structure (WBS), Activities, Activity

relationships, schedule and steps using Primavera

2007 - 2008 Celergo, Deerfield, IL Project

Coordinator / Administrator

. Schedule meetings and participate in such meetings to complete updates to

project plans utilizing Microsoft Project and distribute updated plans to

management for review.

. Tracked and measured progress against the approved project schedule on a

daily basis and involved in rescheduling if necessary.

. Provide assistance in the preparation of documentation to be reviewed at

team meetings.

. Assist with new employee on-boarding process, ordering necessary

equipment, requesting proper access to necessary systems.

. Maintain team documentation on SharePoint, ensure that team members have

proper access to team site, log Actions Items on SharePoint and track

updates from team members through completion.

. Handled the preparation of accurate, concise and complete weekly/montly

status documentations of management.

. Provided professional support and assitance in the creation and

preparation of documentation to be used for team reviews.

. Maintained and updated project plans, and scheduled meetings and

participated in such meetings to complete minutes.

. Addressed any concerns and issues that were in line with job

specifications and ensured employees' customer service consistently met

company standards.

2006 Accountemps, Oakbrook Terrace, IL

Account Receivable / Sales Tax assosiate

. Processed bills utilizing McCloud

. Posted freight bills

. Processed credit/re-bill and cash receipts

. Performed Accounting Reconciliations

. Processed vouchers utilizing McCloud

. Responsible for preparing sales and use tax returns

. Prepared written communications for sales and use tax issues

. Assisiting clients during audits

Contact this candidate