|
|
Services
Database Management
- Database design
- STAR and snowflake schema design
- Database normalization
- Performance tuning
- SQL queries and stored procedures
- Query optimization
- ETL Data migration systems for imports, exports, warehousing
- Backup and disasaster recovery
Business Intelligence
- Business performance management
- Business analysis and requirements
- Benchmarking and Business analytics
- Defining Key Performance Indicators (KPI)
- Metadata repository development
- Reporting Systems
Data Warehousing
- Data architecture
- Data modeling - define and design logical and physical data models
- Process flow and data flow design models
- Data discovery and profiling
- Dimension and fact table design
- Data mart management
- OLAP data cube design and generation
- Extract, transform, and load (ETL) of structured and unstructured data
- Data cleansing functions for standardization, linking and matching
- Data quality improvement analysis
- Performance testing and optimization
- Project management tasks, deliverables and schedules
- Prototyping models
Reporting
- KPI/Metrics - define and implement Scorecards and Dashboards
- Create central report repositories
- Design and distribute complex reports
- Prototyping centralized reporting systems
- Security planning and implementation
- Quality testing
- Administration training
.NET Programming
- Web applications (VB.NET web forms)
- Windows software applications (VB.NET win forms)
- Full life cycle development
- BI and reporting applications
- Expert coding, testing, and deployment experience
|