OBJECTIVE

• My focus is helping companies build intelligent Web/ Cloud/ Data/ IoT/ ML solutions with the latest Confidential technology stack.

SUMMARY

• 20+ years of complete software development life - cycle (SDLC) experience; planning, requirements analysis, design, development, testing, deployment and maintenance; in building applications for leading enterprises and medium businesses that use and depend on high-end systems wherein performance, scalability, security, privacy, reliability, usability, maintainability, extensibility, globalization and localization aspects are inherent and critical.
• Broad experience in developing robust, rich, engaging, and interactive Web/ Windows applications and performant, scalable Web APIs/ Cloud Services. Aware of functional (declarative), imperative (procedural) and object-oriented programming paradigms along with DRY, SoC, LoD and SOLID principles of software development. Proficient at identifying and reducing boilerplate and bookkeeping code.
• Well-acquainted with Azure platform and services including Web, Function, Logic App, DataFactory, Batch, TimeSeries Insights, Service Fabric, CosmosDb, SQL, Storage, Search, Service Bus, KeyVault, Active Directory, API Management, Resource Management, CloudShell and CLI.
• Knowledge of Azure IoT platform and experience working with IoT Hub, Event Hub, IoT Edge.
• Acquainted with running containerized apps using Docker, Container Registry, Container Instances and Kubernetes (AKS).
• Knowledgeable in building machine intelligence-based apps and services using Azure Machine Learning Studio, and conversation bots using Cognitive Services (Speech, Language Understanding) and Bot Service.
• Extensive experience in developing RESTful Web Services built on HTTP and JSON using ASP.NET Web API. Past experience building applications based on Service Oriented Architecture (SOA) i.e. loosely coupled clients talking with robust, scalable and highly interoperable Web Services built on XML, SOAP, and WSDL standards using WCF.
• Skilled in working with .NET Framework, C#, Angular 2+, VueJS, TypeScript, ASP.NET MVC, Web forms, Web controls, JQuery, Javascript, Bootstrap, CSS3, HTML5, IIS to develop and deploy both Intranet and Internet based Web applications. Knowledge of performance testing and improving performance of high-volume web applications/ services.
• Knowledge of implementing Windows applications based on 3-tier architecture and built using the .NET Framework, C#, WPF, Silverlight, XAML, Windows forms, Windows controls and WCF, Remoting for local or remote inter-object communication, SQL Server for backend data services, and Service Bus, Queues, MSMQ for mutually interoperating apps and services. Good experience utilizing ORM like Dapper, Entity Framework, LINQ for data access and AutoMapper for object-object mapping.
• Exposure to implementing authentication and authorization using ASP.NET identity with accounts in SQL or external providers like Confidential, Google, Facebook, Twitter, or LinkedIn, with accounts in Active Directory in Azure/ On-premises, or simply with Windows for intranet applications. Basic understanding of secure delegated access using OAuth 2.0.
• Good understanding of NoSQL databases like Cosmos DB, Storage Table including throughput, performance and cost aspects. Experience using relational databases like SQL Server in data modeling, database design, database normalization, defining schemas and keys, writing views, stored procedures, functions, adding constraints and creating relationships for preserving referential integrity, optimizing performance by creating indexes and improving queries using SQL Profiler and building ETL packages using SSIS.
• Understanding of design patterns like Abstract Factory, Singleton, Adapter, Facade, Proxy, MVC, MVVM, Command, Observer and State. Adapted with using asynchronous and parallel programming, dependency injection, caching, error handling and logging.
• Well acquainted with project planning/ execution, design/ development strategies, architecture, modeling/ UML, best practices and coding standards.
• Skilled using tools - SharePoint, Confluence for document sharing, Visio for diagraming, Visual Studio for development, MSTest with Fakes, NUnit, Nmock for unit testing, Postman, Fiddler for Web/ API development, DevOps, GitHub, Git, TFS, Bitbucket, SVN for source control, DevOps, TFS, JIRA, Mingle for project management and bug tracking and DevOps, TFS, Bamboo for continuous integration/ continuous delivery (CI/CD).
• Conversant with Agile, Scrum, Kanban and Waterfall development processes in addition to Test Driven Development (TDD) techniques.
• Effective communicator, expert troubleshooter and creative problem-solver with focus on quality and thoroughness.

TECHNICAL SKILLS

Design: UML, Visio

Languages: C#, SQL, Python, Javascript

Web: ASP.NET MVC, Angular, TypeScript, Vue, WebForms, Silverlight, JQuery, Javascript, Bootstrap, HTML, CSS

Windows: WPF, WinForms

Services: ASP.NET Web API, REST, Swagger, RestSharp, Json.Net, WCF, SOA, SOAP, WSDL

Container: Docker, Kubernetes

Database: Cosmos DB, SQL Server, T-SQL, SSIS, Entity Framework, LINQ

IoT: IoT Hub, IoT Edge, Event Hub, .NET Core, UWP

Machine Learning: ML Studio, Cognitive Services (Speech, Language Understanding), Bot Service

Azure Cloud: Active Directory, AD B2C, Service Bus, TimeSeries Insights, KeyVault, Kubernetes Service, Web, Function, Logic App, Batch, Service Fabric, CosmosDb, SQL, Storage, Search, DataFactory, API Management, Resource Management, CloudShell, and CLI.

Messaging and Workflow: WorkFlow, Service Bus, Storage Queue, MSMQ

Unit Testing: MSTest with Fakes, NUnit, NMock

Dev IDEs and Tools: Visual Studio Code, Visual Studio 2020, SQL Management Studio, SoapUI, curl, Postman, Fiddler, PerfMon, .NET Profiler, SQL Profiler, Chrome/ Edge Dev Tools

Scripting: PowerShell, bash, cmd

Source Control and Package Management: DevOps, GitHub, Git, TFS, Bitbucket, SVN, nuget, pip, npm

PROFESSIONAL EXPERIENCE

Confidential, Bellevue, WA

Full Stack Software Developer

Responsibilities:

• Model, design, and build secure and reliable backends systems maximizing speed and scale.
• Implement Authentication and Authorization scheme for multi-tenant platform, develop autoscaling data pipelines, web applications and services based on Microservice architecture employing resources and capabilities in the cloud, and write scripts to enable automated infrastructure and software deployments.
• Work together with the development team to develop quality, testable applications based on product and regulatory requirements.
• Manage projects with minimal guidance.
• Contribute to a collaborative environment, helping to establish lean but effective software practices.
• Deliver high quality and timely results to meet the business needs.
• Design and coding practices consistent with security and regulatory standards.
• Design interfaces to integrate with legacy application systems and infrastructure.
• Follow documented procedures for all activities related to the Confidential Quality System.

Confidential, Redmond, WA

Sr. Cloud Development Engineer

Responsibilities:

• Design, develop and test cloud apps for processing data received from sensors, cameras and microphones.
• Design, develop and test IoT Edge apps capable of remote control and bidirectional communication with sensor boxes over TVWS and with the IoT solution backend securely over the internet.
• Write a container app to run serverless and scale on Container Instance/ Kubernetes cluster running docker for stitching images into a panorama.
• Develop an app to manage devices by calling FarmBeats RESTful Web Service.
• Design and implement an agent to handle Protocol to Access White-Space (PAWS) and calling RESTful PAWS Web Service to achieve non-interfering spectrum sharing among multiple devices.
• Automate deployment of resources and data on cloud using Azure PowerShell/CLI command scripts and Azure Resource Manager templates.
• Deploy, configure and manage resources, apps, containers and data on cloud and IoT Edge devices.
• Provide technical guidance on topics in cloud, web services and .NET, troubleshoot production issues, review code and maintain source control.

Confidential, WA

Software Architect

Responsibilities:

• Worked with DBAs for planning migration of data to Azure SQL.
• Designed and implemented robust, scalable and secure stateless RESTful web services running on top of SQL and Solr services in the Azure cloud. Implemented Service layer using Autofac for Inversion of Control (IoC), Entity Framework ORM for SQL, SolrNet client for Solr search, AutoMapper for object-object mapping, Swagger for defining schema and contract, Log4Net for logging, App Insights for monitoring performance.
• Integrated RESTful APIs with new and existing web and mobile views using ASP.NET MVC and JQuery and Bootstrap.
• Decomposed large monolithic ETL process into stateful microservices and deployed to on-premise Service Fabric cluster with high-density hosting and utilizing ReliableQueue for temporally decoupled and fault tolerant messaging.
• Researched Azure AD authentication and authorization. Used identity protocols OAuth2 and OpenID Connect. Implemented single sign-on and federated access for various scenarios - Web Browser to Web Application, Web Application to Web API, and Daemon or Server Application to Web API. Created and tested custom policy definitions. Gained knowledge about user/ service principal, single/ multi-tenant applications, users/ groups, application scopes/ roles, application/ delegated permissions.
• Participated in sprint planning, code reviews, code refactoring, running code analysis, improving error handling and performance, documenting design of Apps and APIs.

Confidential, Redmond, WA

Software Architect

Responsibilities:

• Collaborate with various teams in the Machine Learning and Azure groups to design and develop prototypes, SDKs, REST APIs and Python/ cmd/ PowerShell/ Linux bash scripts for training, scoring, and operationalizing Azure Machine Learning models on local or cluster environments and accessing them from clients.
• Built samples for demonstrating customer’s powerful features for doing Machine Learning in Azure on data in traditional, cloud, big data sources and sinks like SQL, Storage, Data Lake and Cosmos DB.
• Ran realtime/ batch prediction on data in Data Lake or coming in through Event Hubs using Data Factory/ Batch.
• Used Service Bus for reliable and decoupled messaging between cloud resources.
• Updated existing template that creates Logic Apps for creating interface for calling realtime and batch predictive web service.
• Developed chat bot for the Azure Machine Learning portal that can have intelligent conversations with users to answer their questions whenever possible; otherwise handing over to a human agent.

Confidential, Bellevue, WA

Software Architect/ Dev Lead

Responsibilities:

• Participate in requirements gathering and analysis meetings with business product owners and analysts.
• Designing and developing Customer and Vendor side portals for leasing equipment with the help of a team of 4 developers.
• Customer Portal uses SOA architecture with WCF/SOAP based Web Services while Vendor Portal uses REST/JSON based WebAPI both utilizing Document DB and integrating with Dynamics 365 as backend.
• Responsible for design, task breakdown, estimates, prototyping, writing code, unit tests, reviewing code, assisting devs by resolving technical issues, and authoring technical specifications document.

Confidential, Bellevue, WA

Sr. Software Engineer

Responsibilities:

• Updated and tested Google AdWords downloader and uploader Services using Confidential Fakes.
• Implemented SQL query for Coverage and Time to Market Metrics used by their marketing team.
• Update existing schemas, SPs, ETLs, apps and reports to add new information.

Confidential, Seattle, WA

Principal Web Developer

Responsibilities:

• Implemented order fulfillment and inventory on a Microservices architecture utilizing NServiceBus pub-sub design pattern.
• Used Telerik UI for ASP.NET MVC components Menu, TabStrip, PanelBar, Grid, ListView, DateTimePicker, Upload, Validator, and Notification for offering rich user experience and high usability.
• Leveraged Telerik UI for MVC Grid features like binding with RESTful service, paging, sorting, filtering, searching, popup and batch editing with validation, and frozen headers/ columns.

Confidential, Redmond, WA

Dev Lead

Responsibilities:

• Employed common Telerik UI for ASP.NET MVC components and JQuery for rich UX with Bootstrap for responsive web design.
• Provided Business and Marketing staff the ability to slice and dice through data interactively with BI dashboard built using Telerik UI for ASP.NET MVC components like Grid and Line, Bar, Area, Pie Charts for data visualization.
• Hosted DMC web app and RESTful Web API on Azure. Maintained Session state in SQL Azure and pulled domain data from Azure Tables and Document DB. Leveraged Claims Based Identity for access control and Pub/Sub Messaging capabilities of Azure Service Bus for decoupled and fault tolerant communications between local servers and VMs in the cloud.

Confidential, Bellevue, WA

Application Developer IV

Responsibilities:

• Performed requirements analysis and planning tasks such as consideration for physical and logical network topology, mediation server processor, memory, and disk space usage, data warehouse capacity, and size/frequency/latency aspects of the data throughout the ETL process.
• Designed cross-network and cross-platform apps with Visio, Visual Studio layer and class diagrams and using object-oriented concepts and relevant design patterns where applicable.
• Fulfilled necessity to implement highly reliable and performant Windows and Web apps with emphasis on operations support friendliness, maintainability and scalability.
• Created Netezza/ SQL table schemas, setup keys and indexes, wrote T-SQL queries and Stored Procs, built SSIS packages for ETL operations and wrote Netezza scripts to perform aggregations. Executed optimized queries and performed lookups from C# apps using ADO.NET Entity Framework and LINQ to CSV, XML, SQL, and Entities.
• Built WCF clients to make synchronous calls to Web Services over SOAP and HTTP and persist data to flat CSV files.
• Added new functionality to existing Monitoring and Alerting tools and Performance Monitoring and Management web solutions developed using ASP.NET MVC, Razor and Entity Framework, improved ETL performance by optimizing SQL joins, making async calls, and parallel execution where possible. Used caching to avoid excess database connections and trips.
• Participated in estimation, building POC, documenting design, reviewing peer code, refactoring code, writing unit, functional and performance tests, running code analysis and measuring code coverage, fixed bugs, improved error handling and logging, addressed production issues, supervised deployments.
• Team adapted Scrum methodology, used TFS for project management, retained documentation aspect from Waterfall and laid enough stress on learning new development strategies and techniques, team work, and writing quality code with meaningful unit tests.

Confidential, Redmond, WA

Dev Lead

Responsibilities:

• Designed components in UML and implemented them with latest available features in Visual Studio and .NET using relevant design patterns and application blocks where applicable with due importance to reliability, maintainability and scalability aspects.
• Wrote tools to analyze Production data and generate reports, studied and understood the reports, reviewed code to identify bottlenecks in performance, ran perfmon against various site configurations and analyzed results, researched web.config settings, ASP.NET Caching and IIS 7.5 AppPool recycle behavior. Documented performance analysis findings in a report, suggested and later implemented steps to fix both code and configuration based performance degrading issues within the platform.
• Created schemas, setup keys, wrote T-SQL queries and Stored Procs, built ETL packages on SQL Server 2008. Retrieved data using ADO.NET Entity Framework and LINQ.
• Implemented strong types and used JSON/ XML serialization for transmitting information/ persisting it in flat file format. Implemented parser for reading potentially invalid XML content.
• Built custom client to specifications for calling Webtrends using JSON over HTTP. Used WCF to make asynchronous calls to MRS/ WEDCS Web Services.
• Participated in estimation and planning, Joint Application Design (JAD) sessions, wrote technical specifications document, refactored code, reviewed peer code, wrote unit, functional and performance tests, ran code analysis, fixed bugs, improved error handling and performance, built and deployed applications.

Confidential, Redmond, WA

Dev Lead

Responsibilities:

• Designed the middle layer consisting of Model, View-Model, and Controller classes in UML.
• Built the web application on MVVM, Observer-Observable, and Prism pattern for building Composite Applications using the Unity Framework.
• Implemented core business logic involving complex mathematical calculations without losing focus on error handling, logging, maintainability, and reusability aspects always working based on DRY, SoC and SOLID software development principles.
• Wrote T-SQL Stored Procs and MDX queries against SQL Server 2008 databases and OLAP cubes. Retrieved data using LINQ and Enterprise Library data access block.
• Built a robust and scalable application that calls a data service based on the Service Oriented Architecture (SOA) paradigm and built using WCF. Observer-Observable pattern was used to allow asynchronous calls and maintain one-way dependency going from the client to the server.
• Participated in costing and code reviews, refactored code, wrote unit tests, ran code analysis, fixed bugs, improved error handling and performance, documented design and APIs.
• Setup a TFS Build service for obtaining automated continuous integration (CI) builds. Wrote a custom build task using Windows Workflow Foundation (WF) for versioning and another one for running unit tests.
• Worked in a team that followed a modified Agile development process taking useful components from the Waterfall model and adapted Test Driven Development (TDD) techniques.

Confidential, Seattle, WA

Sr. Software Design Engineer

Responsibilities:

• Assisted in analyzing and converting business requirements into usable functional specs, designing the database, various middle-tier components, web services, and user interfaces with due consideration to scalability and interoperability.
• Implemented core business logic in critical areas including order processing and tax calculation, developed the applications based on Service Oriented Architecture (SOA) with the help of WCF Web Services, and built components, custom controls, and fully localizable web interfaces and reports.
• Separated concerns in code by creating Entity Framework data model and building web forms using ASP.NET MVC, Razor, Telerik ASP.NET MVC controls and with authentication, input validation, and rich UI built with custom HTML helpers.
• Developed using MVC, Factory, Proxy, Template Method, and Pipeline design patterns, and configuration management, exception management, and logging application blocks where required always keeping in mind reusability and maintainability requirements.
• Built relational databases by defining and scripting table schemas, setting up primary/foreign keys and relationships between tables, adding constraints, indexes, writing views, stored procs, and functions, implemented the data access layer suitably using either LINQ or Enterprise Library data access block.
• Performed cost analysis, reviewed code, wrote and executed unit, functional, and performance tests, refactored for higher readability and maintainability, fixed bugs, improved security and performance, obtained code and performance metrics, documented design and APIs.
• Worked in a team that followed a modified Agile development process taking useful components from the Waterfall model and adapted Test Driven Development (TDD) techniques.

Confidential, Seattle, WA

Sr. .NET Developer

Responsibilities:

• Participated in designing and building the application based on Service-oriented architecture (SOA) with loosely coupled mobile clients talking with a highly interoperable XML Web Service.
• Built mobile application to run on Symbol wireless devices installed with Windows Mobile 5.0, .NET Compact Framework 2.0, and using SQL Server 2005 CE database for local storage. The mobile application would communicate via GPRS or Wi-Fi with the Web Service that centrally collected dynamic data on an enterprise database and redistributed the same to requesting clients.
• Worked on building the relational database, wrote queries and stored procs, coded data access layer, implemented core functions of the application such as fail-safe and multithreaded upload and download queues, designed and implemented various middle-tier components with proper exception handling and logging using well-known application blocks, created usable and localized forms with suitable input validation.
• Performed costing. Inspected code and fixed bugs. Refactored code for high readability, reusability, and maintainability. Improved the application’s performance by a factor of 10 in places.
• Worked in a team that followed Agile/Scrum/Extreme Programming methodologies and Test Driven Development techniques.

Confidential, Redmond, WA

Software Design Engineer IV

Responsibilities:

• Assisted in analyzing and converting business requirements into usable functional specs.
• Contributed in designing the database, various middle-tier components, and user interfaces for the application.
• Built relational databases by defining and scripting table schemas, setting up primary/foreign keys and relationships between tables, adding indexes, writing views, stored procs, and functions.
• Developed components and custom controls, implemented core functionality of the application, and created Windows form/Web form based user interfaces.
• Migrated sites to Azure changing state from InProc to SQL Azure. Ran site on Web role (IaaS) and delegated complex/ time-consuming processes to worker role connecting the two with Azure Queues. Hosted static content such as images and stylesheets on Azure Drive. Stored application data in Azure SQL database and uploaded binary files to Azure Blob Storage.
• Used well-known design patterns and data access, exception handling, and logging application blocks.
• Applied DRY, SoC and SOLID principles of software development making good use of OOP features such as interfaces, abstraction, encapsulation, inheritance, and polymorphism.
• Participated in code analysis review and MS internal privacy and security audit process.
• Inspected code, performed unit tests, reviewed code written by peers, built and deployed the application, fixed bugs, tested the application for security/performance issues and fixed the same, obtained various performance/code metrics, and guided technical writers in the documentation process.

Confidential, Kirkland, WA

Software Design Engineer

Responsibilities:

• Developed an API using .NET Framework, C#, and third party software.
• Created XSL report templates, implemented library to generate Word and PDF reports using Visual Studio Tools for Office (VSTO) and third party software using XML data and the report templates, implemented the Word/PDF reports feature in the main application by referencing the new library.
• Wrote and optimized SQL queries to access data in a relational database. Also used objects in System.Data and System.Xml namespaces for processing XML files.
• Built server-side and identical client-side User Control using ASP.NET, AJAX, and Javascript for creating and modifying expressions and obtaining as output in the form of XML to be consumed by other code been developed separately based on a schema agreement.
• Implemented complex logic and wrote complicated SQL queries, performed unit tests, and assisted in documenting the API.
• Closely interacted with the client to understand business requirements.

Confidential, Redmond, WA

Software Design Engineer

Responsibilities:

• Played an important role in the research, analysis, design, development, testing, debugging, and deployment phases of the project in an aggressive development life-cycle, contributing nearly 40% of the total effort put in design and development of the 1.0 (Beta) version of this product.
• Participated throughout in designing the overall architecture, designing components, implementing critical, bug-prone, or technically challenging pieces of functionality, debugging and resolving 2500 bugs of different priority and severity over the period of a year from v1.0 (Beta) to v3.0.
• Used COM Add-in Shim for loading the Add-in on Outlook 2002 and Visual Studio Tools for Office (VSTO) to load the same add-in on Outlook 2003/2007 selectively without violating the respective Outlook Object Model’s security restrictions.
• Implemented core and technically challenging functionality such as “Adding travel time to start time for Normal/Recurring/All day Outlook Appointments/Meeting requests”, “Inserting map and directions in message”, “Printing map and directions”, “Loading and saving Options/Settings/Item data”, “Publishing Outlook custom form on install”, “Granting permissions to Add-in assembly on install” and “Help” in v1.0 (Beta).
• Wrote code for critical functionality such as “Upgrading old Outlook Items to newer version”, “Location and Places of Interest (POI) search using Live Search Maps Web Service”, “MapPoint integration”, and “Add-in repair/ removal” in v2.0 (Release).
• Worked on fixing Add-in to support newer version of Live Search Maps site that featured both 2D and 3D maps in addition to Aerial/Bird’s Eye view and Traffic.
• Built a user-friendly interface capable of remembering recently entered information and user specific selections and settings across forms and sessions.
• Developed reusable components wherever possible carefully implemented with an Object Oriented approach using well known design patterns.
• Used Windows API calls for capturing and compressing map images. Consumed Web Services for obtaining Location and Places of Interest (POI) search results from Live Search Maps. Used CDO and MAPI for accomplishing things restricted within the Outlook Object Model. Made ample use of COM Interop for messaging between disparate components.
• Closely worked with the project manager for understanding the requirements and the test team for identifying and eliminating bugs in order to deliver a robust and highly reliable product.
• Used Visual Studio .NET as development environment, .NET Framework as platform for building and running the application, Source Depot for version control, and Product Studio for bug tracking.
• Responsible for reviewing code for peer developers, unit testing on various platforms, troubleshooting test boxes, participation in code analysis review, MS internal privacy and security audit process, approving documentation, and helping setup dev write build scripts, sign assemblies/ executables, or fix bugs in setup and deployment.

Confidential, Houston, TX

Sr. .NET Developer

Responsibilities:

• Designed and developed vital pieces present in the database, business logic, and Web user interface layers of the application dividing effort simultaneously to both versions running in different phases.
• Created new SQL Server objects such as schemas, stored Procedures, user defined functions and modified existing ones after adequate data modeling. Developed DTS packages to perform data import and transformation tasks.
• Optimized SQL queries by examining their execution plans using Query Analyzer. Added indexes and enhanced their performance using Index Tuning Wizard.
• Developed reusable components in the form of .NET shared assemblies carefully implemented with an Object Oriented approach using well known design patterns such as facade, persistence, and factory.
• Created a system to automate data import and merge tasks with proper error logging using DTS packages, SQL stored procedures, and C# and ADO.NET console applications instantiated using duly scheduled batch jobs.
• Built a user friendly Web interface exploiting the full potential of ASP.NET Web forms and Web controls, along with XSLT/CSS for layout and presentation and Javascript for providing client-side functionality and interactivity.
• Created and registered COM type libraries for accessing .NET managed code in shared assemblies from existing ASP web pages.
• Utilized Commerce Server 2002 library to expand purchasing-related information stored in binary format to header/detail tables.
• Produced a new Web Service based on a WSDL document following the Contract-First paradigm and interfaced it seamlessly with a pre-existing .NET console application.
• Closely worked with the client to understand business requirements and with team members of various applications to understand the existing systems.
• Used Visual Studio .NET for development, Visual SourceSafe (VSS) for software configuration management, and IIS 5.0 and Windows Server 2000 for hosting the application.
• Responsible for documentation, unit testing, deployment, and troubleshooting in DEV, TST, and ITG environments.

Confidential, Chicago, IL

Programmer/Data Analyst

Responsibilities:

• Built web-based front-end for entering data and windows-based GUI for administration and report generation.
• Created web interfaces capable of performing authentication, providing restricted access to authorized users, helping the user enter data on web forms using auto-complete feature, and validated the same information on server-side.
• Wrote software to model data using proprietary modeling, data-mining, and analysis tools and reported the results using ADO.NET objects and Crystal Reports.