SANDYA CHILLAKURU

Having 8 years of experience as a Jasper report Developer Having 1.5 years of On-site experience at Nairobi ,kenya. Extensive experience in developing Jasper reports. Jasper Server, iReports, Jasper Server customization Hands on experience in Design, develop and deploy user friendly and rich looking Financial and Billing reports using Oracle PL/SQL, SQL, iReport and deployed onto Jasper Server. Vast Experience in Oracle advance SQL Programming Using unions, Sub Queries, Joins and so on. Good exposure in Product Testing and Web Application Testing. Defined data requirements and report layouts for the business to review. Created testing plans and scripts based on requirements. Having good knowledge on domains like Healthcare domain and Property and Casualty Insurance domain Highly self-motivated and versatile team player with excellent analytical and interpersonal skills.

• Project Title : Kranium Integrated Health Management System
• Product : Electronic Medical Record
• Client : 1.Gertrude’s Hospital, Nairobi, Kenya
• 2
• The Nairobi Hospital, Nairobi, Kenya
• 3.Global Hospital,Hyderabad 4.Star Hospitals ,Hyderabad 5.Naruvi Hosptal,Vellore 6.MGM Hospital, Chennai 7.Andhra Hopitals,Vijayavada
• Organisation : Kranium Healthcare Systems
• Domain : Health Care
• Role : Development and Maintenance
• Environment : PHP, Mysql, Apache
• Description:
• HIS Hospital Information Management System’ is designed to manage the administrative, financial and clinical aspects of a Hospital
• This project takes care of all hospital services like Patient registration, Admission, Appointment, Operation Theatre, Nursing, Laboratories, Pharmacy, Billing etc
• This provides a clear solution to maintain the hospital information for any kind of hospitals
• The Medical records of patient and Administrative records and financial records of Hospital will be saved and maintained in the system
• Roles & Responsibilities:
• Generated Reports based in the client requirement with the Data from database using ETL tools
• Generated many Billing Reports, which can be run to analyze the income Daily , weekly, Monthly and Annually
• Handled Performance Tuning and Optimization by using creating indexing explain plan with strong analytical and troubleshooting skills for quick issue resolution in large-scale production environments located globally
• Monitored Full/Incremental/Daily Loads and support all scheduled ETL jobs for batch processing
• Project Profile In Mastek:
• Project Title : P&C Product Development
• Product : P&C Billing5.0
• Client : Mastek Ltd
• Organisation : Mastek Ltd
• Domain : Property & Casualty Insurance
• Role : Software Test Engineer
• Environment : Java, Oracle 10g
• Description:
• Mastek Ltd is a global IT solutions and services outsourcing provider focusing on Insurance, Government and Financial Services verticals
• Billing5.0 System is Insurance Billing Product developed by STG Mastek, which is basically used as an Isolate billing system for entire billing cycle in Insurance
• It can be easily interfaced with any Policy Administration System (PAS).It is a non-life insurance (Property & Casualty) base product which provides different silos namely Policy, Billing and Claims administration
• Depending on different client requirements, changes are done to the product and sold as new business
• Billing silo includes Manual premium entry, Account creation, Additional Insured creation and Producer/Agent creation
• Through this application we can perform various transactions like applying payment and generating Reports
• We can maintain the cash transactions against policy/account through Billing
• Roles & Responsibilities:
• Preparation of test cases, verification of test data
• Execution of test cases and recording test results
• Involved in Database Testing
• Web services testing using SOAPUI
• Logging of Defects in ePMO and Retesting
• Coordination and follow up with development team to get defect closure
• Defect Reporting/Tracking using Clear Quest
• Checking the database tables and end to end testing which includes executing SQL queries
• Maintaining Daily Status Reports.