We provide IT Staff Augmentation Services!

Sr. .net Architect Resume Profile

4.00/5 (Submit Your Rating)

Objective:

I seek an opportunity that will provide a healthy mix of challenge and reward. Working with and leading technical people in a complex environment challenges me, and my primary source of reward comes from knowing that I am making a valuable contribution to the improvement of business operations.

Skill Set:

  • Guru-level Skills 10 years experience Mentoring, Project Management, Architecture, Service Oriented Architecture, Data Design, Unit and Integration Testing, Continous Integration, Web Services, Workflow, Financial Applications, UI Design, Distributed Design, Requirements Gathering and Analysis, Software Process Improvement, High-load Transactional Environments, Security and Encryption, Event Messaging
  • Methodologies Test-Driven Development, Model-Driven Development, Continuous Integration, Aspect-Oriented Programming, Rational Unified Process, Microsoft Solutions Framework, Agile Development, UML, Together, Use Cases, Open Source, CRC, JAD, Objectory, OOAD, Patterns, Business Process Improvement/Workflow
  • Test Platforms NUnit/JUnit, MbUnit, BizUnit, NMock2, RhinoMocks, TypeMock.NET, FitNesse, ReSharper
  • Object Models .NET, SOA, SOAP, COM, DCOM, COM , CORBA, EJB, XML
  • Languages C , WCF/WF/WPF/XAML, ASP.NET/WinForms/ADO.NET, Java/Struts/JSP, PHP, VB.NET, VB, C , XML/XSLT/XPATH/SAML, SQL, WAP/WML, VBScript, JavaScript, ASP, C, AJAX
  • Databases SQL Server, MySql, Oracle, FoxPro, Sybase, Informix, DB/2
  • Environments Visual Studio.NET 2003, 2005, 2008, 2010, 2012 , Eclipse, WebSphere Studio, Together, Team System
  • Servers MS BizTalk, MS SharePoint Server, SQL Server Reporting Services, SQL Server Integration Services, MS OLAP Services, MS InfoPath, Apache, MS Commerce Server, MS Content Management Server, Oracle E-Commerce, ATG Dynamo, IBM Net.Commerce, Netscape Server, TibcoActiveEnterprise, BEA WebLogic, MQSeries
  • Platforms NT, Linux, Solaris, HP-UX, Macintosh
  • Other Visual Paradigm, Agilian, Visio, Expresso, SourceForge, Solomon IV, SAP, Great Plains, Sales Logix, Baan, Oracle Financials, Onyx, Siebel, Clarify

Experience:

Confidential

Sr. .NET Architect

Sr.NETArchitect,Pinecone .NET4.5/4.0,C /C ,WinServices/WCF/WPF/WinForms,TeamCity, WiX, MS Build Lead architect for server-side product engineering. Very large codebase for secure mobile communications developed originally in .Net 1.1/2.0 that was carrying a great deal of technical debt which I was engaged to eliminate. I automated the build process, crafted target architecture, performed a methodical refactor while increasing unit test coverage and mentored long-time developers on new technologies as part of a technology overhaul process.

Constellation Energy, Sr. .NET Developer

Confidential

Responsible for multiple projects within the Demand Response unit. Developed MVVM framework, real-time WCF duplexing adapter for Oracle and reusable LOB code. Participated in architecture group for engineering improvements to build and deployments.

Educate Inc., Chief Architect, Multiple

Confidential

Lead teams across multiple projects. Created and oversaw companywide build and test Continuous Integration systems. Designed, trained and implemented company's adoption of Agile development methods. Evaluated, selected and lead adoption of multiple software process improvement platforms including TeamCity, Version One and Confluence. Lead and mentored up to 20 coding resources through example and continuous code review in test-driven development and best development practices.

Active Outdoors, Architect Build Automation Lead

Confidential

Advisory architect and team lead for delivering maintenance and new feature development on multiple products to multiple customers based on multiple platforms. Built Continuous Integration CI system across multiple architectures that delivered automated updates after an automated testing circuit. Created SOA governance and testing procedures and mentored multiple teams in .NET, code reuse, build management and test-driven practices.

InfoSpherix, Architect Project Lead

Confidential

Built team of 12 from scratch, architected SOA system to support thousands of live terminals connected through an ESB backbone built on BizTalk. Trained all developers in new technologies and Test-Driven Development practices and lead the agile development process and insured 90 code test coverage on every sprint through Continuous Integration CI discipline. Managed Business Analyst team and interfaced with executive staff in delivering reusable components that could be used beyond the Ohio scope. Designed and managed multiple databases connected to the ESB through WCF, supporting OLAP and OLTP.

EMC Corporation, Architect, Multiple Customers

Confidential

Lead technical efforts for multiple high-profile clients. Designed, lead development, mentored and delivered full life-cycle enterprise solutions. Built reference architectures using live and usable applications that formed the basis for training and mentoring less senior development staff on the .NET 3.5 stacks and BizTalk. Pioneered and constructed library of attributes used in Aspect Oriented Programming to capture business value and gradually evolve legacy and poorly designed code. Designed, completely constructed and delivered an enterprise-wide Outlook Add-in in use by 30,000 users as part of Healthcare legal and compliance.

Simplikate, Document

Confidential

Lead the technical team in the development of a distributed and scalable document management system with fully customizable workflow options and an integrated Windows Explorer based client. Performed all requirements gathering and analysis, project management, production of full complement of UML documents and the development of a prototype demonstrating all the major features of the proposed software. Developed a Windows Namespace extension in C whose structure was completely configurable on the server-side. Wrote all service-bus Web Service and Remoting message contracts Contract First for distributed server interoperability, document acquisition, document annotations, security management and workflow processing. Designed generics-based object database that allowed extensibility system-wise through the plug-in of a .NET class implementing a set of interface contracts.

Confidential

Chief Architect

Federated Payment Serve as the Chief Architect and lead developer on an innovative Internet payment processing system patent pending . Designed high-load transaction processing system with off-line OLAP reporting and maintenance. Pioneered an expanded usage of Federated Identity that has been hailed as the most innovative application of the technology to date by the Liberty Alliance Oracle, Sun, HP, IBM, RSA, Novell, Intel . Work with worldwide vendors and financial clearinghouses in developing a universal transaction work-flow API for heterogeneous technologies. Designed and developed unique fortified security framework for which I am a co-holder of a pending patent. Used SSIS for data transformation and migration from disparate systems of the Telco Biller.

Independent Consultant/Contractor

Confidential

Provided architectural expertise and development on enterprise wide initiative at automating all forms of loan documentation. Documents captured via a KOFAX imaging system are indexed and an XML index document is created. Through the use of BizTalk business rules and orchestrations, these documents are then routed to different personal for functionary work. Each individual in the enterprise is now equipped with a MyWork queue viewer which gives them a comprehensive view of the work that they need to perform, based on their functional area. This development is creating a much more efficient organization that is doubling its loan servicing capacity without the addition of any new personnel.

Confidential

Technical Architect

  • Performed extensive analysis of current BizTalk 2002 Environment including over a dozen custom .Net modules, a dozen Orchestrations and 15 Maps. Created migration wizard project and tested upgrade/migration paths across limited bands of existing functionally. Produced optimization and migration plan to move to the new platform and gain modularization and performance gains in the process.
  • Produced executive reporting system for tracking production and safety statistics across the company's offshore drilling units. Collected statistics were computed and rendered as an executive dashboard in SharePoint with drill-down capabilities.
  • Software architecture and design. Producing software design for a .Net Framework system based on an established requirements specification.
  • WinForms Design and coding. Produced code and design input for a forensic document system to be used in the legal arena. System captures all documents on a network, regardless of source or format and consolidates into a single searchable format to enable investigation and discovery of evidence.

Confidential

Independent Consultant/Contractor

  • The telecommunications giant has a variety of internal technical efforts, and chief among them are the centralization of all the various sources of content, product/service information, legal data, knowledge bases and marketing material. This is a long-term effort to bring all the sources of information together and provide the tools to manage the sources as well. The strategic tool for the effort is MS Content Management Server CMS .
  • Provided R D into security issues, and end-to-end design/development of push-content CMS tools.
  • Developed a variety of Web Services and an XML Database substructure for a CMS toolkit designed to enable CMS Authors and Editors to manage push-content. Developed a placeholder control for HTML content capture that on publish sets off a sequence of steps to send e-mail/handheld literature to potentially millions of users. Provided some exhaustive research and development into security integration of multiple CMS applications managed by the same CMS Site.
  • This retail Demand Chain Management software group has gone through a number of evolutionary steps towards reaching a product vision that will fully implement the Japanese concept of TapinKanri pioneered by 7-Eleven Japan. TapinKanri roughly translating to management by SKU might perhaps best be understood as a means of high-volume, just-in-time inventory management and demand forecasting that enables a retailer to have the exactly correct quantity of the exactly correct product at exactly the right time.
  • Provided full scale re-architecture and next generation systems design.
  • Developed highly detailed design that went through several iterations of pattern identification and abstraction to maximize future portability and scalability of the system as new features and new statistical forecasting methods are developed. Primarily focused development and design efforts on the usage of open source components such as Tomcat and MySql, but insured that the system would be flexible enough to port to other container platforms such as WebLogic and other database systems such as SQL Server and Oracle.
  • Competition in the web hosting business is very challenging and only overcome through value adds and product offering differentiation. This hosting company aims to accomplish that through easily managed and extended portal and blogger systems, but in order to accomplish this many new features and modules must be created to run on these systems thus providing the differentiation.
  • Provided module and database design and module coding and development.
  • Based upon market opportunities for value added functionality identified by the company, designed and developed extended functionality modules that would be portable across a number of open source platforms, primarily PHPNuke and PostNuke. Additional involvement in the open source projects to contribute improvements in the underlying systems.
  • CSX, a rail/sea container shipping company, has maintained a competitive edge by harnessing leading edge technologies for its automated solutions. Differentiated from competitors by their web-based and customer self-service solutions, they have developed a strong and growing customer base. This project called for creating a scheduling component in support of a variety of customer support tools and a reporting engine replacement for Crystal Reports.
  • Provided architecture, technical leadership and component coding.
  • System was designed and built to allow existing applications to easily schedule recurring jobs and activities. This was accomplished through the development of interface support for easy integration and just-in-time component activation according to schedule. Replaced over a hundred reports with XSLT processing on any configured organization data source. Designed and developed underlying SQL Server database and supporting stored procedures for the scheduling component. Administrative and customer interface developed in ASP.NET and C . For organizational backwards compatibility, used legacy VB 6.0 to create MSMQ triggered COM application components that kicked off back-end processes.

Baylor Healthcare, Physician Portal Confidential

  • This healthcare provider is among the most aggressive in its pursuit of a web strategy for physicians and patients. The strategy requires moving thousands of clinical messages throughout their vast systems everyday and delivering them to a variety of devices, from web to handheld.
  • Provided rapid software development and technical mentoring to the Web Strategy team over 2 months.
  • Rapidly developed suite of extensible administration tools and provided assistance and training for migration to .NET. Architected and developed system of Server Controls to automatically inspect organizational .NET components and expose their functionality to portal users through reflection. Trained staff developers in the organization on utilization of controls and in development with C in general.
  • Distributing books internationally has required progressively more systems automation, and extending that automation to the Internet was a natural course for this customer. This system interacted with the customer's warehouse automation and supply-chain systems to enable customers to order online and for the orders to be processed with little human resource requirements.
  • Provided lead technical management and architecture for this four month, seven-developer project. The project is not yet complete, as the company moved its development activity for this project to Israel. However, the primary foundation and plumbing was created during these four months.
  • Utilized ASP to create web-based UI for both customer facing and internal use. Interface connected to primary Oracle database through ADO and COM Messaging MSMQ to connect to legacy warehouse automation and supply-chain systems through BizTalk schedules. Asynchronous transaction processing and order confirmation was made possible through COM Transaction interfaces MTS . Commerce Server acted as the primary glue for the customer facing and internal UI which drew heavily from the App Frame Work, Auth Manager, Biz Desk Security, Catalog Manager, Content List Factory, Euro Display, MtsTx Pipeline, Report Renderer and Shipping objects, among others, in order to enable extensive use of various Biz Desk modules, including Campaigns and Catalogs.
  • This customer's direct sales force operated primarily through paper transactions. This pilot project put handheld devices in the field for order acquisition and automated the ordering process utilizing some of Microsoft's most cutting edge technology.
  • Provided technical leadership and mentoring, requirements gathering and architecture. This was a six-month pilot project with four developers utilizing the latest Microsoft technology and loosely integrated with legacy systems through BizTalk Server. Was involved heavily in the vision building process for the project through extensive proposal and presentation work at the executive level.
  • Architected reusable and extensible business object framework using the .NET Framework and implemented these objects using VB.NET and exposed them to the web interface using ASP.NET. Encapsulated web entry forms for reuse and extensibility through the use of .NET Web Forms and pioneered use of the Serializable attribute for automatic pooled object storage in SQL Server. For appropriate business objects, messages were automatically sent to BizTalk during Serialization for integration with legacy applications and SalesLogix. Additionally, constructed automated return messages from SalesLogix to BizTalk for retrieval by the .NET application.
  • This logistics company wanted to be able to give real-time status information to customers regarding shipments of merchandise and enable their customers to make changes to their orders in real time. This system was designed to allow these functions and was built with extensibility not previously achieved for this company's systems and is now a reference project for other IT initiatives within the company.
  • Acted as project manager and lead JAD facilitator. Managed seven developers over the three month full life-cycle RAD development effort and contributed significantly to business object model design. Projected was completed early and under budget.
  • The utilities industry equipment and supply ordering process is notoriously antiquated. This system enables manufacturers of this type of equipment and supplies to easily catalog inventories and parts lists. It further enables the utilities to dispense with their paper catalogs and order electronically reducing turn-around time and enabling better utility project management. Costs of crews in the field are expensive, and when required parts are not available, projects are delayed while the crew is still on the clock. This system will eliminate this problem for utilities and is expected to be in production after Microsoft's .NET is commercially released and in widespread use within a year.
  • Acted as technical manager and lead architect. Mentored and managed four developers over a six-month pilot project window. Gathered requirements and participated in high-level venture capital sourcing meetings as the technology evangelist.
  • Architected reusable and extensible object model that drew heavily on the .NET framework and Commerce Server. The system's primary driving force lay within its cataloging capabilities, so extensive use of Commerce Server's cataloging component was an integral part of the development effort. In addition, many of the suppliers and vendors worked with low bandwidth Internet connections, so requiring use of online catalog management proved to be too burdensome. Our solution was to develop a Windows Forms application to run locally, and then through the serialization of catalog data to XML format, it was synchronized with the online Commerce Server catalog. Interfaces were developed for extensibility purposes, as further capabilities were planned to enable work site and project scheduling management available via WAP or MS Mobile Information Server.
  • HomeGrocer.com, On-line Grocery Store Java, ASP, IIS, JavaScript, Oracle, PL/SQL, XML, MQSeries, Site Server This now defunct new economy grocer rapidly rolled out an advanced system that allowed groceries to be delivered to the home or office. The cataloging features were implemented with XML and inventories were reflected on the web in real-time. This system was extensible and scalable, but the capitalization of other parts of the company did not go as planned so the system was only in use for a short period of time. However, some of the core technologies were picked up in an acquisition and are now being used by a commercial brick and mortar grocer for national operations and delivery services.
  • StudioM, Entertainment Web Portal Java Servlets, JavaBeans, JavaScript, Oracle, PL/SQL, Apache, XML, On2 This streaming music video web and interactive TV channel is still in the launch process as of last progress check, but this system was designed and built from the ground up utilizing many cutting edge technologies for web scalability and quality streaming video and audio.
  • Enron, Energy Trading Java, Oracle, PL/SQL, XML Design and development of core systems building blocks for this high-profile energy trader was essential as they branched into other markets. Components were constructed to allow maximum extensibility so future market development would require less ramp-up time.
  • WorldByNet.com, Dynamic Content Management Authoring ASP, VB, MTS, MSMQ, SQL Server, XML, Site Server Commerce This provider of electronic content grappled with the problems of content management before the hyped commercial content management packages were available. The problem was solved through the use of highly integrated ASP scriptlets and COM automation objects. The object model was highly distributed and integrated many of Microsoft's advanced technologies.
  • CollectionsX.com, Debt Portfolio Trading Java, ASP, Oracle, PL/SQL, XML, Site Server Debt portfolios are commodities that are frequently traded between financial institutions. The customers of this portfolio auction site must be able to drill down into the portfolio statistics, but the portfolio information must remain highly secure. This system enabled standard auctions and reverse auctions through a highly secure public key infrastructure.

Confidential

PM/E-Business Architect

eLogo.com, Company Store Intranet Java, Java Servlets, JavaBeans, JavaScript, Oracle, PL/SQL, Dynamo, XML Promotional products for large publicly help corporations are often times big ticket items, but prior to the development of this system were accomplished in most cases at a local level resulting in disparity of prices between regions and cost management issues. This system was developed to integrate into the customer's Intranets to allow a single point of contact for the acquisition of these products. Included in the system was a catalog of previously configured materials and the ability for customers to custom configure and order tailored products for specific events.

Confidential

President/CTO

  • AppFusion.com, Software Development Portal Java, Java Servlets, JavaBeans, JavaScript, Oracle, PL/SQL, WebLogic, XML The company's core product initiative was the creation of a portal and hosted software solution for software developers and engineers. This project broke ground on many new technologies, such as allowing a user to customize their portal and selecting various components for use as a part of their hosted solution. Unfortunately, AppFusion.com closed its doors and this product was never released.
  • SGS Thomson Microelectronics, Trading Partner Integration Java, JavaBeans, XML, SQL Server, IIS, JavaScript, WebLogic The customer was a microelectronics manufacturer that was faced with a completed unit inventory surplus. The solution to this problem was to decrease lot sizes during the manufacturing process to create only the quantities required, rather than creating surplus components in the first place. However, this solution was out of reach because of system deficiencies in inter-operating with suppliers. This effort integrated the systems of the customer's trading partners, enabling just-in-time ordering and manufacturing.
  • Downline Management Commissions Accounting System VB, Access, Oracle, PL/SQL, Exchange Server, MTS, Site Server The customer had to pay its force of over 40,000 representatives. That task alone is awesome, but when the commissions are calculated for a Multi-Level Marketing MLM downline, the computational complexity is exacerbated. As many MLM companies do, this customer outgrew the capability of its homegrown Access database and required something more robust and flexible. This system fit the bill and greatly simplified this formerly manpower intensive task, allowing the customer to redirect the attention of some 40 employees that were solely dedicated to this task.
  • XEROX, Support Center Tracking System Java, Oracle, PL/SQL, Apache, JavaServlets The customer handled hundreds of support calls from the end-users of its various products such as copiers, fax machines, and printers. A vast majority of the answers were already known and part of a multi-gigabyte knowledge base. However, this knowledge base was inadequately searchable and accessible. This project brought all the information together for simple searching and reporting for the support reps and for the users themselves via the World-Wide Web.

Confidential

Associate Manager

ECFMG, Medical Practitioner's Licensing System VB, Oracle, PL/SQL, COM/DCOM, Exchange, MTS The makeup of the body of medical practitioners changes every day. From new doctors, transfers from state to state and transfers of foreign practitioners into the U.S., the issuance and management of licenses to practice medicine is a complex task. One of the most complicated details of the system lied in the diversity of educational, language and residency requirements in each state. This diversity of requirements had caused previous attempts to create a unified system to fail. This system enabled largely automatic processing of licensing applications by succeeding where those other attempts failed the implementation of an easily modifiable rules based engine. This reduced the demand on the expert staff and enabled those staffers to focus their attention on problem resolutions rather than day-to-day processing.

Confidential

Mortgage Service Data Warehouse/Data Mart VB, SQL Server, FoxPro, E-Commerce, IIS, ASP Loan portfolios are an investment that is bought up by various investment banking firms. The customer managed the thousands of individual loans and the day-to-day transactions, but was lacking an efficient vehicle to report portfolio performance data back to the investment banks that own the portfolios. This system rolled up millions of transactions and activites collected from various systems into a data warehouse and enabled periodic performance analysis available to the investors via an Extranet web interface. In addition, this system allowed on-line and drill-down analysis of available portfolios so that investment-banking house could make informed buying decisions before committing to the purchase on-line.

Warehouse Automation Inventory System VC , VB, E-Commerce, IIS, SQL Server, ASP, COM/DCOM, RF, EDI In a warehouse with thousands of parts and inventory items, knowing just what all those parts and inventory items are is only half the battle. When orders are placed, those items must be shipped quickly, so it must be known precisely where in the warehouse that the sold item is located. In addition, the sold item must be marked as sold to prevent overselling and track replenishment needs. This system enabled the customer to automate these processes, reduce paperwork and cost, web-enable the administration of the warehouse, and automate replenishment orders with suppliers.

REO Management Tool VB, IIS, Oracle, PL/SQL, E-Commerce, ASP, COM/DCOM, Exchange, Wang Imaging There are hundreds of documents associated with a single piece of real estate, and the customer owned thousands of properties. Management of the thousands of inquiries on the contents of original documents in Real Estate Owned REO was a time-consuming and staff-intensive task. The introduction of this imaging system automated the management of these documents and enabled the large staff devoted to the management of REO to turn their attention to more productive tasks.

MCI Telecommunications, Project Control System VB, Oracle, PL/SQL, COM/DCOM, Mainframe Integration, Microstation, EDI This major telecommunications customer must manage hundreds of thousands of connections, circuits and switches to operate their ever-expanding worldwide communications infrastructure. To accomplish the task of expanding the network capacity, thousands of parts must be ordered and hundreds of technicians must be managed. The technician's time is a valuable asset, so the parts must be at the switching station ready for upgrade or installation when the technician arrives. Management of these thousands of projects required many systems to work together, including the external systems of trading partners. The number of systems involved introduced many points of failure until this system tied it all together.

Customer Benefits Marketing Systems VB, IIS, SQL Server, ASP, COM/DCOM, Mainframe Integration The customer managed the data for consumer award systems like Friends Family and Advantage , but the call centers that handled the thousands of inquiries were not able to promptly answer all the questions put to them. For many matters, a flag was entered on a mainframe system, which generated a follow-up letter containing the requested information. This web interface to the core mainframe data, made available to the call centers via an Intranet, enabled instant responses to the inquiries and made for a more satisfied customer.

Inventory Sales Tracking System VB, PICK, FoxPro, COM/DCOM, IIS, ASP The customer, a major supplier of new and used parts for major air carriers, has warehouses all over the world each managed separately. This made it difficult for the centralized inside sales force to fulfill orders and inquire on inventory. The process was to take the order and find a warehouse with the part by phone. If the part could not be located, it was ordered which usually meant delayed shipment and an unhappy customer. This system enabled real-time inquiry via an Intranet web interface to the PICK databases around the globe, while the customer was placing the order.

Western Geophysical, Seismic Analysis Storage Data Warehouse Java, Oracle, PL/SQL, Netscape Server The customer stores terabytes of seismic, sonic and infrared raw data on thousands of DAT and 9-Track tapes. When a customer would have a requirement for data on a particular location, the requested tape would be retrieved and the raw data loaded for interpretation by various scientific analysis applications that would generate the required information. This was a tedious process that was streamlined by a custom VLDB database architecture. The raw data was retrieved via a Java interface and made available instantly to the interpretive applications.

Well Production Management VB, E-Commerce, IIS, ASP, SQL Server, COM/DCOM, Exchange The customer managed the production of thousands of active wells across the U.S. Fluctuations in oil prices necessitate that the barrel production decrease or increase. This process was working too slowly. This system allowed the customer to instantly query on production for all of the wells and adjust the production of those wells within a day as oil prices dictated.

International Exploration Data Warehouse Netscape Server, Java Script, Java, Oracle, PL/SQL The customer searches for new oil fields and manages hundreds of active exploration projects all over the globe. The results of that exploration were kept in hundreds of paper files, E-mail, spreadsheets and other disjointed systems. This system brought all of that data together, simplified the management, reduced costs and made analysis of the results more efficient via a web interface delivered over a worldwide Intranet.

Materials Management Regulatory Compliance System VB, SQL Server, COM/DCOM, Exchange The government regulations pertaining to hazardous materials and chemicals are overwhelming. Precise quantities and locations must be known for all materials, certain materials cannot be stored in the same facility with other materials, the specifics of the containers must be on file for each material, emergency procedures must be kept for each different material, the precise chemical make-up must be known for each material, and the list goes on and on. This system linked the plants and storage facilities enabling enhanced management and safety, and dramatically simplified the government reporting requirements.

Call Center Quality Tracking System VB, SQL Server, COM/DCOM, Exchange, Real Time Voice Processing In a call center with over 300 customer service representatives, handling over 8,000 calls per day, quality assurance of those calls becomes a major problem. All the calls cannot be monitored, nor is it feasible to record all of them. Our client was tackling this problem by randomly recording service calls, which would later be forwarded to a quality analyst via cassette tape. There were a variety of scores and grades that would be rendered against the randomly sampled recordings, all recorded on paper and routed to the manager of the representative to whom the grade impacted. The largest gap between what our client had and what they wanted is that is would sometimes take 6 to 12 weeks to correct grossly deficient call handling and the paper records made it difficult to plot quality trends throughout the organization. This system enabled complete on-lin, real-tim sampling of customer service callas, immediate routing of grades to management and representatives, and effective management of long-term quality improvement with its robust reporting features.

VarTec Telecom, Circuit Connection Analysis Data Warehouse VB, SQL Server, FoxPro, E-Commerce, IIS, ASP, COM/DCOM, VB Script The customer was a regional long distance carrier, 1 dialing toll operator and pre-paid phone card provider who leases voice bandwidth from a larger supplier's voice network. Faced with the difficult challenge of reconciling bandwidth usage statements, multiple vendor contracts and an expanding customer base, a means of tracking connections and effectively routing calls through the most cost-effective circuits was a paramount concern. The row data was available periodically, but the means to analyze and recognize trends were not. This data warehouse project brought all of the connection data into a consolidated Intranet interface and enabled more effective proactive management of call routing, trend analysis, and, most importantly, increased margins.

Long Distance Toll Customer Data Warehouse VB, SQL Server, E-Commerce, IIS, ASP, COM/DCOM, VB Script In the information age, the maxim is that effective analysis of available customer information enables identification of additional customer needs, preemption of negative trends and boosts to positive trends. For this customer, a wealth of customer information was available in a variety of disjointed mediums. It was believed that bringing this customer information together would enable answers to questions about what markets are most effectively penetrated and why customers have switched to and from the customer's services. This data warehouse project that rolled up all available customer information into a single interactive web-enabled analysis tool delivered via an Intranet, proved the maxim to be true.

Warehouse Management Automation System VB, E-Commerce, IIS, SQL Server, ASP, COM/DCOM, VB Script, Exchange The customer had to deal with over 500,000 in warehouse inventory turnover every day. Managing the incoming and outgoing items and the warehouse staff necessary for that business volume had outpaced our client's ability to efficiently run their warehouse operations. The required the ability to forecast and schedule their warehouse manpower in addition to automating order fulfillment and warehouse restocking. This system met their requirements and raised automatic supplier requisitions via E-mail and other business process improvements that had not been previously considered.

Asset Tracking System VB, SQL Server, E-Commerce, IIS, ASP, COM/DCOM, VB Script, Exchange The customer had thousands of assets, totaling over 25 Billion. From office furniture to loan pools, each asset needed to be tracked. Previous to the implementation of this system were various systems tracking different types of assets at different locations. Through the use of a barcode labeled asset tag and an asset numbering system, this system delivered the ability to do broad asset searches via an Intranet. From doing reports on certain types of assets to locating a particular unit of furniture, this system was critical to a number of departments. The accounting department's efforts to more effectively manage depreciation and take advantage of tax deductions, the executive office's efforts to prepare for a recently completed merger, the loan departments' efforts to negotiate better loan pool purchase agreements, and many other aspects of this customer's business were positively impacted by the implementation of this system.

Confidential

Chief Architect/Project Mngr.

Premium Ware, Premium Audit Collection System VB, VC , SQL Server, Oracle, PL/SQL, Sybase, E-Commerce, HTML, CGI, COM/DCOM, Exchange, EDI General liability and Property and Casualty premium rating and collections is a complicated business compounded by hundreds of thousands of customers. Each of those customers goes through a variety of changes every year, complicating the matter further. Various policies are selected for audit at expiration, and previous to this system's introduction, this was an extremely intensive paper-laden activity. Policies were copied and mailed to field auditors, auditors created various spreadsheets detailing the audit which were then mailed back to the insurance company for review, audits requiring further examination were mailed back to the field for update the paper bounced back and forth for months, delaying collection. This system completely automated this task and aided our client in tracking and collecting these premiums.

Thomson Corp., Supply Chain Requisition Invoicing System Confidential

The customer's business is wholesaling high-volume specialty retail items, but a large portion of their expenses were tied to ordering from suppliers, paying the invoices and billing their customer. This system allowed our client to inter-operate with their suppliers and customers via EDI for dramatically reduced costs.

Optic Solutions, Sales Order Shipping Management System E-Commerce, Netscape Server, CGI, Perl, Scripting The customer was the U.S. point of contact for numerous high-tech items from foreign suppliers. Our client's customers were sales groups who sold the items to retail stores. Much of the staff's activities revolved around taking orders from customers and answering shipping questions. This system enabled the customers to log in via an Extranet to place their orders and track the shipping on those orders, dramatically reducing the load on the staff.

Traveler's Insurance, Broker Commissions Management System VB, SQL Server, E-Commerce, Netscape Server, Scripting, MS Mail Computing commissions on sales of insurance policies is a complicated endeavor even when aided by spreadsheets and mainframe computers, as was the case with our client. Add to that a tiered commission structure, monthly incentive programs, quarterly bonus plans, commission reversals and rebates it required an entire department to manage the commission payments, up to two weeks to get simple inquiries answered and typically two months to get any type of disparity resolved. This system enabled on-the-fly commissions computation with a drill-down web interface delivered via an Intranet. The system's implementation enabled the entire department to move on and do more productive work within the company, and please the insurance agents who could now answer their own inquires via the Intranet and talk with a single person if a disparity were to be found.

Aetna, Premium Control System VB, SQL Server, E-Commerce, IIS, ASP, COM/DCOM, Scripting Various state insurance boards govern insurance premiums through a complicated classification system. Each type of employee is governed by a different class code. Throughout the term of any insurance policy, an insured company will undergo many changes in salaries, exposures, units and class codes. As companies change, and notify their agent, the agent will submit these changes to an insurance carrier to determine premium rate changes. As the regulations pertaining to insurance premiums change constantly within each state, agents were consistently behind the curve in notifying clients of premium changes. This system made those changes available real-time and allowed for better service for the customer's insured companies.

We'd love your feedback!