Lokesh N.

ABOUT ME

• 9 years of experience as Business Intelligence Developer in Development, Production
In SQL Server 2012/2008 R2.
• Expertise in SQL Server Integration Services (SSIS), SQL Server Analysis Services (SSAS) & SQL Server Reporting Services (SSRS).
• Developed DTSX packages to extract, transform and load into the Campaign database from OLTP database using of SQL Server Integration Services (SSIS).
• Experience in Developing and Extending OLAP Cubes, Dimensions and data source view.
• Designed dynamic SSIS Packages to transfer data crossing different platforms, validate data during transferring, and archived data files for different DBMS.
• Have good experience with designing and implementing MDX queries, OLAP architecture, MOLAP, ROLAP and HOLAP.
• Designing and Deployment of Reports for the End-User requests using Web Interface & SSRS.
• Experienced in programming tasks-Stored Procedures, Triggers and Cursors using SQL Server 2008 R2 with T-SQL.
• Involved in data migrations, transfers using utilities like Data Transformation Services (DTS), and SSIS, Bulk Copy Program (BCP) and Bulk Insert.
• Experience in providing Logging, Error handling by using Event Handler, and Custom Logging for SSIS Packages.
• Well acquainted with SQL Server Technologies SQL, T-SQL, SSIS and SSRS.

SKILLS