Ankit

WORK EXPERIENCE Consumer Energy Provider – Coventry DATAANALYST June 2008 - Present Collecting, collating and carrying out complex data analysis in support of management & customer requests. Also involved in reporting statistical findings to work colleagues and senior managers. Duties: Manipulating, cleansing & processing data using Excel, Access and SQL. Responsible for loading, extracting and validation of client data. Liaising with end-users and 3rd party suppliers. Analyzing raw data, drawing conclusions & developing recommendations Writing T-SQL scripts to manipulate data for data loads and extracts. Developing data analytical databases from complex financial source data. Performing daily system checks. Data entry, data auditing, creating data reports & monitoring all data for accuracy. Designing, developing and implementing new functionality. Monitoring the automated loading processes. Advising on the suitability of methodologies and suggesting improvements. Carrying out specified data processing and statistical techniques. Supplying qualitative and quantitative data to colleagues & clients. Using Informatica & SAS to extract, transform & load source data from transaction systems.