Senior Software Consultant - .net Resume
Princeton, NJ
SUMMARY:
- A results - driven IT professional with over 14 years of experience building high-performance, scalable enterprise applications that solve business problems effectively.
- Passionate about creating truly innovative and exceptional software and committed to maintaining cutting edge technical skills and staying up to speed on current technology trends and best practices.
- Proven technical skills and a strong familiarity with all phases of the application development lifecycle.
- A passionate achiever in pursuit of excellence and growth.
- Dynamic IT Professional with 14 years of wide-ranging experience in managing and executing Design and Development of various business applications at the enterprise level using cutting edge Microsoft .NET framework Stack.
- Strong expertise in building multi-tier class applications at par with the enterprise standards and proven patterns.
- Transformed challenging business requirements into appropriate reusable Object Oriented Design (OOD) using accepted design patterns.
- Proficient problem-solver who envisions business and technical perspectives to develop workable solutions.
- Good exposure to agile methodologies, practices and design principles and patterns.
- Demonstrated consulting capabilities to rationalize and optimize business process design implementations.
- Creative thinker who foresee new problem with an innovative solution.
- Optimistic Self-Motivated & Passionate achiever in pursuit of excellence and growth.
TECHNICAL SKILLS:
Web Technologies: C#, ASP.NET MVC, .NET Core, ASP.NET Web Forms, AJAX, JQuery, ASP.NET Web API 2, WCF, Web Services, JSON/SOAP/REST Services, REST APIs .Net Framework 4.5, LINQ, ADO.NET, Entity Framework 5/6, HTML5, CSS3, Bootstrap,Team Foundation Server(TFS), VSS, CruiseControl.NET, Infragistics controls, Data Visualization, Kendo UI, SOA Patterns, Design Patterns,Signal R,Contentful, OAuth 2.0, JWT, Identity Tokens, X509 Encryption, Symmetric &Asymmetric Keys, Angular JS, Angular 2. Couchbase, MemCached, RedisCache Cloud.Power BI, Azure SQL Database, Azure Cloud Services, Azure SQL Warehouse, HDInsight, Azure Service Bus, Azure Scheduler.
Languages: C#.NET, C, C++, SQL, PL/SQL,Java
RDBMS: SQL Server 2015, Oracle 10g
Reporting Tools: Crystal Reports 11, SQL Server Reporting Services (SSRS), Active Reports 3.0
IDE: Visual Studio.NET 2012/2008, SQL Server Management Studio, Fiddler,SQL Server Integration Services (SSIS)
PROFESSIONAL EXPERIENCE:
Confidential, Princeton, NJ
Senior Software Consultant - .NET
Responsibilities:
- Developed a Web API Security architecture using OAuth 2, JSON Web Tokens (JWT) and JavaScript Object Signing an Encryption(JOSE).
- Developed and architected a multi schemed Authentication API, using OAuth 2 and X509 Certificates.
- Developed an encryption and decryption service API using RSA Public and Private Key Pair.
- Developed a CRUD based RESTful API Service using ASP.NET WEB API and C#
- Implemented Domain Driven Design for better scalability and maintainability.
- Developed Web based UI using ASP.NET MVC, C#, AngularJS and Bootstrap which consumes REST APIs.
- Developed a library using EPPlus to generate data driven templates in excel and support upload of the templates.
- Developed a process queue using Mass Transit and Rabbit MQ to handle Publish/Subscribe pattern-based solution for time consuming backend process.
- Developed a Notification System using Signal R to notify or alert users of status of any backend tasks.
- Implemented Azure Gateway for the APIs.
- A REST API Service (Cloud Services) built on Azure platform with CRUD principle, to store and retrieve data to or from the Azure SQL database
- Built Azure SQL Datawarehouse as it provides enhanced security and high-performance platform for analytics.
- Using Azure’s HDInsight, a scalable warehousing was done using Hadoop ETL cluster. This combined with Business Intelligence Tools (Power BI), provided real time analytics that was available in the Web Portal to drive business decisions based on the outcomes.
- Built a Service named “Decision Point Network” using the Cognitive API Services that predicts which Ads are appropriate for a particular POS terminal/business. Using the outcomes of this prediction, Ads can either be slotted to display (This was done using Azure Service Bus and Scheduler) at a certain time from Azure Storage Blob or drive the sales team to prioritize which ads to sell.
Environment: ASP.NET MVC 5.2, WEB API 2, C# 6.0, Entity Framework 6.3, LINQ, P-LINQ, ASP.NET Identity 2.0, Microsoft OWIN, OAuth2.0, JWT, JQuery, CSS 3, Bootstrap, Signal R, Visual Studio 2015, JQuery, SQL Server 2015, IIS 8.5, Tortoise SVN, Rabbit MQ, EPPlus, Mass Transit, Azure Blob Storage, Power BI, Azure SQL Database, Azure Cloud Services, Azure SQL Warehouse, HDInsight, Azure Service Bus, Azure Scheduler.
Confidential, Conshohocken, PA
Senior API Architect
Responsibilities:
- Designing & Developing a Messaging Workflow Architecture and implement in Decisions Rule Engine.
- Integrate Contentful REST Services with Decisions Workflow Engine.
- Designed & Developed the Content API using Web API 2 and C# as a wrapper for Contentful, a headless CMS which follows API first pattern to read/write data.
- Developed ASP.NET WEB API 2 end points for the Wellness applications to integrate with the UI using repository pattern and IoC container implementation and hosted in Azure Cloud Services.
- Designed and Developed Health Tracker API to enable tracking of Activities similar to the one found in many of the fitness Trackers.
- Designed & Developed a Signal R API endpoint which is used as a hub to notify messages across various mobile devices and Desktop browsers.
- Designed and Developed a solution for a generic Messaging to process messages using the Azure Service Bus and Rabbit MQ.
- Enhance the CareCam Admin Portal to support tracking of Activities and Program Completion.
Environment: ASP.NET MVC 5.2, WEB API 2, C# 6.0, Entity Framework 6.3, LINQ, P-LINQ, ASP.NET Identity 2.0, Microsoft OWIN, OAuth2.0, JQuery 2.0, CSS 3, Bootstrap, Signal R, Visual Studio 2015, JQuery, SQL Server 2015, IIS 8.5, Windows Server 2012, Team Foundation Server, Contentful-CMS, Decisions Rule Engine.
Confidential, Princeton, NJ
Senior Software Consultant - .NET
Responsibilities:
- Responsible for designing and developing Muti-tiered application “Einstein 360”, a Widget based architecture application for better reusability and maintainability.
- Designed and Developed UI ASP.NET MVC 5.2 and with extensive use of JQuery with Razor Views.
- Involved in redesigning of the Services Layer from SOAP to RESTful services using Web API 2.
- Implemented Micro services pattern for RESTful APIs with API Gateway to improve security, manage throttling and resiliency.
- Used Couchbase, a document based NoSQL DB to improve the performance of the APIs and the latency of end users experience by caching the output of API calls to avoid calling the backend every time.
- Involved in development of UI using ASP.NET MVC 5.2, Bootstrap, CSS and JQuery.
- Developed a News and Notification alert system using Signal R for .NET.
- Implemented Bearer Token authentication using OAuth2.0 in the API Gateway to authenticate the Widgets.
- Participated in Estimation & Sprint Planning and grooming sessions to accurately estimate the work load towards next sprint.
Environment: ASP.NET MVC 5.2, WEB API 2, C# 5.0, Entity Framework 6.1, WCF, LINQ, P-LINQ, ASP.NET Identity 2.0, Microsoft OWIN, OAuth2.0, JQuery 2.0, CSS 3, Bootstrap, Signal R, Visual Studio 2015, JQuery, SQL Server 2015, IIS 8.5, Windows Server 2012, Team Foundation Server, TeamCity, Octopus.
Confidential, Yardley, PA
Senior .NET Applications Developer/ Architect
Responsibilities:
- Responsible for designing multi-tier system architectures, conceptualizing architectural approaches, developing and validating the architecture and high level solution design against business requirements processes and best practices, design patterns, web based architectures and security for the project ‘AccessLine+.’
- Implemented Repository Pattern with Generic Repository design using Entity Framework 6.1 with lazy loading enabled and SQL Server 2014 following the database first approach.
- Designed every tier with dependency Injection using Ninject, an IOC container to attain light weight and highly modular framework for clean code approach and ease Unit Testing.
- Designed a security framework (S.H.I.E.L.D) using Microsoft OWIN for Authentication & ASP.NET Identity 2.0 with Claims based Authorization. The authorization was further customized to ‘Action based Authorization’, thus making the authorization role-independent. The Authentication was also customized to handle both external and windows authentication.
- Designed and developed a Secured Web Application (https) using ASP.NET MVC 5.2, C#, CSS3, HTML5 and Bootstrap. Created a custom CSS framework using bootstrap to serve as a responsive UI theme for the application.
- Designed and developed a Notification tier using Signal R to support group notifications which is part of the business tier.
- Designed and developed the presentation layer using BDD (Behavior Driven Development) pattern (User Story driven) approach along with Single Responsibility Principle (SRP)
- Extensively used Telerik’s Kendo UI for ASP.NET MVC, a third party data visualization toolkit which offers rich responsive Ajax supported controls.
- Used JQuery extensively, with custom plug-ins to create a feature rich user experience.
- Performance tuned all query transactions performed in database for large data. Optimized C# code using the C# 5.0 LINQ & P-LINQ to speed up database transactions using the deferred execution technique.
- Developed a custom build controller in TFS that builds tests and publishes once the code check-in is complete.
- Responsible for creating, configuring Development, Testing and Production environments in Web server and configuring and setting Team foundation Server (TFS) with custom build controller.
Environment: ASP.NET MVC 5.2, C# 5.0, Entity Framework 6.1, LINQ, P-LINQ, ASP.NET Identity 2.0, Microsoft OWIN, Ninject, JQuery 2.0, CSS 3, Bootstrap, Kendo UI for ASP.NET MVC, Signal R, Visual Studio 2013, SQL Server 2013, IIS 8.5, Windows Server 2012, Team Foundation Server 2013.
Confidential, Pennington, NJ
Lead .NET Developer
Responsibilities:
- Designed and developed “IPE Console”, a prototype driven development customized for Confidential Team.
- Used ASP.NET MVC 4 for the web applications with JQuery/JavaScript to create user friendly and intuitive web pages for the presentation layer to maintain a consistent look and feel for the application.
- Used ANTS Performance Profiler to identify bottle necks and monitor the performance of the ASP.NET Application. Used Performance monitor to identify memory leaks in Managed/Unmanaged Code.
- Used NCache to cache data at both first and second level.
- Used ASP.NET Web API 2 to write services consumed by the front end.
- Used JSON requests to send or receive data to the service.
- Designed SQL Server Database for the project for the services to interact in an effective way.
- Worked extensively on the Analysis phase of the SLC in gathering the system requirements and software requirements.
- Code Optimization at module level to increase the performance and ease the maintenance and scalability of the application.
- Created a few JQuery plugins to uniform the look and feel of certain components used all over the applications.
Environment: HTML, CSS, JavaScript, JQuery, ASP.Net, MVC4, Web API 2, .Net Framework 4.5, C# 4.5, ADO.Net, Linq, SQL Server 2008, SharePoint 2010 customization, IIS 7, Windows Server 2008 and Visual Studio 2013.
Confidential, Yardley, PA
Senior Applications Developer
Responsibilities:
- Designed and developed “Formulatory Compass”, an N-Tier and N-Layer based .NET application that replaces most of the business applications of MMIT.
- Used ASP.NET 3.5 for the web applications with JQuery/JavaScript to create user friendly and intuitive web pages for the presentation layer to maintain a consistent look and feel for the application.
- Designed an application using Oracle 9i to track the Work packages posted.
- Used AJAX type requests with JQuery to avoid multiple page post backs where ever necessary.
- Used Web Services across the application for publishing the Domain and Application layers.
- Worked extensively on the Analysis phase of the SLC in gathering the system requirements and software requirements.
- Tier level code optimization to enhance performance and code reusability.
- Developed classes and methods using the .NET framework 3.5 / 4.0 for the Team to facilitate their coding structures and helped the team by achieving code-reusability.
- Used ‘Web Inspect’ for finding out security leaks and vulnerabilities.
- Involved in configuring load balancer for a server farm.
- Created a few JQuery plugins to uniform the look and feel of certain components used all over the applications.
Environment: Visual Studio 2010, .NET Framework 2.0/3.5/4.0, ASP.NET MVC 3.0, C#, ADO.NET Entity Framework 4.3, JQuery, Windows Communication Foundation (WCF),SOAP/Restful Services, AJAX, JSON, Web Services, Oracle 10g.
Confidential, Conshohocken, PA
Senior .NET Developer
Responsibilities:
- Designed and developed “Novus”, an N-Tier and N-Layer based .NET application that replaces most of the business applications of Confidential .
- Used ASP.NET MVC 2.0/3.0 for the web applications with JQuery to create user friendly and intuitive web pages for the presentation layer to maintain a consistent look and feel for the application.
- Used Entity Framework 4.3 for data access of Novus System using the Code First approach. This approach required generation or POCO (Plain Old C# Classes) manually as needed.
- Used Caching to improve performance and responsiveness of the application leveraging the distributed caching mechanism based on the Windows App Fabric Caching to maintain same copies of the cached data across the servers.
- Used AJAX and JSON type requests with JQuery to avoid multiple page post backs where ever necessary.
- Used Web Services across the application for publishing the Domain and Application layers.
- Worked with creating a report framework with HiQ, third party solution for the reports which deals with adding and editing contents in a PDF document.
- Developed classes and methods using the .NET framework 3.5 / 4.0 for the Team to facilitate their coding structures and helped the team by achieving code-reusability.
- Created a few JQuery plugins to uniform the look and feel of certain components used all over the applications.
- Worked extensively in the framework development of the Novus Applications that lies as a base for all the Business Applications built over it.
Environment: Visual Studio 2010, .NET Framework 2.0/3.5/4.0, ASP.NET MVC 3.0, C#, ADO.NET Entity Framework 4.3, JQuery, Windows Communication Foundation (WCF),SOAP/Restful Services, AJAX, JSON, Web Services, SQL Server 2010, Windows App Fabric, HiQ, TFS.
Confidential, Pennington, NJ
Senior .NET Developer
Responsibilities:
- Develop & Maintain web applications for Confidential Wealth Management App Store and suggest functional changes accordingly.
- Involved in developing the Admin Site for managing the binaries being uploaded to the various environment developed using VS 2010, .NET 4.0, and ASP.NET MVC 3.0 with C#, JQuery and SQL Server 2008
- Used ADO.NET Entity Framework 4, to map objects to the database and retrieve it for seamless database interactions and superior performance.
- Used Data Driven Development pattern.
- Written stored procedures, Functions, Triggers, Joints, Linked server and many complex queries for backend processing.
- Extensively used Team foundation Server as Configuration Management Tool as well as for Continuous Integration.
- Involved in the process of Testing and maintaining different environments IDE, QA and Production.
- Monitor constantly for production errors and report to the concerned developer in detail on what needs to be fixed.
- Upload binaries in the App Store for various environments and verify the download using iPad.
- Build the iOS device specific binaries using a Mac with OS X and code sign with appropriate enterprise certificate.
- Involved in consuming various services developed by the Services Framework Team which is used by the App Store Admin site.
- Involved in the development of various SOAP Services using WCF, and development of RESTful Services for iOS Development Team.
- Monitor performance of applications using Performance monitoring strategies and develop or suggest tools for the same.
- Involved in writing optimized custom Stored Procedures and indexing it as needed by monitoring the performance of the stored procedures and databases.
- Review the requirement documents and implement the changes in the application following best practices and coding review standards.
- Participate in the full regression and smoke testing to dev certify the developed code. Also participate in User Acceptance Testing triage calls.
- Co-ordinate monthly release following Agile process by participating in release calls working along with the Engineering Team to resolve and server issues.
Environment: Visual Studio 2008/2010, ASP.NET MVC 3.0, C#, ADO.NET Entity Framework, jQuery, Windows Communication Foundation (WCF),SOAP/RESTful Services, SQL Server 2008, MAC OSX Xcode 4.3.3 for Max OS X.
Confidential, Rockville, MD
Senior .NET Developer
Responsibilities:
- Design and Develop web applications for Confidential and MindBranch.com that allows client organizations to centralize and manage their purchased content, consolidate billing, and integrate into internal procurement systems using ASP.NET MVC 2.0 with C# and SQL Server 2008
- Involved in the process of re-designing the web application from a legacy system to Entity Framework and merging two different web applications (Profound & MRDC) database into MRDC.
- Involved in the process of removing DAL from the existing application and replacing it with Persistence Layer.
- Design rich web forms and interfaces using Telerik’s RadControls for ASP.NET AJAX.
- Designed and Developed an Automation Tool called Batcher using Windows Forms (C#. NET) which bulk uploads user data to the database as if it was submitted from a Web Form.
- Developed a Tool “Sym Console” (System Management Console) using Win Forms which is used to track errors reported by the Exception Handler, Search and comment on each error.
- Involved in creating reusable custom classes which implements from the Entity Spaces Framework Interfaces.
- Involved in writing optimized Stored Procedures.
- Involved in the design of persistence layer over the RDBMS using Entity Spaces 2009.
- Involved in developing APIs for web pages using RESTful Services for custom search and WCF for PDF download management.
- Review the requirement documents and implement the changes in the application following best practices and coding review standards.
- Used VSS for source control & versioning and Bugzilla for defect tracking management for Development and QA release phases.
- Used NUnit to write unit tests of the .NET classes and Web Services.
- Used ‘Cruise Control’ for maintaining a successful build and continuous integration in the development environment.
- Work closely with other developers and provide assistance in solving bugs, and guiding them during all phases for developments till delivery.
Environment: Visual Studio 2008/2010, ASP.NET MVC 2.0 and C#, Win Forms, Web Services, Windows Communication Foundation (WCF)(both SOAP and RESTFul), Rad Controls for ASP.NET AJAX, SQL Server 2008, Entity Spaces 2009, Cruise Control, NUnit with .NET, Bugzilla, Visual Source Safe, IIS 7.0, Microsoft Enterprise Library.
Confidential, Fort Belvoir, VA
.NET Developer
Responsibilities:
- Involved in design and development of Mission Assistance System, a project estimation tool for the Confidential (DAU) in which support agreement (contracts) are estimated and created in order to support Mission Assistance Efforts in which a product or service to other agencies is provided.
- Developed custom classes in C#.NET relating to Auto Generated mail with dynamic data, using AJAX & Web Services using SOAP and Restful Services.
- Involved in designing and programming custom reports using Crystal Reports 11.
- Involved in an analysis of tuning up the application, optimizing calls to the database without affecting the existing functionality.
- Merged the existing system with the new system without undergoing any major changes in the database or in the existing database which was built already.
- Created Stored Procedures in SQL Server 2005 to enhance and extend the database capability for DAL.
- Used obout custom components for ASP.NET to enhance the look and feel of the grid and for the pages using Ajax toolkit.
- Used Entity Spaces to establish entity with ASP.NET for Persistence Layer and Business Objects to enhance performance. Learning Entity Framework.
- Developed using VS 2008, C#, ASP MVC 2.0 and .Net 3.5.
- Developed Web Pages using HTML, CSS and ASP .NET3.5 Server Controls, LINQ to SQL, JQuery, Ajax, and Web Services.
Environment: Visual Studio.Net 2008, .NET Framework 2.0/3.5, ASP MVC 2.0,ASP.NET C#, SQL Server 2005, AJAX toolkit, Entity Spaces, JavaScript, XML, IIS 6.0 with SSL, AJAX, Web Forms, Obout Tools, AJAX Toolkit, Crystal Reports 11.
Confidential, King of Prussia, PA
Applications Developer
Responsibilities:
- Involved in design and development of various access level hierarchy based on firms involved.
- Developed custom web forms using ASP.NET and C# under Visual Studio.NET 2008 Environment.
- Designed database tables pertaining Technical Specification Document (TSD).
- Involved in designing and building custom reports using Active Reports 3.0
- Involved in an analysis of tuning up the application, optimizing calls to the database without affecting the existing functionality.
- Developed class files Data Access Layer of the ADVISORport portal for code reusability.
- Amended new scoring axis to the existing functionality of Scoring Axes with new lower and upper bounds.
- Dealt with project template, task creation, authorizing user, creating and maintaining SharePoint sites for the projects created.
- Created custom Reports using Active Reports 3.0 for the customer as a PDF copy of the portfolio.
- Created Custom Models for the Portfolio analyzer tool based on the customer questionnaire and developing a scoring logic to determine the exact program for the customer to adopt.
- Utilized Microsoft application blocks & practices for data access, configuration and for minimizing repeated code
- Created Stored Procedures in SQL Server 2005 to process data in the backend mostly to optimize speed and network traffic.
- Created class files for Business and Presentation layers which interact with the data access layers.
- Extensively used Ajax Controls for client server validations
- Performed unit testing and system integration testing.
- Involved in fixing the bugs based on the client requirements and involved in the enhancements in the web forms, class files and stored procedures.
- Conducted internal project meetings together with Business Analysts to keep track of both progress and requirement satisfaction.
- Perforce Visual Client 2007 has been used for all the source code management.
- Involved in fixing most critical defects during a warranty period as the turnaround time is only an hour.
Environment: Visual Studio.Net 2008, ASP.NET, C#, SQL Server 2005, HTML, JavaScript, XML, IIS 6.0 with SSL, Active Reports 3.0, Ajax, Web forms, and Perforce Visual Client 2007.
Confidential
Asst. Systems Engineer
Responsibilities:
- Developed ASP.NET with C#.NET pages using Visual Studio IDE to track each Work Package.
- Created a rule set for scheduling a VC which follows Round-Robin scheduling in XML.
- Designed an application using Oracle 9i to track the Work packages posted.
- Designed and Implemented the User Interface following the common SDLC model and delivery.
- Worked extensively on the Analysis phase of the SLC in gathering the system requirements and software requirements.
- Created an authentication application used in VCM using Web forms in ASP.NET with C# for four level hierarchy login which syncs with BTs central authentication system.
- Developed the Front-End/User Interface using ASP.NET with C#.NET for creating custom forms in a more user friendly and interactive way and creation of WP in XML.
- Worked extensively on Back End (Oracle 9i) and created a stored procedure to schedule jobs which submits the VCM’s WP in XML file format to the flow stream.
- Created a stored procedure and a module in C#.NET which can parse the XML file and submitted the exact VCs to flow streams.
Environment: ASP.NET, C#.NET, Oracle 9i, Visual Studio 2005, XML, Extra-Client
Confidential
Web Developer
Responsibilities:
- Developed an application in ASP.NET along with CDONTS mail component to mail the program owner whenever a survey/feedback is taken in the website.
- Created a custom three state workflow model using the SPS 2003 services within hp to manage the web enhancement requests to be approved by the client.
- Developing the project plan using UML - all details from tasks to be completed, who completed them and when they were completed must be formalized.
- Managing and monitoring the project plan - this allows the organization to stay on track, creating project milestones and feature creeps which allow you to add to the initial plan.
- Created a custom Performance Appraisal form using MS InfoPath 2003 for effective collection of data.
- Handling of projects through the SDLC involving in Design, Development, Implementation and Delivery.
- Used the OWC components in configuring graphs inside the webpage using ASP.NET and values of the graph to be fetched from the database table to populate by itself.
- Customized KPIs using Web parts in SharePoint to continuously monitor the health of the graphical data displayed on the website.
- Extensively used Ajax Controls for client server validations
- Developed a content management portal using ASP.NET and WSS 2.0 for Marketing Document Centre, a repository solution to share documents across the organization.
- Generated reports of Marketing Analysis using VS.NET Crystal Reports and Web Analysis helpful for Business Analysts for further promotion of the sites.
Environment: ASP.NET,VB.NET,JavaScript, Macromedia Dreamweaver MX, Adobe Photoshop, SQL Server 2000,MS SharePoint 2003 & 2007,MS InfoPath 2003, SDLC Architecture Model.
Confidential
Software Development Executive
Responsibilities:
- Designed and created web pages in ASP.NET using VS.NET IDE and also the XP Web Button Maker for better look and feel.
- Requirement gathering from the clients in terms of the report generation using ASP.NET exported to MS Excel in two formats(.XLS and .CSV)
- Understanding and implementation for the complex math calculations involved in the calculation of the score and implementing it using ASP.NET Math Component.
- Created web pages in ASP.NET using JavaScript 2.0 to prepare individual Analyst Report and also the consolidated report made available both in the web page and in CSV format.
- Created an application with ASP.NET with VB.NET which locks the login credentials of an executive if he is rated with poor score.
- Designed a database using SQL Server 2000 enterprise manager which holds up the entire QAS data in an XML format.
- Developed a web application to import and export XML files to save or read the backed the score card
Environment: ASP.NET, MS Excel Component, Web XP Buttons 1.0, JavaScript 2.0, XML, Crystal Reports, SQL Server 2000.
