 Lead development of core application components; full software development cycle technical analysis/design/implementation/testing and deployment. Developing the application using MVC, Entity Data Model, and WEB API RESTful Services. Mentor junior developers, assist with root cause analysis to build long-term solutions Working closely with the client for requirement gathering and analysis and provided the desired solution to the client in time limits. Creating various types… Show more  Lead development of core application components; full software development cycle technical analysis/design/implementation/testing and deployment. Developing the application using MVC, Entity Data Model, and WEB API RESTful Services. Mentor junior developers, assist with root cause analysis to build long-term solutions Working closely with the client for requirement gathering and analysis and provided the desired solution to the client in time limits. Creating various types of reports table, matrix, Drill Down, Parameterized, Cascade and Sub-Reports using SSRS. Created packages included a variety of transformations SCD, CDC and multicast. Created facts, dimensions and star schema representation for the data mart and warehouse systems using Kimball approach. Extracted data from various sources like SQL Server 2008/2012, .CSV, Excel and Text file from Client servers and through FTP. Utilized Power Query in Power BI to Pivot and Un-pivot the data model for data cleansing and data massaging. Implemented several DAX functions for various fact calculations for efficient data visualization in Power BI. Show less