. Office365 administration.. End user hardware and software support internal. Design and develop a wide range of customized and standard reports. Claim submission to the Government Health Insurance Plans (GHIP)

• Design, testing and optimization of SQL queries and stored procedures • Developing reports using SQL Server Reporting Services (SSRS) and Integration Services (SSIS)• Coordinating with coworkers and clients to design and deliver professional reports • Troubleshoot End of Day ETL Process• Troubleshoot transactional replication process• Troubleshoot reporting related issues and implement hot-fixes

PROFILEInformation administrator with extensive experience coding, testing and supporting database solutions in SQL Server environments. Proficient in an assortment of technologies, including MS Office, Access, Excel, MS SQL Server 2014, Windows, Microsoft Visual Studio 2015 and Microsoft Outlook skills Seeking new job opportunity where my years of experience will be an Asset to your company Key Qualifications include:  Strong analytical, critical thinking, and evaluation skills  Excellent knowledge of legal terminologies used in insurance policy contracts  Strong problem-solving skills  Ability to prioritize and multi-task accordingly to the business needs  Reconciliation of TPA payment Protect B Status Cleared

PROFESSIONAL EXPERIENCEAllianz Global Assistance Information Administrator June 2001 – Dec 2017Main responsibilities include providing support to database administration to meet the demand of internal and external clients, and providing report on the performance of the claim department. Also responsible for suite of 100+ self-service SQL reports from various data sources, internal and external for all areas.• Ensured scheduled reporting was prepared in timely fashion; automated 10+ manual reports• Maintained database support records, wrote SQL queries for ad-hoc data extraction and project analysis, as well as help build reporting warehouses through ETL• Automated dynamic reports and their delivery methods, to ensure the process was efficient, with data integrity • Worked closely with the Finance department on pending and paid claims• Maintained relationship with Insured brokers and agentsPROFESSIONAL EXPERIENCEBDP Associate – Student Loan IR, Claims, Investigation July 1996 to Aug 2001Responsible for Disbursement of Ontario and Federal Student loans. Also processed the Interest relief for students and processed claims as needed • Processed claim under delinquency and submitted the Ontario portion of Claim to Government for payment• Sent claim to collection when loan on Delinquency• Disbursed Ontario and Federal Loans• Processed and Approved IR for student.• Send arrear letter to student when behind payment