Chaminda Hewamana

Chaminda Hewamana

Work History

Work History
May 2010 - Jun 2012

Database Specialist

UNDP

•Created SSIS packages (ETL) to migrate data from heterogeneous sources such as MS Excel, Flat Files, .CSV files, Access

•Developed SSIS packages to produce details and summarized reports on a daily basis.

•Created SSIS packages using Conditional Split, Data Conversion, Fuzzy Logic and C#.

•Developed custom reports and deployed them on server using SQL Server Reporting Services (SSRS) and Crystal Reports.

•Generated several weekly, monthly, quarterly, yearly, parametric, drilldown and chart reports using SQL Server Reporting Services (SSRS).

•Built ad-hoc reports using SQL Server Reporting Services (SSRS), Excel.

•Developed Stored Procedures, Functions, Views & Triggers to enforce the business rules.

•Created Indexes (Clustered & Non Clustered) to reduce data retrieval time.

•Created Triggers to implement business control.

•Fine tuned SQL queries to improve query performance and to reduce runtime.

•Reorganized database structures as needed, automate procedures at regular intervals.

•Created and maintained all types of Backups and recovery strategies and set up jobs.

•Set up Profiler Traces, Analyze and replay Profiler Traces for Performance and long running queries.

•Optimized long running Stored Procedures & queries for effective data retrieval.

Environment: SQL Server 2008 (Query Analyzer, Enterprise Manager, SQL Profiler, Index Tuning Wizard, SQL Suite (SSIS, SSRS), SQL Server Business Intelligence Studio, ETL, C#, Windows Vista, MS Excel, MS Access, Ms Word.)

Oct 2008 - Apr 2010

IT Consultant

IAM (Pvt) Ltd

•Develop Stored Procedures, Views,  Functions (UDF), Views, Joins and Sub queries to enforce the business rules.

•Developed data capture applications using C#. 

•Created Indexes (Clustered & Non Clustered) to reduce data retrieval time.

•Created Triggers to implement business control.

•Fine tuned SQL queries to improve query performance and to reduce runtime.

•Extract data from database and export to Excel files for various data users.

•Upload files in Database through weekly run packages in SSIS.

•Scheduled nightly Update the Dimension and Fact tables through SSIS Packages and Updated the cube in SSAS.

Environment: (SQL Server 2008, T-SQL, ETL, C#, SQL Server Integration Services, SQL Server Reporting Services, SQL Server Analysis Services, SQL Profiler, MS Excel 2007, Visual Studio 2008, Crystal Reports XI)

Education

Education

Objective

•To enhance my career as a Business Intelligence, Technical Lead by working to deliver quality results

•Participate in full project life-cycle initiatives that deliver tangible benefits

•Continuous self-improvement through education and involvement

Summary

•Over 10+ years of information technology experience primarily focusing in Data Modeling and Architecture, Data Administration, Data Warehousing and Mining, Business Analysis, Software Systems Analyzing, Designing and Development, BI & Reports Analysis and Development & Statistical analysis.

•Strong Mathematical, Statistical, Computer and Problem solving skills.

•Multi disciplinary exposure engineering and business administration.

•Industrial exposure to in Banks, Financial Organizations, Production, Marketing and Sales Companies, Not for Profit Internationals.

•A well organized, professional, positive attitude, and neat appearance

•Hardworking, Self motivated, , multi skilled, reliable, flexible, quick learner, out of the box thinker and team player

•Excellent communication and interpersonal skills, independent worker and able to manage multiple situations

Interest

Travel, Wildlife

Skills

Skills

VB

C#

PL-SQL

Oracle

Crystal Reports

SSAS

SSIS

SSRS

T-SQL

SQL Server

None