nSage Technologies Portfolio

Consulting Services Data Load and File Management Systems Development

System Admin — Thu, 22 Jul 2010 00:35:00 GMT

Sample Name: Data Load and File Management Systems Development
Client Name: Mckesson Corporation
Features: Back Office, Architecture, Design, Systems Development
Short Description: Provide support, analysis, design, architecture and development services for a medical financial system that creates paper claims and statements as well as online access for patients to their statement information. The primary focus is the manipulation of PHI data sent from hospitals and ETL processes that load it into SQL Server.
Long Description:

Provide support, analysis, design, architecture and development services for a medical financial system that creates paper claims and statements as well as online access for patients to their statement information. The primary focus is the manipulation of PHI data sent from hospitals and ETL processes that load it into SQL Server.

One solution that we helped to architect loads incremental data daily from a hospital to recreate their full dataset instead of the hospital sending full loads daily. Two key benefits are the reduced processing on the hospital systems and the ability to extract and blend data in various formats for different timeframes and blend the data with other sources.

Another solution that we architected is a file management system that harvests files from various sources (FTP, SAMBA, SFTP, FTPS and UNC paths), stores them in a repository, has a file identity system, file routers and event logging. This is a unified system that replaces several single task applications for managing the thousands of files this group receives and manages daily. It is designed to scale out with multiple light weight Harvesters and Routers placed across the network and using WCF to communicate between the services.

Consulting Services Ondemand Template Driven Digital Printing Application

System Admin — Thu, 22 Jul 2010 00:30:00 GMT

Sample Name: Ondemand Template Driven Digital Printing Application
Client Name: Synq Solutions
Features: eCommerce, Marketing, Back Office, Strategic Consulting, Architecture, Design, Systems Development
Short Description: Assigned as Product Manager and Lead Architect leading a team of 3-5 developers to build a platform to decrease time to market, decrease maintenance and increase stability of client systems. The core system was architected as a framework providing base web GUI and Backend Services including Security, Navigation, E-Commerce, Processing Managers and Print Adapters. The framework defined and implemented a skinning and plug-in model to quickly add new clients and business logic.
Long Description:

Assigned as Product Manager and Lead Architect leading a team of 3-5 developers to build a platform to decrease time to market, decrease maintenance and increase stability of client systems. The core system was architected as a framework providing base web GUI and Backend Services including Security, Navigation, E-Commerce, Processing Managers and Print Adapters. The framework defined and implemented a skinning and plug-in model to quickly add new clients and business logic.

The technologies involved in developing the platform included .Net 1.1/2.0, MS SQL Server, Crystal Reports Server, PageFlex, XPIFs, Windows Services, Adobe Document Server and other PDF toolkits to create documents on demand for printing and fulfillment.

This application reduced the new client technology development time from 9 months to an average of 1 month. It provides a base set of services that can quickly be assembled into a custom application for their clients. It also provides the ability to quickly add new components for any given client. The application currently supports 8 major clients, 900 sub-clients and over 8000 end users.

Consulting Services Princeton Retirement Group Consulting

System Admin — Thu, 22 Jul 2010 00:23:00 GMT

Sample Name: Princeton Retirement Group Consulting
Client Name: Princeton Retirement Group
Features: Back Office, Architecture, Design, Systems Development
Short Description: Original 1 Month Contract extended for 3.5 years on 18 separate projects.
Long Description:

Original 1 Month Contract extended for 3.5 years on 18 separate projects. Highlights are listed.

In all of the following projects I was responsible for the full life cycle (Analysis, Design, Development, Testing, Documentation, Deployment and Training). I did all of the development work for the GUIs, services and databases. The technologies used include: Visual Basic, Business Objects, Windows API, ASP, IIS, MAPI, SMTP, SQL Server, VBA, Excel, Word, NT Service, SMTP, XML, XSLT and HyperAccess Scripting.

1) Compliance Audit Package System – A Process Management System that helps the Compliance group manage the analysis, data correction, reporting, packaging and delivery of period audit reports. These packages contain from 20 to 30 reports depending on the client. The application extracts data from a Unix based system into a SQL Server datamart. The UI manages the steps in the process with drill down analysis tools, PDF report creation, analyst assignments, reviews, Excel management reports and delivery to a processing center, web or e-mail. The application runs as a Windows UI, with NT services that run as processing managers for extractions, calculations, Business Objects report creation and package delivery.

2) Universal Document Service – A Web Service that manages the reception, storage and delivery of client documents and their associated indexes to multiple Web applications. The web service uses IIS, ASP, VB COM, XML, XSLT and SQL Server. Two Windows UIs help manage documents and the XSL templates. COM objects that encapsulate the XML communications are used by Windows applications that send documents to the service.

3) XP/AD/Office 2003 Migration Team Leader – Lead a group of 5 technicians, plus various temporary resources to migrate 500+ clients from Windows NT /Office 2000 to Windows XP, Active Directory, Office 2003 and SMS. This included testing and user acceptance of 170+ applications, account migrations, installation scripting, PC certifications, training and deployment across 3 sites.

4) Bank Transfer – Manages the transmission and reception of Checking Account Issuance, Clearance and ACH records between the client and several financial institutions via dial-up, FTP or HTML. The application runs as a Windows Service with a Windows UI to manage the accounts and connection information stored in a SQL Server.

5) Batch Ticket Manager – Coordinates account information between recordkeeping and the Compliance group. The application runs as one standalone Windows UI and a secondary component embedded in a console application with data stored in a SQL Server.

6) Conversion Manager – Manages the process of adding new accounts. The application runs as a Windows UI using data in a SQL Server.

7) Hierarchy Code – Creates and maintains end user hierarchy security codes. The application runs as a Web UI using IIS and ASP in the middle tier and SQL Server on the backend.

Consulting Services Century 21 Projects

System Admin — Thu, 01 Jul 2010 18:37:00 GMT

Sample Name: Century 21 Projects
Client Name: Century 21 Real Estate
Features: eCommerce, Community, Multi-Language, Marketing, Back Office, Strategic Consulting, Architecture, Design, Systems Development
Short Description: Worked with executive management to design the CENTURY 21 technology strategy.
Long Description:

Worked with executive management to design the CENTURY 21 technology strategy. This was an end-to-end strategy involving sales force automation, brokerage management, transaction management, enterprise communications, public access via the Internet, vendor integration, management reporting, customer service systems and Executive Information systems. This was for the entire company of 500+ staff, 5000 brokerages and over 80,000 sales associates.

Managed the development of these strategic systems using an internal software development team (80 people), outsourcing providers and strategic partners. Delivered an intranet to (5000 brokerages and 80,000 associates), a public web site (century21.com), a public site on America Online (CENTURY 21 Communities), a real estate agent product (PowerPak 21 Agent), a real estate brokerage management product (PowerPak 21 Broker), two multimedia sales presentations, an executive information system (500+ users), a training registration system and cleaned up our internal transaction management system (over 10 million transactions a year). All of this was accomplished in little over 18 months.

Managed the sales and evangelism of these products and services. This included creating presentation materials, presenting to medium and large groups (up to 4500) and writing articles for company wide distribution (100,000 people). Managed the implementation of these systems including testing, hardware bundles, rollouts, training and support services.

Consulting Services Coca-Cola Consulting Projects

System Admin — Thu, 01 Jul 2010 18:28:00 GMT

Sample Name: Coca-Cola Consulting Projects
Client Name: Coca-Cola
Features: Back Office, Architecture, Design, Systems Development
Short Description: Original 6 Month Contract extended for 3 years on 3 separate projects
Long Description:

1) Responsible for designing the architecture and building all three tiers of an Extranet Application. The client tier is built with Visual Basic ActiveX Documents hosted in Internet Explorer. Reports are generated using ASP scripts. The middle tier uses Windows NT, IIS and COM Business Objects. The Database Tier includes Oracle, DB2 and Teradata. This application has a user base of 200 clients, contains 90,000 lines of code, 98 VB modules, 65 ASP scripts and 37 PL/SQL stored procedures.

2) Provided business analysis and built the user interface using Visual Basic for a 3-tier reporting tool. Technologies include Orbix COMet to communicate with a CORBA middle tier connecting to a Teradata database tier. This application has a user base of 1000 clients, contains 26,000 lines of client code and 82 VB modules..

3) Designed and built a Deferred Query Server that runs as an NT service. A client application submits Oracle and Teradata queries to the server. The server parses the queries, submits them to the appropriate database server, processes the result set, converts it into a standard database and notifies the client of the progress.