- MARINE RESEARCH FORECASTING, AI/ML DECISION MAKING for a leading Marine Research and Protection Agency. Project comprises of analysis of various research and related data including but not limited to underwater sensors, satellite imagery and various special imagery and related data. This allows researchers to gather vast amounts of information quickly and consistently, spanning large geographic areas and extended timeframes. Specialty ML algorithms trained to identify marine species in images and videos captured by underwater cameras or drones help researchers track species distribution, behavior, and population dynamics, aiding in biodiversity assessments and conservation efforts. AI-driven predictive models integrate oceanographic data to forecast changes in ocean currents, water temperature, and weather patterns. aiding in understanding the effects of climate change on marine ecosystems and improve preparedness for extreme events.
- FULLSTACK E-COMMERCE SOLUTION for a local and online retail supply company. Includes complete setup of end-end e-commerce solution which includes integration into facebook, pinterest, houzz and Merchant seller on Amazon, Google Shopping and more. Also provide a centralized Inventory Mgmt solutions across multiple platforms and integrated POS solutions. Full setup of Accounting solutions and Payroll & Timesheet solutions, Retail Tax payment solutions. Implementation also includes marketing solutions both local and online and email-marketing platforms.
- E-CLINICAL IMPLEMENTATION WITH AZURE CLOUD SERVICES HIPAA regulated Clinical implementation for a local non-profit organization to enable patient management and mobile assessment of patients and potential patients. Integration with current EMR systems to pull and push data through cloud APIs. Data on rest Data Masking and Data Encryption and data in motion SSL Encryption. Implementation of Geo Mapping & Geo Layering of data to perform comparison of Socio-economic and clinical data. Partner data feed implementation and reporting dashboard with KPIs.
- CONSOLIDATION TO CLOUD BUSINESS INTELLIGENCE – Development & Support of an enterprise cloud-based Bigdata analytics system including extensive reporting for a international IPTV company. This project centralizes 300+ customer bases ( each customer base with 20 to 500,000+ individual user base) which has 300+ individual standalone Business Intelligence system to a single centralized cloud based enterprise Business Intelligence system with geographical distributed computing. Includes design of multi-tenant architecture with cloud deployment stacks and extensive cloud analytics process monitoring and reporting with tools such as Tableau, copperegg, pagerduty, VisualOps, ELKStack with a variety of databases and caching components such as Oracle RDS, MySQL RDS, Redshift, Couchbase, Dynamodb, Redis with cloud load balancers (ELB) both public and private facing and isolation of Development , QA, Staging and Production Networks through Virtual Private Networks. Includes other cloud technologies such as Elastic Map Reduce (EMR), Data Pipelines, S3, Elastic Cache , CloudWatch, EC2 Auto Scaling, Load Balancing. Adhoc reporting though Tableau Reporting Servers. This implementation saved the customer both in short and long term millions in terms of 1000+ Servers /hardware and administration, support and maintenance.
- BUSINESS INTELLIGENCE BROKERING SYSTEM for a major credit card company that allows central brokering of data delivered from CostCenters, Project Mgmt Department, IT Division (Windows Domain Information of Users) , HR/Payroll and delivering automated stake holder reporting through intranet and emails. Development includes high-level security compliance and layered security features that allow various presentations of the same reports based on domain credentials and titles. Delivered through Crystal Reports Services with SQL Server and linked-servers to Oracle (SAP Business Objects Universe) for HR data.
- DATABASE CONSOLIDATION AND VIRTUALIZATION & SUPPORT of capacity planning infrastructure for a major virtualization giant including high availability federated cluster (16 Nodes) setup for over 50TB of data. Extensive tuning of Data Transformation Services to increase processing of events per second from billions of events being generated all over the globe. Also balancing of loads of database cluster nodes and geographical isolation of performance issues so all regions or customers don’t get affected due to high load or processing of data from another region.
- DBA AND DEVELOPER CLASSROOM TRAINING for a major CAD software company. The company requested as a Microsoft Certified Training and Solutions partner to follow Microsoft Curriculum and train the Development and DBA team to provide advanced Development & Administration Training and provide them with extensive development and support guidelines to reduce customer issues and maintain internal customer SLA levels.
- CONSOLIDATION/MIGRATION AND DISASTER RECOVERY site setup for a major German Electronic Giant. Additional provide DBA & Development Team internal SLA procedures and Guidelines. Tasks include migration / consolidation and virtualization of 100+ SQLServer databases and 50+ Oracle Databases across 50 + servers. Additional setup includes extensive monitoring through Dell Spotlight, Foglight, Tripwire
- CONSOLIDATION AND VIRTUALIZATION of Oracle/SQL/MySQL databases for a major Pharmaceuticals with over a billion in revenue. The challenge is to meet several ISO and pharmaceutical standards and keep in compliance every step of the way including data security and secured transfers and data sharing restrictions.
- REALTIME SYSTEMS DATABASE DEVELOPMENT/SUPPORT/MIGRATION for a leading City’s Police Department CrimeLab DNA Analysis and Forensics. Implement extensive security and logging for data access and protection.
- MOBILE WEBAPP DEVELOPMENT(cross-platform compatible) for a public sector Behavioral Health Department on SQL Server.
