Ysaias P.

We are a small team of highly skilled and professional people with over 45 years of combined experience. We support and develop for many large and small companies, maintaining very large databases and Business Intelligence environments. Our projects cover a great variety of businesses like large healthcare systems, banks and government agencies in North and Latin America. In 2009 we completed the first completely automated data warehouse for a US healthcare organization. This project provides the company with robust and flexible analytical and statics reporting environment, allowing the customer to create and analyze their data without any database knowledge. Currently we just finished upgrading their environment to SQL Server 2008 R2 and enable many new features from the Microsoft BI stack. Each one of our team has been working in their respective area at least 10 years. We have 2 team members holding a Data warehouse Institute certification (CBIP) and a MCITP: Business Intelligence Developer (2005/2008), one holding a Microsoft Certified Solution Developer (MCSD), a second developer holds a PHP Certification and another team member holding a MCITP: Database Administrator and MCITP: Database Developer (2005/2008). Services we offer: Databases: Design and document database architecture and Data Modeling. Design Data Warehousing and Business Intelligence platform using Microsoft Analysis Services and SQL Reporting Services. Architect, design and implement databases, tables, Stored Procedures, CLR procedures and User Defined Functions. Set up data sharing and disk partitioning. Develop database utilities and automated reporting. Create shell scripts for task automation. Analyze and sustain capacity and performance requirements. Analyze, consolidate and tune databases for optimal efficiency. Monitor systems and platforms for availability. Install, configure and design database servers’ environment on Windows failover clustering, database mirroring and Replication. Oversee backup, clustering, mirroring, replication and failover. Restore and recover corrupted databases. Install and test SQL upgrades and patches. Implement Database security and encryption. Provide 24/7 support for critical situations. Evaluate and recommend new database technologies. Design, develop and implement automated Disaster Recovery processes and procedures. Application and Web development on .Net and PHP: Full lifecycle Winform and Web application development. Maintain existing applications Upgrade existing web applications. Create codes and DLLs. Create Software analysis, code analysis, requirements analysis, identification of code metrics, system risk analysis and software review reliability analysis. Object-oriented Design and Development (OOA and OOD). Service Oriented Design and Development (SOA). Software modeling and simulation. Front end graphical user interface design. Software testing and quality assurance. Performance tuning, improvement, balancing, usability, automation. Evaluate and identify new technologies for implementation. Data Movement, Cleansing and ETL Development: Analyze business needs and requirements Translate business needs into technical and system design specifications Design datawarehouse schema and data model Manage reporting meta data and data standardization for end to end integration Write ETL scripts, design and develop reporting end user layers and reports. Design and implement publication layer like dashboards Manage DW support activities, Issue tracking, escalation and resolution Develop ETL processes to support existing and new data warehouse. Create ETL design, development and testing based business requirements. Systems integration Import and Export data from/to csv,xml,Oracle,MySQL,DBII,Mainframe,Cache,SQL,MS Access, Excel, txt and other sources. Data Availability and Disaster Recovery: Implementation of Database Mirroring, replication and log shipping. Setup from Scratch SQL Server Failover Cluster on multiple Windows 2003/2008 Servers. Develop automated DR Hot and Cold sites processes that can be implemented with ease. BI, Reporting and Data Warehouse: Design architecture, map business rules and processes into technical solutions. Perform analysis, evaluation and development of data mining in a data warehouse environment that includes data design, database architecture, metadata, and repository creation. Design Data Mart solutions including star schemas and cubes. Implement Data Management strategies which include validation of source data and the use of data in management reporting. Develop design specifications, unit test plans, and troubleshoot client issues. Analyze, design and implement User Interface (reports and dashboards) Provide advice and guidance on data warehousing approaches and solutions, and use of data warehousing methodology. Evaluate and Select data warehousing tools for business intelligence, data population, data management, metadata management, and warehouse administration. Table and interface design, development of logical and physical data model/database, ETL processes, BI reporting and OLAP cubes. Develop complex static, interactive and analytical reports using SSRS and ProClarity.