Project Quality Assurance

MAMATA KIRSUR

*****-***********@*****.***

Home-860-***-****

Cell-860-***-****

SUMMARY

6+ years of highly analytical experience in Healthcare and financial

Services industry and proven ability to go above and beyond the norm in

generating results for companies

TECHNICAL SKILLS

MS Word, Excel (v-Lookups, h-Lookups, macros, formulas, PivotTables),

PowerPoint, Access, Outlook, Project, Visio, VBA, SQL Queries, PL/SQL,

Oracle Database, SQL Server

EDUCATION

BS in Computer Science from Kolhapur University India; 2000

Cigna Inc. - Bloomfield, CT

Aug 2013 - Till date

Analyst

. Responsible for reviewing, analyzing, and implementing desired plan

benefit features including formulary loads and performing quality

assurance checks by testing claims against the desired benefit design.

. Ensures accurate claim processing by communicating discrepancies found

in set-up and/or quality assurance testing and recommends appropriate

plan set-up changes and/or system modifications when required

. Coordinates with internal and external customers to ensure the

documentation, implementation, and modification of benefit plans is

completed on a timely basis and is updated according to CIGNA policy

and legal requirements.

. Other assigned activities as determined by the Supervisor of Plan

Design

. Consolidate multiple reports, large set data Validation Using MS Excel

tools (V-lookups, Pivot Tables, H-lookups, Macros, and Formulas).

. Prepare summaries and analysis results using graphical representations

and professional formatting.

ESPN - Bristol, CT

October 2012 - July2013

Business Analyst

. Attend project meetings and take meeting minutes to ensure lines of

communication remain open

. Liaison between IT & Business department. Work with business partners

team to define, document, and review business and system requirements

to support projects.

. Consolidate multiple reports Using MS Excel tools (V-lookups, Pivot

Tables, H-lookups, Macros, and Formulas).

. Build ad hoc and standard reports using Microstrategy & Business

Object tools. Assess reporting results through data investigation,

analysis, and evaluation.

. Work with software developers to implement changes from the

specifications in software

. Identify opportunities for improvement based on results of reporting.

Analyze data and trends to create documentation supporting all of the

reports.

. Prepare summaries and analysis results using graphical representations

and professional formatting.

. Ensure that reports support the overall scope of company's business

strategies.

. Maintain data integrity and ongoing quality control of delivered

reports.

. Work closely with all levels of end users, including executive level

staff, to quickly develop reports which will be used to make strategic

business decisions.

. Create detailed documentation outlining report criteria.

. Conducted Business Review meetings with Developers, Stakeholders, and

Business users for better understanding of BRDs.

. Created different test scenarios to test the application behavior in

different environments..

. Involved In UAT testing

Webster Investments - Kensington, CT Dec 2011 - August

2012

Kensington CT

Financial Analyst

. responsible for supporting various accounting and finance initiatives

ensuring changes to underlying accounting policies, procedures,

systems, processes and work flow are effectively implemented and meet

all established Accounting standards.

. Gather the Data from different Relational Databases to Manipulate, and

Reconcile according to the requirement in MS Excel (PivotTables, V-

lookup, Graphs, formatting) spreadsheet.

. Import data in Access database, build the SQL queries, crafted

relationship between two different Tables in the database to analyze

daily data feed for reasonability, quality, and integrity. This

includes balancing, identifying discrepancies, source of exceptions,

which were identified via SQL queries

. Utilized SQL queries to Analyze, identify, and update customer data.

This includes ensuring customer address is accurate and updating

fields due to parsing errors to ensure usable and accurate marketing

lists to increase potential revenue.

. Coordinate with LPL, management, and reps to ensure future customer

data does not have the same issue. Run Ad-hoc reports. Participated

in Project meeting, documented the requirements, and tracked the

progress of the project.

Covidien - North Heaven, CT

June 2011 - November 2011

Data Analyst/Excel specialist

. Create and maintain Excel reports that utilize VBA for Excel to

automate processes, such as extracting data from multiple databases,

manipulating according to the requirements.

. Format charts and tables and distribute updated reports to websites and

email.

. Provide detailed support on Excel (PivotTable, V-lookup), Access, and

PowerPoint.

. Post documents to internal SharePoint.

. Have good analytical abilities & problem solving Skills.

. Facilitate and or assist with client meetings. Provide agendas and

follow up with meeting minutes

. Provide required problem and status and time reporting

. Writing & executing SQL Queries using SQL view point to get information

from the database.

United Healthcare - Hartford, CT

October 2010 - May 2011

Analyst/Project coordinator

. Provide distribution support of reports to team members

. Manage ORBIT database entries for the card team of 15 FTEs.

. Provide throughput support of incoming work and distribution (template

desk).

. Review websites for ID card related information.

. Provide detailed support on Excel (Pivot table, macros and formulas)

and Access.

. Post documents to internal SharePoint.

. Track Card mail dates for the team and enter into 1 global source.

. Provide administrative support to team members as needed.

. Possibly assist in providing information to internal business partners.

. Process some portal transactions in ID card tool.

Computer System Integration (CSI) - Cromwell, CT

January 2007 - October 2010

Data Analyst/Project Coordinator

. Performed analysis and created reports using Excel, Adhoc requests for

management, both internal and external executives.

. Managed time and sets priorities and deadlines.

. Developed and presented project status updates including weekly status

reports.

. Experience tracking and managing project milestones, goals, risks and

deadlines using MS Project, Plan View tool.

Contact this candidate