* Heavily involved in gathering user requirement, analysis, designing, coding, testing and implementation.
* Involved in database designing, modeling, maintenance and troubleshooting.
* Involved in Dimensional Data Modeling and adopted snowflake schema for Business Intelligence activities.
* Involved in data extraction, transformation and loading from various data sources by using SSIS.
* Involved in Data analysis, data dimensions, data warehousing.
* Involved in web based application with the interaction with Crystal Report XI and Sql Server reporting services tools.
* Coordination with the vendor for setting up new Purchase Order EDI Processing.
* Practicing Business Intelligence techniques for data analysis.
* Using Sql Server Reporting System for scheduling reports in Excel format in emails and created interface to pass parameter and get desired data.
* Bug fixing for existing web applications.
* Used .Net Framework 3.5/4.0, SQL Server 2008 with Visual Studio 2008/2010 and vb.net/c#.
* Involved in coding and testing in vb.net and C#
* Wrote complex stored procedures, functions, Union and views.
* Export Purchase Order to EDI Files, Excel File and PDF File.
* Used .Net Framework 4.0, SQL Server 2008 with Visual Studio 2010 and TFS.
* Used SharePoint 2010 with InfoPath for supervisor daily report submission.
Created and modified web pages in SharePoint. Administration of permissions and roles.