Integration via ETL
i) Stage One • Establishing connections to Sybase databases on Unix server (data acquisition) • ELT process with BCP-ing data into files, moving them to SQL server database BCP into staging and then transforming to new schema in SQL server database (data Ingestion with the elements of data connectivity, integration, meta data capturing and data quality) ii) Stage two • establishing the source databases and tables necessary in the analytics (data acquisition) • connecting to SQL Server database with SSIS • running SSIS packages (data Ingestion with the elements of data connectivity, integration, meta data capturing and data quality) 2. Business Intelligence i) Data consolidation and transformation with SSIS packages with automation of the SDLC ii) Running processes on schedule (automated workflow management) iii) Two warehouses: business and operational 3. Enterprise Analytics and Visualization
About Me
We are a team of highly dedicated developers with expertise in building Microsoft, Java, JS, and Python applications. We've been around since 2001 and have built up an impressive portfolio of projects. Our skills include: * Portals, databases, reporting, data, and analytics * Web, Desktop and Xamarin based mobile apps (sources of records apps) with expertise in high-load systems * JavaScript and TypeScript: Angular, React, Vue, Node, Amber, Backbone, Meteor * Microsoft BI applications, including a complete stack of SSIS, SSAS, SSRS and PowerBI * Integration via APIs, pipelines, Powershell, SSIS, Data Factory and Biztalk, other integration tools * Microsoft Cloud: Office 365, CRM and ERP * Azure Service & BI and Cortana AI-based solutions * DevOps with Powershell and other MS tools * Production Operations: Disaster recovery, backups, configurations Among our clients are companies of all sizes (from Disney to startups to individuals) with references available upon request.
