Data Manager
Resume:
Avani Chenreddy
**************@*****.***
OBJECTIVE:
To apply my knowledge of the insurance industry in a team-oriented atmosphere; where I can establish a promising and fulfilling career.
SUMMARY:
Over 10 years of IT experience as a Business/Configuration Systems Analyst and SAS programmer. Results-driven, self-motivated professional at Beazley, United Healthcare, Optum Health, ING and VDOT.
TECHNICAL SKILLS:
SAS(Base, Advance and Clinical), SQL, JAVA, Advance Access.
APPLICATIONS:
GitHub, Octopus, TeamCity, DocOne/EngageOne, HighGear, Confluence, JIRA, DRC Ratemaker, InRule Rules Engine, Perforce, ServiceNow.
CERTIFICATIONS
SAS Certified Base Programmer for SAS 9, Oracle PL/SQL Developer (OCA).
PROFESSIONAL EXPERIENCE
Beazley
Role: Configuration Systems /Business Analyst Sept 16 – Current
BeazleyPro is the data capture tool encompassing insured, broker, and product information. A request becomes a submission during the clearing process and the limits and deductible with premium are added into BeazleyPro and the quote is sent to the broker.
Role & Responsibilities:
Assists the business in providing an efficient, accurate and effective service to our brokers and clients and enforcement of project deadlines and schedules.
Maintains project documentation via established project management tools (such as JIRA).
Interacts with the business to gather requirements and providing the results to the business.
Participates in the demand management process to assist the business in establishing business cases relating to new systems or existing system changes.
Assumes a Senior Role in working with the technical development teams.
Performs system integration testing and coordinates user testing and approvals with QA.
Coordinates work with the Shared groups (information management, architecture, and application development and production support.)
Works independently in a senior lead role on all aspects of research, analysis, design, support and development of business solutions.
Ensures issues are identified, tracked, reported on and resolved in a timely manner.
United Healthcare - Regulatory Reporting
Role: Business Analyst July 15-Aug 16
Regulatory Reporting Business Analyst creates and manages outcomes of various reports which include analyzing, reviewing, trending, and presenting the information for regulatory and business planning.
Role & Responsibilities:
Manage the projected path for many regulatory and mandated requirements in the health insurance industry.
Work with regulatory contacts on specifications to extract data needed to complete state reporting requirements and HEDIS.
Define and document business processes and projects.
Conduct meetings with business departments to identify requirements and document.
Define project scope and objectives.
Model business processes.
Escalate issues to the Project Manager as appropriate.
Provide follow up with meeting minutes.
OptumHealth
Role: Associate Business Analyst Mar 12 – June 15
Ingenix Data Quality Manager (IDQM), a web based Data assessment tool, fully automated to accommodate any incoming data formats and to perform enhanced and automated data quality checks with an express implementation time.
Role & Responsibilities:
Maintained carrier contacts, carrier transmission (FTP) and receipt of data for high performance guarantee clients.
Resolved any issues on raw files that Optum receives.
Coordinated with vendors to resolve any problems or issues regarding business requirements.
Facilitated conversations with client/carriers regarding any change in the existing business logic.
Implemented new business logic, code changes and tested data based on client/carrier requests.
Reviewed new code changes by running adhoc reports on the data and get sign-off from the client/carrier.
Presented data investigations to the team if there are any data fall outs.
Designed programs to validate current results with expected results utilizing base SAS Procedures: PRINT, FREQ, SQL, SORT, SUMMARY and MEANS.
Ensured that the production processing is completed according to established guidelines from receipt of raw data from the vendors to the delivery of data to the warehouse.
Evaluated the integrity of data based on industry norms or client specifications.
Involved in user acceptance testing by documenting and writing the test cases on current systems.
ING June 10 – Aug 10
Role: Actuarial Intern
MoSes is an application used for Assets/Liability Modeling. The main goal is to implement the fund progression for the unwrapped data similar to the wrapped data under different scenarios.
Role & Responsibilities:
Executed the reporting tool to understand the fund progression in MoSes for one wrapped separate account.
Designed an excel sheet to match the principles of the wrapped data by performing computations with the values from MoSes.
Extended the excel sheet comparison with all the eight separate accounts.
Created a new excel with basic principles values.
Implemented the same functionality for the unwrapped data and checked the fund progression of the unwrapped data from MoSes with the excel sheet that has the basic principles.
Virginia Department of Transportation and Department of Historic Resources, Richmond, Virginia
Role: Programmer March 07 – April 08
DSS provides an integrated, geo-spatially enabled database of historic resources for government, academic, and private clients using JAVA, SQL and XML.
Role & Responsibilities:
Designed new screens in archaeology section and remodelled existing screens both in archaeology and architecture sections.
Maintained the project; worked on nearly 200 enhancements.
Managed code optimization.
University of Memphis, Psychology Department, Memphis, Tennessee
Graduate Assistant August 05 – December 06
Tennessee Department of Safety funded the TraCS software (Traffics Criminal Software). The main goal is to keep track of criminal history of different counties within the Tennessee state.
Implemented enhancements on TraCS software by integrating the existing forms of different counties using Microsoft .NET and Crystal Reports.
Tutored MS Office to the undergraduates.
EDUCATION
Central Connecticut State University, New Britain, Connecticut
Master of Arts, Mathematics with specialization in Actuarial Science GPA: 3.71 (in progress).
University of Memphis, Memphis, Tennessee
Master of Science, Computer Science, December 2006 GPA:3.17
Adarsh PG College, Osmania University, Hyderabad, India
Master of Computer Applications, October 2004 GPA:3.84
Adarsh Degree College, Osmania University, Hyderabad, India
Bachelor of Computer Applications, June 2001 GPA:3.96
Contact this candidate