C# Asp.Net Core

Architect/Lead .Net/SQL Developer

Riaz Gulamali

***** ******** ****** **.

Cypress, Texas 77433

*********@*****.***

Cell: 713-***-****

Introduction

Broad experience in .Net development environment and database programming and architecture.

Hands on experience in C#, ASP.Net Core, C, VB.NET, VB and Classic ASP programming languages.

Extensive experience in programming web and windows technologies from Microsoft and SQL, Oracle PL-SQL and ETL process and SSAS,SSIS and SSRS.

Excellent knowledge in Object Oriented Design, N tier Architecture and Web Technologies like ASP, VBScript, JavaScript, Angular JS, and XML.

Excellent verbal and written communication skills.

Broad experience with Azure and Azure Dev-Ops with CI/CD pipelines.

SUMMARY:

25+ years of proven experience in programming skills with C# and VB.NET

Proficient in PL SQL/TSQL programming skills, Packages, stored procedures, views, and triggers and Integrations Task using SSAS, SSIS and SSRS.

Experienced with new technologies like WCF, WPF, Entity Framework, XAML, LINQ.

25 years + of proven experience in programming web and Windows technologies from Microsoft with broad experience in solution development and consulting

Excellent knowledge in Object Oriented Design, N tier Architecture and Web Technologies like ASP, VBScript, JavaScript, and XML.

Knowledgeable with the full life cycle development used in many projects following different methodologies and design patterns like MVC, MVP, WPF MVVM and Prism.

10 years of experience with ASP.Net Core, Azure and Docker and Kubernetes

EDUCATION

Master of Science, Major: MIS, University of Houston Clear-Lake, Houston, TX

SKILLS & COMPETENCIES

Architecture: Microsoft Power Platform, Blazor, ASP.Net, WPF and Azure.

C#, Entity Framework,WPF MVVM, Windows Communication Foundation, LINQ, Prism 4.0.

Other Technologies: Java Script, C, Crystal Report, HTML, DHTML, Oracle

.net, SSAS, SSIS, SSRS

Project Name : CenterPointEnergy,

Period : Nov, 2024 to May 2025(6 months)

Company : Houston, TX

Task Area : Consultant :PL SQL Developer, ETL,

Tasks

Designed and optimized PL/SQL stored procedures, functions, and triggers.

Developed SSRS reports, SSIS packages, and SSAS cubes for business intelligence.

Created analytical reports, dashboards, and KPI reports using Power BI and DAX.

Worked on a SSO with Azure Active Directory Blazor web app that keeps track of Plants Maintenance schedule(LOTO),

Resolved deadlock and transaction management issues using Entity Framework Core 8.0.

Deployed using Aspire Docker Containerized Blazor Application to Azure Container Services.

Ran many scheduled jobs thru AutoSys and also helped configure those jobs.

Worked with different Monitoring tools like application Insight and cloud Watch.

Worked with Azure data factory to do data integration and create data driven workflows.

implement indexing strategies that improved query performance by 30%.

Partitioned large tables to improve query performances.

Perform regular maintenance tasks such as updating statistics, checking for fragmentation, and running consistency checks.

Worked with M-Views allowing faster retrievals of queried with Oracle Databases.

Worked with building Databases, building schemas and wrote complex queries.

Worked with many different web services like Rest, ASMX, Soap and gRPC services to satisfy client requests.

Project Name : RADD,

Period : May, 2024 to Oct 2024(6 months)

Company : FDIC, VA

Task Area : Consultant :MS Access, Dotnet, SQL, Oracle

Tasks

Developed and maintained the MS Access Front End RADD application, integrating it with Dot Net Web Services with C#, SQL Server in Azure, and Oracle databases.

Converted RADD Access front end with Identity Login as Docker Container, Blazor Front end With C# project and deployed as Azure App Services.

Led the development, debugging, and enhancement of the RADD application, including troubleshooting stored procedures and generating comprehensive reports.

Created and optimized PL/SQL views, stored procedures, functions, and triggers.

Designed and implemented SSRS, SSIS, SSAS using Data Tools, create DTS packages and generated various reports and Data Integration jobs.

Resolved numerous production issues based on user feedback.

Modified and enhanced multiple SSRS reports to meet evolving business needs.

Used DAX functions with Power BI Desktop

Developed Analytical Report, Dash Boards and KPI reports based on the users requirements and Data Integration Tasks and generate PDF using QuestPDF.

Developed different measure based on the context sensitivity on the reports.

Worked on some deadlock issues in transactions management.

Worked with Entity Framework core 6.0 with back end service with C#.

Project Name : Health Plans Inc, Javelina

Period : October, 2022 to Feb 2024(17 months)

Company : Health Plans Inc, Westborrough,MA

Task Area : Dotnet and SQL Architect

Tasks

Architected and deployed a Azure B To C Blazor Dot Net application full stack with Docker containers, CSS with Bootstrap, Java script, DevExpress Controls and handling its as Docker deployment to Azure, including configuring security settings and DNS and Deploy containers to Azure App Services.

Led the development, debugging, and enhancement of web applications, along with optimizing stored procedures for report generation and application functionality.

Worked extensively on .NET web and Windows applications using C# and VB.NET.

Designed and optimized over 50 SSRS reports, including their associated stored procedures.

Implemented numerous enhancements and resolved bugs for production issues.

Primarily worked with Azure SQL Server databases, Oracle Database PL/SQL with some experience in PostgreSQL and Snowflake and used Azure ARM templates for deployments with Entity Framework Core 6.0

Developed recursive Common Table Expressions (CTE) for complex database queries.

Worked on SSIS,SSAS and SSRS using data tools DTS packages to produce reports, dashboards with Power BI and also Data Integrations Tasks

Developed several Power BI reports based on users demands.

Project Name : Web Application and Reports Development

Period : August 2016 to September 2022(6 Years)

Company : Stewart Title, Houston, TX

Task Area : Lead Application Developer

Tasks

Responsible for all development and debugging and Enhancements of Web application called Stewart Access mostly C#, jquery and javascript and Angular based application on the Front End and WCF service, Web API with .Net core, Classic ASP on the back end with SQL Server and Oracle 12i.

Worked with Optimizely CMS and e-commerce applications using Micro Service with Rabbit MQ, Elastic Search and SQL server and Entity Framework Core 6.0

Developed and maintained Blazor Dot Net, SQL, XML, and Power BI reports, including creating charts and visualizations and Deployment to Azure Container Services.

Handled various enhancements and bug fixes across multiple projects.

Worked extensively with Azure SQL Server, Oracle PL/SQL stored procedures, ETL processes, and debugging.

Excellent knowledge in Python and R programming languages.

Designed reports using SSAS, SSRS and many DAX functions and aggregation in the reports and SSIS for Data Integration tasks and Power BI Reports

Managed deployment issues, including resolving TFS merging and branching challenges.

Managed web and Azure deployment to IIS and App Services including troubleshooting deployment-related issues and ARM templates

Enhanced and maintained identity services, improving authentication processes.

Utilized TFS for task creation, build services, and setting up CI/CD pipelines.

Gained experience with Power Apps, Power Platform, and Power FX technologies.

Project Name : Web and WPF Development

Period : August 2014 to July 2016 (24 months)

Company : Powell Industries, Houston, TX

Task Area : Senior Developer

Tasks

Responsible for all development and debugging of MES (Manufacturing Execution System) this application is a WPF application with MVVM pattern with SOA architecture using WCF services and Oracle database as the backend and Entity Framework.

Created new web pages and debugged Mobile web MVC application used for Kitting Parts usin Angular JS

Worked with WCF library that was used for optimation.

Worked with optimation Windows Service for modification and debugging.

Extensively worked with C# and PL/SQL programming in creating packages and debugging packages for various task and data manipulations and sql reports and ETL process.

Some experience with On pemise Active Directory programming and Azure AD.

Worked with TFS and VSS and lot of deployment of WCF, WPF and Web applications.

Project Name : WPF and Web Development

Period : May 2012 to May 2014 (24 months)

Company : Chevron, Houston, TX

Task Area : Senior Consultant

Tasks

Some hands on Experience with ArcMap and ArcCatalog. Built Geodatabases, played with shapefiles, coverage, personal databases and file databases, digitized point’s line and polygon in ArcGIS.

Worked on a small WPF application that was using ARC GIS Dot net Control.

Created services to be exposed as web services and consume those from the clients thru Html, JavaScript API provided by ArcGIS.

Performed tasks to use SSIS to bring data from other Databases and other integrations tasks to merge and incorporate data from other sources.

Worked with some of the widgets like Popup, Legend, Print, Geocoders and toolbars etc.

Used TiledMapServiceLayer and DynamicMapServiceLayer in our applications also executed query and query task to filter data.

Worked on MVC Web application exposing GIS Data with Java script and JQuery we developed this application from scratch and site was up and running for intranet application in eight months. Worked on Dynamic Ajax pages that would update data without doing a post back with charts and tabs with all sorts of data coming from Oracle.

Developing new forms and new pages and create new classes and object for different reasons in .Net C# and VB.Net programming languages. The backend of all these application are Oracle database and ETL process and Data Integrations task with Entity Framework

Write application from end to end which includes writing the data layer, middle layer as well as the front end and includes writing packages and stored procedure in PL/SQL as well

Project Name : WPF Development

Period : Mar 2011 to Apr 2012 (14 months)

Company : City Of Houston, Houston, TX

Task Area : Senior Consultant

Tasks

Worked with City of Houston CSmart Application which is developed with Microsoft .Net 4.0 Technologies called WPF using the MVVM design pattern, Prism, WCF, and Entity Framework. This is a big application with thousands lines of code and a large backend database of SQL server.

Program in C# and VB.Net using service oriented architecture (SOA)

Serve as Lead Developer in their Payment Module and responsible for developing new features and fixing existing bugs in this application.

Project Name : WPF Development

Period : Apr 2010 to Apr 2011

Company worked : Halliburton, Houston, TX

Consulting Company : Perficient Inc, Houston, TX

Task Area : Solution Developer

Industry : Oil/Gas

Tasks

This project is a WPF project with SQL server as the backend and C # programming language. This is a very large project with more then million lines of code and the architect was using Prism as the shell and individual modules were based on MVVM pattern.

Program in C#, C++ and VB.Net using service oriented architecture (SOA).

Created new applications based on the requirements of the company.

Created new WPF forms, view and view models for the application.

Completed research to handle the requirements of the application.

Modified the EDM and SQL scripts to suit the requirements of the application.

Worked with Data Access Layer and Entity Data Model extensively and ETL process.

Provided prior knowledge of WPF and assisted other developers with any WPF and middle tier issues.

Project Name : Web and WPF Development

Period : Apr 2009 to Apr 2010

Company : Superior Energy Service, Houston, TX

Task Area : Solutions Developer Consultant(Independent)

Industry : Oil/Gas

Tasks

Responsible for creating new Dot Net Nuke modules based on company requirements. This is a .Net Intranet based open source framework

Program in C# and VB.Net using service oriented architecture (SOA)

Converted open source Dot Net Nuke programs to Share Point with various modules like E-commerce, Document Management, Forms and List, DAL Builder Pro and many more modules.

Worked with WCF services on various forms and list applications and many small projects as required by the company.

Primary task was to develop new application and resolve any production issues on the Internet or the Intranet in a timely manner and to customer satisfaction.

Project Name : Win Form Development

Period : Aug 2007 to Apr 2009

Company : MD Anderson Cancer, Houston, TX

Consulting Company : Avanade, Houston, TX

Task Area : Solutions Developer Consultant

Industry : Consulting Company

Tasks

Worked as a lead developer in several project modules with a group of eight person teams and SQL reports and ETL process.

Worked with business analyst to develop and design the modules.

Worked with business user and business analyst to agree on the design of the front end user interface.

Worked with other developer in creating the business entities and business class for the various tiers of the application.

Followed the architectural patterns and best practices guidelines developed by the team architect.

Used various tools like Visual Studio Team suite and Visio to created various modules and UML diagrams

Developed several WPF forms using Visual Studio and Expression Web.

Used Avanade's ACA.Net library on various modules for logging, security and exception handling issues.

Worked with deployment team to resolve any deployment issues.

Designed and developed several WCF modules to access data.

Worked with 40 different database admin to access data and connection issues.

Technical Environment: C#, ADO.Net, SQL Server 2005, Visual Studio .Net Team suite, Windows server 2003,.Net Framework 3.0, SQL Reporting Service, Enterprise library 4.1, WCF, WPF, ACA.net, MVC, MVP, Factory Pattern, Infragistic Controls.

Contact this candidate