Enhancement of Mainframe based Online/Offline system for 50 data storage areas handling 125 million air-bulls per day to 100 data storage areas to handle 250 million air-bills per day meet reporting needs.
Allstate Insurance
Web based POS application conforming to regulatory standards using Java technologies to provide single platform for all the channgels to obtain products and services.
AOL Time Warner
Involved in the testing phase of the data warehouse initiative including creation of Test Plans, TSD, Code Review, OPS Review, Data Validation and Bug Reporting.
Bank of America
Design, redesign and development of multiple data warehousing projects including Global Payments System and Sales Office Exchange.
BankOne
Design and Development of Performance Management System with web interface capability using OOP techniques.
Bearing Point
Implementation of enterprise wide reporting system utilizing BI methodology.
BlueCross BlueShield Association
Design and Development of web based desktop application for collection, categorizing and reporting of customer information.
City of Corpus Christi
Infrastructure review, system upgrade, database migration and implementation of ERP module.
Compassion
Upgrade, synchronize and replicate multi-country, multi-location databases from SQ Server 7.0 to SQL Server 2000.
DC FACES
Implementation of Statewide Automated Child Welfare Information Systems (SACWIS), a comprehensive automated case managemen tool that supports social workers' foster care and adoptions assitance case management practice including complementary functionality that supports child protective and family preservation services.
ENDFORCE
Design and Assisted in Manual and Integration testing phases of software.
FannieMae
Developed a Java based application conforming to federal financial standards for recognition of periodical financial data.
FileNet
Modification of the existing work management product's eBusiness framework to .NET platform.
FISKARS
Successful migration of legacy data into the newly implemented ERP system.
Florida Power and Light
Implementation of one module of ERP with responsibility from requirment gathering to documentation.
General Dynamics
Designed and implemented an integrated inter-agency data warehouse for raw data collected from sveral different operational systems and stored in multiple distinct databases.
GlaxoSmithKline
Utilized MicroStrategy suite to calculate the utilization percentage of different reports by various departments and cadres within those departments which would help management to decide which reports to keep up & how to instruct personnel to put reports to better use.
Health & Human Service Commission
Consolidation of systems of 12 existing agencies with different IT systems into 5 ERP based systems, implementation of ERP modules, and multiple instances of system migration.
H-E-B
Two separate initiatives - a data warehousing project to collect, transfer, aggregate and sort 1.4 billion rows of data from nearly 300 stores for merchandise and shortage analyses and a BI reporting project to enhance performance of the pharmacy division and meet enterprise wide reporting needs.
HP
Integration of Enterprise Learning Management System with other enterprise applications and development of custom solutions for more than 200K employees.
Knight Ridder
Supported a two-step migration and upgradation process involving ERP and Client/Server technology.
LCRA
Designed the EPM data warehouse schema, optimized existing Peoplesoft application by resolving connectivity and performence issues and upgraded the components of the PeopleSoft system.
MAGELLAN
Conversion of a VB.NET project into a web based system utilizing C# and ASP.NET
Mentura
Development of proprietary APIs using XML WebServices using .NET technology to enable business partners to participate and integrate with Mentura's Affiliate program.
Nationwide Insurance
Enhancements to the existing data warehouse of the Finance Division Assisted in ETL process from various legacy source systems into the warehouse.
Neiman Marcus
An OLAP initiative utilizing MicroStrategy to analyze data and evaluate performance of various online outlets and to suggest steps to improve performance.
NY State Department of Education
Design and Development of web based tool using Java technology for teachers to apply for and obtain teacher's licence online.
PacifiCare
Assited the IT Department of the Finance Division in its effort to convert all existing applications to .NET platform.
Shearman & Sterling
Database Administration services including logical and physical data modeling, installation and upgrade of software, implement security, regulate users and access, and backup and recovery.
Sprint
Designed project reporting system using Client/Server technology to track the status and progress of projects using key criteria.
Texas Education Agency
Installation of PeopleSoft EPM, upgrade of Informatica, design and implementation of data warehouse schema.
Texas Lottery Commission
Design and development of a case management system in Client/Server.
Texas Online
Development of a system capable of providing summary and detailed intranet, internet and web enabled reports using BI tools.
Texas Workers Compensation Commission
Design and development of web based system for doctors to report injury information and for agency personnel to verify coverage and eligiblity.
Trammell Crow Company
OLAP project using MicroStrategy in a non ETL environment to cater to the needs of financial and marketing departments.
Verizon
Implementation of reporting system using BI tools to track, monitor and evaluate technician performance.
Walt Disney
An EAI initiative to integrate business units spread across the global with SAP system in real time employing WebMethods.
Wyeth
Development o BI based reporting system to provide sophisticated OLAP capability and to retire existing database reports..
An unexpected need arose where we needed to complete some application development in a very short time frame. Lodestar Systems provided very competent resources on short notice...