SHARADWANTH PUSALA

Beavercreek, Ohio • C: 202-***-**** • ac1ylp@r.postjobfree.com

PROFESSIONAL SUMMARY

Dedicated IT professional with over 7 plus years of progressive experience in data analysis, business

requirement analysis, quality assurance, design, development, and testing to further the success of various

organizations' business goals and objectives.• Authored data mapping and transformation requirements

based on understanding of operating rules, and reviewed with ETL developers to ensure understanding.• Knowledge of industry standard health data code sets such as ICD-10, CPT/HCPCS, and Revenue Codes• Knowledge of Data Visualization tools like Tableau. I am Willing to relocate to Anywhere Authorized to work in the US for any employer

WORK HISTORY

Senior Technical Business Data Analyst - Healthcare

CareSource - Dayton, Ohio 11/2016 - Current

• Perform analysis of all data into, out and within CareSource in support of the Data Warehousing efforts.• Identify

and quantify data issues within the organization and assist in the development plans to resolve data issues.•

Support regular data management processes and adhoc user requests.• Monitor the quality of data submitted to

regulatory agencies.• Supports the maintenance of the Analytics Systems data dictionaries.• Develop, document

and perform testing and validation as needed.• Work with SMEs to develop business rules that support the

transformation of data.• Facilitate discussions between end users and data modelers as needed.• Develop reports

in SSRS to the Ohio State Medicaid department and make recommendations to management in CareSource.•

Reconciliation of large amounts of data across multiple system platforms and sources by implementing Data

Quality Checks per domain.• Helping the internal stake holders in driving business decisions based on data

generated by Power BI dashboards.

Senior Data Analyst Healthcare

Evolent Health - Virginia

09/2015 - 06/2016

• Active role in data exploration and transformation, applying basic statistical methods and visualization techniques

to create useful business insights.• Data Profiling accomplished using Informatica tool.• Performed major role in

obtaining data files, catching and handling exceptions, and performing physical imports and updates of production

data using application tools such as SSIS packages and SQL• Worked on implementation of algorithm logic with

development and QA teams towards PCP Attribution (Primary Care Physician) with underlying Enrollment

administrative data• Develop data mapping documents with transformation requirements based on review, analysis

and thorough understanding of business rules; and review these with ETL architects/ developers to ensure

proper understanding. • Employ advanced Excel data analytic tool, SSRS and Crystal Reports to develop insights

into health care outcomes and the drivers of the outcomes.• Aid the Project team in providing updated data models

using DeZign and creating Process flow diagrams in MS Visio.• Extensive data analysis carried using Advanced

Excel (formulas, VBA, VLOOKUP and Pivot Table)• Serve as SME in primary data domain relative to client's data

and transformation rules.• Benchmark, report, and analyze pharmacy claims data and clinical program data for

impacts to drug utilization, costs, and clinical outcome

Senior HealthCare Data Analyst

Inovalon - Virginia

12/2013 - 09/2015

• Conducted analysis of data files, data layouts and data dictionaries from health care providers (member,

enrollment, claims, provider, lab results etc.) to understand the underlying data structure and business rules for

transforming to common data format.• Organized detailed interviews with data providers to ensure detailed

understanding of logic in data operating.• Established standard processes to ingest data form various PBMS/TPAs

and perform data cleaning, data blending to develop advanced data sets and analytical cubes and data

exploration.• Developed Requirement Gap Analysis and Issue Log documents (from high level DQA of raw data

files) before arriving to the Mapping Documents.• Authored data mapping and transformation requirements based

on understanding of operating rules; review with ETL developers to ensure understanding.• Employed advanced T-SQL and Crystal Reports data analytic tools to develop insights into health care outcomes and the drivers of the outcomes.• Provided data analytical input, including charts, tables, graphs, and other analysis for executive-level presentations and client reporting.• Build, test and report on business user acceptance test cases.• Cross functional role in development and maintenance of automated Performance test scripts in Load Runner for ePAAS application.• Documented current process in Iport Plus into a user guide for use by other teams.• Build, test and report on business user acceptance test cases.

Senior Data Analyst

Global Component Technologies Inc

01/2010 - 11/2013

• Received and analyzed enterprise data management and data integration teams QA and reporting of health plan

client data integrity and data coding issues.• Developed and maintained a deep understanding of measure

technical specifications, as defined by the reporting system/entity, and how subsequent changes will alter

analytics, interventions, and continuous improvement techniques.• Evaluated sources of information to determine

reliability and usability limitations.• Identified relationships and trends in data as well as factors that affect results.•

Used data mining techniques to drill deep into data to identify the key factors driving performance results.• Ensured

timely delivery of reports, and manage conflicting priorities and customer expectations.• Researched and identified

root cause/data issues.• Work with researchers and domain experts to prepare case studies on specific segments

of data.• Executed test cases involving validation of web services by XML requests using SOAPUI.• Set the overall

QA test strategy that includes all the various types of testing.• Maintained QA team capacity planning, utilization

and assignment allocation.• Utilized ATDD techniques to create a robust/reliable /repeatable automation test bed

Sr. Business Analyst -Test Automation

General Services Administration

06/2009 - 10/2009

• Interviewed clients to determine project specs and eliciting requirements using a standard SDLC

methodology.• Participated in Change Request meetings to accommodate enhancements and new requirements

for code already in production.• Authorized and published quality documentation covering all functional and

business-system requirements.• Prepared use cases for each project that documents process loads, different

process paths and system applications.• Served as liaison between various team members, including Developers,

the Quality Assurance team and the client.• Validating the results of the testing processes.• Utilized root cause

analysis in order to determine effective solutions to development issues.• Coordinated and assisting in system and user acceptance testing.•

Senior Business Analyst

University of Maryland University College

03/2008 - 06/2009

• Identified business unit requirements, created project and process specifications, facilitated testing, coordinated

Provided resolution to an

extensive range of complicated problems.• Interaction with senior customer personnel on significant technical

matters frequently requiring coordination across organizational lines.• Designed and development SQL Queries to

validate data and ensuring business needs are met at the same time.• Executed stored procedures aiding the

project team keeping up with demanding customer deliverables.• Documented requirements planned meeting

requirements elicitation.• Developed user stories and workflow diagrams to support the

elicitation process.• Worked with developers to generate mockups of proposed solutions, presenting mockups and

refining requirements.• Collaborated with data warehouse QA team to ensure seamless execution of test cases

end-to-end

EDUCATION

Bachelor of Science : Computer Applications

Osmania University - Hyderabad, India

1996

Started/enrolled into school at Osmania University date of March 1993 through March1996--Graduated

DATA ANALYTICS-HEALTHCARE-HEALTHCARE IT COMPANY

Dear Hiring Manager,

Thank you for the opportunity to apply for the Technical Business Data Analyst HealthCare role at your company.

After reviewing your job description, it's clear that you're looking for a candidate that is extremely familiar with the responsibilities associated with the role, and can perform them confidently.

Given these requirements, I am certain that I have the necessary skills to successfully do the job adeptly and perform above expectations. I am a results-oriented professional who has been consistently praised as hardworking by my peers.

Over the course of my career, I have developed proven problem solving, analytical, and teamwork skills, which I hope to leverage into the Technical Business Data Analyst-Healthcare role at your company. After reviewing my resume, I hope you will agree that I am the type of competent and competitive candidate you are looking for.

I look forward to elaborating on how my specific skills and abilities will benefit your organization.

Please contact me at 202-***-**** or via email at ac1ylp@r.postjobfree.com to arrange for a convenient meeting time.

Thank you for your consideration, and I look forward to hearing from you soon.

Sincerely,

Sharad Pusala

SKILLS

Testing Tools QTP, Load Runner, Quality Centre, Test

Manager, Cucumber, Requisite Pro, Win Runner, and

Test Director. Other Tools SQL Server Management

Studio, MS Team Foundation Server, PVCS, Edocs,

Remedy, Clear Case, Clear Quest, Crystal Reports,

Oracle Forms and Reports, Abinitio, TOAD, Rapid SQL,

DOORs, Start Team, Autosys, Selenium, JMeter, XML

spy and JIRA. Databases SQL Server, Oracle, DB2 and

Sybase. Data Modeller Erwin and DeZign Web Tech

Java, JavaScript, XML, HTML, ASP and VB. Languages/Technologies T-SQL, PL/SQL, SQL, SQR, People Code, MF COBOL, UNIX shell scripting, Ruby, and Gherkin. ETL IBM Data Stage and SQL Server Management Studio.

Contact this candidate