contact presentations resources blog development projects

Microsoft Certified Information Technology Professional (MCITP), Microsoft Certified Database Administrator (MCDBA) and Oracle Certified Associate (OCA) certifications have been achieved. Database and data warehouse skills include both OLTP and OLAP environments using SQL Server, Oracle and Teradata with Kimball and Inmon methodology, data warehouse design, database tuning, optimization, performance monitoring, bulk data loads, legacy system data conversions, complex heterogeneous queries, stored procedures, ETL packages, MDX, data mining, statistical data analysis and extensive reporting/analytics applications development.

  • Microsoft SQL Server 6.5, 7.0, 2000, 2005 and 2008 (OLTP, SSRS, DTS/SSIS and OLAP/SSAS with Data Mining and Excel Data Mining Add-Ins)
  • PerformancePoint, ProClarity, SharePoint 2007 (MOSS), Cognos 8, Business Objects XI R2 and Crystal Reports
  • Oracle 7.32, 8i and 9i, 10g
  • Teradata V2R6.1, 12.0 with TPump, MultiLoad, FastLoad Utilities
  • MySQL 4.0 and 5.1
  • Statistics and Data Mining with SAS, SPSS, Minitab and Weka for Classification (Decision Trees, Naïve Bayes), Clustering (K-means), Association (Item-Based Collaborative Filtering, K-nearest neighbor), Regression, Predictive Modeling and Forecasting)
  • Logical/Physical Data Modeling with ERwin and PowerDesigner
  • Microsoft Access and Excel/VBA

Microsoft Certified Solution Developer (MCSD), Brainbench ASP.NET and C# certifications have been achieved. Programming experience includes project management, business process analysis and requirements definition for web based, desktop and client-server applications deployed on Unix, Linux and Windows operating systems. Developer IDE packages and programming languages include:

  • Visual Studio 6, .NET, C#, Visual Basic, VBA, ASP and ASP.NET
  • Cold Fusion
  • PHP, Perl and CGI
  • HTML, Javascript, CSS and DHTML
  • Web Services, XML, XSL, XSLT and XPath