Results for “tec”

Provides PostgreSQL query patterns covering SELECT, JOINs, subqueries, CTEs, window functions, and advanced SQL techniques.

Applies quantitative and qualitative analysis techniques, interprets experimental data, validates procedures, and selects appropriate methods with uncertainty quantification.

Transform raw data into compelling narratives with structured story frameworks, visualization techniques, and presentation templates for executive audiences.

Optimizes SQL queries by analyzing execution plans, rewriting patterns, and applying performance techniques for PostgreSQL and MySQL.

Decomposes trading ideas into actionable Pine Script components by analyzing YouTube videos or conceptual questions, then produces structured implementation plans.

Store, query, and export genomic variant data (VCF/BCF) using TileDB's sparse array technology for scalable population genomics workflows.

Control liquid handling robots, plate readers, pumps, and other lab equipment through a unified Python interface across platforms.

Optimize SQL queries, indexes, and database performance across MySQL, PostgreSQL, SQL Server, and Oracle with execution plan analysis and universal tuning techniques.

Provides 42 technology-agnostic cloud design patterns for distributed systems, covering reliability, performance, messaging, security, and deployment to help architects design robust workloads.

Master modern SQL with cloud-native databases, OLTP/OLAP optimization, and advanced query techniques. Expert in performance tuning, data modeling, and hybrid analytical systems.

Screen S&P 500 stocks for Mark Minervini's Volatility Contraction Pattern (VCP) and detect historical VCPs in a single ticker's price path.

Identifies and exploits SQL injection vulnerabilities in web applications during authorized penetration tests using manual techniques and automated tools like sqlmap.

Diagnoses and reduces Qdrant memory usage by analyzing resident memory, page cache, and providing optimization techniques like quantization, on-disk storage, and async_scorer.

Analyzes stocks using the AlphaGBM Five Pillars framework, returning a composite score, risk assessment, target price, and AI-generated report from real market data.

Manipulate phylogenetic trees, detect evolutionary events, integrate NCBI taxonomy, and create publication-quality visualizations using the ETE toolkit.

Parse and analyze Cobalt Strike Malleable C2 profiles using dissect.cobaltstrike and pyMalleableC2 to extract C2 indicators, detect evasion techniques, and generate network detection signatures.

Gather competitive intelligence on companies by searching SEC filings, recent news, federal contracts, and comprehensive profiles through an MCP server.

Parse Windows PowerShell Script Block Logs (Event ID 4104) from EVTX files to detect obfuscated commands, encoded payloads, and living-off-the-land techniques.

Screens for dividend growth stocks with 12%+ annual dividend growth and 1.5%+ yield that are experiencing temporary pullbacks identified by RSI oversold conditions (RSI ≤40).

Apply bottom-up and top-down role mining techniques to discover optimal RBAC roles from existing user-permission assignments, reducing role explosion and enforcing least privilege.

Detect IBD-style Distribution Days for QQQ/SPY, track 25-session expiration and 5% invalidation, count d5/d15/d25 clusters, classify market risk, and emit TQQQ/QQQ exposure recommendations.

Analyze Zeek network logs to detect lateral movement techniques including SMB admin share access, DCE/RPC remote service creation, NTLM account spray, Kerberos anomalies, and large internal data transfers.

Bypass Web Application Firewall protections using encoding techniques, HTTP method manipulation, parameter pollution, and payload obfuscation to deliver SQL injection, XSS, and other attack payloads past WAF detection rules.

Your data-fill agent. Connect a contact-enrichment tool (contact-level) or a company-enrichment tool (company-level), or both for the full waterfall, to fill gaps on any list. Given a name plus a company, find email, phone, LinkedIn, and title. Given a domain, find headcount, funding, technographic profile, and hiring intent. Trigger on "enrich these contacts with emails", "find LinkedIn URLs for {list}", "get phone numbers for {contacts}", "who are the decision makers at {company}", "complete this prospect list", "enrich this CSV", "get the technographic stack for {company}", "fill in missing data on {list}", or any data-completion, list-enrichment, or contact-lookup question.

Guides AI agents to apply advanced mathematical and probabilistic techniques (Bloom filters, HyperLogLog, FFT, etc.) for large-scale data problems where classical algorithms are optimal but math offers better asymptotic bounds.

Extracts and analyzes malicious VBA macros, XLM macros, DDE, and remote template injections in Microsoft Office documents using olevba, oledump, and deobfuscation techniques to identify download cradles, payload execution, and persistence mechanisms.