We are professional web development and offshore outsourcing company based in Chennai, India. We are into various services and providing quality services to our clients around the world. Our service includes providing technology solution using the open source web development platform. We have expert team. With their experience and expertise we are keen to provide solutions to you and help your business ideas bringing it to live. Our strength lies in our solutions. We work with various organizations, which are at different levels of utilization of the Internet as a medium to do and increase their business.

• Developed Dataflow to extract data from flat file/Tables and load to Staging area using SSIS 2008• Developed SQL Server Integration Services packages to import new source system feeds• Designed SSIS Packages to extract data from staging area and to load it in dimensions. • Designed & Optimized SSIS data flow to load the data in slowly changing dimension(SCD1 and SCD2)• Involved in cleansing activities of the data as per the cleansing strategies.• Most frequently used components are Lookup, joiner and Derived columns • Loaded various Fact tables as per the templates and ETL specs.• Customized the OLEDB source and Lookup component queries to override the SQL. • Resolve the errors (SSIS package errors which occur during Job chain execution (daily/weekly/monthly loads)• Optimized session performance by eliminating performance bottlenecks.• Developed and used unit test cases for the ETL packages• Wrote appropriate SQL,T-SQL,Pl/sql queries • Developing of scripts to extract data from legacy systems• Good exposure on dimensional modelling includes junk dimension, degenerated dimensions design.• Using MS Excel pivot table functionality, presented the cube based reports to business users for feedback purposes

Assess business needs & translate into effective technical solutions.Design and development of applications using AspDevelopment and design of IT reports using Microsoft T-SQL and SQL Server Reporting Services (SSRS).Import data from Excel spreadsheets to Oracle tables. Export data from Oracle tables to Excel spreadsheets.Worked on multiple data sources including spreadsheets and other text sources.Database development using SQL Azure for cloud based services.Building of Access forms and reports and automation sales process through web

Develop administration tools and procedures Monitor physical operation of all equipment, including servers Setup and maintain the Apache web server Technical support for in-house programmers Maintenance of security policies throughout the network Source code control, archival, and implementation Hardware maintenance