Lawrence Asir

Background

About Lawrence Asir

Around 16+ years of professional experience in development and creative in identifying/ designing effective solutions to meet the current needs and future expectations of business• Main areas of expertise are SSRS, Power BI, SSIS, SSAS,Data Warehouse,Data Modeling, Data Analysis, Python,C# WinForms, VB.NET, Visual Basic, and MS SQL Server.• Solutions - oriented Data & Power BI Analyst with proven expertise analyzing various large datasets for the financial, and datacenter industries • Experience in Data Analyst, Data Modeling, Enterprise Data Management, Data Presentation, Visualization and Optimization.• Around 10+ of experience in SSRS/ SSIS development, around 5 years experience in Power BI – data Analyst and 5+ years of experience in SSAS projects with SQL Server• Around 4+ years of experience in developing windows applications in Microsoft Visual Studio using C#.NET, VB.NET, VB 6.0 with SQL Server 2005/ 2008/2012/2016, VBA Programming (Macros) and MS Excel 2003/ 2007.• Developed OLAP cubes by using SQL Server Analysis Services (SSAS) and defined data sources, data source views, dimensions, measures, hierarchies, attributes, calculations using multi dimensional expression (MDX), perspectives, and roles • Expertise in generating reports using Power BI, SQL Server Reporting Services, Crystal Reports, and MS Excel Power View• Experience in Windows-based application, DB design, performance tuning and unit testing/ functional testing • Worked on a large data migration and data segregation projects in banking domain and Functional domain experience involves banking, finance, and instrumentation • Involved in complete life cycle including analysis, design, development, and testing• Adept in analyzing information system needs, evaluating end-user requirements, custom designing solutions, and troubleshooting for complex Information Systems Management• Good hands-on experience in data warehouse design and analysis of various approaches for maintaining different dimensions and facts in the process of building a data warehouse application• Experience in Support activities (L1, L2, and L3)