Micorosft .Net customer portal

Microsoft .Net customer portal project

Data center and hosting customer asked us to write a portal application for customers that subscribe to data center services. Specifically dealing with ingest and egress. The portal was designed to allow customers the ability to view usage data, log technical issues with onsite equipment and receive communication updates from the data center.

Technologies used:

  • .Net MVC 3
  • SQL Server 2008 R2 databases
  • SQL Server Integration Services 2008 R2 ETL
  • PostgreSQL source system
  • Telerik Rad Controls for data visualization
  • Entity Framework ORM with LINQ
  • TSQL stored procedures

Pengele Responsibilities:

  • Lead requirements gathering sessions
  • Document requirements and gain final approval from the customer
  • Develop the MVC web based GUI (custom from the ground up)
  • Design and implement the OLTP data store (design schemas, tables, relationships and constraints)
  • Develop and deploy all TSQL stored procedures
  • Develop the .Net ORM
  • Develop the authentication and security model
  • Integrate with active directory
  • Create the admin guide and user manual
  • Manage the project
  • Install and configure IIS and SQL Server 2008 R2
  • Design, develop and deploy SSIS packages to pull data from PostgreSQL and load the data into the SQL Server source system for the application
  • Build stage and production environments
  • Deploy the application from DEV > STAGE > PRODUCTION
  • Fix bugs and deploy new application releases