Achuta Ramarao
941 Pheasant Drive, Allen, TX 75013                                             
                       (214) 383-6873
SUMMARY 
•	Skillful problem solver with a desire to build a career in quantitative
analysis, predictive modeling, finance and automation.
•	Excellent background in statistical and financial data analysis.
•	Experienced SAS, Visual Basic (VB), and SQL programming,
SKILLS AND ACCOMPLISHMENTS:
Senior Financial Analyst – Health Care Finance, Blue Cross Blue Shield of TX   
01/2004-Present
•	Currently working building a contract modeling extract. The report goal is to
report the Eligible, Allowed, Paid amount by revenue code. The report would also
enable the user to select the carve out claims.
•	Developed a forecasting model to predict costs for Acute Care Providers. Time
series technique is used to predict the future costs based on historical trend
and seasonality. The model allows the user to select an acute care provider and
the model predicts the costs for the prospective 12 months.
•	Responsible for developing a fully Automated Hospital Paid Claim Activity
Report Using Visual Basic. The goal of the application is to generate a report in
excel, automate the formatting, page set up, headers, and footers of the
spreadsheet.  
•	Developed an application to extract claim and line level information from
Teradata, the back-end code is SQL. The goal of the application is to extract the
claim level and detailed level information from EDW and to check if all the
claims are paid as per contractual agreement between the Provider and BCBS of
Texas.
Decision Support Specialist - HCIRA, Highmark Blue Cross Blue Shield, PA
6/99-12/2003
•	Responsible for forecasting cost per member per month, cost rate per case by
product and facility types using time-series forecasting techniques.
•	Designed a model to analyze the claims processing time measured as lag in
days, and by claim type (In-patient, Outpatient, Physicians, and others). 
•	Developed a VB application to access the enrollment information. The
application downloads the enrollment information from Teradata (UNIX Server) to
an excel spreadsheet.
•	Experienced in using the DXCG software to predict the risk at individual,
client & group level.
Analyst - Crew Planning and Administration, USAirways, PA 	                     
 3/96-05/99
•	Responsible for providing analytical support to Crew Scheduling on manpower
requirements for future flight schedules. Identifying critical equipment types
and crew positions and alerting Crew Schedulers on surpluses and shortages.
•	Developed and implemented a Linear Programming model to schedule Instructor
Pilots. The model saves the company $200,000 per month Per Equipment in crew
costs. The objective of the model is to minimize the costs.
•	Provided decision support to senior management on major Airline planning
initiatives on crew requirements based on cost-benefit analysis.
•	Developed regression models to predict the actual aircraft block hours based
on the scheduled block hours.
  EDUCATION:
	MBA, Finance and OR Cleveland State University, Cleveland, Ohio	        
09/93-09/95
	BS, Industrial Engineering Osmania University, Hyderabad, India	        
05/83-06/87 
COMPUTER SKILLS
•	SAS, SQL, and Visual Basic 6.0.
•	Proficient in MSOffice software (Excel, PowerPoint) for data analysis. 
REFERENCES:  Available upon request