(888) 812-6318
Let's Talk.
M&S Consulting Logo

M&S Consulting has developed solutions that require robust OLTP and OLAP functionality. We are experienced at designing world-class database architectures as well as implementing solutions that allow data to be easily entered and retrieved from them. We have built data warehouses storing close to 10 terabytes of data and retrieved most reports from them in less than five seconds delivered via the web. We understand the capabilities and limitations of leading databases like Oracle and SQL Server, a value to every organization as electronic data becomes more critical in this day and age.

Data is the Water of an Organization

- Ashok Aggarwal, M&S Consulting

Our dedication to database services is best summarized as a member of our management explains: “Data is the water of an organization. M&S Consulting ensures that your water is clean, safe, and abundantly available to the right people at the right time.”  We provide many services that relate directly to data and databases as well as indirectly via the applications that utilize the data either transactionally and/or analytically.

Data Warehousing and ETL

M&S consultants have implemented robust and scalable data warehouses that are critical to operations and serve as Decision Support Systems. We have implemented complete solutions including database architecture/design, ETL process implementation with complex transformations from various data sources, analytical reporting, and performance tuning. Having a sound understanding of databases, performance, and robust application development, M&S can aid in every aspect of your data warehousing implementation.
Following are some of the related technologies used with our data warehousing implementations:
  • Ab Initio
  • Informatica
  • Microsoft DTS
  • Custom ETL
  • Stored Procedures (PL/SQL)