Alwin Therattil Email & Phone Number

6975 Creditview Rd, Mississauga, On

• Work with Clients, Project Managers, Application Developers to research and correct application and data related issues.• Ensure all Data Services packages, stored procedures, scripts and functions are updated as business logic are upgraded to meet Pointclickcare standards.• Act as Project lead to gather requirements establish business solutions. • Operate database management systems to analyze data and perform data mining analysis.• Use ASP.NET to connect to Management Studios to support critical systems and various integration tools.• Optimize stored procedures in to extract, transform and load (ETL) data to ensure reporting infrastructure was maintained according to current service level agreements.• Operate as a contact between the technical support group and development teams to increase awareness of customer issues and resolve problems outside of my group’s reach.• Train junior staff to be familiar with database designs and implementation.

Mississauga,On

• Prepared data audit and claim data for risk adjustment by extracting, cleaning, and merging from different tables using SQL.• Demonstrated hands on experience in analyzing and resolving technical problems by communicated with different departments for critical time based work.• Assisted managers and business analysts in developing reports, presentations, and analysis for upper management.• Built and maintained SQL scripts, indexes, and complex queries for data analysis and extraction for varies projects.• Used SSRS to create versatile reports and presentations for business groups and sales associates

• Wrote and executed SQL queries using Tableau Software to provide custom reports to marketing and sales• Worked closely with the marketing group to gather requirements for custom reports and client lists to support advertising campaigns.• Established departmental procedures, metrics and work flow where none previously existed.• Extensively investigated different data issues and communicated with clients to resolve the issues.

Bsc, Computer Science

Programming Languages: SQL, JAVA, C, C++, PHP, Perl

Business Intelligence Sql Server

1. Understand key Business Intelligence key concepts and structures, 2. Create SSIS packages and make use of control flow and data flow..

Big Data And Hadoop