• Lead analysis, data architecture, functional design and development of data warehouse and BI solution. • Primary roles include the lead role in gathering, creating, and editing requirements for the Business Intelligence (BI) program by partnering with the appropriate business and technical teams. • Created Cross-Tab, Drill-down, Cascaded Parameterized, Charts and Sub-Reports using SSRS• Created data models with Report Builder 2.0 to provide a template for end-users for creating… Show more • Lead analysis, data architecture, functional design and development of data warehouse and BI solution. • Primary roles include the lead role in gathering, creating, and editing requirements for the Business Intelligence (BI) program by partnering with the appropriate business and technical teams. • Created Cross-Tab, Drill-down, Cascaded Parameterized, Charts and Sub-Reports using SSRS• Created data models with Report Builder 2.0 to provide a template for end-users for creating reports by themselves with pre-selected group of relational tables.• Used Expressions, Functions and wrote custom code using C#.Net for the dynamic sorting, dynamic visibility and dynamic columns using SSRS 2012 and configured in both Native and SharePoint mode.• Reducing time and labor by 80% by developing new or enhancing existing SSIS ETL processes by implementing an automated data driven process using Visual Studio/BIDS.• Improved the performance of the application by 22% by creating proper clustered, non-clustered, covered indexes in a secondary file group (NDF) and partitioning. • Constructed End User Computing data-warehouses for reports displayed on SharePoint.• Developed VS/SSIS packages using 2012 project configuration, For, For-Each and Sequence loop containers, configured Slowly Changing Diminutions (SCD’s), and implemented SSIS transactions to enable complete commit or rollback in case potential unknown exceptions and configured checkpoints to resume package executions while first few initial runs of SSIS packages on Production.• Created REST Web API Specs and developed the same to the larger extent using MVC Web API’s.• Consumed WCF Rest Services to populate data in SSRS Reports over web service from partners.• Implemented Script Task in SSIS Packages using extensive C# and .NET assemblies to create customized Excel Reports and populate data from Oracle Databases. Show less